John Kim
Wheeling,IL
Summary
An accomplished data analyst with strong experience at Ernst & Young LLP with a bachelor's degree in Information Systems and Operations Management/Business Analytics from the University of Maryland's Smith School of Business. Over 4 years of experience in data analytics, database management, and data visualization. Currently expanding expertise in UI/UX design, data engineering, and advanced analytics to enhance technical proficiency and deliver innovative solutions.
Overview
7
7
years of professional experience
Work History
Senior Technology Consultant
Ernst and Young (EY)
10.2020 - Current
- Engaged with clients to gather requirements and define Key Performance Indicators (KPIs), ensuring alignment with business objectives.
- Transformed and analyzed complex data sets, presenting actionable insights to key stakeholders to identify business risks and opportunities.
- Developed and optimized Power BI dashboards, creating interactive user interfaces that improved data accessibility and decision-making processes.
- Analyzed demand forecasting workflows using Databricks and enhanced visualizations in Tableau, increasing forecasting accuracy.
- Generated manual forecasts for stocked items, including limited-time offers and new products, utilizing R and SQL to inform inventory management strategies.
- Designed comprehensive Tableau dashboards and managed Alteryx workflows to effectively visualize and monitor key risk areas, facilitating proactive risk management.
- Provided ad hoc analytics and streamlined data reporting processes using SQL, Python, and SAS, reducing reporting time by 35% and improving data accuracy.
- Conducted market segmentation and consumer engagement analyses utilizing Databricks, leading to optimized sales strategies and a 40% increase in customer retention.
- Created a robust reporting data model and ETL pipeline for COVID-19 and personal health data in Azure Data Factory and AWS, ensuring efficient data processing and analysis.
- Designed and developed public-facing Tableau dashboards to analyze COVID-19 testing and demographic trends, enhancing public health reporting transparency.
- Developed and refined user stories to define key capabilities and functionalities for web applications, ensuring user-centric design and development.
- Designed multiple wireframes in Figma, incorporating various layouts and components to plan for future enhancements and improve user experience.
Front End Software Developer
Paradyme Management
03.2018 - 12.2018
- Developed a multi-featured android mobile application for citizens living in the greenbelt community utilizing Java and Android Studio
- Designed wireframes for splash pages, the home screen, and multiple informational pages
- Increased application start speed by 50% and fixed multiple UI bugs
Education
Bachelor of Science - MIS & Operations Management/ Business Analytics
University of Maryland, College Park
College Park, MD05-2020
Skills
- SQL
- Tableau
- Power Bi
- R
- Excel/VBA
- PHP
- UI/UX Design (Figma)
- Databricks
- Alteryx
- Business analysis
- Data analytics
- Client relationship management
Timeline
Senior Technology Consultant
Ernst and Young (EY)
10.2020 - Current
Front End Software Developer
Paradyme Management
03.2018 - 12.2018
Bachelor of Science - MIS & Operations Management/ Business Analytics
University of Maryland, College Park
Similar Profiles
ANMOL KACHROOANMOL KACHROO
Functional Sales and Distribution Consultant at Ernst and Young (EY)Functional Sales and Distribution Consultant at Ernst and Young (EY)
Tushar BargaliTushar Bargali
Supervising Analyst at Ernst and Young (EY)Supervising Analyst at Ernst and Young (EY)
Cherisse MadeiraCherisse Madeira
Executive Assistant at Ernst and Young (EY) CTHExecutive Assistant at Ernst and Young (EY) CTH