Name: Pranay

Email: adv1my@r.postjobfree.com

Phone No: 440-***-****

Professional Summary:

•Around 4 years of professional experience in IT with a focus on analysis, design, development, testing, implementation, and maintenance of enterprise applications using Microsoft development technologies.

•Strong experience working in the development of applications using C#, Visual Studio, VB.NET, .NET 6/5/4.8/ 4.7, ASP.NET Core 3.1, ASP.NET MVC, SQL Server 2019/2017, TFS, ADO.NET/Entity Framework, LINQ, WCF, Microsoft Azure, IIS, Web Forms, Razor, XML, JSON, SOAP, SSRS, SSIS, and DevOps.

•Expertise in developing applications using HTML, CSS, JavaScript, jQuery, Bootstrap, TypeScript, Angular JS, React JS, AJAX, and JSON.

•Extensive knowledge in Entity Framework, Object Relational Mapping (ORM), Code First, Database First approaches, Security, Performance, CRUD operations and Migrations.

•Experience creating Web Services (SOAP, REST API, and Window Services) in C# and the.NET Framework.

•Experience in Azure Service Bus, Azure Logic Apps, Azure Functions, Azure App Services, Azure Key Vault, Azure Active Directory, Azure Storage, Azure Cosmos DB, Azure APIM, Azure DevOps, Azure Blob Storage, Azure Queue Storage and PaaS Services.

•Strong Object-oriented Analysis and Design skills and knowledge of OOPS concepts such as Collections, Interfaces, Multi-threading, Synchronization, Exception handling, Data Structures, and Algorithms with expertise in implementing design patterns, and solid principles.

•Expertise in database design (RDBMS), programming, implementation, development, data migration, data analysis and query optimization using MS SQL Server, Oracle, and MS Access.

•Strong analytical and conceptual skills in SQL/T-SQL and creating complex Stored Procedures, Views, Triggers, Functions, and Performance Tuning.

•Experience with ORM and its related components: Entity Framework, Language-Integrated Query (LINQ) queries and retrieving data from different data sources (LINQ to Objects, LINQ to XML, and LINQ to SQL), ASP.NET providers and typed datasets.

•Experienced working with various Extract, Transform and Load (ETL) tasks and proficient in creating SQL Server Integration Services (SSIS) packages, and SQL Server Reporting Services (SSRS) reports.

•Experience with Kendo UI and Telerik controls in building interactive and high-performance applications for rich data visualizations.

•Experience in implementing various design patterns such as Singleton, Factory, Facade, Template, and Dependency Injection.

•Experience in unit testing using X-Unit and N-Unit, with knowledge of Test-Driven Development (TDD) and Behavior Driven Development (BDD).

•Hands-on experience with source control, issue tracking and CI/CD tools such as VSS, TFS, Git, Bitbucket, Jira, Rally, Jenkins, and Azure DevOps.

•Expertise in code reviews, troubleshooting, debugging, and enhancing application performance.

•Experience in Agile and Scrum environments, as well as participation in all phases of SDLC, such as SRS, requirements definition, design and analysis, programming and testing, and system implementation.

•Strong communication, analytical and problem-solving skills with expertise in schedule management, client interaction and understanding business application, business data flow and data relations.

•Highly adaptable in quickly changing technical environments with very strong organizational and analytical skills.

Technical Skills:

.NET Technologies

.NET 6.0/5.0/4.8/4.7, MVC 5/4, ASP.NET Core 3.1, Web Services,

Windows Forms, ADO.NET, Entity Framework, LINQ, AJAX, WCF, WPF, SOAP and RESTful Services

Languages

C#, .NET, ASP.NET, TypeScript

Database

SQL Server 2019/2017, Oracle, MS Access, NoSQL, TSQL

Cloud

Microsoft Azure

Web Technologies

Scripting

and

XML, IIS, HTML5, CSS3, JavaScript, jQuery, Angular, Razor, Bootstrap

Version Control

TFS, GIT, Bitbucket

Reporting Tools

SQL Server Reporting Service (SSRS)

Others

Azure DevOps, Jenkins, SOAPUI, JIRA, Postman, Microsoft Visual Studio

2019/17, TDD, BDD, OAuth, and SQL Server Management Studio

Professional Experience:

Client: Regions Bank, Birmingham, AL Feb 2022 – Till Date

Role: .Net Developer Responsibilities:

•Involved in the development and enhancement of existing applications running on the Microsoft Azure platform.

•Engaged in requirement gathering, designing, development, UI reviews, and maintenance.

•Involved in production support to monitor daily jobs that run on production. fixing issues related to jobs and scripts whenever needed.

