SUMMARY

• Over 13 years of experience in managing the Application Software development, Maintenance and Production Support
• Over 6 years of experience in Informatica Data Quality
• Over 4 years of experience with Informatica Power Center/Power Exchange 9.x/8.x, Informatica IDQ/IDE ( Data Quality) for developing Data warehousing, Conversion, Migrations & Integration projects.
• Good Knowledge of DQ standard, Informatica MDM, Data Profiling guide lines and best practices
• Experienced with all phases of Software Development Life Cycle (SDLC) such as developing, testing, migrating, administrating, and production supporting on various platforms like UNIX, Window XP/7.
• Extensive experience with different types of tools FileMozilla, SSH client like Putty and WinSCP for UNIX platforms.
• Good experience in developing complex reports using Crystal Reports from different Data Sources.
• Excellent experience in Performance tuning in Informatica Power Center and query optimization.
• Experience in OLAP tools such as Business Objects, Crystal Reports (Designer and Reporter).
• Working experience on JIRA to monitor, track and fix bugs and defects on the workflows.
• Involved in Unit Testing, Integration testing and QA Validation.
• Working experience in Informatica Data Explorer (IDE) to provide data profiling and data quality.
• Able to work effectively at all organizational levels and have an ability to manage rapid changes.

TECHNICAL SKILLS

ETL: IDQ 9.5/9.1, Informatica Power Center 9.5/9.1/8.6/8.1/7.1/6.2 , Power Mart 6.2/5.1.2/5.0 , Power Exchange - SAP- 9.5/9.1/8.6

DATABASES: Oracle 11i/10g/9i/8i/7i, MS SQL Server 6.5/7.0.2000 , MS Access 7.0/2000

OPERATING SYSTEM: Microsoft Windows XP/2000/NT, Linux, IBM-AIX, UNIX.

Tools: FileMozilla, UltraEdit, Tibco and Tidal Scheduler

PROFESSIONAL EXPERIENCE

Delivery Lead -Data Quality

Confidential, Auburn Hills, MI

Environment: Informatica Data Quality 9.x, Tibco, Oracle 11g,, SQL server, SQL, UNIX, Windows XP.

Responsibilities:

• Worked on Profiling Report, Expression Rules, Creating and Running Scorecards on claims
• Worked with IDQ toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Identifying and acquiring new data sources.
• Creating and maintaining consistent reference data and master data definitions.
• Publishing relevant data to appropriate users in an organization, and monitoring the published data sources for usage/relevance/quality feedback.
• Creating and managing business metadata for published data sources to ensure that it is easily discoverable, and meaningful to information workers.
• Resolving data integrity issues across stakeholders.
• Analyzing data for quality and reconciling data issues.
• Created Custom Profiles, Run the Profile, Drill Down on Profile Results and generation Scorecard from the Profile Results
• Involved in Profiling, cleansing, standardization and Match/Merge
• Involved in creating IDQ Detail level design plans.
• Design and development of Informatica Data Quality plans
• Involved in uploading Dictionaries using IDQ Content installer.
• Developed reusable Mapplet called as Plans in IDQ and imported into Power center.

Data Quality Analyst /Data Steward

Confidential, Oklahoma City, OK

Environment: Informatica Data Quality 9.x, Toad 9.7, Oracle 11i,, SQL server, SQL, UNIX, Windows XP. Tidal

Responsibilities:

• Defining the data governance rules with other stewards
• Worked on Profiling Report, Expression Rules, Creating and Running Scorecards
• Worked with IDQ toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Identifying and acquiring new data sources.
• Created Custom Profiles, Run the Profile, Drill Down on Profile Results and generation Scorecard from the Profile Results
• Involved in Profiling, cleansing, standardization and Match/Merge
• Involved in creating IDQ Detail level design plans.
• Design and development of Informatica Data Quality plans
• Involved in uploading Dictionaries using IDQ Content installer.
• Developed reusable Mapplet called as Plans in IDQ and imported into Power center.
• Designed the ETL processes using Informatica tool to load data from Legacy systems into the target Oracle database.

