Snehanshu Sengupta
Senior Business Intelligence Analyst
Bangalore
Summary
Results-driven data engineering and analytics professional with over nine years of experience in delivering scalable, high-performance data solutions. Expertise in Google BigQuery for data modeling, query optimization, and performance tuning, complemented by strong skills in SQL, Python, and cloud-based ETL/ELT workflows. Proficient in designing and implementing efficient data architectures and pipelines that enhance performance, reduce costs, and ensure data quality. Specializes in developing interactive dashboards using tools like Looker and Power BI to transform complex datasets into actionable business insights. Strong collaborator adept at communicating intricate data findings to both technical and non-technical stakeholders, fostering a culture of data-driven decision-making that significantly enhances business outcomes.
Overview
9
9
years of professional experience
6
6
years of post-secondary education
3
3
Certificates
Work History
Senior Business Intelligence Analyst
Cloud Software Group
Bangalore, Karnataka
05.2024 - Current
- Proficient in designing and building Power BI reports with diverse data sources, including Dataflows, SQL databases, and Google Sheets.
- Skilled in creating DAX measures and expressions to handle complex business logic and deliver insightful analytics.
- Developed and optimized Google AppSheet applications to streamline data entry processes, eliminating duplicates and enhancing usability compared to previous Google Forms-based workflows.
- Expertise in writing and optimizing complex SQL queries to implement changes based on dynamic business requirements and logic
Senior Data Analyst
Universal electronics
Bangalore
01.2020 - Current
- Advanced proficiency in Power BI and Tableau including creating interactive visualizations, designing and optimizing data models, and implementing complex calculations and measures.
- Expertise in SQL for data extraction, manipulation, and analysis, including writing complex queries, stored procedures, and optimizing database performance.
- Proficient in data wrangling, data cleansing, and transforming raw data into meaningful insights
- Checking The Data Quality using Python
- Designed and implemented complex data models in Power BI to ensure accurate and efficient data analysis, integrating data from multiple sources
- Create pivot tables and modify spreadsheets to achieve analytical goals.
- Manage spreadsheets and maintain data currency to ensure accurate data availability for managers and decision-makers using vba and other functionality in excel
- Effectively communicated complex data insights and technical concepts to non-technical stakeholders, enabling data-driven decision-making across the organization
- Collaborated with cross-functional teams, including Testing Team, data engineers, and project managers, to gather requirements and ensure successful project delivery
Associate
Cognizant Technology Solution
Bangalore
09.2015 - 12.2019
- Conducted root cause analysis of data issues and defects identified during ETL testing, working closely with development teams to resolve them
- Utilized SQL queries and data profiling techniques to analyze and troubleshoot data discrepancies and data quality issues
- Collaborated with data stakeholders to identify data anomalies and patterns, providing insights and recommendations for data quality improvements
- Developed detailed test plans, test cases, and test scripts based on business requirements, data mappings, and transformation rules
- Identified and documented test scenarios for various ETL processes, including extraction, transformation, and loading of data
- Created and maintained test data sets and test environments, ensuring comprehensive coverage of various data scenarios.
- Familiarity with ETL tools such as SSIS (SQL Server Integration Services)
- Developed and executed test scenarios and test cases for fact tables and dimension tables to ensure data accuracy, completeness, and consistency.
- Created different dashboard using Tableau based on customer requirement
Education
Master of Technology - Communication Engineering
Vellore Institute of Technology
Chennai 05.2013 - 05.2015
Bachelor of Technology - Electronics And Communication Engineering
Calcutta Institute of Technology
Kolkata 05.2008 - 05.2012
Skills
SQL
Certification
Google Data Analytics
Timeline
Senior Business Intelligence Analyst
Cloud Software Group
05.2024 - Current
Google Data Analytics
09-2022
Senior Data Analyst
Universal electronics
01.2020 - Current
Power BI
01-2019
Python for Data Science
01-2018
Associate
Cognizant Technology Solution
09.2015 - 12.2019
Master of Technology - Communication Engineering
Vellore Institute of Technology
05.2013 - 05.2015
Bachelor of Technology - Electronics And Communication Engineering
Calcutta Institute of Technology
05.2008 - 05.2012
Similar Profiles
Ankish GuptaAnkish Gupta
Member Technical Staff at Cloud Software Group (Formerly Tibco Software)Member Technical Staff at Cloud Software Group (Formerly Tibco Software)
ANKISH GUPTAANKISH GUPTA
Member of Technical Staff at Encora (Transition From Cloud Software Group)Member of Technical Staff at Encora (Transition From Cloud Software Group)
Souvik SantraSouvik Santra
Senior Technical Writer at Cloud Software GroupSenior Technical Writer at Cloud Software Group
Sijith VJSijith VJ
Principal Software Engineer at OraclePrincipal Software Engineer at Oracle
Sreeram TRSreeram TR
Catalog Manager at AmazonCatalog Manager at Amazon