Post Job Free

Resume

Sign in

Sql Server C#

Location:
Edison, NJ
Posted:
September 26, 2023

Contact this candidate

Resume:

Muthukamatchi Subramanian

Summary

Over **+ years of experience in the IT industry, with expertise in complete SDLC including requirement gathering, analysis, design, development, integration, testing, releasing & maintenance of Internet/Intranet and Client/Server business applications

Experience in design and development of web-based application using .NET frame work using C#, ASP.Net 1.0-4.5, MVC, Entity Framework, ADO.NET, MS SQL Server ASP, Business Objects.

Extensive experience in client side using JavaScript, jQuery, Angular JS, Angular 2.0, and Angular 4- 8.0. Excellent Experience in writing Data Access Layers using ADO.net Entity Framework.

Experience in Web Services, Windows Communication Foundation, Web API, Windows Services.

Expertise in Microsoft .Net environments .Net Core, C#, ASP.NET 1.0 - 4.

Delivered responsibilities as Project/Team Lead, Systems Architect and Senior Programmer/Analyst

Strong in RDBMS Expertise in working with Microsoft SQL Server, T-SQL, ADO.NET/ADO.

Extensive experience in developing ASP.Net and MVC web Applications, Web Services

Have successfully delivered/implemented multiple projects from Requirement gathering to Releasing to Production within given Time and Budget

Worked in plenty of Expertise in capturing software requirements & interacting with clients, practice of formal quality processes & exceptional ability to quickly adapt to changing environments professionally and personally

Hardworking, interested in learning new technologies, with good communication skills and adept at working in both team environments as well as individually

Excellent communication, co-ordination, and inter-personal skills

Experienced in leading team with 4-6 members & ability to effectively lead & handle multiple

assignments.

Good knowledge on Application Migrations and Data migrations from On-premises to Cloud.

Expertise in DevOps, Release Engineering, Configuration Management, Cloud Infrastructure.

Technical Skills

.NET Technologies

ASP.NET, .Net Core, C#.NET, MVC2/3/4.5, Web Services,

ADO.NET, LINQ, Entity Framework, Enterprise Library.

Languages:

C#, VB .NET, JavaScript, VB, XML, PL/SQL, ASP, HTML

Architecture:

MVC, SOA, N-tiered, Client Server

BI Tech:

SQL Server 2008, SSIS

Database

SQL Server 2008/2012/2016, Oracle

DB Tools:

TOAD, SQL Developer, Data Studio

Web Related:

Web Services, WSDL, SOAP, XML, HTML, VB Script

Source Control:

TFS SVN, MS VSS, GIT

Monitoring Tool:

Fiddler, Splunk, Tea Leaf, Gomez/ Dynatrace, Perfecto, HPBSM

Azure:

App Service, App functions, Synapse Analytics, Data Factory

Work Expérience

End Client: Microsoft, Redmond

April 2022 – Till date

Position Title: Solution Architect

Project: MTC (Manual Test Client)

Description: MTC is a Compat’s Test Management Tool. It is deeply integrated with the other core compat toolsets like Test Plan, Work Allocation, App list and App library apps. It caters a lot of data to automated reporting solution at real time which in turns helps to access quality and health of apps compat. The primary usage of MTC is to run the test apps and grab the results. It has been made diligent to collect a lot of diagnostic data to perform telemetry results. MTC is a window-based application. App compat team is responsible for assuring that each new release of window operation system, service pack or patch (window update content) does not destabilize the ecosystem.

Role:

Involve in product design, analysis and product development

Providing Technical solution /guidance to the app development team.

Writing stored procedures, complex queries and creating SISS packages for data migration.

Support multiple apps for bug fixes and enhancement.

Creating Azure App service and registering the app registration in Azure.

Involved in other data migration projects of cosmos stream from Databricks to Synapse using the data factory pipelines.

Environment: Net Framework 4.6, C#, .Net Core, Azure App Service, ASP.NET, Angular JS, Angular 4.0, JavaScript, SQL Server, Entity framework, Window services, CSS, IIS.

End Client: The Harford Insurance Jul 2021- April 2022

Position Title: Technical Lead Full Stack Developer

Project: Gyroscope

Description: Gyroscope is the claim system which is used for paying losses by natural disasters and the evaluators/adjuster would verify the coverage through the underwriting policy system. It supports different claims system but as of now it supports only MAXMUM. It captures the required information about the claims through the policy system. It is used for making payments and generates letters/notices as requested by the user. Application uses third party tool called (Image Right) to store the generated documents.

