Sandeep Kumar

Sandeep Kumar

Freelancer

Followers of Sandeep Kumar1000 followers
location of Sandeep KumarRanchi, Jharkhand, India

Connect with Sandeep Kumar to Send Message

Connect

Connect with Sandeep Kumar to Send Message

Connect
  • Timeline

  • About me

    Data Analyst| Data Scientist| Data Engineer| || Data Cleaning | Python | NumPy | Pandas | Pyspark| SQL| Data visualization |AWS S3|Airflow|PowerBi

  • Education

    • St. Xavier's College, Ranchi

      2013 - 2016
      Bachelor of Commerce - BCom Vocational BUSINESS, MANAGEMENT, MARKETING, AND RELATED SUPPORT SERVICES A
  • Experience

    • Fiverr

      Apr 2017 - Jan 2018
      Freelancer

      ●WordPress website, Landing Page, and WP installation and setup●Business Presentation, Analytics and Infographics visualization using Excel, PowerPoint, and Adobe Illustrator●Graphis Designing, Logo, Business Card and Stationery, Infographics, Icon, Web Banner, Social media Ad design, Presentation, Resume, Print, Product and cover design, Photoshop Landing Page Design.●PDF conversion to Word, PowerPoint, Excel,Manually and OCR

    • Preventa Swaasthcare Pvt. Ltd.

      Jan 2019 - Nov 2021
      Data Analyst at Preventa Swaasthcare Pvt. Limited Ranchi

      Jan 2019- November 2021: Data Analyst at Preventa Swaasthcare Pvt. Limited Ranchi Jul 2021- Nov 2021, Project: Comprehensive Product Sales Analysis for Data-Driven InsightsRole: Data AnalystSkills: SQL (Query), Python (Pandas, NumPy, Matplotlib, Seaborn, Plotly, Statistics)• Conducted ETL processes using SQL to transform raw data for periodical analysis using Python• Collaborated closely with marketing and sales teams to derive actionable strategies from B2B and B2C market segmentation data, resulting in targeted and effective business decisions.• Created and executed Python-based analytical models to assess sales variations across different dimensions, such as month, year, product, and geographic area. These models provided insights into trends and patterns, facilitating data-informed strategies for optimizing sales approaches.• Generated comprehensive sales reports using Power BI and PowerPoint, combining dynamic visualizations with insightful data analysis. These reports effectively communicated sales trends, empowering stakeholders to make well-informed decisions with confidence.Tool: Jupyter Notebook, PowerBi, Microsoft Excel, MySQLApr 2020- Jun 2021, Project: Market Analysis-Channel Sales creation for FMCG PortfolioRole: Data Analyst• Wrangled bad data and developed a advanced data set, retrieved the missing value and dealt with unexpected values• Carried a geospatial analysis to investigate customer demography and developed a map visualization of customer employing choropleth modulePerform Exploratory Data Analysis to audit: • Unified and accumulated data with its variability and plotted to resolve pricing & variations, of Product preferences & Payment Method.• Assembled boxplot to inquire market segment and distribution.• Prepare Channel Sales report for market segmentation with variable data resources Tool: Jupyter Notebook, PowerBi Show less

    • Infosys

      Jun 2022 - Jun 2023
      Data Analyst

      Client: NikeRole: Data Analyst Skills: SQL, Python (Pandas, Pyspark,), Airflow DAG, GitHub Bash• Developed a robust local Automated Python program in PyCharm capable of efficiently comparing two datasets, encompassing millions of records. Designed and executed a streamlined process that produced detailed outputs, as matched, unmatched, and mismatched in Excel Sheet. This program's implementation significantly enhanced data comparison efficiency and accuracy.• Collaborated with Nike developers to design and implement an Airflow Directed Acyclic Graph (DAG) Pipeline that facilitated table comparisons from AWS S3 using Pyspark on weekly basis.• Engineered a connection script that established a seamless link between Snowflake, Teradata and Databricks platforms, enabling the precise comparison of records. Utilized this connection to execute custom queries from an Excel query book, seamlessly extracting and tallying counts as specified and give report in excel sheet.Tool: PyCharm, Snowflake, data bricks, AWS S3, GitHub, Jenkins, Excel, Hive TableClient: Tractor Supply CompanyRole: Data AnalystSkill: Jira, Web and Data Testing• Work with team for data Integration• Live data validation and testing Show less

    • Encora Inc.

      Jan 2024 - now
      Senior Software Engineer
  • Licenses & Certifications