Professional Summary:

• Having 7+ years of Experience in ERP Experience including Developing, Customizing, Designing, Testing and Implementation of Oracle Financials and Manufacturing modules.
• Proficient Experience in General Ledger, Accounts Payables, Accounts Receivables, Purchasing, Order Management, Inventory, AOL and System Administration.
• Good Knowledge on Oracle Bill of Materails and Oracle Configurator.
• Expertise in SQL* Plus, PL/SQL, Reports6i, Discoverer & XML Publisher.
• Experienced in data conversions and Migrations using Interface tables and APIs from Feeder and Legacy systems to Oracle Application 11i suite.
• Involved in development of RICE components using SQL, PL/SQL, Developer 2000, XML Publisher as per Oracle Applications coding/
• Customization/ User Interface standards and Coding techniques in Oracle Applications. Expertise in System Administration and AOL. Designed and
• Developed complex and reports using Reports 6i/Discoverer4.1/10g

• System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
• Developed Loader Control scripts for different conversions and interfaces using SQL Loader.
• Worked-on customizing various Oracle Forms6i with Template.fmb.
• Good experience in using Application ImplementationMethodology (AIM)
• Involved in all phases of Software Development Life Cycle.
• Proficient in functional knowledge of Order to Cash, Procure to Pay and Financial business processes with order to cash(O2C), procure-to-pay(P2P) and END-END cycles of Oracle Applications E-Business Suite and accounting-to-financial reporting functions. This helped a lot to bring effective processes in place, reduce costs with less headcount and make the process more efficient for clients.
• Extensively used TCA (Trading Community Architecture) to create customers in Oracle Receivables.
• Excellent interpersonal, communication skills and understanding of Business applications. Willing to take up challenging assignments and interested to work in different kinds of modules and emerging technologies.

Technical Knowledge:

ERP ORACLE R12, 11I E-BUSINESS SUITE Releases 11.5.4, 11.5.9, 11.5.10.2.
Modules PO, AP, INV, AR, OM, GL, FA.
Languages PL SQL, Java, HTML, XML.
GUI Tools Developer 2000 (Forms 6i & Reports6i).
Reporting Tools XML Publisher, Discoverer 4i/10g.
Other Tools SQL * Plus, SQL*Loader, Data Loader, Toad,OBIEE
Database Oracle 8i, 9i
Methods Oracle AIM for Documentation and Test Scripts preparation
Configuration
Management and
Versioning tools CVS, PVCS.

Professional Experience:

Confidential | Technical Consultant | Jun2011 to till date
Confidential | Senior Software Engineer | Mar2010 to May 2011
Confidential | Technical Consultant | Feb 2007 to Mar2010
Confidential | Technical Consultant | Sep2005 to Feb2007

Client: Confidential, Feb 2012-till date
Role: Oracle Apps Technical Consultant

Project Description: Confidential, headquartered in Lake Success, New York, is a leading provider of consumer, business-to-business, and industrial digital imaging solutions. Now that OCE is part of the Canon Group, Canon combining resources, technology and capabilities to create a new power in the print industry. Canon and OCE will be able to streamline print workflow, improve color management, deliver on form-feed capabilities, and meet the changing needs of a continuously evolving marketplace.

Responsibilities :

• Developed a new conversion script for Item on-hand quantities to import on-hand from OCE Legacy System.
• Developed a new inbound interface for importing the ship confirm data from WMS (DBSchenkar) legacy system to oracle applications using pick confirm and ship confirm API's for supplies orders.
• Developed a new inbound interface for proof of deliveries for supplies orders.
• Developed a Onhand Daily Inbound Bump Report.
• Developed a new inbound interface for importing all inventory adjustments from legacy system(DBSchenkar) to oracle apps base tables.
• Developed new conversion script to upload customers from OCE to Canon using customer API's
• Responsible for collecting business requirements for new conversion and Interfaces converted them into Functional and technical design documents.
• Unit and System Testing of Data migration units developed.

