Harpreet Singh

  

Senior SQL/BI Consultant, Zensar Technologies Pte. Ltd.

Location: Singapore


Certifications

Certified ScrumMaster

Groups I belong to

Scrum Singapore

Biography

SUMMARY         

 

Areas of Knowledge

 

Domain

Investment Bank, Private Equity, Alternative Investments, Production, Inventory/Purchasing

 

System Design & Development

Design, Development, Testing and Implementation

 

Microsoft Business Intelligence

SSIS ,SSRS,SSAS

 

RDBMS

MS SQL Server 2005/2008

 

Reporting

SSRS 2005/2008, Crystal Report 2008

 

Languages

VB.Net, C#, VB 6

 

Internet Technologies

ASP.NET, ASP 3.0, HTML, XML, XSL, Java Script

 

Tools

Visual Studio.Net, Visual Source Safe, ERWIN, Team Foundation Server 2008/2010

 

 

 

Over 9 years of IT experience in Software Analysis, Design and Development in Client/Server systems, Data warehousing and Business Intelligence applications for Banking, Manufacturing and Retail domains.

 

  • Upgrade/Migration of MS SQL Server 2000 to 2005, 2005 to 2008 using any suitable approach.
  • Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization and Denormalization, Stored Procedures, Constraints, Querying, Joins, Indexes, Data Import/Export, derived  tables,Triggers.
  • Adept at using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), writing Transact SQL (T-SQL) Queries and Dynamic-queries.
  • Expert in optimizing the query by creating various clustered, non-clustered indexes and indexed views.
  •  Proficient in writing distributed queries between SQL Servers by creating link servers.
  • Hands on experience in using tools like Index Tuning Wizard and SQL Profiler.
  •  Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Experienced in writing Parameterized Queries for generating Tabular reports, Ad-hoc Reports, Drill-Down, Drill-Through, Cascaded, Pivot, Matrix and Sub reports using Global variables, Expressions, and Functions using SSRS 2005/2008.
  • Worked in various Crystal Environments extracting data from multiple sources, applying several functionalities and used different Data providers like OLEDB, ODBC, etc. Created compelling reports with stunning visualizations using Crystal 2008.
  • Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
  • Hands on experience in .Net 3.5 using Visual Studio 2008, WCF, jQuery.
  • Hands on experience in ASP, XML & XSLT
  • An excellent team member with ability to perform individually as well as in team and have strong communication and interpersonal skills.

 

Currently working with ZenSar Technologies Pte Ltd., Singapore as Senior SQL/BI Consultant. Involved in all phases of Software Development Life Cycle (SDLC) like System analysis, design, development, testing, implementation, and maintenance. Good Experience SSIS,SSRS,SSAS  & Object-Oriented Design / Development and Strong Analytical skills in Database Application Design, Development.

 

CURRENT RESPONSIBITY 

 

My responsibilities and duties during the stay with Credit Suisse are as follows.

 

  • Involved in Upgrade/Migration of MS SQL Server 2000 to 2005, 2005 to 2008
  • Database normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL 2005/2008
  • Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions (UDF’s) and other T-SQL (DDL, DML) statements for various applications.
  • Optimizing the query by creating various clustered, non-clustered indexes and indexed views.
  • Designed fully dynamic SSIS packages for migrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture (Table, chart and matrix report).
  • Sorting the data, defining data source and subtotals for the reports.
  • Involved in archiving old data, writing scripts to move data and update impacted processes.
  • Work with DBA to monitor slow running processes, backup and restore database issues.
  • Support in refreshing databases between two environments (Cold Load process).
  • Identify alternative Design and Documentation approaches and brainstorm with team to select best approach.
  • Enhancements in the existing Systems.
  • Testing of the existing application and newly developed applications.
  • Support to business.
  • Technical support to team members.
  • Understand existing code written in ASP, XML & XSLT and convert to .Net 3.5 using Visual Studio 2008,WCF,jQuery

 

PROFESSIONAL PROFILE

 

  • Currently working with ZenSar Technologies Pte Ltd, Singapore as a Senior Consultant since May 2006.
  • Prior to this worked with Birlasoft Ltd, Noida, India as a Senior Software Engineer from Oct 2004 to May 2006.
  • Prior to this worked with EGS Pvt Ltd, New Delhi, India as a Senior Software Engineer from May 2004 to Oct 2004.
  • Prior to this worked with Woodapple Interactive Pvt. Ltd, Gurgaon , India as a Software Engineer from April. 2002 to April. 2004.

 

