Senior Consultant Resume

SUMMARY

20+ years’ experience developing and implementing operational and business intelligence systems including all phases of systems development, from requirements definition through deployment and maintenance.
Responsibilities have included technical architecture and design, product selection and installation, data / dimensional modeling, ETL design and development, and BI / Operational application specification and development.
Core competencies include the ability to analyze complex business problems, implement practical solutions, and communicate with business and technical team members.

TECHNICAL SKILLS

Servers: Microsoft SQL Server

Tools: SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Visio, Visual Studio, ERWIN, Data Architect, ER Studio, Oracle, LoadRunner, Informatica PowerCenter, TOAD, SAP Netweaver

PROFESSIONAL EXPERIENCE

Confidential

Senior Consultant

Responsibilities:

Worked with team to develop requirements for automated burn - in system. The system supported four different manufacturing stations and required a complex state model and database system. The state model and database system were firsts for the factory room floor.
Recommended and implemented failover cluster instance in SQL Server 2016.
Implemented Change Data Capture to meet audit requirements and built over 100 SSIS packages for persisting the CDC data.
Worked with both development teams to create and modify tables, views and stored procedures as needed.
Installed Oracle Client 12C on all servers including Failover Cluster. Setup linked server to Oracle as needed.

Confidential

Data Architect

Responsibilities:

Architected data model for commercial survey application.
Designed and built ETL for transferring historic data to new application.
Designed and built Data Warehouse for new commercial survey application.

Confidential

DBA

Responsibilities:

Focus was on Developing an Integrated Reporting Environment for Microsoft Dynamics.
Evaluated Bio Analytics environment and cubes outperform EV Analytics and proposed recommendation for correcting.
Installed Visual Studio 2015 and Data Tools.
Performed data tuning on Azure moved storage to improve performance.

Confidential

DBA

Responsibilities:

Responsible for managing 78 SQL Servers from SQL Server 2000 to SQL Server 2012 including both physical and virtual servers with six clustered environments.
Automated database maintenance using Ola Hallengren’s SQL Server Maintenance Solution.
Automated SQL Server native backup/LiteSpeed backup to dedicated StorSimple device. Walked auditors through backup and restore procedures.
Worked with Critical Systems to update SCOM alerts for SQL Server to be more meaningful. Managed and cleared SCOM alerts daily.
Repaired and restored corrupted databases as needed.
Worked with PeopleSoft Development Team and Oracle Support to keep financials running optimally.
Installed/Upgraded SQL Server as needed including multiple clustered instances.
Worked with development teams on identifying and fixing missing indexes and poorly performing queries and procedures and optimizing performance of SQL Servers.
Worked with Critical Systems to restore/recover SQL Servers and minimize surface area following external attacks.

Confidential

DBA

Responsibilities:

Created 400 MB development database to replace 60 GB production database to reduce space requirements.
Wrote server and database auditing specifications to meet HIPAA logging/auditing requirements.
Replaced SQL Server logins with AD service account for DMZ logins and setup execute as caller logic for stored procedures to reduce database attack surface.
Created separate database environments for sandbox, development, QA and staging to production.
Added missing indexes to increase performance by at least an order of magnitude.
Worked with developers to optimize database access for Entity Framework.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship