Deepika M Email & Phone Number

United States

MTEFC (Equipment and Financing Corporation) has 4 sub-systems – ZETA, NAVISION, Zdocs and ON-BASE. ZETA mainly handles loan applications of M&T bank. This application allows the customers to create new loan applications, schedule the payments, status of applications. NAVISION is a General-Ledger system which daily generates GL files which includes credit and debit details. ON-BASE will handle the scanning of documents and printing and save the images of the cheques submitted by customers. Zdocs Mainly handles documents or agreements like security documents, Lease Agreements, Loan Agreements. • Responsible for developing applications for customers and partners using C# and .NET Framework.. Solved multiple production bugs by finding the root cause.• Migrating the SSIS Jobs to Automic jobs(creating new jobs in Automic and changing the logic according to automic software) based on the bank policies.• Worked and resolved multiple vulnerabilities like Security patches, Microsoft Windows Defender, Symantec EndPoint Protection, visual studio vulnerabilities present in the system.• Creating Runbooks/ RTIM requests for handling the prod environment Vulnerabilities.• Managing the SQL Server databases and Written Queries using T-SQL Statements, Views, User Defined Functions, Stored Procedures, in SQL Server for inserting/Updating/Deleting the data into the relational tables.• Developed test cases and responsible for integration testing of the applications and SSIS packages.• Supported User Acceptance Testing and deployment phases of the software deployment.• Worked on multiple bugs in the application and found root cause by debugging.• Participated and contributed to the agile sprint planning, retrospective and big board planning meetings.• Coordinated with Business Analysts, clients and end users in requirement gathering and analysis.

Hyderabad, Telangana, India

1.Responsible for developing applications for customers and partners.2.Developed Business logic by implementing Object Oriented Programming languages (OOPS) concepts, abstraction, encapsulation, inheritance, polymorphism in C#.3.Support/modify the existing applications, web services and windows services as per user requirements.4.Managing the SQL Server databases and Written Queries using T-SQL Statements, Views, User Defined Functions, Stored Procedures, in SQL Server for inserting/Updating/Deleting the data into the relational tables.5.Developed a web application to create relationships between multiple Microsoft products as part of automation. The Presentation Layer is implemented in ASP.Net with HTML and Cascading Style Sheets (CSS).6.Created and deployed SSIS Packages to establish the connection between multiple systems and fetch the data from the multiple systems.7.Worked on SQL performance tuning to optimize the performance of the queries using the SQL Profiler.8.As part of agile methodologies, attended daily stand-up calls, worked on stories created as they are assigned per sprint basis.9.Participated in requirement gathering and analysis meetings to understand the requirements and point the story accordingly.10.Worked on Multiple ICM tickets and solved them by performing Root Cause Analysis and fixing the code.11.Worked in a collaborative development environment, provided assistance and guided to fellow team members.12.Responsible for managing Dev, Test, and production environments.13.Responsible for build and deployment of applications in production using Azure Devops.14.Good knowledge on Azure like key vault for storing secrets, Queues, logging, and knowledge on postman for request/response and WEBAPI.15.Developed test cases and responsible for integration testing of the applications and SSIS packages. 16.Supported User Acceptance Testing and deployment phases of the software deployment.

Hyderabad, Telangana, India

Hyderabad, Telangana, India