PROFESSIONAL SUMMARY

Hands-on information technology professional offering more than 15 years

overall IT experience encompassing project management, resource management,

business analysis, technical design, development, testing, and delivery of

results-oriented solutions that meet or exceed client expectations.

EDUCATION

Masters in M.I.S (Management Information Systems[pic]) North Central

College, Naperville, IL, USA

Bachelors in Chemistry[pic] University of Madras, Chennai, India

PROFESSIONAL EXPERIENCE

1 Northern Trust Bank, Chicago, IL - Applications Consultant - VP

February 2006 - Till Date

2 Risk and Performance team develops and maintains industry leading

analytical and reporting solutions to assist the asset owners and asset

managers. The comprehensive product suite provides data that includes

investment performance measurements, performance attribution metrics

and risk metrics across all asset classes (Equity, Fixed Income, Cash

Equivalents etc.), and in any currency from a global platform.

Enterprise Risk Services

ERS is an online web application for market risk solution for a myriad of

Northern Trust client base including hedged funds, custody and wealth

management clients. Risk offering will encompass (e.g. VaR, Stress Testing)

across all trade products.

3 Environment: MS Project, Java J2EE, JSP, JQuery, JDK 1.6, Web Logic,

Actuate BIRT, Oracle SQL Developer, TFS, ITSM Remedy 7.0, UNIX &

Windows 7

Northern Data Direct - Cutting Edge - DataDirect

Northern Data Direct API for performance data reporting solution populates

a client's desired risk and performance data directly into an Excel spread

sheet. The solution is being used by clients and partners in all regions

across the globe. This application is a .NET interface based Excel Add-in

accessing Java/.NET Web services layer and Oracle 11g, MS SQL Server 2008

databases in the back-end built using MVC design pattern.

4 Environment: MS Project, MS Visual Studio 2008/2010, C#, WPF, MVC, Oracle

11g (Exadata), Java, JDK 1.4, Web Logic Server, Web Services, MS Excel,

Oracle SQL Developer, PVCS, ITSM Remedy 7.0, UNIX & Windows 7

5 Custom Hierarchy

Custom Hierarchy is a tool used by Risk and Performance Analysts to define

reporting that is unique for each client based on the client's portfolio

structure, and not solely on industry driven benchmarks. The application

consists of online web application that provides interface for entering

transactions details, user/ report setup details etc. and the client server

application is user for client reporting setup. Eventual goal is to migrate

the entire application to a online web based solution.

Environment: MS Project, MS Visual Studio 2008/2010, C#, WPF, MVC,

PowerBuilder 9.0, Oracle 11g (Exadata), Sybase 12.x, Java, JDK 1.5, Oracle

SQL Developer, PVCS, MS Office, ITSM Remedy 7.0, UNIX & Windows 7

Executive Reporting

Executive Reporting is a comprehensive reporting solution completely

tailored to meet the staff, committee and executive board information needs

of the clients.

Environment: MS Project, PowerBuilder 9.0, Oracle 11g (Exadata), Sybase

12.x, C++, JDK 1.5, Business Objects XI, Oracle SQL Developer, PVCS, MS

Office, ITSM Remedy 7.0, UNIX & Windows 7

Responsibilities:

* IT Project Lead for suite of online web applications and client

server applications like Enterprise Risk Reporting Services,

Northern Data Direct, Custom Hierarchy and Executive Reporting in

the Performance Reporting team.

* Delivering enterprise software applications that meet user

expectations relative to performance, scalability, fault tolerance,

usability, and data integrity.

* Project and resource management of duties for a development team of

up to 15 resources based in Chicago, Mexico and India.

* Delegate and manage project tasks, ensuring on time delivery within

expected scope defined.

* Provide application architecture leadership and design best

practices to achieve code quality.

* Ensure compliance of established SDLC procedures and appropriate

usage of SDLC tools.

* Manage project task execution and monitoring, delivering action

plans and resolution.

* Mitigating risks and impacts to project resources, budget, and

timeline to ensure on time delivery.

* Gathering requirements from the clients through various

meetings/collaboration with the client team.

* Collaborate with other IT teams, communicating and negotiating

needs to achieve project goals.

* Create and maintain strategies and roadmaps, ensuring they align

with client and IT goals/strategies.

* Translate user requirements into prototypes that illustrate the

final result to business sponsors and stakeholders.

* Respond quickly to production issues. Assume ownership and take

responsibility to ensure the issues is resolved within SLA.

