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 9+ 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.
• Undergone professional training in Data Warehouse Concept and Actuate 8 and Birt (Java reporting tool) in Triumph System and Solution Pvt Ltd.
• 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

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, Actuate 8, BIRT, SQL Developer, PL/SQL Developer and TOAD

Operating Systems: UNIX, Linux, Windows

Scheduling tool: Autosys

PROFESSIONAL EXPERIENCE

Confidential

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.

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

Database: Oracle 10g and SQL Server

Confidential, Atlanta GA

Sr. Programmer 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

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:

• Implement an enterprise solution that is aligned to future state enterprise data architecture, to house security master data required to support all business data within Confidential ..
• Implement a service oriented vending mechanisms that will provide security master data required to support various business processes within Confidential .
• Consolidate various sources for security master data in to a single version of truth using Master Data Management principles.
• Consolidate different data stores across Confidential that stores Security Master Data. The goal is to have enough data to support to retirement of the legacy systems over time.
• 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.
• Created Run Books and Release notes for the migration of the Code and performed Migration through Clear Case Tool.
• Effectively involved in test data preparation and code review.
• Attending Daily defect calls for Project discussion.

Tools: Used: Informatica Power Center 9.5.1,MDM,IDQ,Toad, FTP,SFTP Shell Scripts, Text Editor.

Database: Oracle 11g