Sql Server C#

Priyanka Lalitha Thulasi

.Net Developer

Mob : 302-***-****

Email : **********.***@*****.***

S U M M A R Y

• 8+years of experience in Analysis, Design, Development, Testing, Implementation and Maintenance of client/server based Web Applications using Microsoft Technologies.

• Strong in Object Oriented Programming (OOPs) concepts & Design Patterns.

• Experience on working in Waterfall Model and Agile – Scrum methodology.

• Hands on experience in design using Object Oriented Programming Principles like Encapsulation, Inheritance, Polymorphism, reusability, and Design patterns like MVC, Abstract factory a standard solution to common problems in software design.

• Expertise in ASP.Net, C#, WCF, Azure, .Net Core Web applications/APIs, Entity Framework, ADO.Net, LINQ, Web Services, JQuery and JavaScript.

• Experience in development and implementation of Web APIs, responsible for developing WCF based Service, Message Contracts, and REST API.

• Worked extensively in Data Migration, Crystal Reports, SQL Server Database Design, SQL Query Optimization, Code Publish, Configuring Database and Client Servers.

• Experience in designing and branding Master Pages utilizing Server Controls, User Controls, Data Grid control, Form Validation controls, Custom controls, and CSS.

• Experience in securing web applications using ASP.NET authentication (Forms-based Authentication) and authorization mechanisms like authorizing Users and Roles.

• Experience in ADO.NET components such as Data Connection, Data Command, Data Readers, Data Sets and Data Adapter.

• Sound knowledge in writing stored procedures, Triggers, Cursors, views, user defined functions, database performance tuning, indexing, database backup and restore.

• Strong exposure in Project Execution, Code Review and Project Support

• Hands on experience in Insurance, Hospitality and Realty sector

