SUMMARY:

• 7+ years of experience as an ETL developer in Analysis, Design, Development and Customization of Business Application using Oracle Relational Database Management Systems.
• 4+ years of experience using ODI 10/11g for composing teh corporate BI.
• Experience wif Software development life cycle (SDLC) process - performing detailed analysis, collecting requirements, documenting requirements, coding and unit testing, integration and system integrating.
• Good programming knowledge in Oracle 10g/9i/8i
• Created ODI various interfaces for loading teh data from SAP & PeopleSoft to Data mart.
• Strong skills in Oracle including SQL, PL/SQL.
• Proficient in Oracle tools and utilities for Extracting transforming and Loading (ETL) such as TOAD, SQL*Loader, SQL*Developer and UTL FILE.
• Expertise in ETL Tools like Informatica Power Center, Power mart.
• Experience in ETL methodology in data extraction, loading and transformation using Informatica and ODI tools and testing data load performance from ETL mappings and workflows.
• Experience in performance tuning sessions/workflows, target, source and mappings
• Carried out common tasks wif Oracle ODI interfaces and graphic modules
• Knowledge in UNIX Shell scripting.
• Tuned SQL queries and performed database design leading to significant improvement in system response time and efficiency.
• Client handling skills and proven experience.
• In addition to excellent technical abilities possesses strong oral and written communication skills, analytical and interpersonal skills.

TECHNICAL SKILLS:

Databases: Oracle 10g/9i/8i/8/7.x

ETL Tools: Oracle Data Integrator 10/11g (ODI), Informatica PowerMart 4.7

Tools: SQL*PLUS, SQL LOADER, SQL Navigator, TOAD, SQL*Developer

Languages: C, C++, Java, SQL, PL/SQL.

Operating Systems: Windows XP/NT/2000, UNIX, Linux, MS-Dos.

Version Control: SVN, PVCS, ClearCase 3.2

Web: HTML, XML, XSLT

PROFESSIONAL EXPERIENCE:

Confidential, New York

Senior ODI Developer

Responsibilities:

• Involved in Oracle 11g database development by creating Oracle PL/SQL Functions, Procedures.
• Installed and configured ODI 11g, Informatica 4.7.2, & Oracle 11g in teh Windows environment.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out teh projects.
• Developed various transformations for adapting to teh result Oracle database using teh Oracle Data Integrator (ODI).
• Integrated data from Excel, SQL Server, MS Access & Oracle through ODI (Oracle Data Integrator).
• Involved in data modeling and database design.
• Transported Data into Staging Schema through ODI tool.
• Created various Oracle Reports and Oracle Forms.
• Prepared solution presentation for review.
• Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
• Developed Test scripts, test documents and Technical documents.

Environment: Oracle Data Integrator 11.1.1.5, Oracle Applications R11.5.10 (AP, AR, GL, OM), Oracle 11g,, SQL, PL/SQL, SQL*LOADER, Reports 10g, Forms 10g, TOAD, XML Publisher, Windows 2000 & UNIX

Confidential, Owings Mills Marylan

ODI Administrator/Developer

Responsibilities:

• Installed and configured teh Oracle Data Integrator (ODI) Setup.
• Interacting wif Business users, gathering and analyzing requirements.
• Analyzed and reviewed teh Business Requirements and System specification documents.
• Involved in design of logical and physical data model of teh components.
• Writing complex SQL queries to extract data from various source tables of data warehouse.
• Supported wif creation of fact tables and dimension tables for star schema using dimensional modeling.
• Constructed Oracle ODI interfaces Replication, Transformation, customization of knowledge modules and handling models.
• Loading data from flat files into to database tables using SQL* loader.
• Used features like PL/SQL Record inserts & updates of Oracle 9i.
• For Optimization Process, actively involved in performing database capacity planning, created materialized views, partitions, tables, views, indexes etc as. Tuned and optimized SQL statements.
• ODI Designer is used for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Used ERWIN for Logical and Physical database Modeling.
• Involved in Extracting data from various Data sources through different phases and placing teh required data in teh Test Database using SQL.
• Responsible for coding, debugging and maintaining quality standards set by management.
• Attended Design meetings and Q3 code review and test review meeting before checking code into CVS.
• Attended status meetings and technical meeting wif Developers from various other application and DBA to discuss bottlenecks in teh systems and potential.

