SUMMARY

• 15 years of experience in information technology, including more than 8 years of experience in Data warehousing ETL tool Informatica Power Center, Informatica Data Quality (IDQ) & Data governance tools - Collibra /Big Id /Metacenter
• Establish and govern an enterprise data governance implementation roadmap including strategic priorities for development of information-based capabilities
• Roll out an enterprise wide data governance framework, with a focus on improvement of data quality and the protection of sensitive data through modifications to organization behavior policies and standards, principles, governance metrics, processes, related tools and data architecture
• Define roles and responsibilities related to data governance and ensure clear accountability for stewardship of the company’s principal information assets
• Serve as a liaison between Business and Functional areas and technology to ensure that data related business requirements for protecting sensitive data are clearly defined, communicated and well understood and considered as part of operational prioritization and planning
• Develop & maintain inventory of the enterprise information maps, including authoritative systems, owners
• Facilitate the development and implementation of data quality standards, data protection standards and adoption requirements across the enterprise
• Define indicators of performance and quality metrics and ensure compliance with data related policies, standards, roles and responsibilities, and adoption requirements
• Lead Senior Management, comprising resources from the Business and Functional areas and IT business and operations functions, to achieve their objectives; resolve issues escalated from Business and Functional areas data governance representatives
• In conjunction with the IT, provide progress reports to Board management and oversee periodic updates to the Department Data Governance Roadmap
• Coordinate external data sources to eliminate redundancy and streamline the expense related to those services
• Identify new business opportunities pertaining to the use of information assets to achieve efficiency and effectiveness in the marketplace / represent data as a strategic business asset at the Senior Management table
• Experience in developing, maintaining, migrating and enhancing large business applications in the domain of Insurance, Financial Services and Healthcare.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center 8.x/9.x/10.x (Repository Manager, Mapping Designer, Workflow Manager, Mapplet Designer, Workflow Monitor, Source Analyzer, Transformations Designer, Warehouse Designer), Informatica Data Quality(IDQ) v10.0.0,Power Exchange, Power Connect.
• Experience in Integration of various relational/non relational, Structured/Unstructured data sources like Oracle, Teradata, SQL Server, Message Queues, HL7/EDI x12 HIPAA transactions, UDB DB2, Mainframe data sources(DB2, VSAM), Legacy systems, Netezza, Siebel, ERP systems (SAP BW, SAP R/3) and Flat Files into Flat Files, CSV files, Oracle, Teradata Staging Area/Warehouse.
• Proficiency in data warehousing and data modeling concepts such as Star Schema/Snowflake modeling, OLAP/ROLAP, Fact and Dimensions tables, Physical and logical data modeling.
• Strong knowledge of RDBMS like DB2, Oracle, SQL Server, Teradata.
• Strong experience in writing optimized SQL queries, PL/SQL scripts.
• Experienced with using Teradata utilities Teradata Parallel Transporter (TPT), Fast Load, Multi Load, Fast Export and BTEQ scripts.
• Extensive experience in Mappings, Mapplets, Sessions and Workflow development.
• Experience in using transformations like Source Qualifier, Expression, Router, Update Strategy, Filter, Lookup, SQL Transformation, MQ Series, Web Consumer, Web Provider, Joiner, Normalize, Stored Procedure, Sequence Generator, XML, Unstructured Data Transformation, BAPI Transformation, DQ Transformations Labeler, Standardize, Address validation (Address Doctor) etc to perform cleansing, parsing etc. process.
• Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
• Good analysis skills with an ability to transform the needs of business users and stake holders into functional/technical requirements. Prepared Functional design doc, source to target mapping sheets, technical design, Unit test specifications and deployment documents as per the process compliance.
• Experience in US/UK clients projects and interaction with Business users, Data Modelers, Architects, Business Analysts, Project Managers, Testing Analysts, Configuration team, Change Management team, Infrastructure Team, Support teams, Quality team and various technical/functional teams.
• Extensive experience in all phases of the Software Development Life Cycle (SDLC) including Pre-Initiation, Requirements gathering, Analysis, Planning, Design, Coding, Testing, Reviews, Test Support, Implementation, Warranty Support, Production Support, Documentation & Project End.
• Mentored team members on technical/business concepts.
• Experience of handling team and worked in onsite and offshore model.
• Strong trouble-shooting, problem-solving skills and with abilities to work independently and in a team environment
• Excellent Inter-personal skills and a quick learner.

TECHNICAL SKILLS

Data Governance Tools: Collibra 5.3/Big id /Metacenter /Manta

