Summary
Overview
Work History
Education
Skills
Accomplishments
Work Availability
Timeline
Generic

Reynaldo Moreno

San Antonio,TX

Summary

Accomplished Sr Reporting/Data Analyst with a proven track record at Optum, enhancing organizational efficiency by automating and optimizing data processes using T-SQL, Alteryx, and PowerBI. Skilled in data engineering and adept at fostering cross-functional collaborations, significantly reducing report creation time by 85%. My expertise bridges technical development and management, ensuring data-driven decision-making.

Overview

12
12
years of professional experience

Work History

Sr Reporting/Data Analyst

Optum
10.2018 - 03.2024
  • Provide hourly, Daily, Weekly, Monthly and Quarterly reports for customers
  • Collaborated with cross-functional teams to identify opportunities for process improvement and increased efficiency
  • Conducted thorough reviews of reports to devise and deploy improvement strategies
  • Query On-premise and Cloud databases and created new visualizations with Alteryx, and PowerBI
  • Optimize SQL queries and views in SharePoint to be used as data sources for various processes
  • Developed and automated reports for use in making business decisions saving 85 percent in creation time
  • Used ETL/Data Engineering methods to create and automate data files for operations further down data pipeline - saving 80 percent in creation time
  • Continuously assessed project metrics from raw company data to track improvements in organizational efficiency

Data Analyst/Business Analyst/Reporting Analyst

FCE Benefit Administrators Inc
07.2015 - 09.2018
  • Designed, developed, and implemented reports with T-SQL for internal and external customers
  • Automated monthly file creation with SSRS saving 90% creation time
  • Created T-SQL reports to audit newly implemented claims processing and accounting software
  • Designed and implemented Data Warehouse with SQL and SSIS for more consistent reporting
  • Developed SSRS Reporting Modules to assist HR and Accounting Departments
  • Provide analysis and support for third-party applications
  • Consult on any integration projects with vendors and current development team

SQL Developer

KForce
02.2015 - 05.2015
  • Query large datasets with T-SQL in support of Business Operations for leader in Pharmaceutical Healthcare Services
  • Perform data analysis using SSRS and EXCEL
  • Provide day-to-day customer support related to end-user requests
  • Perform root-cause analysis, develop solutions with team members, and assist or oversee remediation of 340b Pharmaceutical claims

Database Developer/DBA

Uranium Energy Corp
04.2012 - 12.2013
  • Plan, design, and implement application database with MS ACCESS and SharePoint
  • Develop and manage project plans while providing status updates to management
  • Developed web forms to assist in data gathering and reduce Geologist workload by 10 percent
  • Code objects, such as forms, stored procedures, triggers, data macros and views
  • Use MS Reporting Services and SSRS to build reports for internal and external customers
  • Perform ETL operations using SSIS to extract data from MS EXCEL and .CSV files and load them into database
  • Collaborate with internal and external customers on design of user forms and reports - often side-by-side; Making changes as requested
  • Communicate and document changes to database
  • Train end users on use and capability of database
  • Design, document and execute maintenance procedures, including system upgrades, and system backups

Education

No Degree - Mathematics And Computer Science

Texas A&M University - Corpus Christi
Corpus Christi, TX

Certificate - Business Intelligence Developer

Colaberry School of Data Analytics
San Antonio, Texas
2014

Skills

  • Convert business requirements into actionable reports and presentations
  • Report creation and automation using T-SQL, Alteryx, SSRS, PowerBI, Excel, MS VBA
  • Data Profiling; Data Mapping; Data Cleansing; Data Integration, Data Transformations, Data Pipelines
  • Root Cause Analysis
  • Dashboard and Ad-Hoc Reporting
  • Query Development and Optimization
  • ETL using SQL Server Integration Services - SSIS and Alteryx
  • Build Data Pipelines/Data Engineering with SQL, Alteryx, Azure Databricks
  • Version Control
  • Liaison between Management/End-Users and Technical Developers
  • Software API development Utilizing AGILE Methodologies - JIRA, TEAMS, MS PROJECT
  • Data Analytics including HR and Financial/Accounting

Accomplishments

OPTUM

  • Took Lead on migration project from on-prem PostgreSQL database to an Azure Cloud Data Warehouse solution with Alteryx
  • Took initiative to create VBA Macros to automate creation of time-sensitive reporting, reducing creation time by 85 percent
  • Lead, advise and train Jr Analysts through projects


FCE Benefit Administrators

  • Design and implement Data Warehouse for reporting purposes using ETL methods with SSIS
  • Ad-Hoc reporting development and delivery using TSQL, SharePoint, Alteryx, and Excel
  • Delegated responsibilities to Jr Developers
  • Lead and train Jr Analysts with reporting projects
  • Mentor and advise Jr Analysts
  • Member of team using AGILE Methodologies for Software API Development
  • Document and created Development, Test, UAT, and Production environments according to SDLC Best Practices


Uranium Energy Corp

  • Designed new stand-alone application In MS ACCESS and Infopath to update Database information from remote locations
  • Increased efficiency and reduced workload on Geologists by ten percent
  • Successfully centralized data for use by all customers - Geologists, Environmental, Health and Safety, Land Management, Texas Land Commission, Texas Railroad Commission

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Sr Reporting/Data Analyst

Optum
10.2018 - 03.2024

Data Analyst/Business Analyst/Reporting Analyst

FCE Benefit Administrators Inc
07.2015 - 09.2018

SQL Developer

KForce
02.2015 - 05.2015

Database Developer/DBA

Uranium Energy Corp
04.2012 - 12.2013

No Degree - Mathematics And Computer Science

Texas A&M University - Corpus Christi

Certificate - Business Intelligence Developer

Colaberry School of Data Analytics

Similar Profiles

CREATE PROFILE
Reynaldo Moreno