• Experience of working in the complete SDLC process (Software Development Lifecycle Process), design, documentation, development, QA support, UAT support (Including deployments, Unit testing C# with NUnit).

• Experience in bug fix, debugging, troubleshoot and deliver clean and quality work.

• Create Unit test project with NUnit and .NET Core / ASP.NET for build the Client/server web application.

• Migration of the old application to new web technologies with high productivity & automate approach.

• Excellent analytical, designing and programming abilities in using technology to create elegant, flexible, and maintainable solutions for development problems.

• Excellent technical skills in SQL Server Database Design, Analysis, Normalization and in writing tables, Stored Procedures, Views, Triggers, Indexes, Constraints and SQL Query optimization.

• Experience on other technical skills like SCM Tools (TFS, GIT, Bitbucket and VSS) and task status tools like TFS, JIRA.

• Experience in manage onshore/offshore/stakeholders team for development task, track task, record JIRA, coding, peer review, unit testing and SIT in development phase. T E C H N I C A L S K I L L S

• Web Technologies: ASP.Net Web Forms 4.5/4.0/3.5/2.0, ASP.Net Core 3.1, ASP.Net Core API, HTML, CSS, JavaScript, JQuery

• Languages: C#, JavaScript, .Net Core.

• Databases: MS-SQL Server 2016/2012/2008R2/2005.

• Web Servers: IIS 7.5/7.0/6.0/5.0

• OS: Windows 10/8.1/7/XP, Windows Server 2003/2008R2.

• Technologies: Object-Oriented Design/Development, Design Patterns, ADO.Net, .NET Framework 4.7/4.6/4.5/3.5/2.0, WCF, Web API.

• Tools: VS 2019/2015/2013/2010/2008, SQL Server Management Studio 2015, PCF, Harness, Splunk, Azure

• Version Control: Visual Source Safe (VSS), TFS, Bitbucket, JIRA.

• Reporting Tools: Crystal Reports and DevExpress

• Unit Test Tools: NUnit.

P R O F E S S I O N A L E X P E R I E N C E

Project Title : Order To Cash System

Client: Cleveland Cliffs, Chicago, IN

Company Name : Infomatics Corp.

Nov 2022 – Till Date

.NET Lead and Developer

This .Net core web application is developed for Cleveland Cliffs to manage the purchase order from the customer till delivery. Cliffs acquired Arcelor Mittal and in this application we integrated Cliff customer which is referred as CORP and Arcelor Mittal referred as LLC. We are using .Net Core web application as front end, API’s developed in .Net core to fetch data and the database is Sql server. We are using many batch jobs to push data from existing red system to the new integrated databases. Queue application is using to generate various reports of the customers. This application is deployed in pcf through harness pipeline and build are created through bamboo. Responsibilities:

• Involved in all phases of project life cycle includes analysis, design and development.

• Worked in Agile Methodology(Scrum) to meet timelines with quality deliverables.

• Responsible for designing/developing ASP.NET core web application to fulfill the client requirements.

• Implemented JWT token based authentication to secure the ASP.NET Core Web API and provide authorization to different users.

• Created unit test project using NUnit for the application and developed test methods in test classes.

• Developed Stored Procedures, Triggers and views for performance tuning and retrieval of data.

• Responsible for development, Unit testing of web applications in .NET Core using C#.

• Developed Web APIs for exposing functionalities to various client applications.

• Worked with Web Services, State management, Caching features, configuring optimizations and securing the web application.

• Responsible for monthly deployment to Prod, UAT and QA through dev ops pipeline and change management process.

• Worked with QA, UAT, different api teams for the successful delivery of the project. Environment: .NET Core, Visual Studio 2019, C#.NET, SQL Server, 2018, LINQ, ASP.NET MVC, Web Service

Tools: Visual Studio, JIRA, Change Management, PCF, Bamboo, Harness. Project Title : Data Management Utility

Client: Chubb Insurance, Wilmington, DE

Company Name : Infomatics Corp.

Jan 2022 – Nov 2022

.NET Developer

This application is developed for Chubb commercial portfolio. We are using .Net Core web application as front end, API’s developed in .Net core is the API and the database is sql server. This application is using for assign/reassign underwriters for various policies. Various reports are generating and sending to higher level management by underwriter leads. This application is deployed in azure through DevOps Jenkin pipeline. We are doing enhancements and adding new modules to the application in Agile sprints. API is the middle layer, it is a general API which is using by different team for accessing the data.

Responsibilities:

• Worked in Agile Methodology(Scrum) to meet timelines with quality deliverables.

• Responsible for development/deployment of ASP.NET core web application to fulfill the client requirements.

• Created unit test project using NUnit for the application and developed test methods in test classes.

• Developed Stored Procedures, Triggers and views for performance tuning and retrieval of data.

• Responsible for development, Unit testing of web applications in .NET Core using C#.

• Developed Web APIs for exposing functionalities to various client applications.

• Worked with Web Services, State management, Caching features, configuring optimizations and securing the web application.

• Responsible for monthly deployment to Prod, UAT and QA through dev ops pipeline and change management process.

• Worked with QA, UAT, different api teams for the successful delivery of the project. Environment: .NET Core, Visual Studio 2019, C#.NET, SQL Server, 2018, LINQ, ASP.NET MVC, Web Service

Tools: Visual Studio, JIRA, Change Management, Azure. Project Title : FastTrack Integration

Client: Chubb Insurance, Wilmington, DE

Company Name : Infomatics Corp.

Nov 2020 – Dec 2021

.NET Developer

In Chubb commercial portfolio, agents and brokers are purchasing various chubb insurance products through FastTrack application. FastTrack Integration acts as a middle layer between FastTrack UI and downstream applications. Now we have 22 insurance products in UI and team is working to add more products. FastTrack UI issues the source xml based on the input from agents and brokers. Integration applications windows services picks up the xml and get the necessary details from other sources. It will transform the received xml based on conditions for each product. We have 6 Windows/WCF and Webservices for processing and an asp.net application for support activities. Integration will generate one xml for genius and another one for tracker based on the pre-defined formats. Genius will validate the data and process at genius end and issue a response xml. It will determine whether the process is success or not. If it is failure, it has to reprocess through support portal on adding required details.

Responsibilities:

• Developed ASP.NET web application for the support ui to reprocess the input files.

• Developed WCF/Windows/Web services in C# for processing the files received from the input.

• Project planning and defect management- Tracking the status of defects on daily basis.

• Created test methods in NUnit for the application unit testing.

• Involving in code refactoring of the team members.

• Worked with deployment team to deploy code on Development, QA, UAT, Production and Disaster Recovery servers.

• Worked with QA and UAT teams for the successful delivery of the project.

• Attend client meeting to provide status on pending production issues.

• Impact analysis for major production incidents.

• Tracking production incidents on daily basis.

Environment: .NET Framework 4.5, Visual Studio 2012, C#.NET, WCF, SQL Server, HTML5, LINQ, ASP.NET, Web Service, JavaScript, JQUERY, CSS3, SOAP, .Net core Tools: Visual Studio, JIRA, Change Management, Harness, PCF, Splunk Project Title : PRINT STACKING.

Client: Chubb Insurance, Wilmington, DE

Company Name : Infomatics Corp.

Dec 2018 – Oct 2020

.NET Developer

It is a .Net core web application developed for Chubb small business portfolio. Policies are packaged, print and send to customers through this application. MPRT applications put policy data in message queue and print stacking will pick the data through kafka topics, tokenized and display in UI based on certain conditions. Here we introduced three new functionalities. 1) Hold and Release package 2) USAA restrictions 3) Address standardization In this project we made changes for ui, c# changes for controller batch and changes in database. On implementing these changes, chubb can able to package policies based on standard address of customer, hold and release packages for 7 days to restrict from printing and allow usaa policies to be visible only to authorized users. Mainframe changes were did by a separate team and integrated the changes with print stacking.

