Migrated Salesforce table data to Azure Synapse server to create dataset for reporting and dashboard of $20 million cost centerWrote SQL scripts and leveraged Azure ETL tools including Data Factory and Synapse to marry Salesforce data with cost of goods data from SAPConverted pre-existing Tableau reports to PowerBI application with enhancements to dashboard views for usability and functionality customization for various levels of corporate hierarchy

Created pipelines in Azure Data Factory to pull data for various production, manufacturing, warehousing and sales analysis projects. Wrote SQL Server queries and views to clean and deliver data solutions for multiple departments in the company. Loaded data into PowerBI to assist in visualizations and dashboard creation for end users.

Implemented corporate structure for day-to-day operation of a 7 employee business focused on the physical, mental and social health of clients thru regular exercise, social interaction and life coaching programs. Managed sales and marketing initiatives in pursuit of corporate goals for growth and profitability. Fostered “business within a business” paradigm to encourage independence among employees and sense of ownership. Developed strategy for brand awareness/recognition and marketing strategy.Doubled membership in first year via marketing strategy centered around social media ad campaigns with Facebook and Instagram. Created referral program to reward loyal customers for selling Motiv8 to friends and family.Established protocol for daily and weekly employee contact and communication standards to onboard new clients.Developed systems for fitness testing to identify baselines for training goals and results-based objectives. Created unique running program training methodology that incorporates traditional approaches tied to cross-training for better retention and engagement in full suite of Motiv8 services.

Directed the growth of membership with communication strategies and tactics to elicit consumer interest and convert trial memberships to full time status. Coached fitness trainers on developing goals and forming regular habits around attracting new clients and retaining existing ones. Instructed up to 40 clients at a time in proper exercise form with regard to function and movement thru each plane of motion. Educated clients on natural, whole-food based diet philosophy and the role of hormonal balance in maintaining healthy body composition and function.Generated over 85% growth in membership over a twelve month period thru marketing initiatives centered on conversion of trial period memberships to full time status.Developed systemized onboarding of new clients to incorporate them into existing community with weekly and monthly challenges and happy hours to motivate clients to form social bonding around their peers for better support.Designed and introduced loyalty initiatives to minimize attrition thru development of client recognition programs

Engage mid to large sized employers in impacting population health management and wellness with a comprehensive suite of health and wellness services. Consult with employers on strategies to drive better health outcomes through communication to employees and dependents. Empower business owners with visibility through population health reporting and control over the activation of engagement programs using common technology and database platform.Renewed approximately 90% of accounts in 4Q2012.

Negotiated yearly group insurance contract renewals through relationships with key broker partners and C-level executives. Leveraged claims experience to develop customized benefit strategies driving stability in yearly rate adjustments. Partnered with human resources departments on strategies to educate and inform employees on changes to their benefit designs and available Kaiser Permanente services.Renewed approximately 90% of book of business in a market faced with historically unprecedented economic challenges and 10.5% unemployment rateDeveloped wellness programs for Lube Stop Corporation and Voss Industries employees focused on smoking cessation and awareness of Kaiser Permanente healthy lifestyle programsSuccessful renewal negotiations for 2011 resulted in an average annual increase of 6.8% for 1Q2012.

Managed relationships with pharmacy chain, grocer, mixed merchant, discount retailer, association, and independent pharmacies in a 65,000 store pharmacy network. Developed strategies and programs to leverage the pharmacist / patient relationship with the goal of increasing plan enrollment, improving patient health and cost share and promoting profitable drug mix. Evaluated pharmacy partners quarterly on key performance indicators to assist network pharmacies in increasing revenue through incentive programs.Developed and implemented communication to stimulate pharmacist engagement in therapeutic substitution, maximizing incentive earnings and relieving workload for pharmacy managementLed cost savings initiative to align pharmacy reimbursement for diabetic supplies to mirror the Medicare Part B DMERC pricing structure. Adjustments to reimbursement led to $700,000 annualized reduction in drug spendDesigned and executed testing procedures to investigate errors in pharmacy network setup during processor transition to TelePAID / Medco system. Less than 1% of processing rejects / pricing issues were related to pharmacy network setupIncorporated pharmacy network communication technology into incentive programs to increase network-wide generic utilization by more than 2% in 2007

Evaluated new product offerings to enhance wholesale product mix and facilitate better value to customers and end-consumers. Consulted with vendors to determine the most effective marketing strategy to support manufacturer product focus while synchronizing marketing efforts with sales initiatives. Analyzed demographic audiences, market trends and sales history to develop persuasive marketing plans targeted at both business and end-consumer markets Consistently exceeded quarterly sales forecasts to procure $1.4 million in cooperative advertising funds in 2006Led strategic initiative to increase Diabetes group revenue by $1 million through direct mail marketingIncreased cooperative marketing participation by 25% over 2005Developed a Diabetes Care Program including quarterly newsletters, product catalogs, and e-mail updates to promote Diabetes education and encourage customer retention

Supported sales team with pharmacy claim demographics showing volume, market concentration, and chain market share to determine profitable rate structures for each client’s pharmacy network. Maintained pharmacy database to ensure accurate, timely updates to client networks and minimize disruption of service for new pharmacies or pharmacies with new affiliationsLed 60,000 pharmacy re-contracting effort to align reimbursement with market competitionCreated marketing material for solicitation of pharmacy processing contracts, including writing copy for announcements, benefit illustrations, and contract addendums