Brian Marcuse Email & Phone Number

Palmetto, Fl, Us

•Manage staff of 6 programmers with responsibilities including resource allocation. •Manage outsourced consultants •Manage Multiple data warehouses 106 TB Enterprise Aster Data Warehouse (MPP), SQL Server Data Warehouse,Oracle Data Warehouse Cloud DW using MS Azure in SQL ServerCreated Hadoop Cluster to archive historical data that is not used. Implementing Data Lake in Hadoop.•Data Architect : Work with multiple sources and analysts to define feeds and determine appropriate design for reporting, model data and create necessary marts for critical reporting.•Improved ETL performance , timing of data loads and accuracy of data feeds •Primary DBA for Aster Datawarehouse (User Creation, User rights, Query optimization, Backups,...)•Work with Analysts from multiple teams (Email, Membership, Digital, Textbooks,...) to determine best ways to report on the data.•Work closely with Business Intelligence team to get data in appropriate structures and modeled for reporting. •Ad-Hoc reporting •Assist in support of internal Email platform : Neolane •Assist in launch of additional Neolane platform for transactional emails •Worked with Director of Email Marketing to resolve spamhaus issues •Work with email team to create email validation process•Assist in CRM management (customer/household relationships)•Mentor new Staff

Email Marketing and Loyalty Data Analyst •Ad-hoc requests and reporting for email and loyalty teams•Work with Email Operations to create automated email process (Welcome emails, Membership emails, Kids Club Emails)•Built a solution to enable more targeted emails to occur in the email platform, instead of manual targeted pulls.•Report on email campaign performance and customer loyalty program. Worked with Marekting team to determine KPI's to monitor performance of email programs.•Migration of email system from Epsilon to CheetahMail, and then from Cheetahmail to internal source (Neolane)•Training junior staff

Technical Project manager on large custom technical studies (Microsoft, IBM, …). ◦Including initial project design, gathering technical requirements , implementation and QA•Automated reporting (Excel and Web based)•Technical Budgeting on Sales efforts for complex Mulit-million dollar studies.

Manager of Web Reporting Group •Manage staff of 10 programmers with responsibilities including resource allocation , Assitance with budgetihng on sales efforts with advanced reporting , Integreal member of the design committee on Harris' generic reporting solution (ViewPort Pro).•Project manager of largest study (over 3 million dollars) at Harris Interactive. •Manage migration of existing sites to .Net and SQL Server 2005. Senior Software Engineer/Project Manager. •Developed generic and customized Web based reporting systems (ViewPort Enterprise) for market research clients, using MS SQL Server /ASP/VBScript/Javascript and ADO. •Manage and serve as primary technical lead for several large projects ($500,000-$3,000,000) which include project design, technical requirements, implementation and QA. Built Generic Datwarehouse solution which supports all Custom Web Based reporting. Using Stored Procedures, Views, Triggers, Functions, complex dynamic queries, Indexes (Clustered and Non-Clustered), and foreign key constraints. •Built maintenance plans and consisteny checks for Datawarehouse. Key resource for improving performance of complex queries.

Produced standard reports and AD-Hoc queries in SAS/COBOL on MVS host. Created spreadsheets in both Lotus and Quatro Pro. LAN Administrator/Supervisor of Novell 3.11. Administrator of SAS-PC, Set-up of hardware and software configuration on Novell.

New Brunswick, Nj

Programmer/Analyst. Data Warehousing of hospital data using SAS, Business Objects, and Oracle. Maintenance of Visual Basic Application which uses both Access and Oracle tables. Creation of Access Databases for data entry. Programming of crosstabs using SAS. Programming of advanced ad-hoc requests using VBA(Access and Excel) and SAS

Programming of Computer Generated Reports using MS Office and VB. Creating Access Databases for the company and projects. Administration of Web surveys. Programming of Surveys using custom market research software. Programming of advanced ad-hoc requests using VBA(Access and Excel) and SAS.