SUMMARY:

• Superior interpersonal, organizational, and communication skills.
• Excellent work ethic combined with creativity and enthusiasm.
• Highly motivated team player with outstanding problem solving and trouble - shooting abilities.
• Exceptional analysis, design, and development abilities.
• Knowledgeable in, and experienced with, dimensional data modeling concepts and techniques.
• Experienced in designing, building and migrating large data warehouse and business intelligence solutions using dimensional and normalized data architectures.
• Experience loading into and extracting data from large, multi-terabyte, data warehouses, and multiple dimensional data marts.
• Experience with multiple DW/BI tools including Informatica, Business Objects, Cognos, SQL Server, Oracle, and Teradata.

TECHNICAL SKILLS:

• PL/SQL
• SQL
• Unix
• Linux
• XML
• JavaScript
• Perl
• Informatica PowerCenter 6.1 - 10.1
• Informatica Data Quality (IDQ)
• Informatica Analyst
• Oracle 9i - 12c
• Oracle Exadata 12c
• Microsoft SQL Server Enterprise
• Teradata
• SAP Business Objects XI R2 & R3
• Cognos
• Tableau
• Unix/Linux
• CA ER/Studio
• CA ERwin Data Modeler
• Visio Professional
• Toad
• Subversion (SVN)
• Jira
• Robot/Scheduler
• Tidal Enterprise Scheduler
• AutoSys
• BMC Remedy AR System
• Eclipse
• Certus
• TeamMate
• IMS
• DB2
• OS 390
• Microsoft Word
• Microsoft Excel
• Microsoft PowerPoint
• Microsoft Project

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Consultant

Responsibilities:

• Responsible for designing, building, and loading the data structures in the Book of Records data warehouse for Confidential of California.
• Responsible for integrating data from multiple medical data sources, including Cerner, Epic, Facets, and HL7.
• Responsible for the design and development of processes for data warehouse implementation using CA Erwin Data Modeler.
• Responsible for the design and development of processes for data acquisition, and integration, using Linux shell scripts, Netezza SQL scripts, and Informatica PowerCenter workflows.
• Responsible for developing and testing complex load and conversion SQL scripts for use in the data warehouse ETL processes.
• Responsible for maintaining historical versions of files and source code using Subversion (SVN).
• Responsible for performing all work tasks using the agile project management methodology and Jira agile software.
• Perform data profiling and analysis on new data sources for adherence to the organization's quality standards and ease of integration.
• Work with Architects and the Business Community to identify requirements and develop solutions for the data warehouse.
• Support the end-to-end product life cycle including support of agile/iterative development process, code and design reviews, unit and system testing, deployment, transition, and production troubleshooting when needed.

Confidential

Sr. Data Architect

Responsibilities:

• Responsible for designing, building, and loading the dimensional data structures in the Medicaid data warehouse for the state of Colorado.
• Responsible for the design and development of processes for data warehouse implementation, data acquisition, and data integration.
• Responsible for integrating data from multiple medical data sources, including CMS, Epic, Facets, and HL7.
• Develop complex load and conversion Oracle Exadata SQL scripts for use in the data warehouse ETL processes.
• Develop and maintains the source to target mapping documents for all data warehouse import and extract processes.
• Design and build logical and physical data models. This includes maintaining and enforcing the standards for defining the structures, attributes, and nomenclature for data elements using CA Erwin data modeler.
• Responsible for maintaining historical versions of files and source code using Subversion (SVN).
• Perform data profiling and analysis on new data sources for adherence to the organization's quality standards and ease of integration.
• Conduct performance tuning exercises on SQL scripts and Informatica mappings and workflows.
• Work with other Architects and the Business Community to identify requirements and develop solutions for the Colorado State Medicaid Data Warehouse.

Confidential

Sr. ETL (Informatica) Architect

Responsibilities:

• Design and develop Informatica ETL processes to load into and extract data from the Enterprise Data Warehouse.
• Work with other BI team members and business users to identify requirements and develop BI solutions using industry standard development techniques and technologies.
• Support the end-to-end product life cycle including support of development process, code and design reviews, unit and system testing, deployment, transition, and production troubleshooting when needed.
• Ensure developed solution implementations conform to quality, performance, and interoperability standards under enterprise guidance.
• Work closely with the development team to ensure that all standard procedures and best practices are followed when designing and building BI solutions.
• Work with all BI team members to identify efficient and effective options for new and existing solutions, break-fix, customer issues, or enhancements.
• Support the end-to-end product life cycle including support of agile/iterative development process, code and design reviews, unit and system testing, deployment, transition, and production troubleshooting when needed.

