Satyam Chauhan
Gurgaon
Summary
Experienced Senior Business Development Executive transitioning to Data Analyst, skilled in leveraging insights for strategic decisions and process optimization. Proficient in analytical tools, trend analysis, and delivering actionable recommendations. Strong background in market analysis, stakeholder communication, and data analysis, ready to support data-driven decision-making.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Senior Business Development & Marketing Executive
All E Technologies
07.2020 - 02.2024
- Data Management & Strategic Insights (SQL, Python, Advanced Excel): Led the organization and analysis of large datasets using SQL and Python, coupled with advanced Excel techniques such as pivot tables, VLOOKUPs, and complex formulas to drive actionable business insights. Created automated dashboards in Tableau to track KPIs, contributing to a "35% improvement" in lead conversion and revenue growth.
- Lead Generation & Sales Forecasting (SQL): Utilized advanced Excel for data modeling and trend forecasting, integrating SQL and Python for deeper analysis of lead data. Optimized the CRM system to track lead behavior, driving a "15% increase" in qualified leads and boosting forecast accuracy by "25%.
- Campaign Analytics & Optimization ( Advanced Excel): Automated marketing data extraction processes using Python, with advanced Excel functions to conduct granular performance analysis. Resulting in a "12% increase" in engagement rates and a "10% uplift" in web traffic.
- Market Research & Business Strategy (SQL, Python, Excel): Conducted market research using SQL for data retrieval, Python for trend analysis, and Excel for financial modeling, identifying new business opportunities that fueled a "20% rise" in revenue.
Senior Credit Analyst
Creditas Solutions
01.2020 - 06.2020
- Credit Risk Evaluation & Modeling (SQL, Python, Advanced Excel): Utilized SQL and Python to develop predictive models for credit risk assessment, and employed advanced Excel for in-depth data analysis and scenario modeling. This contributed to a "15% improvement" in creditworthiness accuracy and reduced default rates by "10%".
- Financial Reporting & Data Analytics (SQL, Advanced Excel): Extracted financial data using SQL and automated reporting with advanced Excel features such as macros and complex formulas. Presented key findings via Tableau reports, accelerating loan processing time by "20%" and improving risk evaluations.
- Customer Profiling & Risk Mitigation (SQL, Python, Advanced Excel): Leveraged SQL and Python for customer data analysis, using Excel data validation, pivot tables, and conditional formatting to refine borrower risk profiles. This reduced loan delinquencies by "8%" and enhanced credit decision accuracy.
Education
MBA - Marketing & Operations
GL Bajaj Institute of Management & Research
Greater Noida, India07.2021
Bachelor of Technology - Computer Science And Engineering
Amity University
Noida, India05.2019
Skills
- Data Visualization (Power BI, Tableau)
- Performance Metrics Analysis (Excel, Advanced Formulas, Pivot Tables)
- Data Analysis and Reporting (SQL, Python)
- Email and Direct Mail Marketing Campaigns
- Data Cleaning and Preparation (Excel, Python)
- Statistical Analysis (Python, Excel)
Certification
- Complete SQL Bootcamp from Udemy
- Complete Data Analyst Bootcamp from Udemy
- Data Analytics with Python from IBM
Projects
- Music Store Data Analysis (using SQL)
This project involves analyzing sales data, customer behavior, and market trends to optimize business performance and improve decision-making.
Key metrics were:
1. Sales Growth Rate: Monitor sales growth over time.
2. Customer Retention Rate: Measure how well customers are retained.
3. Top-Selling Products: Identify the most popular albums, artists, and genres.
- HR Analytics Dashboard Project (Using Power BI)
This Project focuses on gathering, analyzing, and visualizing HR-related data to provide insights into workforce management, employee performance, and organizational efficiency.
Key metrics were:
1. Headcount: Number of employees by department, gender, age group, etc.
2. Turnover Rate: Percentage of employees leaving the organization in a given period.
3. Employee Satisfaction: Engagement scores from employee surveys.
4. Time-to-Hire: Average time it takes to fill open positions.
Timeline
Senior Business Development & Marketing Executive
All E Technologies
07.2020 - 02.2024
Senior Credit Analyst
Creditas Solutions
01.2020 - 06.2020
MBA - Marketing & Operations
GL Bajaj Institute of Management & Research
Bachelor of Technology - Computer Science And Engineering
Amity University
Similar Profiles
Abhinav MishraAbhinav Mishra
Associate Consultant at All E TechnologiesAssociate Consultant at All E Technologies
Vyankatesh WakharkarVyankatesh Wakharkar
Team Lead at Tata Technologies Ltd, Tata Technologies LimitedTeam Lead at Tata Technologies Ltd, Tata Technologies Limited
Ayush SinghAyush Singh
Client Partnership Manager at Tyroo Technologies Ltd (Divison of Smile Internet Technologies Ltd)Client Partnership Manager at Tyroo Technologies Ltd (Divison of Smile Internet Technologies Ltd)
Smriti RanaSmriti Rana
Technical Architect & Lead at Builder.aiTechnical Architect & Lead at Builder.ai
Sakshi ShuklaSakshi Shukla
Supervisor (C9) at Citi Corp ServicesSupervisor (C9) at Citi Corp Services