Shiva ShiShodiya Power BI Developer / SQL Developer
No reviews yet

Data Analyst Professional with 4+ years of Experience in the data science field, skilled in Advanced Excel, Power BI, Advance Sql Concepts, Tableau, Python with supporting libraries like Numpy, Matplotlib, Pandas, etc., and other computer Science Core concepts (i.e. Programming, Data Structures, Operating Systems, System Design, etc.)

When it comes to giving training of CS i'm a firm believer of giving it via 80:20 manner which means 80% practically and the rest of it theoretically because concepts of any domain of computer science are very interesting and result oriented that the user can see the outcome of his/her efforts on the spot and this thing keeps the curiosity and urge of learning in the students.

I look forward to Connecting with you and will discuss more interesting concepts of CS.

Professional Degree: B.Tech
Stream: Computer Science

SKILLS & EXPERTISE

• Excel • Python • Sql • Linux/Unix • DAX • C/C++
• SSIS / SSRS / SSAS

TOOLS & LIBRARIES
• Pandas • Matplotlib
• Numpy • Power BI
• Tableau • git/Github

EXPERTISE
• Data Analysis
• Data Modelling
• Data Visualization
• Data Storytelling
• Data Scraping
• Data Warehousing and Database Management
• Extract, Transform and Load

Subjects

  • Python Beginner-Expert

  • RDBMS Beginner-Expert

  • SQL Server Beginner-Expert

  • T-SQL Beginner-Expert

  • Advanced DBMS Beginner-Expert

  • Power BI dashboard Beginner-Expert

  • Data analysis and visualization Beginner-Expert

  • SQL and Data warehousing Beginner-Expert

  • Excel (Advanced) Beginner-Expert

Experience

  • Data Analyst (Jul, 2022–Present) at Freelancer,Ghaziabad
    • Scraped the data of a cricket web using the Beautiful Soup library in Python and
    delivered it to the client.
    • Performed ETL process on a client’s data and delivered a visually appealing
    dashboard.
    • Created various visually appealing, and interactive dashboards on different
    topics, GitHub link is provided to have a look.
    • Delivered a project by Automated daily reporting of orders,
    merchant/customer refunds, with 80 % reduction in manual efforts.
    • Engaged to deliver data and reporting solutions within a fast-paced
    environment.
    • Aligning stakeholders, building trust-based relationships, and collaborating
    with cross-functional teams while ensuring profitability and strict compliance
    with regulatory guidelines.
  • Data Analyst (Oct, 2020–Jun, 2022) at TATA CONSULTANCY SERVICES, Gurugram
    • Worked in a team of TCS BANCS project and delivered analytical Solutions &
    data Stories to assist the decision-making process for various business
    requirements.
    • Collected data from various SQL/Oracle servers and put them on Test, Stage,
    and PROD. SQL Server.
    • Worked with ETL team for extracting, loading, and transforming data from
    Database to Application.
    • Responsible to utilize the Power BI server to publish and share the reports with
    the end users.
  • Junior Data Analyst (Aug, 2019–Sep, 2020) at Thinksys Software PVT.LTD, Noida (Uttar Pradesh)
    • Created various visually appealing, interactive dashboards using Tableau and
    PowerBI for different processes. These dashboards will let the stakeholders
    know the important KPIs, Yearto Year details, and much more.
    • Manipulated, cleaned & processed data in Python foringestion into (BI)
    business intelligence Tools.
    • Fetched data according to the client’s needs from multiple tables by writing
    SQL queries and Performed Exploratory Data Analysis on the raw data to draw
    inferences.
    • Building complex SQL Queries, Stored procedures, sql jobs, optimization.

Education

  • B.tech (Aug, 2015–May, 2019) from Dr. A.P.J. Abdul Kalam technical univeristy–scored 79.8

Fee details

    ₹500–1,200/hour (US$5.92–14.21/hour)

    Depends on the Project Complexity, number of hours it would take to get it done, and the urgency(priority) of the project.
    This will be discussed mutually.

Reviews

No reviews yet. Be the first one to review this tutor.