Shakra Shamim
Data Analyst
+91-9919XXXXXX # shakrashamim09@[Link] ï [Link]/in/shakrashamim
Summary
Data Analyst with a strong foundation in SQL, Python, Excel, and Power BI. Skilled in cleaning, analyzing, and
visualizing data to generate insights and support data-driven decision-making. Interested in collaborating on
meaningful analytical work in fast-paced environments.
Skills
Programming & Querying: SQL, Python
Data Visualization Tools: Advanced MS Excel, Power BI, Tableau
Analytical Abilities: Data Cleaning, Exploratory Data Analysis (EDA), Insight Generation, Descriptive Statistics
Experience
Data Analyst Intern April 2025 – June 2025
Dataview Analytics (Remote) Tools Used: Excel, SQL, Power BI
– Processed and standardized a dataset of over 1,00,000 rows from multiple regions to support weekly
analytics—enabled business teams to track KPIs across geography and time.
– Designed smart Excel templates embedded with lookup functions and pivot logic, saving 40% reporting time across
4 departments.
– Developed and maintained Power BI dashboards to visualize revenue trends, customer mix, and monthly
performance—regularly used by managers and analysts across business units.
– Collaborated with 4 analysts and 2 senior managers to define and validate 6 KPIs, improving report reliability and
strategic alignment.
Projects
Customer Churn Analysis | Python March 2025 – April 2025
– Analyzed behavior of 7,043 telecom customers to identify churn patterns based on tenure, contract type, and
monthly charges.
– Engineered new features including contract type buckets and tenure bands to improve segmentation and insights.
– Generated 11 visualizations (histograms, box plots, heatmaps) to highlight churn-prone segments.
– Revealed that 38% of churned users were on monthly contracts with less than 3-month tenure—suggested early
engagement strategies.
Sales Dashboard for Regional Performance | SQL, Power BI February 2025 – March 2025
– Queried and joined 3 sales-related tables covering over 25,000 rows across 12 months and 5 regions using optimized SQL
joins to create consistent, analysis-ready datasets.
– Built 10 dynamic measures and KPIs in Power BI to track regional sales, return trends, and product performance.
– Designed multipage dashboards with slicers and filters, helping stakeholders drill down by region, product category, and
time.
– Detected a 14% sales drop post-festival in the South region. Later, the insight was used for a marketing recovery plan.
Awards & Certifications
• Google Data Analytics Certificate – Coursera (2024): Completed 8 practical case studies involving SQL, data
cleaning, dashboards, and presentations.
• Top 5% in SQL Hackerrank Challenge – 2024: Ranked among top 150 out of more than 3,000 participants for
advanced SQL problem-solving.
• Best Final Year Project – 2025, Marwari College: Built a Power BI dashboard analyzing academic performance
across 6 departments over 3 years.
Education
[Link]. Information Technology Graduated: 2025
Marwari College, Ranchi CGPA: 8.2 / 10