SUMMARY

• Microsoft Certified Solution Developer with 12 years of experience in executing full project life cycle including System Study, Analysis, Project Planning, Technical Design, Development, Testing, Implementation, Maintenance and Production Support.
• Extensive functional knowledge in areas of Financial services, Logistics and Inventory Management.
• Strong knowledge of Fixed Income, Equity and Derivative products.
• Strong business knowledge of financial applications which helps to understand the requirements and suggest the clients on day-to-day issues.
• Have sound knowledge of Trade life cycle/Trades processing, Front office, Middle office and Back office processing.
• Passed CFA Level 1 June-2009 exam.
• Worked closely with business users and cross-functional teams.
• Involved in interacting with clients and various technology teams in analysis and resolution of production/Application support issues.
• Extensively developed Web forms using Silverlight / XAML, ASP.NET, C# .NET, ADO.NET
• Extensive experience in XML, XSLT and Web Services.
• Experience in developing Web Services/WCF (SOA) (SOAP, WSDL, and UDDI).
• Extensive experience with database development using SQL Server and Oracle.
• Experience in end-to-end full lifecycle of software developments SDLC, including configuration management using Visual SourceSafe(VSS), SVN, and SoS
• Proven skills in relationship management with clients and effectively guiding teams during the project development life cycle and delivering the product within time line, cost and quality.
• Strong Object Oriented Analysis and Programming skills.
• Experience in using third party tools like Infragistics web Controls.
• Experience in providing day-to-day production support on existing .net web applications.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

Languages: C# 2.0 / ASP .Net 2.0/4.0, VB .Net, ADO .Net, VB 5.0/6.0, C , C++

Web Technologies:ASP.Net, Silverlight 4.0, AJAX, XML, XSL, DTD, DOM, HTML, JavaScript, VBScript

Middleware:ACTIVEX ,COM, DCOM, COM+, XML Web Services/WCF, (SOA) - SOAP

Databases:SQL Server 6.5/7.0 / 2000 / 2005 / 2008 , Oracle 8i / 9i

Application Server:Internet Information Server (IIS) 5.0 / 6.0

OS:Windows 95/NT/2000/XP/2003, Unix

Framework:.Net Framework 1.0, 1.1, 2.0, 3.5 and 4.0

Tools Utilities: VisualStudio.Net, BizTalk Server 2000,Visual Source Safe, Source Offsite, Visual InterDev, Visual Modeler, Erwin, UML, Visio 2000, Install Shield, TOAD, CMxtra.

EDUCATION
Bachelor of Engineering.

CERTIFICATIONS

Microsoft Certified Solution Developer – MCSD – 2000

PROJECT DETAILS

Confidential, New York-NY Nov 2011 to Till date
Project: Performa
Role: Sr. Consultant

Description:
It is a pricing and performance measure application. Under the Pricing it shows the pricing chart of a particular security. Pricing chart allows the users to compare multiple securities price movement at a time. Performance section displays all securities for a given period. When the user selects a particular security it shows up the performance chart with different performance return measures like periodic return, cumulative return, Rolling six period return, Rolling 12 period return etc. This application gives a snapshot of pricing movement and different performance measures of a security.
Pricing/Performance charts are provided with Chart wizard to change the chart type.
It has export to excel feature to export the data or chart.

Responsibilities:

• Designed and Developed Pricing and Performance screens using Winforms, C#.
• Coded business layer and to bind the data to UI screens.
• Wrote stored procedures for retrieving data Using SQL Server 2008.
• Used DevExpress controls i.e. Grid control, Chart control on Pricing and Performance screens.
• Wrote formulas in business layer to calculate performance measures.

Environment:
Languages: Winforms, .Net 4.0, C#, SQL Server 2008, DevExpress Controls for Winforms, Visual Studio 2010.

Confidential, New York-NY May 2011 to Oct 2011

Project: Security Framework
Role: Sr. Consultant

Description:
It controls the user’s access level to different intranet applications. It provides granular level access i.e. at page level/entity level and Field level access. Users and Groups can be created using this application and grant access level at user level or group level. It has the provision to grant access to all entities of a particular entity type. Whenever there is a new entity created, the user who has access to all entities will automatically get the access to it. Entities can be grouped on a particular attribute and can be given permission at group level. New entity type can be added and as and when a new entity is added it brings all the entities belong to that entity type. Similarly when all objects permission is granted for a user, whenever there is a new Field added to a particular page the user will automatically get access to it. From implementation side applications will check if the user has access to any of the objects belongs to a particular page and then it would check if the user has access to that entity. It would allow the user to view/Edit the particular sections of the page based on the permissions set in the Security Framework.

