Sql Server Manager,.net

Current Residence: *****, Floyd Drive, Overland Park, KS. Cell #:913-***-****, Visa Status: L2 (EAD)-NO SPONSORSHIP REQUIRED, Email address: *********@*****.**.**

Bhavesh M. Mehta

Summary

* B.E. (Computers) with experience of 10 years majorly in developing solutions using Microsoft technologies for Finance domain divisions- Global fund services/Business Infrastructure Services (Middle office), Fixed Income, Wealth Management, and Equities(Front Office),E-learning and power/electrical domains.

IT Skill Set

Programming Environment: Microsoft .NET Framework 4.0, SOA-Windows & Web Services.

Languages: ASP.NET, Java script, XML, Json/Jquery, Linq to sql, VB.NET, C# .NET, Unix, WCF and MVC 3.0 framework.

Database: SQL Server 2008(2005 & 2000), Oracle 8i/9i, IBM Informix, MS Access 2000 & Sybase.

Version Control System: Clearcase, Microsoft VSS, CVS, SVN (Tortoise and Aankh)

Other Tools & Technologies: WCF Storm, NUnit tests, Fiddler, Team City, Microsoft Visio, FxCop & Fitnesse.

Work Experience:

Ascend Learning (Overland park-KS) - April 2014 to till date

Roles and responsibilities:

* Hands-on development, Testing, Requirement Gathering, Release scheduling and Deployments, Task Estimation, Project planning, Offshore team interaction/coordination and business user meetings.

1. Minipool services/QBTB

Operations users (For Aviva & JPMAM)

08/11 – 03/28

An e-learning portal consists of assessments (tests) which are configured for number of institutions and consortiums. When a batch is created and students take a test, they don’t necessarily start at the same time. As a result, there is a chance that students can disclose questions and answers to the next batch. Hence a requirement was raised to bunch up the assessments into a group and then randomly select an assessment from a pool so that no 2 batches get the same set of questions. In the scenario in which, a form is compromised users should be able to exclude a form so that it is never picked up. QBTB UI essentially means creation of object, attribute definition for assessment pools and assessments including their relationships with institutions and consortium. Minipool WCF services were configured to expose API’s for UI which would connect to the database.

Technology Used: Silverlight, WCF, MVC, C# .NET, MS SQL Server, Nunit, Microsoft Visual Studio 2013.

JP Morgan– Aug 2011 to March 2014

Worked with JP Morgan as Associate in Corporate Investment Banking Technology.

Roles and responsibilities:

* Hands-on development, Testing, Requirement Gathering, Release scheduling and Deployments, Recruitment, Task Estimation, Project planning, Stakeholder interaction and business user meetings with local & global operations team.

Project implementation methodology:

All projects use agile methodologies and significant milestones are segregated into separate sprints. For each sprint, agile storyboard is created and all tasks are assigned to the team and discussed in daily scrum calls.

1. Claims and Investigation Management System (CIMS)

Operations users (For Aviva & JPMAM)

08/11 – 03/28

Overdrafts can be authorized (permissible) or can be created by lack of funds which can be oversight by Cash Settlement team or due to operations. CIMS is a system used to manage and update overdraft balance details by operations, which enter into the system via back-end feeds (using Autosys jobs) from a system called TLM.

The most important users for this system are Aviva and JPMIB. This feed contains overdraft data which includes negative balances as well as positive balances over 5 million GBP for client Aviva. Comments are entered, transaction amount is modified and the responsible team is assigned the transaction. Daily, these balance overdrafts are signed off and sent to the claims bucket. Audit history with a circular log is maintained for every single insert, update and delete.

2. Net Equity File Inspector (NEFI)

Operations users

08/11 – 03/28

It is a system which is used by Aviva and configured for JPMIB, UBS and Citibank clearers for managing ETD’s(Exchange Traded Derivatives). Initial Margin (minimum required balance for futures contract), Variation Margin (Daily Profit/Loss differential amount), Account Reference, Excess deficit cash (Net Equity), ExchangeRate to GBP gets uploaded for all the clearers via csv to the database. A buffer is set in the database to 500000 GBP. If Net Equity is greater than half the buffer size, then a PreAdvise is auto-calculated for excess amount else a Payment is auto-calculated for deficit amount. Pre-advise and payment adjustments can be done by the maker (Junior user) while the checker and Approver verify it. Once these are verified, payments are released to the downstream systems and confirmations are sent out via email.

