SUMMARY

• Around 11 years of experience in the IT Industry.
• 5+ years of experiance as a Business Intelligence Business Analyst and in Project Management activities.
• 7+ years experience in Data warehousing / Business Intelligence Domain.
• 5+ years in Siebel Analytics/OBIEE including OUT OF THE BOX SIBEL CRM, STAND ALONE and ORACLE EBS
• Worked in various DW/BI tools such as OBIEE/Siebel Analytics, Informatica, Data Stage, ACTA, and Brio / Hyperion.
• Extensive custom coding using Oracle PL/SQL, and also involved in Basic Oracle DBA Activities, and Production Support.
• Expertise in writing Complex SQL statements.
• Excellent understading of Database Deisgns and Database Structures.
• Excellent Data Modelling Skills.
• Excellent Communication skills with peers, Business and key Stakeholders of the Project, and Vendors.
• Experience in handling Onsite - Offshore models.
• Ability to adapt to Situations quickly, and face challenges, and ultimately get the work done right, in the stipulated time frame.
• Expert in SDLC - Software Development Life Cycle, including analysis, design, development, testing and implementation of software applications.
• Expertise in System Design and Development required for business process.
• Extensive testing experience and also writing the test scripts required for the necessary testing

ETL Tools

Informatica, Data Integrator, SQL Loader, Custom Coding using PL/SQL

BI Tools

Siebel Analytics / OBIEE, Brio 6

RDBMS

Oracle 7.3, 8, 8i, 9i, SQL Server

GUI

Visual Basic 6.0, Oracle Forms

Languages

PL/SQL, COBOL, C, PASCAL

Web Related

HTML, Java Script

Operating System

Windows NT, XP, Windows (95/98/2000/XP), Sun Solaris

TECHNICAL CERTIFICATIONS

Certification in Oracle 8i PL/SQL Certification in Oracle 8i Network Administration CISCO Certification in Oracle Incentive Compensation

WORK EXPERIENCE

Client: Confidential,Nov ’09 Till Date
Sr OBIEE Consultant / Business Analyst / Data Modeler
To Lead a Business Intelligence initiative to build a Survey Model to analyze the responses from Citrix Online Customers
Reponsibilities

• Had sessions with the Business Stakeholders to identify the Project requirements, and draw the project road map.
• Prepared the Business Process Requirements and S/w System Requirements.
• Had session with the development team to make sure they understood the functionality and the business rules.
• Followed Agile process and identified the contracting resources for this project.
• Scheduled Scrum meetings every 2 weeks, and made sure the tasks were complete by end of the Sprint.
• Schedule Backlog Grooming sessions, Sprint Retrospective and Sprint Planning sessions to analyse and discuss as to what estimates were made for every tasks, actual time taken, tasks that were completed, and plan User stories and tasks for the next Sprint.
• Created OBIEE RPD; Reports and Dashboards using OBIEE Answers and Dashboards; Scheduled iBots using Delivers; Used catalog manager to merge and manage Webcat files and folders.
• Create bug tracking database and quality assurance systems to organize project assets, reduce time, and locate assets.
• Create test plans for Unit testing, Integration testing and UAT.
• Migrated RPD and Webcat from DEV to TEST and from TEST to PROD.
• Made presentations to the user community world wide on the reporting application and using it; trained the End Users in using the tool.

Environment: OBIEE 10.1.3.4, Business Objects Data Integrator (BODI), Oracle 10g, Windows XP

Client: Confidential,Mar ’09 Nov ‘09
Senior Lead OBIEE Consultant / Business Analyst
To develop OBIEE Dashboard displaying the comparison of Actual vs the Forecast Data, which are called Forecast Accuracy Reports, and also display Forecast Waterfall Reports.

Responsibilities

• Installed and Configured OBIEE.
• Gathered and refined the requirement.
• Dveloped the strategy for data flows from the various systems from Actual and from Forecast, which was called the Demantra, into the OLAP (Datawarehouse).
• Suggested ideas and implemented, to have a common date dimension, instead of having many date dimensions, which was the part of current architecture.
• Designed and Created 2 tables in the Datawarehouse, for Forecast Accuracy and Waterfall reports.
• Designed the tables to handle complex requirements, such as handling Lags, Uplift Percentage Calculations, etc.
• Created the RPD Physical, Business Model and Mapping and the Presaentation Layers.
• Created Aliases to handle complex requirements, and overcome existing limitations.
• Created Dynamic Session variables to handle Date filters.
• Created reports in Answers, some of them being complex like having Forecast Error % and Forecast Accuracy %.
• Created Dashboards.
• Created and scheduled iBots.
• Interacted with the ETL team in Manila. Sent to them the Design Document prepared and letting them know, how the functionality works.
• Involved extensively in wrting test scripts for Testing, and also participated in Testing.
• Captured Bugs, and fixed it both ETL and RPD.
• Merged the RPDs and Webcat Demantra Forecast, BBB and existing RPD.
• Migrated the RPD and Webcat from Dev to Test.
• Prepared the Detailed Design Document and also the training document for the Business, and they would be migrating from Brio to OBIEE.

Environment: Siebel Analytics 10.1.3.4, Oracle 10g, Windows XP

Client:Confidential,May ’08 Feb ‘09
Senior Lead OBIEE Consultant / Business Analyst
The core of this project is about how Commissions are calculated and paid to CISCO’s sales agents. The reporting application is called VISIBILITY (OBIEE) and its source is OIC (Oracle Incentive Compensation).

Responsibilities

• Installed and Configured OBIEE.
• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Created the OBIEE environments for Development, QA and Production.
• Designed, Created and Tested Report in the Dashboard and created adhoc reports as per client needs.
• Designed, Developed and Tested Data security and Dashboard security in OBIEE
• Migrated the Code - Reports, Dashboards and Repository from Dev to QA, and from QA to Production.
• Did OBIEE Admin work such as New Id creation, Account modification of existing users, Password reset and Deletion of accounts.
• Assisted the Project Manager in identifying potential risks at various stages.
• Created test Plans and test cases for testing the Visibility Application during Go-Live and releases, and tested the same.
• Analysed the impact due to the change in the HR Source application for OIC, from Peoplesoft to Oracle.
• Prepared test case scenarios for scenario based testing about the Flow of data from Oracle HR application to OIC, and finally into the Visibility application.
• Involved in support activities, answering and clearing questions from Sales Agents about Comp Plan setup, Goal setup, Commissions paid, Draw Recoveries, Bookings, etc.
• Prepared FAQs and Information Documents and uploaded them in the Knowledge portal which addresses Project Release, Release Items, Fixes, Release Dates, Impact, and information which answers Sales agent questions with respect to Commission Payment, Bookings, etc.
• Certified in CISCO\'s Oracle Incentive Compensation.
• Currently getting trained in Compensation Plan setup, Goaling Setup and Payment Compensation.

Environment: Siebel Analytics 7.8, Oracle Incentive Compensation

Client: Confidential, Jan ’08 Apr ‘08
Senior Lead OBIEE Consultant
Creating New Reports, Dashboards using Siebel Analytics 7.8

Responsibilities

• Created new reports using Siebel Answers.
• Solved many of the existing problems, including creation of complex reports, managing Dashboards.
• Suggested ways to handle complex problems using Variables.
• Investigated the data for performance, and suggested building indexes and environment changes.
• Also suggested to implement a Caching solution and documented the same.

Environment: Siebel Analytics 7.8.4.6, Oracle 10 g, Windows XP

Client: Confidential, May ’07 Nov ‘07
Senior Lead OBIEE Consultant / BI Business Analyst
Implementing Siebel Analytics 7.8.4.6 for Business Intelligence. Creation of Reports and Dashboards in Siebel Analytics, that exists in Business Objects, and also creation of new measures and reports.

Responsibilities

• Involved in the Requirements session with the Business people to gather the Requirements.
• Created new measures and Dimensional attributes in the Repository.
• Developed reports using Answers and built Dashboards.
• Used Siebel Delivers for sending Alerts.
• Prepared the training Document for client (US and Europe), and assisted them in clearing their questions during training.

