Sql Server Management

Ragupathy Kumarasmay

Phone: 925-***-****

ac0bcx@r.postjobfree.com

www.linkedin.com/in/ragupathy-kumarasmay-146bbb56/

Employer Details:

Russell Reed

CGVAK Software USA Inc

**** **** ****** *lvd STE#101 Walnut creek CA-94595

Ph: 925-***-****, 925-***-**** Fax:925-***-****

Email: ac0bcx@r.postjobfree.com ; www.cgvak.com

8 Years of experience in all phases of Software Process across various workflows (Requirement analysis, Design, Coding, Testing, Deployment and Maintenance) in Web & Client/Server application development.

8 years of experience in Web & Client/Server applications Development using Microsoft Technologies (ASP.NET, MVC, C#, WCF, VB.Net, ADO.NET, Web API), JAVA & angularJs.

Experience in developing and deploying software based on Software as a Service model (SaaS).

Experience in developing SOA(Service Oriented Architecture) based applications.

Extensively used HTML,CSS, Bootstrap, JavaScript, XML, JSON and XSLT on the web application.

Experience in configuring build structure environment using Jenkins & GIT.

Experience in writing cross browser JavaScript code & CSS.

Good knowledge in SPA(AngularJS) – Services, Modules, Custom directives & Expressions

Experience in developing web application using ASP.NET MVC & Entity Framework.

Created complex Stored Procedures, Common Table Expressions (CTE), Functions, Packages, Triggers and Views using Transact SQL programming (T-SQL).

Good experience in creating database tasks and scheduling.

Experience in AJAX, AJAX Extension, Windows Services.

Good experience in Object Oriented Concepts & Design.

Excellent understanding of UML and proficient in developing Use Cases, Sequence Diagrams, Activity Diagrams, Class Diagrams and Domain Model.

Experience in preparing Test Case Documents and related procedures.

Experience in preparing requirement specification documents, functional specifications and code plan documents and communicating the requirements to the team.

Experience in SQL Server Reporting Services (SSRS) to create, deploy, and manage reports.

Experience in EF4, EF5, Entity Framework with T4 Templates.

Good Knowledge in SQL Server Integration Services (SSIS) for enterprise-level data integration and data transformations solutions.

Used LINQ to query the databaseand C# objects for data manipulation tasks.

Expert level in managing, administration of IIS 6.0/7.0 and configuring SSL, Domain certificates.

Experience in migrating web applications from ASP to ASP.NET and VB6.0 to VB.Net.

Experience in fine tuning applications and databases.

Experience in Agile, Scrum and Water Fall methodologies of the SDLC.

Experience in making new releases by pushing the updates to the staging, production servers and maintaining relevant release documents.

Experience in team management and providing customer support.

Expert in handling client issues and communicating the hot fixes to client.

Excellent team player with strong interpersonal skills, excellent verbal & written abilities, problem solving skills and positive attitude.

SOFTWARE SKILLS

.NET Technologies

.NET Framework ASP.NET 3.5/4.0/4.5, MVC 2.0/4.5, ADO.NET, VB.NET, XML, Web Services, LINQ, WCF, XML/XSLT, JSON, Windows Services

Architectures Patterns

N-Tire/MVC/SOA

Programming Languages

C, C++, C#, VB.NET, JAVA

Data Access Technologies

ADO.NET,LINQ,Entity Framework,DNS

Database

SQL Server 2005/2008/2012,2014, MS Access

Server

IIS 6.0/ 7.0

Client/Browser Technologies

AJAX, ASP.NET Ajax ToolKit, HTML, CSS, Twitter Bootstrap, Angularjs

Operating System

Windows

IDE

Visual studio 2005/2008/2012/2015, Eclipse, GIT extension, ReSharper

Other tools

Blaze, soapUI, InstallShield, etc.,

Reporting Tools

Crystal Reports for .NET, SQL Reporting Services (SSRS)

Office Suite

MS Office 2003/2007/2010/2013

EDUCATIONAL QUALIFICATIONS

Bachelor of Science in Computer Science, Bharathiar University.

PROJECT SUMMARY

Nov 2015 –Till date

Sr. .Net Developer RSI – Roseville, CA

Revenue Premier Enterprise - RPE

Designed specifically for the Tax and Revenue industry, Revenue Solutions, Inc.’s (RSI) Revenue Premier® provides an integrated, highly functional and advanced technical solution to support the processing, tax accounting and compliance functions of a tax agency. Revenue Premier is comprised of four primary integrated modules: Integrated Tax Processor, Collections Manager, Portfolio Warehouse and Audit Manager. Revenue Premier boasts an open technical design and a set of shared services which provide vast flexibility for reusing services, integrating other products and supporting a variety of technical infrastructure options. Revenue Premier’s integrated Business Rules Management System provides maximum control over system behavior and tailoring of the solution to an agency’s own policies, without base-code modifications.

This is a fullyservice oriented application.

Responsibilities:

Fully involved in analyzing the existing, new business requirements, design, development, support.

Implemented the business logics for different regions (Canada).

Involved in writing new WCF services using C#.

Involved in writing complex database objects using SQL server 2014.

Involved in creating cross domain security certificates using Java keytool.

Involved in writing business rules using Blaze.

Involved in migrating Telerik controls in UI level.

Configured Jenkins builds systemusing GIT.

Extensively worked integrating multiple applications.

Involved in performance tuning the application in database level and application level using Dynatrace& SQL server profiler.

Involved in writing & reviewing technical documents, SRS.

Worked in release management & publish the artifacts.

Fully involved in managing development branches, merges, etc.

Coordinating with offshore team.

Fully involved in Agile/Scrum.

Environment : ASP.NET 4.5, C#, WCF,Wildfly, JAVA, SQL Server 2014, GIT, Jenkins,SoapUI, FICO Blaze advisor,LINQ, T-SQL, AJAX, Java Script,jQuery, IIS 7.0, CSS, XSLT, XHTML, XML, AGILE SDLC, MVC 4.5, visual studio 2015, Nunit,

Aug 2011 – Oct 2015

Sr. .Net Developer SeaTip – Ellenton, FL

Loan Information Management System - Skylight

This project is developed for leading product Development Company in Florida, USA.

Loan information management system – Skylight isSaas based financial application for servicing of installment loans specifically designed for the auto finance business. Its focus is for those companies that purchase either originated or seasoned (aged) loans, singularly or bulk (packages) from auto dealers.

This is an N-Tier application composed of presentation layer, Database layer, Entities layer, Business logic and Service layer.

Responsibilities:

Fully involved in analyzing the existing, new business requirements, design, development, communicating the requirements to developers and assisting the team.

Involved in client interaction for getting the change requirement

Involved in developing a secured administrator's control panel for user and role management and assigning role level permissions.

Involved in creating windows services for status update and posting on daily basis

Extensively worked on amortization module to calculate the dues on monthly, bimonthly and weekly basis.

Extensively worked on all primary modules as payment, payment history, loan history, collectors, report generic, letters creation and generation modules.

Implemented multi-level loan approval.

Involved in designing the architecture for the application.

Exclusively created error logging library using Log4NET

Created and implemented various ASP.NET User Controls

Extensively used third party Infragisticscontrols

Involved in code evaluation to validate and fine tuning the performance in application level and database level

Involved in recommending Hardware requirement based on the Load/Performance test results.

Experience in configuring IIS and Secured socket layer (SSL).

Used Microsoft Team Foundation server (MS TFS) for version control and source code management.

Involved in building WCF with REST services for the plan & project modules.

Deployed and configured the Software As a Service model (SaaS).

Involved in making new releases by pushing the updates to the live server

Provided customer support by handling the client issues while implementation.

The whole development & project management was executed using agile/scrum methodology.

Extensively used SQL Server Reporting services (SSRS) in the reports module for creating, deploying and managing reports.

Connecting Jobs

This project is developed for leading product Development Company in Florida, USA.

Connecting jobs is online job portal system, which is created to connect the job seekers with the employers by which helping employers to find the right employees for their organization as well as helping job seekers to find the right job.

Responsibilities:

Fully involved in analyzing the business requirement, design, development, communicating the requirements to developers and assisting the team.

Involved in designing the OOAD – UML diagram for representing the workflow.

Completely designed the architecture for the application using MVC(Model-View-Controller)

Extensively worked in creating responsive layout pages using twitter bootstrap, CSS

Extensively worked in razor engine views

Used Javascript, Ajax, jQueryinorder to minimize post back across page and for better used experience

Created unit testing for the controller actions using Nunit

Responsible for managing source code using TFS version control

Used LINQ to Entities for data access

Involved in creating RESTfulservicesfor project modules.

Involved in code evaluation in maximize application performance

Actively participated in daily meeting and weekly meeting

The whole development & project management was executed using agile/scrum methodology.

Environment : ASP.NET 3.5, C#, Windows services, SQL Server 2008R2, LINQ, ADO.NET,SSRS,T-SQL, AJAX, AJAX Extension 1.0, Java Script,Infragistics, jQuery, IIS 7.0, CSS, XSLT, XHTML, TFS, XML, AGILE SDLCMVC 4.5, Entity framework 5.0, SQL Server 2012, visual studio 2012, LINQ, Bootstrap 3.0, CSS, javascript, jQuery, Ajax, Razor, Nunit, MS-TFS.

March 2009–July 2011

.NET Developer Image Technology Systems, TX, USA

Visual Matrix – PMS System

Visual Matrix PMS is a Property Management System that delivers the most technically advanced and intuitive property management system on the market today. The website manages day-to-day operations and forecast effectively. The website helps increase in room revenue and occupancy percentage which is achieved through use of robust yield management system. The PMS helps the user maintain the details about Front Office, Housekeeping, Maintenance, Accounting & Management, Sales & Marketing, and Banquet & Catering etc.

The application uses MVC architecture for the report module. The reports are generated using the HTML controls and loading all the data in the hierarchical order. Thus the reports are loaded quickly with large number of data by using MVC architecture.

Roles & Responsibilities:

●Fully involved in analyzing the existing, new Business requirements, design, development, communicating the requirements to developers and assisting the team

●Involved in designing OOAD-UML diagrams for representing work flow and entity relations.

●Extensively worked with the Master pages, themes, Skin CSS and XSLT.

●Created and implemented various User Controls in the application to save development time and standardization.

●Used JavaScript, AJAX and AJAX Extension 1.0 Toolkit in order to minimize post backs across pages and for better user experience.

●Created work desk for internal bug tracking system.

●Involved in designing Database Schemas and database objects.

●Involved in designing MVC architecture for report module

●Created various views, triggers, stored procedures, functions and CTE using transact SQL programming

●Used Visual Source Safe (VSS) for version control and source code management.

●Extensively used Expert PDF components to generate PDF documents from the application.

●Used LINQ to SQL for querying the database and for data manipulation tasks.

●Providing customer support by handling the client issues.

●Configured the database server for automatic backups of the database and mailing.

●Used SQL server profiler to measure the query execute plan and improved query execution timing

●.The whole development & project management was executed using agile/scrummethodology.

●Involved in data migration using SSIS

●Coordinated with QA team for defining test plans and testing.

Environment: ASP.NET 2.0,3.5, 4.0, C#, SQL Server 2005/2008, MVC 2, LINQ, ADO.NET, T-SQL,SSIS, AJAX, AJAX Extension 1.0, Java Script, IIS, CSS, XSLT, XHTML, MS Visual Source Safe, XML, SOA, Visual Studio.Net 2008, AGILE SDLC

May 2008 - March 2009

DNS Associates, UK

.Net Developer

Accounts Management System

AMS is an application capable of handling accounting and finance, sales management, materials management, works management, payroll, user management, costing, quality assurance, taxing, accounts receivable, accounts payable and general ledger. This is an integrated system with on-line update of all related entries of other relevant modules, Standard financial accounting transactions such as bank vouchers, cash vouchers, journal vouchers, receipts, payments, debit note and credit note are also provided in the system.

Roles & Responsibilities:

Involved in analyzing and designing the classes needed for the application, testing the components and deployment.

Used tortoise SVN for version control.

Done client side validations and processes using JavaScript.

Involved in working with on the various modules using C#

Involved in functional testing and preparing test documents.

Fixed the bugs reported by QA team.

Closely involved with QA for project flow.

Involved in writing the documents for different modules and workflow

Created various stored procedures using PL/SQL for the reports.

Extensively used Crystal reports in the reporting module.

Environment: Asp.Net 2.0, C#, Tortoise SVN, XML, Oracle, HTML, IIS, Windows XP & Server 2008, JavaScript.

Contact this candidate