Talent's Information
-
Location
Delhi, India
-
Rate
$10.0 per Hour
-
Experience
7 Year
-
Languages Known
English,Hindi
Available for
About RAHUL
Having 7.5 years of experience in Data warehousing and Business Intelligence technologies
worked inallphases of DWH/BI full life cycles including analysis, design, development, unit testing, deployment, post-production maintenance, documentation and end-user training.
Worked as a Associate Staff Engineer
Worked as a Senior Analyst Programmer
Worked as a BI Developer as well
Worked as a Programmer Analyst
Expertise in Tableau (9.1.1/10.5/2019.1.3), OBIEE 11g/12c & BI Publisher.
Having extensive experience in Analysis, Design, Development/Configuration in OBIEE 11g/12c and
Oracle BI Publisher, Proficient in Designing and developing the OBIEE Metadata Repository (RPD) using Oracle Business Intelligence Admin tool and creating Reports/dashboards Online .
Expertise in creation of complex SQL queries, Performance Tuning and Query Optimization.
mining, Data manipulation and Data preparation, gathered necessary data for analysis from different
sources, prepared data for data exploration) using Python (NumPy & Pandas).
Worked on projects in waterfall and agile methodology.
Always Eager to learn new technologies and can handle multiple tasks at a same time.
Good understanding of the Dimensional Data modeling like Star-Schema modeling, Snowflakes
modeling, fact and dimension tables modeling of data.
Expertise in handling all phases of Software Development Life Cycle SDLC of the BI Projects.
Always Eager to learn new technologies and can handle multiple tasks at a same time..
Tech Stack Expertise
-
Python
Python
4 Years -
Oracle
Oracle,Oracle
2 Years
Work Experience
Data Analyst
- January 2016 - February 2023 - 7 Year
- India
Projects
Put Phub Application
- January 2021 - January 2023 - 25 Months
-
Project involved development of advance reporting solution using Tableau and
SQL. Worked on the latest features of tableau and developed some advance
dashboards/prototypes and automated tableau admin workflows using Python.
Got an opportunity to explore Power BI as well ,worked on few POCs and dashboarding solutions using it.
Roles & Responsibilities:
Developed requirement documents and designed reports by worked closely
with business users.
Build Advance Tableau BI Applications utilizing complex Calculated fields,
Table calculations, Advance LOD's, parameters & Sets and expertise in
Data Blending, Joins, Filters and Actions.
Implemented NLG and NLP.
Created tableau magic charts using data densification technique.
Worked on Migration of tableau workbooks from Azure Data Bricks to AWS
Redshift.
Provided Support to team members in issues, model design and reporting.
Automated Tableau server activities using (TSC) python library.
Had written multiple SQL queries for the creation of data-source queries
subject to achieve client specific needs.
Fund Reporting & Analytics
- January 2020 - December 2020 - 12 Months
Project involved development of complex and generic BI reporting solution
using Tableau and OBIEE for the internal Fund Reporting team. Highly
interactive dashboards/data visualizations reports showing fund related
information have been created and It also enabled automated file transfer using
the BIP Bursting mechanism.
Roles & Responsibilities:
Interacted with business users in gathering, analysing and documenting the
business requirements and translate them into technical specifications.
Build Tableau reports utilizing complex Calculated fields, Table calculations,
Advance LOD's, parameters & Sets and expertise in Data Blending, Joins,
Filters (quick filters, context filters, cascading filters) and Actions.
Created several Tableau data extracts with prebuilt calculations, parameters
and sets to enable end users to easily utilize the extracts as semantic layer
to create their own workbooks.
Development of metadata repository using OBIEE Administration tool,
Intelligent Dashboards, Answers And extensive experience in developing
Data Models and rtf/excel templates to create pixel perfect reports using BI
publisher, proficient in BIP bursting mechanism.
Working Capital Solutions
- January 2019 - December 2019 - 12 Months
-
Project involved creating Tableau Reporting solution for Working Capital
Solutions team. Performance tuning of tableau workbooks and extracts to make them
POC-Created automated data management and ETL pipelines for a wide
variety of data sources (Data mining, Data manipulation and Data
preparation, gathered necessary data for analysis from different sources,
prepared data for data exploration) using Python (NumPy & Pandas).
Roles & Responsibilities:
Designed and developed the Working Capital tableau applications by
blending various data sources.
Created Multiple Data sources (Live and Extract both) and various custom
SQL's, implemented Data Blending, connecting to various data sources -
Oracle11g, SQL server, Excel etc
Developed multiple reports/dashboards using Dual Axes charts,
Histograms, filled map, Bubble chart, Bar chart, Line chart, Tree map, Box
and Whisker Plot, Stacked Bar etc.
Restricted data for particular users using Row level security.
Conducted training sessions for Tableau Power users to use it as
Confidential Self-service BI tool.
Cummins Reporting Solution
- June 2017 - December 2018 - 19 Months
-
Project involved creating Tableau Reports/Dashboards, OBIEE Repository and
Dashboards, OBIEE Upgrade, Noetix OBIEE RPD generation and ETL
pipelines using Informatica.
Roles & Responsibilities:
Converted existing OBIEE reports to Tableau dashboards.
Involved in end-to-end implementation and enhancements of multiple
tableau projects, created rich Reports/Dashboards using Tableau desktop,
Good understanding of Tableau server architecture and experienced in troubleshooting and performance tuning of reports.
Having experience of upgrading OBIEE 11g to OBIEE 12c.
Design and development of three layers Physical, Business model and
Presentation of an OBI Metadata Repository using Oracle BI Administration
tool.
Repository development using the Noetix RPD Generator for generation the
OBI reports.
Implemented Object level and Data level securities in BI Dashboards.
Fixing the issue in UAT and helping the support teams during new releases.
Exposure to Informatica PowerCenter, worked on design of ETL layer.
Created Unit Test Cases and performed unit testing and Participated in
designing, coordination and execution of User Acceptance Testing (UAT)
with QA, BA and selected business users.
Aflac Solutions
- January 2017 - May 2017 - 5 Months
-
Developed Reporting Solution using Tableau. dashboard maintenance and enhancement.
worked on ETL pipelines.Expertise in providing end-to-end business intelligence solutions using Tableau Desktop/Server.
Interacted with business users in gathering, analyzing and documenting the business requirements
and translate them into technical specifications.
Roles & Responsibilities:
requirement gathering by interacting with business users
Designed and developed the application from scratch.
Implemented Object level and Data level securities in BI Dashboards.
Soft Skills
Industry Expertise
Education
in B. Tech
Delhi Univeristy- June 2009 - June 2014
