Candidate – #3120

Remote/Hybrid Preferred

SUMMARY

Business Intelligence Senior Data Analyst – As a dedicated and detail-oriented Data Analyst with over 8 years of experience, I specialize in transforming complex data into actionable insights.

Providing ad hoc analysis and reporting, sales commissions, and partner residuals. Versatility includes variance analysis, sales pipeline analysis and forecasting, market penetration, KPIs and Dashboards as Financial Analyst. Operations KPIs, BPI, and offshore resource performance management as an Operations Lead, and within a data warehouse production environment as a Report Analyst.

 

EMPLOYMENT HISTORY

SphereCommerce, Las Colinas, TX (Remote from March 2020 to April 2025)

Jan 2020 – Apr 2025

Business Intelligence Data Analyst/Senior Data Analyst

As a dedicated and detail-oriented Data Analyst with over 8 years of experience, I specialize in transforming complex data into actionable insights using advanced tools and methodologies. My expertise lies in leveraging Power BI, Tableau, SQL and Excel to drive data-driven decision-making and optimize business performance.

Key Responsibilities:

• Data Visualization: Developed interactive and insightful dashboards using Power BI and Tableau, enabling stakeholders to make informed decisions.
• Data Analysis: Conducted comprehensive data analysis to identify trends, patterns, and anomalies, providing actionable recommendations to improve business processes.
• SQL Proficiency: Utilized SQL for data extraction, manipulation, and querying from various databases, ensuring data accuracy and integrity.
• Reporting: Generated detailed reports and presentations to communicate findings and insights to cross-functional teams and senior management.
• Collaboration: Worked closely with business units to understand their data needs and provide tailored analytical solutions.
• Data Quality: Ensured high standards of data quality and consistency through rigorous validation and cleansing processes.

• Ad hoc: Providing reporting and development within the BI department across business functions utilizing RT ticket system.

SphereCommerce, Las Colinas, TX

Oct 2017 – Dec 2019

Senior Financial Analyst

• Partner with Finance, Accounting, Sales and Operations to provide monthly reporting, month end close and ad hoc requests using SSMS SQL, Power BI and excel.
• Developed and implemented Sales Rep commissions using Power BI and excel by country (US, CA, & AUS).
• Developed and implemented partner residual payments, partner residual reporting and all partner ad hoc requests analyzing TSYS fees for profitability.
• Provided TSYS fees and interchange analysis and reporting.

Burlington Northern Santa Fe (BNSF) – Contract, Fort Worth, TX

Dec 2016 – Mar 2017

Technical Report Analyst (Data and Reporting Analyst)

Evaluate business and functional project requirements to develop technical reports, graphs, and dashboards, coding in Splunk, for the Positive Train Control (PTC) project. Splunk captured all train CPU sensor logs on train activity such as speed, braking, location and stops. Utilized extensive logging detail. This is a government mandated project to install on all trains to take control of the train whenever the conductor is unable to.

Vizient – Contract, Las Colinas, TX

Apr 2015 – May 2016

Senior Analyst and Financial Analyst

• Monthly financial reporting to senior leadership on sales operations performance against budget. This included supply chain data analytic subscription sales to hospitals.
• Sales and revenue forecasting using pipeline analysis from Salesforce.com.
• Provide market penetration by product and territory, along with Geo Maps of the same in Tableau.
• Partner with the VP of New Business Development – Sales, to develop dashboards, KPIs, and other BI reports providing insight and direction in sales operations using Tableau.
• Provide ad hoc analysis and partner with application developers to automate reports and create custom reports for our sales operations team.

The Nielsen Company, Dallas, TX

Jul 2010 – Jul 2014

Financial Analyst

Provided budgeting, forecasting, and variance analysis to senior leadership; this was for the Digital Measurement, Telecom Mobile Data Acquisition businesses, and NM Incite.

