PROFESSIONAL SUMMARY:

• Over 7+ of professional experience in IT industry including 6+ years of expertise in Design, Development and Implementation of Data Warehousing applications using Informatica. And have developed end-to-end J2EE applications as well.
• Experience in all aspects of SDLC, including analysis, design, Implementation, testing, build and deployment, configuration, and production support.
• Experienced in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center 7.1.2/8.6.
• Performed all phases of development including Extraction, Transformation, Loading (ETL) data from Heterogeneous sources into Data Warehouses and Data Marts using Power Center (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Specialized in Insurance and Telecom domains.
• Experience in OLTP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in performance tuning of targets, sources, mappings, sessions & systems. Designed and developed both simple and complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union transformation and more.
• Experience in reporting tool like Microstartegy.
• Good understanding of relational database like oracle, and SQL server.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Solid hands-on experience in developing end-to-end J2EE applications.
• Experience in writing UNIX shell scripts.
• Extensive experience in all phases of Software Development Life cycle
• Extensive experience in database programming

Technical Skills:

Data warehousing Tools Informatica Power Center 7.1.2/8.6 Database Oracle 10g/9i,MS Access Languages Java, Oracle PL / SQL Reporting Micro Strategy Operating Systems Windows, Linux, Unix J2EE Technologies Servlets, JSP, EJB, JDBC, JMS Web Technologies JavaScript, HTML, XML, Application/Web Servers Web logic 8.x, Tomcat 5.x IDEs Eclipse Version Controls CVS

PROFESSIONAL EXPERIENCE:
Client: Confidential, Tampa FL, Jan 11 to Till Date
Description: financial service provider. The services provided for different vendors and the clients needs to be tracked and the data needs to be transformed based on the demands of the vendor and the clients.
Role: Informatica Developer
Responsibilities:

• Identification of various Data Sources and Development Environment.
• Prepared user requirement documentation for mapping and additional functionality.
• Extensively used ETL to load data using PowerCenter from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Created and used reusable Mapplets and transformations using Informatica PowerCenter.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Created sessions, tasks and workflows using workflow manager.
• Designed and developed complex mappings.
• Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) process.
• Used transformations like Lookup, Aggregator, Sequence Generator, Update strategy, Expression and Joiner to develop complex mappings.
• Documented the complete Mappings.
• Administer the Repository by creating Folders and logins for Group Members.
• Have migrated mappings from development to testing and from testing to production.

Environment: Informatica Power Center 8.6, Oracle 10g, PL/SQL, Toad.

Client: Confidential, Deerfield, IL. May 09 to Dec 10
Description: Confidential, doing business, as Walgreens is the largest drug store chain in the USA.Walgreens provides access to consumer goods and services and pharmacy, health and wellness services in America through its retail drugstores, Walgreens Health Services division and Walgreens Health and Wellness division. This primary object of this project is to develop a ETL process that supports the Walgreens prescription medicines insurance claims. And the Final data is sent to the Walgreens health department where the individual claims are processed. The other dimension of this project is called the item load. Items/Products are important for the Point of Sale system. The items were maintained at the AS400 system and were sent to POS system as flat files. These items were extracted, transformed and loaded into the POS system so that any sale can be performed. These fixed length format records were extracted based on their offset and each attribute would be transformed based in the master tables. Finally these records were inserted into Data warehouse tables.
Role: Informatica Developer
Responsibilities:

• Worked on Informatica PowerCenter tools-Source analyzer, Warehouse Designer, Mapping Designer and Transformation developer.
• Responsible for extracting and loading item records into Oracle.
• Responsible for attending meeting with the AS400 team to understand the item layout.
• Meet with stakeholders to gather requirements and transform them into technical documents.
• Responsible for coding and testing the item load.
• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Have developed complex mappings.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Used informatica repository manager to create repositories and give permissions to users.
• Have done informatica performance tuning and query tuning.
• Performed unit testing and integration testing.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Weekly, Monthly and Yearly Loading of Data.
• Worked on performance tuning of the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse.
• Developed complex mappings and SCD type-I, Type-II and Type III mappings inInformaticato load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations.
• Documented the complete Mappings.
• Used SQL tools to run the SQL queries.

Environment: Informatica Power Center 8.6, Oracle 10g, PL/SQL, Toad.

