Diwakar Singh Negi

Diwakar Singh Negi

Waltham, MA, USA - 02453

Email: acgeor@r.postjobfree.com

: acgeor@r.postjobfree.com

Mobile No: +1-781-***-****

Highlights:

? SSRS SQL DEVELOPER / ANALYST with 10 Years expertise using multiple database interfaces, familiar with

rational database structures, multidimensional databases, SQL Server 2008/2005/2000, SSRS, Visual Studio,

Crystal Reporting and Business Objects. Experience includes requirements gathering, development, design, testing,

deployment and maintenance of SQL Server technologies.

? Development and maintenance of custom reports and queries in a multi-platform environments.

? Domain expertise in HealthCare-Payer vertical includes Members, Providers, Claims and Brokers modules.

? Design data models, stored Procedures, and custom views.

?Extensive experience in Installation, Configuration and Updates of SQL Server & SSRS.

?Experienced in programming tasks-Stored Procedures, Triggers and Cursors, Index, Views and appropriate

User defined functions using SQL Server 2005/2008 R2 with T-SQL, SSIS & SSAS skills.

?Expertise in generating reports using SQL Server Reporting Services 2005/2008 R2, Crystal Reports, and MS

Excel spreadsheets.

?Designing and Deployment of Reports for the End-User requests using Crystal Report & SSRS.

?Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.

?Experience in creating scheduling Jobs, Alerts, and SQL Mail Agent

