Jun 2024 – Jul 2025 · 1 yr 1 mo · Gurugram, Haryana, India

• I work as a data analyst, providing data-driven insights and consultation to support strategic decision-making.

Apr 2024 – Jun 2024 · 2 mos

• Leading a team to implement best practices in dashboard development.
• Enhancing visualization processes by exploring and integrating new tools and technologies.
• Reducing manual efforts within the team to accelerate progress.
• Meticulously documenting processes to organize and streamline team efforts.
• Onboarding and guiding new team members through comprehensive knowledge transfer sessions on projects and tools.
• Enforced new methods for application development with Gen AI technology
• reducing the development days.

Apr 2022 – Mar 2024 · 1 yr 11 mos

• Analysed student data and crafted reports in Power BI using SSAS, DAX and in house tool, enabling clients to gain insights into attendance, academics, behaviour and K12 related data seamlessly
• Engineered a variety of visuals utilizing an in-house tool, employing intricate SQL queries (advanced like CTE, Window functions etc) and logic to present insightful trends and visuals for enhanced data interpretation
• Conducted data profiling and validation to ensure data accuracy and consistency
• Swiftly adopted and seamlessly migrated to a new technology, ensuring a prompt implementation that significantly enhanced dashboard performance
• Enhanced query performance in Snowflake by tailoring optimizations to its architecture for more efficient execution
• Led the team from its inception, overseeing the creation and enhancement of dashboards
• Assisted in the ETL process and maintenance of it to improve data consistency
• Spearheaded dashboard development with an in-house tool and Snowflake, boosting sprint productivity
• Guided and collaborated with QA/Dev, providing insights into stories, addressing bugs, and facilitating knowledge transfer
• Contributed actively to development through researching and discussing new requirements, emphasizing documentation
• Identified, troubleshooted, resolved, and escalated data-related issues to ensure seamless operations
• Developed a Python automation task to boost team productivity by eliminating recurring daily tasks

Aug 2018 – Sep 2022 · 4 yrs 1 mo

• Develop Power BI reports for K-12 education system related to Attendance, Grades, Discipline & Behavior and Student Readiness
• Develop T-SQL scripts for performing automation tasks
• Develop custom calculated measures using DAX to satisfy business needs
• Experience in building SSAS cubes and dimensions for Business Intelligence and writing MDX scripts
• Worked with Agile methodology for application development
• Ensure the performance of Dashboards while using DAX
• Research and develop new features provided by product team
• Planning the estimates, hence assigning the user stories to the team for development and unit testing
• Participate in requirement meeting and data mapping sessions to understand business needs
• Work with Microsoft team on product limitations and communicate limitations and tool capabilities to Product Team
• Involved in troubleshooting, resolving and escalating data related issues and validate data to improve data quality
• Giving application demos to Product Team and other teams at every sprint end

Sep 2016 – Aug 2018 · 1 yr 11 mos · Jaipur Area, India

• Responsible for maintaining quality reference data in SQL by performing operations such as
• Cleaning, Transformations and ensuring Integrity in a relational environment.
• Expertise in writing T-SQL Queries, Dynamic-queries, Joins, Stored Procedures, Triggers.
• Develop and deploy ingestion pipeline using Azure Data Factory with incremental load.
• Build ETL Packages using Microsoft SSIS, troubleshoot ETL Failures.
• Deploy and develop the ETL Pipelines using Azure Data Factory, for real time using Azure Stream Analytics and Azure Event Hubs. Showing real time data creating visuals by connecting Stream Analytics to Power BI.
• Create basic model using Machine Learning Services (R, Python) in SQL Server 2016 and SQL Server 2017.
• Develop reporting solutions and visualizations using Power BI.
• Hands on Experience in Azure ML, Spark, Databricks, SQL Server Machine Learning Services.
• Mentor new employees and interns with on-boarding and project team integration.
• Handle client demos and presentations for projects on an ongoing basis.
• Being part of and manage team of front end and back end developers.
• Tools/Technologies - Data Factory, Event Hubs, Power BI, SSMS, SQL Server, SSAS, SSIS, Visual Studio
• Languages - Python, SQL, DAX
• Cloud Computing Platforms - Microsoft Azure (ADF, Azure SQL, Azure DW, Azure Storage, Azure ML, Studio, Event Hubs, Stream Analytics, Azure Virtual Machines, Vaults, Schedule, Power Shell)

Jun 2016 – Sep 2016 · 3 mos · Jaipur Area, India

• Developed ML functionality in MS Excel to analyze the data. It helped users to create their own predicting model only in few clicks.
• Created a POC in Machine Learning Services (R, Python) in SQL Server 2016 and SQL Server 2017 to create a Customer Churn model on Telecom Data and to integrate this model to find customer churn on daily transaction data.
• Developed Power BI reports on 60 Million Records, configured Power BI gateways to connect SQL Server to Power BI.
• Tools/Technologies - MS Excel, Power BI, SSMS, SQL Server 2016, SSAS, SSIS, Visual Studio
• Languages - VBA, Python, R, SQL