PROFESSIONAL SUMMARY:

• Highly - skilled Data Engineering professional with 25 years of experience in Data Warehouse and Enterprise Data Analytics using ETL Data Integration, data quality, master data management, Statistical and data visualization tool, data modeling implementing EDW, and BI analytical and reporting in mainframe, client server and web-based environments for Healthcare, Insurance, Finance, Retails, Utility, HR, CRM, Telecom and Wireless industries.
• High ability to provide technical expertise across wide range of technology, to build strong partnerships with technical team, peers, business partners and vendors to maintain cohesive relationships with various teams and to deliver work.

TECHNICAL SKILLS

Databases: Oracle, MS SQL 2005 - 2016, SharePoint, DB2, Sybase, Teradata, NETEZZA, NetSuite, SAP, SFDC, RDS.

Software: Informatica Platform, Pervasive, Ab Initio, SQL, PL/SQL, SSIS, EDI x12, 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, Test tools, HP QC, and MS Office Suites.

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

Hardware/OS: MS Windows, NT, UNIX, LINUX, NOVELL, AS400, OS390, DG, AWS, Oracle Cloud CI and Hadoop.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Principal Enterprise (MDM) Architect

Responsibilities:

• Architect and design financial MDM 10.2 environment in premise and cloud databases and Salesforce.
• Administrate and provide production support for B2B integration IDQ, PC, IDD, AVOS and MDM 10.2 environment.
• Monitor B2B production performance integration processes using IDQ, PC and MDM 10.2 environment.
• Utilized remedy service tickets and Jira development, testing and production cloud environments.
• Architect and design manufacture and international logical and physical data models and EDW schema.
• Managed and administrated informatica IDQ 10.1 environment on the cloud and created users and groups
• Architect and design ETL reusable maps and apps to load retails items, orders and updates to cloud data objects.
• Led architecture manufacture and design retail EDW SaaS on the Cloud using Informatica IDQ 10.1 and PIM.
• Led development and performed data quality discovery to enterprise application systems using IDQ 10.x tools.
• 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.
• 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, SFDC, BO, SSIS, Informatica, MDM, Power BI, SAS BI, AWS, Java and Big Data.

Confidential, NJ

Data Architect Consultant/PM

Responsibilities:

• Expert resource set cutting edge industry standards SAS Data Flux, Data Cleansing and Data Quality Solutions.
• Utilized Informatica PC and IDQ 9.x developer; created Maps, Maples, Transformations, Sessions and Workflows.
• Led possesses functional and technical skills in the Data Governance and Master Data Management subjects.
• Managed ETL processes using Informatica, control tables, error logging, auditing, data quality and business rules.
• Utilized SQL queries and PL/SQL stored procedures and created maps in development and testing environments.
• Managed logical Data Model, Slowly Changing Dimension and architecture using intelligent MicroStrategy.
• Created SAS data sets, macros, developing statistical analysis, and created financial visualized report.

Environment: LINUX, Oracle, Teradata, MS SQL, Netezza, BO, Informatica, IDQ, SAS, SFDC, Java, Power BI and Big Data.

Confidential

Senior IPS DQ Consultant

Responsibilities:

• Managed business requirements, perform analysis identifying Data Quality Solutions using MDM and IDQ tools.
• Utilized Informatica PowerCenter 9.x developer; created Maps, Maples, Transformations, Sessions and Workflows.
• 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.
• Applied business rules as required to Data Cleansing maps, Data Quality Solutions and Created dashboard.
• Managed and led Informatica 9.x server and client installation on MS 2008 server, Oracle and VM environments.
• 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, SFDC, Teradata, MS SQL, DB2, Netezza, BO, Informatica, DQ, SAS, Java, VM and UNIX.

Confidential, CA

Sr. Tech Lead

Responsibilities:

• Led Vender's development team using Agile and Scrum master methodology 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, Trizetto FACETS and LINUX.

Confidential, CA

Enterprise Data Architect/Senior ETL Architect

Responsibilities:

• Designed and developed logical, physical data models, and metadata objects migrating enterprise architecture.
• Designed Business Objects Universe adding tables, identify joins and contexts and define new classes.
• Utilized Informatica PowerCenter 9.1 designer; created Maps, Maples, Transformations, Sessions and Workflows.
• 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.
• 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.

Confidential, Boise, ID

Enterprise Data Architect/PM

Responsibilities:

• Gathered business requirement, performed analysis, creating enterprise architecting processes and documentation
• Design and lead EDW ETL mapping design, data modeling, managing data quality into Utility EDW system.
• Designed eCommerce/OLTP application data models and created Hives/DDL to support both RDBMS and Hadoop environments.
• 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.
• Architect, developed logical, physical data models, and metadata objects in Big Data and EDW environments
• Managed and led inbound/outbound claims, encounter and membership data integration into Big Data, EDW.
• Managed developing lifecycle agile, waterfall and Scrum Architecture standard and methodologies using Togaf.
• Managed HIPAA 837 institutional and 837 Professional claims conversion from ver. 4010 to ver.5010.
• Led and managed HIPAA 834, 820, 837 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.
• Created datasets using SAS/STAT and Graphs creating encounter statistical and descriptive reports for business.
• Used PROC SQL for ad-hoc report performs data manipulation and analysis using SAS/STAT Procs.

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

Confidential, CA

Enterprise Data Architect/Sr. BI Consultant

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.
• 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.
• Worked with big data architect to determine how the source data will be distributed and processed in Hadoop.
• 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, Hadoop, Big Data, MS SQL, DB2, SAS, EDI, Informatica, Perl, Remedy, BO and Cognos.

Confidential, CA

Enterprise Data Architect/PM

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.
• Architected and maintained wireless Enterprise Data Warehouse utilizing (Kimball) Bottom/Up approach.
• Maintained Telecommunication billing systems and create billing cycles descriptive and analytics reports.
• Provided technical support to AMDOC Telecom 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.

Confidential

Enterprise Data Architect/Sr. PM

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.
• 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.
• Managed utilities (PW&E) systems (Billing, Metering, Payments, Rates, Services provision and reports).
• Designed and created (ER diagram, logical and physical) dimension models using Erwin data modeling.
• Maintain called C subprograms to extract data using embedded queries and PL/SQL functions and packages.
• Optimized and tuned queries performance and created analytical financial and listing using Reporting tools.
• Created datasets and required billing cycle statistical and listing reports using SAS, Macros and Graphs.
• Managed pharmacy prescription claims, pricing adjudication, inventory and drug education report system.
• Maintain called C subprograms to extract data using embedded queries and PL/SQL functions and packages.
• Managed EDI data maps and interfaces using HL7, ANSII X12 for HIPAA compliance requirement
• Utilized BO designer creating List and Cross-reference descriptive and statistical visualize reports.
• Created SAS datasets, developed descriptive statistical reports using SAS/STAT, SAS/Macro and Graphs.

Environment: Oracle, DB2, SQL Server, COBOL, C, Erwin, Crystal Reports, SAS, Java, EDI, HL7 and UNIX.