EDUCATION

 

Masters in Computer Application (1999-2002) from H.N.B. Garhwal University, Srinagar with 69%.                        

 

CAREER PROFILE

 

Project                  

Awards

Client

Credit Suisse

Period                    

May 2006 – till date

Team Size

6 People in Singapore

Responsibilities

Supporting business: manage requested changes, analysis of requirement, time estimation, executing changes as per plan & coordinating with quality team.

Key focus is on –

  • Involved in Upgrade/Migration of MS SQL Server 2000 to 2005, 2005 to 2008
  • Database normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL 2005/2008
  • Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions (UDF’s) and other T-SQL (DDL, DML) statements for various applications.
  • Optimizing the query by creating various clustered, non-clustered indexes and indexed views.
  • Designed fully dynamic SSIS packages for migrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture (Table, chart and matrix report).
  • Sorting the data, defining data source and subtotals for the reports.
  • Used Expressions, Functions and wrote custom code using VB.Net for the dynamic sorting, dynamic visibility and dynamic columns using SSRS 2005.
  • Working in various Crystal Environments extracting data from multiple sources, applying several functionalities and used different Data providers like OLEDB, ODBC, etc. Created compelling reports with stunning visualizations using Crystal 2008.
  • Involved in archiving old data, writing scripts to move data and update impacted processes.
  • Work with DBA to monitor slow running processes, backup and restore database issues.
  • Support in refreshing databases between two environments (Cold Load process)
  • Understand existing code written in ASP, XML & XSLT and convert to .Net 3.5 using Visual Studio 2008, WCF, jQuery

 

The Project          

Awards System is a web-based employee plan management system.  Employee plan is used as the firm's people retention vehicle to allow employees to invest in Alternative Investment funds.  Alternative Investment funds on the average provide a much better ROI than the market or mutual funds but require the investor net worth to be of a much higher threshold.  Employee plan lowers the threshold for the firm's employees and provides investment loans matching employee's contribution.  It tracks employee plan participation, including investments and plans ownerships.  It processes shares and cost by allocation, distribution, and transfers.  It calculates cash and loan balance through new loans, equity contributions, interest calculations, and pay downs.

 

To live up to the expectation of a true strategic partner to employee plan business, IT needs to upgrade Awards to handle increasing data processing and reporting needs and ensure performance and functionalities.

Operating system

Windows 2003 Server

Languages

ASP.NET 3.5,C#, JQuery, XML/XSLT

ETL Tool

SSIS 2005/2008

Reporting Tool

SSRS 2005/2008, Crystal Report 2008

Database

SQL Server 2005/2008

IDE / Tools

Visual Studio.Net

Web Server

IIS 6.0

Work location

Credit Suisse , Singapore

 

Project                  

Awards Reference System

Client

Credit Suisse

Period                    

May 2006 – till date

Team Size

6 People in Singapore

Responsibilities

  • Involved in Upgrade/Migration of MS SQL Server 2000 to 2005, 2005 to 2008
  • Database normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL 2005/2008
  • Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions (UDF’s) and other T-SQL (DDL, DML) statements for various applications.
  • Optimizing the query by creating various clustered, non-clustered indexes and indexed views.
  • Designed fully dynamic SSIS packages for migrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture (Table, chart and matrix report).
  • Sorting the data, defining data source and subtotals for the reports.

 

The Project          

Web-based tool to manage data referred to by other Application

Operating system

Windows 2003 Server

Languages

ASP.NET 3.5,C#, JQuery, XML/XSLT

ETL Tool

SSIS 2005/2008

Reporting Tool

SSRS 2005/2008

Database

SQL Server 2005/2008

IDE / Tools

Visual Studio .NET 2005, Microsoft .Net Framework 2.0, Microsoft Visio, VSS,TFS 2008

Web Server

IIS 6.0

Work location

Credit Suisse , Singapore

 

Project                  

FOF Employee Plan Management

Client

Credit Suisse

Period                    

2006 – 2007

Team Size

4

Responsibilities

  • Active member of application development team.
  • Involved in development of business logic for user interfaces.
  • Was also partly responsible for Data Architecture and related processes. Have written stored procedures for certain packages.
  • Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions (UDF’s) and other T-SQL (DDL, DML) statements for various applications.
  • Optimizing the query by creating various clustered, non-clustered indexes and indexed views.
  • Was responsible for managing, developing and testing of all the modules
  • Maintenance of data structure
  • Review Procedures, functions, views & queries.

 

