I supported marketing efforts of the Acquisition, Up-selling, and Retention (Get, Grow, and Keep) teams by identifying demographic and product usage variables to create distinct market segments.I used R, SQL, and SAS to extract demographic data from ACS for 20k ZIP Codes to understand who and where the customers were in the new combined Charter footprint.I became the expert in identifying the 325.5k monthly moves within TW Cable footprint using SQL and SAS to combine data from multiple sources to track changes over time by various attributes allowing targeting of messages to movers before or after a move.I created Monthly and Quarterly workbooks in Tableau with 250+ customer characteristics and variables for strategic planning by the marketing teams.

Used SAS to aggregate data from multiple sources for submissions to Early Retiree Reinsurance Program offered by Department of Health and Human Services. Completed accurate delivery of medical claim data in the required format for multiple clients of Towers Watson.

Improved the development of databases for Nielsen Claritas Business Data Products.Researched recent economic indicators and analyzed Monthly Retail Trade reports from the U.S. Census Bureau to revise the methodology for setting control totals for the Retail Market Power product which reports retail sales and consumer expenditure estimates at various geographic levels to allow actionable site and market analysis.Improved efficiency in the programs creating databases by reducing the number of lines of code and the number of programs needed which resulted in reduced run times. Reduced chances for error by removing hard-coded references and replacing them with a regularly updated data source and by recommending improvements in the DQA reports and checks. Chaired a cross-functional internal SAS users group and coordinated the annual licensing updates for 20 users across the company in multiple locations throughout North America and Europe.

Coordinated the move of a small technology company into a larger office space currently under construction by working with the architect, general contractor, and management company to ensure that the space was built to specifications by learning to read blueprints and use Visio to update plans. Selected and scheduled subcontractors for electrical and voice/data wiring, movers, and Internet providers.

Supplied the data needs for multiple areas within the company’s Consumer Organization to facilitate the expansion into new products and services.Partnered with multiple functional areas to develop a national standard for assigning and maintaining local billing zones when MCI launched its Neighborhood local telephone service across the entire country. Derived a paid revenue field using SAS to produce new local customer and prospect models needed to reduce the low profitability of new local customers.

Managed all data needs for MCI Specialty Brands, 10-321, 1-800-COLLECT, etc., including pulling leads for customer and acquisition mailings, selecting records for customer research and focus groups, extracting records for sweepstakes, and providing response reports. Managed the data processes for a 50 million piece mailing as part of the national launch of MCI's 10-321 dial-around product by collaborating with internal and external IT resources, multiple print shops, and the internal product manager. Mail was nationally dropped within a short time-frame to achieve maximum exposure.

Managed over 20 domestic, international, new product, and current usage projects for MCI customer mailings with 100% on time delivery to ten different vendors as part of the Customer Communication strategy to add products and increase usage in current customers. Selected over 18 million customers for mailings on the basis of state, products, tenure, language, demographics, or usage to up-sale additional products or stimulate usage.Developed detailed reports to quantify installs and usage resulting from specific direct mail marketing campaigns.Saved MCI $100 million plus in consulting fees by creating programs to select records for existing customer mailings using SAS, SyncSort, and Easytrieve Plus.Managed and directed the resources to incorporate the portfolio of Customer Communication projects into the CRM system. This increased the scope of the initial CRM system from processing the 100 thousand new installs to processing the entire 14 million customer base which required new IT resources and data transfer procedures in order to maintain the existing biweekly schedule.

Supported the Direct Response, Advertising, Joint Promotions, and Partner Marketing channels by providing install and reject reporting and identifying customers for special promotions or surveys.Audited new reporting systems and identified errors in the logic that assigned channel credit for new installs to ensure proper revenue accounting for the channels supported.

Managed the tracking and reporting of all capitalized labor for MCI. Managed the transition from manual time sheet processing to Optical Character Reader (OCR) technology for reporting capitalized expenses while maintaining the accurate entry into the monthly P&L process.