Kunal Sharma

732-***-****

c84ivz@r.postjobfree.com

CAREER OBJECTIVE:

Senior Database and .NET developer seeking a position in a fast-paced company that leverages my achievements, skills, energy and talent for providing a technological solution to business solutions. I have over 14 years of experience in various fields such as Hedge Funds, Finance, Fashion, Telecomm and Energy

EXPERIENCE

The Blackstone Group, New York NY Feb 2010 – Present

Senior Database Developer, BAAM

Blackstone Alternate Asset Management (BAAM) serves many of the worlds largest and most sophisticated institutional investors. These investors look to BAAM to protect their assets through both commingled and custom-tailored investment strategies designed to deliver compelling risk-adjusted returns and mitigate downside risk

Responsibilities:

• Developed and enhanced several interfaces between multiple systems designed specifically for fund of funds portfolio management system

• Customized a fund of funds portfolio management system bought by the company (HedgeSphere) including developing custom reports

• Resolved numerous deadlock related issues within several processes that were causing a severe delay in lock-down of funds

• Implemented a transaction delivery system from the in-house built HedgeHog system to the newer HedgeSphere portfolio management system that eliminated dropping of valuation requests

• Reduced the time it took to process valuation reconciliation between the two systems, greatly increasing efficiency of fund accountants

• Provided capability to be able to perform Side Pocket allocations for funds of funds from one fund to another while interfacing with HedgeSphere

• Delivered several tools for fund accountants and pricing teams to enable in estimates processes and perform fund lockdowns sooner

• Migrated over a dozen processes to a single monitoring agent (ActiveBatch)

Royal Bank of Canada, New York NY Jun 2009 – Jan 2010

Senior SQL Developer

Royal Bank of Canada Capital Markets is a Premier Investment Bank that provides a focused set of products and services to institution, corporations, and high net worth clients around the world

Responsibilities:

• Designed and developed on several SSIS Packages to load data from Excel files, XML files, Sybase Database Servers and other SQL Servers

• Wrote and optimized several stored procedures to help aid back-office Product Control report processing

• Designed and implemented several web reports using SSRS, including implementing automated email delivery to front-office and back-office business users

• Worked with business users to gather requirements, test the implementation of end products and provide continued user support

• Designed service contract, service implementation, business logic and data access components to satisfy application (business and technical) requirements

Merrill Lynch/Bank of America, Hopewell NJ Jan 2009 – Jun 2009

Senior SQL Developer/DBA

Merrill Lynch is a major global financial services firm providing a variety of services to its clients. Worked with the Global Wealth Management (GWM) group in the Business OnLine (BOL) team.

Responsibilities:

• Designed and developed a Log Management System to read the Systems and Application logs over the network and storing the pertinent information in a SQL Server 2005 database. Created several reports that helped with troubleshooting errors when they occurred as well as searching for similar errors on a different machine. Files were parsed using VBScript and system was developed using VB.NET

• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance

• Meet with technical team members to gather and analyze business requirements.

• Administered all SSAS instances and worked on SSAS in order to analyze grouped data and aggregate it into different formats and views. Created SSIS packages. Implemented Pager options to inform corresponding DBA basis on Each Job Status.

Coach, Inc., New York, NY May 2007 – Dec 2008

Senior SQL Developer/ DBA

Coach is a leading global fashion accessory company, delivering high quality merchandise at a competitive price.

• Migrated several in-house databases from SQL Server 2000 to SQL Server 2005. Instrumental in installation, configuration and maintenance of SQL Server 2005 databases

• Developed, deployed and monitored SSIS packages including upgrading DTS to SSIS (MS SQL 2000, MS SQL 2005)

• Designed and developed a Bridge between the existing (SQL Based) Product Lifecycle Management system (Karat) and a new (Oracle Based) FLEX PLM system that maintains data integrity between the two systems

• Designed and developed application to enhance the capabilities of existing Strategic Lease Integration Management (SLIM) application that manages the rent aspect of the individual stores at Coach

• Customized various extracts from the application to adhere to new business requirements. Application involved rewriting several critical components in the SLIM database to enable storage of key determinants such as breakpoints, split factors and accrual in the database as opposed to calculating them on every run design and developed application to forecast accrued rent for stores for a year in advance

• Developed application to automatically create PDF files from Crystal Report files, and mail them to the individual landlords

VSNL International, Princeton NJ Feb 2004 – Apr 2007

Senior SQL Server Developer/DBA

VSNL International promotes communications solutions to the global carrier and enterprise markets by leveraging our extensive undersea and satellite network capabilities in India and around the globe. In February 2006, VSNL acquired Teleglobe, one of the world’s leading wholesale providers of international telecommunications services, including mobile, IP and voice services.

• Optimized several stored procedures and reduced processing times by over 80%.

