SUMMARY

• Information technology professional wif strong business noledge.
• Strong familiarity wif 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 wif 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 / Languages/ Databases Used: JD Edwards EnterpriseOne One World Tool Set (OMW, RDA, FDA, Power Forms, UTB, Event Rules(ER), BSNF Business Functions, BSSV, UPK, Workflow, Business Views BDA, TDA), E1 Pages, Watch List,One View Reporting, 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 wif BI Publisher, MQ Series, Primavera, Oracle Test Manager, 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, Real Estate Management, Equipment Maintenance, Payroll, Human Resource, Expense Management.

PROFESSIONAL EXPERIENCE

Confidential, Michigan, USA

Techno Functional Lead Consultant

Responsibilities:

• Worked closely wif EBS SMEs, and identified, analyzed teh core requirements and key features of teh ongoing projects.
• Facilitated user interviews and workshops to gather requirements.
• 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 Gap analysis to identify teh business rules and determine teh risks involved in various processes.
• Use Agile/waterfall development techniques to review existing BRDs, and develop FDDs.
• Helped in retrofitting objects effected in teh upgrade from 9.0 to 9.2.
• Used HPQC/ALM to record test scripts, defects and changes, create test plans, schedule to execute teh test plans as per teh availability of teh 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 teh accounts of a company which has been sold, so all teh 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 teh old ones.
• Managed project for Lot Tag information, and helped in designing and teh 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 teh purchase orders, and shipping them directly to teh buyer by creating sales orders (direct ship), based on teh demand/planning created by JDA system.
• Setting up functions and formulas for timecard new and modified teh 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.

Confidential Los Angeles, CA

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 wif teh help of business, listing out teh exceptions and resolve teh exceptions.
• There were over 20 instances of Distribution Centers running XE and data is being merged into E1 version 9.1.3 (wif DSI/WMS/Initial Target Manhattan tan moved to JDE WMS System)
• Design, developed teh UBEs and tan performed testing and checked teh functionality of teh UBEs and teh related applications
• Setting up orders to receive teh purchases wif teh License Plate number and get teh suggestions to put away location.
• Created functional design for an interface to up load teh pricing information into JDE.
• Involved in teh 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 teh 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 teh needs of business
• Unit testing of teh UBEs and teh 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 teh information and upload teh prices.

Confidential

Senior Business Analyst Lead

Functional Lead Responsibilities

• Developed business blueprints for teh REM process at Housing Provider to implement Real Estate Module.
• Developed teh strategy to implement Real Estate Module keeping teh 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 teh enhancements in teh REM module.
• Designed specs to develop interfaces for REM (Real Estate Management / Property Management).
• Provided support on month end rent manual billing, receipt processing, recurring billing, rent roll process for Real Estate module.
• Customized JDE reports to suite teh business / user requirements for REM (Property Management).
• Helped in teh Implementation of Expense Management System.
• Documented teh process flow to approve teh expenses.
• Created UAT environment to test teh expenses process and teh workflow.
• Designed specs to make changes in teh workflow for expense management system.
• Developed user guides and conducted training on teh module
• Reviewed and analyzed existing budget upload process & suggested teh better process to upload budget.
• Involved in testing of Purchase Order approval using blackberry.
• Providing functional and technical support to teh 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 teh 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.
• Address Book (Inbound/Outbound)
• Real Estate / Property Management ( Lease/Billing information/Data Conversion)
• HC / HPIMS / Web Focus to Accounts Payable Vouchers ( Inbound)
• HPIMS to Accounts Receivable ( Inbound )
• MEIA Receipts Upload to JDE
• HPIMS to General Ledger (Inbound)
• HPIMS to GL ( Outbound )
• Real Estate Module to GL (Inbound)
• PerPas Payroll to GL ( Inbound)
• Many other Interfaces to GL
• Designed/Developed DS Budget a spreadsheet based system into Enterprise One to upload budgets.
• Writing of teh interfaces is involved all kind of development like creating UBEs/ Creating Custom Reports (comparison reports), customized existing reports, Forms, Views, Tables, Data Items etc. etc.
• Customized JDE reports to suite teh business / user requirements for REM (Property Management), A/P, AR, GL, Procurement, Capital Asset Management, Work Order, Expense Management etc. etc.
• Retrofit/customization JDE Reports, using Create Forms.
• Worked on a conversion project and modified RPG/400 / ILE /IV programs in order to suite teh business requirement using IDS Order Entry, Purchase Order, AP, AR, GL.
• Customizations done in ERP INFINIUM, AS/400 based system.
• Worked on finance and sales modules.
• Teh Software ABSTRACT has marked teh modifications poorly.
• Identified teh objects and made changes in teh program using ALDON change management system.
• Discuss teh changes wif teh user in order to satisfy their needs.
• Test programs and move them to teh 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 BSNF.
• Modified Real Estate Management System leases and other applications as per teh business requirement.
• Provided support on rent roll, and receipt processing.
• Designed new reports and modified existing reports as per teh requirement for Real Estate Module.
• Build a process to perform General Ledger posting using JD Edwards 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 teh 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 teh system as per user’s requirement.