• Point person for senior management in Operations across 3 major lines of business, including our JVs local and international on all issues.
• Identified financial risks and opportunities. Negotiated an 84,000 reduction in data charges for our JV Japan.
• Saved Operations approximately $750,000 identifying duplicate vendor charges, Capex, and unused funds.
• Created financial pivot dashboards and control charts, color coded, for approximately 20 cost centers or companies within 3 to 4 lines of business with 25 million in budget. Developed a higher- level dimension for custom LEE account roll-ups within the pivot dashboard providing a high-level view of variance drivers or the ability to do a deep dive down to the invoice level providing a clear financial picture.
• Performed month-end close processes, accruals, and reclassification of expenses where needed.
• Reconciled and paid offshore resource charges in the millions (over 600 resources) for Operations across multiple functions and lines of business and provided accruals for the same.
• Managed Mobile’s data acquisition line of business vendors across ten products. Set–up new vendors. Reconciled and paid all vendor invoices, including ICCs and JV cross charges, while tracking all for reporting, budgeting, and analysis.
• Ensured vendor contract compliance in the billing process and resolved all invoicing and contract issues.
• Provided ad hoc financial analysis and recommendations to senior leaders. Collaborated horizontally and vertically across companies and functions to research and resolve issues for all the above.
• Facilitated coordination to shut down two of Nielsen’s businesses.

The Nielsen Company, Dallas, TX

Oct 2008 – Jul 2010

Production Project Lead and Operations Lead

Managed the performance and created metrics for an offshore team in India of approximately 50 resources; tracked production process performance against target for trending insights, and post-mortem production issues through resolution. Assisted with new projects, and provided BPI recommendations, including a newly acquired business called Buzz Metrics. Nielsen certified in Microsoft Enterprise Project Management.

• Created SLAs (service level agreements) and set performance targets for the offshore team, resulting in a 95% overall utilization rate. Assisted with SOWs and Operations knowledge transfer from Israel to India teams.
• Created a centralized daily production report for all major tasks, to show utilization rates by task and total utilization rate across all tasks for the team. Provided a monthly dashboard, and task utilization graphs.
• Developed KPIs for onshore Operations by product and function providing insight into production targets.
• Created a training matrix for Operation Managers and their employees to show depth and skill levels by product and function. This provided direction for training and hiring.
• Produced monthly production reports for Mobile Media and Mobile Internet with SAS and SQL showing traffic and ad impressions by site and sold to clients. Provided cost analysis and process setup for these reports.
• Gathered Operational requirements for development projects (Job Jar). Created a dashboard to track projects through Job Jar phases and represented Operations in prioritization meetings.

AmeriCredit Corporation, Arlington, TX

Jan 2007 – May 2008

Report Analyst

Oversaw approximately 50 daily or monthly data warehouse production reports; developed BI reports (requirements analysis, design, code, test, implement, and document) using Oracle SQL, COGNOS (Power Play and Report Net), Informatica, SAS, and Excel, while also providing ad hoc analysis to internal and external clients.

• Developed a cube and Report-Net reports in COGNOS for senior management to show performance of all sales reps across the US. The VP considered this Cube a vital business management tool.
• Developed Report-Net reports that combined four merged companies in Informatica. Redeveloped other BI reports out of SAS into Informatica as part of an ongoing effort to move production to mostly Informatica.
• Oversaw the data warehouse corporate services inbox used to resolve any issues for over 300 monthly production reports. Worked with ETL team, Data Architecture team,

Oracle and Cognos Administrator’s to resolve all issues and for development.

RadioShack Corporation, Ft Worth, TX

Oct 2005 – Sept 2006

Database and Decision Support System Analyst

• Developed trending and month over month variance reports using MS Excel’s Hyperion

Essbase to show performance in sales and units over time for several product lines providing valuable business intelligence.

• Analyzed the impact of various tests performed on the network of 7,000 retail outlets using a statistical tool called APT (Applied Predictive Technologies). Created test and control groups, to determine what variables, demographic or others, had a significant probability of driving sales to then drive company strategy.

Early Career – Frito-Lay, Plano, TX (4 years)

Sensory Science Analyst (Research and Product Development Department)

• Performed analyses on survey data obtained from consumers tested in the field.
• Created and modified SAS programs and macros to produce statistical reports for internal clients.
• Provided modeling (ANOVA, GLM and Duncan sensitivity tests), segmentation, frequency distributions, means and lsmeans, probability values, and regression analysis to give product development direction.
• Programmed with Ci3 to create self-administered questionnaires for consumer product data gathering of snack food sampling. Created programs that significantly reduced data entry errors by field representatives and consumers to less than 1%.
• Performed approximately 50% of Frito-Lay’s Sensory Product analyses the last 2 years.
• Coordinated communication between product managers, “Sensory Scientists” and field operations.
• Evaluated consumer survey designs for validity.

EDUCATION

B.B.A., Strategic Management and Entrepreneurship with a track in Business Computer Information Systems (12 additional hours needed for this second degree in BCIS), University of North Texas, Denton, TX