SUMMARY:

• Comprehensive background in various corporate Oil & Gas Financial, Fixed Income, Energy, Trading, Manufacturing, Retail and Supply Chain Business areas.
• Capable of handling Data Governance, Master Data Management, Data Integration, Data Migration, Data Cleansing, Data profiling, Data Lineage on a large scale projects.
• Lead the delivery of Target Architecture for strategic business transformations and programs.
• Proficient in working with INFORMATICA MDM and comfortable working in Hierarchy Manager and IDD.
• Highly experienced in designing DW/BI and MDM Models - - OLAP Star/Snowflake Schema specialized in applications integration and customization.
• Talented in Designing E2E Solutions using DataLake Architecture using Hadoop Based Technology.
• Collaborated with the Data Lake to develop MDM/DW/Analytics Strategies and ETL design patterns.
• Expert in managing all facets of extract, transform load (ETL Technologies), MDM and Integration process to design Target Architecture for strategic business transformations and programs.
• Expertise in finding Data Warehousing and Data Integration Solutions using Informatica Power Center 10/9.X, Data Stage 8.X, and Business Objects XI R2.
• Competent in handling the roles of Solution Architect/DI/DW/ETL/BI Architect/DI/Data Management Specialist to maintain High Quality of Data in process of Data Integration.
• Proven expertise in all phases of complete Software Development Life Cycle under Project Management guidelines including Evaluation of Software Tools, SOX compliance.
• Upheld current with technology trends and emerging architectures and recommend applicability.
• Excellent communication, interpersonal, intuitive, technical and problem-solving skills. Thrive in both independent and collaborative work environments.
• Significant experience in successfully facilitating project work cycles with off-shore teams.

TECHNICAL SKILLS:

Operating System: Windows NT 4.0/XP/VISTA/7/8 Unix - SUN Solaris 5.8

Data Warehousing, BI, DQ and MDM: Informatica Power Center 10.X/ 9.X, Informatica MDM 10/9.X/Siperian XU, DataStage 8.X, InfoSphere Suite 8.5, Information Analyzer 8.5, Microstrategy 7.1, Business Objects XI R2 (SAP BO),Trillium V12, Composite Software 6.X,TIBCO 5.X

RDBMS: Oracle 9i/10G, SQL SERVER 2008/12, SYBASE 11,DB2, MS Access,DB2

Languages: PL/SQL, SQL PLUS, RPG/400, CL/400, SQL/400, QRY/400, RPGLE

Development Tools: Clear Quest, Erwin 8/9.X, Toad 9.1, IDQ, Vi Editor, Visio, Quality Center 9.0, Aldon CMS, DBU, Hawkeye, Ezview, Robot, Autosys, SharePoint

PROFESSIONAL EXPERIENCE:

MDM Solutions Architect/ Lead Data Modeler

Confidential

Responsibilities:

• Associated with IT Management/Stakeholders to align enterprise plans to strategic architecture direction and program management on planning of emerging enterprise services.
• Aligned EIM technical architecture framework with requirements defined by EIM Delivery.
• Provided leadership, guidance with Architecture best practices, governance, standards and conventions.
• Conducted workshops with SMEs, gathered MDM entities, relationships in Wells & Fields, Finance Model.
• Developed enterprise Conceptual models to integrate master data from diverse data sources into confirmed, high quality, and referentially sound enterprise MDM model for Wells, Finance and Supplier
• Reviewed DataLake Architecture and aligned stakeholders on the ongoing growth, value of the Data Lake.
• Designed Logical, Physical MDM models for Finance to fit in MDM in architecture framework and Reviewed with Architecture team.
• Deployed MDM Landing, Stage and Base Tables in MDM HUB and created Informatica MDM mappings to load data from Source to Staging Tables.
• Designed Trust and Survivorship, Data Validation rules for Match and Merge.
• Designed User Exits in to update the HUB data after Pre landing, Post Staging jobs.
• Derived relationships across Base Objects to configure Hierarchy Manager.
• Coordinated the development of Informatica MDM mappings and configuration with offshore.
• Created Match and Merge Rules to load Master in HUB and Template for Match Statistics reports.
• Analyzed source data patterns and created data cleansing, transformation and validation rules.

Environment: Informatica MDM 10.1, Informatica PC/IDQ 10, TOAD 9.1, ERWIN 9.6, UNIX 10, Jboss 7.0

Data Architect/ Lead Data Modeler

Confidential

Responsibilities:

