David Lynch

Senior Data Analyst

ad3qzi@r.postjobfree.com

908-***-****

Somerset, NJ

SUMMARY

I am an experienced data analyst of marketing, sales, inventory and financial data, and adept at producing Key Performance Indicators, building relational databases, programming, query development and supporting clients with technical analyses.

My goal is to work in a team on technical projects supporting clients to build and automate standard and ad-hoc reports, and analytical tools to help manage business growth.

EXPERIENCE

Data Analytics and Statistical Analysis – Certification courses – 2024

Shaw Academy – online Upskillist courses

Data Analysis and processing using R; and, Statistical Modeling using SAS

Data Scientist/Engineer – Certificate – 2023

Kaizen Technologies – Edison, NJ

Data Sciences certification program, for Python, Spark and AWS

Metrix Learning online – Certificates – 2022

Excel, Python, Power BI, Tableau

Senior Business/Data Analyst – 07/2012 - 09/2022

T-MOBILE – Lifeline Service, supporting Marketing, Finance and IT – Warren, NJ

- SAS, Excel, Access, SQL Server, Oracle SQL, Teradata SQL, Alteryx, Linux, Google Analytics

• collected disjointed subscriber data and built new KPI reports

• developed reports and ad hoc analyses for Marketing and Finance clients, including e-commerce analytics

• built regulatory reports for Finance, filed with the FCC and state PUCs; identified fraud and production bugs

• developed a comprehensive report which identifies why subscribers lost eligibility, used every day by teammates in Marketing for campaign management, diagnostics, Sales for commissions, and by Finance for developing monthly budget; retooling processing and reporting, using Alteryx and Power BI

• developed models to predict sales for Marketing, Finance and handset management colleagues

Senior Data Analyst – 06/2010 - 06/2012

BUDCO – Analytics Department – Piscataway, NJ

- SAS, Excel, Access, SQL Server, Business Objects, Alteryx

• designed and managed relational database for auto insurance client, handling their e-commerce marketing, db QA and automated reports, agent compensation, campaign development and ad hoc analyses

• compiled socioeconomic indicators of prospects, automated agent marketing kits, retrieved for their marketing material

Database Analysis Consultant – 10/2009 - 04/2012

Construction Financial Management Association – IT – Princeton, NJ

- Excel, Access, SQL, Publisher, Business Objects

• developed an Access database for distribution of construction industry financial white paper membership management

• provided technical support for our website, email campaigns, convention data and access to industry financial reports

• created and automated marketing and finance reports using Business Objects and Access

• prepared and sent direct marketing messages to chapter members for e-commerce of financial white papers

• website maintenance, campaign development and analytics

Computer Science – Certificate – 2009

Avtech Institute of Technology – Piscataway, NJ

SAS, SQL, HTML, CSS, JavaScript, Dreamweaver

Marketing Forecast Analyst – 07/2004 - 11/2008

Ultimate Office – IT and Marketing – Farmingdale, NJ

- Excel, Access, SQL, Hyperion, SPSS, Ecometry (Inventory, Marketing and Finance system), Google Analytics

• developed standard and ad hoc reports in support of business management

• produced reports using Excel and Access, to summarize market trends, forecast product demand and profit, for Finance, Marketing, Sales, Inventory departments

Founder/CTO – 10/2001 - 06/2004

Global Metallurgical Supply – e-commerce – Somerset, NJ

- Excel, Access, Html, JavaScript

• Small Business Administration training courses helped me start a small business, selling high tech equipment to oil industry professionals

• built e commerce website and prepared lists for email direct marketing campaigns

• developed an Access database to manage customer work orders and billing

Reports Manager – 12/2002 - 11/2003

Chase – Home Equity division – Iselin, NJ

- Excel, Access, Foxpro, Sql, Lotus Notes

• designed home equity sales analyses, loan database management, financial modeling

• produced reports using Excel, and Access, to summarize market trends

• designed production and ad hoc analytical tools for market research, sales, finance and management

• developed sales agent rewards model, based on sales volume, data quality and the impact on profit

Strategic Information and Analysis Manager – 01/2001 - 07/2001

First Data Corp – Western Union – Montvale, NJ

- SQLPlus, Excel, Access, Oracle, Lotus Notes

• designed market research analyses, database management and financial modeling

• produced reports to summarize market trends, analyze customer response to incentive programs, including loyalty rewards, customer surveys and special events

• designed algorithms to match names and addresses from prospect lists with current customers, and developed logic to consolidate duplicate customers with both invalid and extra database records; this eliminated duplicate addresses, saving thousands of returned mail pieces per mailing, and allowed us to more efficiently identify and serve our customers

• designed production and ad hoc analytical tools for Market Research, Sales and Finance

Senior Database Analyst – 09/1996 - 01/2001

The Janus Group – Analytics – Bridgewater, NJ

- SAS, SPSS, Excel, Access, SQL

• managed a consulting team assigned to clients and projects

• supervised and trained new employees; accounts for AT&T, Lucent, Ticketmaster, and Home Shopping Network

• developed and implemented systems to import and summarize questionnaire and census data, to produce interactive tables and graphs allowing clients to quickly respond to market changes

• created a PowerPoint application that imports raw data into Excel to perform customer segmentation analyses by credit scoring and applying demographics; the automation saved hundreds of person days of manual labor per month

• wrote various SAS and SQL programs to validate sales and complaints data; this revealed data integrity issues for Home Shopping Network; lead to substantial new business and provided online interactive reports

• developed financial models of customer retention, projected sales and revenue and reporting tools based on customer demographics and transaction history

Telecommunications Rate Analyst – 04/1993 - 08/1996

AT&T – Marketing Sciences Department – Basking Ridge, NJ

- Excel, Access, SAS

• developed automated charting utilities; used to create ad hoc and production graphs for monthly reports; saving processing time and thousands of dollars by allowing users quick in house processing

• extracted data from Contract Tariffs; transferred to spreadsheets and organized to facilitate case studies for customers with telecommunications requirements in existing contract tariffs, saving many hours of manual labor; this tool was used in a commercial application to quickly provide service to customers

• developed user interface to interactively select fields and prepare reports from various telecommunications databases; allowing users to dynamically interact with SAS databases

• supervised clerical staff; developed managed rate databases to reduce manual labor

• developed analytical reporting tools for marketing, finance, sales managers; tools were used to report to senior management and FCC regulators

Consultant – 07/1991 - 08/1992

Warner Computer Services - Analytics Division – Fair Lawn, NJ

- FORTRAN, Assembly Language

• designed, modified, tested and documented a large set of FORTRAN programs; as new changes were required to the production system; resulting in other developers requiring significantly less effort for subsequent changes

• evaluated and developed code specifications and prepared reports for customers; used by both clients and managers for strategic marketing and rate planning

• analyzed insurance financial and competitive data to enhance corporate policies

Senior Scientific Programmer Analyst / Meteorologist – 06/1988 - 07/1991

Unisys Corporation - government contract – Ivyland, PA

- FORTRAN, Unix, SUN Workstations, Assembly Language

• wrote the programs that process the raw doppler radar scan data to form 4D objects displayed as radar graphics images and time lapse loops used today by the NWS, research facilities, news and in smartphone and tablet radar display apps

• developed FORTRAN code for the Next Generation Weather Radar system, a nationwide array of strategically placed Doppler stations; these algorithms are currently being used by the National Weather Service to identify and predict storms and severe weather such as thunderstorms, hurricanes, tornadoes, snow and hail

• built site configuration module and system user interface; documented system and performed software test reviews, built unit and system integration testing

• performed statistical analyses between radar and observed values for station configurations and validation, this assured the NWS that the modules worked as designed and system properly handled hardware faults and data input errors

Staff Supervisor – 04/1983 - 05/1988

AT&T - Strategic Pricing, Marketing and Finance departments – Basking Ridge, NJ

- FORTRAN, SAS, BASIC, VISUAL BASIC

• developed market research tools to determine the marketing objectives of the competition, analyzed Local Exchange Carrier financials; this facilitated new marketing strategies and helped to raise Millions of dollars in annual revenue

• supervised clerical and technical support staff; the training and team management allowed these assistants to better help other colleagues and for them to develop their careers

• developed cost analyses, financial models and reporting tools and reports for the FCC and justice department

Air Pollution Consultant, Research Assistant, Weather Observer, Forecaster – 01/1982 - 04/1984

Rutgers University - Meteorology Department – New Brunswick, NJ

- FORTRAN, SAS, BASIC, SPSS

• developed FORTRAN code to study the impact of Resource Recovery Plants on air pollution and automobile traffic, and processed air sampling data with EPA programs; analyses used by communities to vote on this issue

• programming and data extraction from logging devices; received award for accurately reporting data from various instruments, data used as input to forecast models by National Weather Service; prepared daily weather forecasts

• prepared several meteorological research projects with professors, for research grants; published

EDUCATION

SAS Institute – various classes – 1982-1988 - Base SAS, Graphics, Statistics, SQL, Macros, SCL

Meteorology and Physical Oceanography – BS – 1980

Rutgers University / Cook College – New Brunswick, NJ

Contact this candidate