Credit Transactions and Fraud Detection Analysis – SQL & Power BI
→
Summary
A project focused on analyzing credit transaction data to identify high-risk customers and detect fraud patterns using SQL and Power BI.
About
Highly analytical Market Research Analyst with a strong foundation in data analysis and marketing strategy, adept at leveraging tools like Power BI, SQL, and Excel to drive business insights. Proven ability to enhance campaign targeting, optimize lead generation, and inform strategic decision-making through data-backed reporting and visualization. Eager to apply advanced analytical skills as a Data Analyst/ Business Analyst to solve complex challenges and contribute to measurable business growth in a dynamic organization.
Work
MyBlackPlate
|Market Research Analyst
Delhi, Delhi, India
→
Summary
Market Research Analyst responsible for leveraging data to enhance campaign targeting, lead quality, and B2B outreach strategies.
Highlights
Spearheaded competitive market research utilizing Gartner and Thomson Reuters, elevating campaign targeting accuracy by 15%.
Designed and deployed dynamic KPI dashboards and sales insight summaries using Excel and Power BI, providing critical support for marketing strategy development.
Produced weekly analytical reports for senior leadership, directly influencing the refinement of B2B outreach positioning strategies.
Collaborated cross-functionally to develop a data-backed marketing plan, ensuring alignment with prevailing industry trends and strategic objectives.
Analyzed business processes to identify key performance gaps, leading to the development of a more targeted and effective campaign strategy.
Built and managed a comprehensive B2B prospect database by consolidating data from LinkedIn, Apollo.io, and Sales Navigator, expanding the outreach pool by 25% and improving lead quality.
Executed targeted secondary research on industry players and decision-makers, empowering the sales team to personalize outreach and boost client conversion rates.
CollabAdda Pvt. Ltd.
|Market & Brand Research Intern
Delhi, Delhi, India
→
Summary
Market & Brand Research Intern focused on consumer behavior analysis, competitive intelligence, and reporting to enhance branding and marketing efficiency.
Highlights
Analyzed consumer behavior data to pinpoint critical brand perception gaps, informing strategic brand adjustments.
Generated and presented weekly insights reports in Excel to stakeholders, facilitating data-driven decision-making.
Developed competitor dashboards to support the branding team, accelerating messaging iteration and competitive response.
Identified marketing strategy inefficiencies through data trend analysis, supporting informed business analysis tasks.
Streamlined reporting formats using Excel formulas and macros, reducing report generation time by 30%.
Designed a structured database of potential clients and partners via LinkedIn and Apollo.io research, significantly improving campaign targeting and lead generation efficiency.
Conducted in-depth competitor and market mapping using Sales Navigator, delivering actionable insights that refined branding team positioning strategies.
Education
Indira Gandhi National Open University
→
M.A.
Economics
University of Rajasthan
Jaipur, Rajasthan, India
→
B.A. (Hons.)
Economics
Certificates
Power BI Essential Training
Issued By
LinkedIn (NASBA)
Tableau Data Visualization
Issued By
Great Learning
Data Analytics Professional Certificate
Issued By
MedTourEasy
Lean Six Sigma Yellow & White Belt
Issued By
Six Sigma Academy
SQL - Beginner to Advanced
Issued By
Simplilearn
Digital Marketing Certification
Issued By
Hubspot
Project Management Certification
Issued By
Udemy
Skills
Data Analysis & Visualization
Power BI, SQL, Tableau, Excel (VLOOKUP, Pivot Tables, Power Pivot, Power Query), Data Storytelling, Dashboard Creation (Excel, Power BI, Tableau), Data Interpretation & Presentation.
Business Intelligence & Reporting
Microsoft PowerPoint, Advanced Excel Macros, Business Reporting & Analysis, KPI Development, Client Relationship Management.
Market Research & Strategy
Competitive Market Research, Consumer Behavior Analysis, Brand Perception Analysis, Marketing Plan Development, Lead Generation, Market Mapping, Positioning Strategy.
Professional Skills
Stakeholder Management, Problem Solving, Proactive Collaboration, Communication, Teamwork.
Projects
Marketing Campaign Performance Dashboard - Power BI
→
Summary
Developed an interactive Power BI dashboard to evaluate multi-channel marketing campaign performance and customer response behavior using a Kaggle dataset.
Strategy Consulting & Job Simulation - Accenture (Forage Virtual Experience)
→
Summary
Developed market entry strategies and client recommendation reports aligned with Accenture's business consulting practices.
Data Analytics & Visualization Simulation – Accenture (Forage)
→
Summary
Built interactive sales dashboards and tracked KPIs to identify revenue gaps, presenting stakeholder-ready reports with actionable insights and sales forecasts.