• Completed the Solution Architectural Design for IMET to project data from Various Source Systems EC, PI, and Archestra through Composite Virtualization Environment.
• Guided the IT and Business Teams through the Enterprise architecture principles, policies and standards aligned to strategy.
• Designed Physical, Logical Data Models to ensure accurate mappings of data from source data to target by using Data Modelling Tool Erwin.
• Created Data Mapping Documents with Transformation Rules, to load into DW, Composite Data Virtualization Environment and UI.
• Architected Well Master Data and maintained (MDM) from various System of Records and maintained Physical Master Reference Data architecture.
• Designed/Reviewed Hadoop based Data Lake Architecture for various DM/DW/Reporting Projects associated with variety of Unstructured Data Sources of Upstream Business Solutions.
• Evaluated the strategic technologies - DW/Data Quality Tools required for Confidential ’s Up Stream Business.
• Managed, supported and facilitated E2E and User Acceptances Testing with Dev team, Business users and utilized Project Life Cycle skills as Technical Architect and as a project participant.

Environment: Informatica 9.X, DataStage 8.6, SQL Server 2008/2012, Composite Software 6.2Oracle 10g, TOAD 10.1, Erwin 9.1, PI, Energy Component, WPH, PPDM.

Informatica MDM Consultant

Confidential

Responsibilities:

• Coordinated with Business, IT Management to align enterprise plans to strategic architecture direction.
• Worked with Architecture team to model MDM Hub, MDM Landing, Stage and Base Tables.
• Created Data Mapping Documents to Load Data from Landing to Staging Tables.
• Created Data Migration Mappings, Sessions, and Workflows using Informatica 9.1.
• Developed Informatica MDM mappings for loading data into Siperian Staging Tables.
• Configuring Trust and Survivorship, Data Validation rules for Match and Merge.
• Created User Exits in PL/SQL to update the HUB data after Pre landing, Post Staging jobs.
• Derived relationships across Base Objects to configure Hierarchy Manager.
• Created Match Statistics reports for Match Rule, Involved in Testing of Landing to Staging to HUB.
• Analyzed source data patterns and created data cleansing, transformation and validation rules.
• Recommended Informatica strategies and best practices for mappings, mapplets and sessions.

Environment: Informatica MDM 9.X, Informatica Power Center 9.X, IDQ, Oracle 10g, TOAD 10.1, Solaris 5.8, JBOSS 5.8.

MDM - Consultant

Confidential

Responsibilities:

• Influenced Business, IT owners to define, develop and maintain strategic plan for MDM Solutions
• Setup Data Profile Lab using InfoSphere Information Server/Information Analyzer.
• Installed InfoSphere Information Analyzer on Linux Server and take care of administration.
• Profiled the Source system data for data consistency, data integrity, data aging, data validity, data accuracy and trustworthiness of the Source Data.
• Worked with Data Architects to establish DQ rules and implemented rules in IA.
• Defined Data Quality Standards, Identified Data Quality gaps, directed data clean-up activities.
• Established Definitions, and Quality Standards for Item, Customer, Supplier data.
• Defined Data Governance Committee Structure that enables business sponsorship and accountability in partnership with IT.
• Established an ongoing Data Quality program utilizing Data Stewards.

Environment: InfoSphere Information Server Suite 8.5, Information Analyzer 8.5, Oracle 10g, SQL Server 2008, DB2/400, DB2, TOAD 9.1, Linux.

Data Integration Consultant

Confidential

Responsibilities:

• Gathered Business Requirements from different Source Systems across LOBs for MDM Hub.
• Analyzed & Profiled Source system data for data accuracy, consistency, data aging, data validity.
• Prepared Business Requirements, Functional Requirement and Technical Design Documents.
• Validated with Business Users for trustworthiness of Data to integrate into MDM Hub.
• Created Data Mapping Documents to Load Data from Landing to Staging Tables.
• Derived relationships across Base Objects to configure Hierarchy Manager.
• Created Data Migration Mappings, Sessions, and Workflows using Informatica 9.1.
• Developed Informatica MDM mappings for loading data into Siperian Staging Tables.
• Worked with Architecture team to model MDM landing Tables, Stage Tables, and MDM Hub.
• Analyzed source data for patterns, prepared set of rules for data cleansing and transformation.
• Created Data Mapping Documents with Transformation, Cleansing Rules to load into MDM Hub.
• Worked with Data Governance team to prepare consolidation rules for excluding profiles from matching.
• Recommended Informatica best practices for mappings, mapplets and sessions.

