Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Languages
Timeline
Projects
Generic
Sameer Manubansh

Sameer Manubansh

Delhi

Summary

Having 9 years of overall experience, including 4 years with proficiency in French and 5 years of specialized experience as a Data Engineer and BI Developer. Demonstrated expertise in Azure Data Factory pipelines, ETL processes, Power BI, data analytics, and data visualization.

Overview

9
9
years of professional experience
1
1
Certificate

Work History

Data Engineer

Claranet
New Delhi
07.2022 - 06.2024

• Perform ETL using Azure Data Factory and SSIS
• Manage Data Warehouse on SSMS, creating tables & procedures
• Writing complex SQL Server queries to access data from Datawarehouse
• Create Power BI dashboards with various data source connections
• Use DAX function to create custom calculations and aggregations for data analysis
• Perform data cleaning in Power Query Editor
• Develop financial KPI calculations as per business

Consultant - Data Analytics

Capgemini
Bangalore
04.2019 - 07.2022

• Automating reports and dashboards by architecting design and workflows using RPA tools for the leadership.
• Perform ETL using Azure Data Factory and SSIS and write complex SQL server queries to fetch data.
• Understand and design analytical solutions to Business problems leveraging analysis of Data.

• Creating data stories in Power BI to analyze trends and provide business recommendations.

• Assist in stakeholder meetings to understand current business process and create workflow diagrams.

• Derive business based attributes using Advanced Excel Power Query Editor.

Catalog Associate - French

Amazon
BANGALORE
07.2016 - 02.2019

• Perform product catalog audit on the Training and Test sets to help Model achieve the threshold accuracy for production.
• Perform deep dive to analyze data and identify new trends/patterns.
• Work closely with Program Managers on process improvement projects.
• Process training and mentoring the new hires in the team.

HR Analyst - French

Rio Tinto
Gurgaon
06.2015 - 06.2016
  • End to end recruitment after the selection process (Managing day-to-day operational aspects for conducting pre- employment background checks by external vendors, medical checks, site visits, hiring process of the candidates).

Education

Master of Science -

Liverpool John Moores University
02-2021

Post Graduate Diploma in Data Science -

IIIT Bangalore & UpGrad
07-2020

Bachelor of Arts in French -

Amity University
06-2015

Skills

  • Azure Data Factory
  • DAX
  • Power Query
  • Data Modeling
  • Power BI
  • SQL Server
  • SSIS
  • SSMS
  • Data Visualization
  • Rest API
  • Data Pipeline Design
  • Data Science Techniques
  • RPA
  • Data Warehousing
  • Data Analytics
  • Power Automate

Certification

DELF B1, Alliance Française De Delhi, Delhi

Accomplishments

  • Shri Baljit Shastri Award for Human & Traditional Values at Amity University Delhi NCR
  • Silver medal for academic excellence at Amity University Delhi NCR

Languages

Hindi
First Language
English
Proficient (C2)
C2
French
Proficient (C2)
C2

Timeline

Data Engineer

Claranet
07.2022 - 06.2024

Consultant - Data Analytics

Capgemini
04.2019 - 07.2022

Catalog Associate - French

Amazon
07.2016 - 02.2019

HR Analyst - French

Rio Tinto
06.2015 - 06.2016

Master of Science -

Liverpool John Moores University

Post Graduate Diploma in Data Science -

IIIT Bangalore & UpGrad

Bachelor of Arts in French -

Amity University

Projects

Company: Claranet| SSIS to ADF Migration | May'23 - Oct'23

• Migrated 20 ETL packages from SSIS to ADF
• Created pipelines for all the SSIS packages in ADF environment
• Created stored procedures in SSMS for complex SQL related queries functioning with Datawarehouse

Company: Claranet| Group KPI Visuals (Quarterly & Monthly) | Nov'22 - Jan'23

• Implemented all manual excel calculations in Power BI DAX (specially the KPIs Moving Average based on various time stamps like end of quarter, fiscal quarter, monthly with various exceptions) Created all graphs as per business logic (implemented waterfall graph for TARR (monthly & quarterly))
• Created Quarter vs Quarter value change & Percentage wise change table
• Implementation of this report saved 0.5 FTE cost of a Senior Financial Analyst

Company: Claranet| Performance Analytics (Technical Service Delivery, Order Management) | Aug'22 - Nov'22

• Implemented all DAX calculations as per Performance Analytics logic on ServiceNow dashboard 

• Created various visuals similar to ServiceNow with drill-down functionality to display all background data with URL to ServiceNow
• Created ETL flow to capture ServiceNow data into Datawarehouse
• Saved multiple dollar annual subscription cost of Performance Analytics on ServiceNow

Similar Profiles

CREATE PROFILE
Sameer Manubansh