SUMMARY

• 10 years of IT Experience Oracle Development including analysis, modeling, design, coding, testing, administration, maintenance of Oracle Database systems.
• Experienced in developing ELT for supporting Extraction, Loading and Transformation using ODI 11g/12c.
• Worked on couple of source systems flat files, Microsoft SQL server and oracle as target.
• Worked extensively with complex Interfaces/Mappings using ODI.
• Experienced in environments requiring direct customer interaction during specifications, design, and development and product implementation phases.
• Worked on creating Variables, Sequences, Procedures, Packages, Scenarios and Control Tables.
• Very good noledge of Data Extraction, Data Mapping, Data Conversion and Data Loading process.
• Solid experience in Oracle Database Programming using PL/SQL, SQL, Database Design (both Physical and Logical), Database Modeling, Oracle Tuning & Optimization.
• Experienced in backend database development using tools SQL*PLUS, SQL* Loader, Oracle Designer, Oracle TOAD with good understanding of RDBMS and Normalization Techniques.
• Experience in creating Procedures, Packages, Functions, Triggers views, Cursors, PL/SQL Collections and optimizing query performance and other database objects using SQL, PL/SQL.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Expertise in ODI Repositories (Master & Work).
• Expertise in creating ODI interfaces for various source and target technologies.
• Experience in Installation of ODI 10g/11g.
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
• Experience in XML Data base functions to generate data in XML.
• Tuning of SQL Queries to improve performance of a system. Identify root causes and resolve problems related to system functionality. Experience in numerous Oracle implementations through full infrastructure and performance optimizations including I/O optimization, Backup and Recovery Planning, Testing and Implementation.
• Developed (Extraction, Transformation and Loading) Using Pre - Stage, Stage, Pre-Target and Target tables.
• Knowledge in Test Scripts, Test Cases, and SQL QA scripts to perform Unit testing, System Testing and load testing. Seamlessly migrated the Code from Development to Testing, UAT and Production.

TECHNICAL SKILLS

ETL Tools: Oracle Data Integrator 11g

EPM/BI: Hyperion Essbase/Planning, System 9, 11.1.x, 11.1.2.3/11.1.2.4.

Languages: SQL, PL/SQL, Shell Scripting

Operating Systems: UNIX, Windows

RDBMS: Oracle 11g

Tools: SQL Developer, TOAD, TFS, VSTS, Oracle PIM, ODI Metadata Navigator, ODI Console.

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

ODI Senior Developer

Responsibilities:

• Involved in design, development of ODI for ETL Project, gathering requirement specification documents and presenting and identifying data sources.
• Developed various ODI interfaces to load Metadata and data from Flat file/Relational Sources to Oracle Data Mart.
• Used the ODI Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
• Involved in creating the mapping between source and target using Oracle Data Integrator.
• Developed and managed the physical and logical models and performed reverse engineering
• Sound Knowledge in creating Agents, Physical schema, Logical schema and handling Load Balancing.
• Customized Knowledge Modules (KM’s) as per business requirements.
• Loading data from Production to development to generate test data.
• Created complex Stored Procedures, Functions, User Defined Data-Types, used complex queries involving join and union of multiple tables.
• Optimizing Stored Procedure to improve performance, preserve referential integrity and provide application functionality.
• Created data mapping and transformation document, used to develop the code. PerformedSQLtuning using Explain Plan, Hints and indexes.
• Used Sequence, for loop & for each loop containers for repetitive control flow tasks.
• Worked with business analysts in aggregating the business requirements, planning and designing phases of the project.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, hints, indexing and Partitioning of tables.
• Designed the PL/SQL Procedures to load data from Flat files and Oracle into the target Oracle database.

Environment: Oracle 11g, Oracle PIM,SQL, TFS,VSTS,TOAD,Explain Plan.

Confidential, Dallas, TX

Project Lead, ODI Senior Developer

Responsibilites:

• Created ODI Interfaces with simple to complex transformation rules while migrating from Source to the target
• Created ODI Package of various complexity and automated process data flow
• Configured the testing environment and process to export and Import ODI Objects into the Testing and Production (Execution) environment
• Performed source to Staging and staging to target mapping specifications and developed ETL / ELT ODI code for the same.
• Data Migration using PL/SQL stored Procedures.
• Developed packages, scenarios using interfaces and variables.
• Debugging the master jobs and packages by using operator navigator.
• Monitoring the execution logs in operator.
• Experienced in Working with Load Plans and Scenarios.
• Involved in creating Functional and Program Specification documents.
• PL/SQL Development and Implementation.
• Used SQL*Loader to load bulk data from various flat files and legacy systems.
• Involved in the creation of Partitioned Tables and Indexes.
• Involved in the creation and modification of Packages, Stored Procedures and Triggers.
• Involved in writing complex SQL Queries to implement the business requirements.
• Involved in Code Review and User Acceptance Testing (UAT) of the application.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, hints, indexing and Partitioning of tables.
• Designed the PL/SQL Procedures to load data from Flat files and Oracle into the target Oracle database.

Environment: Oracle 11g, SQL, PL/SQL,SQL Loader, PLSQL Developer, Explain Plan, ODI.

Confidential, Memphis, TN

Project Lead, ODI Senior Developer

