Sql Server Project

CHIRAG SHAH

** ***** ******, ****** ****, NJ ****6 551-***-**** *******@*******.***

Career Overview

Highly skilled IT Professional with over 9 years of experience in SQL Server and other database technologies. IT industry experience of over 13 years having played the role from trainee to managing teams and successfully delivering projects.

Professional highlights

Highly experience in database design and development in SQL Server 2008, 2005 and 2000.

Writing complex stored procedures and queries handling huge volumes of data.

Over 3 years of experience in DBA activities in SQL 2005 and 2000.

Performance tuning of queries and data load batch.

Experience in ETL using SSIS.

Implementing ERP at client sites.

Involved from requirements gathering to final delivery.

Managing teams across multiple locations

Low level project management

Good communication and client interfacing skills

MS Certification – MCTS – SQL Server 2008 Development

Domain – Capital markets & Investment banking

Constant Learning

Technology Experience

Databases – SQL Server 2008, SQL Server 2005, SQL Server 2000, SQLite, SQL CE, MS Access, Oracle 8i

ETL – SSIS, DTS

Data modeling – Visio, Database diagrams

Project Management – Open Work Bench, MS Project, Excel

Source control – IBM Synergy, git/stash

Technical Competencies

Writing Stored procedures, functions, triggers, ad-hoc sql

Perform calculations, aggregations, rankings in sql

Use correct isolation level, transactions, error handling in stored procedures

Writing data load stored procedures that load and process millions of rows of data

Query optimization using query plans, sql profiler, DMV’s

Use geo-spatial data for computing distance between 2 points

Data modeling - logical and physical design using Visio and Database diagrams

Table and Index design – Clustered and Non-Clustered indexes

Table Partitioning based on time line

Implement Slowly Changing Dimension in the database

Production deployment – creating and scheduling tickets and creating sql scripts

Dependency checking while scheduling tickets

Change management – maintain inventory of changes for each release

ETL using SSIS. Data sources are flat files, teradata, sql server

Use transformations like lookup, aggregate, conditional split, merge and pivot in SSIS

Restart SSIS package from point of failure

Dynamic SSIS packages where in the SSIS steps are read from a table

Parallel running of SSIS packages

ETL using DTS in SQL 2000

FACT, DIMENSION tables in DataWarehouse project

Scheduling Database backups – Full backups, Log Backups

Restore chain of backups

Creating database snapshots

Knowledge of Oracle 9i

Knowledge of Qlikview reports

SRS review and creating Tech Design documents

Project Management - Effort estimation and Resource allocation and people management

ERP implementation at client sites

Functional lead for finance and payroll modules

Professional Experience

Capgemini Financial Services Jul/2010 – till date

Project Summary: - Working on a project for Capgemini’s client Morgan Stanley bank for 5 years as a SME. Project involves around maintaining and enhancing reporting dashboards that show financial information like revenue, assets etc related to financial advisors. Financial Advisors use this application to view client wise, product wise revenue, assets, growth and other financial metrics. Application also shows the different teams the financial advisor belongs to and the overall ranking of the advisor within the organization.

Second project I work on shows the various financial metrics like revenue, assets etc for each office within the Morgan Stanley sales organization.

Huge volume of data is processed and shown on the dashboards and the business logic resides in the database. The data load batch uses SSIS to bring in the data from various sources and also to run the batch.

Writing complex stored procedures and queries that process huge volumes of data and do lot of calculations and aggregations.

Design and model database tables and data load batch.

Suggestions to the client to resolve technical and business issues.

Performance tuning of stored procedures and the data load batch.

Involve right from requirements gathering to final delivery.

Co-ordinate with the business analysts, business users and other stake holders.

Prepare Tech design documents.

Participate in code review.

Production support for the daily data load batch.

Project management – effort estimation, resource allocation.

Team management.

Offshore – onshore co-ordination and client interfacing.

Ticket creation for code deployment.

Environment:- SQL Server 2008, SQL Server 2005, SSIS, .NET, Visio, git/stash, sharepoint

UST Global Jan/2010 – Jun/2010

Project Summary: - Bring in data from mainframe systems to SQL Server as part of data migration project for client Medicaid.

•Build ETL packages in DTS to bring data from mainframe to SQL.

•Write stored procedures to be executed after the ETL.

•Database table design.

•Team lead activities.

Microobjects Nov/2004 – Jan/2010

Project Summary: - Worked on various web and mobiles projects as database developer and DBA. Couple of the projects I would like to mention are Dexsar, Gloflogix. Dexsar leases out digital storage space to users and Golflogix is used for maintain details of a game of golf. We used geo spatial data to compute the nearest golf course from a given geographical location.

•Writing stored procedures and queries in SQL Server, SQLite and SQLCE. SQLite and SQLCE were used for mobile projects.

•Used geo spatial data in SQL 2008 for distance computation

•DBA activities include backup strategies, database maintenance, database change management and User privileges.

•Performance tuning of stored procedures.

•Database design and modeling of database tables.

•Evaluate new features of SQL Server for solving business problems. Ex: geo spatial data

•Code review

Xylon Technologies Dec/2001 – Nov-2004

Project Summary:- Worked on an ERP developed by xylon technologies. ERP included payroll, Inventory and accounts modules. I lead the HR and Finance modules and also implemented the ERP at client sites.

•Writing stored procedures and queries in SQL 2000.

•Database change management and deployment at client sites

•Lead HR and Finance modules of the ERP and help customization of these modules for clients

•Provide tele-support and co-ordination between onsite associates in Kenya and offshore development team in India

Softsystems

Project Summary:- Softsystems had developed an agri-business ERP which was implemented at various client sites in Africa.

•Train the end users of the ERP at implementation site.

Educational Qualification

Bachelor of Commerce (Accounts) from Mahatma Gandhi University India

Contact this candidate