PROFESSIONAL SUMMARY:

• Confidential has 10 years of experience in Information Technology as an Oracle Apps Consultant in implementing Client/Server and Oracle Applications e - Business Suite. His expertise in Oracle Applications as a Techno-Functional Consultant has focused on performing technical and functional work and successfully met challenges in Oracle Applications 11i modules, such as Demantra, ASCP, APCC, OM, INV, AR, AP, PO, IB and Service Contracts.
• Experienced and expertise in Application System Administration. Activities like user setup, defining responsibilities, values sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs and providing support to apps users for any Technical or functional issues.

TECHNICAL SKILLS:

Oracle Apps Modules: Oracle: Demantra, Order Management, Inventory, Purchasing, Service Contracts, Installed Base and Discoverer

Databases: Oracle 10g/11g

Development/Productivity Tools: MS Office Apps, SQL Developer, TOAD

Programming Languages: SQL and PL/SQL

Tools: Kintana Migration tool and SVN & CVS version tools

PROFESSIONAL EXPERIENCE:

Confidential, Lincolnton, NC

Demantra Functional Analyst

Responsibilities:

• Project transformed the entire Demand Planning process.
• Setup the Item hierarchy based on client’s requirement.
• Setup the Location hierarchy based on client’s requirement.
• Working with Business team on integration with EBS elements.

Confidential, Minneapolis, MN

Demantra Solution Architect

Responsibilities:

• Upgrading Demantra from 7.3.0.2 to 7.3.1.4
• Designed solution for Migrating and Upgrading the Demantra application
• Converted the history and forecast data from older Demantra version and latest version. As part of this, cleaning the data to maintain its integrity through custom program.
• Created Integration interfaces to export and import the conversion data.
• Created series to bring in various data sets like forecast rolling profiles, MAPES as per customer requirement.
• Improved Converting process performance drastically by using various scripts like REORG and GATHER STATS.
• Designed an easy to use process to troubleshoot the issues which occurred in the conversion process.
• ASCP Customizations for forecast publishing.
• Improved various issues occurred in publishing forecast to ASCP.
• Analyzed the current system health and proposed various design changes like running the PROPORT before the engine runs and adjusting the Forecast tree as per the latest hierarchy.
• Implementing the solution to roll-outs of various organizations across the company.

Confidential, Houston, TX

Demantra Lead Consultant

Responsibilities:

• Rolling-out the solution(ASCP &Demantra) to the global units across the globe
• Supporting the CRP and UATs for the global roll-outs.
• Project transformed the entire Demand Planning and sales & operations process
• Setting up Inventory parameters for ASCP and designed an easy process to use it for roll outs across the globe.
• Setting up Sourcing rules for ASCP and designed an easy process to use it for roll outs across the globe.
• Implemented the User security process based on the role.
• Designed and configured various solutions like Net Need approval process, Customer Safety Stock quantity feeding process which is mapped to best practice Demand Planning processes to demantra 7.3.1.4 DM, including integration with Oracle EBS R12.1.3.
• Designed and developed various reports for ASCP.
• Working knowledge of collaborative planning.
• Customized the ASCP safety stock population through Custom hook.

Confidential, Dayton, OH

Demantra Solution Architect

Responsibilities:

• Project transformed the entire Demand Planning process as part of Service Parts Logistics.
• Designed and configured the full end-to-end solution, which mapped best practice Demand Planning processes to Demantra 7.3.1.4 DM, including integration with Oracle EBS R12.1.3.
• Designed four engine profiles to generate the forecast based on various history streams.
• Brought in the spare parts returns history and generated forecast by creating a custom engine and published the forecast to SPP where SPP treats that as supply/on hand and suggests the plans accordingly.
• Setup the Item hierarchy based on client’s requirement.
• Setup the Location hierarchy based on client’s requirement.
• Designed the forecast tree to generate the forecast accurately.
• Used rolling profiled for forecast accuracy.
• Fixed various issues as part of the implementation.
• Designed various worksheets as per the user requirement.
• Implemented the user security based on the roles.
• Final solution delivered to Spare Parts Planning, which created the plans based on the Demand forecast.
• Integrated Demantra with APCC for reporting solution.
• Integrated APCC with Demantra for reporting purpose.
• Customization for APCC integration with Demantra to include the Location hierarchy.

Confidential, LeMars, IA

Demantra Senior Consultant

Responsibilities:

• Solution included Demand Planning and Predictive Trade Planning based on various seasonal and causal factors.
• Configured Demand Management and provided technical solutions for the full solution using Demantra DM/PTP 7.3.1.2, including integration with Oracle EBS R12 and retailer data.
• Participated in requirements gathering sessions.
• Created various custom series to bring in the various data streams into Demantra.
• Developed the integration interfaces to bring in the third party data into demantra.
• Worked on various customizations of rolling profiles.
• Worked on various customizations of PTP.
• Participated in CRPs and UATs.
• Participated in user .
• Documented all customizations and process.
• Worked on various Integration objects of Demantra and ERP
• Documented the integration process.

Confidential, Topeka, Ks

Senior Analyst

Responsibilities:

• Project Included Oracle EBS R12 with Demantra, ASCP EAM, INV, WMS and OBIEE.
• Provided technical solutions and support for Demantra, ASCP, INV and EAM.
• Developed various interfaces, conversions and reports across all the modules.
• Worked on the Integration of Demantra and ERP.
• Worked on Inventory Conversion.
• Worked on various EAM interfaces.
• Worked on Demantra Performance issues.
• Worked on ASCP Safety stock population.
• Provided support for ERP and Demantra issues.
• Responsible for all Demantra and ASCP Support.

Confidential - Sunnyvale, CA

Consultant

Responsibilities:

• An implementation of R12 Phase 4 which included OM, INV and AR
• Developed various reports and interfaces in OM and AR.
• Worked in AR module for revenue recognition reports.
• Created Discoverer Business area for Revenue Recognition reports.
• Worked on BI Publisher report for Freight carriers.
• Developed and delivered various Revenue Recognition reports like FOB reserve, Non Standard deal report, Tax reconciliation and etc.
• Migrated discoverer reports from one environment to another using KINTANA tool
• Worked on PA revenues reports and Exported and imported business areas.
• Worked on invoice reports for CFDs.
• Developed AIM Documents like MD70, TE20 and MD120.
• Created new Forms to track the RICE items as per the client requirement.

Confidential, Fremont (CA)

Consultant

Responsibilities:

• Designed test scripts for Costing and Billing.
• Created Discoverer Business area for projects accounting.
• Developed Discoverer Reports like Timecard detail Report, QA Sample report, QA Sample Projects utilizations report, monthly resources report, Monthly workload report and monthly team time report.
• Worked on Order Import API.
• Migrated discoverer reports from one environment to another.
• Created discoverer reports using Foundation tables views and custom views
• Granting privileges to discoverer reports and business areas using Discoverer Administrator tool.
• Developed Projects Conversion Program.
• Set up the Employee Cost centers for the expense approvals.
• Tested the iExpenses and OTL functionality using the test scripts by creating expenses.
• Customized the Time approval (OTL) workflow.
• Worked on timecard workflows and customized as per requirements.

Confidential, San Jose CA

Responsibilities:

• Setup the OIC collectors for salesperson and packages.
• Developed salespersons report - Discoverer.
• Created reports using Foundation tables and views and custom views
• Customizations for discoverer reports like adding columns and tuning the SQL to increase performance.
• Solved day-to-day technical issues.
• Involved in SQL Performance tuning.

Confidential, Redwood City

Responsibilities:

• Team Member of implementing OM,SC and IB modules
• Developed Data Conversions and Interface Programs using PL/SQL, SQL and SQL*Loader Scripts.
• Developed Service Contract conversion program.
• Developed Item Master Conversion program.
• Developed BOM Conversion program.
• Worked on Reports like Quote renewal, IB extract reports.
• Worked on Projects Conversion Program.
• Designed and Developed custom program to Recognize Revenue based on counters for prepaid transactions
• Developed, tested various reports in Order management and Service Contracts.
• Involved in functional activities in Setup and Transactional testing for Order Management and Service Contracts.
• Worked on AR reports for handling the client requirements.
• Created different Business Areas on module level.
• Maintained Discoverer access levels using Discoverer admin.
• Exported and imported business areas.
• Modified OM Workflow to suite business needs.
• Prepared Technical design documentation for Conversion, Interface and Reports.
• Prepared Test cases for Order Management, Service Contracts and Installed Base modules for CRP’s and UAT.
• Responsible for resolving issues in CRP’s and UAT.

Confidential, Walnut Creek, CA

Programmer Analyst

Responsibilities:

• Worked on various projects, such as those involving implementation, support and upgrades.
• Provided various technical services across Oracle EBS modules, such as OM, INV, Service Contracts, AR and PO.
• Worked on interfaces, conversions, and reports using Discoverer.
• Worked in supporting team for the clients.