Sql Server Project Manager

Bhrugu Giri

**** ****** *******

Apt **

Pine Brook, NJ 07058

Cell - +1-201-***-****

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

SUMMARY:

• 7 years of solid Core Java expertise with focus on Object Oriented methodology, multi-

threading, deadlock prevention, code base synchronization and design. Some experience

working on SWING.

• 7+ years of experience in Oracle Server and PL/SQL with additional experience on DB2,

Sybase ASE 12.5 and MS-SQL Server.

• 4+ years of experience managing and leading teams of varying sizes for projects ranging

from software development, infrastructure and deployment.

• 3+ years of experience with Autosys

• 2 years of experience with ETL using Informatica.

• Working knowledge of JMS and MQ Series with focus on enabling communication

between heterogeneous platforms.

• Working knowledge of J2EE components like JSP, Servlets, EJBs, XML and parsing

methodologies.

• Strong hands on experience on Design principles, application optimization and

performance analysis.

• Working experience on Equity Derivatives, FX products, Fixed Income and Equity sales

and research functional areas. Experience dealing with Business and FX Operations, and

Client Facing business users. Currently working in the Futures & Options Technology

team.

• Excellent communication skills. Adept at building strong work relationships with co-

workers, business users, clients and management.

SKILLS

• Languages: Java, PL/SQL, SQL, PERL, C#

• Databases: Oracle 9i, MS-SQL Server 2000, Sybase ASE 12.5, DB2

• OPERATING SYSTEMS: Unix, Windows9X/NT/2000/XP, Windows 2003 Server, Red

Hat Linux

• Software: Eclipse, BEA Workshop, MS-Visio, Autosys 4.5, BOXI R3, Xcelsius 2008,

Crystal Reports 10, Microsoft Project

• Tools: MS Visual Source Safe, Subversion

• Web and UI: JSP, HTML, ASP .Net, AJAX, JavaScript, SWING.

• Others: Object Oriented Programming and design, Agile methodology, MVC Framework,

UML,JDBC, Multi-threading, Java Servlets, JMS, XML, IBM MQ Series, IBM Websphere

5.1, Weblogic 8.1, JBOSS 4.0, Tomcat 5.0, MS IIS.

EXPERIENCE

Barclays Capital / Lehman Brothers, Jersey City, NJ 7/2007 – Present

Project Lead - Capacity and Performance Metrics, Application Management (Mar’09-

current)

• Identify key application performance metrics and indices for key applications under the

Application Management area for Prime Services.

• Build database schema and objects to store metrics and provide required data feeds

for analytics and graphical presentation tools.

• Design and build framework around capturing data from multiple sources like

Relational Databases (Oracle, Sybase, SQL Server, and DB2), AS-400 flat files and CSV

Data feeds using Core Java and PERL.

• Perform complex data manipulation / mining using Oracle PL/SQL constructs to generate

analytical data for presentation.

• Build graphical representation scorecards, dashboards and ad-hoc reporting using BO XI

3.5, and Xcelsius 2008.

• Build Data maintenance front-ends to manage configuration data, key SLA information

etc using Core Java, JSPs.

• Generate exception reports to notify missing data, other alerts using PERL and shell

scripting (bash).

Environment – Business Objects XI 3.5, Xcelsius 2008, PERL, Core Java, JSPs, Servlets,

Oracle, SQL Server, Sybase, Windows XP, Tomcat web server.

Senior Analyst / Developer - Futures Technology (July’07 – current)

• Analyze requirements and architect Java and ETL Informatica components for the futures

and options domain. Worked on Java business layer components to effectively collate

data from multiple sources to a central data repository and provide data extracts to down-

streams for further processing.

• Developed and designed ETL workflows for downstream position,activity, margin and

other business data file delivery for mission critical downstream reporting and client

statement delivery.

• Analyze requirements and architect solution for effectively managing the logging and

tracking of production services tickets and issues. Create UML use case and structural /

behavioral diagrams.

• Develop from scratch the Ticket Management System front-end, middle-tier components

using Core Java, JSP, Servlets and JDBC using key J2EE design patterns.

