Sql Server Software Development

SUMMARY:

• IT professional with **+ years of development experience in all aspects of Software development methodology including Requirement Analysis, Design Specification, Implementation, Testing and Deployment of Enterprise Web Application, Client Server based Applications using .Net Framework on Web & Windows Platform.

• Extensive knowledge and experience in Software applications development and production Support / maintenance (enhancements) of applications using C#, Windows Forms, ASP.NET, ASP.Net MVC core, WPF, MVVM, MVC, WCF, Web API, LINQ, XML, XSD, JavaScript, Bootstrap, jQuery, RESTful Services, Ajax, CSS, MS SQL SERVER, IIS, JSON, ADO.NET, Entity Framework.

• Hands on in Angular, React, Type script and Java script.

• Extensive experience in clean architecture, design, development of Client-Server and Distributed Web Applications with MVC, MVVM, n-Tire Architecture using Web Forms and Razor view engine.

• Having experience with Relational database designs, SQL, Stored procedures, functions, Triggers, Views, SSIS.

• Experience in generating Custom Reports using SQL Server Reporting Services (SSRS) and Crystal Reports and Power BI Desktop also integrated them into web applications.

• Experienced with Microsoft Application building blocks for .Net projects (Data Access, Exception Handling, Serialization).

• Expertise in using Object-Relational Mapping (ORM) technologies such as EF.

• Extensively used Versioning tools like Visual Source Safe, TFS, Git and Azure DevOps.

• Worked in SDLC models like Water fall and Agile (Scrum & Kanban).

• Experience in implementing Service Oriented Architecture (SOA) with XML based Web Services (SOAP/WSDL) and Windows Communication Foundation (WCF).

• Expertise on Object Oriented Programming (OOPS) Concepts including Inheritance, Abstraction, Encapsulation and Polymorphism, good experience in Exception Handling, Debugging, and tracing.

• Proficient in developing systems built on SQL Server using Tables, Triggers, Views, Functions and Stored Procedures in SQL and maintaining the database, including requirement analysis, design, data conversions and SQL Profiler.

• Experience with Involvement in all phases of Software Development Life Cycle (SDLC) such as planning, analysis, design, implementation, testing and maintenance of Web Based, Client-Server and N-tier Architectures.

• Experience in Insurance, Finance, Banking, Automotive and public sector domains.

• Good exposure to work both independently and in a team with collaborative model.

EDUCATION AND CERTIFICATION:

• Master of Computer Application, University of Madras (2002 to 2005)

• Bachelor of Science (Computer Science), University of Madras (1999 to 2002)

TECHNICAL SKILLS:

Scripting Language : HTML, Java Script

Programming : C#, Razor page, Win Forms, .Net Core Web API, ASP. Net MVC & .NET

UI component libraries : Telerik and DevExpress

DBMS / RDBMS : MS SQL Server 2017, 2018

Tools : TFS, VSS, Git, Azure DevOps, SSIS, SQL profiler

Reporting Tool : Power BI Desktop, SSRS

Domain : Banking, insurance, automative and public sector

LinkedIn Id : https://www.linkedin.com/in/meenakshi-sundaram-gurusamy-90047665/

PROFESSIONAL EXPERIENCE:

Project : MiTalent, WBL (Work Based Learning), D4AD (Data For American Dream), WARN (Work Adjustment and retraining Notification), TAA (Talent Acquisition Portal)

Client : State Of Michigan (Lansing-MI-USA) (DTMB)

Department : LEO (Michigan Department of Labor & Economic Opportunity)

Period : March-2019 to Current

Role : Lead/Programmer Analyst

Environment : .NET 4.8, C#, MS SQL SERVER 2018, Angular (Hands On), .Net WEB API in MVC,

Angular CLI 14.1.0, .NET 4.8, C#, MS SQL SERVER 2018, Boot strap, CSS, Java script, Entity Framework.

SQL SB : SSIS, SSRS MS Reports and Power BI desktop reports.

Responsibilities:

• Involved in the development of new .Net core web Api for the front-end application to consume.

• Used boot strap in the C# Asp.Net MVC web application for mobile compatibility.

• Maximized Bootstrap’s responsive framework to deliver seamless cross-device compatibility with minimal manual intervention.

• Developed and validated dynamic UI components using JavaScript and AJAX for efficient API communication and real-time updates.

• The WCF application was used by external entities to export their job feed into the web application DB.

• .Net Core C# web APIs (REST) was used by Angular frond end application to communicate with the DB objects using entity framework.

