Lucknow(Uttar Pradesh)| | | agarwal-059a701 Profile Accomplished Senior Software Developer with 8 years of experience in designing and implementing enterprise-grade applications. Seeking to transition into a Tech Lead role to drive technical excellence, mentor development teams, and architect scalable solutions. Passionate about optimizing software performance, enhancing system reliability, and aligning technology with business goals. Professional Summary &bull; 8+years of experience in IT industry with skills inC#,.net,.net core,VB6,Windows Application,MVC,LINQ,SSRS,SSIS,Snaplogic,PowerBI,Python and SQLServer. &bull; Having good knowledge in Healthcare and Banking domain. &bull; Good in coding,troubleshooting and documentation. &bull; Strong understanding of Object oriented programming and currently working on it. &bull; Development experience in migrating VB6 applications to Windows application. &bull; Backend experience of RestAPI services. Technical Skills Software Development: .NET Core, C#, REST API, Soap Services, Windows Applications, XUnit Test cases, VB.Net, LINQ Database Management SQL Server, SSRS, SSIS, Crystal Reports, Power BI Cloud Technologies: Microsoft Azure (AZ-900 Certified), SnapLogic Architecture &amp; Design Microservices, API Development, Scalable System Design Development Methodologies &amp; Tools Agile, DevOps, CI/CD, Visual Studio API Testing &amp; Development Experience &amp; Projects Undertaken Company &ndash; Wipro - Apr, - Current LBG &ndash; RMS Migration Page 2 About Project RMS is a suite of SOAP APIs used across multiple applications within Lloyds Banking Group, requiring migration to REST APIs to support new updates and enhanced features. The migration involved refactoring multiple applications to accommodate changes in API calls and updating implementations to align with the modernized API methods, ensuring improved performance, scalability, and maintainability. Technology Used Visual Studio , REST API, SOAP API, .net core, SQL Server, Windows Application, C# Roles and Responsibilities API Change Analysis &amp; Implementation: Reviewed changes introduced by third-party APIs and incorporated necessary updates into our API calls. Application Impact Assessment: Analyzed applications utilizing the affected API methods and implemented corresponding modifications to ensure compatibility. End-to-End Testing: Conducted comprehensive testing to validate system functionality stability. Client Collaboration &amp; Demos: Provided demonstrations to clients, ensuring UI changes aligned with expectations and received necessary feedback for refinements. DevNXT - Investment About Project DevNXT is Wipro&rsquo;s internal migration platform designed to assist multiple customers in modernizing their legacy applications by transitioning them to the latest technologies. The tool automates the migration process, significantly reducing manual effort while ensuring accuracy and efficiency. DevNXT supports migrations such as .NET Framework to .NET Core, VB6 to Windows applications, and various other legacy-to-modern technology transformations, making it a robust solution for seamless application modernization. Technologies Used C#, .Net core, Windows Application, Angular, VB.Net, Rest API, SOAP API Roles and Responsibilites &bull; Requirement Analysis &amp; Migration Strategy: Analyze customer requirements for migrating legacy applications to modern architectures. &bull; Wrapper Development: Design and implement wrapper solutions to facilitate seamless migration while ensuring compatibility with modern frameworks. &bull; Customer Collaboration: Engage with customers to understand migration challenges, execute migration processes, and provide technical guidance. &bull; Error Resolution &amp; Optimization: Identify, debug, and resolve migration-related issues, ensuring minimal downtime and accurate syntax transformations. &bull; Enhancement &amp; Documentation: Continuously improve migration tools, add missing syntax conversions, and document best practices for future use. Page 3 LBG About Project LBG, a banking-based project, involved migrating legacy VB6 applications to modern Windows applications to enhance performance, security, and maintainability. The migration aimed to modernize the existing system while ensuring seamless functionality, improved user experience, and compliance with banking regulations. The project focused on re-engineering critical banking applications while minimizing downtime and maintaining data integrity. Technologies Used VB.Net, .net core, Windows Application, c#, Crystal Reports, SSRS Reports, SQL Server Roles and Responsiblities Legacy System Analysis: Conducted in-depth analysis of legacy VB6 applications to identify migration requirements and challenges. Application Migration: Utilized Wipro&rsquo;s internal migration tools to successfully migrate 6-7 applications, resolving ensure seamless functionality. Legacy System Dependency Analysis: Conducted in-depth analysis of all dependencies of legacy application which were in VB6 and migrated those to .net core and integrated with migrated Windows Application and resolved issues Report Migration &amp; Optimization: Researched and executed the migration of Crystal Reports to SSRS, successfully converting 20 reports while ensuring accuracy and performance improvements. Company &ndash; TCS Mar, &ndash; Apr Humana About Project The Formulary Enterprise System was designed to serve multiple user groups by automating the ingestion, management, and analysis of formulary and drug information. The system seamlessly updates formulary data by integrating external sources, ensuring real-time coverage details for various health plans. Additionally, it allows users to analyze, edit, generate reports, and export formulary data based on business requirements. Technologies Used C#, .Net Core,REST API, SOAP, Server, IIB, Kafka topic, Power BI, MVC, Xunit Test Cases, TFS VSTS deployments Roles and Responsiblities Backend Service Development: Implemented RESTful services consumed by the UI to display data as per business requirements. Unit Testing &amp; Quality Assurance: Developed manual unit test cases and conducted end-to-end testing for all workflows before production deployments to ensure system stability. SSRS Report Design: Created SSRS reports to track and analyze data, including reports on expired drugs. ETL Development &amp; Data Management: Designed and implemented SSIS packages to load master data and integrate new drugs into the system. Deployment &amp; Version Control: Managed deployments using TFS and VSTS, ensuring smooth release cycles. Page 4 SnapLogic Integration: Designed scheduled SnapLogic pipelines to transfer data to downstream applications based on specific data dependencies. Process Optimization: Identified and implemented a value-added enhancement that was not initially requested, successfully getting it approved and leading to significant process improvements. SQL Development : I have designed and implemented multiple stored procedures and complex CTE queries to meet client requirements efficiently. For REST APIs, I developed optimized stored procedures to handle data retrieval and processing. Additionally, I performed performance tuning to enhance query execution, particularly for scenarios involving large datasets, ensuring minimal latency and improved efficiency. Humana About Project Developed a comprehensive healthcare analytics dashboard to visualize and monitor formulary data for health plans. The dashboard integrated data from multiple external sources to provide real-time insights into drug coverage, expiration, and utilization. The system enabled stakeholders to analyze formulary updates, generate customized reports, and track key metrics through interactive visualizations Technologies Used Power BI, SQL Server Roles and Responsiblities &bull; Designed and developed interactive Power BI dashboards to present drug coverage data and utilization metrics. &bull; Integrated data from various sources, including SQL Server and excel/flat files, for seamless data visualization. &bull; Conducted performance tuning on complex queries to ensure fast and efficient data loading in the dashboard. &bull; Collaborated with business users to gather requirements and iterated on dashboard design based on feedback. Education B.TECH (COMPUTER SCIENCE) | SEPT &ndash; JUNE | SHRI RAMSWAROOP MEMORIAL UNIVERSITY LUCKNOW 12TH| | EMMA THOMPSON SCHOOL LUCKNOW 10TH| | EMMA THOMPSON SCHOOL LUCKNOW Personal Details Father&rsquo;s Name Mr. Raj Kishore Agarwal Date of Birth 12th Jan, Marital status Married Page 5 Languages English and Hindi