|
Bhupendra (Bill) Gaheer
Phone: +91-988-124-4507
email: bgaheer@hotmail.com
SUMMARY: Bill has over 12 years of Industry experience, with 6 yrs of expertise in Customization, Implementation, Upgrade and Developing Oracle Applications and Oracle tools. Over 6 Years of expertise in Analyzing, Designing and development of various projects in Oracle Applications. Bill has worked extensively in USA (5.7 Years in total). Excellent functional experiences in Oracle 11i Distribution, Financial and CRM applications including Inventory, Order Management, Advanced Pricing, iStore, iSupport, Shipping, Inventory, Purchasing, BOM, WIP, MS/MRP, AOL and System Administration, System Administrator, Workflow 2.6. Excellence in suite for Order to Cash and Procure to Pay. Worked on project using AIM and other third party monitoring tools. Worked in a broad range of environments (Engine Mfg, Automotive Parts Mfg, E&PS, Oil - Natural Gas, DVD Replication - Duplication, Credit-card Processor, Consulting, Drug Manufacturer and more) with emphasis on Multi-Org configuration, Manufacturing, CRM and ebusiness Bill’s Proficiency in Functional Roles – Manufacturing: Lean Production - Understand and apply modern process mapping, capacity analysis and production controls, Global Supply Chain - Understand how to forecast requirements, manage the entire supply chain, multiple vendors on several continents, do risk analysis and thereby enable lean manufacturing. Inventory "Turns" - Be able to increase inventory turns, read constraints, balance production lines and remove bottlenecks - FIFO or LIFO methods, Sharpening Profitability - Manage business for short term and long term profit; by analyzing fixed and variable costs, investments in capital equipment, "make or buy" decisions and analyzing product profitability. Integrating Quality - Managing for quality under the ISO 9000 series and your firms quality program (e.g. 6 Sigma), Workforce Management and Morale - How to build work force flexibility, participation and self-direction , Change Management - Cope with stress of change in operations; plan and implement new product processing. More with Less - Apply software tools to Improve productivity, quality, service and cost effectiveness, with limited resources; without adversely impacting staff morale, Applications - Contribute to a "Best Practice"' Panel in key phases of your company's operations and implement a Post-Graduate project to achieve "more with less" Order Entry (OE)/ Order Management (ONT): 5 plus years of Order Entry / Order Management, experience in implementations and upgrades, worked on 11.0.2, 11.0.3, 11.5.4, 11.5.6, 11.5.8 and 11.5.9 Applications, Experience in GAP analysis/design, System Setup and Implementation, USER Training, and Post implementation support of Order Management System administrator, managing the functional set-ups for Oracle Order Management, Worked on setting up Oracle Quick Order Entry Screen for Call Center (new feature in 5.9), Responsibility and Menu setup to meet and exceed the new D&B requirements, customized Menus to meet D&B requirements. Carrying out unit and integration testing of data flow between different modules including Order Management, Helped in developing Custom Workflow in Order Management module, Helped setting up defaulting rules for Order entry, hence saving time and making more efficient use of time for the end user. Setup Taxation i.e. tax codes, location and rates, exemptions. Credit policies rules, Credit check for Account Payable customers, Credit check for CC payments through ipayments. Researched and implemented global order promising for the existing client. Prepared an Application Set up Control Sheet for Order Management with all this attributes Created a test instance for client demonstration of a full suite of Oracle applications solution and led efforts to secure detailed solutions for Order Management (OM), Purchasing (PO) and Inventory applications. Responsible for Setting up and monitoring Regression Test Plans for upgrades. Integrated Oracle iStore with ONT and help setup iStore. Analyzed Workflow steps for Denial Party Listing (Export Compliance Screening) and performed changes to the existing workflow and added DPL steps to all Workflows ISTORE: Gap analysis performed between existing webstore and iStore, performed the recommended setups for test and performed test cases (setup and integration between iStore and ONT/QP). Setup performed for Denial Party Listing (Export Compliance Screening) for iStore (part of ONT setup) designed Workflow steps as per the business need. Integrated iPayment with iStore for CC processing and helped determine ways to encrypt data. Identified and implemented conversion of WebStore Customers to FND Customers for iStore. Performed standard setups based on multi-org for catalog’s , shopping carts and orders, help setup text messages, workflow email notifications WORKFLOW: Analyzed Business needs and performed GAP analysis of different types of Custom workflow. Performed setup for workflow and added workflow to transaction types in OM, workflow engine, email notification. Customized Workflow steps (workflow customized to meet / exceed the business requirement). Added a config validation step in WF to suite the business need for custom and config packs. Performed setup and monitored workflow for Oracle Management/Purchasing . Analyzed and customized Denial Party Listing (Export Compliance Screening) to meet and exceed business need BOM: GAP analysis/design, System Setup and Implementation, USER Training, and Post implementation support of BOM. Played an Important role in setting up BOM Components, Functional role in Sharing, Copying of Bills, Mass Changing of BOM, Bill Compare, Deleting Bills etc. Did analysis / Scripts to see if BOM Business Object can be implemented to integrate with other software. Helped in setting up Time, Workday Calendar, Pattern, Shifts etc in BOM, Helped in Resource planning, assigned various departments’ different roles and helped them merge the department in BOM. Helped design the flow routing. Responsible for Setting up and monitoring Regression Test Plans for upgrades WIP: Experience in GAP analysis/design, System Setup and Implementation, USER Training, and Post implementation support of WIP. Helped laying out the work order, production order or shop order, Helped querying the system, Analyzed the Average Costing of WIP, Responsible for Setting up and monitoring Regression Test Plans for upgrades MRP: Excellent functional experiences in Oracle 11i – Oracle Master Scheduling, Analysis/design the MRP Plan. Helped document the supply and demand in the MRP systems, Did Planning with the planning committee and then helped the technical consultants implementing the Planning Committee recommendations. Knowledge of the Horizontal Material plans and its benefits, Provided the technical people with Resource and Capacity information to complete the capacity planning. Run Simulations to see the working results of the MRP module. Responsible for Setting up and monitoring Regression Test Plans for upgrades, Worked on various planning process including but not limiting to Memory based snapshots, Memory based planner and Inter-process communications ASCP:
Certified ASCP Analyst from Oracle University, hands on exp in setting up a multi node setup – with a choice of Oracle 11.0.3, 11.5.9, SAP and Mapix. Worked on documentation and analyzing of DB link setups, worked on running different types of plans i.e. unconstrained, constrained and optimized plan, help the users understand the outcome of the plan. Inventory: 9 yrs exp in managing Inventory with 5 yrs of Oracle 11i Inventory experience, Carrying out set up in Inventory and Purchasing modules including defining Inventory Organizations, Shipping Networks, master and organization Items, item categories, Buyers, Positional hierarchies, approval groups, approved supplier lists, sourcing rules, Replenishment counts, Assignment sets. Carrying out integration testing of data flow between inventory, and other modules. Setting up of inventory organizations, (including Replenishment Counts) Operating units, Legal entities, Master and Organization item attributes, shipping networks. Setup Shipping, delivery, freight, special charges rules etc. Helped Organizations use Barcode in Std INV Module to enhance productivity. Responsible for Setting up and monitoring Regression Test Plans for upgrades. Helped setting up Carrier-Ship Method Relationships iProcurement: Designed and developed Oracle’s iProcurement enhancements: Led a technical team that delivered the iProcurement customizations listed below (Oracle Applications 11i), ‘Catalog Extractor and Loader Process’ to extend the existing realm capability to control Blanket Purchase Order and Quotations visibility in the iProcurement catalog. The added functionality allows multiple users within an Operating Unit to have restricted visibility on certain blankets/quotations when they search the catalog. ‘PO Requisition Account Generator Workflow’ to generate account combinations for requisition lines. The customization was performed in a Multi-Org environment where each Operating Unit had its own set of books, and therefore its own logic to generate and validate accounts. ‘PO Requisition Approval Workflow’ to add approvers to the approval list based on business requirements. The customization was performed in a Multi-Org environment where each Operating unit had its own approval requirements. ‘PO Create Documents Workflow’ to modify some of the required business rules to generate POs out of approved requisitions. The customization was performed in a Multi-Org environment where each Operating unit had its own requirements. ‘PO Approval Workflow’ to add approvers to the approval list based on business requirements. The customization was performed in a Multi-Org environment where each Operating unit had its own approval requirements. Sarbanes-Oxley compliance: Built processes, controls to mitigate the risks, audit procedures within our product for Sarbanes- Oxley compliance. Set the vision, strategy, and direction for Approva’s Oracle compliance products. Oracle Internal Controls Manager: Architected a solution to integrate Oracle Internal Controls Manager (ICM) integration with BizRights. SKILLS: Business Analysis Distribution Process Design Project Feasibility Studies Non-Oracle Products interfaced with Oracle Strategic Planning Project Management DPL setups in Distribution Process Documentation Management Oracle 10.7 to 11.5.10 Application suites Upgrade and Implementation knowledge of Oracle Application Inventory, Engineering/Bill of Material, Work in Process, MRP/MPS/ Supply Chain, Cost (Standard & Average) Quality, Procurement, Order Management, Shipping, Capacity Planning, Flow Manufacturing, Project Inventory/ Manufacturing, Multi Org, Project/Contract, Oracle AIM Methodology, Solution Design, Project Management, 3rd Party Integration, End User Training, Executive Education, Risk Mitigation, System Administration, Conversions & Interfaces. Implementation Knowledge: Order to Cash, Procure to Pay, Order Entry, Order Management, Advance Pricing, Shipping, Inventory, Purchase, iStore, iPayment, iProcurement, Enterprise Asset Management, eCommerce Gateway, Accounts Payable, Accounts Receivable, General Ledger, Enterprise Asset Management, MRP, BOM, WIP, Warehouse Management, Customer Relations Management, Maintenance Management, “I” Product Series & Advanced Supply Chain EDUCATIONAL QUALIFICATION: • Bachelor of Commerce, Mumbai University, 1992 • Oracle ASCP Certification from Oracle University • Certificate Course in Oracle Apps Manufacturing Modules • Certificate course in Management in Information technology Application and Tools: Oracle Applications 11.0.3 and 11i (5.4, 5.5, 5.7, 5.8, 5.9, 5.10), Up Grades from 11.5.4 to 11.5.8 and from 11.5.8 to 11.5.9 and 11.0.2 to 11.5.9 RDBMS: Oracle 8.x, Oracle 7.x, MS SQL Server 7.0, MS-Access, Toad and SQL Navigator. Operating Systems: DOS, UNIX, Windows 95/98, Windows NT, 2000, XP PROJECT DETAILS: Client - FleetGuard Filters Pvt Ltd Title - Project Manager, Oracle Application Manufacturing Functional Consultant, Track Lead for Distribution (OTC and P2P), Order to Cash Process Lead, Quality Lead for Project Implementation Duration - Sept 2005- To Present Environment - Oracle Applications 11i 11.5.10 - Advanced Pricing (QP), Order Management (OM), Inventory (INV), Shipping (WSH), Purchasing (PO), Inventory (INV), Workflow, Workflow Builder (2.6.1.5.3), Quoting (Order Capture), Bills of Material (BOM), Work in Process (WIP), Quality, Engnieering, GL, AR, AP, FA, Cash Management, Support (Tar), Toad. Has the Functional Lead, Bill’s responsibility included providing subject matter expertise for the implementation for his modules with imphases on overall delivery of the BPR requirement which are 30% and 33% reduction in Manpower and Inventory on hand, currently Phase One “Requirement Definitions” is complete This is a END to END implementation with complete BPR. Responsibilities include: • Managing the entire development life cycle from analysis & design to implementation and user training. • Managing and planning for a team of 7 functional and 8 technical resources. • Identifying and assigning project roles, responsibilities and performing relationships. • Providing guidance to the development team as required. • Communicating with stakeholders of the project – Vendors • Multi level customization are identified at this level itself i.e. Interface with Oracle ENGG, Interface with Oracle OM, QP and WSH • Identified external software requirements for few of custom applications • Highly Complex Order Scenarios with multi level discounts based on customer profile and different sites • Discounts also given on Kits etc • Over all Custom Interface to help drop Engg BOM to Oracle and later convert it to Process BOM • We are following KPIT’s internal documentation system and merging it with AIM’s to get the best of the both • Currently Solution Designing phase is in Process… which includes TO BE, GAP and SOLUTION DESIGNING.. ….as processes Client - KPITCummins Infosystems Title - Functional Lead –Setups & Support. Duration - Sept 05 to Current Environment - Oracle Applications 11i (11.5.10), 11.0.3, SAP and Mapix with a separate Server for ASCP. Making it a true multi node setup. KPITCummins as a learning initiative has taken up steps – one of them is of having complete knowledge of ASCP suites of Modules from Oracle with multi node application installation. • Installed ASCP as a stand along instance with DB links setup between 11.5.9, 11.5.10 and Mapics • In process of adding a small size legacy application to ASCP • All this help us understand the complex nature of the ASCP. • Worked on unconstrained, constrain and Optimized Plans • Worked on Plan simulations and its effects • Understanding the complexity of results of the Plan how to understand them as the input is made on business decisions • Working on to solve the complexity of multi ERP setups i.e. although ASCP can be a bolt-on on any one or multi ERP platforms but there are certain requirments with needs to be taken care while setting up the instances Client - Approva Corporation Project - BizRights – The Enterprise Controls Management solution Title - Project Lead Duration - April 05 – Sept 05 Environment -Oracle Applications 11i - Support (Tar), Reports, Oracle Discoverer. Role - Oracle Applications Consultant (Functional). Approva is redefining the Enterprise Controls Management market to help companies move beyond mere compliance documentation. With BizRights software provides a “plain English” assessment of ERP controls. Freed from arcane application codes, everyone – application security specialists, auditors, and even business managers – can collaborate in asserting controls. Risky configuration settings, policy violations, and other problems can be resolved quickly. Even better, BizRights' simulation facilities enable tests of controls before changes are made. Partnering with leading finance and audit specialists, we ensure our automated examinations of critical business processes reflect real-world requirements. And a standards-based, application independent architecture provides visibility across applications and systems, yielding true enterprise-wide control Responsibility: • Setups for Vision 11.5.9 and 11.5.10 OTC and P2P Modules • Create Custom Menus, Functions and Responsibilities for testing purpose • Created ‘English’ Rules for Financial, O2C, P2P Modules as per SOX Compliance • Testing of the rules in BizRights and cross validating them in Apps • Understanding of the SOX Compliance • Testing of the Generated Reports • Built processes, controls to mitigate the risks, audit procedures within our product for Sarbanes-Oxley compliance. • Developed go-to-market offerings and responded to inquires in a timely and professional manner. • Set the vision, strategy, and direction for Approva’s Oracle compliance products. • Worked with Approva’s offshore software development teams to ensure the delivery of useful, unique, and high quality product offerings. • Conduct competitive analysis to ensure that our product offerings are well differentiated Client - PepsiCo, European Upgrade - Belgium (Offshore work) Title - Track Lead Duration - Feb 05 - March 05 Environment - OM, Advanced QP, Shipping, WF, INV, e-Commerce gateway for EDI order imports and AR. Order to Cash processes, Oracle TAR’S and Toad. Role - Oracle Application Manufacturing Sr. Functional Consultant Lay's is the international leading manufacturer of potato chips. Lay's chips are the international chips brand of Frito-Lay, the chips and salt division of PepsiCo. The Project was for Frito lay Belgium, This is an upgrade from 11.0.3 to 11.5.9. My role as a Sr. Functional Analyst for Order to Cash process was to understand and dissect the Scenario’s provided along with the documentation. Upon successfully understanding the Scenario’s in 11.0.3 – re run them in 11.5.9 and notes the Gap’s or any advantages what 11.5.9 may have over 11.0.3. Modules Involved not limited to OM, Advanced QP, Shipping, WF, INV, e-Commerce gateway for EDI order imports and AR. Tasks: • Setups of the modules as per PepsiCo Documentation • Understanding the Scenario’s and running them in 11.0.3 and then re-running them in 11.5.9 • Documentation of the Gap’s – changes between 11.0.3 and 11.5.9 • Documentation of any new setups needed to be performed after the upgrade • Upgrade was done using Oracle Upgrade Tool • Understanding of any customization currently in use and what steps should be taken during the upgrade to first understand the customization need and then later try and replace them in existing 11.5.9 and if not possible then to modify and use it in 11.5.9 Company - Texas Instruments – Dallas TX Title - Sr. Analyst Order to Cash Lead Duration - Jan 04 – Feb 05 Environment - Upgrade project we are going from 11.0.2 to 11.5.9 / 10 and I am helping with the upgrade of OM, Pricing, iStore, iPayment, Workflow, Procurement - Purchasing, Average costing, Inventory, WIP, Projects Oracle TAR and Toad. Role - Oracle Application Manufacturing Functional Consultant Texas Instruments Inc is industry leading technology product design / development, manufacturing and distributing company with products like DLP Chipset, Sensors & Controls, Educational technology and calculators to name few. Texas Instruments Inc is an Information Technology company with leading edge technology products and constantly adding new product to its portfolio. Responsibilities/Tasks: • Responsibilities as Senior Analyst included but not limited to - setting up and upgrading from 11.0.2 to 11.5.9 OM, Pricing, iStore, iPayment, Workflow, Purchasing, Average costing and Projects. • This is a multi – Org setup • Prepared Documentation on performed Setups and changes to the environment • Prepared training Documentation • Analyzed Denial Party Listing setups - Export Compliance Screening (Workflow Steps – Customization of Data pull as per business needs – who will get the notification and approval steps) • Setup Transaction types using customized workflows tested actual stimulated business processes • designed regression testing for testing of normal order flow based on business as done in current 11.0.2 • tested upgrade of all the modules, used oracle 11i upgrade tool to do the upgrade • Performed post upgrade setups and tested each module for issues • Responsibility and Menu (includes Customization) setup to meet and exceed the new D&B requirements • Research and analysis of the Global Order Promising (Pros and Cons) visa a via our current business structure and helped the technical team implement the Oracle Global ATP Server and the Global ATP API’s to help NON-Oracle Applications access global order promising. Helped configuring sources of supply and demand. • Developed Implementation Strategies for GOP, considering -Multi-Org impact, Legal • Gap analysis performed between existing webstore and iStore • Performed the recommended setups for test and performed test cases ( setup and integration between iStore and ONT/QP) • Integrated iPayment with iStore for CC processing and helped determine ways to encrypt data • Extensive Testing of ipayment for CC processing using CC processing companies. • Advance pricing setups for Charging Freight Charges based on Shipping Methods in iStore. • Identified and implemented conversion of WebStore Customers to FND Customers for iStore • Performed standard setups based on multi-org for catalog’s , shopping carts and orders, help setup text messages, workflow email notifications • Developed and documented test case scenarios and assisted in configurations for Order management, Inventory, Receivables and purchasing • Added a config validation step in WF to suite the business need for custom and config packs • Setup performed for Denial Party Listing (Export Compliance Screening) for iStore ( part of ONT setup) designed Workflow steps as per the business need • Performed standard setups based on multi-org for catalog’s , shopping carts and orders, help setup text messages, workflow email notifications • Analyzed Business needs and performed GAP analysis of different types of Custom workflow • Performed setup for workflow and added workflow to transaction types in OM, workflow engine, email notification • Performed setup and monitored workflow for oracle purchasing • Analyzed and customized Denial Party Listing (Export Compliance Screening) to meet and exceed business need • Texas Instruments Inc does reporting in Data warehousing helped the technical team locate the data from oracle tables to populate DW Reports • Documentation included but limited to – Customization, Setups and Training. • Customization worked on – WF, Config Validation, trigger for – items in price list, Freight Charges in OM, and Freight Charges through iStore, Denial Party Listing – (converted it to internal process then STD external) • Data corruption issues because of the upgrade scripts being vanilla and the reports being out of data warehouse (meaning all ids become more important as DW looks at the ids) – like picking_line_id, Source_line_id, WF not being assign to upgraded TT types etc. handled and solved the issues with Oracle over the Tar and internally with Dev and DBA’s • Helped the client on the process of Tar Escalations – setup a Tar conference with oracle. • Worked on Data tie –outs. • Worked with the upgrade assistance tool and S.S. • Helped the client understand and use complete quick order entry forms and quick customer entry forms • Helped oracle fine tune the quick customer entry forms as there were some form designing issues which were brought to their attention Company - Hanover Compressor Company, Houston – TX Title - Sr. Oracle Application Analyst Duration - Sep 03 – Jan 04 Environment -OM, Pricing, Workflow, Procurement - Purchasing, Average costing, eAM Inventory, WIP and Projects, Oracle TAR and Toad. Role - Oracle Application Manufacturing Functional Consultant The Hanover Company is the leading provider of natural gas compression services, maintaining a 3.7-million-horsepower rental compression fleet that is the largest in the industry. Hanover also provide parts and service for our installed base of compression equipment, treatment services, compressor fabrication, production equipment fabrication, and measurement services. Hanover operates mostly across the Western Hemisphere, including Argentina, Venezuela, Mexico and Canada. We continue to expand into Europe, Asia, and Australia. Responsibilities/Tasks: • Production Support Lead for Oracle 11.5.8. Modules: Inventory, Manufacturing, Enterprise Asset Management, WIP, Workflow, Order Management, Advanced Pricing, Purchasing, Projects / Contracts and AP • Environment includes multiple Legal Entities, Operating Units and Organizations for worldwide operations grossing several billion dollars per year • Responsible for Setting up and monitoring Regression Test Plans for upgrades to 11.5.9 • Responsible for Setting up and monitoring Regression Test for various modules for patch set upgrade i.e. eAM • Prepared end-user documentation for Training and support • Provided end-user support and training • Providing post-implementation end-user support for Phase 3 (International) and 4 (Manufacturing) go-live • Work with Shop Floor Managers/Department Manager, Business Consultants, software developers, users and process owners to compile and prioritize enhancements and defect resolutions to proprietary and non-proprietary applications nationally and Internationally (Canada) • Identified issues with 11.5.8 eAM, helped solve them and upgrade to 11.5.9. Company - Mediacopy, El Paso – TX Title - Oracle Application Analyst Duration - July 03 – Sep 03 Environment - OM, Pricing, Workflow, Procurement - Purchasing, Inventory, WIP and Projects, Oracle TAR and Toad. Role - Oracle Application Manufacturing Functional Consultant World's leading DVD replicator and CD duplicator, offering full-solution support with a full range of packaging, distribution, warehousing and fulfillment services. Responsibilities/Tasks: • Lead support role for all new features for Order Management, and Shipping. Testing new functionality while identifying old custom functionality that can be replaced. Testing all aspects of the upgrade in relations with Order Management and some features of WMS. Training on all new functionality and new business process with Order Management, Advanced Pricing and Shipping execution. • Preparing gap analysis: business requirements vs. Oracle 11i functionality. • Working with end-users on Usability Analysis • Preparing end-user documentation • Providing end-user training • Helped with setting up Barcode’s in INV Module to enhance productivity • Providing post-implementation end-user support • Work with Shop Floor Managers/Department Manager, Business Consultants, software developers, users and process owners to compile and prioritize enhancements and defect resolutions to proprietary and non-proprietary applications Company - Retriever Payment Systems, Houston TX Title - Oracle Application Analyst Duration - March’02 till June’ 03 Environment - Implementation of Oracle 11.5.4 and later upgrade to 5.8, ERP, manufacturing modules, including Order Management, GOP, Advance Pricing, Shipping, Inventory, Purchasing, BOM, WIP, iSupport, iStore, Installed Base, Knowledge Base, Receivables, Payables, General Ledger, Oracle TAR and Toad. Role - Oracle Application Manufacturing Functional Consultant Subject matter expert working on the Implementation of Oracle 11.5.4 and later upgrade to 5.8, ERP, CRM and manufacturing modules, including Order Management, GOP, Advance Pricing, Shipping, Inventory, Purchasing, BOM, WIP, iSupport, iStore, Installed Base, Knowledge Base, Receivables, Payables, General Ledger. Responsibilities and duties included: • Acting as system administrator, managing the functional set-ups for Oracle Order Management/ Manufacturing/CRM modules. • Research and analysis of the Global Order Promising (Pros and Cons) visa a via our current business structure and helped the technical team implement the Oracle Global ATP Server and the Global ATP API’s to help NON-Oracle Applications access global order promising. Helped configuring sources of supply and demand. • Developed Implementation Strategies for GOP, considering -Multi-Org impact, Legal • Compliance and Language barriers • Developed International trading model, Intercom any transactions and oracle multi-org structure models for GOP. • Helped the management Balance planning, operational, finance and legal requirements from country to country GOP. • Got knowledge base of How to implement GOP by searching the Internet, reading, Oracle.com and asking fellow managers questions about the GOP “as There is not ONE correct setup for international implementations” And preformed impact analysis to • Achieve global objectives. • Facilitating resolution of interface errors. • Carrying out unit and integration testing of data flow between inventory, purchasing, Order Management, Accounts Receivables modules • Helped in developing Custom Workflow in Order Management module to monitor credit worthiness of PO customers, Custom activity in this workflow will monitor custom interface table, which get populated through EDI from 3rd party financials institute and release sales order for pick release activity. • Developing SQL*Loader script to load the item master data file and purchase order receipt file from legacy system into the Oracle Applications and developed corresponding interfaces for Inventory, Order Management and Purchasing applications. • Conducting functional design and functional testing for new projects. • Working with internal end-users to document business and functional requirements. • Preparing gap analysis: business requirements vs. Oracle 11i functionality. • Preparing plan to address the gaps and track progress of modifications that address the gaps. • Working with end-users to document reporting requirements (types of reports, report formats, etc.) • Generating sample reports (prototype) for customer review and approval. • Serving as the liaison between end-users and the technical team • Keeping end-users apprised of project status throughout the project lifecycle • Preparing workflow documentation to understand internal interface requirements (e.g., between the various Oracle modules) and external interface requirements (e.g., between Oracle modules and external systems) • Participating in software testing to prepare test plans / test cases, reviewing test results, helping document bug reports • Working with end-users on Usability Analysis • Preparing end-user documentation • Providing end-user training • Providing post-implementation end-user support • Work with Department Manager, Business Consultants, software developers, users and process owners to compile and prioritize enhancements and defect resolutions to proprietary and non-proprietary applications • Developing/Customizing reports, creating concurrent programs for reports and registering them in Applications • Creating database objects for item master conversion and PO receipt interfacing • Assist client in analysis, design and implementation of an EDI system. Responsibilities included: functional design, technical specifications, and programmers supervision • Helped the development team in analyzing, designing and developing the EDI interface for Internal Sales Orders. • Helped in Modifying, the Invoice Print Report and the Purchase order Print report in 6i for printing the EDI enabled records. • Creating Menus, Functions, Users, Responsibilities, Descriptive/Key Flex fields, Request groups, and Value sets. Company - Application Technologies, Inc. Bethesda, MD Title - Oracle Application Analyst Duration - March’01 till Feb’02 Environment - Implementation of Oracle Applications 11.0 & 11i: Order Management, Advanced Pricing and Shipping, Inventory, Purchasing, BOM, WIP, and MRP, AOL, Sys admin, Oracle TAR and Toad. Role - Oracle Application Manufacturing Functional Consultant Provider of a broad range of integrated end-to-end solutions, which include project management, package implementation, systems integration, outsourcing and training. Responsibilities included: • Setting up of item-container relation ships, transaction Types, Order Import Sources, Document Sets, Freight Carriers, freight costs, pick slip grouping rules, Release sequence rules, shipping parameters etc • Extensively worked in defining the pricing contexts, qualifier contexts, qualifier attributes, modifiers, price lists, price breaks and discount breaks. • Trained the users for processing the orders through different order cycle steps like Order Entry, Order Booking, Order Scheduling, Pick Release, Ship Confirmation, creating deliveries, trips and stops etc • Carrying out unit and integration testing of data flow between inventory, purchasing, Order Management, Accounts Receivables modules • Developing/Customizing reports, creating concurrent programs for reports and registering them in Applications • Carrying out set up in Inventory and Purchasing modules including defining Inventory Organizations, Shipping Networks, master and organization Items, item categories, Buyers, Positional hierarchies, approval groups, approved supplier lists, sourcing rules, Assignment sets • Defining master and organization items, item category flex fields, item catalogs and UOM classes. • As a member of the Conversion & Interface team, responsible for mapping legacy data elements to corresponding Oracle Fields, writing conversion, technical design specifications, documents. Designing & developing strategies to convert data - including mapping rules, cross reference tables and development of programs to convert the legacy data into Oracle, design & development of validation programs to check the accuracy of the conversion process as a post conversion step... • Created Vendor Performance Report that lists Vendor Name, Materials Supplied, Planned & Actual Delivery Times, Payments Terms and Prices. • Created a Report to display a list of Purchase Requisitions, Release Date, Item, Quantity and Unit of Measure along with standard details. • Created customized reports for price lists, Item / customer level sales orders break up etc • Creating concurrent program executables and concurrent programs and attaching the concurrent programs to the Request group • Creating Menus, Functions, Users, Responsibilities, Descriptive/Key Flex fields, Request groups, and Value sets. Company - NetworkXchange Inc Centerville VA. Title - Oracle Application Analyst Duration - Feb’00 till Feb’ 01 Environment - Implementation of Oracle Applications 11.0.3 upgrade to 11.5.4: Order Entry/Order Management, Inventory, Purchasing, BOM, WIP, AOL, Sys Admin Role - Oracle Application Manufacturing Functional Consultant Responsibility: • Involved in the Requirement Gathering, Functional Design, Technical Development and Implementation of the Custom Interfaces and Custom Report(s). • Carrying out integration testing of data flow between inventory, purchasing, Order Management, Receivables modules • Interacting with different level of users, determining and documenting detail Functional and Technical design specification • Setting up of price lists, order types, Order cycles, pick slip grouping rules, release rules, freight carriers, shipping parameters etc • Setting up of inventory organizations, Operating units, Legal entities, Master and Organization item attributes, shipping networks. • Carrying out unit and integration testing of data flow between inventory, purchasing, Order Management, Accounts Receivables modules • Defining the Material costs, Resource costs, Department overheads and checking the item costs in the BOM • Designed and developed Technical Solutions in Inventory and BOM. • Customized interface solutions include Item Revisions, Categories, and Locators with Restriction Controls. • Designed an Interface Program (Concurrent SRS) for Model Class Items. This interface is aimed at creating new Inventory /BOM Items, dynamically, as and whenever new items are created in legacy. • Creating Menus, Functions, Users, Responsibilities, Descriptive/Key Flex fields, Request groups, Value sets, Registration of custom Tables in to Oracle Applications using AD_DD packages and registration of concurrent programs. • Designing the logical and physical database structures, creating tables, views, synonyms, sequences, Database triggers, indexes. • Developing/Customizing reports, creating concurrent programs for reports and registering them in Applications. • Creation of descriptive Flex fields in various forms to add more information that is necessary for business. • Extensively used AOL European Tour - May 99 till Jan 2000: I had the unique opportunity to visit the 10 best Industries in the Europe with Industries like the Tusen Steel Plant In Germany, Mercedes Production Plant in Germany where they product E and S class cars, Compaq, Bayer, Deutsche bank, The Smart production facility, the GM gearbox plant in France, French Wine productions etc. to name a few. We had traveled by road within Europe and the whole project was conceived to understand the Business Models of each company, we had lectures by the head of each dept or the Top ranking officers in the ORG, This tour added more then 10 years of actual Job Experience in my life. We were divided into 4 groups and my group’s project was to dissect the Automotive Industries focus comparisons where the production process at Ford Motors and the Production process at Mercedes Plant in Germany and we had to present our view at the end of the tour. FUNCTIONAL EXPERIENCE DETAILS: Held various administrative and management positions in sales, customer service and Plant Management areas for various employers, in my non- oracle work exp of 6 yrs. |