SUMMARY:

• Oracle Certified Professional (OCP) with experience in design and development of business systems.
• 6 years of experience with Oracle Applications / E-Business Suite(11i & R12) - Performing functional and technical work mainly within the OM, PO, AP, AR, GL, Manufacturing , Inventory, TCA, Advanced Pricing, Bill of Materials, Install Base, CRM, Oracle Configurator Developer.
• Worked in all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support.
• Hands-on experience with Oracle Forms/Reports, SQL, PL/SQL, APIs, BI/XML Publisher and Work Flow Builder
• Developed and maintained custom schema objects (Tables, Views, Packages, Triggers).
• Extensively worked in code and data migration and documentation.
• Skilled in performance tuning; SQL Trace, TKPROF, explain plan.
• Experience in working with offshore teams.
• Excellent communication skills (written, presentation & verbal), creative problem solver, and analytical, organizational, interpersonal, teamwork and training skills.

TECHNICAL SKILLS:

Operating System: Windows 95/98/2000/XP/NT/7, MS DOS, UNIX, Sun Solaris, Linux
Languages: SQL, PL/SQL
Tools/Applications: Oracle Forms 6i,10g, Oracle Reports 6i/10g, Toad, Oracle SQL Developer, JDeveloper, Oracle UPK, PLSQL Developer, Data Loader, Work Flow Builder, BI/XML Publisher, Microsoft Office 2010
ERP: Oracle E-Business Suite (11i and R12)

Confidential | Carrollton, TX 11/2011 – Present
Oracle Application Techno Functional Consultant

• Working as a technical and functional consultant in the implementation of Oracle MRP modules (11.5.10); involved in design and development of interfaces, Data migrations, code migration, writing custom packages, creating tables, concurrent programs setting up responsibilities.
• Developed inbound and out bound interfaces from/to the legacy systems.
• AR to Oracle GL Inbound Interface.
• Forecasting inbound interface.
• Kronos WIP resource inbound interface.
• ATP –item Demand/Supply Outbound Interface.
• Item Master Outbound Interface.
• Inventory decrement Inbound Interface.
• BOM Outbound Interface.
• Sales Order feed to Oracle MRP.
• Material Reservations Inbound Interface.
• Data Migration, Code migration, set ups, documentation
• Item Master Data migration.
• BOM Data Migration.
• On hand Data migration.
• PO -Vendor and Vendor site migration
• Sourcing rule and Assignment migration.
• Open Purchase Order Migration.
• Reports – BI/XML Publisher Report
• 6 Week on hand Quantity Report.
• Work Order Pick List Report.

Confidential | Richardson, TX 4/2011 – 11/2011
Oracle Application Technical Consultant

• Worked as a technical consultant in RICE development project in oracle Applications (R12) -AR, CRM modules.
  Developed oracle Reports, xml publisher reports, custom application using oracle forms, performance tuning.
• Created custom API’s and other database objects including tables, views, triggers, indexes, synonyms.
• Invoice Modification Reprint – Custom application to modify the invoice details and to reprint the invoice with the restriction of users groups.
• Developed application using oracle forms
• Developed Oracle reports to reprint the invoices.
• Created value set, profile options, API’s , tables, views , indexes, synonyms, triggers to support the applications.
• Invoice Modification Reprint Audit Report- Generate weekly audit report.
• Developed xml publisher report with Excel as output.
• Developed procedure to generate XML, template, data definition and concurrent Program to support this report development.
• License Audit Form– Bug fixing and Performance tuning.
• Fix the error in the production application form.
• Fine tune views for performance gain.
• Invoice Error Message – Report all the invoice error messages in a time range.
• Created XML publisher report to report all invoice error message.
• Developed procedure to generate XML, template, data definition and concurrent Program to support this report development.
• Invoice Zero Balance Apply – A report which display open invoices and open on-account remit/credit amount within a customer account when the open amount of the remit directly matches the open invoice amount in draft mode and apply the amount to invoice in final mode.
• Created PKG, concurrent programs to support this development.

Confidential | Plano, TX 7/2006 – 4/2011
Programmer/Analyst

• Providing ERP solutions with Oracle Applications and working in the functional and technical areas of Oracle E-Business Suite (11.5.9, 11.5.10 & R12) modules, especially Manufacturing, Order Management, Advanced Pricing, Purchasing, Bill of Materials and Inventory. Task includes setups, customizing Oracle standard forms, API, creating custom forms, reports, writing PL/SQL, Java, UNIX scripts, data migration, maintain the database objects, documentation, testing systems in multiple projects.
• Manufacturing/Inventory /Pricing
• Created Items, BOM through the standard form as well migrating items through the API.
• Worked in WIP, cost, discrete jobs.
• Experience in Advanced pricing.

PROJECTS:

Confidential