Responsibilities:

• Involved in full Software Development Life Cycle (SDLC) and identifying the requirements and defining the business rules to user requirements.

• Responsible for development, Unit testing of web applications in .NET Core using C#.

• Developed pages and functionalities using C# and HTML controls.

• Designed different components using C# .NET language with extensive use of Object Oriented Programming Techniques(OOPS) like Abstract classes, Polymorphism, Interfaces etc.

• Created Stored procedures and functions using SQL.

• Created unit test project using NUnit for the application and developed test cases.

• Project management from creating Project Initiating, Planning, Executing, Monitoring & controlling till closing.

• Worked in Agile methodology(Scrum) to meet timelines with quality deliverables.

• Responsible for deployment to Prod, UAT and QA through dev ops pipeline.

• Writing JavaScript validations.

• Involving in Code review of the team members.

• Extensively used user Interface controls which use JQuery to validate client side validation. Environment: C# 3.5, WCF service, SQL server 2008, .Net core, HTML5, JavaScript, JQuery, CSS3. Tools: Visual Studio 2008, Harness, PCF, Splunk.

Project Title : PRS Gateway System

Client: Chubb Insurance, Wilmington, DE

Company Name : Infomatics Corp.

Dec 2018 – Sep 2020

.Net Developer

This .Net Core web application is developed for Chubb small business portfolio. In this a third party centralized system named genius is using for all the downstream applications. But various upstream system data format are not accepted in genius. So a new gateway service system has designed to convert data from all the upstream systems to genius acceptable format. Gateway system is a windows service which is getting data and converting the data to genius acceptable format and pushing to genius through daily jobs. Gateway have four main sources and policy data is getting received to gateway through jobs. Gateway validates the data received through various sub process and check the premium amounts and coverages. During this process gateway creates various xml files and finally generates the feed for genius system. These feeds will move to genius through scheduled jobs and rejects if any validation failure in genius. If file gets rejected, gateway will analyze the file and send back to source if any source data issue is identified. Through this systems a centralized data holding system is creating for Chubb. Responsibilities:

• Worked with Visual studio 2019,.NET Core,WCF and Web services.

