Sql Server Engineer

Sivakumar Manickavasagam

Mobile : 262-***-****

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

Professional Summary

9+ years of experience in all phases of SDLC including Requirement Analysis, Design, Development of Multi-tier Applications, Testing, Implementation and Maintenance.

Expertise in ASP.NET MVC 3, MVC 4, Master Pages, User Controls, Custom Controls, Themes and Skins.

Strong skillset in Design and Development of Web Applications using WebForms, ASP.NET, C#, ADO.NET and .NET Framework.

Worked on Web API, Web Services and WCF based services involving SOAP and REST Protocols.

Strong foundation in Object Oriented design and programming.

Implemented responsive application presentation layers using frontend frameworks like Ajax, CSS, Bootstrap, HTML, jQuery and JavaScript.

Implemented MVC Models, Views and Controllers, used Razor syntax and HTML/AJAX Helpers.

Strong experience in SQL Server 2005 & 2008 database environment.

Proficient in database connectivity programming using Microsoft ADO.NET and knowledge on ORM Tools like Entity Framework.

Worked on designing Databases, Tables, Stored Procedures and Triggers.

Comfortable with NUnit for preparing unit test case.

Good experience with Agile and Waterfall environment.

Well versed in using source control technologies such as Team Foundation Server and Visual SourceSafe.

Familiar with AngularJS.

Excellent Technical, Communication and Interpersonal Skills with strong Customer Orientation and Client Interfacing Skills.

Excellent team player with problem solving and troubleshooting capabilities.

Worked on multiple projects in different sectors like ERM, HRMS and Mortgage.

An accomplished and established professional with 2+ Years proven track record in team management and leadership

Experience in preparing different Test cases and Documentations.

Experience of coordinating between onsite and offshore teams.

Education: Completed B-Tech in Information Technology from Anna University, Chennai, INDIA (2001-2005).

Certification: MCTS 70-515: .NET Framework 4, Web Applications

Employment Summary:

Organization

Designation

Duration

Wipro Technologies

Technical Lead

Feb 2015 - Feb 2017

Aspire Systems limited

Senior Engineer

May 2011 - Jan 2015

Adrenalin e -Systems Ltd

Senior Systems Engineer

Oct 2008 - May 2011

Softwapps Technologies

Programmer Trainee

Nov 2006 - Jul 2007

Technical Skills:

Web Technologies/Frameworks:

ASP.NET MVC, WebForms, Web API, WebServices, WCF, Ajax, jQuery, AngularJS.

Programming Languages:

C#, JavaScript

Data Access Technologies:

ADO.NET, Entity Framework, LINQ

Database:

SQL SERVER 2005/2008

Development Tools:

Visual Studio 2008/2010/2012

Markup:

HTML, XML

Source Control:

TFS, VSS

Testing Tools:

NUnit

Software Methodologies:

Waterfall, Agile

Operating System:

Windows Server 2008/2003, Windows 7, XP, Vista

Design Patterns

Model View Controller Pattern, Singleton, Factory, Dependency injection using Unity Container

Defect/Issue Management Tools

JIRA, TFS and ATS(Internal Bug Tracking Tool)

Domain Knowledge

ERM, HRMS and Mortgage.

Professional Experience:

Client: Huntington National Bank, OHIO Feb, 2015 – Feb 2017

Project: Net Oxygen

Role: Technical Lead

The Global banking and Financial services marketplace has seen tremendous shifts in terms of the range and complexity of products, growing demands of customers, new and more pervasive channels, use of web-based technologies, deployment of software as a service, and new operations models that transcend traditional boundaries. The challenge for market participants, therefore, is to predict change and provide differentiated solutions for the empowered global customer. Application deals with loan origination systems which offer versatility ease of use and control. As with all versions the workflow is seamless and delivers an intuitive user experience at every aspect of the loan lifecycle, from lead management, processing and underwriting through post-closing, funding and interim servicing.

Responsibilities

Developed Front end using ASP.NET MVC4 Architecture, LINQ, Jquery, JavaScript, and Back end using SQL Server.

Working on creating Rest Services using ASP.NET Web API and C# to allow new web/client projects to leverage reusable data.

Involved in all phases of the Agile process.

Created WCF SOAP based services for B2B portal.

Worked closely with business customers to do requirements analysis.

Identified the Common modules & components.

Implemented MVC Architecture and used the Razor View Engine.

Define Code review guidelines and review of code for the modules developed by the team members.

Presenting solutions for issues and bugs in applications.

Provide technical guidance and assistance to development teams.

Developed end user screens for interacting with the application.

Designed Database, Tables, Triggers and Stored Procedures in SQL Server 2008.

Used NUnit to create test suites to ensure unit testing the functionality and to ensure complete code coverage during Unit Testing.

Identified user functionality errors and resolved it.

Maintained the source control in Microsoft TFS.

Attended daily triage meeting with the clients.

Created User documentation and presentation for the business team.

Environment: ASP.NET MVC 4, Web API, WCF, C#, Razor, jQuery, AJAX, HTML, SQL Server

Client: Ingram Micro Mobility, Sweden Sep, 2013 – Jan 2015

Project: BPO5 Online & Admin Tool

Role: Senior Engineer

Project Description

BPO Online project helps to order the electronics product on Web. It consists of modules like News Letter, Help Desk, Invoices and Product List. The products are listed based on brands and categories. User can either choose product from the product catalogue list or search the required item based on brand and category from the search text box. User can have access to add/delete the product in the cart and place the final order. BPO5 admin used to create customers, members and helps to settings to access the bpo online. It consists of main modules like Administrators, marketing, sales, reports, tools etc. Marketing deals with campaign, offers, accessory boards, survey and news. All settings will be created based on Instance and sites. BPO Online settings can be done using this admin tool.

Responsibilities

Working through development and production support activities in these applications.

Implemented project in a 3-Tier Architecture. (Presentation, Business, and Data Access Layers)

Migrated the project into MVC architecture like Controller, View, Models and Helper methods linked to backend database

Development of Webpages using AngularJS, Bootstrap, Ajax, jQuery and JavaScript to enhance the user experience.

Implemented Business Logic and Models using C# and Entity Framework.

LINQ used to query database when editing specific fields.

Implemented client side validation JavaScript.

Designed stored procedures in SQL server 2008.

Followed an Agile design model throughout the project.

Effectively participating daily status meeting with clients.

Used Microsoft TFS for version control to maintain the source code

Environment: ASP.NET, C#, MVC 4, Web API, WCF, LINQ, AngularJS, Bootstrap, jQuery, SQL Server, ADO.NET, JavaScript

Client: Brightpoint, Sweden May, 2011 - Sep, 2013

Project: Brightpoint ePlus

Role: Senior Engineer

Project Description

Eplus tool provides end to end enterprise system to the user. All the products will be displayed as accessory board container page. Customer can add the items to the cart and place the order. The container has the products on it and will have the detail of the product when user clicks the container links. This Project provides end to end Enterprise resource management system to the customer to purchase product from the web. The customer can review their purchased product and keep maintaining the history of the product.

Responsibilities

Involved in the Analysis and design of the core objects of the application.

Migrated from Asp.Net webforms to Asp.net MVC 3 architecture.

Responsible for gathering Enhancements Support requirements from client

Created user interface with HTML, CSS and jQuery with AJAX calls to Web Services for a fluid and responsive interface.

Built WCF Services in order to implement the business logic to assure the calculations were done in a safe secure environment on server.

JQuery has been implemented for client side validation.

Data accessed and managed via ADO.NET data adapters (disconnected architecture).

Data management such as inserts and updates were managed using disconnected architecture with ADO.NET.

Used ASP.NET Authentication to verify users and create administrative/read only roles.

Used SQL Server 2008 as the database.

Attended weekly meeting with the customers.

Developed Tables, Indexes, Stored procedures, Triggers and Functions using SQL Server 2005

Environment: ASP.NET, WCF, C#, LINQ, SQL Server, Stored Procedures, ADO.NET Entity Framework, Ajax, jQuery

Client: Religare Securities Limited, India Mar, 2010 – May, 2011

