Senior Market Research & Analysis Manager
Resume:
K. SHAYNE JACOBSON
Email: *********@****.***
Seymour, CT 06483 Home: 203-***-****
Cell: 203-***-****
SUMMARY OF DATABASE, ANALYTICAL, PROGRAMMING SKILLS
Analytical Skills Data Analysis, Statistical Analysis, Forecasting, Mathematics, Predictive Modeling, Problem Solving, Quantitative Analysis, Research
Programming Skills Algorithm Development, ETL Methods, Performance Optimization, Performance Tuning, Production Support, Report Development, Reporting Accuracy, Resource Utilization, Testing, Troubleshooting
Database Skills Capacity Planning, Data Conversion, Data Mining, Database Development
SOFTWARE
Databases Microsoft SQL Server, SQL, Transact SQL, Microsoft Access, Business Objects
Statistical EPS, ESP, Shazam, E-Views, SAS, SPSS
Mapping EGIS
Other EXTRA!, TSO, ISPF, Lotus 1-2-3, Mathematica, BASIC, COBOL, Pascal, Fortran
Office Microsoft Excel, Word, PowerPoint
PROFESSIONAL EXPERIENCE
Sole Proprietor
The Art Works & Image Factory, Seymour, CT, February, 2011 – Current
• Developed a website and an online shopping cart for marketing and retail sales.
• Managed advertising outlets and social media presence.
• Developed product line.
• Developed retail pricing for new products, and organized the placement of products in different venues.
• Managed a stock and option portfolio, calculated entry and exit prices, and net effect of multiple trades within one symbol, and compared the overall performance of different strategies.
• Managed two rental properties.
Senior Market Research & Analysis Manager
AT&T Connecticut, New Haven, CT, 2000 – 2010
• Automated data extracts from corporate data warehouse using Microsoft Access SQL scripts, pass-through queries, linked tables, and macros; and automated data summarization using Microsoft Excel data links, macros, and formulas. Automation processes were flexible, provided accurate results, and adapted to a wide variety of data reporting needs, including dozens of daily, weekly, and ad hoc reports such as:
o Reconciling customers’ statuses from disparate DSL wholesale/retail billing systems, satisfying auditor requests, leading to improved billing accuracy and increased revenue.
o Reporting revenue accruals to bring accounts into compliance with generally accepted accounting principles; designed robust processing to handle idiosyncrasies and unique requirements of various products, product promotions, variable billing cycles, and revenue streams, including: Circuit Switched Data, Frame Relay, DSL, Long Distance, Toll Free, and Coin Services.
o Increasing accuracy in reporting monies owed to business partners, monthly customer counts for Marketing, upgrades to fiber optic service for Marketing and resource planning, detailed DSL Customer lists and promotional information for Marketing and billing accuracy, and DSL customer stratification by price and speed for Marketing.
o Reporting daily landline and DSL installs and disconnects for Consumer and Business Marketing.
o Reporting market penetration of landlines and DSL by Wire Center, ZIP code, Distribution area, and Cable Competitor for marketing campaigns.
o Providing customer counts by product, toll minutes, and revenue, annually, as well as on an ad hoc basis, for regulatory hearings, and Investor Relations meetings.
• Developed standardized data definitions and edits for counting DSL customers and revenue adopted by Finance, Marketing, and IT, improving reporting consistency, accuracy, and efficiency.
• Produced maps of Connecticut from combining corporate data warehouse and public utility filings that used color and icons (for color blind audiences) by town indicating market penetration of landlines and DSL for presentations to upper management.
• Constructed projections of customer counts by product, toll minutes, and revenue for budgeting and planning purposes, and for regulatory hearings, and Investor Relations meetings.
• Migrated reports, ETL, and reporting processes from Lotus to Excel, from Business Objects to Access and back, from one Access database to two and back, from Access to SQL Server, and from a data warehouse with one data model, to a data warehouse with a different data model.
• Forecasted overall corporate workload drivers for workforce planning by regressing workload drivers against dozens of combinations of forecasted economic variables and demographics. Generated a consensus growth rate using growth rates derived from these econometric models.
Staff Specialist – Financial, Marketing/Sales, Information Services
Southwestern Bell Communications, New Haven, CT, 1996 – 2000
• Analyzed and forecasted counts of toll calls made in Connecticut, and revenue generated, on a daily, monthly, and annual basis for Residential and Business Toll, as well as WATS and 800 services; data used for financial and network planning, marketing, and regulatory purposes.
• Produced actual vs. forecast reports, and analyzed deviations for financial and network planning, marketing, and regulatory purposes.
• Systematized technique for incorporating market intelligence and other information from sales channels into toll call and revenue forecasts for budgeting and product management purposes.
• Developed technique to forecast toll calls and revenue for the last day of each month, allowing Controllers to close the books a day earlier.
• Designed and systematized technique to forecast month end toll calls and revenue based on data for several days early in the month for financial and network planning, and marketing in response to a particularly volatile period and inaccurate budget.
• Developed and implemented statistical technique to update annual toll call and revenue forecasts with confidence intervals every month.
Staff Associate – Financial, Marketing/Sales, Information Services
Southern New England Telecommunications, New Haven, CT, 1990 – 1996
• Designed a special variable, a grid search technique, inspired by the Hildreth-Lu procedure, and a non-linear iterative technique, inspired by the Cochrane-Orcutt iterative method, to estimate the impact of competition on toll calls and revenue for financial and network planning, marketing, and regulatory purposes. Implemented grid search technique in EPS and converted to ESP. Implemented non-linear iterative technique in ESP and converted to Shazam, then E-Views.
• Assumed responsibility for analyzing, forecasting, and compiling monthly and annual revenue reports generated by toll telephone calls made in Connecticut on a daily, monthly, and annual basis for Residential and Business Toll, as well as WATS and 800 services.
• Initiated use of the ratio of non-manufacturing employment over non-agricultural employment to reduce the impact of the ARIMA adjustment on toll call forecasts.
• Produced a Mathematica program that performed least-squares regression with an ARIMA adjustment on the residuals.
• Coordinated forecasts from and communicated data between Finance, Network Planning, Product Management, Regulatory, and Business Intelligence.
EDUCATION
Graduate Courses in Statistics 1987-1990
Bachelor of Science, 1985
Major in Mathematics/Numerical Analysis, Minor in Computer Science
Southern Connecticut State University
New Haven, Connecticut
Contact this candidate