Environment: Oracle Data Integrator 10.1.3.x, Windows NT, Oracle database 9i, Forms 6i, Reports 6i, TOAD, SQL*Loader, Erwin

Confidential, Fort Worth, TX

Oracle Consultant

Responsibilities:

• Analysed teh business requirements of teh project by studying teh DD document.
• Involved in database modelling and database design.
• Prepared program specifications for PL/SQL procedures and functions to do teh data-migration and conversion.
• Worked on Database Schema design and User Interface screens. Designed ER diagram of database using ERWIN.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Involved in database development by creating Oracle PL/SQL.
• Involved in database priming which would update teh eligibility tables wif teh most current data.
• Run batch jobs for loading database tables from flat files using SQL*Loader.
• Involved in Unit testing and Integrated testing.
• Participated in performance tuning using Explain Plan and TKProf.
• Created Unix Shell scripts for automating teh execution process.

Environment: Oracle 9i, Informatica Power Center 7.0, SQL, PL/SQL, SQL*Plus, SQL*Loader, UNIX

Confidential, Charlotte, NC

SQL Developer

Responsibilities:

• Executed requirement analysis, documentation and Schema updates.
• Created and executed sql queries to retrieve & manipulate teh data, using Pl/SQL Stored Procedures, Partition and Functions.
• Worked wif SQR forms & Reports.
• Extensively worked wif Business team related to manage care issues.
• Hands on experience wif Oracle Tuning, explain plan and TKPROF. Used cost base tune extensively.
• Extensively used Oracle forms and reports using Oracle 6i/9i/10g. Generated forms and Report in XML, PDF and HTML format.
• Worked wif Rational clear case atria.
• Extensively used ETL tool.
• Migrated MSSQL procedures to Oracle (T-SQL to PL/SQL).
• Used SQL *Loader for loading/manipulating teh data in flat files.
• Using MS-Excel and MS-Word Prepared Translation/Mapping & Reconciliation Document b/w source and target.
• Used MS-Access for Staging, imported data from flat files and then Exported to Oracle 9i/10g.
• Worked wif Oracle 9 RDBMS as well as flat database. Created Oracle Objects like tables, functions, packages, triggers etc.
• Extensively used script in UNIX, shell scrip, java script and PL/SQL.
• Extensively used object oriented concepts of C++ and Java in developing PL/SQL functions and procedures.
• A specialist in working wif ERWIN for data modeling purposes.
• Oracle supplied packages were extensively used.

Environment: Windows XP/2k, Oracle 9i/10g, SQL, PL/SQL,ETL, Oracle database, TOAD 8.0, SQL*Loader/Import/Export, MS-Access, MS-Office.

Confidential, Owings Mills Maryland

Oracle Developer

Responsibilities:

• Involved in analysis, Design, Development phases of teh project.
• Involved in walkthrough sessions wif business users during Analysis and Designing phase Writing PL/SQL Stored Procedures, Functions and Packages to meet teh business requirements.
• Writing SQL reports and scheduling these reports from UNIX scripts.
• Worked on performance issues and used EXPLAIN PLAN for tuning teh queries
• Worked wif SQL*Loader for bulk load processing.
• Involved in code walk through and review sessions wif teh development team.
• Involved in teh migration project to load data from mainframe systems into oracle database.
• Involved in developing data conversion programs using SQL *Loader, PL/SQL and UNIX shell scripts.
• Developed Master Detail reports in Reports 6i to meet teh requirements of end users wifin teh system.
• Developed data entry forms, complex and template forms in Forms 6i.
• Creation of Pop-up Menus and maintaining Master Detail relation-ship.
• Used various LOVS (List of Values) and record groups at various points in runtime.

Environment: Oracle 9i, Sql *Loader, Forms 6i, Reports 6i and Linux