Friday, December 13, 2024

From Knowledge Analytics to Actual-Time Reporting: My Skilled Journey

I’m Chetan Sharma, currently residing in Gurgaon, Haryana. During the past five years, I have developed a profound understanding of the field, acquiring expertise in tools such as MS-Excel, Power BI, and Power Automate, with certification directly from Microsoft.

Beyond the domain of information assessment, I have a passion for sports. With a sense of pride, I’ve had the honor of playing for Haryana State in national-level soccer tournaments, demonstrating my commitment to the sport and its demands. With a personal passion project of over a year in studying boxing, I’ve found both physical and mental benefits to be an enriching experience for me.

With a strong background in information analytics, I seamlessly integrate my professional pursuits with a passion for sports, fostering a holistic approach to personal growth and professional development. 

Prior to commencing my journey, I was deeply embedded in a senior role at FIS International Companies. As a senior analyst within the Enterprise Intelligence and Digital Transformation group, my primary responsibility entailed developing influential solutions tailored to meet the unique needs of our clients. In particular, I led the initiative to design and develop custom Energy BI dashboards that catered to the unique needs of our customers. This role further refined my technical expertise while cultivating my ability to distill complex data into practical recommendations, ultimately informing strategic business decisions.

I decided to join the Nice Studying program to accelerate my career growth by acquiring new skills and expertise. Following a three-year stint within the corporate sphere, I felt an insatiable urge to broaden my intellectual horizons by venturing into the realm of Knowledge Science, which I saw as a natural extension of my analytical roots.

What resonated with me most about Knowledge Science was its extraordinary capacity for revolutionizing decision-making by extracting profound understandings and informed conclusions from vast amounts of raw data. My innate curiosity prompted me to explore a wide range of study paths, including certificate programs offered by renowned institutions such as the Indian Institutes of Technology (IITs). Notwithstanding the numerous relaxing activities, Nice Studying truly shone through. The endorsement from a respected senior colleague, having previously held the esteemed position of Lead Knowledge Scientist at CitiBank, played a crucial role in cementing my decision. The trainees’ testimonials and guidance solidified the reputation of Nice Studying for delivering exceptional and reliable educational experiences.

As I explored Nice Studying’s offerings, I was particularly struck by the thoughtfully designed curriculum, carefully constructed schedules, and exposure to cutting-edge industry programs. These modules offered a comprehensive learning experience, seamlessly integrating theoretical foundations with practical applications.

What stood out most was the impressive professional assistance offered by Nice Studying. Upon completing my education, I felt a profound sense of security knowing that various career paths were within reach, fostering unwavering trust in my decision-making process and making Nice Studying an obvious choice for me throughout my academic tenure.

My expertise in Nice Studying has stood out uniquely. Through their expertise, they’ve empowered me to unlock my true capabilities by providing unparalleled access to the complexities of the information science industry. With their encouragement, I successfully revitalized my academic pursuits following a five-year sabbatical subsequent to earning my graduate degree. Throughout this system, I acquired profound insights into Python programming, the pivotal role of statistics in shaping business decisions, and much more besides.

What particularly impressed us was the unwavering support provided by the system administration team, always ready to lend a hand, and the mentors’ tireless efforts to clarify any misunderstandings and ensure conceptual clarity.

This system has had a profound impact on both my professional trajectory and personal growth. This professional training enabled a significant career advancement by shifting my skill set from MS-Excel and Power BI towards expertly crafting in-built reporting solutions using Python, SQL, and Tableau. Through this transition, I’ve streamlined processes by leveraging SQL Server to extract data, reprocessing it with Python, and crafting dynamic dashboards tailored to meet the specific needs of enterprise and higher-level administrators.

This shift not only minimises human effort previously invested in guide report preparation, but also automates tasks, thereby optimising resource allocation across the organisation. For me, this pivotal moment marks the culmination of diligent study efforts, enabling me to proactively respond to shifting industry demands while streamlining workflow and amplifying productivity in my role.

At Airtel Worldwide LLP, a key challenge arose within the Airtel Cash division, specifically with managing suspicious transactions identified by SAS analytics programs. Across a customer base of 150 million spread across 14 countries, our system processes approximately 15 million alerts on a monthly basis. Without real-time visibility into Service Level Agreement (SLA) performance, critical issues went undetected and unresolved for an extended period. To avert potential revenue losses, it was crucial to swiftly resolve these alerts, which directly impacted income, within the agreed-upon timeframes.

Utilizing Knowledge Science methodologies, I successfully addressed the SLA reporting issue within Airtel Worldwide LLP’s Income Assurance Compliance department. To address the inherent limitations of month-to-month data analysis within Microsoft Excel, where manual processing consumed 72-96 hours due to the sheer volume of information, I developed a solution. Initially, I established an analogy between a SQL database and a Jupyter notebook, then developed a course structure to create cumulative learning experiences for the 14 participating countries, completing the task within 15 minutes. Building on the insights gleaned from the Service Level Agreement (SLA) experiences, I created a comprehensive Tableau Dashboard that offers a panoramic view of global performance metrics by week, as well as the analysts responsible for addressing each alert. This streamlined strategy not only accelerated reporting, but also significantly enhanced visibility and monitoring capabilities, thereby empowering proactive administration of suspicious transactions and ensuring the integrity of revenue streams.

The introduction of the novel reporting platform generated substantial benefits for our team.

  1. Time Savings: By transitioning from manual, monthly Excel reports to daily automated reporting via Jupyter Notebook, approximately 3-4 days of human labor were freed up each month. Through this optimisation, the SAS/Airtel Cash team was able to efficiently allocate resources, ultimately ensuring the successful satisfaction of all Service Level Agreement (SLA) targets.
  2. Enhancing Efficiency in Monitoring: By integrating SLA outcomes into the Tableau dashboard, we gained valuable insights into how analysts handle alerts, previously an overlooked aspect. The introduction of this solution enabled the company to effectively identify brokerages struggling with alert management, thereby allowing for targeted support and guidance programs that ultimately boosted overall operational performance.
  3. Operational Efficiency: The streamlined reporting process and enhanced efficiency monitoring capabilities of this initiative drove overall effectiveness within the Income Assurance Compliance group.

As progress is made in moving forward, initiatives are being implemented to further intensify reporting cadence, with the ultimate goal of disseminating insights on a near-real-time basis. Our relentless pursuit of innovation showcases our commitment to harnessing the power of Knowledge Science in driving continuous improvement and business excellence?

Related Articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest Articles