Na - BO Architect,DWH Consultant,PMP - Bangalore, KA, India

Keshav Na

Bangalore, KA, India


BO Architect,DWH Consultant,PMP


BO Architect,DWH Consultant,PMP,ERP,DBA

Work History

Manager- Projects

Ness Technologies (India) pvt. Ltd

From January 2013

Ness Technologies (India) pvt. Ltd

From January 2013

1. NextGen PfAST Track III BO Upgrade
(Business Object reports migration from BOXIR2 to BOXI3.1)
Period Ongoing since Jan-2013
Environment Business Objects XI R3.Webi, and BI 4.1, Oracle
Client Pfizer, New York , USA

NextGen PfAST Track III BO Upgrade project is migration of existing Business objects reports from BOXI R2 3.1 environment to BOXI3.1 environment.

• System study: understanding existing BOXI R2 reports, their functionality & complications
• Providing migration and Development plan and strategies for Business Objects Universes and reports
• Providing daily, weekly, monthly, and ad hoc status reports to managers and clients on all project activity
• Defining Change management process
• Coordinating with Application team, users and other support groups in shared environment
• Involved in Migration activities using LCM, Import wizard and report conversion tools
• Fixing migrated report and universe issues and bugs
• Providing solutions & work around to implement same R2 features in BI.4 reports
• Monitoring and managing migration & Development team
• Coordination with onsite and offshore team

Citigroup Singapore(Citibank NA)

May 2011 - April 2012

Environment Business Objects XI R3.Webi, Oracle.Sybase.Mainframe
Client Citigroup Singapore(Citibank NA) -Business Object Competence- Centre- (BOCC)

Solar BAU Application was utilizing Solar Ad-Hoc reporting engine for its reporting functions
Solar Ad-Hoc reporting engine was planned to standing down by end of 2011, due to solar EOL the reporting tool will be switched to Business Objects (BO) in shared Technology Environment (STE).
Solar to BO conversion project involved to convert solar Adhoc and SQL database reporting functions to Business objects and provide a platform of reporting functions to users.

• System study and understanding existing Solar BAU application and Solar Adhoc reporting tool
• Translating Solar BAU reporting requirements to BO Universe and BO Webi reports
• Analyze migration strategies for Business Objects Universes and reports across multiple Business Objects Repositories (Development, UAT and Production)
• Designed and Developed the Physical model and logical model
• Design and Development of BO Universe and BO Webi reports for Solar BAU sub-applications
• Providing post-implementation, application maintenance and enhancement support and Troubleshooting migration issues, provide 24x7 production supports to users.
• Coordinated with Different Solar BAU Application team, support groups such as the server teams, database and vendors to implement and maintain the Business Objects.
• Developing training documents & delivering end user training sessions in support of Production rollout and Document the upgrade process and procedures
• Involved in Managing scope, effort / cost, schedule, and quality, while continuously identifying and mitigating underlying risks.
• Provided daily, weekly, monthly, and ad hoc status reports to managers
• Played a lead role in managing migration projects as well as multiple level repository migration


January 2011 - April 2011

4. The Financial data warehouse (FDW) application- Business Objects software up-gradation
Period: Jan-2011 -April-2011
Environment: Business Objects 6.5 XI R2 and R3
Client: Citigroup (Citibank NA) Singapore-Business Object Competence- Centre- (BOCC)

Description: The Financial data warehouse (FDW) application is to support the country financial reporting requirements pertaining to management reporting & local reporting.
Business Objects software up-gradation project is migration of existing BOXI R2 to BOXI R3 version.

• Business analysis and systems design, technical, functional, and training documentation
• Involved in up-gradation and test the Business Object Software XI R3 content/environment Administration using Central Management Console to configure user and group security, schedule reports, and manage and assigning rights and privileges to categories, folders, groups, profiles.
• Applied command level restrictions, set object-level and row level security.
• Conversion Desktop Reports to Web Intelligence using Report Conversion Tool and transfer with Import Wizard and BIAR generation.
• Performed report tuning, routine database tuning and administration activities.
• Managing the day-to-day operational aspects of the project, monitoring all work in accordance with schedules.
• Involved in Full project lifecycle management including hardware installation, software installation, software/hardware testing, user acceptance testing and release to production

production analyst


November 2009 - December 2010

3. FDW-(Financial data warehouse) Pearl Project implementation & FDW BAU activities
Period: Nov2009 -Dec-2010
Environment: Oracle9i,10g, Business Objects and PLSQL
Client: Citigroup(Citibank) Singapore

Description: The Pearl project is the name of a new single Franchise database for Citi bank that incorporates the Performance Measurement Framework and Standards. It will affect a common information language for business performance measurement and reviews.

Responsibilities: As a production analyst/support team member involved in below activities
• Worked extensively with the end users team in understanding the business rules and writing requirement specs, technical specs and mapping documents from staging to data mart, cubes and reporting needs to the end user community
• Designing and creating the architecture of OLAP cubes, Aggregations, Query and Reporting.
• Involved in developing the project plans for executing and controlling the project
• Coordinated with stakeholders to obtain and review Requirements and Design
• Developed Complex reports as per user requirements using BO XI R2 and Created and maintained universes, Created Dash boards using Crystal Xcelsius. Created Reports such as linking of Two Reports, Drill Down and Drill Up

