Kusala J

Executive IT and Data Analyzer

Sri Lanka Technological Campus • Tiempo completo

Sep 2020 - Present • 6 yrs 1 mo

Professional Overview & Job History Company: George Steuart Health (Pvt) Ltd Role: Junior IT Executive (Data & Excel Solutions Specialist) Tenure: 2020 – Present Core Responsibilities & Key Performance Areas (KPAs) Corporate Data Management & Infrastructure Support Serving as the primary point of contact for departmental data architecture, ensuring that massive datasets regarding pharmaceutical distribution, sales metrics, and inventory levels are meticulously organized and accessible. Bridging the gap between raw IT database outputs and actionable business intelligence for executive-level management and departmental heads. Maintained absolute data integrity across diverse data streams by implementing rigorous validation protocols, eliminating errors in reporting by up to 95%. Advanced Analytics & Complex Formula Architecture Designing and implementing complex, multi-tiered formula frameworks using advanced lookup functions such as XLOOKUP, INDEX/MATCH, and OFFSET to create dynamic, cross-referenced data structures. Utilizing conditional logic tools like SUMIFS, COUNTIFS, and AVERAGEIFS to extract highly specific, filtered metrics from massive corporate transaction logs. Deploying next-generation dynamic array formulas and LAMBDA functions to build highly scalable models that recalculate instantly without sluggish performance. Executive Dashboard Design & Visual Intelligence Developing professional-grade, interactive executive dashboards that provide directors and senior managers with a real-time snapshot of company health and sales performance. Integrating advanced formatting, custom charting, and structured grids to translate dry financial and operational metrics into visually striking, intuitive visual stories. Implementing user-friendly navigation systems within workbooks, allowing non-technical stakeholders to effortlessly interpret complex logistical data.