SUMMARY:

• Highly - skilled Data Engineering professional with 25 years of experience in architecting, data modeling and implementing EDW and BI analytical reporting solutions in mainframe, client server, desktops, web-based environments in Healthcare Insurance, Labs and Pharmacy, Finance, Retails, Utility, HR, CRM, Insurance and property causality, Telecom and Wireless environments.
• Hands on experience in EDW architecture, Data modelling quality and Integrity and Business Intelligence solutions.
• Hands on experience using ETL tools Informatica (PC, IDQ, MDM,PIM and BDE), Cloud, Pervasive, SSIS and EDI.
• Experience in creating visualizes analytical reports using SAS BI, Oracle BI Suite, BO, Tableau and Microstrategy.
• System Analysis, Design, data Integration and Change Management and Performance Improvement experience.
• IT PM and SDLC, Healthy workers (Medi-Cal, Healthy worker and Child Health) and Medicare Federal planes.
• PMI member and Certified TOGAF training
• Hands on experience using Informatica (PC, DQ, IMM, MDM, PIM and cloud) and IBM MDM implementation.
• Experience using Teradata ETL BTEQ scripting and load utilities (FastLoad, Multiload, TPump and FastExport)
• Proficient in using IDQ, MDM, data profiling, cleansing, parsing, standardization, validation, matching and merging.
• Hands on experience using Erwin and ER/Studio modeling tool creating Logical, Physical and Cubes Data Models.
• Hands on architecting and designing logical and physical EDW schemas and table, integrating various regional and national healthcare MDM systems and creating BI analytical reports using Service Oriented Architecture approach.
• Utilized EDW integration in various data sources and targets environment like Oracle, DB2, MS SQL, TERADATA, Sybase and MAINFRAM VSAM. XML and sequential files implementing EDW object’s performance improvement.
• Experience using EDI X12, HL7 and HIPAA integration for 837IPD, 834, 277, 278, 835, 820 and 99 7 transactions.
• Created HEDIS and informatics reports to Medi-Cal California state (Medicaid) and Medicare Federal programs.
• Utilized financial data models in the Cognos Framework manager, created dimensions and analytics measures.
• Developed Query studio and Report Studio extract data and creating complex queries retail descriptive reports.
• Architected Facets membership, provider, financial and claims extracted daily medical management data into EDW.
• Experience with Confidential appliance Netezza MPP, design, data vault modeling and BigData with (Hadoop).
• Expertise in leading and manage SDLC producing high quality deliverables in EDW on time and under budget.
• Significant experience managing both people, projects and PMO office using Waterfall, Agile and Scrum master.
• Teams using Jira for project management architecting processes using Togaf Enterprise Architecture standard
• Experience managing vendor's team up to 50 professional members on/off shore delivering EDW and BI solutions.
• Hands on experience using statistical SAS BI tools such as SAS EG, Information Map studio, Report studio Data Miner, Management Console in Windows, UNIX and Mainframe environment creating analytics and reporting.
• Created complex financial visualize analytical and graphical reports using SAS BI, Microstrategy, BO and Tableau.
• Worked across several project's life cycle, implementation using Agile, Waterfall and Scrum methodologies.
• Hands on working knowledge of CITRIX, Java Development Platform and Object Oriented Languages like C, C++.
• Broad knowledge of various drug therapeutic categories and corresponding indications and treatment protocols.
• Skilled in Salesforce SaaS CRM applications and functionality (Sales, Servi ces, Marketing, Community and Analytics), Managed sales, marketing creating monthly, quarterly and annually financial and analytical reports.
• Lead communication influencing senior management and decision makers about new Technologies updates.
• Completed Trizetto Facets 5.0 Technical Foundation, data models and applications certified training.
• Support Trizetto Facets Version migrations to 5.x applications and Tech. lead conversion DEV and UAT teams.
• TriZetto QNXT certified Product Associate training using BizTalk and EDI mapping to QNXT backend MDM tables.
• Manage and Oversight EDW Data Governance and Quality framework implementing organizations objectives.
• Managed pharmacy and MDM (pharmacy, medical, claims, patients, providers and ICD9/10, CPT, DRUG codes).

TECHNICAL SKILLS:

Databases: Oracle MS SQL 2005 - 2014 MS SharePoint DB2 Sybase Teradata NETEZZA NetSuite SAP

