Himadri Bhusan Jena

Himadri Bhusan Jena

Senior Consultant – Oracle Analytics Cloud/Fusion Analytics Warehouse
India

About Me

12+ years experienced BI and data warehousing professional adept at collecting, analyzing and interpreting large datasets, developing analytical solutions to provide valuable insights from raw data. Proficient in designi…

Experience

Senior Consultant

Deloitte USI
Jan 2021 - Present · 5 years 9 months

Working as a Senior Consultant in Deloitte USI. Working as a Senior Consultant in Deloitte USI. Working as a Senior Consultant in Deloitte USI. Working as a Senior Consultant in Deloitte USI. Working as a Senior Consultant in Deloitte USI. Working as a Senior Consultant in Deloitte USI

Senior Consultant – Oracle Analytics Cloud/Fusion Analytics Warehouse

Deloitte USI, Bengaluru, IN
Present

<p>Creating appropriate BI data model suitable for reporting out of data present in a format of entity relationship model<br>
Gathering and analyzing requirements and building various reports to create dashboards to report default management<br>
Leading the BI team to provide Analytics solutions for the client<br>
Provisioning FAW, configuring Data Pipelines and enabling different fusion Analytics(ERP,SCM etc.) offerings<br>
Working on Data Augmentation and Semantic Model Extensions to meet the custom requirements<br>
Implementing custom and OOTB security in FAW and validating the data in FAW with OTBI<br>
Interacting with business leaders to understand their pain points and current state architecture and reporting needs</p>

Data Analyst

Tata Consultancy Services (TCS)

<p>Analyzed various datasets to extract hidden and meaningful information from the data and build predictive models<br>
Adapted various Data Processing techniques for making data useful for creating Machine Learning models<br>
Developed models by using different algorithms such as Linear Regression, Decision Tree & Random Forest<br>
Created POC’s/POV’s for client to automate through Machine Learning and NLP using Python</p>

Senior ETL Consultant

Tata Consultancy Services (TCS)

<p>Created ETL source to target mapping document by understanding the business requirement<br>
Prepared HLD(High Level Design) and LLD(Low Level Design) by discussing with functional users and Business Analyst<br>
Developed complex mappings by creating Aggregate, Router, Sequence generator and dynamic lookup transformation<br>
Tuned performance of mappings and sessions by identifying the bottlenecks in existing process<br>
Built Update Strategy and Lookup transformation to implement the Change Data Capture CDC process<br>
Created connections, sessions, tasks and workflows utilizing Workflow Manager in Informatica Powercenter<br>
Implemented Push down optimization to improve the system performance<br>
Created UNIX shell script for file processing to third party vendor through SFTP, encryption and decryption process</p>

BI Analyst/OBIA Consultant/Tableau Analyst/Tech Lead

Tata Consultancy Services (TCS)

<p>Led a team of ~15 as a Technical Lead for upgrading OBIEE 11g to OBIEE 12c for a Banking client<br>
Trained ~4 fresher’s within the team in OBIEE to groom them for taking up the future challenging works<br>
Interacted with Business users for gathering requirements for GAP Analysis and prepared technical design documents<br>
Implemented Financial Analytics including installation, configuration and customization of OBIA for manufacturing client<br>
Designed efficient Tableau dashboards through efficient use of Tableau Desktop involving multiple datasets<br>
Designed documentation of the Tableau Dashboards by evaluating functional and technical business requirement<br>
Awarded as Star of the Quarter by TCS inSep’16 for leading the team for defect free delivery for a mission critical project<br>
Awarded as Star of the Month by TCS in Jan’17 for leading the team of 15 people for delivering the project successfully</p>

OBIEE Developer

Tata Consultancy Services (TCS)

<p>Developed reports, dashboards and dashboard prompts in OBIEE Answers<br>
Created/modified Metadata repository using the OBIEE 10g/11g's Physical, BMM and Presentation Layers<br>
Designed and modified OBIEE security using roles, privileges in EM, Administration Console to Access security</p>

Skills

Oracle Data Repository SQL Python PySpark Oracle Cloud Microsoft Azure NumPy Pandas Matplotlib Seaborn Tableau OBIEE Oracle Analytics Cloud Fusion Analytics Warehouse SQL Server Informatica PowerCenter Data Warehousing Business Intelligence Dimensional Modeling ETL Data Pipelines Semantic Model Extensions Security Predictive Modeling Machine Learning NLP Linear Regression Decision Tree Random Forest UNIX Shell Scripting SFTP Encryption Decryption Workflow Manager Push Down Optimization CDC OBIA Tableau Desktop OBIEE Answers Metadata Repository Roles Privileges
Report this Profile?