Responsibilities:

• Developed Entity Permissions and object permissions pages to retrieve and update permissions using Silverlight 4.0 C#/XAML and Telerik RadControls.
• Designed and developed User/Group pages.
• Created WCF service wrapper on top of existing middleware to communicate with database.
• Wrote database scripts with application objects data to deploy it to UAT/Prod.
• Wrote stored procedures for creating/retrieving user's object permissions and entity permissions Using SQL Server 2008.
• Enhanced middle tier components using C#/.net to service the Security Framework needs.
• Implemented Security Framework in existing intranet applications.

Environment:
Languages: Silverlight 4.0, XAML, ASP.Net 4.0, C#, WCF, XML, XSL, JavaScript, SQL Server 2008, Visual Studio 2010, Telerik RadControls for Silverlight

Confidential, New York-NY Aug 2010 to Apr 2011

Project: PRISM-Portfolio Ranking and Investment Selection Model
Role: Sr. Consultant

Description:
It is a web based application developed in Silverlight 4.0. It is mainly used by Portfolio Managers and Analysts for their investment analysis and selection. It covers different type of instruments i.e. Fixed Income instruments and Equity. Among Fixed income instruments it covers Bank Debt, MBS, Corporate bonds, Floating Rate Notes, etc. It has a Security details screen it contains different sections of information i.e. Issuer Info, Security Info, Coupon Info, Call Schedules Info, Total Return and Commentary Info. It also provides the Analytics information by using the third party Bond calculator. It considers all the call schedules and amortization schedules to provide the yields.
PRISM has a Model Security screen to create a model/sample security to do the what-if analysis of new/sample security. Underlying data for PRISM is sourced from Paladyne and VMP (Virtual Portfolio Manager).

Responsibilities:

• Designed and developed Security Detail Page using Silverlight 4.0/C#.
• Wrote stored procedures for Security Detail Page using SQL Server 2008/XML
• Created views and stored procedures using SQL Server 2008.
• Developed service layer using WCF/C#/.net.
• Integration of generating XML request, XML response and updating Analytics data in PRISM using C#/WCF and Bond Calculator.
• Designed and developed upload screen to upload Credit Agreement or Bond Prospectus
• Designed and developed Model Security Screen using Silverlight 4.0/C#.
• Implemented entitlements to enable/disable some of the features based on the user type.
• Designed and developed Amortization Schedules page using Silverlight 4.0/C#.
• Wrote common code to be used from different pages using C#.
• Implemented integration of managed code and JavaScript.

Environment:
Languages: Silverlight 4.0, XAML, ASP.Net 4.0, C#, WCF, XML, XSL, JavaScript, SQL Server 2008, Visual Studio 2010, Infragistics NetAdvantage Volume 10.3.

Confidential, New York-NY Sep 2009 to Jul 2010

Project: Account Master
Role: Sr. Consultant

Description:
It contains the complete information of a particular securities Account. The account could be a Mutual fund type or an entity type. Account will have several statuses like in-progress, ready for trading and ready for reporting based on the information provided during the account creation.
It contains several sections of information. Example Basic Info, Investment Admin, Financial Info, Performance Info, Regulation info, settlement etc. It allows to add the portfolio manager/ reporting manager, executing broker and clearing broker. It allows to specify the trading/reporting currencies and countries allowed to invest for an account. Account master internally tracks the each update to the account through data versioning and it gives the status of an account at a particular period of time.

Responsibilities:

• Designed and developed Account master Web forms using ASP.net/C#.
• Wrote algorithm for Account master data versioning.
• Wrote stored procedures for data versioning using SQL Server 2008.
• Created views and stored procedures using SQL Server 2008.
• Developed middle tier components using C#/.net.
• Coordinated with other teams where it has the dependencies.
• Used XML in stored procedures to extract the parameter data into data tables.
• Designed and developed web pages for contacts sub module using ASP.net/C#.
• Coded generic popup page to bring the lookups/multi-select values using ASP.net/Java script.
• Coded middle tier component for performance engine and account master integration in C#.
• Coded stored procedures for performance engine and account master integration using SQL Server 2005.
• Resolved integration issues between performance engine and Account master.

