SUMMARY

• 11+ years of Software Development Life Cycle (SDLC) experience as a Solution Architect/Lead/Developer/consultant implementing Client/Server and Data Warehouse applications for Finance, Health, Pharma and Retail Service domains.
• 6+ years of experience with ETL tool Informatica Power Center 9.x/8.x.
• 5+ years of experience as a PL/SQL developer using Oracle 11g/10g/9i/8i & Microsoft SQL Server 2000/2005.
• Expertise on all stages of Software Development Life Cycle such as Requirements Gathering, Architecture, Design, Development, Testing, Implementation and Production Support of Business Intelligence solutions.
• Strong expertise in design and development of ETL programs using InformaticaPowerCenter 9.x/8.x.
• Extract data from and Load data to flat files(fixed width and delimited) and relational tables (Oracle, SQL Server)
• Transform data with transformations like Expression, Lookup, Filter, Router, Update Strategy, Sequence Generator, Aggregator, Joiner, Sorter, Lookups, Rank, SQL transformation.
• Created Sessions tasks, Workflows and Worklets using Workflow Designer.
• Use of Mapping Parameters, Session Parameters and Workflow Variables.
• Excellent knowledge in identifying performance bottlenecks and tuning the ETL Processes.
• Well versed with the data modeling techniques like star schema, snowflake schema and Entity - relationship Modeling.
• Extensively worked on Oracle & Microsoft SQL Server skills that include build/maintain tables and indexes, PL/SQL scripts, Stored Procedures, Triggers, Packages, Functions and performance tuning of SQL queries.
• Good Knowledge in UNIX.
• Expertise in troubleshooting and analyzing test/prod issues.
• Worked on Job scheduling tools like AutoSys& Control-M.
• Well versed with Autosys send events and Job Information Language (JIL) scripts.
• Managed development, production and strategy issues for the Enterprise Data Warehouse.
• Involved in Unit Testing, System Integration Testing and Performance Testing of various Projects.
• Have lead teams and demonstrated excellence in ETL design and development under aggressive timelines.
• Ability to multi-task and work in a fast-paced environment and work in multiple projects simultaneously

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.x/8.x, IDQ 9.x

Databases: Oracle 9i/10g/11g, SQL Server 2000/2005

Data Modeling: Erwin 4.0/3.5.2, Oracle SQL Developer Data Modeler.

BI Tools: COGNOS 10.2.1 (Framework Manager, Report Studio, Query Studio, Analysis Studio), MSSQL Server 2005 Reporting Services

Scheduling Tools: Autosys, Control-M, Tivoli.

Query Tools: Toad, SQL Developer.

Languages: SQL, PL/SQL, XML, HTML, Unix Confidential script.

Operating Systems: UNIX, Windows Family, Linux.

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Developed various mappings& workflows to load Historical data from Legacy system to new DWH.
• Based on the Business logic, Developed various mappings &mapplets to load data from different sources using different transformations like Source Qualifier, Filter, Expression, Lookup, Router, Update strategy, Sorter, Union, Aggregator, Joiner in the mappings.
• Developedseveral mappings that supportSlowly Changing Dimensions(Type 2).
• Developed various workflows using Session Tasks, Email Tasks, Command Tasks, Assignment Tasks and Workflow Variables.
• Responsible for migrating the folders, mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.
• Performed data profiling to identify the issues in the target systems.
• Created bitmap indexes to improve the performance.
• Created Test cases for Unit Test, System Integration Test and UAT to check/validate the data.
• Involved in bug fixes post go-live.
• Developed Views, Stored Procedures and functions to implement the business logic.

Environment: Informatica Power Center9.6.1/9.1, Oracle11g/10g, Toad11.6, PL/SQL, COGNOS 10.1, Windows7/XP,Linux,TivoliJob Scheduler.

Confidential

ETL Designer / Developer

Responsibilities:

• Responsible for design, development and implementation of enterprise architecture.
• Review the Business Requirements, Data Requirements and Functional Requirements and providing the necessary suggestions to be made to the respective documents.
• Created Source to Target Mappings, High Level Design and Technical Design Documents.
• Delivered end to end in terms of Solution Design for New Country Rollouts.
• Customized ETL processes and resolved related issues.
• Identified improvement areas in existing system and implemented the same.
• Designed the ETL solution for new countries as per the regulatory requirements.
• Enhanced the existing Data Model to make the model generic for all clients across the globe.
• Identified the performance bottlenecks and optimized the Informatica Mappings/Sessions.
• Improved the Error Handling Approach.
• Updated Data Standards documents to align with new requirements.
• Reviewed daily deliverables of the Offshore Team and provided them with necessary comments / suggestions.

Environment: InformaticaPowerCenter 9.5.1, Oracle 11g, Oracle SQL Developer, SQL Developer Data Modeler, UNIX

Confidential

ETL Designer / Developer

Responsibilities:

