Business Analyst Senior Supply
Resume:
Anny Firman
Lincolnshire, IL *****
***********@*****.***
OBJECTIVES
Seeking a challenging position with a leading firm.
QUALIFICATIONS
Goal oriented and solution-focused individual who not only knows how to accomplish tasks well independently, but also in a team environment
Outstanding experience in project initiation and organization, problem solving & analysis
Broad understanding of computer hardware & software
Interact very well with customers, listen and understand end user requirements, work very well in team environment
Experience in business process design/redesign/modeling, SDLC, and UAT
Good work ethics, strong accountability, and responsibility
Delegating work to and supervising staff
EXPERIENCE
07/16 – Current Brunswick Corporation Mettawa IL – Senior Business Intelligence Analyst
Responsibilities:
1.Develops Power BI apps which consist of 20+ dashboards /visual tools such as Supplier Performance dashboard, Inventory dashboard, or Spend Report.
2.Maintains and updates business intelligence tools, databases, dashboards, systems, or methods.
3.Designs and maintains complex business intelligence applications using combination of Business Objects, Alteryx, Tableau, and Power BI.
4.Determines business information needs and identifies system requirements.
5.Ensures that the use of business intelligence applications enhances business decision-making capabilities.
6.Assesses data extraction, report generation, and bugs appearing in operations involving the data warehouse or applicable reporting applications.
7.Synthesizes current business intelligence or trend data to support recommendations for action.
8.Manages the timely flow of business intelligence information to user.
9.Summarizes and communicates results clearly using verbal, written, and formal presentation techniques.
10.Identifies, researches, and resolves technical problems.
11.Manages individual projects as assigned to ensure adherence to schedule, as well as quality and accuracy of delivered results
08/12 – 6/16 MEDLINE INDUSTRIES, Inc. Mundelein IL – Senior Supply Chain Analyst
Sample Responsiblities:
1. System/Software Transition Project
Planning, Managing and transitioning Fox Pro Applications to Webfocus
Planning and Managing Webfocus software migration
Prepare migration plans, communicate requirements and impact to business, perform data/code migration audit/test and exception reporting
2. Project Management
Design Medline Canada hotsheet (inventory position report) SQL table and Canada realigned sales history SQL table
Use the SQL table designed above to design corrected consumption upload files
Use the SQL table designed above to design several Ad-hoc reports such as Inventory Dollar Report, Sourcing Report, Branch Capacity Report and Master Data reports.
4. Process Improvement
Assist Implementation team with the Pre-DED (stock request) impactful analysis
Design Buyer PO review process and expediter open PO review process
Design and automate Dead Stock Reroute program (Webfocus and autosys) and write Dead Stock Reroute measurement program
Design DED (stock request) auto kill process
Design process to correct forecast with reporting
Design demand change review process
Design process to automatically block or unblock source list
5. Adhoc Reporting or Support
Support Inventory Management issues related to Reporting, Master Data, Forecasting, Data access, etc
Adhoc Reporting such as slot consumption report, epidemic spike report, sku list reduction report, new limited sourcing branches with high forecast and inventory, gross margin report to free up tight branches,etc
10/08 – 08/12 MEDLINE INDUSTRIES, Inc. Mundelein IL – Business Analyst (for Process Improvement Team)
Responsibilities:
1. Research Business Process/Logic
Meet with Directors/VP to suggest/advise area needed improvement (or needed new process) with analysis/research/report
Meet with Divisions to analyze their needs for Conversion and accomplish the Item Conversion based on Divisions’ needs
Meet with Manager/Director to improve demand planning and inventory planning process
Meet with Manager/Director to decide the input/data for Inventory Management Scorecard (e.g monthly Purchase Order net worth, total Purchase order line, $ amount resulted from item conversion)
Locate the data for Inventory Management Scorecard and design them in a monthly or quarterly report
2. Project Management
Design rules for SAP R/3 Material Update Management related to Item Conversion, Decline, Promotion, Cannibalization and New Item Process(e.g. Safety stock, Reorder point, Case Override, etc)
Involves in Material Update related to SAP R/3 and APO planning area (e.g. Material Updated based on lot sizing, DEDs or Item Conversion, design of BW Metrics)
Identify SAP R/3 Material Update Management bugs and have IS fix it
Implement Item Realignment for Item Conversion
Write Webfocus procedure to validate SAP R/3 Material Update Management changes
Work with IS to implement SAP R/3 Material Update Management.
Identify SAP R/3 Material Update Management bugs and have IS fix it
Write Webfocus procedure to validate SAP R/3 Material Update Management changes
3. Process Design/Redesign and Process Improvement
Design Item Conversion Process, Decline, Promotion, Cannibalization and New Item Process which includes Set Up (Design Reason Codes), Maintenance (Life Cycle Planning) and Completion (Master Data after completion)
Design SQL table to maintain Forecast Master Data and Forecast Master Data History. This SQL tables are used for multiple purpose such as New Item, Item Conversion, Managing Spike, DEDs, Branch Realignment, Forecast Segmentation and Item Realignment.
Design Forecast Segmentation SQL table (forecast error, bucketing, lumpiness).
Design SQL table (or Control Table) with matrix/rules for Item Conversion (Material New) that is used to set up and maintain Master Data (e.g rules related to DEDs, Bookings, Frequency, Corporate Designation, Deployment Center, SNP Flag, Req Check, etc)
Design SQL table to automatically update Item Conversion Run out Date based on Reason Code designed
Improve Month To Date Spike data used by Demand Planner to adjust spike.
Write Webfocus procedure to ensure consistency in APO Life Cycle Planner (e.g. CVC, Selection ID, or Assignment Table validation)
Write Webfocus procedure to automate Master Data maintenance according to matrix designed
Write VBA program to automate uploads to APO Life Cycle Planner
Replace VBA program with Webfocus procedures to auto upload Life Cycle Planner using APO job stream
Validate the results of the APO Life Cycle Planner auto upload job stream with Webfocus program
Manipulate LCP (APO) to work for Group Account/Customer Level Conversion, Decline, Cannibalization, etc
Work with IS to design APO forecasting tools for Seasonal Items or Promotions
Solve problem/issue related to incorrect forecast
Prepare report and do analysis for Division Product Manager (Webfocus, BEX query, etc)
Advise/Assist division to do stock transfer/reroute
Write Webfocus report to assist buyer in balancing inventory, repack/breakdown items
Design and write BSD, SID and any documents before migrating/implementing new processes, procedures, transactions or SQL tables
4. Mentoring/Training
Train analyst to takeover Item Conversion
Train/Assist buyer to use reports created/designed
Write training documents in share point
8/02 – 10/08 ALAMIO INTERNATIONAL, Lombard IL – Business Analyst
Responsibilities:
Collect data, analyze the data and formulate action items that will positively affect business metrics and profitability
Involved in forecasting and planning, budgeting, and product line reporting
Identify processes to reduce costs and increase margin
Conducting new product research and analysis
Determine pricing
Identify new market potential for existing and new products.
Work with the team to continuously improve service and delivery
Respond to customer/client inquiries
Give presentations and attend trade shows (domestically and internationally)
Set up company’s EDI system to comply to retail store requirements
Supervise operation specialist and coordinator
Automate company’s shipping by designing input to UPS software (schema, ODBC data source, etc)
4/98 – 7/02 HONEYWELL SYSTEM SENSOR, St. Charles, IL – Reliability Engineer
Responsibilities:
Perform Accelerated Life Testing on smoke detector to exceed industry standards.
Preparing test plan for the new product prior to Accelerated Life Testing.
Analyze product non-conformances and pursue corrective actions.
Evaluate the reliability of the new or current product by doing the MTBF calculation.
Participate on product FMEA for new product development.
Interact with vendors regarding component failure on a regular basis.
Set up a new database for component failure.
Write reports documenting product and component reliability.
EDUCATION
ILLINOIS INSTITUTE OF TECHNOLOGY, Chicago, Illinois
8/98 – 2/01 Master of Business Administration (GPA: 3. 56)
Majoring in Finance
8/96 – 05/98 B. S. in Electrical Engineering (GPA: 3.05)
Minoring in Business Management
TARUMANAGARA UNIVERSITY, Jakarta, Indonesia
9/93 - 5/96 Associate Degree in Electrical Engineering (GPA: 3.65)
AUTOMATIC FIRE ALARM ASSOCIATION (AFAA), Lake Mary, Florida
4/02 Certification in Intermediate Fire Alarm System
Layout, install and maintain manual and automatic fire alarm systems in accordance with applicable codes and standards.
MICROSOFT CERTIFICATION STATUS
12/98 – Present Microsoft Certified Professional (Achieved: 01/99)
Certification completed: Networking Essential, Implementing and Supporting NT™ 4.0 Workstation, Implementing and Supporting NT™ Server 4.0 in the Enterprise, Implementing and Supporting NT™ Server 4.0
8/98-8/01 APPLICATION DEVELOPER/SOFTWARE CERTIFICATION
Renewed Certification in Visual Basic 6.0
Certification in Access Programming
Certification in Visual Basic Application
Certification in LabView
Certification in Visual Basic 6.0
HONEYWELL SYSTEM SENSOR, St. Charles, IL
9/98 Certification in Internal Auditor
SKILLS
Written/Spoken Language: English, Indonesian, Chinese
Computer and Non-technical skills: WEBFOCUS, APO/DP, SAP BEX, BW, C++, JAVA, Fortran, Visual Basic 6.0, VBA, Access Programming, SQL, MS-Office Suite, PSPICE, LabView, Assembler, MATLAB, Oscilloscope, Logic Analyzer, Digital Multimeter, Capacitance meter, Ammeter, Voltmeter, Field Strength Meter, Function Generator, Temperature-Humidity Chamber
Finance skills: risk management, value added analysis, SAP, GAAP, financial statements, expense analysis,, portfolio management, financial and strategic planning, P & L management, auditing and compliance, operating and working capital, budget management, mergers and acquisitions, cash flow management, business valuations, data warehouse reporting, A/P, A/R, MS Excel, spreadsheets.
REFERENCES
Available upon request
Contact this candidate