SUMMARY

• More than 15 years of hands experience in Retail functions including POS, Inventory management, Order management, Demand planning, Assortment Planning, Replenishment, Demand Forecasting, RTV, VMI, TMS, Sales Audit, Loss Prevention, Pricing, Promotions, Cost, Distribution, e - Commerce, Customer Loyalty programs and Vendor Management
• More than 15 years of experience as a Developer and Business/Technical Analyst in core Retail functions
• Expert in Master Data Analysis including Master Table Setup, Data Mapping, and General and Ad Hoc Reporting
• Expert in Retail Applications Processes from Front to Back Office including POS, ERP, Host, Inventory, Supply Chain, e-Commerce, EDI, Finance, General Ledger, Sales Audit, Data warehouse etc.
• Technical and Functional Expert in various POS vendor applications including, ORPOS, MICROS (X-Store-POS and Analytics), Sales Force, IBM-POS, EPICOR-POS, Legacy-POS, NCR-POS, APTOS-POS
• Over 15 years hands-on Development, Configuration, Extensions, API-Integrations, in Diverse ERP Vendor Packages, including APTOS-Sales Audit, APROS-CRM,JDA-MMS, JDA-TMS, JDA-E3, JDA-Arthur, JDA-EP, JDA-MANU, JDA-INTACTIX/KB, Manhattan Associates, JDA-WMS, Red Prairie, Blue Younder
• Technical and Functional Expert in JDA-Red Prairie Implementation, Data Mapping, Integration, Modification and Custom Extensions
• Technical and Functional Expert in Manhattan-Associates/PKMS including Manhattan Scale
• Extensive experience in all aspects Master Data Management
• Technical and Functional experience in IBM-COGNOS Analytics including Integration, Configuration, Custom changes and Extensions
• Over 7 Years’ Experience in Digital Platform, Service and Transformation, including SLA and SOP.
• Expert in JDA-SCPO v7.8.0.0 (Demand, Fulfillment, Forecasting, Master planning, and Category Management)
• All aspects of TAX including, Sales Tax, Tax Holiday, Special District TAX, VAT, etc.
• Expert in IBM Sterling Commerce (V9.2.1 and V9.3.0) and IBM Sterling OMS
• Software testing - Test Cases, Test Scripts, Q/A support, UAT plan
• All aspects of Price Management, Price Change, Promotion Events, Mark Downs, Clearance, Liquidation, etc.
• All aspects of Cost Management including PO Allowances, Selling and Buying Rebates, Volume Rebates, PO Factors, Land Cost, Average Cost and Landed Average Cost
• Over 10 years’ experience Designing, Developing and Executing Learning Strategy, Learning Content and Learning Materials including Training materials, CBT, Web-Based Training, eLearning and Audio/Video Training
• Expert in PCI-DSS and SOX Compliance, including Compliance guide, Audit and Reporting
• Identity and Access Management, including LDAP, MS Active Directory and Local Security Configuration and Management
• Change Management tools including TIVOLI, ALDON, SUBVERSION and TURNOVER
• Knowledge of Agile project management including Epic definition, Story writing, and grooming, Sizing
• Expert in OMNICHANNEL Retail Solutions
• Experience in third party billing
• Over 10 Years of experience as Senior Business Process Analyst in cross-function and multi-functional teams
• Excellent Written and Communication Skills

TECHNICAL SKILLS

Hardware: All aspects of Administration and Development on Oracle Server, AS/400, I-Series, Microsoft, and UNIX.

Applications: JDA-SCPO, JDA-EP, JDA Demand, JDA-MMS, JDA-E3, Manhattan-Associates WMS/WOMS, IBM-OMS, IBM-Commerce, MICROS-Retail POS (including XSTORE, XADMIN, XLINK, XCENTER, XNBR, and XBALANCE), Oracle Applications,Siebel-CRM.SAP-Retail, SAP-IDOC, APTOS-CRM, APTOS-POS, APTOS-Sales APTOS-Sales Audit, -JDA-MANUGISTICS, YANTRA, island Pacific, E3, Purchase Order Management, AP, AR, GL, Advanced Warehouse Replenishment, Advanced Store Replenishment, SAP-Retail, YANTRA, JDA-TMS, Sterling-Commerce, EDI, PREMENOS, GENTRAN, XML, MQ Series, LDAP/MS Active-Directory

Modules: Merchandise Management (MMS), Supply Chain, Demand planning, Order Management, Demand, Planning, JDA-Replenishment, JDA Fulfillment, JDA-E3, 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, Sieble-CRM

Programming: SQL, PL/SQL, Java, J2EE, C++, .Net, RPG, ILE, ILE-Free, SQLRPGLE, SYNON, COBOL, CL, Open Query/400, SEU, SDA, RLU, DDS, Sub files, DBU, SQL, Oracle, SQL, PL/SQL.

