SUMMARY:

• Certified Oracle apps professional having 17+ years of experience. Worked in both Implementation and support of manufacturing and financial systems, Demand Planning / Demantra demand management / Oracle applications 11i / R12 / Cognos Business Intelligence.
• Worked on CAPEX and budget requirements IT projects
• Delivery manager and responsible for all development works and ensure source control and SOX compliance
• Manage technical development team, business intelligence team, Offshore partners and various implementation partners
• Create project plans, risks and track deliverables
• Manage IBM implementation partners during Cognos BI and analytic applications implementation and implemented GL, AR, AP, Sales modules
• Manage Supply chain fusion implementation partners and Hitachi offshore development team for Supply chain Demantra implementation
• Conduct interviews and select resources for project deliverables team
• Experienced in executive dashboards for CEO, CFO and deliver to iPad using the latest tool sets Cognos active reports and worked directly with C level executives
• Experienced in PMO techniques, project management, creating project scope, resource assignments and implement project within budgets
• Experienced in business process reengineering
• Worked with auditing firms on the SOX compliance
• Implemented appealing sales dashboards and finance dashboard and helping the executives to review revenue, variance to their TM1 forecast / budget, working capital, quick ratio trend, DSO/DPO, Inventory turnover, current assets and liabilities, customer aging, profit, return on equity, net profit margin, return on total assets, net income, current assets, equity, backlog, bookings, on time delivery more accurately and timely manner
• Implemented Demantra demand management and statistical, POS forecast models: business Modeler, Install and configure demantra, configure worksheets, workflows, users, series, integration interface, stats engine administrator, backup demantra schema and recover
• Integrated backlog, shipments, supply, on hand, purchase orders, work orders from ASCP to Demantra to better manage the supply and demand picture in SOP cycle. Create oracle quotes, PO and vendors using API
• Implemented SOP process (Sales and Operations Planning) monthly processing cycle that allowed collaboration between marketing, sales, supply and the executive team members. Tools used are Oliver Wight, Demand planning, ASCP and Demantra
• Implemented forecasting at product family, planning BOM, forecast accuracy and error techniques using demand planning. Demand and supply are shown in single worksheet that helped the management understand the supply demand netting, inventory positions and their backlog and delinquent backlogs. Created statistical forecasts from histories and that helped the business to forecast with highest accuracy percentages. Different techniques used to calculate forecast accuracy at line and product family level.
• Oracle Applications 11i / R12 (Order management, Inventory, Shipping, WIP, BOM, Purchase Orders, Cost, ASCP, Demantra, AP, AR, GL)
• Expertise in application business processes purchase to pay cycle and Order to cash, S&OP
• Implemented ICIO (Inter Company, Inter Org) with IP rights. Dynamic accounts are generated using cost extensions and AP, AR invoices are generated dynamically based on complex logics. Oracle interface and API used to create AR and AP invoices
• Implemented and supported oracle EBS modules
• Worked on 9i DB upgrade /10G/UTF - 8 Conversions / 11.5.10 upgrade projects
• Purged oracle OM, PO, inventory, distributions, workflow and successfully reclaimed more than 130 GB of disk space
• Implemented EDI (Invovis Trusted link, Catalyst Map) auto creation of purchase orders and Sales Orders
• Implemented custom e-Mail alerts and security. Custom alert is a tool by itself. This has higher features than the oracle alerts. Procedures, SQLS, Concurrent programs can be launched from here with features like grouping, selective launch, sharing and e-mailing the outputs as one single attachment
• Experienced and having sound knowledge in creating functional requirements, technical solution designs, migration of legacy data into oracle applications, conversions, understanding user requirements, analysis, coding and end user .
• Specialized in preparing the process flows, project management plans, track tasks and the offshore co-ordination.

TECHNICAL SKILLS:

Applications: Oracle Demantra 7.3, Oracle Applications 11i / R12

Modules: Business Modeler, Member Management, Engine administrator

Process: SOP ProcessLearning management systemOracle UPK (User productivity Kit)Oracle Applications 11i

Applications: Oracle Apps 11i / R12

Modules: Demand Planning, Manufacturing and Finance Modules - INV, PO, OM, BOM, ENG, WIP, MRP, AP, AR, GL, e-Commerce Gateway, Forecast

Mapping Tools: Catalyst map / Trusted Link - Inovis (ASCII12 and EDIFACT)

Developer Tools: Oracle 9i/10G, Forms 6i, Reports 6i, SQL Loader, Toad 7.3.0.0, 8.0, Workflow 2.6. Pro*C, Tad Link - Printing oracle reports on local printers

BI Tools: APCC, Discoverer 4i, Warehouse Builder 9i, 10G Data mart tools, OEM 9i, BI Beans, BI Spread Sheet add-in, JDEV 10.1.2.2

Microsoft: VB 6.0 / SQL Server

Coding: Unix, C, C++

EDI: Trusted link / Catalyst Map

Cognos Business Intelligence: Cognos administrator, analytic applications, adaptive warehouse, active reports, report studio, analysis studio, metric designer, iPad integrations, TM1