• Continuous integration and Conitinuous Deployment through Harness pipeline.

• Monotoring all build and deployments, Working on Build and Release activities.

• Worked on Agile Methodology(Scrum) to meet timelines and quality deliverables.

• Worked on Bug fixes and QA Support.

• Responsible for Development, deployment using Harness in PCF.

• Responsible for designing and implementing New Webservices.

• Check for business expectations and validate.

• Responsible for design, develop and support of applications in a .NET using C# language on coordinating with offshore team.

• Translated application storyboards and use cases into functional applications and have been coordinating onsite- offshore.

• Worked with deployment team to deploy code on Development, QA, UAT, Production and Disaster Recovery servers.

• Lead the team for non-customer impacted policies track and reduced the rejected policy count from 7500 to 2000 in 6 months.

Environment: .NET Framework 4.5, Visual Studio 2012, C#.NET, WCF, SQL Server, HTML5, ASP.NET, Web Service, JavaScript, JQuery, CSS3, .Net core

Tools: Visual Studio, JIRA, Change Management, Harness, PCF Project Title : UB Realty

Client: UB Realty, TX

Company Name : Fingent, Cochin, India

Jun 2018 – Oct 2018

Software Engineer

UB Realty is a property management solution specialized for selling, buying and rent a property. Anyone can express their interest against the property. So the Property Agent will respond to the Lead. Likewise the property can manage through their agents. The application is hosted on Amazon Web Services infrastructure, developed on .NET framework and ASP.NET for web console and backend SQL Server, and HTML5.

Responsibilities:

• Developed UI using C#

• Developed pages using ASP.NET using HTML controls, Data grid and validation controls

• Prepared user documentation.

• Involved in design, coding, unit testing and integration testing.

• Developed functionalities by writing classes, functions, stored procedures.

• Involved in requirement gathering and analysis of the system and developed the prototype.

• Worked with QA, UAT and Performance testing teams for the successful delivery of the project.

• Project Planning and Defect Management- Tracking the status of defects on daily basis.

• On-Call support for Production Issues.

• Tracking Production Incidents on Daily Basis.

Environment: .Net Core, ASP.Net, C#, MVC, Web API, JQuery, JavaScript, JSON, .NET Framework 4.5, Services, SQL Server, Html5, CSS, SMTP

Tools: Visual Studio, JIRA, Change Management, Harness, PCF Project Title : IronWorkers

Client: iDynamics Ltd UK

Company Name : Pumex InfoTech Pvt.Ltd, Cochin, India Jan 2018 – May 2018

Software Engineer

IronWorkers is a web- based application to handle the information of Workers. This product was targeted to tradesman who works in the iron working industry. We use repository pattern to develop this project. So it separates the data access logic and maps it to the entities in the business logic. It also provides high unit testability of each component.

Responsibilities:

• Developed pages of ASP.NET using HTML Controls.

• Created stored procedures and functions using SQL Server Integration Services.

• Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation.

• Monitor workflow and make timeline adjustments as needed.

• Responsible for design, develop and support of applications in a .NET using C# language on coordinating with team.

• Worked with business owner and Business analyst to understand the business requirements and discussed with development team on daily basis to understand road blocks

• Worked with deployment team to deploy code on Development, QA, UAT, Production and Disaster Recovery servers.

• Providing Resource/ Schedule Estimation.

• Attend client meeting to provide status on pending production issues. Environment: .NET, JavaScript, HTML, SQL Server, CSS, JQuery, .NET Framework 4.5, Services, MVC 5 Tools: Visual Studio, Change Management, JIRA

Project Title : Welder Certification Program(WCP)

Client: iDynamics Ltd UK

Company Name : Pumex InfoTech Pvt.Ltd, Cochin, India Jun 2017 – Dec 2017

Software Engineer

WCP is a web-based application to handle the information of Welders Certificates. This is already developed application in PHP. We implemented this application using MVC with set of new features and covering all limitations of existing system using dotnet. Responsibilities:

