Jhilmil Baruah
ETL & BI Expert | AWS Certified Solutions Architect | EMR & Snowflake | Data Specialist
Kolkata
Summary
Experienced Lead Engineer/Data Specialist/Associate Consultant with 13+ years leading teams in Data Mining, cloud migration, and Data Warehousing. Skilled in driving process efficiency, ensuring data integrity, and leveraging technology to optimize operations for maximum efficiency.
Overview
6
6
Certifications
14
14
years of professional experience
Work History
Technical Lead
TCS (Baxter Pharmaceuticals)
09.2023 - Current
- Provided end-to-end support for data engineering pipelines, ensuring timely data delivery and minimal downtime across AWS and Snowflake environments.
- Managed and monitored ETL workflows, data loads, and batch processes using tools like AWS Glue, Lambda, and AWS S3, AWS EMR.
- Developed and maintained SQL scripts, stored procedures, and views in Snowflake to support business analytics and reporting.
- Supported data ingestion from various sources including S3, APIs, and on-premise systems into Snowflake using AWS Data Services.
Technical Lead
TCS
02.2022 - 09.2023
- Understanding the existing data warehouse, identifying the key issues/redundancies, identifying the key dimensions and facts and converting those into models that are suitable for holding the client requirements.
- Had worked on creating and designing automated solutions to transform SAP data to On cloud SQL RDS.
- Had worked hand in hand with the team to design packages and workflows to extract the client specific data, transform those and load them into the corresponding data warehouse and automate the same for ease.
Lead Engineer
Espire Infolabs
07.2020 - 02.2022
- Understanding the existing data warehouse, identifying the key issues/redundancies, identifying the key dimensions and facts and converting those into models that are suitable for holding the client requirements.
- Had worked on creating and designing and also testing of the below Power Bi reports and visualizations– Marketing Reports, Finance Reports, Business Support.
- Had worked hand in hand with the team to design packages and workflows to extract the client specific data, transform those and load them into the corresponding data warehouse and automate the same for ease.
Data Analyst
British Airlines (NIIT Technologies)
12.2018 - 06.2020
- Produced monthly Crew Data Management and Flight Ops data reports using Advanced Excel spreadsheet/Power BI functions for British Airways.
- Participated in requirements meetings and data mapping sessions to understand business needs.
- Identified and documented detailed business rules and use cases based on requirements analysis.
- Developed database objects, including tables, views and materialized views using SQL.
- Transformation of XML files generated from BA legacy system to implementation database after data profiling, data mining, data cleaning and data validations are checked, and after applying the required business rules.
- Designed automated approach that could complete task with just 10% manual intervention.
Developer Analyst
AON Pvt Ltd
03.2016 - 12.2018
- Developed an SSIS package which pulls the data from SQL Server (source) and loads into SQL Server (target) data base on given date range.
- Created Different types of Charts like Column, Bar Chart, Line and Pie Chart with the Client requirement.
- Preparing Functional and Technical Specifications as per Client’s Business Requirement.
- Extensive experience with T-SQL in constructing Store Procedures, User Functions, Views, Indexes, Relational Database models.
- Designed Different Types of Reports like Drill Down, Drill Through, and Parameterized Reports.
- Supported the client’s operations team by automating the group claims processing and other operations tasks by implementing the same using UI Path (RPA).
- Had earned the opportunity to travel to Singapore to interact with the client, understanding their issues and resolving them or providing those solutions and that included in their manual day to day tasks as well as any enhancements in the current processing of the data cycle.
Senior Software Engineer
AON Pvt Ltd.
03.2012 - 02.2016
- Providing solutions to complex client requirements and leading a team of resources to provide quality support and deliveries on time.
- Good knowledge of query optimization.
- Excellent analytical and problem-solving skills and can work independently.
Software Engineer
LA- Retirement Benefits
08.2011 - 02.2012
- Proven experience in designing, development, testing of Data warehouse and Data marts.
- Directly responsible for Extraction, Cleansing, Transformation and Loading of data from multiple feeds and sources into Data Warehouse.
- Created and executed SQL statements in both SQL production and development environments.
Education
Bachelor of Engineering - Information Technology
Rajiv Gandhi Technical University
Skills
Snowflake expertise
Data processing with AWS services
Proficient in PostgreSQL
SQL data analysis
Data integration using SSIS
Experience with MS SQL Server reporting tools
Scripting with VBScript
Data integration specialist
SharePoint collaboration tools
Excel data visualization
Certification
SAS certifications (BASIC as well as advanced) by Coursera
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Accomplishments
- Supervised team of more than 5 staff members.
- With experience, had guided new resources and helped them learn by conducting trainings.
- Have experience on different domains including Healthcare and medicine, Airlines , Sales and Insurance domain.
Quote
"Data is like garbage. You'd better know what you are going to do with it before you collect it"
Mark Twain
Timeline
Technical Lead
TCS (Baxter Pharmaceuticals)
09.2023 - Current
Technical Lead
TCS
02.2022 - 09.2023
Lead Engineer
Espire Infolabs
07.2020 - 02.2022
Data Analyst
British Airlines (NIIT Technologies)
12.2018 - 06.2020
Developer Analyst
AON Pvt Ltd
03.2016 - 12.2018
Senior Software Engineer
AON Pvt Ltd.
03.2012 - 02.2016
Software Engineer
LA- Retirement Benefits
08.2011 - 02.2012
Bachelor of Engineering - Information Technology
Rajiv Gandhi Technical University