ETL/Data Quality Tools: Informatica Power Center 8.x/9.x( Designer, Workflow Manager, Workflow Monitor, Repository manager, Informatica Administration Console),Informatica Meta Data Manager,Power Exchange 8.x/9.x/10.x. Informatica Data Quality v10.0.0(Informatica Developer,Informatica Analyst,Admin Console, Monitoring console)

Programming Languages: SQL, PL/SQL,Unix Shell Scripting,Cobol,JCL,CICS,C,C++, RexxObject Star and Visual Basic 6.0.

Databases: Oracle 9i/10g/11g, DB2, VSAM,Teradata v 13.10/14.0,SQL Server 2005/2008,MS-Access,Teradata

Tools: /Utilities: Tidal,Autosys,Control-M,IBM Websphere MQ,Teradata SQL Assistant, SQL Developer, Endevor, Panvalet,Max, ADW, HAT, Proforma,Xpediter, INTERTEST,QMF,Dump Master, EASYTRIEVE,Trace Master, SPUFI,NET EXPRESS, QMF,Tivoli OPC(TWS), MS -Office, Visio,Quality Center/ALM, Service Now, Tortosie SVN and Remedy

Operating Systems: Microsoft Windows 7/Vista/XP/2000/NT, UNIX, IBM OS/390

PROFESSIONAL EXPERIENCE

Confidential, Boston

Data governance - Data Quality - Metadata management Architect

Responsibilities:

• Establish and govern an enterprise data governance implementation roadmap including strategic priorities for development of information-based capabilities
• Roll out an enterprise wide data governance framework, with a focus on improvement of data quality and the protection of sensitive data through modifications to organization behavior policies and standards, principles, governance metrics, processes, related tools and data architecture
• Define roles and responsibilities related to data governance and ensure clear accountability for stewardship of the company’s principal information assets
• Serve as a liaison between Business and Functional areas and technology to ensure that data related business requirements for protecting sensitive data are clearly defined, communicated and well understood and considered as part of operational prioritization and planning
• Develop & maintain inventory of the enterprise information maps, including authoritative systems, owners
• Facilitate the development and implementation of data quality standards, data protection standards and adoption requirements across the enterprise
• Define indicators of performance and quality metrics and ensure compliance with data related policies, standards, roles and responsibilities, and adoption requirements
• Lead Senior Management, comprising resources from the Business and Functional areas and IT business and operations functions, to achieve their objectives; resolve issues escalated from Business and Functional areas data governance representatives
• In conjunction with the IT, provide progress reports to Board management and oversee periodic updates to the Department Data Governance Roadmap
• Coordinate external data sources to eliminate redundancy and streamline the expense related to those services
• Identify new business opportunities pertaining to the use of information assets to achieve efficiency and effectiveness in the marketplace / represent data as a strategic business asset at the Senior Management table

Confidential

Senior IDQ/Data Governance Architect

Responsibilities:

• Interacted with Business users, Business Analysts, Architects, Data Modeler, DBA, Informatica Admin and Technical teams.
• Prepared the Design documents, Source to Target mapping sheet, Unit Test Plans, Code review checklists, Punch lists (Deployment components/activities sheets), Operations Manuals (Run book) etc.
• Involved in new data marts creation for existing data ware house with additional requirements, high quality, performance and worked on adhoc requests like data feed loads, data extracts etc.
• Developed the mapplets/rules in IDQ to apply data quality rules, perform cleansing, fetch CHRISTUS standard code values for source system data, set the score cards etc.
• Extensively created and used physical data objects, logical data objects, reference tables, reference files like dictionaries, address doctor (.MD files), domain names etc. in the mapplets.
• Developed the mappings, workflows, data services(web services, SQL services), Applications, DQ Rules/mapplets in IDQ to fetch the data from Flat Files, Teradata Staging tables, apply DQ rules, transformation logics etc and load the transformed data along with company standard code values and score cards target tables of Teradata Enterprise data ware house.
• Performed import/export for components and deploy /redeploy applications.
• Created the schedules in IDQ Admin Console.
• Executed and monitored the development IDQ workflows in Admin Console.
• Developed the mappings, mapplets, workflows, tasks etc in Informatica Power Center to read the data from Flat Files, CSV files, SQL server, Oracle, Teradata Staging tables, Message Queues, apply the transformations and load the data to Flat Files, CSV Files, SQL Server, Teradata Enterprise Ware house.
• Worked with HL7 v2 (ADT, BAR, ORM, RDE), EDI X12 v5010 (277,834,835,837) transactions data and loaded the data into Teradata tables.

Confidential

Data Governance & Metadata manager

Responsibilities:

• Define indicators of performance and quality metrics and ensure compliance with data related policies, standards, roles and responsibilities, and adoption requirements
• Lead Senior Management, comprising resources from the Business and Functional areas and IT business and operations functions, to achieve their objectives; resolve issues escalated from Business and Functional areas data governance representatives
• In conjunction with the IT, provide progress reports to Board management and oversee periodic updates to the Department Data Governance Roadmap
• Coordinate external data sources to eliminate redundancy and streamline the expense related to those services
• Identify new business opportunities pertaining to the use of information assets to achieve efficiency and effectiveness in the marketplace / represent data as a strategic business asset at the Senior Management table
• Extensively created and used physical data objects, logical data objects, reference tables, reference files like dictionaries, address doctor (.MD files), domain names etc. in the mapplets.
• Developed the mappings, workflows, data services(web services, SQL services), Applications, DQ Rules/mapplets in IDQ to fetch the data from Flat Files, Teradata Staging tables, apply DQ rules, transformation logics etc and load the transformed data along with company standard code values and score cards target tables of Teradata Enterprise data ware house.
• Performed import/export for components and deploy /redeploy applications.
• Created the schedules in IDQ Admin Console.
• Executed and monitored the development IDQ workflows in Admin Console.
• Developed the mappings, mapplets, workflows, tasks etc in Informatica Power Center to read the data from Flat Files, CSV files, SQL server, Oracle, Teradata Staging tables, Message Queues, apply the transformations and load the data to Flat Files, CSV Files, SQL Server, Teradata Enterprise Ware house.
• Worked with HL7 v2 (ADT, BAR, ORM, RDE), EDI X12 v5010 (277,834,835,837) transactions data and loaded the data into Teradata tables.

Confidential

Data governance & metadata management

Responsibilities:

• Interacted with Business users, Business Analysts, Architects, Data Modeler, DBA, Informatica Admin and Technical teams.
• Prepared the Design documents, Source to Target mapping sheet, Unit Test Plans, Code review checklists, Punch lists (Deployment components/activities sheets), Operations Manuals (Run book) etc.
• Involved in new data marts creation for existing data ware house with additional requirements, high quality, performance and worked on adhoc requests like data feed loads, data extracts etc.
• Developed the mapplets/rules in IDQ to apply data quality rules, perform cleansing, fetch CHRISTUS standard code values for source system data, set the score cards etc.
• Extensively created and used physical data objects, logical data objects, reference tables, reference files like dictionaries, address doctor (.MD files), domain names etc. in the mapplets.
• Developed the mappings, workflows, data services(web services, SQL services), Applications, DQ Rules/mapplets in IDQ to fetch the data from Flat Files, Teradata Staging tables, apply DQ rules, transformation logics etc and load the transformed data along with company standard code values and score cards target tables of Teradata Enterprise data ware house.
• Performed import/export for components and deploy /redeploy applications.
• Created the schedules in IDQ Admin Console.
• Executed and monitored the development IDQ workflows in Admin Console.
• Developed the mappings, mapplets, workflows, tasks etc in Informatica Power Center to read the data from Flat Files, CSV files, SQL server, Oracle, Teradata Staging tables, Message Queues, apply the transformations and load the data to Flat Files, CSV Files, SQL Server, Teradata Enterprise Ware house.
• Worked with HL7 v2 (ADT, BAR, ORM, RDE), EDI X12 v5010 (277,834,835,837) transactions data and loaded the data into Teradata tables.
• Used Informatica Analysts for referring Reference tables, Glossaries, Profiles etc.
• Used the IDQ mapplets in Power Center mappings by importing from IDQ to Power Center.
• Created the schedules in Informatica Power Center/Tidal.
• Executed and monitored the workflows in Informatica Workflow Manager/ Tidal scheduling tool.
• Created the parameter files, Mapping Variables and Parameters.
• Followed the standards and best practices for developing the components.
• Extensively used the transformations like Expression, Lookup, Filter, Update Strategy, Router, Read, Write, Input, Labeler, Address validation, Standardizer etc.
• Extensively written the SQL scripts for DML and DDL operations and send to DBA.
• Used left outer joins, SCD types, Teradata utilities (Fast Export, Fast Load, Multi load), TPT Connections for fetching and loading the data from/to Enterprise data ware house.
• Used the Shell/BTEQ scripts for pre and post command activities.
• Used the debugger for trouble shooting.
• Used TPT, Push down Optimization, Partitions etc for performance tuning of ETL bottlenecks.
• Performed Code review, Unit testing, Peer testing support.
• Resolved the peer testing, integration testing, and production issues.
• Performed the Data analysis and Data validations.
• Raised and tracked the Change requests in service now.