Gagandeep Singh Chawla

Project : Sales and Marketing Domain

Roles : Technical Lead

Responsibilities:

• Implemented Python3 script transformation initiative for Sales team on quarterly basis, significantly enhancing data retrieval efficiency. Originally, process took over 20 days to compile information for 1000k records. By migrating script to PySpark framework, retrieval time was reduced to just 21 hours. Acknowledged and appreciated by both sales teams and project stakeholders for its impactful results.
• Developed Datatype Validation Test Cases Framework integral to all ETL pipelines, ensuring robust data validation. This framework compares table schemas against master CSV attributes, verifying attribute presence and datatype consistency. Successfully matched attributes signify pipeline success, while disparities result in pipeline failure.
• Marketing Teams are encountering difficulties in accessing quarterly reports because of problems with Fivetran connectors and Five9 SMTP connections. To address these issues, conducted research and utilized Python3 ETL and pipelines, leveraging Five9 Python3 library. As result of this effort, received positive feedback and appreciation from both marketing teams and stakeholders.
• Successfully oversee release processes for both Prod and QA, achieving flawless success rate of 100%.
• Maintained close communication with clients throughout project life cycles for accurate progress reporting and prompt issue resolution.
• Supervise 6 developer teams, overseeing code reviews to ensure adherence to coding standards and providing guidance on code enhancement and meeting project requirements.

Project : Mortgage Domain

Roles : Team Lead and Senior Software Engineer

Responsibilities :

• Designed and implemented metadata extraction tool that ingests client data and performs information searching in document. It utilizes various matching capabilities, including fuzzy matching, exact matching, and number-to-word conversion, to identify relevant information within documents. Short: Developed metadata extractor tool leveraging fuzzy/exact matching and number-to-word conversion to identify relevant information from client data for document information searching.
• Implemented configuration-driven database migration tool that facilitates efficient database transitions. It extracts complete database schemas and data in Parquet format, enabling restoration to various database platforms.
• Webhook Developed configurable webhook system for real-time client notification regarding status of cases and file.
• Implemented output_converter component, responsible for data type transformation based on database configuration and performing post-processing operations such as splitting, merging, and appending values.
• Led architecture discussions, driving innovation in software design and implementation strategies.
• Maintained comprehensive documentation of development work, facilitating knowledge sharing among team members.
• Enhanced software functionality by identifying and resolving complex technical issues.
• Proactively identified areas for process improvement, implementing changes that led to significant time savings for team.
• Supervise 10 developer teams, overseeing code reviews to ensure adherence to coding standards and providing guidance on code enhancement and meeting project requirements.

Project : An Desktop and Android Application Which is Decentralized, Encrypted, Peer-To-Peer, the Trustless Communications Protocol That Can Be Used By One Person To Send Encrypted Messages To Another Person, Or To Multiple Subscribers.

Role: Python Developer

• Successfully upgraded Desktop and Android Application from Python 2 to Python 3. During this process, updated various third-party libraries such as configparser, pillow, and qrcode etc. This involved extensive research and documentation. Additionally, provided all necessary documents to QA team for testing both desktop and Android Devices.

Project : On Online Ticketing Portal.

Role: Django Python Developer

• Developed feature to track real-time sales data, incorporating discounts through promo codes and daily sales promotions on tickets, enabling accurate tracking of employer's total sales. Successfully stabilized project with over 300 bugs by resolving on average of 3 bugs daily over span of 3 to 4 months, resulting in enhanced project stability.

Project : Escape Room Game Concept

Role : Django Python Developer

Responsibilities :

• Developed Rest APIs for mobile development teams, facilitating creation of custom escape rooms by users. This involved features such as adding participants, configuring light effects, and setting duration of escape room experience.

• Project: Blog Website Development
• Position: PHP WordPress Developer
• Responsibilities: Served as WordPress Developer for dynamic website projects, responsible for updating content on user's WordPress Portal and ensuring its synchronization with user's WordPress sites.