Sql Server Project

Mehul Shah

Email: ********@*****.***

Contact #: 551-***-****

Objective

To obtain a challenging position that utilizes my strong software development skills, good finance knowledge and also helps my career growth.

Professional Summary

Having 12 years of professional experience in developing, maintaining, enhancement and conversion of software applications using Microsoft .Net Technology Stack. Currently working as a Lead Consultant with Capgemini Financial Services USA Inc.

12 years of experience in Information Technology including 8 years in financial services with Morgan Stanley.

Expertise developing web & windows applications using Microsoft .Net technology stack.

Good knowledge and understanding on trade life cycle, Alternative Investments, Mutual Funds & Fixed-Income, products.

Wide range of exposure and 12 years’ work experience in software technologies including C#, ASP.NET, WinForms, WCF, JavaScript with .NET 1.1 to 4.0 Framework.

Sound knowledge and experience in Object Oriented Programming and Design and object modelling tools such as Microsoft Visio and Rational Rose.

Good understanding of XML and Web Service technologies.

Possess good knowledge of writing Data Access Components using ADO.NET.

Proficient in writing complex SQL queries, stored-procedures, Views, triggers and Database Design in SQL Server 2008 and Oracle.

Experience in creating and maintaining SSIS packages to Import/Export data from various entities like flat files, XML, Excel.

Good experience in distributed version control tools such as Visual SourceSafe, Perforce, Synergy, Git and expertise in third party components such as Infragistics, Syncfusion.

Proficient in implementation of best practices and various software Design Patterns.

Experience in Application design & development in 'Wealth Management', 'Capital Markets', ‘Insurance’, ‘Human Resource Management' domains.

Experience in all phases of SDLC using Waterfall and Agile Methodologies.

Good experience leading a team and working with cross-functional development teams and expert doing Project proposals, feasibility study and estimations.

Strong analytical and problem solving skills and ability to provide solutions for complex problems and challenges.

Dedicated Team player, Self-motivated professional with excellent Interpersonal, Collaboration & communication skills.

Proven record of working in an Onsite-Offshore Delivery Model and leading Technical Teams across locations.

Quick learner and adapt quickly to new situation/changes and work pro-actively towards meeting deadlines is my forte.

Trainings and Certifications

NCFM – Certification for Capital Markets and Mutual Funds

IMPACT – Process Management Training Program

Technical Skills

Programming/Scripting Languages & .Net Technologies

C#,VB.NET,ASP.NET, .NET framework 4.0/3.5/3.0/2.0, WCF, WinForms, SOAP/REST Web Services, Windows Services, Visual Basic 6.0,Java Script, Angular-JS, Web API,,HTML,CSS, XML, LINQ, XPath, XQuery,AJAX,N-Unit

Web Server

IIS

Database & Tools

MS SQL Server 2000/2005/2008,Oracle,Crystal Reports, MS Visio, Rational Rose, CLR profiler, SQL Profiler

Operating System

DOS, Windows 98/XP, Vista, Windows 7

IDE,

Version Control & Continuous Integration Tools

Microsoft Visual Studio 2010/2008/2005.

Visual Source Safe,Git,Stash,Synergy,Team City, Jira

ETL Tools

SSIS (SQL Server Integration Services)

Professional Experience

Working as a Project Lead at Morgan Stanley Wealth Management, NY from July 2015 to till date.

Worked as Lead Consultant in Capgemini India Pvt Ltd, India from May 2007 to June 2015.

Worked as member of Technical Staff in Persistent Systems, India from Nov 2006 to May 2007.

Worked as Senior Software Engineer in Accenture Services Pvt Ltd, India from Jan 2004 to Nov 2006.

Morgan Stanley Wealth Management, New York

Project Title

Enterprise Business Components

Tenure

July’15 to till date

Client

Morgan Stanley Wealth Management

Tools & Technologies used

.NET 4.0, C#, WCF,ASP.Net, LINQ,VS 2012, SQL Server 2008, SSIS,HTML, CSS,IIS

Project Description

EBC(Enterprise Business Components) team is responsible to build enterprise shared services which are used as single source data provider for all front end applications across the firm. This project uses SOA architecture and follows the ESB (Enterprise Service Bus) concepts.

One of the Primary project worked on includes, Socially Responsible Investing (SRI) also known as sustainable, socially conscious, "green" or ethical investing. It indicates any investment strategy which seeks to consider both financial return and social good.

Roles & Responsibilities

As Technical Lead responsible for end to end project delivery which includes

Requirement Gathering & Analysis, Technical Design, Implementation, Testing,

Product Deployment.

Developed WCF Service which analyses & rates client portfolio based on

ESG(Environmental, Social & Governance) Scores provided by MSCI.

Developed Services Testing Dashboard using ASP.Net, C#, Html & CSS. This tool is

used for regression testing for services within EBC stack.

Managing a team of 10 members including Onsite – Offshore.

Prepare technical design documents, perform code reviews, debugging and testing

Create and maintain shared services which are used as single source for providing

Common and sensitive data across the firm.

