Enterprise Data Warehouse Engineer Resume gineer Confidential, - Hire IT People

SUMMARY:

23 years of IT experience including application development, testing, data analysis and data modeling, database development, enterprise data warehouse design and development, production support and project management.

COMPUTER SKILLS:

Teradata (v12, v13, v14)
SQL Server (2008, 2010, 2012)
Unix
WhereScape
AutoSys
Visual Studio
Azure
Informatica

EXPERIENCE:

Enterprise Data Warehouse Engineer

Confidential, WA

Responsibilities:

Built a pharmacy reporting solution for clinically administered medications which allowed the Pharmacy department to save 10 million dollars the first year.
Participated in the Confidential EDW Architecture team by proposing standards, providing prescriptive guidance and performing proof of concepts to increase the consistency and efficiency of development in the EDW organization.
Implemented backward compatibility process for EDW to help control impact to end users.
Contributed as the technical lead for a team of 4 - 5 people driving the EDW solution with high data quality while being accountable for following EDW Architecture standards.
Gathered requirements and performed story sizing/complexity to enable project managers with estimating project delivery dates.
Developed code and unit tested to ensure business requirements were met. Performed peer code reviews to simplify maintenance and ensure EDW Architecture standards were met.
Coordinated cross team migrations for conformed dimensions and many versions of multiple solutions to production.
Performed production support, troubleshooting errors, resolving and addressing technical issues.
Identify and drive a sustainment team user story backlog for solution improvement to deliver data one day earlier, reduce monitoring and validations at night and improve code performance by 80% in some cases.

Enterprise Data Warehouse Engineer

Confidential

Responsibilities:

Tested Windows Phone app in Confidential Azure. This app was used by Confidential to track Windows Phone Sales.
Planned and delivered an enterprise Business Intelligence Platform utilizing SQL SERVER Enterprise, Master Data Services, SSIS, and Tableau for client Finance department to track profitability at the Billable Test level.
Hosted Business Intelligence Requirement cross-organization workshops to produce comprehensive Business Requirements Document and Functional Specification Documents
Built a Data Model defining Entities and Attributes to ensure system integration mapped and all requirements were satisfied.
Performed PM duties including project plan tracking and weekly status updates
Led development efforts performing multiple roles as needed including code reviewer, tester, build-master, and SQL analyst/coder.
Managed test planning and User Acceptance, working with key stakeholders to verify the solution met the requirements.

Technical Project Manager

Confidential

Responsibilities:

Created Extract functional design to support Onboarding Applications integrating with a custom solution called MDM Privacy
Created Reporting functional design to support business users consuming MDM Privacy data
Created Database functional design to support MDM Privacy data management
Assisted in Disaster Recovery functional design MDM Privacy.

Technical Project Manager

Confidential

Responsibilities:

Primary responsibilities included vendor procurement and management
Creating functional design to assign Segmentation taxonomy and Sales Geography Hierarchy to Confidential customers (EPG and SMS&P).
Assisted in Development with system integration using SSIS

Technical Project Manager

Confidential

Responsibilities:

Tested, reviewed, released and communicated Logical Data Model
Developed and tested RM Canonical Model for Confidential Consulting Services and Customer Support Services.
Performed engagement management, provided architecture guidance and data mapping for systems implementing the Logical Data Model.

Software Developer

Confidential

Responsibilities:

Developed and tested Resource and Project Management database.
Modified and tested Resource and Project Management Middle-Tier and UI.

Software Developer

Confidential

Responsibilities:

Integrated Invoicing data to Confidential ’s SAP billing system using MS SQL Server 2000.
Developed and tested multi-subsidiary invoice printing using C#.
Modified and tested ETL integration using C#.

We provide IT Staff Augmentation Services!

Enterprise Data Warehouse Engineer Resume

Gineer, Confidential

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship