Project Manager

Ravi Gururaj Singit

Summary:

More than ** years of progressive experience in Information Technology,

Project and Operational Management focusing on Data Warehousing & Business

Intelligence space. Major strengths are Process and Technology Management

with a strong focus on continuous improvement. Lead several end-to-end

enterprise data warehouse and business intelligence projects from inception

to deployment.

Proven track record in organizational development and operational

efficiency, demonstrated abilities in:

. Policy and Procedure Development

. Relationship Management

. Productivity and Process Improvements

. Vendor Management

. Team Building and Employee Development

. System Architecture & Implementations

. Operational Management

. Technology Management

. Strategic Planning

. Extensively exposed to business analysis, business interface,

requirements gathering, data analysis, scoping, resourcing, design &

data modeling, development, data quality & security strategy, process

re-engineering.

. Efficiently lead Data Warehouse and Business Intelligence projects in

all the stages of the System Development Life Cycle from Project

Initiation, Scoping, Risk Analysis, Scheduling, Effort and Cost

Estimating, Requirement, Design and Development through Deployment.

. Played key role in the global organization under various capacities

including Project Lead, Business Analyst, Technical / Solutions

Architect for DW & BI Solutions on both support initiatives and

development projects.

. Has high knowledge in Retail, Healthcare, Technology and Finance

domains having worked for organizations like Nike, Kohl's, Target

Corporation, HEB, Medtronic Inc, SAP Inc, Microsoft and Citibank NA.

. Well versed with Data Warehousing concepts of Star and Snowflake

Schema, Dimensions, Facts, KPI... etc

. Effectively managed lead roles in business interaction identifying

business impacts of application behavior, validating and verifying

data models, data analysis and reconciliation, exception handling and

non functional requirements.

. Hands on development in Informatica, Cognos, Business Objects, Crystal

Reports, Micro Strategy, SAS along with strong exposure to PL/SQL on

Teradata, Oracle and SQL Server databases.

. Managed and executed software and hardware upgrade projects on both

ETL and BI applications.

. Managed major performance improvement initiative on Enterprise Data

Warehouse and Business Intelligence applications working closely with

vendor consultants like SAP, IBM and Oracle.

. Holds Brainbench certification on Project Management (2005), Business

Communication and Customer Requirements Analysis and Informatica

Certified Developer; certificate number 179612.

. Nominated for 'Medtronic Inc - CIO award' for contribution Process

Consultant in re-engineering the Business Intelligence process using

Lean Sigma technique.

Technical Skills

Operating Systems: Windows, Unix

Databases: Teradata, Oracle 8i/9i/10g, SQL Server, DB2 on Unix and DB2

Mainframe,

ETL Tools: Informatica, Data Stage, Microsoft Analysis Services

OLAP Tools: Cognos, Business Objects 6.5.1 & XIR2, Crystal Reports 2008 &

11.5 MicroStrategy 8.1.1

Languages: PL/SQL, UNIX Shell Scripting

Others: Erwin, Data Modeling, Maestro & ESP Scheduler, PVCS, Mainframe

Ravi was nominated for Medtronic Inc - CIO award for his significant

contribution as Business Objects BI Process Consultant in effectively re-

engineering the Business Intelligence process using Lean Sigma technique.

Also was awarded with SPOT cash award for his contributions.

Work Experiences:

Project Title: Nike Planning IT Projects

Client: Nike Inc

Duration: 08/03/2010 - current

Role: Senior Business Analyst

Environment: Cognos, Teradata

Project Description

Various projects for Nike demand fulfillment team on enhancing and

developing various Teradata data marts and Cognos reporting solutions.

Responsibilities:

. Facilitate requirements elicitation sessions for new and upgrade

applications.

. Showed Strong business acumen to quickly learn new business processes

and understand how IT needs to support the business in achieving

revenue and profit goals.

. Proven ability to pull a diverse group of individuals with different

goals together and facilitate productive discussions.

. Demonstrated leadership capability, including ability to motivate and

mentor others within work group. Ability to work with onshore/offshore

teams, and communicate using virtual communication tools (phone,

conferencing, online meeting).

. Deep knowledge and hands on creation of key artifacts including uses

cases, user acceptance criteria and functional specifications

. Liaison between the business units, technology teams and support

teams.

. Translated business functionality and opportunities into clear,

precise and easy-to-read functional specifications.

. Perform & coordinate user acceptance testing. Plan and track schedule

and cost, report and escalate status through appropriate channels to

senior management.

Project Title: SAP GD Citi Crystal Migration

Client: Citibank N. A.

Duration: 01/11/2010 -05/31/2010

Role: Project Lead

Environment: Crystal Reports 2008, Oracle 8i, 9i, 10g, SQL Server 2005

Project Description:

The project is about migrating an application (560 reports) that is

currently built using PowerBuilder and Actuate tools. The application is

being used across the world and in all the languages. The project is

executed for Citibank NA, New York on behalf of SAP Global Delivery, New

York from SAP GD office in Bangalore by Cognizant.

Responsibilities:

. Prepare and execute development project plan.

. Analyze, document the AS-IS system by interacting with SAP GD and

Citibank NA SMEs on existing application.

. Design solution implementation approach to migrate application to

report using Crystal Reports.

. The responsibilities also included develop and manage the requirement

specification document with approval from Citibank.

. Interact with different business units that are impacted by the

reports migration.

. Analyze the impacts from other upstream and downstream applications.

Develop, unit test and deliver the upgraded application to Citibank

NA.

. Provide daily project status to SAP GD and Citibank NA. Make necessary

resource changes to meet the schedule and cost of both SAP GD as well

as Citibank NA.

. Manage SAP GD resources and define roles and responsibilities on the

project.

Project Title: EIM BI

Client: Collective Brands Inc

Duration: 05/16/2009 - 11/15/2009\

Role: Project manager and technical architect

Environment: DB2 on Mainframe, Micro Strategy

Project Description:

Enterprise Integration Management and Business Intelligence group of

Payless wanted to build retail analytics application for recently acquired

Stride Rite Corporation on the existing platform. The current Stride rite

application is on excel and access database. The project is to build a data

mart for Stride Rite retail analytics replicating the scaled down version

of existing payless data model. The data load was built using DB2 SQL and

UNIX scripts executed using Mainframe jobs.

Responsibilities:

. Prepare maintain and implement project plan, assessment, analyze and

understand payless Decision.

. Support System architecture. Design, requirement gathering, analysis &

requirements validation, validate data model, validate view

definitions and provide consulting inputs to schema changes and data

model changes.

. Perform data profiling, complete data analysis of the existing as-is

stride rite retail analytics system by working with payless SMEs.

. Work with payless and finalize data model for stride rite retail

analytics application.

. Develop & validate the SQL, UNIX scripts. Unit testing, coordinate

system integration testing and UAT co-ordination with Stride rite and

Payless business SMEs.

. Post and pre Implementation support plans along with production

deployment. Submit project status reports on periodic basis.

Project Title: Merchandise App Development Project

Client: Kohl's Corporation

Duration: 12/16/2008 - 05/08/2009

Role: Project lead and Technical architect

Environment: DB2 Sql Scripts on UNIX, Unix Shell scripting, Informatica,

Crystal reports 11.5

Project Description:

The merchandising management group at Kohl's corporation wanted to build

Size Pack application

The current pack optimization engine is integrated into Kohl's new Order

Optimization and Allocation applications, however not all business cases

are adequately supported. This is a continuation of the Size/Pack

initiative for Kohl's.

The merchandising management group at Kohl's corporation had initiative to

create reporting applications on comparative merchandising sales, pre-

season assortment. It involved building 14 comparative reports and 4

complex static reports spanning three different applications. The major

challenge on these reports is most of reporting needed to be done on top of

application database as the business wanted real time data for quick

decision making on markdowns considering the precarious market conditions

apart from technology challenges of dealing with raw data. The approach was

to call stored procedure through the Crystal reports to access data across

multiple applications.

Responsibilities:

. Interacting with business in requirement gathering, design and develop

data mart and data extraction process from EDW. Plan, track and manage

development and implementation schedules.

. Develop and code Informatica mappings and workflows.

. Extract application transaction data using DB2 Sql script and Unix

scripts.

. Facilitate Unit testing and coordinated system integration testing and

UAT by business users.

. Manage change requests and enhancements for the application. Submit

project status reports on periodic basis.

. Assessment of AS-IS BI architecture. Interact with business interface

and business entities to understand the expectations.

. Responsible for Design of all reports, planning, tracking and managing

the report development and implementation schedules.

. Develop and design the very complex reports, performance assessment

and tuning of the reports based on the user feedback and managing

change request and enhancements for the KMM reports.

. Facilitate Unit testing and coordinated system integration testing

and UAT by business users. Manage change requests and enhancements

for the application.

. Submit project status reports on periodic basis.

Project Title: HEB DW & BI Projects

Client: HEB Grocery Stores

Duration: 01/21/2008 - 12/12/2008

Role: Project Manager and Business Analyst

Environment: Consulting, Architecting & Design, Informatica, Oracle 10g,

Micro Strategy 8.0.1,

Project Description:

HEB DW&BI team had various initiatives in upgrading the existing

applications along with changes needed as per the new business policies

adopted by the business. Operating Excellence Initiative (OEI) :

Performance Summary data for each Region and Store that is resulting in

consumption of human power. The Showtime Event Scheduling System (SESS)

seeks to leverage the Event Data Entry Platform for process management,

automation, data integrity and show time program administration. This

system will facilitate planning, booking and execution of Showtime

Campaigns and Selling events, currently HEB is generating these reports in

excel format manually which is resulting in: Reports data is not accurate

due to the manual intervention, HEB Partners, Vendors are not able to view

the reports at their convenience which is causing delay in Business

decisions and performance management of the partners.

Responsibilities:

. Preparation of project plan, requirements analysis and functional &

technical specification finalization, approval of functional &

technical design documents, manage and control application

development. Design and develop ETL process.

. Develop and code Informatica mappings and workflows.

. Extract application transaction data using DB2 Sql script and Unix

scripts.

. Build a BI solution by automating the report generation, execution and

distribution through Micro Strategy.

. Validate the Informatica design, monitor and manage implementation

schedule.

. Analyze the data model and propose necessary changes, create metadata

layer in Micro Strategy Desktop 8.0.1.

. Manage creation of required metrics, filters, reports and documents in

Micro Strategy Desktop 8.0.1.

. Manage and control resourcing and adjust the delivery schedule and

communicate the changes to stake holders.

. Submit project status reports on periodic basis.

Project Title: Inventory Accounting & Analytics

Client: Target Corporation

Duration: 08/02/2007 - 01/10/2008

Role: Project manager/Business Analyst/ Technical Architect

Environment: Consulting, Shell Scripts, DB2 Sql scripts, Data Modeling,

Micro Strategy

Project Description:

The project is an in house project for a business unit of Target

Corporation. Develop and implement efficient solution for reviewing,

analyzing and reporting store/warehouse stock shortage and related data in

cycle inventory accounting systems. The application suite addresses need

for data repository for enterprise wide Inventory analysis and accommodates

accelerating org growth, improve inventory data reconciliation.

Responsibilities:

. Manage stake holder's expectations by arranging meetings and

understanding the objectives.

. Prepare project charters and project plan. Identify the KPI's and

present to stake holders. Explore and Partner with global vendors to

provide project support at significant cost savings.

. Complete end to end project responsibility of leadership and solution

