top of page

CS Data provides cloud based data infrastructure and analytics consulting services for small businesses. Take a look below to learn more about how we can provide value to your business, and feel free to get in touch if you’d like to learn more.

Blog
Home: Welcome
Headshot_v2_edited.jpg

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.

Home: About Me

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

Home: Experience

EDUCATION

UTSA_Logo_edited.jpg

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.

UT_Logo_edited.jpg

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

UT_Logo_edited.jpg

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

UT_Logo_edited.jpg

BACHELOR OF SCIENCE AND ARTS (B.S.A.), UNIVERSITY OF TEXAS AT AUSTIN

Bachelors of Science and Arts in Human Biology

Home: Education

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.

Home: Skills

"Believe you can and you're halfway there"

Theodore Roosevelt

Home: Quote

LET’S CONNECT

  • Facebook
  • LinkedIn
  • Instagram

Thanks for submitting!

Home: Contact
bottom of page