Sagar Gupta Email & Phone Number

Portsmouth, New Hampshire, Us

• Collaborated regularly with teams like Finance, IT and, Audit to understand the BI reporting requirements.• Developed and executed ETL processes using Tableau Prep to integrate data from various databases, APIs, and flat files, reducing data preparation time by 90%.• Achieved data wrangling by defining the table relationships and data models for efficient reporting.• Created MDX queries, Parameters, and Sets to ensure accurate and efficient BI reports.• Built Machine Learning models using Python to analyze the Call Center data in order to evaluate ways to reduce cost and increase total revenue.• Designed FP&A reports to analyze the cost efficiency of individual vendors that resulted in annual savings of approximately $250,000 through process optimization and strategic vendor negotiations.• Communicated with clients and non-technical managers to provide end-user training on the working of the BI reports.

Boston, Massachusetts, Us

• Automated SQL data extraction and Tableau Server live import, improving efficiency by more than 80% compared to the manual process.• Generated ETL packages using SSIS to load data from Microsoft SQL Server to OLAP and developed OLAP cubes using SSAS to analyze Massachusetts hospital’s revenue data.• Built Monthly and Quarterly Tableau dashboards for the data quality team to get insights into hospital's financial data.• Deployed the Tableau dashboards to the live Tableau server and implemented role-based access levels to enhance security and limit dashboard access within the organization.

Richardson, Texas, Us

Founded a student organization at the University of Texas at Dallas, aiming to promote, explore and teach programming languages like Python and R.

Richardson, Texas, Us

On-campus employment at The University of Texas at Dallas in the Parking and Transportation Services Department.• Automated Task Scheduler in T2 Flex to update more than 32,000 student's data, resulting in 70% efficiency.• Created Oracle SQL Queries to move the student's data from T2 Parking System to University's Database.• Created Excel Pivot Tables to analyze the enrolment behavior of more than 32,000 students.• Updated the existing faculty data by matching them with all the Staff's databases using Excel VLOOKUP.

Mumbai, Maharashtra, In

• Extracted Data by creating Views from Oracle SQL to prepare the data layer for Tableau reporting.• Performed data cleansing using Python (Pandas, NumPy) and created visualizations to analyze Debit Card sales.• Built Tableau Dashboards to get customer insights, increasing the speed of analysis of Debit card sales by 10%.• Enhanced the performance of the existing Tableau dashboards by implementing data validation.• Led a team of 6 new hires in a dashboard migration project from Power BI to Tableau with 100% data integrity.

Master Of Science - Ms, Information Technology And Management With Specialization In Bi Analytics

Bachelor Of Engineering, Information Technology

Computer Science