SUMMARY

• Strong credentials in designing, implementing and supporting technical solutions for Product based and Service based IT services. Received multiple appreciations organization wide for delivering cost effective solutions as per business requirements and track record of on - time delivery. Dynamic and accomplished professional with 10+ years of experience in Information Technology and Services industry.
• Undergone professional training in Oracle 9i form.
• Worked Extensively on Informatica PowerCenter and IQD tool.
• Worked on Informatica, IDQ, PL/SQL programming, SQL, Querying & Stored procedures, D2K, Java, JSP, HTML and JavaScript
• Good self-learning capabilities and quick learner in new technologies and proved productive within short period of time.
• Good communication skills and excellent team player.
• Managed team of 10-15 resources.
• Dimensional Data Modelling experience on Data modelling, Erwin 4.0, Dimensional Modelling, Ralph Kimball Approach, Star Modelling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modelling
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De Normalization Concepts.
• Experience in preparing the ETL Design Documents like High Level and low-level Design documents. Involved in the Unit testing, integration testing, System testing and UAT using Quality Centre.

TECHNICAL SKILLS

Languages: Java, PL/SQL, SQL, Shell Scripts

App/Web Servers: Tomcat

Databases: Oracle 9i, Oracle 10g, Netezza

Web Technologies : Java Script, HTML, XML

Tools: Informatica PowerCenter 8.1.1,8.6.1, 9.0.1 and 9.5.1, IDQ 9.0.1, FCI (Reporting tool), Jasper, Tableau, Actuate 8, BIRT, SQL Developer, PL/SQL Developer and TOAD, Aginity

Operating Systems: UNIX, Linux, Windows

Scheduling tool: Autosys

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, California

Senior Developer

Responsibilities:

• Developed Informatica 9.6.x mappings/Workflows using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
• Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
• Using Tableau tool to generate the reports for business.
• Design the warehouse for Data Quality Rules using unix shell script.
• Create the Data Quality Rules to identify the data pattern.
• Effectively involved in test data preparation and code review.
• Daily CM (Configure Manager) calls for Product discussion.
• Actively involved in Defect solving in UAT and Production phase.
• Handing the Onshore Offshore (China and India) module.

Environment: 3 Tier Architecture.

Tools: Used: Informatica Power Center 9.6.X, Tableau 10.1

Database: Oracle

Confidential

Data Quality Developer

Responsibilities:

• Design the warehouse for Data Quality Rules.
• Create the Data Quality Rules to identify the data pattern.
• Develop the Data profiling rule in Informatica DQ tool.
• Create the score card from profile and send the report to business.
• Create the rule in Informatica Data Quality tool.
• Developed Informatica 9.6.0 mappings/Workflows using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
• Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
• Effectively involved in test data preparation and code review.

Environment: 2 Tier Architecture.

Tools: Used: Informatica Power Center 9.6.0, IDQ and Aginity.

Database: Netezza 7.0.x

Confidential, Irvine, CA

Onsite Technical Lead

Responsibilities:

• Oracle Sieble with Call Center Application.
• Interactive Voice Response (IVR) is an automated telephony system that interacts with callers, gathers information and routes calls to the appropriate recipient
• Developed Informatica 9.5.1 mappings/Workflows using various transformations like
• Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
• Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
• Effectively involved in test data preparation and code review.
• Daily client calls for Project discussion.
• Actively involved in Defect solving in UAT and Production phase.
• Handing the Onshore Offshore module.
• Scheduling the Job through DAC.

Environment: 3 Tier Architecture.

Tools: Used: Informatica Power Center 9.5.1, OBIEE (reporting Tool), SQL Developer, DAC.

Database: Oracle 10g and SQL Server

Confidential

Senior Programar Analyst

Responsibilities:

• Designed and developed Powercenter /Idq .
• Played an extensive role in business requirement gathering, requirement analysis and data rules creation in idq and Powercenter development.
• Configured relation among table to obtain LKP.
• Performance tuning mapping and database.
• Working on reference tables.
• Obtained golden records using Informatica master data management hub console.
• Loaded the landing tables with the help of etl jobs and IDQ mappings and workflows
• Created mapping applications in IDQ to lad landing data.
• Developed Informatica 9.6.1 mappings/Workflows using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects
• Create the store procedures.
• Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
• Effectively involved in test data preparation and code review.
• Attending Daily defect calls for Project discussion

Environment: 3 Tier Architecture.

Tools: Used: Informatica Power Center 9.6.1, MDM 9.6.1, IDQ, SQL developer, IDD, FTP, SFTP, Shell Scripts, Text Editor.

Database: Oracle 11g

Confidential

Sr. Programmer Analyst

Responsibilities:

• Requirement Analysis through business model and functional model.
• Developed Informatica 9.5.1 mappings/Workflows using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
• Data profiling in Analysts and developer tool and improve the steps of analyzing profiling, validation and cleansing data.
• Create rules as per business requirement (critical and warning) and use out of the box rules.
• Capability to combine data quality rules with data transformation logic and ability to conduct profiling even in midstream.
• Create mapplets as per business requirement and use as a rule.
• Create the scorecard.
• Working on reference tables.
• Create the store procedures.
• Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
• Wrote the High Level / Low level Design Documents, Application Control Documents, Interface Control Documents in DOORS.