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.

TECHNICAL SKILLS:

TOOLS: Confidential EnterpriseOne One World Tool Set (OMW, RDA, FDA, Power Forms, UTB, Event Rules(ER), Confidential Business Functions, UPK, Workflow, Business Views BDA, TDA), RPG II / RPG/400,ILE RPG, CL/400, SQL/400, DBU,DB2, Aldon, Hawkeye Pathfinder, Visual Basic, MS Access, Lotus Notes 4.6/ Domino, Oracle, SQL Server 2000, JAVA, JDBC, Java Servlets, XML, HTML, ASP, ADO, WAP, Create Forms, VB Script, Data Modeling, JDE interface with BI Publisher, MQ Series, Primavera, Oracle Test Manager, One View Reporting, Web Methods, ALM, Clarity, JIRA, Remedy

BUSINESS MODULE EXPERIENCE:

General Ledger, Accounts Receivable, Accounts Payable, Fixed Assets, Sales Order (Order to Cash), Purchase Order (Procure to pay), Distribution, Inventory, Confidential Management, Equipment Maintenance, Payroll, Human Resource, Expense Management.

PROFESSIONAL EXPERIENCE:

Confidential, Michigan

Oracle JDE EnterpriseOne Lead

Responsibilities:

• 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.
• Managed a project to decouple 28 companies from Confidential 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 Confidential 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 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 to record test scripts, defects and changes.
• 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 etc. etc.
• 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).
• Designed and developed a process to make payments (Accounts Payable) Checks and Wire through Kyriba a third party system using XML file as medium.

Confidential, Irvine, CA

Senior Upgrade Analyst Consultant

Responsibilities:

• Help in revising the current project plan according to new requirement 8.12 to 9.2.
• Help in developing the strategy to perform upgrade 8.12 to 9.2
• Get an inventory of test scripts and execute them according to the processes.
• Execute test script against different branch plants, in test environment.
• Track the custom objects, retrofit and testing, including the objects went in production after code freeze in 2013.
• Help business users to create, modify and execute the test scripts and record the defects in ALM quality system.
• Prepare a change document to present the application changes in the new release.
• Accounts Payable, General Ledger, Equipment Maintenance modules.

Confidential, Los Angeles, CA

Senior Team Lead Consultant

Responsibilities:

• Led the 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.
• Involved in the conversion process form XE to 9.0 and 9.13. There are 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 Functional for off shore team to do the development and test the functionality of the UBEs and the application
• Setting up orders to receive the purchases with the License Plate number and get the suggestions to put away location.
• Drive standardized business processes among sales and distribution systems/functions to simplify business processes.
• Configuring, testing, supporting and providing post go live support and troubleshooting of order to cash and advance pricing. 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 Confidential 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 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.

Confidential

Senior Business Analyst Lead

Responsibilities:

• Developed business blueprints for the REM process at Housing Provider to implement Confidential Module.
• Developed the strategy to implement Confidential Module keeping the requirement of interfaces in mind which involves feasibility analysis.
• Provided proof of concept, created Conference Room Pilot environment for REM.
• Responsible for developing Functional / Technical Specs for the enhancements in the REM module.
• Designed specs to develop interfaces for REM ( Confidential Management / Property Management).
• Provided support on month end rent manual billing, receipt processing, recurring billing, rent roll process for Confidential module.
• Customized JDE reports to suite the business / user requirements for REM (Property Management).
• Helped in the Implementation of Expense Management System.
• Documented the process flow to approve the expenses.
• Created UAT environment to test the expenses process and the workflow.
• Designed specs to make changes in the workflow for expense management system.
• Developed user guides and conducted training on the module
• Reviewed and analyzed existing budget upload process & suggested the better process to upload budget.
• Involved in testing of Purchase Order approval using blackberry.
• Providing functional and technical support to the users for Financial, Expense Management, Asset Management, REM modules.
• Designed functional / technical specs to develop various interfaces for AP, AR, GL, Fixed Assets, REM, budget, Job Cost, Address Book modules.
• Documented as-is and mapped to-be business process for new implementation of JDE E1.
• Provided support to convert data from legacy system to the Enterprise one for AP, AR, GL, Address Book, Fixed Assets, and Supplemental data.
• Developed documentation and training guides using UPK.
• Designed specification and developed various reports to suite business requirement.

Confidential

Systems Analyst

Responsibilities:

• Worked on a conversion project and modified RPG/400 / ILE /IV programs in order to suite the business requirement using IDS Order Entry, Purchase Order, AP, AR, GL.
• Customizations done in Confidential, AS/400 based system.
• Worked on finance and sales modules.
• The Software ABSTRACT has marked the modifications poorly.
• Identified the objects and made changes in the program using ALDON change management system.
• Discuss the changes with the user in order to satisfy their needs.
• Test programs and move them to the test environment for user testing and signoff.

Confidential

Business Analyst

Responsibilities:

• Documented as-is business processes and mapped to to-be business processes.
• Developed technical alignment, integrated purge, and data migration strategy for financial data.
• Identified data collisions, documented and developed work around strategies.
• Provided support for Purchase Order, General Ledger, A/P, A/R, Fixed Assets, Job Cost.
• Developed reports / forms using Form Design Aid, Report Design Aid, Table Design Aid, and View Design Aid, Event Rules and Confidential .
• Modified Confidential Management System leases and other applications as per the business requirement.
• Provided support on rent roll, and receipt processing.
• Designed new reports and modified existing reports as per the requirement for Confidential Module.
• Build a process to perform General Ledger posting using Confidential Standard posting programs.
• Implemented Oracle based Royalty Management System
• Implemented DB2 based Production accounting system PRISM.
• Developed program to upload data for Web methods.
• Helped in Disaster Recovery Planning to run JDE applications from another location.
• Used Aldon change management tool to check in and out the objects.
• Provide support for In house developed systems like Joint Interest Billing JIB (RPG/400), and Joint Venture Oil Sands system JVOS(RPG/400). Created different reports (IFRS), and made modifications in the system as per user’s requirement.

Confidential

Business Analyst

Responsibilities:

• Created a project plan to isolate plant from one company to another (Modules A/P, A/R, G/L, Fixed Assets, Purchase Order, Inventory and Sales )
• Designed project plan to perform related tasks.
• Defined new accounts for new company.
• Created /changed AAIs for all the modules like (A/P, A/R, G/L, Job Cost, Fixed Assets, Purchase, Sales and Distribution and Inventory).
• Segregation of bank accounts.
• Mass transfer of assets with their accumulated depreciation etc. etc.
• Transferred balances of the accounts.

Confidential, Irving

Techno Functional Consultant

Responsibilities:

• Worked on Confidential World / One World using Financial, Purchase Order, and Inventory
• Modifications and the enhancements in different modules.
• Developed programs to create inventory cubes for Power Play ( Cognos ).
• Designed and developed interface of inventory system to the GL (summary).
• Made modification in the programs written to transfer shipping information to the clients using EDI Gentran.
• Created AS/400 extract using Inventory system to display data in Cubes.
• Created/modified programs using EDI 944, 945 947 to record inventory transactions.
• Designed and developed interface of Purchase Order System to update GL.
• Created programs in VB to read AS/400 database and create XML data to communicate with BizTalk.

Confidential, Oak Brook, IL

Senior Programmer Analyst

Responsibilities:

• Exchange of item information via MQ Series between Inventory management system ( Confidential World) and the Restaurant Resource Planning System made in oracle to determine what is available and what needs to be sent, according to the different offers running at the restaurants base on their locations, size, and their previous history.
• Customization of Confidential Edward World data entry programs / reports in ILE RPG according to the business requirements.
• Customization of Confidential Edward World Programs on AS/400 RPG according to the business requirements.
• MQSI Implementation in Mc Donald’s.
• Created situations when needed in order to handle problems/situations.
• Developed programs to move data using MQ Series to the Sun Solaris System and vice versa.
• Lotus Notes data transfer using MQ Series.

Confidential, Schaumburg, IL

Senior Programmer Analyst

Responsibilities:

• Performed maintenance, Designed & Developed MIS Reports using Confidential Distribution.
• Used Transact SQL / SPL / RPG ILE on IBM AS/400.
• Designing Data Marts using SQL/400 and the front end was developed in JAVA to display the sales information/progress to the managers for the decision making purpose
• FTP Data Marts on the SQLL Server
• Worked on MQ Series to retrieve data from mainframe IBM 390 to AS/400
• Created flowcharts of the programs written in COBOL/400 to convert into ILE RPG.
• Involved in the analysis and designing of Data Warehouse.
• Created flow enabling the client to use MQSI over MQ series.
• Extensive use of Hawkeye for mass updates.

Confidential, San Ramon, CA

Senior Programmer Analyst

Responsibilities:

• Designed & developed various reports using Infinium System.
• Software 2000 (Infinium Support)
• Enhancements and modifications in the Infinium programs to meet the user requirements using RPG. Created programs, made modifications to transfer checks / invoices information in EDI format using Gentran.
• Used Aldon change management and Hawkeye Pathfinder for cross reference.
• Day to day user support and the administration of the General Ledger/ Payables / Purchase Management / Accounts Receivables / Order Processing /Journal Processing/ Vertex system.

Confidential, Sacramento, CA

Programmer Analyst

Responsibilities:

• Design and developed the interface of Service Billing System with the Confidential 7.3 Financial System.
• Supported, Enhanced / customized HR and payroll System as per business requirement.
• Designed and developed the interface of Appraisal System, Manpower Budgeting, and the Executive Information System with the Personnel and Payroll System.
• Customization of Confidential Edward 7.3 Programs on AS/400 RPG according to the business requirements.
• Created various MIS reports Crystal Report and ODBC to satisfy the GUI reporting requirements.
• Designed and developed DLLs in Visual Basic 6.0 to convert Confidential Julian Date format to the different date formats and vice versa. These DLLs were used in the Crystal Reports 7.0 to convert the date formats.
• Analyzed and documented the Confidential changes occurred in Confidential Edward’s Cum 7 programs, applied the cum 7 changes to the Confidential Edward custom programs, compiled the programs, tested, implemented and documented.
• Analyzed and documented the changes occurred in Confidential Edward’s Cum 11.