Rajkumar Gupta

Mobile No. : +919*********

E-Mail : acutiy@r.postjobfree.com

Passport No. : G6776472

Experience Summary

9.5+ Years of IT experience in Software Development and Implementation using Microsoft Technologies.

Motivated and ambitious MSBI (SSIS, SSRS) Developer with using SQL Server 2005/2008/2012.

Good experience and understanding of database design, relational integrity constraints, OLTP, OLAP.

Strong in SSIS, SSRS, Sql Server and database design, analysis of business requirements.

Experience in creating Sql Jobs, Alerts, SQL Mail Agent, Design ETL Package and Scheduled SSIS Packages.

Design, Deploy SSRS Reports.

Database Activity

Created numerous simple to complex queries involving joins, correlated sub queries Tuned and optimized queries by altering database design, execution plans, analyzing different query options, and indexing strategies.

As part of a team, analyzed the business requirements and systematically designed a database for our applications. Employed best practices in creating a complete schema including tables, relationships, stored procedures and views, clustered and non-clustered indexes.

Design and Create ETL package and Reports.

Career Profile

Name of Concern

Period

Designation

EdCIL (India) Limited

Aug 2014 – Till Date

MIS and Development

Velocis System Pvt. Ltd.

Mar 2013 - Aug 2014

Senior Developer

CyberQ Consulting Pvt. Ltd.

May 2009- Feb 2013

Senior Programmer

HCL Info system Pvt. Ltd.

Apr 2006 - Apr 2009

Programmer

Skills Profile

Areas/Applications

SQLServer2005/2008R2/2012,MSBI(SSIS,SSRS),Data warehouse

ETL Tool

SQL Server Integration Services 2005/2008

Reporting Tool

SQL Server Reporting Services 2005/2008

RDBMS

SQL Server 2005/2008,Oracle9i

Language

C#

IDE

Visual Studio 2005/08/10

Assignments

The details of the various assignments that I have handled are listed here, in chronological order.

Title: National Means-cum-Merit Scholarship Scheme (NMMSS)

Environment : Windows Server 2010, Visual Studio 2008

ETL Tool: SSIS 2008

Reporting Tool: SSRS 2008

Database: Sql Server 2008R2

Description:

The objective of the scheme is to award scholarships to meritorious students of economically weaker sections to arrest their drop out at class VIII and encourage them to continue the study at secondary stage. Scholarship of Rs.6000/- per annum (Rs.500/- per month) per student is awarded to selected students every year for study in classes from IX to XII in Government, Government aided and local body schools. There is quota of scholarships for different states/UTs. Students whose parental income from all sources is not more than Rs. 1,50,000/- are eligible to avail the scholarships. The selection of students for the scholarships was being made though an examination conducted by the State Governments/UT administration along with the National Talent Search Examination. We receive data in excel format via from server and convert it to SQL format then we generate report as per requirement.

Roles & Responsibilities:

Prepared Data model and implemented.

Design OLTP, Design Data Warehouse

Built SSIS packages to Load OLTP Data into SQL Server 2008

Created Email notification.

Generated Jobs and scheduled.

Stored Procedure Design

Monitoring Jobs & Alerts

Title: E-Admit Card Application system

Environment : Windows Server 2010, Visual Studio 2010

ETL Tool: SSIS 2008

Reporting Tool: SSRS 2008

Analysis Tool: SSAS 2008

Database: Sql Server 2008

Description :

UPSC conduct many exams as IAS, IFS, CPF, SCRA, NDA, CDS etc. After filling form candidates has got a RID number. It’s an auto generate number. After that candidate generate their E-Admit card in PDF format using RID number and date of birth. I have worked here for designed e-admit card web based application using asp.net, c#, SSRS, SSIS. Generate e-admit in PDF format in SSRS using asp.net, C#. Job profile included coding, development, make report, Database maintenance etc.

Roles & Responsibilities:

Built SSIS packages to get data in to SQL Server 2008

Design SSRS Reports

Generated Jobs and scheduled.

Stored Procedure Design

Monitoring Jobs & Alerts

Title: Integrated Management Information System

Environment: Windows Server 2003, Visual Studio 2005

ETL Tool: SSIS 2005

Reporting Tool: SSRS 2005

Database: Sql Server 2005

Description:

Integrated Management Information System is web based application. This s/w is designed for fixation/Revision of prices of scheduled Bulk Drugs/Formulations under drugs prices control order. This s/w is designed for Medicine Company who manufactured medicine and send reports or medicine formulation to Govt. of India to fix their medicine Prices.

Roles & Responsibilities:

Built SSIS packages to get data from Excel to SQL Server 2005

Design SSRS reports.

Created Email notification.

Generated Jobs and scheduled.

Stored Procedure Design

Monitoring Jobs & Alerts

Title: Newsonair

Environment : Windows Server 2003, Visual Studio 2005

Front End: Asp.Net with C#, ADO.Net

Reporting Tool: SSRS 2005

Database: Sql Server 2005

Description :

This project of All India Radio is a website developed for the public to view and listen all kinds of news in different languages. All news is updated through CMS (Content Management System) developed by the team..

Roles & Responsibilities:

Involved in the development and maintenance of the project.

Implemented & worked on various security issues required for CMS.

Involved in Search Engine Optimization to improve volume/traffic on website.

Managing daily operations & human resources involved in upgrading & development of website.

Design SSRS reports.

Stored Procedure Design

Title: Community Information Center (CIC)

Front End: Asp.Net with C#, ADO.Net

Reporting Tool: SSRS 2005

Database: Sql Server 2005

Description :

This s/w is for all those who are responsible for administering CICeNRICH software at NIC Head quarters, State, District and Community level, for Domain Managers and also for the end users who consume the information in rural areas people who are unknown their areas knowledge.

Roles & Responsibilities:

Involved in Requirement Collection, Designing, Developing, Deployment & Training of Application.

Designing of Database. Implementing & worked on various security issues required for CMS.

Generated Reports required for smooth flow of data at various levels and for further analysis.

Design SSRS reports.

Stored Procedure Design

Title: Integrated Sugar Information System

Front End: Asp.Net with C#, ADO.Net

Reporting Tool: SSRS 2005

Database: Sql Server 2005

Description:

Sugar production data is collected from all sugar factories on weekly basis in telegram/Performa-II/fax by Directorate of sugar. The data so collected focus basics for deciding the regulated release mechanism during the different months. Job profile here is coding, development, make report, Database maintenance etc.

Roles & Responsibilities:

Involved in the development and maintenance of the project.

Implemented & worked on various security issues required for CMS.

Involved in Search Engine Optimization to improve volume/traffic on website.

Managing daily operations & human resources involved in upgrading & development of website.

Design SSRS reports.

Stored Procedure Design

Title: Sugar Export Transport Subsidy Claim

Front End: Asp.Net with C#, ADO.Net

Reporting Tool: SSRS 2005

Database: Sql Server 2005

Description:

The objective of the system is to promote the export of sugar. In order to promote the export of sugar government announces subsidy on the expenses incurred on export process by road, rail and port. The maximum subsidy amount fixed by the government Rs 1350/mt is for the factory located in the coastal area and Rs 1450/mt for the factory located in the non-coastal area.

Roles & Responsibilities:

Involved in the development and maintenance of the project.

Implemented & worked on various security issues.

Involved in Search Engine Optimization to improve volume/traffic on website.

Managing daily operations & human resources involved in upgrading & development of website.

Design SSRS reports.

Personal Details

Education Qualification

Master of Computer Application (2005)

Present Address

20B, Gali No-16, Vashist Park, Pankha Road, New Delhi

Contact this candidate