Summary

• Undergone professional training in Oracle 9i form.
• Having 8 yrs. of experience in IT industry.
• 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 around 8 years of experience in Information Technology and Services industry.
• Worked Extensively on Informatica Power Center tool.
• Worked on Java, JSP, HTML, Informatica 8.6.1, PL/SQL programming, SQL, Querying Stored procedures and D2K.
• 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 Modeling experience on Data modeling, ERwin 4.5/4.0/3.5.5/3.5.2, Dimensional Modeling, Ralph Kimball Approach, Star Modeling, 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 Center.

Technical Skills Set

• Languages : Java,PL/SQL,SQL, Shell Scripts
• App/Web Servers : Tomcat
• Databases : Oracle 9i,Oracle 10g
• Web Technologies : Java Script, HTML, XML
• Tools : Informatica Power Center 8.1.18.6.0 and 9.0.1, FCI Reporting tool ,
• Actuate 8, BIRT and TOAD
• Operating Systems : UNIX, Linux, Windows

Professional Experience

Confidential -- Tech Lead

The objectives of FSI are to:

• Reduce operational risk through process change, improved data quality and Automation.
• Improve reporting and analysis capabilities, reliability and timeliness.
• Improve the quality, accuracy, and consistency of all data coming into business by providing a unified
• capability for acquisition of data and proactive management of upstream SLA.
• Reducing the time and cost of data cleansing activities by doing it once as the data model created and
• complex data sourcing logic in multiple application.

Responsibilities:

• Dimensional Data Modeling experience on Data modeling, Conceptual, Physical Logical data modeling.
• Doing Changes in LLD Low Level Design PDM Physical Data Model and new CR.
• Requirement Analysis through business model and functional model.
• Developed Informatica 9.0.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 client calls for Project discussion.
• Actively involved in Defect solving in SIT and UAT testing phase

Environment : 2 Tier Architecture.

• Tools Used : Informatica Power Center 9.0.1,SQL Developer, Shell Scripts.
• Database : Oracle 10g

Confidential Support lead

The objectives of FSI are to:

• Reduce operational risk through process change, improved data quality and Automation.
• Improve reporting and analysis capabilities, reliability and timeliness.
• Improve the quality, accuracy, and consistency of all data coming into Manufacture by providing a unified capability for acquisition of data and proactive management of upstream SLA.
• Reducing the time and cost of data cleansing activities by doing it once as the data model created and complex data sourcing logic in multiple applications.

Responsibilities:

• Developed Informatica 8.1.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.
• Alter the store procedures and packages.
• Effectively involved in test data preparation and code review.
• Attending Daily client calls for Project discussion.
• Actively involved in Defect solving in SIT and UAT testing phase.
• Attending Daily client calls for Project discussion.
• Monitoring the Dashboard DAC

Environment : 3 Tier Architecture.

• Tools Used : Informatica Power Center 8.6.1, OBIEE reporting Tool , SQL Developer,
• Shell Scripts.
• Database : Oracle 10g

Confidential Technical lead

The objectives of FSI are to:

• Reduce operational risk through process change, improved data quality and Automation.
• Improve reporting and analysis capabilities, reliability and timeliness.
• Improve the quality, accuracy, and consistency of all data coming into Finance by providing a unified capability for acquisition of data and proactive management of upstream SLA.
• Reducing the time and cost of data cleansing activities by doing it once as the data model created and complex data sourcing logic in multiple application.

Responsibilities:

• Dimensional Data Modeling experience on Data modeling, Conceptual, Physical Logical data modeling.
• Prepare the HDL High level Design and LLD Low Level Design
• Create PDM Physical Data Model .
• Requirement Analysis through business model and functional model.
• Done the Data Profiling in informatica Power Center 9.0.1.
• Developed a Metadata as per the data model for Project work.
• Developed Informatica 8.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 oracle functions and 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 client calls for Project discussion.
• Actively involved in Defect solving in SIT and UAT testing phase

