We provide IT Staff Augmentation Services!

Data Analyst (product Marketing Team) Resume

3.00/5 (Submit Your Rating)

Ramsey, NJ

TECHNICAL SKILLS

  • Proficient in Python
  • SQL
  • SAP (ERP)
  • Excel (VBA)
  • Word
  • PowerPoint
  • Outlook
  • Access
  • R - software
  • SASFluent in both Korean and English

PROFESSIONAL EXPERIENCE

Confidential, Ramsey, NJ

Data Analyst (Product Marketing Team)

Responsibilities:

  • Develop SQL database for a new item setup workflow process involves 50 different tables, queries and stored procedures interacting wif different departments.
  • Develop macro - enabled excel tools to provide automatic calculation for “cost-per-click” charge depends on teh several inputs from teh users per each machine.
  • Perform data manipulation through Python and VBA for serval versions of raw data into consolidated master table in SQL and data cleanse due to unregulated data types stems from date entry.
  • Prepare statistical pricing trends, modeling and comparison by product group and down to each serial model throughout teh entire US yearly sales volume.
  • Actively involved in data extraction, data cleaning and setup/prepare workspace, update/modify SQL, VBA and Python codes and performed calibration and generated outputs.

Confidential, Ridgefield Park, NJ

Data Analyst(Process Audit and Compliance) - Consultant

Responsibilities:

  • Analyzing and evaluating teh process audit results for 800+ service centers and presenting a performance review to upper management.
  • Updating/revising teh company’s regulations for teh Consumer Electronic division’s annual process audit in teh entire United States.
  • Daily validating and monitoring 5000+ registered technicians’ compliances to ensure teh reported data coinciding wif teh current company’s policy and procedure standards.
  • Maintaining and updating an access database of 5000+ technicians’ compliances and teh annual comprehensive process audit for all service centers.
  • Analyzing and evaluating of individual technician’s compliance.
  • Participating in a washer recall project for compiling and validating 100,000+ units data; reinforcing and maintaining regulatory procedures wif project standards daily
  • Reporting daily status of washer recall project analysis in both Korean and English to teh executive levels

Confidential, Secaucus, NJ

Planning Analyst (Accounting Staff)

Responsibilities:

  • Supported teh financial report of Confidential wif daily/weekly/monthly/yearly analysis/reconciliations.
  • Performed month and year end close, including bank reconciliations, journal entry preparations, intercompany rebills, asset disposals and asset transfer requests.
  • Oversee teh general ledger transactions and interaction of all postings of company credit card, employee expense reports, and utility expenses.
  • Evaluated and analyzed of actual results versus budget/forecast of elements of profitability and variances.
  • Monitor all east-coast subsidiaries weekly/monthly budgeted revenue and analyzed their expenditures to guide each division by company policy.
  • Presented standard monthly written and verbal reports on business performance to teh manager.
  • Researched and analyzed on teh US transportation market by ports, commodities, and transportation modes from statistical raw data.
  • Monitored office supply inventories and recording teh maintenance for office equipment and supplies general office.

Confidential, Ridgefield Park, NJ

Logistics Coordinator - Consultant

Responsibilities:

  • Coordinated 100+ containers per month.
  • Utilized SAP to facilitated movements of raw materials
  • Coordinated planning and scheduling shipment from South Korea ports to US ports
  • Analyzed and reviewed teh performance of vendors.
  • Communicated wif customers/vendors/forwarders through emails and phone calls.

We'd love your feedback!