David Johnstone Email & Phone Number

Meridian, Idaho, Us

Rebuilding SQL procedures and automations for the transition to a new data system. Processes I oversaw resulted in more efficient runtimes and easier maintenance in the event of failure.Deployed new data objects and data layers based on the utilization needs of business analysts.Troubleshooting issues in SQL scripts and WhereScape Red automated tasks.Deployed a new weekend running job as a split off of the daily tasks. This project resulted in better running times by splitting daily data needs versus more stagnant data feeds.Developing user acceptance testing plans for the deployment of data layers.Utilizing Agile techniques for the development and completion of data projects.Leveraging complex sets of healthcare related data to optimize the delivery of data visualizations\reports. In-depth SQL Query development knowledge in writing scripts and procedures to develop data stores and views.Designing, building and maintaining Data Warehouses using the applicable warehousing techniques such as Star-Schema Design, Data Vault, and others.Creating and executing detailed testing plans to ensure accuracy in ETL processes.

Meridian, Idaho, Us

Design, develop, and reconcile risk adjustment reporting data sets for regular CMS submissions, attestations and external data submissions.Design historical reporting and analyses needed by Management for various CMS payment reconciliation settlements.Assure accurate and timely analysis and reconciliation of CMS data sets in response to federal guidance and maintaining effective relationships with external vendors and CMS technical support staff.Provide ad-hoc reporting for various other departments, including Medicare Advantage, Provider Services, MQM, Executive, Internal Audit, and others throughout the company.

Boise, Idaho, Us

- Manage, program, and develop the menu of reports for over 500 users including associates, directors, and VP's to use for their data needs.- Facilitate training and support end users during a database/system transfer across multiple sites.- Developed and managed the reporting process for the monitoring of over two million items to ensure expiration and code date guarantees are met. - Audited the payments received from vendor efficiency to ensure accurate payments were received.- Responsible for the development and implementation of innovative analytical reports and support tools to enable decision making by the Supply Chain business- Managed and administered the consolidation of 15 separate SharePoint sites into one master site.- Maintenance and publication of business reporting and data sources- Provide analysis and recommendations to management/users using high-level presentations, charts, and graphics.

El Segundo, Ca, Us

Gathering, cleaning, and analyzing data from relational databases in order to fulfill internal reporting needs.Stack ranking and blending employee performance based on a multitude of key performance indicators.Tracking the performance of new hires from over 50 call center sites and data summary.Providing credit and budgetary analysis including goal vs actual, site and departmental level summaries.Providing statistical analysis on a weekly/monthly/ad hoc basis for executive audiences of a Fortune 100 company.Proficient in Microsoft Office Suite, SAS Enterprise Guide (SAS/SQL), and Oracle.

El Segundo, Ca, Us

Managed the production and staffing requirement reporting process for a medium sized department (>100 employees) on a part time basis. Reporting included process compliance, daily production, staffing requirements, and tracking customer satisfaction.Developed material for and facilitated beginner and intermediate Excel classes on a quarterly basis for DIRECTV’s career development program due to my expertise.Balanced time and performance between reporting and customer service responsibilities.Provided written responses for customer complaints filed through consumer agencies including the following: state attorney general offices, BBB and the FCC.

El Segundo, Ca, Us

Handled customer complaints directed towards executives via a myriad of avenues including calls, emails, and letters.Point of contact for providing guidance to colleagues in handling escalated customer calls and business procedures.