Data Analyst Management

Lester Jack, MBA

ad00kl@r.postjobfree.com

214-***-**** cell

Summary

** **** ***** ** **** management including HR data mining and manipulation.

Advanced Excel trend analysis using formulas, creating tables, and forecasting trends.

Combined complex Excel spreadsheets from a variety of sources, utilized the data and created business dashboards to show project statuses, cash expectations, created graphs that auto update as data is entered.

Created PowerPoint and Visio presentations of analysis and presented to executive management.

Workday and Salesforce experienced.

Expert key performance indicators reporting

Education: Master of Business Administration, Amber University

Technical Skills:

Access

Advanced Excel

Advanced Outlook

Advanced Word

Budgeting

Data Modeling

Forecasting

GAAP

MS Project

PeopleSoft

Power BI

PowerPoint

Quality Center

Salesforce

SAP

ServiceNow

SharePoint

Tableau

Visio

Workday

Professional Experience:

HCL - Remote Jan 2023 –July 2023

Data Reporting Analyst

Managed large HR databases to produce trends and forecast reports.

Updated HR records in ServiceNow

Produced data models utilized in governance reports.

Developed several excel reports used to monitor network efficiency using pivot table and lookups.

Worked with network development team on enhancements and maintenance projects.

Prepared and presented project status report to management team.

Developed dashboards in ServiceNow.

AT&T- Remote April 2022 –Dec 2022

Data Reporting Analyst

Produced trend and forecast reports based on prior and future project specs.

Managed data from legacy system by adjusting prewritten SQL scripts to be used in management reports.

Developed several excel reports using pivot table and lookups to track cell tower construction expenses.

Produced data models of multiple project procedures for use by management in executive reports.

Presented findings in PowerPoint presentation to management.

T-Mobile Frisco, TX Jun 2021 –March 2022

Data Analyst

Reviewed current utilization reports and produced forecast reports for next quarter and year.

Managed large database in Salesforce used data to produce daily management reports.

Utilized data in Power BI to produce several ad hoc reports on usage trends.

Developed several excel reports using pivot tables and lookups to track projects.

Reviewed installation and testing of towers including Alcatel and Cox

Disney Corporations -Remote Feb 2021 –June 2021

Data Analyst

Prepared efficiency reports for HR used by management to determine contract compliance.

Organized and performed several presentations for management on different trends including sales and inquiries.

Performed analysis on possible payroll changes for HR.

Developed forecast reports for use by management and staff.

AT&T -remote Jul 2018 – July 2020

Data Analyst / Project Manager

Downloaded data from legacy system. Data was used to create data models for management and staff.

Project managed several switch updates and testing for multiple manufacturers.

Created several dashboards to monitor projects performance utilizing advanced excel skills.

Developed new excel spreadsheet to monitor actual verses estimated status of projects.

Lester Jack, MBA

214-***-**** cell

Abbott Labs-Plano, TX April 2018– Jun 2018

Data Analyst

Produced sales trends presentations for management utilizing Workday, Excel, PowerPoint, Visio, and word.

Analyzed sales financial records for accuracy, advised accounting on errors found.

Downloaded and data mined rep production information from legacy platform and Salesforce.

Downloaded rep information from Workday used to produce management reports.

Developed complex excel dashboards to review project performance.

AT&T -Remote April 2014 – Nov 2017

Data Reporting Analyst

Retrieved project data from a legacy system and mined data. I produced excel based reports for management.

Developed project delinquency reports and dashboards utilizing excel, word, and PowerPoint.

Downloaded 4G wireless project estimated budget totals from multiple billing systems utilizing SQL.

Created forecast report for future wireless update project costs.

Produced and presented daily metrics reports utilizing complex excel spreadsheets and word documents.

Analyzed testing data for accuracy in Quality Center making changes and updates where needed.

Clear Channel – Addison, TX Dec 2013 – Mar 2014

Human Resources Analyst

Project lead a pay equity research project. This project was designed to determine the correct salary range for a $650M nationwide company.

Developed compensation reports utilizing workday data compared to company compensation reports.

Developed multiple excel spreadsheets to monitor and report the progress of the project.

Acted as tier 1 help desk contact. Assisting people with problems related to System access, SharePoint issues and Excel problems.

Downloaded HR data from existing HR databases and Workday and Salesforce.

Tested accuracy of downloaded and newly entered information into Kenexa salesforce and Workday to determine if it met basic data standards.

Developed new excel dashboard used to track employee statuses and salary range.

Hosted status meetings with multiple levels of management on the status and findings of the project

Reviewed sales agent compensation for accuracy.

Citi – Irving, TX Aug 2012 – Aug 2013

Data /Human Resources Analyst

Developed Dashboard using Excel spreadsheets to monitor the progress of a $60M migration project from one platform to another cost-effective platform.

Facilitated weekly status meetings for middle and upper management on status of the conversion project.

Calculated associated saves from migration project totaling over $8,000,000.

Worked with the HR department on downloading needed budget information for a multinational division of approximately 400 people.

Performed HR functions for the division including onboarding new employees.

Improved accuracy of monitoring and reporting of the division’s staff roster, furlough days and vacation days.

Reviewed existing internal HR budget and prepared status reports.

Developed complex excel spreadsheet to monitor employee data for an international department.

Forecast department hiring, position moves and cost saving to make sure a department remains with a forecasted budget.

Analyzed financial data utilizing excel spread sheets. This analysis was of numerous sources containing thousands of data rows.

Developed new internal billing process including testing. This process found and corrected errors saving customers over $2M.

Designed reports combining data from several databases into an executive report of status of several projects.

Lester Jack, MBA

214-***-**** cell

British Telecom – Irving, TX Jan 2012 – Aug 2012

Data Analyst

Developed, tested, and implemented new financial reports for a multinational company that is distributed to upper management.

Built excel spreadsheets used to monitor financial data for an international billing department.

Reconciled billing amounts between multiple billing systems.

Layered Tech – Plano, TX Jul 2010 – Jul 2011

Business Human Resources Analyst

Developed new excel dashboard to report financial and HR status to management.

Compared current sales person compensation to existing Workday compensation . Data was used to determine compensation of current employees.

Updated records in Workday and produced reports based on the data.

Audited telecom billing records for an internet access/equipment company,

Facilitated billing system upgrades with IT department including performing ad hoc testing on updates.

Managed multiple project statuses and updated management on the status of the projects.

Designed and distributed sales projection reports based on current sales and historical sales using Workday.

Review sales agent compensation for accuracy

Verizon Business – Irving, TX May 2008 – May 2009

Reporting / Human Resources Analyst

Compiled financial and HR data from salesforce for a wireless group.

Developed sales forecast and sales history models used by management to monitor the sales force of Verizon.

Created ad hoc reports for executive management meetings.

Analyzed financial and HR details for a national sales team, for efficiency.

Lead weekly project ad employee status meetings with management.

Managed, designed tested and implemented billing/ reporting tool project including testing training.

Facilitated management level meetings about trending and profitability of sales.

AT&T – Richardson, TX Feb 2005 – May 2008

Financial Data Analyst

Project Managed combining of wireless and wired billing systems including writing test requirements using Quality Center,

Trained staff on billing procedures

Analyzed regional financial billing trends and produced sales forecast reports based on my analysis.

Downloaded combined and audited billing data from Cingular, Amdocs, and AT&T databases.

Created data models used to report statistics during daily status calls.

Contact this candidate