SQL Server Developer & Data Engineer
Resume:
Hemant Chhibber
SQL Developer
**********@*****.***
Experienced SQL Server developer with over 20 years designing and implementing database projects. My professional expertise includes developing tables, stored procedures, functions, and optimizing queries. Work Authorization: US Citizen
Wells Fargo (NJ) : November2024 – June-2025
(Senior Data Engineer)
Wells Fargo (Apex, NJ): November 2022 – November 2024 SQL Developer
Working as SQL Developer – Supporting UI/API Team
Data Modeling
DDL/DML
Stored Procedures
Functions
Queries Optimization
Indexes
Denormalization of Data for reporting purposes.
Using Github for version control
Liquibase for SQL deployment
FieldPrint - Mondo Consulting (Addison Group) – NJ: March 2022 – Sep 2022 SQL Developer
Working as SQL developer – Supporting UI team: -
Working for UI team and modifying and creating stored procedures, tables, indexing
Performing query optimization
Creating Adhoc queries for generating data for business users.
Using Visual Studio with Git for Version Control
Using Change Control Tool
Using Jira
Hemant Chhibber – Page 2
Teladoc - APN Consulting – NJ: April 2020 – March -2022 SQL Developer
Working as SQL developer (Using MySql): -
Taking requirements from different teams and creating end to end SQL Processes
Working with reporting team and providing stored procedures and adhoc queries
Providing data using adhoc queries for MIS purposes.
Scheduling the process using Control M
Query optimization
Creating tables, indexes.
Using Jira
Documenting the processes.
Nestle & Associates – NJ : February 2020 – March 2020 SQL Developer
Best Value Auto Body Supply - Chicago : February 2017 – June 2017 Worked as Team Lead with Offshore team on Sales Management and Inventory Control Application. This is a Java/MySql based application.
Coordinating between business users and team members.
Understanding the business requirements
Assigning the tasks to the Team Members
Initiate sub-groups or sub-teams as appropriate to resolve issues and perform tasks in parallel.
Ensure deliverables are prepared to satisfy the project requirements, cost and schedule.
Help keep the team focused and on track.
Migration of data from the legacy system to the new platform. Bank of America (NJ) November 2015 – January 2016
November 2013 – April 2015
SQL Developer (Consultant)
Worked extensively on SQL server (TSql,Tables, Views, Functions, Stored Procedure, Triggers)
Complex queries, query optimization, dynamic SQL
Automated manual processes using SQL and SSRS.
Moving data with in different SQL environments using SSIS and import-export utilities.
Interacting extensively with Business Leads to understand the requirements.
Version control using VSS. Moving code from DEV QA UAT Prod. Deployment in QA, UAT .Production deployment done by the DBAs.
Part of Scrum meetings during different projects worked with the bank. KPMG (NJ)
Hemant Chhibber – Page 3
SR. Technical Associate (SQL Developer and Reporting) (Employee) July 2010 – October 2013 SR. Associate (SQL Developer and Reporting) (Consultant) March 2009 – July 2010 Environment
Access 2003/SQL 2008/VB .NET
(Used T-SQL/VBA/VB.net/SSIS)
Automated the process of sending daily reports in XLS format. This process was created using VB
.net.
Interacting with Business Analysts and Business Users to understand the requirements.
Primary responsibilities are to analyze and modify existing queries and create new queries based on changed database schema of NGGC Application. These queries are used for generating XLS reports for global KPMG users.
Created SSIS packages to transfer data from one SQL server to another for different member firms. This is created using SSIS, .net and outlook.
Analyzing existing reports and changing them based on new database schema. These crystal reports are based on SQL Server as well as Access Databases.
Worked on a tool in access using VBA which will import data from SQL using Pass thru queries and then use it for transferring the results in the XLS format using macros.
Worked on creating an automated tool using .Net/Crystal Reports/Outlook/Word. The tool when run will automatically send the reports to the specified users.
Out Sourcing Project: -
i. Responsible for transferring business and technological knowledge to outsourcing team of SQL Developers from TCS.
ii. Explaining the Database Schema and various reports for the current application that is being outsourced.
iii. Explaining the company’s processes for performing the day-to-day operations. Kewaunee Scientific Corporation (NC)
SQL Developer (Consultant) Sep 2008 – March 2009
This is maintenance Project. My primary responsibilities are to create stored procedure, crystal reports and link them with an ERP Package Syteline. This package is used for accounting, inventory and invoicing of Kewaunee Scientific.
Responsible for gathering the user requirements.
Responsible for creating new and modifying existing stored procedures. Based on the user’s requirements modify or create the stored procedure.
Responsible for creating and modifying reports using Crystal Reports. These reports can be for invoicing, inventory or financial in nature.
Responsible for linking the reports with the ERP package Syteline using VBA. In this case, new forms have to be designed and linked with the reports. KPMG (NJ) Feb 2008 – Sep 2008
SQL Developer (Consultant)
Hemant Chhibber – Page 4
Environment
Access 2003/SQL 2000/2005/VB .NET
(Used T-SQL/VBA/VB.net)
Primary responsibilities are to analyze and modify existing queries and create new queries based on changed database schema of SETINEL Application. These queries are then used for generating XLS reports for global KPMG users.
Analyzing existing reports and changing them based on new database schema. These crystal reports are based on SQL Server as well as Access Databases.
Work individually to convert an MS-Access reporting tool to VB .net reporting application. This application is using SQL Server 2000 as well as MS-Access 2003 databases.
Designed screens for different reports in VB.net 2005.
Used ADO.net for connecting the application to SQL Server Database and Access Database.
Used VB.net Components.
Used MS-Access as an object.
Written Complex SQL-Queries using T-SQL for retrieving data from the SQL database.
Worked on a tool in access using VBA which will import data from SQL using Pass thru queries and then use it for transferring the results in the XLS format using macros.
Responsible for modifying reports using Crystal Reports. GE Aviation (NJ)
SQL Developer (Consultant) July 2007 – Feb 2008
This is maintenance Project. My primary responsibilities are to create stored procedure, crystal reports and link them with an ERP Package Syteline. This package is used for accounting, inventory and invoicing of GE Aviations.
Responsible for gathering the user requirements.
Responsible for creating and modifying stored procedures. o Based on the user’s requirements modify or create the stored procedure.
Responsible for creating and modifying reports using Crystal Reports 10. These reports can be for invoicing, inventory or financial in nature.
Responsible for linking the reports with the ERP package Syteline using VBA. In this case new forms have to be designed and linked with the reports. Hemant Chhibber – Page 5
JPM Chase (NJ) May 2007 – July 2007
SQL Developer (Consultant)
Environment
Access 2003/SQL 2000
This is a short-term project to upscale the Access database to SQL Server 2000. The project
‘IMPlanning’ is used for mangers to keep track on the project, resources and costing required to run the projects.
1. Primary Responsibilities are to create the stored procedures in SQL from the MS-Access VBA code. 2. Responsible for creating views based on the queries written in MS-Access. 3. Responsible for creating User Defined functions in SQL Server. 4. Responsible for creating DTS Packages.
5. Responsible for creating Update/Insert/Delete Triggers. KPMG (NJ) Aug 2006 – May 2007
SQL Developer (Consultant)
Environment
Access 2003/SQL 2000/2005/VB .NET/Crystal Reports 11.0
(Used T-SQL/VBA/VB.net/Crystal Reports 11)
1. Primary responsibilities are to analyze and modify existing queries and create new queries based on changed database schema of SETINEL Application. These queries are used for generating XLS reports for global KPMG users.
2. Worked on Exporting Data into Access using DTS scripts or DTS Import/Export utility. 3. Actively involved in creating and testing queries in SQL and then using them in the pass thru queries to get the output in access. This output is then further used to create reports using Crystal reports 11.0.
4. Analyzing existing reports and changing them based on new database schema. These crystal reports are based on SQL Server as well as Access Databases. 5. Actively involved in writing code for comparing the SQL data with the XLS files using VBA. 6. Work individually to convert an MS-Access reporting tool to VB .net reporting application. This application is using SQL Server 2000 as well as MS-Access 2003 databases. i. Designed screens for different reports in VB.net 2005. ii. Used ADO.net for connecting the application to SQL Server Database and Access Database.
iii. Used VB.net Components.
iv. Used MS-Access as an object.
v. Written Complex SQL-Queries using T-SQL for retrieving data from the SQL database.
7. Worked on a tool in access using VBA which will import data from SQL using Pass thru queries and then use it for transferring the results in the XLS format using macros. Hemant Chhibber – Page 6
Cleary Gottlieb Steen & Hamilton LLP (NY) June 2006 -Aug 2006 Consultant
Environment
Visual Basic 6.0
As a team member, actively involved in modifying and creating new modules for the Data transfer utility. This will take the data from different sources such as MS-Access, MS-Excel and Text files and create a feed for the Elite Accounting System. This tool is being written in VB 6.0. Alliance Capital – New York
(Consultant) May 2006 – June 2006
This was a short-term assignment to transfer the knowledge and help the new developer to understand the application flow and database design.
Actively involved to modify and create new reports using crystal reports 9.0 and attach the reports with the front-end using VB 6.0.
Written complex stored procedures using SQL-Server 2000 for front end as well as for crystal reports.
Created Reports using crystal reports 9.0.
Actively involved in moving the Application changes from Development Environment to QA and finally to production.
Worked extensively for data migration from xls, text files to SQL server 2000 using DTS Import/Export utility.
Alliance Capital – New York Oct 2005 – March 2006
Programmer Analyst July 2000- Oct 2005
Environment
Visual Basic 6.0, SQL Server 2000, Crystal Reports 9.0
Solely Developed Report Engine for Admin Services in Alliance Capital. This application is developed using VB 6.0 as front end and SQL Server 2000 at the back end level. Reports were generated using Crystal 8.0/9.0.
This system generates reports for different departments using Crystal Reports 9.0 and at the backend using SQL Server 2000.
Initially written the stored procedures in SQL Server 6.5 for various reports and latter on migrated to SQL 2000.
Started as a team member but after the initial launch of the application, solely responsible for maintaining and enhancing the application. Involved in the generation of ITBRS (Information Technology Budgeting System). This application does the budgeting for the IT Managers. This is developed using Visual Basic 6.0 along with third party tools like True DBGrid, DBList controls. For report designing Crystal Reports 8.0/9.0 are being used and SQL 7.0/2000 at the back end level.
Designed different forms for ITBRS using different components such as True DBGrid, True DBList.
ADOs are used for database connectivity.
Developed Reports using Crystal Reports 8.0/9.0 with SQL server 7.0/SQL 2000.
Written Stored Procedures, views for inserting, deleting, updating features of the application. Done Database design changes.
Hemant Chhibber – Page 7
Actively involved in loading data into the SQL Server Database using DTS/Import export utilities. Data is being migrated from Access/XLS/Text to SQL Server 2000.
Written complex SQL queries using T-SQL for retrieving data from SQL Server.
As a Part of two members team actively involved in Maintenance of ACS (Artwork Catalog System). This application maintains the records of all the paintings and artwork in Alliance Capital. This application is developed using Visual Basic 6.0 as front end and SQL Server 7.0. Crystal Reports 8.0 is used to generate reports.
As a team members made the changes in the Front End based on users requirements.
Responsible for report writing with Crystal Reports 7.0, later upgraded to 9.0.
Created new Stored Procedures and modified existing stored procedures in SQL Server 2000.
As a part of two members team developed a Work Order Tool for facility center. This tool helps the facility center staff to know the rooms or space availability in the New York and New Jersey area of the company. This tool is developed in Visual Basic 6.0 and SQL Server 7.0 is used as the back end. Reports are developed using Crystal Reports 8.0/9.0.
Supporting third party application Facility Center 7.3. This application is using SQL 2000 at the back end. This application keeps track of all the floor plans, work orders and assets management. City of New York-New York Sept.1999 – June 2000
Programmer Analyst (Consultant)
Environment
Visual Basic 6.0, ADO, Access, Microsoft Outlook, Crystal Reports 7.0, Sheridan Controls As a part of a 2-person team, involved in design and Development of Bulletin Broadcasting System for City of New York-New York. This application was developed using VB 6.0 (Front End) and Access (Back End) and at the same time using Microsoft Outlook on Exchange Server.
This system generates predefined bulletins for City of New York employees and is broadcast to various departments using Outlook and Exchange.
Generated various screens for Data entry and Editing of an existing data
Generated Reports using Crystal Reports 7.0
Used third party software Sheridan – Data Widgets, Calendar Widgets
Designed the database in MS Access and writing the queries in MS Access. Hemant Chhibber – Page 8
Columbia Energy – Canonsburg - PA March 1999 – Sept. 1999 Programmer Analyst (Consultant)
Environment
Visual Basic 6.0, MS-SQL Server 6.5, Crystal Reports 7.0, MS-Access 7.0
As a part of a 3 person team, involved in design and development of Trigger Database Management System
This System is to Accept Orders from Different Sales Persons and compare on line NYMEX prices
Developed Data Entry Screens, Edit screens etc.
Maintaining the information table
Handling of various types of Invoices, Orders, User’s History, Orders Details Executed or existing
To generate email for the customers/Salespersons when there Credit is approved (Using Lotus Notes)
Developed the procedure for Importing data from the NYMEX
Generation of various Reports (using Crystal Reports 7.0)
Responsible for Data designing in MS Access.
Written Queries for retrieving and modification of data. Business Management Software, Atlanta, GA December 1998 – February 1999 Analyst/Programmer (Consultant)
Environment
Visual Basic V 5.0
Worked on maintenance of Financial Accounting Project on VB 5.0
Helped in changing the forms and reports.
Hemant Chhibber – Page 9
GSA - Unisys Corp - Chicago June 1997 – December 1998 Analyst/Programmer
Environment
Visual Basic 5.0/6.0, SQL Server 6.5, Windows 95/98/NT, Visual FoxPro, Pentium Servers
As a member of a four-person team, designed, developed and implemented a Financial Management System for the General Services Administration. This system reconciles payments and controls the payment approval process. This system was running in FoxPro and we have to rewrite the system in Visual Basic
Developed the system using Visual Basic 6.0 and SQL Server 6.5
Performed data modeling and designed the SQL Server database.
Responsible for writing stored procedures and views.
Maintained the Creditors Control Register
Designed and coded all data entry and update/delete screens and functions
The system was designed to process the payments associated with various types of Invoices, purchase orders, travel vouchers, check requests and transmittals
Developed an import function in order to import data from the current Online Financial Data System
Developed functionality to cater for allowances and projections
Using Crystal Reports, designed and developed various management reports
Contact this candidate