Data / SQL BI Analyst Lead Resume

TECHNICAL SKILLS

Teradata
MS PDW
Hive
SQL Server 2017, 2016, 2014, 2012, 2008R2, 2008, 2005,
Oracle 9i
MS Access
DB2
MySQL
SSMS
TOAD
SSIS/SSRS/SSAS
Tableau
PowerBI
Power Designer
MS Visio
C/ C++
Java
HTML
VB.Net
C#.Net
ASP.Net
JavaScript
Site Catalyst
Google Analytics
Discover/Ad Hoc
Report Builder
Campaign tracking code classification
Chat Reporting Cube
SEO Cube
Self - Serve (My Verizon) Cube
Clickstream
Automated Break Analysis

PROFESSIONAL EXPERIENCE

Confidential

Data / SQL BI Analyst Lead

Responsibilities:

Work with senior leadership to gather and analyze the needs for data, reports / dashboards and ad hoc analysis
Manage planning and development of Data Quality and stock plan dashboards / reports and analysis
Develop new Tableau dashboards / reports and delegate tasks to team members
Present dashboards / reports and actionable insights to team
Proposed and managed development of automated data breaks analysis process
Utilize Teradata, DB2, Tableau, Excel for data analysis and visualization
Manage offshore resources to create and oversee tableau dashboards, recurring and ad hoc reports, KPI validations and analysis

Confidential

ETL Architect

Responsibilities:

Actively participated in kick offs and assessment meetings with business leaders and analysts to understand the current integration, reporting and linkage challenges
Analyzed EDW, reporting and ETL platform to understand the current challenges
Recommended dimensional approach for EDW to enable better and efficient slice and dicing and reduce report market time
Recommended CDEs measurement process to improve the data quality and increase confidence

Confidential

Data Architect

Responsibilities:

Gathered requirements to understand the end goals of the various projects and make sure required data elements are captured
Collaborated with data architects for data model management and version control
Created data dictionary and data mapping documents
Developed logical data models and physical data models for Teradata, Greenplum and Hadoop using SAP PowerDesigner
Enabled the development of Clickstream (Adobe Site Catalyst), Goal Base Wealth Management, Stockplans data marts that helped understand online consumer behavior and investing behavior
Conducted data model reviews with project team members
Created data objects (DDL)
Enforced standards and best practices around the data modeling efforts
Collaborated with BI and marketing teams to create reporting data structures
Helped offshore resource with on boarding and on-going projects

Confidential - Piscataway, NJ

Business Intelligence Consultant

Responsibilities:

Created and managed My Verizon cube using SSAS and SSIS for reporting on KPIs across all digital platforms
Promoted self-service analytics by creating multiple OLAP cubes that enabled business end users to quickly and efficiently obtain desired data points and KPI metrics
Helped reduce Call-In-Rate by 30% by providing business teams with various analytics tools
Partnered closely with internal (Finance, IT, Project Management) and external (Microsoft, SHI) teams to acquire and implement hardware and software solutions that housed analytics tools for multiple stakeholders
Negotiated terms and conditions of licensing with Microsoft to reduce costs by 15% resulting in over $20k in savings
Managed SEO cube to measure traffic and organic visits to drive revenue on vzw.com
Worked with IT and Site Search team to develop process to provide popular content to improve search relevancy data model and increased the click through rate by over 13%
Created and Managed campaign tracking code classification for improved Site Catalyst reporting efficiency using SSIS that eliminated over 20 hours a week of manual efforts
Managed direct report to create and oversee self-serve (My Verizon/Support/Community/Mobile First App) tableau dashboards and additional daily work including ETL maintenance, KPI validations and Cube enhancements & maintenance
Trained and guide business users on cube technology and ad hoc analysis development
Helped new team members get acclimated to Digital Operations by providing training and knowledge transfer

Confidential - New York, NY

Data Integration Programmer

Responsibilities:

Created ETL Process to import the data from different Ad servers including Google DFA, Sizmek and C3 to PDW
Worked with Microsoft to resolve issues with PDW Server configuration
Developed a file acquisition process to import files from the Ad server

Confidential - New York, NY

Business Intelligence Developer

Responsibilities:

Created Dynamic SSIS package/projects to import data from different vendors to SQL Database
Migrated SSIS 2005 packages to SSIS 2012 projects
Created, modified and deployed SSAS Cubes and improved the reporting
Created various canned reports and dashboards in SQL Server Reporting Service (SSRS)

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship