Education:

Bachelor of Computer Science and Engineering from Anna University, Chennai, India

Awards, Certifications and Training

Awarded “Keane Silver Certificate” for
delivering defect free code and meeting the SLA

Awarded “Team HITS Certificate” from Honeywell for Q4 2009

Awarded “Team HITS Certificate” from Honeywell for Q4 2010”

Objective

Achieve excellence in work through self-motivation, hard work, and eagerness to learn new technologies.

Professional Summary

• 5 years of Software industry experience in all stages of Project Life Cycle including Analysis, Design, Development, System Testing and Deployment
• Strong experience in SQL Server 2000 and 2005.
• Expert in designing and implementing relational database model as per business needs.
• In-depth knowledge of Transact-SQL (DDL,DML)
• Expert in creating Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2005
• Experience in setting up SQL Server 2008 development environment.
• Experience in the upgrade of SQL Server 2000 to 2005
• Experience in creating Jobs, Alerts,SQLMail Agent, and schedule DTS/SSIS Packages.
• Experience in configuration of reportserverand report manager scheduling, give permissions to different level of users inSQLServerReporting Services (SSRS).
• Experience in installation, upgrade and configuration of MicrosoftSQLServerand databases.
• Expertise in the upgrade of Changepoint11.02 to Changepoint 2009
• Implemented Time Tracking System for Honeywell employees in Changepoint
• 10 months of working experience in Travis Perkins Client Location (United Kingdom).
• Responsible for training new employees and providing detailed knowledge of the software as well as the business.
• Experience in working with end-users for support and maintenance activities.
• Experience in performance tuning of the reports
• Effective team player and lead a team of 4 members
• Excellent communication, analytical, interpersonal and presentation skills.
• Experience in configuration management tools like Visual Source Safe.
• Expertise in Client side and server side scripting with JavaScript.
• Experience in working in the Database redesign and normalization project
• Expertise in working in various migration projects
• Configuration Team Lead (CTL) for PPS project which consist of Changepoint, SIOP, MyISR and Scorecard
• Quality Team Lead (QTL) for Changepoint
• Experienced in Onsite Offshore model coordinating with development/support activities.
• A reputation with team for being thorough, conscientious, hardworking, intuitive, and having good analytical skills. A highly motivated self-starter who is passionate about technology.

Experience Summary

Employer

Duration

Designation

Confidential,

25/06/2007 to 15/02/2012

Team Lead

Technical Skills

Programming Languages

ASP.NET,C#.NET, T- SQL, Java, Pick Basic

Dot NET Framework

.NET Framework 1.1, .NET Framework 2.0

Web Technologies

JSP, HTML, DHTML, CSS, XML, JavaScript

Operating Systems

Windows 2000/NT 4.0, XP, UNIX

Database

SQL Server 2000/2005/2008, Universe

Application Server

IIS

Server-Side Technology

J2EE

Version Control System

Visual SourceSafe

Scripting Languages

Java Script, VB Script

EPOS (Electronic Point of Sale)
Duration: Feb 2011 – Feb 2012

Confidential,
Electronic point of Sale Applications involves Merchanting system operations between the company and its customers. The Project is to establish and run a long-term development, application enhancement and maintenance engagement.

Responsibilities:

• Senior developer in the Client’s Team.
• Onsite Coordinator for all modules and responsible for all communications between Offshore and Client.
• Worked with business partners to transform the business requirements to technical specification.
• Handled an offshore team of five members.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions and Views.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Ensure on-time deliveries from Offshore

Technologies: Universe, Pick Basic, SQL Server 2005

Process Model: Development Project.

Client: Travis Perkins

Location: Northampton, United Kingdom

Sales Inventory Operation and Planning
Duration: May 2010 – Jan 2011

Confidential,

Honeywell IT Services used this application for determining demand and capacity plans. It is the process by which management proactively coordinates, integrates, and provides direction for the projected demand and capacity. Demand Management and Capacity Management are two key elements of the SIOP.

Responsibilities:

• Involved in Requirements Gathering
• Involved in the migration of the SIOP Application from ACS (Automated Control System) to (Honeywell IT services Environment)
• Involved in the normalization project and re-design the database.
• Successfully migrated the data fromSQLServer2000 toSQLServer2005.
• Developed the Individual WalkForward System module in SIOP web application
• Implemented the Personal Time Tracking notification using SSIS in SIOP application.
• Configuration Management activities
• Have leaded the team and acquired leadership qualities.
• Got recognition for the successful migration of the SIOP Application to HITS environment

Technologies: C#.Net, SQL Server 2005, Windows XP

Process Model: Development Project

Client: Honeywell

Location: Chennai, India

MyISR (Infrastructure Service Request)
Duration: Dec 2009 – April 2010

Confidential,

Honeywell IT Services used this application for tracking the Infrastructure Service Request. The ISR request created in Changepoint application will be viewed by the Honeywell users in the MyISR Portal. The MyISR portal allows the users to keep track of the service request created in changepoint. The tool allows report generation based on various input filters in the region wise.

Responsibilities:

• Understanding the Existing System
• Co-ordinated with the Honeywell team and involved in the migration of the myISR portal from ACS (Automated Control System) to (Honeywell IT services Environment)Environment
• Re-Design the SSIS Packages used in the existing System
• Configured the SQL server reporting server and set up the reports in the new environment

Technologies: C#.Net, Sql Server 2005, SSIS and SSRS

Process Model: Migration Project.

Client: Honeywell

Location: Chennai, India

Changepoint
Duration: June 2007 – Nov 2009

Confidential,

Changepoint is a Project Portfolio Management tools. Changepoint is a single, integrated system that enables Information Technology (IT) organizations or departments to manage core work processes. Changepoint successfully tracks effort for projects, processes, and request-driven work. Developed by Compuware Corporation Changepoint effectively tracks a client’s core business processes from start to finish, providing real-time access to accurate, business-critical data. Changepoint automates and integrates key business processes and gives access to unprecedented views into the distribution of effort and cost of service delivery. Management gains greater control to drive accountability at all levels of the organization to ensure investments support business priorities and increase the quality and efficiency of service delivery.

Responsibilities:

• Involved in complete Life Cycle including Analysis, Design, Development and Testing.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using DTS
• Upgraded the Changepoint application from version 11.02 to 2009
• Upgraded the Changepoint database from SQL 2000 to SQL 2005
• upgraded the DTS packages in SQL 2000 to SSIS packages in SQL 2005
• Involved in designing the SSIS packages to export data of flat file source to SQL Server Database
• Involved in issue fixing of support tickets within SLA time
• Involved in analysis, estimation and development of enhancement requests.
• All support applications are offshore driven, coordinated with customers in requirements gathering, implementation and issue discussions.

Technologies: ASP.NET, SQL 2000/2005, DTS, SSIS

Process Model: Application Management