• Involved in full Software Development Life Cycle(SDLC) and identifying the requirements and defining the business rules to user requirements.

• Providing resource/schedule estimation.

• Involved in designing the front-end screens and checking for the client validations on the screen controls while inputting the required information.

• Creating web pages using ASP.NET and JavaScipt.

• Responsible for design, develop and implement applications in a .NET using C# language on coordinating with team.

• Worked on development and testing.

• Worked with business owner and Business analyst to understand the business requirements and discussed with development team on daily basis to understand road blocks in development and propose solutions and get updates on assigned Pages/Modules.

• Worked with deployment team to deploy code on Development, QA, UAT, Production and Disaster Recovery servers.

Environment: .Net, Javascript, SQL Server, ADO.Net Code first approach with Entity Framework Tools: Visual Studio, TFS, Splunk

Project Title : KPI Dashboard

Client: iDynamics Ltd UK

Company Name : Pumex InfoTech Pvt.Ltd, Cochin, India Jan 2017 – May 2017

Software Engineer

This project is mainly used to customize KPIs ( key performance indicator) depending on company needs. Graphically present information for a foot care in a dashboard format with clean and modern interfaces. In this we have developed different types of charts based on client requirement to show the growth in the foot care system.

Responsibilities:

• Responsible for design,develop and implement critical applications in a .NET applications using C# language.

• Translated application storyboards and use cases into functional applications and involving production tickets to troubleshoot the production issues.

• Worked with business owner and Business analyst to understand the business requirements and discussed with development team on daily basis to understand road blocks in development and propose solutions and get updates on assigned Pages/Modules.

• Worked in Coding, Database design & Testing.

• Worked with deployment team to deploy code on Development, QA, UAT, Production and Disaster Recovery servers.

• Developed and written high quality coding that met customer requirements and created software documentation and updated existing documentation. Environment: .Net, SQL Server, HTML5, CSS, JavaScript, JQuery, Chart JS Tools: Visual studio, TFS, JIRA

Project Title: Hotel Management

Client: iDynamics Ltd UK

Company Name : Pumex InfoTech Pvt.Ltd, Cochin, India Jan 2016 – Dec 2016

Software Engineer

The objective of this project is to develop a Web based application for Hotel Management and report users to monitor the activities of hotels and export data using reports . Extensively used Gridviews with sorting and paging . Created Resource file for creating both the Arabic and English version. Used DataGrid, DataList, Repeater controls as well as third party controls like Telerik Controls to show detailed information. Implemented user permission levels using ASP.NET Membership User & Role Provider. Used BootStrap for achieving Responsive design. Responsibilities:

• Developer role for analyzing and reviewing the business requirements, design document, use cases, functional requirements document

• Coordination of team and involved in production tickets to troubleshoot the production issues.

• Utilized ADO.NET Technology extensively for data retrieving, querying, manipulation and storage.

• Created stored procedures and Functions using SQL Server integration Services.

• Coordinating between Onshore and Offshore teams. Environment: ASP.Net, C#, SQL Server, ADO.NET,JavaScript. Tools: Visual studio, TFS, JIRA

Project Title : Image Processing for Riya

Client: Riya Designs

Company Name : Paali Software Technologies, Bangalore, India Aug 2006 – March 2007

Developer

A Web application for processing the images of different fabric products of a client Riya who is a leading distributor of fabric items in US.

Responsibilities

• Analyzing and reviewing the business requirements, design document, use cases and functional requirements document.

• Implemented Application Architectural Design using 3-tier Architecture using Dependency Injection and Database Architecture

• Handled Project Planning, Execution, Estimation, Database design review Environment : Microsoft .Net 3.5, SQL Server 2005

Tools: Visual studio, TFS, JIRA

E D U C A T I O N

Master of Technology - MS University, Tirunelveli (2011)

Bachelor of Engineering in Computer Science, Anna University (2006)

Contact this candidate