SUBHAJIT GHOSH
Business Analyst Enthusiast
Open to Work
About Me
Detail-oriented Business Analyst Enthusiast with a solid foundation in analytics, technical skills, and leadership. Specializing in statistical analysis, data visualization, and data-driven decision-making. Proven track record in creating efficient data pipelines and dashboards. Effective communicator with the ability to convey complex findings to diverse stakeholders. Committed to continuous learning and eager to contribute expertise to drive business growth and make a positive impact.
Technical Skills
• Python
• R programming
• SQL
• Excel
• Snowflake
• AWS
• Power BI
• Tableau
• Google Analytics
• Statistics
• Machine Learning
• Marketing
Soft Skills
• Leadership
• Problem solving
• Critical thinking
• Communication
• Presentation
• Negotiation
• Attention to detail
• Teamwork
• Research
• Creativity
• Innovative
• Active listening
Projects
Retail Data AnalysisOptimized data processes, conducted thorough EDA, established KPIs, and implemented an intuitive dashboard, cutting reporting time by 50% and enhancing decision-making accuracy for more informed business strategies.
Czechoslovakia Banking Financial Data Analysisexecuted AWS-to-Power BI end-to-end data transformation, achieving a 15% reduction in operational costs and a 20% increase in profitability through dashboard development
IPL DashBoardProvided HR managers with actionable insights to enhance workplace dynamics, decrease attrition rates, and informed decision-makers on factors like age, salary, job satisfaction, and work-life balance correlating with employee attrition.
TCS Financial Analysis in One Page Conducted analysis on sales growth, gross profit margins, and EBITDA margins (March 2019 to March 2023), explored shareholder structure (Tata Sons holding 72.27%), examined key management remuneration, and achieved project objectives by extending market reach and implementing impactful marketing strategies.
Marketing & Execution for Myglamm in SeekhoImplemented data-driven marketing techniques, spearheaded marketing and execution to elevate brand presence, boost sales, achieve project objectives, and extend market reach through impactful strategies.
Experience
Urgence
Marketing Analyst and Strategist
Jun 2022 – Jul 2023• Developed and executed strategic initiatives for B2B and B2C healthcare clients, enhancing operational efficiency by 35% and revenue by 15%.
• Analyzed intricate healthcare data for meaningful insights, fostering data-driven decisions.
• Collaborated on cross-functional teams for market trends, competitive intelligence, and innovation.
• Played a vital role in urgency management, ensuring swift responses to critical healthcare situations.
ABFR Ltd – Pantaloons
Sale and Operation Intern
May 2022 – Jun 2022• Conducted comprehensive market research, including analyzing customer feedback, and implemented a customer satisfaction survey.
• Achieved a 20% sales increase and enhanced customer satisfaction.
• Worked as a cashier at the cash counter, actively participating in inventory management, and collaborated closely with the sales and marketing team.
Shining Tomorrow Foundation
Business Analyst Intern
Apr 2021 – Jul 2021• Analyzed social media accounts, used advanced analytics to identify growth opportunities.
• Developed innovative strategies that boosted followers by 10,000 in three months, resulting in a 25% increase in brand awareness.
• Collaborated with a cross-functional team to implement effective marketing strategies, leading to a 30% rise in donor contributions.
Certifications
• Full Stack Data Analyst - Ineuron• Advance Business Analytic Skills - LinkedIn Learning• Power BI Data Analyst (PL-300) Associate Cert Prep: Manage Workspaces - LinkedIn Learning• Advance Excel - Grant Thornton• Integrated Marketing Communications: Advertising, Public Relations, Digital Marketing and more - Coursera• Marketing Foundations: Analytics - IIBA• Using Tableau to Discover Powerful Business Insights - LinkedIn Learning• Data Science with Python - Simple Learning• IBM SPSS Modeler V18.2.x Essentials - IBM
Achievements
• Secured 1st place in an IBM-hosted competition at LPU.• Recognized as Best Performer during internship at Shining Tomorrow Foundation.• Awarded 1st prize in Youth Parliament at Gangajalghati High School.
Education
Lovely Professional University, Punjab (2020 – 2024)
Integrated BBA - MBA: Business Analyst & Marketing
CGPA: 8.05Chousal High School, Bankura (WBCHSE) 2018 - 2019
12th Percentage: 70%Chousal High School, Bankura (WBBSE) 2016 - 2017
10th Percentage: 80%