Ruben Alvarez
Houston
Summary
A highly skilled team player with expertise and data domain knowledge to add new value by defining, building, and supporting BigData & data science in analyzing business operations to guide strategic decision making. I always been passionate about solving business challenges with a data-driven approach.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Data Ops Analyst/Eng
Teladoc Health
09.2022 - Current
- Set up SFTP connections for seamless file transfers to S3 and Box.
- Implemented the ingestion of a diverse range of medical data feeds through our ETL system.
- Creating a cloud-native Big Data Analytics pipeline, I specialize in the following:
- Utilizing Infrastructure as Code (IaC) to provision Azure and Databricks resources across diverse environments.
- Implementing CI/CD pipelines with expertise in GitHub Actions and Jenkins
- Developing ETL pipelines using Azure Data Factory, Azure Data Lake Storage Gen2, Databricks with PySpark, and MySQL.
- Utilized FastAPI to develop efficient and high-performance APIs for file monitoring, queuing, and tracking.
Data Analyst
Energy Transfer
11.2019 - 09.2022
- Build automated reports to aid in decisions and planning for management team, including metrics that support dashboards, scorecards, and organizational planning models and analysis.
- Standardized ETL processes and tools to automate data extraction from different source systems. (SQL, Web, SharePoint, Access, Flat Files)
- Use predictive modeling to increase and optimize business processes, identify areas for cost savings, and other business outcomes.
- Perform activities to address data validation, data mining, data cleansings, data harmonization, business logic, exception handling, and required data indication.
- Provide insights, stays at the leading edge of emergent trends and technologies and advises management team on the introduction of new Data technologies.
- Work with various business areas to gather requirements, identify process improvements, and implement solutions using Nintex Workflow and Forms.
Accounting Analyst
Codilis & Moody, P.C.
05.2017 - 11.2019
- Build data models and dashboards to analyze past results, perform variance analysis, identify trends, and make recommendations for improvements; billing, collections and A/R.
- Provide data collection and reporting assistance during internal and external audits.
- Research and analyze client contracts, update billing system with client specific requirements, and work with other departments to ensure that the firm is in full adherence to client/investors guidelines.
- Prepare and analyze daily reports of invoice status; denied, check confirmed, adjustment, short paid, or not submitted.
- Monitor AR aging and analyze payment performance.
- Prepare monthly detailed analysis on billed revenues for the month, including invoice vs. accrual analysis.
- Generate and modify queries to measure the completed work and project the estimated revenues.
Billing Specialist
Codilis & Moody, P.C.
02.2017 - 05.2017
- Reviewed and confirmed all expected client invoices to be billed.
- Created accurate and efficient billing invoices.
- Resolved and/or communicated all billing invoice exceptions with intention to resolve for all clients.
- Gained and retained working knowledge of all client requirements as it relates to billing and ensured the requirements were met.
- Managed and reconciled pre-billed processes for clients with the controller.
- Effectively communicated and followed up with the controller to increase optimal solution regarding client billing.
Education
Accounting
University of Houston-Downtown
01.2022
Associate's degree - Accounting
Lone Star College
Skills
- Azure Data Factory
- Azure Databricks
- Infrastructure as code (IaC)
- Jenkins
- Github actions
- Analytical Skills
- Team Building
- Communication
- Problem Solving
- Power BI
Certification
Microsoft Certified: Azure Data Engineer Associate
Timeline
Data Ops Analyst/Eng
Teladoc Health
09.2022 - Current
Data Analyst
Energy Transfer
11.2019 - 09.2022
Accounting Analyst
Codilis & Moody, P.C.
05.2017 - 11.2019
Billing Specialist
Codilis & Moody, P.C.
02.2017 - 05.2017
Associate's degree - Accounting
Lone Star College
Accounting
University of Houston-Downtown
Similar Profiles
Wanyun WuWanyun Wu
Strategy & UX Researcher at Teladoc HealthStrategy & UX Researcher at Teladoc Health
Jermaine ButlerJermaine Butler
Refund Specialist at Teladoc HealthRefund Specialist at Teladoc Health
EMILY BELLEMILY BELL
Medical Assistant at Teladoc HealthMedical Assistant at Teladoc Health
Madhuri Singh JadaunMadhuri Singh Jadaun
Collection Specialist at Teladoc HealthCollection Specialist at Teladoc Health
Jennifer PickardJennifer Pickard
Purchasing and Operations Coordinator at Grace InstrumentPurchasing and Operations Coordinator at Grace Instrument