Sql Server Management

Sohail Ahmed +1-917-***-****

***********@*****.***

Over 12 years of experience as Programmer Analyst with full SDLC of various

projects, financial applications and databases in a variety of environments

with expertise in client/server environment. My understanding of

stimulating growth in the organization, identifying cost reduction

opportunities, managing client expectations and business relationships are

key strengths of my career. Expertise in financial tools like Bloomberg's

API, Geneva TLM reconciliation and Intra-Day cash management makes me

strong candidate to add value in company's growth.

Core Competencies

10 years of GUI (VBA forms ) Experience in Design Patterns, Data

development in Excel VBA, user Modeling, information gathering and

interactive templates, business creating data models using Use Cases

tier and data access layer, and ER diagrams. Expertise in

including presentation layer using reporting services and OLAP cubes(

Ajax 2.0, Dundas Charts SSRS,BIDS)

8 years of experience in data C/C++,VB.C#, Web Services (SDL,

access object using ODBC,DAO,RDO, UDDI, DISCO, SOAP protocol) and .NET

ADO and ADO.NET components such as Remote scripting and AJAX,

Typed Datasets, Data Adapters, Data Delegates, Multicasting delegates,

Readers, etc. Threading and Multithreading. WCF,

WWF, WPF, LINQ etc

8 years experience in of SQL Proficient in Design Patterns,

Server2000/2005 and Sybase database modeling and entity

development in writing SQL Queries, relationships, Data Grid, List

Stored Procedures, Indexes, Controls, and Tree View, as well as

Triggers, views menu and tab controls. Proficient in

Expertise in reporting services and C# classes, delegates, events.

OLAP cubes( SSRS,SISS)

Professional Experience

STATE STREET (Financial Service Providers) July

2009- Till date

Financial reporting and Trade reconciliation

Beehive is a client server application build on windows platform for

capturing trade activities for fixed income, FX, futures and equities

across the globe. Application enhanced operational control by securing all

trade activities in Asia, EMEA and Europe. System also has the features of

importing data from many different sources and creates dashboard reports

for different investment types for top management.

Responsibilities

. Credit risk modeling based on asset value, historical trend and market

ratings

. Developing pricing model using Bloomberg API and Excel Add-In to track

price volatility and trend analysis using different technical indicator

like Pricing Model

. Credit risk factor profiling and loans default analysis based on

financial data

. Creating spread sheet model (Excel/VBA) and financial templates to

capture trade activities, volume and commissions detail for counter

parties trade.

. Credit predictive modeling, Risk Analysis, calculating VaR, and scenario

analysis for loans default and using statistical algorithms and

. Designing Option Model for portfolio optimization, financial analysis

and financial reporting using MS. Access and Excel VBA

. Designing credit score card to provide quantitative measures to define

credit risk using statistical formulas

. Creating reports for Cash reconciliation, shares and tickets, commissions

and FX etc.

. Designing customized Add-ins (XLA) and tool bars using VBA forms and

macros to provide user friendly reporting capabilities and to apply

security model for data access.

. Credit scoring (Internal) and financial risk factor profiling

VBA, Excel, Pivot tables, Access 2003, SQL Server 2005, VSTO 2008,

Bloomberg API

UBS Investment Bank

400 Atlantic Ave Stamford CT

Financial Forecast and Estate Management

July 2008- June-2008

Forecast engine is a spread sheet model which enables entering and tracking

forecasts for servers and storage cost for business streams and to give

them an overview of their infrastructure cost over for next five years.

Forecast engine interact with internal financial applications and provide

approval status for each request made by forecast engine

Responsibilities

0. Analyzing, designing prototypes and creating spreadsheet Model for

business Streams.

1. Market data Analysis includes Bloomberg, Reuters and other internal

application to review the cost benefit analysis for senior management

reporting using VBA.

2. Writing procedure functions and modules using VBA to extract data from

different data sources,

3. Calculating TCO (Total cost of Ownership) for each recorded forecast

using Pivot tables.

4. Design different reports using XLT like TCO Analysis, Dashboard, Score

Cards, Risk Matrix, benefit summary using MS-Query and Pivot table

functionality

5. Spread sheet Modeling, data normalization and maintaining data

integrity for database tables.

6. Writing formulas and routines for net cost/benefit analysis based on

monthly, quartile and yearly

7. Importing and exporting Activity based Excel Templates for different

streams using VBA and consolidating different reporting for Credit

derivatives financial assets like forward contracts, swaps, and options

etc.

8. Creating Pivot Tables and extracting data using OLAP reporting for

building data cubes.

9. Creating reports, pivot tables and customized data cubes using Analysis

services for SQL Server 2005

VBA, Excel, Pivot tables, OLAP Reporting, Analysis Services, C#, Access