Role:

Involve in product design, requirement and product development

Providing Technical solutions/guidance to the development team

Peer Reviews, Analyze, diagnose and resolve application issues

Writing stored procedures, views and complex Queries.

Managing/supporting multiple legacy applications in Hartford.

Environment: .NET Framework 4.5, ASP.NET, C#, .Net Core 2.0 Angular JS, Angular 2.0, Angular 4.0, Angular 8.0, Web APIs, AJAX, XML, JavaScript, SQL Server, Entity Framework, Windows Services, CSS, IIS

End Client: TriZetto Corp, a Cognizant Company, NJ

Apr 2017- Jul 2021

Position Title: Senior Associate Projects

Project: TCS (TriZetto Communication System)

Description: Trizetto Communication System (TCS) provides health plans with the ability to generate, manage, and customize effective constituent communications. TCS utilizes a set of components, batch processes and system information to process communication requests and delivers them over a wide range of media. It can produce high quality documents (such as letters and health statements), and make them available to end users via the Web, as PDFs or in printed hard-copy format. It can also create and deliver email notifications, as well as feed communications events externally for fulfillment and delivery.

Role:

Involve in Product design, analysis and requirements, quality assurance and testing.

Product enhance, maintain, and support software solution to business problems.

Peer Code reviews, diagnose and resolve triaging defect and provide impact analysis.

Writing stored procedures, triggers, views and complex Queries.

Create build definition and package using VSTS and Azure pipeline tasks.

Environment: .NET Framework 4.5, ASP.NET, C#, .Net Core 2.0 Angular JS, Angular 2.0, Angular 4.0, Angular 8.0, Web APIs, WCF, AJAX, XML, JavaScript, SQL Server, Entity Framework, Windows Services, CSS, IIS

End Client: Morgan Stanley, New York USA

May 2014 – Apr 2017

Position Title: Principal consultant

Project: MSO (Morgan Stanley Online)

Description: Morgan Stanley online is an online web portal which allows clients to view their portfolio and perform variety of functions like trading, bill payment, market data. The vision of the online banking initiative is to enhance client experience by providing a suite of online money transfer services to clients through ClientServ.The purpose of the application is to give the feature to User to transfer from one account to another. These accounts can be internal (MS Accounts) as well as External Accounts (outside MS).

Role:

Managing support teams for setting up Synthetic monitoring of the applications.

Develop and maintain application modules as per functional requirements

Peer Reviews, Analyze, diagnose and resolve application issues

Writing stored procedures, triggers, views and complex Queries.

Working with Business, FAs and Field for resolving user issues.

Environment: .NET Framework 4.5, ASP.NET, C#, Angular JS, Web APIs, WCF, AJAX, jQuery, XML, XSD, JavaScript, SQL Server, Entity Framework, Windows Services, CSS, IIS

End Client: Citigroup, Jersey City USA

Nov 2010 - May 2014

Position Title: Sr. Project Lead

Project: AIMS (Advance Invoice Management System)

Description: Legal application has consolidated of Legal compliance, Matter management and customer complaint project that mainly deal with the Compliance services, matter management and customer complaint service. Compliance application mainly deals with the restrictions which they provide to the different trading Matter management deal with maintaining Legal matter management system and invoices to the vendors system

Role:

Development/Coding architecture using C# and Designed UI.

Design document and Architecture diagrams

Brainstorming with Developers on Design and business requirement

Define technologies to be used and create prototype

Designed and developed the base framework

Coordinating with production support team for the prod fixes

Environment .NET 3.5, C#, MS SQL 2008, ADO.NET, XML, JavaScript

End Client: JPMC, New York City, NY

Jun 2010 - Oct 2010

Position Title: Consultant

Project: Whippany Database Migration

Description: DNA (Data Network Analytics) developed to provide information about various Sources, its related databases and its related Q-tree information. JPMC eSource directly stores all user personalization in DNA db. The Project aim was to get all this information from various data sources and organized into proper relational database format.

Role:

Understand & co-ordinate client’s needs / enhancements, customization, software-related issues, provide solutions in adherence to delivery schedules.

Preparation of functional specification document and technical design doc.

Created Data Load packages using SSIS

Designed and developed database tables, Scripting stored procedures, triggers, views and complex Queries

