Work Experience
Project Engineer, Application Support and Enhancements
Duration: 02/2021 – 05/2022
Summary:- Provided comprehensive support for two applications, including a Windows application built on the
- NET Framework that connected to a web API and utilized Azure Data Factory (ADF) to integrate various data sources
- Delivered excellent Level 2 support for both applications by efficiently addressing issues in workflow and data flow
- Resolved all user-reported tickets promptly, resulting in improved reliability, usability, and a commendable 40% reduction in total tickets
- Collaborated with users to gather requirements and successfully implemented various minor enhancements, including the addition of new features based on user requests, thereby improving application functionality and user experience
- Conducted a proof of concept (POC) and designed a Workforce Transformation app utilizing PowerApps, Dataverse, Microsoft Power Automate, SharePoint, and Power BI
- This app provided employees with a wide range of opportunities to enhance their skill sets, ensuring they remain relevant in the industry
- Led initiatives to upgrade technologies within the application, ensuring that the software remained current with industry standards and best practices, which contributed to improved performance and security
- Enhanced functionality and completed successful enhancement work for two RPA bots using UIPath RPA and Power Automate, optimizing workflows that resulted in significant time savings of 1-2 hours per day for the client
- Conducted thorough debugging and testing to identify and resolve numerous bugs, enhancing the overall stability and reliability of the application
- Created and maintained documentation for incident resolutions, enhancements, and upgrades to facilitate knowledge sharing within the team and support future maintenance efforts
- Worked collaboratively with the development team to ensure successful implementation of enhancements and automation solutions while adhering to Agile methodologies to meet project milestones
Responsibilities: Application support and issue resolution, requirements gathering and implementation of enhancements, POC and design of Workforce Transformation app, technology upgrades, RPA bot enhancement, debugging and testing, documentation, collaboration within Agile teams.
Technologies: .NET Framework, Azure Data Factory (ADF), PowerApps, Dataverse, Microsoft Power Automate, SharePoint, Power BI, UIPath RPA, SQL Server
Developer L2, Data Source Migration and API Source Change Project
Duration: 05/2022 – 06/2023
Summary:- Revamped Existing API Integration: Led the transition of a
- NET Windows application from a deprecated external API to a new API, ensuring seamless functionality and improved performance for end-users
- Web API Modifications: Executed comprehensive updates in the
- NET Web API to facilitate connections with the new external API, enhancing data retrieval and processing capabilities
- Web Forms Application Updates: Implemented similar changes in a legacy Web Forms application, ensuring compatibility with the new API and maintaining consistent functionality across platforms
- Secure Authentication: Integrated OAuth 2
- 0 for secure authentication and authorization when connecting to both the new API and the Web Forms application, ensuring compliance with industry security standards
- LINQ Query Implementation: Utilized LINQ to craft efficient queries for data manipulation and retrieval in both applications, improving code readability and maintainability
- Performance Optimization: Addressed load constraints by implementing effective caching strategies using in-memory caching techniques, significantly enhancing response times and overall application performance under high-load scenarios
- Error Handling and Logging: Developed robust error handling mechanisms and logging frameworks to monitor API interactions in both applications, ensuring quick identification and resolution of issues
- Led the successful migration of data source connections for a critical application from an on-premises Oracle database (WellView) to Azure Data Lake Gen2 (WellView Allez), ensuring minimal disruption during the transition
- Issue Resolution: Identified and resolved multiple transition issues, preparing both applications for deployment and ensuring they met operational requirements
- Real-Time Data Integration: Successfully integrated live data from Azure Data Lake Gen2 within the project timeline, earning recognition from business unit champions and leadership for exemplary performance
- Azure Data Factory Expertise: Demonstrated advanced proficiency in leveraging Azure Data Factory to facilitate seamless data migration from on-premises environments to cloud infrastructure
- Redesigned and optimized ADF pipelines to align with cloud-based architecture, ensuring efficient data transfer
- SQL Script Conversion: Employed strong SQL skills to convert over 50 PL/SQL scripts into T-SQL scripts, integrating these optimized solutions into both applications using Azure Data Factory, all completed within the designated timeframe
- Agile Methodologies: Collaborated effectively within Agile and Scrum frameworks to achieve project milestones and adhere to strict deadlines
- Strategic Planning for ADF Enhancements: Contributed to the strategic planning of enhancements for Azure Data Factory, focusing on optimizing efficiency, simplicity, and cost-effectiveness for end-users
- Successfully executed and finalized the project
Responsibilities: Led API integration transition, modified Web API and Web Forms applications, implemented secure OAuth 2.0 authentication, developed LINQ queries, optimized performance via caching, implemented error handling and logging, led data source migration from Oracle to Azure Data Lake Gen2, resolved migration issues, integrated real-time data, optimized Azure Data Factory pipelines, converted SQL scripts, collaborated in Agile environment, contributed to strategic planning of ADF enhancements.
Technologies: Azure Data Factory, Azure Data Lake Gen2, Oracle Database (WellView), .NET Framework, C#, ASP.NET Web API, T-SQL, PL/SQL, OAuth 2.0, LINQ, In-memory Caching, Agile Methodologies, Scrum
Senior Developer, App Modernization
Duration: 06/2023 – Current
Summary:- Business Logic Development: Implemented robust business logic using Visual Studio and the
- NET Core Framework, ensuring high performance and maintainability
- Full Rebuild of Legacy System: Recreated a legacy
- NET app from scratch using Azure Functions, MS SQL Server, and React, leveraging serverless architecture for scalability and cost efficiency
- Azure AI Document Intelligence: Designed and implemented custom models to process and extract data from complex PDFs using Azure AI Document Intelligence
- Data Integration and Reporting: Automated extraction pipelines via Azure Functions, storing structured results in Azure SQL DB, later visualized in Power BI dashboards
- SSIS to ADF Migration: Migrated multiple SSIS packages to Azure Data Factory (ADF) to modernize ETL workflows, achieving improved reliability, maintainability, and performance in cloud environments
- AI-Powered Productivity: Utilized GitHub Copilot for generating unit test cases, code snippets, and API documentation, boosting overall development speed and consistency
- Data Access Layer: Coded business logic and database interactions using Entity Framework and the Repository Pattern, promoting separation of concerns and code reusability
- LINQ Utilization: Leveraged Entity Framework LINQ for efficient data access and manipulation, enhancing query readability and performance
- SQL Development: Created and modified stored procedures, and views in SQL Server, integrating them into the application for optimized data handling
- Complex Query Development: Developed complex SQL queries to support business requirements and improve data retrieval efficiency
- RESTful Service Creation: Developed RESTful services using Azure Functions, building HTTP services that formatted JSON responses with web API media type formatter for client consumption
- Dynamic PDF Generation: Generated dynamic PDFs using MigraDoc within Azure Functions to meet reporting requirements
- Authorization Implementation: Implemented token-based authorization for secure access to service endpoints
- Version Control Management: Worked with the distributed version control system DevOps, utilizing feature branches, rebasing, and merging strategies to maintain code integrity during collaborative development
Responsibilities: Developed business logic, rebuilt legacy system with serverless architecture, designed Azure AI Document Intelligence custom models, automated data extraction and reporting, migrated SSIS packages to Azure Data Factory, used GitHub Copilot to improve development, implemented data access layers with Entity Framework and Repository Pattern, developed complex SQL queries and stored procedures, created RESTful services with Azure Functions, generated dynamic PDFs, implemented token-based authorization, managed version control with DevOps.
Technologies: Visual Studio, .NET Core, C#, HTML5, Entity Framework, Azure AI Document Intelligence, Agile Methodologies, Web Services, Windows, Angular, TypeScript, CSS, SQL Server, IIS, DevOps
Education
- Bachelors in Technology
Megha Institute of Engineering and Technology
2016 – 2020