• Developed applications to upload rate sheets into a Costing database that fed the Routing systems

• Created several DTS package scripts to migrate data from excel spreadsheets to SQL Tables, and vice versa

• Developed application to transfer Costing data for reconciling VOIP traffic costs between systems in Princeton and Montreal

• Created several reports for end users and set them to be sent out on a regular schedule

• Developed translational application in SQL Server to transfer data between Rate Entry system (MS SQL 2005) and the Billing Engine (Oracle 10)

Green View Ventures, NYC Aug 2003 – Jan 2004

Senior SQL, VB Developer

Greenview Ventures was a New York City-based venture capital firm organized to invest in emerging growth companies in the software, financial services, distribution, and media industries.

Responsibilities:

• Developed Internet payment system (WEBPAY) for various customers.

• Implemented user-management for end-users

• Developed web services for making E-Check payments and payment authorization calls to ECHO for credit and debit cards

Metro Plus Health Inc., NYC May 2003 – Aug 2003

Senior VB and SQL Server Developer

Metro Plus Inc. is one of the reputed insurance companies in Health Care industry. Metro Plus provides access to health care services to New York City residents in Brooklyn, Queens, the Bronx and Manhattan through New York State.

Responsibilities:

• Developed reports using Crystal Reports 8.5

• Developed COM objects for data retrieval and update purposes

• Designed several user-defined functions that were used for ‘View Time Security’ so that reports would return only data relevant to the user who was logged in

Constellation New Energy, Inc.

Walnut Creek, CA

Sr. Systems and Database Architect / Team Lead June 1998 – April 2003

New Energy is the largest player in the deregulated retail energy market. It has offices in California, New York, Pennsylvania, Ohio, Illinois and Texas, with distributions in the above mentioned states and in New Jersey.

Data Warehousing System

• Led team of four developers to develop two huge sized data warehousing systems, both over 400 gigabytes in size.

• Developed applications for acquisition of EDI Files from over 30 utilities across the US from over seven states.

• Led development of highly scalable data import system capable of importing over 100 thousand rows of EDI data per day in a matter of minutes.

• Designed and developed data warehousing system of Usage data from over 30 utilities across the US.

Development of CIS system for retail electricity market

• Designed and developed front-end web-based application that allowed customer service representatives in the regional offices to enroll customers under various different billing products.

• Provided tools for regional offices to verify usage data received from utilities against what was sent in invoices.

• Built functionality to automatically and manually post payments received from customers and answered any billing-related questions.

• Built capability for ad-hoc reporting that could be e-mailed or downloaded upon request to CSV files, developed as a table-driven reporting system.

Pricing Download Application

• Supervised development of application in VB 6.0 to download pricing factors from utilities’ web sites.

• Scheduled application to download data every hour since prices were hourly updated in most cases.

Development of Invoicing System

• Designed and developed invoicing database in SQL 2000 using ERWIN.

• Wrote algorithms for aggregating 15-minute, 30-minute and 60-minute usage data into on peak, off-peak and intermediate-peak values based on the rules set forth by the utilities.

• Wrote algorithms for double-checking usage data received in usage files (EDI 867) against the invoice files (EDI 810) and in case of any, flagged it to the appropriate people who could handle the situation.

• Developed critical business objects to parse the invoice data in the EDI 810 files so that it may be used for billing.

EDI Payment File Creation

• Designed and wrote program for creating and transmitting EDI 810 files for major telecommunications customer containing invoice information.

Integration with third party Information Product

• Created staging database for transfer of account, meter, and usage data between two systems.

• Wrote DTS packages for data transformation between usage warehouse and staging database, while aggregating usage to the hourly level.

• Created flat files for usage transfer between Staging database and Information Product in CSV format.

• Provided daily feed of invoice data and PDF files from billing database to information product, housing in the data on the staging server.

A-B Lasers, Inc.

Acton, MA

Software Engineer, Web Master Sep 1997 – Jun 1998

A-B Lasers is one of the largest manufacturers of Laser Marking Machines. Responsibilities included designing, developing and successfully implementing customized front-end applications for laser machines to automate the marking of products.

Production of Bearing Marker machine for Kaman Corporation

• Supervised construction of a two-station 90-watt rotary machine to mark bearings.

• Developed application to enable automated marking of several different bearings, including keeping track of serial numbers on different bearings.

• Worked on developing applications for label marking machines for a major cell-phone manufacturing company.

TECHNOLOGY: Microsoft SQL Server (2000, 2005), VB.NET, C#, Crystal Reports, VB Script, XML, Erwin, VISIO, SSIS, SSRS

EDUCATION

Bachelor of Engineering June 1995

Computer Engineering, Delhi College of Engineering, University of Delhi, India

CERTIFICATIONS

Microsoft Certified Technology Specialist, SQL Server 2005

Contact this candidate