SUMMARY

• Having 5+ years of programming experience as an OraclePL/SQLDeveloperin Analysis, Design, and Implementation of Business Applications using teh Oracle Relational Database Management System (RDBMS).
• Involved in all phases of teh SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, Production Support, Quality Assurance and maintenance with timely delivery against aggressive deadlines.
• Experience in Client - Server application development using Oracle PL/SQL,SQL*PLUS, TOAD,SQL*LOADER.
• Solid experience of creatingPL/SQLPackages, Procedures, Functions, Triggers and Materialized Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions.
• Strong experience in Data Analysis, Data Profiling, Data Cleansing & Quality, Data Migration, Data Integration
• Excellent experience in designing, developing, documenting and testing ofETLjobs and mappings in Server and parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.
• Have experience in Data Modeler. Working in areas of Data Mining and Data quality process.
• Experienced in using ETL tools in (SSIS) MS SQL 2008, MS SQL 2005 and DTS in MS SQL 2000.
• Experience in Query Optimization, Debugging, Tuning and improvising performance of teh database, using theOracletools like Hints, Explain Plan, and TKPROF.
• Worked extensively on Ref Cursor, External Tables, Collections (Nested Tables and Array) in complex backend packages.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel,MSAccess, Oracle, and DB2 toMSSQLServerby using Import Export Wizard, DTSSSIS, and BCP & Bulk Insert utilities.
• Experience in developing SQL*Loader control programs and PL/SQL validation scripts for validating data to load data from staging tables to production tables.
• Good knowledge of key Oracle performance related features, such as Query Optimizer, Execution Plans and Indexes, for faster execution.
• Experienced in scheduling, running and monitoring jobs using ETL tool IBM DataStage 8.5.
• Involved in Agile Software Development Team using SCRUM, TDD Test Driven Development.
• Used SVN, CVS, GIT for Version controlling and error reporting and project management tools like JIRA.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

PROFESSIONAL EXPERIENCE

Oracle PL/SQL Developer

Confidential, Scottsdale, AZ

Responsibilities:

• Involved as a key team member for Requirement Analysis during teh design phase and interaction with teh client.
• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality.
• Engaged in writing PL/SQL stored procedures and complex queries to read data from multipledatabases, apply business rules to create summarized data to be consumed by teh application.
• Written complex OracleSQLqueries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
• Optimized query performance with modification inPL/SQLqueries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful indexes and Views.
• Extensively monitored various jobs for data staging, processing and loading data.
• DevelopedPL/SQLpackage procedures using REF cursor, Collections.
• Extensively used teh advanced features ofPL/SQLlike Records, Tables, Object types and DynamicSQL.
• Working with tools like SQL Developer, Toad, Jira, Team Foundation Server (TFS).
• CreatedSSISpackages to validate, extract, transform and load data-to-data warehouse databases and deployed with minimal changes using XML configuration file.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks usingSSIS.
• Optimized and enhanced teh existing procedures andSQLstatements for teh better performance.
• Involved in planning process of iterations under teh Agile Scrum methodology.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Analyzed teh tickets based on description in JIRA. WrittenPLSQLscripts to fix teh defects.

Environment: Oracle 11g/10g,PL/SQL,SQLLoader, SQL, Agile, Team Foundation Server, OraclePL/SQLDeveloper.

Confidential, Austin, TX

PL/SQL Developer

Responsibilities:

• Develop and implement databases, data collection systems, data analytics and other strategies dat optimize statistical efficiency and quality.
• Created /updated tables, Indexes, materialized views, synonyms and sequences per requirement.
• Involved in getting teh User Requirements, Data Modeling & Development of teh system.
• UsedPLSQLto Extract Transform and Load (ETL) teh data into Data Warehouse and Developed PL/SQL scripts in accordance with teh necessary Business rules and procedures.
• Involved in ETL (EXTRACT, TRANSFORM and LOAD) in OLAP database to transfer data from source tables into teh data warehouse tables using PL/SQL.
• SupportedAPEXapplications and conducted performance tuning for PLSQL.
• Configure SSL forAPEXover web logic server, HTTP server and others in Test and production environments.
• Extensively worked on BULK COLLECTS, BULK INSERTS, and BULK UPDATES & BULK DELETES for loading, updating and deleting huge data.
• Experience working with Oracle Workspace Manager to handle transactional data at different instances such LIVE and save point.
• Used various transformation tasks to createETLpackages for data conversion.
• Extensively involved in performance tuning using Explain Plan, DBMS PROFILER, Optimized SQL queries and created Materialized views for better performance.
• Worked on control-M Scheduler for successfully working of these validated scripts to run in daily and weekly basis.
• Involved in tuningETLPLSQLpackages and SQL queries, views by passing hints and analyzing them using plan table and created indexes if needed.
• Worked extensively on Ref cursors and alter table exchange partition and implemented in many procedures.
• Worked with Fixed width flat files to load into staging tables.
• Used Tortoise SVN sub version for code repository.

Environment: Oracle 11g, ORACLEAPEX4.2/4.1,TOAD, Windows XP, Pl/SQL, SQL, UNIX, DataStage 8.1, ETL, SVN.

Confidential, Austin, TX

Data Analyst

Responsibilities:

• Responsible for gathering data migration requirements.
• Identified problematic areas and conduct research to determine teh best course of action to correct teh data.
• Analyzed problem and solved issues with current and planned systems as they relate to teh integration and management of order data.
• Analyzed reports of data duplicates or other errors to provide ongoing appropriate inter-departmental communication and monthly or daily data reports.
• Monitor for timely and accurate completion of select data elements.
• Monitor data dictionary statistics.
• Involved in analyzing and adding new features of Oracle 10g like DBMS SHEDULER, Create Directory, Data pump, CONNECT BY ROOT in existing Oracle 9i application.
• Archived teh old data by converting them in to SAS data sets and flat files.
• Extensively used Erwin tool in Forward and reverse engineering, following teh Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Enhance smooth transition from legacy to newer system, through change management process.
• Trained team members in PL/SQL and provided Knowledge Transfer sessions on Finance and Banking domains.
• Planned project activities for teh team based on project timelines using Work Breakdown Structure.
• Created Technical Design Documents, Unit Test Cases.
• Involved in Test case/data preparation, execution and verification of teh test results
• Created user guidance documentations.
• Created reconciliation report for validating migrated data.
• Used GIT for pulling and committing teh developed content from/to teh GIT repository

Environment: Oracle 11g, SQL, PL/SQL, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services,UNIX shell script, Git, Visual Studio 2005/2008/2012

Confidential

OraclePL/SQL Developer

Responsibilities:

• Coordinated with teh front-end design team to provide them with teh necessary stored procedures and packages and teh necessary insight into teh data.
• Involved in logical modeling and physical modeling of application.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in Development and Production environment for Oracle 10g and was involved with teh Performance tuning, Optimization of queries and standardization of teh code.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Developed PL/SQL Procedures and database triggers for teh validation of input data and to implement business rules.
• Suggested and Implemented indexes for faster retrieval of data in Weekly and Monthly Metrics reports.
• Created records, tables, collections (nested tables and arrays) for improving performance by reducing context switching.
• ImplementedSSISdata, created maintenance procedures and provided data integrity strategies.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Worked on data conversion, loaded data from different Sources into teh Temp data backup environment using SQL Loader and validated teh data before loading it into oracle tables.

Environment: Oracle 10g, UNIX, SQL, PL/SQL, SQL Loader, SSIS,SSRS, SSAS, UNIX shell script, XML, Forms & Reports 9i, PL/SQLDeveloperand Toad.