Environment:
Languages: ASP.Net 3.5, C# , AJAX, XML, XSL, VBScript, JavaScript, HTML, CSS, SQL Server 2008,Visual Studio 2008

Project: Security Classifications
Role: Sr. Consultant

Description:
It allows classifying securities under particular index/scheme like FTSE Nareit, GICS, SP sector etc. It allows to create different classifications and sub-classifications under particular Index/Scheme. Root classifications and the corresponding sub-classifications can be created under a Scheme i.e. FTSE Nareit, GICS, SP sector etc. Once the Scheme and its classifications are set up then a Security can be associated to one or more Scheme/Classification. It has also provision to clone a particular scheme along with its classifications instead of building it from scratch. All the classifications under a scheme are being displayed in a tree structure to view the complete hierarchy of root classification.

Responsibilities:

• Designed and developed Classifications, SecurityClassifictions, ClassSource, Maintenance and Assign Classification Web forms using ASP.net/C#.
• Wrote stored procedures for all pages using SQL Server 2008.
• Displaying tree structure of sub-classifications is coded using AJAX.
• Developed middle tier components using C#/.net.
• Coordinated with other teams where it has the dependencies.
• Used XML in stored procedures to extract the parameter data into data tables.
• Assign classifications is coded using AJAX.

Environment:
Languages: ASP.Net 3.5, C# , AJAX, XML, XSL, VBScript, JavaScript, HTML, CSS, SQL Server 2008,Visual Studio 2008

Confidential, New York-NY, Jersey City-NJ June 2003 to Aug-2009

Project: Trade Allocation and Correction System (TACS)
Role: Sr. Consultant/Team Lead

Description:
TACS is an MLX based web application to provide block trade allocation for Merrill’s institutional clients/Investment Managers. Trade executions come from broker side and the corresponding block and allocations comes from client side through Oasys/Omgeo and TradWeb. The execution and client block gets matched automatically based on certain criteria. Clients can as well upload the block and allocations that gets matched with the corresponding trades. Manual matching and manual affirm capability is provided for internal users and some of the external users. It has the facility to edit, split and merge the block trades. When the allocations ran into Account errors, users can correct the account details and resubmit. After the trades are allocated successfully the allocations get booked into clients accounts. Allocation services has different flavors of businesses, i.e. ISS for Fixed Income securities, BCC for Equity ,MMS for Money manager services for both Fixed Income and Equity ,GCS for Custody services, CPB and FIPB versions are for Prime broker business. These business entities are acted as an executing broker or Clearing Settlement service or Custody services etc.

Responsibilities:

• Involved in Trade data analysis to identify the root cause of the issues.
• Coordinated with other technology groups to resolve the issues.
• Responded user’s calls and mails and assisted users in resolving production issues.
• Simplified the production support process for quick analysis and resolution.
• Notifying the respective User groups in advance if there are any delays in trades processing.
• Monitored application Health check alerts and message queues to identify delays.
• Monitored the Message queues to see if they are any message backlogs.
• GUI modeling and development of manual allocation Web forms using ASP.net/C#
• Wrote algorithm for allocation upload file processing.
• Coded Build block Web forms using ASP.Net/C#/AJAX
• Conceptualized, designed for Report Error email functionality.
• Used XSLT for transforming the XML data in HTML
• Wrote stored procedures for Priority report and accounts list with SQL Server 2000.
• Coordinated with offshore team on development and support during non-us market hours.
• Involved in part of the UAT testing team in TACS 2.0 migration.

Environment:
Languages: ASP.Net, C# ,ASP 3.0, AJAX, XML, XSL, VBScript, JavaScript, HTML, CSS, XML, Web Services, SQL Server 2000,Visual Studio.NET, Windows 2000.

Project: Octane

Description:
It is a CRM web application migrated to ASP.Net. It is developed for supporting Merrill’s Institutional Portal and servicing customer profiles. Octane II would maintain the entire customer data and the applications for which they are entitled in the Portal. Octane II constantly interacts with MS Active Directory through Web Services and does real time update in Active Directory. An advanced reporting section is also included to run various customer related statistics on a weekly, monthly basis. Customer Usage is also tracked inside the portal and the data collected is used for application tuning. An add on tool called Bulk Upload is provided through which the users are uploaded into Active Directory via a plain vanilla Excel Sheet without even interacting with the web interface. There are more than seven external components to which the application needs to interact with and all is done through web services. Email, File Upload, Customer Inactivation, Sync with third party Databases are handled through Windows Services and a single exe acts as a control for all the windows services.

