SANJAY PAGIDIMARRI
Summary
Over ** years of experience in IT with proven performance in the Analysis,
design, development and Testing of software applications and interfaces
using various ERP systems.
Expertise in Software Development Life Cycle(SDLC) which has various phases
like Requirements Gathering, Analysis, Designing, Coding, Testing, Release
& Maintenance.
Extensive knowledge in Supply Chain Management Sales Order, Manufacturing,
Inventory, Procurement, Shop floor, Warehouse Management System, Capacity
Management
Expertise in Financial - General Ledger, Accounts Payable, Accounts
Receivable, Fixed Assets
Expertise in software packages JDEdwards World (A5.2, A6.2, A7.3 Cum 12,
A9.1), One World (XE, Enterprise One,8.10), WMS - SOFTEON,JBA System 21,
JDA, PkMS, PRMS, Retail Pro 7, RMS, MS OFFICE, MS Project, MS Visio
Languages and Tools
Strong Knowledge of: AS/400, DB2/400, RPG III/400/IV/ILE/Free Format,
CLP/400, SQL/400, FTP, JAVA 1.1, SDK 1.3, embedded SQL, Dream Writer,
Showcase, WDSC, Object Management Workbench (OMW), Enterprise Report Writer
(ERW), Form Design Aid (FDA), User Defined Codes (UDC), Data Dictionary
(DD), Table Design Aid (TDA), Table Conversion (TC), Debugging Tools (ER
Debugger, Visual C++, ISDB), STRATEGY2.0, Essabase, Crystal Reports, Client
Access, SDLC, ODBC, ALDON, Implementer, ROBOT Job Scheduler, Hawkeye,
Turnover, Implementer
Clients
SONY - SONY MUSIC, SONY DADC, SONY ENTERTAINMENT, SONY DADC-CANADA .
BED BATH & BEYOND . P/KAUFMANN . LVMH . UNILEVER/CALVIN KLEIN . LOUIS
VUITTON . MERCK .
SEIKO . LAMAR . PWC (PRICEWATERHOUSECOOPERS) . VIACOM/SHOWTIME
Professional Experience
. Sr. Analyst in JDEdwards Consultant
. Project Management/Team Lead for Sony BMG outsourcing team
. JDEdwards World Upgrade Projects (A5.2,A6.3,A7.3,A9.1 in
SD,G/L,A/R,A/P)
. Technical and Business Plans with User Documentations
. Sony DADC Canada-WMS Consultant (OPM, JBA,AS/400)
. Enhancements to JDEdwards world applications
. Interface applications design, development and testing between
different packages
. Data conversion from JD Edwards world to One World
. Enhancement to SIGN System for Bed Bath & Beyond Client
. Developed EXCELDOCS, MAILDOCS Tools-Convert AS/400 files to excel and
mail services
. Article (Item) interface to GDS system from DADC, SPHE and RPS
. FTP Interface process to send the Data from GDS to other System
. Warehouse Interface development and conversion from 5.2 to 7.3
. One World Xe, data conversion and custom reports and FASTRs
. Enhancements to the interface applications with JDE/Retail Pro/RMS
. Developed interface applications to JDE Financials with Visual Max
. Developed custom fixed asset module in JD Edwards Financials
. Enhancement to Advance pricing, A/R, A/P and G/L programs and custom
reports
. Exposure with PDM and MM module
SONY - Sony Music, Lyndhurst, NJ (02/10-
Present)
AS/400 RPG Technical Consultant
. Working on JDEdwards to CDS (Oracle Application) conversion project as
part of global supply chain distribution system migration
. Involved in Project implementation, process flow charts design, test
scripts
. Develop Interface applications in AS/400 between JDE GDS to SilkRoute
(iVMI)-
. Design and develop Interface applications in JDE/ AS/400 to CTSI(CTSI
Logistics)-
. Design and Develop SBT (Scan Based Trading) application in AS/400 with
JDE Interface
. Create and execute test cases for system test and UAT
. Create user guide documentation
. Provide knowledge transfer presentation sessions for technical team
members
. Create specialized reports to facilitate SOX IT Compliance audit
AS/400, RPG/400, JDEdwards 7.3, 9.1, Oracle forms, Lotus Notes, MS-Office,
Visio
Bed Bath & Beyond, Union NJ (09/09-02/10)
AS/400 RPG Technical Consultant
. Development and testing Merchandise Store Collaboration(MSC) project,
which is demand planning system for stores based on region
. Enhancements to the Custom commercial invoice print
. Interface applications between PC based and JBA Inventory System
(VB,.NET,ACCESS)
. Developed maintenance Programs for -Merchandise Store
Collaboration(Sub files, Windows, Message subfile programs)
. Develop SCDP and PCS modification (Pool & Consolidation) enhancement,
which are purge process, 856 PASS 4 Supply Chain Feed, ASN Creation
and Upload process
. Involved with QA, UAT and production support
. Involved in SOX IT Compliance audit
AS/400, RPG Free, JDA, MS-Office, Track Record (SOX), Implementer, MS-
PROJECT, VISIO
Sony DADC, Toronto Canada (04/09-09/09)
WMS Consultant
. Implementation of SOFTEON OPM(Order Pool Management) as part of
global supply chain
. Develop Interface applications in AS/400 between JBA and OPM
. Involved in data setup in warehouse system
. Create and execute test cases for system test and UAT
. Create user guide documentation
. Provide knowledge transfer presentation sessions for technical team
members
. Create specialized reports to facilitate SOX IT Compliance audit
AS/400, RPG/400, OPM, JBA System 21, Lotus Notes, MS-Office, Visio
Sony DADC, NY (06/08 - 04/09)
Sr. JD Edwards Developer/Analyst
. Involved in custom program changes in JDEdwards Upgrade 7.3 to 9.1
financial module
. Design and program a series of custom tables, programs, menus, file
descriptions, job audits of transactional data, Dream Writers and
Job Schedulers
. Train & Support IT Staff on issues related to the operation of the
Interface as well as the dynamics of process flows
. Create specialized reports to facilitate SOX IT Compliance audit
. Troubleshoot & resolve system related glitches
AS/400, ILE, RPG, RPG/400, JDE A7.3, A9.1, FASTR, Dream Writer, World
Writer, MS-Office, Turnover, MS-PROJECT, VISIO
Bed Bath & Beyond, Union NJ (09/07-05/08)
Sr. Technical Consultant
. Enhancements to the SIGN SYSTEM-prints labels on daily basis at each
store
. Interface applications between PC based and JBA Inventory System
(VB,.NET,ACCESS)
. Developed maintenance Programs for -Category Codes, Descriptions,
Sorting ID within the Product ID (Sub files, Windows, Message subfile
programs)
. Develop custom reports, Product availability by store, Inventory
adjustment, backorder
. Involved with QA, UAT and production support
. Involved in SOX IT Compliance audit
AS/400, RPG Free, JDA, MS-Office, Track Record (SOX), Implementer, MS-
PROJECT, VISIO
Sony Entertainment Distribution, New York, NY (10/03-
07/07)
Sr. JD Edwards Developer/Analyst
. Enhancements and development in Article (Item) Interface to
GDS from DADC, SPHE Systems.
. Developed MAILDOCS (ILE RPG,JAVA), which converts Reports,
Physical files to Excel Sheets, PDF and other documents and
mail the documents using AS/400 Mail Server
. Enhancement to the FTP Inbound/Outbound and Get Process for GDS
systems
. Design and development of ISAMS interface project in JDE to the UK
affiliate
. Knowledge Transfer /Team Lead for Sony India team
. Data conversion project between JDE, OPM
. Interface applications between GDS and OPM applications
. Design and program a series of custom tables, programs, menus, file
descriptions, job audits of transactional data, Dream Writers and Job
Schedulers
. FTP Interface process to send the Data from GDS to other System
. Interface to custom distribution application to JD Edwards system
. Technical and Business Plans with User Documentations, SOX IT
Compliance
. Technical Knowledge Transfer to SONY INDIA Outsourcing Team
JD Edwards (A6.2), SDA,RDA, DD, Dream Writer, World Writer, FASTR, FDA,
ERW, BSVW, UBE, AS/400, RPG/400, ILE, RPG Free, JAVA,JDK1.2, SQLRPG, SOX,
MS-Office, VISIO, MS-PROJECT
P/Kaufmann, NY (10/02-10/03)
. Enhancement to custom applications SD, FM
. Worked on Functional Design for the Accounts Payable (A/P) system
. The Major tables involved for the A/P are the supplier Master (F0401),
AP Ledger (F0411), AP Matching Document (F0413), AP Matching Detail
(F0414)
. Involved in Upgrade from A7.3 cum 12 to A8.1 and custom applications
are modified based on the SAR's from JDE. Changes to Dream Writer,
Processing Option, FASTR reports
JD Edwards A7.3, A8.1, DD, Dream Writer, AS/400, RPG/400, ILE, MS-PROJECT
PREEMPT, LLC, MN
Sr. JD Edwards Consultant
Louis Vuitton, NA, NY (01/02-10/02)
. Interfaced and collaborated with MIS staff on project requests,
requirements and feasibility to meet high priority computing needs
. Analyzed, developed and implemented for software modifications and new
development
. Create/modify/format/enhance reports by using the Report Design Tool
in JDE World
. Utilized Report Design Director to design and set up basic report
elements in JDE World
. Developed technical documentation and training
Unilever/Calvin Klein Cosmetics, NJ (06/00-10/01)
. Involved in product allocation interface to the affiliates, sales and
G/L reconciliation system
. Custom reports and maintenance screens - Bill of Material inquire
. Developed and support warehouse interface from Trend setter to JDE
. Custom enhancement to PDM and Material Management modules
. Conversion of applications from 5.2 to 7.3 cum 11. FASTR and World
Writer Reports
. Developed according to user requirements
. Data analysis and conversion data for One World XE
JD Edwards (A5.2, 7.3, B7331), SDA, RDA, DD, DreamWriter, WW, FASTR,
AS/400, RPG/400
VIACOM - ShowTime, NY (01/00-05/00)
. Involved in the interface programs in JD Edwards distribution,
inventory module with Retail Pro and RMS warehouse systems
. Involved in the interface programs in JD Edwards A/P, G/L module and
BEX interface
. Ad hoc reports developed using FASTR, STAR reports
MERCK - NJ -Technical Consultant (11/98 - 12/99)
. Worked with JD Edwards Systems OneWorld XE and World A7.3 on Financial
Module
. Development and implementing interface programs for Fixed Assets from
GEAC mainframe system
. Major Application development in Fixed Asset like Direct purchase,
Capital project, Transfers, and Retirements. FASTR reports generations
. Involved with Year 2000 assessment
. Enhancement to custom JDE programs in financial module
. Created upgrade plans, performed upgrades B7332 to XE, Data conversion
from B7332 to XE On going data refresh and conversion to XE. Data
refresh between development/prototype and production
JD Edwards World (A7.3) OneWorld (XE), FM, PDM, AS/400, RPG/400, ILE, WW,
DD, Dream Writer, FASTR
PRICEWATERHOUSECOOPERS, LLP, NJ (07/97 - 10/98)
Senior Associate (SEIKO, Mahwah, NJ)
. Worked with JD Edwards System Package in SD/FA module
. Enhancements to custom applications from mainframe to JDE
. Designed and developed complete new system for MRA returns
(Merchandise Return Authorization) for warehouse
. Developed interface batch programs, which downloads the orders to PkMS
in Warehouse
. Involved in developing advanced pricing and product preference
profiles
. Developed reports like, A/R aging over 90 days, royalty, product
preference error generation
. Implement new applications into production
. Support AS400 applications currently in production
JD Edwards (A7.3), SD, FM, PDM, PKMS, AS/400, RPG/400, WW, FASTR, DWV
Global Software Solutions, Chattanooga, TN
Programmer Analyst
Lamar, Inc. Minneapolis, MN (01/97-06/97)
. Custom enhancements to JDE System.
. Development and testing to Inventory and Financial running
applications.
. Develop custom applications and reports like daily orders, customer
month end and year to date sales to the clients
. UAT, Regression Testing applications and system performance were done
. Data migrations from mainframe to AS/400 system and client server
applications were developed.
IDSI, Inc. Chattanooga, TN (08/96-12/96)
. Developing, Modifying and Testing of Automatic Data Collection system,
integrated with PRMS Modules like RC/SC/ Inventory movement,
adjustment and disposition movement
. Custom modifications to IDSI Application and testing through LRT (Bar-
code Scanning) Spectrum
Status Permanent Resident (Green Card Holder)
Education & Certification
M.S Electrical Engineering, University of Tennessee at Chattanooga, TN
B.S Electrical Engineering, Sri Krishna Devaraya University. India
J.D. Edwards Developers Immersion Class
JD Edwards World Technical Foundations, New Jersey
JD Edwards World Advanced Programming Concepts & Skills, Costa Mesa, Ca
JD Edwards One World Technical Foundation, New Jersey
Member of APICS
JD Edwards Northeast Chapter Member