Environment: Siebel Analytics 7.8.4.6, Oracle 10 g, Sun Solaris, Windows XP

Client: Confidential,Jan’07 - Apr ‘07
Senior Siebel Analytics Lead Consultant / BI Business Analyst
Creating new measures for Customer Profitability and Displays, and to develop an Archiving statergy. These measures are created in the Siebel OLTP, then transformed to Siebel OLAP layer using Informatica and then Reports are created using Siebel Analytics.

Responsibilities

• Interacting across various business groups to find out the requirements.
• Documented these requirements to prepare the Understanding document.
• Worked with the Project manager by assisting him in identifying potential risks and gaps.
• Suggested changes to be made that would improve Performance in the reports.
• Worked with the Siebel Vertical team to analyze the existing system and to incorporate the new metrics in the layer.
• Designed the ETL flow from the Siebel OLTP to the OLAP layer and scheduling the workflows in Argent.
• Designed the table to be created to hold the new metrics.
• Worked on designing the layout of the reports and Dashboards.
• Provided solution to Archiving.

Environment: Siebel Analytics 7.8.4.6, Windows XP, Argent
Industry: Consumer Goods

Client:Confidential,Oct’06 - Jan‘07
Senior Lead Siebel Analytics Consultant / BI Business Analyst
Developing a Customer Team Decision Cockpit (Dashboard) for the P&G‘s Business Leaders to analyze the shipment of P&G‘s products across the globe.

Responsibilities

• Interacted with the business to find out the requirements.
• Transformed Business Requirements into Technical specifications. Created the Technical Relationship Document and the Understanding Document.
• Did feasibility study to identify gaps, and also identifying the tool’s advantages and limitations and documenting the same.
• Refining Business requirements by suggesting changes to the Business team which could make the Dashboard more user friendly and interactive.
• Suggested customizations to make user interaction easier in the Dashboard.
• Identified the backend process and suggested necessary aggregations that need to be built for the report performance.
• Interacted with the Kalido team regarding the integration of the Kalido application with the Reporting tool to manage hierarchies. Explained to the team about the business requirements.
• Incharge of getting business user responses after start of development to get the feedback and discuss changes if any.
• Interacted with the security team, regarding third party security integration and made sure the functionality was strictly adhered to.
• Interacted with the Quality team, helping them to understand the project functionally and to make sure that the process is followed.
• Preparing the test plans and participated in Functionality testing and UAT.
• Incharge of identifying the support process after go live.
• Documenting the changes to be done for point release, after the go live.
• Trained Business Users to use the tool.
• Instaled Siebel Analytics and built the repository.
• Helped the development team to boost the performance of the reports by suggesting aggregation table builds and caching.

As a Siebel Analytics Consultant,

• Worked in the Analytics Repository to build the model.
• Created level based measures and Logical hierarchies.
• Handled security using the Security manager.
• Created reports in Answers.
• Solved many formatting issues.
• Built Dashboards.
• Created the test data.
• Wrote test scripts using SQL, for testing the data in the BI environment with the source.
• Logged the cases in the Inquiry tool, and fixed the issues.

Environment: Siebel Analytics 7.8.4.6, Oracle 9i, Windows XP.
Industry: Consumer Goods

Client: Confidential, Aug’05 - Sep’06
Siebel Analytics Lead Consultant / Bi Business Analyst
Bookings and Debookings, Backlog, Revenue, ENB, POS and are analyzed and are reported on Daily, Weekly, Monthly, Quarterly and Yearly basis to the Finance and the Demand Analysts.

Responsibilities

