CS DATA CONSULTING
ABOUT
Cristian Sandoval's About Me
Passionate in utilizing data to help organizations optimize their performance. Master of Science in Data Analytics from the University of Texas at San Antonio. Microsoft certified in Power BI, Excel, and Azure Fundamentals. Microsoft Certified Solutions Associate (MCSA) in BI Reporting. Experienced in developing resilient and efficient cloud based data pipelines. Extensive knowledge in SQL, with skill in data modeling and warehousing as well as querying for development of reports and dashboards. Skilled in developing and deploying machine learning models in both in Python, R, and SAS Miner. Experienced in data tools and technologies such as Azure Data Factory, Microsoft SQL Server, Azure Data Lake, Azure Storage Accounts, Logic Apps, Azure Functions, Databricks, Python, PowerShell, Power BI, DevOps (Git & CI/CD), Power BI Report Builder, SSRS, and Excel.
MY EXPERIENCE
DATA ENGINEER, MPOWERHEALTH
May 2022 - Current
Relevant Technologies & Tools: Azure Data Factory, SQL Server, Azure Storage Accounts, Logic Apps, DevOps Git, DevOps Build/Release Pipelines (CI/CD), PowerShell, Power BI, Power BI Report Builder, SQL Server Reporting Services (SSRS), Python, Excel
• Develop and maintain data pipelines from various data sources using Azure Data Factory, Python, SQL, Storage Accounts, Logic Apps, and REST API’
DATA ENGINEER, GOODMAN TELECOM SERVICES
Nov 2020 - May 2022
Relevant Technologies & Tools: Azure Data Factory, Azure Virtual Machines, Azure SQL Databases, Azure Storage Accounts, SQL Server Management Studio, MySQL Workbench, Power BI, Power BI Report Builder, SQL Server Reporting Services (SSRS), Excel
• Create and maintain custom data pipelines that meet business requirements
• Create and maintain data model and storage in database
• Identify and define business data and reporting needs
• Clean and prepare datasets to be used in reporting
• Develop reporting and visualization tools
DATA ANALYST, MPOWERHEALTH
July 2019 - Oct 2020
• Create, publish, and present Microsoft Power BI dashboards and reports utilizing DAX and SQL queries regarding financial, operational, and clinical data to drive insights and aid in the decision-making process
• Maintain/update data pipelines and models in MS SQL Server to ensure data availability and accuracy for reporting
• Develop a machine learning model with Python/scikit-learn to predict claim reimbursement and forecast collections
• Create and deliver Excel reports utilizing Power Query and PivotTables/PivotCharts
• Assist in optimization efforts in the revenue cycle process through analytical approaches and application use
• Creation of reports employing EMR systems such as eClinicalWorks, NextGen, AdvancedMD, and ModMed
• Provide training to staff members on use of Power BI Service, Excel, and EMR systems
APPLICATION ANALYST, NORTHEAST OB/GYN
Dec 2017 - July 2019
• Utilize Microsoft Power BI and R using MS SQL based EMR system to create and present visualizations/reports for office managers, executives, and clinicians
• Deliver technical support for all clinicians and staff members for multiple medical offices regarding various applications, hardware, or other issues as well as assist network administrator with related tasks
• Perform daily, weekly, and monthly maintenance, workflow documentation and optimization, and manage program upgrades within NextGen systems and other supported applications
• Review measures and submit for the Merit-Based Incentive Payment System (MIPS) program for 23 physicians.
• Created a new workflow to import fee schedules from all several of our payers (100+) into our NextGen system by utilizing VBA Code within MS Excel, substantially reducing the work for our credentialing department from a week to an hour for each payer contract
EDUCATION
MASTER OF SCIENCE IN DATA ANALYTICS, UNIVERSITY OF TEXAS AT SAN ANTONIO
• Relevant Coursework: Data Analytics Algorithms I, Visualization and Communication, Data Analytics Algorithms II, Data Foundations, Data Analytics Applications, Data Driven Decision Making and Design, Big Data Technology, and a Practicum I course
• Use of R, including ggplot2, caret, and shiny packages, Python, including scikit learn and numpy, Hadoop Ecosystem, SAS Enterprise, and Tableau programs
• Knowledge and application of machine learning techniques such as logistic and linear regression, LDA/QDA, K-Nearest Neighbor (KNN), LASSO/Ridge regression, Random Forests, Support Vector Machines, K-means and hierarchical clustering, Generalized Additive Models, Boosting methods, and Neural Networks
• Knowledge of resampling methods such as the validation set approach, LOOCV, K-fold CV, and bootstrapping.
HEALTH INFORMATICS AND HEALTH IT CERTIFICATE, UNIVERSITY OF TEXAS AT AUSTIN
• Intensive 9 week program with coursework including: Introduction to Health Informatics; Fundamentals of Health IT; Operational Models of Healthcare Systems; Workflow, Process Redesign and Project Management; and Electronic Health Records and Health Information Exchange laboratory
• Hands-on experience with EHRs, including Allscripts, athenahealth, Cerner, eClinicalWorks, Greenway; HIEs including Orion and ICA; LabCorp orders and results; STC immunization registry; STC disease surveillance registry; HL7 message creation; data analytics (MS SQL Server and Access); EHR data structure and configuration (Open EMR)
• 10-day practicum experience at industry, government, or healthcare organization
• Creation and presentation of a health informatics or health IT research project
MCCOMBS BUSINESS FOUNDATIONS CERTIFICATE, UNIVERSITY OF TEXAS AT AUSTIN
• 24 credit hours of coursework designed to give students a fundamental understanding of the building blocks of any business environment such as Finance, Accounting, Management, and Business Law
BACHELOR OF SCIENCE AND ARTS (B.S.A.), UNIVERSITY OF TEXAS AT AUSTIN
Bachelors of Science and Arts in Human Biology
SKILLS
I bring a wide range of data science skills to the table, from creating and maintaining ETL pipelines, data querying and report building, and the development and deployment of machine learning models. I am confident in my skillset and am sure I can provide value to your business. Take a look below to learn more about my specific abilities, and feel free to get in touch if you’d like to learn more.
AZURE DATA FACTORY
Extensive experience using ADF to develop, orchestrate, and schedule data pipelines
SQL
Experienced in creating and maintaining ETL processes using stored procedures or SSIS packages, and querying data for reporting and analytics. Familiar with both T-SQL and MySQL.
POWER BI
Experienced in developing reports and dashboards and presenting confidently to business leaders. Certified in Power BI from Microsoft
PYTHON
Experienced in developing ML models (scikit learn), analyzing and visualizing data (pandas, matplotlib), web scraping (beautifulsoup)
EXCEL
Experienced in Excel functions, pivotcharts/graphs, and VBA. Certified in Excel from Microsoft.
"Believe you can and you're halfway there"