William Guevara

Greater New York City Region

917-***-**** adlthq@r.postjobfree.com

SUMMARY

Analyst at a Construction Consulting company that has excelled in their role and works directly with executive management to meet company needs. Responsible for creating various reports, roadmaps, and KPI’s by working with Excel and company database. Looking to work at a company that offers opportunities for growth in the Data Analytics field. EDUCATION & CERTIFICATIONS

NYU Tandon School of Engineering March 2021

Tableau Data Analytics Certificate Program New York, NY Courses: Business Analytics Fundamentals, SQL for Analytics, Tableau for Analytics Stony Brook University May 2019

B.S. Business Management, International Business and Finance Concentration Stony Brook, NY GPA: 3.60, Cum Laude Organizations: Alpha Kappa Psi & The Emma Bowen Foundation SKILLS

Excel SQL MySQL Workbench Tableau Word PowerPoint Salesforce Timberline Exploratory Data Analysis (EDA) Data Analytics Database Normalization Bi-lingual English/ Spanish EXPERIENCE

Andromeda Advantage New York, NY

Business Analyst Nov 2019 - Present

● Responsible for performing data wrangling, analyzing data, finding insights, and providing data-driven recommendations by creating accurate and timely reports in Excel that are then used by senior management to make financial business decisions for four major construction entities.

● Oversee all cash collection, creates different reports that ensure work is billed properly, requisitions are approved, and resources are provided. This leads to payments collected 25% faster and maintain a healthy cash flow.

● Create and update monthly reports to evaluate the performance of all Business Developers based on metrics such as the number of awarded bids and jobs, the volume of bids and sales, and recommending sales goals for the upcoming year.

● Responsible for projecting over $15 million of monthly revenue through both quantitative and qualitative methods, and creating roadmaps, which are then used to allocate resources for cash collection purposes.

● Liaison between the Management Reporting department and Accounting, Legal, Operations, and Management teams to both create and streamline current processes and procedures. NYU Tandon School of Engineering

Tableau Data Analytics Certificate Nov 2020 - March 2021

● Cleaned, manipulated, visualized, and analyzed raw data using spreadsheet software (i.e. Google Sheets), SQL (i.e. MySQL), and BI data visualization tool (i.e. Tableau).

● Conducted an exploratory data analysis (EDA) to provide key stakeholders with data-based evidence of user success characteristics to make the business case for additional funding.

● Created DDL and DML SQL queries from formal and ad hoc data requests to draw insights and make data-driven recommendations to support company growth.

● Built a Tableau Story with interactive dashboards and dashboard objects to report insights from comparative analysis completed in Tableau Desktop to technical and non-technical stakeholders. Spectrum Stamford, CT

Corporate Social Responsibility Intern May 2018 - Aug 2018

● Responsible for analyzing the effectiveness of the Emergency Heating Relief Grant by reaching out to nonprofits, creating and distributing surveys, analyzing the results, and presenting the results.

● Filtered and compiled volunteer data sets and created reports.

● Lead the winning team for the “Hackathon.” Proposed new strategies on becoming the best telecommunications company in America by working with cross-functional teams and conducting two focus groups within the organization. Field Engineering Intern May 2017 - Aug 2017

● Assisted the Regional Engineering Sr. Directors in tracking and ordering $4 million of inventory in the NYC region

● Partnered with the Construction Project Manager to develop manuals using different platforms for all technicians and project coordinators in the NYC region.

● Worked with a team of interns and collaborated with cross-functional departments to present ideas on using a new consolidated company app to the senior executives, hiring managers, and mentors.