Data Analyst Resume
PROFILE:
- A business minded person with interest in technology. Is driven and can deliver.
- Also values quality.
- Uses collaboration to achieve both.
- Good with numbers. Likes problem solving. Intuitive, good at learning, and applying knowledge.
- Brings structure to unstructured.
- A self starter who understands that relationships progress the work. An independent person with collaborative work style.
- Analytical and process oriented.
- An accomplished Business Analyst with over 8 years of proven success in documenting, analyzing, designing, and implementing /delivering processes and systems that improved operating efficiencies through process engineering and technology projects. Keen understanding of project life cycle.
- A professional who is able to make successful industry transitions as demonstrated with over 15 years of successful career in Retail, CPG / Telecom, and Engineering industries (13 years combined in Supply Chain, of 8 years in Retail).
- Solid Business Analyst skill sets such as requirement gathering, testing, process mapping, and project management with experience in supply chain, retail (merchandising and marketing), and eCommerce areas.
- Knowledgeable in other industries and business areas due to liking to read business articles.
- Implementation experience includes working with software vendors and external resources and/or using offshore - onshore delivery model. Lots of testing including test strategy (test schedule and resource plan), test development (test scenarios and test data requirements), and test execution (validate test results, request fix, and re-test including regression) - including integration and UAT.
- A Business Analyst who understands importance of translating between business and IT - understanding business requirements and communicating that understanding to technical teams. A thoughtful person who also documents why in what documents like BRD.
COMPUTER SKILLS:
Proficient with Excel (including Pivot tables etc.), Word, PowerPoint, Project, Visio
HP (Mercury) Quality Center, Atlassian Jira ticket system
SAP (SD, MM, and WM modules)
Oracle Netsuite Order Management System, and Oracle Warehouse Management System Cloud (formerly known as LogFire, similar to Manhattan), Stibo Step (item master)
JDA Demand & Fulfillment, and JDA Transportation (formerly known as MTM)
Oracle Retail Merchandising System (RMS), Oracle Retail Price Management (RPM), Capgemni Retail Mix & Match Module (RM3), IBM Sterling Order Management System (OMS)
Slack, SharePoint
Access, SQL
AC Nielsen
CAREER HISTORY:
Confidential
Data Analyst
Responsibilities:
- Enhanced and troubleshoot Nielsen market share reporting. Raised many questions from Day 1 which led to reporting enhancements and fixes. Combined data from multiple sources and generated reporting while looking for accuracy.
- Reporting and analysis of trends and insights to executives and senior management.
- I have been travelling and working on personal projects.
- Also, I have been upgrading my knowledge in emerging technologies through seminars and reading.
Confidential
Business Analyst Consultant
Applications, software: Oracle NetSuite, Oracle WMS Cloud (aka LogFire, similar to Manhattan WMS), Salesforce Demandware, Stibo, Atlassian Jira, Oracle Retail Merchandising System (RMS), Oracle Retail Price Management (RPM), Capgemni Retail Mix & Match Module (RM3), IBM Sterling Order Management System (OMS), SAP, Slack, Google, Excel, Word, PowerPoint, Visio, Access, SQL, IBM Notes, and Legacy systems (item, vendor and location master, and WMS)
Responsibilities:
- Implemented cloud Warehouse Management System (Oracle WMS Cloud) in 6 months.
- Created requirement document in a short time. Created testing documents. Reviewed charters, interface specifications, and functional design provided by the software vendors and consultants.
- Post implementation: system support for Oracle WMS Cloud (Level 2 support). Provided after hours support and leadership in cases of a business critical application problem. Managed Help Desk tickets, and provided status reporting on Tickets, Modification and Project requests.
- Post implementation: operational support for Oracle Netsuite Order Management System - identify and notify cause of orders not flowing from OMS to WMS. Identify and notify inventory discrepancies between OMS and WMS and the root causes. Find and report bug / defects of interfaces and systems. Also identify and notify item master not interfacing from MDM (Stibo) to OMS and WMS. Supported payment token issue workaround between OMS and the 3rd party payment system. Knowledge of Salesforce Demandware.
- Captured high level current and future state processes and requirements for gift cards.
- Requirement documentation, including site visit to DC, for the shipping solution so that the vendor can present their solution.
- Knowledgeable in vendor managed inventory (drop ship and cross dock /“quick response”).
- Understands 3rd party product flow in ecommerce - through relationship with Amazon’s 3rd party merchants and through placing orders.
- Resolved system and business process issues between Confidential and 3rd party logistics provider (3PL) for the ecommerce business by bridging the gap with my expertise in 3rd party’s system (SAP).
- For example, supported reduction in over 50% of inventory discrepancies by identifying how inventory is reported by each system differently and by providing solution for synchronization.
- Enhanced system logic and interfaces between each company’s warehouse management systems.
- Skillful in high level system integration - led development packages end to end, from requirement to high level design to testing to implementation. Collaborative and assertive as the development activities involved negotiating with two 3rd parties. Managed, led, and guided testing effort including test strategy (test schedule and resource plan), test development (test scenarios and test data requirements), and test execution (validate test results, request fix, and re-test including regression). Took time to explain rational behind each test case to build rapport. Arranged implementation and back out plans.
- Interface disengagement from 3PL - Led this initiative which had high visibility. Met deadline and had minimal issues. Interrelated internal systems needed to be disengaged as well. Facilitated 10+ participants meetings and updated senior management. Tracked and followed up tasks and progress. Able to obtain cooperation from business, architects, other system administrators and developers.
- Partnered with stakeholders to elicit /gather Business Requirements and Governance for business process analysis and design for Planning, Merchandising, Promotion, and Marketing. Captured Business Process Improvement opportunities and mapped future state processes through over 100 workshops and breakout sessions for the new merchandising systems.
- Lead and implemented CubiScan interface development to upload dimension and weight information to the item master systems. 2 weeks to design and build due to consultant’s schedule and got it done.
- Development work intake (sizing and scoping /estimating works) and delivery.
- Able to leverage expertise of technical teams with collaborative style. Solution assessment and validation.
- Organized multiple initiatives from multiple stakeholders.
- Analysis to firm up requirements.
- Provided guidance to outsourced IT development team in overseas for development work (offshore-onshore delivery model). Performed data analysis via data extract.
Confidential
Business Analyst
Applications, software: JDA Demand & Fulfillment, JDA Transportation, Automated Order Management, HP (Mercury) Quality Center, SharePoint, Excel, Word, PowerPoint, Project, Visio, and Access
Responsibilities:
- Created current and future state process maps by investigating and documenting each department’s tasks, gaps, and opportunities through facilitating workshops.
- Created first ever comprehensive and consistent process maps for 7 transportation units.
- Presented complex solution (concept) in smaller pieces to build foundation and to gain acceptance from multiple stakeholders.
- Organizational Change Management - Supported Change Management by Stakeholder Analysis and by consistent and constant Communication to the stakeholders for change readiness. Created training materials (User Guides), planned training sessions, and trained users. Reduced training material production time by 50% by creating department / function matrix which identified duplicate materials.
- QA including Test Scenario, Cases, and Scripts creation and UAT. While leading test of a vendor rebuilt Legacy application, uncovered over 100 defects during a short vendor warrantee period (2 weeks of testing).
- Also, found defects from an existing application that was copied to the rebuilt application as well. Test included comparison of the application and database queried data. Most defects were fixed as a result of tenacious follow up with the vendor.
- Business Analysis - Partnered with stakeholders to gather Business Requirements and to present solutions design. Analysis included Use Cases, Gap Analysis and Cost Benefit Analysis.
- Authored and supported various project documents including Business Requirement Document, High Level Design Document, and Test Completion Report.
- Worked within a distribution center with many mechanized automations.
Confidential
Business AnalystApplications, software: SAP (SD, MM, and WM modules), Excel, Word, and PowerPoint
Responsibilities:
- Excelled in Sales Planning (annual and 3-month sale plans) and Inventory Management (Forecasting, and Replenishment) for Telecom (cell phone) division, annual revenue of half billion. The inventory management included item creation and master data management.
- Provided analytical support to the sales team, and collaborated with customers and sales on promotion and pricing. Managed inventory shortage situations extremely well.
- Resolved issues as the department’s main point of contact with finance, IT, and 3PLs, ensuring smooth business continuity. Resolved issues knowing the root cause along with the long term fix in mind.
- Lead a team of 4 individuals working in order management, inventory planning, operations, and distribution. Defined job scope and wrote job descriptions for new hires to accommodate company growth, including conducting interviews and coaching post hire.
- Reorganized team’s tasks and roles for effectiveness.
- Designed and improved layout of reports and tools in SAP, supporting IT resource to code.
Supply Chain Management Analyst
Confidential
Responsibilities:
- Managed inventory level, stock transfers, accuracy, control, scrap, and loss recovery.
- Liaised with sales and marketing to clear out excess inventory.
- Project lead for VMI (vendor managed inventory) and CPFR (collaborative planning forecasting replenishment) to improve inventory planning for key customers.
- Projects included planning, costing, system mapping, etc. Led the successful change of VMI service provider in a very short duration, including test of data interface.
- Initiated successful start-up and ownership of distribution operation for Telecom (cell phone) division, with annual revenue of half billion.
- Designed business process flow from scratch.
- Supervised logistics, distribution, and order management and fulfillment of cell phone products, including planning, scheduling, and monitoring of all distribution services.
- Accountable for vendor management of third party logistics (3PL) providers, including building relationships and purchasing logistics services of $2 million annually (includes transportation service).
- Negotiated contract, rate, and service levels, achieving annual savings of over 6.4% in 3PL rate.
- Monitored operation and inventory control of 3PL, achieving inventory accuracy of 99.9%. Inventory value over $20 million. Monitored interface of 3PL’s WMS and ERP (SAP).
- Negotiated and sold damaged inventory to refurbishers for a maximum price.
- Supervised 3PL provider change including 3 different warehouses.
- Put an end to consistent container demurrage and storage charges by effectively scheduling inbound containers (ocean freights transported by CN & CP). Permanent saving of $20,000 per month.
- Supervised Sheppard Subway track construction. Also supervised track maintenance.
- Worked many additional hours as needed to keep the construction on schedule.
Confidential
Transportation Designer
Responsibilities:
- Designed roads and performed associated engineering duties.
- Monitored construction and inspection professionals as a representative of the company on site.
- Designed roads and railways (CAD) including quantity calculations, construction scheduling, and surveying.
- Traffic study for the Mississauga region and the Airport.
- Prepared many MTO highway Proposals (in response to RFPs) including Schedules.