Data Analyst Business
Resume:
David Lynch
Senior Business Data Analyst
*****.******@*****.***
Somerset, NJ
SUMMARY
Seasoned Data Analyst with over two decades of experience in analyzing marketing, sales, inventory, and financial data. Expert in producing Key Performance Indicators (KPIs), building relational databases, and programming query development. Proven ability to support clients with technical analyses, reduce costs, increase profit and customer engagement through innovative data-driven solutions. Adept at developing and automating standard and ad-hoc reports and analytical tools to drive business growth. I am currently retired, seeking a Data Analyst role.
TECHNICAL TRAINING
Code Academy courses — Metrix Learning online certification preparation 2022, 2024
Excel, Python, SAS, Power BI, Tableau
Data Analytics and Statistical Analysis — Shaw Academy online Upskillist Certification Courses 2024
Data Science using R; Statistical Modeling using SAS
Data Science/Engineering courses — Kaizen Technologies Edison, NJ 2023
Data Sciences certification program, for Python; Spark and AWS
Computer Science courses — Avtech Institute of Technology - Certificate Piscataway, NJ 2009
SAS base; SQL, ASP, C# coding; web development using HTML, CSS, JavaScript, Dreamweaver
EXPERIENCE
Senior Business Analyst — T-Mobile - Lifeline - Marketing, Finance and IT Warren, NJ 07/2012 - 09/2022
Utilized SAS, Excel, Access, SQL Server, Oracle SQL, Teradata SQL, Alteryx, Linux, Google Analytics to unify data from multiple sources and years with millions of observations and thousands of variables.
Extracted integrated subscriber data from vender and internal files, built and managed QA and reporting, including automated PowerPoint and Excel summary graphics, tables, charts and interpretations for users in Marketing, Finance and FCC.
Built and reviewed Google Analytics HTML and results for Marketing.
Analyzed and synthesized fragmented subscriber data to generate comprehensive KPI reports, resulting in a 15% reduction in client churn and a 20% increase in subscriber usage insights
Developed and automated comprehensive reporting systems for Marketing, Finance, and e-commerce analytics, resulting in a 50% reduction in report preparation time and enabling data-driven decision-making across departments
Developed and trained staff on regulatory reporting for Finance, ensuring compliance with FCC and state PUCs regulations, and identifying fraud and production bugs; these reports detected 5-10% potential fraud in services.
Designed a comprehensive report to identify subscriber eligibility loss, supporting Marketing, Sales, and Finance teams in campaign management and diagnostics
Retooled processing and reporting using SAS, SQL and Alteryx, enhancing campaigns and budgeting.
Developed Power BI dashboards for real-time data visualization and decision-making
Built predictive visual models and automated dashboards for sales forecasts, aiding Marketing, Finance, and handset management colleagues in strategic planning
Senior Data Analyst — BUDCO – Analytics Department Piscataway, NJ 06/2010 – 06/2012
Leveraged SAS, Excel, Access, SQL Server, Business Objects, and Alteryx to design and manage relational databases for an auto insurance client
Handled e-commerce marketing, database quality assurance, automated reporting, agent compensation, campaign development, and ad-hoc analyses
Compiled and analyzed socioeconomic indicators of prospects to enhance marketing strategies; automated the creation of agent marketing kits, streamlining their retrieval for marketing material
Developed comprehensive workflows, process documentation, use cases, activity diagrams, and other business process modeling methods and tools
Managed projects and initiatives from inception to completion, ensuring all deliverables were met on time and within budget
Consultant — Construction Financial Management Association - IT Princeton, NJ 10/2009 - 04/2012
Using Excel, Access, SQL, Business Objects, developed an Access database and user interface to import membership data and output paginated letters and reports for distribution of construction industry financial white papers and membership management
Provided technical support for corporate websites, developed email campaigns, and managed 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
Marketing Forecast Analyst — Ultimate Office - IT and Marketing Farmingdale, NJ 07/2004 - 11/2008
Used Excel, Access, SQL, Hyperion, SPSS, Ecometry (Inventory, Marketing and Finance system), Google Analytics to develop 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, and Inventory departments
Founder/CTO — Global Metallurgical Supply - e-commerce Somerset, NJ 10/2001 - 06/2004
Leveraged 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 using Excel, Access, Html, JavaScript
Developed an Access database to manage customer work orders and billing
Reports Manager — Chase - Home Equity division Iselin, NJ 12/2002 - 11/2003
Designed home equity sales analyses, loan database management, financial modeling using Excel, Access, FoxPro, SQL and Lotus Notes
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 Analysis Manager — First Data Corp / Western Union – Analytics Division Montvale, NJ 01/2001 - 07/2001
Designed market research analyses, database management and financial modeling using SQL Plus, Excel, Access, Oracle, Lotus Notes
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 Developed logic to consolidate duplicate customers with both invalid and extra database records
Implemented these improvements, standardized customer addresses and eliminated duplicate addresses, saving several thousand 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 — The Janus Group – Marketing Analytics Department Bridgewater, NJ 09/1996 - 01/2001
Supervised and trained new employees and managed a consulting team assigned to clients and projects
Managed accounts for AT&T, Lucent, Ticketmaster, and Home Shopping Network
Led system upgrading SAS version and new statistical analysis routines
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 with SAS, SPSS, Excel, Access, SQL
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 — AT&T - Marketing Sciences Department Basking Ridge, NJ 04/1993 - 08/1996
Developed and automated charting utilities; used to create ad hoc and production graphs for monthly reports
These enhancements allowed us to produce in-house standardized and ad-hoc reports, saving processing time and thousands of dollars by allowing users quick in house processing
Automated extraction of data from Contract Tariffs; transferred to spreadsheets and organized to facilitate case studies for customers with telecommunications requirements in existing contract tariffs
These enhancements resulted in saving many hours of manual labor
This tool was used in a commercial application to quickly provide service to customers
Managed, supervised and mentored junior technical support staff and clerical staff
Developed user interface to interactively select fields and prepared reports from various telecom databases allowing users to dynamically interact with SAS databases
Developed and managed current rate databases to reduce manual labor
Developed analytical reporting tools for marketing, finance, sales managers
These tools were used to prepare reports for senior management and FCC regulators using Excel, Access, SAS
Consultant — Warner Computer Services – Auto Insurance - Analytics Division Fair Lawn, NJ 07/1991 - 08/1992
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 accident insurance reports, financial and competitive data to enhance corporate policies
Senior Scientific Programmer Analyst / Meteorologist — Unisys Ivyland, PA 06/1988 - 07/1991
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, ensuring system properly handled hardware faults and data input errors
Staff Supervisor — AT&T - Strategic Pricing, Marketing and Finance Basking Ridge, NJ 04/1983 - 05/1988
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 using FORTRAN, SAS, BASIC, VISUAL BASIC
Air Pollution Consultant, Research Assistant, Weather Observer, Forecaster — Rutgers University - Meteorology Department New Brunswick, NJ 01/1982 - 04/1984
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 NWS award for accurately reporting data from various instruments; was data used as input to forecast models by National Weather Service and prepared daily farmer weather forecasts
Prepared several meteorological research projects with professors, for research grants; published
EDUCATION
Graduate studies at University of Wisconsin-Madison 1980-1981
Graduate studies at Rutgers University – New Brunswick, NJ 1982-1983
BS Meteorology and Physical Oceanography Rutgers University / Cook College – New Brunswick, NJ 1980
https://www.linkedin.com/in/david-lynch-4ba399177
Contact this candidate