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