Confidential

ETL (Informatica) Architect

Responsibilities:

• Responsible for software development within the existing Data Warehouse applications using SQL scripts and Informatica PowerCenter mappings and workflows.
• Work with other Architects and the Business Community to identify requirements and develop solutions for telecom Data Warehouse solutions using industry standard development techniques and technologies.
• Work in an iterative development environment responsible for solving a wide array of business problems.
• Support the end-to-end product life cycle including support of agile/iterative development process, code and design reviews, unit and system testing, deployment, transition, and production troubleshooting when needed.
• Ensure developed solution implementations conform to quality, performance, and interoperability standards under enterprise guidance.
• Develops and performance tune complex Oracle Exadata SQL scripts used in the ETL processes.

Confidential

Sr Software Engineer (Informatica)

Responsibilities:

• I was a member of the Monarch project team responsible for the design and development of the ETL to transform and load legacy aviation and navigation data to the Navigation Information Repository (NIR). These responsibilities include:
• Working with the Architect and Data modelers to design the ETL and Data Architectures for the Monarch project.
• Working with the Project manager to develop project plans and timelines.
• Working with all project team members to identify efficient and effective options for new and existing ETL and data solutions.
• Design, develop, test, and deliver the ETL to transform and load the legacy aviation and navigational data.
• Work closely with the development team to ensure that all standard procedures and best practices are followed when designing and building BI solutions.

Confidential, Kansas City

Lead Software Engineer (Informatica)

Responsibilities:

• I was a member of the FIR project team responsible for the design and development of the Financial Information Repository for the US Treasury. These responsibilities included:
• Principal Architect for the design of the ETL load processes for the FIR project.
• Worked with the Data Architects on the design of the FIR data architecture.
• Developed and documented the standards, policies, and procedures for the ETL/Informatica architecture, design, and development of the FIR project.
• Design, developing, and supporting Business Intelligence solutions using Informatica 9.1 - 9.6.1, Oracle 11g, and Business Objects XI R3.
• Working with the Project Managers to develop project plans and timelines.
• Work directly with other development team members and project managers to design, build, and deliver quality BI Solutions.
• Working with all BI team members to identify efficient and effective options for new and existing solutions, break-fix, customer issues, or enhancements.
• Working closely with the development team to ensure that all standard procedures and best practices are followed when designing and building BI solutions.
• Working with Production Support to schedule workflows appropriately based on performance metrics to meet BI SLAs

Confidential, Englewood, Co.

Sr ETL (Informatica) Developer

Responsibilities:

• Designed and built the development, UAT, and production Informatica environments; included the design and build of the server architectures, and the installation of Informatica 9.1.0.
• Re-designed the existing data warehouse using dimensional modeling techniques. The re-design included a data warehouse layer containing 12 fact tables and 38 dimensions; and a business intelligence layer containing 12 fact tables, 38 dimensions, and several audit tables.
• Responsible for converting all existing ETL processes from Cognos Data Manager to Informatica.
• Responsible for designing, developing, and supporting Business Intelligence solutions using Informatica, Oracle, SQL Server, and Cognos.
• Responsible for documenting standards and procedures for designing and building all BI solutions.
• Responsible for developing project plans and timelines for all BI projects.
• Responsible for tracking all BI project plans and timelines using Microsoft Project.
• Responsible for working with all BI team members to identify efficient and effective options for new and existing solutions, break-fixes, customer issues, and enhancements.

Confidential, Englewood, CO

Sr. ETL (Informatica) Developer

Responsibilities:

