**** ****** **, ****** *****, CA

650-***-****(M)

ac0p0t@r.postjobfree.com

JOSEPH GEORGE

CAREER SUMMARY

Sr. Business Intelligence Engineer / Data Analyst with extensive management and development experience in delivering enterprise-wide BI, Analytics and data warehousing solutions for the past 12 years.

Last 7 years in technical leadership role in the consumer industry with primary focus on digital content and mobile app analytics.

SKILLS & ABILITIES

Programming Languages: SQL, Analytics SQL, PL/SQL,

R, Python, Shell scripting

Databases: Oracle, Teradata, Postgres, MS SQL Server, MySQL, MS Access, Hive.

BI Tools: Oracle BI, Tableau, Google Analytics, Omniture, Excel, Grafana, Google Charts in javascript

ETL Tools: Oracle PL/SQL, Informatica, Alteryx

Data Modeling: erwin Data Modeler, SQL Developer Data Modeler, Dimensional Modeling for Data Warehouse

CRM Tools: Siebel, Salesforce

SQL Tools: TOAD, SQL Developer, Teradata SQL Assist

Analysis: Cohort Analyses, AB Test Analyses, Churn Analysis, Conversion funnels, User Retention and Engagement, User flow analysis, Marketing Campaign segmentation, Campaign effectiveness, Royalty reports, Sales and Revenue reports, Subscription Forecasting, User growth forecasting, Regression Analysis, Data Stories for Public Relations

Training: Product demo and training business users

Certifications: Teradata Certified Professional, Siebel Certified Analytics Server Architect

Education: Bachelors Engineering Degree in Information Technology, University of Calicut, India

EXPERIENCE SUMMARY

BI ARCHITECT AT SLACKER RADIO, PALO ALTO, CA

NOV-2012 TO APRIL 2017

Worked closely with the Marketing and did analysis on user acquisitions, cohort analysis, churn analysis, user retention, marketing campaigns, social media campaigns, push notifications segmentation, promotions and email marketing using advanced SQL, R and Excel.

Worked with Product & Engineering to better understand user-flow, user drop-off points during purchase flow, AB Testing new UI and product features.

COA (Cost of Acquisition) Reports, CPM Reports, Subscriber Life Time Value Reports to measure the ROI of Marketing’s acquisition efforts.

Participated in AB Testing design followed by its AB Test Analysis to pick the winner. AB Tests were mainly done with the goal to improve subscription purchases, trial-conversion rates and product features.

Improved the Trial-Conversion and Subscription Purchase rates by experimenting on different purchase-flows, push message campaigns, duration of Trial, Tier of Trial (Plus or Premium).

Defined metrics to measure the engagement of radio listeners, returning frequency and usage of features like Skip, Heart, Ban, Download etc.

Forecasting subscription growth using R.

Detecting spikes and dips in Data using R to alert various departments through emails.

Used Regression Analysis (BFast model in R) to detect trend breaks and to predict the immediate user and subscription growth.

Designed and Developed enterprise-wide BI solution with multiple subject areas pulling data from Data Warehouse, Transactional Databases and flat files using Oracle SQL, Oracle Job Scheduler and Materialized Views.

Created Data Models and associated ETL using Oracle SQL. Used Python for extracting data from third-party providers on web.

Created corporate and departmental dashboards using OBIEE and Tableau.

Administration of the BI System which includes code release, upgrades, security and performance fixes.

Built Dimensional Data Models (STAR and SNOW-FLAKE) in erwin Data Modeler to measure digital media streaming performance issues like buffering, playback and crashes.

Royalty and Revenue reports for Finance.

Supplied Data for Radio stations based on User’s music listening (Slacker Top 40, Throwback 30, Best of 2016, Rising Songs Now to name a few)

Data stories from user data for Public Relations (Ex. Which state rocks the most)

Served as the technical lead for questions on data, training other analysts on data and training business users to use the BI portal

OBIEE ARCHITECT AT EPOCRATES INC, SAN MATEO, CA

JUNE-2010 TO NOV-2012

Built the enterprise wide BI system from scratch including both technical tasks (setting up machines) and functional task (OLAP Query model)

Created a unified business model to ensure that all metrics, calculations and definitions are uniformly consistent to provide better alignment and visibility across the organization

Built multiple Subject Areas conforming on common dimensions to provide a 360 view

Created and maintained data dictionary containing definitions of all the metrics and data

Drastically reduced the number of BI Tickets by building dashboards for business units; training the business power users for ad-hoc analysis; improving the business operations efficiency

Promoted user self-sufficient BI and utilized BI resources for more analytical work

Worked closely with Product Managers in deriving new metrics, showing past trends, predicting future results

Implemented Alerts to proactively monitor key Performance Indicators, fix issues

Implemented Alerts to proactively monitor key Performance Indicators, fix issues

System Administration on Linux, shell scripting, WebLogic administration

Various Data Analysis on user growth, Product metrics using SQL and OBIEE

SR. BI DEVELOPER CONSULTANT AT CYMA SYSTEMS INC

Oct-2008 to Jun-2010

Worked for Cyma System’s BI Projects for their clients.

At Southwest Airlines Dallas, implemented OBIEE Loyalty Analytics pulling Data from the Siebel Loyalty Data Mart for the airline’s frequent flyer program. Data Analysis using Oracle and OBIEE Answers.

At Verizon Business Atlanta, worked on building new data models in erwin Data Modeler, ETL using Informatica, new Subject areas in Siebel Analytics which looked at the enterprise telephony equipment sales. Data Analysis using Siebel Analytics and MS SQL Server.

ASSISTANT SYSTEM ENGINEER AT TATA CONSULTANCY SERVICES

Jan-2005 to Oct-2008

Worked for TCS’s clients implementing BI Apps using OBIEE/Siebel Analytics on relational databases.

At Cingular Wireless Atlanta, worked on Siebel’s prepackaged Sales Analytics and custom Analytics products using OBIEE and Teradata

At Toyota Los Angeles, implemented Siebel Analytics’ call center and customer-service analytics package using Siebel Analytics and Oracle.

Contact this candidate