SUMMARY:

• 9 Years of experience in Information Technology as a with a thorough understanding of SDLC methodology and having in-depth knowledge in Architecture, Analysis, Design and Development of Data Warehouse and Business Intelligence applications.
• Extensively worked on all the phases of Data warehouse life cycle from Requirement Gathering, Infrastructure Setup, Analysis and Design to Project Support
• Expertise in BO 4.0, BO 3.1, BO-XIR2 BO 6.5 Architecture, Implementation, Universe Design, Reports Development Administration along with Crystal Report Design
• Have expertise in creating Interactive and for better Data Visualization Dashboards using Tableau 7 8, Xcelsius Dashboard 4.0 , MicroStrategy 9.3 and OBIEE.
• Hands on experience in SAP HANA modeling. Created multiple schemas and table definitions. Experienced in creating Attribute views, analytical view and calculated views.
• Analyze and understand business requirements, explore and evaluate various options, develop prototype using reporting and dashboard tools thereby validating the requirements, eliminating ambiguity and providing early visibility to business on the final solution
• Have experienced in Google Query and Google Analytics.
• Extensively worked on ITSM domain. ITIL V3 Foundation and Service Operations Certified.
• Extensive knowledge and experience in IT Service Operations.
• Excellent understanding and experience in Data Warehouse methodology dimensional modeling.
• Experienced in designing the logical and physical Data Modeling/ER-Modeling using Erwin tool/ER Studio and designing the data warehouse using star schema/snow-flake schema and dimensional modeling.
• Have Expertise knowledge and experience in SAP Integration with Business Objects.
• Have expertise knowledge in creating OLAP universes and reports based on the OLAP Cubes SAP-BI MSAS , Infocubes, Multi providers and BEx queries using Business Objects.
• Have knowledge in creating a BI data model with InfoObjects characteristics, key
• figures and an InfoCube for storing data in the SAP BI system. Map the source structure of the data in the BI system and define the transformation of the data from the source structure to the target format. Loading the data in DataSource using InfoPackages
• Have expertise knowledge in designing/creating BEx Queries using SAP BW Tool Business Explorer Analyzer .
• Experienced in customizing Business Objects code using BO SDK.
• Strong understanding of relational databases with hands on experience in SQL programming
• Have good knowledge in Operational Data Store ODS , OLAP and ETL Informatica and BODS .
• Experienced in doing Impact Analysis and Gap Analysis for business users.
• Experienced working as liason between IT and Business Users and supporting the users.
• Experienced working proactively in identifying the issues and escalating and communicating the issues to the business clients.
• Experienced in preparing test cases of the business process or application.
• Experienced in presenting trainings to the wider audience.
• Excellent experience in managing team Onsite and Offshore model also of any size.
• Excellent communication skills, Passion for analysis and reporting, Fast Learner Dedicate, Hard worker and Good Team player.

Technical Proficiency:

• Business Intelligence: Business Objects 4.0, 3.1, XIR2 6.5, Xcelsius Dashboard , Tableau 7 8, SAP 7.1, SAP BW Front-End Tool Business Explorer Analyzer , Crystal Reports 2010, Voyager, BODS, Informatica 8.6 , Business Objects Mobile XI, OBIEE R11, Microstrategy 9.3
• Databases: SAP HANA, Oracle, SQL Server, MSAS and MS Access 7.0
• Data Modeling Tool: Erwin ER Studio
• Prog Languages: SQL.
• Operating Systems: AIX, Sun Solaris, Linux, Windows
• Front End Tools: TOAD, SQL developer.
• Server Environment IIS 5, Apache and Tomcat
• Application Software BMC Remedy ITSM, MS-Office Suite.

Career profile: Project Wise

Senior/Lead Consultant

Confidential

Project Title: PSO for BMC Analytics and Dashboard

BMC Software has a product called BMC Remedy IT Service Management Suite that is used by many companies for IT Service and Management ITSM . BMC Analytics for BSM provides a set of analysis tools and reporting features that allow you to analyze the application data from BMC Remedy IT Service Management ITSM , BMC ProactiveNet, BMC Performance Manager Portal, and BMC Impact Portal and create ad hoc reports.BMC Analytics for BSM uses SAP Business Objects Enterprise Professional, a third party business intelligence system, as the host for the universes and reporting engine that administers and publishes the reports. The universe provides a business user's view of the BMC Remedy ITSM application data.

Responsibilities:

• Requirement Gathering Development
• Installation Configuration
• Product Demonstrations and Workshops
• Conducted Product demos at Customer sites
• Conducted Workshops on ITIL Metrics/KPIs and Industry best practices for reporting
• Performed Server Sizing for Business Objects Installation in Dev, QA and Prod.
• Installed BOXI3.1 and BMC Analytics.
• Set up user security for system access as per customer requirements
• Gathered requirements from the End Users to identify the Reporting needs
• Translate the functional requirements to high level design and build technical specifications document
• Created custom charts and Dashboards to display the impact of system health and performance on business
• Designed custom derived tables and universe customizations to meet the reporting requirements.
• Designed Analytics Reports as per requirements
• Performed data validation
• Provided Production Support
• Performed Business Objects deployment troubleshooting.
• End user Training Documentation
• Trained the end users to create new dashboards, analytics reports and BOXIR2 / 3.1 administration activities
• Documented the BMC Analytics Dashboards Customization and Design

Environment: Business Objects 3.1, Xcelcius Dashboard 4.0 , Tableau 7, Oracle, BMC Analytics 7.6.01, BMC ITSM 7.6.04, Remedy AR System 7.6.04 for ITSM, BMC Dashboard for BSM 7.6.03

Technical Lead Confidential

• The eCommerce Solution Dashboard and GIO Dashboard are being delivered as part of the ESQI Program and will remain operational as part of the resulting ITSM enabled solution. Objectives are:
• Define top KPI and metrics for eCommerce that will demonstrate IT's delivery of service per commitments
• To identify the most important eCommerce delivery metrics that allow improvements to be quantified and tracked
• To locate and model the data sources that support the eCommerce delivery KPIs and metrics
• Deliver an executive dashboard that demonstrates IT's delivery against the commitments of the Solution Definition
• Automate the data publication as much as possible
• Leverage existing platforms and tools
• IT User Experience team to design a user focused experience in Tableau
• Deliver a repeatable and scalable model, utilizing Data Governance, that enables reporting of other solutions or services

Responsibilities:

• Held over all responsibilities of delivering the project to customer in both technical and management perspective.
• Design Implement systems that meet the information delivery needs of business intelligence systems perform technical and advisory functions in the development of business objects architecture and the creation of frameworks for reporting, dashboards, delivery, scheduling
• Work with the business management in gathering the requirements to ensure business objects and Microstrategy/Tableau are appropriately utilized for all required management and adhoc reports and Dashboards.
• Designed HANA model in SAP HANA and created the Attribute, Analytics and Calculation Views.
• Conducted Workshops on ITIL Metrics/KPIs and Industry best practices for reporting and dashboards.
• Designed Service Desk GIO Global Performance using Tableau and eCommerce Dash using Microstrategy considering best practices for Data Visualization and Interactive.
• Providing guidance and mentoring a team of 7 in Business Objects, Tableau, Microstrategy, BODS and SAP HANA.
• End user Demo, Training Documentation

Environment: Business Objects 3.1, Tableau 8, Microstrategy 9.3, SAP HANA 1.0.5, BODS, Oracle, Remedy AR System 7.6.04 for ITSM

Senior/Lead Consultant Confidential

BMC Software has a product called BMC Remedy IT Service Management Suite that is used by many companies for IT Service and Management ITSM . BMC Analytics for BSM provides a set of analysis tools and reporting features that allow you to analyze the application data from BMC Remedy IT Service Management ITSM , BMC ProactiveNet, BMC Performance Manager Portal, and BMC Impact Portal and create ad hoc reports.BMC Analytics for BSM uses SAP Business Objects Enterprise Professional, a third party business intelligence system, as the host for the universes and reporting engine that administers and publishes the reports. The universe provides a business user's view of the BMC Remedy ITSM application data.

