EXCEL
Jeffrey Lipton
Data Analyst
Ontario,CA
Summary
Business and Data Analyst with 10+ years of experience across diverse industries. Expertise in analysis and testing of business requirements to drive deployment of applications, business processes and system solutions. Highly analytical and detailed with documented track record in full software development life cycle methodologies. Exceptional skill in SQL-based environments. Recognized consistently for performance excellence and contributions to success in multiple industries. Strengths in EXCEL, ACCESS, SQL and Tableau.
Overview
40
40
years of professional experience
Work History
Data Analyst
Select Group
Los Angeles, CA
01.2018
- Created SQL queries for Public Utility requirements in one month.
- Created EXCEL charts, maps and other analysis for multiple audiences, combining dozens of files in one easy-to-use report.
Data Analyst
Southern California Edison
Los Angeles, CA
05.2018 - 11.2019
- Maintained Grid Contract database, written in ACCESS, using Constant Improvement to reduce errors.
- Created and sent 200 emails to avert electrical fires in high risk areas.
- Developed system to read and log PDFs from California’s Electrical system, eliminating clerical errors.
- Automated monthly management reports, using SQL, ACCESS and EXCEL VBA.
- Extensive use of OneDrive and SharePoint to share data and documents.
Senior Application Analyst
Aspect Consulting
Montvale, NJ
08.2016 - 07.2017
- Performed data mining and analysis on tables with millions of rows, updated every second.
- Created Data Dictionary so staff could access schema and table layouts.
Senior Application Analyst
Unisys
Norwalk, CA
12.1977 - 08.2015
- 10+ years as head of the Quality Assurance team on the County of Los Angeles Welfare System project.
- Our team was responsible in ensuring that any program, form or screen followed strict guidelines, while maintaining government deadlines.
- Queries were approved within 24 hours with a 99.99% success rate.
- Effective use of teamwork between our group, programmers and managers led to programs being evaluated, modified as needed and promoted with in 2 days, while maintaining the precision and throughput required in a client-facing financial system.
- 5+ years of Database Administration: designed and updated database for County of Los Angeles Welfare System – millions of rows in multiple tables, accessed in sub-second transactions.
- Worked with development, system and client teams.
- Created SQL queries which were completed with 2 hours.
- Oversaw Quality Assurance team (up to 5 people) to maintain standards and ensure SQL queries were correct.
- Queries were approved within 24 hours with a 99.99% success rate.
- Tutored staff on database queries.
- Created and updated Oracle tables.
Education
Bachelor of Science - Computer Science
California Polytechnic State University
Skills
Spreadsheet management
Excel formulas
Database Management
MS Office
Software
ACCESS
SQL
Tableau
Timeline
Data Analyst
Southern California Edison
05.2018 - 11.2019
Data Analyst
Select Group
01.2018
Senior Application Analyst
Aspect Consulting
08.2016 - 07.2017
Senior Application Analyst
Unisys
12.1977 - 08.2015
Bachelor of Science - Computer Science
California Polytechnic State University