ABOUT ME

A current senior data analyst who is using statistical and analytical techniques to uncover insights, trends, and patterns within the data. I'm also in responsible of making the clear and useful data visualizations that will effectively convey findings to stakeholders (including C-level and non-technical audiences).

Additionally, I previously worked for 5 years as a Business Intelligence Analyst/Manager. My main responsibilities were automating and generating insightful reports that supported leaders' business decisions, setting KPI forecasts, and analyzing data and business processes to enhance marketing strategies and increase company revenue. In addition, I have 2 years of expertise as a previous SQL Developer. My main duties were gathering business requirements and collaborating with application developers to design, optimize, and fix SQL Stored Procedures. Also, I started off my career as Application Support for 3 years which included monitoring database activities, eliminating database bugs, working on support tickets and maintenance tasks. WORK EXPERIENCE

Senior Data Analyst

February 2023 – Present

PLAY’N GO

Online Gaming Company

Migrates numerous reports with optimization from Tableau to Quicksight platform.

Prepares game release reports (performance of the games compared to other releases; market and brand performance)

Identifies unusual patterns and activity (analyzing drops or sudden increase of main metrics such as rounds, bet, revenue, etc)

Develops and presents analyses using a powerpoint presentation to explain the primary reason for a reduction or an unexpected gain.

Performs data extraction and collection (extracting datasets from Athena database)

Optimizing SQL table with hundred million rows by decreasing it into 80-90% of rows through SQL query

Prepares any ad-hoc reports.

Business Intelligence Analyst/Manager

January 2018 – February 2023

DUMAR PHIL INC.

Online Gaming Company

Creates MySQL/PostgreSQL/MSSQL scripts and deploys on a reporting server or directly presenting the data through MS Excel in a timely manner.

Designs, builds, and deploys dashboards through PowerBI/Tableau.

Directly cooperates with CCO/COO regarding the reports containing insightful and actionable business information especially regarding the target KPI of the company.

Collaborates with stakeholders and developers by collecting, integrating, and presenting the data specifically for the Pre and Post Analysis of Marketing Promotions.

Sets the Revenue Department’s Key Performance Indicators (KPI) metrics through forecasting especially the crucial value which is the company’s Revenue.

Optimizes existing SQL scripts to improve data loading.

Analyzes data to enhance marketing strategies or business processes to be able to boost the company’s revenue by double-digit rate.

Assists the Automation of Bonus Crediting to customers by creating SQL scripts and Business Process Flow Chart.

Reduces manual work and ad hoc reports by building reports and improving data visualization in PowerBI/Tableau.

Initiates/Contributes on new data analysis methodologies or variables on KPI.

Ensures that the automation and reports created by team members are aligned with the goal of the stakeholder’s department.

SQL DEVELOPER

July 2015 – November 2017

BAYVIEW TECHNOLOGY INC

Online Gaming Company

Gathered business requirements and convert it into SQL stored procedures

Designed and created tables and stored procedures and worked as a one-man database team specifically for 1 project

Assisted several deployments in different stages of environment

Worked with Application Developers for further understanding of the system and optimized the existing database stored procedures and tables

Implemented an automation of recurring inserting and updating of data without production issues

Created SSIS packages that automatically extract the flat files, transform, and load into database daily

Had driven in implementing of organized database deployment process with the Release Management team by eliminating extra steps and last-minute writing of scripts

Created number of SSRS reports based on business requirements in a timely manner

Performed numbers of verification of data before proceeding on production environment

Created Tableau reports from data warehouse and used by the upper management in analyzing of company’s daily, monthly, and yearly transactions

Ensured accuracy and integrity of data and applications through analysis, coding, and problem resolution.

CABANBAN,

DANELLE DG.

Senior Data Analyst

CONTACTS

North Hollywood, CA 91605

+1-562-***-****

ad08pv@r.postjobfree.com

EDUCATION/TRAINING

2007 – 2012

BS Industrial Engineering

First Asia Institute of Technology and Humanities

Tanauan City, Batangas

July 2012

Avanade (SQL & .NET) Bootcamp

Accenture Inc.

August 2012

Business Intelligence Bootcamp

Accenture Inc.

SKILLS

PowerBI/Tableau Advanced

Data Visualization Advanced

MS Office (Excel, Word, PPT) Advanced

Quicksight Proficient

MSSQL/MYSQL/PostgreSQL Proficient

Datawarehouse Proficient

Data/Business Analysis Proficient

SSRS Basic

SSIS Basic

Critical thinking & problem-solving

Communication skills

CERTIFICATION

April 2015

70-461 Querying Microsoft SQL Server 2012

Microsoft

WORK SUMMARY (10+ years)

PLAY’N GO

> Senior Data Analyst

February 2023-Present

DUMAR PHIL INC.

> Business Intelligence Manager

May 2021 – February 2023 (1yr & 9 mos)

> Business Intelligence Lead

June 2019 – April 2021 (1 yr & 10 mos)

> Business Intelligence Analyst

January 2018 - June 2019 (1yr & 6 mos)

BAYVIEW TECHNOLOGY INC.

SQL Developer

July 2015 – November 2017 (2yrs & 4mos)

ACCENTURE

> Software Engineer

June 2013 – July 2015 (2 yrs & 1 mo)

> Associate Software Engineer

June 2012 – June 2013 (1 yr)

Associate/Software Engineer

June 2013 – July 2015

ACCENTURE INC

Project: Large Retailing Client in South Africa

Handled support tasks in production by monitoring processes, resolving incidents logged, and enhancement of reports and application

Took on the service level reporting lead for the team by making analysis and daily reporting for the incident’s performance of the team

Shared knowledge and assisted new team members to be able to meet the target productivity of the new resources

Communicated and coordinated with the onshore counterpart/client to be able to achieve goals by understanding requirements

Automated/Optimized reports and application by using SSRS, SQL and other application.

Designed/reviewed functional design and technical design for the Continuous Improvement of the application.

Performed investigations on production issues and contributed inputs to SMEs

Provided End-User support during project pilot implementation

Contact this candidate