•Developed server-side code using ASP.NET.

•Created dynamic web pages using web controls and AJAX, HTML, and CSS.

•Created NuGet packages, which are used in several applications.

•Implemented application business logic in C# with the MVC design pattern.

•Performed extensive logging and error handling in C#.

•Implemented JWT-token based authentication.

•Used REST services to fetch/push information from endpoints.

•Used ADO.NET Entity Framework extensively for retrieving, querying, and manipulating data in the database using LINQ.

•Implemented CRUD functionality with Entity framework in ASP.NET MVC and implemented sorting, filtering, and paging with Entity Framework Code First in MVC.

•Performed code review, debugging, bug fixing, unit testing, Integration testing and production support.

•Developed database objects like complex Stored Procedures, Cursors, and Tables, Views, User- Defined Functions, in MS SQL Server for inserting/Updating/Deleting the data into the relational tables to implement the business logic and created clustered and non-clustered indexes.

•Using joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables and calculations from different databases and debugging stored procedures to improve query performance.

•Created ETL packages with different data sources (SQL Server, flat files, Excel source files, XML files, etc.) and then loaded the data into destination tables by performing various kinds of transformations using SSIS packages.

•Knowledge of NoSQL database security considerations, including authentication, authorization, and encryption

•Developed various stored procedures for data retrieval from the database and generating different types of reports using SQL Reporting Services (SSRS).

•Involved in functional and unit testing of the application.

•Worked on Microsoft Azure Storage - Storage accounts, blob storage.

•Used Dependency Injection with the Singleton pattern for application-level services.

•Deploying and managing applications in the data center, virtual environment, and Azure platform as well.

•Worked with GitHub, Team Foundation Source Control (TFS), as the source for version control and project issue management.

Environment: Visual Studio 2019, C#, .NET 6, SQL, REST, Azure, MVC, .NET Framework, JavaScript, CSS, ADO.NET, Entity Framework, Web API, HTML5, N-Unit, LINQ, NodeJS, WCF, AJAX, HTTP, XML, jQuery, SSIS, SSRS, NoSQL, SQL Server 2019, IIS, T-SQL, Bootstrap, GIT, TFS.

Client: KeiraD Pvt, Ltd/ Hyderabad, India June-2019 – April-2021 Role: .Net Developer

Responsibilities:

•Involved in all phases of SDLC, including requirements gathering, design, programming, and testing.

•Analyzed the requirements and prepare the technical and functional specification documents.

•Implemented the Autocomplete using type-ahead and timeout sessions using jQuery & AJAX.

•Implemented an event logging system for the project to record the error logs using N-Log from NuGet Packages.

•Designing database schemas in line with the end user’s business requirements.

•Developed highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes.

•Created a client-side JavaScript library for various standard control validations using regular expressions and DOM methods.

•Responsible for designing and developing reusable UI components like MVC Master Pages “Layouts and Nested Layouts”, “View Start” and MVC User Controls “Partial Views” using HTML5, CSS3, and Bootstrap in the Razor engine.

•Experience designing NoSQL data models that accommodate data access patterns and performance requirements, including denormalization, embedding, and partitioning.

•Used joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables and calculations from different databases.

•Created SSIS Packages to consume data from a RESTful Web API/SOAP API using C#, transform JSON/XML data and transfer it to SQL Server using Business Intelligence Development Studio.

•Worked on posting data to Oracle ERP Cloud using REST API services.

•Created Pipelines in ADF using linked services/datasets/pipeline/ to extract, transform, and load data from different sources like Azure SQL, Blob storage, and Azure SQL Data Warehouse.

•Used different transformations (Derived Column, Data Conversion, Condition Split, Lookup Transformation, Multi-Cast Transformations) under Data Flow Task while pulling and loading data from one source to another source to make the data clean and consistent.

•Proficient in using MS Build to manage version numbers, generate release notes, and deploy releases to production environments.

•Experience with managing Kafka topics, including creating topics, configuring topic attributes, and managing topic partitions.

•Worked with ADO.NET and LINQ to access and update database and data tables.

•Worked with DDL/DML triggers, tables, user-defined functions, indexes, user profiles, relational database models, cursors, common table expressions (CTEs), and data dictionaries.

•Created scripts for test cases in development and QA environments and made sure that the test results were as expected according to the business requirements document/functional specifications.

•Created reports using SSRS from OLTP and OLAP data sources and deployed them on the report server.

•Worked on implementation of logging, error handling by using an event handler, and custom logging for the packages. Involved in the complete life cycle of creating SSIS packages, building, deploying, and executing the packages in both the LLE and production environments.

