Lorenzo Yniguez

Irvine, CA 92620 · (714) 661-4675 · lyniguez@gmail.com

Over the past 10+ years, I have accumulated a diverse analytical skill set that has allowed me to communicate data driven business insights.

Experience

Report Developer

Össur

• Formulate, troubleshoot, and optimize report logic in SSRS using SQL queries to support multiple sales teams and help identify customer and product growth trends and track sales quota attainment.

• Implemented use of Power BI for multiple sales teams and internal support teams to provide advanced data visualizations and dashboards that highlight performance on key metrics.

• Create ad-hoc reports in Excel using Power Query and Pivot Tables from Sales Cubes data sources, providing valuable data driven insights to support management decisions.

• Manage report subscription distribution and automated schedules in SSRS Report Manager and Power BI.

• Collaborate with international BI team to ensure data ETL processes are up to date and communicate any issues or delays to stake holders.

2018 - Current

Marketing Consultant

Studio Yniguez

• Increased sales by more than 20% YoY each of the last 2 years by optimizing SEO and advertising for each individual listing.

• Analyze periodic sales to formulate strategies for new listings in the upcoming months and seasons.

• Created decomposition tree visualization in Power BI to drive advertising timing and budget decisions

2016 - Current

Senior Business Analyst

LA Fitness

• Collaborated with IT development team to create new stored procedures and jobs that automated manual processes and helped increase efficiency within the Internal Audit Department.

• Create Ad-Hoc reports in SQL and Excel to identify automated process errors and train Internal Audit staff on how to make proper corrections.

• Supervise analyst team that updates rates and commissions in the sales application program.

• Process daily billing files to send, receive, and process from VISA, MC, AMEX, DISCOVER, ACH, and BOM . Compile and analyze all incoming and outgoing data.

• Implemented new commission procedures for nationwide personal training packages that saved the company in overpaid commissions to employees.

• Collaborate with Internal Audit staff to ensure new procedures work properly and efficiently while progressing to a fully automated process.

2014 - 2018

Billing Analyst

LA Fitness

• Process daily billing files to send, receive, and process from VISA, MC, AMEX, DISCOVER, ACH, MONERIS, and BOM. Compile and analyze all incoming and outgoing data.

• Worked together with C-Level management during the acquisition of multiple companies and provided analytical support to update and merge billing data.

• Improved collection percentage on declined accounts by analyzing return codes from Credit Cards. Provided insight that led to new billing strategies based on timing collection calls that required coordination with more than 1000 employees across the nation.

2012 - 2014

Sales Operations Analyst

LA Fitness

• Coordinate with Executive VPs of Sales, CFO, and IT team, on a bi-weekly basis to establish national rates and commission structures for more than 700 clubs by evaluating previous monthly sales and making optimal adjustments to drive revenue.

• Saved hours of labor each bi-weekly pay period by creating a process to review and verify commissions of all employees internationally to ensure that all commissions were valid and in agreement with company guidelines.

• Support IT and sales staff in entering, testing, and ensuring accuracy of in-house sales operations software related to national sales, corporate sales, and marketing materials.

• Facilitated communication between VPs in the US, Canada, and corporate office on a daily basis to determine if any special rates were needed in order to increase sales to reach monthly goals.

2009 - 2012

Corporate Sales Analyst

LA Fitness

• Provide detailed analysis and insights of company enrollments and employee usage to maintain agreements and negotiate renewals of large corporate accounts.

• Created an internal sales report using pivot tables to audit each sale and verify corporate enrollments. This led to reduced fraudulent use of discounted corporate rates.

• Collaborated with IT to create a new web based application to be used that would provide vouchers for prospective companies to enroll new memberships and allow the corporate office to track and audit each individual companies’ enrollments and usage.

2007 - 2009

Internal Audit

LA FItness

• Executed periodic audit reports that helped minimize human errors in data entry.

• Worked with Visa, MC, American Express, and Discover to resolve over 100 daily customer disputes and chargebacks by providing the necessary information.

• Streamlined the internal response process for disputes and chargebacks by creating templates for each possible response.

2005 - 2007

EFT Operations

LA FItness

• Managed membership accounts and responded to complaints and inquiries.

• Called and collected balances on delinquent LA Fitness membership accounts daily.

2004 - 2005

Education & Certifications

University of California Irvine

Bachelor of Arts
Sociology
September 2000 - June 2005

University of California, Irvine Division of Continuing Education

Data Analytics Certification

Accelerated course that provides insight and knowledge on Data Analytics and the programs used to best perform analysis. Through this course I learned advanced excel and VBA, modeling and forecasting, python, pandas, matplotlib, web data API calling, social media mining, bot building, SQL, Javascript, dashboard building in Tableau, and machine learning.

September 2017 - April 2018

MCSA: BI Reporting

Exam 778: Analyzing and Visualizing Data with Power BI
Exam 779: Analyzing and Visualizing Data with Microsoft Excel
Earners of the MCSA: BI Reporting certification demonstrate knowledge relevant to data analysis, data visualization, modeling, dashboards, and direct connectivity to data sources in Excel and Power BI.
July 2020 - October 2020

Microsoft Certified: Data Analyst Associate

Exam DA-100: Analyzing Data with Microsoft Power BI
Earning the Data Analyst Associate certification validates the skills and knowledge required to enable businesses to maximize the value of their data assets by using Microsoft Power BI. As a subject matter expert, Data Analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations.
March 2021

Skills

Programming Languages & Tools
Skills
  • SQL: Advanced queries, Subqueries, Views, Stored Procs, Join, Union, Create/Alter/Update tables, Query optimization
  • SSRS: Paginated reports with Parameters, Formulate/Audit logic in Datasets, Data-driven subscriptions
  • Microsoft Power BI: Data aggregation, Advanced visualizations and dashboards, DAX formulas, Power Query, App creation and RLS implementation
  • Microsoft Excel: VBA, PowerPivot, PowerQuery, Data Models, PivotTables, Vlookup, SumIf
  • Python: Pandas, Numpy, Flask, Matplotlib, Seaborn
  • JavaScript: JSON, D3, Leaflet
  • SQLite
  • MongoDB

Interests

Apart from being a Data Analyst, I am a HUGE sports fan. I grew up in the Bay Area as an avid 49ers, Warriors, and Giants fan and have been a 49ers Season Ticket Holder since when Levi's Stadium opened. I try and venture up for a couple games a year.

Outside of sports, I follow a number of sci-fi and fantasy genre movies and television shows (e.g. Game of Thrones, Black Mirror, Fringe, Star Wars, and the MCU to name a few). I also maintain my physical fitness by hiking outdoors and powerlifting at the gym.


I spend a large amount of my free time exploring the latest advancements in the world of analytics. I go through online classes on Udemy, Coursera, and EdX to keep my skills fresh and up to date. I also attended the SQL Pass Summit for the first time in 2019 and am looking forward to being more involved in the data community!