John Ling Email & Phone Number

Bellevue, Washington, United States

• Build custom reporting packages for over 40 clients providing clear, standardized, and consistent reporting instilling confidence and trust with our clients.• Effectively oversee daily ad hoc data and reporting requests from a team of 20+ members.• Create 30+ fully automated reports leveraging Microsoft Power BI with Microsoft Power Automate.• Transform extensive datasets containing 3 billion+ records into insightful and actionable reporting.• Successfully lead multiple, highly sensitive and confidential Attorney Client Privileged projects demonstrating adept handling of sensitive information.• Serve as a subject matter expert, enhancing executive-level reporting by identifying and rectifying inconsistencies within source databases.• Streamline and enhance reporting efficiency by replacing ad hoc processes with automated and standardized solutions.• Develop reports tailored for consumption by stakeholders at various levels, including executive leadership, clients, and peers.• Complete Medicare & Retirement Certification Levels 1, 2 and 3 to enhance industry knowledge and elevate the impact of reporting initiatives.• Engage regularly with stakeholders to thoroughly understand requirements, leading to the successful development of tailored reporting solutions.• Skillfully navigate shifting priorities in a rapidly changing environment.

Bellevue, Wa

• Create complex dashboards and scorecards with drill down capabilities for more comprehensive reporting using SSRS, Power BI and Tableau.• Recognized as key point of contact for customers in need of a leader who can effectively manage the process of understanding, developing, and implementing custom reports to drive automation and efficiency.• Operate as a subject matter expert and improve executive level reporting by discovering and correcting inconsistencies within the databases and reports.• Lead effort working with multiple teams to reduce inventory by over 100,000 devices resulting in $3+million in revenue and storage cost savings.• Create dashboards leveraging software and hardware data from multiple sources to save company $100,000+ in monthly storage licensing costs.• Track assets through their lifecycle stages, identify workflow inconsistencies, and initiate new processes to ensure proper movement/documentation in each step.• Produce dashboards to closely monitor third party disposal and procurement vendors to ensure accurate data transfers and to track SLA’s, security risks and other key metrics.• Track and project ITAM department expenses and revenue.• Closely monitor daily data feeds and collaborate with cross-functional teams to set up necessary processes and infrastructure to ensure clean data loads.• Meticulously compare vendor Request for Proposals (RFP) to enable cost savings and vendor pricing cuts.• Migrate all reports from Tableau to Power BI as well as hundreds of SSRS reports from 2012 Reporting Server to 2016 with no disruption of reporting for stakeholders.

Bellevue, Wa

• Provided the research, data mining/analysis, reporting and interpretation of all client performance metrics.• Communicated insights and findings to senior level Directors and Vice Presidents across departments through daily to quarterly reporting.• Developed reports and track results for department executive level communication and presentations.• Assisted clients by providing analysis and insights to unlock growth, accelerate revenue, and increase awareness of current financial and market standings.• Worked with developers to improve reporting from a client needs perspective.• Generated and tracked Key Performance Indicators for the Financial Performance Solutions department.• Highly skilled in consolidating data from multiple sources into one concise report.• Regularly created reports using T-SQL, Excel, and Access from large data sets with millions of records.

Bellevue, Wa

• Lead analyst responsible for creating new standardized reports across the department.• Designed and implemented new monthly scorecard report to improve timing, consistency, and quality of client analyses. • Created benchmarks for clients to uncover any potential inaccuracies or errors.• Responsible for client visits to ensure proper understanding of customized reports and analytics and that Optum360 is meeting clients’ unique needs and expectations.• Experience with creating and modifying SQL and ad hoc queries to ensure data is user friendly for various departments within the organization.• Created regular site monitoring reports to easily identify inconsistencies in coding for proactive correction.• Worked and coached coders to ensure that proper annotations were documented for ease of reporting and accuracy.

Bellevue, Wa

• Provided analyses with a demonstrated ability to improvise, improve procedures, and meet demanding deadlines. • Delivered innovative solutions to feed into our clients’ reporting needs with an emphasis on delivering better and more efficient methods of data reporting.• Development of physician feedback report providing insightful findings to accelerate revenue for both company and clients.• Lead Analyst in managing transition from ICD9 to ICD10 (International Classification of Disease) standard.• Served as a primary contact for and liaison between coding management and clients.• Created and improved upon in-depth training manual for incoming analysts.