Swapnil Singh

About Swapnil Singh

Welcome to my LinkedIn Profile! I\'m Swapnil Singh, a Data Analyst with 3 years of experience in Data Science and Analytics. Proficient in SQL, Advanced Excel, and Power BI, I specialize in Business and Data Analysis, Data Modeling, Data Visualization, and Business Intelligence. Additionally, I\'m adept at Stakeholder Interaction, Requirement Gathering, Query Design, and Process Improvement. With a strong background in Power BI, I specialize in creating interactive dashboards, blending data, advanced visual analytics, and storytelling. Currently, I\'m utilizing my skills as a Data Analyst in the Transformation Team, MD & CEO Office of Hero Fincorp.CAREER Integrated disparate datasets and conducted data preparation for analysis using CRM, surveys, and PostgreSQL database, facilitating seamless analysis. Cleaned and organized data to ensure accuracy, completeness, and consistency, involving handling missing values, removing duplicates, and standardizing formats. Performed exploratory data analysis (EDA) to uncover patterns, correlations, and trends within the data. Created clear and informative visualizations such as charts, graphs, and dashboards to effectively communicate findings and insights to stakeholders. Generated regular reports and conducted ad-hoc analyses to deliver insights on key metrics, performance indicators, and business trends. Utilized BI tools and platforms to extract, analyze, and visualize data, facilitating data-driven decision-making Data Extraction, Data Integration, Data Blending, Data Cleaning, Data Transformation, Data Manipulation, Data Modeling, Data Visualization, Data Analysis, Data Interpretation, Data Warehousing Business Intelligence (BI), Reporting, Dashboard Design ETL (Extract, Transform, Load) SQL (Structured Query Language), PostgreSQL, MySQL, Microsoft SQL Server Power BI Desktop, Power BI Service, Power Query, Power Pivot Statistical Analysis Advanced Excel, Google Sheet, Spreadsheet Data-driven Insights, Data-driven Decision Making, Critical Thinking, Analytical Skills, Communication Skills, Data Certified Data Analyst - Coding Invaders SQL (Basic, Intermediate, Advanced) Certificate - HackerRank Microsoft Power BI Data Analyst Professional Certificate - CourseraLET\'S out to me at s••••••••@gmail.com if you are interested

Experience

1. Business Intelligence Analyst

   Hero FinCorp

   Apr 2024 — Present · Gurugram, IN

   As a Business Intelligence Analyst in the MD & CEO office at Hero Fincorp, I transform complex data into actionable insights that drive strategic business decisions. My role includes:1) Publishing daily, weekly, monthly, and quarterly disbursement dashboards (tentative and final versions) to monitor performance.2) Delivering monthly bounce reports to highlight key payment trends and deviations.3) Updating the CEO Dashboard with various business metrics, ensuring leadership has a clear and current view of business performance.4) Conducting competition benchmarking quarterly, providing critical insights on market positioning.5) Collecting, transforming, and analyzing Electric Two-Wheeler market data to provide OEM-wise sales trends, market size, industry updates, subsidy impacts, and state-level opportunities.6) Publishing monthly market share analysis Power BI dashboards with dealer and sub-dealer data, enhancing business visibility.7) Managing the Two-Wheeler Dealers Tracking Dashboard for better performance analysis and tracking.8) Developing Power BI dashboards for tracking logins and disbursements monthly.9) Preparing presentations on potential new product lines, and supporting business development efforts with critical insights.10) Publishing Annual Operating Plan (AOP) Reckoners on a monthly, quarterly, and yearly basis to support budgeting and forecasting.11) Working on urgent and ad-hoc projects to provide timely analysis and insights in response to evolving business needs.

Education

• Coding Invaders

  Certificate of Completion, Data Science and Analytics

• Narayana Institute

  Intermediate, Physics , Chemistry , Mathematics

• Chandigarh University (CU)

  Bachelor of Engineering - BE, Computer Science