Responsibilites:

• Installed ODI. Set up the ODI connection with Oracle and flat files.
• Did reverse engineering for the data sources and targets.
• Set up the Topology including physical architecture, logical architecture and context.
• Created new models for the data sources - flat files, Oracle.
• Created ODI packages, scenarios using interfaces, variables, procedure
• Involved in Data modeling activities.
• Managing and leading the project team.
• Worked on Adhoc Request
• Requirement analysis and design.
• Maintaining Offshore Team.
• Data Migration using PL/SQL stored Procedures.
• Involved in creating Functional and Program Specification documents.
• Used SQL*Loader to load bulk data from various flat files and legacy systems.
• Involved in ETL Development using native Oracle tools(SQL*LOADER, Oracle PL/SQL)
• Involved in the creation of Partitioned Tables and Indexes
• Involved in the creation and modification of Packages, Stored Procedures and Triggers.
• Involved in writing complex SQL Queries to implement the business requirements.
• Involved in Code Review and User Acceptance Testing (UAT) of the application.
• Helped in maintaining an TEMPeffective documentation process to track the version control and requirement changes.
• Designed the PL/SQL Procedures to load data from Flat files and Oracle into the target Oracle database.

Environment: Oracle 11g, SQL, PL/SQL,SQL Loader, TOAD, Explain Plan, UNIX andODI.

Confidential - Redmond, WA

Team Lead, Senior Oracle Developer

Responsibilities:

• Generated SQL and PL/SQL scripts to install building database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms with oracle 10gdatabase.
• Created complex functions, stored procedures and packages by using PL/SQL.
• Participated in Designing databases (schemas) to ensure dat the relationship between data is guided by tightly bound Key constraints.
• Responsible working with user groups, analyzing reported problems, performing root cause analysis and presenting alternatives to correct the problem.
• Developed back end interfaces using PL/SQL packages, stored procedures, functions, Object Types, Pipelined functions, Oracle queues and used Collections, Bulk Collects to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Wrote complex SQL queries using Joins, sub queries and inline views to retrieve data from the database.
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Involved in Dimensional modeling and developed the star and snowflake schemas.
• Designed and developed complex reports to meet end user requirements and deployed.
• Developed complex triggers in reports before/after for validation of user input.
• Performed unit testing and supported integration testing and end user testing.
• Extensively worked on production issues with TEMPeffective defect management.
• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
• Developed SQL’s for loading data from feed file to staging tables.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using tools like EXPLAIN PLAN etc.
• Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.

Environment: Oracle 11g, SQL, PL/SQL,SQL Loader, TOAD, Explain Plan, UNIX.

Confidential

Team Lead, Senior Oracle Developer

Responsibilities:

• Involved in Data modeling activities for ADP Payroll project.
• One time migration of initial data to ADP using SQL Loader.
• Worked on Performance Tuning using Parallel Queries.
• Create SQL Views for transformation tables, so dat same can be used in the data extraction scripts.
• Development of PL/SQL Procedures for loading target tables using field mapping document.
• Build the code based on the requirements and develop middleware layer to provide data to ADP Global View. It is proposed to route data from all the source applications to GV through GIF. And similarly route all data from GV to downstream applications through GIF. New interfaces would be developed & deployed to facilitate this data interchange.
• Responsible for Handling Development Database Issue.
• Prepare Low Level Design (LLD) document based on the mapping document and Data Model on.
• Handled Development Database Issues.

Environment: Oracle 11g, SQL, PL/SQL,SQL Loader, TOAD, Explain Plan, UNIX.

Confidential

Team Lead, Senior Oracle Developer

Responsibilities:

• Interacting with Business users, gathering and analyzing requirements.
• Created system design document with high-level design and requirement document. Conducted walk through for requirement and system design.
• Created and modified SQL, PLSQL and SQL*Loader scripts for data conversions to load data from flat files into oracle interface tables.
• Developed SQL Queries to fetch complex data from different tables from different databases using database links and inserted the results into the newly developed tables.
• Created views, materialized views and synonyms for developers to hide the complexity and secure the direct access of DB Tables.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL asper the Design Documents.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, hints, indexing and Partitioning of tables.
• Worked on Data Modeling tool which includes both Logical and Physical Models.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*Plus, Toad, PVCS, Load Runner, SQL Loader, Unix.

Confidential

Senior Oracle Developer

Responsibilities:

• Validating existing data against given requirements, generating data exception report and sending it back to business teams for correction. Loading of corrected data from excel to staging tables Involved in regular code inspection and optimizing code.
• Used SQL Loader to load bulk data from various flat files.
• Developed design documents and Packages & Stored Procedures.
• Checking front end application, if migration process was successful.
• Involved in Queries Tuning, with the halp of Explain plan.
• Analyzed business requirements and developed design documents (Class diagrams and Sequence diagrams) and Packages & Stored Procedures.
• Master data is uploaded using direct file access in stored procedure to increase the performance of the application.
• Involved in regular code inspection and optimizing code.
• Extensively worked on fixing defects and handling new change requests.
• Provide support to the Internal Testing, SAT and UAT Team.

Environment: Oracle 10g, Toad, SQL Loader, Edit plus, CLARIFY CRM, UNIX.