Data Analyst Business Intelligence

SR DATA ANALYST

Analytical, motivated, and results-driven Data Analyst with a successful record in varied portfolios and multiple initiatives across organizations. Twenty plus years of information technology experience dedicated to Data Analytics and related roles. Proven track record focusing on business data from various sources and providing data-driven insights and information to relevant departments.

Areas of expertise:

Business Intelligence

Data Analysis

Data Warehousing

Project Management

Project Financials

Data Modeling

Source to Target Mapping

Relational & Multi-dimensional Schemas

SQL

Development – Programming & Report

System Integration

Business Requirements Gathering

Leadership and Cross-Functional Collaboration

Solution Strategy and Business Plan Development

RELEVANT EXPERIENCE

Cumis

Sr Data Analyst Nov 2019–Present

Data Analyst and Business Intelligence Reporting working with the DW and operational files, creating Dashboards and Reports (Power BI, SSRS, Visual Studio and SSMS). Determining Transformations, Business Rules, etc. Writing the Source to Target mappings and SQL to hand over to ETL. Conduct testing, gather business requirements and incorporate these into new deliverables or modifications to existing dashboards and reports.

Data Analyst and Modeler on a conversion project to replace a legacy UW system with a new Workflow-based system. Responsibilities include design go-forward ODS, data discovery (data profiling and analysis of legacy system data), ETL specifications from the legacy system to a conversion landing zone, report requirements gathering. Conducting reconciliation, testing and UAT. Provide road maps/project plan (data stream) to Sr management. Reporting requirements include operational, regulatory, standard and audit.

Key Accomplishment(s):

Create Dashboards and Reports

Data Warehouse and Operational Data Stores

ETL, Source to Target Mapping, including XML files

Data Modeling (Relational & Multidimensional)

Detail Analysis of Source system data analysis for purposes of data conversion and migration to the new target platform

Data Profiling

Landing Zone table design, DDL creation and generation and population of tables

Requirements gathering

Technologies: SQL Server, Oracle, SQL, Power BI, DAX, SSRS, SSMS, MS Project Manager, Erwin, DbSchemaPro, Jira, Service Now, Visio, PowerPoint, Toad

ADT

Data Analyst Mar 2017–Nov 2019

Data Analyst (including hands on technical) for the development and implementation of a Corporate Scorecard, including the integration of a merger company’s dashboard and reporting environment. Moved to a new integration project as Technical Data Analyst where the goal is to identify and ensure all reporting requirements, including the data, are covered for all project tracks within the Portfolio. Audit data in areas of compliance, accuracy and duplication for applications, reports and dashboards. In addition to the Analyst role, also acted as a Project Coordinator and in charge of the Project Financials for an 18M+ project (Forecast, Budget, eCER’s, SOW’s), Participate in architecture and strategy sessions to support business endeavors and initiatives.

Key Accomplishment(s):

Researching and understanding data elements, future and past systems

Formal documentation

Created a corporate glossary/data dictionary to be used at the C-level management

Created a BRD and Technical document for a 3 system, Tech Productivity

Technologies: Oracle, SQL Server, SQL, Quality Center, PlanIt, Jira, Visio, PowerPoint, Microsoft Project, Toad

Solutions Specialists – Clients: Bluegreen Vacations, Sheridan Health Corp, JM Family, Office Depot, Prologis

Data Analyst Jan 2015–Mar 2017

All System and/or Product Integration projects from Internal and External sources, including partner companies and 3rd party vendor application systems. Identify, analyze and interpret trends and patterns in complex data sets, in order to draw insights that will aid the business. Collaborate with the business teams, customers, data providers, IT, and project teams (PMO) to elicit, document, and manage business data requirements for Data Integration (DI) and Data Warehouse (DW) projects. Coordinate and investigate nature of requests and/or enhancements and direct and manage to appropriate areas for completion. Lead QA/UAT Initiative.

Key Accomplishment(s):

Collaborate with both IT and business to ensure all areas are represented

Gap analysis and review with business to determine measurements for certain data anomalies

Drive QA and UAT initiatives to obtain timely signoff

Technologies: Oracle, SQL Server Management Studio, Teradata SQL Analyzer, SQL, DBVisualizer, Quality Center, Cognos Suite, LucidCharts, ALM, Visio, SalesForce, Clarizen (Project Management and Time Tracking), Footprints

Viacom

Data Analyst / BI Developer Jan 2013–Mar 2015

Worked in Viacom’s systems creating new reporting by pulling in various data sources. Determine data accuracy and completeness by running SQL against the different sources of data, including pre and post ETL and business rules. Business Intelligence and Data Warehousing initiatives to support Viacom’s reporting and information requirements. Interface with department teams and/or vendors to support existing and new applications, products and tools. Conduct formal presentations of new and proposed deliverables, solutions and technologies.

Key Accomplishment(s):

Integrate disparate systems US and United Kingdom

Collaborate with both IT and business to ensure all areas are represented

Sift through data, identify patterns and present decision makers with useful, actionable insights

Technologies: SQL (Stored Procedures, SQL syntax), Oracle, SQL Server, Data Analysis, Visio, Requirements, Documentation, Data Analysis, Cognos Suite: Framework/Metadata Layers, Cognos Administration and Configuration, Report Studio (reports and dashboards), Analysis Studio (multidimensional cubes), Transformer, Business Objects, Business Objects, PowerPoint, Microsoft Project

TECHNICAL ACUMEN

Operating Systems

Windows, Unix

Database

Oracle, SQL Server, Teradata

Software

SQL (Oracle, SQLServer, Teradata), Power BI, SSRS, SSMS, Jira, Erwin, Informatica, Cognos Suite, Business Objects, Microsoft Office Suite, Microsoft Project, Smartsheet, Microsoft Visio, Microsoft Project, Cognos Reporting, Business Objects, SharePoint, CRM (Salesforce), PlanIt, Oracle Discoverer

OTHER EXPERIENCE

Sr. Data Analyst-cumis/cooperators insurance, Univita Health

Analyst & Team Lead-Florida DOT

Data Analyst Consultant-JM Family (3 return engagements)

Sr. Principal Consultant-Adjoined Technologies (2 return engagements)

DW Analyst-Argonaut Insurance

BI Analyst-ANC Alamo, National, CarTemps (2 return engagements)

ETL Consultant-Cap Gemini Ernst & Young (hired for Cognos)

Instructor-Toronto School of Business, CompuCollege

Sr. Systems Analyst-Crown Life Insurance

EDUCATION AND CREDENTIALS

University of Toronto: Bachelor of Arts program

Herzing Institute: Computer Programming and Business Systems Analysis

Technical Courses: Power bi, visual studio, ssrs, dax, SQL, PL/SQL RDBMS, Cognos Suite, Business Objects, LAN Admin (Novell, Magic)

Non-Technical Courses: soc 2 essentials, Systems Analysis, Data Warehousing, Project Management

PROFESSIONAL AFFILIATIONS

Oracle Users Group-South Florida Chapter

Cognos Users Group-South Florida Chapter

United States Power Squadron-Pompano Beach, Member & Volunteer

Habitat for Humanity-Broward County

Contact this candidate