Responsibilities:

• Requirement Gathering Development
• Installation Configuration
• Product Demonstrations and Workshops
• Conducted Product demos at Customer sites
• Conducted Workshops on ITIL Metrics/KPIs and Industry best practices for reporting
• Performed Server Sizing for Business Objects Installation in Dev, QA and Prod.
• Installed BOXI3.1 and BMC Analytics.
• Set up user security for system access as per customer requirements
• Gathered requirements from the End Users to identify the Reporting needs
• Translate the functional requirements to high level design and build technical specifications document
• Created custom charts and Dashboards to display the impact of system health and performance on business
• Designed custom derived tables and universe customizations to meet the reporting requirements.
• Designed Analytics Reports as per requirements
• Performed data validation
• Provided Production Support
• Performed Business Objects deployment troubleshooting.
• End user Training Documentation
• Trained the end users to create new dashboards, analytics reports and BOXIR2 / 3.1 administration activities
• Documented the BMC Analytics Dashboards Customization and Design

Environment: Business Objects 3.1, Xcelcius Dashboard 4.0 , Tableau 7, Oracle, BMC Analytics 7.6.01, BMC ITSM 7.6.04, Remedy AR System 7.6.04 for ITSM, BMC Dashboard for BSM 7.6.03

Business Objects Lead Confidential

Stanford has its financial data in Oracle Apps that is also the core transactional database for all kind of reporting. The project was to upgrade the Oracle Apps R 11 to R 12. This has a huge impact on all the reports running on Oracle Apps R11. Many tables got replace, deleted, renamed and new views were created. There were around 30 Universes and 159 reports that got impacted with this upgrade. Re designing the Data model along with retrofitting all the universes and reports was the main objective along with designing new reports for ORA Project. I have designed dashboard in OBIEE for ORA Office of Research Administration Project as a POC.

Responsibilities:

• Participate in design of Data warehouse data model and provide input and feedback from a Business Intelligence tool perspective.
• Worked on the Impact Analysis for all the 30 Universes and 159 reports.
• Re-designed all the Universe and reports.
• Created and Developed the Repository rpd and dashboard for ORA POC.
• Involved in setting up the environments for OBIEE including installation.
• Gathered the complex business requirements and did business analysis to write functional specification document for new reports
• Trouble shooting the issue Development related which arises during the time of UAT.
• Involved in the performance tuning of reports using indexing, partitioning etc.
• Involved in documenting the business process by identifying the requirements.
• Documenting all the Data Mapping documents, Design documents, Test Plan Documents.
• Worked as Business Objects Lead and allocated work to junior team members and guide them for successful accomplishment of same.

Environment: Business Objects XIR2, Oracle 10 g, Oracle Apps R11, Jira

BI Technical Lead Confidential

The project is about migration and re-pointing/re-writing of all the critical and scheduled reports which are in the BOXIR2 environment to BOXI 3.1 environment, which the users used to analyze the telecom industry data. These reports give complete information about the Mobile phone accounts, subsriptions, service plans, stores, sales, billed usage etc.

Responsibilities:

• Worked directly with the business users and capture simple, moderate and complex business requirements.
• Assisted in defining the scope of the project, technical and business specifications
• Gathered the complex business requirements and did business analysis to write functional specification document for new reports
• Worked in the data mapping, designing phase and deploying the 4 Universe and 200 reports.
• Working on building new BO reports with BDW, POS, IPS and ODS2 universes.
• Creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Developed Cross-tab and Tabular reports from multiple data providers or data sources.
• Designed 2 dashboard using Xcelsius 2008 using Query as Web Services.
• Presented Trainings to the higher managements using PowerPoint.
• Trouble shooting the issue Development related which arises during the time of UAT.
• Involved in the performance tuning of reports using indexing, partitioning etc.
• Involved in documenting the business process by identifying the requirements.
• Documenting all the Data Mapping documents, Design documents, Test Plan Documents.
• Worked as BI Technical Lead and allocated work to junior team members and guide them for successful accomplishment of same

