Sandeep Rawat Email & Phone Number

New Delhi, Dl, In

Gurugram, Haryana, India

🚀 **Python & DSA Learning Journey at Code and Debug**- Comprehensive Python Training: Mastered Python from foundational concepts to advanced techniques, including object-oriented programming, decorators, and context managers.- In-Depth Data Structures & Algorithms (DSA): Gained hands-on experience with fundamental and advanced DSA concepts, such as: - Arrays, Linked Lists, Stacks, Queues - Trees (Binary Trees, Binary Search Trees, AVL Trees) - Graphs (BFS, DFS, Dijkstra’s Algorithm) - Hashing, Sorting and Searching Algorithms - Dynamic Programming and Greedy Algorithms - Practical Problem Solving: Successfully solved over 200+ DSA problems on platforms like LeetCode and GFG, enhancing analytical and algorithmic thinking.- Advanced Techniques: Explored complex algorithms and optimization strategies, refining problem-solving skills and coding efficiency.

Gurugram, Haryana, India

Client: ZS Internal Project: Beta Testing of ZS Alignment Tool • Led the beta testing team for an in-house tool at ZS, playing a pivotal role in refining and enhancing theplatform which resulted in a 30% improvement in functionality • Enhance the effectiveness of an in-house tool for managing client alignments and roster details, resultingin a 35% improvement in operational efficiency

Gurugram, Haryana, India

Client: AbbVie Project: Data Migration for US-Based Pharmaceutical Client • Successfully Built an end-to-end ETL Pipeline for a US based client, ensuring the seamless daily consumption of input and output processes • Developed and optimized ETL Scripts using AWS Glue, PySpark and Spark SQL by 20% to ensure data accuracy, redundancy and integrity as per business needs • Created Apache Airflow jobs to orchestrate the data pipelines • Collaborated with CST Team and ZS UI team to resolve the issue and deliver the project on time Client: Lilly Project: US-Pharmaceutical Alignment • Developed PySpark scripts for data extraction & transformation from landing layer based on business needs • Utilized HiveQL to perform comprehensive data analysis • Collaborated with US clients to understand their business requirements, design RFP documents, and create LLD and other design documents, ensuring success through weekly calls Client: ZS Clients Project: Go-Live Client Requests • Developed an application compatible with an ZS home grown tool, streamlining operations for the client operations team, and resulting in 95 % reduction in time and effort to determine alignments drop reason. • Tool features a Salesforce UI and backend on AWS Enhance the effectiveness of an in-house tool for managing client alignments and roster details, resulting in a 35% improvement in operational efficiency • Collaborated with a team of 5 developers to successfully launch a web application, enabling seamless data synchronization with external tools. Utilized AWS services and orchestrated workflows with AWS Managed Apache Airflow, reducing backend processing time by 40%

Delhi, India

During my internship focused on Core Java, I engaged in various projects aimed at mastering the fundamentals of Java programming. I worked on implementing core Java concepts such as object-oriented programming, exception handling, multithreading, and collections framework. The projects ranged from developing standalone applications to building small-scale systems. Through these projects, I gained practical experience in software development, debugging, and testing methodologies within the Java environment. Overall, the internship provided a solid foundation in Core Java and equipped me with essential skills for software development.

Bachelor'S Degree, Computer Science, 8.18 C.G.P.A

I pursued a Bachelor of Technology (B.Tech) degree in Computer Science and Engineering from Guru Gobind Singh Indraprastha University.

Seconday, Science, 7.5 C.G.P.A

I completed my 12th grade in the science stream at Govt. Boys Sr Secondary School, M.B Road Pushp Vihar. This educational background.