2000, SQL Server

Ramius Capital -Hedge Fund (Sr. VBA Programmer)

599 Park Ave NYC NY

Real Time Pricing and Intraday PNL Financial Reporting

Aug-2007- Jul-2008

The application enables users to get real time prices from Bloomberg and

evaluate their different level of PNL for their holdings. Application also

provide an overview of overall market volatility and changes in currency

across the globe, which helps traders to evaluate the risk associated to

their funds and make adjustments based on their financial analysis.

Responsibilities

. Trading floor assistant, supporting trading apps, investigating issues

and respond to client inquiries.

. Designing reports for Traders to calculate Daily, Monthly and YTD PNL

reporting for traders and identifying Top5 winner& Losers funds

. Supporting traders applications and supporting and fixing day to day

issues and queries from traders.

. Data Analysis, verification & correction of derivative contracts,

i.e., notional amounts settlements & trade dates, fixed & float

spreads & LIBOR rates

. Building user interface using forms for maintenance, project tracking,

LOB(line of business) allocations and to have an overview of cost and

benefit for projects over the periods of time

. Integration with Bloomberg API to get real time pricing and writing

functions, modules and procedures to extract holdings and calculating

real time PNL for traders using VBA.

. Creating Add-Ins (.XLA) files to apply business rules based policies

and structure.

. Financial Reporting for Credit derivatives assets like forward

contracts, swaps, and options contracts.

. Importing and exporting XLS Templates files for different Towers using

VBA and consolidating different Reporting Credit derivatives financial

assets like forward contracts, swaps, and options etc.

. Designing Tool bars, controls and icons based on the user requirements

using system application object and their controls collections.

. Create NPV, IRR, discount cash flow, and VaR models for evaluating

financial implications of new products and investments, and provide

recommendations to senior management

Excel/VBA, C#, ADO.NET SQL Server 2005, Sybase, Bloomberg API,

Asset Management

Moody's Financials Services (Sr.VBA Programmer)

7-World Trade Center, New York, USA

Global Rating Methodology Model Apr-

2006- Jul-2007

Developed enterprise Rating Model which enables users to calculate

indicated Ratings, conduct scenario analysis, help to understand key

factors and financial ratios used by Moody's in determining ratings for

different industries in corporate sector. Application also provides

research data, analytic capabilities for assessing credit ratings, and

publishes market-leading credit opinions such as S&P Bloomberg etc.

Responsibilities

. Designing Business prototypes for rating methodologies and applying

business rules based on their strategic and predefined policies.

. Creating Toolbars and Menus using VBA to access customized reports

from database.

. Financial reporting using data cubes, Pivot tables, Graphs and score

card matrix

. Close interaction with business user to understand and define business

process.

. Enterprise system deployments and DR strategies and post production

. Database integration with internal reporting services using ADO

objects to extract data from database

. Capacity planning and Cost change management for resources

. Lead the creation of data schemas for application topology to enforce

development process

. Leads projects by ensuring scheduling, delegating and monitoring

project tasks, and reviewing project deliverables.

. Designing Business Templates (Excel XLT) for towers and applying

business rules based on their strategic and predefined policies

VBA, OLAP reporting, Excel, C#, Access 2000,Oracle, SQL Server

JP Morgan Investment Bank (Sr. Programmer Analyst)

Merger Cash Flow Management and Data Modeling

Sep-2004- Mar-2006

Cash Flow Management system is designed for efficient processing and

delivering widespread overview of yearly investment and target spending.

System provides financial reporting for project's cash flow and their

current status in terms of cost, benefits and projected targets. System

also provides the flexible environment that allows users to view and

manipulate their financial activities using business templates. Spreadsheet

models offers managers an advanced financial reporting and analysis feature

which is integrated with centralized data source and also gives reporting

for top management to drive projects with standards matrix based corporate

strategies

Responsibilities

. Business Analysis, gather requirements and formulated the functional

specification for project.

. XLA(Add-in) for all financial reporting to server financial reports.

. Designing Excel and Access applications using VBA, ODBC and Ms-Query

to integrate data from streams.

. Designing security master and historical pricing for securities

. Close interaction with business user to understand and define business

process.

. Designing spread sheets Models for rating methodologies and applying

business rules based on their strategic and predefined policies.

. Designing Interactive spread sheet Models based on real time pricing

to calculate Current, MTD and YTD PNL for different investments

vehicles

. Coordinating financial factors reporting and calculating Trend

Analysis based on multiple years ratings against current market

rating.

. Building user interface for maintenance, to input user's financials

allocations and to have an overview of current and projected scenarios

for current and future ratings.

VBA Excel (XLT,XLA), VB.Net, Access 2000, SQL Server,Oracle

