Suraj Kumar
Bokaro
Summary
Exceptionally well organized and resourceful individual with an academic background in Engineering and having 9+ years of work experience in IT (Information & Technology) industry working independently with key stakeholders and management and liaising between technical and business projects primarily into the insurance domain. Strong contributor and carry hands-on experience in the areas of Data Engineering, Reporting and Migration. Have an extensive knowledge into programming and coding in SQL, PLSQL, Java, PuTTY, Shell-Scripting, Java Script and also to automate ETL pipeline using Pentaho Data Integration, Matillion ELT tool. Experience in creating Analytical report, Tabular report and Interactive report using Pentaho reporting tools, Experience in Team handling and Resource management.
Overview
11
11
years of professional experience
Work History
Consultant (ETL Development)
Genpact India
04.2024 - Current
- Project: Data Migration.
- Client: Label solution provider company
- Description: The project is intended to provide migration solution from Pentaho to Matillion cloud tool. Automates the migration process and ensures that all data pipelines, workflows, and mappings are correctly transferred.
- Roles and Responsibilities:
- Work with the team to development of the Matillion ETL/SQL codes.
- Work as a lead Pentaho ETL developer and understood the Pentaho ETL flow.
- Work with the team to develop of the Matillion ETL/SQL codes.
- Prepare the ETL Framework High Level Design Documents.
- Functional Skills Used: Matillion ELT development, Data validation and Testing of the Data.
- Technical Skills Used: Pentaho Data Integration,Matillion, SQL, PostgreSQL, UNIX, PuTTY,Java Script, GIT, JIRA
Consultant (ETL Development)
Genpact India
03.2022 - 03.2024
- Project: Data Integration.
- Client: One of the biggest banks in Australia
- Description: The project was intended to provide data feed using Pentaho Data Integration for Oracle Fusion Accounting Hub(FAH) and Aptitude(IFRS17) as per requirements. The ETL solution also validates data from multiple sources, including actuarial and production data required for calculating cash flows. Data quality, transparency and auditability further support the data management process, ensuring the quality of the input while addressing regulatory and accounting requirements. This process group the data and deal with them per category in order to efficiently automate each ETL process required with sufficient controls and checks in place.
- Roles and Responsibilities:
- Worked as a lead Pentaho ETL developer in developing the etl codes for reading the data from multiple source systems andloading it to target as per the mapping document.
- Communicated and coordinated with the project team, partners, and stakeholders.
- Validated the Source provided Data to maintain the system clean and appropriate as per the business need.
- Wrote the Unix script to run the Pentaho jobs in ST environment.
- Lead/helped the team in development of the Pentaho ETL/SQL codes.
- Implemented Data reconciliation checks as per business rule.
- Prepared the ETL Framework High Level Design Documents.
- Functional Skills Used: Pentaho ETL development, Data validation and Testing of the Data.
- Technical Skills Used: Pentaho Data Integration, SQL, PostgreSQL, UNIX, PuTTY, WIN SCP, Shell-Scripting, Java Script, GIT, JIRA
Senior Software Engineer
Mphasis India Pvt Ltd
03.2021 - 02.2022
- Project: Data Migration and Integration.
- Client: One Of the biggest financial market data provider in America.
- Description: The project is intended to migrate the data from its existing PL/SQL platform to the Pentaho ETL platform.
- Roles and Responsibilities:
- Performed the code transformation from legacy(PL/SQL) system to Pentaho ETL Data Pipelines.
- Performed the code transformation from the legacy (PL/SQL) system to Pentaho ETL Data Pipelines.
- Designed and maintained ETL processes, using the tool Pentaho Data Integration.
- Performed troubleshooting and implemented performance tuning for Pentaho ETL jobs.
- Understood the data flow mechanism of legacy system.
- Prepared unit test cases for developed code to ensure functionality.
- Technical Skills used: SQL, PL/SQL, Pentaho Data Integration, PUTTY, Unix, WinSCP, JavaScript.
- Database used: Oracle, MySQL
Senior Software Engineer
6d technologies
08.2019 - 02.2021
- Project: Data Integration
- Client: One Of the telecommunications provider in America.
- Description: The project is intended to organize and manage the telecommunications data and generate the wide range of analytical, interactive and tabular reports.
- Roles and Responsibilities:
- Developed generic error handling ETLs utilizing metadata-driven approaches.
- Designed dynamic ETLs for diverse data extractions.
- Handled soft and hard failures in PDI.
- Performance tuning for SQL Queries and ETLs.
- Generated analytical, tabular, and interactive reports using Pentaho Schema Workbench, Pentaho Report Designer, and Pentaho Metadatabase Editor.
- Analyzed data in Pentaho User Console and worked on administrative features of it.
- Installed and configured the Pentaho Suite.
Software Engineer
CGI
01.2015 - 07.2019
- Project: Data Integration
- Client: One Of the biggest electronic procurement system provider in America
- Description: The project is intended to organize and manage the electronic procurement data. Built the data pipeline by loading data from the source system(Json format) into the data warehouse using Pentaho DI.
- Roles and Responsibilities:
- Created dynamic ETLs for all kinds of extractions.
- Loaded data to multiple facts and dimension tables using PDI.
- Created Generic error handling ETLs using metadata driven.
- Handled soft and hard failures in PDI.
- Performance tuning for SQL Queries and ETLs.
- Created Email notifications to notify the status of Jobs and Transformations.
- Created and made use of reusable transformations.
Education
B.Tech - Computer Science and Engineering
Aryabhatta institute of engineering and management
Durgapur, WB01-2013
Intermediate - Science
R.V.S Bokaro
Bokaro, Jharkhand01-2007
High School - undefined
High School Bandhdih
Bokaro, Jharkhand01-2005
Skills
Extensive experience in ETL, Programming & Reporting on Pentaho BI/SQL/Java and delivering reports in various formats like HTML, PDF, CSV and XLSX
Architect and design data pipelines within Pentaho Data Integration for efficient data processing
Experience in developing Matillion ELT pipeline
Data Migration and Integration across different servers
Design Analytical, Tabular and Interactive Reports
SQL, PLSQL, JAVA, Pentaho BI, Pentaho Data Integration, Pentaho Report Designer, Pentaho Metadata Editor, Pentaho Schema Workbench, JAVA SCRIPT, JENKINS, PUTTY, WinSCP, UNIX, SHELL-SCRIPTING, BITBUCKET, GIT, JIRA
An effective communicator with an experience in building and handling client relationship and information management skills with a good understanding of Data structure and Computer programming Willing to learn new tools and technology
Timeline
Consultant (ETL Development)
Genpact India
04.2024 - Current
Consultant (ETL Development)
Genpact India
03.2022 - 03.2024
Senior Software Engineer
Mphasis India Pvt Ltd
03.2021 - 02.2022
Senior Software Engineer
6d technologies
08.2019 - 02.2021
Software Engineer
CGI
01.2015 - 07.2019
High School - undefined
High School Bandhdih
Intermediate - Science
R.V.S Bokaro
B.Tech - Computer Science and Engineering
Aryabhatta institute of engineering and management
Declaration:
I declare, to the best of my knowledge that the information given above is true. Suraj Kumar