Microsoft/Other: MS-Excel, MS-PowerPoint, MS-Word, MS-Project, MS-Visio, APIs, Google AppsMS-Share Point, Microsoft-Dynamics, Jira, Confluence

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton CA

Senior Business Systems Analyst

Responsibilities:

• Gather Business Process for Store Replenishment,
• Review JDA SOW agreed with Business
• Perform Confidential Analysis between AS-IS and To-Be
• Present CRP (Conference Room Pilot) of To-Be Application CRP to Business Teams
• Designed, Developed and Executed Learning Strategy and Learning Content for Technical and Business Audience
• Gather Business Requirements for Confidential Wholesale Enablement Initiative from Cross Functional Business
• Present Requirements to Technical Teams and outside Vendors for Development
• Worked with technical teams to enable inbound and outbound EDI transactions for wholesale customers and vendors
• Data mapping for EDI 810/820/856/875/880
• Responsible for making all architect decisions on JDA WMS including configuration, integration, custom changes and extensions
• Was responsible for Supply Chain Master Data Management including defining Source of truth, referential integrity, Data cleansing, ETLs, and maintaining proper Table index/logical views
• Responsible for Data Analysis including data mapping for Host ERP to IBM-COGNOS, publishing data to Web Methods and Subscribing to Web Methods to consume inbound data
• Create User Groups in JDAFAR and subscribe users to correct security Groups an grant access through LDAP
• Present Deliverables to the Business to confirm that Solution is aligned with approved Requirement through coordination of UAT and QA

Environment: Oracle Server, AS400, I-Series, RPG, ILE, SQL, IBM-Sterling-OMS (V9.3.0), IBM-GENTRAN, PL/SQL, JAVA, J2EE, DB2, FTP, XML, Manhattan-Associates, Manhattan Scale, LDAP (User Access), ESB(WEBMETHODS), Remedy, JIRA, Confluence.

Confidential, NE

PM/Senior Business Analyst /Data Analyst

Responsibilities:

• Acquisition Merger - Confidential Analysis on Cabela’s and Confidential JDA Merchandise Applications
• Merging JDA-MMS, IBM Sterling OMS and Manhattan-WMS in the two companies to one system on one platform (IBM I-Series)
• Responsible for Master and Transaction Data Mapping
• Responsible for Cabela’s Data Cleansing and Transformation to load historical Data to Confidential Database
• Responsible for EDI Data Mapping for PO/Invoice/ASN
• Responsible for all Source and Target ETLs for POS Logs and Inventory
• Responsible for develop RPG ILE code for Data Conversion
• Responsible for designing all Applications' Integration/Interfaces
• Responsible for populating SAP with Master Data as well as setting up IDOCs to Data Integration
• Responsible for merging Confidential and BASPRO Access Groups in LDAP
• Responsible to verify and harmonize all TMS (Transportation Management System) formula from both Companies, into one Corporate Formula Repository

Environment: Oracle Server, AS400, I-Series, RPG, ILE, SQL, JDA-TMS, IBM-Sterling-Commerce, GENTRAN, IBM-Sterling-OMS (V9.3.0), PL/SQL, JAVA, J2EE, DB2, FTP, XML, JDA-WMS, JDA-MMS (2016), SAP-Retail, IBM-COGNOS, IBM-Sterling OMS, JDA-EP, EDI, ESB(WEBMETHODS), Sieble-CRM, Remedy, JIRA, Confluence.

Confidential - Pleasanton, CA

Senior Business Analyst

Responsibilities:

• Work with Supply Chain and Logistics teams to build project plan for Pick Period Preparation
• Engage Warehouse Vendors to manage expectation on triaging anticipated issues and refining Service Level Agreements
• Engage Technical Teams that provide Level 2 and Level 3 support to manage expectation on triaging anticipated issues and refining Service Level Agreements
• Analysis of all tickets reported in the last 24 months
• Reviewed Business Requirements for WMS/WMOS order receiving, fulfillment and shipping

Environment: Oracle Server, AS400, iSeries, RPG, ILE, SQL, IBM-Sterling-OMS (V9.3.0), PL/SQL, JAVA, J2EE, DB2, FTP, XML, Subversion, TIVOLI(TMS), JDA-TMS, JDA-WMS, JDA-RedPrairie, Manhattan-Associates, ORACLE/MICROS-POS XSTORE/XCENTER/RELATE/LOCATE/, IBM-COGNOS, ESB (WEBMETHODS), Remedy, JIRA, Confluence

Confidential, San Francisco CA

Senior Business Analyst / Data Analyst

Responsibilities:

• Work with Business team to gather business requirements, Story-writing, Story-grooming, Sprint Planning
• Work with Offshore team to develop code based on business requirements
• Configured Oracle Customer Loyalty Application - RELATE
• Configured and Tested Sales Tax, VAT, SDT for Continental US, Puerto Rico, Canada, Canada-French and Brazil
• Trained users on how to Oracle Customer Loyalty Program - RELATE
• Was responsible to integrate current Customer Loyalty Application with Oracle Relate and Oracle POS -XSTORE
• Create and support UAT Test scripting and Execution
• Performed AS-IS and TO-BE Business Process Analysis and created Visual Documents for Business consumption and approval.
• POS Confidential -FIT Analysis for Current and Future state, and worked with Business teams to determine solutions
• Responsible for all Master Data Analysis including DATA MAPPING (Source/Target) between XSTORE POS to various Host ERP (MCS)
• Designed Custom Changes and Extensions to XSTORE for fixed POS and Mobile POS
• Documented Business Process Flow for Identity Authentication Process through LDAP to subscribe new users and move existing users to various Access Groups
• Worked on integrating XSTORE with IBM Sterling Commerce and IBM Sterling OMS (V9.2.1)
• Was Responsible to configure different types of Discounts and Price Events correctly
• Ensured that Merchandising activities are interfacing correctly with POS inbound and outbound
• Work with Business to plan for XSTORE roll-out in US, Canada and Brazil
• Analyzed Customer Information to ensured that the system was PCI and SOX compliant
• Worked with DBA, System Administrators and System Security team to ensure that Micros XSTORE and Host were PCI DSS compliant

Environment: Oracle Server, AS400, i-Series, RPG, ILE, SQL, PL/SQL, JAVA, J2EE, .Net, DB2, XML, ORACLE/MICROS-POS (XSTORE/XCENTER/RELATE), ESB(WEBMETHODS), EDI, Business Objects,JIRA, CONFLUENCE and Service-Now

Confidential, Middleton MA

Business Analyst / Lead Developer

Responsibilities:

• Was Lead IT person working with marketing team to Design Customer Loyalty Programs "New Business Ventures"
• Designed Application to issue and manage Discounted Gift Cards for Customer Loyalty Program
• Developed Business Requirements Document based on New Business Ventures’ Project Requirements
• Worked Development Teams to Develop Requirements and Deliver based on BRDs and Deliverables
• Gathered Code, with deliverables, from development teams and migrated to test environments
• Development of MOCA commands, GUI forms, DDA, reports and labels.
• Developed custom MOCA components and applications as Java classes using Mocha Connection, Mocha Context and Mocha Results interfaces. Wrote the code for custom MOCA exception handling using Mocha Exception base class and translated them using MOCA Message Resolver hook. Configured JDA Red Prairie web services.
• Configured JDA-Red Prairie WMS functionalities including but not limited to Receiving, Order allocation, Picking (Regular, List, Carton and Cluster picking), Loading, Cycle counting and auditing, serialized inventory tracking and data formatting and transmission to LMS/WFM.
• Modified and Configured JDA-WMS to handle Gift Cards in Order fulfillment, including card activation, order packaging and job scheduling, per Business Requirements
• Reconfigured JDA-E3 and Replenishment Orders to integrate with OMS and Commercial-Ware
• Developed Design and Technical specification
• DEsigned Interfaces to APTOS-POS, APTOS Sales Audit and APTOS-CRM
• Developed Test Plans and works with Q/A team to execute test plans and implement deliverables
• Worked with Production Team to implement the project and support Post Implementation period
• Project was implemented within budget and on time

Environment: Oracle Server, AS400, I-Series, RPG, ILE, SQL, PL/SQL, DB2, FTP, XML, REMEDY, Commercial-Ware Direct, Commercial Ware Card Services, MICROS-POS XSTORE/XCENTER/XLINK, ETL, DATA STAGE, ESB, Business Objects, Power-builder, Crystal Reports, JDA- RedPrairie, EDI, MOCA

Confidential, Brentwood TN

Project Lead

Responsibilities:

• Worked with Project Manager and Business to complete Implementation of TMS and YANTRA (Sterling- OMS).
• Worked with Project Manager and Business team-to-team complete implementation of Average Cost and Landed Cost.
• Implemented SALESFORCE for CRM with the support of SALES-FORCE Vendor
• Integrated TSC Customer Loyalty Application with JDA, SAP and SALESFORCE-CRM
• Trained users on using Sales Force
• Worked with Logistics Vertical to ensure that TMS was performing as planned
• Design, development, configuration and deployment of Red Prairie Warehouse management system. Customized, developed, setup and implementation of WMS, TMS and JDA Manugistics Demand Planning Manager.
• Supported improvement of JDA-E3 interface to SAP-Retail and SAP Business Objects using PL/SQL and RPGLE. Used TIVOLI-TMS to monitor SLAs
• Completed Micros X-Store POS implementation and helped implement operations Service Level agreements.
• Worked with users to perform UAT. Helped to review UAT results and document results.
• Provided technical support EDI processes 810, 812, 832, 849, 844, 849, 850, 855, and 856 in IBM-GETRAN, SAP-RETAIL, SAP-IDOC, SAP-FICA
• Configured and maintained VMI (Vendor Managed Inventory).
• Ensuring that Merchandising Department is setting up items in the correct departments, as well as doing hierarchy movement for merchandising correctly.
• 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.