• Design and Develop a normalized and configurable database scheme for the Ticket

Management system in Oracle 9i.

• Deploy Ticket Management System on the JBOSS 4.0 application server.

• Generate Activity and Position reconciliation statements using Crystal Reports 10

• Follow firm approved standards and release procedures to roll-out the application to

internal business users.

• Provide Level 2/ Level 3 Support for applications under the Futures Technology space.

• Follow Agile SDLC to develop this application.

Environment – Core Java, JDBC, JSP, HTML, Servlets, Oracle 9i, MS-SQL Server 2000, DB2,

Informatica 8.1, DB Artisan, Eclipse, BEA Weblogic workshop 9.0, Windows XP, Linux, JBOSS

4.0, Rolfe and Nolan RISC 4.0, SunGard GMI Books and Records, PERL, Unix Shell Scripts and

UML.

Project Manager / BCP Engineer – Futures Technology Application Management (Oct’07-

Mar’08)

• Plan BCP and DR testing for multiple applications under the Futures and Options

Technology Application Management group.

• Interact on a day-to-day basis with various business and infrastructure teams to arrive at

consensus on the type of testing and also to design the series of events to execute the

DR Test

• Executed DR Testing for CLS (Continuous Link Settlement), TRAM (CityNetworks) and

CAMEO (firm proprietary) applications.

• Performance and scaling testing and design for multiple settlement and high volume

platforms.

• Publish results and resulting communication to major stakeholders (senior management

etc.) within the firm.

• Prepare documentation on follow-up actions for the subsequent DR tests to ensure

cross-team knowledge of the implementation.

Environment – Windows XP, Windows 2003, Microsoft Project 2002, Microsoft Visio 2003

I-flex Solutions Inc, New York, NY (Client - Bear Stearns Inc) 7/2006 – 7/2007

Programmer Analyst / Project Lead - Equity Sales

• Analyze requirements for the IEPL (Institutional Equities Profit and Loss) distribution

engine to be used by the Equities Sales and Research group at Bear Stearns.

• Participate in weekly meetings with key business and technology users to discuss the

current progress of the project and to gather feedback on any changes to the current

approach.

• Design the distribution engine using UML Use Case, Class and Sequence diagrams.

• Create pseudo-code documentation for developers within the team.

• Develop the core a multi-threaded distribution engine which intelligently determines the

distribution of client profit and loss based on various factors and sources using Core

Java, JFC SWING, JDBC and Design Patterns. This engine is executed in parallel by

multiple client front-ends at any given time to get daily snapshot of client P&L.

• Design and Develop database schema and stored procedures for the distribution engine

using Sybase ASE 12.5

• Design and Develop mail service implementation using Java Mail API for sending critical

notifications on the status of distribution engine process.

• Prepared weekly status reports for the management to keep them abreast with the

progress of the project deliverables.

Environment – Core Java, SWING, JDBC, Multi-threading and Synchronized code base, Java

Mail API, Sybase ASE 12.5, UNIX Shell Scripting, Design Patterns (Factory, Command, Business

Delegate), UML, Microsoft Project, UNIX, Windows 2000 Professional.