Environment : 2 Tier Architecture.

• Tools Used : Informatica Power Center 8.6.1, BIRT,FCI,Jasper reporting Tool , SQL Developer,
• Shell Scripts. Java,JavaScript
• Database : Oracle 10g

Confidential Senior Software Engineer

The objectives of FSI are to:

• Reduce operational risk through process change, improved data quality and Automation.
• Improve reporting and analysis capabilities, reliability and timeliness.
• Improve the quality, accuracy, and consistency of all data coming into Finance by providing a unified capability for acquisition of data and proactive management of upstream SLA.
• Reducing the time and cost of data cleansing activities by doing it once as the data enters the gateway and Eliminating redundant and complex data sourcing logic in multiple application.

Responsibilities:

• Requirement Analysis through business model and functional model.
• Developed a Metadata as per the data model for Project work.
• Developed Informatica 8.6 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.
• Improved Performance by selecting all Dimension LKP cache as persistent and reused those caches for Fact loads.
• Effectively involved in test data preparation and code review.
• Attending weekly client calls and Video conference for Project discussion.
• Actively involved in Defect solving in SIT and UAT testing phase.

Environment : 2 Tier Architecture.

• Tools Used : Informatica Power Center 8.6.1, SQL Developer, and Shell Scripts.
• Database : Oracle 10g

Confidential Senior Software Engineer

Responsibilities:

• Working as a developer for the entire modules.
• Responsible for timely development and release of modules in phases.
• Involved in Problem Solving and maintaining a constant interaction with the Onsite and Configuration team for speedy closure of development related issues.
• Requirement Analysis through business model and functional model.
• Developed a Metadata as per the data model for Project work.
• Developed Informatica 8.6 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 oracle functions and 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 weekly client calls for Project discussion.
• Actively involved in Defect solving in SIT and UAT testing phase

Environment : 2 Tier Architecture.

• Tools Used : Informatica Power Center 8.6.1, FCI, BIRT, Jasper reporting tool SQL Developer.
• Database : Oracle 10g and DB2

Confidential Senior Software Engineer

Responsibilities:

• Working as a developer for the entire two modules.
• Responsible for creating the Triggers, Functions, Store procedure and packages.
• Responsible for timely development and release of modules in phases.
• Monitoring Patch releases to QC and Onsite team.
• Involved in Problem Solving and maintaining a constant interaction with the Onsite and
• Configuration team for speedy closure of development related issues.

Environment : 3 Tier Architecture.

• Tools Used : Informatica Power Center 8.6.1, PL/SQL, Oracle 9i Forms D2k and Toad.
• Database : Oracle 9i

Confidential Software Engineer

Responsibilities:

As a Team member, I am primarily responsible for customizing various packages,Procedures for NMIC Project for the Underwriting modules and Controlling PL/SQL part as writing packages, procedures, Cursors, and writing SQL queries. Providing support to handle and resolve UAT calls and issues for NMIC Project.

Environment : 3 Tier Architecture.

• Tools Used : Informatica Power Center 8.6.1, PL/SQL, Oracle 9i Forms D2k and Toad.
• Database : Oracle 9i

Confidential Software Engineer

Responsibilities:

• Working as a developer for the entire modules. Underwriting There develop the procedure ,function , Trigger ,Cursor , Packages and Forms, Dynamic SQL Queries, Views.
• Involved in Problem Solving and maintaining a constant interaction with the Onsite and Configuration team for speedy closure of development related issues.
• Participate Unit Testing before passing it to the Testing team for System Testing.

Environment : 3 Tier Architecture.

• Tools Used : D2k, PL/SQL,SQL Server also Oracle 9i, TOAD, Oracle 9i ,Form Builder ,Java, Jsp,
• Servlet, Xml, Html, Hibernate, Spring, Mule.
• Database : Oracle 9i