• Developed and implementing enhancement to the application based on the user request.

• Based on the requirement create new application in new Razor views in ASP.NET core MVC

• Creating new DB tables, SP in SQL server for the application to consume using Entity framework.

• Used Azure DevOps, GIT as Version Control for taking a new branch, and merging the code to the main source code branch.

• Created new reports and modified existing one using MS report builder.

• Tweaking functionalities in SSIS project based on the business requirements.

• Utilized Agile (scrum) methodologies for project management, ensuring a flexible and adaptive approach to changing business requirements and priorities.

• Creating new tables, stored procedures and function as and when needed for UI and reports.

• Involved in analyzing the defects found in the live environment and fix them.

• Used ORL like entity framework in DB first approach.

• Created SQL Views for the Power Bi Desktop.

• Created several reports using Power BI Desktop reporting tool.

Project : L-Screen

Client : Toyota Technical Center (Saline-MI-USA)

Period : Aug-2017 to Feb 2019

Role : .Net Developer

Team Size : 3

Description : Maintenance of .Net Win Forms application built of MVC design pattern based.

Environment : .NET 4.7, C#, MS SQL SERVER 2017, CLR Assembly

Reporting Tool: Power BI

Responsibilities:

• Implementing enhancement to the application based on the user request.

• Involved in analyzing the defects found in the live environment and fix them.

• Adding encryption to the application for the data sent to and received from the SQL server DB using CLR assembly.

• Used TFS for Version Control.

• Analyzed on implanting AD authentication.

• Utilized Agile (scrum and kanban) methodologies for project management.

• Creating new DB tables, SP in SQL server for the application to consume using Entity framework.

• Created SQL Views for the Power Bi Desktop.

• Created several reports using Power BI Desktop reporting tool.

• Hands-on experience working with Stored Procedures, Functions, T-SQL Queries, Triggers in SQL Server.

Project : COMPAS

Client : NBCUniversal (USA)

Period : Oct-2016 to July-2017

Role : Project Lead

Team Size : 12

Description : The WPF application built of MVVM design pattern based on entity framework has to be revers engineered.

Environment : .NET 4.5, C#, Entity Framework, WPF, MS SQL SERVER 2008 R2 and Oracle

Responsibilities:

• Involved in analyzing the code of the WPF project and creating documents related to the business functionality and DB related information based on the entity used.

• Highlight missed functionalities found in the C# code and map the data to and from the DB.

• Used TFS for Version Control.

Project : Rainmaker Integration

Client : GENTIN (KL - Malaysia)

Period : Nov-2015 to Sep-2016

Role : Senior Software Engineer

Team Size : 6

Description : The web site and web service is used by (GENTING). The web service is used to push and pull data form Rainmaker (Microsoft – An analytical service) to provide the selling rate of rooms based on the past records of booking and season.

Environment : ASP.NET 3.5/4.0, C#, ADO.NET, WCF, HTML, JavaScript, Ajax, XML, MS SQL SERVER 2014.

Responsibilities:

• Involved in gathering requirements and design reviews for the new requirements.

• Involved in planning and development of Application life cycle - Study and analysis of the Business process flow and existing systems requirements.

• Responsible for reviewing design and technical deliverables.

• Developed web application with Microsoft.Net technologies - Web layer with ASP.NET, business layer with C#, and Data access layer with ADO.NET advanced functionalities.

• Created Database Tables and have written SQL Queries, Stored Procedures & Functions using SQL server 2014.

• Created schemas for xml files for the various interfaces.

• Worked on inline scripts for validation of mandatory fields.

• Fixing the bugs and redeploying the applications.

• Prepared Technical & Functional Specification documents.

• Used TFS for Version Control.

• Created test tools to check the performance (Load test) of the web service created.

Project : Facility Management System

Client : LBG - CBR (UK) (Work location Chennai India)

Period : Jan-2015 to Oct-2015

Role : Senior Software Engineer

Team Size : 20

Description : The web site is used by (Commercial Banking & Risk). The application Facility Management System is used to manage the facilities and to generate reports using SSRS.

Environment : ASP.NET 3.5/4.0, C#, ADO.NET, WCF, HTML, JavaScript, Ajax, XML, Entity Framework 3.5, LINQ, MS SQL SERVER 2008 R2, SSRS.

Responsibilities:

• Involved in gathering requirements and design reviews for the new requirements.

• Involved in planning and development of Application life cycle - Study and analysis of the Business process flow and existing systems requirements.

