Senior Data Analyst with 12+ Years BI Expertise
Resume:
Odell Ping
Denver, CO
Email: *******@*****.***
Summary
Over 12 years experience with SQL and data analysis with BI analytics reporting. Experienced developer working with Microsoft BI stack, Excel as well as databases MSSQL Server, Oracle, AWS Redshift and Snowflake. Knowledge and Experience with Data Visualization tools and Analytics such Tableau and Power BI with Alteryx. Predictive Modeling/business analysis functions in Agile Scrum Environment.
Certifications: Tableau Certified Data Analyst, Tableau Desktop Specialist, Snowflake Associate Platform 2025, Snowflake Data Engineering and Snowflake Data Science Essentials Badges, Google Analytics, AWS Cloud Practitioner, Microsoft Power BI.
Summary of Qualifications
Data Science/AI BI Visualization Application Software
Snowflake Predictive Modeling Tableau Desktop 2024 SalesForce Classic/Lightning.
AWS ML Tableau Prep/Server 2024 SAP HANA CRM
Linear/Logistic Regression Power BI
Alteryx Desktop
Python Pandas\Scikitlearn
Databases Cloud Technology Other
MSSQL Server 2014/16 AWS Redshift/S3 Requirements Gathering
Snowflake Snowsight SalesForce Lightning Agile Scrum/JIRA
Oracle 11g Developer Snowflake AI Cloud Project Management
AWS Redshift
SAP HANA
Professional Experience
Principal Data Analytics Analyst
Medtronic Remote Dec.2021-Apr.2026
Responsible for Combining different Data Sources into a single cohesive usable table utilizing Alteryx workflow logic and SQL views from various data sources such as SalesForce, Salesforce Opportunities, Oracle, Excel, SAP & Snowflake using Alteryx and SQL for internal analysts for various Sales data, medical device demographics and supply chain data.
Write SQL queries for Med Surg and CDS/CRM datasets for reporting on Contract dollars fiscal reporting and Implant Inventory demographics data.
Build, Design and maintain efficient, reusable, and reliable Tableau Dashboards\Extracts and Some Power BI data analytics by gathering requirements for business leaders revolving around Medtronic business segments such as Sales, Lung Health, Medical Surgical,CAS,Cardiovascular and Supply Chains providing analysis of data, identifying trends, patterns and insights that can inform business strategies while collaborating with stakeholders.
Helped Oversee and assist Direct Manager in supporting analysts with projects on the surgical team with both technical and non-technical issues.
Create Forecasting analysis for Salesforce & Quota performance for Financial reporting.
Develop Predictive Modeling in Snowflake on Sales Data.
Utilize Chatgpt and Medtronic GPT for Converting Alteryx flows in KNIME and translating SQL into Salesforce SQL for KNIME.
Tableau Developer/Analytics Consultant(Contractor)
Robert Half Consulting Remote(Denver) Mar.2020-July 2021
Development and maintenance of operational and financial Tableau Dashboards for Robert Half clients Vantage data center and Westerra Credit Union.
Troubleshoot, Maintain and monitor Tableau Server and Tableau Server issues.
Develop SQL table views for data center specifications for pre-aggregation of measures and columns for tableau dashboards on MySql, SQL Server and Azure SQL database.
Maintain/update existing scheduled tracking reports for internal operations and management using Excel, Power BI and Tableau dashboards and Analyze data from different sources and translate complex analysis into impactful business insights using Python Pandas and Tableau.
Provide recommendation for process improvement and validation for BI and Product teams to develop data consistency and meaningful dashboards.
Sr.BI Consultant – Tableau Developer(Contractor)
Bixal Solutions Remote July 2019-Feb.2020
Development of Tableau Dashboards/Tableau Prep Data Flows, analytics and setup and maintenance of Tableau Server in a conjoined effort with Booz Allen Hamilton to work on federal contracts for the U.S. Government and the Dept. of Health & Human Services(HHS). (Granted Government security clearance).
Developed Power BI & Tableau Dashboards for data analysis for the Dept of Food Security on a Project called US Aid to Africa.
Utilize SQL Queries based on Google analytics/Google Search Console, Moz, Qualtrics and various data sources in AWS Redshift for calculating data aggregations, data retrieval for backend data warehouse and connections to Tableau.
Develop Dev Machine learning models in Python for Tableau and predictive modeling such Linear, logistic, K-means and K-nearest neighbors regression.
Gather and document business requirements from stakeholders for Tableau/Redshift projects and maintain data dictionary.
Utilize Agile/Scrum for project development.
Sr.Business Intelligence – Data Analytics Analyst(Contractor)
Change Healthcare(McKesson) Remote Aug.2018-June 2019
Support sales and finance teams by creating ad hoc reports and scheduled reports to produce summary information analyzing payment integrity and pre-pay change healthcare savings impact analysis utilizing SQL, Tableau, SSRS and Excel for our clients.
Produce monthly and weekly reports on revenue estimates, savings of change healthcare discounts and integrated repricing plans on medical claims savings.
Develop and Modify SQL Code including stored procedures and functions for reports and SQL Server tables.
Use AWS Machine Learning\AWS S3 and Machinify machine learning software to identify which claims have potential for future savings by providing score assessment and algorithms models. Utilize Tableau with AWS Redshift/S3 for pulling data for visualization dashboards.
Analyze, load, reconcile and validate external data records from clients to internal SQL Server databases to produce reporting data for finance team with T-SQL, Excel pivot tables.
Sr.Business Intelligence Analyst\SQL Developer
Triwest Healthcare Phoenix, AZ June 2016-Aug.2018
Create and design contractual and Ad-hoc reports for Data Management and Data Governance to the U.S. Department of Veteran Affairs utilizing SSRS, Excel and Tableau Dashboards by consulting with other departments and senior leadership on business requirements.
Support Data warehouse infrastructure and develop and troubleshoot SSIS ETL packages at Triwest while ensuring data integrity and data quality. Develop initial stages of SSAS tabular models and Python Data Science for healthcare analysis.
Provides analyses and interpretations of complex healthcare issues, including recommendations related to a variety of healthcare management and process improvement initiatives.
Write and develop complex SQL queries, functions and stored procedures in SQL Server 2012/2016 to support needs of reporting and EDW. Monitor and tune databases and code for optimal performance. Troubleshoot and resolve database integrity issues, performance issues and queries. Extract transactional data from Oracle 12g to ensure raw data is accurate.
Participate in the development and implementation of analytical standard reporting with Tableau and utilize Agile and SDLC best practices and methodology for sql code development and user testing using TFS for version control.
Analyze claim status data and revenue cycle for producing reports on discrepancies between claim status and amounts and existing reports.
Manage and Lead projects and assignments while working with multiple teams and translating business requirements into technical development.
BI Reporting Analyst
NorthCentral University Scottsdale, AZ Mar.2015-Apr.2016
Responsible for fulfilling the information requests of key decision makers within the University by directly querying against the SQL Server database(2008,2012) using SQL, ensuring the accuracy and relevance of that information, and providing access to information in a seamless and timely manner in the form of data extracts, ad hoc parameterized SSRS reports, Excel Pivot Tables and Power BI.
Performs requirements gathering for reporting for SSRS and Power BI design. Work with Marketing team on student acquisition metrics and remarketing reports via Google Analytics and create reports on any data Google Analytics wasn’t able to provide.
Interprets results and data using a variety of techniques ranging from simple
data aggregation to complex data mining. Designs, develops, implements and
maintains business solutions via aggregates metrics.
Comprehensively worked on complex SQL scripts using Common Table Expressions (CTE) as per the requirement and convenience, temp tables, complex SQL Joins and created stored procedures and user defined functions.
Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into final database/data warehouse.
Business Intelligence Analyst(Contract)
CVS Caremark Scottsdale, AZ Sept.2014 – Dec.2014
Use internal CVS Caremark Business Intelligence tools to design, develop, and produce professional enrollment reports and data files for several Medicare Part D plans. Create standardized Ad-Hoc reporting using T-SQL and PL/SQL on Microsoft SQL Server and Oracle 10g utilizing SSRS, Oracle Developer and Excel.
Assist Centers for Medicaid and Medicare Services (CMS) by providing further operational guidance, development analysis of Reporting Analytics and SSIS packages in supporting Medicare Operations Teams and systems in ensuring that proper changes are implemented and documented.
Provide SQL development and coding to help support and modify manageable, scalable, and high-performance SQL code in SSIS packages and perform ETL data transformation from data source to target.
Support automation job processes by configuration of ETL packages from development environment to production in SQL server agent.
Respond to ticketing requests in a timely manner involving CVS relationship with CMS Medicare part D which includes researching and troubleshooting issues with member information such as enrollment, disenrollment, provider plan changes and coverage determination.
SQL Data Analyst
Reed-Elsevier Healthcare Atlanta,GA Nov.2011- Sept.2014
Extract, Update, Manipulate and perform data validation and file data conversion using T-SQL on 2008 SQL Server production databases for client services and other data related requests through salesforce CRM.
Responsible for providing Ad-Hoc Reports to Customer care/Client Services retrieving customer information utilizing complex analytic SQL queries from SQL server tables and reporting the data on excel spreadsheets and internal reporting tools. Perform and build ETL data transformation and loading processes using Microsoft SSIS from source to target.
Troubleshoot and QA Elsevier front end E-Learning Management Software issues in relation to the Elsevier business rules while using root cause analysis to diagnose potential problems on backend SQL Server databases involving tables and data structure
Interpret and analyze client data and functional front end issues while making relevant findings on improving methods, practices and procedure.
QA SQL code for reports, functional issues, stored procedures and triggers.
Write documentation on Elsevier relational database tables relationship modeling, schemas and troubleshooting procedures. Interact with client services utilizing Salesforce CRM on client cases.
Technical Support Analyst(Contractor)
McKesson Alpharetta, GA Feb.2011- Nov.2011
Provides system level support of multi-user clinical applications residing on Windows server 2008 and Red Hat enterprise server 5.0, software applications, individual user issues and support of these systems to maintain high availability and minimum downtime. Serves as liaison between clinical departments and managed services, partnering with departments and SA resources to facilitate ITS support and response to system issues and needs while logging cases through SAP CRM.
Provides SLA support and escalation of McKesson clinical applications such as Horizon Patient Folder and various system related issues which include networking problems, VPN’s, and Oracle 10g databases through effective use of monitoring, phone support and email queues using analytical, technical knowledge and documentation.
Monitor and maintain tier 1 support of Oracle 10g database issues both non-routine and major incidents to ensure integrity and system performance through troubleshooting procedures and escalations to Oracle DBA’s.
Systems Analyst(Contractor)
Sears Holdings Chicago, IL May 2010-Oct.2010
Maintain support of Sears Linux/Solaris server farm systems, networks, applications, hardware and software issues within the Ecommerce NOC.
Performs level 1 and 2 infrastructure operational support to Sears Ecommerce IT teams through effective use of documented troubleshooting/escalation procedures, technical analysis and system administration for web and infrastructure related issues.
Perform and monitor SQL and PL\SQL queries on orders, batch jobs and processes from Oracle 10g and MySql databases. Helped assist on documentation web project using Python and MySQL.
Works with infrastructure staff to develop strategic direction for operation and support teams to maintain web site uptime and stability as well as participate in ongoing processes of investigating, analyzing, and providing long term resolutions.
Sr. Data Analyst
Nielsen Company Schaumburg, IL June 07- May 2010
Analyze, respond and quality check data inquires from international delivery services on IBM DB2 mainframe while transitioning, uploading, and troubleshooting sales figures and custom information while processing final reports using Nielsen proprietary software for customer client representatives.
Work with design team to produce production order and recommend any changes that need to be done to product dimension and help build international databases that meet client deliverable requirements.
Through effective use of analytical skills, documentation and research determine whether data integrity sent by clients for processing are correct and accurate while making sure database delivery and report deadlines are met for Nielsen International Solutions for various global track brand name products such as Nestle, Kimberly Clark and Kraft.
Pull aggregate sales facts and figures utilizing SQL queries from DB2 database and reporting sales data using Excel and Pivot tables.
Education
Bachelor of Science: Management Information Systems from Franklin University 2003.
Columbus, Ohio
Certifications
Snowflake SnowPro Associate Platform Certification
Credential ID: 139579807
Snowflake Hands-On Essentials Data Science Badge.
Credential ID: 158218689
Snowflake Hands-On Essentials Data Warehousing Badge.
Credential ID: 130218190
Snowflake Hands-On Essentials: Data Engineering
Credential ID 131021209
Tableau Certified Data Analyst
Credential ID: T000031571
Tableau 10 Desktop Specialist Certified
License ID 1011116
Microsoft Power BI 70-778 Analyzing and Visualizing Data
License ID 989456136
Amazon Web Services Cloud Practitioner Certification
License ID 1D5HLHL2K1141GKF
Google Analytics Individual Qualification Certification 2019
License ID 32021899
References upon request
Languages
English, Chinese (Mandarin)
Contact this candidate