Business Intelligence Consultant Resume

SUMMARY

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 wif large data sets to gain insights and deliver compelling stories from them.

TECHNICAL SKILLS

Tableau, SAP Business Objects, QlikView, OBIEE, Power BI, Design Studio, Lumira, Crystal DB Platforms Oracle, SQL Server, AWS Cloud, Snowflake, NoSQL, Redshift, Access Languages R, Shiny R, SQL, PL/SQL SAS, Python, Data Science Weka, Rapid Miner, SAS Ent Miner, IBM Watson, Alteryx Project Management Git, MS Visio, UML HP Quality Center, ServiceNow, Jira

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Consultant

Responsibilities:

Liaised wif multiple stakeholders to gather and freeze business requirements, prepare BRD, 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
Created numerous complex SQL queries involving self joins, correlated sub queries and analyzed different indexing strategies
Manipulate large data sets using R & SQL to automate validation and administered user creation, security, privileges & transport
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

Confidential

BI Module Lead

Responsibilities:

Engaged wif power users to identify end users, key reports & understand business logic of each report to enable improvisations
Developed stored procedures to load the data from ERP to stage, perform ETL operations & tuned query to load data warehouse
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 geography from onsite to enhance ETL data pipelines, mapping and load
Handled custom warehouse load (Oracle & MySQL) individually and tuned stored procedures to improve performance by 30%

BI Developer

Confidential

Responsibilities:

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