Collected/processed diverse data from highly structured flat files to raw data from web forms. Developed, reviewed, and improved SQL code to provide cohesive, actionable, high-quality data sets. Actively supported projects and teams throughout lifecycle and resolved problems using existing or new technologies. Served as POC for clients’ data teams.● Led project to automate data collection/integration across multiple contracts. Planned/developed framework, validations, and documentation. Worked cross-functionally for continuous quality improvement. The process now runs 3 times/year/with little human intervention. ● Conceived/developed new test window strategy for key client. Strategy was presented to clients in scope of existing business requirements and data models to ensure understanding and acceptance. Existing code was optimized to speed up processing, and automation was installed to deliver data in half the time.● Collaborated with program managers, IT, data analysts, and clients to write business requirements, data definitions, layouts, and schedules.

Concurrent responsibility as Production Manager/Data Analyst; coordinated data acquisition projects, organized and managed data flow, and provided customers and vendors with data sets. Communicated and documented ideas for colleagues of varying technical backgrounds.Led data project to improve marketing program efficiency. Required acquiring/cleansing/importing 100K records, researched audience overlap. Required data integration across Oracle/SQL Server. This reduced duplicate mailings/marketing costs by 20%/15%, respectively, with no negative impact on sales. ● Initiated processes to identify opportunities to reduce marketing costs. Wrote SQL queries, procedures, and views that were scalable/efficient and provided marketing with statistics and insights. New strategy reduced redundant mailers by 20%.● Created strategy to identify underrepresented markets. Cross-referenced internal data with databases to find potential new/current listees who had been screened out, identified target markets/key personas, and created titles to sell to. Resulted in $50K in new sales/data attractive to outside data firms. ● Independently investigated new income sources from data sales or product sales. Presented ideas to leadership backed up with data insights and visualization.

Point of contact/inside sales rep for large OEM customers. Ran sales histories for multiple locations and provided forecasting and purchasing recommendations. Presented sales summaries extracted from regional and product line sales data to the VP of Sales.

Promoted to Lead Bookseller in less than one year. Solely responsible for marketing and sales within Bargain Department. Modified marketing plans and routinely surpassed company sales expectations, often by double digits.

Managed small, widely diverse group producing custom ordered hardware and flag kits. Reorganized workspace to increase efficiency. Conceived and led creation of visual manuals that laid out construction procedures eliminating department downtime.