SUMMARY

• Information technology professional with strong business knowledge.
• Strong familiarity with project management methodologies and ability to handle multiple projects.
• Good understanding of relational database, business intelligence, and data warehouse concepts.
• Experience in implementing and maintaining quality and compliance standards and procedures.
• Result oriented with excellent leadership, communication, analytical and team skills.
• Strong experience in all phases of Software Development Lifecycle (SDLC) using Waterfall, Agile/Scrum, and Software Testing Life Cycle (STLC).
• Create Functional Specifications Document (FSD)/Functional Document Design (FDD), Technical Document Document (TDD), Nonfunctional Requirements Document and Use Cases Specifications.

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead Consultant

Responsibilities:

• Analyzed /defined the process of Sales Order based on client requirements from sales order creation to sales update in the AR.
• Automated the integration process - data flowing through mainframe EDI 850 to JDE to create sales orders using (F47071/F47072).
• Overall worked to fulfill the functional needs of Sales Order and Advance Pricing systems.
• Designed functional / Technical specs for Debt Management System (Treasury) developed in house.
• Configuring Debt Management System helped in to integrate with the Accounts Receivable and General Ledger modules.
• Data Conversion activities / support for Debt Management system.
• Helped in testing of data conversion and integration activities.
• Helped to determine item upload integration process.
• Define security and test security based on different type of roles.
• Performed GAP analysis and converted the existing sales order manual process.
• Tested interfaces for Cycle count to update the inventory system using F4141Z1.
• Provide FDD and TDD for developer to perform development.
• Conducted Training / UAT Sessions.
• Created UDOs, CafeOne interface as per user requirements POC for mapping forms created on JDE.
• Developed (Integration Solution) orchestration interface for Sales Order using orchestration studio, proof of concept.
• Provided Training to the Associate Junior Developers.

Confidential

Technical Lead Consultant

Responsibilities:

• Managed a project to decouple 28 companies from JD Edwards system and moved them to Oracle EBS, which involves AP/AR and GL account changes. (Kyriba, AR Recon, Expense Management, Hyperion Extract)
• Managed data conversion project to move 28 companies Address Book, AP, AR, GL, Fixed Assets data from JDE to EBS.
• Developed functional specification to exchange data between JD Edwards and Oracle EBS for intercompany GL transactions.
• Managed project to deactivating Business Unit, GL accounts, changing AAIs, helped in writing functional specification to close, open POs, invoices, and vouchers.
• Performed extensive Fit Gap analysis to identify the business rules and determine the risks involved in various processes.
• Use Agile/waterfall development techniques to review existing BRDs, and develop FDDs.
• Helped in retrofitting objects affected in the upgrade from 9.0 to 9.2.
• Used HPQC/ALM to record test scripts, defects and changes, create test plans, and schedule to execute the test plans as per the availability of the staff.
• Helped in modifying BSSV integration process to consume data in JD Edwards.
• Manage off shore teams of developers using agile/waterfall approach to manage small projects.
• Providing functional/Technical specs to support Sales, Procurement, and finance modules like AP / AR / GL and Fixed Assets.
• Developed functional/Technical Specs for off shore team of developers.
• Involved in segregating the accounts of a company which has been sold, so all the activities related to data conversion of closing accounts, open POs, SOs, Invoices, vouchers, need to be transferred.
• Setting up functions and formulas for timecard new and modified the old ones.
• Managed project for Lot Tag information, and helped in designing and the development of multiple forms, table triggers for Lot Tag file.
• Developed BI Publisher report for bill of material related information.
• Presently designing/developing a process to create purchase order, on behalf of buyers receiving the purchase orders, and shipping them directly to the buyer by creating sales orders (direct ship), based on the demand/planning created by JDA system.
• Setting up functions and formulas for timecard new and modified the old ones.
• In Payroll, modified and created new DBA Groups, Pay types, Deductions, Benefits, Accruals.
• Setup processing options for P051121 Speed Time Entry.
• Applied GEO Codes/Sales tax rate updates (using vertex) and performed testing using SQL Server database.
• Wrote conversion programs in RPG400/LE as no expertise available using legacy system AS/400.
• Designed and developed a process to make payments (Accounts Payable) Checks and Wire through Kyriba a third party system using XML file as medium.
• Worked closely with EBS SMEs, and identified, analyzed the core requirements and key features of the ongoing projects.
• Facilitated user interviews and workshops to gather requirements.

Confidential

Senior Development Team Lead Consultant

Responsibilities:

• Helped in developing data conversion process from 9.0 to 9.13 which involves 8 Distribution Centers, setting up conversion rules with the help of business, listing out the exceptions and resolve the exceptions.
• There were over 20 instances of Distribution Centers running XE and data is being merged into E1 version 9.1.3 (with DSI/WMS/Initial Target Manhattan then moved to JDE WMS System)
• Design, developed the UBEs and then performed testing and checked the functionality of the UBEs and the related applications
• Setting up orders to receive the purchases with the License Plate number and get the suggestions to put away location.
• Created functional design for an interface to up load the pricing information into JDE.
• Involved in the support of Sales & Distribution, WMS, Purchase Order, Accounts Payable, Accounts Receivable, General Ledger, and in house build systems.
• Document AS-IS process, TO-BE process and completed fit-gap analysis and determined the customization strategy.
• Setting up AAI, DMAAIs, UDC, Document types, Line Types etc. etc.
• Summarization of EDI 810 Invoice for duplicate items.
• Help user testing scripts using Oracle Test Manager.
• Involved in developing procedures on AS/400 and JD Edwards to move tables into JDE 9.0
• Developed functional and technical documentation.
• Developing FTP routines in RPGLE and CL 400 to accommodate user requirement.
• Developed / Retrofit applications, UBEs for XE, 9.0.
• Developed various reports in BI Publisher, to satisfy the needs of business
• Unit testing of the UBEs and the application after retrofitting.
• Developed Purchase Order, Invoices, labels and various to print in BI Publisher.
• Used Boomerang to transfer code from XE to 9.0 & 9.1
• Designing/Developed (UBEs/Forms) interfaces to upload HAVI/HUB pricing into JDE on daily and monthly basis. Provided User documentation/training to correct the information and upload the prices.