Technology Used: Winforms+web: ASP.NET, MVC, C# .NET, MS SQL Server, Autosys, UNIX, Informatica, Nunit, Team City, FxCop.

2) Lehman Brothers/Nomura – Feb 2007 to Aug 2011

http://www.nomura.com

Roles and responsibilities:

* Coding, Testing, Requirement Gathering, Deliveries and Recruitment.

Onsite experience:

Worked in the London office of Nomura for 2 months to get Phoenix (Cash Manager) knowledge and train the offshore team and thereby increase team size. Worked in the New York, US office of Lehman Brothers for 1 month to meet the business users, solve their queries and build relationship with the counterpart in US.

Business Infrastructure Services:

1. Phoenix - Cash Manager

Operations users (Nomura)

03/10 – 08/11

Cash Manager is a critical middle-office pre-Gloss application which is used by Operations to settle the OTC derivative cashflows for variety of complex futures, options down to Gloss. It receives cashflows from Front Office Gateway and helps Ops users to net the cashflows and manage state of workflows from New, Released, Booked, Cancelled to Settled. It is an important application that reduces the reconciliation chores and reduces late payment risks. Also, it can help measure liquidity at a given point of time by giving a quick snapshot to the users for a particular counterparty by netting all the corresponding cashflows. The users can also net the cashflows and send them down for settlement by using swift messages. Netting helps reduce cost by reducing the quantum of messages sent down. Cashflows are booked in SMO(Strategic Middle Office) and swift messages are sent down to Gloss. It also helps apply MT103 swift settlement exception and lets the users get static information update from RDM.

Technology Used: Web:- ASP.NET, C# .NET, Web services, XML, SOAP, IBM Informix, MS SQL Server.

3) CMC Ltd (A TATA Enterprise) – May 2006 to Feb 2007

Project: (Development)

1. EKATS (Kuwait Automated Traded System)

K.S.E (Kuwait Stock Exchange)

05/06 – 02/07

EKATS is an automated event-based OLTP trading system implemented for Kuwait Stock Exchange with features like trading facilities in Equities, Bonds and Derivatives segment for the users of the KSE system. MSDE has been used on client terminals to store downloaded data (such as masters) and the active data that is valid for the session. Primarily the system focuses on the following:

* Central Trading Engine (CTE), which will take care of the core trading logic.

* Internet Trading System which will cater to Online Order Entry.

Modules: Broker Terminal, Broker Admin Terminal, View Only Terminal, Surveillance, Internet Trading System, Market Operations and Market Maker Terminal.

Technology Used: Winforms:- C# .NET, ADO.NET, MS SQL Server.

4) Krohm Solutions – July 2004 to May 2006

Project: (Development)

1. MeDAS (Development)

AMR/MDMS Product by Krohm Solutions

11/04 – 05/06

This project involves the development of an Automatic Meter Reading (AMR) software system that manages the collection, storage, processing and analysis of data obtained from AMR-ready energy meters. The system would support PSTN, GSM, and RS-232 communication interfaces to the meter data concentrator units. Contributed to the development and testing of following subsystems:

* Consumption Calculation (Billing): The meter readings received by the MeDAS Software by Real time reading, Manual User Entry, Daily readings would get the readings in table, which are then used to calculate Daily and Monthly Consumption. This Monthly Consumption is then used to bill the customer as per the tariff rates incurred depending on the customer type (Agricultural, Industrial or Commercial) and time slot of consumption.

* Multithreading Get Daily Meter Reading, Get Outage Info., get Error Log Screens: While MeDAS Software communicates with DCU, the User needs to be given updates about the RecordNo. being fetched by MeDAS. Hence the GUI updates are shown on a modal dialog box in one thread while protocol communication takes place on a different thread.

* Crystal Reports: Developed 2 crystal reports for :

a) Viewing Daily readings report: This report shows Meter, Customer, Premise, Reading Date-Time, KwhValue details grouped by either of user selectable fields CustomerId, Meter Sr.No., PremiseId etc for a user specified date Range.

b) Viewing Invalid Readings Report: This report shows Meter, Customer, Premise, Error Date-Time, KwhValue details grouped by either of user selectable fields CustomerId, Meter Sr.No., PremiseId etc for a user specified date Range.

Technology Used: Winforms:- VB.NET, C# .NET, ADO.NET, Oracle 9i, MS Access, Pl/Sql, UML

Contact this candidate