Business Analyst Lead/sr. Consultant Resume
Brentwood, TN
SUMMARY
- Business Analyst Lead/Sr. Consultant Functions
- All Aspects of Software Development and Implementation
- Software Testing including writing test scripts and supporting UAT
- Technical Documentation and Training Materials
- Knowledge of Agile and Waterfall project management
- Expert in all aspects of Retail Applications functions
- Expert Manhattan Associates PkMS / AS/400 and WMOS Unix systems 2004 support activities for 2010
- E - Commerce Retail Application Development
- Expert in Applications Design and Development for Retail Chain Companies
- Expert in Business Process Analysis and Development for Retail e-Commerce solutions
- Ability to handle entire project life cycle from conception to implementation
- Conversant with Retail selling channels concepts such as multi-channel, Omni-Channel
- Functional and Technical expert on various Retail Vendor applications such as JDA, SAP-Retail, TMS, Oracle/Retek, EPICOR, MICROS (XStore-POS and Analytics), WINDSS-POS, IBM-POS, etc
- Excellent Communication Skills
TECHNICAL SKILLS
Hardware: All aspects of Administration and Development on Oracle Server, I-Series, RS6000, and UNIX
Applications: JDA, JDA Demand, JDA Planning, Manhattan-Associates, MICROS-Retail POS (including XSTORE, XLINK, XCENTER and XBALANCE), SAP-Retail, JDA-MANUGISTICS, YANTRA, island Pacific, E3, Purchase Order Management, AP, AR, GL, Advanced Warehouse Replenishment, Advanced Store Replenishment, SAP-Retail, YANTRA, EDI, PREMENOS, GENTRAN. XML, MQ SeriesModules Merchandise Management (MMS), Inventory Management, Supply Chain, Demand planning, Order Management, Demand, Planning, JDA Fulfillment, Pricing, Costing, Replenishment, Receiving, Returns, EDI, Sales, and reporting, Tax, Markdowns, Stock Ledger, Rebates, AP, AR, GL, Cycle Counts, Allocations, Assortment Planning, Vendor Management, Data Warehousing, Interfaces to finance, AP, AR, GL etc.
Programming: SQL, PL/SQ, Java, C++, RPG3, RPG4, RPGLE, ILE, SQLRPGLE, SYNON, COBOL, CL, Open Query/400, SEU, SDA, RLU, DDS, Sub files, DBU, SQL, SAP-Retail, Oracle, SQL, PSQL, Views, Triggers, etc.
Micro Soft: Excel, Power Point, Word, MS-Project, Visio
PROFESSIONAL EXPERIENCE
Confidential, BRENTWOOD, TN
Business Analyst Lead/Sr. Consultant
Responsibilities:
- Worked with Project Manager and Business complete Implementation of TMS/Sterling
- Worked with Project Manager and Business team to team complete implementation of Average Cost and Landed Cost
- Worked with users to perform UAT…helped review UAT results and document results
- Reviewed and documented Pricing concepts, including Promo contentions and various pricing concept that that are best industry practice
- Worked with offshore team to complete development
Confidential, Framingham, MA
Business Analyst Lead/Sr. Consultant
Responsibilities:
- Worked with Business team to gather requirements on upgrading IBM point of sale (POS) applications
- Worked with Technical Team to implement ESB for Applications integration n
- Ensured that JDA Planning was communicating with other systems
- Ensured e-Commerce interfaces (to and from Host system) were working as expected
- Coordinated six teams including, IBM team, Middleware Team, offshore development team, and Q/A team
- Prepared UAT Test matrix, and worked with users to execute UAT test script
- Lead a team of 6 Developers based offshore to do coding in RPGLE and perform unit testing and system testing
- Worked with Business team to do UAT testing.
- Was responsible to prepare weekly status report and update the Project Manager on Project Status.
Confidential, Hoffman estates, IL
Senior Technical Lead
Responsibilities:
- Worked with Business team to gather requirements on Space Planning (JDA IKB) enhancements
- Developed Technical Specifications for Space Planning, Planogram, Flow Planning
- Support of 4 PKMS WHSE environments (V 2004R1 through 2010) and 1 TE environment
- Lead a team of 6 Developers based offshore to do coding in RPGLE and perform unit testing and system testing
- Worked with Business team to do unit testing.
- Coordinated implementation and deployment of JDA Intactix/Knowledge base enhancements
Environment: iSeries, AS/400, DB400, RPGLE, CLLE.
Confidential, Newton, MA
Senior Systems Analyst/Project Manager
Responsibilities:
- Lead a team of 6 programmers to implement MICROS Retail Point of Sale system, as well as Sales Audit system
- Responsible for coordinating and reviewing code change and Q/A testing, as well coordinating implementation and post implementation support
- Gather Business Requirements from business teams and turn the Business Requirements to Functional Specifications and actual deliverables.
- Coordinated Functional Specifications with Micros Development team. Was responsible to receive XSTORE/XCENTER/XPAY/XADMIN code to Q/A lab, coordinate Q/A testing, coordinate piloting releases and upgrades, as well as rollouts to entire chain.
- Responsible to document all interfaces between host applications and Micros XSTORE/XCENTER including all production support issues
- Ensured that e-Commerce channel (i-Congo) interfaced with host system correctly
- Support of 4 PKMS WHSE environments (V 2004R1 through 2010) and 1 TE environment
- Supported SAB Blue-Printing and design of SAP-Retail interfaces with JDA-MANU
- Review SOWs, Quotes and invoices and advise PM on their accuracy.
- Involved in SAP Blue Print sessions on POS inbound and outbound interface mapping, Price Events, Transfers, Purchase Orders, and Permanent Price Changes, and Promotional Price Events
- Modified RPG code where necessary to support Q/A and Production
- Reviewed PCI compliance for Credit Card Settlement.
- Created Service Level Agreement for Sales Audit between Vendor and Corporate Help Desk.
Environment: Oracle Server, AS400, i-Series, RPG, ILE, SQL, DB2, FTP, XML, MICROS XSTORE/XCENTER/XLINK (ETL)
Confidential, New York, NY
Project Analyst
Responsibilities:
- With direction from CIO and CFO, managed a team of 4 to enhance JDA Rebates, Allowances, and landed cost factors, as well as ensuring that that all Landed Cost Factors are affecting Inventory’s Average Cost and Landed Average Cost
- Responsible to test JDA-YANTRA interface bridge, including developing and executing all test cases, as well as working with users to do UAT in YANTRA and JDA.
- Responsible for all design work, including all feeds to/From Manugistics for Auto-Replenishment, Demand, Planning and Fulfillment
- Modified Vendor programs in RPGLE to fit customer requirements
Environment: Oracle Server, AS400, i-Series, RPG, ILE, SQL, DB2, FTP, XML
Confidential, Kansas City, MO
Project Lead (MMS/POS Coordinator)
Responsibilities:
- Performed Gap Analysis between Existing Customer Loyalty Application and other 3rd party Customer Loyalty Applications, and presented the findings to the business, including recommendations on both Technical and Budgetary implications
- Implemented Customer Loyalty Application
- Created interface bridge to and from JDA-MANU (for both Retail and Wholesale)
- Helped to audit Credit Card and Debit Card transactions to ensure that applications are PCI-DSS compliant
- Created Sales Reporting Applications for items sold outside Confidential Stores, such as CVS and Target.
- Cleanup all custom interfaces
Environment: Oracle, i-Series, RPG, ILE, SQL, DB2, FTP, XML
Confidential, New York, NY
Business Analyst
Responsibilities:
- Wrote specs for Legacy to JDA-MMS implementation in several applications
- Data Conversion from Legacy to MMS - Inventory, Price, Cost, SDI Outbound, SDI Inbound.
- MMS to POS Coding (Customization for KWI and EPICOR POS), Sales Audit, Inventory and Price/Cost Events
Environment: Oracle, AS400, i-Series, RPG, ILE, SQL, DB2, FTP, XML
Confidential, St. Louise, MO
Responsibilities:
- Responsible for all technical/business support of all 7 BEC Theme Parks’ Retail operations (day to day) in the following areas: (7 parks including SeaWorld and Busch Gardens)
- General JDA-MMS and Island Pacific Support
- RPG/ILE coding as well as working with vendor applications to apply program fixes
- Point Of Sale Interface - GSA to MMS, Retail Ideas, SAP and other homegrown applications, MMS/WINDSS Interface, MMS/EPICOR Interface, MMS/KWI Interface, Island Pacific/Epicor Interface
- MMS support including ad hoc reporting (SQL and general reporting)
- Supported Warehouse Functions such as receiving and inventory sync, EDI, and ensuring that Warehouse inventory is in sync with MMS which is the system of record.
- Accounts Payable (SAP) invoice matching
- Vendor Compliance Management and reporting
- Supported Help-Desk on Retail related calls
- Retail-Ideas (Data Warehouse) Support in extracting Data and providing support to users
- Was responsible to create Business Continuity plan, to ensure that business can recover from a disaster in near-real-time.
Environment: AS400, i-Series, RPG, ILE, SQL, DB2, FTP, XML, SAP, JAVA
Confidential
Business Analyst/Technical Lead
Responsibilities:
- Team lead on a of Multi-Channel Transformation team to transform a Catalog company to a Multi Channel Retail company in a team of 30 plus consultants
- Designed interfaces between JDA and YANTRA as well as YANTRA and PKMS to support Order Management. Made custom changes in YANTRA to meet Business Requirements in separating inventory for various channel such as Catalog, e-Commerce, and stores. Made custom changes to sync Inventory from YANTRA to other applications such as Data warehouse (Retail Ideas), PKMS, JDA and EVANT. Key resource in YANTRA production support.
- Team Lead for JDA-MMS Configuration, Implementations Planning, Giving JDA-MMS demos to user groups/SME, coordinating implementation of developers’ tasks with business-production, supporting UAT and System Integration testing and managing post-implementation issues
- Team Lead for configuring MMS interfaces to and from JDA-MANU for planning and fulfillment daily interfaces
- Team Lead for Multi Channel Transformation’s increment one phase to implement Item, vendor, Price, Cost and Purchase order in JDA.
- Technical lead for Multi-Channel Transformation’s increment two’s inventory conversion from legacy to JDA-MMS, including all aspects of inbound inventory interfaces to and from JDA MMS
- Worked Enterprise Solutions Architect to ensure that teams where using preferred corporate standards in design and development. For example, implementation planning had to ensure that all teams’ interfaces where channeled through Web-Methods in canonical designs, unless otherwise exempted by Enterprise Architect.
- Full Security Configuration and Implementation, Testing Support (UAT and Integration Testing), Supporting development of training material
- Evant Replenishment Orders Design to MMS (all interface requirements and Schedules)
- Leading Design work for MMS order interfaces to YANTRA (Ordering Applications)
- JDA-Arthur Planning, Configuration and Interfaces
- Leading Design work to create Architects certified interface bridge for JDA to/From PKMS/Manhattan Associates
- Leading Design work for Web Methods Publish/Subscribe Interface Process using canonical interface designs that enable general communications between all platforms and all applications
- Developing Training materials, as well as supporting training sessions of over 7,000 users nationwide
- Was responsible to create Technical Documentation for most of the enterprise applications, and supported SMEs (Subject Matter Experts) in creating User Reference Documentation
Environment: AS400, i-Series, RPG, ILE, SQL, DB2, FTP, XML, SAP, WEBMETHODS, POS-WINDSS
Confidential, Chicago, IL
Project Lead
Responsibilities:
- Technical Lead in a team of 6 to design and develop JDA-MMS interfaces to and from to EDI. Responsible to gather business requirements and prepare business documents, develop executive summaries, supervised team of developers, work with users to support UAT, Prepare Technical Documentation.
- Worked with EDI team on other platform to customize various EDI segments (Orders, Acknowledgements, ASN and Invoices). Developed System Test Plan and Application Test Plans, as well as Test Scripts.
Environment: AS400, i-Series, RPG, ILE, SQL, DB2, FTP, XML, POS-WINDSS, POS-IBM
Confidential, Columbus, OH
Applications Developer
Responsibilities:
- Provided technical support to Confidential ’ host system (AS400/JDA) to take third party UPCs. The process included creating algorithm logic to validate UPC-a, UPC-e, EAN-8 and EAS-13. If UPCs are not validated, POS cannot receive or scan third party UPC. My role included involved reviewing Business Requirements, converting Business Requirements to Technical Specifications, Programming, Testing, Change Management and Documentation.
Environment: AS400, i-Series, RPG, ILE, SQL, DB2, FTP, XML, SNADS, Oracle, POS-WINDSS, POS-IBM
Confidential, Los Angeles, CA
Applications Developer
Responsibilities:
- Created RAA (Return Authorization Application) that is supplementary to JDA-MMS RTV (Return to Vendor Application) to enable the company to analyze monthly returns. Role involved meeting with the users to gather business requirements, develops technical specifications, programming, testing, implementation and training.
- The RAA application functions include Return Level Simulation and Analysis, Emailing Suggested Returns to the Distributor to obtain RA (Return Authorization), Forward Authorized returns to store managers for picking, and later interfacing returns with financial application
Environment: AS400, i-Series, RPG, ILE, SQL, DB2, FTP, XML, VB
Confidential, Canton, MA
Business Analyst
Responsibilities:
- Performed EDI gap analysis between company divisions, as well as gaps between different releases of JDA. Developed Business Requirement and Technical specifications including test plan and test scripts for EDI 810/832/850/856 and Cash Management Application.
- Participated in Redesigned ACH mainframe COBOL application to an AS400-RPGILE Application. The application design was upgraded to include Application Security, Firewall and well-coordinated Service Level agreements. Involved entire project cycle from discovery phase to testing and implementation
Environment: AS400, i-Series, RPG, ILE, SQL, COBOL, DB2, FTP, XML
Confidential, Lexington, MA
Applications Developer
Responsibilities:
- Designed and developed application to support Virtual Warehouse (a business requirement to separate wholesale inventory from retail inventory).
- Custom module interfaced with JDA-MMS module of Inventory Managements, Transfers, Return to vendor, Physical inventory, and all other aspects that involve inventory movement.
- Helped to test and Implement JDA-MMS interface to Arthur Allocation and PKMS.
Environment: AS400, i-Series, RPG, ILE, SQL, DB2, FTP, XML
Confidential
Applications Developer
Responsibilities:
- Created training materials for user training for JDA-MMS Automated Replenishment module
- Trained users on how to use JDA-MMS Automated Replenishment
- Designed and coded process to Interface JDA-MMS to PKMS
- Retrofitted Customer JDA-MMS 4R5 with JDA-MMS 4R0/EB-UK custom fits in Transfers, Return To Vendor, Sales Audit, and Stock Ledger.
- Created JDA-MMS 4R0 custom layers to JDA-MMS 4R5 Warehouse and Distribution process
- Converted and tested Sales Audit and Inventory Management applications from JDA-MMS 4R0 to JDA-MMS 4R5
Environment: AS400, i-Series, RPG, ILE, SQL, DB2, FTP, XML
