SUMMARY:

• 5+ years of rich IT experience in Oracle database development, performance optimization and ETL Development using Informatica PowerCenter 9.5
• Experience in creating complex database subprograms in PL/SQL (created Packages, Stored procedure, Triggers, Functions, Exception Handlers, Ref Cursors etc.).
• Proficient in using bulk operations (bulk collect, for all etc.) and oracle collections such as PL/SQL records, associative arrays, nested tables and varrays in PL/SQL.
• Hands on experience with TKPROF for performance tuning.
• Experience in UNIX shell and Python scripting and basic UNIX commands.
• Experience in getting better execution plan via using appropriate hint such as use nl, use hash, index, full, driving site etc.
• Experience in performing range, list, hash and composite partitioning to improve concurrency and ease of administration.
• Performed data conversion from Flat files to Oracle using Oracle SQL* Loader.
• Experience with Data Pump, External Tables in various types of ETL projects.
• Experience in implementing parallel execution to run SQLs in multiple threads in order to reduce response time for data intensive operations.
• Experience writing complex SQL queries using analytical functions like RANK, DENSE RANK, FIRST VALUE, LAST VALUE, LEAD, LAG etc.
• Extensive experience in writing complex SQL queries using joins, sub queries and correlated sub queries and creating Indexes, synonyms, sequences.
• Experience in creating materialized views for incremental data refresh.
• Designed applications/databases for optimal performance in Multi - Terabyte and high load environment.
• Experience in creating complex mappings using various transformations and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica 9.5
• Data Processing experience in designing and implementing data mart applications, mainly transformation processes using Informatica PowerCenter.
• Strong knowledge in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema, Fact and Dimensional tables.
• Extensively worked on Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Experience in documenting High Level and Low level Design, Source to Target Mapping (STM), Macro and Micro Documents, Unit test plan, Unit test cases and Code Migration Report.
• Experience in working with Informatica Developer 9.6 to convert Relational data into JSON and vice versa using Data Processor Transformation.
• Used performance tuning logic on Source, Targets, Mappings, Sessions to provide maximum effectiveness and performance.
• Worked in Agile Methodology for SDLC (Software Development Life Cycle) and utilize Agile scrum meetings for creative work.
• Hands-on experience in designing & developing applications using PowerCenter's advanced features like parallel loading, Pushdown optimization, Performance Tuning.
• Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Experience in Data modeling using Erwin and logical and physical database design.
• Insight into different data transformation technique such as cleansing, filtering, aggregation and derivation.
• Ability to think out of the box and develop innovative solutions.
• Team player with excellent communication and Interpersonal skills and ability to work independently and cross functional.

SKILL SET:

Databases: Oracle 11g/10g/9i, MySQL, SQL Server, Teradata

Data Warehousing ETL Tools: Informatica Power Center 9.5, Informatica Developer 9.6

Operating System: Windows/XP/Vista/08/07, UNIX, Linux

Programming: SQL, PL/SQL

Data Modeling: Dimensional Data Modeling, Star Schema, Snow-Flake

SQL: Oracle Performance Tuning, Explain Plan, TKPROF

Scripting: Shell Scripting, Python

Tools: TOAD, SQL*Loader, SQL Developer, SQL *Plus, MS Office, Putty, WinSCP

Big Data: Hadoop, HDFS, Hive, PIG, Flume, Oozie

PROFESSIONAL EXPERIENCE:

Confidential

Informatica and Oracle PL/ SQL Developer

Responsibilities:

• Designed and developed an end-to-end process to load data into Oracle Sales Cloud by invoking the RESTful and SOAP web services via Informatica PowerCenter.
• Implemented Data Processor Transformation in Informatica Developer to create JSON files from oracle tables in order to use that JSON data as input while calling the web services.
• Created mappings and workflow to invoke RESTful and SOAP web services with GET and POST methods using HTTP Transformation.
• Experience in creating complex database subprograms in PL/SQL (created Packages, Stored procedure, Triggers, Functions, Exception Handlers, Ref Cursors etc.).
• Created Python scripts to create an HTTP request, call the web services with PATCH method and store the received response into an oracle table.
• Worked with business analysts to understand the business requirements and created Technical Requirements Documents and Technical Design documents according to the business requirements.
• Created and used reusable Transformation, Mapplets using Informatica PowerCenter.
• Design and Developed complex mappings by using Lookup transformation, Expression,
• Sequence generator, Update, Aggregator, Router, Stored Procedure to implement complex logics while create mappings. 
• Developed mappings using Informatica to load the data from sources such as Relational tables, Flat files, Oracle tables into the target data warehouse.
• Contributed and actively providing comments for user stories review meeting within an AGILE SCRUM environment.
• Developed mappings/Transformation/mapplets by using mapping designer, transformation developer and mapplets designer using Informatica PowerCenter
• Used the Slowly Changing Dimensions (SCD type 2) to update the data in the target dimension tables.
• Extensively used types of caches like static, dynamic and persistent caches while creating sessions and tasks.
• Extensively used Informatica debugger to find out the problems in mapping. Also involved in troubleshooting and rectify the bugs.

Skills Used: PL/SQL, SQL, Oracle11g, Informatica 9.6, IDQ 9.6, Erwin Data Modeler, Oracle PL/SQL, TOAD, Hadoop Ecosystem

Confidential, Wayne, NJ

Informatica and PL/ SQL Developer

Responsibilities:

• Working with business analyst to understand the business requirements and created technical requirements documents.
• Prepared the Technical Design according to the business requirements.
• Design and Developed complex mappings by using Lookup transformation, Expression, Sequence generator, Update, Aggregator, Router, Stored Procedure to implement complex logics while create mappings. 
• Developed mappings using Informatica to load the data from sources such as Relational tables, Flat files, Oracle tables into the target data warehouse.
• Experienced in methodologies like SDLC and Agile methodologies such as SCRUM.
• Designed and developed complex aggregate, join, lookup transformation to generate and consolidate (fact and summary) data using Informatica Power Center
• Created and used reusable Transformation, Mapplets using Informatica PowerCenter.
• Worked on different tasks in Workflows like sessions, event raise, event wait, decision, e-mail, command, Assignment, Timer and scheduling of the workflow.
• Experience in writing UNIX and automation of the ETL processes using UNIX shell scripting.
• Designed and Developed ETL using PL/SQL packages, procedures, functions and UNIX shell scripts for the massive data loads from OLTP systems to staging database system.

Skills Used: PL/SQL, SQL, Oracle11g, Erwin Data Modeler, Oracle PL/SQL, TOAD, Hadoop Ecosystem

Confidential, San Jose, CA

Oracle Performance Tuning Consultant

Responsibilities:

• Oracle performance bottleneck identification.
• Advising application teams on SQL/PLSQL performance improvement.
• Pro active tuning of SQL/PLSQL issues and other complicated database issues of various applications.
• Designed indexes, histogram and created materialized views from performance perspective.
• Analyzing TKPROF output for performance bottleneck identification and coming up with practical tuning solutions.
• Table partitioning (Range, List, and Hash& Composite) for appropriate scenario.
• Use of bulk binding (bulk collect and forall update/insert/delete/merge) and oracle collections as per situation.
• Deciding optimal indexing strategy and suggesting hints for plan stability and better plan selection by oracle.

Skills Used: Or acle PL/SQL, SQL, Oracle Performance tuning and basic UNIX commands Oracle 9i/10g/11g, Toad.

Confidential, Richmond, VA

PL/ SQL Developer

Responsibilities:

• Understand and analyze requirements and convert them into robust, scalable solution for implementation.
• Created Master Data tables for managing various insurance policies and related products and developed Procedures, Functions, Packages, Triggers, views, synonyms and sequences.
• Written complex SQL queries using joins, sub queries and correlated sub queries.
• Implemented Table partitioning (Range, List, Hash and Composite) for appropriate scenario and used bulk binding (bulk collect and for all update/insert/delete/merge) and oracle collections as per situation.
• Physical database object design and implementation (indexing, partitioning, materialized views etc.)
• Interact with various teams to define requirements, interfaces and implementation approaches.
• Developed normalized Logical and Physical database models to design OLAP system for insurance applications.
• Implemented Data extraction/Transformation/Cleaning/Loading using SQL Loader and PL/SQL.
• Monitoring and issue resolution of Daily reconciliation jobs for important interfaces and resolving day to day queries raised by the business users.

Skills Used: PL/SQL, SQL, Oracle Performance tuning, UNIX, Oracle 11g.