Data Manager

Ashok 319-***-**** *****.*****@*****.***

SUMMARY:

12+ years of data warehousing experience in building and managing various data warehouses/data marts using Informatica products: MDM 9.x/IDQ 10.x/Power Center 9.x, Power Exchange, Integration Hub and Informatica Cloud.

Good exposure in overall SDLC including analysis, design, development, implementation, testing, debugging, deployment, production support and Maintenance of various applications on Data warehousing.

Strong experience in Configured Informatica Data Quality (IDQ), defined rules, built scorecards, applied metrics and grouped into various dimensions in IDQ.

Experienced in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica.

Experienced in Performance Tuning of sources, targets, mappings, transformations and sessions.

Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.

Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.

Good exposure in Informatica MDM where data Cleansing, De-duping and Address correction were performed.

Expertise in several key areas of Enterprise Data Warehousing such as Change Data Capture (CDC), Slowly Changing Dimensions (SCD), Lookup Tables and ETL data movement.

Experience in Integration of various data sources like Oracle, Teradata, SQL Server, Sybase, Flat Files, XML files, DB2 files.

Experience in Toad (Tool for Oracle Application Developers) and VSS (for version Control).

Experience in PL/SQL Programming (Stored Procedures, Functions and Triggers).

Experience in UNIX shell scripting and experience in using third party tool Tivoli for Informatica Job scheduling.

Excellent communication skills, good organizational skills, self-motivated and extremely hardworking with ability to implement business concepts quickly and efficiently.

TECHNICAL PROFILE:

Data Warehousing: Informatica Power Center 9.x/8.x/7.x,Informatica Power Exchange 9.x, Informatica Developer 9.6, Informatica Data hub, Informatica MDM, Informatica Metadata Manager.

Reporting Tools: Business Objects XI R2, 6.5/5.0/5.1/4.x (Designer, Supervisor, Reporter and WEBI), Micro strategy 7.1/6.x, Cognos.

Data Modeling Tool: Designer 2000, Erwin.

Databases: Oracle 11g/10g/9i/8i, SQL Server2012/2008/2005/2000, Teradata, DB2/UDB, Sybase, Netezza, SAP ECC.

Languages: SQL, Shell Scripting, PL/SQL, C, C++, HTML, DHTML, XML.

Operating Systems: UNIX (Sun-Solaris, HP-UX), IBM AIX, Windows XP

Database Utilities: MLOAD, TPUMP, FAST LOAD, Toad 11.x, VSS.

Testing Tools: Mercury Test Director 8.0, Quality Center, Clear Quest

Scheduling Tools: Tivoli, AutoSys, Tidal

PROFESSIONAL EXPERIENCE:

DTCC, Irving, TX Dec’13 to Current

Sr.Informatica Data Quality Consultant

Depository Trust Clearance Corporation is a financial company to reduce costs and provide clearing and settlement efficiencies by immobilizing securities and making book-entry changes to ownership of the securities. DTC provides securities movements for NSCC's net settlements, and settlement for institutional trades which typically involve money and securities transfers between custodian banks and broker/dealers, as well as money market instruments.

Responsibilities:

•Developed appropriate ETL Data Quality routines and mappings using Informatica Data Quality based on the requirements and technical design specifications.

•Worked with Business Intelligence leadership team to develop and enhance Data Quality development process to meet the needs of the business and reduce risk factors.

•Participated in design sessions with ETL Data Quality developers, report developers, DBAs and Business Analysts.

•Handled multiple project assignments concurrently, serve in a production support rotation, and deliver on commitments.

•Created Physical data objects and did profiling on the data and provided the results.

•Worked on Mapplet rules, Mapplets as per business requirements and used in multiple mappings in Informatica Developer.

•Created and managed Reference tables which needed for the Projects.

•Created Applications, Topics, Publications and Subscriptions using Informatica Data Hub.

•Developed mappings and workflows in Power center and incorporated with Data Hub to execute the Publications and Subscriptions.

•Developed complex mappings in Informatica Developer to provide the data reports from various sources using various transformations like SAP BAPI/RFC, SAP IDOCs transformations, Source Qualifier, Look up, Expression, Aggregate, Association, Standardizer, Joiner, Filter and Router etc.

