Professional Summary

Confidential is an Information Technology IT Professional with 17 years of successful experience with advanced level of development of Client Server applications. He offers over 8 years of working experience in all the cycles of development in SQL server development life cycle, customization in the end users/business requirements, in design, Architecture, analysis and testing of Data warehouse using ETL tools, Data Modeling and OLAP tools. He is experienced in all phases of the Software Development Life Cycle, analyst and solutions for the customs applications, client interaction, end user documentation and technical documentation. Mr. Leigh is an expert in Setting up, Configuring, Creating and Scheduling SQL Server Integration Services and Analysis Services and hands on experience in creating OLAP cubes. He is experienced in enhancing and deploying the MS-SQL Server SSIS packages from development server production server. He has expertise in creating database, T-SQL scripts, stored procedures, views, tables, indexes and constraints, user function and security using MS-SQL Server 2008 r2/2005/2000 expert in migration of ETL packages using DTS from MS-SQL server 2000 to SSIS 2008 r2 and implementing all transformations available in the SSIS toolbox. He has experience in Data Extraction, Transforming and Loading ETL between Homogenous and Heterogeneous System Excel, AS400, and Access . Mr. Leigh possesses a fair knowledge on .NET Framework methodology for understanding front-end applications and services. He sets and achieves goals, works well under pressure and is bilingual Spanish and English .

Technical Skills

• Languages PL/SQL, Visual Basic for Access, Visual Basic .NET, C , XML, XSL, T-SQL
• Software/Tools Share Point, Visual Studio 2010, Business Intelligence Studio MS-SQL Server 2008-SSIS, SSAS, SSRS , BPCS, Monarch, Ultra Edit, MS Office 2010, VMWare, Vision
• Operating Systems Windows Server 2008, Windows 7
• Methodologies UML, Agile

Professional Experience

ETL/ SQL Developer

Confidential

• SQL Server 2012, writing store procedures, scripts, SSIS packages, ETL, Datamart snowflake schema. Creation of Store procedures and triggers.
• KPI calculations with store procedures and scripts using TSQL.

MS- SQL SERVER DEVELOPER

Confidential

• Administration for backup and restores, creation of profiles, security for users and schedule jobs for SSIS packages, configuration and setup the mail for MS-SQL Server, creation of logins, security, scheduled for jobs and notification to operators.
• Developed an ETL process which collect data from a database, Marin File and Sizmek File which create a final report for a Client. Use of parameter, variable and distribution by email. Creation of view, database, T-SQL scripts using Visual Studio 2010 and MS-SQL Server Management Studio 2012.

MS- SQL Developer

Confidential

• Experience working in the HealthCare Industry with remote teams on defects in Agile methodology.
• Creation of complex t-sql scripts and queries.
• Troubleshooting for data and SSIS and C packages and ETL with SQL Server 2008.
• Develop interfaces in .Net C and SOAP with Web .NET and Java services.
• VMS Billing
• Technical verification of T-SQL code changes.

MS- SQL Developer

Confidential

• Assigned to New World Systems Nov-Dec , Ramstad - Eagle Ottawa Jan - Mar and Arrow Strategy - 1st Recovery Group May-Jun
• Business Intelligence Developer
• SSRS reports with SharePoint and Enesys software, reports accessing I-series ERP BPCS and LX
• Migrating Data from text files into MS-SQL server
• Creation of complex scripts and Reports in SQL server 2008
• Mapping of Tables in SQL
• Use and creations of scripts and use of T-SQL commands for Microsoft SQL Server
• PM10 software, creating SSIS packages with external variables from a batch file, accessing Cognos tables
• VBA in Excel and Access, use of store procedures and documentation for PM10 process.
• Use of SSIS, SSAS and SSRS with PM10

Confidential

System Programmer .NET Data-Warehouse Developer

• Facts Accuterm, use of TCL and updating the system
• EDI File conversion to SQL databases using Visual Studio .Net limited
• Access Programming Monarch, Ultra Edit., Develop applications in Visual Basic .Net with EDI files and SQL Server
• Creation of Reports using SSIS, SSRS, creation of MS-SQL Server Databases
• Evaluation and Testing of new products like Monarch v 11.3 for core process and reporting bugs to vendor company
• Analysis and design of System for the Core Process with HIPAA 5010 Standards

