Johnjose M

Ashley furniture India private limited

Apr 2024 - Present • Current

Developed HR and Sales analytics dashboards in Power BI, enhancing decision-making speed by 30% through governed, Row-Level Security (RLS)-enabled models and user-friendly self-service reports. - Automated scheduled reporting processes using SQL and Power Automate, reducing manual effort by over 20 hours per month while standardizing data refresh cycles, alert notifications, and access controls. - Delivered ad-hoc HR insights within 24 hours, ensuring high report accuracy and reliability by implementing rigorous data validation checks and maintaining strict issue resolution SLAs. - Integrated multiple data sources including SharePoint lists and SQL Server databases; thoroughly documented data lineage, definitions, and dashboard usage to boost user adoption and data governance.

Eltech Appliances Pvt. Ltd

Jul 2023 - Mar 2024 • 0.7 yrs

Designed and implemented MIS packs and executive dashboards using Power BI and Excel, centralizing key performance indicators (KPIs) and standardizing templates for weekly and monthly reporting cycles. - Developed repeatable data preparation workflows with Power Query and SQL Server, enhancing data integrity by incorporating validation rules and exception logging. Reduced data processing errors by approximately 25% through automated validation and error-tracking mechanisms.

SB TVS Industrial Ventures Private Limited

Feb 2022 - Jul 2023 • 1.4 yrs

Developed operational performance dashboards to enhance data visualization and decision-making. - Automated ERP-to-report data pipelines using Power Query, reducing manual effort by 30%. - Scheduled automated report exports to ensure timely data availability for stakeholders. Collaborated with cross-functional teams to define key performance metrics, improving report accuracy and relevance. - Streamlined report delivery processes, increasing report timeliness by 25%.

Spare Mind solutions (Div.of Lucas-TVS Limited)

Nov 2018 - Feb 2022 • 3.3 yrs

Managed inventory and logistics data to ensure accuracy and completeness of stock records. Developed and maintained Excel-based trackers to facilitate timely and precise reporting. Enhanced data accuracy, contributing to a 55% reduction in stock discrepancies and improved supply chain efficiency.