SUMMARY

• Aspired ETL Architect who specializes Business Intelligence in relational and dimensional database design, data integration and support of custom operational data stores and data warehouses that enable key performance metric reporting and other analytic reporting. Strengths include Health Sciences, Finance, Supply Chain / Logistics, and Procurement/Manufacturing.
• SOFTWARE
• Information Builders, Omni-Patient Omni Framework : EMPI enterprise master patient index , iWay Data Integration, Data Quality and Master Data Center.
• EHRs: Cener Millenium, CPSI and AllScripts.
• ERPs: Sapphire SMS and Lawson.
• Teradata v13, HP NeoView, Informatica, HP Open View Service Desktop formerly Mercury Interactive Test Director , Informatica, Microsoft Office, Access, SharePoint, Word, Excel, PowerPoint, and Project Oracle SQL Plus Oracle SQL Loader, Power Designer, Erwin Business Object Visual Source Safe Visio Sys Admiral Telnet FTP.

PROFESSIONAL EXPERIENCE

Confidential

EDW - Data Architect Migrating ESP EmailServiceProvider from eDialog to ExactTarget salesforce.com . Worked with Email Marketing Team on High Level Design Requirements for TotalRewards' patrons emailing campaigns. Responsibilities include but not limited to data mining on Teradata v13, code review with offshore team, and resolving Production support's data quality or enhancement issues. Confidential EDW/BI - Data Warehouse Engineer

Multi-Fiscal-Year EDW/BI initiative of satisfying Meaningful Use MU American Recovery and Reinvestment Act of 2009 requirements, as well as utilizing electronic medical record technology and/or Statistical Process Control SPC to reduce inpatient hospital readmission rate, improve patient safety and outcomes.

Leading the project to:

• 1. Define the internal/external data requirements across multiple organizations including critical access hospitals and HIE Health Information Exchange with the following systems:
• EHR: Cerner Millenium, AllScripts, and CPSI.
• ERP: Sapphire and Lawson.
• 2. Define HealthCarePerformance metrics adHoc requirements with the ability to drill up/down on the reported data.
• 3. Implementing OmniPatient Healthcare models with data domains in Patient, Provider, Organization, Facility, WorkForce, and Clinical.
• 4. Design and Implement industry's best practice of ETL and MirthConnect HL7 processes across the enterprise.
• 5. Implementing match, merge and mastering the golden patient records of EMPI Enterprise Master Patient Index .
• 6. Consolidate and stabilize current reporting of 10 TB of structured and unstructured data environment.

Key Accomplishments:

• Completed pilot program with Information Builders' OmniPatient, iWay, WebFocus, Data Migrator, Data Profiling, HL7 messaging, Match and Merge modules.
• Assessing and documenting current landscape of network infrastructures, database platforms, internal/external reporting and external partners HIE.
• Research on external Healthcare sector consulting firms to assist EDW/BI roadmap and gap analysis. Carefx Harris Consulting was selected and have completed charting the EDW/BI roadmap for the next 5 years.
• Leading effort in creating and educating the management on the Data Governances' key role in data quality, data stewards/ownership, data integrity/accountability in order to build EDW/BI successfully.
• Served as advisor of influencing decisions on ETL tool, reporting tool, and database platform selections.
• Providing input for industry's best practice of ETL processes to consolidate 300 applications throughout the community and remote hospitals as well as external HIE partners.
• Providing on-call support and maintaining existing SQL server ETL extract processes.

Confidential

• Enterprise Data Warehouse - Business Intelligence Data Integration Enterprise Data Warehouse Engineer A Subject Matter Expert SME in ETL design, development, implementation and testing for a large EDW of 250TB. The application must have extremely high availability and excellent performance while serving thousands of users worldwide. This EDW application has successfully integrated to legacy infrastructure including Finance Data Warehouse, Supply Chain IT, Sales/Marketing and Services portfolios. Essential Duties and Responsibilities include:
• Worked with the Business Analysts to understand business requirements and solution definitions.
• Demonstrated the ability for gathering technical requirements definition/documentation and detailed ETL design specifications.
• Implemented ETL metadata and perform data validation.
• Provided input into integration methodologies, development, coding standards and best practices.
• Technical ETL design and development of application solutions that meet customer requirements.
• Advanced Support Tier 4 of analyzing and solving production technical issues, and successfully implemented fixes/patches and coordinating Move-To-Production change management of ETL enhancements following the data warehouse best practice.
• PL/SQL programming NeoView SQL and Oracle .
• Ensuring quality and reliability of deliverables.
• Demonstrated strong communications skills with offshore teams in China Development Center and India Support Center ensuring highest standards of project deliverables and support.
• 24/7 on-call rotation for supporting Global Mission Critical Production Outages, Troubleshooting issues and Resolving problems.

Confidential

• Accenture Information Management Systems AIMS - Business Intelligence - Sr. Informatica Consultant United Health Care Group Integrated several legacy systems into one Enterprise Data Warehouse. Designed re-usable Common Component mappings. Setting standards for Design, Coding and Quality Assurance Test Procedures. Motorola Scope of the solution includes the release of Supply Chain BI capability for a telecommunications equipment manufacturer. Lead Informatica Developer. Star Schema Data Modeling and Business Requirements Analysis. Successfully designed and implemented ETL mappings and workflows for the next generation data warehouse. Project planning and budgeting. Provided mentorship for junior analysts. Data mining analysis using Oracle PL/SQL. Business Object reports development. Confidential Supply Chain IT - Business Intelligence - Business System Analyst IV Integrated Quality Data Collection System IQDC Front-End migration on retiring WWCIW's Brio reports into Business Object reports according to BI full development life cycle standards. Conversion efforts involved: Front-end and back-end system analysis in Oracle database, Business Object design documentation specification for universe reports, MS Project timeline planning, Review and sign-off with data governance committees and business stakeholders, Managing off-shore developers activities, Full system testing in development environment, Managing Change Management migration to integration environment, Coordination of users acceptance testing, Acceptance test using Mercury Interactive Test Director, Managing Change Management and Applications releases into production. Maintenance and support contract manufacturing quality data feeds, new sites on-boarding integrations and sustaining BRIO reports. Executive Information System EIS II Post merger reporting manufacturing metrics consolidation. Gather source data and analyze business requirements Informatica ETL developer for different data warehouse layers. World Wide Corrective Actions System Phase III design Lead Developer Tracks manufacturing product quality problems and ensures proper correction made. It requires users to work through the 8 Disciplines Corrective Action Process and tracks the workflow progress. Lead Developer of PHASE III using Microsoft Exchange Server 5.5 Outlook 2000 application programming with VB script, ASP and VB ActiveX controls tools to: Enhance manager email escalation and assignees' accountability. BSI audit required changes made on ISO Corrective Actions to conform to ISO9000 standards. Customized Crystal Reports for Houston, EMEA, and South America business units. ReEngineer PCs manufacturing data collection systems using tools with Oracle SQL SQL , PL/SQL to generate reports for executive directors tracking manufacturing defects repair efficiency. Integrated Quality Data Collection System developer
• An integrated Oracle warehouse containing worldwide Compaq quality data. It provides the user a set of easy to use data access tools for reporting, tracking, and analyzing product and process quality information.