SUMMARY:

• Ten plus (10+) years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Financial, Banking and oil &gas Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools like Informatica Server, Repository Server manager .
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.5/8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Extensively worked in the Performance tuning of the SQL and ETL processes.
• Strong experience in coding using SQL, PL/SQL Procedures/Functions, Cursors, Triggers and packages.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Experience with Oracle Supplied Packages such as DBMS SQL,DBMS JOB and UTL FILE .
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Good knowledge on oracle 10g, 11g, Teradata 12 and 13 versions.
• Good knowledge on Database/ETL Performance Tuning Techniques.
• Good experience in working with Oracle, SQL Server, ETL and reporting tools crystal reports and business objects.
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer.
• Experience in implementing Slowly Changing Dimensions (Type1, Type2) mappings.
• Expertise in running of Informatica sessions and batches using UNIX Shell Scripts and Autosys
• Experience in using Pipeline Partitioning feature in the sessions to reduce the load time.
• Experience in integration of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, CSV files, COBOL files and XML files.
• Extensively executed SQL queries on Oracle using Toad and SQL Server tables in order to view successful transaction of data and to validate data.
• Good Exposure on Programming Languages C, C++ and JAVA.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Proven management experience, with years of practice in all aspects of the SDLC process
• (Waterfall and Agile methodologies)
• Able to understand and work flexibly in high paced environments and adapt quickly to different business organization needs.
• Have good Knowledge on cassandra and Mongodb.
• Have good exposure to BIGDATA concepts .

TECHNICAL SKILLS:

ETL: Informatica 9.5.1/9.1.0/8.6.1/8.5/8.1/7.1 / IDQ 9.5.1

Database: Oracle 11g/10g/9i, SQL Server 2005/2008, Teradata v12/13, DM Express

Interfaces: TOAD 11.6, SQL*Loader, MS SQL Server Management

Languages: PL/SQL, C, C++, SQL, HTML, XML.

Scheduling Tools: Autosys, Control-M

Concepts: Data Warehousing, ETL and RDBMS

Operating Systems: Windows 2008/2007/2005/ NT/XP, UNIX, Linux

Tools: MSOffice-Word, Excel, Access, Visio, PowerPoint, SQL Loader, SQL, Navigator, TOAD11.6 for Oracle 11g

Knowledge of: SSIS, SSIA, SSRS, T-SQL, SAP Business Objects & Crystal Reports

Other Technologies: Unit Testing, Integration Testing, Production Support

PROFESSIONAL EXPERIENCE:

Lead ETL /PLSQL Consultant/ Sr. Data Analyst

Confidential - Houston, TX

Responsibilities:

• Created reconciliation reports to reconcile data from Endure to ODS load for price value entity. • Involved in cost analysis (explain plan) of complex queries, gathering stats and copying baseline plan from one to other DB environments.
• Reverse engineering complex ETL mappings in-order to document and map the existing production logic to the new systems.
• Generated First of the month reports for (Power, GAS & NGL) using SQL and Informatica.
• Involved in mentoring the new joiners in the team.
• Created mappings to move the historical data from ODS to EDW, and generated the purge mapping to purge the historical data from ODS (non-current records) to improve performance and cleanup the ODS.
• Informatica object metadata search in the Informatica repository(using metadata queries) before decommissioning or to find out the dependencies in the DWH.
• Develop the reconciliation reports to reconcile the data movement from ODS to EDW.
• Notified the downstream stake holders for any changes to ODS/EDW.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Used deployment groups to migrate the Informatica code from Dev to INT, Test and Prod. Also created labels and queries.
• Involved in resolving issues in FRR/LTR reports (Federal regulatory reports for trading ).
• Worked with the DA team to improve the performance of the existing ETL processes.
• Good exposure to Business Objects/Crystal Reports.
• Worked closely with the business analyst's team in order to solve the Problem Tickets, Service Requests. Helped the 24/7 Production Support team.
• Good Knowledge on Market Risk and Credit risk Applications.
• Good understanding of finance, fixed income securities and deri vatives.

Environment: Informatica PowerCenter 9.5, SQL Server, Endur, Oracle 11g, SQL, TOAD, Business objects/Crystal reports, PL/SQL, STAR Schema, Remedy.

Senior PLSQL/Informatica Developer

Confidential, Birmingham, Alabama

Responsibilities:

• Developed multiple mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Router, Lookup, Sequence Generator, Filter and Sorter.
• Extensively used ETL to transfer and extract data from source files (Flat files and VSAM main frames) and load the data into the target database CRDB (Credit risk Database).
• Migrating data from oracle database to sqlserver using informatica ETL Tool.
• Attended meetings and got the business requirements & Updated maps, sessions and workflows as a part of ETL change.
• Writing, tuning and reviewing the PLSQL stored procedures, triggers and functions.
• CDC Process: has been done for the comparison between the Source File Data and previous files.
• Experienced in Business Requirements analysis, Application Design, Data Modeling, Coding, Development, Testing and implementation of business applications with ETL & RDBMS
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations
• Created mapping that stores historical data which is further used for reporting
• Used XML file generation to load data in XML files the XML file used for Confidential application recently Confidential compass tied up business with Confidential .
• Writing and reviewing the complex SQL queries in Maestro ETL Tool.
• Developing the ETL Mappings in Maestro ETL Tool and Testing the Mappings.
• Generating the Reports and analyzing the reports in SumOneX portal.

Environment: Informatica PowerCenter 9.5, SQL Server, Oracle 11g, SQL, TOAD, Business objects/Crystal reports, PL/SQL, STAR Schema, Remedy.

PLSQL Developer

Confidential

Responsibilities:

• Reviewed Transaction records for accuracy and prepared records for release to authorized parties. Organized chart-holding facilities using ETL Tools
• Documented workflows and executed comprehensive training plan to medical staff that more than doubled EMR access (from 45% to 100%) and usage (from 35% to 80%)
• Worked on Informatica- Source Analyzer, Designer, Mapping Designer, Mapplet, and Transformation Developer, worklet designer,
• Extracted data from DB2, XML, Flat files, Sequential files, loaded Data warehouse on Oarcle
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 SCD 3 dimensions and Incremental loading and the mappings.
• Extensively worked in the performance tuning of SQL, ETL and other processes to optimize session performance.
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer.
• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of InformaticaPowerCenter.
• Developing control files, Stored Procedures to manipulate and load the data into Oracle database

Environment: Informatica PowerCenter 9.0.1, SQL Server 2008, DB2, Shell Scripts, Oracle 10g, SQL, PL/SQL, Toad 10.

PLSQL Developer

Confidential

Responsibilities:

• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Modified existing forms, reports, and graphs as per the enhancement
• Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines. Moved data from one database to other database, Used SQL Loader for data migration.
• Used workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency.
• Used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.
• Defined Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Used CONTROL M Tool to schedule Informatica jobs. Generated Ad-hoc reports using Business Objects XI R2.
• Running pipelines in True comp and Loading Data marts.
• Developing the Pay sheets using crystal reports.

Environment: TrueComp, Informatica PowerCenter 8.6 Oracle 10g, Unix, Windows XP. SQL

Informatica Developer

Confidential, IL

Responsibilities:

• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse for University recruiting Purpose.
• Modified existing mappings for enhancements of new business requirements. Used Debugger to test the mappings and fixed the bugs.
• Perform the unit testing, system integration testing and assist with user acceptance testing
• Responsible for peer code reviews and data validation
• Responsible for continuous performance tuning and resolving production data issues.
• Work closely with the DBA teams to maintain production environments and ensure maximum system availability.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV environment.

Environment: Informatica 8.6.1, Oracle 11g/10g, SQL Server 2008, Autosys, SQL Developer, Toad for SQL Server, Microsoft Excel, Visio.

Informatica Developer

Confidential, MO

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Migrated the code into QA (Testing) and supported QA team and UAT (User)
• Prepared migration document to move the mappings from development to testing and then to production repositories
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities

Environment: Informatica 8.6, SQL server 2005/2008, Teradata, Toad, MS Visio, Windows, Oracle 10g

PLSQL DEVELOPER

Confidential

Responsibilities:

• Analyze the requirement and get clarifications on Functions specifications
• Database development as per the Frontend needs
• Developed Macros in MS Excel to automate manual effort and developing automation scripts for testing
• Code review of the Sub Ordinates and Implementing performance tuning techniques of DB stored Procedures
• Prepare Unit Test cases and Unit, Integration and Stress testing of the application
• Developed enhancements of the application and release the modules to the test team
• Bug Fixing of the application in various areas
• Production Support and troubleshoot Production issues
• Trained new associates to perform relevant tasks
• Preparation and updating the documents on the Checklists for Coding standards, Functional areas, and Project Initiatives, Code Review Checklists, VSS Changes, Test case Writing and Execution standards related to applications

Environment: /Skills: Oracle 10g, SQL Server 2005, Crystal Reports, VB.NET, Visual Studio.NET 2005, ASP.NET 2.0, C#.NET, VB Script, Toad, PL/SQL Developer, Visual SourceSafe, Team Foundation Server (TFS)