Ojal Bhatnagar Email & Phone Number

As a Software Engineer Intern, I optimized over 40 WordPress sites, diagnosing and resolving complex plugin conflicts to enhance site stability and user experience. I conducted rigorous security audits, identifying and removing vulnerabilities to secure the digital assets of each client. Additionally, I managed 15+ client requests, designing custom themes and upgrading UX/UI elements. My tailored solutions not only improved client satisfaction but also boosted site performance and visual appeal, driving better engagement and showcasing SAM IT’s commitment to digital excellence.

At InspiritAI, I led operational logistics and administrative oversight, efficiently managing a dynamic team of over 50 instructors and coordinating program delivery for 400+ students globally. I streamlined end-to-end workflows, addressing logistical challenges and ensuring optimal program functionality. My role required keen organizational skills to handle resources, instructor schedules, and real-time issues, resulting in a seamless program experience and exceptional feedback from participants.

At Geeky Insights, I spearheaded the design and deployment of a scalable data pipeline using Dagster, Google API, and DigitalOcean infrastructure. This system processed vast amounts of social media data from marketplaces in Dallas and Seattle, providing actionable insights for local businesses

As a Data Analyst with ArtSci Lab, I collaborated with UT Southwestern’s cancer division to reengineer a mobile app based on user feedback. My analysis of interactive video data led to a 20% improvement in the app’s self-care management features, which enhanced patient engagement and compliance. Working across teams, I used data insights to recommend UX adjustments that prioritized user needs. This impactful redesign showcased the power of data-driven decision-making in healthcare and reinforced the app’s value as a self-management tool for patients.

New Delhi, Delhi, India

In my role at TCS for Walgreens, I led a major ETL migration project, transitioning 94 ETL processes from Abinitio to Talend to improve system agility and scalability. My efforts in optimizing 32 ETL jobs on Microsoft Azure led to a 15% increase in data pipeline performance. I also engineered data flows from Oracle, Excel, and flat files, ensuring seamless data loading into Oracle databases. This project earned me a top annual review score of 5/5 for my consistent delivery, technical expertise, and leadership in managing cross-functional teams.

Bengaluru, Karnataka, India

At Capgemini, I processed a 20,000-product dataset using Hadoop and Spark SQL to drive insights on sales trends and discount patterns. My analysis enabled strategic improvements for product placement and pricing. This experience deepened my understanding of big data processing and laid a foundation for my career in data engineering, while also providing valuable insights for the client’s product strategy.

Pune, Maharashtra, India

Successfully developed a password reset page for intranet dashboard. Functionality was developed using JWT token-based authentication, with a Node.js backend and React frontend to provide a secure password reset capability to meet the security standards. CI/CD pipelines were used to implement an Agile environment for faster development timelines.

Master Of Science - Ms, Computer Science

Bachelor Of Technology - Btech, Computer Science

CGPA = 8.24

Standard 12Th, Science(Cbse), 93.6%

Activities and Societies: Member of the school basketball team