Software: Informatica (PC, IDQ, MDM, BDE) Pervasive Ab-Initio SQL PL/SQL SSIS EDI SPSS Toad Base SAS, SAS/MACRO FTP/SFTP Lotus Notes .NET MS Project Remedy UNIX scripting Perl Python VB Erwin, SAS DI Sybase Power Designer ER/Studio TCL C/C++ Java XML MF COBOL IBM Rational tools, Mercury tools (Winrunner, Loadrunner, QTP and TD) HP QC EDI x12 MS Office Suites

Reporting/Analytics: SAS Web Report Studio Information Map Studio SAS DataFlux EG Data Miner SSAS SSR, Micro Strategy BO BO Universes Cognos Cognos Framework Tableau QlikView

Hardware/OS: MS Windows NT UNIX LINIX NOVELL AS400 OS390 DG

PROFESSIONAL EXPERIENCE:

Principal

Confidential, Hillsboro, OR

Responsibilities:

• Lead design and architecture design manufacture retail EDW using Informatica IDQ 10.1 on the Cloud and PIM.
• Led development team to perform data quality discovery to enterprise application systems using IDQ 10.x tools.

Environment: Linux, MS SQL, SalesForce, BO, SSIS, Informatica Cloud, MDM, PIM, IMM, SAS BI, AWS, Java.

Data Architect Consultant/PM

Confidential, San Francisco, CA

Responsibilities:

• Lead design and support functional and technical cloud CRM SalesForce using Informatica Cloud, IMM and MDM.
• Utilized Java scripts to manage inbound/outbound files around development, testing and runtime environments.
• Utilized SQL queries and PL/SQL stored procedures and created maps in development and testing environments.
• Lead supporting CRM Analytics retail reports in cloud environment using BO, HANA, SAS BI and Host Analytics.
• Created logical and physical Data Model using intelligent Microstrategy Facts and Dimensions objects for reports.

Environment: Linux, NetSuite, MS SQL, SalesForce, BO, SSIS, Informatica Cloud, MDM, SAS BI, AWS, Java.

Data Architect Consultant/PM

Confidential, Jersey City, NJ

Responsibilities:

• Expert resource set cutting edge industry standards SAS Data Flux, Data Cleansing and Data Quality Solutions.
• Managed gathering business requirements, analysis MDM, Data Cleansing and identifying Data Quality Solutions.
• Led possesses functional and technical skills in the Data Governance and Master Data Management subjects.
• Provided solutions aligned with bank data governance strategy and in accordance with regulatory within IHC.
• Managed ETL processes using Informatica, control tables, error logging, auditing, data quality and business rules.
• Participated in setting strategy and standards through logical and physical modeling and implementation of EDW.
• Utilized SQL queries and PL/SQL stored procedures and created maps in development and testing environments.
• Utilized Python scripts to manage inbound/outbound files around development, testing and runtime environments.
• Managed logical Data Model, Slowly Changing Dimension and architecture using intelligent Microstrategy.
• Implemented Microstrategy objects such as attributes, facts, hierarchies and complex metrics dimensions.
• Created SAS data sets, macros and developing statistical analysis and created financial visualized report.

Environment: Oracle11, Teradata, MS SQL, Netezza, BO, Informatica, IDQ, SAS, SSIS, Java, LINUX and UNIX.

Senior IPS DQ Consultant

Confidential

Responsibilities:

• Managed business requirements, perform analysis identifying Data Quality Solutions using MDM and IDQ tools.
• Define and perform Data discovery and Data Cleansing creating Transformation for the MDM implementation.
• Led development team to perform data quality discovery to enterprise application systems using IDQ 9.x tools.
• Managed and led Informatica 9.x server and client installation on MS 2008 server, Oracle and VM environments.
• Utilized Informatica DQ developer 9.x profiling source data and creating mapping, moppets and business rules.
• Utilized IDQ profiling structured/unstructured data, creating business rules, comment, IDD, Tags and scorecards.
• Hands-on experience utilizing Informatica Data Quality, IDD, IMM toolsets, data exception and error handling.

Environment: Oracle, SSIS, Teradata, MS SQL, DB2, Netezza, BO, Informatica, DQ, SAS, Java, VM and UNIX.

Enterprise Data Architect / Sr. Tech Lead

Confidential, San Francisco, CA

Responsibilities:

• Led Vender's development team using Agile and Scrum master methodolegy for cross functional teams using Jira for project management to migrate enterprise architecting processes using Togaf Enterprise Architecture standard.
• Utilized Informatica powercenter 9.1 designer; created Maps, Maples, Transformations, Sessions and Workflows.
• Performing data analysis, existing ETL mapping to identify the root cause of process performance issues.
• Architected accountable care organization (ACO) facets provider and members medical management data.
• Architected Facets claims, provider and members extracted data into EDW using Informatica powercenter 9.x.
• Provided technical support and facets architecture and migration life cycle and testing from ver. 4.7 to ver. 5.01.
• Managed Facets regression testing to the new version Ver. 5.01 and environments object performance and reports.
• Manages all aspects of the HEDIS reporting process and direct reporting of measures to the state partners.
• Created logical, physical Data Model and used intelligent Microstrategy architecting Facts and Dimensions objects.
• Reengineer ETL maps, sessions and workflows and other objects to improve hpXr applications performance.
• Provided technical support to business users and solving day to day service problems and issues as needs.

Environment: Oracle, Teradata, MS SQL, Netezza, BO, Togaf, Informatica, SAS BI, FACETS and LINUX.

Enterprise Data Architect/ Senior ETL Architect

Confidential, Foster City, CA

Responsibilities:

• Architect, developed logical, physical data models, and metadata objects migrating enterprise architecting processes using Togaf Enterprise Architecture standard. in enterprise Confidential .
• Designed Business Objects Universe adding tables, identify joins and contexts and define new classes.
• Utilized Informatica powercenter designer; created maps, various transformations, sessions and workflows.
• Created complex and reusable macros and SAS data sets, analysis and generated financial graphical report.

Environment: Oracle, Teradata, MS SQL, BO, SSIS, Informatica 9.1, Togaf, SAS BI, Windows, LINUX and UNIX.

Enterprise Data/ ETL Consultant

Confidential, Bellevue, WA

Responsibilities:

• Performing data analysis, providing support for existing systems; troubleshooting data and system issues.
• Architected and utilized Informatica PC creating Maps, Mapplets, Transformations, Sessions and Workflows.
• Created complex and reusable macros and SAS data sets, analysis and generated financial graphical report.

Environment: MF COBOL, MS SQL 2008, DB2, SSIS, Informatica powercenter 8.5, SAS BI, Windows and UNIX.

Enterprise Data Architect /PM

Confidential, Boise, ID

Responsibilities:

• Gathered business and end user's requirement, performed analysis, creating required enterprise documentation and architecting processes using Togaf Enterprise Architecture standard.
• Architect and lead EDW ETL mapping design, data modeling, managing data quality into Utility EDW system.
• Managing support EDW team of technical resources (on-site and off-shore) and ensure project delivery.
• Created and developed (logical and physical) and star schema modules using Erwin data modeling tool.
• Created datasets using SAS/STAT and Graphs creating statistical descriptive reports for business research.

Environment: MS SQL, Oracle, DB2, Informatica, Erwin, SAS, SSIS, TOGAF, SAP, BO, QC, Windows and UNIX.

Sr. Data Analyst/PM

Confidential, San Francisco, CA

Responsibilities:

• Architect, developed logical, physical data models, and metadata objects in BigData and EDW environments
• Managed and led inbound/outbound claims, encounter and membership data integration into BigData, EDW.
• Managed project's system developing lifecycle agile, waterfall and Scrum architecting processes using Togaf
• Enterprise Architecture standard and methodologies approaches.
• Managed HIPAA 837 institutional and 837 Professional claims conversion from ver. 4010 to ver.5010.
• Led and managed HIPAA 834, 837, 820 institutional and 837 Professional EDI data integration to QNXT.
• Manages all aspects of the HEDIS reporting process and direct reporting of measures to the state partners.
• Used PROC SQL for ad-hoc report performs data manipulation and analysis using SAS/STAT Procs.

Environment: MS SQL, SAS, EDI, Pervasive, SAS, SSIS, QNXT, TOGAF, COGNOS, BO, HIPAA and UNIX.

Enterprise Data Architect /Sr. BI Consultant

Confidential, CA

Responsibilities:

• Gathered business and end user's requirement, performed analysis and created required documentation.
• Designed Business Objects Universe adding tables, identify joins and contexts and define new classes.
• Utilized Informatica powercenter designer; created maps, various transformations, sessions and workflows.
• Managed financial data models in the Cognos Framework manager and created dimensions and measures.
• Created complex and reusable macros and developed data sets, analysis programs and generated report.
• Created datasets using SAS/STAT and Graphs creating statistical descriptive business reports as required.
• Created sales, marketing monthly, quarterly and annually financial analytical reports using Oracle BI Suite.

