David Reznick Email & Phone Number

Hatboro, Pa, Us

Atlanta, Georgia, Us

• Revamped Lyft SSIS project to standardize mapping between Lyft invoice details and internal Insight system accounting records • Designed algorithm to dynamically generate applied bulk rate adjustments using SQL stored procedures

Conshohocken, Pa, Us

Manager, Business Intelligence/Data Warehouse Architect• Designed data model for data warehouse and engineered ETL using SSIS/Stored Procedures from various transactional sources (Dynamics AX, ASP custom backend, Google Analytics, third-party flat files, EDI documents, etc.)• Worked directly with leadership and department heads to validate and quantify all corporate initiatives from the initial viability assessment through post-launch analysis• Oversaw the BI Environment:o Acted as POC for any report inquiries or requestso Maintained SSRS report server and created over 100 unique reportso Designed two SSAS cubes to scale billions of records into a utility that end users could access directly in Excelo Acquired/Maintained/Developed integrations for new and existing data sources • Served as the technical lead for several projects requiring predictive analytics and/or data modeling. Some examples include:o Created a pricing engine to dynamically adjust pricing of catalog with 40,000+ active SKUso Implemented a keyword mapping algorithm to tie thousands of blog articles to relevant catalog elements o Created the back-end data model/stored procedures/functions for the company’s subscription-service (Auto Ship)

Mount Laurel, New Jersey, Us

Oversee and maintain multiple enterprise-level databases such as the CRM and Order Processing SystemWrite SQL code for the following purposes:• Data cleansing/data integrity• Data normalization• Ad-hoc reporting• ETL procedures for integration amongst internal and external sources of informationComplete various projects to resolve business issues and minimize inefficiencies Provide technical assistance and support for any database-related issues

Egg Harbor City, New Jersey, Us

Built Microsoft Access database to serve a variety of business functions including report publishing, inventory tracking, CRM, process streamlining, etc.Wrote custom SQL for tasks outside of Access’s core functionality Served as IT administrator by solving employees’ computer-related issues

Conducted wound-care marketing and analysis to identify and pre-qualify top hospital prospectsSalesforce.com Administrator: o Scrubbed, prepared, and imported data from multiple sources into the new database o Assigned user roles and profiles o Customized fields, layouts, and reports to fit specific business needs o Created training documents for end users to effectively utilize the CRM and enter data correctly to insure its integrity o Provided support to representatives on all Salesforce.com related issuesGenerated leads by setting appointments with C-level administrators of targeted hospitals

Pennsauken, Nj, Us

Categorize and pre-qualify inside sales callsProvide technical assistance and guidance for customers ordering CD/DVD duplicationAssist sales representatives by providing a second level of technical support for short-run projectsResponsible for pre-sales support for all CD Baby Disc Manufacturing and Disc Production Services brands