* Ensure all project documentation is properly completed and stored

in a centralized location for compliance.

* Recruit, establish goals, and coach team members.

6

7 Optech Consulting Inc - Consultant Technical Lead

Client: Wells Fargo Bank, San Francisco, CA November 2004 - January

2006

GUS - General Ledger Utility System

Environment: PowerBuilder 8.0, DB2, CICS, COBOL, Oracle 9i, Sybase SQL

Adaptive Server, MS Visual Studio 2003, C#, MS Visual C++ 5.0/6.0, UNIX &

Windows XP

Responsibilities:

In the role of Technical Lead/Sr. Programmer Analyst

* Oversaw the conversion of GUS system from PowerBuilder 8.0 to MS .NET

environment.

* Provided technical guidance and lead project development effort as

needed to junior resources.

* Gathering requirements from the client through various

meetings/collaboration with the client team.

* Writing technical documents for the development team and providing

clarifications when required.

* Involved in development, unit testing and deployment of GUS.

* Used OOPs concepts e.g. Inheritance, Polymorphism and Encapsulation

for creating objects, writing scripts and functions.

* Responsible for creating and modifying Windows, Window functions, User

Objects, UO functions, User Events and DataWindow.

* Responsible for modification and enhancement of C++ codes

* Part of production support team.

9 Optech Consulting Inc - Consultant Senior Programmer

Analyst

Client: Charles Schwab & Co., San Francisco, CA July 2003 -

November 2004

Mercury Phase III - Part 2 & 3

Environment: Java - JDK 1.4, JBuilder 9.0, JDBC, PowerBuilder 9.0/8.0,

Oracle 9i, PL/SQL, SQL Navigator, TOAD, MQ Series, StarTeam, UNIX & Windows

NT

Responsibilities:

In the role of Sr. Programmer Analyst

* Involved in Design, Development, Unit Testing and Deployment of

Mercury Phase III Part 2 and 3.

* Responsible for developing Proof of Concept to call Java methods from

PowerBuilder 9.0 and implementing PB to Java connectivity.

* Developed PowerBuilder code and proxy objects that call Java methods,

which validates data and returns it back to PowerBuilder GUI.

* Used OOPs concepts e.g. Inheritance, Polymorphism and Encapsulation

for creating PB objects, writing PB scripts and functions.

* Responsible new Windows, window functions, User Objects, UO functions,

User Events and new DW.

* Responsible for migrating application from PB 8.0 to PB 9.0.

* Wrote complex SQL queries and Oracle stored procedures.

* Performed the role of new version release manager.

10 Optech Consulting Inc - Consultant Senior Programmer Analyst

Client: Aventis Pharmaceuticals, Bridgewater, NJ May

2002 -May 2003

Midlink Home Office Application & Samples Report Application - Territory

Renumbering Project

Environment: PowerBuilder 6.5, Oracle 8.x, PL/SQL, JSP, JavaScript, JDBC,

HTML & Windows NT 4.0

Responsibilities:

In the role of Sr. Programmer Analyst

* Interviewing the end users to gather requirements and prepare

functional and design specifications documents.

* Used OOPs concepts e.g. Inheritance, Polymorphism and Encapsulation

for creating objects, writing scripts and functions.

* Coding stored procedures and complex SQL scripts which are used as

data source by the PowerBuilder report objects or to build data into

the tables.

* Responsible for rewriting/enhancing existing PowerBuilder reports.

* Coded Visual/Non-Visual user objects, UO functions, Window functions

and User events.

* Responsible for creating Java Server Pages Web Reports for the Samples

Report application using JSP, JavaScript and HTML.

11 Optech Consulting Inc - Consultant Senior Programmer Analyst

Client: Kraft Foods, Parsippany, NJ November 2001 -

March 2002

Data Mart Integration & Enterprise Portal

Environment: MS SQL Server 2000, DB2, MS Visual Basic 6.0, Active X, ASP

3.0, MS Visual Interdev, Site Server, PowerBuilder 8.0/7.0, PFC, Visio, &

MS Windows 2000.

Responsibilities:

In the role of Sr. Programmer Analyst

* Responsible for data analysis and writing MS SQL Server T-SQL stored

procedures, triggers and SQL scripts in the data mart integration

project.

* Involved in the support and maintenance of Sales Force Automation

application developed using PowerBuilder 8.0/7.0, PFC and MS SQL

Server 2000.

