SUMMARY:

• Highly accomplished and specialized in Informatica, Oracle and Sql Server.
• Highly experienced in Data analysis, extraction and integration of data from various systems.
• Strong experience in Onsite/Offshore development model.

TECHNICAL SKILLS:

Concepts & Specialties: OOAD, Data Structures, Testing concepts, Big Data, SDLC, Data warehousing

Languages: C, C++, Java, Cobol, VB

Software Tools: Informatica Powercenter 9.1, Microsoft VSS, Rational ClearCase, Redwood Scheduler, Rational ClearQuest, Quest Toad, WinSCP, HP Loadrunner, OBIEE, JIRA, Confluence, Zephyre, SSIS, Pentaho,ER - Assistant

Operating Systems: Windows NT/2000/XP based PCs, Sun Solaris 10, Red Hat Linux

Databases: Domain Oracle 11g, MS Access

SQL Server: Automotive Incentive System, Accounting

PROFESSIONAL EXPERIENCE:

Confidential

Technology Analyst

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Worked on dimensional modeling to design and develop STAR schemas by identifying the facts and dimensions.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files, XML files and Oracle (source) and loaded into Oracle (target).
• Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
• Created reusable Mapplets transformations to load data from operational data source to Data Warehouse
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Developed complex mappings such as Slowly Changing Dimensions Type 2, Type 3, type 1 - Time Stamping in the Mapping Designer.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
• Monitored the workflow performance and the status with Workflow Monitor.
• Developed various command tasks to automate the Pre session jobs. Did performance tuning to improve the load. Wrote complex SQL Queries involving multiple tables with joins.
• Involved in writing of Triggers, Functions.
• Used Variables and Parameters in the mappings to pass the values between sessions.
• Scheduled Informatica jobs using Informatica and Redwood Scheduler.
• Determined various bottle necks and successfully eliminated them to great extent.
• Performed Unit Testing and Involved in tuning the Session and Workflows for better Performance.
• Debugged and sorted out the errors and problems encountered in the production environment.
• Generated Adhoc reports using Business objects.
• Developed OBIEE Scheduled using data models and on Demand reports Using Business objects.
• Created layout of OBIEE templates for Scheduled reports
• Created & tested reports using Business Objects functionality like Queries
• Documented the entire process. The documents included the mapping document, unit testing document and system testing document among others.

Confidential

Senior Software Engineer

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.

• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files Oracle (source) and loaded into Oracle (target).
• Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Developed complex mappings such as Slowly Changing Dimensions Type 2, Type 3, type 1 - Time Stamping in the Mapping Designer.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
• Monitored the workflow performance and the status with Workflow Monitor.
• Developed various command tasks to automate the Pre session jobs. Did performance tuning to improve the load. Wrote complex SQL Queries involving multiple tables with joins.
• Used Variables and Parameters in the mappings to pass the values between sessions.
• Scheduled Informatica jobs using Redwood Scheduler.
• Determined various bottle necks and successfully eliminated them to great extent.
• Documented the entire process. The documents included the mapping document, unit testing document and system testing document among others.

Confidential

Senior Software Engineer

Responsibilities:

• Respond to the issues assigned, do analysis, participate in estimating the effort needed to implement the solution and communicate to all the stake holders and close the issue as per the agreed timelines

• Develop and review Artifacts (Code, Documentation, Unit test scripts) conduct reviews for self and peers, conduct unit test and document unit test results for ETL jobs in order to deploy the jobs for Validation/Delivery.
• Do impact analysis, participate in high level design and create design specifications as per the high level design.
• Participate in handling customers as onsite coordinator in order to provide right level of information to Customer and also coordinate with offshore team to assign work on a day to day basis.
• Writing query to generate Adhoc reports to support business for critical decision making.
• Engaging multiple teams to make sure that end to end testing happening without any impact to any other interface while moving any fix or enhancement.
• Helping Auditors for SOX audit for incentive systems from IT perspective.
• Follow the Predefined process to avoid any SOX violation.
• Providing workaround around for critical and complex issue to make business run smoothly.
• Providing the user on the inquiry related to incentive system.
• Understanding user’s pain points and providing them solution for the same.

Confidential

Software Engineer

Responsibilities:

• Respond to the issues assigned, do analysis, participate in estimating the effort needed to implement the solution and communicate to all the stake holders and close the issue as per the agreed timelines

• Develop and review Artifacts (Code, Documentation, Unit test scripts) conduct reviews for self and peers, conduct unit test and document unit test results for ETL jobs in order to deploy the jobs for Validation/Delivery.
• Do impact analysis, participate in high level design and create design specifications as per the high level design.
• Participate in handling customers as onsite coordinator in order to provide right level of information to Customer and also coordinate with offshore team to assign work on a day to day basis.