SUMMARY

• Overall Eight years of experience in Oracle Implementations, Upgrade and Global Rollout Projects Extensive experience and expertise in Oracle Financials modules (General Ledger (GL), Payables (AP), Receivables (AR), Assets (FA), Cash Management (CM), Order Management (OM), Purchasing (PO), Approval Management Engine (AME) and Inventory (INV)
• Excellent experience in Order to Cash, Procure to Pay and Record to Report functional processes
• Extensive experience in Requirement gathering, performing Gap Analysis between standard Oracle EBS functionality and current business practice, Solution design, Set up, Configuration, Testing, Data Migration, Specifications for Customization, Documentation, Period End closing and Post implementation support.
• Experience in managing Oracle Service Requests (SR), escalating with Oracle as needed for resolution and researching Oracle patching requirements and assesses impact to common global objectives.
• Experience in Configuring Demantra webserver with Oracle Web logic, Configuring Demantra engine servers on Linux and Windows environments.
• Experience in working with business in various industries like Manufacturing, Telecommunications, Networking and Software Services Industries
• Extensive experience in implementation of various Oracle Application versions (1103, 1155, 1158, 11510 and R12) Upgrade from 107 SC to R12.
• Involved in the Case Study and Client Presentation with Oracle Consulting on R12 upgrade project
• Functional Oracle ERP (EBS R11i and R12) experience in WMS, OM, 3PL Logistics, Pricing, Shipping,ENG, CST, Quality, BOM, WIP, Inventory and Configurator.
• Well experienced in Multi - Org, Multi-Operating Units, Multi-Currency, Intercompany/Interbiling, Global Oracle Applications environment
• Merging and Roll out of different OU/Organizations into Single instance
• Excellent Business Analysis and Documentation Skills
• Strong knowledge in Data Conversion from Legacy systems to Oracle Applications for GL Balances, Suppliers, Customers, Items, Open AP and AR balances, Fixed Assets
• Have very good knowledge of various Software Development Life Cycle (SDLC), QA and Agile Methodologies
• Expertise in preparing Designing Process Flows, Test Plan, Business Case, Test Cases, Use Cases and conducting Functional Testing, GUI Testing, Regression Testing, Web Application Testing and System Testing of new/modified application modules
• Extensive experience working on Quality Center for tracking issues
• Involved in the Conference Room Pilot (CRP) to install, evaluate, and configure the functionality of the applications, identified gaps, determined solutions and tested modifications
• Participated in System and User Acceptance Testing
• Provided training to key users, end users and prepared documentation for Functional Specifications and Standard operating procedures
• Experience in interaction with various cross flow teams, onsite/offshore teams
• Aware of Oracle AIM implementation methodology

TECHNICAL SKILLS

Software/Hardware: Oracle Applications 11i & R12 (11.5.4, 11.5.7, 11.5.8, 11.5.9, 11.5.10.2, 12.0.4, 12.0.5, 12.0.6), Accounts Receivable, Accounts Payable, General Ledger, Fixed Assets, Pricing, Shipping,ENG, CST, Quality, BOM, WIP, Inventory, Customization,Cash Management, Order Management, Purchasing, Inventory, INV, PO, QA, WSH, MFG,O2C,CRM,Global R12.1.1

Oracle Implementation: Demantra7.2,ASCP, Purchasing,Manhattan Warehouse Management System ( WMOS 2003, 2006, 2008 and 2009 ), BR100,Data Model, CF250’s,PMO,TARS,Oracle Financial Analyzer, RICEW, MRP Forecasting,Application Desktop Integrator ver 7.2 (ADI), Oracle Web ADI

ERP Methodology AIM: Forms & Reports Oracle Financial Statement Generator (FSG) Reports, ADI Report Wizard and OBIEE, Operating Systems MS-Windows 95/ 98/ NT 4.0/ 2000/XP, Microsoft Windows Server 2003, Linux, Solaris, Database Oracle RDBMS 8i/9i/10g/11g,Oracle R12 ASCP, Utility Tools TOAD, SQL Developer, & Data Loader

Programming Language: SQL, PL/SQL, Project Plan Tools MS Projects, MS Visio, and MS Office

PROFESSIONAL EXPERIENCE

Confidential - Herndon, VA

Lead Oracle Project Accounting Consultant

Responsibilities:

• Worked as Financial Functional Analyst in supporting Oracle Financial R 12.1.3. Responsible for GL, AP, AR, FA, PO, INV.
• Requirement gathering and GAP analysis
• Responsibility included setting up Consolidated Schools in Primary Ledger. Scope involved, MRP Forecasting, Cost Management, Purchasing, iProcurement, iSupplier, Inventory Management,GL, AP & iExpense.
• Participate in the evaluation of Agile tools to support the SDLC, including definition of evaluation criteria, coordination of demos, and making recommendations based on process needs.
• Using Sqlldr script loading data in staging table and then calling procedures to populate the BOM interface tables
• Involved in maintenance of CRM base customization and in creating Organizational determination rules.
• Having experience in maintaining project schedules, deliverables, budgets and resources.
• Subject Matter Expert (SME) in Oracle Financials (AP, AR, GL), HRMS (Core HRMS, Payroll, Benefits), Inventory (Stocks, Manufacturing Management), OM, O2C, P2P, FA, Implementation Methodology, AIM, Oracle eBusiness Center.
• Configured different profiles in web client and performed CRM web UI settings
• Worked on Data Migrations, Extractions, Interfaces and customization of Oracle Applications EBS 10.7, 11i and R12
• Review and update business process flows to reflect in implementation of SCM.
• Created T-SQL scripts for RDBMS applications.
• Validated the functional production-readiness of new CRM system on behalf of the business prior to Go-Live.
• Worked with Middleware consultant to migrate business partner and product master data from R3 to CRM.
• Involved documenting new customizations for the Recruitment, Workforce Administration and Benefits module.
• Maintained data model and data dictionary.
• Maintained customer hierarchies, customized customer master to prevent changes to the fields owned by CRM.
• Functional Oracle ERP (EBS R11i and R12) experience in WMS, OM, 3PL Logistics, Pricing, Shipping, ENG, CST, Quality, BOM, WIP, Inventory and Configurator.
• Specialized in building various business applications using Oracle Relational Database Management System (RDBMS), implementing, solving break/fix issues, or by providing design, development, and support knowledge of RICEW objects and Java technology.
• Onsite Functional Implementation consultant supporting all SCM modules Inventory, PO, OM Integrate legacy system to Oracle Applications
• GL: Added School codes in Chart of Accounts, Updated Parent accounts, Define Legal Entity, Define Intercompany relationships, Creation of Operating Unit. Creation of new responsibility, Adding Cross validation rules.
• Thorough working knowledge of MS Office Suite (MS Office, Word, Excel, Data Entry), MEDITECH systems, TARS.
• Configured CRP's, Prepared Test Scripts,PMO,ASCP,Manhattan WMOS, Test plan, Test Scenarios, User Manuals, plan for UAT and user feedback integration.
• Strong Understanding of Business Process Cycles: Procure-to-Pay (P2P), Order/Invoice-to-Cash (O2C) including implementation and integration of Order Management, Purchasing and Inventory modules, Service contract module with Oracle Financial Modules (GL,AP,AR) and Advanced Pricing and configuration set up implemented Oracle Apps for maintaining their Project maintenance and P2P and O2C oracle process.
• Manages configurations and provides functional and technical configuration expertise within the scope of the Oracle Customer Data Hub and core EBS.
• Created SDLC documentation for a Documentum-based document management system migration and enhancement project.
• Assist in new product roll out programs for all CRP customers.
• Monitor outs and shortages to CRP/VMI customers on a daily bases.
• Implemented PMO control point measures, via SharePoint, that implement business processes and reporting procedures for global stakeholders to contribute to and monitor project activities.
• Training business and end users on CRM Web UI and implemented features.
• Gave assistance in exporting the analyzed data to RDBMS using Sqoop.
• Designed, implemented and maintained PMO work products including, program dashboard, project scorecards, project closeout checklist, KPIs, reporting metrics, RACI charts, RAID (Risk, Action, Issue and Decision) logs, CSIs.
• Worked with technical teams to collect requirements and publish SDLC documents.
• Oracle Demantra. Demand Management. Generated Forecast using Analytical engine Steps Imported Sales data, Using Demand Modeler Defined levels and Series, Build Model, Configured Forecast tree, Load the Data from Staging tables and Configured Collaborator workbench. Demantra Tables and Workflow Knowledge.
• 11i Applications modules included Inventory, BOM, MRP / ASCP, WIP, Sourcing, PO, OM, Pricing, MRP Forecasting,Shipping Execution, MSCA, Engineering, AP, AR, OKS, IB and Costing.
• Create, review and maintain detail Functional Documents like MD50,CF250 and BR100.
• Gather and map business requirements, Gap Analysis, Documentation as per AIM Methodology (RD 50, CF250,BR100)
• Designed and developed (BR100) documentation based on the system analysis done on the current 11.5.10 Application. BR100 & CF250 setups consisted of Modules from both OTC and P2P - Order Management, Shipping Execution, and Purchasing
• Working as the lead for ASCP module.
• Supporting EBS Financials module installation & maintenance: AP, PO, FA, supplier, procurement, Sourcing, Contracts, MRP Forecasting, Cost Management, Purchasing, iProcurement, iSupplier, Inventory Management,EBS administration support like Concurrent Managers, Forms/Report Servers, Web Servers, Discover, Markview, Appworx etc.
• Configuring the ASCP module as per the business requirements.
• Involved in testing the release of purchase requisitions and discrete work orders from ASCP to OLTP.
• Assisted other teams with data modeling and improving performance.
• Customization of batch programs, reports & interfaces.
• Involved in the business process meetings along with Functional resources to identify the customizations.
• Worked on various interfaces like running ASCP Collection, On hand quantities, customer bases pricelist, Open Sales Orders, final forecast, Creating a plan for Demantra.
• Having OBIEE experience with full Life Cycle of OBIEE implementation.
• Oracle Demantra. Demand Management. Generated Forecast using Analytical engine Steps Imported Sales data, Using Demand Modeler Defined levels and Series, Build Model, Configured Forecast tree, Load the Data from Staging tables and Configured Collaborator workbench. Demantra Tables and Workflow Knowledge.
• Work directly with DC end users to troubleshoot WMOS issues, revise processes / procedures and change configuration as needed to help operations team conduct business efficiently
• Recommends and implements operational process improvements based on usage of WMS platform.
• Evaluates, plans, coordinates, and tracks internal and external resources and tasks related to application implementation or enhancement of Manhattan WMOS.
• AP: Setting up Financial Options, Payable Option for each OU, Setting up new AP responsibilities, Create roles & responsibility, Assign LE for bank access, Update Security profile, Create bank accounts, Payment documents, Payment defaulting rules, Payment process templates.
• AR: Setting up Transaction types. Memo Lines, Revenue recognition rules for Avanta invoicing.
• Customized Web ADI with descriptive flexfields to populate Supplier information during upload.
• Experience in Integration of Demantra With Oracle ASCP EBS R12, Oracle Retek, SQL Server based systems(Just Enough) OBIEE .Hands on experience in Demantra Schema and Architecture.(Both Custom and Standard Data models)
• Changed SLA rules to derive accounting rules based on business requirements in Fixed Assets module.
• Created test scripts and training of end user
• Worked extensively with offshore team (Oracle on Demand)
• Provided post production support.

Environment: Windows, MS Office(MS Word, MS Excel, Demantra MS Powerpoint, MS Visio), INV, PO, QA, WSH, MFG,Oracle R12 ASCP.Cognos,PMO,AP, AR, GL, FA, NET, O2C, BR100, CF250,ERP,Oracle,Manhattan WMOS,Crystal reports, TARS,ENG, CST, Quality, RUP, UML, SQL.

Confidential, Sacramento, CA

Oracle Project Accounting Consultant

Responsibilities:

• Reviewed the Business Requirements Documents with the business and development teams and analyzed the functionality of the Oracle applications so as to finalize the solution.
• ERP Systems, SQL, Database Systems: Microsoft SQL Server, Oracle, MySQ
• Troubleshoot and resolve ERP functional System, website, software, operating system, application, and other technology issues
• ERP System deployment, updating, and administration
• Identifying standard functionality, analyze gaps document and design solution for GL & AR depending on Business requirement.
• Most experience in Planning, Supply Chain, Manufacturing Domains in following modules of EBS R12 and R11 .
• Providing solution to all tickets / defect raised by user during Business Process testing of R12.
• Having experience in maintaining project schedules, deliverables, budgets and resources.
• Subject Matter Expert (SME) in Oracle Financials (AP, AR, GL), HRMS (Core HRMS, Payroll, Benefits), Inventory (Stocks, Manufacturing Management), OM, O2C, P2P, FA, Implementation Methodology, AIM, Oracle eBusiness Center.
• Once approval from Management was awarded the (BR100) documentation was mapped out to specify the changes and setup that would need to be included
• Following and keep track of BR100 & MD050-- there may be changes to these docs depending on the reviews, testing results.
• Involved in preparing the Impact Analysis document for the upgrade of the P2P and O2C process from 11.5.10.2 to R12.1.3.
• Collaborate with clinical and practice management leadership to plan software customizations and upgrade projects;
• Validating the BR100,CF250 and actually entered data in DV1OMR if there is discrepancy- reaching out and getting the clarification from cross flows.
• Involved in Setup Requirements gathering through BR100 & MD050,CF250.
• Setup requirements data are provided in the form of BR100,CF250 & MD050 by the cross flow teams.
• Responsible for importing client data, QC check on data, answering questions concerning resident addresses and monthly resident statements
• Manage all new account conversions under CRP/VMI program
• Identify the Business requirements (BR) in various functional areas of Supply Chain for new functionality in R12 and developing System Requirements Documents (SR) by mapping the BR with Oracle EBS Standard functionality
• Worked with quality team to ensure end-products met the requirements for the new Merck SDLC templates.
• Lead SCM Support team of 4 responsible for Fleet/Logistics Program, Value Creation validation and reporting, SCM Process & Technology and Process Improvement initiatives.
• Worked closely with project management team and senior leadership in implementing and improving PMO best practices including specification of Project Life Cycle (PLC), governance and artifacts to be utilized.
• Research for accurate SARS and TARS.
• Responsible for data architecture and data model. Responsible for approving all schema changes requested by other developers.
• Proficiency in Data Modeling tools like Erwin, ER Studio and Power Designer, developing and modeling Entity Relationship diagrams, Transactional and Data Warehouse Databases.
• Gathered requirements and authored SDLC documentation (functional specifications, user requirements, design specifications, Traceability Matrices, etc.) for a new global asset management database (CMDB).
• Setting up the oracle SCM standards/processes and CM system for development groups, designing branching and labeling
• Coordinated with Project Manager, Business team for system updates and deadlines for the implementation.
• Experience in Configuring Demantra webserver with Oracle Web logic, Configuring Demantra engine servers on Linux and Windows environments.
• Involved in development of Custom Objects and worked on Demantra collaborator workbench create worksheets.
• Configures functional and technical configuration for the Manhattan WMOS application.
• Created Demantra Workflows, integration profiles for the tolerance and combination creation. Worked on Projected Inventory Analysis report for Gross Requirement and Planned Orders.
• Participate in the evaluation of Agile tools to support the SDLC, including definition of evaluation criteria, coordination of demos, and making recommendations based on process needs.
• Worked on flat file load (CSV file) into Demantra, for series baseline forecast at different levels creating cache worksheets for huge worksheets with loads of data in it.
• Configures Manhattan WMOS ie. Tasking, picking zones, wave templates, locations, WG/WA,MRP Forecasting, Cost Management, Purchasing, iProcurement, iSupplier, Inventory Management.
• Worked on various Reports, Interfaces and Conversions as part of Implementation and Demantra Interfaces to Integrate EBS.
• Responsible for maintenance support for Manhattan WMOS application.
• Develop training documents/conduct training sessions across teams for knowledge sharing as an UI and EIS expert for WMOS classic.
• Setup the IR/ISO flow for managing shipments between Koyo warehouses from ASCP.
• Set-up Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar & Currencies.
• Set-up Standard Journals, Statistical Journals, Recurring Journals and Suspense Accounts and Mass Allocation, Defined FSG's, and Open and Close Accounting Periods
• Set-up AR System option, payment term and Auto accounting.
• Created and setup customers and its profile class.
• Set-up receipt class, receipt methods, receivable activities and accounting information for revenue recognition
• Configured CRP's, Prepared Test Scripts,PMO,ASCP,Manhattan WMOS, Test plan, Test Scenarios, User Manuals, plan for UAT and user feedback integration.

Confidential - Mountain View, CA

Business Analyst Implementation of Oracle Financials

Responsibilities:

• Study of exiting business process of GL accounting
• Designed the Chart of Accounts Numbering of Cost center and Natural Account values
• Used the Consolidation feature in Oracle GL for Account Mapping of Legacy Accounts and Oracle Accounts
• Implemented Recurring Journals feature in GL
• Implemented Global Intercompany System (GIS)
• Worked on EDI (Electronic Data Interchange) Gateway for order import to oracle ERP R12.
• Hands-on experience in Developing Interfaces, Extensions in various Oracle ERP R12 modules.
• Installation, configuration, administration and integration of Weblogic / SOA with R12 ERP Platform migrations from Tru64 to OLE5 Linux 64 bit (R12 ERP application).
• Specialized in building various business applications using Oracle Relational Database Management System (RDBMS), implementing, solving break/fix issues, or by providing design, development, and support knowledge of RICEW objects and Java technology.
• Defined GIS Subsidiaries, Intercompany transaction types, Intercompany Clearing Accounts, and Auto Accounting Rules
• Implemented Consolidation billing feature in AR
• Configured the ASCP module to generate replenishment requisitions for the new DC's.
• Having experience in maintaining project schedules, deliverables, budgets and resources.
• Participate in slide presentations to potential CRP customers.
• Configured different profiles in web client and performed CRM web UI settings
• Spearheaded, designed and managed CRM Deployment and implementation of salesforce.com solution including tracking methodologies, process flows and training for sales, marketing, support, contracts, and a customer interface.
• Created T-SQL scripts for RDBMS applications.
• Guide and assist the client in defining its SDLC and QA processes by producing an MS Visio diagram depicting the respective processes.
• Exported Demantra Final Forecast to ASCP and created users and user groups and providing privileges for different types of workflows.
• Supervised the Central Receiving Point (CRP) and Port and Terminal operations.
• Modifying the accounting on the requisitions created via requisition import program from ASCP by deploying a DB trigger.
• Having OBIEE experience with full Life Cycle of OBIEE implementation.
• Supporting EBS Financials module installation & maintenance: AP, PO, FA, supplier, procurement, Sourcing, Contracts, EBS administration support like Concurrent Managers, MRP Forecasting, Cost Management, Purchasing, iProcurement, iSupplier, Inventory Management,Forms/Report Servers, Web Servers, Discover, Markview, Appworx etc.
• Involved documenting new customizations for the Recruitment, Workforce Administration and Benefits module.
• Customer service, inventory, ordering, filling, labeling, third party billing, tars upgraded EBS application and added Brazilian and French multi language, including EBS multi node application to shared application filesystem.
• Implemented Auto lock box, Auto invoicing, Auto Accounting features in AR
• Suggested Descriptive Flexi fields to track Additional information in AR
• Designed and prepared FSG's show the Profit or Loss per Balancing segment, Cost center.
• Maintained data model and data dictionary.
• Identify opportunities that can improve efficiency of business processes through the utilization of ERP functional System, software and other technology
• Utilize PLEX Manufacturing ERP System for manufacturing processes.
• Provides new and innovative alternative solutions to Advantage ERP system and application challenges via Business Process Re-engineering or Improvement (BPR/BPI).
• Strong experience in Peoplesoft Data conversions, Implementation, Upgrade, Customizations, Production support, Reports, Process, Interfaces, Queries and Scripts.
• Gave assistance in exporting the analyzed data to RDBMS using Sqoop.
• Created Demantra Workflows, integration profiles for the tolerance and combination creation. Worked on Projected Inventory Analysis report for Gross Requirement and Planned Orders.
• Involved in CRP1, CRP2 and UAT
• Designed and executed data migration strategy for master and transaction data Migrated GL balances, budgets, suppliers, customers, AP open invoices, AR open invoices and Fixed assets by using ADI tools (web ADI and Desktop ADI) and loader scripts
• Responsible for importing client data, QC check on data, answering questions concerning resident addresses and monthly resident statements
• Documentation: BR30, BP40, BR80, BR100 and TE050
• Provided user training
• Functional design for customization in AP module
• Coordination with technical consultants for integrations and customizations
• Designed month end procedures according to the companies policies and practices

Confidential - Sanford, NC

Business Analyst

Responsibilities:

• Involved in implementing and providing support for the Financial Statement Generators, AGIS and consolidations
• Developing a prototype to validate the purchase requisition approval process solution using oracle purchasing/ oracle approval management
• Supported Procure to pay and FA issues with month end and additional configurations.
• Support various customers on WMOS classic (2006, 2008, 2009 versions) as well as SCPP 2011 versions.
• Created T-SQL scripts for RDBMS applications.
• Conduct classroom and hands on training for all WMOS/WMiS, Labor and Slotting applications and modules
• Liasoned between the technical staff and the users (staff and management). Was also responsible for inter-departmental co ordination between the various teams involved.
• Having experience in maintaining project schedules, deliverables, budgets and resources.
• Mappingbusiness requirements and databases to logical data model that defines project delivery needs.
• Generate DDL statements and scripts from Physical Data Model to create objects like table, views, indexes, stored procedures and packages.
• As a Lead Engineer, experience in ERP full life cycle deployment, RICEW technical design, development, testing, and implementation, providing solutions/technical support to Weight watchers E-Business Suite and Back office systems.
• Worked on Major Frameworks of SAP CRM: CGPL (Marketing), Whitefield (Loyalty management) and BOL GENIL
• Good exposure to SAP CRM Marketing Campaign Management, Marketing Calendar, Campaign Automation, Target Groups, Segmentation, Marketing attributes, Personalized Mail forms, ELM, Lead Management
• Recommend and implement best practices and standards in line with current SDLC standards and process.
• Understand the software build, configuration and release process supporting the software development lifecycle (SDLC)
• Worked on demantra business modular to create series and levels and Demantra integration Interfaces, exported Demantra Final Forecast to ASCP.
• Setting up the ASCP instance to create internal requisitions for replenishing the Canadian warehouse from US warehouse.
• Experience in Integration of Demantra With Oracle ASCP EBS R12, Oracle Retek, SQL Server based systems(Just Enough) OBIEE .Hands on experience in Demantra Schema and Architecture.(Both Custom and Standard Data models)
• Effectively managed internal client services - which allow all users to address questions, report problems, and submit requests related to project implementation
• Prepared the data collection sheets for inventory, purchasing and Order Management modules.
• Audit field employee bill rates in GE Oracle ERPfunctional analyst system to match those in Granite billing system
• Audit Engineering Employee timecards keyed to GE Oracle (ERP) System against Granite Oracle System
• Worked on Demantra collaborator workbench to create worksheets, business modular to create series and levels and Integration Interfaces
• Setup Expense Account Rules based on company, account segments attached to categories as per business requirements
• Documented and communicated changes throughout the user organization, supporting change management and compliance.
• Worked on Lag series Import and Export Integration Interface with custom workflow and Audit reports which will run in ERP Side, APS Side and Demantra Side. Worked on Item Master update attributes, Item Import.
• Architect, design, install and implementation of SCM tools for maintaining the versions of source code, documents for various milestones and releases.
• Reviewed and improved functional designs proposed by the project team
• Reviewed and approved any configuration change documentation for General Ledger, Cash Management, Accounting Receivables and Accounting Payables
• Leading the offshore technical team and working in multiple time zones for implementing the functional and technical solutions
• Supervised the Central Receiving Point (CRP) and Port and Terminal operations.
• Undertook performance-tuning activities on the Oracle EBS applications, concurrent manager and with exceptions the database tier
• Provided daily user support for fianancial modules as and when required to resolve the application issues
• Participated in user testing and helped in migration to production for BAU activities
• Post-Go-Live production support- performed system audits and troubleshooting

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), XML, Java, Unix, C++, J2EE, JSP,ERP,RICEW, Oracle, DB2,Demantra(7.2,7.3), Manhattan WMOS,ASCP,Sybase, SQL Server Reports, TARS,BR100, CF250’s,AP, AR, GL, FA,ETL, WinRunner, LoadRunner, Quick TestPro,IBM,MDM.

