Sql Server Developer

Diwakar Singh Negi

Diwakar Singh Negi

Waltham, MA, USA - 02453

Email: *******.****@*****.***

: *********@**********.***

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.

•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.

•Involved in UAT and Integration testing with QA team.

• 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

Reporting Tools : SSRS 2005/2008 R2, Crystal Report 10, 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

-1-

Diwakar Singh Negi

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 2008 R2, SSRS 2008 R2, SSIS, SSAS, ASP.NET 3.5, IIS6.0, C#,

VS 2010, TFS, Infragistics, .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.

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

reports.

• SQL Server 2008 R2 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.

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

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

-2-

Diwakar Singh Negi

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.

• 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).

-3-

Diwakar Singh Negi

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.

• 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.

-4-

Diwakar Singh Negi

Projects:

6. Project name: “First Care“

Duration: Nov-07 – May-08.

Client: First Care (Healthcare – Payer

), Texas,

U.S.A.

Software: C#, ASP.NET2.0, SQL Server2005, SSRS.

Team Size: 6

Role: Sr. Developer

RESPONSIBILITIES:

S/W Estimation, Documentations, Application Design, Creating Sql Server Reports, Analysis, Coding, Database

Design, Create Stored Procedure, Cursor, triggers, Optimization and indexing.

I am responsible for above activities and accomplished the same for following modules:

• Refund Log: It provides a standardized process for requesting refunds, mechanism to generate refund letters,

mechanism to monitor and track outstanding refund requests from providers/members, mechanism to identify

claims that are due to be recouped, standardized process for tracking recovered monies of the refunds requested,

notification to regions of refunds requested.

DESCRIPTION:

FirstCare is a State of Texas for-profit company, organized for the purpose of operating an IPA (Independent

Practionary Association) -model health maintenance organization. First Care provides prepaid medical, hospital, and related

comprehensive health insurance services to its subscribers and their enrolled dependents. They have close to about 200,000

members and 1000 providers associated in their network providing service across all the states in United States. First Care also

owns southwest Life & health insurance Company which offers the First Care PPO (Preferred Provider Organization) and life

insurance products.

Refund log tool

The scope of the project is to develop a new application which will provider mechanism to provide a standardized process for

requesting refunds, generate refund letters, enter and track checks and monies received, monitor and track outstanding refund

requests from providers /members, generate recovery reports etc.

Web Portal

FirstCare has 4 business portals one each for Members, Providers, Employers, and Agents. There are list of enhancements that

are proposed for these portals. These have been prioritized, and currently we have scoped and estimated for 4 such

enhancements.

AMISYS:

FirstCare uses AMISYS for claims adjudication. 2 work packets which have been worked on are:

- Magellan Extract.

• Provider Load

• Authorization Load

HEDIS Reporting.

-

• Develop 7 medical claims reports with feed from AMISYS system

• Develop pharmacy claims report with feed from DWS.

.

Projects:

7. Project name: “United HealthCare Services (UHS)-LOH “

Duration: May- 2006 – Oct-2007.

Client: United HealthCare & Neighborhood Health Partnership (NHP), U.S.A.

-5-

Diwakar Singh Negi

Software: VB 6.0, C#, ASP.NET, SSRS, ASP, Crystal Report 10.0, Sql Server2000.

Team Size: 5

Role: Sr. Developer

RESPONSIBILITIES:

Develop Low-Level design, Creating Reports, Application Maintenance, Analysis of Enhancement Requests, Coding of

Enhancement Requests, Analysis of defects, Defect fixing, Create Stored Procedure, Cursor, triggers, Optimization and

indexing.

I am responsible for above activities and accomplished the same for following modules:

• Member Module: It provides the member with an on-line provider

lookup, on-line Enroll for Health Plan Benefits, self-serve option for members to update

demographic information, change PCPs and review eligibility status, add or terminate a dependent, request a new ID

card for the subscriber and/or dependents, list of claims that have been submitted for a given subscriber and dependents,

change a Primary Care Physician (PCP) for the subscriber and/or dependents, view member eligibility, and benefits,

