Sql Server Data

Sanjiv Prakash

**** ******** *****, ***** ****** VA 22043 ? 703-***-**** ? Cell: (703) 395

**** ? E-mail: *************@*******.***

Professional Summary

. Expert in Business Intelligence application analysis, selection and

implementation and maintenance efforts.

. Recognized for strong client relationship management skills coupled with

consistent performance that exceeds client expectations.

. Proven track record in requirements gathering, design and implementation

of reporting solutions that ensure users' functional requirements are

met in a safe and secure environment.

. Resourceful and creative thinker with strong analytical problem solving

skills.

. Excellent interpersonal skills. Ability to establish strong rapport with

all levels of management, user community and technical specialists.

. Strong verbal and written communications skills.

Business Intelligence Platform and Project Management Areas of Expertise

Research ? Analysis ? Architecture ? Design ? Implementation ? Administration

& Maintenance ? Training

? Data Management ? Vendor Management ? Budgeting ? Project Management

Technical Skills

Operating Systems: Windows 2003 Server, UNIX

Programming Languages: ASP.NET, Visual Basic

Business Intelligence/Reporting Platforms: Business Objects XI 3.1, Data

Services 3.1, Web Intelligence, Crystal Reports XI, Hyperion/Brio, Web

Focus

Databases: SQL Server 2005/2000, Oracle 11/10g, Sybase 10.0

Miscellaneous: IIS, Tomcat, VMware

TIME WARNER INC. & AMERICA ONLINE INC.

nEW York, NY & Dulles, VA

Senior Technology Analyst/Senior Software Engineer

6/2002 to Present

Manage Business Intelligence Platform

. Sole administrator of the Business Objects BI/ETL platform at TW

Corporate IT. Architected and implemented the user access design for 165

users and 12 development groups on the platform.

. SME/Consultant for the BI/ETL platform to other TW Corporate IT

application groups.

. Manage vendor relations and budgeting process for ongoing licensing

requirements for the platform for TW Corporate IT.

. Evaluated, recommended and led the Business Objects upgrade to v3.1,

including moving to a Java deployment and utilizing a blend of IIS (web

server) and Tomcat (application server) for single sign on.

. Coordinated the virtualization of the BI platform with the IT Operations

group.

Design the data exchange system between external Travel & Expense provider

system and all TimeWarner divisions

. Designed and implemented the ETL processes and data mart that:

o Gather and consolidate daily configuration data from divisions to

provide to the T & E vendor

o Receive daily data generated from the vendor system and process into

the data mart

o Provide monthly extracts to an external source for integration and

processing in the finance system

Provide new reporting capability to World Wide Recruitment and Executive

Search

. Designed and delivered an in-house solution to provide recruitment data

to an external on-boarding system, saving $20,000 and the associated

annual maintenance for this integration, if it were implemented by the

recruitment system vendor.

. Created new universes and reports on the BI platform against the

proprietary Encore database providing reporting capabilities such as

report scheduling, currently not available on Encore, a third-party

application.

. Designed a solution for hosting reports on the BI platform and

integrating user access in the Encore product by leveraging the OEM

version of Crystal reports in .NET instead of acquiring additional

Business Objects licenses for infrequent users. When implemented, this

will lead to a cost saving of $30,000, with additional annual

maintenance savings of $6,000 for 5 users.

Design and Manage Recruitment Metrics Data Mart and reporting across all

TimeWarner divisions

. Designed and implemented the ETL import processes for incoming BrassRing

recruitment data and the underlying recruitment metrics data mart

supporting the reporting system using Data Services.

. Seamlessly migrated recruitment reporting from Web Focus to the Business

Objects platform.

. Designed and deployed OFCCP reporting for federal compliance for Time

Warner Cable to provide self-service reporting at a sub-divisional

level, decentralizing the reporting and reducing divisional work load.

. Created training material and trained recruitment end-users for all

TimeWarner divisions in developing Web Intelligence reports to support

self-service reporting for recruitment metrics.

. Designed universes and reports to support the reporting environment for

AOL, Warner Brothers, Time Inc., Time Warner Cable, Turner Broadcasting,

HBO, New Line Cinema and OFCCP (Office of Federal Contract Compliance

Programs) reporting for Time Warner Cable.

. Architected a scalable user access environment on Business Objects

providing for inter-divisional isolation of data at various levels of

hierarchy.

. Created a project charter, developed the budget and managed the project

to acquire new hardware, software licenses and the install and

configuration of the BI platform.

. Led research, evaluation and selection of a standard BI/Reporting

platform across TW Corporate IT. Worked with various IT teams to test

Business Objects and gather consensus on this selection.

. Converted reporting system (to MS SQLServer and Web Focus) to provide ad

hoc reporting capability. Created training material and trained all

divisional users in creating reports on the Web Focus ad hoc reporting

environment.

. Designed and developed the recruitment metrics reporting data mart and

reports using Hyperion/Brio on Sybase database to provide published

reports to all TimeWarner divisions.

ICON MEDIA LAB (Formerly Insight Technology Group, St. Louis, MO)

Brussels

Computer Associates International and CMSI Inc. (Landover, MD)

Senior Consultant / Software Consultant at Discovery Communications

Inc. 5/1996 to 6/2002

Responsible for designing and developing a suite of custom reports using

Crystal Reports and managing the underlying reporting database schema on

Oracle and SQL Server to support the reporting needs of the Ad Sales and

Programming groups of a major cable network client.

. Developed a process to support overnight data transfer from Oracle to

SQL Server

o Identified, evaluated and implemented the Oracle Transparent Gateway

for automated data transfer to synchronize the Ad Sales and Programming

data for reporting.

. Analyzed and planned upgrade of all existing reports from Crystal 5 to

Crystal 8 including impact analysis on

the underlying database using CAST.

. Supported end-user group using Brio/Hyperion as the reporting tool on

an Oracle 8 database.

. Deployed the reporting database schema, designed using Erwin, migrated

legacy data from existing Paradox

systems to Oracle 7 and SQL Server 6.0.

. Designed and implemented Visual Basic 5 applications to support older in-

house applications' connectivity to upgraded vendor applications,

specifically tying in the in-house reporting application to Gabriel, a

third party application.

MIACO CORPORATION (Landover, MD)

Software Consultant

10/1995 to 5/1996

. Developed course work and end user training materials to support an Ivy

League university in Oracle Government Financials.

INSYS, INC. (Olney, MD)

Programmer Analyst 1/1995 to 9/1995

. Developed financial application for a bank utilizing PowerBuilder

Enterprise on an Oracle 7 database.

. Developed and tested an application that translated Sybase 10.0 Transact-

SQL to Oracle 7 PL/SQL.

Education

Masters in Computer Science, George Mason University - Fairfax, VA

1994

Bachelor of Mechanical Engineering, Manipal Institute of Technology -

Manipal, India 1985

Contact this candidate