SUMMARY:

Results - focused and resourceful professional with many years of success spanning IT business systems analysis, development and management for a diverse range of organizations of varying size and scope. Proven track record for creating efficiencies while overseeing small, medium and large scale system designs, conversions and consolidations.Expertly develop impactful technical and business solutions to positively drive profitability and productivity. Possess hands-on experience with a broad range of technologies and platforms utilized throughout multimillion-dollar programs. Confidently foster relationships with project stakeholders of all levels. Work well in a group and independently.

CORE COMPETENCIES INCLUDE:

Adaptability Organization Communication Database Administration Database Development Systems Analysis Team Building

CAREER HISTORY:

Confidential, Schaumburg, Illinois

Technical: SQL Server 2008/2012/2014 ; T-SQL; SQL Profiler; Performance Monitor

Senior SQL Server DBA/Developer

Responsibilities:

• Monitor and maintain SQL Server databases in development, test, staging and production environments;
• Code and maintain DML and DDL scripts for database object creation and data manipulation and querying;
• Create and maintain SQL Server Integration Services processes and Reporting Services reports;
• Create and automate business processes in SQL Server and document as Standard Operating Procedures (SOPs).

Confidential, McHenry, Illinois

Technical: SQL Server 2005/2008/2012 ; T-SQL; SQL Profiler; Performance Monitor; system and code assessments.

Senior SQL Server DBA/Developer

Responsibilities:

• Maintain development and production SQL Server environments.
• Work with the development teams to assess, monitor and support the database environment for educational OLTP applications, providing a database perspective to ensure the best of performance, reliability and recoverability.
• Review SQL code for efficiency and mentor developers as to proper coding techniques.
• Establish best practices standards and procedures regarding SQL Server database design and coding.

Confidential, Oak Brook, Illinois

Technical: SQL Server 2005/2008/2012 ; T-SQL; SSIS; TFS; client engagement; system assessments.

Senior Engineer

Responsibilities:

• Engage clients, install and configure new SQL servers, assess existing servers and systems and manage SQL servers through best practice auditing and implementation of database maintenance, capacity planning and performance monitoring and tuning.
• Development of T-SQL scripts used to audit and maintain databases.
• Program ETL processes using T-SQL and SSIS.
• Used Team Foundation Server (TFS) for source control.

Confidential, Lake Forest, Illinois

Technical: SQL Server 2005/2008; T-SQL; SSIS; SSRS; TFS.

Senior Systems Analyst (SQL Server DBA/Developer)

Responsibilities:

• Managed SQL Server databases and the enterprise data warehouse design, development and implementation.
• Installed and configured SQL Server. Using both T-SQL and SSIS, set up structures and ETL processes for Staging and Organizational Data Store to be used for all enterprise and departmental reporting.
• Design SSRS reports deployed to Sharepoint for end user access.

Confidential, Glen Ellyn, Illinois

Data Warehouse Developer

Technical: SQL Server 2005; T-SQL; SSIS; Excel; Visio; Project.

Responsibilities:

• Support global initiative to fuse business and IT concepts and processing via consolidation of all organizations under the corporate umbrella into single, global corporate ERP instance and Organizational Data Store (ODS).
• Collaborate with group of database developers and liaise with key business subject matter experts, project managers and data architects to define and develop final elements and attributes of the ODS.
• Analyze, implement, and support the first stage of the project to simplify and unify the data store, including the design, development and testing of the T-SQL ETL procedures of the data warehouse, extracting and transforming data from J.D. Edwards (JDE) enterprise resource planning (ERP) system and various data sources and performing data analysis, mapping, modeling and validation.
• Favorably streamline design of ETL data structures, processes and schedules.
• Lead stage-1 team in developing the T-SQL procedures needed to populate the global ODS with consolidated corporate data from disparate sources.
• Participated in the distributor consolidation project to simplify the go-to-market strategy for the company which paved the way for increased marketing efficiencies and sales within key states. Established processes to consolidate distributor data within JDE by way of back-end ETL programming (T-SQL).
• Collaborated with subject matter experts and internal IT teams to discover target to source objects, elements, attributes and procedures to ensure achievement of project strategies and goals.
• Cost savings generated allowed for $100M in focused marketing campaigns in the key states and caused top executives to identify the project as the most visible, complex and beneficial to date in the company’s history.
• Developed the T-SQL procedures required to extract, transform and load data to and from distributors and JDE sources to reflect the specific consolidations.