DKR Capital Inc. Hedge Fund(Sr. Programmer Analyst)

Pricing Model and Trade Reconciliation System

Apr- 2003- Aug- 2004

Designing real time Pricing, Trade conformation and Cash Reconciliation

system. Trade conformation and reconciliation gives the ability to

reconcile trades, identifies the breaks and detail of exceptions. System

automates the reconciliation process between in house software applications

and counter parties. System also has the features of importing data from

many different sources. System process all trades, Cancel Corrects detail,

PNL and holding positions and automate email process for back-end

operations.

Responsibilities:

. Front-Office support & backup for daily trading activities and issues

related to applications.

. Building Options pricing evaluating model for Risk Management group

using VBA.

. Reporting Trades activity and financial reporting for vanilla credit

derivative products

. Loading Transaction Like revenue, Expense, Adjustment, Pricing in to

Geneva.

. Processing all derivative transactions, verify trades and reconcile

with other financial resources.

. Calculation for best price using Ask, Bid, Last, High, low and Mid

Prices.

. Provided background operational& back office support for all traders.

. Designing Strategies for calculating best prices for regular and

convertible bonds.

. Writing scripts for mapping Bloomberg fields and calculation real time

pricing.

. Integrating and implementing Bloomberg pricing process with financial

apps.

. Writing store procedure and T-SQL to manipulate data from Bloomberg

decrypting files.

. Creating corporate action reports like Cash & stock Dividends, Spins

off and Acquisitions etc.

VB, VB.Net, VBA Excel, OLAP, Access 2000,Geneva portfolio System,

Crystal, Bloomberg, SQL Server

Assets & Equities Management System(Programmer Analyst)

Citi Group 299-Park Ave- New York, NYC Oct-

2002- Mar-2003

SSR Reconciliation system is an advanced financial reporting and business

examining application, which integrates with the various smartstream

applications like reconciliation of cash, security holdings and security

transactions in a single platform, providing consistency in control through

the use of matching rules and procedures. smartstream Intra-Day provides

comprehensive, real-time information to improve cash and liquidity

management.

Responsibilities:

. Designing financial management reports from SSR and Portia data feed

using Excel spreadsheet and Access reports writer.

. Designing Excel and Access applications using VBA, ODBC and Ms-Query.

. Responsible for database design including determining various entities

and their attributes, finding the relationships between different

entities, designing and normalizing of database tables, choosing keys and

determining integrity constraints and identifying and enforcing

relationship.

. Creating reports in Business Objects like Cash reconciliation, Aged Cash,

Intraday Cash etc.

. Excel based app using Visual Basic for Applications (VBA), building

reports batch process package

. Maintaining over night batch reporting process including snapshot and

spreadsheet output format.

. Production support and customer services for trading desk and day-to-day

financial activities.

. Exceptional handling for Trade feed from Bloomberg to Portia using C++

Excel, VBA, Access 2000, VB. Net, Business Objects, Portia, Bloomberg,

Sybase

Financial Projects Tracking System(VBA Programmer)

Bank of America Mar- 2002- Sep- 2002

Customer Services and support system is responsible for tracking all the

financial activities in all call centers. System interacts with the

different internal applications to get required information and manipulate

the data using different query tools to complete its process. System is

responsible for project analysis reports, cost summaries, executive

summaries and Gantt charts based on consolidated information from all call

centers. Business users and steering committee members can access and

download status spreadsheets for their projects to meet their financial

needs and to make the decisions for the projects and can set their

priorities based on the best available resources.

VBA, OLAP, Access 2000, Excel, ASP, HTML, COM Plus, SQL Server,

Deutsche Bank (Software Developer)

280-Park Avenue NYC NY Sep, 1999 - Mar,2002

Fixed Income Trading System

Fixed income trading system (FITS) is meant to address some of the

processing situation that have caused Fixed Income trading to be a largely

manual, paper based process. It is meant to replace the existing fixed

income-trading process with the graphical front-end, navigated with the

mouse and keyboard. System needs to communicate with the current Landmark

Database (Internal Financial Database) and pulling update financial

information using Bloomberg (API). All features provided by the standard

Bloomberg API(Excel) are encapsulated within the system to get the real

time financial data. Application is designed to mean all the business

requirements from creating purposed orders till ticket execution.

Excel, VBA, Access 2000, Visual Basic 6.0, Bloomberg, C/C++, ASP, HTML,

Oracle

Education:

Master in Computer Sciences

Master in Business Administration

Software Engineering Post Graduate Certification

Bachelor of Arts (Statistics & Economic)

Bloomberg API Active-X Training

Credit Derivatives/Interest Rate Swaps Fundamentals (NYU)

Risk Management Certification (NYU in Process)

Reference: References will be furnished upon request

Contact this candidate