Post Job Free

Resume

Sign in

Data Analyst Business Process

Location:
Sacramento, CA
Posted:
February 04, 2024

Contact this candidate

Resume:

Overview

My education, volunteering in Math, and time in the corporate world have provided me with the skills, experience, and structure to contribute with my expertise in applications of Mathematics in a team environment and thrive.

Summary

Extensive experience in research, data analysis, budgeting, forecasting, and reporting in support of business decision-making, strategy and operations.

Skilled in business process improvements, quality control, and other initiatives.

Proficient in developing, managing, and coordinating performance and quality assessments, business process re-engineering, change management, communication, and training.

Extensive experience in developing data-driven and hybrid automation frameworks.

Strong skills in reviewing and analyzing Business Requirements and creating Test Plans, Test Cases, Test Scripts, Test Estimation, and Requirement Traceability Matrix (RTM).

Proficient in using test automation tools.

Adept in all phases of the Software Development Life Cycle (SDLC), including SCRUM and Waterfall methodologies.

Professional Experience

Data Analyst

First Tech Federal Credit Union June 2019 – July 2021

1.Develop, manage, and implement production automation processes via CXC eSupport.

2.Develop, implement, and monitor Secure Message Dashboard automated through Alkami online banking.

3.Analysis and development of reports through Alteryx for the Digital Fraud team.

4.Developed and Directed tracking database for CXC Agent Occurrences; specs to create the database and automate emails daily, weekly, and monthly.

5.Managed automated product change and email alerts for Deposit Products.

6.Skilled in compiling Member Overview Dashboard (Member Growth and Sentiment).

Data Analyst

Educational Results Partnership July 2021 – December 2023

1.Developed business metrics from Community Safety, Education, and Health data domains.

2.Developed an ETL tool using population data structure from the US Census as part of the broader application for business metrics.

3.Extensive use of descriptive programming to create effective and efficient reusable functions and maintain them in a neat function library to be used by the team.

4.Gathered requirements documents such as business requirements design documents and other related documents.

5.Developed and executed SQL queries to verify the proper insertion, deletion, and updates into the Oracle supporting tables and cubes.

Data Analyst

Educational Results Partnership July 2021 – December 2023

(Continued)

6Reviewed database test cases according to assigned Requirements to validate reports by retrieving data with SQL queries from the Oracle database.

7.Performed End-to-End testing of the database to check data integrity using SQL queries.

8.Assisted QA lead in documenting the User Acceptance Test report and reporting defect resolution.

9.Experienced in Cross Browser Testing by executing test cases in Chrome and Internet Explorer.

Environment

R (RStudio), Python, Tidyverse, Tableau, SSMS, Snowflake, SQL, MongoDB, LaTeX, XML, Oracle, MS-Office, Oracle SQL Developer, MS Excel, Agile/Scrum, Windows XP, Windows 10

Professional Development Skills

Critical thinker, analytical, team oriented, excellent communicator, diligent, problem solving, articulate, adaptable.

Education

California State University Sacramento, Sacramento California

Business Associate’s Degree, Applied Mathematics, Certificate - December, 2018

(Computational Statistics, Engineering Mathematics, Number Theory, Numerical Analysis)

University of Denver, Denver Colorado

Master’s Degree – Data Science, In Progress (128 of 140 units completed)

References

Ryan Drew – Senior Data Analyst, CXC - Email:

Quaite Dodson – Product Manager – ad3c3o@r.postjobfree.com

Alex Barrios – President – Email: ad3c3o@r.postjobfree.com



Contact this candidate