We provide IT Staff Augmentation Services!

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

TECHNICAL SKILLS

  • SAP Business Objects, Tableau, Lumira, QlikView, OBIEE, Toad, Design Studio, Crystal Reports
  • Oracle, SQL Server, MS Access, Redshift, AWS Cloud, Snowflake
  • R, Shiny R, SQL, PL/SQL SAS
  • Weka, Rapid Miner, SAS Ent Miner, IBM Watson, Alteryx
  • Git, MS Visio, UML HP Quality Center, ServiceNow, Jira

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Consultant

Responsibilities:

  • Liaised with multiple stakeholders to gather and freeze business requirements, prepare business proposals and project plans
  • Conducted POCs to identify limitations, workarounds and finalize solutions to convert OBIEE dashboards to BO reports & cubes
  • Converted 35 OBIEE & legacy reports (on Oracle) to BO 4.2 WebIntelligence reports (HANA) in agile methodology
  • Led the team in effort estimation and solution design to migrate legacy applications into Tableau, Design Studio and mobile BI
  • Administered user creation, security, privileges, transport and deski to webi conversion using LCM & CMC on windows server
  • Familiar with BIAL(JavaScript) to build Design Studio dashboards, customize analytics using extensions & enable mobile BI
  • Conducted trainings to skill 100+ BI practitioners on Lumira and led firm initiatives to publish a decision tree for SAP Analytics

Confidential

BI Module Lead

Responsibilities:

  • Engaged with power users to identify end users, key reports & dashboards, translate & understand business logic behind reports
  • Developed scalable & robust RPD model, complex scorecard & dashboards to mirror BOBJ reports to drive BI adoption strategy
  • Managed an offshore team of 4 OBIEE developers across different geographies from client site for Primavera BI implementation
  • Prepared UPP & BCP documents, supported code deployment and established change management processes for SIT and UAT
  • Modeled scalable BOBJ Universe Design Tool/ Information Design Tool universe (IDT & UDT) to enable Ad-Hoc reporting
  • Produced interactive reports & dashboard analytics to provide automatic trend analysis and reduced around 2/3 processing time
  • Handled custom warehouse load (Oracle & SQL Server) individually; Tuned stored procedures to improve performance by 30%
  • SAP BO Developer
  • Designed & developed BO universes (IDT/UDT) to enable ad-hoc reporting, list/crosstab drill up/down, web intelligence reports
  • Delivered a POC on Tableau to analyze repairs module; Created technical design documents and test plans for functional leads
  • Achieved Six Sigma Green Belt certification by automating a cluster of batch jobs that resulted in 60% optimization
  • Implemented Enterprise Data Warehouse modeling - star and snowflake schemas, ETL, ELT, Data Marts, OLAP and OLTP
  • Used PL/SQL (extract, transform & load) event based job scheduling to load data-marts & reduced manual efforts by 20%

Hire Now