Shankar Rajput – Senior Data Analyst
Location: Pune, India.
---------------------------------------------------------------------------------------------------------------------------------Summary:
• Around 11 years of hands-on experience as a Data Analyst leveraging Python, SQL, Tableau, Power
BI, cloud platforms (AWS, Azure), and ETL tools to extract, transform, and load data for insightful
analysis and reporting.
• Expertise in Python to manipulate data for data loading and extraction and worked with Python
libraries like Matplotlib, NumPy, SciPy, Seaborn, and Pandas for data analysis.
• Experience in data integration, data wrangling, ETL/ ELT processes, Data Interpretation, and Data
Integration by using SQL.
• Practical understanding of Data modelling (Dimensional and relational) concepts like Star-Schema
Modelling, Snowflake Schema Modelling, and Fact and Dimension tables.
• Proficient in Data Modelling, Data Migration, Data Cleansing, and ETL Processes, with an
understanding of RDBMS (SQL Server, MySQL) and NoSQL (MongoDB, HBase) technologies to design
and implement solutions for diverse data needs.
Key Domain and Technical Skills:
• Domain: - Retail & Banking, HR
• Technical: Python, SQL Server, SSIS, SSAS, SSRS Tableau, Power BI, ADF, Azure, and ETL tools, Agile,
Erwin, Toad, ChatGPT, GenAI Copilot.
Academic Qualification:
• Masters in Computer Management in 2012 from Pune University, Pune, Maharashtra, India.
• Bachelors in Computer Science in 2010 from SRTMUN University, Nanded, Maharashtra, India.
Certifications / Professional Awards:
• Data Analytics with Microsoft Power BI
• AI-3016: Develop generative AI apps in Azure AI Foundry portal
• AI Tools Completion Certificate by be10x.
Languages known: English, Hindi, Marathi
Experience:
Lead Developer
Infosys Mar-2023-Present Pune, India.
• Resulted in a {20%} increase in predictive accuracy by integrating advanced analytics into {5} Power
BI dashboards.
• Optimized SQL queries by 25% using query performance tuning techniques (indexing, query hints)
in SQL Server Management Studio (SSMS), leading to improved database performance.
• Improved reporting fidelity for {50} projects by ensuring data accuracy through comprehensive SQL
data quality checks.
• Delivered complex analytics solutions resulting in a {15%} increase in operational efficiency.
• Facilitated collaborations with {20} stakeholders to define technical requirements for {5} major
projects.
• Designed and implemented SSIS packages to automate data extraction, transformation, and
loading (ETL)processes for data warehouses, reducing manual effort and a 25% improvement in data
processing speed.
• Achieved a 30% improvement in data management outcomes by optimizing data storage, retrieval,
and processing within the Azure Data Lake.
• Generated multiple informative visualizations (histograms, scatter plots) using Matplotlib and
Seaborn to communicate complex data insights to stakeholders, leading to a 30% improvement in
decision-making efficiency.
Senior Data Analyst
Flexibility HR Solutions
April-2022 to March-2023 Pune, INDIA
• HR solutions provider for businesses.
• Summarized recruitment data utilizing Excel and Power BI, yielding {30} insightful dashboards.
• Generated reports through Power BI and MySQL, managing {100} datasets leading to informed
decision-making.
• Enhanced recruitment analysis by summarizing data for {1000} candidates using Excel and Power
BI dashboards, leading to clearer insights.
Data Analyst
Team Lease Services
June-2015 to April-2022 Pune, INDIA
• Lead HR and workforce solutions company.
• Initiated {25} actionable insights utilizing data visualization tools for enhanced business
intelligence.
• Analysed and collated data to produce {50} reports for management, improving data accessibility.
Associate
Indecomm Global Services
August-2012 to August-2014 Pune, INDIA
• Provider of technology and business process outsourcing solutions.
• Produced and managed {12} MIS reports monthly while overseeing budgeting and data analysis
processes.
• Achieved a {30%} improvement in data governance compliance by developing data standards for
{15} stakeholders.
Projects:
Project Title:
Retails Store Sales Analytics
Duration: From June 2023 to August 2024
Description:
• Developed and implemented a sales analytics model that improved sales forecasting accuracy by
20%
• Analysed 12 months of sales data to identify key trends and patterns, resulting in a 15% increase in
cross-selling opportunities.
• Created a comprehensive sales dashboard that provided real-time insights, contributing to a 25%
reduction in sales cycle time.
• Contributing to a 25% reduction in sales cycle time. Project Title: Banking Data Governance
Duration: From August 2024 to Till Now. Description:
• Optimized SQL queries by 25% using query performance tuning techniques (indexing, query hints)
in SQL Server Management Studio (SSMS), leading to improved database performance.
• Improved reporting fidelity for {50} projects by ensuring data accuracy through comprehensive
SQL data quality checks.
• Delivered complex analytics solutions resulting in a {15%} increase in operational efficiency.
• Designed and implemented SSIS packages to automate data extraction, transformation, and
loading (ETL)processes for data warehouses, reducing manual effort and a 25% improvement in data
processing speed.
• Achieved a 30% improvement in data management outcomes by optimizing data storage, retrieval,
and processing within the Azure Data Lake.
• Generated multiple informative visualizations (histograms, scatter plots) using Matplotlib and
Seaborn to communicate complex data insights to stakeholders, leading to a 30% improvement in
decision-making efficiency.
