TECHNICAL SUMMARY:

Big Data Technology: Data Lake, Hadoop, HDFS, HiveQL, Spark

BI Tools: Microsoft Power BI Desktop and Report Server (January 2019), Tableau 10.0, 9.0 and 9.3, Cognos Analytics v11.3; SSRS (2016), SSAS (2016), and T - SQL (2017); Qlikview v11.0 (Publisher, Designer/Developer, Server Admin, QMC); Cognos v10.2.2 (Framework Manager, Report Studio, Workspace, Workspace Advanced, Query Studio, Powerplay Transformer, Analysis Studio, Event Studio, Drill-Through Definitions, Cognos Administration, Cognos Connection); Motio v10.0, SAS Studio (Base SAS) 3.6, R Studio v1.0.136

Marketing Analytics Tools: Adobe Reports and Analytics (Omniture), UNICA Campaign

Database Management and Query Tools: Teradata v16.0, SQL Server 2000 thru 2017, Navicat Premium v11.2.16, ORACLE 8.0 thru 12.2, IBM DB2 v10.0, Sybase, Informix, 2013 MS Access; TOAD v9.0, SQL Developer 3.0.04, Oracle PL/SQL, IBM IMS Database

ETL Tools: Pentaho PDI v5.2.1, SSIS v2014, Cognos Data Manager

Other Software: Adobe Analytics, MS IIS, Foxfire, Safari, Microsoft Active Directory (LDAP), SiteMinder V6.0Documentum, BMC Remedy IT Service Management, IBM Lotus iNotes 8.5.3, Visual Source Safe 6.0

Operating Systems: Windows 2008, Windows 2010, Windows 10, MVS, OS2, AS400, UNIX Solaris 8.0, UNIX AIX, Linux, Apple Mac

Office Tools: 2016 Microsoft Office (Word, Excel, PowerPoint, Access)

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, FL

Visualization and Analytics Solution Architect

Responsibilities:

• Responsible for leading the architecture and development of executive level reports and dashboards using the following technologies Cognos Analytics v11.1, Tableau v2019, OBIEE, and Power BI.
• Also responsible for leading the design and development of an executive level, tool-agnostic BI web portal.

Confidential, Lake Mary, FL

Lead Microsoft BI Developer/Architect

Responsibilities:

• Served as the lead developer/architect responsible for the architecture and development of interactive dashboards, visualizations, and reports against SQL Server OLTP, OLAP, and data warehouse data sources using the following tools: Power BI, SSRS, SSAS, Report Builder, and T-SQL.
• Lead the development and support of hundreds of real-time operational and executive level Power BI dashboards, SSAS analytic models, and SSRS reports.

Confidential, Orlando, FL

Sr Marketing Data Analytics Consultant

Responsibilities:

• Served as the lead marketing data and analytics developer responsible for harvestings, analyzing, and visualizing Disney Parks and Resorts data to support the development and optimization of website traffic and marketing campaigns.
• Developed complex SQL Scripts in Teradata SQL Assistant and TOAD to extract data from numerous Teradata tables and views to support the marketing staff’s ability to create and optimize marketing tactics
• Performed validation of data in Teradata to support enterprise data quality initiatives
• Developed and published Tableau dashboards to Tableau Server for user consumption

Confidential, Orlando, FL

Data Management Analyst

Responsibilities:

• Served as a data management and reporting professional responsible for providing data and reports to the Medical Therapy Management Call Center.
• Successfully imported and stored all pharmacy data received from various medical providers using Pentaho Data Integration and Microsoft T-SQL
• Successfully created and modified all client reports using SSRS

Confidential, Atlanta, GA

Sr Sales Operations Reporting Manager

Responsibilities:

• Served as the technical leader on a team of six developers responsible for extracting, analyzing, and compiling sales operations and point-of-sales data.
• Responsible for developing insightful, visually compelling reports and analytics to be used for executive leadership consumption.
• Presented findings and communicated recommendations to business partners across the organization.
• Lead the development of custom SSRS, Excel Powerpivot, and Tableau 9.3 interactive reports dashboards used to provide insight into the performance of in-store sales promotions and standard KPI’s
• Provided technical leadership on the analysis and reconciliation of results between SQL derived reports and MDX derived Tabular Models
• Facilitated meetings between the Cricket Sales Operations Reporting Team and the Cricket IT Technical Leadership Team
• Provided thought-leadership on matters related to BI development best-practices, standards, and strategies

Confidential, Orlando, FL

Lead Analytics Developer and Architect

Responsibilities:

• Served as the technical lead responsible for the architecture and delivery of insightful analytic, reporting, and dashboard solutions for the Sales, Finance, and Marketing Divisions of Confidential .
• I was also responsible for managing software license/entitlements, maintaining the BI Roadmap, and staying abreast of emerging technology throughout the industry.
• Lead a team of six business intelligence developers responsible for management, development, and support of all business intelligence reporting and analytic solutions
• Lead the development of simple and complex Cognos reports, visualizations, and dashboards
• Developed and modified numerous T-SQL queries, views, and stored procedures
• Architected, developed, and supported numerous Report Studio reports as well as Powerplay Transformer models and reports
• Lead the installation and upgrade of the enterprise Cognos software environment
• Lead the migration from Cognos v10.3 to Cognos Analytics v11
• Managed and supported the batch Powerplay cube build process
• Successfully leveraged SQL and MDX functions to support complex report and dashboard design requirements
• Provided thought-leadership on the design and development of all BI solutions
• During the absence of Sr Manager, served as the lead and point of contact for all BI reporting and analytic matters

Confidential, Atlanta, GA

Marketing Analytics Architect/Developer

Responsibilities:

• Responsible for providing technical leadership on the architecture and development of all marketing reporting and analytic solutions used to support the enterprise marketing team’s ability to monitor and track the effectiveness of website traffic and marketing campaign performance across multiple channels.
• Successfully lead the architecture and development of a new marketing analytics platform to replace Adobe Analytics
• Successfully lead the analysis of

Confidential, Orlando, FL

Sr. Business Intelligence Consultant

Responsibilities:

• Serving as a Lead Business Intelligence Consultant responsible for delivering customized IBM Cognos report and dashboard solutions, provide development expertise, and deliver specialized training to external clients.
• Developed numerous complex simple list and crosstab Cognos Report Studio reports and Workspace dashboards against a 2008 SQL Server relational OLTP database source
• Delivered customized report and prompt page solutions using Render and Style Variables, Drill-Through Definitions, Master-Detail Relationships, and Report Studio Query Subject Joins
• Leveraged SQL Server database functions to ensure optimized query performance and report rendering
• Performed unit and functional testing of all deliverables
• Facilitated internal and external client meetings and participated in SCRUM Stand-Up sessions
• Analyzed and translated customer requirements into technical design specifications
• Collaborated with teammates throughout the Agile development life-cycle

Confidential, Orlando, FL

Sr. Business Intelligence Consultant

Responsibilities:

• Developed and modified numerous complex Cognos Report Studio reports using a combination of hard-coded SQL, report-joined Query Subjects, and published Framework Manager models
• Facilitated meetings with the customer during the requirements gathering phase
• Gathered and translated requirements into technical design specifications
• Collaborated with teammates throughout the development life-cycle
• Lead user-acceptance testing of all deliverables
• Maintained and supported the execution and troubleshooting of all on-demand and scheduled reports

Confidential, Suitland, MD

Associate - Cognos TM1 and BI Consultant

Responsibilities:

• Developed DMR and Relational FM Models to support the customer’s ad-hoc query, reporting, and analysis requirements
• Updated and maintained Cognos Connection user access permissions
• Participated and supported the monthly budget data loads and reporting cycle
• Collaborated with teammates on the development of Cognos TM1 budget models
• Supported the execution and troubleshooting of on-demand and scheduled Cognos reports

Confidential, Orlando, FL

Sr. Business Intelligence Consultant

Responsibilities:

• Developed numerous SSRS reports, SSAS cubes, and Excel PowerPivot spreadsheets to support the Sales, Finance, and Marketing Divisions’ access to actionable information
• Facilitated meetings with the customer during the requirements gathering phase
• Gathered and translated requirements into technical design specifications
• Collaborated with teammates throughout the development life-cycle
• Lead user-acceptance testing of all deliverables
• Successfully reverse-engineered complex SSRS reports to SSAS cubes

Confidential, Orlando, FL

Cognos and Qlikview Technical Lead/Administrator

Responsibilities:

• Successfully lead the enterprise implementation of Qlikview in the development, test, and production environments.
• Successfully performing in the role of administrator and developer of numerous complex models, reports, and dashboards using the full suite of Cognos 10.1.1 products (i.e. Framework Manager, Cognos Connection, Report Studio, Query Studio, Business Insight, Business Insight Advanced, Event Studio, Powerplay Transformer, Powerplay Studio) against DB2, Oracle, and SQL Server relational database sources in Windows XP and UNIX environments.
• Successfully lead in the troubleshooting of problems related to functionality, usability, and performance of Cognos solutions.
• Consistently received favorable performance reviews for providing excellent leadership and customer service.