SUMMARY

• Over 8 years of Strong IT experience as a technical and functional analyst/programmer in Designing, Development, Implementation of Oracle Applications R12 (Oracle Financials (OM, INV, AR, AP, GL, PO) Conversant in RICEW components and production support.
• Experience in the full System Development Life Cycle (SDLC) with understanding of a variety of technologies and platforms such as web, client/server, entity - relationship diagrams (ERDs), relational database concepts and object-oriented programming
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Excellent conceptual knowledge of Oracle 11g, PL/SQL and SQL.
• Rich experience in writing SQL queries, Views, Materialized views, PL/SQL, functions, procedures, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Developed UNIX scripts to save Oracle concurrent program outputs and sending them as an email attachment.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Expertise in loading data from legacy systems using SQL*Loader.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shells scripting, SQL, PL/SQL and SQL Loader.
• Extensively worked in developingtechnical documents (MD70).
• Strong interpersonal skills, ability to interact with people Confidential all levels. Good communication and presentation skills

TECHNICAL SKILLS

Oracle Applications: Oracle Applications Release 12i, 11.5.4 to 11.5.10 Oracle Financials (GL, AR, AP)

Application Tools: Reports 6i, Forms 10g/6i, Discoverer 10g/4i, XML/BI Publisher, Oracle Enterprise Manager (2.1.0).

Databases & Tools: Oracle 11g, TOAD, SQL*PLUS, SQL* Loader.

Scripting Languages: Unix Shell scripts, K shell, C shell.

Languages: C, C++, JAVA,SQL,PL/SQL, XML

Operating System: Sun Solaris, Unix, Linux, Windows 8/7/XP

PROFESSIONAL EXPERIENCE

Confidential

Oracle EBS Developer

Responsibilities:

• Worked in Oracle backend objects like:Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.
• Extensively involved inSQL tuning, troubleshooting, debuggingand fixing the code and made the changes according to the new business requirements.
• Registered theConcurrent Programs, Forms, Reports and Requests Sets inAOLand System Administration.
• Customized formsusingcustom.pllto change the functionally of the standard forms.
• Worked on theBudget Upload Open Interfaceto load the data from legacy systems to theGL Budget Interfacetable usingSQL*Loader.
• Involved in theanalysisof the assignedsupportticketsincluding replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.
• Developed custom forms to perform tasks such as creatingWIPjobs, updatingWIP jobs, performingWIPmoves and making material transactions via writing to the appropriate interface tables and then calling the concurrent manager which processes the interface tables.
• CustomizedSales Order formto add customer fax, email and phone number contacts.
• Customized the existing forms with descriptiveflex fields.
• Work on the development activities as part ofissueresolution. Perform Unit Testing, migrate to next environments, assistusertestingand closing thetickets.

Environment: Oracle 11g, PL/SQL, Oracle Apps R12/11i (11.5.10) Oracle Financials (OM, INV,AR,AP,GL,PO), XML/BI Publisher, Forms/Reports 10g, Toad, Windows7, Linux.

Confidential

Oracle EBS Developer

Responsibilities:

• Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
• Involved in data modeling team for identifying tables and relations between them.
• Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Designed and developed various custom packages triggers and forms.
• Converted open purchase orders from legacy system to Oracle Purchasing using SQL* Loader, PL/SQL, Packages/Procedures
• Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQL and import items program.
• Developed various reports ‘Customer Statement of Account’, ‘Core Debit memo’ and AR Invoice Report.
• Involved in implementing Order to Cash (O2C) cycle and P2P cycle.
• Worked on Internal Requisitions, Internal Sales Orders, and Drop Shipment process in Purchasing, Order Management applications.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
• Involved in integration testing.
• Debugging and Fixing Production Data.

Environment: Oracle 11g, PL/SQL, Oracle Apps R12/11i (11.5.10) Oracle Financials (OM, INV,AR,AP,GL,PO), XML/BI Publisher, Forms/Reports 10g, Toad, Windows7, Linux.

Confidential, Irvine, CA

Oracle Developer and Analyst

Responsibilities:

• Lead the upgrade process of Oracle Forms and Reports 6i to 10g including the setup of the 11g Oracle Development environment.
• Built custom reports using Report 6i to solve the client’s reporting needs.
• Upgraded 6i client server Oracle Forms and Reports application to web based 10g and ran the application through Oracle Portal and Single Sign-on.
• Assisted in setting up the Forms and Reports Services on standalone 10g App Server.
• Assisted in setting up the Forms and Reports Services on standalone 10g App Server.
• Designed and developed Web-enabled Oracle Forms & Reports. Including Forms based on stored procedures.
• Developed interface programs to import parts information to inventory base tables.
• Converted open purchase orders from legacy system to Oracle Purchasingusing SQL* Loader, PL/SQL, Packages/Procedures
• Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQLand import items program.
• Developed in development of shell scripts to send invoices to customer through mailing.
• Developed procedures, functions, triggers,andpackagesfor validation and loading of data into target table based on the current requirement.
• Designed and developed various custom packages triggers and forms.
• Extensively usedfor allandbulk collectto fetch large volumes of data from table.
• PerformedSQL and PL/SQLtuning and Application tuning using various tools likeTKPROF, AUTOTRACE and DBMS SQLTUNE
• Developed performance Tuning to enhance the quality for all current and future code development using hints for SQL for determining instance and I/O efficiency, and using TKPROF.
• Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning and coding standards.

Environment: PL/SQL; SQL; SQL*Plus; Oracle 11g; Oracle Forms 10g; Sun Solaris Unix; Windows 7; TOAD; Oracle Portal, HTMLDB; Oracle Reports 10g, 6i;

Confidential

Technical Consultant

Responsibilities:

• Analyzed, designed, modeled, and implemented new database schemas.
• Responsible for creation of Data Clean-up procedures, transformations, Scripts, Stored Procedures and execution of test plan for loading the data successfully into the targets
• Involved in designing database architecture and technical documents for better understanding the relations, associations and dependencies within the application.
• Designed and developed OraclePL/SQLProcedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Performed Unit Testing and Integration testing for the ETL's.
• Oracle Back-endSQL,PL/SQLDevelopment i.e. ComplexSQLQueries containing hundreds of LOC, Views, Packages, Stored Procedures, Functions & Triggers.
• CreatedPL/SQLprogram units to include DML, DDL statements using DynamicSQL.
• Coordinated and collaborated with the solution delivery teams in onsite/offshore to ensure project deliverables and timeliness are met
• Periodically appraised client and internal management about the health of the project

Environment: Oracle 11g,SQL/PL/SQL, Toad, Windows7, Linux,PUTTy.

Confidential

Oracle Developer

Responsibilities:

• Developed user documentation for all the application modules. Also, responsible for writing test plan documents and unit testing for the application modules.
• Createdstored proceduresand functions to support efficient data storage and manipulation.
• Created/ reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Implemented security by creating User logins,Rolesand granting Users access to the database according to their role.
• UsedUTL JOBto automate the plsql procedures and packages.
• DevelopedMaster Detail reportsin Reports 6i to meet the requirements of end users within the system.
• PerformedSQL and PL/SQLtuning and Application tuning using various tools likeTKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Environment: Oracle 9i,SQL Server 2000, Windows 2003,UNIX, SQL,PL/SQL, Confidential -SQL, SQL Loader, Visio and SQL Navigator.

Environment: Oracle 10g,PL/SQL, SQL*Plus, SQL, SQL*Loader, Reports, TOAD.