production analyst


February 2008 - October 2009

2. FDW-(Financial data warehouse) Rainbow project Implementation & FDW-Migration
Period: Feb-2008 - Oct-2009
Environment: Oracle9i,10g, Business Objects and PLSQL, Datastage
Client: Citigroup(Citibank) Singapore

Description: The FDW-Rainbow application generates the financial reports required for corporate and Management. Activities Involving Rainbow project implementation and migrating FDW application to new version. Migration involves a new front end on Info view portal, Business Objects upgrade (from 6.5 to XI), new hardware platform (TRU64/HP-UX to AIX), and Oracle database upgrade (from 9i to 10g)

Responsibilities: As a production analyst/support team member involved in below activities
• Evaluated processes and on-going support structures to enable reuse and efficiency
• Created data flow diagrams and process models and integrated models across functional areas and platforms
• Involved in activities of implementing, migrating and maintaining Business Objects modules both full-client modules (Business Objects XIR2 Designer, Desktop intelligent and Central Management Console) for user Community and server-side modules (Web Intelligence).
• Involved in designing and development of Universes and Reports and Conversion of reports to BO XI R.2.and publishing WEBi reports
• Maintaining of CMC (Central Management Console) and performing tasks of maintaining security, Managing Objects, Server and Audits.
• Involved in Change management activities, Import and export of data from oracle UAT to Production database,
• Involved in installation of Business Objects components/service packs on UNIX and Windows OS

Senior Software Consultant

Emerio Globesoft Pte Ltd

August 2004 - April 2012

Emerio Globe soft pte Ltd

August 2004 - April 2012

5. Conversion of Solar Ad-Hoc reporting to Business Objects

Country Specific production analyst/support team member


August 2004 - January 2008

(Citibank) Singapore

Description: The Financial data warehouse (FDW) system application is to support the country financial reporting requirements pertaining to management reporting & local reporting. The system uses the country-level General Ledger data and generates the country financial reports using the reporting definition of the regional FINCON on the basis of the Common chart of accounts. Allows allocation of Expenses, Revenue and non-financial nature
Responsibilities: As a Country Specific production analyst/support team member
• Carrying out FDW system day to day and monthly and pre month end activities
• Analyzing requirements, analysis of existing data and developing new B.O Universes
• Hierarchy Maintenances for country specific metadata and OFA cube purpose
• Modifying and Generating new Business objects reports for analysis at various levels of users
• Supporting end users on System report related queries
• Creation of BO reports using BO functionalities like Combined Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc, Created Groups, Users and managing Security Management related activities using BO
• Creation of new PLSQL procedure, function and packages, Editing/modification of PLSQL code
• Oracle Development database maintenance, Monitoring sessions, alerts etc, Schema/User maintenance, creation/grants/roles etc on oracle Dev database, DB link creation between Database
• Tables pace/RBS maintenance on oracle Dev DB, Monitoring & maintenance of indexes

Oracle Express DBA

GE Capital Consumer Credit services

April 2004 - August 2004

Description: GE Capital Consumer Credit service is a leading consumer finance company in Osaka-Japan has been merged with another GE capital group company GE Consumer Finance. The primary objective of this project is to build a robust and integrated OFA system architecture, using a common software version, common sever, common system
Responsibilities: As a Oracle Express DBA, maintenance of Oracle Express Database
• Carrying out day to day Export/Import and Backup procedures
• Extracting GL data and uploading into OFA database, Monitoring and Analyzing Solves and models performance, Creating and editing custom programs, Analysis on growing databases size and FDI's
• Analysis of additional requirements for enhancements and providing impact report on existing system. User Interaction with Local and Super DBA's and with developers for trouble shooting


GE Capital International Services

October 2003 - August 2004

GECIS Software (GE Capital India)

October 2003 - August 2004

1. GCF (Global Consumer Finance)

Oracle DBA and InformaticaDeveloper

Equipment Management

November 2003 - March 2004

Environment: Oracle 8i, Informatica
Client: Equipment Management

Description: Equipment Management, GE's leasing businesses having integrated warehouse system with multiple data sources. It is proposed to provide a merged system which will extract data from multiple systems and pooling into to merge Database for OLAP Analysis. Involved in maintenance of an existing system with support and enhancement activities.
Responsibilities: As Oracle DBA and InformaticaDeveloper
• Maintenance of Oracle database which involves user monitoring and end user support
• Regular Backup of database, carrying periodic Import-Export activities
• Tablespace maintenance and Rollback segment management, Database and Informatica Session tuning
• Designing and architecting end-to-end ETL process including data Extraction, Transformation and Loading from source systems using Informatica
• Monitoring/Managing Informatica sessions and Scheduling the Informatica Session
• Involved in designing/editing Informatica mappings, Managing Informatica Server
• Maintenance of Informatica Repository such as creation /backup/monitoring

