SUMMARY

• An Oracle Certified Professional having over 8 years of IT experience in Oracle, SQL, PL/SQL, C++, SQL Tuning, Database Design and Development, ETL, System Analysis under Web - based and Client Server Development and OLAP applications using Oracle8i/ 9i/ 10g.
• Expertise in RICE (Reports, Interface, Conversion and Extension), PL/SQL, Forms, Reports development and customization, Discoverer Reports, Oracle JDeveloper 10g.
• Extensive experience in developing database objects such as Stored Procedures, Functions, Packages, Triggers, Cursor, Ref Cursors, Constraints, Indexes and Data Structures like Graphs, Trees, Views, In-line Views, Materialized Views, Synonyms, PL/SQL tables, Database Links, Export/Import Utilities and user-defined data types.
• Extensively worked on Data Mining, Data Modeling, Normalization and De-normalization of data in various applications.
• Experienced in optimization of SQL query and PL/SQL code using Analyze, Explain Plan, Cross database queries, parallel processing, TKPROF, DBMS STATS and DBMS TRACE and Extract Transform and Load data into target database.
• Strong programming, debugging and analytical skills in C++, PL/SQL, SQL and UNIX shell scripting.
• Expert in using the data query tools for Oracle like TOAD, SQL Developer, FTP, SQL*Loader etc.
• Very good understanding of OOD and OOPS concepts in C++, Java, JDeveloper 10g.
• Effectively used version control softwares such as PVCS, WinCVS.
• Worked with Oracle Database Administrator for Performance Tuning, Storage management and maintenance of databases. (Tablespace, Datafile, table, indexes etc.), Database security (User & Resources, User Privileges & Roles).
• Extensive experience in using database packages such as DBMS SQL, UTL FILE, DMBS OUTPUT, DBMS JOB.
• Well experienced in setting up the applications profiles, creation of users, responsibilities, Request groups, and value sets in Oracle E-Business Suite 11i/10.7/9i.
• Expertise in customization of Oracle Applications by creating/editing Flex fields values, lookup values, registering Forms, Reports, PL/SQL procedures, host programs, etc.
• Excellent in writing technical and functional specification documents.
• Efficiently used Oracle’s Metalink for registering Service Requests to resolve known bugs.
• Good understanding of Eagle Pace Portfolio Management System.
• Experience in all phases of SDLC including requirement analysis, design, coding and development, testing, deployment and post-implementation support.

TECHNICAL SKILLS

ERP Technology: Oracle Applications 11i/10.7

Databases: Oracle 8i / 9i /10g

Tools: TOAD, SQL* Loader, SQL Navigator, Oracle SQL Developer

Operating Systems: Windows 2000/XP, UNIX, Linux

Languages: PL/SQL,C++,Unix Shell Scripts

GUI Tools: Developer2000 / 6i /9i (Oracle Forms and Reports), JDeveloper 10g,Oracle Discoverer 9i AS/10g (Discoverer Administrator, Desktop, Viewer, Plus)

PROFESSIONAL EXPERIENCE

Confidential, NJ

Lead Oracle PL/SQL Developer

Responsibilities:

• Played vital role in Development of automated data transfer and loading applications based on UNIX shell scripts, FTP, job scheduling using crontab and PL/SQL stored procedures for conversion and interfaces.
• Wrote PL/SQL scripts for conversion of retail data such as sales, audit, vendors, AP, Receipts and inventory to run them on daily/on-demand basis.
• Effectively used SQL*Loader and FTP to load data into flat files and upload them onto remote servers.
• Database design and development of data models, indexes, views, materialized views using OOD and OOP concepts.
• Worked as a code reviewer for the peers and played a central role throughout the entire project life cycle.
• Generation of customized status report using PL/SQL Stored procedures.
• Effectively handled performance tuning of SQL queries using Query optimizer.
• Actively involved in Unit Testing and Post-implementation support.
• Involved in creating standard documentations critical to project execution.

Environment: Oracle PL/SQL, SQL, C++, UNIX Shell Scripts, TOAD, FTP, Crontab, Oracle SQL Developer.

Confidential, NJ

Lead Oracle PL/SQL Developer

Responsibilities:

• Played a vital role in Design and Development of various OLAP and OLTP applications for banking transactions.
• Worked as Lead in development of Financial Statement Generator (FSG) Reports, Oracle Reports and Oracle Forms 9i in Oracle Financial modules like GL, AP, AR, FA in Oracle E-Business Suite R12.
• Effectively used Informatica Powercenter 7.1 using tools like Informatica Designer, Workflow Manager, Workflow Monitor and Repository Manager to extract, validate, map, transform and load data from heterogeneous sources like SQL Server, Flat Files, COBOL files to Oracle Database.
• Expertise in creation of SDE and SIL mappings in Informatica Designer and variety of transformations like Source Qualifier, Expression, Aggregator, Lookup Strategy, Joiner, Router etc to transform data from source to ODS (Operational Data Store) and from ODS to large data warehouse.
• Worked as a liaison for the business users located in Japan, UK and all over USA to understand the requirements and convert them into technical specifications.
• Lead various applications by periodic meetings with the team members and tracking the status using Plan View and version control software such as PVCS.
• Designed physical database objects and developed Data Models using TOAD, Erwin.
• Proved to be a responsible resource to handle Data Mining, performance tuning of SQL queries and parallel processing PL/SQL stored procedures using Indexes and optimizing hints.
• Worked as a Discoverer Administrator to manage Security, Privileges and Responsibilities using Discoverer Administrator 10g in Apps and Non-Apps mode.
• Worked with Oracle Corporations Support team to resolve issues and install patches to the applications.
• Proved to be an efficient resource in Conversion of Oracle Financial Services Applications (OFSA) to Oracle Discoverer Reports 10g Rel2.
• Lead the Data Migration effort to migrate GL data into CORONA (third party tool) for GL Reconciliation and batch process by developing PL/SQL script and Unix Shell Script, FTP using SQL Loader.
• Worked as Lead in Migration of Discoverer Reports from 4i to 10g Rel 2 and Discoverer 9i AS to BI Discoverer 10g Rel2.
• Developed adhoc C++ programs using OOP and OOD concepts to design and develop programs for mapping validations.
• Developed Database Links, cross database queries, complex PL/SQL Stored Procedures, packages, functions and triggers to fetch, validate and load data from Oracle database into third-party tool, Corona.
• Worked independently as well as within a team to resolve production support issues.

