Pranay Shrivastava
@pranayshrivastava
Data Analyst skilled in SQL, Power BI, and Python—turning marketing and customer data into actionable insights.
ZimbabweWhat I'm looking for
I’m a Data Analyst with hands-on experience in Business Intelligence, Data Analytics, and Business Analytics, using SQL, Power BI, Excel, and Python to analyze large datasets and support data-driven decision-making. I’ve worked across end-to-end analytics—from data cleaning and transformation to KPI analysis, funnel insights, and stakeholder-ready reporting.
In my client-facing Digital Marketing Analytics engagement as a Data Analyst Intern, I analyzed 52K+ campaign records to identify customer behavior, acquisition patterns, and campaign performance insights. I built interactive Power BI dashboards and BI reports, and conducted data cleaning, validation, and marketing funnel analysis to uncover conversion drop-offs and recommend improvements. I also developed analytics projects covering marketing/customer engagement (including Python-based NLP sentiment analysis), banking customer risk/financial behavior segmentation, and sales performance intelligence with BI dashboarding and revenue trend insights.
Experience
Work history, roles, and key accomplishments
Built a marketing analytics and customer engagement dashboard analyzing 38K+ customer interaction records to evaluate campaign effectiveness and identify user abandonment across conversion stages. Used Python-based sentiment analysis (NLP) and created interactive Power BI dashboards for campaign monitoring, retention, and conversion-focused reporting.
Data Analyst Intern
Trigunasoft
Mar 2025 - Oct 2025 (7 months)
Collaborated on a client-facing Digital Marketing Analytics engagement, analyzing 52K+ campaign records using SQL, Power BI, and Excel to identify customer behavior, business trends, and campaign performance insights. Performed data cleaning/transformation/validation and marketing funnel analysis across 216K impressions to 25.4K clicks to 1.3K purchases, and built interactive Power BI dashboards a
Analyzed 24K+ financial customer records to study borrowing behavior, repayment trends, and credit exposure, and built risk segmentation models using credit utilization and loan-to-deposit ratios. Designed Power BI risk intelligence dashboards to support credit evaluation and portfolio/biz risk assessment, including identifying a high default-probability segment where loan-to-deposit ratio exceeds
Processed 1.2B+ commercial sales data to analyze revenue performance and profitability across regions and product categories, including identifying that top products drove over 40% of total sales. Conducted trend analysis to uncover 10–12% recurring seasonal demand patterns (May–July) and built Power BI dashboards for regional performance tracking and business planning.
Education
Degrees, certifications, and relevant coursework
LNCT Group of Colleges
Bachelor of Technology (B.Tech), Artificial Intelligence & Data Science
2022 - 2026
Grade: CGPA: 7.80
Pursuing B.Tech in Artificial Intelligence & Data Science at LNCT Group of Colleges, Bhopal (2022–2026), with a CGPA of 7.80.
Vandana Convent Sr. Sec. School
Senior Secondary, Senior Secondary Education
Grade: Percentage: 86.2%
Completed Senior Secondary education at Vandana Convent Sr. Sec. School, scoring 86.2%.
Vandana Convent Sr. Sec. School
Secondary, Secondary Education
Grade: Percentage: 92.6%
Completed Secondary education at Vandana Convent Sr. Sec. School, scoring 92.6%.
Availability
Location
ZimbabweAuthorized to work in
Job categories
Skills
Interested in hiring Pranay?
You can contact Pranay and 90k+ other talented remote workers on Himalayas.
Message PranayGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
