We provide IT Staff Augmentation Services!

Data Warehouse Lead Resume

2.00/5 (Submit Your Rating)

Redmond, WA

SUMMARY

  • Data Warehouse Lead
  • Data Warehouse Lead with more than 15 years of experience developing data focused solutions seeking to design and implement state of the art data warehouse solutions.
  • Excellent design, implementation, communication, leadership and problem solving skills.

SPECIALITIES:

Database Environments: Oracle, Teradata, MS SQL Server 2014, ODBC, Ingres, DB2, MS - Access, MySQL, and Sybase.

Languages: SQL, Java, C#, C, VB.NET, ProC, PHP, HTML, JavaScript, CSS, C++, OpenROAD, and COBOL

Operating Systems: Microsoft Windows, AIX, Linux, z/OS, Solaris, and HP-UX

Other Software: Business Objects (BOBJ), DataStage, InfoBurst, ClearCase, AWS, SSIS, AutoSys, InfoBurst, Confluence, Eclipse, Excel, Crystal Reports, SSRS, JCL, Visual Source Safe, CVS, Tomcat, XML, PGP, JUnit, Ant, JDBC, Weblogic and Sharepoint.

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Data Warehouse Lead

Responsibilities:

  • Develop and maintain BI reports with Business Objects and InfoBurst. Development, testing of Business Objects Universe changes
  • On call 24x7 to support Data Warehouse ETL
  • Led support of all Univar Information Warehouse users
  • Designed, developed, tested and deployed DataStage ETL enhancements and bug fixes
  • Source to target analysis for analysts, users and management

Confidential

ETL Programmer Analyst

Responsibilities:

  • From within Confidential assisted with the migration of Supplier Data from PQAA and ESCAN to Confidential using DataStage, Java and Weblogic.
  • Worked closely with Analysts to coordinate work, understand specifications and to streamline testing efforts.
  • Modified existing and created new DataStage jobs.
  • Assisted in reducing ESCAN data migration process times from 20 hours to 8 hours.
  • Supported Confidential ETL interfaces to D1 - 4426 and from BEST, EPDW and SMMART. Supported Domino PQAA application.
  • For Confidential as development lead:

Confidential

Data Warehouse Administrator

Bellevue, WA

Responsibilities:

  • Provisioning of new data warehouse users.
  • Fulfillment of data request.
  • Assistance in the development of user documentation.
  • Participation in multiple weekly customer support meetings .
  • Development of custom reports in SSRS.
  • Oversight user acceptance testing.
  • Initial deployment CDW and CDW patches.Collaboration with off-site and off-shore CDW support engineers.

Confidential

BIConsultant

Responsibilities:

  • Converted three MS-Access systems to SQL Server using SQL views, stored procedures, functions and complex SSIS packages.
  • Provided careful, thoughtful, patient user support and coordination across departments.

Confidential

Senior Software Developer

Responsibilities:

  • Led an offshore team in the development of a large, very complicated reporting system.
  • This reporting system was an integral part of FinanceCenter, Confidential ’s industry leading front office automation and risk management software.
  • Planned, designed and implemented the complete deletion of sensitive customer data from an over 300gb archive database.
  • This effort required the analysis of 276 tables. This resulted in a zero defect delivery to quality assurance and the client.
  • Completion of this project helped ensure the resumption of over 300K in annual customer billings.

Confidential

Software Engineer Enterprise

Responsibilities:

  • Designed, implemented and tested new features for the Enterprise Access gateways to DB2, Microsoft SQL Server and Oracle on Windows
  • Designed and implemented the Confidential Advantage Enterprise Access gateway to DB2 UDB on Windows and AIX.
  • Supported the DB2 UDB gateway through quality assurance and beta test, until it Confidential Availability status.

Confidential

Senior Software Engineer

Phoenix, AZ

Responsibilities:

  • Extended the DDW/ODBC Driver to support numerous DDW gateways.
  • Defined product release contents and schedules.
  • Developed the Teradata gateway Design Specification.
  • Wrote the Teradata gateway Project Plan, User's and Administration's Guide, Software Release Bulletin, and Release Notes.
  • Defined product release contents and schedules. 

We'd love your feedback!