Himadri Bhusan Jena

Himadri Bhusan Jena

Senior Consultant – Oracle Analytics Cloud/Fusion Analytics Warehouse
India

نبذة عني

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…

الخبرة

Senior Consultant

Deloitte USI
Jan 2021 - حتى الآن · 5 سنوات 5 أشهر

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
حتى الآن

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

Data Analyst

Tata Consultancy Services (TCS)

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

Senior ETL Consultant

Tata Consultancy Services (TCS)

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

BI Analyst/OBIA Consultant/Tableau Analyst/Tech Lead

Tata Consultancy Services (TCS)

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

OBIEE Developer

Tata Consultancy Services (TCS)

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

المهارات

أوراكل مستودع البيانات 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
الإبلاغ عن هذا الملف الشخصي؟