Sales Data

Eric S. Fanwick (Wilton, CT)

*** ******** ** • Wilton, CT 06897

Phone: 203-***-**** • E-Mail: *********@*****.***

Project Management

Customer Satisfaction Measurements

Design, Budget and Staffing

Ability to manage multiple projects concurrently

Reduce Cost while improving productivity

New Product & Service Development & Innovation

PROFESSIONAL EXPERIENCE

OrthoNet Senior Systems Analyst (DBA)(2017- Present) - Create claims based data lake(multiple Terabytes in size) to facilitate a more flexible reporting structure Extensive importing and analysis of Claims data using both CPT and ICD-9 to intermate results in Excel and Tableau. . Designed system to categorize DRG codes in to hierarchical groupings for reporting and analysis purposes. Support of data for Focus Claims Analysis. Supporting multiple reporting platforms, including Tableau. Implemented ETL via SSIS from multiple data sources. Led Data Administration team. Collected requirements and implemented supporting data systems. Created Enterprise Reporting System to support Regulatory reporting systems with in a HIPPA environment. Implemented MS SQL Upgrades from 2008 thru current versions, Oversaw SQL Maintenance patches. Designed and implemented maintenance job and exception based email notification systems. Implemented backup and restore processes. Monitor and Recommended hardware and software growth bath. Used 3rd party software like IDERA and Erwin to monitor use.

Fanwick Associate, LLC

Clients include: principal

Optimization Partners (2017) E-Forecast Model - Designed the data lake, data warehouse and ETL Routine that supported the forecasting model for e-commerce sales for a major cpg/pharmaceutical company. Coordinating data from over 19 data sources including AMA, One Click, Clavis, Nielsen, IRI among other to in the creation of this system with the goal of quadrupling sales in 4 years in the e-commerce channel (mainly Jet, Box and Amazon) Created sub-system in both PL/SQL Server and MySQL to implement reporting systems

FamilyTime (2006 thru 2017) – Lead effort to create in-context based advertising system. Assisted in POS data for analysis of customer behavior. Continue support of email and database systems, create Access based recipe entry. Asp.net survey system. Ran data analysis for all survey systems that using T-SQL dynamically created tables based on the survey. SQL Server, ASP, SSIS. Led team to enhance survey tool system in asp. Worked analysis using SSAS and Market Sight tools. Cubed the survey results. Using asp.net/vb.

RestorixHealth (2015) – Data Warehouse Support – Created the ssis and store procedures to load and analyze healthcare records. Created analytics to cull out information on placement of new facilities and ways to increase ROI based on procedures

Landauer Metropolitan (2007 – 2017) – Lead Image processing – order processing system in asp.net/c#/JQuery, SQL Server, SSIS, SSAS, SSRS. Using LINQ to integrate. Did all Database Architecture. Designed rules based analytic engine to allow administration to better identify and process product. Designed stored procedures PL/SQL in Oracle. Worked performance and deadlock issues using profiler and perfmon. Set up SQL Server 2014 Test environment Set up replication. Development Access based billing systems for truck routes, Creation of interactive voice response system. Support of customer portal and data entry system, creation and support of Customer Service Order Entry system, Set up data warehouse with dataloads from BrightTree, Dataline and FastTrack and Team-DME.

AllCare (2014 – 2017) – Set up data warehouse in MS SQL Server using SSIS loading data from BrightTree. Developed reports using Access. Use SSIS to load bright tree data. Used SSAS for reporting cube on sales reports. Worked in SQL Server 2014

TruGreen (2010 thru 2015) – Creation of detail marketing analysis and support of marketing studies PL/SQL, MS Access, Excel. Loaded and analysis Experian consumer data of over 1TB. Using TruGreen sales data against Experian consumer to analysis ways to identify new customers and territories. Analysis take place normally in summer months, using Excel, SSIS and other tools to gather insights into company growth.

Sealy (2006 – 2009)– support of databases and analysis of mattress studies. Creation of innovation tracking system. SQL Server Access. Sealy Study revolved around new product and market development, supported marketing research analysis using Excel and SSIS. Used mattress experimental data to identify successful new products

Gartner Group (2009 – 2012) – Work on development of multiple systems to assist in seminar analysis. Using SQL*Server, MS Access

Stamford Hospital (2006 – 2011) – Design, implementation and support of patient scheduling and tracking systems. SQL Server, SSIS, MS Access. Managed team to upscale backend from access to sql server 2008. Used T-SQL to automated data analysis.

FamilyTime.com, Fairfield, CT(1999 – 2006).- CTO/VP Product Development 3/00 – 3/06

A leading Internet marketing services company. Supporting both the internal FamilyTime web site and multiple client websites in the B2C space and e-commerce space and Intranet area.

Mission: Hired by CEO into startup Internet Company to be agent of change. Built internal technology staff while reducing technology spending as a percentage of revenue while increasing productivity. Department size of up to 10, including 2 project leaders)

