JOHN CHOI
Norcross,USA
Summary
Results-oriented data analyst with 10 years of experience delivering actionable insights through data evaluation and interpretation. Proficient in data mining, visualization, and statistical modeling to analyze business objectives and develop comprehensive dashboards/reports using Excel and Power BI. Skilled at fostering collaboration and serving as a liaison between cross-functional departments to ensure data accuracy and optimize work procedures.
Overview
16
16
years of professional experience
Work History
Marketing Analyst
Mellow Mushroom
07.2023 - Current
- Established test and control groups to ensure marketing effectiveness.
- Used SQL spreads to accurately categorize thousands of SKUs and new items
- Continuously keeping up with trends within the industry and competitive research
- Track, analyze, and report marketing initiatives and provide KPIs on the impact to the business
- Provide detailed sales and pricing guidance reports to all franchisees and stores
- Organize and lead group training sessions for data and insight platforms
- Developed dynamic Excel worksheets to boost team productivity
- Conducted market research studies to identify target audiences, assess competitive landscape and determine pricing strategies
- Created comprehensive reports on campaign performance metrics for senior management review.
- Recommended actionable improvements to management derived from in-depth KPI analysis.
- Work with IT, Operations, Marketing, with cross functional meetings to help provide data mining support and Power BI updates
Senior Product Analyst
Hyundai L&C
09.2019 - 06.2020
- Logistics cost analysis and identifying opportunities for cost improvements
- Created product pricing, promotion, product mix based of sales data and industry trends
- Led Salesforce implementation and management.
- Demonstrated success in working with diverse teams to provide actionable insights
- Developed and implemented product strategies to ensure maximum customer satisfaction.
- Conducted market research to evaluate competitor products and pricing structures
- Collaborated with cross-functional teams to ensure the successful launch of new products
- Created detailed reports outlining current product performance and potential improvements
Business Consultant
American Home Liquidation
10.2017 - 09.2019
- Improved financial status by analyzing results; monitoring variances; identifying trends
- Researched market price to determine competitive product pricing and placement
- Managed advertisement and sales via social media and other marketing channels
- Provided strategic advice to senior management teams on how to maximize profits and streamline operations.
- Assisted with creating marketing campaigns to increase sales and brand awareness.
Sales Analyst
Pepsico
09.2012 - 06.2017
- Assessed effectiveness of various sales and marketing strategies
- Drafted weekly and monthly reports on sales trends.
- Coordinated meetings, projects and conference calls with marketing, operations and sales teams.
- Analyzed market trends, pricing models, and competitor data to identify opportunities for improvement.
- Conducted research on potential customers, competitors, and industry trends to inform business decisions.
- Created comprehensive reports of sales performance metrics such as lead generation, conversion rates, and ROI
- Identified areas of opportunity in current sales processes and developed solutions to improve efficiency
Project Manager
LG
04.2010 - 09.2012
- Led complex projects, monitored project performance to identify areas of improvement
- Proven ability to manage cross functional teams and optimize workflows to deliver within budget and on time
- Developed warranty program, process, and procedures still in use
- Coordinated with cross-functional teams to resolve project issues and mitigate risks
- Presented findings from data analysis in a clear, concise manner that was easily understood by stakeholders at all levels of the organization.
- Managed marketing, sales, and product placement projects
Quality Control Assistant Manager
SJA America
06.2008 - 01.2010
- Investigated defective product issues to find issues and created action plans to prevent recurrences
- Reviewed claims received by customers and submitted claims for credit to suppliers for non-conforming parts
- Developed and recorded inspection reports and documents for QC and production
- Developed, maintained and monitored quality control systems to ensure product reliability
- Conducted regular audits of production processes to identify areas for improvement in quality assurance
- Trained new employees on the company's quality control standards and procedures
- Provided technical support to other departments in order to maintain a high level of product quality
- Analyzed customer feedback and complaints in order to develop strategies for improving product quality
Education
BBA - International Business
The University of Georgia
Athens, GA05.2008
Skills
- Promotional tracking
- Product mix optimization
- Market review
- Excel expertise
- Power BI, SQL, and Tableau experience
- Trend forecasting
- KPI analysis and performance
- ROI assessment
- Pricing strategy
- Marketing strategy
- Competitor evaluation
Languages
Korean
Professional
Timeline
Marketing Analyst
Mellow Mushroom
07.2023 - Current
Senior Product Analyst
Hyundai L&C
09.2019 - 06.2020
Business Consultant
American Home Liquidation
10.2017 - 09.2019
Sales Analyst
Pepsico
09.2012 - 06.2017
Project Manager
LG
04.2010 - 09.2012
Quality Control Assistant Manager
SJA America
06.2008 - 01.2010
BBA - International Business
The University of Georgia