Summary of Qualifications

• SQL Server 2008 / 2008 R2 / 2010 / 2012 - 3 years working with the SQL Server suite of tools from SQL Server 2008 to SQL Server 2012.
• SQL Server Reporting Services SSRS - 2 years creating reports containing single and/or multi-valued parameters, functions, custom VBA coding, complex groupings, and multiple datasets and sources. Ability to deploy reports and report parts to report servers, create reporting dashboards by embedding reports in SharePoint site pages, automatically execute and distribute reports via email Outlook through custom SQL Server Agent Jobs.
• SQL Server Integration Services SSIS - 1 year importing various data files via SSIS into database staging tables and create ETL Processes.
• SharePoint 2010/2012 - 1 year managing internal SharePoint sites and manipulating site content and structure to accommodate growing business needs. Able to create and manipulate Web Part content and structure, embed reports, manage user groups and permissions, and edit JS and CSS via SharePoint Developer.
• MySQL - 3 years experience writing queries, creating tables, indexing, and managing views. Experience also includes designing data structures and populating tables with data imported from source APIs.
• Excel - 5 years working with Excel workbooks. Experience creating complex reports, creating and managing OLEDB connections, writing functions, automating tasks with macros, creating and managing data feeds to and from XLS files/SQL Server, and creating Pivot Tables and charts.
• SQL Agent - Able to create SQL Agent jobs that run scheduled ETL processes, reports, and validation/error message emails.
• Misc. SQL - 1 year experience working with a MySQL data warehouse.
• IT Compliance - Experience managing, outlining, and ensuring compliance with company IT regulations from both a hardware and software perspective.
• Regulation Compliance - Experience working with corporate finance teams to provide data for state and federal regulatory agencies for monthly data audits.

Business intelligence

Professional Experience

Data Engineer/IT Operations Berkley Asset Protection Underwriting Managers

• Administers and maintains reports and reporting systems SSRS, Company SharePoint site, data connections, and datasets .
• Acts as the primary point of communication between Berkley Asset Protection and W.R. Berkley's DBAs Berkley Technology Services .

Data Analyst Confidential

• Created T-SQL Queries, Views, and Stored Procedures that run complex parameterized SSRS Reports.
• Assisted with data migration moving Berkley Asset Protection's Data Warehouse from one SQL Server to another. Accounted for all dependencies ensuring a smooth transition to the new SQL Server without disrupting reports on the company's SharePoint site.
• Provided Time and Cost Reports highlighting the most, and least effective sources of income based on the success rate, overall profit, and time investment involved.

Data Analyst Confidential

• Created custom dashboard reports for Product Leads ensuring that they and their team are on track with their quarterly goals, and that they are able to identify areas of weakness in time to correct their actions if needed.
• Reported to Berkley's Executive Team including, but not limited to The President and CEO, Executive Vice President, Chief Information Officer Direct Supervisor, and various VPs.
• Ensured data accuracy by checking nightly processes results daily and responding to process errors in the appropriate manner.
• Worked with the W.R. Berkley Corporate Finance Team to create reports for them to reconcile data in the Ledger against data that is being reported from the Warehouse Post - ETL
• Collaborated with Berkley's DBA, Data Architect, and Product Teams daily to ensure an accurate, and efficient data Ecosystem.

Data Specialist Confidential

• Helped ensure consistent and ongoing customer satisfaction by querying raw data from Squarespace's data warehouse to prepare reports in Excel for management use, to showcase key metrics/trends of agent Key Performance Indicators KPIs .
• Identified data deficiencies in Squarespace's data warehouse by scrubbing data to find inconsistencies. This data cleansing also enabled the creation of variance source systems data compared to that in Squarespace's Data Warehouse reports to Business Intelligence and Data Engineering managers.
• Supported Squarespace executives by providing datasets or reports to with data queried from Squarespace's various data sources and/or data warehouse.
• Generated and distributed customized reports for Squarespace's executive team and Steering Committee. Reports illustrated agent performance, coaching opportunities, areas of strength/weakness, and platform issue/deploy impact on customer perception of the company.
• Created confidential employee and budget reports from sensitive data sent in a secure manner and ensured compliance with all internal policies for protecting such sensitive information.
• Supported Squarespace's Resource Management processes by analyzing and generating regular reports based on dynamic business data. These reports helped to identify staffing and schedule requirements for Squarespace's Support team. Reports were created to provide monthly, weekly, and hourly information on incoming vs. outgoing support case volume.

Platform Assistant Lead Tier II Support Specialist

• Commerce Platform Pre-Release and Release - Worked with Squarespace's Product Development, Project Management, Engineering, and Support teams to create knowledge base articles, author training aids for new-hires, beta test product features, and create pre-launch bug reports for bugs found within Squarespace's online commerce platform.
• Commerce Platform Escalation Support - Provided Tier II ticket escalation support for the Customer Care Team. Troubleshot platform issues, created bug reports if necessary, and provide regular status reports to customers with outstanding issues being investigated by Squarespace's Engineering Team.
• Squarespace Evangelist - Chosen to be part of a team that represented Squarespace and it's platform at the An Event Apart developer conference Washington DC .

Office Manager/Report Writer Confidential

• Reporting - Worked directly with Resolvit's COO to help determine ongoing effectiveness and cost needs of requirements postings by generating weekly reports that compare ROI from job sourcing sites.
• Freelance Web Developer Casual Confidential
• Developed custom websites for friends and family based on their individual needs with an emphasis on design and SEO.

Support Specialist Confidential

• Advanced Testing - Tested beta apps, features, and templates to help ensure issue-free deployments for Squarespace's SaaS Content Management platform.
• Knowledge Base - Worked with the Knowledge Base Team to create guides and tutorials for users, as well as macros and training materials for employees.
• Support Tickets - Worked on an award-winning support team responsible for responding to a high volume of user support tickets for the Squarespace CMS platform.
• Workshops - Participated in online real time and in-person training sessions outlining core principals of the Squarespace platform.

Office Manager/Report Writer Confidential

• Analysis - Responsible for finding the most cost efficient and effective way to reach qualified applicants by refining the company's marketing and outreach strategy through analysis of site and applicant analytics.
• Customer Relationship Management CRM - Created and launched a custom weekly CRM email campaign targeting candidates that fulfill specific skill/experience requirements.
• Recruiter Training and Data Learning - Assisted consultants and internal new-hires by creating training presentations and step-by-step manuals for essential job functions as well as outline Resolvit's internal processes and procedures.