Email Management system. Responsible for the FamilyTime email program. We send over 2.5 million emails a month and I have automated the systems for bounce processing (both hard and soft). Automated the unsubscribe link. Monitoring of the IP that we mail from which is 216.244.110.42 to ensure that it is on no spam lists. Using vb.net

Email tracking. Develop systems to monitor email sends opens and click as well as the reporting system on them.

Development of Kagome.us. website. Kagome a juice product from Japan. I led a team to develop both an informational web site at kagome.us as well as an e-commerce component at http://shop.kagome.use

B to B Website to distribution information from producer to provider. http://www.campbellsseeds.com The Campbell’s Seeds web site allows Campbell’s to provide information of seed products to farmers that are available through distributors. The site developed in asp.net(c#) has such features as dynamic map gif, dynamic pdf generation. Intelligent search.

Web base delivery of Public Relations monitoring, Project Manager. System takes electronic feed, scans for mention of companies, products and issues and then rates them for prominence of topic and subjectivity of article. Led team of 3 developers. Project developed using asp.Net/C#

National non-Profit organization. Project lead. Development for new web site in asp for that included elements of e-commerce for donations and merchandise. http://www.kab.org (1 developer)

Web-based food and family related service for consumers. Project Lead. Manage technology team in development of a sophisticated, while providing a powerful marketing channel and information for Consumer Products Goods companies. Designed and implemented database CRM system for tracking user behavior and E-commerce. (5 developers and 1 team leader) http://www.familytime.com

Lieberman Presidential Campaign: Technical Outside advisor. Develop initial Website and advised on subject of Email Campaign, Networking and computer security prior to the official announcement.

Internal Project. Project Lead. Managed, designed and develop systems to automate email campaigns in support of 2 million+ email a month distributed with original content to 75,000+ users on a daily basis. Resulted in $150,000/annum savings. (2 developers)

Banking software. Project Lead to develop web based front end for a banking industry leading software system that deals in the area for foreign exchange swaps, options, forward and spots, fixed incomes swaps, options and forwards. Project developed in .net.(C#) System worked across multiple databases. (2 team leaders and 5 developers)

Reduced firm’s technology spending by 67% while, increasing productivity and project workload. Replaced outside email service bureau with internal staff resulting in an 8% reduction in total company expenses.

Lights, Camera, Interaction!, Inc., Westport, CT. Chief Information Officer 10/98 – 3/00

An industry leading educational toy company. Using industry leading direct marketing techniques, the company experienced consecutive 40 to 100% growth years in a mature market. Company size 20 to 30 employees

Mission: Hired by owner to develop internal information system to support rapid growth.

Conceived and delivered corporate technology strategy. Designed Web and Internet strategies. Modernized and converted corporate databases and data warehouses around SQL*Server. Directed all Y2K planning.

Created sales information system to dynamically present best product by customer and to monitor best time to market by customer. Feed into CRM system that lead to a 40% increase in sales in a 1 year period, Designed and implemented a bar-code based inventory tracking and shipping system with EDI Links to vendors.

EIS Solutions, Norwalk, CT., President 3/88 – 10/98

Firm specializing in consulting, software development management, design and implementation of advanced software system.

Project: Client: Lipper Analytical Services – Mutual Fund Tracking and reporting system/Data feed System Integration – Client: Project Leader

Designed and implanted system for the rapid recalculation of fund performance. System allowed for real time calculation of thousands of performances using DCE, Sybase and Powerbuilder. This system used to create daily mutual fund data printed in Wall Street Journal and other daily newspapers. Converted existing Wang, ISAM file based application to SQL*Server based application. Lead team of 6 developers.

Project: Client: Merrill Lynch - International Mutual Fund Research System –Project Leader.

System was deployed to over 1000 Merrill Lynch Branches. This is a tool Designed, Managed and implemented system to allow for the rapid analysis of customer portfolio base on Mutual fund holdings.

Project: Client: Citicorp – Litigation Tracking System –Project Leader.

Designed system to allow Citicorp to track outside counsel activities. Implemented system. Maintained Database management and all DBA Activities. (5 developers)

Project: Client: Citicorp – Legislative Tracking System –Lead Developer.

Developed and implemented system to allow Government affairs the ability to track all state legislation. Developed rapid data import system for legislation.

Project: Client: Xerox –Strategic Marketing Database – Lead Developer/DBA

Designed and implemented a system based on Dunn and Bradstreet information to allow sales and marketing to target low volume customers with high volume potential based on size and industry.

COMPUTER BACKGROUND

Software Windows XP, 2000, Visual Studio. ASP.Net, C#.Net, VBA, ASP, VB, VB Script, SQL, Sybase, SQL Server, Erwin, HTML, DHTML, SSAS, SSIS, SSRS

EDUCATION

Pace University, White Plains, New York. Masters of Science with honors - Computer Science

George Washington University, Washington, D. C. Bachelor of Arts - Economics

Contact this candidate