How I switched my career track from Business Analysis to Data Analysis?
From a Business Analyst role I never asked for to a Data Analyst career I love.
TL;DR
How I went from an accidental Business Analyst at TCS to a Data Analyst, by way of Excel, VBA, R, Python and one project I automated myself out of.
After I graduated from NIT Jalandhar in 2010, I secured campus placement in Tata Consultancy Services. After the Initial Learning Program in Trivandrum, Kerala, I was posted to Mumbai. Even though I was in the top 10 in my ILP batch for Java/J2EE development, I was assigned the role of a Business Analyst (BA) in TCS’s Talent Acquisition Business Analysis team. To be honest, I didn’t even know such a role existed! So the hesitation in my mind existed since the beginning. Only 5 out of the 30+ batch was given Business Analysis roles. The reason for this (which my supervisor told me after almost 4 years) was that my communication was better than most in that batch.
However, I gave it my best and became a top performer. What enabled me to perform well was that my technical inclination in addition to my communication and writing skills allowed me to become an expert in translating business requirements into functional specifications (which is the primary responsibility of a BA). Due to my interest in systems and databases, I used to spend more time with the Development team (which was, luckily, colocated). This also enabled me to be a thorough tester which ensured minimum defects in User Acceptance Testing (UAT). This satisfied my technical interest to some degree but job satisfaction wasn’t high. I tried to mitigate that feeling by writing a few SQL scripts for some stored procedures and data-fix SQL scripts here and there, which was completely off-track for a BA.
There weren’t many job openings for Business Analysts then, so I made the mistake of not actively looking for other opportunities. The popular quote “Hindsight is 20/20” rings true in this case. Then I got married in January 2015 and the responsibilities of managing a family kicked in. Mumbai is a fine city but very expensive!! I and my wife stayed in Mumbai for a year after marriage but realized that Mumbai was unsustainable at our current salary levels so we moved to Bengaluru. It was at this time that I planned to change tracks as I had gotten bored of Business Analysis. I got released from the project as my supervisor found it challenging to manage remote team members!! This was pre-covid so nobody could challenge this reasoning. This opened up a very real opportunity to change my career track.
Since I had no “official” development experience, I got no development roles. I had to tweak my resume to highlight my technical achievements within my business analysis roles. I found a Reporting Analyst role in a team that managed IT services for Cisco. I was assigned a task to analyze tickets and create operational performance reports. I realized this was my time to shine. I quickly put all my knowledge of Excel and VBA to streamline their daily and weekly reporting. To automate the process, after some negotiation, I was given access to the SAP Business Objects reporting module. I fully automated the reports, created a dashboard for clients and in my enthusiasm, automated myself out of the project!! I still shake my head today thinking about this. How naive was I!
I was then assigned to the Cisco Webex project as a Business Analyst but was released in 2 weeks due to budget constraints. But then, I found a proper Data Analyst role in a Cisco project having a wonderful team of data scientists. The lead scientist gave me 1 month to learn the R language and machine learning. Up until then, I hadn’t even heard of R. After watching a couple of videos on YouTube, I fell in love with it. The things I used to do with multiple lines of VBA could be done in a few characters in R. I was smitten!
I followed the “Learning by Immersion” method to learn quickly. I followed the #rstats hashtag on Twitter, followed R developers and data scientists on Twitter and LinkedIn, joined R communities on Facebook, subscribed to R newsletters and read Statistics and ML books implemented using R. Anytime I looked at my phone, I would read R-related content or tips & tricks. I was not only immersed, I almost drowned in R. Work became Play! Then, I was assigned some data cleaning and analysis activities and when I presented my results, they realized my presentation skills were good and started giving me PowerPoint work to create use cases. We bagged the deal but were not allowed to implement it. I quickly realized I was getting sucked into the same spiral and decided to change my organization.
I then found a job with ExxonMobil in the Safety, Security, Health and Environment (SSHE) department as a proper Data Analyst. I ensured I didn’t automate myself out of a job or anybody else but strived to bring up the entire team. A quick small win was an Excel Add-In that converted event IDs into hyperlinks linked to the internal incident tracking system, which gave me quick recognition across the India and US teams. I automated the reporting work just enough to free up time to do more pro-active insights reporting rather than plain reporting. During this time, I got the opportunity to learn GIT version control and implemented an R package which generated ExxonMobil-branded reports along with another developer from Houston, TX. This was a great learning experience. The git version control along with R knowledge allowed me to dip my toes into the exciting ocean of opportunities presented by the Opensource R Package Developers community. I made a few submissions (PRs) towards the R packages which I used a lot i.e. openxlsx and croquet. It was an enriching and delightful experience. I was also trained in Tableau and PowerBI but management was undecided on which one to take up as the official reporting tool.
At ExxonMobil SSHE, we, as a team, greatly minimized the time spent on weekly and monthly reports, which brought recognition and awards. It also brought more opportunity as we became notorious for automation and were tasked with automating monthly and quarterly reports for the Managing Committee. This is where the lead analyst (seated in Houston, TX) brought in Python and a few members from our Data Analysis team (including myself) took up the challenge to learn Python and manage the monolithic Jupyter notebook containing almost a thousand lines of code. Then the Lead Analyst from TX left the organization and the responsibility fully came to our team. This went on for a few months and then Covid hit!!
Work from Home was established and 6 months passed in a blink. The Great Resignation started and half of our team resigned over a period of 4 months. Unfortunately, my father got infected and had to be hospitalized. It was a challenging time, both family and job-wise. With no promotion or increments in sight, I reluctantly decided to switch companies and luckily found a job close to home and double the salary in Bengaluru in LTIMindtree (was just Mindtree in 2021). Bengaluru’s traffic is so crazy, that distance to work is a real criterion while looking for jobs. This job was god-sent!
Now, it has been 2 years since I joined LTIMindtree as a Data Analyst and feel good about making the transition successfully. As I reflect on my journey, I’m filled with a profound sense of hope and excitement for what lies ahead. Every twist and turn in my career path has taught me invaluable lessons in resilience and self-discovery. The transitions, the challenges, and the triumphs have all shaped me into the person I am today. With each step forward, I’ve embraced change with unwavering determination, knowing that every opportunity brings new possibilities for growth. As I look towards the future, I am eager to continue exploring new horizons, fueled by the belief that every stride forward holds the promise of adventure and fulfilment. With optimism in my heart and courage in my soul, I eagerly anticipate the journey ahead, ready to embrace whatever challenges and opportunities come my way. Someone rightly said “Raste tumhare kadam chumegi, ek kadam aage toh badhao” which translates to “The path will kiss your feet, at least take the first step”.
Originally published on LinkedIn on March 11, 2024.