Sql Server Software Engineer

RESUME

S.B.GANAPATHIRAMAN Lotus F*, I Floor, Harine Apartment,

Senthil Nagar, VijayNagar extension,

Near PTC Quarters,

Varadharajapuram,

Chennai – 601301.

Mobile: 984*******

E-mail: ********@*****.**.**

Profile

Having 10+ years of relevant IT Experience in Software Development.

Expertise in VB6, ASP, ASP.NET, VB.NET, C#, MS-SQL SERVER and Crystal Reports.

Handled various aspects of the Project Life Cycle which includes Design, Requirements Analysis, Team Management, Decision-Making, Project Handling, Testing and Evaluation and Quality Improvement.

Experience in MS. SQL SERVER 2005/2008 Database Administration.

Good Team Player while maintaining independent line of thought.

Can take responsibility and can lead a Team.

Good experience in SQL Queries, Stored procedures and Performance Tuning.

Professional Objective

To attain Professional excellence through result-oriented approach, smart work, self-motivation and confidence and to use my capabilities to grow with the organization.

Educational Qualification

1. M.C.A May 1999, Bharathidasan University, Tiruchirapalli.

First Class, 1996 – 99.

2. B.com May 1996, Bharathidasan University, Tiruchirapalli.

First Class, 1993 – 96.

3. MBA – HRM, Anna University, Chennai.

Technical Skills

Web Technologies : JavaScript, ASP, ASP.NET and C#

Database : MS-SQLSERVER 2008 and

MS. Access 2007

GUI : VB 6.0, Visual Basic.NET

Professional Experience

1.Worked as Team Lead-Software in Cadgraf Digitals Pvt. LTD from July 2015 to 31-May-2016 in Chennai.

2.Worked as Deputy Manager-Software (Project Lead role) in Scientific Publishing Services Pvt. LTD from Nov 2008 to Dec 2014 in Chennai.

3.Worked as Senior Software Engineer in WIPRO Technologies from Oct 2007 to Sep 2008 in Chennai.

4.Worked as Software Engineer in Scientific Publishing Services Pvt. LTD from Feb 2001 to Sep 2007 in Chennai.

PROJECTS HANDLED

Project title

NEO SYSTEM

Platform and Tools

VB.NET and SQL SERVER 2008

Role

Team Lead includes Coding

Duration

10 months

Company

Cadgraf Digitals

Description

NEO is an multi-user system. It is an easy-to-use tracking tool for tracking the Newspaper Stories for various stages for customer workflow. This System gives a clear picture of the status of Jobs to plan and maintain schedules.

Project title

Migration to SQL SERVER 2008 R2

Platform and Tools

MS-SQL Server 2008 R2

Role

Stored procedures Development & DBA

Duration

1 year

Client

Internal Production Team

Description

This Project deals with migration of database from MS-SQL Server 2008 to MS-SQL Server 2008 R2 for Production Tracking Application of 5 Client applications.

Project title

Production Management System (PMS)

Platform and Tools

ASP.NET, C#, JavaScript and MS-SQL Server 2008

Role

Project Lead

Duration

1.5 years

Client

Internal Production Team

Description

PMS is an intranet based multi-user system. It is an easy-to-use tracking tool for tracking the Jobs for various stages for different customer workflow. PMS gives a clear picture of the status of Jobs thereby helping the production team to plan and maintain schedules. The Production team Manager can view the status and MIS reports easily. The productivity of the team can be generated by Human resources team easily.

Project title

Online Store

Platform and Tools

ASP, Commerce Server 2002 and MS-SQL Server 2005

Role

Sr. Software Engineer

Duration

5 months

Client

IATA, Montreal, Canada

Description

The OnlineStore is a Shopping cart application, which deal with Products like Books, Class Room Training, Web downloadable etc. These products cater to the Airline industry requirements. This application helps the users to select IATA products and orders can be placed. They can make payments through Bank/Credit Card. The validations of the Credit Card are done through the third party software Cyber Source. This is one of the main sources of revenue generating source. The user has to create their login Id and can select products & place orders. This has the option to view the orders created by the customers. Role: I had worked in fixing the Incidents, Developing enhancements, Preparing RCA, Impact Analysis documents and System Outage documents.

Project title

Order Processing System

Platform and Tools

VB 6.0, ASP & MS-SQL Server 2005

Role

Sr. Software Engineer

Duration

4 months

Client

IATA, Montreal, Canada

Description

The Order Processing System (OPS) is an intranet used to track the orders & process them, raise invoice and make payment entries. The Customer Service Dept. (CS) can also create orders and process it using this application. This has the Master entry modules like Customer, Products, Shipping Charges, Inventory, Login Id creation and transactions modules for creating orders. It has various reporting options like Total orders, sales shipping etc. And, the CS Dept can send automatic e-Renewal to the customers for the products subscribed by them.

Role: fixed the Incidents, completed enhancements, Preparing RCA, Impact Analysis documents and System Outage documents.

Project title