• Designing business intelligence processes to analyze enterprise data that enhances business processes and decision-making.
• Acting as a functional consultant working at all levels of the business matching software to business needs.
• Working closely with the business serving as an expert resource to leverage business intelligence to better serve the business.
• Identifying business requirements/strategies and implements business intelligence solutions to support these business initiatives/business rules for data/success criteria/ business intelligence objectives. Created the Technical Relationship Document.
• Analyzing source data, its applicability in solving business problems, and its quality (compliance to business rules).
• Integrating business intelligence applications with existing systems.
• Assisting in defining, sequencing and estimating project tasks.
• Developing and implementing test plans, assuring quality in all project deliverables
• Worked closely with the VP’s of the organization to gather requirements to build the FLASH page in the Dashboard, for the top most Management team in CISCO.
• Installation, Configuration & administration of Siebel Analytics.
• Configuring the Siebel Analytics repository.
• Interacted with the data team to build aggregates at various levels.
• Worked in Answers to build reports. Also created Global Prompts and filters.
• Created Dashboards and FLASH page for the top most management team in CISCO.
• Created the Tables, Indexes, Analyze scripts for the Backend Linearity tables.
• Wrote PL/SQL procedure to load data in backend for Linearity reports.
• Wrote the event poll script for cache clearing.
• Scheduled the Linearity Jobs in Dollar U environment.
• Created the Calendars, UPROCS, Sessions, Tasks and Launches in Dollar U for the linearity Jobs.
• Did Knowledge transfer to the offshore team for supporting Dollar U Job run.
• Created the test data.
• Wrote test scripts in both the environments BI and EDW, for testing the data for reconciliation.
• Logged the defects in the Quality center tool, and fixed the issues.

Environment: Siebel Analytics 7.8.2.3, Informatica 6.1, Oracle 9i, Dollar Universe, Sun Solaris, Windows XP.
Industry: Manufacturing

Client: Confidential, Feb’05 - Jun’05
BI Business Analyst / Senior Lead Siebel Analytics Consultant
Confidential, petrol card is a solution for organizations, which needs to centralize and track the fuel and service of their fleets systems. The Customer care team is a contact point for all the queries and tickets raised by the customers. The Customer, fleet, driver and billing details are handled by a Siebel Call Center application.
This Siebel Call Center application is plugged with Siebel Analytics to analyze & generate interactive reports.

Responsibilities
As a Business Analyst,

• Worked with the Business team to gather the Business requirements.
• Analyzed the requirements and identified Gaps.
• Prepared the Business Understanding Document and Technical Relationship Document as well.
• Suggested a few changes to the Business team to make the look and feel better and on tool specific functionalities.
• Documented the functionality and calculations.
• Assisted the Project Manager with the Project Plan to identify potential risks.
• Created mock reports for the users to get their feedback and implemented those changes in the actual reports.
• Was incharge of the testing phase of the project, and created Unit test plans and did testing on all reports for their functionality.

As a Siebel Analytics Consultant,

• Installation, Configuration & administration of Siebel Analytics.
• Created repositories that include Physical layer, Business Modeling mapping layer & Presentation layer to reflect the business.
• Implemented the Repository level & data level security methods to restrict & control the data, which is exposed to the end users.
• Cache management and enhancing query performance.
• Developed highly interactive business intelligent report using Global filters, Charts, Pivot tables etc.
• Configured Siebel Analytics scheduler and generated proactive Delivers-iBot alerts.
• Configured Siebel Analytics Briefing book to port the entire needed request to a lightweight report easy for users to view the reports offline.
• Took backups of repositories and Webcat files.
• Installated and configured Informatica Repository Server.
• Developed mappings, mapplets. Configured Workflows to port all the data from oracle OLTP database to oracle OLAP database.
• Configured different Transformations like Source Qualifier, Filter, Sorter, Aggregator, Expression, Joiner, Normalizer, Lookups, Sequence Generator, Router, and Update Strategy.
• Configured Transformations by using complex transformation expressions Mapping Parameters and Variables.
• Validated the data between the OLTP & OLAP database.
• Documented the Mappings and workflows explaining the functionality and purpose of Mapping and Workflow for further reference.
• Created the test data for the various scenarios.
• Wrote test scripts in SQL, to test the data in the BI environment and its source.

Environment: Siebel Analytics 7.5.2, Informatica 6.1, Oracle 9i, Windows NT.

