We provide IT Staff Augmentation Services!

Enterprise Data Warehouse Engineer Resume

Gineer, Confidential

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#.

Hire Now