Supply vs. Demand Management & AutoSlotting System

Platform and Tools

SQL Server 2005,ADO, IIS, Process Automation, TCP/IP, C#, NET Framework

Role

Sr. Software Engineer

Duration

2 months

Client

ITV plc, UK

Description

This application will provide the optimized Campaigns to fit in the Commercial breaks occurring in between programs of the ITV. Moreover, the Sales Group users and Sales Operations Users provided with the PYO (PICK YOUR OWN) options to choose the optimal campaign (Soft and Hard PYOS) to increase the revenue. Role: developed the Stored Procs for the following cases and created Linked Server for the application. a. To identify the differences in the Post extract data process b. For Housing Keeping purpose – purging old data from the database of the application c. Created Linked servers in this application d. Created Ingres SQL Scripts to upload the data from the application to the Client database (Ingres).

Project title

Author Correction Details Tracking System

Platform and Tools

ASP, VB 6.0 and MS-SQL Server 2008

Role

Design, Coding, Testing

Duration

1 year

Description

This web application is used to track the Author Correction details

(Mandatory components) for the articles processed in the SPS. The automated email reminders will be sent to the Author requesting the unsent components. The database entry will be made automatically and notification ZIP package will be sent to the Springer automatically. Some applicable information will be fetched from the Input (XML Meta file)

Project title

AutoXMLOrderProcess System

Platform and Tools

VB 6.0 with MS-SQL Server 2008

Role

Design, Coding, Testing

Duration

2.6 years

Description

Articles/Issues received automatically logged in directly into the Workflow. The system automatically calculates and assigns deadline for the various departments/stages and helps in keeping track of an article/issue as it moves through production cycle.

Project title

SPS HR PACKAGE

Platform and Tools

VB 6.0, Crystal reports with

Access 2000

Role

Design, Coding and Testing

Duration:

3 years

Description

The Package has following modules:

a. Attendance Monitoring System

b. Payroll Processing System

Attendance Monitoring System comprised of HR modules like Employees Master Entry, Leave, Permission, Overtime update, Manpower Planning, Increment/ revisions and manual attendance updating (if any). It has various reports for HR department.

Payroll Processing System has Monthly Salary processing and generation of Pay slip and various Reports. It will generate various report line ESI, PF report etc.

Project title

Springer PTS - UDR System

Platform and Tools

ASP 3.0, JavaScript, VB 6.0 & Access 2000

Role

Design, Coding and Testing

Duration

6 months

Customer

Springer Science + Business Media, Germany

Description

This application is a combination of batch processing and web application. It has 4 modules - FTP refresh, data loading, web application and Email Notification. The entire process is scheduled in the server and it will run on weekdays.

FTP refresh application downloads KAPReport.mdb file from ftp1.wkap.nl site if only the data refreshed. File Timestamp used for checking data freshness. Data loading program will starts processing and updates the unified_KAPreports.mdb file when it has refresh input and will send a no refresh data alert to application administrator.

Email notification will deliver the overdue notification to the production editors and Production managers with attachments. The web application will also get fresh data i.e. (Unified_KAPreports.mdb) and Performance summary also updated.

Project title

Online Scan Timesheet System

Platform and Tools

ASP 3.0, JavaScript and MS SQL Server 2005

Role

Design, Coding and Testing

Duration

6 months

Description

This web application enables the scanning department to take reports of individual scanning Operators files scanned and processed. Individual Operator can enter the files scanned and processed into the system authenticated by login credentials. The Department head can take the performance reports.

Project title

Workflow Management System (Workflow)

Platform and Tools

ASP 3.0, and HTML with MS-SQL Server 2000

Role

Design, Coding and Testing

Duration

6 months

Description

The Workflow Management System for keeping track of journal Articles for all customers from receipt until dispatch of final medium. Using a web browser, the user can login, view all reports, and take printouts if necessary. Articles/Issues as received automatically logged in directly into the Workflow. The system automatically calculates and assigns deadline for the various departments/stages and helps in keeping track of an article/issue as it moves through production cycle. The system also generates Datasets for the Electronic Deliverables at the page proof/ Revision/Issue stage from the details available in its repository.

Project title

JobTrack

Platform and Tools

ASP 3.0, JavaScript and MS-SQL SERVER 2000

Role

Design, Coding, Testing

Duration

4 years

Description

JobTrack is a Web based online multi-user system. It is a easy-to-user tracking tool for tracking articles/issues across various stages for different customer workflow. JobTrack gives a clear picture of the ongoing articles/issues thereby helping the user to plan and maintain schedules. There are two main stages through which an article goes through namely - Pageproof and Issue Stage. Once the article comes for Pageproof stage directly updated to the database of JobTrack and it automatically generates deadline date for various departments. User can view the status of articles easily and take printouts.

Personal Profile

Name : S.B.Ganapathiraman

Father’s Name : S.Balasubramanian

Date of Birth : 05.02.1976

Marital Status : Married

Language Known : Tamil, English and Hindi

Contact this candidate