The Project          

The FOF Employee Plan Management System is used to manage the individual and fund level loan balances for the legacy DLJ employee fund of funds, by tracking investment purchases, proceeds, capital call payments, and other miscellaneous transactions.

Operating system

Windows 2003 Server

Languages

ASP.NET, C#, Java Script, HTML

Database

SQL Server 2000

IDE / Tools

Visual Studio .NET 2005, Microsoft .Net Framework 2.0, Microsoft Visio, VSS

Web Server

IIS 6.0

Work location

Credit Suisse , Singapore

 

Project                  

I-Many

Client

I-Many Inc. London, UK

Period                    

Aug’ 2005 – April’ 2006

Position 

Senior Software Engineer

Team Size

16

Responsibilities

  • Designed fully dynamic SSIS packages for migrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Migrated DTS packages to a SSIS packages
  • Active member of application development team.
  • Involved in development of business logic for user interfaces.
  • Created the stored procedures to extract data to be used in applications.
  • Unit tested the code.
  • Writing script for Migration from legacy database both oracle and SQL Server.

 

The Project          

I-Many is a product based company and they specialize in Mortgage products. The product can help to recover money from all the customers with individual breakdown.

Operating system

Windows 2003

Languages

ASP.NET, C#, Crystal Reports

ETL Tool

SSIS 2005

Database

SQL Server 2000/2005

IDE / Tools

Visual Studio .NET 2005, Microsoft .Net Framework 2.0

Web Server

IIS 6.0

Work location

Birla Soft Ltd. Noida

 

 

Project                  

Chartering Wing Automation

Client

Ministry of Shipping (MOS), Govt. of India

Period                    

March’ 2005 – Aug’2005

Position 

Senior Software Engineer

Team Size

6

Responsibilities

  • Active member of application development team.
  • Involved in Database design of the system.
  • Involved in development of business logic for user interfaces.
  • Created the stored procedures to be used in the application

The Project          

Project is being developed using C#, ASP.NET as the front end and SQL Server as database. The project is proposed to computerize various activities and operations of functioning units under the Chief Controller of Chartering wing to provide them online computerized environment. It also provides the various services offered by TRANSCHART in an efficient manner.

Operating system

Windows 2003

Languages

ASP.NET, C#, Crystal Reports

Database

SQL Server 2000

IDE / Tools

Visual Studio .NET 2003

Web Server

IIS 6.0

Work location

Birla Soft Ltd. Noida

 

       

Project                  

Project Simplicity

Client

HFS/USEF - GE Capital International Services

Period                    

Oct’2004-March’2005

Position 

Senior Software Engineer

Team Size

5

Responsibilities

  • Worked as the team member of cash module, involved in every activity of this module.
  • Performed unit testing
  • Participation in the verification and validation and Quality assurance

The Project          

This process provides funding to external vendors for healthcare equipments and other equipments that are leased out to customers. These processes have numerous sub processes that take care of cash accounting etc. This application consists of automating work- flows in the following two sub processes – Cash Application and Vulcan.

Operating system

Windows 2000

Languages

Visual Basic, Mainframe (Attachmate Extra Personal Client)

Database

SQL Server 2000

IDE / Tools

Visual Studio 6.0

Work location

Birla Soft Ltd. Noida

 

Project                  

Supplier Enablement Solution

Client

UCA Systems Inc., USA

Period                    

May’2004-Oct’2004

Position 

Senior Software Engineer

Team Size

5

Responsibilities

  • Active member of application development team.
  • Involved in Database design of the system.
  • Involved in development of business logic for user interfaces.
  • Created the stored procedures to be used in the application

The Project          

The Software automates the business process with Trading Partners. The e-business transaction is done by trading partners either thru sending e-data or by connecting to online shopping cart. In Phase I of the project, the e-data received in different formats are converted & made compatible with existing ERP Software of the company. The Phase-II will enable e-trading using online shopping carts.

Operating system

Windows 2000

Languages

XML, VB.NET

Database

SQL Server 2000

IDE / Tools

Visual Studio .Net 2003, BIZTALK Server

Work location

EGS Pvt Ltd, New Delhi

 

 

Harpreet Singh