BI Data analyst

• Oct 2022 - Present

Sales Assistant and Deli Assistant

• Mar 2021 - Apr 2022

* Assisting customers to find what they are looking for while maintaining the floor well organized and presentable. * Managing multiple tasks like cashiering, floor maintenance, security, shelves restocking, customer support, etc. * Collaborate with other team members to provide the best shopping experience to customers. * Responsible for opening and closing of the shop * Ensuring excellent customer service is always provided by the whole staff * Managing stock and organizing orders to be fulfilled as required Show less

Data Analyst

• Feb 2020 - Jun 2020

• Statistical analysis of accidental insurance claims using IBM SPSS and Exploratory Data Analysis process. • Delivered 5+ SQL server-based ETL applications that improved critical reporting. • Worked on Power Bi for visualization report for sector-wise insurance sales in Madhya Pradesh, India, from 2018 to 2019. • Replaced and made proficient data extraction system from Source database to a data warehouse for better and immediate analysis processes. • Handling 2+ client calls daily, frequent interaction with 6+ development teams and Admin team. • Implemented BI solution for 10+ applications from the different data warehouses. Show less

Junior data Analyst

• Jun 2018 - Jan 2020

• Deployed 2+ applications that satisfy business-critical needs. • Lead team of 5 members for handling the production support of 10+ applications. • Implemented scd type 1 and type 2-dimension modeling using SSIS. • Well versed with data warehousing star schema. • Responsible for data migration and ETL tool migration. • Performing root cause analysis to evaluate the failure or diversions on implementation of ETL plans. • Creating and modifying SQL databases by using SQL server management studio. • Adding Tables, views, and stored procedures are among the database objects using SSMS. • Manage databases such as backup, restore, and maintenance plans using SSMS • Formation pivot tables using advanced Microsoft Excel, including VLOOKUP and other Excel methods. • Developed weekly and monthly reports and dashboards using Power BI for Sales, Marketing, and Business operations to reach better business decisions and initiatives. Show less