Management Customer

SUMMARY

. Extensive experience in Information Technology Industry focusing on hands-

on application development, business analysis, project management, off-

shoring and vendor management.

. Excellent analytical skills and creative problem solving combined with

the ability to work at conceptual and execution levels while balancing

conflicting demands to achieve optimum performance with minimum business

disruption.

. Leverage organizational and communication strengths to lead requirements

analysis, reengineer business processes and deliver business-aligned

technology solutions.

TECHNOLOGY HIGHLIGHTS

Software: Oracle, PL/SQL, SQLPlus, SQLLoader, SQL Developer, Hyperion

Essbase, Clarity, Cognos, MS Access, Excel (VBA macros, pivots),

Hyperion SQR (Brio), MS Project, ERWin, Visio, Power Point, Visual

Basic, Crystal Reports, Shell, Perl, BMC Patrol.

Systems: Unix/Solaris, Unix/HP-UX, Linux, XP

EDUCATION

BS (Bombay University, India)

Certificate in Project Management (Middlesex County College) Working

towards PMP Certification

PROFESSIONAL EXPERIENCE

GAB Robins NA, Parsippany NJ Sep 04

- Present

Senior Business Systems Analyst

GAB Robins is a global claims management company providing loss-adjusting

and third party administration services, helping clients manage the total

cost of risk by developing and implementing workers' comp, general

liability, auto and property claims management programs while processing

close to $1 billion worth of claims.

. Working with the GMs of Sales and Operations in compiling revenue and

claim count projections by lines of business. Analyzing operating results

against prior year, budget and forecast to understand key drivers of

significant variances. Utilizing adhoc SQL to extract the information

from Oracle.

. Presented the business case to senior management to automate the complete

budgeting and forecasting process for all GAB's domestic and global

affiliates. Led the effort by using Essbase and Clarity (created

Applications, Databases, formulae and calc scripts) resulting in

efficiency improvement of more than 35%. Currently managing the outline

structures of the same.

. Designed and implemented ETL procedures to extract the GL (from

mainframe) and claims data (from Oracle) and upload into Essbase OLAP

cubes to facilitate reporting. Implemented Essbase Calc Scripts and

Macros (in Excel Add-in) and PL/SQL procedures for ETL.

. Acted as a liaison between Finance-Systems, Operations and IT (including

offshore teams) organizing and chairing various JAD sessions to elicit

and validate requirements and reduce scope creep. Mentored interns and

new recruits to reduce the learning curve and bring them up to speed.

. Functioned as a single point of contact for certain customer requests and

assigned them to the appropriate department in the ticketing system to

initiate the required projects, also involved in the UAT of these

requests. Created various Bordereau and Triangle reports for TPA

customers/carriers and their actuaries along with Loss runs and MIS

Scorecards using Hyperion-SQR Reporting. Designed Hurricane reports to

keep track of the Incurreds, Invoices and Temp Spend for each storm.

. Partnered with the pricing team and CFO to determine the ROI of various

customer accounts (by analyzing large volumes of historic data), which

led to GAB's non-renewal of 10% of accounts. Achieved 40% increase in

efficiency of the collection processes by implementing AR Aging Cognos

Cubes to track outstanding balances on all customer accounts by company.

. Coordinated the compilation of due diligence reports and presentations

for Board of Directors, Venture Capitalists and Banks. Partnered with the

Sales team to create historical claims analysis and visuals for RFPs and

Customer Presentations.

Entegra Technologies Inc, NJ

Aug 00 - Jan 03

Business Systems Analyst

Amoeba Telecom, NJ (now Isoftel Telecommunications)

Amoeba Telecom is an Infrastructure Management Solutions provider based in

India, which developed QoS Analysis, and SLA Management products for IP

based Data and Voice communication. The company's Convergence Traffic

Analysis Platform (CTAP) won the IP Telephony Solution of the Year Award in

the Year 2000.

. Functioned as the main US contact, focused on marketing a suite of

Service Quality Management products for the global convergence market

especially for new generation service providers using IP as the single

unified medium to deploy voice, video and data services.

. Acted as the interface between the beta customers and the offshore

development team for the design and development of the VoIP product,

which was written in C++ and Visual Basic. Gathered customization

requests from Beta-test customers and conveyed the same to the off-shore

team in India. Tested the changes before implementing at customer

locations.

. Orchestrated product demonstrations to prospective US based clients.

Facilitated easier flow of information between the customers and the

offshore product development team based in India for all product design

and development, customer communications and customization efforts.

RealSoft Inc, NJ

1996 - 1999

Senior Technology Consultant

AT&T WorldNet (Business IP Services), Middletown, NJ

. Involved in the complete SDLC of a web-based system to manage Business IP

services. Interfaced with AT&T Customer Care and other business units to

elicit requirements for the design and implementation of a Data Warehouse

encompassing all legacy data and interfacing with the Inventory System.

. Developed an in-house ETL tool for automatic data collection (customer

information, network configurations) from multiple sources (Access,

Clarify and Excel), transform the data to meet the needs of the system

and ease the distribution to downstream systems. Used SQL Loader for bulk

loads of massaged data from the various sources.

. Designed and implemented a Customer Usage Reports database (Oracle) to

contain terabytes of data. Designed and implemented database maintenance

utilities in shell and Perl to simplify the nightly/weekly NOC duties.

Interfaced with BMC in the setup of their software to monitor the

production database.

. Chaired JAD sessions and worked with departments across functional areas

to identify and implement best practices, while coordinating the

summarization and communication of the entire cross-functional

initiative.

CNA Insurance (Credit Insurance) Cranbury, NJ

. Participated in a team effort to develop a system that encompasses

complete policy processing - from the application at the customer

locations to the booking of the policy, and ultimately the draft

processing. The system links various agency offices and various branches

of CNA.

. Worked with the agents and underwriters in the requirements analysis

phase. Responsible for the logical and physical design of Oracle

databases, Data modeling using ERWin, front-end development in Visual

Basic using PL/SQL, Oracle stored procedures, triggers and ODBC/Windows

API calls (used in data transfer with OLE) to the Back-end Oracle

database.

On-lyne Systems

1992 - 1995

Analyst/Developer

Bank of Tokyo, Bombay, India

Lead role in a team effort to automate the manual payroll processing with a

Payroll/Personnel system encompassing the employee details, grades and a

corresponding link to the pay structure, monthly payroll and overtime

processing. It also included final settlements like Gratuity, Pension and

Super-Annuation. Involved in analysis and design, development,

documentation and end-user training. Used Crystal Reports extensively in

generation of financial statements and reports.

Chase Manhattan Bank, Bombay, India

The System generates Document Credits from Drawee Banks to the Client

Banks. This application accepts documents from Exporter's Client Banks (all

over India) at Chase Manhattan (Bombay), which are then verified. An

acceptance telex goes to the respective client banks with the appropriate

credits. TTS (Transaction Tracking System) was used to control

transactions. The system was used in Chase branches all over India and

Pakistan.

Contact this candidate