ORGANIZATION: ITTI Pvt.Ltd. Bangalore, India PERIOD: June 2002 to October 2003
1. CR (Commercial Reporting System)

Systems Analyst

ITTI Pvt.Ltd

June 2002 - October 2003

Module Leader

Unilever Arabia (Subsidiary of Unilever Plc. (UK)

July 2002 - September 2003

Saudi Arabia
Description: CR (Commercial Reporting System)
Unilever Arabia is a leading FMCG Company in Middle East with products on Home and Personal care and Foods & Beverages. The objective of this project aims at developing systems, which helps in the analyzing Sales information at higher level this project is targeted to higher management.
Responsibilities: As a Module Leader my responsibilities included:
• Build and Design fact and dimension tables, materialized views etc.Backup and Recovery of the database, repositories of the Warehouse. Database and Warehouse Performance and Tuning.
• Database & Data Mart creation and Maintenance. Backup and Recovery of the database, repositories of the Warehouse. Database and Warehouse Performance and Tuning
• Analyzed data and extracted from source data base

Hindustan Lever Ltd., subsidiary of Unilever Plc

June 2002 - July 2002

3. Central Purchase System - Enhancements
Period: June2002 - July 2002
Environment: Oracle Express Server , Oracle Express Objects 2.2, ASP, Oracle 8i
Client Hindustan Lever Ltd., subsidiary of Unilever Plc (UK). Mumbai

Description: Central Purchase System - Enhancements
Hindustan Lever Ltd. (HLL) is one of the leading FMCG (Fast Moving Consumer Goods) Giants in India.
Central Purchase System helps the Central Purchase department in different analysis for negotiation and finalization of prices. The system also disseminates the prices to each of the manufacturing units
Responsibilities: As a Team Leader My Contribution is:
• User requirement Study and System requirement Specification, Project Planning, Project Schedule preparation
• Project Monitoring, System testing, Implementation & User Training , Monitor and Maintenance of Database
• Regular Backup of Database and User Maintenance & Table space management,
• RBS Management & Monitoring Log and maintenance of Redo log files.

Project Assistant I

Unique Exports India Ltd

August 2001 - May 2002


Description: Internal ERP Systems
Internal ERP Package is developing for the company, which is having branches in different locations across the world. This package consists of multi modules and supports various business functionality like multi user, multi currency, budgeting, storing customer and vendor information, tracking material and inventory.

Responsibilities: As Project Assistant I was involved in the following activities:
• Involved in System study, analyzing the business requirements of the clients, Designed Forms, screens and required reports, providing & Documenting business rules, Testing and bug fixing
• Creating Test/Production Databases, Monitoring and controlling the user access to the database,
• Installing Oracle & other different Softwares, Privileges, Roles and profile administration and General user administration, Creation and sizing of temporary and permanent rollback segments

2. Easy business package

ERP Consultant & Junior DBA

General Package for SMI's

June 2000 - July 2001

Description: EASY BUSINESS PACKAGE was being used for integrating order management, financial accounting, and Inventory control system. It comprises of modules like Inventory, Purchasing, Sales, Account receivable, Account payable, Payroll, Financial accounting, Vendors, Customers, production Planning etc.

Responsibilities: As an ERP Consultant & Junior DBA responsibilities were for the following activities:
• Customer Interaction, Requirement Gathering, Data collection &Project initialization
• Preparation of test plans and carried out unit testing and integration testing of live datas.
• Interacting with the project manager and the end user and demonstrating the various modules to the user and getting their feed back at regular intervals.
• User administration and Reorganizing table spaces, Allocating tablespaces
• Granting privileges and roles
• Database designing& Planning

3. Oracle Application Implementation & Customization

Analyst Programmer

Digital Commerce Solutions Software (India) Pvt

August 1999 - June 2002

Projects Undertaken and Responsibilities

DCS Software (India) Pvt.Ltd

August 1999 - June 2002

1. Internal ERP Systems

SB Global Corporation Ltd

August 1999 - May 2000

Description: As a Consultant Member involved in the implementation & Customization of the following.
The project mainly involved Customization &implementation of following Oracle Financials Modules
Responsibilities: Primary responsibility was GL - Module and secondary responsibility was AP, AR, OE &Sys Admin Modules. Contributed mainly in the Implementation of GL - Module and customization of various reports through Financial Statement Generator (FSG). Mapping the old system of accounting for Oracle Implementation, Re-designed Chart of Accounts taking into consideration the future requirements
• Designed the structure of flex field after taking into consideration the complexities of business. Completed various set-ups in GL, AR, AP, OE - Module including defining set of books, Currencies, Calendars, Chart of Accounts, Value Sets, Roll up groups, Summary Accounts
• Customized Different reports through Financial Statement Generator (FSG) including Segmental Profit & Loss A/c, Segmental balance Sheet, Cash Flow and Fund flow Statements.

Qualifications & Certifications

University of Mysore

University of Mysore

Skillpages has been acquired by! is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Are you sure that you want to leave?