Byron Orellana
Garden Grove
Summary
Data Analyst with over 20 years of experience in generating high-quality reports and optimizing data processes for financial institutions. Expertise in SQL query development and data visualization, ensuring data integrity and efficiency through collaboration with business units.
Overview
13
13
years of professional experience
Work History
Business Technology Analyst
U.S. Bank
06.2023 - Current
- Developed and maintained complex SQL queries, enhancing data extraction efficiency.
- Analyze data and report inconsistencies during system conversions to avoid errors.
- Collaborated with business units and technology partners to gather requirements for process improvements.
- Use Microsoft Access to create and modify queries and modules to extract files for calling campaigns
- Use Microsoft excel file to compare data between current process and updated process to verify that updated processes are working as expected.
Data Analyst
U.S. Bank
02.2017 - 06.2023
- Developed business intelligence visualizations in Tableau, enhancing data insights for customer service, business operations, and executive departments.
- Create SSIS packages gathering data from various SQL and Oracle databases to run automatically to create data feeds.
- Improved report delivery by converting Microsoft Access reports to SQL SSIS packages and crystal reports, streamlining access to critical data.
- Scheduled automated runs and delivery of reports using Business Objects, ensuring timely access to essential information for stakeholders.
Report Developer/Analyst
City Loan LLC.
12.2014 - 02.2017
- Acted as the primary contact for data extraction and report development, facilitating clear communication and timely delivery.
- Develop and update SSRS reports that users can run from Microsoft CRM Dynamics application.
- Streamline business processes by creating SQL Server Integration Services (SSIS) packages.
- Developed dashboard reports in Microsoft Excel for Collections and Marketing departments to improve data visibility.
- Proactively identify data errors and data anomalies in order to maintain accurate information.
- Use SQL update queries to correct data entry errors in database.
- Assisted accounting manager in reconciling GL totals with CRM totals, enhancing financial accuracy.
BI Developer
Alorica Inc.
02.2013 - 12.2014
- Created and modified reports for internal and external clients using SQL stored procedures and Crystal Reports 2008, enhancing data visibility and decision-making.
- Utilized SQL queries and Excel for ad-hoc data research to support timely business insights and decision processes.
- Create and update tables in SQL Server 2008 and SQL Server 2012.
- Use Business Objects to schedule automatic run and delivery of reports.
- Maintained and documented report procedures for quality assurance and deployment teams, ensuring smooth transition of reports from testing to production.
Education
Bachelor of Science degree - Computer Engineering Technology
California State University
Long Beach01-2001
Skills
- SQL query development
- Crystal Reports
- SSRS
- Data visualization
- Data integrity verification
- Requirements gathering
- Project collaboration
- Analytical skills
- Problem solving
Timeline
Business Technology Analyst
U.S. Bank
06.2023 - Current
Data Analyst
U.S. Bank
02.2017 - 06.2023
Report Developer/Analyst
City Loan LLC.
12.2014 - 02.2017
BI Developer
Alorica Inc.
02.2013 - 12.2014
Bachelor of Science degree - Computer Engineering Technology
California State University