Confidential, Murrysville, PA

Business Analyst

• Evaluating, and adjusting where appropriate, the company setup tables relative to the client business practices
• Responsible for functional design, configuration change, setup, test and implementation
• Developed the Ad-hoc journal reports using FSG as per the end-user requirements.
• Manage the WMOS/WMiS implementations, coordinating the pilot site and then subsequent parallel site implementations
• Standard General Ledger reports and Oracle Payables reports such as Trial Balance, Payment Register and Invoice Register using FSG as per the functional specifications.
• Having experience in maintaining project schedules, deliverables, budgets and resources.
• Extensive hands on experience of all major SCM and change mgmt tools Clear case, PVCS, CVS, Harvest, Spectrum, VSS, GIT, Subversion.
• Defined and implemented SDLC, QA, and CM process, procedures, and best practices across multiple business units. Like MRP Forecasting, Cost Management, Purchasing, iProcurement, iSupplier, Inventory Management.
• Participate in the evaluation of Agile tools to support the SDLC, including definition of evaluation criteria, coordination of demos, and making recommendations based on process needs. upgraded EBS application and added Brazilian and French multi language, including EBS multi node application to shared application filesystem.
• Customization of various functionality of Manhattan WMOS product as per client requirement.
• Provide technical expertise in the areas of server administration, networks, databases and ERP applications.
• Handling periodic ERP functional analyst data refreshes
• Worked on demantra business modular to create series and levels and Demantra integration Interfaces, exported Demantra Final Forecast to ASCP.
• Manage implementation of Manhattan WMOS products including Inbound and outbound warehouse flow along with other modules needed by client like LM.
• Creating users and user groups and providing privileges and developed different types of workflows. Developed, trained and supported key users in the areas of Oracle ASCP and Costing.
• Worked on various interfaces like running ASCP Collection, On hand quantities, customer bases pricelist, MRP Forecasting, Cost Management, Purchasing, iProcurement, iSupplier, Inventory Management,Open Sales Orders, final forecast, Creating a plan for Demantra.
• Modified Sub Ledger Accounting (SLA) definition as per client's requirement and resolve problems with SLA
• Managing a team for functional implementation of Oracle Financials (GL, AP, CM and FA modules) with localization across the organization
• Responsible for implementation of FSGs, AGIS and consolidations
• Rendering complete support and maintaining Oracle R12 financials modules
• Team up with functional teams and customer's staff and produce desirable results.
• Manages configurations and provides functional and technical configuration expertise within the scope of the Oracle Customer Data Hub and core EBS.
• Worked on demantra business modular to create series and levels and Demantra integration Interfaces, exported Demantra Final Forecast to ASCP.
• Integrating the invoices and payments data from Accounting Payables to General Ledger
• Preparing functional/technical specifications for reporting, interfaces and customizations.
• Experience in accessing data in a relational database management system.
• Translate business/functional requirements to technical team.
• Worked on Demantra collaborator workbench to create worksheets, business modular to create series and levels and Integration Interfaces
• Performed fit/gap analysis between the client's business processes and their intended use of the software, identified and communicated the solutions for the problems to the client
• Contributed to the overall strategic vision, and integrated a broad range of ideas regarding implementation and support
• Approving as well as correcting the accounting entries transferred from Oracle Payables to cover receipt accruals, invoice distributions (expense, Work in Process), payables liability and disbursements
• Defined the auto-invoice in Accounts Receivable and confirmed the auto applications.
• Review and update business process flows to reflect in implementation of SCM.
• Oracle Demantra. Demand Management. Generated Forecast using Analytical engine Steps Imported Sales data, Using Demand Modeler Defined levels and Series, Build Model, Configured Forecast tree, Load the Data from Staging tables and Configured Collaborator workbench. Demantra Tables and Workflow Knowledge.
• Assists in obtaining the approved/signed "Final Acceptance Sheet" from the client on his/her own module(s) within the project
• Attended to, researched and fixed issues that emerged from production environment