?Working knowledge of .Net Framework 3.5 (ASP.NET and C#), IIS 6.0, TFS, VSS.

?Strong analytical, problem solving and troubleshooting skills.

?Good programming knowledge in C#, VB.NET, VB 6.0, VB Script, T-SQL.

?Scheduled DTS Packages and Involved in data extraction and loading using DTS in MS SQL Server 2000 and

SSIS in MS SQL Server 2005,Import Export data, Bulk Insert and BCP.

?Expert in Data Extraction, Transforming and Loading (ETL) using For Each Loop in SQL Server Integration

Services (SSIS) with .NET.

?Skilled in Developing SSAS Cubes, Dimensions, Facts, data source views. Deploying and Processing SSAS

objects

?Able to work collaboratively, quickly understand system architecture and business needs while committed to

achieving corporate goals.

?Able to Create/Maintain documentation for database schemas, data flows, database object definitions.

?Supported team in resolving SQL Reporting services and Database related issues.

? HIPAA Certification & ITIL knowledge.

? Valid H-1B Visa till Sep-2016

Educational/ Professional Qualification:

1. Passed B.Sc. from Kumoun University, Naini Tal, India in 1997.

2. Passed M.C.A. from GIMT Institute of Management & Technology, Noida (affiliated by Dr. B.R. Ambedker University,

Agra approved by AICTE) in 2002 with 71%.

I. T. Skills

Languages : C#, VB.NET, VISUAL BASIC 6.0, VBA, T-SQL.

Web Application : ASP.NET, ASP.

Scripting Languages : VB Script, Java Script.

Operating System : Windows 2003/2007/XP/7 Advanced Server, NT & Windows 9x,.

Internet Technologies : HTML, XML, CSS, Ajax, JQuery, Silverlight.

Web Server : IIS V6.0/7.0.

SQL Server Tools : DTS, BIDS (SSIS, SSAS, SSRS), BIMS, Query Analyzer, Enterprise manager

-1-

Diwakar Singh Negi

Reporting Tools : SSRS 2005/2008 R2, Crystal Report 10, Business Intelligence Tools, BOXI.

Database : SQL Server 2000/2005/2008 R2, T-SQL, Oracle, MS-ACCESS, MYSQL.

Other Tools : TFS, VSS, Remedy.

Awareness : ADO, ADO.NET and Software Engineer

Awards, Achievements, Publications and Professional Affiliations

? ?ON THE SPOT AWARD? in DELL for the year 2013.

? Awarded ?LONG SERVICE AWARD? for excellent contribution in DELL success in the year 2010.

? ?ASSOCIATE EXCELLENT AWARD? in DELL for the year 2009.

? ?ON THE SPOT AWARD? in DELL for the year 2008.

? ?PAT ON THE BACK? award in DELL for the year 2007.

? Published multiple articles on QA DELL CoE knowledge management portal.

Professional Experience Summary:

Job Duration: Oct-2005 ? Till Date, DELL, Wellesley, USA

Projects:

1. Project name: ?HPHC Reporting?

Duration: June-12 ? Till Date.

Client: Harvard Pilgrim HealthCare, Wellesley, U.S.A.

Environment: SQL SERVER 2005/2008 R2, SSRS, SSIS, SSAS, ASP.NET 3.5, C#, TFS, MS

visual Studio, BIDS, TFS, T-SQL, .NET Framework 3.5, Ajax, Java Script.

Team Size: 6

Role: Sr. SSRS/SQL Developer

RESPONSIBILITIES:

? Gathered, organized, validated, and manipulated data to answer business questions as needed by management.

? Designed and programmed custom reports throughout the organization. Maintained current reports created in

SQL Reporting Services. Created Ad-hoc reports as needed and carry out report projects as required.

? Meet with Executive and Department leadership to discuss reporting needs and provide support as needed.

? Generated periodic reports based on the statistical analysis of the data from various time frame and division

using SQL Server Reporting Services (SSRS) 2008 R2.

? Developed various operational Drill-through and Drill-down reports using SSRS

? Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

? Used cascaded parameters to generate a report from two different Data Sets

? SQL Server 2008 R2 RDBMS database development using T-SQL programming, queries, stored procedures,

UDF, views.

? Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data

marts

? Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server

databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.

? Involved in Installation, Configuration and Deployment of Reports using SSRS.

? Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS.

? Developed Reports for business end users using Report Builder with updating Statistics.

? Performed Debugging on the stored procedures for the requirement to handle the errors.

? Involved with Query Optimization to increase the performance of the Report.

? Performance analysis/ improvement.

DESCRIPTION:

A new customer delivery system is to be developed which will be a web based portal which would allow customers to

request for a new virtual machine and configure the defined aspects of virtual machines as per their requirements. For

-2-

Diwakar Singh Negi

instance, a customer would have multiple options in the portal that would allow them to choose a virtual machine with

specified memory, CPU, space etc. Also there is a module Project Services which caters to orders which are of type

projects and can have approval workflow, Change requests, Issues, Work lists and Weekly Status Reports/ Dashboard

related to the same.

2. Project name: ?CSS REPORTING?

Duration: Jan?12 ? June?12.

Client: BCBSRI, Rhode Island, USA.

Environment: BO XI3.1, SAP Crystal Report XI/8.0, Crystal Enterprise 10, Infoview, SQL Server

2005, Sybase IQ 15.1, CVS, VB Script.

Team Size: 6

Role: Sr. Report Developer

RESPONSIBILITIES:

? Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team,

Development team, Capacity planning and upgrading of SQL Servers.

? Designed and programmed custom reports throughout the organization. Maintained current reports created in

Crystal Report XI.

? Meet with Executive and Department leadership to discuss reporting needs and provide support as needed.

? Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks.

? Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.

? Implemented new T-SQL features in SQL Server 2005 like Advanced Error handling, Common Table

Expression (CTE) and LINQ.

? Involved in all phases of migration from Crystal Enterprise 10 to XI R2.

? Involved in designing Universe and migrating existing adhoc ?Crystal Reports Explorer 11? to WebI.

? Involved in creating the SRS/BRS for ?Master Reports Suite? which included enhancements to existing adhoc

product.

? Stress tested the crystal enterprise servers to determine ideal configuration for the best performance.

? Responsible to support the issues with reports on the crystal enterprise environments ( Development, UAT, Test

and Production )

DESCRIPTION:

Blue Cross Blue Shield of Rhode Island is largest healthcare insurance company in the state of Rhode Island. It markets

administer, service, and underwrite health and dental insurance plans for individuals, employers, and governmental

agencies. The functions supported include data processing, claims processing, marketing, finance and accounting,

customer relations, provider and professional relations, and managed care.

BCBSRI ? AM/AD is a healthcare Insurance project, which based upon the HIPAA standard. The project is to provide

support to ensure the smooth functioning of the existing applications and maintenance of the applications including bug

fixing and catering to the needs of development / enhancement through the means of RSS. BCBSRI has outsourced this

work to PSHS and Perot Systems CAS is supporting PSHS through onsite-offshore model engagement in carrying out

the ADM and other services.

?Resource Management

3. Project name:

Duration: Feb?11 ? Dec?11.

Client: Dell-IS Team

Environment: SQL SERVER 2008 R2, SSRS 2005, SSIS, ASP.NET, Framework 3.5, C#,

Microsoft Office SharePoint Server (MOSS) 2010, VS 2010.

Team Size: 5

Role: Sr. Report Developer

RESPONSIBILITIES:

? Gathered, organized, validated, and manipulated data to answer business questions as needed by management.

-3-

Diwakar Singh Negi

? Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts.

? Designed and programmed custom reports throughout the organization. Maintained current reports created in

SQL Reporting Services.

? Also created, modified, maintained and optimized SQL server database.

? Design, develop and test stored procedures, T-SQL, Views and user-defined functions.

? Meet with Executive and Department leadership to discuss reporting needs and provide support as needed.

? Daily use of SQL 2005 with SQL Reporting Services. I created custom queries, views, models, and stored

procedures using T-SQL and I?m familiar with other variations of SQL. I integrated custom reports with the

ASP.NET Application.

? Encrypted sensitive data in Database using transparent data encryption (TDE).

DESCRIPTION:

Resource management is the systems where the details been shown for resources. Authorized person can look the

resource competency, project assigned resources etc. All information and activities related to the organization is placed

on the portal which is designed using the Microsoft Office SharePoint Server 2010, .NET. The application is having

three modules Skill Inventory, Resource Request Management, Work Force Management.

All modules have been developed under Resource Management. The architecture design is of 3-tier and used

SharePoint with ASP.NET, database SQL Server 2008 & reports SSRS. The SharePoint InfoPath, Web parts & Lists has

been used to create the application. The access permission of User, Groups and Securities for the separate sections in

application has been taken care using Microsoft Office SharePoint Server (MOSS) 2010.

4. Project name: ?HPHC Time & Labor Application ?

Duration: Jan?09 ? Jan?11.

Client: HARVARD PILGRIM HEALTH CARE (HPHC), Boston,

U.S.A.

Environnent: ASP.NET, C#, SQL SERVER 2005, SSRS.

Team Size: 3

Role: Sr. Report Developer

RESPONSIBILITIES:

S/W Estimation, Documentations, Application Design, Developed Custom Reports using SSRS/BIDS, Created

Dashboards in SSRS 2005, Analysis, Requirement Specification, Coding, Gathered requirements to identify and create

database objects such as tables, views, triggers and indexes..

DESCRIPTION:

It?s a web-based application which was built in .Net environment. The major functions performed by the application are

Timesheet Validation, Generating Invoice, Calculate FTE, Generating Offshore Accruals, Shift Allowance and other various

reports. The application uploads timesheet (.xls format) file, import data in SQL database and generating various reports using

SSRS which is integrated with ASP.NET.

5. Project name: ?QC/ITG Reporting?

Duration: June?08 ? Jan?11.

Client: Harvard Pilgrim HealthCare, Wellesley, U.S.A.

Environment: SQL SERVER 2005, SSRS, ASP.NET 2.0, IIS 6.0, C#, Java Script.

Team Size: 6

Role: Sr. SSRS Developer

RESPONSIBILITIES:

? Gathered, organized, validated, and manipulated data to answer business questions as needed by management.

? Designed and programmed custom reports throughout the organization. Maintained current reports created in

SQL Reporting Services. Created Ad-hoc reports as needed and carry out report projects as required.

? Meet with Executive and Department leadership to discuss reporting needs and provide support as needed.

-4-

Diwakar Singh Negi

? Generated periodic reports based on the statistical analysis of the data from various time frame and division

using SQL Server Reporting Services (SSRS).

? Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized

reports.

? SQL Server 2005 RDBMS database development using T-SQL programming, queries, stored procedures,

UDF, views.

? Involved in Installation, Configuration and Deployment of Reports using SSRS.

? Performed Debugging on the stored procedures for the requirement to handle the errors.

? Involved with Query Optimization to increase the performance of the Report.

? Performance analysis/ improvement.

Father's Name : Mr. C. S. Negi.

Gender : Male.

May 24th, 1978

Date of Birth :

Nationality : Indian.

Passport No : G6523359

Hobbies : Listening Music, Playing Cricket,

Net Surfing, Traveling, Tracking, Watching T.V.

Permanent Address : ?CHANDAN HOTEL

Gwaldam, Chamoli

Garwhal, Uttarakhand, India - 246441.

I hereby declare that all the above information is true and complete to the best of my knowledge.

-9-

Diwakar Singh Negi

(Diwakar Singh Negi)

- 10 -

Contact this candidate