Data Analyst

Tony Wei

Data Analyst

*********@*****.*** 401-***-**** Cherry Hill, NJ 08034

EDUCATION

New Jersey Institute of Technology 09/2021-08/2023

MSc in Computer Science(Full-time GPA:3.45/4.0) Newark, NJ

Johnson & Wales University 09/2009-02/2012

MBA in Financial Analyst (Full-time GPA:3.55/4.0) Providence, RI

SKILLS

Software and Platform: Power BI, Tableau, Azure Data Factory, Databricks, MySQL, Oracle, Snowflake SQL, SAP HANA,

Excel, Salesforce, Github

Programming Language: Python, Java, Excel VBA, Pyspark

Certificate: Azure Data Engineering Associate

EMPLOYMENT HISTORY

JobLogic-X. LLC 03/2023-Present

Data Analyst(Green Card) Plano, TX

• Automated reporting with Power BI and Power Automate, incorporating electricity consumption data from SAP HANA and

Oracle. Reduced manual report preparation time from 5 hours to approximately 15 minutes, enhancing efficiency.

• Utilized Databricks combine to the SQL query for ETL pipelines to integrate electricity user data from ADW, enhancing

cross-validation. Developed a Power BI dashboard to improve data quality, reducing inconsistencies by ~25%.

• Developed a fraud detection algorithm like logic regression, or IQR, Z-score methods etc. that analyzes anomalies in

high-risk customer groups, cutting detection time by about 30%, enabling faster response to theft and disconnection risks.

• Optimized existing SQL queries and procedures, reducing execution times by up to 50%, thereby enhancing database

performance and user experience.

LTS NJ 02/2012-08/2019

Marketing Analyst(OPT&H1B) Mount Laurel, NJ

• Formulated and implemented annual marketing plans, budget forecasts, and profit and loss estimates to achieve sales and

profit goals for brand development, including market planning, profit/loss statements, and operational KPI analysis.

Monitored market demand and consumer behavior, coordinating with suppliers to ensure product quality and compliance.

• Conducted annual financial ratio and operational variance analyses to refine CCTV and surveillance strategies, managing

risks to ensure profit targets. Developed and implemented a cost reduction and strategic adjustment plan based on previous

year's results, focusing on product and marketing mix adjustments.

• Integrated dimension drilling, category and channel analysis, along with quadrant analysis, to enhance its product lineup and

promotional tactics. This strategy substantially boosted the company's market share in the Eastern U.S., increasing it from

12% to 23%, and at times, the market share in specific sectors even surpassed 60%.

• Developed and optimized Tableau dashboards visualizing sales data across more than 10 regional markets, which supported

real-time tracking of key metrics like sales volume and customer churn, cutting manual report preparation time by

approximately 60%.

• Enhanced customer relationship management (CRM) strategies to boost client retention and satisfaction. Implemented

advanced CRM tools to analyze interactions and data across the entire customer lifecycle, aiming to enhance business

relationships with customers, with a specific focus on increasing customer retention and driving sales growth. This proactive

approach included personalized communication and targeted marketing campaigns to ensure high levels of customer

engagement and loyalty.

Children’s Friend 09/2011-02/2012

Financial Analsyt(Intern) Providence, RI

• Responsible for preparing and auditing the Organization’s financial statements, including balance sheets,

income statements, and cash flow statements, in accordance with GAAP, ensuring the accuracy and compliance

of all accounting treatments. Maintain the accuracy and reliability of financial data through continuous

oversight and evaluation of accounting policies and procedures.

• Participate in month-end and year-end close processes, performing detailed account reconciliations and analysis

to ensure timely and accurate financial reporting. Utilize expertise to interpret financial data and trends,

supporting management in making data-driven decisions.

• Assist in the preparation and monitoring of annual budgets, conducting variance analysis between actual

expenditures and budget, identifying discrepancies, and suggesting adjustments. Enhance the organization's

financial planning and efficiency through precise financial forecasting and cost management.

• Responsible for managing and auditing paystubs to ensure the accuracy and timely distribution of employee

salaries.

Contact this candidate