• Involved in System Analysis & Design of the Enterprise Data Warehouse implementation
• Requirement gathering for new change requests, Designing, developing and translating business requirements to technical requirements.
• Responsible for design, architecture and development of Databases and ETL Processes.
• Involved in enhancing the Mappings based on new requirements like adding new fields to Dimension & fact tables and adding ETL logic to load data to new fields.
• Ensuredthe team met all KPI’s (key performance indicators) set by the Client in terms of Incident/Change SLA’s.
• Scheduled weekly call with the Client to discuss on the outstanding issues and the steps taken to mitigate them.
• Monitored AutoSys Jobs and troubleshooting during production failures
• Optimizing the existing mappings and workflows.
• Involved in Unit Testing, system Integration Testing, user acceptance testing for Go-Live releases.
• Handling production support issues which involve ticket resolution, root cause analysis and fixes.

Environment: InformaticaPowerCenter 8.6, Oracle 11g, UNIX (SunOS), Erwin 4.0, Autosys.

Confidential

ETL Developer

Responsibilities:

• Worked on PowerCenter client tools like Source Analyzer, Target Developer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Developed and Unit Tested the below:
• Informatica Mappingsfor implementing SCD Type 2 dimensions with transformations like Joiners, Lookups, Sequence Generators, Routers, Update Strategies, Expressions, etc and their corresponding sessions and workflows.
• Informatica Mappings for implementing FACT tables with transformations like Aggregators, Ranks, Lookups, Expressions, etc and their corresponding sessions and workflows.
• Created Workflows to load data into Dimensions and facts.
• Autosys Jobs to schedule the ETL Processes on a daily, weekly and monthly basis.
• Created Reusable Transformations, Mapplets and Mappings using Designer.
• Involved in Designing Logical Database Design, and converting it into Physical Schema
• Involved in providing 24*7 production support to the application as it is PRIME to business.
• Provided solutions for defects raised via Change Requests.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.

Environment: InformaticaPowerCenter 8.6, SQL Server 2005, Erwin 3.5, Control-M, Windows Server 2003.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in Requirement gathering for new change requests. Analyzing, Designing, developing and translating business requirements to technical requirements.
• Implemented the business logic using Triggers, Stored Procedures and PL/SQL functions
• Used Visual Source Safe as a tool for repository of codes and version control, also maintained test scripts and documentation following the industry standards
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard
• Participated in designing Disaster Recovery plan for SQL Server Database and actively monitored the maintenance of database backup at scheduled time
• Held weekly call with the Client to discuss on the outstanding issues and the steps taken to mitigate them.
• Responsible to see that handover between the Tech Center’s is effective.
• Involved in understanding the new change requirements and accordingly providing the estimates and timelines.
• Planning & implementing annual disaster recovery tests.
• Providing knowledge transfer for new team members and assisting the team in resolving tickets.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server Reporting Services (SSRS), SQL Profile, Windows Server 2003

Confidential

Database Developer

Responsibilities:

• Actively participated in all phases of project life cycle.
• Extensive participation in logical and physical database design, and normalizing the database to accommodate possible changes in the requirement
• Enforced Referential integrity of data by creating different constraints
• Developed Triggers, Stored Procedures and functions using T-SQL to implement the business logic
• Understanding the client change orders and implementing the necessary changes.
• Tracking and resolving the issues that are logged into IssueTracker, coordinating with all the team members and resolving the issues.
• Involved in Transforming XML files to HL7 format using XML, XSLT, and XPath

Environment: Microsoft SQL Server 2000, Windows NT, XML, XSLT, XPath& HTML.

Confidential

Database Developer

Responsibilities:

• Developed tables, views, stored procedures, functions and Synonyms for the organization
• Created table structures along with the triggers and indexes.
• Maintained the data integrity and security using constraints and database triggers.
• Involved in programming database triggers for automatically updating the tables and views.
• Used various forms of control structures including Case, Decode, If-Then-Else, For loops, While loops while developing procedures.
• Troubleshoot performance issues within packages and stored procedures using Explain plan and dbms output.
• Improved the query performance using better joins and hints appropriately.

Environment: Oracle 9i, SQL, PL/SQL, Toad, Windows 2000.

Confidential

Oracle Consultant

Responsibilities:

• Preparation of Detailed Functional Specifications and Detailed Implementation Specification.
• Developed tables, views, stored procedures, functions and Synonyms.
• Maintained data security using constraints and database triggers.
• Implementing Database objects in different environments like DEV, TEST and PROD servers.

Environment: Oracle 8i, SQL, PL/SQL, Toad, Windows 2000.

Confidential

Oracle Consultant

Responsibilities:

• Created Database objects Tables, Views and Constraints.
• Developed Stores Procedures & User Defined Functions.
• Unit Testing of the applications built

Environment: Oracle 8i, SQL, PL/SQL, Windows 2000.