SUMMARY

• Results oriented IT Professional over 11+ years of experience with expertise in design, analysis, development, testing, and implementation of Oracle E - business Suite applications11i/R12 using Oracle Relational Database Management Systems (RDBMS).
• Implementation and technical expertise in Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Extensive experience in writing stored procedures, triggers and very strong in PL/SQL.
• Having good Experience materialized views for data replication in distributed environments
• Expertise in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables and Dynamic SQL, Collections and exception handling.
• Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace and TKPROF utilities and Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes, PowerShell scripting, Performance Tuning.
• Implemented SQL*Loader to load data into tables and also used Dbms Utility package.
• Experienced in Performance Tuning and analyzing using TKPROF, SQL Trace, and Explain Plan
• I have experience on Oracle EBS (11i/R12) Oracle Financial and Supply Chain Distribution (SCM) Manufacturing: Accounts Payable s (AP), Account Receivable (AR), General Ledger (GL), Fixed Assets, Order Management (OM), Oracle Inventory (INV), Oracle Purchasing (PO), HRMS.
• Extensive Experience in Oracle Business flow in Order to Cash (O2C) and Procure to Pay (P2P)
• Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, UAT, Cut-Over and Project Coordination activities.
• Experience in designing, developing, implementing and customizing RICEFW (Reports, Interfaces, Conversions, Extensions, Forms and work flow) Components.
• Technical Skills include SQL, PL/SQL, Forms 6i/10g, Reports 6i/10g, Form Personalization, Oracle Discoverer, XML/BI Publisher, Conversions, Data Migration, SQL*Loader, Interfaces for Cross-System Integration and Oracle APIs.
• Expertise in bug fixing and interacting with oracle support, and experience in designing and developing inbound and outbound interfaces for Oracle Applications.
• Strong programming experience in creating Procedures, API, Packages, Functions, Triggers, and other database objects using SQL and PL/SQL also extensive experienced in fine-tuning code for better performance.
• Have good experience in Data mapping between source systems and Target systems for ETL coding.
• Self-starter, result-oriented team player with an ability to manage multiple tasks simultaneously.

TECHNICAL SKILLS

• C
• C++
• JAVA
• SQL
• PL/SQL Developer 2000 (Reports 6i/10g
• Forms 6i/10g)
• Work flow
• Unix Shell Script
• Oracle Applications 11i
• R12
• Oracle Financial GL
• AP
• AR
• PO
• INV
• OM
• Oracle Distribution/Supply Chain/Manufacturing (INV
• PO
• OM
• BOM
• WIP iStores
• Advanced Pricing)
• Oracle BI/XML Publisher
• Oracle
• Mongo DB
• TOAD
• SQL*Loader
• PL/SQL Developer
• Kintana
• Clear Case
• Mercury QA
• PUTTY
• Data loader
• SQL*Plus

PROFESSIONAL EXPERIENCE

Confidential, TX

Oracle Developer

Responsibilities:

• Discussing the requirements with business partners and preparing the high level design for the business changes and review with business users and get the approvals for the high level design document.
• Develop complex search SQL queries based on the business requirements. Troubleshoot the long running queries in production and tune the scripts after review AWR reports.
• Create low level design document on the basis of the high level design derived from requirements.
• Develop the code based on the low level design document and follow the coding standards and test the code. Correct the errors by making appropriate changes and then rechecking the program to ensure that the desired results are produced.
• Perform design and code reviews to ensure high-quality deliverables.
• Created new objects: PL/SQL procedures, functions, and packages for data population and manipulation as per user requirements.
• Created new tables and indexes for Source of wealth
• Worked on data mapping between source systems and target systems and closely worked with Abinitio team.
• Closely worked with business team and provided profiling results for them from large database.
• Developed complex search queries and tuned the queries to improve the performance.
• Discussing with offshore team on the project requirements and assigning work to team.
• Preparing and executing unit test cases and provide support for User Acceptance Testing and System Integration testing. Resolve UAT issues and production issues on specified SLA tracked through HP Quality Center tool.
• Working on the ad-hoc requests from different lines of business (Retail Banking, Brokerages and Cards).
• Working on deployment activities to deploy the code in production through DBA and validate the code in production.
• Working on the critical production issues and modify the production code in lower environments and deploy in production after proper testing. Ensure documentation of problems received and resolution method identified. Provide RCA (Root Cause Analysis) of each issue.
• Conducting knowledge sharing sessions and attending internal programs.

Confidential, Seattle

Oracle Apps TechnoFunctional Consultant

Responsibilities:

