Pratik Awasthi

Senior\Lead Software Developer Experience:

Web API Development & Architecture Collaboration
As a Senior Software Developer, I designed and developed C# .NET Core JSON Web APIs from the ground up. These APIs dynamically fetched data from MS SQL Server using stored procedures, based on input requests from downstream systems. I collaborated closely with Solution Architects and Business Systems Analysts (BSAs) during the discovery and design phases to ensure the architecture aligned with business needs and technical standards.

.NET Web Application for Insurance CRM operations
As a Lead Developer, I built a read-only C# .NET Core Web Application with granular role-based access for our insurance client's Call Centre and internal business teams. The application enabled users to validate and view advisor and branch information. I worked alongside a Junior Developer, guiding development tasks and code quality. I also partnered with BSAs to gather requirements and contributed to designing UI wireframes that improved usability and data visibility.

Team Leadership & Web Service Integration
In my role as Lead Developer managing offshore resources from OnShore, I developed and maintained .NET XML-based Web Services to facilitate communication between internal and external systems. I supported requirement gathering with BSAs and Solution Architects, and led the offshore developer by assigning tasks, defining development approaches, and ensuring alignment with project goals and timelines.

Event-Driven Data Publishing via Siebel Integration
I engineered a .NET Class DLL that was invoked by Siebel CRM during Create, Update, and Delete events. This DLL retrieved relevant record data from SQL Server using stored procedures and published it to Kafka Topics for downstream consumption. This integration enabled real-time data propagation and improved system responsiveness across platforms.

Legacy Data Migration & SQL Automation
Led multiple data migration projects in collaboration with legacy developers and database analysts. I developed SQL scripts using advanced Excel formulas to transform business-provided spreadsheets into structured data. These scripts were used to populate MS SQL databases that supported newer .NET and CRM applications, ensuring data integrity and continuity across systems.

Spreadsheet-to-SQL Automation Tool
Managed and mentored a Junior Developer to create a .NET program that parsed spreadsheet data and generated SQL Insert statements. These statements were reviewed and executed by DBAs, streamlining the data onboarding process and reducing manual effort.

Application Refactoring for Performance Optimization
Worked on a modernization initiative to refactor an existing .NET application. The enhancement involved replacing Siebel Object-based data retrieval with SQL Server stored procedures accessed via datasets. This change significantly improved performance, reduced dependency on Siebel, and simplified maintenance.

Software Developer Experience
Oracle Siebel CRM Infrastructure Upgrade & Deployment
• Upgraded server and database infrastructure to the latest OS versions to support enterprise modernization.
• Installed, configured, and deployed Oracle Siebel Financial Services 24.x CRM, including Gateway and Web Services.
• Ensured seamless deployment and integration with existing systems, improving performance and scalability.

Siebel CRM Enhancements & Downstream Integration
• Delivered Siebel Screen and Business Service changes using Siebel Tools, including configuring business components, applets, views, screens, and other objects as part of BAU requirements and project initiatives.
• Enabled business functionality enhancements while maintaining system stability and compliance.
Batch Job Development & Scheduling
• Created multiple batch jobs that executed Stored Procedures, SSIS packages, and Siebel workflows to synchronize data and generate batch extracts.
• Scheduled and monitored complex batch processes using Control-M, ensuring reliable and timely execution of critical business operations.
• Played a key role in maintaining data consistency across systems and supporting reporting needs.

• Automated and managed secure file transfers through MOVEit, supporting internal and third-party integrations.

ASP.NET Web Application Security Maintenance
• Periodically implemented code changes to the FASAT ASP.NET Web Application to address security vulnerabilities identified during scans.
• Ensured compliance with internal security policies and improved application resilience against threats.

Expertise working in ServiceNow Incident & Change Management tool and
LogMeIn Rescue Technician Console for application support.
• Providing 24/7 2nd and 3rd level of production application support to thousands of
advisors across Canada.
• Creating change request through ServiceNow Change Management System for
any code deployment in production.
• Creating, monitoring & maintaining batch jobs with Control-M task scheduler in all
environments in windows servers.
• Maintaining and providing end to end support to file transfers jobs through secure
SFTP Move-It tool.
• Coordinating with Business Individual Customer Team for insurance application deployment
• Having regular meetings/daily huddles, presentation with IS, business team and
vendors.
• Creating & updating .NET XML Web Services and ASP.NET Web apps as per business requirements and testing
them with SOAP UI tool
• Creating & modifying MS SQL server database tables, views & stored procedures
based on business requirements

• Electrical and Computer Engineering Department
• Developed and integrated an interactive WebGL-based 3D brain model, enabling smooth browsing and visualization for research and educational applications for medical students

• Data Encryption Unit
• Designed and implemented a data encryption system capable of serial data reception, encryption, and re-transmission.
• Developed on FPGA using C++ and Xilinx toolchain, ensuring secure and efficient data handling.
• Ship Navigation Function
• Created a ship navigation module to display angular deviation from true North.
• Programmed hardware interface with LEDs and implemented key functions in Assembly language on the 8051 Microcontroller.

• Automatic Traffic Light Controller Model
• Designed and implemented a timer-based automatic traffic light control system using an 8051 microcontroller, programmed in C for efficient traffic signal automation