for the Inventory Accounting and Analytics application.

. Interact with business & communicate application impacts of the

application on business apart from requirement gathering, data model

design and development, non functional requirements.

. Coordinate and facilitate user acceptance testing. Interact with the

business analysts & users for upstream and downstream application

impacts and data impacts.

. Arrange meetings with all stake holders and present periodic status

reports.

. Coordinate vendor meetings and validate against organizational

policies on contracting.

Project Title: Research & Planning Application

Client: Target Corporation

Duration: 10/25/2006 - 07/29/2007

Role:

Environment: Data Modeling, Shell Scripts, DB2 Sql scripts, Micro Strategy

Project Description:

The Research and Planning application (RPA) will replace the Microsoft

Access Data and Application data bases that are used today with an

integrated application suite. The application suite will combine and

enhance existing and new store market strategy plans and an external GIS

application providing flexibility for future offshore expansion.

The new system will accommodate the accelerating store growth, improve

sales forecasting accuracy, track market densification and incremental

sales, and integrate new, remodel, existing store strategy, and sales

performance programs.

Responsibilities:

. Arrange meetings with stake holders in preparing requirements

document.

. Validate the requirements against the project objectives and

organizational BI strategy.

. Assess the AS-IS system and prepare to-be application.

. Prepare and arrange vendor conferencing.

. Prepare data points for make or buy decisions by the stake holders.

Implement an effective on/offshore development model. Plan, design and

implement research and planning application comprising of reports

built using Micro Strategy

. Validate and verify design, data model and design the data model.

. Interact with technical and business groups in gathering and hardware

and software resources.

. Present the to-be BI application to organizational BI stake holders

and analyze upstream and downstream impacts.

. Also validate and evaluate report behavior per non functional

requirements and exceptions.

. Work with business in analyzing the requirement and implementing the

changes per business need changes.

. Analyze the hardware requirement for application and build support

system for the new application.

Project Title: IT - Shared Services

Client: Medtronic Inc

Duration: 10/2004 - 10/2006

Environment: Consulting, Informatica, Erwin, DB2, Pl/Sql, Business Objects,

Unix Scripts

Project Description:

The engagement involved defining a DW&BI roadmap, prioritizing focus areas

for future DW&BI initiatives. Carry out operational maintenance, support,

redesign and enhancement of global Enterprise Data Warehouse and Business

Intelligence systems at Medtronic Inc., USA. The global EDW & BI

architecture was redesigned and reengineered to make smarted decisions.

Responsibilities:

As onsite coordinator the responsibility was to provide technical

consulting in architecting the Business Intelligence systems. Implement an

effective onsite /offshore development and support model. Manage the

operations of Business Intelligence applications. Partner with global

partners and provide 24*7*365 support at significant cost savings. Create

and validate high level design changes, analyze and reconcile the reports

with source systems. Performance tuning of report SQL extracts on DB2 and

oracle tables. As lead technologist and system admin worked closely with

other Business geographies to make sure the systems are stable and resolved

most of the recurring problems. Planned and execute Business Objects

migration project from 5.1.5 to 6.1b. Technical interactions with external

vendors like oracle & SAP in providing optimum solution in reengineering

the Business Intelligence application to meet the business requirements.

ORGANIZATIONAL EXPERIENCES:

December 2003 - October 2006 : Wipro Technologies US Corp

October 2003 - December 2003 : Netpro Technologies Pvt Ltd.

October 2001 - September 2003: Logix Microsystems Ltd.,.

January 2000 - September 2001: Canbank Computer Services Ltd.

May 1998 - December 1999: OTIS Elevator Company (I) Ltd.

Education

. BA/BS in Industrial and Production Engineering, BMS College of

Engineering, Bangalore, India

. MBA, Marketing with Systems, Institute for Technology & Management,

Bangalore, India in collaboration with New Hampshire College, NH.

Contact this candidate