Triage Co-ordination involving Service Consumers and Data Providers.

Working in a collaborative development environment, providing assistance &

technical guidance to fellow team members.

Accountability for successful operation of the services within EBC stack.

Primarily responsible for designing, and implementing services adhering to Service

Oriented Architecture (SOA).

Responsible for building Shared Services using WCF, C# & SQL Server technology

stack.

Creating and maintaining SSIS packages used for extracting data from centralized

data sources across the firm.

Onshore-offshore team co-ordination.

Capgemini India Pvt Ltd

Project Title

Alternative Investments - Investment Administration

Tenure

July’12 to June’15

Client

Morgan Stanley Wealth Management

Tools & Technologies used

.Net 4.0, C#, ASP.Net, SQL Server, WCF,SSIS, JavaScript, Jquery,ASP.Net MVC, Angular-JS,Ext-JS Infragistics Web Controls, HTML, CSS

Project Description

AI -Investment Administration application serves as Order Processing Platform for Retail and Private Wealth Management with primary focus on Alternative Investments (i.e Non Traditional investments).

The objectives of this process are to:

Provide appropriately designed automated capability to handle business requirements;

Better satisfy the needs of clients and FAs/IRs; - Improve regulatory and operational control;

Increase economies of scale that will facilitate effective management of growth in distribution of AI products.

This is a workflow based web application developed using Asp.Net technology Stack. It provides Order Entry functions for the Alternative Investments Products allowing Subscription, Redemption, Exchanges, and Transfer type transaction. Orders created through this systems are sent to Mainframe for downstream transaction management.

Roles & Responsibilities

Developed end to end flow for Subscription and Transfer Transactions.

Gathering project requirements from Business team.

Designing cost effective solutions addressing Business requirements.

Performing Impact Analysis and providing effort and time estimation for application

development activities.

Primarily responsible for designing, and implementing AI Order Entry web

application using Asp.Net, C#, SQL Server technology Stack. Used Infragistics web

controls for accelerated development.

Lead team of 5 members including Onsite – Offshore. Worked onsite from May'11

to Mar'12.

Prepare technical design documents, perform code reviews, debugging and testing

Design framework components and reusable modules for .NET application.

Designed table schemas and created Stored Procedures, Views, Triggers and

Complex T-SQL queries in SQL Server 2008.

Creating and maintaining SSIS packages used for sourcing metadata required by

Order Entry System and transmitting order details to downstream systems.

Providing assistance & technical guidance to fellow team members.

Onshore-offshore team co-ordination.

Prepare weekly project status report depicting project progress.

Capgemini India Pvt Ltd

Project Title

Alternative Investments - Offering Administration

Tenure

March’10 to June’12

Client

Morgan Stanley Wealth Management

Tools & Technologies used

.Net 4.0, C#, ASP.Net, SQL Server, WCF,SSIS, JavaScript, Jquery,Infragistics Web Controls

Project Description

Alternative Investments Offering Administration (Reg-D) is a web application serving as Client suitability system for Alternatives and Managed Futures investments. This application automates the process of pre-qualifying an investor to receive materials for a specified private placement offering. As part of the process, the investor must satisfy specific eligibility and suitability requirements for the offering. This Process acts as pre-requisite before allowing any client investments in Alternative Investments portfolio.

Roles & Responsibilities

Primarily responsible for designing, and developing AI Offering Administration

web application using Asp.Net, C#,SQL Server technology Stack.

Lead team of 4 members including Onsite – Offshore.

Analyze Business Requirements and provide technical solution adhering to standard

processes and timeframe.

Perform code reviews and ensure that the developed code complies with best

practices and standards.

Preparing deployment plan with release management and design scripts to deploy

change.

Involved in relational database diagram design and Tables design in SQL Server.

Created Stored Procedures, Views, Triggers and Complex T-SQL queries in SQL

Server.

Creating and maintaining SSIS packages used for extracting required data elements.

Providing assistance & technical guidance to fellow team members.

Capgemini India Pvt Ltd

Project Title

RAPS(Reconciliation Analysis and Processing System)

Tenure

March’08 to Jan'10

Client

Morgan Stanley Wealth Management

Tools & Technologies used

C#.NET, ASP.NET 2.0, Infragistics Web Controls, Ajax Control Toolkit.

Project Description

RAPS application helps to reconcile various positions like Shares, Cash, Sub Accounting and Accrual. User can perform various actions like Split, Merge, Match, and Update on positions in order to reconcile the entries.

The Project involves rewriting of existing RAPS Application written in Power-Builder into an ASP.Net Web Application. In order to match the look and feel of existing application, most of the processing in new RAPS is done on client side. For this, Infragistics Web Control’s client side features along with Ajax Control toolkit and PageMethods were used extensively. The application back end consists of Cobol/DB2 stored procedures.

Roles & Responsibilities

Analyzing features provided by existing RAPS PowerBuilder application.

Gathering requirements for new features from Business Team.

Preparing requirements specification document collating all the requirements.

Responsible for end-to-end delivery of Cash and Shares reconciliation modules.

