Rajesh B.

Rajesh B.

Data architect with data warehouse and big data analytics

Bengaluru , India

Experience: 12 Years

Rajesh

Bengaluru , India

Data architect with data warehouse and big data analytics

54005.9 USD / Year

  • Notice Period: 90 Days

12 Years

Now you can Instantly Chat with Rajesh!

About Me

▪ Around 13 years of working experience as Data Modeler/Architect, including 8.6 years in DWH and Data Modelling and 4.2 years in DataLake implementation.

▪ Involved in gathering & analysing the requirements and understood the architec...

▪ Involved in gathering & analysing the requirements and understood the architectural design of the project in a step by step process along with the data flow.

▪ Experience spanning across the horizontal practice of Design & Development, ETL, Enterprise Data Warehousing, DataLake Implementation, Data Analytics, Business Intelligence and Requirement Analysis.

▪ Experienced in developing Conceptual, logical models and physical database design for OLTP and OLAP systems using ER Studio and SQL Power Architect.

▪ Experience in integration of various relational and non-relational sources such as Teradata, Greenplum, Oracle, SQL Server, SAP HANA to Hadoop.

▪ Hands on experience with Hadoop distributions like Cloudera, Hortonworks, Hadoop architecture and technology stack like Hive, Impala, KUDU, Sqoop, HDFS, Oozie.

▪ Extensive experience in data modelling, data and solution architecture, data warehousing & business intelligence.

▪ Extensive working experience in architecture design of ETL/ELT methodology using Informatica Power Center, SSIS and SAP BODS.

▪ Experience in integrating SAAS based applications to Big data Hadoop (HDFS) using StreamSets.

▪ Experience in handling huge volume of data in/out from Teradata, Greenplum and Big Data Systems.

▪ Experience in using PL/SQL to write Stored Procedures, Functions.

▪ Extensively used ER Studio Data Architect and SQL Power Architect as the tool for modelling.

▪ Designed and developed Data Marts / DWH with different schemas like Star Schema, Snow-Flake Schema based on project requirement.

▪ Designed various practical Data Visualizations, Charts, Dashboards, Prototypes for Analytical Projects using QLIKVIEW and Power BI.

▪ Having domain experience across Retail, Pharmacy, Banking, Agriculture Supply Chain, Animal Nutrition and Telecom verticals.

Show More

Skills

Operating System

Portfolio Projects

Finance Data Lake

Company

Finance Data Lake

Description

We are building centralized datalake by integrating multiple source systems like SAP, SAP HANA, JDE, SQL Server, Oracle and SAAS based applications into data lake.

Building centralized data warehouse for enterprise or organization level.

Building different certified data sets or integration views for different business units based on the requirement.

Involved in entire life cycle of the project from gathering the requirements to production support.

Designed the architecture of the project including data integration, data modelling and data visualization.

 

Show More Show Less

Global IT Data Lake

Company

Global IT Data Lake

Description

We are building centralized datalake by integrating multiple source systems like SQL Server, Oracle, flatfiles and SAAS based applications into data lake.

Building centralized data warehouse for enterprise or organization level.

Involved in entire life cycle of the project from gathering the requirements to production support.

Recovered and saved the cost of more than 100Mn in enterprise.

Show More Show Less

Value Center Of Expertise (Value COE)

Company

Value Center Of Expertise (Value COE)

Description

▪ Gathering & understanding business requirements and converting them into functional specifications and technical requirements.

▪ Involved in preparation of ETL mapping specification document.

▪ Involved in migrating tasks from SAP HANA to Hadoop (Cloudera).

▪ Involved in productivity through automation (Rundeck) and process improvement.

▪ Involved in Extracting, Transforming and Loading data from different source systems.

▪ Involved in providing SAP Audit results to corporate audit team.

▪ Involved and provided results for various Data desk activities.

Show More Show Less

Customer Segmentation Datamart

Company

Customer Segmentation Datamart

Description

▪ Gathering & understanding business requirements and converting them into functional specifications and technical requirements.

▪ Involved in preparation of ETL mapping specification document.

▪ Creating data model in Greenplum & QlikView.

▪ Working experience with mapplets and mappings using different transformations like Expression, Lookup, Filter, Router, Union, Aggregator, Joiner, Update Strategy, Sequence generator

▪ Created Dashboard using different components of QlikView like List boxes, Multi boxes, slider, and buttons, Input Box and charts (Bar, Line, Combo, Scatter, Pie and Straight/Pivot table) etc.

▪ Experience in working with QlikView Functions.

▪ Involved in Extracting, Transforming and Loading data from different data source.

▪ Different ETL script statements like Resident, Concatenate, Join, Keep, Mapping Load, etc.

Show More Show Less

NSCC Positions & Risk Analysis

Company

NSCC Positions & Risk Analysis

Description

▪ I was leading the Data Analytics and Reporting Team of Five members.

▪ Gathering & understanding business requirements and converting them into functional specifications and technical requirements.

▪ Expertise in Informatica & Data warehousing, Database design, Performance Tuning.

▪ Involved in preparation of ETL mapping specification document.

▪ Integration of Apache Sqoop, HDFS with Hive and Greenplum.

▪ Identification and designing systems & reports for Decision Analytics derived out of structured and unstructured data.

▪ Involved in leveraging Open-source technologies to reduce the cost of operation and improving efficiency.

Show More Show Less