ETL Tools: Cognos adaptive warehouse, Oracle Warehouse builder

PROFESSIONAL EXPERIENCE:

Confidential

IT PMO

Responsibilities:

• Implement ASCP, Demantra and APCC
• Identity project risks, resources
• Review current business process and identify areas of improvements
• Work with the implementation partners for the complete reimplementation of R12 modules
• Lead the conversion of current R11 systems to the new R12 systems
• Coordinate internal Confidential resources
• Monitor progress and coordinate internal weekly status reports
• Manage the identification and resolution of project issues
• Drive solutions for cross-functional design issues (responsible for cross-functional/integrated design)
• Address project risks within relevant area: cross-functional design issues, staffing issues
• Sign-off on business requirements for relevant area
• SME for Implementing ASCP and Demantra module

Confidential

Manager / Demantra supply chain

Responsibilities:

• Collaborated with business users, support team, technical development team and recommended process changes to S&OP
• Collaborated with business users and automated their demand / sourcing process
• Implemented Demantra weeks to months’ time resolution and manage the development, and IT resources
• Implemented STATS forecast, beginning inventory, weeks supply, ending inventory using customer POS data
• Achieved various business benefits by implementing POS models
• Improved forecast accuracy thereby reducing inventory risk and increasing operational efficiency.
• Established a standardized forecast model across all end users.
• Eliminated multiple points of forecast entry for end users (excel and then Demantra).
• One source of truth for key metrics including pricing.
• Improved reporting capabilities - reduces time required to pull forecast and historical data from multiple sources e.g. (Demantra & Cognos), increases data accuracy, and easier access to data for key business users
• Achieved process improvements that improved efficiency and reduced manual hours days a month for Demand Planning function ($100/hr X 32 hours X 2 planners) = $6,400 / month days per month for each US Retail & Canada Sales Analyst ($100/hr X 16 hours X 14 analysts) = $22,400 / month
• Bigger benefit relates to stronger controls over data integrity and accuracy
• Integrated EBS, ASCP, ERP, Demantra, Hyperion and Cognos
• Implement R12 VCP

Confidential

Manager / EBS / Demantra supply chain / TM1 / Cognos Business Intelligence

Responsibilities:

• Manage offshore technical development team Hitachi consultants (Size of 12 +)
• Delivery manager and responsible for change requests, enhancements and approvals to production systems
• Managed Cognos executive reporting delivery team
• Implemented Demantra demand modules
• Created project plans and identify resources for projects
• Approve functional specs for development, identify and setup project teams
• Managed IBM delivery team for Cognos BI implementation and executive dashboards
• Identify and conduct interview to hire resources
• Create metrics to review on time delivery of development works
• Configured Demantra to work with S&OP process (Sales and operations planning that involves sales, marketing, schedulers and finance team)
• Automated manual excel worksheet analysis into workflow driven processes
• Created learning management system, online videos using oracle UPK to help end users
• Implemented oracle UPK
• Implemented Sales and Operations monthly planning cycle to collaborate between sales, marketing, scheduling and executive team member

Confidential

Manager / Project Lead

Responsibilities:

• Revenue and COGS was developed with advanced features to display graph data based on cross tab product line selections, QTD, YTD, YTD, Prior Year comparisons were computed
• Factory level on time delivery was calculated on the fly using the OTD dashboard
• Customer level performances were monitored using the TOP10 customers and their rankings
• Revenue actual were measured against the revenue targets and metrics were generated around that
• 13 week bookings and backlog trend was shown to help understand the top management on the progress in bookings and progress on customer satisfaction
• Qtr over Qtr sales was helping the management understand quarterly sales in the current year to date
• Marketing publishes their unconstrained marketing demand and the scheduling team constrains it. After marketing and scheduling team collaboration it will be published to simulation plan and supply demand netting, inventory positions will be reviewed. This number will be presented to the executive team to come up with the consensus
• Demand was captured for 24 months and using MRP API it was loaded into different demand classes and organizations.
• Different data stream was shown for the marketing and operations team to better forecast. Backlog, delinquent backlog, shipments, statistical forecast, on hand, unconsumed forecast and supply quantities and dollar values
• Provided the capability for product transfers from one inventory location to other inventory location over the time period. This helped in doing big product transfers at ease.
• Statistical forecasts were generated based on the order history using best fit in demand planning
• Used oracle forms personalization to default, enforce security at forms

Confidential

Business Analyst

Responsibilities:

• Completed 3 rounds of CRP and tested INV, WIP, Order to Cash and Purchase to Pay cycles
• Co-ordinate two major sites in their efforts in testing
• Co-ordinate with the offshore team and fix any issues encountered during testing phase
• Train all users on the new 11.5.10 applications
• Helped in performance tuning of some bottleneck programs
• Workflows created for missing order headers and lines
• Order to cash, purchase to pay cycles were tested

Confidential

Project Lead / Business Analyst

Responsibilities:

• This helps the marketing team to forecast at higher level (Product family). This increases the accuracy of the forecast.
• Items will be allocated based on planning percentages to product family and this will be exploded to MDS. When a sales order is received both the product family and the end item will get consumed
• Statistical techniques like RSFE, MAD, Forecast error, Variability are created in demand planning. This helps the marketing team understand the problematic forecasts
• Forecasts loaded at model BOM and history from configurations are rolled up to model BOM. Consumption happens at model BOM

Confidential

Project Lead / Business Analyst

Responsibilities:

• Configure levels, hierarchies in demand planning
• Build demand plan, collections distribute to planners, publish forecast
• Create different demand plans for VMI forecasts (weekly), and monthly forecast
• Create scenarios, data streams
• Successfully archived 8 years of transactional data using ware house builder (ETL), OEM (Schedules)
• Reclaimed 130 GB of space from PROD. This compounded the savings every time a clone was made out of PROD
• This helped to improve the performance in the following key areas. Cost rollups, cost updates, shipping transactions, OM processing and inventory transactions

Confidential

System Analyst

Responsibilities:

• Migrating Legacy data into Oracle interface tables, Standard tables using SQL Loader, Standard API’s. To name a few, Item master, Item balances, Formulas were uploaded using PL/SQL format API provided by oracle. Batch Creation, Allocation, partial,, releasing and canceling are done by PRO*C interface API’s. GL Interface, PO Vendors, Costing is uploaded using PL/SQL Format API’s into interface tables.
• Published white paper on Customizing the DFF / folders on custom forms
• Published the Oracle developer handbook for Confidential Standards.
• Created data warehouse / data mart modules using Oracle Warehouse Builder 9i (9.2) and scheduled the jobs using OEM (Enterprise Manager)
• Customer items forecasted using 830 / DELFOR process (ASCII and EDIFACT Standards)
• Created email package using java stored procedure. Using this email can be delivered from oracle PL/SQL, created java stored procedure for executing the UNIX commands from PL/SQL procedures.
• Implemented EDI solutions for the customers Solectron Penang, Celestica, Avnet, Fair child, Digikey, Ericsson and Jabil for the following transactions. 850/Orders, 855/ORDRSP, DELFOR/830, Shipping release in EDIFACT and ANSI standards
• Data Quality check Monitoring tool - Developed a new tool to launch exception SQL and to deliver emails. This combines the futures of oracle concurrent programs / request sets / request groups and alerts.
• Function Tree DBA monitoring and security tool - This will list all the users accessing a particular function / menu / form. It gives a tree kind of structure and highlights where exactly a function is attached in a menu. Function, menu exclusions can be done from this tree itself.
• Co ordinate with the offshore development team, functional design document, delivery testing and integration testing
• Gathering user requirements, preparing the design, analysis, debugging, and implementation.
• Prepare Project management plan for project deliverables.
• Prepared the process flow diagrams for CTDI data import process

Confidential, Troy, MI

System Analyst

Responsibilities:

• Published white paper on Tad link. - Tad link is to administer quick and effective remote support mechanism like printing remote output files in the local printers.
• Released API documents, dictionary of the entire API available in Oracle APPS.
• Published developer standards handbook
• Standards prepared for document maintenance related to process and product.
• Solution suggested to clients for current view MRP that is not available in the standard oracle APPS reports.
• Migrating Legacy data into Oracle interface tables, Standard tables using SQL Loader, Standard API’s. To name a few, Item master (MTL SYSTEM ITMES INTERFACE), BOM (Process BOM API) and routings (Process RTG API), Orders (OE ORDER PUB API), AP, AR Invoices, GL and GL Budgets were uploaded using PL/SQL format API and open interfaces provided by oracle.
• Analysis, design, coding, debugging, testing and implementing.
• Help the team in analysis of the project and performance tuning.
• Prepare standards documents for process improvements.

Confidential

System Analyst

Responsibilities:

• RICE (Reports, Outbound and Inbound Interface, Customization), Up gradation from 10.7 to 11i.
• Conversion team. Responsible for converting the oracle data from 10.7 to 11i

Confidential

Supervisor

Responsibilities:

• In charge for all technical related aspects of the projects spread over forms customization, developing reports and modification of existing reports to suite the business requirements of the company. Also responsible for migration of data using SQL Loader into standard interface tables.
• Train End users of the procedures and discipline to be followed.
• Responsible for designing and implementing the customized forms and reports in the project. One Complete module is developed in-house called OPM Worksheet to do most of the functions available in OPM Production Management using API’s as the interface between existing business practice and OPM Production Management.
• Developed report objects for pre-printed stationary format not supported by standard Oracle Application Reports.
• System Administration and Application Development.
• Uploaded five years of financial GL data into GL INTERFACE and GL budgets.
• Formulas, Master items and Opening Balance - Inventory is uploaded from available data.
• MRF had major problem in addressing to alternate items in formulas. Each item in the formula will have alternate items. In case of shortage in inventory the primary item can be substituted with the alternate item. Each formula will have ten ingredients and they in turn will have number of alternates. Oracle is addressing to the same problem with different versions in formula. But it is not feasible in MRF, because sometimes more than fifty versions are coming, and is practically difficult both in formula and batch creation level. Shop Floor will not know in which version the looked - up item is available.