Anny Firman

* ******* **.

Lincolnshire, IL *****

630-***-****

advonz@r.postjobfree.com

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