Shashank Sahu

As a motivated and versatile professional, I offer a diverse skill set encompassing Data Analysis and Front-End Development. I excel as a coder during the day, while my nights are dedicated to gaming. Over the past year, I've consistently shared valuable insights and content on LinkedIn, building a growing audience. To delve deeper into my skillset, experience, and projects, please continue scrolling.

AdventureWorks Report - Microsoft PowerBI

  • Crafted a user-friendly AdventureWorks Report utilizing advanced DAX for measures and calculated columns; improved overall report efficiency, resulting in users completing analyses 30% faster than previous reporting methods.
  • Implemented tailored design elements like advanced conditional formatting, parameters, bookmarks and custom tooltips on interactive dashboards which led to enhanced clarity in financial presentations viewed by over 100 users weekly at company meetings.

    • Glance Output

    Pizza Sales Dashboard- Microsoft SQL Server and Excel

  • Constructed a user-friendly Pizza Sales Analysis Dashboard integrating data from Microsoft SQL Server while implementing tailored metrics in Excel, enhancing tracking efficiency by creating 5 distinct key performance indicators.
  • Used advanced SQL to write the queries, and PivotTables and timelines in Excel to design the dashboard.

    • Glance Output

    Car Sales Dashboard- Microsoft PowerBI

  • Constructed an interactive dashboard in Microsoft PowerBI Desktop to visualize car sales data. Integrate visual elements like bar charts, line graphs, and pie charts to display metrics such as total sales, sales by model, and regional sales distribution.
  • Calculated key performance indicators (KPIs) using advanced DAX functions, including Year-to-Date (YTD) Sales, Month-over-Month (MoM) Growth, Year-over-Year (YoY) Growth and so on.

    • View Output

    Credit Card Financial Analysis Reports - Microsoft PowerBI

  • Created detailed credit card transaction and customer reports in Power BI Desktop, integrating data with SQL and crafting custom columns and measures using DAX queries; enhanced data accuracy by 40% and reporting speed by 50%.
  • Engineered comprehensive visualizations of KPIs through dynamic charts, uncovering critical customer behavior trends and transaction patterns, which led to a 25% improvement in financial forecasting accuracy and a 10% increase in quarterly profits.

    • Inspect Output

    Typing Speed Tester- HTML, CSS and JS

  • Developed a HTML, CSS, and JavaScript-based typing speed assessment tool, evaluating user accuracy and speed; increased average typing speed by 20 WPM in a user base of 500+.
  • Commences the timer the moment user input is detected, and impeccably halts it when the entered text precisely matches the provided text, ensuring timing accuracy down to the millisecond during user interactions.

    • Watch Output

    Rock-Paper-Scissors- HTML, CSS and JS

  • Created an interactive Rock-Paper-Scissors game using HTML, CSS, and JavaScript, enabling users to engage in strategic gameplay against the computer.
  • The top scoreboard prominently displays the scores of both the user and the computer for quick reference
  • Experience dynamic visual feedback with a captivating glowing effect behind the rock, paper, and scissors icons, signifying the outcome of the user's interactions against the computer, whether it's a win, draw, or loss.

    • Review Output

    Associate Analyst

    INFOCEPTS TECHNOLOGIES PVT LTD

    August 2022 - February 2023

    Key contributions:

  • Optimized data management efficiency by 40% through expert utilization of various client tools, including Discover, CROWN, AD-HOC Web, Microsoft Dynamics, and Connect Express, effectively streamlining operations..
  • Performed exacting Excel validations and meticulous frontend database assessments, consistently upholding a 98% accuracy rate to ensure unwavering data integrity and reliability.
  • Successfully overhauled and harmonized KPIs to ensure seamless alignment with overarching business objectives, leading to a significant 20% enhancement in performance tracking precision.
  • Delivered comprehensive insights through the dissemination of 100+ reports via the Discover EU platform, accompanied by in-depth explanations and actionable recommendations, fostering productive client interactions.

    • Assistant Associate

    INFOCEPTS TECHNOLOGIES PVT LTD

    February 2022 - August 2022

    Key contributions:

  • Completed intensive training in Microsoft SQL Server and Microsoft PowerBI, resulting in the development of dynamic dashboards that improved data accessibility and reduced manual reporting efforts by 35%.

    • Web Developer Intern

    UGWT PVT LTD

    March 2021- June 2021

    Key contributions:

  • Redesigned website user interface, implementing responsive design principles and optimizing page load time, resulting in a 15% increase in conversions and a 20% increase in average session duration.
  • Championed the development of 30+ visually stunning and user-friendly web pages using HTML, CSS and React JS for front-end design.

    • Bachelor of Technology- CSE

    SHRI RAM INSTITUTE OF TECHNOLOGY (2018-2022)

  • Developed an in-depth understanding of computer programming languages and their applications.
  • Gained experience working with various tools and techniques for developing software.
  • Became proficient in using computers to solve complex problems.
  • Learned how to effectively communicate with other computer science professionals.

    • 10+2- PCM

    JOY SENIOR SECONDARY SCHOOL (2005-2017)

  • Successfully completed my secondary education at Joy Senior Secondary School, specializing in the PCM (Physics, Chemistry, Mathematics) stream.