Summary
Overview
Work History
Education
Skills
Accomplishments
Interests
Timeline
Ramcharan Bauri

Ramcharan Bauri

Kolkata

Summary

Data engineer with 7+ years of experience building data pipelines and data warehouses. I have experience with a variety of data engineering technologies and am skilled at finding creative solutions to complex data challenges. I am a quick learner and have a passion for data engineering and data science

Overview

8
8
years of professional experience
3
3
Languages

Work History

IT Analyst

Tata Consultancy Services
Kolkata
11.2022 - Current
  • Developed datastage jobs as per business requirements.
  • Worked on automation of manual load process and troubleshoot job failures.
  • Building batch processing jobs in DataStage to generate multiple reports.
  • · Creating jobs to read and write data into sequential files.
  • Designing and developing DataStage jobs to extract data from different input sources (Database and input files) applied to transformation logic
  • · Working closely with the Customers and team members to understand business requirement that drive the analysis and design of quality technical solution.
  • · Wrote, maintained, and executed SQL queries to validate the integrity of the database.
  • · Utilized SQL to query and manipulate large datasets for analysis and reporting.
  • · Designed and optimized SQL queries to improve data retrieval performance

Senior System Engineer

IBM
07.2018 - 11.2022
  • Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
  • Extracting data from sources like Netezza, DB2, flat files and transforming them using business logic and loading the data to the business tables.
  • Gather requirements and business process knowledge in order to transform the data in a way that's geared towards the needs of end users.
  • Work with the business in designing and delivering correct, high quality data.
  • Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions.
  • Maintain and improve already existing processes.
  • Extensively used Sequential file, Remove duplicate, Join, Funnel, Sort, Aggregator, Transformer while developing DataStage jobs.
  • Resolved troubleshooting problems and application issues for Data Stage.
  • EMEA Internal Global Account - MIS reporting center

Education

B.tech -

MAKAUT, Kolkata, WB
06.2017
GPA: 7.85

Higher secondary - undefined

DAV PUBLIC SCHOOL, Dhanbad, JHARKHAND
04.2012

Secondary - undefined

DAV PUBLIC SCHOOL, Dhanbad, JHARKHAND
04.2010

Skills

Datastage

Db2

Unix scripting

Winscp

Putty

Github

Accomplishments

  • Certificate of appreciation from client
  • Awarded with the best final year project of the college for the session 2016/17 (2016-06-01 - 2017-06-30)

Interests

Chess
Cricket
Watching movies

Timeline

IT Analyst - Tata Consultancy Services
11.2022 - Current
Senior System Engineer - IBM
07.2018 - 11.2022
DAV PUBLIC SCHOOL - Higher secondary,
DAV PUBLIC SCHOOL - Secondary,
MAKAUT - B.tech,
Ramcharan Bauri