Confidential

MS-SQL Developer/Data-Warehouse Developer

• Developed new process of the printing process using VBA code, T-SQL and PL/SQL. Printing on demand Programming, Testing, Optimizing, Documenting and Implementing Systems in VBA in Access 2007 with SQL server 2008 in the back end. Quality assurance was applied for all the projects in this client
• Responsible for the migration of the data-warehouse from SQL Server 2000 to SQL Server 2008, use of Database Cubes and Pivot Tables using Visual Studio 2008 - SQL Server Business Intelligence Development Studio XML, Some task has .Technology used by SQL server 2008 R2
• ETL tool as SSIS was used for the creation of tasks which extracts information from an IBM AS/400 and then transforms and moves to SQL server databases. This operation reduced the operation already in place, but with the migration from SQL server 2000 to SQL server 2008 R2, the load of information used to take 4 hours, with the new implementation the process takes 30 minutes. VB Script programming
• SSAS and SSRS was used for the creation database cubes and data modeling the challenge was the time, which the format in SQL 2000 use functions and in the new version of SQL server 2008 R2 is necessary the use of a time table and the recreation of the database cube and dimensions. The SSAS was used for the Pivot tables which were retrieved from Excel using ODBC connections. Carried a deep Understanding of Dimensional Modeling and OLAP. The timetable was used for the visualization of weekly, monthly and year data. The database cubes were used for sales, marketing, operations and the president of the company, showing revenue, profit and cost
• Trained the IT Department in the use of tools such as SSIS and SSAS and the documented the technical steps for the use of the new procedure of creation of the time table. Upgraded computer and laptops in Windows 7
• Help Desk support using technology Ultra VNC and Desktop support in hardware and software. Migration from Exchange to Google Apps

Confidential

MS-SQL Developer/ Programmer

• Migration of system from Access 97 to Access 2003. The application uses Visual Basic for Access with SQL Server version 2005 in the backend. Desktop support for Windows XP. Maintenance and use of SQL Server. The project was integrated the GIS module into the Access 2003 for the LAWA's Environmental Service Division
• This system helped the Environmental department with their quarterly reviews for the several airlines tenants, the actual system was very inefficient and slow, the migration helped the power users for their work with a faster performance and robust system. Quality Assurance was applied in this project

Confidential

Document controller

• Handled clerical and general office duties. Quality Assurance was applied in this job
• Input information into computer system utilizing Trinium program
• Processed bill of ladings
• Processed invoices

Confidential

Office Manager

• Trained personnel utilizing Windows XP and Microsoft Office Suite. Quality Assurance was applied in this job
• Supervision and recruitment of the personnel
• Responsible for the branch operations

Confidential

SQL DBA/ Developer

• Designed and developed applications with Visual Basic Scripts using SQL server version 7, ASP technology VB Script, Dreamweaver and Photoshop
• Installed, setup users, security in database server SQL Server version 7, design, implemented and maintained. Monitored and improved database performance and capacity. Quality Assurance was applied in these projects
• Use of Gantt chart to follow the project schedule and monitor activities in development and graphic design. Lead the development team and coordination with the CEO and CIO with strategies in the portal

Confidential

SQL DBA/ Developer

• Responsible for Network operation and installation of SQL Servers, daily, weekly checklist for SQL servers' performance and backup. Quality Assurance was applied in these projects
• Managed Network and Help Desk function as well as prioritized, resolved, recognized and routed end-user computer problems. Help Desk in Lotus Notes

Confidential

SQL DBA/ Developer

• Designed and developed applications with Visual Basic Scripts, using SQL server version 7, ASP technology, Dreamweaver and Photoshop. Managed Network and Help Desk function as well as prioritizing, resolving, recognizing and routing end-user computer problems. Quality Assurance was applied in these projects
• Established and document policy and procedure, Supported Web Site
• Designed and supervised of the mailing list of the company using Windows NT, Intranet ware Novell and Support in Mac System 7

Responsible for Network operation and installation of SQL Servers version 7, daily, weekly checklist for SQL server's performance and backup