Developing Asynchronous Web Application using Ajax Control Toolkit and

PageMethods.

Involved in relational database design in SQL Server.

Created Stored Procedures, Views, Triggers and Complex T-SQL queries in SQL

Server.

Persistent Systems Pvt Ltd,India

Project Title

IIS 7.0 Reference

Tenure

Dec’06 to May'07

Client

Capgemini, Pune.

Tools & Technologies used

C#.NET, IIS 7.0,ASP.NET 2.0

Project Description

This project includes creation of White Papers and Tutorials to give overview of features provided by IIS 7.0. It includes implementing the features provided by IIS 7.0 on a sample web application. This application is used as reference point to explain the IIS 7.0 features in the tutorials.

Roles & Responsibilities

Develop a sample application using ASP.Net & C# which will be used as reference

for demonstrating features of IIS7.0.

Implemented features provided by IIS 7.0 like creation of HTTP Handlers &

Modules, Asp.Net 2.0 provider model with IIS 7.0, custom Errors etc. on the

sample application.

Writing and reviewing technical documents(Tutorials and White Papers) which

explains the features provided by IIS 7.0.

Accenture Services Pvt Ltd,India

Project Title

Insurance Claims Processing System

Tenure

Aug’05 to Nov’06

Client

The Hartford, USA

Tools & Technologies used

VB.NET, ASP.NET,ADO.NET, Oracle

Project Description

Claim processing system is N-Tier web application built to handle the claim processing of various Lines of Business.

There are various third party applications used by the Claims Processing System(Spark). BizTalk Server is used to Integrate all these third party applications with Claim Processing System. These third party applications provide data which is needed by the Claim Processing system. BizTalk Implementation picks up the data from various vendors, converts it in format required by the Claim Processing system and inserts the data in database used by Claim Processing system. Claim processing system picks up the data, processes it and updates the processed data in database. This updated data is picked up by BizTalk Implementation, converted to format required by various vendors and passes the data to appropriate vendors.

Roles & Responsibilities

As Senior Developer responsible for the development of Desktop module which is

core module in Claim processing application.

Technology stack used includes ASP.Net, VB.Net,Oracle.

Part of Integration Team which handles the Integration of claim processing system

with third party systems.

Handled responsibility of responding to client queries.

Part of Team handling critical Enhancements in the application. Involved in direct

communication with business for requirements gathering.

Prepare technical design documents, perform code reviews, debugging and testing.

Involved in relational database design.

Created Stored Procedures, Views, Triggers and Complex T-SQL queries in SQL

Server.

Accenture Services Pvt Ltd,India

Project Title

ABACUS-PCMM SYSTEM

Tenure

Dec’04 to July’05

Client

Accenture

Tools & Technologies used

VB.NET, ASP.NET, ADO.NET, SQL SERVER 2000

Project Description

Abacus-PCMM is a Web Application that is used for recording Assessments of employees (self and supervisor) across different People Capability categories like Technical, Process.

This application provides guidelines, measurement criteria’s to help employees for doing self assessments and supervisor assessments .It also provides information about the learning maps to be followed in order to achieve the further levels. This application is used for collecting information about the levels of resources for different skills in organization. This information is useful in achieving PCMM level for the organization.

Roles & Responsibilities

Played important role in all the phases of the application development. Involved in

Requirement Gathering and Designing of application.

Responsible for end to end delivery of Assessments module which records and

accesses self and supervisor scores. This is most critical module in the application.

Created Stored Procedures, Views, Triggers and Complex T-SQL queries in SQL

Server.

Deployments of the application in all the environments.

Handled responsibility of responding to client queries as part of helpdesk team.

Accenture Services Pvt Ltd,India

Project Title

ABACUS- RECRUITMENT SYSTEM

Tenure

Feb’04 to Dec’04

Client

Accenture

Tools & Technologies used

VB.NET, ASP.NET, ADO.NET, SQL SERVER 2000

Project Description

Abacus Recruitment System is a Web Application meant for the recruitment team and scheduling teams of organization to keep track demand and supply ratio.

Recruitment system keeps record of candidates applying in organization, Interviews Scheduled, results of interviews and Candidates joining the Organization. Application provides various useful reports on the basis of which Recruitment and scheduling teams can keep track of demand and supply ratio.

Roles & Responsibilities

Played important role in all the phases of the application development. Involved in

Requirement Gathering and Designing of application.

Responsible for end to end delivery of Candidate module which tracks tagging of

candidates against open demands .This is most critical module in the application.

Created Stored Procedures, Views, Triggers and Complex T-SQL queries in SQL

Server.

Part of team responsible for doing system testing.

Deployments of the application in all the environments.

Education

Degree

Specialization

University

Year of Passing

Master of Computer Science

Computer Science

Pune University, Maharashtra, India

2005

Bachelor in Computer Science

Computer Science

Pune University, Maharashtra, India

2003

Other Details

Visa Type

:

H1-B

Date of Birth

:

December 8, 1982

Gender

:

Male

Contact this candidate