Environment: Informatica PC/Exchange Grid 8.6.1, Informatica MDM/Siperian XU, Trillium 12, Oracle 10g, Salesforce, TOAD 9.1, Unix Sun Solaris 5.8.

ETL ARCHITECT

Confidential

Responsibilities:

• Gathered Business Requirements from different Source Systems (LOB) and Redesigned part of Data Warehouse OLAP/Star Schema as a part of Source Systems upgrade.
• Architected Functional Design/Data Model for new development and written Technical Specifications
• Involved in Enhancements and Support mode of the SENA/CREDIT MART warehouse.
• Setting up Cross Reference Data for Currency, UOM, Instruments and other Dimensions.
• Developed and Deployed medium to complex ETL Mappings, Sessions, Workflows and migrated into various Environments (SIT, UAT and PROD) of Informatica.
• Maintained, worked in multiple Environments (SIT, UAT, PROD) of Informatica 8.x/9.x
• Troubleshoot production alerts, issues in applications and perform bug-fixes.
• Ensure the integrity, high availability, reliability, security, and performance of Informatica tools.
• Involved in making decisions for Project execution and cutover plan for application to UAT and Go Live.
• Provided 24/7 production support to the existing ETL infrastructure, including bug resolution and enhancements of existing solutions.
• Made recommendations and technology suggestions to solve problems and improve efficiency.

Environment: Informatica PC/Exchange Grid 8.6.1, TIBCO 5.X,Oracle 10g, SAP/R3, SQL 2003, Endur 9, Legacy Main Frame, TOAD 9.1, Unix Sun Solaris 5.8.

Data Warehouse Architect

Confidential

Responsibilities:

• Gathered Business Requirements from different Source Systems (LOB) to meet the defined requirements for redesigning of Lead Conversion Analysis.
• Redesigned Data warehouse Solution Architecture of LCA for Operational Data Source.
• Written Functional Design and Technical Specification documents as per requirements.
• Have done Impact Analysis/Gap Analysis on existing Mappings of Lead Conversion Analysis.
• Defined guidelines to Maintain Master Data for Leads and dimensions using MDM process.
• Designed DW environment in OLAP/Star Schema Setting up X-Reference Data Dimension Tables.
• Worked with Micro Strategy team and Business users to define reporting requirements.
• Defined attributes, facts, filters, prompts required and generated ad-hoc reports in Report Builder to validate data in reports.
• Proactively seeks innovative solutions to customized needs of the different business needs.
• Provide troubleshooting and diagnostic support at L2 / L3 level for ETL and Database technologies

Environment: ORACLE9i, Datastage 7.5, SQL Server 2005, PL/SQL, TOAD, UNIX Sun Solaris 5.8., MicroStrategy 7.1

Sr. Tech Associate

Confidential, HOUSTON

Responsibilities:

• Gathered Business Requirements from the Line of Business (LOB) to meet the defined requirements and involved in Data Analysis and profiling.
• Written and maintained Functional Design and Technical Specifications documents.
• Designed data warehouse/data mart (OLAP/Star Schema) environments doing the data modeling creating physical and logical models .
• Lead the effort to create S2T Mappings and endure accuracy mappings of data from S2T.
• Set up Cross Reference Data and Managing Portfolio hierarchy as required.
• Developed and maintained complex Informatica Mappings, Sessions and Workflows.
• Created and maintained Business Objects Universes of as per analytical requirements.
• Generated WEBI/Desktop Reports for data transparency and data exceptions summary.
• Utilized project life-cycle management skills daily, as technical lead and as a project participant.
• Successfully facilitated project work cycles with off-shore teams during development.
• Created Test Plan and Test Strategy documents as needed, used Quality Center extensively.
• Effectively communicated with Developers, Architects, Admins, PMs BAs, QA, Users and Off-shore teams.
• Handled the Informatica Administration work and maintained DEV, SIT, UAT environments. Environment: ORACLE 9i, Informatica 8.1/7.1.4, SQL, PL/SQL, TOAD, UNIX Sun Solaris 5.8., Business Objects XI R2, AS/400, DB2, Endure.

Confidential, DAYTON, OH

Programmer

Responsibilities:

• Analysis, Functional Design & Spec Preparation.
• Data Conversion of all Master files.
• Coding, Testing & Writing Test Plans.
• Generating Reports using RLU and Query/400.
• Involved in Unit, Integration and User Testing and Implementation.

Environment: IBM AS/400, BPCS 6.0, PRMS, RPG/400, RPGILE, CL/400, and QUERY/400