SUMMARY:

• 13 years of IT industry experience in Analysis, Design, Development and Implementation of business application systems for Investment Banking, Retail and Manufacturing clients.
• Strong experience in Design, Development and Implementation of Data Integration Solutions using Informatica, Oracle PL/SQL and Control - M Job Scheduler.
• Strong experience in Extraction, Transformation and Loading (ETL) data from Flat Files, XML Files and Remote Databases into Data Warehouses using Informatica Power Center as ETL tool on Oracle database.
• Expertise in creating Oracle PL/SQL Stored Procedures, Functions and Views and Performance Tuning SQL queries.
• Experience in developing Complex mappings using transformations like Source Qualifier, XML parser, Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Experience in Performance Tuning in Informatica at various levels - Targets, Sources, Mappings and Sessions.
• Strong experience in writing complex stored procedures using Bulk Binding, Analytic functions, Indexes, Partition keys and Exchange Partition for performing high volume data loads.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

Primary Skills: Oracle 10g/11g, SQL, PL/SQL, Informatica, Unix Scripting, XML

Databases/DB Tools: Oracle 10g/11g, SQL Server 2008, SQL Loader, Toad, SQL Developer

Scripting Languages: Unix Shell Scripting

Scheduling Tools: Control-M

Source Control Tools: GITHub, Clearcase, SVN

Deployment Tools: IC Environment Manager (ICEM), Liquibase

Operating Systems: UNIX, Windows 2008 Server

Unix tools: Putty, FileZilla

PROFESSIONAL EXPERIENCE:

Senior Software Engineer

Confidential, Lansing, MI

Responsibilities:

• Designed and Developed Interfaces by Creating Oracle Views, Packages and Tables to load Provider and User Account data from Claims Database into Facility Settlement system.
• Developed Data Migration Environment by Creating Informatica Workflows to load Legacy data from flat files into Staging Tables in Oracle database using transformations like Source Qualifier, Lookup, Stored Procedure, Aggregator and Joiner.
• Developed Source Views in Oracle Database to provide aggregated Claims data for COGNOS reports.
• Performed Query Optimizations for Database Views and Procedures by adding Indexes to Base Tables, Re-Ordering Joins and using Bulk Binding to perform high volume data loads.
• Fine-tuned performance of Informatica Workflows by identifying and fixing performance bottlenecks in Mappings and Sessions.
• Maintained Database Objects in SVN Source Control Tool and Supported Deployment of Database objects into Test and Production Environments using Liquibase.
• Provided System Test, UAT and Production Support by Fixing issues within SLA by debugging Procedures and Workflows.

Technology Lead

Confidential, Durham, NC

Responsibilities:

• Participate in the Analysis sessions, gather requirements and take them to the implementation phase.
• Analyzed the requirements and framed the business logic for the ETL process.
• Designed batch process to load model data like model holdings, model asset mix, statistics, customer accounts and benchmarks from flat files and Remote Database tables into Datawarehouse. Design involved dividing the data load process into four layers - FTP layer, Staging, Integration and Presentation layer.
• Designed Informatica Mappings and PL/SQL Procedures for each layer by identifying source tables, Lookup tables and filter conditions.
• Designed and developed Target tables in Oracle Database to store model data history and Reference Data by identifying Column Data types, Key constraints, Indexes and Partition/Sub-Partition Keys.
• Developed Stored Procedures to load data from staging tables into target tables using bulk binding and Exchange Partition.
• Created mapping documents to outline data flow from sources to targets.
• Developed Informatica workflows to load data from flat files into staging tables in Oracle database using transformations like Source Qualifier, Lookup, Stored Procedure, Aggregator and Joiner.
• Developed mapping parameters and variables to support SQL override.
• Used Debugger to test the mappings and fixed the bugs.
• Create Informatica workflows to generate flat file and XML file extracts containing model data for consuming applications.
• Fine-tuned performance of Database views by adding required indexes on base tables and joining base tables using appropriate Keys.
• Fine-tuned performance of Informatica Workflows by identifying and fixing performance bottlenecks in Mappings and Sessions.
• Prepared migration document to move the mappings and PL/SQL procedures from development to testing and then to production environment.

Team Leader

Confidential

Responsibilities:

• Designed, developed and maintained software applications and systems using .Net Technology, Oracle and MS SQL Server.
• Analyzed user need and developed software solutions per project requirements.
• Deployed code to different environments and resolved defects raised by QA.
• Used Third party tools to generate reports in the form of graphs.