Sales Marketing
Resume:
*** ********* ***** ****: 908-616-
2169
Somerset, NJ 08873
*******@*******.***
OBJECTIVE
I am an experienced analyst of marketing, sales, inventory and financial
data, and adept at building spreadsheets, databases. My goal is to work on
a team on technical projects and support clients to build and automate
standard and ad-hoc reports and analytical tools to help manage business
growth.
TECHNOLOGIES (including years of experience)
Primary: Excel (13), Access (12), SPSS (16), SAS (20), Lotus-123 (14)
Proficient: SQL (8), VBA (7), Hyperion/Essbase (4), SAS Macros (5),
WinCross/Quanvert (3), HTML, Javascript, Visual Studio, VB.NET, ASP.NET,
ADO, C#
BUSINESS EXPERIENCE
Construction Financial Management Association 10/2009 -
present
Independent Consultant - Database Analyst Excel, Access, SQL,
Publisher
. Developed spreadsheets to link between Word and Excel tables for a mail
merge.
. Prepared relational database and user interface to manage mailings to
members.
Ultimate Office, Farmingdale, NJ 07/2004 -
11/2008
Marketing Forecast Analyst Excel, Access, SQL, Hyperion, SPSS,
Ecometry
Reporting to the Marketing and IT VP, responsible for the development of
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.
. Developed trend and forecast reports for Finance, Marketing, Sales,
Inventory
. Developed and managed spreadsheets and databases and tools for
facilitating and automating report preparation of marketing mailing lists
and warehouse backorders.
. Prepared customer segmentation for print and email marketing campaigns,
analysis of the results and recommendations for future campaigns
including inventory forecasts.
Ethnic Marketing Association and Aospinal Computadores 12/2003 -
06/2004
Independent Consultant - Database Analyst Excel,
Access, SQL
. Attended Small Business Administration training for starting a business.
. Prepared lists for email direct marketing campaigns.
. Developed an Access databases to manage customer work orders and billing.
Chase, Iselin, NJ 12/2002 -
11/2003
Reports Manager Excel, Access, FoxPro, SQL, Lotus
Notes
Reporting to the Executive VP-Home Equity, responsible for the design and
production of sales analyses, database management, and financial modeling.
Produced reports using Excel, and Access, to summarize market trends.
. Developed reports to help sales managers to manage Home Equity business
units.
. Managed pipeline database, used by loan officers and sales managers to
monitor and negotiate consumer rates for Home Equity Loans and Lines of
Credit.
. Designed production and ad-hoc analytical tools for market research,
sales, finance and management.
. Developed sales and agent rewards model based on sales volume and data
quality and the impact on profitability.
. Recipient of several corporate teamwork awards and commendations.
David M. Lynch - page 2
of 3
First Data Corp - Western Union, Montvale, NJ 01/2001 -
07/2001
Strategic Information and Analysis Manager SQL*Plus, Excel, Access,
Oracle
Reporting to the VP-CRM responsible for the design and implementation of
market research analyses, database management, and financial modeling.
Produced reports using SQL, Excel and Access, to summarize market trends,
analyze customer response to incentive programs, including loyalty rewards,
customer surveys and special events.
. Developed CRM strategies to acquire new customers, and to retain and
stimulate loyal customers, and analyzed results of these and other direct
marketing initiatives, yielding increased customers and sales revenue.
. 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, saved thousands of returned mail, allowed a better
understanding of customers.
. Analyzed the viability of strategic partnerships with other corporations;
successful joint ventures launched.
. Designed production and ad-hoc analytical tools for market research,
sales, finance and management.
. Developed sales and agent rewards model based on sales volume and data
quality and their profitability impact.
The Janus Group, Bridgewater, NJ 09/1996 -
01/2001
Database Analyst/Marketing Sciences SAS, SPSS, Excel,
Access, SQL
Reporting to the company president, I was responsible for a consulting team
assigned to specific client projects. Supervised and trained new
employees. Major accounts included AT&T, Lucent, Ticketmaster, and Home
Shopping Network.
. Developed and implemented systems utilizing SAS, SPSS, Excel and Access
to import and summarize questionnaire and census data to produce
interactive tables and graphs allowing AT&T 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.
AT&T(1993-1996); NECA(1994); KPMG Peat Marwick(1995) 04/1993 -
08/1996
Telecommunications Rate Analyst, Independent Consultant Excel, Access,
SAS
. Developed automated charting utilities; these tools were used to create
both 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, investors and FCC.
David M. Lynch - page 3
of 3
Warner Computer Services, Fair Lawn, NJ 07/1991 - 08/1992
Independent Consultant - Senior Programmer Analyst FORTRAN, Assembly
Language
. Designed, modified, tested and documented a large set of FORTRAN
programs; as new changes were required to the production system, other
developers required 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.
UNISYS Corporation, Ivyland, PA 06/1988 -
07/1991
Senior Scientific Programmer Analyst FORTRAN, Assembly
Language
. Developed FORTRAN code for the NEXRAD 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.
. Documented system and performed software test reviews and unit and system
integration testing; this assured the government the code works as
designed and system properly handled hardware faults and data input
errors.
AT&T, Basking Ridge, NJ 04/1983 -
05/1988
Staff Supervisor/Market Research and Cost Analyst SAS, SPSS, Excel,
Lotus123
. 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.
Rutgers Meteorology Department, New Brunswick, NJ 01/1982 - 04/1984
Air Pollution Consultant, Research Assistant, Weather Observer and
Forecaster
FORTRAN, SAS, BASIC
. 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.
. Several meteorological research projects with professors were prepared,
for research grants; results published.
EDUCATION
Avtech Institute of Technology, South Plainfield, NJ 05/2009 -
11/2009
SAS, C#, e-commerce: HTML, XML, CSS, Javascript, Dreamweaver, SQL, VB and
ASP.NET
. Basic and Advanced SAS, training, review for certification from SAS
Institute
. Web development and object-oriented programming, lab assignments and
project
Graduate Studies:
1982 - 1984 Rutgers University, Meteorology & Physical Oceanography
Department
1980 - 1981 University of Wisconsin-Madison Meteorology Department
Undergraduate:
BS (1980) Cook College, Rutgers University; Earth and Atmospheric Science
Specialization: Meteorology and Physical Oceanography
Minors: Mathematics and Statistics
Contact this candidate