Sql Server Manager

KAMARAJ V

Mobile: 094********; E-Mail: act6yl@r.postjobfree.com

Seeking assignments in Web Application Design & Implementation with a technology driven organisation of repute, preferably in IT - Software industry

PROFILE SUMMARY

Offering over 10 years of experience in:

~ Application Development ~ Coding, Testing & Validation

~ Client Servicing ~ Effort & Cost Estimation

~ SDLC ~ Technical Documentation

Skilled in mapping clients’ business requirements and translating these requirements into functional specifications, services, implementations and custom designing solutions.

Gained knowledge in SharePoint Web Parts, Workflows, InfoPath Forms, Business Data Catalogue, Business Intelligence, Reporting and Windows SharePoint Services.

Having real-time experience in SharePoint Office 365.

Depth in handling end-to-end development of software products / projects from inception, requirement specs, planning, designing, implementation, configuration, documentation and closure with cross-cultural teams

Rich experience in project management activities with insightful knowledge of analysis, design, development, testing, configuration management and training

Acquired technical expertise in SQL Server, Transact-SQL, ADO.NET Entity Framework, writing optimized T-SQL, WCF, Silverlight 3.0 & RIA Framework and SharePoint 2013 & SQL Server 2012

Good knowledge in SSIS and SSRS and SSRS integration experience with SharePoint 2010 environment.

Good experience in Deploying SharePoint Solutions into QA and Production environment using PowerShell.

Able to design Master page, Page Layout, Business Approval workflow, Approval Dashboard.

Decent knowledge in Bootstrap, AngularJS and REST API also integrate these into SharePoint 2013.

Having good understanding and experience in implementing ASP.NET MVC 4/5 with Bootstrap and AngularJS.

Effectively handling support activities in existing projects and North American Ford customer.

ORGANISATIONAL EXPERIENCE

Since Aug’10: Ciber Sites India Pvt. Ltd, Chennai as a Senior Consultant

Deputed at Ford India- Chennai

Oct’08-Jul’10: ShipNet Software Solution India Pvt. Ltd., Chennai as a System Analyst

Nov’07-Oct’08: Cloversoft Solutions (P) Ltd., Guindy, Chennai as a Team Leader

Apr’06-Oct’07: Insoft.com Pvt. Limited, L.B. Road, Adayar, Chennai as Senior Programmer

Jul’04-Mar’06: XSoft Technologies, Adayar, Chennai as Software Engineer

Role:

Functional:

Analyzing user needs and requirements to determine feasibility of design within time and cost constraints; consulting with customers about software system design and maintenance

Interacting with team members to ensure smooth progress of project work; monitoring and ensuring customer delivery during the transition period

Ensuring adherence to quality norms throughout the implementation process; identifying, analyzing defects, questionable functions, errors, inconsistencies in software program functions, outputs, online screens and content

Conducting system study and coordinating with team members for product documentation, system design & integration, coding, application maintenance, etc.

Delivering and implementing the project as per scheduled deadlines and extending post-implementation and maintenance support

Designing, developing and implementing the workflow program, presentation and handling various phases of interface development based on technical specification

Technical:

Microsoft SharePoint Server 2010, Microsoft SharePoint Foundation 2010, Basic and Enterprise Search configuration for SharePoint, Microsoft Office SharePoint Server 2007 (MOSS 2007), Windows SharePoint Services 3.0 (WSS 3.0)

Installation, Configuration, Upgrade, Architecture, Customization, Site Templates, Site Definitions, Taxonomy, Metadata, Content Management, Collaboration, Windows Workflow Foundation, Custom Web Parts, BCS, Search, InfoPath Services, Content Types, Features, Excel Services, PerformancePoint & CAML

Microsoft Office 2010, Microsoft Office 2007, SharePoint Designer 2010, InfoPath, Visio, Project, Active Directory,

.Net: ASP.Net, C# & VB.Net

WCF, HTML, CSS, XML, XSL, XSLT, JavaScript, JQuery, AJAX & Silverlight

SQL Server 2008/2005, SQL Server Reporting Services (SSRS) & SSIS

Visual Studio 2010/2008

Current Projects:

North American Vehicle Logistics

Knowledge Sharing Portal

Plant Floor System

Ford Appeal Application

Market Rep Planning

Accomplishments:

Successfully designed, developed & implemented SharePoint Portal for back office applications

Played a key role in developing SharePoint components including web parts, lists, web pages, workflow, InfoPath forms and back-end processing solutions

Recognised for deploying, managing, monitoring, upgrading, migrating and designing SharePoint Servers

Instrumental in designing, deploying & testing web systems, applications, tools & sites

Efficiently handled the development, implementation and utilization of Web Services & Service Oriented Architectures (SOA)

CERTIFICATION

Microsoft Certified Technology Specialist (MCTS) in .NET Framework 2.0 & ASP.NET 3.5

TRAINING

Undergone 3 months intensive training on Web Development with advanced Java at Radiant Software Solutions

EDUCATION

MCA from Bharathidasan University, Trichy in 2005

PGDCA from Bharathidasan University, Trichy in 2002

B.Com. from Bharathidasan University, Trichy in 2000

Diploma in Computer Software APTECH, 1995 – 96; achieved 7th rank in all over India

PERSONAL DETAILS

Date of Birth: 2nd May 1974

Permanent Address: S/O. Veerappan, Thulukkaviduthi South, Avanam Post, Peravurani Taluk, Thanjavur District - 614623, Tamil Nadu, India

Current Address: Old No. : 9/1, New No. : 93, Avvai Nagar, West Street, Choolaimedu, Chennai – 600094, Tamil Nadu, India

Please refer to the annexure for project details

ANNEXURE

Currently working in

Global Network Distribution Strategy (GNDS)

Market Representation Planning website

Knowledge Centre (Site redesign)

Title: North America Vehicle Logistics (NAVL)

Environment: SharePoint Server 2010, SharePoint Designer 2010, XSLT, JQuery

Period: Nov’13-Jan’14

Description: SharePoint 2010 application to maintain Vehicle Logistics for Ford.

Responsibilities:

Efficiently developed:

oList- Schema preparation

oDesigned and customize List Forms with effective validation

oDesigned Approval workflow with various stages of approvers.

oSite pages for all level of approval

Title: Corporate Trip Manager

Environment: SharePoint Server 2010, SharePoint Designer 2010, XSLT, JQuery & InfoPath 2010

Period: Jan’13-Nov’13

Description: PreTrip is a tool used to submit and authorize Travel requests. Originally this was going to be rolled out World Wide and it is still possible that it might but the current focus is on North America right now.

Responsibilities:

Efficiently developed:

oInfoPath filler form to create trip request

oSharePoint Designer Workflow

oDashboard page using XSLT

oSite pages for all level of approval

Title: Plant Floor System

Environment: SharePoint Server 2010, SharePoint Designer 2010, XSLT, JQuery, ECMA Script & SPServices

Period: Mar’13-May’13

Description: PFS site used to maintain all the running and protecting the business for Plant Floor System.

Responsibilities:

Managed branding master page and created site pages

Involved form customizations and workflow

Title: Idea Place

Environment: SharePoint Server 2010, SQL Server 2008 R2, SharePoint Designer 2010, XSLT, JQuery, ECMA Script COM, SP Services & managed Metadata Services

Period: Sep’12-Dec’12

Description: “IdeaPlace” is a web application to collect the valuable ideas and suggestions from employees of Ford across the globe. Ideas can also be potential candidates for future patents for which the idea submitter will be duly credited. It is a complete system which performed acceptance accept ideas from the employees across the globe. Categorized & classified ideas for easy retrieval. Reviewed of ideas by the SME after which an idea can be accepted or declined. The submitter of Accepted Ideas will be rewarded according to the Employee Reward Policy.

Responsibilities:

Developed Designer Workflows for idea review process, idea submission and reward process

Search Customization using XSLT and Managed Metadata Refiners.

Personalized Dashboard Views for Admin & Reviewers using content Query Web Part.

Data view Web Parts with XSLT customizations for idea views.

Home Page Views using Content Query Web part.

Highlights:

Handled maximum site customization helping the admin (without technical knowledge) to perform all site related activities with ease

Carried out search customizations with additional refiners and custom search views using XSLT

Managed Metadata Features for filtering ideas

Worked on SP Services and client object model

Provided dashboards for Admin & Reviewers to perform their tasks

Title: IFRS (International Financial Reporting Standards)

