Data Warehousing/Business Objects Architect

Objective:
To obtain a Senior Level position in Business Intelligence Group (DW Projects), where I can utilize my experience in the areas of Design, Development, Configuration, Implementation My strengths include excellent communication skills and strong hands-on approach to deliver results, coupled with my excellent organizational skills.

Summary:

• Over Eleven plus (11) Years of experience in IT.
• Extensive experiences In Business Analysis
• Experienced in preparing excellent documentation on business requirements
• Experienced in working with various tools which is used for requirements gatherings in business
• Expertise in system design and development required for business process
• Vast experience in Project and Operations Management
• Wide knowledge in re-engineering concept
• Good written and oral communication
• Worked as a liaison among business stakeholders to understand business problems and opportunities in the context of requirements and recommend solutions that enable the organization to achieve its goals.

• Excellent experience as Data Warehousing and Business Objects Architect

Strong Analysis and Design Skills

• Data modeling: normalization, denormalizations, physical database design, relational models, star schemas, snowflake schemas, etc.
• Software engineering, system design, functional partitioning, module identification.
• Requirements definition
• System architecture and high-level design
• Program specification
• Dimensional data modeling, star and snowflake schemas, key generalization, and other OLAP considerations.
• Data warehouse design, construction, and support principles and issues.
• Data scrubbing and data integration algorithms.
• Document design

• Business Objects with Web intelligence - Business Objects Admin, Supervisor, Designer, Reporting, BCA console, Web Intelligence Info View, Broadcast Agent and Auditor, Application Foundation - Dashboard, SDK ,
• Xcelsius, SAP Integration KIT with BO.
• Crystal Reporting, Cognos, SAS (Base SAS, EIS), SEAGATE, DAPHNE, MS SQL (OLAP Services) and Seibel Analytical
• Extensive experience in Oracle 8i/7.x, SQL, PL/SQL scripts and procedures, MS SQL Server
• Good experience in Visual Basic, ASP, Visual Interdev, Developer 2000, Java, JavaScript
• Excellent Knowledge on SAP BW/BI like Data models , BI objects , Data Flow, storage objects in BW, Remodeling tool box, BI reporting(Business Explorer/ Query designer ), BI Extraction etc.,

TECHINICAL PROFILE

RDBMS : Oracle 8i/7.x, SQL, PL/SQL, Sybase, MS SQL
Server with Data Warehouse, SAP BW
OLAP TOOLS : Business Objects XIR3, (various version from BO 4 to BO XIR3 with SAP BI/BO), OBIEE, Cognos, SAS (Base SAS, EIS), SEAGATE, DAPHNE, MS SQL (OLAP Services)
ETL : Informatica, Oracle Warehouse Builder, MS-SQL DTS
Languages : JAVA (JDK1.2), C, C++
Internet/Intranet : VBScript, JavaScript, HTML
O/S : Windows NT/95/XP, MS DOS, UNIX

Confidential
Business Analyst and Sr. Business Objects Consultant May2010 to Till Date

Project #

IBRECON (Install Base Reconciliation): Overall Objective of this project is to use the existing pre-quoting validations to identify data issues and applies proven business logic to mitigate those issues to correct the line in C3.
Pre-validate and fixing the data issues related to quoting leads to fewer quoting errors, accurate goaling, higher quote conversion, reduces the number of support cases and improves overall productivity. Fixing the top 5 quoting issues will be a huge productivity improvement, reduce support cost, cleaner data leads to correct opportunity reporting. TOP 5 Quoting Errors are

• The Contract Number/service levels chosen for the major and minor-line products must be the same.
• The City and Postal Code associated with the Install Site on this line represent different locations.
• Duplicate Coverage Issue
• The State associated with the Install Site on this line was not found in the Cisco Service Availability Matrix.
• Cisco records show that the serial number on this line comes from a device that has been decommissioned and can no longer be placed on a service contract.