Involved in Prod maintenance activity and enhancement

Environment: SQL Server 2008, 2005, ASP.NET 3.5, C#, JavaScript, HTML, XML

End Client: Citigroup, USA

Oct 2009 - Apr 2010

Position Title: Associate Consultant

Project: Citi Direct

Description: Citi Direct is a common Internet-enabled Electronic Banking / Electronic Commerce platform to provide for the integrated delivery of Citibank’s portfolio of corporate banking services to all of Citibank’s customers globally. One of the leading offerings of Internet Banking for Corporate worldwide, and it provides a web-enabled customer front-end for e-business products of Payments and Reporting, Global Trade, Receivables, Netting and Liquidity. GECD is the premier provider of electronic banking solutions for corporate bank customers. It caters to the financial needs of these customers.

Role:

Created Proof-Of-Concept Reports and application

Database design and Creation of stored procedures and Functions

Created Business Reports and Database Management Reports

Designed Web pages using ASP.NET 2.0

Coordination with Online Applications Team, Operations Team

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

End Client: Citigroup, USA

May 2008 –Sep 2009

Position Title: Associate consultant

Project: Citi Card Management System

Description: CCMS is a web-based application for card management that provides Internet access to Citibank commercial card customers. It allows authorizing officials and program coordinators to administer their commercial Visa and Master cards used for business-to-business purchases. Functionality includes creating new cards, modifying existing cards, limits setting, self-directed customer service and exception reporting. Moreover, CCMS allows cardholders to view their statements and associated transactions. CCMS caters to top corporate and government agencies in the United States and Canada.

Role:

Providing technical design solutions to effect reusability of artifacts

Coding and unit testing

Peer reviews with the focus on avoiding functional defect leakages

Maintenance of version control for artifacts developed at offshore

Preparation of release ship-media structure and compile a list of all the source code

Environment: ASP.NET, C#, ASP 3.0, JavaScript, Visual Basic and SQL Server 2000

End Client: Royal and sun Alliance plc, UK

Aug 2007 – May 2008

Position Title: Software Engineer

Project: Stargate

Description: Stargate is the Internet Sales and servicing system of RSA. It deals with household insurance of new Business and most amendments. A customer can make a quote and save. A quote becomes a policy only when customer buys it. All saved quotes & Policies are stored in the SQL server database. Customer can also be able to amend their policies for pay for renewal.

Role:

Designed and developed the Views, Work Items and Controllers for the UI part using C#.NET and Enterprise Library

Designed & developed database tables, stored procedures & triggers using TSQL

Tested the methods using Testing tools incorporated in Visual Studio 2005 & prepared Test Plan and Test Cases

Coordination with Testing Team explaining the Functionalities

Environment : C#, ASP.NET, SQL Server 2005, MQ

End Client: MetLife India Insurance Pvt Ltd

Jun 2006 – Jul 2007

Position Title: Associate Technical

Project: Report Database

Description: Report database is an offline Reporting tool for MetLife, which is used to print all the letters, and Reports that MetLife needs to send to the entire customer. MetLife have a Policy Admin system (eSeg) from where the data will automatically follow to the Offline Tools Report database by a Data mart Job.

Role:

Preparation of functional specification document

Designing, coding, testing and debugging as per functional requirements

Monitoring the performance of the application

Scripting complex stored procedures, triggers and views

Environment: ASP.NET, ASP, VB, Crystal report and SQL Server 2000

End Client: Tata Tele services, Chennai

Jan 2004- Apr 2006

Position Title: Team member

Project: Technical Education Portal

Description: Developing www.educationstep.org is a website for development of technical education in India. This website gives information about the various technical education institutes across India. This portal is providing information about the technical education in India and evaluation of the technical education institutes through a dynamic model and various other program through this website.

Role:

Preparation of customer requirement specification

Coding, testing and debugging the web application

Database designing, scripting stored procedures and triggers

Environment: ASP, VB and SQL Server 2000

Education

Degree/ year of passing: Bachelor of Computer Science Engineering, 2003

College / university: Raja Rajeswari Engineering College Chennai, university of Madras, India

License and Certification

AZ-900 : Microsoft Certified Azure Fundamentals

Contact Information

Phone : 201-***-****

Email : adzzab@r.postjobfree.com

LinkedIn : www.linkedin.com/in/muthukamatchi-subramanian-86136593



Contact this candidate