Sap Bo Administrator Resume
SUMMARY:
- 11 + years of IT experience in implementing Data Warehouse applications and BI applications using SAP Business Objects, SAP HANA, Qlikview.
- Experience with Self - service BI and Agile BI development and Availability for occasional travel based on client and project needs.
- Hands on Experience in SAP HANA, SAP Landscape Transformation( SLT) and SAP HANA Design studio.
- Hands on Experience implementing SAP Business Objects 4.x reporting on top of SAP HANA.
- Experience in gathering User Requirements, and involved in preparing detailed Functional and Technical documents.
- Flexible and versatile to adapt to any new environment with a strong passion to keep pace with latest technologies.
- Experience in working in onsite-offshore structure and effectively coordinated tasks between teams.
- Business Objects reporting Expertise in installing, configuring, deployment, Upgradation and maintenance of SAP Business objects applications using BI Launch Pad, Infoview, CMC, CCM, Desktop Intelligence, Web Intelligence, Information Design Tool, Universe designer, Import Wizard, LCM, UMT, Translation Manager, Report Conversion Tool, Life Cycle Manager, Query Builder, Live Office.
- Hands on Experience in Upgrading/migrating in Business Objects Enterprise .Installation and configuration of SAP Business Objects Enterprise and client tools on Windows server.
- Excellent experience in creating/debugging Universes with Business Objects XI R2, 4.x Universe Designer Module, Information Designer Module, reports using BO Web I, Web I Rich client, Desktop Intelligence from SAP & Non SAP Data Sources, Creating Dashboards using SAP BO Dashboards Using universe query, Live Office data driven from Business objects web intelligence reports.
- Developed dashboard BOBJ 4.x integrated BODS 4.x with SAP HANA1.x, Designed, developed, tested the Web I documents and scheduled for the required users.
- Exclusively worked on HANA Modeling in HANA Information Model design: Attribute View, Analytic View and Calculation Views as per the Business requirement.
- Strong experience in relational Database modeling and Star Schema design.
- Creating Packages, Attribute views, Analytical views and Calculation views by using SAP HANA studio.
- Successfully lead complex projects with global and rapidly evolving requirements.
- Effective communication skills and record for coordination between globally located teams.
- Project delivery under stringent timelines and high pressure.
- Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
- Experience in Project Leading, Project Schedule, Project Tracking and Team Management
TECHNICAL SKILLS:
Enterprise Reporting: Business Objects 5.x,6.x / BO XIR2/BI 4.x,Qlikview, BEx analyzer
ETL: Informatica, SAP BODS
RDBMS: Oracle, MS SQL, SQL Server, SAP HANA
OS: Windows 2003/2000/98, UNIX (Sun Solaris, Linux)
PROFESSIONAL EXPERIENCE:
Confidential
SAP BO Administrator
Responsibilities:
- Installation and Administration of SAP Business Objects Business Intelligence Platform 4.x and client tools on Windows Server and software products like Tomcat, and Apache load balancer (Clustered and Standalone environments).
- Validated the installation by checking the Applications, public folders, Reports in Personal folders, Groups, security, Scheduling and by creating some sample reports based on universe and BICS, PMT, Verified the remaining Business Objects installation works without any issues.
- Transferred CMS data From old BI 4.1 Sp4 Patch 12 to new version through DB repoint, BIAR File/live-to -live.
- Integrate SAP BW with SAP BI4.2 along with SSO.
- Clustering and Un-clustering different Business Objects servers, configuring, Deploying Tomcat web applications & Load balancing.
- Perform Business Objects Server Management Tasks, using Central Management Console (CMC) and Central Configuration Manager (CCM).
- Setting up rights on different objects (users, user groups, severs, applications, folders).Building a security model using the new features of SAP BI 4.x Access levels, granular rights, and application specific rights.
- Worked with server team to provide them with list of specifications need to build the servers for BI 4.X.
- Responsible for managing scope, planning, tracking, change control, aspects of the project.
- Served as a focal point to communicate and resolve interface and integration issues with other teams.
- Escalate issues, which cannot be resolved by the team. Provide guidance to the team based on management direction.
Environment: SAP Business Objects Enterprise XI 4.x,Explorer,Lumira,Analysis Office, Windows, SQL Server
Confidential
SAP Business Objects Developer
Responsibilities:
- Interacted with Business Users, Business owners to know their Business requirements in developing and modifyingUniverse, Reports and dashboardsaccordingly.
- Delegating work to other team member to reach the project deadlines and guiding them as mentor
- Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs.
- Created universe (using IDT), created Webi Reports and Dashboard.
- Extensive experience in Development, Testing, Documentation, Requirement analysis, End user documentation, Data extraction, Data modeling, Data loading, Reporting and Production Support.
Environment: SAP Business Objects Enterprise XI 4.x
Confidential
SAP Business Objects Developer
Responsibilities:
- Interacted with Business Users, Business owners to know their Business requirements in developing and modifyingUniverses and Reportsaccordingly.
- Delegating work to other team member to reach the project deadlines and guiding them as mentor
- Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications forBusiness Objects Universes and Reports.
- Appliedsecurity featuresof Business Objectslike row level, report level & object level securityin the universe so as to make the sensitive data secure.
- Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
- Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs.
- Created complex reports by linking data from multiple data providers, stored procedures and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.
- Knowledge about SAP HANA Architecture which includes setting up modeling environment,
- Created analytical, calculation and attribute views using SAP HANA 1.0 HANA Studio and created SAP BO Universe and Webi Reports.
- Worked with the SAP Basis team to setup the SLT replication for Sql Server tables into SAP HANA Databse.
- Created universe (using IDT) on HANA views to expose the data in BO 4.1 Webi
- Extensive experience in Development, Testing, Documentation, Requirement analysis, End user documentation, Data extraction, Data modeling, Data loading, Reporting and Production Support.
Environment: SAP Business Objects Enterprise XI 4.x, SAP HANA
Confidential
SAP BO Administrator
Responsibilities:
- Installation and Administration of SAP Business Objects Business Intelligence Platform 4.x and client tools on Windows Server and software products like Tomcat, and Apache load balancer (Clustered and Standalone environments).
- Uninstalled BI 4.0 Sp2 from the server to install and cleaned registries before the installation BI 4.0 Sp4
- Validated the installation by checking the Applications, public folders, Reports in Personal folders, Groups, security, Scheduling and by creating some sample reports based on universe and BICS, PMT, Verified the remaining Business Objects installation works without any issues.
- Transferred CMS data between old BI 4.0 Sp2 Patch 12 and new version through BIAR File/live-to -live.
- Integrate SAP BW with SAP BI4.1 along with SSO.
- Clustering and Un-clustering different Business Objects servers, configuring, Deploying Tomcat web applications.
- Perform Business Objects Server Management Tasks, using Central Management Console (CMC) and Central Configuration Manager (CCM).
- Setting up rights on different objects (users, user groups, severs, applications, folders).Building a security model using the new features of SAP BI 4.x Access levels, granular rights, and application specific rights.
- Reverse engineered and optimized reports
- Worked with server team to provide them with list of specifications need to build the servers for BI 4.X.
- Responsible for managing scope, planning, tracking, change control, aspects of the project.
- Experience in leading and managing teams. Handled multiple roles. Successful global SAP Business Objects upgrade across multiple sectors simultaneously. Project Lead, BO Administrator, and Technical Architect, Good team orientation and Leadership qualities
- Served as a focal point to communicate and resolve interface and integration issues with other teams.
- Escalate issues, which cannot be resolved by the team. Provide guidance to the team based on management direction.
Environment: SAP Business Objects Enterprise XI 4.x,Explorer,Design studio, Windows, SQL Server Confidential -PayPal(2-C company split)
SAP BI,BW,BO Developer
Confidential
Responsibilities:
- Being SAP Consultant understand the existing system landscape and modifying the reports in BI system such that the report to work in both Confidential and PayPal systems.
- Served as a focal point to communicate and resolve interface and integration issues with other teams.
- Escalate issues, which cannot be resolved by the team. Provide guidance to the team based on management direction.
- Modified Universe, modified reporting in Webi, Bex Reports for High-level reporting in BO Dashboards/Xcelsius to work for only PayPal.
- Created detailed documentation about the universe, dashboard, and Webi report modified.
- Validated SAP HANA views that have been built for Confidential and PayPal and views to be working with only PayPal after split legal day using HANA Design studio.
- Created, modified existing BODS Jobs to exclusively work for Confidential sources /targets, PayPal sources/targets in separate systems.
- Responsible for creating mapping and transformation specifications based on the business requirements from various business teams and implemented in Data Services jobs.
- Validated and executed batch jobs. Tested data flows and scripts against sample data and real data. Creation of initial and incremental load jobs.
- Trouble shot the issues on existing Bex Reports.
- Involved in the migration of all the jobs of all the developers in moving from DEV TO TEST TO PROD
- Provided the day to day support for all the scheduled jobs in the production
- Created all the technical design specifications & Functional specifications documents by interacting with the business analysts and the business users.
- Responsible for internal team on SAP HANA and BOBJ.
Environment: SAP Business Objects Enterprise XI 4.x, BODS, Windows, Oracle, SQL Server,HANA,SAP BW,BEX
Confidential
SAP - Business Objects Report&Dashboard Developer
Responsibilities:
- Being a SAP BO Consultant in the P&C reporting team responsible for detailed analysis requirements and areas of improvement, performing RCA about the pain areas and suggesting new solutions for reporting by resolving the complexity.
- Provide status reporting of team activities against the program plan or schedule.
- Keep the project manager and committee informed of task, issues and status in Agile development methodology project
- Served as a focal point to communicate and resolve interface and integration issues with other teams.
- Escalate issues, which cannot be resolved by the team. Provide guidance to the team based on management direction
- Involved in different phrases of the project like analyzing requirement, planning, execution and maintenance.
- Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documents them textually or within models.
- Developed various Informationspaces,Reports, Dashboards for P&C Product management, P&C Actuary using Business Objects 4.X
- Maintained and did enhancement to existing universes and reports generated by Business Objects developers.
- Interacted with the end users, Project Manager and other resources in understanding the requirements and writing universe, report specifications.
- Defined and created classes, objects, conditions, users and measure objects to capture complex formulae.
- Identified and resolved the performance issues in reports and tuned the universe for better performance.
- Created Universe in IDT, Detailed reporting in Webi and for High-level reporting in BO Dashboards.
- Created detailed documentation about the universe, dashboard, and webi report developed.
- Have worked Business Objects explorer IDT as source integrated to BO Dashboard.
Environment: SAP Business Objects Enterprise XI 4.1, BO Explorer, Windows, Oracle, SQL Server
Confidential
Business Objects Tech Lead
Responsibilities:
- Gathering, Analyzing & Documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports
- Designed, Developed, Tested a prototype Universe, webi report and dashboard on SAP HANA Database
- Designed, developed, tested and supported reports in Web Intelligence and in creating Complex reports with multiple universes by merging the dimensions in the Web I documents.
- Performed administrative tasks like assigning access privileges, Migrating Reports Development to UAT and Production using Import Wizard and Scheduling Web Intelligence documents using Central Management Console.
- Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions on report creation and its enhancements
- Created detailed documentation about the universe, dashboard, webi report developed.
- Delegating work to other team member to reach the project deadlines and guiding them as mentor
Environment: SAP Business Objects BI 4.0,BO Dashboards, SAP HANA
Confidential
Business Objects Tech Lead &Administrator
Responsibilities:
- Participated in project planning sessions with project managers, business analysts and Team members to analyze business requirements and outline the proposed solution.
- Prepare the Checklist/Test Plans for testing the migrated Universes, reports.
- As a part of Admin work Used Import Wizard for the Migration process. Migrated users, universes, folders, and reports, Connections, Categories Profiles etc, created the Users, groups and assigned the security
- Used Report Conversion Tool for the Conversion process from Deski to Webi reports.
- Performed administrative tasks like assigning access privileges, Migrating Reports Development to UAT and Production using Import Wizard and Scheduling Web Intelligence documents using Central Management Console.
- Configuring servers Central Management Server, Web Intelligence report job Servers
- Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions on report creation and its enhancements Modified universes, classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.
- Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
- Converted the Deski Reports to Web Intelligence Reports using the Report Conversion Tool.
- Publish, distribute and schedule Web Intelligence reports using Info view.
- Managing and supervising code migrations, and maintaining the consistency of code in 3 environments.
- Extensively worked on report performance debugging.
Environment: SAP Business Objects5.x,XI R2, Windows, Oracle, SQLserver 2000
Confidential
Business Objects Administrator
Responsibilities:
- Participated in project planning sessions with project managers, business analysts and Team members to analyze business requirements and outline the proposed solution.
- Installation and Administration of SAP Business Objects Business Intelligence Platform 4.x and client tools on Windows Server and software products like Tomcat.
- Used Upgrade Management Tool and Life cycle Manager for the Migration process. Migrated users, Universes, Folders, Reports, Connections, Categories Profiles etc.
- Coordination and work along with the managers to ensure the timely execution of project as well as testing the quality of data and providing inputs to them.
- Delegating work to other team member to reach the project deadlines and guiding them as mentor.
- Setting up rights on different objects (users, user groups, severs, applications, folders).Building a security model using the new features of SAP BI 4.x Access levels, granular rights, and application specific rights.
- Performed Analysis of migration content to the new environments and testing of universes, reports functionalities, reports performance, Dashboards functionalities in the new environments before migrating
- Business Objects Enterprise environment setup, server installations, implementation, upgrades, Configured Report Servers, testing
- Worked and Creating Complex reports using Multiple Queries to satisfy the Report Requirements
- Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
Environment: SAP Business Objects BI 4.0 SP2/XI R2 SP2, UMT,LCM, Windows Server 2003,2008 .
Confidential
Business Objects Administrator & Developer
Responsibilities:
- Worked directly with projects team members and business users to translate business requirements into technical specifications to drive semantic layer and report development, Analyze, design, and develop new Business Objects reports against existing universes, including universe-based webi reports and free hand SQL reports
- Analyze data processes to support the automation, efficiency and reporting Resolving tickets timely manner.
- Used Import wizard for the Migration process. Migrated users, universes, Folders, reports, Connections, Categories Profiles etc.
- Reporting, ETL Code Migration in promoting from Development to UAT and Production Environments
- Designing and building Universes, Classes and objects and defining the necessary connections
- Provided technical assistance to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
- Involved in migration of universe, Inserting tables, Detecting joins, Detecting cardinalities and checked the integrity.
- Modified universes, classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.
- Delegating work to other team member to reach the project deadlines and guiding them as mentor.
- Publish, distribute and schedule Web Intelligence reports, Implementing change management and version control standards.
- Business Objects Enterprise environment setup, server installations, implementation, Configured Report Servers, testing.
- Designed, developed, tested Web I documents and scheduled for the required users
- Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Mart and Power Center
- Used several transforms in BODS /Informatica mining and organizing massive data sets of both structured and unstructured data.
- Used DS objects like transforms, scripts, Data flows, Workflows in initial load and delta load mappings.
- Prepared the Business/Technical Requirements, Design Templates, Development Standards document and detailed design documents.
- Developed number of Complex data Services Mappings and Reusable Transformations to facilitate Daily, Weekly & Monthly Loading of Data.
- Actively involved in the production support and also transferred knowledge to the other team members.
Environment: SAP Business Objects Enterprise, SAP BODS, Windows, Oracle 11i,informatica,sql server,Linux
Confidential
Business Objects reports Developer
Responsibilities:
- Analyze data processes to support the automation, efficiency and reporting Resolving tickets timely manner.
- Used Import wizard for the Migration process. Migrated users, universes, Folders, reports, Connections, Categories Profiles etc.
- Designing and building Universes, Classes and objects and defining the necessary connections
- Developed reports using Web Intelligence based on user requirements
- Created charts based web Intelligence documents, Created reports with break, sections, merging columns.
- Implementing row level security in Universe
- Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
- Involved in migration of universe, Inserting tables, Detecting joins Detecting cardinalities and checked the integrity.
- Modified universes, classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.
- Implementing change management and version control standards.
- Designed, developed, tested the Web I documents and scheduled for the required users
Environment: SAP Business Objects Enterprise XI R2, Windows, Oracle 11i,sql server
Confidential
Business Objects reports Developer
Responsibilities:
- Analyze data processes to support the automation, efficiency and reporting Resolving tickets timely manner.
- Used Import wizard for the Migration process. Migrated users, universes, Folders, reports, Connections, Categories Profiles etc.
- Designing and building Universes, Classes and objects and defining the necessary connections
- Developed reports using Web Intelligence based on user requirements
- Created charts based web Intelligence documents, Created reports with break, sections, merging columns.
- Implementing row level security in Universe
- Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
- Involved in migration of universe, Inserting tables, Detecting joins Detecting cardinalities and checked the integrity.
- Modified universes, classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.
- Implementing change management and version control standards.
- Business Objects Enterprise environment setup, server installations, implementation, upgrades, Configured Report Servers, testing.
- Designed, developed, tested the Web I documents and scheduled for the required users
Environment: SAP Business Objects Enterprise XI R2, Windows, Oracle 11i,sql server
