Data Analyst Manager

William Lopez

Summary

Detail-oriented and focused professional with extensive experience in collecting, processing, and analyzing healthcare data. Proven success in designing reports and dashboards for staff. Recognized for interpreting trends or patterns in complex datasets and develop graphs and reports of results. Skilled at identifying and resolving data gaps through root cause analysis. Committed to collaborate with diverse teams to achieve common goals. Expert in the construction of regulatory reports with the respective regulations and legal implications.

Technical Proficiencies

Platforms:

Windows and iOS

Tools:

Oracle, MongoDB, Toad and SQL management Studio, AWS, Azure, SAS(Base, Stats, Data Steps and SQL), Tableau, Power BI, and Microsoft Office Suite

Programming Languages :

SQL, PL-SQL, SAS Base, VB.net and Python

Project tools:

Agile methodology and Jira, Confluence, Smartsheet, Miro,, Microsoft Project, Visio, Slack, and Microsoft Teams

Data Management:

Data Mining, Data Modeling, Data Reporting and Data Validation

Career Experience

McKesson Specialty Health, The Woodlands, TX 2018 – 2020

Data Analytics and Support Engineering

Coordinated with stakeholders and technical team for identifying and resolving business related problems/issues. Documented technical procedures and processes complied with standards. Lead the team to support the definition and calculation of measures for regulatory reporting. Results are presented in Tableau Dashboards to end users. Implemented data marts for improving end-user response and analytic capabilities to support different areas of the business. Oversaw license updating, user access, job scheduling, server maintenance, and user support of SAS servers. Guided supported technical support for Practice Insights platform. Developed and supported regulatory programs like OCM and Value Based Care in short period of time and low budget.

Processed and managed big data in Oracle and SQL, as well as designed a Tableau dashboard to present big data using key indicators.

Directed application and report testing by creating and leading QA teams.

Utilized Python for developing predictive analytics projects related to/based on oncology space, identifying risk of hospitalization for patients in advanced stage of diagnosis.

Assessed and validated new products and technologies by carrying out proof of concepts (PoC).

Developed a tool for Clinical Trial Research group for identifying potential patients for study enrolment.

McKesson Specialty Health, The Woodlands, TX 2014 – 2018

Product Development Manager

Coordinated with all stakeholders and managed data consumers within oncology space. Addressed business issues by preparing data marts. Supported data consumers through data dictionaries. Supervised pricing process and presented business rules and proposals to clients.

Led all phases of Practice Insights (provided facing) and Market Connect (pharma facing) development and utilized for delivering and presenting data in dashboards with key indicator to customer from proof of concepts, pilots and development of the solutions.

Enhanced sales process utilizing Tableau dashboards.

Aided Genentech, GlaxoSmithKline, Pfizer, Bayer, Amgen and other clients by providing clinical and marketing insight solutions.

Designed and presented portfolio of products on Claims and EMR systems.

McKesson Specialty Health, The Woodlands, TX 2012 – 2014

Lead Data Analyst

Cooperated with clients for deciding/defining business rules. Collected, interpreted, summarized, and presented big data for better understanding of reports and dashboards. Ensured all data consistency by identifying and resolving data gaps. Coordinated with research teams for accurate data collection and recording. Guaranteed regulation compliance and best internal practices to confirm compliance with specific procedures.

Led clinical data analysts and increased collaboration marketing and brand teams of pharmaceutical clients.

Managed analytics team by defining deadline and priorities.

Collected data from 835/837, EHR, retail Pharmacy.

Additional Experience

Data Analytics Manager, The Nielsen Company, Mexico, 1999 – 2006

Education

Degree in Bachelor of Science

Manuela Beltran University, Colombia

Degree in Computer Programming

CIDE, Colombia

Professional Training & Certifications

Galvanize Data Science Training

“MCAD & MCSD” (Transcript Id: 814499 Access code: lopezw670510)

Contact this candidate