Karan Mahajan
Noida
Summary
Results-driven Business Intelligence Analyst recognized for maximizing productivity and efficiency in delivering data-driven insights. Expertise in data warehousing, predictive analytics, and visualization techniques enhances decision-making processes. Proven skills in critical thinking, problem-solving, and effective communication facilitate clarity in complex scenarios. Aiming to leverage analytical acumen to drive strategic growth within a forward-thinking organization.
Overview
7
7
years of professional experience
Work History
Quality Analyst – Studio A
Hogarth India Pvt Ltd
Gurugram
05.2023 - Current
- Tested websites for numerous Apple projects, from the iPhone 15 launch to the iPhone 16 launch, involving functional, regression, smoke, and sanity testing.
- Reported hundreds of bugs for the websites on multiple platforms, involving desktop and iPhone.
- Produced test scripts for new automated software testing rounds.
- Analyzed hundreds of bugs and created a bug repository, which improved the quality of testing for the websites.
- Created numerous test cases for bug reporting and the automation process.
- I analyzed the team’s efficiency from data collected through the client side, which improved the performance of the team by 15 percent.
- Maintained quality assurance procedure documentation.
- Monitored bug resolution efforts and tracked successes.
- Created and maintained database of common and known testing defects.
- Documented, triaged, and managed defects in software and worked with developers to facilitate timely resolutions.
- Trained personnel on proper use of tools, equipment, materials, and software used for quality assurance purposes.
- Worked with Agile and Scrum methodologies to accomplish project milestones and meet demanding timelines.
- Completed day-to-day duties accurately and efficiently.
Maintenance Engineer
Mitsubishi Elevators India Pvt Ltd
Delhi
10.2017 - 11.2020
- Solved breakdown of numerous Elevators in South Delhi Region
- Analyzed breakdowns of numerous elevators and improved material efficiency by 12 percent
- Improved the quality of Elevator maintenance by 15 percent by data collected from breakdowns
- Improved team efficiency by 20 percent by investing in team training and involvement
- Reduced the breakdown response time by 20 percent
Education
B.Tech - Electrical and Electronics
Uttar Pradesh Technical University
07-2017
12th -
St. Andrews Public School
Agra01.2012
10th -
St. Francis Convent School
Agra01.2010
Skills
- Excel (VLOOKUP, Conditional Formatting, Pivot Tables)
- SQL (SQL Server, MySQL)
- Python (Pandas, NumPy, SciPy, Matplotlib, Seaborn)
- Tableau
- Microsoft Power BI
- Visual data representation
- Business needs analysis
- Data utilization
- Git
- Business acumen
- Data cleaning
Projects
Sentiment Analysis on Product Launch - Company Project, June 2024
Utilized Python to conduct sentiment analysis on 10,000 reviews across six geographies
Performed data cleaning and text analysis to identify major product complaints
Applied regression and machine learning techniques to develop a final model achieving 91% accuracy and a 35% lift
Team Efficiency Analysis – Company Project, January 2024
Utilized Structured Query Language (SQL) to extract data from eight related tables in Employee databases using JOIN and VIEW techniques
Transformed and filtered data using aggregation and filtering functions to enhance the reporting process
Utilized Python to load and visualize data, identifying key business insights to enhance team performance
Timeline
Quality Analyst – Studio A
Hogarth India Pvt Ltd
05.2023 - Current
Maintenance Engineer
Mitsubishi Elevators India Pvt Ltd
10.2017 - 11.2020
B.Tech - Electrical and Electronics
Uttar Pradesh Technical University
12th -
St. Andrews Public School
10th -
St. Francis Convent School
Similar Profiles
YASIN MYASIN M
QA Lead at WPP Marketing Communications India Pvt Ltd (Hogarth Division)QA Lead at WPP Marketing Communications India Pvt Ltd (Hogarth Division)
Randhir Kumar PrasadRandhir Kumar Prasad
Stacker at Engineering and Allied Services Pvt. Ltd, Lift & Shift India Pvt. Ltd, Roadwings International Pvt. Ltd, Western Carriers India Pvt. Ltd, Tractor India Pvt. Ltd, Transworld Terminal Pvt. LtdStacker at Engineering and Allied Services Pvt. Ltd, Lift & Shift India Pvt. Ltd, Roadwings International Pvt. Ltd, Western Carriers India Pvt. Ltd, Tractor India Pvt. Ltd, Transworld Terminal Pvt. Ltd
Viraja ParanjapeViraja Paranjape
Associate Director, Financial Risk Remediation at UBS Business Solutions (India) Pvt. Ltd. (Erstwhile Credit Suisse Services (India) Pvt. Ltd.)Associate Director, Financial Risk Remediation at UBS Business Solutions (India) Pvt. Ltd. (Erstwhile Credit Suisse Services (India) Pvt. Ltd.)
Prashant KashyapPrashant Kashyap
Consultant at TATA CONSULTANCY SERVICESConsultant at TATA CONSULTANCY SERVICES
Amartya SharmaAmartya Sharma
Web Analyst at Munivar Online Pvt LtdWeb Analyst at Munivar Online Pvt Ltd