Environment: Oracle Apps 11i, INV, OM & AR, PL/SQL, Interfaces, Reports and Conversions.

Client: Confidential, Jul 2011- Feb2012
Role: Oracle Apps Technical Consultant

Project Description: Confidential, is one of the leading metals processors and distributors in North America. With multiple locations conveniently located throughout North America, Macsteel Service Centers USA offers one of the largest inventories of metals in the service center industry. Macsteel processes and distributes carbon, stainless, aluminum and specialty metals to customers throughout North America and Puerto Rico.
Macsteel is proud of its 100-year heritage serving the metals industry. We credit our dedicated employees, loyal customers and suppliers for making us ranked among the ten largest metals service centers in North America. Macsteel enjoys a legacy of commitment and dedication to the metals industry and we look forward to providing another century of superior customer service.

Responsibilities :

• Developed a Macsteel Customer Listing Summary Report
• Developed a Customer Invoice Report
• Developed a Macsteel RMA Receiving Report
• Writing the Queries in EBS for developing the Report in OBIEE.
• Implement the XMLBURSTING Functionality
• Preparing analysis and design documents.
• Implementation/Go-Live support & Knowledge Transfer.

Environment: Oracle Apps R12, INV, PO, OM, PL/SQL, Reports 6i,XML Publisher & obiee Reports

Client: Confidential, Mar 2010-May 2011
Role: Oracle Apps Technical Consultant

Project Description: The Indal IT project intends to implement Oracle R12 as a common ERP tool across its units (that currently use different tools ) to achieve standard business processes and reduce operating costs .This is a global roll out for 300-400 users for Indal spanning the following business processes:-
Planning , Finance ,P2P , O2C, Manufacturing, ASCP ,Oracle quality and Approvals.
The project will have a global design and build phase followed by three deployment phases as below:-
Phase2: Netherlands, Belgium, Germany, Spain, Portugal, UK
Phase3: France, Saeta
Phase4: Czech Republic, Poland, Brazil, China

Responsibilities

• Developed new interfaces on oracle configurator importing the non bom nodes and configuration rules.
• Developed outbound interface for sales orders.
• Developed the interface on bill of materials for importing the bom items, option classes and bom structure to oracle application.
• Involved in Unit and System Testing of Data migration units developed.
• UAT support related to migrated Data sanctity checks.

Environment: Oracle Apps R12, INV, PO, ORACLE CONFIGURATOR, BOM, PL/SQL, Reports 6i.

Client: Confidential, Aug 2009 - Mar 2010
Role: Oracle Apps Technical Consultant

Project Description: Cisco is undertaking Salesforce.com Implementation Program for supporting its TAC processes and it intends to implement it in various phases to create a customer support platform:
This has been implemented in 2 major releases - Mercedes and Bentley
Mercedes - Limited customer, Limited users and standalone implementation.
Bentley - Full Integrated and fully functional solution.
Business Benefits
Current TAC application is not flexible enough to adapt to changing business requirements and perceived as rigid- migration to Salesforce.com will make it adaptable to business needs
Migrating to Salesforce.com will also help keep the platform on the latest version always while taking away ownership of infrastructure maintenance of functionality.

Responsibilities

• Development of concurrent program to extract data from the C3 Oracle database to .csv files to be loaded into the SFDC legacy data base by using UTL_FILE.
• Preparing analysis and design documents.
• Problem identification, analysis and resolution independently from offshore.
• Unit and System Testing of Data migration units developed.
• UAT support related to migrated Data sanctity checks.
• Implementation/Go-Live support & Knowledge Transfer.

Environment: Oracle Applications 11i (11.5.10), OM, SRM, ORACLE 9i, PL/SQL.

Client: Confidential, Oct 2007 - Aug 2009
Role: Oracle Apps Technical Consultant

Project Description: C3 is an application widely used by worldwide customers and Customer Support Executives in Cisco to server Cisco customers. If customers or CSE faces an issue with the application an alliance case is opened with the CACO support team who then analyses the issue and resolves if its customer training or data issue. If the issue turns out to be a Bug or and Enhancement request then Support person created an I2R. This holds good for CSE and Business as well.

Responsibilities

• Based on the customer requirements, created the technical and unit test plans.
• Involved in unit testing, integration testing, system testing.
• Involved in Production support for Reports and developed change request technical documents..
• Resolved issues in custom packages.
• Analyzed all I2R's provided solutions and captured in the technical design document.
• Prepared the Technical Design and UTP documents
• Developing Code, Bug Fixing and Testing.
• Coordination with users during UAT and getting signoff from them.
• Worked on Complex I2R'S related to pl/sql and all modules (OM,PO,INV)

Environment: Oracle Applications 11i (11.5.10), OM,INV, PO, ORACLE 9i, PL/SQL, Reports 6i, UNIX.

Client: Confidential, Jun 2007 - Sep 2007
Role: Technical Consultant

Project Description:Office Depot Inc., founded in 1986, is one of the world\'s largest sellers of office products and an industry leader in every distribution channel, including stores, direct mail, contract delivery, and Internet and business-to-business electronic commerce.
Corporate Office located at Delray Beach, Florida, USA.

Responsibilities

• Participating in meeting with functional team and assist in good design(in terms of feasibility and alternate approaches)
• Creation of Delivery Documents including Migration document.
• Responsible for managing the process for code migration to different instances.
• Assisting the other team members in Developing Complex Reports.
• Development of New Discoverer Reports using discoverer Desktop edition 10g and discoverer plus.
• Register the discoverer Reports in oracle applications

Environment: Oracle Applications 11i (11.5.10), AR, FA, ORACLE 9i, PL/SQL, Discoverer10g, XML Publisher, UNIX.

Client: Confidential, Mar 2007 - May 2007
Role: Technical Consultant

Project Description:Level 3 is an international communications company headquartered in Broomfield, Colorado. The company operates one of the largest communications and Internet backbones in the world.

Responsibilities

• Responsible for completing the assigned work in time
• Involved in performance tuning.
• Responsible for managing the process for code migration to different instances.
• Responsible for following the development standards as per the project.
• Creation of Final Delivery Package zip files.

Environment: Oracle Applications 11i (11.5.10), OM, INV, PO, AR, ORACLE 9i, PL/SQL, Reports 6i, Forms6i, UNIX.

Client: Confidential, Aug 2006 - Feb 2007

Project Description:This is an Oracle Applications implementation Project. Oracle Applications 11.5.10 is implemented to cover the business of client. This client is in the Implementation of all Financials, Manufacturing and HRMS modules. As a Technical consultant has been involved in the areas of Customizing the Reports and Interfaces.

Responsibilities

• Responsible for completing the assigned work in time
• Preparing technical designs.
• Responsible for managing the process for code migration to different instances.
• Responsible for following the development standards as per the project.

Environment: Oracle Applications 11i, OM, INV, AR,ORACLE 9i, PL/SQL, Forms 6i, Reports 6i, Discoverer4i, UNIX.

Client: Confidential, Sep2005 - Aug 2006
Role: Developer

Project Description: Ventana Medical Systems is the world\'s leading supplier of automated diagnostic Systems to the anatomical pathology market. Their customers consist of hospital-based histology labs, Independent reference labs, medical research centers, and drug discovery laboratories of the largest Pharmaceutical and biotechnology companies in the world.

Contribution

• Involved in Development of Forms & Reports.
• Developed PL/SQL Scripts, Procedures, Functions and Triggers.
• Involved in testing
• Carried out Integration, Regression, Validation and Functional Testing in different Modules.

Environment: ORACLE 9i, PL/SQL, Forms 6i, Reports 6i.

Education & Certification:

• First class Masters Degree in Computer Applications