Project: Human Capital Management System - PMS

Role: Senior Systems Engineer

Project Description

Performance Management System allows to set up an application for a specified period. Employee can create and maintain goals for a period. This module contains phases like Goal setting, Goal Approval, Template Mapping and Self-Appraisal etc. Goals set by employee have to be approved by the manager. Once the goal is approved, performance can be assessed by the employee as a part of self-assessment and then by the manager. Goals status and modification required by business requirement can be reviewed periodically. It helps manager to establish culture, develop career plans, and allocate compensation efficiently.

Responsibilities

Worked through entire Software Development Life Cycle.

Implemented project in a 3-Tier Architecture. (Presentation, Business, and Data Access Layers).

JavaScript has been used for client side validation.

Written coding using C# along with SQL Server 2005 database.

Developed end user screens for interacting with the application.

Created WCF services to publish business objects with end points.

WCF services for passing and updating data from data layer to middle to front end.

Developed database and created Tables, Stored Procedures etc.

Was involved in creating release notes and deployment.

Created the release notes for monthly and weekly customer requested data.

Support and maintenance of the product and co-ordinate with the L3 support team.

Involved in performance tuning of the stored procedures and long-time executing queries.

Environment: ASP.NET, C#, JavaScript, HTML, XML, .NET Framework, SQL Server, WCF

Client: Religare Securities Limited, India Oct, 2008 – Mar, 2010

Project: Human Capital Management System - eRecruitment

Role: Systems Engineer

Project Description

Adrenalin Recruitment Module helps to manage the complete recruitment function. It makes recruitment faster and more effective, while reducing costs and impact of employee turnover. This module consists of sub modules like Recruitment Masters, Position Management, Vacancy Management, Resume Screening, Interview Management and Candidate Selection. It identifies vacancies and map requirements by skill sets, experience, etc. Post vacancies on the internal job-board, external job board and with external consultant / media to invite applications Recruitment tracks and record unique resumes across sources .This system creates and use document templates for applicant correspondence for acceptance, rejection and status at various stages. The iReporter module is used to generate various kind of reports using dynamic queries by the end user. Customer can build their own query using the drag & drop options from the iReporter system.

Responsibilities

Developed applications using N-Tier Architecture with presentation layer, business and data access layers using .NET Technologies.

Writing Business Logics in C# and application development in ASP.NET

Created Cascading Style Sheets (CSS) to improve the user-interface of the application.

Identification of modules and sub-modules & creating the effort estimations.

Created Tables, Joins and Stored Procedures using SQL Server database.

Used ADO.NET features and created SQL Queries to manipulate data.

Developed and consumed ASP.NET Web Services for common functionalities.

Extensively used Grid Views with sorting, paging and various template columns.

Attended daily status meeting with the clients.

Environment: ASP.NET, C#, SQL Server, Web Services, JavaScript, XML, HTML, ADO.NET, Crystal Reports

Client: Agrodutch Industries Limited Nov, 2006 – Jul, 2007

Project: Enterprise Resource Management

Role: Program Trainee

Project Description

This ERP project handles the all enterprises related things of a Container making factory. In the first phase handled production related transactions like production, wastage calculation, consumption, packing and floor stock. In Stock related accepts, it handles the material receipts, issues, issues returns, sales return, adjustments etc. In this system all programs are inter related and mainly classifies into master entry, master lists, transactions, reports, administration, and miscellaneous levels. In this all programs are made in the basis of application. In our reports we are using lexical parameters also for reports. This system provides the facility to convert the reports to Excel, PDF, Html formats

Responsibilities

Developed Masters Forms and transaction forms like Stock entry transaction, issue return etc. and also I did many transaction reports and MIS reports.

Developed Front end screen designing and backend process like creating stored procedures, functions and views.

Involved in requirement analysis, design and prototype development, effort estimation and team management.

Responsible developing WebForms for client-side validation. Configuration and Version Control by Visual Source Safe (VSS).

Participated training and sessions on .Net Architecture Framework.

Environment: C#, Asp.Net, SQL server 2000, Crystal Reports

Contact this candidate