Having * years of experience in ETL development in Hitachi Pentaho and IBM DataStage.

I have expertise in Pentaho designing, developing, testing, deploying, maintaining data

Integrations, performance tuning, enterprise Reporting. I was awarded by Hitachi Ltd. For excellent service delivery.

Name

Rojalin Pradhan

Year of birth

Work Authorization

1993

L2 EAD Valid till: 2022

Residence

Centennial Denver 80112

Nationality

Indian

Overall, 3 years of experience in ETL Development, Testing and reporting in Pentaho, ETL development in IBM DataStage.

Experienced in creation and execution of test cases, test scenarios.

QlikView, Tableau Data analysis, Data visualization and reporting.

Migrating Oracle PL/SQL Scripts to SQL Server PL/SQL Code.

Working knowledge in SQL, PL/SQL, Batch scripting, Core Java and J2EE.

Worked on various platforms like Ubuntu and Windows.

Experience in Bug Life Cycle, Bug Reporting, Bug Tracking Process and Analyzing results.

Thorough understanding of different phases of SDLC and STLC

Worked in agile form of development and testing.

Quick learner, able to adapt to changing environments while multi-tasking and working under pressure.

Functional: Ability to work in an Agile environment as a powerful part of team picking up team transcending development and test activities, like development coordination, development and test management.

Technical:

oETL development using IBM DataStage and Pentaho

oQlikView and Tableau Data analysis, Data visualization and reporting

oBatch Scripting

oSQL and PL/SQL

oJava, JavaScript

oSVN, GIT(Version Control)

oSQL Server 2014 and 2017

oSQL server Management Studio

oOracle SQL Developer

oEclipse IDE

Speak

Read

Write

Hindi

Native language

Native language

Native language

English

Fluent

Fluent

Fluent

01-04-2018

Client

Hitachi

To present

Project Name

Eco-E

Role

ETL/SQL developer

Environment

Oracle SQL Developer, Database: Oracle 10g, SQL Server Management studio Express Edition, SQL Server import and export wizard

Description

Activities

Understanding business requirement.

Understanding and executing Oracle PL/SQL scripts and migrating the same logic to implement Microsoft SQL Server PL/SQL script.

Development of PL/SQL scripts in SQL Server, peer reviewing, preparing Test Data, Executing Test Cases.

Helped with definition, structuring and documentation of data sources as per requirements.

Assisted in designing and development of complex ETL structures for transformation of data sources into data warehouses.

Designed codes for data access along with stored procedures and current SQL queries.

Conducted reviews of database designs and system integration issues for further improvements.

Resolved troubleshooting problems relating to ETL applications and data issues.

Implemented procedures for validation, reconciliation of metadata and error handling in ETL processes.

Analyzed database designs and system integration processes to make suggestions for further enhancement.

Maintained project documentation relating to testing, coding and logic of ETL processes.

01-07-2016

Client

Hitachi

To 31-03-2018

Project Name

HES-BAS

Role

Analyst

Environment

IBM DataStage, Pentaho, QlikView, Tableau

Description

Confidential

Activities

Understanding and Analyzing Requirements.

Creating HLD and LLD, business logic implementation and development, Code Review, Unit testing, Integration testing and deployment.

Creating Design Memos, design documents, creating ETL jobs.

Data Analysis and Report creation as per functional requirement.

Done Test Plan Documentation

Derived Test Scenarios, Documented Test Cases and Collected Test Data for Functional Testing.

Good understanding with functional specifications.

Actively involved in MOM.

Designed data extraction processes to meet business application requirements and data sources.

Provided technical expertise and guidance for data management, quality and reporting functions.

Suggested improvements in processes for managing data integrity and quality for overall enterprise.

Created data models and processes for conceptual, logical and physical data elements after thorough analysis.

Conducted code and design reviews for suggesting and approval of design specifications.

Implemented processes for extraction and loading of ETL data into data warehouses and marts.

Executed procedures for definition and designing of data integration mapping algorithms.

01-02-2017

Client

Hitachi

To 31-12-2017

Project Name

HES-BAS

Role

Analyst

Environment

IBM DataStage, Pentaho, QlikView, Tableau

Description

Confidential

Activities

Understand the Requirements and Functionality of the application from specifications.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.

Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

Converted existing business operational reports and visualization to tableau dashboard

Created different KPI using calculated key figures and parameters

Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's

01-06-2015

Client

Capgemini

To 01-02-2016

Project Name

Inhouse project

Role

ETL developer

Environment

Batch Scripting, Java, Pentaho

Description

Confidential

Activities

Logical and Physical database modeling of the warehouse, responsible for database schemas creation based on the logical models.

Involved in performance tuning of targets, sources, mappings, and sessions.

Wrote complex java scripts to avoid Pentaho Look-ups to improve the performance as the volume of the data was heavy.

HTML5, CSS, JavaScript, Core Java

SQL, PL/SQL with Oracle 10g

J2EE, Spring

Configure Management, Defect Prevention- Capgemini India

Class/Degree

School/College

Board

Percentage/CGPA

Passing Year

10th

St. Xavier’s High School

CBSE

88%

2009

12th Intermediate

Stewart Sc. College

CHSE

72%

2011

B.TECH(Computer Science)

Gandhi Institute For Technological Advancement

BPUT

8.6 (CGPA)

2015

Reading Books

Classical Dancing

https://www.linkedin.com/in/rojalin-pradhan-216659102/

Hobbies .

Contact this candidate