EXPERIENCED BUSINESS ANALYSIS PROFESSIONAL
Diligent and results-oriented Analyst with 5+ years of experience in utilizing data to increase business efficiencies and profits. Proven track record of managing upgrades, modifications, maintenance and troubleshooting of business intelligence systems, and providing recommendations to enhance system performance and capacity. Strong background in validation of data warehouse system for data integrity, quality, and accuracy. Solid expertise in analyzing business intelligence reporting processes, suggesting and establishing improvements. Academically founded in Industrial and Systems Engineering with core competencies in:
Data Analysis Machine Learning Data Modeling
Forecasting Data Visualization Tableau
Power BI Feature Additions Report Building
Data Improvement ETL Procedure Design
Python MySQL, SQL Server, PostgreSQL R
BUSINESS INTELLIGENCE ANALYST, United Health Group, Indianapolis, IN 10/2013 – Present
Operative position focused on translating business requirements into coherent business intelligence reports and developing optimal and scalable applications to meet business needs.
Produce ad hoc customized reports, dashboards, and scorecards by utilizing R markdown, Tableau and Power BI skillfulness from various resources for a group of 50 Industrial Engineers on multiple teams. Enabled automated weekly visualizations and summary report for managers with stored procedures using R scripts.
Saved Industrial Engineers over 300 hours of time by using R and translating business reporting requirements and designed automated data processing, manipulation, and visualization functions.
Decreased the percentage of missing and incorrect values from 81% to 15% by guiding and directing 4 ongoing data quality improvement projects on workforce SQL Server databases.
Integrate and enhance necessary KPIs by collaborating with the VP and Directors of Provider Relation team. Improved case submission quality, reduced the incomplete case submissions from 75% to 30%, and saved 20% of the case scrubbing workforce by identifying and defining the quality problem from case submitters, redesigning the entry form, and conducting education programs for case submitters.
Provide annual savings of approximately $275k by developing optimized solutions such as process redesign and automation projects for delivery across all indicators.
Developed the Industrial Engineer web tool for business users by collaborating with the SDEs and served as the champion for Industrial Engineering for data improvement, feature additions and report building.
Prevented quality issues and saved the potential cost of over $300k by monitoring, discovering and troubleshooting data issues in the data pipeline.
Saved time in communicating results to stakeholders by building a predictive model for case receipts and claim representative performance, visualizing the results, and cooperating with workforce planners to validate metric change effects.
Conducted new hire training for Industrial Engineering team. Ensured the up-to-date practices from Industrial Engineering team of 56 with the internal tools and databases by creating, managing and maintaining the updates of 9 Standard Operating Procedure documents promptly. Assured that IE team understand the current rules of conduct in IE projects.
Coordinated approximately 50 people by managing the turnaround time and the inventory for case intake SharePoint.
SALESFORCE ANALYST INTERN, Blackboard Inc., Los Angeles, California 06/2013 – 10/2013
Internship role concentrated on assisting Managers for preparation for desired account analysis by producing reports and updating client information through utilizing Salesforce Report Builder and Dataloader proficiency.
Decreased Salesforce data storage by 30% by identifying and eliminating Connect Classic accounts left over through Connect 5 migration stage, as well as other excessive information.
M.S. Industrial and Systems Engineering, University of Southern California, Los Angeles, CA
B.S. Industrial Engineering, Nanjing University of Technology, Nanjing, China