Resume

Sign in

Sql Server Developer

Location:
Fresno, California, United States
Posted:
February 22, 2018

Contact this candidate

Resume:

Professional Profile

Senior Developer

Strengths

SQL Server Development

Data Conversion, ETL

Strong technical, analytical and Effective problem solving skills

Team leading skills

Flexibility, inclination towards learning

Positive attitude and good team player

Skills

SQL Server 2012/2014

SSRS, SSAS, SSIS.

Microsoft Technologies

ASP.NET, VB.Net, ADO.Net, VB 6.0

Visual Studio 2010/2013

ASP, HTML/DHTML, java script, CSS, Crystal Report, Data report, SQL Server 2012/14 Reporting Services, File Scripting, HTML and Text Reports.

JSON, TFS, MS Visio

Spoken Languages

English (Proficient)

Punjabi (Native)

10+ years of IT experience in Microsoft technologies. Has been involved in design, development and implementation of desktop, legacy migration based projects using Microsoft technologies. Has worked extensively on technologies like. ASP.Net, C#, VB.Net using the IDE Visual Studio 2010. SQL Server 2008/12/14. Has got good technical skills in SQL Server used for application development.

Has also worked on Microsoft web technologies like ASP, java script, VB script, HTML, DHTML, CSS, JSON and VB 6.0 for component development.

The highlights of my profile are given below

Experience in different team projects with good project implementation experience, team skills, troubleshooting, presentation abilities and issue resolution capabilities

Good Business and System analysis skills to understand the requirements and customize client applications

Expertise in desktop based application development using Microsoft technologies

Education:

M.Sc (I.T) from Punjab Technical University with aggregate of 79% (Session: 2003 -2006)

BCA from Punjab Technical University with aggregate of 61% (Session: 2000 -2003)

Harmanpreet Singh

Work Experience (Continued)

Aug 2016 – June2017

Organization: LAUSD (Los Angeles Unified School District)

Project: MiSiS

Location: Los Angeles, CA

Activities:

Working as SQL/SSRS developer. Creating store procedures, SSRS reports

Production support on existing reports/modules.

Creating design and requirement document for implementing the new changes in the existing system.

Working on Defects, fixing bugs on the ongoing production support and new development.

Skills:

SQL Server 2008/12/14, SSRS/SSIS. T-SQL, TFS, MS Project, Visio

Jan 2016 – Jul 2016

Organization: Microsoft

Project: D & E Reporting & Analytics

Location: Redmond, Washington (Remote)

Activities:

Working as SQL/SSRS developer. Creating store procedures, SSRS.

Worked on fixing bugs in the existing SSIS packages for the ETL transformation.

Creating design and requirement document for implementing the new changes in the existing system.

Working on Defects, fixing bugs on the ongoing production support and new development.

Skills:

SQL Server 2008/12/14, SSRS/SSIS. T-SQL, TFS, MS Project, Visio

Feb 2013 – Nov 2015

Organization: Hewlett Packard

Project: ISEG (Initial Severity & Escalations Generator)

Role: Senior Technology Consultant IIIB

Location: Remote

Activities:

Working as SQL/SSRS developer.

Maintaining database server for Replication / SSRS reports deployment.

SSAS Experience in different Database Environment

Creating SSRS Reports as per user specification

Doing changes in the existing c# application code for new requirement.

Adding new features such as sending bulk emails and other as requested.

Skills:

SQL Server 2008/2014, T-SQL, SSRS, SSAS, C#, ASP.Net, HTML, CSS, TFS, MS Visio

June 2012 – Feb 2013

Organization: Hewlett Packard

Project: NGTS (Next generation Taxation System)

Location: Vancouver, Washington

Role: Senior Technology Consultant IIIB

Activities:

Working on NGTS project for the Taxation & Accounting database and reporting module.

Working as SQL/SSRS developer. Creating store procedures, SSRS.

Worked on fixing bugs in the existing SSIS packages for the ETL transformation.

Skills:

SQL Server 2008, SSRS/SSIS. T-SQL, TFS, MS Project, Visio

May 2011 – June 2012

June 2010 – Sept 2010

Organization: Hewlett Packard

Project: Maryland Pension Administration System

Location: Chennai, India & Baltimore, MD

Role: Senior Technology Consultant

Activities:

Working on Pension System Reform and Enhancement changes.

Working at client side for the Reform/Enhancement implementation and user acceptance.

Working in the .NET for the new requirement implementation.

Working in SQL development. Creating store procedures, Implementing DB schema changes.

Worked on SQL BI. Creating SSIS packages.

Documentation of all the processes involved in maintaining the database for future reference.

Work on creating the Data models using Erwin Data Modeler.

Data migration/conversion activities.

Provide direction on database aspects to the team of existing SQL developers and the end user application development team (that is using .Net technology) that includes directing the team carrying out Reporting development using SSRS.

Active participation with the onsite Client to resolve the requirement related queries

Creating design and requirement document for implementing the new changes in the existing system.

Working on Defects, fixing bugs on the ongoing production support and new development.

Skills:

SQL Server 2005, T-SQL, VB.NET, BizTalk, ILOG, SSRS/SSIS.

March 2006 – June 2010

Worked for

Seasia Consulting: Chandigarh, India

Stellar Data Solutions: Chandigarh, India

Shah Infosys: Chandigarh, India



Contact this candidate