Project Manager Data

VIRAL DALAL

Technical Project Manager

PROFESSIONAL SUMMARY

Viral Dalal is a Decisive, Action oriented and results focused professional

offering 10+ years of experience is various industries, focused primarily

on Project Management, analysis and coordination. Offering outstanding

talent in leading projects, resourcing, documentation, analyze

requirements, and extensive technical hands-on experience. He has

demonstrated excellent skill in project planning, analysis, coordination

and thorough implementation of variety of aggressive IT projects.

TECHNICAL SKILLS

Reporting Tools / OLAP Hyperion Essbase 6.5.4, 7.5.4, 9.3, Essbase Integration

Services 6.5.4, 7.5.1, 9.3, Essbase Administration

Services 7.1.3, 9.3 Hyperion Planning 9.3, Business

Objects XI

Languages C, C++, SQL, PL/SQL

Operating Systems Windows 98/ XP /NT 4.0/2000, UNIX, Redhat Linux 7.3

Databases Oracle 7.3, 8.0, 8i, 10G, DB2 7.0, Microsoft SQL Server

7.0, MS Access 2000, Visual FoxPro

GUI Visual Basic 4.0, 5.0 & 6.0, Developer 2000

Project Management Tools Microsoft Visio 2000, Designer 2000, Microsoft Project

ITSM Tools Clarify 3.0, Remedy, GE Support Central, IBM Clear

Quest, IBM Clear Case

EDUCATION

Master of Science in Computer Science Fairleigh

Dickinson University, Teaneck NJ

PROFESSIONAL EXPERIENCE

GE CAPITAL SOLUTIONS

Norwalk, CT

Technical Project Manager

July 2008 - Present

GE Capital Solutions offers various financial services to its clients

around the world. Goal of the project at GE was to develop and implement a

Planning system. This was achieved in June 2009. My current responsibility

is to lead the development team and multiple businesses (12 businesses) to

get them on a single Hyperion platform. Currently I am working extensively

with the business users and development team as a Project Manager and

coordinator.

Responsibilities:

. Managing and leading offshore development team

. Directing and coordination with on-site development team

. Direct reporting to the Project Sponsor and the Finance Directors

. Team coordination and daily status reporting

. Very strong technical and business understanding

. Working as a bridge between business users and the development team

. Responsible for getting the application to production environment

. Taking ownership of issues and working towards resolution

. Responsible for meeting all delivery deadlines

. Managing and planning multiple iterations of user testing in global

time zones

. Preparing entire project testing and implementation time line

. Strong communication and high level understanding is part of the

responsibility

. User requirement gathering and preparing requirement definition

documents

. Conducting multiple user training sessions globally

. Planning and conducting entire User Acceptance Testing for the

application

. Accommodating new user requests using GE Support central

. Extensive work with Technical and Business teams for issue resolution

. Provided Accurate and timely resolution

. Ad-hoc update calls and stand-up meetings with the Program Manager

. Performing under extensive work pressure and multiple major tasks

. Preparation of entire data dictionary for the application

Achievements

> Taking ownership of issues and getting the resolution

> Successful deployment of new Planning system for Canada and

Franchise business

> Successful approvals and sign-off from Canada and Franchise

businesses

> Successful implementation of GECA platform

> Successful approvals and sign-off from 12 GE core businesses

> Successful user training for 150+ users

> Showcased very positive approach towards assigned tasks

Environment: Hyperion Essbase System 9.3, Hyperion Planning 3.5.1, 9.3,

Essbase Integration Services 9.3.1, GE Support Central, Oracle 10G,

Microsoft Project 2007, Microsoft Excel SmartView, Microsoft Windows XP

Professional

FANNIE MAE

Washington, DC

Project Coordinator / Technical lead

Oct 2006 - May 2008

Fannie Mae is one of the largest home mortgage companies in the United

States. It is a shareholder-owned company that works to make sure mortgage

money is available for people in communities all across America. Goal of

the project at Fannie Mae was to develop a reporting database from scratch,

and then convert those multidimensional reports into user-friendly canned

reports using Business Objects.

Responsibilities:

. Working as Project coordinator and project lead for the on-site

development team

. Extensive work as a technical and functional resource for the

Business users

. Hands-on work with the data warehouse and financial reporting