Confidential, Scarborough ON

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 teh 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 wif their accumulated depreciation etc. etc.
• Transferred balances of teh accounts.
• Worked on JD Edwards World / One World using Financial, Purchase Order, and Inventory
• Modifications and teh enhancements in different modules.
• Developed programs to create inventory cubes for Power Play ( Cognos ).
• Designed and developed interface of inventory system to teh GL (summary).
• Made modification in teh programs written to transfer shipping information to teh 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 wif BizTalk.

Confidential, Oak Brook, IL

Senior Programmer Analyst

Responsibilities:

• Exchange of item information via MQ Series between Inventory management system (JD Edwards World) and teh Restaurant Resource Planning System made in oracle to determine what is available and what needs to be sent, according to teh different offers running at teh restaurants base on their locations, size, and their previous history.
• Customization of JD Edward World data entry programs / reports in ILE RPG according to teh business requirements.
• Customization of JD Edward World Programs on AS/400 RPG according to teh 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 teh Sun Solaris System and vice versa.
• Lotus Notes data transfer using MQ Series.
• Performed maintenance, Designed & Developed MIS Reports using JD Edwards Distribution.
• Used Transact SQL / SPL / RPG ILE on IBM AS/400.
• Designing Data Marts using SQL/400 and teh front end was developed in JAVA to display teh sales information/progress to teh managers for teh decision making purpose
• FTP Data Marts on teh SQLL Server
• Worked on MQ Series to retrieve data from mainframe IBM 390 to AS/400
• Created flowcharts of teh programs written in COBOL/400 to convert into ILE RPG.
• Involved in teh analysis and designing of Data Warehouse.
• Created flow enabling teh 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 teh Infinium programs to meet teh 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 teh administration of teh General Ledger/ Payables / Purchase Management / Accounts Receivables / Order Processing /Journal Processing/ Vertex system.
• Design and developed teh interface of Service Billing System wif teh JD Edwards 7.3 Financial System.
• Supported, Enhanced / customized HR and payroll System as per business requirement.
• Designed and developed teh interface of Appraisal System, Manpower Budgeting, and teh Executive Information System wif teh Personnel and Payroll System.
• Customization of JD Edward 7.3 Programs on AS/400 RPG according to teh business requirements.
• Created various MIS reports Crystal Report and ODBC to satisfy teh GUI reporting requirements.
• Designed and developed DLLs in Visual Basic 6.0 to convert JD Edwards Julian Date format to teh different date formats and vice versa. These DLLs were used in teh Crystal Reports 7.0 to convert teh date formats.
• Analyzed and documented teh Y2K changes occurred in JD Edward’s Cum 7 programs, applied teh cum 7 changes to teh JD Edward custom programs, compiled teh programs, tested, implemented and documented.
• Analyzed and documented teh changes occurred in JD Edward’s Cum 11.

Confidential

Programmer Business Apps

Responsibilities:

• Involved in teh implementation of JD Edwards Financials (V7.3) Implementation
• Provided support on JD Edwards system.
• Created various reports to suite user’s requirements using FASTR, World Writer, Dream Writer and RPG/400.
• Created different group of teh users.
• In house training for teh JD Edwards A/P, A/R, GL, Fixed Asset, and teh Budgeting from AL-FALAK from teh authorized company for JD Edwards in Saudi Arabia.
• Helped in setting up and configuration of AAI, User Define Code, and Address Book, Periodic process, Annual process and Chart of Account.
• Environment creation setup.
• Parallel run for three months to test teh TEMPeffects of teh transactions on teh JD Edwards.
• Production & Stock System ( AS/400 )
• Sales & Export System( AS/400 )
• Idhammar Manufacturing System( Add-ons / AS/400 to PC data Conversion
• On Call Duty System ( AS/400 )
• Plant Modification Proposal ( AS/400 )
• Unforeseen Shutdown System( AS/400 )
• Project Scheduling ( AS/400 )
• Transport Arrangement System( AS/400 )
• Plant Modification Proposal Queries( Lotus Notes )
• Non Conformity System ( Lotus Notes )
• Ticket Management SystemFoxbase
• Accounts PayrollFoxbase

Confidential

Programmer Analyst

Responsibilities:

• Analysis and design of various systems based on teh user requirement.
• Programming of teh designed systems in different environments in-house and at teh client's place.
• Installation and implementation of teh systems especially in multi-user environment.
• Conducted training programs of different PC packages, like lotus 123 and word star.
• In house development
• Personal SystemAS/400
• Cotton ExportAS/400
• Payroll SystemAS/400
• Inventory Control SystemOracle
• General Ledger Foxbase
• Excise & TaxationDbase
• Medicine InventoryFoxbase
• Billing SystemFoxbase
• Accounts Receivable Foxbase
• Electronic Correspondence Foxbase
• Short & Medium Term ForecastingFoxbase