PROFESSIONAL SUMMARY:

• Seven Plus (7+) Years of IT experience in Analysis, Design, Development, Testing and Implementation of business application systems for Property & Casualty, life insurance and ERP.
• Strong Data Warehousing ETL experience of using Informatica 9.5.1/9.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Drawing on Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, data migration and reporting solutions)
• Developed mappings in Informatica to load the data from various sources into the Data warehouse different transformations like Source Qualifier, JAVA, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Extensive experience in developing stored procedures, functions, Views, Triggers, Complex SQL queries and Oracle PL/SQL
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions
• Databases: 7 years of experience using Oracle 10g/9i/8i, DB2 8.0,Teradata
• Experience with Data Profiling, UNIX Shell Scripting.
• Experience in using Automation Scheduling tools like Autosys and ESP.
• Database / ETL Performance Tuning: Broad Experience in Database Development including effective use of Database objects, SQL Trace, Explain Plan, Different types of Optimizers, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views, Global Temporary tables, Autonomous Transitions, Bulk collect, Capabilities of using Oracle Built-in Functions. Performance Tuning of Informatica Mapping and workflow.
• Business Intelligence experience using Crystal Reports XI, Oracle reports and working knowledge of Business Objects XIR3.
• Superior communication skills, strong decision making and organizational skills along with outstanding analytical and problem solving skills to undertake challenging jobs. Able to work well independently and also in a team by helping to troubleshoot technology and business related problems.
• Good experience on preparing the mapping document between the Data warehouse(Teradata) and Oracle.
• Good experience in Data Extraction, Transformation and Loading (ETL) from disparate Data sources like Relational Databases, Flat files & CSV files.
• Mentor team members in developing quality deliverables.
• Experience with AGILE and Waterfall Methodologies.
• Code deployment, release management and support.

TECHNICAL SKILLS:

ETL Tool: Informatica PowerCenter 9.5.1/9.1

BI & Reporting: Business Objects XIR3, Crystal Reports

Databases: Oracle 10g/9i, Teradata, DB2, MS Access 2000.

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting

Oracle Tools: TOAD, SQL Developer.

Environment: Windows 7/2000/XP.UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

ETL Technical Lead

Responsibilities

• Review the requirement and create design document.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data mart.
• Created mapping documents to outline data flow from sources to targets.
• Created source staging database model to load the data from Data warehouse.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated into Data mart.
• Developed mappings to load into staging tables and then to Profiles and Facts.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Lead 2 member Informatica team at the client site.
• Weekly Status reporting to Onshore Project Manager
• Deriving best practice, processes & standards for the project in consultation with the client architects/Business.
• Story Card Planning, Capacity allocation, Attending Scrum meetings and Retro meetings
• Co-ordinating the offshore tasks, Release Management & Deployment tasks.
• Code Review and ensure overall quality of the project

Environment: Informatica Power Center 9.5.1, Workflow Manager, Workflow Monitor, PL/SQL, Oracle 10g/9i, ESP, Teradata 13.1, UNIX, Toad 10

Confidential, Hartford, CT

Sr. ETL Developer

Responsibilities

• Analyzed the requirements and framed the business logic for the ETL process.
• Data profiling using Trillium tool.
• Involved in the ETL design and its documentation.
• Extracted data from iSeries as one of the source databases.
• Responsible for the development, implementation and support of the databases.
• Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages.
• Developed mappings in Informatica to load the data from various sources into the Salesforce, using different transformations like Source Qualifier, JAVA, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Developed reusable Mapplets and Transformations.
• Optimized the performance of the mappings by various tests on sources, targets and transformations
• Design, develop and Informatica mappings and workflows; Identify and Remove Bottlenecks in order to improve the performance of mappings and workflows
• Scheduled the tasks using Autosys.
• Created high level design documents, technical specifications, coding, unit testing and resolved the defects.
• Status reporting to Offshore project management
• Release Management

Environment: Informatica Power Center 9, AS400 Connector, DB2, Salesforce, PL/SQL, Oracle 10g/9i, Autosys, UNIX, Toad 9.0, Salesforce Connector.

Confidential, Hartford, C

ETL Developer

Responsibilities

• Gathered business requirements from Business Analyst.
• Involved in the ETL design and its documentation.
• Responsible for the development, implementation and support of the databases.
• Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages.
• Developed mappings in Informatica to load the data from flat file sources into the relational tables, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy and Joiner.
• Creation of Business object Universe and reports
• Creation of Crystal reports.
• Scheduled the tasks using Autosys.
• Prepared Implementation document and support
• Release Management

Environment: Informatica Power Center 8, SQL, PL/SQL, Oracle 9i, Autosys, UNIX, Toad 9.0, Business Object XIR3 and Crystal report XI.

Confidential

Oracle Developer

Responsibilities

• Gathered Requirement for ERP product
• Clarified the requirements with user groups and accordingly modify the functional and technical specifications.
• Develop oracle functions, procedures, views, materialized views, triggers and packages.
• Designed Oracle Forms and Reports.
• Migrating existing source data to ERP product
• Developed Unit Test Plans and Unit test results creation.
• Modified existing code as per new design.
• Data validation using sql queries.
• Create Unit Test Plans and Unit test result
• Prepared user manual and help document for the ERP product.

Environment: Oracle Developer 10g/9i/8, SQL, PL/SQL, Toad 8, Oracle report Builder, Oracle Forms.