• Analyzing the Business Requirements and System Specifications to understand the application.
• Coordinated and documented detailed gap analysis between client requirements and Oracle R12 functionality.
• Worked with oracle team for CEMLI objects.
• Modified PL/SQL procedures, functions, and packages for data population and manipulation as per user requirements.
• Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries)
• Worked on Customized objects.
• Wrote PL/SQL packages for different validations, for processing data in order to create valid POs and Receipts to populate the PO interface tables and invoked seeded import programs to populate the base tables.
• Worked on custom objects
• Created custom reports, forms, packages, workflows.
• Understand the different types of parts (Expendables, Rotables and Repairable) which are using in the aircraft.
• Good working knowledge of PL/SQL and UNIX in Production Support.
• Working closely with appropriate Boeing personnel for effective problem resolution.
• Created the reports as per client requirement.
• Created new supplier setups.
• Creating Customers, Profile Classes & Bank information.
• Involved in preparing Test plan and Test cases and regressive testing in all the phases.
• Created test cases for different test scenarios.
• Participating in the analysis and design of various reports and forms using OBIEE, XML/BI Publisher, Oracle Discoverer and Reports and Forms.
• Created different types of invoices in Account Payables and tested the customized reports.
• Created Security profiles as per client requirements.
• Created the recurring generals (formula and Skelton journals) in GL module.
• Involved in developing the auto lock in Account Receivables.
• Analyzing and resolving the functional and technical problems raised by the users on Order management, Inventory and purchasing modules, Account receivables and Payables.
• Resolved the customer facing issues in finance modules.
• Designed, Created and Tested Reports in the Dashboard and created the adhoc report according to the client needs.
• Tested the application end to end cycles (P2P and O2C cycles) and created defects in QC.
• Every week providing the test execution status to the client.
• Helped the end user while doing UAT
• Have experience in opening, managing, and resolving Oracle TAR's with Oracle Support/ Metalink.
• Involved in solving the post production issues.

Environment: Oracle Applications R12 Financial/Supply Chain (OM, PO, INV, QP, AP, AR, TCA, GL, EBTAX), Oracle, Toad 8.0.0.47, Reports, Forms, XML/BI Publishers, UNIX, SQL*Plus, Windows XP, VSS

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Created and modified severalUNIX shell Scriptsaccording to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.

Environment: SQL,PL/SQL, Oracle Applications R12 Financial (PO, AP, GL,SLA), Oracle, Oracle SQL Developer tool,Toad 8.0.0.47

Confidential, Chicago, IL

Oracle Apps Techno Functional Consultant

Responsibilities:

• Analyzing the Business Requirements and System Specifications to understand the application.
• Worked on setups for Inventory, Purchasing and Order Management.
• Involved in user requirements gathering, organization setups, filed/attribute mappings, design and development of interfaces, conversions, reports and extensions.
• Validated Setup steps for Inventory like Inventory Organizations, Source Types, Item Templates, Category Sets, UOM, Classes and Conversions.
• Worked on conversions like purchase orders, payable invoices, AR Invoices, vendors etc using APIs/Interfaces
• Participating in the analysis and design of various forms and reports using Oracle Discoverer 10g, Reports 6i,BI/XML Publishers
• Designed and Developed PL/SQL Procedures, Functions and Packages as per client requirement.
• Involved in Development and testing of outbound interfaces and conversions.
• Worked on custom PL/SQL packages, which support functionality of project.
• Develop the code to load rates from external system.
• Involved in System test plan creation based on the requirement and design document.
• Involved in testing at the time of application downtime.
• Resolving the problems related to different interfaces.
• Creating Change Requests to resolve the data fix issues
• Creating Kintana and clear case for change requests.
• Doing set ups in the production for new releases.
• Attending KT calls before releases to production
• Involved in Creation and review of test Scenario and test Case based on requirement and design document
• Tracking the Test Plan/Test Specification vs. Requirements
• Tested the functionality and involved in resolving issues.
• Code Migration by using HP Kintana (Migration Tool).
• Version Control tool by using Clear case.

Environment: SQL,PLSQL,Oracle Applications R12 Financial/Supply Chain (OM, PO, INV, QP, AP, AR, TCA and GL), Oracle, Toad 8.0.0.47, Reports, Forms, XML/BI Publishers, UNIX, PVCS, SQL*Plus, Windows XP, VSS

Confidential, Chicago, IL

PL/SQL Developer/Support

Responsibilities:

• Understanding the production environment, business and different tools and different interfaces used in production.
• Analyzing and resolving the functional and technical problems raised by the users on finance modules and supply chain modules.
• Involved in production code changes (L3 Activities like code change on existing production code)
• Modified the procedures/functions/Packages.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Created automated SQL scripts to monitor the application issues.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Created Indexes on the customized oracle tables for faster retrieval of the data to enhance the data base performance.
• Modified UNIX shell Scripts to fix the issues.
• Interacting with customers on crated issues to know more information about the issues and resolved the issues within SLA.
• Understand the issues and raise change request if it is a code change or functional setup to resolve the issues and work on change request based on the priority of the issues.
• Worked on invoice errors and PO issues.
• Worked on month end close activities to close the period smoothly.
• Involved in the application downtime activities in the weekend and closely worked DBA team.
• Involved in testing at the time of application downtime.
• Resolving the problems related to different interfaces.
• Creating Change Requests to resolve the data fix issues
• Creating Kintana and clear case for change requests.
• Doing set ups in the production for new releases.
• Attending KT calls before releases to production
• Initiating bridge and involving in SRT’s if any critical issue.
• Involved in enhancements

Environment: Oracle Applications R12 Financial/Supply Chain (OM, PO, INV, QP, AP, AR, TCA and GL), Oracle, Toad 8.0.0.47, Reports, Forms, XML/BI Publishers, UNIX, PVCS, SQL*Plus, Windows XP, VSS