Data Warehouse

HEMALATHA

GOPI

**************@*****.***

*** ********** ****,

399746 Singapore

+65 85472993

Education

Bachelor Degree

Information Technology

**** ***********, *****

Aggregation: 82%.

Master Degree

Distributed Computing Systems

2018 Pondicherry, India

Aggregation: 87%.

Technical Skills

RDMS

Oracle 12c/11g/, MySQL.

ETL Tools

Pentaho Data Integration

(Kettle),

Informatics(Basics)

OS

Unix, Windows

Languages

SQL, PL/SQL, MySQL, Shell

Scripting.

Reporting Tools

Qlik Sense, Jaspersoft

Personal Information

MARITAL STATUS

Married

D.O.B

12th Sep1993

Nationality

Indian

Languages Known

English & Tamil& French

Alternate Contact No.

+91-741*******

Pass Type

Dependant Pass

Profile

Experienced and passionate BI Engineer,seeking a challenging position in an organization where I can use my 3+ years of experience to grow and expand an organization as well as myself.

Professional Experience

Tata Consultancy Service -2018 – Present,Chennai,India Experienced in Airline Domain

Over 3+ years in Production support, Development & Enhancements with ETL and Reporting tools.

Extraction of data from Sources to Targets- Staging Area, Data Marts or Data Warehouses.

Experience in SQL Programming (Stored procedures, Triggers) using Oracle and UNIX shell scripting to perform job scheduling.

Designed, tested and deployed interactive dashboards & reports using QlikSense. Lead a team of 4 to maintain production support activities. Project Reponsibilities

Pentaho

• Used Pentaho Data Integration (PDI)/Kettle to design & transform all ETL processes to extract data from external files, cleanse and then load the data into target data warehouse.

• Used different types of input and outputs transformations for various data sources including Tables, Text File, and Excel and CSV files.

• Worked in Slowly Changing Dimension Type 1 and Type2 in ETL jobs for various dimensions.

• Created automations using Shell scripts in UNIX and PL/SQL scripts to automate daily routine jobs using CRON for production databases. QLIK Sense

• Worked on Data Extraction from database, stored in QVDʼs and Load scripts.

• Developed QVD scripts to load history and current data using Incremental refresh and full refresh logic.

• Designed, tested, and deployed interactive dashboards and reports using Qlik Sense and implemented user access, task chains, incremental refresh for the same. Achievements

Automation Specialist

Automation Specialist of the Month Award for handling Automation for support level activities to reduce manual effort.

Appreciation for a Young Leader

Took sole responsibility in leading a team of 4 to maintain production support activities

Declaration

Place

G.HEMALATHA

Singapore

G.HEMALATHA

SINGAPORE

Contact this candidate