SUMMARY:

• Masters degree in Computer Science with over eighteen years of experience as an application software architect/developer.
• Take pleasure in working in a team environment and play a key role by sharing technical knowledge and taking responsibilities to deliver quality work on time.
• Worked as a Team Lead, Sr. ETL Architect/Developer/Admin, IDQ, MDM, Data warehouse Developer for over 12 years.
• Proficient in ETL design and development using Informatica 9.5 products: Powercenter, Informatica Data Quality IDQ , PowerExchange and Master Data Management MDM
• Proficient in data extraction and transformation, data modeling, logical/physical database design star schema and Relational , PL SQL and Stored procedures development and data conversion/migration. Exception report generation/analysis and re cycling of data.
• Developed more than 300 mappings for both Initial full load and Change Data Capture CDC for various data sources including Relational, flat files, Mainframe and XML.
• Experienced in installation and administration of Informatica 9.5/8.6.1 Repository Service on Linux, AIX and Windows platforms with multiple node Grid architecture in both development and production environments.
• Have developed strong business/functional knowledge in Federal Govt. EPA, DHS, Dept of Edu, HUD , Mortgage, Finance, Utility, Ins., Telecommunication and Banking industries.
• Experienced in creating client deliverables like Software Design Document SDD , Data warehouse Architecture Plan document, programming standards document, Best practices document and training.

SKILLS:

• Informatica PowerCenter 9.5/8.6/7.3 , Powerexchange, Data Quality IDQ 8.6 , Master Data Management MDM , SAP BW.
• Oracle 11g PL/SQL, Stored Procedures/Triggers , DB2 UDB 8/7, Sybase.
• RapidSQL, TOAD, SQL Navigator, ERwin, ERStudio, SAS, PowerBuilder, PL/SQL.
• Business Objects, Cognos-ReportNet, Crystal Report.
• Sun Solaris, Unix HP Shell Script , Windows NT 4.0, AIX, Windows.
• Rational Rose UML , TogetherSoft, RequisitePro.

WORK EXPERIENCE:

Confidential

Informatica ETL Consultant

Project Description: Hilton Worldwide Enterprise Data Warehouse EDW initiative is to improve overall Data Quality and Productivity of existing processes to deploy reliable and accurate information. As a member of the data warehouse architecture team I was responsible to implement the next generation enterprise data warehouse and to create the Business Intelligence reference architecture. Extensively used Informatica Data Quality tool IDQ to establish Data Profiling and Data Governance Practice. Developed Data Quality standards and ETL mapping rule templates.

Accomplishments: Used IDQ toolkit Informatica Analyst and Informatica Developer to perform extensive Data profiling on data related to Reservation, Properties, Budget and Forecast. Generated Data profiling results and scorecards to help Business users to analyze data issues efficiently. Developed ETL mappings which replaced existing stored procedures and views used to populate a set of tables. Was part of team responsible for MDM tool set evaluation.

Environment: Informatica 9.5, Oracle 11g, Informatica Data Quality IDQ 8.6.1 , PL SQL

Confidential

Informatica ETL Architect / Developer

Project Description: MassDOT is modernizing its Mainframe based application by moving to Oracle and web based application. Immediate goal of this project is to:

• Perform data profiling on address data using IDQ.
• Analyze profiling results, prepare business rules
• Develop a data model to fix the data.
• Use MDM tool to analyze data and identify Golden record.
• Interact with Salesforce tool to transfer data.

Accomplishments: Used IDQ toolkit Informatica Analyst and Informatica Developer to perform extensive Data profiling on address data coming from various sources including Driver License, registration, Insurance company, traffic violation cases. These data have no referential integrity and also don't follow strict data type rules.

Responsible for the following activities on daily basis:

• Installed Address doctor and USPS reference data.
• Performed profiling using Address Validator on Data from US, non-US, MA etc..
• Develop profiling rules and implement them by coding mappings and mapplets.
• Performed comparison between IDQ profiling results and SAS DataFlux tool profiling results.
• Worked on prototype to show the client capabilities of MDM tool by consolidating data from three sources.

Environment: Informatica 9.5, Oracle 11g, Data Quality 8.6.1 IDQ , MDM Hub console, PowerExchange, PL SQL, SQLDeveloper, Unix.

Confidential

Lead Informatica ETL Architect / Developer/Admin - Lead Data warehouse Developer