Responsibilities:

• Migrated Customer profile, Entitlement, User roles web forms in ASP.Net
• Developed DTS packages for ELT for data migration of data from Epiphany to SQL Server 2000.
• Developed database schema for data migration from existing production environment to new production environment.
• Executed migration scripts daily bringing new/modified data from Production-I to Production-II and enhanced the migration scripts.
• Wrote Stored procedures migration from Oracle to SQL Server
• Created views and Triggers using SQL server 2000
• Designed and created Triggers for Audit Trail of client profiles
• Developed entitlements page using ASP.NET / C#
• Created Middle layer components using C# for Roles, User and Entitlements module
• Developed Web Services using .Net Framework for getting data from third party portal
• Developed Custom report page for generating custom made reports.
• Off-shore coordination & Process Management

Environment:
Languages: ASP.NET 2.0, VB.NET, VBML, ASP 3.0, Web Services ,XML, VBScript, JavaScript, SQL Server 2000, Epiphany Studio, Visual Studio.Net, XMLSpy, Windows 2000

Confidential, Bloomington, IL Mar-2003 to June 2003

Project: External Tracking System (ETS)
Role: Sr. Consultant

Description:
External Tracking System is a part of SFI internal project. It severs to maintain the SFI vendors information. This application is for capturing the detailed information about Vendors, External Associate, External Associate Orientation and Master Contract.

Responsibilities:

• Preparation of Sequence Diagrams for Vendor Usecase.
• Preparation of Class Diagrams for Vendor Usecase.
• Writing the pseudo code for different layers and ASP pages
• Developed Unit Test Cases for Vendor module.
• Preparation of work breakdown structure.

Environment:ASP, VB, VBScript, JavaScript, DB2, Lotus Notes, Windows 2000 Server

Confidential, NJ Mar-2002 to Feb-2003

Project: Small Business Solutions (SBS)
Role: Sr. Consultant

Description:
Small Business Solutions is a part of Dun and Bradstreet’s IT services. It provides all the companies info in United States and also in foreign countries. It offers different kind of reports that are I) Credit Evaluator Reports ii) Comprehensive Reports iii) Marketing Lists. iv) Industry Reports. v) CreditBuilder Report. vi) Collection services vii) Country Reports etc. D&B maintains gamut of information about the companies’ details. It helps business analysts to build profitable business relationships with their customers, suppliers, and business partners. It involves extensive use of XML request/response to multiple servers to post/get the required data..

Responsibilities:

• Developed stored procedures, functions and views using SQL Server 2000
• Designed and developed of EMAIL2 processor using CDONTS component
• Designed and developed CreditBuilder Product with ASP 2.0.
• Developed COM components and back end objects for various products in SBS/RWS applications.
• Coded web page and used XSL Transformation of XML data to render ASP pages.
• Developed web pages using ASP 2.0 and Style Sheets (XSL) for various modules across the site.

Environment:ASP 2.0, VB 6.0, VBScript, JavaScript, XML, XSL, XPATH, CDONTS, SQL Server 2000,Visual InterDev, SourceOffSite, Windows 2000 Server

Confidential, Englewood, CO Jan-2001 to Mar-2002

Project: Private Market Place
Role: Sr. Consultant

Description:
Private Market Place is s an e-commerce product. Private Marketplace application brings existing markets, such as buying groups and cooperatives, online. Members can view product information and place orders with approved suppliers. Members gain value through reduced order-entry errors, the convenience of having product information and pricing of all suppliers in one online location. Buying groups and co-ops can further enhance the loyalty of their members and can track and analyze ordering activity.
It has the features like Fast Track, UI Customization, Pricing, Multidelivery schedule, Unit of Measurement, Catalog Manager, Manage Placed Orders, Multilingual support, Rapid Order Entry, Advanced Search, Notifications, Data Log etc.

Responsibilities:

• Created templates for different functions in COM for business layer components
• Developed common routines for using across the ASP pages
• Wrote JavaScript validations across ASP pages
• Coded Reorder and amendment components using COM and corresponding web pages using ASP 1.0.
• Created of Database Objects across the application.
• Involved in support and Production Bug fixing and preparation of CIMP (Change Impact Management Plan)