Company: Confidential, Mar 06 to Dec 08
Client: Verizon US
Description: Confidential, is a global broadband and telecommunications Company and a component of Dow Jones industrial average. Working on the CCR'S based on the client's requirements. The Customers will come up with the change request based on the current market requirement. The necessary changes has to be made in the DWH tables which may include adding a column or row or even deleting the column or row, or even a procedure level change or a query change or even writing a new procedure based on the requirement. We need to work on new customer's change request, which involves creating of the dataware house transformations, writing procedures, creating DWH tables committing and running the transformations from end to end. Oracle 10 g and Unix where the environments involved.
Role: Informatica Developer
Responsibilities:

• Responsible for creating a new CCR based on the customer request.
• Worked on bug fixes on the existing informatica mapping to produce the correct output
• Develop ETL programs (mappings, sessions, workflows) via Informatica.
• Responsible for creating the BRD'S. (Business Requirement Document)
• Extracted, transformed data from various sources such as Flat files, Oracle and transferred data to the target data warehouse Oracle.
• Created complex mapplets for reusable purposes.
• Responsible for releasing the updated and enhanced CCR'S in the production environment.
• Has performed all levels of testing.

Environment: Informatica 7.1, Micro Strategy, Oracle 10g, Unix.

Project # 2
Description: The licensing cost for the Microstartegy reporting tool was very high so the clients came up with the idea of building the same tool in java, so the project of MSTR replacement came into life. This is a java based development project with oracle as the backend. An extremely challenging project that involved lot of development activity. The reports that were generated using the MSTR tool is now generated with this java based application that involved all the latest J2EE technologies. And hence reduced the licensing cost of owning the tool.
Role: Developer
Responsibilities:

• Responsible for attending the client meetings as it was a new development project.
• Responsible for creating BRD'S.
• Responsible for Design, coding and testing.
• Responsible for preparing the test cases and perform testing in all the environments starting from the system to the UAT environment.
• Was involved in all the phases of the project like coding, bug tracking, testing and production support.
• Worked as a lead developer for the project and was also the single point of contact for the clients.
• Used JDBC-API to communicate with the database.
• Involved in code optimization
• Involved in design, development and configuration of server side J2EE components.
• Have developed components in java that enable crating the reports in Excel format.

Environment: JAVA, JSP, HTML, JavaScript, Oracle 10g, Web logic 8.1.0, Unix

Company: Confidential, Mumbai, India. Mar 04 to Feb 06

Project # 1 Description: This module was developed for the Help Desk team of SBI Life. Important Features Included Policy Tracking, Complaint Tracking, Task Reporting, and MIS generation. Role: Java Developer

Responsibilities:

• Analysis, coding, Execution and testing.
• Responsible for creating specification documents.
• Responsible for coordinating between different teams.
• Was involved in all the phases of the project like coding, bug tracking, testing and production support.
• Train new joiners and conduct knowledge transfer sessions for them.
• Developed the business components in core java for calculation module.
• Have develop the user interface page with JSP.
• Performed source and version control using CVS.

Environment: JAVA, JSP, Oracle 9i, Web logic 8.1, Macromedia Dreamweaver-8.

Project# 2
Description: This module is developed for the Help Desk team of SBI Life Insurance Co. Ltd. Some important features include; Policy Tracking, Complaint Tracker, Task Reporting, and MIS generation. This module is an in-house Module that is available for access only to the employees.
Role: Developer
Responsibilities:

• Responsible for attending the client meetings.
• Responsible for Design, coding and testing.
• Responsible for preparing the test cases and perform testing in all the environments starting from the system to the UAT environment.
• Responsible for giving training to others teams with regards to the application.
• Was responsible for developing the user interface screen.
• Developed the business components in core java used in the jsp page.
• Performed unit and integration testing.

Environment: JAVA, JSP, Oracle 9i, Apache Tomcat 5.5, Macromedia Dream weaver -8

Project # 3
Description: This application provides the ability to track project details and maintain resource relationships, allows tracking of resource details including time entry.

Role: Developer

Responsibilities:

• Responsible for creating the design document.
• Responsible for Design, coding and testing.
• Developed web pages using HTML, JSP and servlets.
• Client side validations are handled in jsp pages.
• Responsible for preparing the test cases and perform testing in all the environments starting from the system to the UAT.
• Was involved in all the phases of the project like coding, bug tracking, testing and production support.
• Involved in code reviews.

Environment:JAVA, JSP, Oracle 9i, Apache Tomcat, Macromedia Dreamweaver-8.

Education

• Bachelor of Engineering. (Instrumentation and Control)

References

Will be provide upon request.