Sarang Lanjewar

Noida

I'm Sarang Lanjewar, a Software Developer at Global Intelligence Software Ltd in Nagpur, India, where I leverage my ambition and determination to drive innovative solutions. Collaboration is at the heart of my approach, allowing me to connect with team members to navigate challenges with logic and resourcefulness while maintaining a pragmatic outlook. My journey in tech has taught me that blending empathy with analytical thinking creates exceptional results, and I'm excited to keep evolving in this dynamic field.

Experience

Member

Toastmasters International · Sep 2024 – Apr 2025

Not yet confirmed

• As a member of Toastmasters International, I have been actively developing my public speaking, leadership, and communication skills through structured learning and real-time practice.
• From delivering prepared speeches to handling impromptu Table Topics, each session has helped me gain confidence and clarity in my expression.
• Taking on various roles like Timer, Evaluator, and Speaker has enhanced my ability to think critically, manage time effectively, and provide constructive feedback.
• Being part of a supportive community of like-minded individuals has not only refined my speaking skills but also strengthened my ability to lead, listen, and inspire others.
• Toastmasters continues to be an enriching experience, pushing me beyond my comfort zone and shaping me into a more articulate and impactful communicator.

G

Software Developer

GLOBAL INTELLIGENCE SOFTWARE LIMITED · Sep 2023 – Dec 2024

Not yet confirmed

• At Global Intelligence Software Ltd, I designed and developed a Python-based rule engine exposed through REST APIs to execute dynamic SQL queries defined via Excel configurations.
• By eliminating direct user interaction with databases, I strengthened data security, enabled concurrent multi-user query execution, and improved system flexibility while reducing manual intervention.
• I also optimized Data Ingestion Services (DIS) on Azure by identifying cross-subnet latency bottlenecks in bulk insert operations.
• Using Azure Kubernetes Service (AKS) and AzCopy, I reduced large-scale data transfer time from 3–4 hours to approximately 10–15 minutes, significantly improving automation, performance, and scalability.

G

Software Developer

Global Intelligence Software Ltd, Nagpur, India · Sep 2023 – Dec 2024

Not yet confirmed

• Built a rule-based query framework using Python enabling non-technical users to analyze KPI datasets and derive insights via Excel-driven configurations, eliminating manual SQL usage.
• Automated KPI comparison workflows by converting Excel-based logic into SQL queries, reducing 4–5 hours of manual effort daily and improving operational efficiency.
• Redesigned ingestion architecture by deploying a cloud VM within the database network, eliminating VPN bottlenecks and significantly improving large file processing performance.
• Developed an asynchronous ingestion pipeline using Python and RabbitMQ with chunking and multithreading, enabling scalable data processing and reliable job execution with email notifications.

T

System Engineer (Promoted from Assistant System Engineer)

Tata Consultancy Services Ltd (American Express), Pune, India · Aug 2021 – Aug 2023

Not yet confirmed

• Designed and maintained scalable ETL/data ingestion pipelines for banking datasets using Python, PySpark, SQL, and PL/SQL, supporting regulatory reporting and analytics.
• Extracted and transformed data using SQL/PLSQL and PySpark, performing data cleaning, validation, de-duplication, schema standardization, and multi-table joins to ensure high data quality.
• Loaded processed data into a NoSQL database and designed optimized data schemas using normalization for efficient storage and retrieval.
• Automated pipelines as scheduled batch jobs and ensured data quality through validation and monitoring checks, resolving failures such as query timeouts, DB connection issues, and dependency failures reducing frequency by 30%.
• Deployed schema changes across Silver, Gold, and Platinum via RFC process, ensuring stable releases.
• Developed a Java-based reconciliation tool to compare AMEX and internal reports, improving data accuracy and reducing manual validation effort.

System Engineer

Tata Consultancy Services · Aug 2021 – Aug 2023

Not yet confirmed

• At Tata Consultancy Services, I worked as a Data Engineer for the American Express Travel & Lifestyle Services project, where I designed and maintained scalable ETL and data ingestion pipelines using Python, PySpark, and SQL (PostgreSQL/MySQL).
• I collaborated with business stakeholders to identify data sources and build reliable workflows for downstream analytics and reporting.
• I developed and optimized complex PL/SQL queries for Oracle OFSAA systems, improving query performance by approximately 25–30%.
• I monitored daily batch processing jobs, proactively resolving production issues and reducing rerun frequency by 30–35%, ensuring stable and reliable data operations across environments.
• Additionally, I built a Java-based automation tool to streamline report reconciliation and data comparison processes, reducing manual validation effort by 40% and improving cross-team data consistency.
• I also supported schema updates, ODL changes, and deployments across Silver, Gold, and Platinum environments, contributing to smooth production deployments and high data integrity.

Member

SAEINDIA · Dec 2018 – May 2021

Not yet confirmed

• Member of Society of Automotive Engineers India. (SAE India).
• This allowed me to interact with different peoples and community and helped to gain and interchange some knowledge.

Powertrain And Electronics Department

IIITDMJ RACING · Aug 2018 – May 2021

Not yet confirmed

• As a member of IIITDMJ Racing, Sarang contributed to the design and manufacturing of a student formula racing car to participate in the SUPRA SAE competition, held annually at Buddh International Circuit (BIC).
• For the 2019-20 competition, he was part of the Powertrain Department, focusing on engine and electronics.
• His responsibilities included gaining expertise in engine components such as intake, exhaust, and fuel tank while actively contributing to the car's development.
• Through collaborative efforts, the team secured an All India Rank (AIR) 48 among 150+ participating colleges, demonstrating technical proficiency and teamwork in automotive engineering.

Member

Automotive and Fabrication Club, IIITDMJ · Aug 2017 – Jan 2021

Not yet confirmed

• ​As an active member of the Automotive and Fabrication Club, Sarang engaged in various hands-on projects, notably the development of a water rocket, which enhanced his practical engineering skills.
• Demonstrating his passion for aerial technology, he participated in the International Drone Racing League at IIT Bombay's Techfest, a premier technology festival.
• This competition challenged participants to navigate high-speed drones through intricate courses, requiring precision and agility. ​