Environment: SharePoint 2010, C#., Asp.Net, JQuery and JSGrid Control

Period: Jun’12-Aug’12

Description: The current process for quarterly liability reporting and tracking complies with US (GAAP). This is a manual process and is conducted for only 30 sites out of 150 sites. To comply with the IFRS standard, this process needs to be performed for all 150 sites, and will impact a fivefold increase in this effort.

Provide a collaboration solution that simplifies the above process, by enabling the environmental engineers (for all 150 sites) to input financial information into a system to avoid the duplicate entry when financial analysts perform their quarterly adjustment and reporting process.

Responsibilities:

Deftly involved in creating site column, content type, list definition, list instance, visual web parts, unit testing and deployment in QA environment

Efficiently used JSGrid control for site cost estimation purpose

Title: CAMS (Computer based Application Management System)

Environment: SharePoint 2010, Client Object Model, SharePoint Designer 2010, XSLT and JQuery

Period: Mar’12-May’12

Description: CAMS used to maintain the applications used to Ford (North America). Three major types of applications such as VESS, Manufacturing and Other applications are available. Each application contains one associate Availability List (SharePoint List). Availability Lists contains details about the applications such as version, operating system, platform, etc.

Responsibilities:

Involved in creating different Data view pages using ECMAScript (Client Object Model) and JQuery

Title: Leave Management System

Environment: SharePoint 2010, InfoPath 2010, SharePoint Designer 2010, XSLT and Jquery

Period: Jan’12-Feb’12

Description: LMS is used by Ford corporate Employees (Chennai and Gurgaon). By using this system employee can apply leave and getting approval from respective Managers. Leave type, Leave balance details, employee details, manager details are stored and maintained in SharePoint Lists.

Leave/Approve forms are developed by InfoPath 2010. Managers are able to view their employee leave history and required reports in a Manager Dashboard. Employee also has a Dashboard page to see his/her details in clear picture. Approval/Rejection process has been handled by SharePoint Designer Workflow.

Responsibilities:

Accountable for creating:

oInfoPath Form templates and apply rules based on requirement

oSharePoint designer workflow to approve/reject leave process

oEmployee and manager dashboard page using Data View Webpart with XLST 1.0

oExtensively used JavaScript and JQuery for validation purposes

Title: @Ford Online (www.at.ford.com)

Environment: SharePoint 2010, C#., Asp.Net, Client Object Model, SharePoint Designer 2010, XSLT and JQuery

Period: Mar’11-Dec’11

Description: @Ford Online is the Web hub for Ford Motor Company. The site can be seen as ‘one-stop shopping’ with links to work tools and thorough global news coverage about the company and the industry for all employees, retirees and agency/contract personnel.

The site introduces new features, including the ability to 'like' articles and the Tags section. Also, new to the site is the ability to customize a section on the page with five links of your choosing. We’ve made the world clock visible on the home page for key Ford cities and added a visible navigation footnote panel. The Stock Ticker has been enhanced as well as the A-Z section with the addition of a search that will only return results from the A-Z section. The site is much more globally representative and allows some sections to display regional specific content.

Responsibilities:

Efficiently involved in webpart design & development

Removed the CQWP and introduced the DVWP in A-Z Site Index, News, Publication & Clipsheet Modules to increase the performance & productivity

Successfully developed Tag-cloud by using Data View webpart and XSLT 1.0.

Involved in bug-fixing and support during production move

Involved in develop Around the Oval webpart using CQWP with XSLT 1.0.

Creating Technical specification documents

Create custom permission levels and implemented permission levels based on requirement

Create Custom content Types and Page Layouts in SharePoint Designer 2010

Extensively used JavaScript/JQuery.

Extensively used ECMAScript (Client Object Model)

Implemented Target Audience in item, webpart and page library level based on requirement

Title: ITCN (Information Technology Communication Network) www.itcn.ford.com

Environment: SharePoint 2010, C#., Asp.Net, Client Object Model, SharePoint Designer 2010, XSLT and Jquery

Period: Aug’10-Feb’11

Description: Each week IT Communication Network (ITCN) provides global news and information for Ford IT employees. Employees from The Americas, APA, and Europe submit articles about their regions, departments or teams. Articles in ITCN can be displayed for a global audience, or, if needed, marked for display in only specific regions.

