Lead Oracle Functional/technical Analyst Resume
3.00/5 (Submit Your Rating)
Jacksonville, FL
SUMMARY
- 15+ years of experience providing end - user support, system testing, System Trainer and Subject Matter Expert. To include User Acceptance Testing. Proficient in the entire Oracle Merchandising System modules.
- RMS, RPM, SIM, RIB, ReSA, REIM, ALLOCATE, MFP
- System End-User: 8+ years of overall experience with ERP/Merchandising Systems. Highly proficient in all aspects of the entire Oracle ERP/RMS suite.
- Extensive supply chain experience as well as crisis management.
PROFESSIONAL EXPERIENCE
Confidential, Jacksonville, FL
Lead Oracle Functional/Technical Analyst
Responsibilities:
- Lead Functional/Technical Analyst for Oracle Merchandising systems.
- Served as Project Manager for all DSW-related enhancements and changes. Instrumental in keeping projects on track and delivered on time.
- Liaison between Business and IT Department, providing user support, new user training.
- Create and use PL/SQL queries for deep data mining, analysis and reporting.
- Research data anomalies and provided data corrections, resulting in successful Unix/Batch executions.
- Research database tables and analyze data and provided resolutions to Merchandising Business Partners.
- Provided ORPOS and Back Office end-user support to all Stein Mart stores.
- Reviewed Functional Specifications and Business Processes, and guided QA Team in testing forms, PL/SQL updates and patches successfully.
- Application Administrator for all Oracle Applications (multiple environments, including PROD, TST, QA).
- Authored, drafted, and published over 25 Enterprise Technical Operation Procedures (and training documents) to streamline and standardize internal processes for efficient operations.
- Medical First-Responder team member for IT Department.
Confidential, Virginia Beach, VA
Supply Chain Systems Support Analyst
Responsibilities:
- Provide end-user support and troubleshooting for all issues concerning the various RIB messages, to include those from RMS or RDM or SIM.
- Research database tables and analyze data related to Oracle Retail issues - resolve as appropriate
- Work through Appworx to monitor batches and identify delayed batches
- Plan, schedule and compile test data for numerous ongoing projects to include writing test queries and scenarios as well as tracking system anomalies.
- Exercise analytical ability, and apply a thorough knowledge of management principles, practices, and techniques to continuously monitor accuracy and efficiency of EDI and Supply Chain operations.
- Serve as primary point of contact (and subject matter expert) for functional EDI operations and matters.
- Recommend programmatic plans, alternative courses of action, policies, and future strategies to support goals and objectives related to the Supply Chain.
- Trained facilitator for small CPI and Rapid Improvement Events that help to streamline a process by partnering with business users and identifying areas that can be automated or improved, to increase efficiency and workflow.
- Design and develop interactive forms using MS Access for vendor tracking used as reporting tools.
- Completed NAVSUP Lean Six Sigma Greenbelt training, proficient in process/project analysis and value stream analysis.
Confidential, Quantico, VA
Electronic Data Interchange Manager
Responsibilities:
- Manage the functional daily electronic data interchange (EDI) operations, including planning, implementation, and maintenance.
- Coordinates internal MCCS departments and external business partners.
- Investigate and develop new EDI solutions for retail business operations and oversee implementation.
- Exercise analytical ability, judgment, discretion, and apply a thorough knowledge of management principles, practices, methods and techniques to continuously analyze accuracy and efficiency of EDI operations to recommend improvements.
- Run pilot testing, gather data, check system entry, result analysis, and recommend or delay progress. Recommend programmatic plans, alternative courses of action, policies, and future strategies to support goals and objectives.
- Successfully implemented the EDI 850, 810 and 856 transaction data sets at Confidential Exchange with an initial go-live that was lauded as "outstanding, and effortless" by our EDI partners (SPS Commerce and vendors).
- Completed user-acceptance testing and final implementation of the EDI860 document with very few issues, a seamless transition from the 850 Replacement document for both the MCX Buying Teams as well as the vendors.
- Assisted in providing New Associate Training for the Merchandising Systems.
- Maintained data integrity by monitoring and validating system settings in RMS using Web Queries, IBIS and COGNOS reporting systems.
- Perform deep data mining to evaluate and improve the overall Merchandise Replenishment Program.
- Managed replenishment process and partner with the Buying Teams to ensure accuracy of the program and secure sales levels.
- Reviewed historical data and current trends to identify opportunities by line of business.
- Monitored review cycles and replenishment results and make recommendations for changes to increase sales.
- Assisted the MCX Buying Teams with monitoring and maintaining open-to-buy and established analysis tools (in Excel and Access) to streamline the process.
Confidential, Virginia Beach, VA
Supply Chain Systems Support Analyst
Responsibilities:
- Directly responsible for the testing and implementation of the Oracle Merchandising System/ERP, which includes testing of base code and further testing of custom code for NEXCOM and User-Acceptance testing.
- Provided direct end-user support for all aspects of the RMS system with focused support for allocation issues.
- Troubleshoot RMS/Allocate/RDM problems using TOAD while tracking system anomalies.
- Trained all new Corporate associates on all aspects of the merchandising systems.
- Troubleshooting pricing problems, interface issues and direct communication with the stores and warehouses to resolve system-related problems.
- Provided end-user support for Inovis, authored numerous Discoverer reports for use by end-users.
- Directly responsible for inventory management of a $30M department.
- Maintained stock levels at the Distribution Center, as well as 104 stores, to ensure goals are met for sales, stock turn, inventory levels and in-stock percentages.
- Managed new and existing store assortments, monitoring sales daily and making required adjustments based on EOM Sale and Inventory reports and store requests.
- Instrumental in the analysis of data pertaining to Task Force Uniform (TFU) project. This included the impact it would have on phased out uniform items, and the projected addition of over $100M for the project rollout.
- Directly responsible for the financial plan, provided weekly sales/inventory projections to the DMM/GMM for review.
- Participated with senior level active-duty Confidential personnel (O6 and above) on conference calls and in meetings preparing for TFU.
- Assisted in maintaining day-to-day operations of the Audio and Video Electronics Departments.
- Utilized Oracle Merchandising System, and other legacy merchandising systems, to troubleshoot both HQ and Store level issues.
- Assisted in maintaining stock assortments and replenishment values
- Managed sales information with Data Warehouse and I assisted in monitoring the Master Stock Assortment.
- Performed Category Scorecard evaluations to optimize the various assortments based on store size and location.