Project #
Services BI is a Migration project from Oracle and Teradata. Services BI is an offline reporting application. An existing System CIBER BI has 17 excel reports using Pl/SQL coding via a Interface (Java)(users use interface to get the excel files to their email) And the main idea of this migration project is to change Database and also.. To use analytical tool Business Object.
In Services BI application, user can request various business reports by submitting though the application user interface. After the successful processing, the report will be sent in the form of email attachment to the user.

Project #
EWR (Early Warring Reports) -The scope of the EWR is to offer a dynamic (real time) online repository of standardized and custom reports for end users of the field health metrics. Phase one of this project will focus on the automation and enhancement of the current manually generated field health reports compiled from disparate systems and manual sources into one dashboard.
Overall Objectives of the users will leverage reports and associated data to assess and identify the opportunity to engage in the improvement of product quality and process improvement product serviceability. The information will help them identify opportunities to engage, validate systemic issues identified. The data will be used to develop business case with analysis to quantify the scope and cause of a specific systemic issue or concern.

Responsibilities:

• As a Business Analyst and Sr. Business Objects Consultant My Contribution for these project is to interact with business team to understand existing system in CIBER BI and EWR New application details
• Creating BRD's for IBRECON project (Data Fix's for Top 5 errors in IBRecon Quoting process) , EWR project (listing out # of EWR Reports with detail elements ,and formats of the graphs as per user requirement, and listing out sample data.) and converting same BRD's Into Technical Documentation
• Analyzing the Existing Oracle database PL/SQL code to Map with new system Database Teradata
• Key person to do Analysis Existing Reports in PL/SQL or in Oracle in order to convert them to SQL using Reporting tool Business Objects. (for Services BI)
• Worked with Business to finalize Xcelsius dashboard design and created a POC for Xcelsius
• Key person to build universes using Designer module. And building /designing all the 17 reports (Services BI) , 19 reports (EWR) and to answers the existing system (Leading a team of three from offshore)
• Parallel Supporting issues related to CMC ,BO Administration with and report migration with in Dev and STG box's
• Assist in User Acceptance Testing
• Provide support to project plans and release plans
• Documentation as per project requirements (user documentation on Adhoc reports)
• Demo on ad hoc reporting for EWR project.

Environment: Business Objects XI R3 Enterprises Suit (Designer, Web Intelligence (with Rich Client) CMS and Report Conversion Tool, Xelsius Dashboard, BO SDK (BO Reporting engine SDK is used to set the prompts, schedule the report from Java) Oracle (PL/SQL), Teradata 12.0, JAVA, Microsoft Tools, UML

Confidential (SFO, CA)
Sr. Business Objects Consultant and Data Analyst Aug2009 to May2010

Confidential at Confidential came up with DW project and the overall approach that has been agreed for reporting is to divide the inventory of reports into subject areas (e.g. Enrollment, Provider, and etc.) and then to further sub-divide the reports between Internal and External. For the Internal reporting, the approach is to perform a data analysis to determine if there are additional data needs that are not already covered in the Business Objects Universes as defined by Edifecs. The universe with the additional identified data would provide the basis for authorized personnel to define and run reports using Business Objects. For External reports, individual detailed reporting specifications will be developed so that these reports can be built as part of the Channel EDI development.

Responsibilities:

• As a Sr. Business Object Consultant and Data Analyst My Contribution for this project is to convert existing FRS to Technical documentations
• Working with Business Team closely to understand the process of BSC Transaction Management application System and to manage stakeholder expectations as project progresses.
• Analyzing DATA into Details to ensure backend data bases of Transaction Management data storage
• Key Person To Design the Universe using Business Object Designer XI 3,
• Key person Report Development based on Mockup requirements using Desktop Intelligences , Web Intelligences and Rich Client
• Working on CMS module for any User security setup related to Enrolment Reports or Claims
• Developing test scenarios, scripts and conducting testing effort, including the recording of testing issues.
• Documenting : Details Report Design Document on both Technical and on TM application functionality system analysis
• Providing post -production support for system issues, including research and follow-up.

Environment: Business Objects XI R3 Enterprises Suit (Designer, Desktop Intelligences, Web Intelligence (with Rich Client) CMS and Report Conversion Tool), SQL Server, Oracle and Transaction Management Application System (used by most of the Insurances companies)

Confidential (Los Angeles, A)
Sr. Business Objects Consultant Apr2009 to Aug2009

The BI environment at Oakwood is currently tenancy centric, driven by the reporting needs so far. The apartment data in the Data warehouse is also derived largely based on tenancies; some of the critical information like property base rent is sourced from tenancy rather than apartment data.
This does not allow for accurate/efficient reporting on basic inventory metrics like all active inventories vs. vacancy. The problem is more pronounced in the OCH division given the dynamic nature of the business.
The overall objective of the Inventory Management Project is to provide a reporting environment that combines the apartment and tenancy data seamlessly by maintaining data integrity…

Responsibilities:

• As a Sr. Business Objects Consultant My Contribution for this project is to interact with business team and convert the FRS to Technical Designs.
• Understand the business needs to start new projects on Data marts
• Key person to do Analysis on the data and on current existing System.
• Key person to build universes using Designer module. And building various reports to answer Business Questions.
• Supporting current production issues related to CMC ,BO Administration ,Web Intelligence, Universe (existing universe which is almost like legacy system) etc.,
• Key person to Modify Current BO homepage(home.jsp)
• Created a POC for BI/BO system and below are few details in my experiences
• Firstly for this POC other than regular Business objects setup ,SAP integration kit was installed on the Business Objects Server
• And to createBusiness Objects WEBI /Rich client reports created new universe for which back end was SAP BW, Created connection for SAP client in order to getaccess to Cubes from SAP BW.
• Created Cubes with the BEx queries( used existing Bex queries )
• Also Created universe on top of Infocubes, Multiproviders and BEx Queries

Environment: Business Objects XI R3 with Web Intelligence Info View, SQL Server, SAP BW

Confidential (Mountain View, CA)
Sr. Business Objects Lead Apr2008 to Mar2009

Auto Renewal project will build Auto-Billing functionality in-house ,capture lost revenue, improve conversion rates for auto-billing customer via improved marketing and reduce customer support issues. The main stakeholders for this project are CPS, GOS, FTT, Marketing, GSS and SKU. This Business Requirements document (BRD) has been created for the Auto Renewal reporting project. The clients for this project are CPS, GOS, Treasury, Marketing and GSS. This document itemizes the formal business functions, processes and rules that require the intake, management and provision of data from the Enterprise Business Intelligence (EBI) technology platform for the Auto Renewal project under ePayment solution program. The EBI platform provides reporting, dashboard reports, data set and data mart services in response to these requirements.
Auto Renewal will enable the business, to experience improved flexibility, to define and implement business changes within their systems. The system will also provide improvements for, and resolve current issues related to:

• Inflexibility of current reporting environment.

Auto Renewal reporting will enable the users in accessing canned reports. Currently Vindicia an application is used for auto renewal activity. All reports that exist in the Vindicia application needs to be recreated in this new auto renewals application. Additionally new reporting functionality and reports are being introduced in order to improve and optimize reporting capabilities.

Responsibilities:

• As a Business Object Lead My Contribution for this project is to convert FRS to Technical design documents
• Key Person To Design the Universe using Business Object Designer XI R2,
• Reporting Leading Of shore team (in India) to assign the work for report development
• Developing test scenarios, scripts and conducting testing effort, including the recording of testing issues.
• Developing training documents & delivering end user training sessions in support of Production rollout.
• Providing post -production support for system issues, including research and follow-up.

Environment: Business Objects XI 2 Release with Web Intelligence Info View, Oracle

Confidential. (San Jose, CA)
Business Analyst and Sr. Business Objects Consultant Nov2007 to Mar2008

A part of the Demand Management Excellence (DMx) initiative, Business Intelligence & Data Management (BI&DM) is chartered to establish a structured Data Management framework and provide robust Business Intelligence capabilities for the Manufacturing Demand Management & Planning (DM&P) organization.

The program consists of three key areas:

Foundational Datamigrates DM&P data elements to centralized platform (TeraData) in phased releases. The migration will involve existing data as well as new data from the DMx applications: (SAS, used for analytical forecasting; Demantra, used for demand planning; and Kinaxis, used for supply planning).
Business Intelligence builds upon the foundational data to deliver robust ad-hoc analyses, reporting and dashboarding capabilities with the deployment of a new Business Intelligence (BI) application. The business objective is to provide more intelligence in reporting and to shift from tactical data analysis to strategic planning.
Data Governance implements Data Management Methodology to enforce accountability for data ownership and quality. This will ensure a reliable, accurate and trustworthy single source of truth.

This Business Requirement Document (BRD) is to identify processes, tools, and business and data requirements needed for BI&DM 1.0 Release in March 8, 2008. The scope of this release includes deployment of the new business intelligence application and ad-hoc environment, which will incorporate required DM&P business data objects (BDO) existing in TeraData.

Responsibilities:

• As a Business Objects Consultant and Business Analyst My Contribution for this project is to convert BRD (Business Requirement Document) to FRS (Functional Requirement Specification) work enters Universe Design in XI R2, Testing and validating Mock Up reports.
• Interacting with Users to understand Requirements to convert to FRS
• Key Person To Design the Universe using Business Object Designer XI R2,
• Working on security privileges using CMS Module (Central Management Server).
• Creating ad hoc reports using Web intelligences to test mock Up Reports.
• Coding - Writing SQL for Conditions, Context and for pre built Filter (like roll up months) at various levels based on the FRS.
• Created UAT Scripts to Test and validate the Data
• Testing and Bug Fixing based on Tester\'s report. User Interaction for design the Specs and all other doubt clarifications(in Dev, QA and Production)

Environment: Business Objects XI 2 Release with Web Intelligence Info View, Teradata 7.1

Confidential (SFO, CA)
Sr. Business Objects Consultant June2007 to Nov2007

Supporting same old project for Confidential day to day activities or day to day reporting system to Business Objects for Ad-hoc Queries
The Data Mart or Universe contains all US homeowners and renters. Contains Marketshare and Walletshare information on an MSA, State and Footprint level of geographic detail. The products categories are: Home Mortgage, Home Equity, Credit Card, Auto & "other" debt.Credit risk details of FICO score groups are available on all products. Further, for Confidential-Home Equity the channel of origination and G2-eligibility are available and few of the reports were like All Up Weekly Tracking Reports(These files contain weekly Home Equity applications, boards and funded dollars by marketing promotions. The report is broken down by Line of Business.),PCM Customer Management Programs, Smart Fit Advertising Tracking, Marketing Customer Management Report(M), PCM Acquisition Response by Cell CTD,PCM Acquisition Response by Cell MTD, Product Performance(M).
Responsibility:

• As a Team Member was involved in XI 2 Migration for Marketshare Report – (Converting .rep to Webi documents, Testing and When necessary modified the reports)
• Interacting with Users to understand New Requirements
• Created Functional Specifications and Technical Specifications based on the Requirements
• Involving with Database team for developing some of the functions in order to pull from Universe Module
• Key Person for creating New universes for Marketshare and Hemisphere Universe and in making relevant changes for existing universes
• Key Person to Create Reports/Manipulating data through various presentation styles such as; charts, cross tabs, standard tables and synchronization reports using both Desktop Intelligences and Web intelligence
• Analyzed data to see whether Data matches to User Expectations.
• Created UAT Scripts to Test and validate the Data
• Periodical Scheduling for Reports to run automatically. Implementation and periodic maintenance, activity Optimization of Queries used in Business Object.

Environment: Business Objects XI 2 Release with Web Intelligence Info View, Oracle

Confidential (Sunnyvale, CA)
Sr. Business Objects Consultant Oct 2006 to Mar2007

Project 2# GCS (Global Consulting Solution), Quick Arrow is a hosted solution for entering the Consultant\'s time sheet and the Billing is done through the PA module of ERP. The data from Quick Arrow is fed manually into the PA systems and this has caused many data inconsistencies and errors The purpose of the reporting system for this project is to highlight the errors and aid in the billing, Data is from both the system is brought in to Business Objects and linked using the Synchronization feature of Business Objects. The missing data is highlighted using the conditional filter option in Business Objects from there on users will use Varies BO reports such as Timecard entry, Events, Invoice, Tasks on each and individual Project these reports were used to find out Missing data in PA in order to Enter or update or modify the PA System
Project 1 # Digital River (DR) is the 3rd Party Vendor of the eCommerce platform used by GOS for Online Sales. There was an existing version referred to an Atlantic (or V3) is in process of being upgraded to the new Pacific (or V4) platform including APJ (Asia Pacific and Japan) countries which are already on the 2-byte V4 platform. The 'new' Pacific platform has been migrated regionally in phases. The Pacific data structure is identified to have changes from existing Atlantic data structure being fed into the Data Warehouse from which front-end user reporting is extracted. -- The Pacific (V4) data structure has been added to the GOS data mart schema to allow for reporting on the online sales and traffic transactional data sourced from both the Atlantic (V3) and Pacific (V4) Digital River platforms.
Environment: Business Objects XI 2 Release with Web Intelligence Info View,6i, Informatica 7i and Oracle.

Confidential (SFO, CA)
Business Analyst and Sr. Business Objects consultant Jun2005 to Sep2006

Confidential Department started upgrading their day to day activities or day to day reporting system to Business Objects for Ad-hoc Queries .
The Data Mart or Universe contains all US homeowners and renters. Contains Marketshare and Walletshare information on an MSA, State and Footprint level of geographic detail the products categories are: Home Mortgage, Home Equity, Credit Card, Auto & "other" debt.Credit risk details of FICO score groups are available on all products. Further, for Confidential-Home Equity the channel of origination and G2-eligibility are available and few of the reports were like All Up Weekly Tracking Reports(These files contain weekly Home Equity applications, boards and funded dollars by marketing promotions. The report is broken down by Line of Business.),PCM Customer Management Programs, SmartFit Advertising Tracking, Marketing Customer Management Report(M), PCM Acquisition Response by Cell CTD,PCM Acquisition Response by Cell MTD, Product Performance(M).
Environment: Business Objects 6.5, XI 2 Release with Web Intelligence Info View, Dashboards, Oracle

Confidential has started Developing Data marts for its Marketing, Sales net and for its Call Center Departments. Call center is for Pre-sales where they call the Customers for Business and this call center data is a part of CRM (Customer Relation Management).

The process of the data for this Project was to extract the data from Siebel database to Oracle and Sql server Database using DTS and to produce Ad hoc and Formatted reports for users by using Front End Tool Business Object 5.1.7 with Web Intelligences Info View 5.1.2

Responsibilities:

• As a Business Object Consultant My Contribution for this project is to work on Call Center Data
• Working one Both Functional and Technical Specifications.
• Key person for Installing BO Server and Client module, configuring and setting the connections etc.,
• Key Person To Design the universe using Business Object Designer,
• Key Person Working on security privileges using Supervisor Module
• Creating standard and ad hoc reports using Business Object Reporting and Web intelligences.
• And monitoring performances of report running and restarting the BO web Server enabling the BCA's writing the Sql's and Procedures in backend. Etc.,
• Distributing Documents inside and outside of the business using Broadcast Agent server (BCA) and administration for scheduling the Reports (like rep, wqy, pdf, excel, text and html format).
• Manipulating data through various presentation styles such as; charts, cross tabs, standard tables and financial tab
• Layout designing for various Reports in Business Object and Integration of reports. Coding, Reviewing, Formatting, Testing, Bug fixing & Integration with different classes. Analyzing system functionality requirements, documents and scope of the work.
• Coding - Writing SQL Conditions for the Context and for the Filtering at various levels based on the specifications.
• Testing and Bug Fixing based on Tester\'s report. User Interaction for design the Specs and all other doubt clarifications.
• Implementation of reports in Production after user approval in test area.
• Periodical Scheduling for Reports to run automatically. Implementation and periodic maintenance, activity Optimization of Queries used in Business Object.
• And supporting the Reports, which are in production box.

Environment: Business Objects 5.1.7 and 6.5.1 and with Web Intelligence Info View, Sql Server 2000, Oracle, Ms-Access, Crystal reporting

Confidential
Business Objects Consultant/Architect Aug 2000 to Dec 2003

Confidential NV newly entered into the Data Warehouse development for its Fixed Income and Treasury Trades. These are state-of-art Web enabled projects using Business Object with Oracle DB. They have been successfully implemented. It generated reports like MAS Monthly Reports, Nostro Projection Report, Outstanding Performance of Trades, Head Office Balance Sheet, Profit & Loss Report, and Periodical Transactions reports, Trial Balance, Daily Cash Flow Reports etc. RAP Reporting is a separate Project. It serves the Users to get the reports by uploading WSS data into RAP Application.
Bulk loading Data from Wall Street System to Oracle Database and understanding Data flow in Wall Street System is also a part of this project.

Responsibilities:

• Business Objects Consultant / Architect for Data warehouse Project
• Analyzing and tuning the data based on the requirements and Implementing Data Flow
• Key Person for Administrating Designer and Supervisory Module.
• Key Person for Creation of User Administration and New Reports with Formatting or standard templates, Applying sorts, cumulative, calculations, breaks, and ranking to data and Opening, modifying, saving and sharing existing reports.
• Creation of Universe in the Designer and making connection with the Oracle Database.
• Distributing Documents inside and outside of the business using Broadcast Agent server (BCA) and administration for scheduling the Reports (like rep, wqy, pdf, excel, text and html format).
• Manipulating data through various presentation styles such as; charts, cross tabs, standard tables and financial tab
• Layout designing for various Reports in Business Object and Integration of reports. Coding, Reviewing, Formatting, Testing, Bug fixing & Integration with different classes. Analyzing system functionality requirements, documents and scope of the work.
• Coding - Writing SQL Conditions for the Context and for the Filtering at various levels based on the specifications.
• Testing and Bug Fixing based on Tester\'s report. User Interaction for design the Specs and all other doubt clarifications.
• Implementation of reports in Production after user approval in test area.
• Periodical Scheduling for Reports to run automatically. Implementation and periodic maintenance, activity Optimization of Queries used in Business Object.
• Creation of Oracle Stored Procedures for some complex Reports.
• Developed report for Bloomberg Trade feed to find the Total P&L (Realized and UN Realized).
• Successfully Implemented Data Warehousing for Fixed Income and Treasury Trades in Asia Pacific Confidential in Singapore, Hong Kong, Thailand, Japan, Manila and Sydney and later handled new enhancements for existing reports and new request
• Successfully Implemented Data Warehousing for Treasury Trades in Confidential Amsterdam (Alco)

Environment: Business Objects 5.1.3 and with Web Intelligence Info View, 2.6.3, Oracle 8i, SQL, PL/SQL, Informatica Power Center, MS Access

Confidential (Confidential)
Data warehouse Professional Apr 1999 to Jul 2000

Confidential was a part of Confidential. Confidential develops various Data Marts for different Business areas like Retailing, Banking, Transportations etc and present the Demos on Sample marts with ad-hoc queries using DAPHNE (developed by Confidential Research and Development Team) and Business Objects 4.5

Responsibilities:

• Team Lead
• Carried out retail requirements study and designed the DW architecture
• Designed the Data Marts based on the requirements like Metrics like scalability, identification of grain and the utilization of the warehouse.
• Key Person for ETL and the implementation of the front end OLAP Universe in Business Object Designer to present the data based on Customer requirements
• Implemented the BO Universe based on the Access area design of the Data warehouse.
• The presentation aspects of the reports in BO tool were another area, which had challenging reporting requirements at Customer Place.

Confidential, India
Software Programmer Oct 1997 to Mar 1999

Confidential was a part of Confidential. It develops various projects both in and out of the Company for different Business Areas.

Responsibilities:

• As a Team Member was responsible for Forms Designing
• Have worked on PL/SQL coding
• Interacted with Business Users to gather the requirements