ITCN is a collaborative publication, with reader comments encouraged on all major articles. Additional features in ITCN provide diversion (IT tube), encourage innovation (What’s Hot in IT), announce personnel changes (Personnel Announcements), highlight achievements (ITCN Spotlight), and track events (IT Calendar). Global IT websites are accessible by regional tabs located across the top of ITCN. Other tabs include IT A-Z Index, a user-maintained listing of miscellaneous IT sites, and links for global computer support.

Title: Enterprise Solution

Environment: Windows SharePoint Services 3.0, MOSS 2007, C#.Net, Asp.Net & SQL Server 2005

Role: System Analyst/Developer

Period: Aug’09-Jul’10

Description: ShipNet provides business critical solutions to ship-owners, charterers and ship managers, based on a comprehensive ERP software platform that ties together all departments within a maritime enterprise, ship to shore.

Enterprise Solution: The main purpose of this site is to integrate the available applications into one common framework that would improve the activities happening on different verticals/ departments, data exchange platform from one application into another.

Worked on 5 different modules:

Process & Policies (QShip) - a repository of approved process assets for our project execution and to maintain completed approved documents in historical database for reference with easier web access

Enterprise Applications - a suite of basic applications that help improve basic activities that need not be managed manually

Human Resource Management - End to end HRMS solution that caters to the most important needs of the HR Team. The most important modules of the HRMS solution would be the Recruitment and the Performance Management

Infrastructure Management - a set of modules built and made available to the IT Team of ShipNet India, that would allow them manage the Infrastructure very well

ShipNet India Intranet - The purpose of the module is to centrally store all the information regarding employees and form the base for other modules to be developed in ShipNet Dev World. This site has various modules like Taxonomy, Home Page, Performance Management, Policies and Pre-requirement process

Title: Marine Exchange (MEX)

Environment: C#.Net3.5, ASP.Net, 3.5, WCF, MSMQ, WebService, LINQ, XLINQ, Windows service, Lamda Expression, SQL Server2005, Visual Studio 2008 & DevExpress Controls

Period: Jun’09-Aug’09

Title: Disbursement Management Solution (DMS)

Period: Oct’08-May’09

Client Handled: Golden Ocean - Norway, Martrade shipping – Germany and Geogas Trading SA – Switzerland

Team Size: 10

Environment: .NET Framework 2.0 with Windows XP, Languages: ASP.NET 2.0, C#.NET, Visual Studio .NET 2005, SQL Server 2005, ETL & SSIS

Title: HRClover

Period: Jun’08-Sep’08

Client: Transworld Education Academy Pvt. Ltd.

Team Size: 4

Environment: WPF, SQL Server 2005 and C# 3.0

Title: SISI Web Development

Period: Nov’07-Jun’08

Client: SISI (Chennai)

Team Size: 5

Title: XsitePro

Period: Apr’07-Oct’07

Team Size: 7

Environment: C#.NET 2.0, XML and Nevron and DevExpress third part window based controls. Lame Encoder, Viscomsoft.com (VideoEdit ActiveX Control)

Title: QTS File Watcher

Period: Oct’07-Oct’07

Team Size: 1

Environment: C# 2.0

Title: Wirtz(www.wirtznv.be)

Period: Dec’06-Mar’07

Team Size: 3

Environment: VB.NET 2005, ADO.NET 2.0, SQL Server 2005 and Infragistics Window Based Controls

Title: Auxipress

Period: Apr’06-Dec’06

Team Size: 6

Environment: ASP.NET 2.0, ADO.NET 2.0, VB.NET 2005, XML, SQL Server 2005 & SSRS

Title: ecTouch

Period: May’05-Mar’06

Team Size: 5

Environment: ASP.NET 1.1, ADO.NET, C#.NET, XML & SQL Server 2000

Title: Report Manager

Period: Feb’05-Apr’05

Team Size: 1

Environment: Visual Basic 6.0, ADO, XML, SQL Server 2000 & Windows 2000

Title: Golden Accountant

Environment: Visual Basic 6.0, Oracle 8, Windows 2000

Title: Pharma Management System

Environment: Visual Basic 6.0, SQL SERVER 2000, ADO, XML, Windows 2000

Title: Clinic Management System

Environment: Visual Basic 6.0, Oracle 8, ADO, XML, Windows 2000

Contact this candidate