Data Analyst Business

Gary Klavan 973-***-**** • **********@*****.*** • LinkedIn

Personal Summary

Highly experienced and motivated business data analyst with a demonstrable track record of successfully delivering. Seeking a new challenge.

Skills

Excel VBA SQL LookML Tableau PowerBI

Professional Experience

Maxsip Telecom, Valley Stream, NY

Business Data Analyst Mar 2024 - Aug 2024

● Responsible for daily credit card transaction reconciliation, analysis and reporting with PowerBI and Excel. IDT Telecom, Newark, NJ

Manager - Commercial Wholesale Reporting 2011 - 2024

● Responsible for all operational reporting and profitability analysis for Wholesale Telecom division.

● Provided analysis support to Telecom Finance for managing financial projections and operational complexities.

● Migrated over 200 reports from Hyperion to Looker by creating new data types in LookML to minimize the need for post BI Excel transformations.

● Reduced daily analysis time by over 25% by designing and maintaining a well-integrated enterprise system responsible for operations and A/R invoicing for over 50% of IDT’s business.

● Managed global data team standards and procedures across a wide array of data disciplines to meticulously ensure top-notch business intelligence reporting within Looker and Tableau. Manager - Commercial Performance Management 2005 - 2010

● Designed new reports in Hyperion and Excel which saved over four million dollars in traffic loss incidents by decreasing data processing time by 75%.

● Created new pricing metrics and strategies to illuminate meaningful profitability tracking. Business Analyst 2002 - 2004

● Identified and mitigated cost fluctuations directly affecting gross profit and worked closely with account managers to adjust pricing policies.

● Mitigated resource contention during high-traffic incidents by leveraging a blend of technology and business knowledge to balance volume and profitability.

Operational Support Systems Engineer 1999 - 2001

● Reduce call detail record processing time by over 50% for aIl IDT DMS-300, SNSE and S12 switches by designing and implementing a new extraction package from PERL to C that translates records written in native switch fractional byte language into usable operational formats.

Director of Credit Operations 1995 - 1998

● Created new reporting systems with Acess and Excel to capture all aspects of the company’s billing system.

● Reduced time required to process and record customer payments by 50%.

● Slashed bad debt by 90% and chargebacks by over 80%.

● Enabled ACH transactions with payment processors thus providing customers with additional payment options. Paper Direct, Inc., Secaucus, NJ

Operations Research Analyst 1994 - 1995

● Optimized staffing strategy and order projection model through combining daily operational metrics with PBX data. Education

● M.B.A. in Computer Information Systems from Baruch College, New York, NY

● B.A. Cum Laude in Mathematics from Yeshiva University, New York, NY

Contact this candidate