• Partner with developers, architects, other technical team members and database administrators to design and develop scalable integration solutions. • Drive and manage the development and maintenance of the data architecture artifacts according to the data architecture standards, for any solution or segment architecture, including roadmap, data models, mastership, and utilization for the data within the business.• Identify and propose potential data model and data integration changes and improvements, including decommissioning systems and master data management solutions, data services.• Lead projects within API architecture.• Work directly with Portfolio managers, IT managers and Product managers to implement the target portfolio and address data architecture issues in the portfolio.• Design complex enterprise integration solutions with industry standard technologies including Microsoft .NET, SQL Server, Oracle, MuleSoft, Salesforce, Angular.• Write functional specifications using cases and requirements that describe the necessary system changes or new system features.• Collaborate with cross-functional teams, engineers, and software developers to select appropriate design solutions and ensure the compatibility of system components• Mentor and provide API architectural guidance to multiple teams building innovative applications.

• Design and development of modernization of an existing ASP.NET web applications to REST Web API based solution using Microservices architecture.• Upgradation of existing ASMX based web services to RESTful Web APIs.• Upgradation of existing .NET Framework 2.0 based Windows services/Jobs to .NET CORE 2.1 and .NET Standards 2.0.• Replace existing ADO.NET based Data Access Layer with Microsoft Entity Framework Core. Along with that development of complex LINQ and Lambda queries.• Design and development of complex Database Objects such as Tables, Stored Procs, Views, Functions, Custom Types, Indexes in Microsoft SQL Server 2014.• Performance analysis of slow running DBOs and fine-tuning of the SQL using Execution Plan and Profiler.• Design and development of complex SSRS & Power BI reports.• Creating feature branches, Baseless code merge, migration of shelve-sets using Team Foundation Server.• Use of Team Foundation Server and Git for housekeeping of the code and version control.• Hosting of the Windows Service Jobs, Web Applications, Web APIs on the QA and Stage servers using Teamcity and CARA.• Analysis of the existing system to see how the new requirement can fit in and doing the impact analysis to figure out what all components are required to be changed. • Major and minor enhancements of existing web applications using Microsoft Technologies including .NET Framework 4.6.1, ASP.NET, C#.NET, MS-SQL Server.

•Requirement analysis, UI mockups, design, development, and integration.•Development of new features and services based on the requirements proposed by the customer.•Preparation and delivery of the functional requirements, solution designs based on the requirements.•Design, development, and maintenance of databases.•Carry out construction and testing activities.•Carry out integrated testing within the application and also in between the applications.•Review the documents and requirements given by the customer.•Perform the impact analysis on the requirements given by the customer & understand the feasibility of the requirements.•Technical evaluation of candidates for open positions.•Task validation and code review of the components developed by team.

• Development of modules in the web application.• Development of Database objects such as Stored Procedures, Views and Functions.• Alignment/UI Development of various screens for entire application including DDC, Commission, Contract and Finance and Accounting.• Implementing Logging mechanism and Exception handling for proper trouble-shooting in the application.• Involvement in designing of the RUD (Requirement Understanding Document).• Involvement in the creation of Unit Test Cases for modules.• Estimation of timelines and effort required for the application development.• Use of TFS for version control.• Unit testing of the application before releasing the module.• Interacting with client for understanding the requirements.

• Major and minor enhancements of existing web applications using Microsoft Technologies including .NET Framework 2.1, ASP.NET, C#.NET, MS-SQL Server. • Resolution of the issues/enhancements/change requests raised by client.• Development of Database objects such as Stored Procedures, Functions, Views and reusable components using MS SQL Server 2005.

Successfully completed my initial training in Hyderabad and started working for a Japanese client - Nissan Motors Limited. My primary responsibilities were -Resolution of the issues/enhancements/change requests raised by client using Microsoft Technology stackDevelopment of Database objects such as Stored Procedures, Functions using SQL Server Management Studio.

Application development and maintenance with PROGRESS 4GL and PROGRESS Database