Data Analyst Manager

ROBERT JACK Brooklyn NY *****

****************@*****.***

m. 917-***-****

S K I L L S and S T R E N G T H S

● Data Modeling: Collect, clean, model and analyze structured and unstructured data for business initiatives and intelligence

● Excel: Clean, extract, interpret and analyze data to identify key metrics, transform data into actionable information through conditional formatting, creating formulas, concatenating data, VLOOKUPS / XLOOKUPS, Pivot Tables, named ranges, filters, slicers

● Understanding of Statistical Modeling for business and data analysis

● Dashboards: create visually impactful dashboards in Excel and Tableau

● SQL: PostgreSQL coding to clean, retrieve, query and aggregate data from large databases

● Tableau: query and analyze data, create visualizations, dashboards, and storybooks

● Project management, development and coordination through collaboration and oversight

● Experienced in Client Servicing, verbal and written communications

● Development of standard operating procedures and project-specific procedures

● Writing and editing analytic reports for content, clarity and accuracy

● Able to work independently as well as in team collaboration

● Strong creative problem-solving desire and ability

● High attention to details and meticulous in organization

● Dedicated to setting goals and following through for success D I G I TA L

● Microsoft Excel, Word, Powerpoint, Google G-Suite

● PostgreSQL (Intermediate)

● Tableau

● Adobe Photoshop, Illustrator, InDesign, Lightroom, Acrobat E D U C A T I O N City College of New York, New York 1994 BSLA Landscape Architecture, Honors List

Certifications: Data Analysis, General Assembly, 2020 Probability and Statistics for Business and Data Science, Udemy, 2020 Google Analytics, 2020

E X P E R I E N C E S

GV Art Conservation, New York March 2012 – July 2020 Project and Studio Manager

● Operations management of projects including work planning schedules, coordinated projects with services and clients, tracking project development details

● Database administration / management and analyze internal data

● Generate data reports, charts on clients, projects, work process

● Research and analysis specific to projects including creating innovative solutions

● Write, review and edit technical reports and data analysis to meet business needs ROBERT JACK Brooklyn NY 11215

****************@*****.***

m. 917-***-****

● Budgeting and tracking expenses

● Develop and establish standard work guidelines, both general and project specific

● Coordinate services with logistics vendors following established protocols

● Client consults and correspondence to ascertain project budgets, goals; develop approaches to meet needs, and keep clients apprised of project status and deadlines

● Schedule daily work for employees; coordinate workspace, materials and equipment

● Review project progress and target deadlines, adjust schedules with vendors / clients

● Hiring process: write job descriptions, review resumes, interviews, onboarding

● Develop and maintain database system for tracking projects and clients

● Operational management of facility including physical systems, maintenance, upkeep Paul Kasmin Gallery, New York March - November 2011 Registrar

● Updated artwork inventory, catalogue and archive project and exhibition information

● Shipping of artwork, including imports and exports

● Managed 3 warehouse locations to accurately track large inventory at gallery

● Regularly review main facility to assess maintenance conditions

● Coordinated with Gallery Manager to plan and prepare for upcoming projects

● Coordinated with Head Preparator to complete installations, special projects

● Worked in a fast-paced environment to manage several projects concurrently AC Lawrence Real Estate, New York December 2010 – March 2011 Licensed Real Estate Salesperson

• Residential rentals and sales

• Monitor and assess physical conditions of rental property for quality Lehmann Maupin Gallery, New York June - November 2010 Production Manager

● Managed the operation schedule, oversaw Operations Department staff

● Primary point of contact for maintenance, infrastructure of facility

● Maintained and tracked a large inventory of artworks at 2 gallery and 3 warehouses

● Supervised the Art Preparator staff at 2 gallery locations

● Managed the Registrar and all shipping of artworks

● Planned department’s yearly budget, tracked expenses through monthly reports

● Managed artist fabrication projects, coordinated with fabricators to ensure completion

● Arranged shipping of artworks domestically and internationally

● Supervised installations of exhibitions in the gallery, including planning with artists, preparation of facilities, budget planning, scheduling, and completion of installations

● Planning for art fairs, including booth planning, arranging packing and shipping Peter Blum Gallery, New York November 1997 – June 2010 Registrar and Head Preparator

● Responsible for cataloging the gallery’s inventory of artworks, maintaining good client relations, coordinating projects with staff and outside vendors, organized events at the gallery, and oversaw the work schedules at 2 gallery locations

● Maintained inventory of artwork at 3 locations for proper storage / packing ROBERT JACK Brooklyn NY 11215

****************@*****.***

m. 917-***-****

● Supervised the Art Preparators at 2 gallery locations

● Managed several projects concurrently, supervising others to ensure tasks completed

● Planned and executed installations in the gallery, including pre-planning with artists, preparation of facilities, budgeting, scheduling, and completion of installations

● Sales and client relations

Contact this candidate