Business Intelligence Consultant

CHAITHANYA RAO

ac4fai@r.postjobfree.com 813-***-**** Tampa, FL - 33613 Linkedin Portfolio Information Management professional offering over 5.5 years of proven techno-functional experience in multidimensional reporting, analytics, ETL and data warehousing solutions. Proficient in data cleansing, exploratory analysis, statistical tools and predictive data modeling. Adept at working with large data sets to gain insights and deliver compelling stories from them. CORE COMPETENCY

Business Intelligence Analytics & Data Visualization Data-Warehousing

Data Science Project Management Requirement Gathering & Analysis TECHNICAL ACUMEN

Business Intelligence DB Platforms Languages Data Science Project Management Tableau, SAP Business Objects,

QlikView, OBIEE, Power BI,

Design Studio, Lumira, Crystal

Oracle, SQL Server,

AWS Cloud, Snowflake,

NoSQL, Redshift, Access

R, Shiny R,

SQL, PL/SQL

SAS, Python

Weka, Rapid Miner,

SAS Ent Miner, IBM

Watson, Alteryx

Git, MS Visio, UML

HP Quality Center,

ServiceNow, Jira

PROFESSIONAL EXPERIENCE

University of South Florida, Tampa Jan 2017 - Dec 2017 Graduate Assistant, Information Systems in Organizations

• Mentored more than 500 undergraduate business & finance majors to become proficient in MS Access, HTML and IBM Watson Deloitte Consulting LLP, Mumbai Feb 2015 - Dec 2016 o Business Intelligence Consultant

• Liaised with multiple stakeholders to gather and freeze business requirements, prepare proposals (RFP) and project plans

• Led effort estimation and solution design to migrate legacy applications into Tableau Server to facilitate self-service analytics

• Built comprehensive workbooks, views & KPIs having calculated fields, parameters, hierarchy & advanced charts using Tableau

• Manipulate large data sets using R & SQL to automate validation and administered user creation, security, privileges & transport

• Developed stored procedures to load the data from ERP to stage, perform ETL operations & tuned query to load data warehouse

• Conducted POCs to identify limitations, workarounds and finalized solutions to replicate OBIEE dashboards to SAP BO reports

• Conducted trainings to skill 100+ BI practitioners and led the firm initiative to publish a decision tree for Analytics CoE Tata Consultancy Services, Mumbai Mar 2011 - Feb 2015 o BI Module Lead

• Engaged with power users to identify end users, key reports & understand business logic of each report to enable improvisations

• Produced interactive reports in Tableau Desktop to provide automatic trend analysis and reduced around 2/3 processing time

• Developed scalable & robust data models, complex scorecard & dashboards to mirror legacy reports to drive BI adoption strategy

• Managed an agile offshore team of 4 developers across different geography from onsite to enhance data pipelines and mapping

• Handled custom warehouse load (Oracle & MySQL) individually and tuned stored procedures to improve performance by 30%

• Created numerous complex queries involving self joins, correlated sub queries and analyzed different indexing strategies o BI Developer

• Designed BO universes (IDT/UDT) to enable ad-hoc reporting, list/crosstab drill up/down, hyperlink, LOVs and Webi reports

• Implemented Data Warehouse models - star and snowflake schemas using ETL, T-SQL, Data Marts for OLAP & OLTP systems

• Used PL/SQL (extract, transform & load) event based job scheduling to load data-marts & reduced manual efforts by 20%

• Achieved Six Sigma Green Belt certification by automating a cluster of batch jobs that resulted in 60% optimization

• Created UPP, BCP, technical documents & test plans, supported code deployment and established change management processes ACADEMIC PROJECTS

Sentiment Analysis and Text Mining Dashboard Link Apr 2017

• Used APIs & R programming to extract tweets, apply NLP and preprocess; Analyzed attributes, performed feature extraction, attribute selection & classification techniques in Weka. Built & compared models to predict sentiment with 62% accuracy Airline Operational Metrics: Interactive Shiny Dashboard Project Link Feb 2017

• Developed key performance indicators to plot dynamic charts & geospatial plots enabling inferential analysis in shiny R Restaurant Ratings Aggregator Dashboard Link Sep 2017

• Scraped ratings using Alteryx web crawlers, coalesced & geocoded to compute drive time & distances using Google Maps API o Programming expertise in R (dplyr, ggplot2, plotly, tidyverse), Python (pandas, numpy, scikit, beautiful soup) and web scraping o Extensive knowledge of A/B testing, base SAS, regression, clustering, neural n/w, qualitative/quantitative analysis & graph plots o Exposure to data mining, NoSQL, clustering, decision trees, & developing models using tools such as Weka & Rapid Miner o Setup instances (EC2, Glacier), configured services (S3, IAM) on Amazon Web Service (AWS) & monitored resources on Cloud EDUCATION

MS in Business Analytics and Information Systems - University of South Florida, Tampa, FL (GPA: 3.9) Dec 2017 Bachelor of Engineering in Instrumentation - University of Mumbai, Mumbai Jul 2010 CERTIFICATIONS

Six Sigma Green Belt, R Programming, Statistical Inference, IPP (Life Sciences & Health Care), Advanced Google Analytics, FCPA, Fundamentals of Visualization with Tableau, Cloud Computing with Amazon Web Services

Contact this candidate