Open To Work
SHOBHIT RAJAK
IPG MediaBrand
Pune
Work Preference
Job Search Status:
Open to work
Desired Job Title
Data AnalystBusiness Analyst
Work Type
Full Time
Location Preference
RemoteHybridOn-Site
Location:
Pune, IndiaBengaluru, KAMumbai, MHGurgaon, HRDelhi, DL
Open to relocation:
Yes
Minimum Desired Compensation
₹100000/yr
5
Years of experience
2
Languages
Data and Business Analyst with 4+ years of experience in SQL-driven analysis, database administration, business requirement analysis, application support, and operational reporting, leveraging structured data to identify business insights and process improvement opportunities.
Work History
Delivery Analyst
1 Year 5 Months- Analyzed quarterly and annual media plans to evaluate planned spend, campaign
performance, profitability, and business objectives, converting complex planning
data into structured analytical insights for stakeholders. - Developed interactive dashboards and visual reports to simplify media-plan
analysis, enabling stakeholders to monitor key performance indicators, identify
trends, and understand campaign-level performance more effectively. - Performed profitability and loss analysis across media plans, identifying potential
drawbacks, cost inefficiencies, and performance gaps that could adversely affect
business outcomes. - Provided data-driven recommendations to clients and stakeholders by
identifying areas of underperformance and suggesting optimization
opportunities to improve campaign efficiency, profitability, and overall business
returns. - Prepared and maintained MIS reports, KPI dashboards, and analytical outputs
using Power BI/Excel/Tableau, enabling stakeholders to monitor delivery status,
campaign performance, quality indicators, and operational trends.
Application Support Engineer
2 Years 2 Months- Managed 2 database platforms, Oracle and MySQL, maintaining high availability and implementing performance-tuning and backup/recovery practices that improved overall database reliability by ~30%.
- Optimized SQL queries and database operations, reducing query execution time by ~20% and enhancing application responsiveness and processing efficiency across production workloads.
- Monitored application and infrastructure environments across 3 platforms - Dynatrace, Nagios, and AppDynamics, identifying bottlenecks and contributing to an estimated ~8.9% improvement in overall system efficiency.
- Automated recurring Linux operational activities using Python scripting, reducing manual intervention by ~50% and saving approximately ~20 hours per month across routine workflows.
- Handled L1/L2 support for mission-critical applications, resolving approximately ~7 incidents per month while maintaining 94% SLA compliance and minimizing service disruption.
- Performed root-cause analysis on recurring incidents, executing corrective and preventive actions that strengthened application stability and reduced the likelihood of repeated failures.
- Collaborated with database, application, and infrastructure teams to investigate technical bottlenecks, accelerate issue resolution, and introduce preventive measures across critical workflows.
- Standardized troubleshooting procedures and technical documentation, strengthening knowledge sharing, shortening resolution cycles, and establishing consistent support practices across the team.
Developer
9 Months- Conducted detailed defect and stability analysis across the application codebase, driving corrective actions that reduced application crashes by 40% and improved overall system reliability.
- Performed structured code and solution reviews to identify quality gaps, inconsistencies, and improvement opportunities, contributing to a 50% reduction in defects and a 30% improvement in application stability for a user base of approximately 200,000.
- Managed 40+ production deployments with a 99%+ success rate, coordinating release activities, validating deployment outcomes, and supporting controlled production delivery.
- Analyzed inter-service communication and application workflow dependencies to identify process bottlenecks, supporting architectural changes that reduced synchronous dependencies and improved application responsiveness.
- Collaborated with customer-facing and technical stakeholders to understand business requirements, refine feature expectations, and align delivered functionality with customer needs and user-experience objectives.
- Evaluated application engagement and usability metrics following interface and navigation improvements, contributing to a 30% increase in user engagement, 15% reduction in bounce rate, and 30% growth in mobile user engagement.
Education
Bachelor of Commerce
10+2 - Commerce
Skills
Data Analytics
Python
Pandas
SQL
Exploratory Data Analysis (EDA)
Data Cleaning
Data Validation
Statistical Analysis
Hypothesis Testing
Root Cause Analysis (RCA)
KPI Analysis
Digital Analytics
Data Storytelling
Business Intelligence & Visualization
Power BI
DAX
Power Query
Dashboard Development
Data Modeling
Data Visualization
KPI Reporting
MIS Reporting
Tableau
Excel
Pivot Tables
Adobe Analytics
Data Engineering
ETL
ELT
Data Pipelines
Data Warehousing
SQL Optimization
Business Analysis
Requirement Gathering
Business Requirement Analysis
BRD
FRD/FRS
User Stories
Acceptance Criteria
Business Rules
Process Mapping
AS-IS / TO-BE Analysis
Gap Analysis
UAT
Stakeholder Management
Domain & Delivery
ERP
Procurement
Demand Planning
Supply Chain
Transaction Monitoring
Financial Crime
Agile
JIRA
Automation
Microsoft Graph
Miscellaneous
MIS
Data Pipeline
HLOOKUP
AI & LLM Models
SAS
GitHub
Git
ServiceNow
Asana
Notion
Snowflake
LANGUAGES
Hindi: Native
C2
Bilingual or Proficient
English: Advanced
C1
Advanced
Projects
Fraud Detection Banking System:
Developed and deployed a Django-based fraud detection system leveraging data science and deep learning techniques to analyze banking transactions and identify potentially fraudulent activity., Performed comprehensive data preprocessing and validation, including missing-value treatment, feature encoding, and normalization, to prepare transaction data for model development and analysis., Partnered with financial crime and transaction-monitoring experts to refine a novel detection approach, enhancing model accuracy by 18% and aligning outputs with critical regulatory requirements., Integrated the model into a Django web application, enabling stakeholders to query, investigate flagged transactions, and interpret fraud-related insights through a user-friendly interface.
URL - https://github.com/Shobhitrajak98/Fraud-Detection-App.git
Timeline
Delivery Analyst
IPG MediaBrand
04.2025 - CurrentRead More
Application Support Engineer
Mindage Solutions
01.2023 - 03.2025Read More
Developer
LanceSoft
03.2022 - 12.2022Read More
Dr. Hari Singh Gour Central University
Bachelor of Commerce
Read More
KITS Academy
10+2 from Commerce
Read More