Sql Server Project

Abhishek Sharma

Phone - 092********, 093********

E-Mail - ******.******@*****.**

[pic]

Summary: Ambitious and self-motivated SQL developer with a strong technical

background and more than 3.5 years of work experience in SQL Server and

having good Knowledge of ERP and Business Intelligence.

Education:

Degree Course University % Year

B.tech(Computer Science) Uttarakhand University 65% 2006-2010

Intermediate(Math)* Uttarakhand University 70% 2006

*Achievements: Got three distinctions (Math, Physic, and Chemistry) in

Intermediate.

Work Experience:

1. Employer: NexCen IT Services P Ltd Delhi NCR From July 2011 -May

2013

As a programmer, involved in projects for various multinational clients on

platforms SQL Server using MS SQL, ASP.net, C# technologies. Major projects

involved:

A. TRAI BILLING AND METERING AUDIT

Working as a Programmer Analyst on TRAI BILLING AND METERINGAUDIT for

Client Aircel. This is TRAI mandated annual audit being done as per TRAI

guidelines for the telecom carriers. The sample data has been selected

based on various plans, subscribers, tariffs and time periods. Then this

sample data is being analyzed for any discrepancy between the plan

configuration, teriffs and billing amounts based on different criteria and

observations being shared with TRAI for suitable actions.

Responsibilities included:

. SQL Server Installation

. Data Import and Export

. SQL Tracings and Run time analysis

. SQL Scripting of Data Analysis and Validation at various points.

. Reporting of Observations.

. CDR rating thru alternative measures for Post Paid and Pre Paid Billing

. Review Of Observations

. Status Reporting

B. Worked as a Sql Developer for Data Analysis assignment for Client

Airtel.

Responsibilities included:

. SQL Server Installation

. SSIS(ETL Package) for upload data.

. Data Import and Export

. SQL Scripting of Data Analysis and Validation at various points.

2. MoserBaer India Ltd. Delhi NCR From May 2013 -Current

Working with Moser Baer India Ltd. in ERP. Worked on RAMCO ERP Solution on

SUPPLY CHAIN MANAGEMENT and HCM Module. And SQL SERVER 2008 as Database.

Functional Skill Set:-

. Creation of Master data - chart of Accounts, Account Groups, and GL

master records.

. Creation of Customer/Vendor Accounts Groups, and Customer/ Vendor

Masters Creation

. Creation of Accounts Group and Masters for Items.

. Setting up the entire purchasing cycle including purchase request,

Request for quotation, purchase order with contracts & scheduling

agreements, Goods receive, Supplier Order Based Invoice, Pay Batch.

. Creation of entire Sale Cycle including Sale Order, Ship Order,

Customer Invoice, Receive Payment

. Creation of Master data for -HR Setup, Employee Induction, payroll,

Performance Management system.

. Provide the support on Export -Import Process of the organization.

. Technical Skill Set:

. Create and modify tables, Stored Procedures, various Clustered and

non-Clustered indexes, Triggers, Constraints and Functions.as user

requirement.

. Developed SSRS Report as User Requirement.

. Developed UDS (User Defined Screen) and MIS reports.

PROJECT: ERP HCM Module Implementation. (November 2013 to August 2014)

Client: RECL (Rural Electrification Corporation LTD.)

Team Size: 5

Responsibilities:

. Report Development for HCM (Human Capital Management) Module using

SQL Server 2008.

. Developed reports using SQL Server Reporting Services and utilizing

complex SQL queries and stored procedures.

. Assist junior programmers with scripts, SSIS projects, troubleshoot

complex Stored Procedures and query optimization.

. Troubleshooting Using Code Related Issue /Defects.

. Worked On Ramco 4x VirutalWorks for generate EDK.

. Worked on Ramco 4x Decision Works and provide link between Store

Procedure and Reports. Define Business Terms For Output Data and

Generate Reports.

. Presented training to staff as needed.

. Communicated frequently with business client.

PROJECT: ERP Implementation. (October 2014 to till now)

Client: Shilpi Cable Technologies Limited.

Team Size: 5

Responsibilities:

. Developed, and implemented code as needed using SQL Server 2008.

. Communicated often with business clients throughout the process and

gave updates of work.

. Worked On Ramco on Demand Enterprises for Development.

. Performed troubleshooting and debugging as needed.

. Carefully tracked time and utilized good time management skills to

ensure project deadlines met.

. Provide Post Implementation Support.

Training and Certification:

1. Six month .net training from ducat (8 November 2011 to 30 April 2012).

2. Worked on a project for social networking site using Asp.net, Ajax, C#

as a front-end and Sqlserver 2008 as a back-end.

3. As a project work for B Tech,

a) I have Done My Project (Maintaining the World Clock and Their

Currency) in C++ Language from B.H.E.L (Bharat Heavy Electricals

Ltd.).

b) Created a website for booking airline tickets by using java as a

front-end and MS-access as a back-end. I have done a project of

website in HTML, CSS and Java Script for female actress

maintaining her profile data like Personal details, Films,

Awards, Gallery, Contacts, and Testimonials.

Technical Skills:

Languages: ASP.net, C#,C,C++,HTML,CSS

Databases: SQL Server2008, MS-Access

ERP Software: Ramco 3x, Ramco on Demand Enterprises Cloud Solution, Ramco

4x

Business Intelligence: SSRS, SSIS (ETL Packages)

Strengths:

Excellent Communication skill to present points precisely and clearly

Good problem solving ability and analytic skill to solve the problem

efficiently

Good team player and have excellent interaction skill to coordinate and

work within a team

Personal Information:

Date of Birth: 13-April-1989

Marital Status: Single

Languages Known: English & Hindi

Nationality: Indian

Contact this candidate