Project Description: EPA started a major initiative in 2010 to replace several systems with a web based, single sign on application -- Superfund Enterprise Management System SEMS . It was using three primary application systems, the Comprehensive Environmental Response and Compensation Liability System CERCLIS , the Superfund Document Management System SDMS , and the Institutional Controls Tracking System ICTS . Besides these 3 systems, there are approximately forty other IT systems to manage Superfund activities nationwide.

Accomplishments: Successfully completed Data migration / Data conversion effort by leading the whole ETL effort including installation of Informatica products, Setting up ETL environment/ Coding guidelines, Data Analysis/Profiling, ETL development, QA test process, ETL code deployment process and deliverables SDD, VDD, Architecture plan . Coordinated three major production releases including the final release in Dec 2013. I have developed around 130 ETL mappings and 35 Oracle Stored procedures. The main goal of this effort was to migrate trusted data by performing data conversion and improve data quality addressed duplicates, orphan/ invalid data, standardize, NULL values etc.. with the help of new mapping rules and constraints on target tables to restrict bad data coming into the database thru' new application. Currently, working on enhancements and maintenance of ETL code and providing ETL development training.

Responsible for the following activities on daily basis:

INFORMATICA ETL DEVELOPMENT

• Work with Data Architect to discuss and analyze the Data model, data migration/conversion requirements, ETL mapping rules.
• Design, develop and Unit test Informatica Extract, Transform and Load ETL objects to perform Data migration for Full Load and/or Incremental Load CDC .
• Design and implement error handling procedures. Made use of Informatica generated error handling system tables to analyze exceptions.
• Design and develop reusable transformations and mapplet.
• Generate Exception report on migrated data and discuss the results with Data Architect.
• Performed data profiling using PL SQL and IDQ. Presented results to Data Architect to help in Data model development/ modification effort and also to resolve data related issues.
• Suggest Data model changes, table structure changes and make changes to ETL code based on the initial unit test.
• Modify ETL code and perform additional unit test to re cycle source data.
• Development of Oracle Stored procedures to handle complex data migration rules. Used them in ETL mappings and also to perform pre or post ETL data migration.
• Deployment of Informatica ETL objects to QA, Staging and Production environments.
• Participate in SEMS Data warehouse and Business Intelligence BI requirement analyses. Understand the existing Reports and new Reports requirement and scope for the future releases.
• Perform data analysis, business logic and exceptions using PL SQL, Data Quality IDQ and data profiler tools.
• Support production system by monitoring ETL tasks, analyze ETL performance, analyze data issues, develop emergency fixes to ETL code or prepare new Data correction script and deploy them.
• Evaluation of tools like Primavera, Oracle BI, Informatica Master Data Management MDM and BPM products.
• Attend Daily scrum meetings and weekly SEMS Technical Review meetings.
• Prepare deliverables like Software Design Document SDD on ETL Data Migration for both ODS and DW and Data warehouse Architecture Plan document, Version Deployment Document VDD for a major production releases.

INFORMATICA DATA QUALILTY IDQ DEVELOPMENT

• Used IDQ toolkit Informatica Analyst and Informatica Developer to perform extensive Data profiling during initial/mid stage of the project to develop a thorough knowledge of source data content, structure and data quality.
• Performed extensive data profiling:
• Structural analysis of the data stores each table
• Pattern analysis for given fields within each data store
• Range / threshold analysis for required fields
• Analysis of counts like: record count, sum, min, max, percentiles etc..
• Performed Data cleansing, Parsing , Correction , Standardization using Informatica Develop Transformations like: MATCH, PARSER, STANDARDIZER, DECISION , LABELLER, ADDRESS VALIDATOR etc..
• Address Validation
• Experience in using Hamming Distance, Reverse Hamming distance and Biagram scoring algorithms to identify duplicates.
• This exercise of gathering important source data information helped:
• Data modeler to develop an efficient data model with proper indexes and constraints.
• Data architect and Data Analyst to develop ETL mapping rules for each target table

INFORMATICA ADMIN

• Installation and Migration of Informatica from Version 8.6.1 to 9.5 on LINUX machine.
• Create new 9.5 Repository, Folders, Groups/Roles/Users and migrating code to new repository.
• Performed Repository Backup and Restore.
• Experienced with Grid Architecture Gateway node and worker nodes .
• Apply patches and hotfixes on Informatica PowerCenter.
• Deploy code from Development to Staging environment, assign integration services to workflows.
• Monitor logs, perform trouble shooting.

Environment: Informatica 9.5, Oracle 11g, Data Quality 8.6.1 IDQ toolkit, PowerExchange, PL SQL, SQLDeveloper, Unix, Primavera, JIRA.