Vijay Chauhan
Principal Consultant ( BI )
Mumbai
Summary
Data Architecture and Data Analyst || PL-300 Microsoft Certified Data Analyst || Power BI || Power Query || DAX || Power BI Architecture ||MS SQL || PostgreSQL|| SSIS || SSRS || SSAS || [PCEP-30-02] PCEP certified Python Developer || DP-900 Microsoft Certified: Azure Data Fundamentals || Advanced Data Modelling From Meta || Tableau || Snowflake
Overview
12
12
years of professional experience
6
6
Certifications
Work History
Principal Consultant
Nice Software Solutions Pvt. Ltd.
04.2024 - Current
- Summarized operational and strategic insights of Mashreq Bank.
- Empowered Mashreq Bank's business users by implementing and designing sophisticated data solutions for self-service analytics as a Power BI Data Engineer.
- Designed AI-powered Power BI dashboards to enhance data visualization.
- Enabled efficient and empowered data utilization with the development of self-service semantic models for report generation.
- Leveraged advanced AI capabilities in Power BI for reporting on sales trends, deal performance, retention metrics, and IO card journeys.
- Optimized data accessibility through transformation of reporting structure within Power BI framework.
- Enhanced collaboration by integrating deployment pipelines in Power BI, ensuring streamlined development and accurate reports.
- Streamlined the management of simple and data-driven subscriptions for stakeholders.
- Upgraded report presentations with more insightful and dynamic visual enhancements.
- - Landing Page Modification: Modified the landing page to enhance user experience and improve navigability
- Streamlined data reporting by migrating platforms, implementing deployment pipelines and version control systems, transforming reports for better insights, and improving user experience through landing page enhancements.
Data team lead BI
ETech Pvt Ltd
10.2023 - 04.2024
- Directed activities and functions within Giant Eagle, an American organization.
- Developed and maintained Power BI reports to optimize inventory management across the U.S..
- Developed and generated reports through thorough end-to-end processes.
- Ensure high performance and security in the creation of Power BI and Pagination reports.
- Maintained and enhanced actionable inventory management reports using Power BI.
- Handled data modeling, schema creation and user access granting during the development process.
- Facilitated requirement analysis to deliver impactful Power BI dashboards and Pagination outputs.
- Implemented Row-Level Security (RLS) protocols to ensure secure and tailored report access.
- Collaborated with Giant Eagle LLC to enhance functionality and security of Power BI and Pagination reports.
Associate Manager
SS&C Technologies
12.2022 - 09.2023
- Company Overview: Northrock LLC (US-based Firm)
- Managed responsibilities as a Data Analyst focused on risk assessment processes.
- Monitored risk compliance through automated email alerts.
- Executed accurate risk assessment through diligent management of everyday activities linked to the Risk Score Card.
- Implemented detailed reporting solutions using SSRS and Power BI to facilitate effective risk management.
- Ensured accurate and relevant reports through advanced SQL querying.
- Enabled stakeholders to swiftly mitigate risks with automatic alerts.
- Ensured projects met required standards through effective oversight and timely task execution.
Software Engineer
NEC Corporation India Pvt Ltd.
12.2020 - 12.2022
- Implemented end-to-end solutions for HR data visualization with Power BI.
- Collaborated with stakeholders to collect and analyze project requirements.
- Delivered high-quality outputs through the end-to-end creation of Power BI HR analytics.
- Worked with the client for requirement alignment in creating or updating Power BI reports.
- Worked closely with stakeholders throughout development phases, ensuring report alignment for maximum ROI.
- Oversee scheduling, sensitivity protocols, and configurations for secure report, and implementing Row-Level Security (RLS) to enhance report functionality and security
- Collaborated with U.K. clients to create customized reporting solutions, enhancing functionality and security.
Business Intelligence Developer
NeoQuant Solutions Pvt Ltd
10.2019 - 12.2020
- Company Overview: SBI Mutual Fund
- Executed end-to-end development of scalable data infrastructure for efficient reporting and business insights.
- Ensured sensitive data management by optimizing SQL queries and improving report visuals.
- Developed dynamic queries, DW databases, and SSAS tabular models to support business needs.
- Optimized complex SQL queries using recursive CTEs and advanced techniques for efficient data retrieval.
- Handled creation, modification, refresh schedules and dynamic partition processing for SSAS.
- Configured workspaces and ensured secure transmission of sensitive information.
- Showcased proficiency in Power BI through expert data management techniques.
- Produced award-winning reports recognized for excellence and impact at the Annual Meeting.
- Enhanced report functionality, security, and efficiency using advanced Power BI and SSAS techniques.
Database associate
Decimal Point Analytics Pvt Ltd
05.2018 - 09.2019
- Company Overview: Lakshmi Vilash Bank
- Developed comprehensive data solutions by creating and updating SSIS packages, MS SQL queries, procedures, dynamic queries, and data warehouse databases.
- Ensured data sensitivity and enhanced report functionalities and visualizations.
- Built SSAS tabular models and Power BI reports to support analytical insights.
- Optimized report creation process to deliver detailed insights.
- Optimize existing reports to enhance performance and usability
- Developed and fine-tuned complex SQL queries and procedures leveraging recursive CTEs, inner queries, and advanced joins to optimize performance.
- Ensured data integrity and performance through dynamic partition creation and processing.
- Configured workspaces for accurate and protected report dissemination.
- Demonstrated proficiency in Power BI for enhanced data analysis and protection.
- Created and optimized Power BI reports to provide critical insights, managing report schedules and data sensitivity.
Database Developer
Valuefy Solutions Private Limited
06.2016 - 04.2018
- Company Overview: Invezta (Sister Company)
- Streamlined data workflows through robust development of scalable technical solutions.
- Collaborated on development of robo advisory SQL series to support advanced analytics.
- Crafted effective procedures and queries to enhance data processing efficiency in Invezta's projects.
- Utilized logs and reverse engineering to rectify errors in data runs.
- Streamlined ETL workflows to ensure precise and efficient transformation of raw data into structured formats.
- Refined SSIS solutions to ensure optimal functionality and stability.
- Enhanced performance of SQL operations through development of streamlined recursive processes, nested queries, and effective join strategies.
- Streamlined operations by integrating automation into transactional feed systems.
- Automated operational transactional feeds to improve overall process efficiency; collaborated on robo advisory SQL series for innovative solutions.
Executive
ICICI bank
07.2013 - 08.2015
- Administered charge operations for credit cards and assisted with client inquiries.
- Prepared analytical MIS reports facilitating data-driven decision-making.
- Managed customer concerns related to credit card fees, providing effective solutions.
- Enhanced operational performance by delivering actionable insights through robust MIS reporting.
- Structured analysis and presentation of data trends.
- Utilized Excel and various tools for thorough data analysis, enhancing efficiency in credit card operations.
- Present data in a visually appealing manner using charts, graphs, and dashboards
- Streamlined routine reporting procedures to ensure accuracy and effectiveness.
- Understood and met distinct departmental reporting requirements by customizing MIS reports.
- Provided excellent customer service through quick resolution of credit card queries.
Education
Bachelor of Science - Computer Science
Thakur College of Science and Commerce
Mumbai 07.2008 - 7 2011
PG Diploma - Computer Science
CDAC
Mumbai04.2016
Skills
Power BI & DAX
Data Modelling & AI-Driven Reporting & Semantic Data Transformation
Deployment Pipelines & Version Control
Agile Development & Stakeholder Collaboration
SSRS (SQL Server Reporting Services) & Complex SQL Queries
Data Analysis & Dataset (DW) Management
SQL Query Optimisation & Power BI performance Tuning
Data Warehouse (DW) Management & SSAS Tabular Models
Certification
Microsoft Certified: PL-300 Power BI Data Analyst Associate, Microsoft, 01/2022, https://www.credly.com/badges/056e8f46-e518-4f6e-a9f6-b8e887f87a9f?source=linked_in_profile
Timeline
Principal Consultant
Nice Software Solutions Pvt. Ltd.
04.2024 - Current
Data team lead BI
ETech Pvt Ltd
10.2023 - 04.2024
Associate Manager
SS&C Technologies
12.2022 - 09.2023
Software Engineer
NEC Corporation India Pvt Ltd.
12.2020 - 12.2022
Business Intelligence Developer
NeoQuant Solutions Pvt Ltd
10.2019 - 12.2020
Database associate
Decimal Point Analytics Pvt Ltd
05.2018 - 09.2019
Database Developer
Valuefy Solutions Private Limited
06.2016 - 04.2018
Executive
ICICI bank
07.2013 - 08.2015
Bachelor of Science - Computer Science
Thakur College of Science and Commerce
07.2008 - 7 2011
PG Diploma - Computer Science
CDAC