* Involved in the migration and maintenance of the application from

PowerBuilder version 7.0 to 8.0.

* Developed COM Objects using VB 6.0 for the Kraft Enterprise Portal

keeping in view the type of transaction (Required or supported).

1

12 Optech Consulting Inc - Consultant Senior Programmer Analyst

Client: Coca-Cola Corp., Atlanta, GA November 2000 - August

2001

Service Billing Profiles (Phase I) & Profit and Loss User System

Environment: PowerBuilder 7.0, PFC, Sybase 12 Direct Connect, Sybase T-SQL,

Oracle 8i/Gateway, PL/SQL, DB2, PVCS, Windows API, UNIX & Windows NT/95

Responsibilities:

In the role of Sr. Programmer Analyst

* Writing functional specifications and user requirements document.

* Was involved in the evaluation for PowerBuilder version 8.0

extensively.

* Coded complex PowerBuilder screens.

* Responsible for writing DB stored procedures, functions and SQL

scripts

* Used a variety of PFC Services e.g. application, data window, non-

visual objects and windows.

* Used Windows API calls through non-visual user objects to enable

deployment of new code and objects between two major application

releases.

* Provided user training

13 Optech Consulting Inc - Consultant Senior Programmer Analyst

Client: Cox Communications Inc., Atlanta, GA March 1999 -

October 2000

Pay Per View Monthly Analysis

Environment: PowerBuilder 6.5/PFC, Oracle 7.3/8i, PL/SQL, MS SQL Server

6.5, T-SQL, SQL Navigator 3.0, AS/400, ERWin 3.0, MS Excel, Visio, UNIX &

Windows 95/NT

Responsibilities:

In the role of Sr. Programmer Analyst

* Designed the PPV application to automate the processes involved in

generating invoices for various vendors.

* Used a variety of PFC Services e.g. application, data window, non-

visual objects and windows.

* Developed all the screens, data windows, user objects, functions and

reports.

* Wrote DB stored procedures and SQL scripts (team of 2).

* Used ERWin 3.0 for database engineering and data modeling.

* Provided user training.

1

14 Optech Consulting Inc - Consultant Senior Programmer Analyst

Client: Fiserv Inc., Pittsburgh, PA October 1998

- January 1999

Return Item Control System (RICS)

Environment: PowerBuilder 6.5, C++, Oracle 7.3, Sybase 11, Sybase T-SQL,

DB2, ERWin 3.0 & Windows NT

Responsibilities:

In the role of Programmer Analyst

* Created various user objects for the upload module of the data from

Sybase or Oracle databases to the mainframe system and vice versa.

* Wrote SQL scripts for RICS database schema and used ERWin 3.0 for data

modeling.

* Performed unit testing and created system documents for the

application.

15 Optech Consulting Inc - Consultant Senior Programmer Analyst

Client: FOX Broadcasting., Santa Monica, CA May 1998 - October

1998

FRED (FOX Research Express Data)

Environment: PowerBuilder 5.0/6.0, Sybase 11, Sybase T-SQL, Rapid SQL, 6.0,

MS Excel, UNIX & Windows NT 4.0

Responsibilities:

In the role of Programmer Analyst

* Created PowerBuilder reports for four rating types and ad hoc reports.

* Primarily used Infomaker 6.0 to generate reports.

* Responsible for testing FRED to ensure it delivered the correct

output, which was reflected in the reports. Tested all the report

modules rigorously.

Bharath Shipping Agency - Sr. Programmer, Chennai, India July 1997 -

February 1998

Custom and Central Exercise, FOREX, Payroll Management System

Environment: PowerBuilder 5.0, PFC, Oracle 7.x, Sybase SQL Anywhere &

Windows 95

Responsibilities:

In the role of Sr. Programmer

* Designed, developed, tested and implemented Custom and Central

Exercise, FOREX and Payroll system applications.

* Coded and tested the various complex screens of the front end

application in PowerBuilder.

* Created and coded various PowerBuilder reports.

* Wrote DB stored procedures and SQL scripts.

South India Systems - Programmer, Chennai, India November 1996 -

June 1997

Savings Bank Account, SCR (Service Concern Report)

Environment: PowerBuilder 4.0, Watcom SQL Server & Windows 3.1

Responsibilities:

In the role of Programmer Analyst

* Coded the various complex screens of the front-end application in

PowerBuilder.

* Created and coded various PowerBuilder reports.

* Involved in unit testing of the applications

Contact this candidate