SUMMARY:

Highly - skilled Data Engineering professional with 25 years of experience in architecting, data modeling and implementing EDW and BI analytical and reporting in mainframe, client server, desktops and web-based environments for Finance, Retails, Utility, HR, CRM, Insurance and property causality, Telecom and Wireless industries.

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, SSRS, Micro Strategy, BO, BO Universes, Cognos, Cognos Framework, Tableau, QlikView

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

ENTERPRISE DATA LEADERSHIP SKILLS/EXPERIENCES

DATA WAREHOUSE:

• 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.
• 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, Map and Report studio and Data Miner.
• 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.
• Skilled in Salesforce SaaS CRM applications and functionality (Sales, Servi ces, Marketing, and PO).
• Lead communication influencing senior management and decision makers about new Technologies updates.

• Manage and Oversight EDW Data Governance and Quality framework implementing organizations objectives.
• Applied business rules as required to Data Cleansing maps, Data Quality Solutions and Created dashboard.

PROFESSIONAL EXPERIENCE:

Architect

Confidential, Plano, TX.

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 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.

Environment: Linux, MS SQL, Oracle, Salesforce, BO, IDQ Cloud, MDM, PC, WebSphere, SAS BI, AWS, Java.

Architect

Confidential, Hillsboro, OR.

Responsibilities:

• 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.

Environment: Linux, MS SQL, Teradata, Salesforce, BO, IDQ Cloud, MDM, PIM, IMM, PC, SAS BI, AWS, Java.

Data Architect Consultant

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.
• 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: Oracle, ODI, 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, Trizetto FACETS and LINUX.

Enterprise Data Architect/Senior ETL Architect

Confidential, Foster City, CA

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 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, ODI, Teradata, MS SQL, BO, SSIS, Informatica, 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 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.
• 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 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, 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, Burbank, 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, Remedy, BO, Cognos and Infosphere