SQL Server Specialist at DataTamer Inc.
Quebec, Canada
- Current
-
- SQL Server Specialist at DataTamer Inc.
- Past
-
- Senior SQL Server Specialist at Caiman
- SQL Server Specialist at Allegro MicroSystems, Inc.
- Project Manager at Prospec Tracking
- Education
-
- University of Ottawa / Université d'Ottawa
- University of Phoenix
- Recommended
-
2 people have recommended Michael - Connections
-
83
connections
- Industry
- Information Technology and Services
- Websites
Michael Lato’s Summary
- Driven, detail-oriented IT professional with 10 years of SQL Server design, development and administration experience.
- Excellent verbal and written communication skills for interaction with business users and managers at all corporate levels.
- Extensive experience in design techniques and relational database theory.
- Extensive experience in database administration for both development and production systems.
- Skilled in all areas of project management (PMBOK), software development lifecycles (SDLC) and system documentation.
- Skilled in performance monitoring and tuning.
- Strong troubleshooting and analysis skills.
- Microsoft Certified Technical Specialist (MCTS) in SQL Server 2008 Implementation and Maintenance.
- Editor of Transact-SQL Coding Techniques for www.sqlserverpedia.com
- Speaker at PASS conference in 2007 and 2008 (largest SQL Server conference in North America): www.sqlpass.org
- Speaker at SQLTeach conference in Toronto in 2008: www.sqlteach.com
Michael Lato’s Specialties:
- SQL Server 2008, 2005 and 2000: design, development, administration, conversion of business user requirements into system design, project management
Michael Lato’s Experience
-
SQL Server Specialist
DataTamer Inc.
(Information Technology and Services industry)
August 2009 — Present (7 months)
Lead consultant for all clients.
-
Senior SQL Server Specialist
Caiman
(Privately Held; Information Technology and Services industry)
April 2009 — July 2009 (4 months)
- Database development and support for international sales of CDs, DVDs, books and video games at www.tower.com.
- Expanded sales markets by integrating systems with multiple vendor sites such as www.play.com and www.buy.com.
- Responsible for database design, administration and maintenance in Microsoft SQL Server 2005 and Microsoft SQL Server 2000.
- Responsible for report generation and maintenance in Microsoft SQL Server Reporting Services 2005. -
SQL Server Specialist
Allegro MicroSystems, Inc.
(Privately Held; Semiconductors industry)
April 2004 — March 2009 (5 years )
- CRM and reporting system support for 200 international users.
- Acted as key liaison between IT department and Business Unit Directors to determine data requirements and areas of improvement. Translated business requirements into system design documents and project plans.
- Acted as lead developer and solution architect for the design, development and implementation of the opportunity management and forecasting system. This system was constructed in-house to replace an off-the-shelf product with limited growth potential.
- Improved and streamlined business analysis activities through techniques such as margin analysis, ongoing historical data tracking, selective denormalization and report aggregation.
- Reduced costs by integrating disparate systems into a single location as well as automating many manual data transfer processes such as distributor sales information.
- Responsible for database design, administration, maintenance and training in Microsoft SQL Server 2005, Microsoft SQL Server 2000, and OnContact CMS.
- Responsible for report generation and maintenance in Microsoft SQL Server Reporting Services 2005, BusinessObjects Server 11.5 and Crystal Reports 11.5 and 11.0.
- Responsible for ETL processing against multiple data streams (including Oracle) using DTS and SSIS. -
Project Manager
Prospec Tracking
(Information Technology and Services industry)
January 2003 — March 2004 (1 year 3 months)
- CRM system support for 800 users.
- Focused on critical database performance increases by using SQL Profiler and migration to improved data structures. This resulted in improved system response time for key clients.
- Improved client satisfaction by reducing feature implementation time from 4 weeks to 5 days.
- Responsible for database design, administration and maintenance using Microsoft SQL 2000 and 7.0, as well as sales report generation in Crystal Reports 9.0 and 8.5.
- Responsible for project planning and resource allocation utilizing Microsoft Project 2000.
Michael Lato’s Education
-
University of Ottawa / Université d'Ottawa
Bachelor of Mechanical Engineering (incomplete) ,
-
University of Phoenix
Bachelor of Science , Computer Science and Business
Michael Lato’s Contact Settings
Interested In:
- consulting offers
- job inquiries
- expertise requests
- business deals
- reference requests
- getting back in touch