•Created Workflows and deployed using Application and executed from pmcmd/infacmd command line through UNIX server.

•Created Profiles using Informatica Analyst/developer tool to profiling the data and applied rules on profiles.

•Migrated all Developer objects including Application deployment into higher environments. QA, PROD etc.

•Created XML parameter files for all the mapping and Workflows objects.

•Coordinated and develops process automation/job scheduling, conduct code reviews, testing and defect analysis.

•Scheduled all the Workflows using Autosys tool.

Environment: Windows XP, Oracle 11g, PL/SQL, Toad 11.x, Informatica Developer 9.6, Informatica Power Exchange 9.6, Informatica Data Integration Hub 9.6.0, Informatica MDM, Informatica Metadata Manager, SAP ECC, Sybase, SharePoint, UNIX and Autosys.

Bank of America, Dallas, TX Jan’13 to Dec’13

Sr. Informatica Data Quality Consultant

Bank of America is a financial institution, serving individual consumers, small and middle market businesses, corporations and Governments with a range of banking, investing, asset management and other financial and risk management products and services. The objective of the project was to build data Warehouse for Customers Investment Deposit, funding accounts and Corporate Services. The data for Customers, Accounts and Transactional related information were extracted from multiple sources, transformed and loaded into the target database using ETL tool.

Responsibilities:

Good experience in creating Technical requirement documents and Gap Analysis documents.

Experience in Leading the projects and delivering with high efficiency.

Prepared user requirement documentation for mapping and additional functionality.

Extensively Used ETL to load data using Power Center / Power Exchange from source systems like Mainframes into staging tables and load the data into the target database Oracle/DB2.

Created data maps (Records and Tables) of Mainframe data files using Power Exchange.

Used Power Exchange to read/write from/to Tapes, db2unload and VSAM files.

Used Informatica Designer to create mappings using different transformations to move data to the ODS.

Developed mappings in Informatica to load the data from various sources into the Data

Warehouse, using different transformations like Source Qualifier, Expression, Lookup,

Aggregator, Update Strategy, Joiner, Normalizer, Router, Stored Procedure, Union.

Worked on Error handling and Performance Tuning of the mappings.

Optimized the performance of the mappings by various tests on sources, targets and

various transformations.

Extensive knowledge in writing Bash scripts to perform various tasks related to files.

Provided key Information about source data to drive data cleansing with IDQ(Informatica

Data Quality).

Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and sequence buffer length.

Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.

Worked partially on finding out the Data Lineages using Metadata manager and

Implemented changed data capture (CDC) technique to maintain the incremental loads.

Developed PL/SQL Procedures, Functions and Packages and used EXPLAIN PLAN to tune the SQL queries.

Environment: Windows XP, Oracle 11g, PL/SQL, Toad 11.x, Informatica Power Center 9.x, Informatica Developer 9.x,Informatica Power Exchange, Teradata, SQL Server, SharePoint, UNIX and Autosys.

Verizon, Irving, TX Jan’12 to Dec’12

Sr. Informatica Consultant

Verizon is the world leader in delivering innovation in communications, mobility, information and entertainment, Verizon provides superior broadband, video and other wireless and wire line services to consumers, businesses, governments and wholesale customers across the globe. The Provisioning domain was explicitly responsible for pending, completed and cancelled orders apart from the responsibility to produce and file periodic performance reports with state and federal regulatory agencies. The reports demonstrate Verizon’s level of service to its wholesale customers and the level of service parity with the retail market or Verizon’s affiliates.

Responsibilities:

Responsible for eliciting requirements, designing dimensional data models and preparing written design documents.

Interfaced with Business Analysts for gathering the business requirements and designed user-friendly templates to communicate any further enhancements needed.

Responsible for creating ETL detailed design docs and also high level process overview documentation.

Lead the team in development of design standards and codes for effective ETL procedure development and implementation.

Developed complex mappings in Informatica to load the data from various sources using various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router

Maintaining the change management with the source code versions, scripts and documents in Verizon Shared Point.

Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.

