Subhradeep Guha
Data Analyst/Engineer
Hyderabad
Summary
Experienced and enthusiastic Consultant with track record of success across wide range of industries. Possesses exceptional interpersonal, problem-solving and analytical skills to provide advice and expertise to client organizations improving business performance. Experienced in all aspects of operations, strategy and technology.
Overview
7
7
years of professional experience
4
4
years of post-secondary education
Work History
Associate Consultant (Data Engineer)
Rythmos
07.2022 - Current
- Experienced in leading Teradata to Redshift migration project from start to finish
- Regularly maintained and updated Jira boards, streamlining workflow management and enhancing team productivity.
- Extensively worked on development, integration, automation, and data visualization using Python
- Expertise in extracting data from Teradata, transforming it to meet Redshift requirements, and loading it into the Redshift environment
- Implemented different automated workflows using Microsoft Power Automate, streamlining operations and reducing manual tasks.
- Proficiency in validating and testing the migrated data to ensure its integrity, accuracy, and consistency
- Integrating Python scripts in Power BI environment and automate using Power Automate flow
- Creating different kind of ETL Process by running python scripts and fetching data from SFTP server
- Implementing Machine Learning Model in Power BI environment on advanced level
- Several types of statistical analysis based on client requirements
- Writing SQL Queries based on adhoc requirements
- Building reports & dashboards using Power BI
- Augment, document and understand current ETL process
- Working on field quick turn-requests for adhoc analysis
- Creating new ETL scripts for new data sources and reports.
Process Developer (Maintenance Analyst)
Genpact India Pvt. Ltd.
11.2018 - 07.2022
- Preparing monthly client reports by using different Python scripts, SQL queries
- Managed diverse kinds of adhoc tasks by using Python, Advanced Excel, and Statistical analysis.
- Utilized analytical and technical expertise to provide insights and proposals to support business improvements.
- Developed Key Performance Indicators (KPI) and presented it to the management.
- Worked on exploratory data analysis and applied predictive analysis such as Machine Learning (ML) techniques to forecast Cost.
- Prepared dashboards based on client requirement by using Power BI, Salesforce Lightning tools.
- Conducted business process analysis and identified critical issues and gaps.
- Working on daily data queries (Adhoc) and prepared reports & preparing different trackers and time basis adhoc-queries.
- Developing all internal report formats, Managed MIS (Management Information System) work also RTA (Real Time Analysis) tasks
Associate (Data Analyst)
PWC-SDC (Price Waterhouse Coopers - Service Delivery Centre)
10.2017 - 02.2018
- Automated control testing deploying CAAT's like ACL, SQL, and Alteryx
- Applied ACL Analytics for reconciliation in financial datasets for different ERPs
- Control and report testing in global territory.
Education
B.Tech - Electronics And Communicaton Engineering
University of Engineering & Management
Jaipur, India 01.2013 - 04.2017
Skills
Data Analytics
Python
Power BI
Alteryx
SQL
Advanced Excel
Shell Scripting
AWS (Basics)
Projects and certifications
- Data Science Internship, Innomatics Research Lab, Oct'2017, Feb'2018, Intern ID - IN30133 Project: Song Recommendation System
- Data Science & Business Analytics Internship, The Spark Foundation, Project: Prediction of the percentage based on study hours using supervised ML Certificate Number - 4XJ8HR5NDN
- Data Science course, Let the Data Confess, Worked on various projects including prediction models for Boston House Pricing, Automobile Cost Prediction, Medical Cost Prediction, and Beer consumption rate in Sao-Paolo.
- Lean Project (Six Sigma), RONA Implementation, Oct'2017, Feb'2018, Streamlined business processes and reduced the daily abandoned rate.
Languages
Bengali
Bilingual or Proficient (C2)
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Timeline
Associate Consultant (Data Engineer)
Rythmos
07.2022 - Current
Process Developer (Maintenance Analyst)
Genpact India Pvt. Ltd.
11.2018 - 07.2022
Associate (Data Analyst)
PWC-SDC (Price Waterhouse Coopers - Service Delivery Centre)
10.2017 - 02.2018
B.Tech - Electronics And Communicaton Engineering
University of Engineering & Management
01.2013 - 04.2017