Environment: Oracle, Teradata, MS SQL, Sybase, SAS, Informatica, SSIS, Perl, BO, Cognos, UNIX and Windows.

Sr. Data Analyst/Lead

Confidential, Woodland Hills, CA

Responsibilities:

• Utilized Informatica 8.6 designer; created Maps, Maples, Transformations, Sessions and Workflows objects.
• Administered MDM team Informatica environment creating users, groups, folder and assigning privileges.
• Involved in Software Development Life Cycle (SDLC) of the application, requirement gathering, design and analysis.
• Monitored daily workflow's data loads reporting failed sessions and improved session's load performance.
• Provided technical support to business users and solving day to day service problems and issues as needs.

Environment: Oracle, Teradata, MS SQL, DB2, SAS, EDI, Informatica, Perl, XML, Remedy, BO, Cognos and IBM Infosphere .

Enterprise Data Architect /PM

Confidential, Los Angeles, CA

Responsibilities:

• Designed Enterprise financial institute Data Warehouses utilizing Bottom/Up (Kimball) EDW's approach.
• Developed commercial loans/mortgage applications and maintained interest, amortization's calculations and created required borrower's applications, legal documents and payments instalment interval reports.
• Managed Insurance and property causality estimate, calculation applications and DataMart systems.
• Utilized Cognos Query studio and Report Studio developing complex queries extract required information.
• Enhanced exist Business Objects Universe design adding dimension tables, joins and defined new classes.
• Converted Clinical study SAS code to SQL code creating Facts, dimensions tables and analytical reports.
• Managed and supported EDW team of technical resources (on-site and off-shore) and ensure project delivery.

Environment: Oracle, Teradata, SQL Server, Erwin, Informatica, UNIX, SAS, Visio, BO, Cognos, and Java.

Enterprise Data Architect /SQA

Confidential, Bellevue, WA

Responsibilities:

• Architected and maintained wireless Enterprise Confidential utilizing (Kimball) Bottom/Up approach.
• Maintained Telecommunication billing systems and create billing cycles descriptive and analytics reports.
• Provided technical support to Confidential management system and monitor data load and extracts.
• Maintain called C subprograms to extract data using embedded queries and PL/SQL functions and packages.
• Designed maps, Various Transformations, Sessions and Workflows using Informatica powercenter Designer.
• Created and developed (logical and physical) and multidimensional modules using Erwin modeling tool.
• Created financial and semimonthly billing cycle descriptive and analytical reports using Oracle BI Suite.
• Created SAS descriptive statistical programs to generate wireless billing cycle's cross-reference reports.

Environment: Oracle, TOAD, Informatica, EDI, MS SQL, SAS, Erwin, SSIS, Java, VBScript, Java, PCVS and UNIX.

Enterprise Data Architect /Sr. PM

Confidential

Responsibilities:

• Designed and developed Maps, Transformations, Sessions and workflows using Informatica powercenter.
• Designed and created (ER diagram, logical and physical) dimension models using Erwin data modeling.
• Exported Business Object universes into repository to be available to the users for ad-hoc reports.
• Created datasets using SAS/STAT and SAS/Graphs to create statistical descriptive business reports.

Environment: SQL Server, ORACLE, DB2, SAS 9, Crystal Reports, C, MS Project, Windows and UNIX.

Enterprise Data Architect /Project Lead

Confidential, Albany, NY

Responsibilities:

• Gathered business and HIPAA requirements and perform analysis and documentation using EDI X12 Trans.
• Created and developed HIPAA 837 Institution, Professional and Dental claim applications and reports.
• Created and developed Medicare and Medicaid daily and monthly status (claims and payment) reports.
• Developed various Maps and Transformations like (expression and filter) using Informatica Designer.
• Provided In-house support to Electronic Data Exchange (EDI) translator and interfaces using HL7 Standards.
• Created and developed (logical and physical) and star schema modules using Erwin and E/R modeling tools.
• Created datasets and developed statistical analytical reports using SAS/STAT, SAS/Macro and graphs.

Environment: ORACLE, DB2, EDI, Erwin, SAS, COBOL, C, JCL, COGNOS, Informatica, HIPAA, OS/390 and UNIX.