Environment: Oracle PL/SQL, SQL, C++, Unix Shell Scripts, TOAD, PVCS, PlanView, Oracle 9i/10g RAC, Discoverer Plus / Desktop / Administrator, Oracle Business Objects, Noetix Views, Data Mining, Data warehousing, SQL Loader, Informatica Powercenter 7.1.(Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor)

Confidential, FL

Lead Oracle Developer

Responsibilities:

• Played a vital role in a variety of tasks from Requirement Analysis, design and code development up to Unit testing for OLAP applications.
• Lead database design efforts to design and normalize database tables/views and create materialized views using Data Modeling tools.
• Generated PL/SQL packages with dynamic SQL queries for Oracle Financial modules like GL, AP, AR, FA as per the requirements.
• Troubleshooting the performance issues and data errors of Oracle Reports by optimizing complex SQL queries.
• Worked on development and customization of Oracle Forms/Reports 9i.
• The only responsible resource to effectively analyze, design, develop and implement an automated scheduled concurrent program of data Migration and interface.
• Development of database objects such as views, Indexes, Materialized views, sequences functions and triggers as well as interfaces to invoke standard interface -Customer interface and order import.
• Developed UNIX shell scripts to perform file transfer across different servers, file level validations, record level validations and to send an e-mail to support team for all invalid records using SQL Loader.
• Worked as business analyst understanding business requirements and creating technical design documents
• Developed complex PL/SQL stored procedures to generate customized response file and error file giving the status of the data conversion.
• Unit testing and preparation of test plan documents.

Environment: Oracle 10g, PL/SQL scripts, Oracle Data Migration and conversion in customized format, SQL, PL/SQL stored procedures, Data Modeling, Erwin, Normalization, De-normalization, Interfaces, Unix Shell scripts, FTP, SQL Navigator, SQL*Loader, PVCS, TOAD.

Confidential, OR

Sr. Oracle Developer

Responsibilities:

• Database design and development of data models, indexes, views, materialized views.
• Effectively used SQL*Loader and FTP to load data into flat files and upload them onto remote servers.
• Worked as a code reviewer for the peers and played a central role throughout the entire project life cycle.
• Generation of customized status report using PL/SQL Stored procedures.
• Pro actively worked on designing and deployment of OLAP applications for Oracle 10g.
• Effectively handled performance tuning of SQL queries using Query optimizer.
• Conducted weekly status meetings with the subject matter experts.
• Successfully created various Database Objects such as temporary tables, PL/SQL tables, views, materialized views, Indexes, sequences.
• Helped and mentored the peers for problem solving and optimizing of SQL query and complex PL/SQL procedures.

Environment: Oracle9i/10g, Data conversion as per Organizations definitions, PL/SQL scripts for Post Implementation updates script, WinFTP, TOAD, winCVS, Data structures.

Confidential, UT

Oracle Developer

Responsibilities:

• Responsible for customization of Oracle Reports mainly in Oracle Financials modules like GL, AR, AP.
• Preparation of Technical Design Documents (MD070) from the functional inputs(MD050) from Business Requirement Document (BRD).
• Worked with DBA team to design and develop data models and database objects like tables, views, materialized views, table space and Schemas.
• Created complex PL/SQL stored procedures using Dynamic SQL queries, PL/SQL tables, Temporary tables.
• Developed C++ programs and UNIX Shell scripts to enhance existing applications.
• Designed and Developed complex matrix reports with groups that represents data in a sophisticated tabular format.
• Tuning SQL queries using Trace and Explain Plan and refinement of database design so as to enhance the performance, system response time and efficiency.
• Prepared Technical Design Document, Test plans Issue log and Delivery documents.

Environment: Reports 9i, PL/SQL scripts, Application Object Library (AOL), SQL, PL/SQL, Explain Plan, DBMS TRACE, Data modeling, TOAD, C++

Confidential, NJ

Oracle Developer

Responsibilities:

• Design and Development of PL/SQL Stored Procedures, Functions and packages.
• Extensively involved in Performance Tuning of SQL Queries for OLTP environment using Optimizing hints, DBMS TRACE, plan table, Explain Plan.
• Development of new Database objects like Tables, Views, Synonyms, Materialized Views and PL/SQL Stored Procedures for an On-line Transactions Processing (OLTP ) application.
• Successfully developed custom applications which facilitates end users with various forms for daily transactions and generates monthly reports using Oracle Forms 9i and Reports 9i including need based Adhoc Reports.
• Worked as Discoverer Administrator to manage users, Security, Privileges and Responsibilities.
• Designed dynamic, flexible Discoverer reports for business users so that they can change the layout, view, drill-down of the report as and when the requirements changes without any technical assistance.
• Responsible for generation of monthly status report, progress report, and expenditure report etc. using Reports 9i.
• Requirement analysis and creation of Technical documents (MD60/MD70) from functional documents (MD050).

Environment: Oracle 8i/ 9i/10g, PL/SQL procedures, Development and customization of Adhoc Reports, PL/SQL stored procedures, packages, SQL Query Optimizer.