. Preparing Requirements definition document for all new Business

Objects reports

. Preparing Conceptual Design Document and data dictionary from

scratch

. Preparing test cases for the reports which were migrated to

Business Objects

. Designing and executing multiple UAT test plans/cycles

. Handling frequent business requirements changes before production

migration

. Converted 2006 multidimensional database into flat file format and

loaded to the Oracle data warehouse

. Resolving and documenting the defects/ enhancements for current

Essbase reports including drilling down data from Oracle GL

. Handled numerous migrations from testing to production environment

. Worked simultaneously with various phases, from requirements

gathering to system build and test

. New BO XI (Business Object Version 11) requirements gathering done

for developing the same report in Business Objects (Earnings Per

Share model)

. Documenting and resolving new enhancements/defects for Business

Objects reports

. Tying GL Reports with 10K - 10Q reporting logic and reporting the

defects

. Created new procedures and updated SQL retrieves in data warehouse

such that calculations are done before data load

Achievements:

> Successful implementation of RS_ASM Essbase model

> Successful RS_ASM migration to Business Objects reports

> Achieved sign off from all business users

> Successful production migration of Business Objects reports

Environment: Hyperion Essbase 7.1.5, 9.3, Essbase Integration Services

7.1.5, 9.3, Oracle 10G, Microsoft Excel 2007, Microsoft Windows 2000, IBM

Clear Quest, IBM Rational Clear Case

ALCON LABORATORIES

Fort Worth, TX

Functional lead/ Sr. Developer

June 2006 - Oct 2006

Alcon labs, is one of the leading manufacturers of surgical lenses and eye

care products. Alcon business is centered on three key divisions -

Surgical, pharmaceutical and Consumer vision care. Goal of the project was

to provide support for the existing structure, while developing plan for

tuning and optimizing the multi-dimensional database.

Responsibilities:

. Providing online support for the production environment

. Creating and implementing entire project plan for disaster recovery

. Created and implemented cube backup plan

. Preparing Conceptual Design Document for all the cubes

. Extensive work with Essbase administration, user privileges,

creating filters, tuning and optimization of cubes

. Designing and executing UAT test plans

. Resolving and documenting the defects/enhancements

. Preparing System Requirement Specification documents for all the

cubes

. Developing new formulas to avoid calculation script delays

. Created new procedures in the data warehouse so that the

calculations are done before data is loaded

. Investigating and fixing the errors which caused incorrect numbers

. Being in sync with the Data warehousing team and discussing the

changes

. Created SQL server batch scripts to BCP out data to the Essbase

server

. Extensive work with load rules for clearing dimensions and loading

members and data

Achievements:

> Significant reduction in calculation time achieved

> Resolved various defects and enhanced the existing application

> Helped implement the newly developed system

> Implemented optimized cube structure into production

Environment: Hyperion Essbase 7.1.3, Essbase Analytical Services 7.3.1,

Hyperion reports 7.1.3, SQL Server 8.0, Microsoft Excel 2003, Microsoft

Windows 2000

GE COMMERCIAL FINANCE

Stamford, CT

Essbase Technical Lead

Oct 2003 - May 2006

GE Commercial Finance offers various financial services to its clients

around the world. The goal of the project at GE was to develop and

implement and maintain a robust Hyperion Essbase reporting platform for the

business users for their monthly, quarterly and yearly financial reporting

purposes.

Responsibilities:

. Extensive development work for improving the current system

. Preparing requirement specification documents for existing

structure

. Preparing requirements definition document for all financial

reports

. Designing project plan to make sure that the current system does

not crash

. Preparing Conceptual Design Document for finance cube

. Preparing test cases for the multiple reports which had new

calculations

. Designing and executing multiple UAT test plans/cycles

. Working closely with off-shore supporting team and coordinating the

resources

. Extensive work with Essbase administration, User privileges,

creating filters, tuning and optimization of cubes

. Testing the existing calculation scripts and data with different

cube settings

. Entire cube structure was changed to tweak the calculation time

. New format to be accommodated in the existing cube keeping

historical data intact

. Monitoring to be done around the clock (on - call)

. Investigating and fixing the errors which caused incorrect numbers

. Creating and implementing entire project plan for disaster recovery

. Created and implementing entire cube backup plan