Environment: Business Objects XI 3.1, Xcelsius 2008, Query as Web Services Oracle 10 g

Business Objects Technical Lead Confidential

To provide a prototype for SAP BI competency and as a SAP- BW integrator, a BI model was design to fulfill the requirement of incorporating all the functionality on how to create a BO report from SAP queries, i.e. BEx queries and Multi providers. These reports were used to view in Business Objects Mobile XI.

Responsibilities:

• Understanding requirement of generating the reports out of Cubes, BEx queries / multi providers.
• Involved in creation of Info Areas, Info Objects, Info Cubes, and DSO's, and created required Transformations and DTP to load data into Data Targets.
• Involved in creating the generic data sources.
• Involved in uploading Master Data and Transaction Data from Different Source systems.
• Created an OLAP universe out of the BEx queries / Multi providers in Business Objects designer by connecting to the SAP Source.
• Designing and Reviewing the Security Structure following the best practices to enable a high secured Environment
• Maintaining and monitoring the Application Audit Reports.
• Maintaining the BO Servers and performance tuning of all the BO servers
• Created Variables, hierarchies and custom prompts based on these hierarchies.
• Once the universe was developed, tested and exported to the repository, created WebI reports from them to view in Business Objects Mobile XI
• Worked as Business Objects Technical Lead and allocated work to junior team members and guide them for successful accomplishment of same

Environment: Business Objects XI 3.1 and SAP BW, Business Objects Mobile XI 3.1

Business Objects Lead Confidential

The project deals with building an End to End solution of Data warehouse. The goal was to build an EDW for the SSS Metric. This project is to provide a solution for the Shared Service System of GE Corporate. SSS Metric is about the Invoices, Purchase Orders and Requisitions for all the Vendors across multiple Organizations all over the world. There are 4 subject areas Account Payable, Markview, Purchase Order and Requisition. Based on these subject areas we have developed a single universe and 200 reports. The source system was Oracle Apps. Earlier there was a Web Portal to generate the reports, which was very slow in performance. So to over come this potential drawback, we provided the solution of using Business Objects as reporting tool and Informatica as an ETL tool.

Responsibilities:

• Involved in preparing the proposal on response of RFP for the SSS Metric Project. Gathered the requirement from the client and also provided the estimation to build 200 reports and universe.
• Worked closely to gather the requirement and suggested best possible design of Data Model based on the reports requirement.
• Worked in the data mapping, designing phase and deploying the Universe and 200 reports
• Extensively used Toad for database analysis, performance tuning and trouble shooting.
• Involved in data modeling of OLTP systems
• Implementing the Row Level and Object Level Restriction on the Groups.
• Designing and Reviewing the Security Structure following the best practices in BOXIR2 to enable a high secured Environment.
• Maintaining the BO Servers and performance tuning of all the BO servers.
• Presented Trainings to the higher managements using Powerpoint.
• Trained the key users for usage of SSS Metrics Universe, developing the queries and usage of Info view module.
• Designed Xcelsius reports out of SSS Matrix Universe.
• Trouble shooting the issue Development related which arises during the time of UAT.
• Involved in the performance tuning of reports using indexing, partitioning etc.
• Involved in documenting the business process by identifying the requirements and also involved in finding the system requirements.
• Documenting all the Data Mapping documents, Design documents, Test Plan Documents and preparing best practice documents.
• Worked as Business Objects Lead and allocated work to junior team members and guide them for successful accomplishment of same.

Environment: Business Objects XIR2, Xcelsius and Oracle 10g

BO Administrator Lead Confidential

• The project deals with the migration, testing and fixing of around 6000 corporate documents and 130 universe from BO 6.5.4 to BO XIR2 of around 30 Data Warehouse and also migrating 15000 worldwide users. This also involves migration of around 50GB 20000 of Personal Documents. Project also includes creation of 75 WebI documents from existing Crystal Reports 10. A completely new Security Setup was implemented in XiR2 by following the existing security of 6.5. There has been a customized enhancement of Business Objects login process as well as automation of some functionality with the help of BO SDK. An automated process of adding the bulk users into the repository using BO SDK was also implemented. This project basically divided into 3 phases following the strategy of incremental migration.
• I was at onsite for 3 months during the first phase to gather the requirement and setting up the New Environment. I have designed and implemented the Security Structure following the Best Practices to enable a high secured Environment. I have migrated all the content of Phase 1 groups to BOXIR2 from legacy system BO 6.5.

