Mohan Kumar
@mohankumar1
Immediate Joiner|| Business Analyst @ Affine || NIT Jamshedpur’22
What I'm looking for
I'm Mohan Kumar from India, and I completed my B-Tech at the National Institute of Technology (NIT) Jamshedpur in 2022. Following that, I joined Affine as a Business Analyst, where I worked for 1.5 years.
During my tenure at Affine, I delved into data and analytics using technologies like Excel, SQL, Cosmos DB, and Power BI. I actively contributed to two significant projects: Microsoft Bing Ads and Microsoft Azure Campaign Analytics.
In the Bing Ads project, I conducted comprehensive assessments of Ads, analyzing key performance indicators (KPIs) such as click-through rates (CTR), conversion rates (CVR), and cost per acquisition (CPA). This provided valuable insights for advertisers and publishers to gauge the performance of their ads on the platform. Additionally, I designed and executed A/B tests on ad copy, optimizing messaging strategies and resulting in increased ad engagement and conversions.
For the Azure Campaign Analysis project, I led the identification of the target audience for the launch of the new product Microsoft Fabric (Trident). I conducted in-depth analyses of incremental impacts on user engagement using A/B testing and performed statistical significance tests on KPIs such as Daily and Monthly Active Users, Conversions, Activations, Retention, Revenue, and Usage. Furthermore, I collaborated with the team to automate reporting processes for skilling campaigns, reducing manual work and saving time.
Experience
Work history, roles, and key accomplishments
Business Analyst
Affine Analytics
Jun 2022 - Dec 2023 (1 year 6 months)
I joined Affine as a Business Analyst, working on two live projects. My role involved post-launch campaign performance monitoring, tracking various KPIs such as impressions, clicks, trail-to-paid conversions, and revenue using SQL and Cosmos DB. Subsequently, created visual representations of these KPIs using Power BI and delivered actionable insights to stakeholders for effective decision-making.
Business Analyst
Affine
Jun 2022 - Dec 2023 (1 year 6 months)
Analyzed Microsoft Bing Ads and Azure campaign performance, built Power BI and Excel dashboards, and automated reporting for 10+ campaigns reducing manual effort by 60% while improving insight delivery for optimization.
Education
Degrees, certifications, and relevant coursework
NIT Jamshedpur
Bachelor of Technology
2018 - 2022
National Institute of Technology, Jamshedpur
Bachelor of Technology, Metallurgical and Materials Engineering
2018 - 2022
Completed a Bachelor of Technology in Metallurgical and Materials Engineering from June 2018 to June 2022 with coursework and projects in materials engineering and data analysis-related tools.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Portfolio
github.com/Mohan81020Social media
Job categories
Interested in hiring Mohan?
You can contact Mohan and 90k+ other talented remote workers on Himalayas.
Message MohanFind your dream job
Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!