. Being in sync with the Oracle (Data warehousing team) and

discussing the changes.

Achievements:

> Development and maintained the reporting environment for 3+ years

> Significant (50%) reduction in calculation time achieved

> Resolved various defects and enhanced the existing application

> Disaster recovery plan implemented

> Cube backup plan implemented

> Robust reporting platform incorporated

Environment: Hyperion Essbase 7.5.4 (XTD), Hyperion reports 7.5.4(XTD),

Oracle 9i, Microsoft Excel 2003, Linux, Microsoft Windows 2000

UNITED HEALTH GROUP Minnetonka,

MN Essbase Developer

May 2003 - Sept 2003

United Health Group is a group of companies, which include United Health

Care, Ovations Uniprise, Specialized Care Services, Ingenix and various

other business segments. The aim of the project at United Health Group was

to provide top management and end users with a fully functional data

warehouse for each of the business segments separately and as per the user

requirements.

Responsibilities:

* Installed (and upgraded) Hyperion Essbase, Essbase Integration

Services

* Developed EIS Meta-outline for various cubes

* Created various filters as per user requirement in EIS

* Performed member loads and data loads successfully for various

cubes created

* Analyzed all dimensions and members in Essbase outline

* Performed tuning by using the Dense/Sparse settings and developed

the required alternate roll-ups

* Designed and developed numerous complex Essbase applications with

excellent balance of dense and sparse settings

* Developed Calculation scripts and optimized it according to the

Essbase outline

* Performed SQL tuning to minimize data load timing. Excellent gain

in performance recorded

* Involved in defining requirements, functional specifications,

design documentation and test strategy

* Involved in weekly status meetings, documentation and status

reporting

* Developed various load rules for previous year's data, current

year's data and forecast data

* Developed SQL to extract data from Oracle to the data warehouse

* Verified data tie-outs to make sure that the data in Oracle matched

the data in data warehouse.

* Handled and successfully completed change requests for various

cubes

Environment: Hyperion Essbase 6.2, Hyperion Analyzer, Hyperion Reports 2.0,

Essbase Integration Services 6.2, Microsoft Excel 2000, MS SQL Server 7.0,

Windows NT 4.0, Unix

COPE INSTITUTE

New York, NY

Data warehousing consultant / Trainer

Sep 2000 to Dec 2000

Responsibilities:

* Defining the logical warehouse objects

* Create a set of definitions for a logical warehouse schema, its

data sources, target and the operations that map, transform, and

populate a warehouse

* Created mappings from flat files to Data warehouse (Oracle), (other

data sources included Various Databases, flat files, data marts,

ETL jobs etc)

* Tuning the Warehouse performance by controlling the proliferation

of data marts

* Creation of star schema, Dimensions - tables, Indexes on tables to

improve the performance of queries running against the Database.

Used the Informatica Session Manager to create and run the sessions

for loading data using the mappings created

* Imparted training to a class of 18 students

* Creating, Maintaining and monitoring the databases of development

and testing environments

* Optimizing database performance and use of resources, Fine Tuning

Performance

* Optimizing SQL Queries for better performance

Environment: Informatica Power Mart 4.7, Informatica Power Center 1.7,

Oracle 8i.

TRIVEDI INFO. SOLUTIONS

Ahmedabad, India

Programmer / Trainer

May 1998 to Aug 1999

Responsibilities:

* Designed and developed Graphical User Interface using Forms

* Developed the PL/SQL stored procedures for implementing the

business logic

* Developed the on-line context-sensitive user help

* Development of reports (stores ledger, invoice preparation) using

reports 3.0

* Developed test plans for invoice, order entries, billing, shipping,

and Stock maintenance

* Imparted training for Oracle and Visual Basic

* Conducting Functional testing, System testing and GUI testing

* Tested the functionality by creating dummy transactions

* Manually tested different reports generation

* Created Packages, Procedures and Functions

* Configure Oracle Clients on Win NT Workstations

* Constructing Oracle Database Triggers and Indexes

* Oracle Administration: Creating, Modifying and Deleting user

accounts

* Granting Roles and Privileges to Users

Environment: Developer 2000, PL/SQL, SQL, Oracle7.3 and Windows NT, Visual

Basic 5.0

Contact this candidate