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 hands-on technical leadership role in the consumer industry with primary focus on digital content and mobile app analytics.
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
Interface design and implementation
Interface design and implementation
Proficient in HTML
Requirements analysis and design phases
Agile development methodologies
Advanced knowledge of embedded systems
Certifications: Teradata Certified Professional, Siebel Certified Analytics (OBIEE) Server Architect, Business Analyst Nanodegree from Udacity.
BI Architect11/2012 － 04/2017Slacker Radiopalo alto, ca
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, OBIEE 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.
Data for Slacker Radio Charts based on user's listening.
Served as the technical lead for questions on data, training other analysts on data and training business users to use the BI portal.
01/2010 － 11/2012OBIEE ARCHITECT AT EPOCRATES INCSAN MATEO, CA
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 consistent across the reporting solution.
Built Dashboards for Epocrates User Marketing, Doc Alerts Product, Market Research, Sales Teams and Medical Content Team.
Built multiple Subject Areas conforming on common dimensions to provide a 360� view of Epocrates user.
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 and training the business power users for ad-hoc analysis.
Promoted user self-sufficient BI and utilized BI resources for more analytical work.
Worked closely with Product Managers in deriving new metrics related to product engagement and user growth.
Implemented Alerts to proactively monitor key Performance Indicators.
System Administration on Linux, shell scripting, WebLogic administration
Various Data Analysis on user growth, Product engagement using Oracle SQL and OBIEE.
Sr. BI developer consultant10/2008 － 06/2010cyma systems inc
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.
01/2005 － 10/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.
Education and Training
Bachelors Engineering Degree:University of Calicut - Information TechnologyIndiaInformation Technology