Data Quality Analyst

Confidential, Seattle, WA

Environment: Informatica Data Quality 9.1.0, Toad 9.7, Oracle 11i,, SQL server, SQL, UNIX, Windows XP.

Responsibilities:

• Worked on Profiling Report, Expression Rules, Creating and Running Scorecards
• Worked with IDQ toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Created Custom Profiles, Run the Profile, Drill Down on Profile Results and generation Scorecard from the Profile Results
• Involved in Profiling, cleansing, standardization and Match/Merge
• Involved in creating IDQ Detail level design plans.
• Involved in uploading Dictionaries using IDQ Content installer.
• Developed reusable Mapplet called as Plans in IDQ and imported into Power center.
• Designed the ETL processes using Informatica tool to load data from Legacy systems into the target Oracle database.
• Developed mappings in Informatica Powercenter to load the data from various sources.
• Used Informatica power exchange to change data capture option to capture the updates to the existing data.
• Incorporated IDQ plans into Informatica Power center using the integration plug in.

Data Analyst

Confidential, Washington DC

Environment: Informatica Data Quality 9.1.0, Powercenter 9.1, Toad 9.7, Oracle 11i, SQL server, SQL, UNIX, Windows XP.

Responsibilities:

• Worked on Profiling Report, Expression Rules, Creating and Running Scorecards
• Worked with IDQ toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Involved in creating IDQ Detail level design plans.
• Involved in uploading Dictionaries using IDQ Content installer.
• Developed reusable Mapplet called as Plans in IDQ and imported into Power center.
• Designed the ETL processes using Informatica tool to load data from Legacy systems into the target Oracle database.
• Developed mappings in Informatica to load the data from various sources.
• Used Informatica power exchange to change data capture option to capture the updates to the existing data.
• Incorporated IDQ plans into Informatica Power center using the integration plug in.
• Functional Lead responsible for identifying and documenting system interfaces, data sources and data objects with existing legacy application.
• Worked on LLD and HLD to document the requirements, logic, analysis involved in the project.
• Worked on JIRA to track and fix bugs in the code by analyzing the logs in Informatica.
• Created Test plans for Unit testing, User Acceptance testing.

ETL Developer(Informatica)

Confidential, Columbus, Indiana

Environment: Oracle 10g, Informatica Power Center 8.6, TOAD, UNIX, WinSCP, Putty.

Responsibilities:

• Liaise with business analysts for need Analysis and to define Business and Functional Specifications.
• Worked with heterogeneous sources from various channels like Sybase, Oracle, Flat files.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Created/Modified Informatica ETL mappings in various stages folders like Staging area and production area for development and production environment that transfers data from Sybase, Oracle Source systems to Oracle Target system.
• Designing tables, primary and foreign keys to enforce referential integrity, design views, writing stored procedures, packages and functions.
• Involved in Design & coding of Database Triggers to enforce some complex Business Rules which could not be enforced by Integrity Rules
• Designed the ETL processes using Informatica to load data from Sybase, Oracle, Flat Files, XML Files and Excel files to target Oracle Data Warehouse.
• Loading the OLTP data into the Warehouse OLAP and built the Re-usable Mappingsusing Informatica Power Center.
• Trouble shooting and problem solving applications with Informatica.

ETL Developer(Informatica/Oracle)

Confidential, New York

Environment: Informatica PowerCenter 8.1/7.1, Oracle 10g, UNIX

Responsibilities:

• Worked on complete SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Worked with PowerCenter client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Designed and developed standard re-usable mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Used ETL to extract and load data from Finance tables and flat files to Oracle.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformation like Filter, Router, Expression, and Sequence Generator.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Created Relational Connections, migrated the Mappings from Development to Testing and Testing to Production.