Developer Sql Server
Resume:
Harmanpreet Singh
Los Angeles, CA *****
ac57nk@r.postjobfree.com
Senior Developer
Authorized to work in the US for any employer
Work Experience
System Analyst/Developer
FCOE - Fresno, CA
August 2017 to Present
Activities:
• Working on production support.
• Work with end user for their issues/concern
• Doing the RCA for the user issues.
• Creating JIRA tickets and assigning it to development team
• Working as SQL/SSRS developer. Creating store procedures, SSRS reports
• Creating SSRS report for their existing inhouse production application.
• Migrating old SACS, Logi report to new SSRS reporting solution.
• 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/16, SSRS/SSIS. T-SQL, TFS, MS Project, Visio, JIRA, In House Support System SQL/SSRS developer
LAUSD - Los Angeles, CA
August 2016 to June 2017
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 SQL/SSRS developer
Microsoft - Redmond, WA
January 2016 to July 2016
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 Senior Technology Consultant IIIB
Hewlett Packard
February 2013 to November 2015
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 Senior Technology Consultant IIIB
Hewlett Packard - Vancouver, WA
June 2012 to February 2013
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
Senior Technology Consultant
Hewlett Packard - Chennai, Tamil Nadu
June 2010 to September 2010
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. Programmer Analyst III
Seasia Consulting - Chandigarh, Chandigarh
March 2006 to June 2010
India
Stellar Data Solutions: Chandigarh, India
Shah Infosys: Chandigarh, India
Education
M.Sc
Punjab Technical University
2003 to 2006
BCA
Punjab Technical University
2000 to 2003
Additional Information
SQL Server Development
SSRS Reports
Power BI (Working Knowledge)
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/16
Power BI
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 /16 Reporting Services, File Scripting, HTML and Text Reports.
JSON, TFS, MS Visio
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/16. 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
Contact this candidate