Technology Advisory Staff ConsultantErnst & Young － Chicago, IL
Identified multiple data discrepancies root causes via data quality analysis and recommended remediation solutions Designed and built automated control reports on client's key operation processes in MS Excel and Access, and led staffs and seniors on periodic reporting Built regression models in SAS to segment customers and maximize the return on investment for a mailing campaign Created and migrated various reports and dashboards on transaction data to identify key trends for executive management with Teradata Enterprise Data Warehouse and QlikView Web Application Support Coordinated with developers across the globe to plan, test, implement and support revision releases for a Java based case management web application Provided business users assistance, walkthrough trainings and support documentation, and responded to users' requests including data entry, access issues, and interface troubleshooting Automated the procedure encoding process in MS Excel with formulas and VBA to easily generate SQL queries to write the procedures into the database.
01/2014 to 05/2014
Cyber Risk AnalystIndiana State Department of Health － Indianapolis, IN
Evaluated a local government agency's current IT policies in alignment with the 2014 NIST framework and identified potential areas of improvement.
Recommended the implementation of appropriate security controls to minimize potential damages from future security breaches.
10/2012 to 04/2013
Project ManagerDuke Energy Inter-University Case Competition － Oxford, OH
Led a team of four to develop a consumer orientated mobile strategy optimizing the implementation of the Green Button Initiatives and won 1st place among nine competing collegiate teams.
Developed business requirements and modeled business processes for a mobile app that enabled a Zigbee Network at 30% lower cost of competitors'.
Education and Training
Master of Science: Information SystemsIndiana University, Kelley School of Business － Bloomington, INInformation Systems 3.88 / 4.00 Awarded graduate assistantship for the top 10% of the admitted class based on merit
Bachelor of Science: Business Marketing, Information and Process ManagementIndiana University, Kelley School of Business － Bloomington, INBusiness 3.86 / 4.00 Marketing, Information and Process Management Business Honors Program, Beta Gamma Sigma International Honor Society, Hutton Honors
Adaptability Problem Solving Project Management Requirement Analysis BPMN Data Analytics Data Visualization Excel Advanced User Programming
agency, business processes, case management, client, data entry, Data Visualization, Data Warehouse, database, documentation, executive management, Java, local government, mailing, Access, MS Excel, Excel, Enterprise, Network, policies, Problem Solving, processes, Programming, Project Management, quality, reporting, Requirement, SAS, SQL, strategy, Teradata, troubleshooting, VBA