Client: Confidential, Sep’04 - Feb’05
Employer: Wipro Technologies

This project involved analyzing the Confidential, printer usage by the various customers of Confidential,.
The project is a Datawarehousing project where reports were created using Siebel Analytics.

• Worked with Business Analyst, Discussed and Gathered the Analytics requirements from different user groups and created the Business Model using Star and Snowflake schemas.
• Installed and Configured Siebel Analytics Administration.
• Created Repositories, Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Siebel Analytics Admin Tool.
• Created Dimensions, Aggregations and Levels using admin tool in the Business Model and Mapping Layer.
• Set up Groups, access privileges and query privileges with the Security settings in Siebel Analytics Administration Tool.
• Configured repository & session variables to get dynamic reports and dashboard.
• Involved in Cache mgmt.
• Customized Reports and Dashboards using Siebel Analytics Web.
• Used prompts such as Global Filters, Column Filters for the user to select the value during run time.
• Configured Siebel scheduler and generated iBot alerts for different threshold values.
• Created test plans, and wrote test scripts for the data in the Business Intelligence environment to be compared against its source. The test scripts were SQL.
• Created the test data for the various scenarios.
• Tested the data and logged in the issues.
• Was involved in fixing the defects in the BI environment and also the ETL code.

Environment: Oracle 9i, Informatica 6.1, PL/SQL, SQL Loader, Siebel Analytics7.5.2, Windows XP, Confidential, UNIX Server.
Industry: Manufacturing

Client: Confidential,Hard Jan’04 - Aug’04
DW Analyst / Siebel Analytics Developer
Confidential,hard specializes in surface and materials science. The project is a Full Life Cycle Datawarehousing project where Informatica was used as the ETL and Siebel Analytics was used to generate Reports.

Responsibilities

• Identified the granularity level of the data required to be available for analysis
• Gathered business data to design the business model.
• Analyzed and converted the hierarchy of Facts and Dimension tables before performing the ETL process.
• Performed the Incremental ETL process to populate the Data Warehouse.
• Recognized some critical and non-critical areas of impact in terms of performance and user interface.
• Customized the Physical, Business Model and Mapping, and Presentation layers of metadata repository.
• Built Logical Hierarchies and level based measures.
• Managed users and their priveleges using the Security manager option in the repository.
• Increased the performance of the reports by caching them.
• Created variables to capture User session information and also variables to handle changing current months dynamically in the reports.
• Customized the Dashboards by appropriately including guided navigational links and drilldowns to maintain effectiveness.
• Optimized complex OLAP requests by dividing into multiple queries. This feature has a top to down approach when viewing the data and was implemented using drilldowns.
• Used Filters and provided customized prompts appropriately to avoid excessive data showing up on Analysis Reports.
• Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities using the Security Manager option.
• Setup delivery of analytics alerts as per the user requirements and to users preferred device.
• Worked closely with the Data Architecture team to design the aggregate tables needed for the reports for performance.
• Created ETL specifications, and Informatica Mappings, Mapplets using Informatica Designer.
• Defined Source and Target Definitions and Scheduled Informatica Jobs.
• Configured and ran test sessions using Informatica Server Manager.
• Used Informatica Workflow Manager to define Sessions, create tasks using Task Developer and involved in the functional execution of the workflow.
• Used various transformations such as Router, Lookups, Aggregator, Stored Procedure, etc.
• Analyzed, Designed, Validated and Tested ETL maps.
• Used Informatica Workflow Monitor to monitor the Workflows and see log information for trouble shooting in case if the task fails.
• Created test plans, and wrote test scripts for the data in the Business Intelligence environment to be compared against its source. The test scripts were SQL.
• Created the test data.
• Tested the data and logged in the issues.
• Fixed the defects in the BI environment, based on the defects logged.

Environment: Oracle 9i, Informatica 6.1, Siebel Analytics7.5.2, Windows XP, Sun Solaris Server.
Industry: Manufacturing

QUALIFICATION
Master in Computer Applications
Bachelors in Commerce