Responsibilities:

• Involved in preparing the proposal on response of RFP for the BOXI Migration Project and also gathering the requirement.
• Setting up the 3 Environments Dev, Stage and Prod where stage and production are horizontal clustered one.
• Configuring the SSO Siteminder with Business Objects Enterprise for Single Sign On.
• Designing, Implementing and Validating the Security Structure following the best practices in BOXIR2 to enable a high secured Environment.
• Designed a document for validating the security structure of the users, groups, folders and applications.
• Implementing the Row Level and Object Level Restriction on the Groups.
• Migrating the Content Corporate/Personal Documents, Groups and Users etc from BO 6.5 to BOXIR2 using incremental method.
• Involved in the understanding the requirement, designing phase and deploying the customized pages as customized login, Logoff etc. using BO SDK for user's login into the BOXI.
• Involved in the understanding the requirement, designing, deploying the customized Automated User Addition Code using BO SDK for adding bulk of user into the BOXI.
• Customizing the BO code for achieving some functionality as per the functional user's requirement. For example: - Send to Functionality, Disabling the Send options and discussion thread.
• Maintaining and monitoring the Application Audit Reports.
• Trouble shooting the issue Admin/ Development related which arises during the time of UAT.
• Maintaining the BO Servers and performance tuning of all the BO servers.
• Documenting all the functionalities and preparing best practice documents.
• Allocate works to junior team members and mentor and guide them for successful accomplishment of same.

Environment: Business Objects XIR2 CMC, Infoview, Designer, Business Objects 6.5, Supervisor, BCA and Oracle 10g 9i

Business Objects Support Consultant Confidential

Provide technical support to all the Business Objects customers. It involves both Outbound and Inbound Calls. Basically involves in troubleshooting the customers issues.

Responsibilities:

• Understand functionality level and technical level of the issues.
• Troubleshooting all design and architectural issues of different Business Objects Products and version.
• Providing solution for universe, reports and administration issues.
• Replicate the customer issues by replicating the customer environment in house.
• Research on the customer issues through various BO informative sites
• Depending upon the issue, created different reports like DESKI, WEBI Crystal.
• Online updates Direct contact with the Customers.
• Extensively worked with people soft CRM.
• Resolved the issues related to different Business Objects Products and Versions.
• Installation configuration of various Business Objects Products and Versions.

Environment: Business Objects 5x/6x/XI/XIR2, Web Intelligence 2.7.2, Crystal Reports and Oracle 8i/9i.

Business Objects Consultant Confidential

This is a survey tool, which helps organizations to seek, capture and analyze feedback on their products, services and employees an ongoing basis in real time. Generate various graphical reports to Organizations, which helps them in identifying their week parameters in their business and helps them in improving their business in future, by taking necessary actions. Also there were four BO Server in which primary node cluster is configured. All the four servers have common Repository connected to it and common file storage system.

Responsibilities:

• Involved in the design of the Universe, the metadata layer of Business Objects in the Designer module.
• Defined hierarchies of classes and subclasses into the model reflecting the business concepts.
• Created measure objects, which are derived from aggregate functions.
• Constructed management reports flexible and standard using Business Objects Reporter tool.
• Understand functionality level of business needs for Installation.
• Understand the compatibility of the Environment for the Business Objects Setup.
• Provide the Architecture suitable for the existing environment with best performance.
• Configured the cluster in all the four servers with primary nodes in each server.
• Configured the BCA in all the four servers.
• Configured the Auditor module in all the four servers with common Auditor Database Repository .
• Performed the validation and UAT User Acceptance Testing for all the four servers, Universe and Reports.

Environment: Business Objects 5.x , Auditor, Oracle 9i