I-flex Solutions Ltd, Mumbai, India ((Client – State Street, Boston) 1/2005 – 7/2006

Associate Consultant / Team Lead - Investment Banking

• Design and develop multiple modules for the State Street Global Repository System

(GRS) including Investment Manager Trade Processing Attribute, Sender Management,

and Broker Maintenance / Client Maintenance applications using Core Java, AJAX,

JavaScript, iPlanet Application Server, JDBC, Synchronized code base for multi threaded

access and JSPs.

• Developed SWING GUI components for the application administration modules to

configure off the fly database and application level properties using layout managers, etc.

• Developed database tables, functions and stored procedures for the application.

• Prepared weekly status reports for the management / client to keep them abreast with the

project deliverables.

• Participate in weekly project progress discussion with on-site Project Managers and

business users to monitor application development and incorporate new changes.

• Created technical and user documentation for various modules to be used as training and

maintenance manuals.

• Lead a team of 3-5 developers.

Environment – Core Java, JDBC, JSP, Servlets, Design Patterns, JavaScript, AJAX and iPlanet

Application Server.

Accenture Services Pvt. Ltd, Bangalore, India 12/2003 – 12/2004

(Client – St. Paul’s Travelers, Hartford, CT)

Junior Software Quality Engineer - Homeowners Insurance

• Design and develop modules for the Test Harness application for underwriting engine

using Core Java, JDBC, Session Beans, Message Driven Beans, JMS and IBM MQ

Series.

• Implement synchronization in Core Java components to achieve multi-threading

capability and avoid potential deadlocking and data integrity issues.

• Develop database stored procedures and tables using Oracle 9i.

• Designed Unit and System Test Plans to document test cases in Mercury Test Director

• Designed and created multiple queues on the Websphere MQSeries Server using the

MQ Explorer

• Performed Unit, System and Performance testing using the test plans.

• Created Technical Specification Document for the Test Harness Application.

Environment – Core Java, JDBC, EJB, Message Driven Beans, JMS, IBM MQ Series,

Websphere 5.0, Mercury Test Director, Oracle 8i, Unix, Windows 2000.

NIIT Education Ltd, Udaipur, India 1/2002 – 6/2002

Programmer

• Develop from scratch the Online Testing Engine using Core Java, JDBC, SWING, and

JSPs

• Designed and developed database stored procedures and tables using MS-SQL Server.

• Designed Unit and System Test Plans to document test cases

• Performed Unit, System and Performance testing using the test plans.

• Created Technical Specification Document for the Online Testing Engine.

Environment – Core Java, JSPs, Servlets, JDBC, SWING, MS-SQL Server, SCO UNIX

Intech Systems Pvt Ltd, Ahmedabad, India 1/2001 – 12/2001

Programmer (Client - U’n’Us Super Stores, Ahmedabad, India)

• Gather requirements for the Stores Management Application for U’n’Us Super Stores.

• Design and develop from scratch the Purchase Order, Returns/Receipt and Inventory

Tracking and Cash Register applications for the store using Core Java, JDBC and JSPs.

• Design and develop stored procedures and tables using MS-SQL Server.

• Design Unit and System Test Plans to document test cases

• Performed Unit, System and Performance testing using the test plans.

• Created Technical Specification Document for the application

Environment – Core Java, JDBC, JSP, Servlets, MS-SQL Server, Windows 2000

Programmer (Client - Torrent Pharmaceuticals, Ahmedabad, India)

• Develop key modules in the Depot Information Tracking System project for Torrent

Pharmaceuticals using Visual Basic 6.0.

• Design and develop database stored procedures, tables, functions and triggers using

Oracle 7.3 over SCO Unix.

• Design Unit and System Test Plans to document test cases

• Performed Unit, System and Performance testing using the test plans.

• Created Technical Specification and User Manual Document for the application

Environment – Visual Basic 6.0, SCO UNIX, Oracle 7.3

E-Comm. Opportunities Pvt Ltd, Ahmedabad, India 6/2000 – 12/2000

Programmer

• Gather requirements and design the Customer Registration and Relationship

Management Application

• Develop from scratch the Customer Profile, Service Tracking and Complaint Tracking

modules using Core Java, Servlets, JDBC and HTML

• Created database stored procedures and tables using MS-SQL Server.

• Created Unit and System Test Plans to document test cases.

• Performed Unit, System and Performance testing using the test plans.

• Created Technical Specification Document for the application

• Environment – Core Java, JDBC, JSP, HTML, Servlets, MS-SQL Server

EDUCATION

July 2004 Symbiosis International University, Pune

Masters of Science Degree in Computer Applications, MSC (CA)

June 2000 College of Science Udaipur

Bachelor of Science Degree in Physics, Mathematics, Statistics, BSC

December 2000 NIIT Ltd (Diploma)

GNIIT Diploma in Software Engineering (Computers + Quality Management)

AWARDS & ACHIEVEMENTS

Super Troopers Award in Accenture for Exemplary Team Performance

Contact this candidate