Talk to sales Try for Free
JAYANT DIKSHIT

JAYANT DIKSHIT

Followers of JAYANT DIKSHIT901 followers
location of JAYANT DIKSHITBengaluru, Karnataka, India

Connect with JAYANT DIKSHIT to Send Message

Connect

Connect with JAYANT DIKSHIT to Send Message

Connect

  • Timeline

  • About me

    Consultant @ Morgan Stanley || Ex - TCSer || Python || Machine Learning || Postgre- SQL || T-SQL|| Power BI || Data Analyst || Statistics

  • Education

    • Maharaja Institute of Technology Bhubaneswar

      2013 - 2017
      Engineer’s Degree Electrical engineering 7.63 CGPA

      Activities and Societies: * Provided tutoring in Engineering Mathematics to junior students. * Actively mentored junior students in Python and SQL programming. * Active participant in Cricket & Badminton. I earned my B.Tech in Electrical Engineering from Biju Patnaik University of Technology in 2017. This program provided me with a comprehensive education that covered Electrical Engineering, Computer Science, Basic Science, and Humanities, offering a well-rounded knowledge base.Furthermore, I pursued certification courses in Programmable Logic Circuit (PLC), Programming in C, C++, and SQL. These certifications have been invaluable in enhancing my technical expertise, enabling me to excel in… Show more I earned my B.Tech in Electrical Engineering from Biju Patnaik University of Technology in 2017. This program provided me with a comprehensive education that covered Electrical Engineering, Computer Science, Basic Science, and Humanities, offering a well-rounded knowledge base.Furthermore, I pursued certification courses in Programmable Logic Circuit (PLC), Programming in C, C++, and SQL. These certifications have been invaluable in enhancing my technical expertise, enabling me to excel in various professional roles.My education at Biju Patnaik University of Technology has been the cornerstone of my career, providing me with a strong foundation for success in Electrical Engineering and software development. Show less

    • Ganga singh college chapra saran

      2010 - 2012
      Intermediate PCM 69.2%

      In 2012, I accomplished my Intermediate in Science (I.SC) with a specialized emphasis on Physics, Chemistry, and Mathematics (PCM), achieving top honors in Mathematics. This pivotal academic phase stimulated my profound interest in advanced mathematical concepts, particularly Calculus and Algebra.

    • Shri yogendra singh rishikool high school reotith gopalganj

      2008 - 2010
      Matriculation Mathematics, Basic Science, Social Science, Humanities & Languages 72%

      In 2010, I completed my secondary education, achieving distinctions in both Science and Mathematics. This educational milestone not only showcased my commitment to academic excellence but also laid a strong foundation for my future pursuits in the fields of science, technology, and mathematics.

  • Experience

    • Tata Consultancy Services

      Mar 2018 - Nov 2021

      - Significantly enhanced the performance of over 30 T-SQL stored procedures and Analytical SQL Queries while also contributing to the development of more than 150 stored procedures, views, triggers, and User-Defined Functions (UDFs) during my tenure at TCS.- Proficient in advanced SQL techniques, including Stored Procedures, Views, Triggers, Window Functions, Common Table Expressions (CTE), Indexing Techniques, Complex Joins, and Query Optimization.- Played a pivotal role in the restructuring of schemas encompassing 50+ tables, resulting in a substantial improvement in data integrity.- Spearheaded the development of Python scripts for ETL purposes, enabling the preparation of multiple datasets to support various analytical projects.- Successfully created and delivered over 10 highly interactive Power BI dashboards, meticulously designing the data model to ensure scalability for future needs.- Implemented advanced DAX logic to meet complex business requirements, demonstrating a keen understanding of data analysis and modeling techniques. Show less - Moved internally in Analytics team, contributed to the design and development of a sophisticated database structure for an analytical project.- Focused on advanced SQL concepts, including the creation of complex stored procedures, user-defined functions (UDFs), optimized views, triggers and ensured data normalization while setting up audit tables, fact tables, and dimension tables.- Leveraged expertise in aggregation, window functions, inbuilt advanced functions, common table expressions to generate highly complex Analytics tables/dataset.- Employed correct Indexing strategies, Statistics and fine-tuned query performance to optimize database efficiency. Show less

      • System Engineer

        Mar 2020 - Nov 2021

      • Assistant System Engineer

        Mar 2019 - Feb 2020

      • Assistant System Engineer Trainee

        Mar 2018 - Feb 2019

    • Morgan Stanley

      Nov 2021 - now
      Consultant

      - Enhanced performance by optimizing over 20 Python data processing and data transformation scripts, resulting in improved efficiency.- Achieved a 5x speed increase in data pre-processing and ETL pipelines by transitioning to the Python Polars module, replacing Pandas.- Successfully led the migration of more than 200 DB2 data items to PostgreSQL, ensuring a seamless transition of data systems.- Developed and delivered 25+ highly interactive and informative financial analysis Power BI dashboards, providing critical insights for decision-makers.- Actively contributed to the Python upgrade process, facilitating the transition from version 3.5 to 3.11, keeping the technology stack up to date.- Engaged in the development and improvement of analytical reports from a basic to intermediate level using SAP Business Objects. Show less

  • Licenses & Certifications

  • Honors & Awards

    • Awarded to JAYANT DIKSHIT
      On the Spot Award Tata consultancy Services September 1, 2020