• Responsible for reviewing design and technical deliverables.

• Used Model View Controller (MVC) architectural Design Patterns for the development of the product. Used Entity Framework (EF3.5) for all business Objects and Retrieving data from SQL Server database.

• Developed web application with Microsoft.Net technologies - Web layer with ASP.NET, business layer with C#, and Data access layer with ADO.NET advanced functionalities.

• Created Database Tables and have written SQL Queries, Stored Procedures & Functions using SQL server 2008.

• Review and test customer deliverables. Responsible for providing technical assistance to the team.

• Created schemas for xml files for the various interfaces.

• Worked on inline scripts for validation of mandatory fields.

• Fixing the bugs and redeploying the applications.

• Prepared Technical & Functional Specification documents.

• Used TFS for Version Control.

Project : Collateral Management System

Client : LBG – CBR (UK) (Work location Chennai India)

Period : May-2014 to Dec 2014

Role : Senior Software Engineer

Team Size : 10

Description : The web site is used by (Commercial Banking & Risk). The application Collateral Management System holds collateral details against which are provided as security taken against the lone in Bank. This is an enhancement project.

Environment: ASP.NET 3.5, C#, SQL Server 2008, VS 2008, ADO.NET, Agile Methodology, AJAX & AJAX Toolkit, LINQ, WCF, CSS, JavaScript, XML, IIS 6.0, Web services.

Responsibilities:

• Involved in gathering requirement and design reviews for the proposed system

• Involved in planning and development of Application life cycle - Study and analysis of the Business process flow and existing systems requirements.

• Developed the web application with Microsoft.Net technologies - Web layer with ASP.NET, business layer with C#, and Data access layer with ADO.NET advanced functionalities.

• Developed Web-based Graphical-User Interface (GUI) user interface using ASP.NET, JavaScript, and HTML and AJAX framework.

• Built ASP.NET Master Pages to maintain a consistent layout and style across related application and content pages. Used Cascading Style Sheets (CSS3) to attain uniformity of all web pages.

• Used HTML, CSS and XSLT for styling the Web pages.

• Developed SQL stored procedures & Functions for data manipulation and querying data from SQL Server.

• Review and test customer deliverables.

• Performed version controlling in TFS.

• Used SMTP to Send Email notifications.

• Responsible to provide technical assistance to the team.

Project : Tarifrechner

Client : LBG - IFS (Germany) (Work location Chennai India)

Period : Feb-2010 to April 2014

Role : Software Engineer

Team Size : 10

Description : The web site is used by (IFS International Financial Services– Insurance Division). The application would be used to generate Illustration of various Insurance policies offered by the Bank. This is a maintenance project.

Environment: ASP.NET 2.0, C#, SQL Server 2005, VS 2005, ADO.NET, IIS 6.0, Web services.

Responsibilities:

• Track and close incidents raised in the incident tracking tool

• To work on the LILs which are prioritized by the business

• Raise clarification with the SME on site regarding the incidents & LILs

Project : Human Lifecycle Matrix

Client : Prodialog (Germany) (Work location Chennai India)

Period : May 2008 to Feb 2010

Role : Programmer

Team Size : 5

Description : The web site is used by Prodialog clients to maintain their company’s employee details and to manage there recourses in project.

Environment: ASP.NET 2.0, VB, SQL Server 2005, VS 2005, ADO.NET.

Responsibilities:

• To design, develop and unit test the code based on the requirements provided by the client.

Project : Sysnet

Client : Sysnet (UK) (Work location Chennai India)

Period : December 2006 to April 2008.

Role : Programmer

Team Size : 10

Description : The web site is used by the Sysnet clients to register and pay the company to certify them that their web sites are reliable for Credit Card Transactions. The client will be certified after they clear the scan.

Environment: ASP.NET 2.0, C#, SQL Server 2005, VS 2005, ADO.NET.

Responsibilities:

• To design, develop and unit test the code based on the requirements provided by the client.

Project : Amtech

Client : Amtech (UK) (Work location Chennai India)

Period : August 2007 to April 2008

Role : Programmer

Team Size : 3

Description : The web site is used by the Amtech Engineers clients to register and pay the company to certify them that their web sites are reliable for Credit Card Transactions. The client will be certified after they clear the scan.

Environment: ASP.NET 2.0, C#, SQL Server 2005, VS 2005, ADO.NET.

Responsibilities:

• To design, develop and unit test the code based on the requirements provided by the client.

Contact this candidate