Validated unit test results using Metadata tables like OPB tables and REP tables.

Used Tidal to schedule the workflows using shell scripts to run automatically on daily, weekly and monthly as per business needs.

Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.

Worked with ET, UV and WT Tables and did error handling and performance tuning in Teradata queries and utilities.

Environment: Windows XP, Oracle 11g, PL/SQL, Toad, Informatica Power Center 9.x,Informatica Developer9.x, Teradata, SQL Server, SharePoint, UNIX, Tidal.

BCBSM, Detroit, MI Feb’08 to Jan’12

Lead/Sr. Informatica Data Quality Consultant

Blue Cross Blue Shield of Michigan (BCBSM) has undertaken a strategic initiative to enable improved decision-making and actions that favorably impact costs, quality of care, outcomes, and satisfaction through an information-driven environment that leverages [their] data assets for competitive advantage. The development of the Data Foundation BI Business Intelligence has been divided into Subject Areas, which are logical groupings of business data. Pharmacy, Medical Claims, Customer, Member, ELV and Pharmacy Carvout is part of the initial seven subject areas to be implemented with other subject areas scheduled incrementally added over the 2007-2011 period.

Responsibilities:

Collection of data source information from all the legacy systems and existing data stores.

Created Datamaps in Informatica Power Exchange to extract the Mainframe sources across all subject areas.

Worked extensively on different types of transformations like Expression, Filter, Aggregator, Lookup, Joiner, Sequence generator and Router.

Developed complex mappings using multiple sources and targets in different databases,

Flat files and Mainframe files.

Involved in creating Tivoli workflow Job streams for each subject area and scheduled as per the business requirements.

Pushing the compressed and encrypted xml files and flat files generated to the external vendor using MFT (managed file transfer).

Comprehensively analyzed and systematically documented the end-to-end flow of the Inbound and Outbound claims file (834 HIPAA).

Implemented CDC process across all subject areas using MD5 function in Informatica.

Implemented ABC (Audit, Balance, and Control) architecture for all Informatica workflows across all subject areas.

Implemented four steps algorithm for Member matching process to load the accurate data into EDW.

Created stored procedures to generate the sequence numbers for Master data tables in landing area.

Worked on DB2 files to make sure that the files are connected with Informatica Power Exchange nodes properly.

Used IDQ tool to validate SSN, Member, and Address data in the Source systems.

Worked within a team to populate Type II slowly changing dimension customer tables from several mainframe flat files.

Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.

Environment: Windows XP, Oracle 10g, PL/SQL, Informatica Power exchange 8.6.1, Toad, Informatica Power Center 8.6.1,Informatica Data Explorer, Informatica Data Quality, Informatica B2B Data Exchange 8.6, Informatica B2B Data Transformation Studio 8.6, PVCS, SQL Server, UNIX, DB2, Tivoli, Teradata

State Street, Boston, MA Dec’06 to Feb’08

Lead/Sr. Data Warehouse Consultant

State Street is one of the largest financial companies in the world. The goal of the project is to implement ETL process to load .Enterprise data warehouse and develop integrated customer data mart, which supports Business Intelligence. Informatica tools were used to extract data from

various sources like flat files, Oracle and populated a Data Warehouse.

Environment: Windows XP, Oracle 9i, PL/SQL, SQL Server 7, Toad, Informatica Power Center 7.1.4, PVCS, UNIX.

AEGON, Cedar Rapids, IA Jan’06 – Dec’06

Informatica Developer/Admin

Environment: Informatica 7.1.3, Windows XP, TOAD, SQL, PL/SQL, Oracle 9.2, Erwin, MS-Office, VSS, Putty, Business Objects 6.5.1, Test Director

UBS Bank, New York, NY Jan’05 – Jan’06

Informatica Developer/Admin

Environment: Informatica 7.1/6.2, Business Objects 6.5.1, AUTOSYS 4, Oracle 10g/9i, SQL Server, Putty, ERWIN4.1, Test Director, Teradata, TOAD, Clear case 5.0, Unix, Windows XP.

Time Warner Cable, Charlotte, NC Feb’04 – Jan’05

Informatica Developer/Admin

Contact this candidate