About Me
Skilled Database Professional with 5+ years of experience in system operations, database administration, MIS reporting, data analysis, business Analysis and data mapping. Experienced with AI tools across various platform…
Skilled Database Professional with 5+ years of experience in system operations, database administration, MIS reporting, data analysis, business Analysis and data mapping. Experienced with AI tools across various platforms. Proficient in advanced Excel, SQL and complex formulas. Strong ability to leverage technology and leadership skills to optimize data management processes and support data-driven decision-making in dynamic environments.
Experience
MIS - Data Analyst, Data Management Specialist
Developed Advanced Reporting Dashboards in Power BI and Tableau to automate monthly, quarterly, and annual performance reports, enhancing data accessibility and decision-making for senior management in healthcare.
Implemented Data Validation & Cleansing Techniques using Power Query and Excel, ensuring data integrity for clinical and operational metrics, improving the accuracy of healthcare analytics and reporting.
Streamlined Financial Data Audits & Sales Reconciliation by automating data matching with advanced Excel functions (VLOOKUP, XLOOKUP, SUMIF, Macros) and Power Query, ensuring accurate closure of monthly account statements.
Built Consolidated Healthcare Data Models using Excel Power Pivot and Power BI, integrating clinical, operational, and financial data sources to enhance analysis and support data-driven decision-making.
Optimized Performance Reporting & Forecasting Models using Excel Macros, dynamic charts, and forecasting techniques, reducing report generation time by 40% and ensuring real-time updates on healthcare KPIs.
Collaborated with Cross-Functional Teams to deliver impactful presentations at Core Team Meetings (CTM), providing key metrics and actionable insights to drive continuous improvements in healthcare operations.
MIS - Data Analyst, Data Management Specialist
Developed Advanced Reporting Dashboards in Power BI and Tableau to automate monthly, quarterly, and annual performance reports, enhancing data accessibility and decision-making for senior management in healthcare. Implemented Data Validation & Cleansing Techniques using Power Query and Excel, ensuring data integrity for clinical and operational metrics, improving the accuracy of healthcare analytics and reporting. Streamlined Financial Data Audits & Sales Reconciliation by automating data matching with advanced Excel functions (VLOOKUP, XLOOKUP, SUMIF, Macros) and Power Query, ensuring accurate closure of monthly account statements. Experience with Al tools like ChatGPT, Gen AI and other AI. Built Consolidated Healthcare Data Models using Excel Power Pivot and Power BI, integrating clinical, operational, and financial data sources to enhance analysis and support data-driven decision-making. Optimized Performance Reporting & Forecasting Models using Excel Macros, dynamic charts, and forecasting techniques, reducing report generation time by 40% and ensuring real-time updates on healthcare KPIs. Collaborated with Cross-Functional Teams to deliver impactful presentations at Core Team Meetings (CTM), providing key metrics and actionable insights to drive continuous improvements in healthcare operations.
Merchandiser And MIS - Data Analyst Reports Specialist
Optimized MIS Operations by leveraging advanced Excel functions (XLOOKUP, NESTEDIF, CONDITIONAL, POWER PIVOTS, MACROS) and Google Sheets to generate weekly, monthly, and quarterly reports on sales, production, and inventory, driving strategic decision-making and KPI tracking.
Implemented Robust Data Management by executing data cleaning, validation, and consolidation techniques, ensuring a unified sales database. Enabled precise alignment of showroom stock with production schedules, improving inventory turnover by 20%.
Developed Advanced Dashboards & Reporting Tools using pivot tables, dynamic charts, and conditional formatting, improving SKU demand forecasting by 30% and providing real-time merchandising insights for decision-making.
Led Vendor & Supply Chain Coordination with data-driven stock allocation strategies, optimizing stock dispatch and delivery schedules, improving vendor performance, reducing stock-outs by 15%, and streamlining inventory replenishment.
Enhanced Production Efficiency through in-depth analysis of production data, identifying gaps in manpower, workflow, and processes. Recommended and implemented improvements, resulting in a 10% increase in operational productivity.
Strengthened Quality Assurance & Compliance by creating detailed production and sales MIS reports, resolving customer issues, aligning operations with business goals, and improving customer satisfaction ratings by 25%.
Executive
Defined clear goals, growth roadmaps, and strategic business plans to drive organizational success.
Stock order management can be planned using sales reports.
Conducted business forecasting to analyze trends and inform strategic decisions.
Developed and executed sales strategies to meet short-term and long-term revenue targets.
Merchandiser And MIS - Data Analyst Reports Specialist
Optimized MIS Operations by leveraging advanced Excel functions (XLOOKUP, NESTEDIF, CONDITIONAL, POWER PIVOTS, MACROS) and Google Sheets to generate weekly, monthly, and quarterly reports on sales, production, and inventory, driving strategic decision-making and KPI tracking. Implemented Robust Data Management by executing data cleaning, validation, and consolidation techniques, ensuring a unified sales database. Enabled precise alignment of showroom stock with production schedules, improving inventory turnover by 20%. Developed Advanced Dashboards & Reporting Tools using pivot tables, dynamic charts, and conditional formatting, improving SKU demand forecasting by 30% and providing real-time merchandising insights for decision-making.
Executive
Defined clear goals, growth roadmaps, and strategic business plans to drive organizational success. Stock order management can be planned using sales reports. Conducted business forecasting to analyze trends and inform strategic decisions. Developed and executed sales strategies to meet short-term and long-term revenue targets.