including but not limited to, co-pays and date of eligibility.

• Provider Module: It provides member eligibility information, such as

benefit-specific co-pays and date of eligibility, Submit Authorization, search criteria

for an authorization resulting in the display of detailed information, such as

authorization number, referring provider, referred to provider, start and end date,

Provides list of provider-specific claims that have been submitted for a given

subscriber and dependent(s), user ability to change his/her password for web account

access and user ability to search for providers by network. Search criteria includes,

Network, Provider Type, PCP, Provider Name, Zip/Postal Code, Language spoken,

Hospital Affiliation, and Specialty..

• Broker Module: It provides Brokers, Administrative Representatives,

and Underwriters with the ability to generate quotes and view quote

details on-line, Administrator with the ability to manage Rules and

Rates, ability to access Quote Cases with update capability, add

Broker account, Broker Search, Add/Update/ Delete/Search Quote

and provide quotes for small groups.

DESCRIPTION:

Neighborhood Health Partnership is a for profit health maintenance organization (HMO) serving the tri-county

area of South Florida including: Miami-Dade, Broward and Palm Beach Counties. They are committed to putting

members first by providing quality health care and exceptional customer service.

Digital Health Plan (DHP) is Perot Systems’ web-based application for health care payer organizations. The DHP

application provided subscribers, employers and providers a web based interface for entering and viewing information

like demographic information, claims, referral status etc.

The DHP project involved creation of a new module for online generation and management of quotes/premiums, based

on the case information entered by brokers, sales representatives and underwriters. This included:

• Construction of screens related to brokers, representatives, underwriters and quotes in the DHP

application

• Construction of screens for addition and updation of master tables

• Construction of New Auditing module

-6-

Diwakar Singh Negi

Projects:

8. Project name: “ISO Management (KWI) “

Duration: Oct - 2005 – May - 2006

Client: Global Energy Services, Inc., California, USA.

Environment: C#, XML, ADO.NET, XML, Infragistics v5.3, Sql Server2000

Team Size: 6

Role: Developer

RESPONSIBILITIES:

Gain understanding of requirements by analyzing the business requirements specification documents.

Develop Low-Level design.

Develop Code (scheduling and balancing the demand for electricity was implemented through .NET applications).

I am responsible for above activities and accomplished the same for following modules:

• Creating & Deleting Bids: It provides creating & deleting Bits for

Generating Units called Assets.

• Sending & Receiving Bids: It provides Bids from the suppliers and

sends it to the ISO Markets.

• Graphical Representations of Bids: It provides Graphical

representation of bids to get a snapshot of electricity prices over a period

of time.

DESCRIPTION:

The Independent System Operator (ISO) is a central authority tasked with scheduling and balancing the

demand for electricity with the utilities willingness to supply electricity. The ISO accomplishes its task by managing

multiple auction processes (or markets). For each market it receiving offers (bids) from suppliers to supply electricity

and matches them with bids to buy electricity from load serving entities. Having reviewed and accepted the bids, the

ISO typically provides a set of forecast Schedules to the Participants that details he expected production from each

electricity supplier and the expected demand for consumption. The ISO sends instructions in real-time just before the

moment of need so the electricity suppliers know whether to increase or decrease their production to meet the actual

need for electricity.

The project was to provide following functions in the tool:

• Create, save and delete Bids for Generating Units called Assets

• Submit Bids to ISO Markets

• Validate Bids as per the existing market rules using a Rule Engine

• Provide graphical reports & charts can be generated to get a snapshot of electricity prices over a

period of time

• Historical analysis

Job Duration: Feb 2005 Oct 05, Differential Technologies Ltd. (ISO 9001:2000), New Delhi, India

Projects:

9. Project name: “VeriCORP “ Web Application for Employee Verification

Duration: Feb - 2005 – Oct-05

Client: VeriCORP Inc., Louisville, Kentucky, USA.

Environment: ASP.NET, C#, VB.NET, ADO.NET, Sql Server2000, IIS.

Team Size: 5

Role: S/W Developer.

RESPONSIBILITIES:

-7-

Diwakar Singh Negi

• Requirements Analysis, Seek clarifications from the client on requirements.

• Implementation and Maintenance of application.

• Created Database Tables, Queries, Cursor, triggers, Stored Procedure and maintaining Database

DESCRIPTION:

VeriCORP is a web application for Employment screening, verification of employee credentials against

companies. It has three modules In-house, Agent, Client.

• In-House: It is administrator part, responsible for login creation against companies, a new administrator or a

new agent. It is also responsible for assignment of employee verification against any company to an agent and

for watching the agent works. Administrator can edit some part of agent also.

• Agent: Agent is responsible for doing verifications of employees allotted to him. After completion of

verification he has to make complete report against that verification in his area.

• Client: Client area means basically the Company who will give the verification request against his employees.

A client will create request for verification request against his employees. They can see the reports against that

verification in his area, can cancel the verification if it is not right, and can remove request.

Job Duration: Mar 2004– Feb 2005, Data Nova India Pvt. Limited (A Norwegian Collaboration) Noida, India

Projects:

10. Project name: “E-handle “For Data Nova India Pvt. Ltd.

Duration: May - 2004 – Feb - 2005

Client: Sportshuset, Prefust in Oslo, Norway.

Environment: ASP.NET, C#, VB.NET, SQL server 2000, Java Script, ADO.NET

Team Size: 6

Role: S/W Developer

RESPONSIBILITIES:

• Developing ASP.NET pages for their internal processing.

• Created Database Tables, Queries, Cursor, triggers & Maintenance databases of Different Clients.

DESCRIPTION:

The E-handle is web site, which is used for online-shopping; through it people can select and purchase the

goods by cash or credit card.

Projects:

11. Project name: “Sports-Drilldown Web Reports“

For Data Nova India Pvt. Ltd.

Duration: Mar - 2004 – April -2004

Client: Sportshuset, Prefust in Oslo, Norway.

Software: ASP.NET, C#, VB.NET, Sql Server 2000, Java Script, VB Script.

Team Size: 2

Role: Developer

RESPONSIBILITIES:

• Developing ASP.Net pages for their internal processing.

DESCRIPTION:

-8-

Diwakar Singh Negi

The Sports-Drilldown is online reports, which display all the reports, which are related to company, Co’s profile,

Region, shop, Department, itemgropus and items. It is a part of E-handle Web-site that is used by Admin.

Job Duration: July 2002– Mar 2004, Pioneer eServe Private Limited, Nehru Place, New Delhi, India.

The company is involved in maintaining and auditing of PF (Provident Fund) and payroll processing of their clients.

Since they deal with variety of clients it is very difficult to fetch the data of the respective client when they go for

auditing at the client site. The software division is completely committed to provide all the software services required

by the Payroll and PF wing. Also develop and market a sophisticated system for schools.

Projects:

12. Project name: “SOCIALSECURITYINDIA.COM (PFM system) “

For Pioneer eServe Private Limited

Duration: June -2002 to Mar -2004

Client: Pioneer Securities Ltd.

Software: SQL server 2000, ASP, Microsoft Visual Basic 6.0,

Java Script, FrontPage, VB Script

Web Server: IIS V5.1

Team Size: 10

Role: S/W Developer

RESPONSIBILITIES:

• Developing ASP pages and Visual Basic Form for their internal processing.

• Created Database tables, Queries, Cursor and triggers.

DESCRIPTION:

It is basically a portal that contains all the processing of various type of provident fund trust. Our client is maintaining

the provident fund trust for their different client like BALCO, APOLLO, MTNL, Bechtel, Indorama, Punjlloyd group,

etc. Their basic aim to make all the processing related to Provident fund trust like processing of Loan application,

Settlement application and Transfer of their account online.

This Project consists of following three modules:

• First Module covers migration their existing FoxPro database into SQL Server2000

• Second module covers to develop a portal

• Third module covers Financial Accounting of their trust

Personal Details:

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.

(Diwakar Singh Negi)

-9-

Diwakar Singh Negi

- 10 -

Contact this candidate