• Responsible for designing, developing, and supporting Business Intelligence solutions using Informatica, Teradata, Microstrategy, and Robot Scheduler.
• Involved in the stabilization of the data warehouse architecture and ETL processes.
• Worked with the Project Managers to develop project plans and timelines.
• Worked directly with other development team members and project managers to design, build, and deliver quality BI Solutions.
• Worked with all BI team members to identify efficient and effective options for new and existing solutions, break-fix, customer issues, or enhancements.
• Worked closely with the development team to ensure that all standard procedures and best practices were followed when designing and building BI solutions.
• Worked with Production Support to schedule workflows appropriately based on performance metrics to meet BI SLAs
• Analyzed new and existing Informatica workflows to determine where performance improvements could be made
• Delivered ETL workflows and documentation developed to specifications, in the agreed upon timeframe.

Confidential, Englewood, Co.

Business Intelligence Development Lead

Responsibilities:

• Responsible for all aspects of DW/BI development; including the design, build, and migration of all BI solutions.
• Responsible for the planning and implementation of all upgrades and conversions to Informatica and Business Objects.
• Responsible for designing, building, and migrating solutions to load into and extract data from a large (4TB) Clinical Healthcare data warehouse, and multiple dimensional data marts.
• Responsible for the BI Development team, consisting of 2 data modelers, 3 Informatica/ETL developers, and 4 Business Objects Report Developers.
• Responsible for enhance the development team’s ability to design, build, and deliver quality BI solutions by ensuring that all team members have the information and tools they need to deliver BI Solutions to the standards of the Business Intelligence department.
• Worked directly with development team members, BI analysts, and project managers to design, build, and deliver quality BI Solutions.
• Coordinated the flow of projects between BI teams and other departments
• Tracked resource availability and project timelines.
• Responsible for the timely completion of all projects, minor enhancements, and break fixes.
• Assigned resources to all projects, minor enhancement or break fixes.
• Worked with the BI Analysts to develop project plans and timelines.
• Identified, initiated, and coordinated cross team training opportunities.
• Worked with the development team members to identify training or continuing education opportunities to enhance their skills and job performance.
• Took part in all cross team training and continuing education opportunities.
• Worked with all BI teams to identify efficient and effective options for new and existing solutions, break-fix, or customer issues.
• Worked within the BI team and across BI Teams to design and implement scalable, high performance solutions.
• Worked with BI Support to identify bottlenecks and areas for performance improvement.
• Implemented best practices that improve the overall architecture and performance of the development process, and BI solutions.
• Worked with the BI Analysts to define standardized documents and procedures
• Worked closely with the development teams to ensure that all standard procedures and best practices were followed when designing and building BI solutions.

Confidential, Englewood, CO

Sr. Informatica Developer

Responsibilities:

• Designed, built, and migrated ETL solutions to the standards defined in the Informatica (Velocity) Best Practices documentation.
• Championed and implemented best practices that improved the overall architecture and performance of the ETL workflows
• Initiated and coordinated cross team interactions for the purpose of identifying processes and methodologies for improving the scalability and performance of the data warehouse ETL procedures.
• Worked within the DW Team and across BI Teams to design and implement scalable, high performance ETL procedures.
• Worked with BI Support to identify bottlenecks and areas for performance improvement.
• Designed and Implemented performance improvement methods that reduce resource requirements and/or processing time.
• Recommended improvement to existing workflows and worked with management to schedule time to implement improvements, while continuing to deliver against the BI AOP
• Conducted performance load testing to establish baseline runtimes for ETL workflows
• Worked with BI Support to schedule workflows appropriately based on performance metrics to meet BI SLAs
• Analyzed new and existing workflows to determine where performance improvements could be made
• Championed and implements best practices that improved the overall quality and timeliness of the deliverables
• Delivered ETL workflows and documentation developed to specifications, in the agreed upon timeframe, including adherence to Data Governance Policy for data quality and on time reporting
• Develop accurate estimates for the development of ETL workflows.
• Worked with Data Modelers to develop efficient and scalable dimensional models for data marts.
• Worked with Business Objects Report developers to design and implement efficient and scalable Business Objects solutions.

Confidential, Denver, Co.

SW Systems Engineer

Responsibilities:

• Responsible for the development and support of all Remedy AR system applications and databases.
• Primary developer for the Remedy AR mid-tier and web applications.
• Primary developer and support person for the Certus (SOX Compliance) application and database. I am responsible for all application and database upgrades.
• Primary development and support person for the Business Objects XI Webi application.
• Responsible for the development and support of all is-web applications. These applications were developed using primarily UNIX, Perl, CGI, and HTML.