•Experience integrating NHibernate with other frameworks, such as ASP.NET, or WCF

•Ability to create responsive UI with WPF layout containers and controls Knowledge of WPF styling and theming, including custom control.

•Experience processing SQS messages in a distributed system, including using worker processes, load balancing, and throttling.

•Created, monitored, and scheduled existing/new jobs in the production environment.

•Used Postman to test Web API functionality.

•Used GitHub, Bitbucket for source control and Rally for project management.

Environment: Visual Studio 2019, .NET Framework 4.8, Entity Framework, ADO.NET, ASP.Net, C#, NoSQL, SQL server, SSIS, SSRS, XML, JavaScript, CSS, jQuery, HTML5, LINQ, Web API, Jira, Vue JS, ASP.Net MVC, SQS, Angular, Bootstrap, Bitbucket, Azure DevOps, Nunit, NodeJS, AJAX, IIS, WPF, Kafka, NHibernate, SQS, WCF services, MS Build.

Client: Country’s Cart, Hyderabad, India June-2018 – May-2019 Role: .Net Developer

Responsibilities:

•Developed applications using Visual Studio, SQL Server, C#, ASP.Net, and ADO.Net, and Entity Frameworks.

•Developed application UI pages using AngularJS, HTML5, CSS, Bootstrap, JavaScript, jQuery, AJAX, and JSON.

•Designed the graphical user interface using ASP.NET MVC and the business logic was coded in C# (MVC controllers).

•Worked on .NET web forms and .NET web services using Visual Studio.Net, and .NET Framework.

•Developed ASP.Net pages using ASP.NET, web form controls, custom user controls, and HTML server controls in C#.

•Designed and developed various abstract classes, interfaces, and inheritance to construct the business logic using C#.NET, and ADO.NET.

•Used Entity Framework to connect the web forms to data sources such as MS SQL Server for manipulating data in the database.

•Working with the Enterprise Identity Access Management (IAM) team to onboard the users to Active Directory groups using the enterprise IES tool to restrict unauthorized access to applications.

•Configuring the App Dynamics tool to monitor application performance.

•Worked on SQL Server Integration Services (SSIS) packages to extract, transform and load (ETL) data from different databases.

•Creating SQL Server Reports, handling sub-reports, writing stored procedures and queries for generating drilldown reports using SSRS.

•Involved in gathering the requirements from clients for product design and enhancements.

•Involved in enhancing Windows Forms Applications that interact with a Microsoft SQL Server database using ADO.NET.

•Developing complex T-SQL code such as stored procedures, CTEs, functions, triggers, indexes, and views for the application.

•Create scheduler jobs to pull data from various sources and file formats, such as flat files, dB files, csv files,.dat files, and Excel files, and then load the data into SQL Server tables.

•Designed and developed the portal using Angular 8 along with HTML5, CSS4, TypeScript and Bootstrap.

•Proficient in querying NoSQL databases, including using query languages such as MongoDB Query Language (MQL), Cassandra Query Language (CQL).

•Worked on performance tuning, SQL query enhancements, and code enhancements to achieve performance targets.

•Used JSON for data exchange between client and server to reduce network load and update only certain components of the website.

•Debugged stored procedures and improving query performance while retrieving millions of records by creating indexes.

•Experience with integrating WPF with other .NET technologies, such as Entity Framework or ASP.NET.

•Responsible for creating and scheduling the SQLSERVER jobs and monitoring the status of the scheduled jobs.

•Develop unit test plans for checking the functionality of each component.

•Understanding of Kafka Streams and its use cases for real-time stream processing and event-driven architectures.

•Knowledge in optimizing NHibernate performance, including understanding the impact of lazy loading, caching, and fetching strategies.

•Experience in managing SQS messages, including sending messages, receiving messages, and deleting messages.

•Experience automating build processes with MS Build, including setting up continuous integration builds and, creating build scripts.

•Handling builds and release management work for all the applications under our team.

•Used Jira, GIT and Bitbucket for source control.

Environment: Visual Studio 2017, .Net 4.7, ASP.NET MVC, Angular 8, C#, RESTful Web API, JSON, NodeJS, LINQ, ADO.NET, Entity Framework, JavaScript, AJAX, jQuery, NoSQL, SQL Server, SSRS, SSIS, Azure, HTML5, CSS3, WPF, Kafka, NHibernate, MS Build, SQS, WCF.

Master’s in Information Systems at Cleveland State University-2022

Bachelors in Computer Science at Lovely Professional University-2019

Contact this candidate