Hugo Alvarez
*** ******* ******, **********, **, 07070
************@*****.***
Professional Summary
Detail-focused Analyst with knowledge in data warehousing, process validation, and business needs analysis; 3+ years of experience building SQL queries. Adept at understanding customer requirements and translating them into actionable project plans. Dedicated and hard-working with passion for Big Data. Proficient in preparing test cases, plans, and scripts. Dedicated to analyzing and resolving defects. Highlights
SQL Jira and Confluence Document management
Database Detail-oriented Problem-solving
Tableau Critical thinking Time management
Data analysis Microsoft Office Suite Strong interpersonal skills Professional Experience
J.M. Rodgers, Sparta, NJ
Data Analyst, July 2022 – Present
Automated an OCR software that reduced the amount of time to gather data from large invoices and key it into a program from 4 hours to 20 minutes. This increased the number of invoices processed per day.
Finding trends and patterns in complex data sets and reporting those to management.
Provide ongoing reports for internal teams and external clients after interpreting data and analyzing results using statistical techniques.
Monitor servers for scheduled report failures. Necessary review and logging are performed to correct code errors.
Creating reports after acquiring data from primary or secondary data sources such as Oracle and SQL servers.
Build stored procedures in SQL that generate reports based on business needs.
Monitor, track, and audit data for inconsistencies and errors.
Work across relevant departments to establish the overall approach for data clean-up, maintenance, and quality control to ensure the accuracy of data and reporting.
Create and maintain reports in data visualization tools (Tableau) to provide information to cross- functional teams.
Identify and track KPIs and provide ongoing reports to inform leaders of current business performance.
Perform the role of scrum master for all company projects.
Ensure smooth and proper running of databases.
Vertican Technologies, Fairfield, NJ
Business Analyst, January 2022 – June 2022
Defining, analyzing, and documenting requirements in addition to managing requirements at a project level to fulfill clients and company’s needs.
Create business cases by documenting strategic objectives alongside specific product owner and researching development choices (including estimating and cost-benefit analysis).
Conducting meetings and presentations with stakeholders and external clients to share insights and plans to ensure the solutions provided meet business needs and client requirements.
Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions.
Gathering critical information from meetings with various stakeholders and producing useful reports.
Managing projects, developing plans, and monitoring performance to ensure timely completion of projects.
BA / QA Analyst, December 2019 – March 2022
Utilize understanding on relational databases and SQL to analyze data in development and production environments.
Hugo Alvarez
128 Carmita Avenue, Rutherford, NJ, 07070
************@*****.***
Develop complex data quality audits using SQL to identify possible data issues coming into the data warehouse.
Perform regression testing for various programs to ensure that no newly developed code causes bugs or breaks any existing functionality in the software.
Analyze varied complex test scenarios and delineate a standard procedure to decrease the amount of time it takes to perform testing.
Define test strategy, test suites, test cases, and implement them based on company’s needs.
Document complex software defects in an issue-tracking system and proactively communicate issues to business analysts, developers, and product managers.
Actively communicate quality issues to stakeholders with regards to the way data is collected, stored, processed, or used.
Identify and analyze problems with different program functions, output, or content.
Strategize and identify ways of improving the overall quality of software and data testing. Client Services Specialist, November 2018 – December 2019
Run various SQL queries to determine the reason why data is not being inserted or updated into the proper tables which caused certain EDI records to not be generated.
EDI data mapping and translation.
Replicate software bugs and document for pertinent teams to review.
Test existing and new programming when required.
Troubleshoot and resolve incidents via telephone and email. Fujitsu (Costa Rica)
QA Analyst, December 2017 – July 2018
Manage and update knowledge base that contains standard procedures.
Coordinate and lead weekly meetings to review team's performance.
Start problem solving sessions that involves relevant teams to create an analysis of the work demand to improve
any metric that is not being met.
Review team s performance on daily basis to make sure client s goals are achieved.
Respond to client s escalations and provide proper coaching to service desk agents.
Create new SOP s and SOW’s.
Education
Essex County College Associate in Computer Science, 2021 – Present VMEdu Targeting Success Lean Six Sigma Yellow Belt, 2017 BrainStation Data Analytics Certificate, 2022