• Developed Leaps System Custom Oracle Form that will display the data base on manufacturing cells and organizations and also link to other Standard oracle forms like Work Order less completion, BOM.
• Min-Max Quantity Set Custom Oracle Form which allows to calculate and update the Min-Max Quantities based on the demands derived from a supply Chain MPS\MRP plan or a MDS schedule.
• Developed Oracle Reports for printing Certificate of Medical Necessity (CMN), Letter Of Medical Necessity (LOMN) using BI Publisher , XML Publisher Administrator, concurrent programs.
• Setups of profile value, value sets and form personalization
• Worked on custom form which shows the min and max item quantity based on the inventory positions.
• Developed custom views for ADF Cash Apps Applications which is based on AR Module.
• Created Price lists and attributes.
• Created and maintained custom schema objects –Tables, views, indexes.
• Wrote custom API, views to support Customized Order Management ADF Application.
• Work Flow modification to using Work Flow Builder.
• Performance tuning for custom views and api’s.
• Data Migration between instances and documentation including writing MD120’s.
• Included in requirement gathering, analysis and design, UAT.

Confidential

• (Configurator Project: Development of configuration models which can be invoked from OM, Quoting).
• Maintaining the custom schema.
• Created and updating tables, indexes, sequences, synonyms.
• Schema export to different instances.
• Using JDeveloper create ERD diagrams of tables, generate DDL scripts.
• Data migration of Non-BOM -items, items properties, model structure, model properties, rules to CZ – IMP tables using Java program and then using the custom package load to standard tables.
• Writing PL/SQL programs for currency conversion, different queries which are called from java code.
• Documentation.
• QA – Performance Evaluation testing in different instances and maintain UAT tickets.

Confidential

• Creating new Items
• Adding items to Bill of Materials.
• Fixing the issues.
• Worked in WIP, cost

Confidential

• (Configurator Project: Development of configuration models).
• Developing configuration models for engines.
• Creating items, BOM.
• Creating Structure for the models and converting Business rules into configurator rules.
• Creating UI (user interface) and testing.
• Worked on Advanced pricing.

Confidential

• Wrote API for updating records.
• Accounts Payable, Accounts Receivable, Purchase Order, Projects Item Master & Bill of Materials.

Confidential

• (Configurator Project: Development of configuration models which can be invoked from Order Management, Quoting)
• Task to migrate prices using the following methods.
• Load the prices into an intermediate tables using SQL Loader from an excel sheet.
• Wrote a PLSQL custom package which calls the standard price list process procedure to import into standard tables.

Confidential

• Worked on service request-
• Creating and updating TAR in oracle metalink.
• Communicating with oracle consultants.
• Creating Production Move documents.

Confidential

• Wrote APIs
• Create sales order using a configuration.
• Create new customer account.
• Add location to an existing customer account.

Confidential

• Involved in fixing the post implementation issues of customized application
• In Oracle Forms & Reports (6i).
• Includes purchase order form, receiving form and reports
• Debugging the PL/SQL -APIs for errors and fixing the issues.

Confidential

• Created user’s reference manual using User Productivity Kit (UPK).

Confidential

• Automation of the process of shipping preparation till pick release using customized application
• Customizing the Oracle standard APIs, creating and maintaining custom tables, data migration, testing.

Confidential | Dallas, TX 4/2003 – 7/2006
Lab Support Specialist 2

• Provides processing of specimens and data entry to ensure the integrity of specimens and to expedite the completion of tests ordered. Using Cerner Pathnet application which is based on oracle database , admit patient in lab information system ,update patient demographics, order tests, verify samples received in lab, report lab results to doctors or nurses

Confidential | Lewisville, TX 3/2002 – 4/2003
Receiving Clerk

• Accession of goods and maintaining the records of incoming and outgoing items. Assist with recording the daily and weekly inventory for each department.
• Book keeping of purchase, credits accounts receivable. System was based on UNIX.

Confidential | NY, NY 8/2001 – 11/2001
Consulting Programmer

• Involved in the development of Library systems project.
• Primary job was to create Database using oracle 8i, and also assisted in system analysis.

Confidential | Mumbai, India 2000 – 2001
Corporate Trainer

• Provided training to people in basic and advanced topics that include operating systems, languages like C, word, excel, PowerPoint applications, outlook communications tools and the internet. Conducted flexible training programs tailored to the needs of clients in the corporate section. Their training ranged from basic to advanced levels. Installing software and troubleshooting for the purpose of training.

Confidential | Mumbai, India 1999 – 2000 Faculty

• Full time faculty teaching students the computer basics and programming languages. Student were taught the basics of Computer systems, hardware/software, Computer fundamentals, Operating Systems including DOS, Windows 95, Applications including MS office, Internet and programming language like C and C++.

Confidential | Mumbai, India 1996 – 2000
Tutor

• Tutoring Math (Algebra and Geometry) for high school going students.

EDUCATION:

Advanced Diploma in Software Engineering (ADSE Honors – 4 years)
Bachelor of Science in Mathematics
Bachelor of Technology (Computing System) Pursuing

CERTIFICATES & TRAINING:

Oracle Certified Internet Application Developer
Oracle Forms Developer Rel.6/6i (OCP)
Oracle (10g) Database Administration course from North Lake College
Member of Dallas Oracle Users Group