Environment:ASP, VB, VBScript, JavaScript, MS SQL Server 7.0,Crystal Reports 7.0, Windows NT server.

Project: Transaction Billing Accounting

Description:
This application is for charging the market places hosted for different clients. Through this, Admin can setup different transactional rates for different duration. Reports can be mailed in HTML, Excel or RPT format to the concerned clients using this system. It has four modules 1.Billing Setup 2.Transation Activity, 3.Report History and 4.User profile.

Responsibilities:

• Developed middle layer COM components for Transaction Activity Module using VB 6.0
• Designed and developed COM components for Report History Module
• Coded web pages using ASP 2.0 for Report History Module
• Involved in Launching the Crystal Reports in Web Browser.
• Configured of Crystal ASP Web server for launching the existing reports in Web Browser.
• Wrote stored procedures, functions, triggers for the application with MS SQL Server 7.0.

Environment: ASP 2.0, VB 6.0, VBScript, JavaScript, MS SQL Server 7.0, Crystal Reports 7.0, Windows NT server

Confidential, Jun-2000 to Dec-2000

Project: BHP-Logistics
Role: Sr. Consultant

Description:
This system is developed for the Logistics Supply Tracking for BHP. It involves Data exchange and Integration between the Emrey Worldwide Logistics system GLS (Global Logistics Supply) and Global Supply Network with BHP for dealing with various details like PO, Shipment Details, MRPL, Notes, Shipment Docs. Microsoft BizTalk framework is used to achieve the integration process .The middle-ware used for the entire integration across the enterprise is Microsoft BizTalk server 2000. BizTalk Mapper has been used to convert the input flat files into XML documents in the BizTalk Framework and transfer them to the specified server based on the channel – port configuration in the BizTalk Server. On the receiver end the data in the XML file is extracted, which is updated/maintained in a database server.

Responsibilities:

• Developed component code for deploying components in BizTalk Orchestration Designer.
• Configuring the ports, channels, organization and document definitions.
• Designed work flows using orchestration designer, XML schema used for communication
• Interacted with client for gathering business rules and prepared design documents.

Environment: ASP, JavaScript, VBScript, SQL 7.0 Server, MS Project, Microsoft BizTalk server 2000,Windows NT Server

Confidential, India Jan-2000 to Jun-2000

Project: Real Estate Information System
Role: Developer

Description:
It extends Real Estate services, which include, Homes for sale Lease, Rentals, Mortgages, Financial Services etc. For Sellers this site gives the facility to register their homes with complete details. For Buyers it gives facilities wherein the buyer can specify the type of house he requires by listing his requirements. The Features, which make this, site one of the best Real Estate sites. Because of facilities like File Upload feature for uploading the Images by the sellers, Automatic Email update Feature for Sellers to acknowledge the listing of their house, for buyers all the matching houses with the specifications provided by him are mailed to him regularly.

Responsibilities:

• Involved in designing and coding the web pages for listing the all kinds of homes in ASP.
• Designed and coded uploading the image files functionality.
• Created unit test cases and tested unit test cases.

Environment: ASP, JavaScript, VBScript, SQL 7.0 Server, Windows NT Server

Confidential, India Jun-1999 to Jan-2000

Project: Agriculture Information System
Role: Developer

Description:
It is an Agricultural Portal, which covers Gamut of Information with regard to Indian Agriculture, Crops, Vegetable, Plants, Organizations etc. Crops, Vegetables Information like varieties available, soil types on which they can be grown Diseases/pests and their remedies. Covers Gamut of information with regard to Gardens, House plants, Ornamental, Medicinal Plants, etc. Different Agricultural Organizations/boards viz., Coffee Boards. National Horticulture Board etc. Financial Organizations, which provided finance facilities to Farmers with regard to Govt. Schemes. Different Vegetable/Plants, which can be grown in a household atmosphere, also provides the necessary inputs like the required space investment etc. It contains features like Message Boards, Site Search facility, Guest Book

Responsibilities:

• Involved in designing and coding for Guest Book Module in ASP.
• Coded for agricultural message board Module
• Wrote stored procedures and functions in SQL Server 7.0

Environment: ASP, JavaScript, VBScript, SQL 7.0 Server, Windows NT Server.