Environment: Oracle Server, AS400, iSeries, RPG, ILE, SQL, PL/SQL, DB2, FTP, XML, MICROS-POS XSTORE/XCENTER/XLINK, ETL, ESB, JDA-TMS, JDA-EP, SAP, Business Objects, REMEDY/BMC, Turnover.

Confidential, Framingham MA

Project Manager/Business Analyst

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 - Designed all POS/Host ESB ICD (Interface Design Documents).
• Was responsible for all Data Mapping exercise
• Ensured that JDA Demand Planning and Assortment planning were interfacing with other systems
• Was Technical Lead to enhance Company Loyalty Membership Application (Legacy) with IBM-POS and Host ERP
• Ensured e-Commerce interfaces (to and from Host system) were working as expected.
• Ensuring that Merchandising Department is setting up items in the correct departments, as well as doing hierarchy movement for merchandising correctly.
• Coordinated six teams including, IBM team, Middle ware 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.
• Responsible to prepare weekly status report and update the Project Manager on Project Status.

Environment: IBM-POS, Oracle-RMS, Sieble-CRM, i-Series, Data Storage, Data Power, IBM-Sterling Commerce/Gentran, RPGLE, PL/SQL, ETL, ESB.

Confidential, Hoffman Estates IL

Senior Project Manager

Responsibilities:

• Worked with Business team to gather requirements on Space Planning (JDA IKB) enhancements.
• Developed Technical Specifications for Space Planning, Planogram, Flow Planning.
• 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 including upgrade of existing planograms and custom changes of planograms for special locations

Environment: iSeries, DB400, RPGLE, CLLE, Oracle, SQL, JDA-KB, PL/SQL, Power-Builder.

Confidential, Newton MA

Project Manager / Senior Business Analyst

Responsibilities:

• Lead a team of six programmers to implement MICROS Retail Point of Sale system, as well as Sales Audit system.
• Configure Oracle Customer Loyalty Application - RELATE, and migrated Data from Legacy Loyalty Application to RELATE
• Involved in SAP Blue Print sessions on POS inbound and outbound interface and data mapping, Price Events, Transfers, Purchase Orders, and Permanent Price Changes, and Promotional Price Events.
• Responsible for coordinating and reviewing code change and Q/A testing, as well coordinating implementation and post implementation support
• Responsible for all Master Data Analysis including DATA MAPPING (Source/Target) between XSTORE POS to various Host ERPs
• Gathered Business Requirements from business teams and turn the Business Requirements to Functional Specifications and actual deliverables.
• Coordinated Functional Specifications with Micros Development team. 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 for developing and executing Learning Strategy and content for Corporate and Field Users
• 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.
• Supported SAB Blue-Printing and design of SAP-Retail interfaces inbound and outbound
• Reconfigured JDA-WMS (Red Prairie) for integration with XSTORE and SAP
• Prepared SAP-Retail Demand Planning Requirements
• Reviewed SOWs, Quotes and invoices and advise PM on their accuracy
• Ensured selling rebates were set correctly and tracked correctly
• 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, iSeries, RPG, ILE, SQL, PL/SQL, JAVA, J2EE, DB2, FTP, XML, JDA-TMS, MICROS-POS XSTORE/XCENTER/XADMIN and Legacy-POS, ETL, SAP, Power-Builder, Crystal Reports.

Confidential, New York NY

Business Analyst / Data Analyst

Responsibilities:

• With direction from CIO and CFO, managed a team of four to enhance JDA Rebates, Allowances, and landed cost factors, as well as ensuring that that all Landed Cost Factors are affecting Inventory Average Cost and Landed Average Cost.
• Responsible for Data Analysis, Data Cleaning and Transformation of all Inventory Movement to recalculate Cost over prior 5 years
• Guided Q/A team to test new Customer Loyalty Card
• Worked with Production team to implement Service Level Agreement (SLA) for Customer Loyalty Card
• 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, iSeries, RPG, ILE, SQL, DB2, IBM-COGNOS, FTP, XML, Crystal Reports.

Confidential, St. Louis MO

MMS/POS Lead

Responsibilities:

• Supported all Retail and POS requirements in development and daily production issues.
• Performed Confidential 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
• Configure JDA-WMS and JDA-MMS
• Configured and Implemented JDA IKB Space planning, including generating and versioning Planograms
• 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.

Environment: Oracle, iSeries, WINDSS-POS, RPG, ILE, SQL, DB2, FTP, XML.