SUMMARY

• Over 9 years of IT experience as a Business Intelligence Architect (SAPBOE,HANA,IBM Cognos, Tableau, Power BI,Qlikview,Epic) in different areas such as Analysis, Design, Support and Maintenance.
• Exposed to Data Warehouse assignments in various domains (Banking, Insurance, Retail and Healthcare)
• Effectively supervised and administered the SAP BO BI Universe Designer, Information Design Tool, Web Intelligence, Info View, BI launch pad, Desktop Intelligence, Rich Client, Central management console, Upgrade Management Tool and Crystal Reports.
• Strong administrative and development knowledge of Cognos environment and tools IBM Cognos BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio)
• Have extensive experience in SAP Migration, security and Upgrades
• Upgraded large Health care Business Objects Environment to BI 4.2 SP4 with over 15000+ reports and 5000 users
• Created completely new architecture for BI 4.2 SP3 clustered environment.
• Upgraded BOE 4.1 environment from BO XIR2 for Insurance client with over 10000+ financial reports.
• Successfully migrated over 140+ application objects from BO 3.1 environment to SAP BOBI 4.1 environment
• Installed and updated HANA 2.0 SPS 02 on SUSE linux in Dev,Test and Prod
• Updated HANA system with dynamic tiering and moved epic clarity database to warm database.
• Have designed backup and recovery strategy for SAP HANA Database in DR environment.
• Integrated SAP HANA and BOE environments with Active directory configuration.
• Have a good knowledge on Linux administration.
• Expert in the concepts Aggregate awareness, Derived Tables, Contexts, Handling LOVs, Implementing Row level security, Hierarchy creation and Index awareness
• Expertise in creating, monitoring, publishing and performance tuning of the reports - Calculation Contexts, Section, Breaks, Customized Queries
• Designed complex dashboards and Stories in Tableau Desktop and good experience in Tableau Server
• Expertise in Parameters, context filters, data blending, work books and joins
• Experience in installing and administering Tableau, Power BI and Qlikview
• Experience in creating dashboards using SAP Lumira, Tableau and Epic Radar

TECHNICAL SKILLS

• SAP Business Objects XIR2,XIR3,BI 4.1,Crsytal Reports 2016,2013,Tableau 10, Epic Reporting 2017 and 2015, Tibco Data virtualization, SAP Lumira, Central Management Console, Central Configuration Manager, Infoview, Web / Desktop / OLAP Intelligence, Designer, Administrator, Crystal Decisions, Reports, and Xcelsius Data Visualization, BODS, Import Wizard, Information Design Tool, Universe Design Tool, Promotion Management, Web Intelligence.
• SAP HANA, Oracle 9i,10g, SQL 2014
• Epic 2017,Epic 2015,Reporting workbench

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Administrator

Responsibilities:

• Worked on advanced BO Configuration experience with SDK’s, JSP scripting and best practices.
• Proved leader to set/manage BO migration project expectations with all involved parties.
• Provided support and expertise to the business community to assist with better utilization of Business Intelligence tools.
• Worked with all stakeholders and implement BO migration project from 3.x to 4.2
• Worked on clustered/multiple nodes with latest backup/restore and fail over concepts.
• Assessed existing BO 3.X or 4.X landscape and come with the plan for Strategic Upgrade option and approach .Worked with operations team and vendors to resolve infrastructure related issues
• Troubleshooted at all levels of the tech stack including BO security setups, debugging of log files and DB query performance.
• Worked with Data Warehouse and Architectural staff to provide data requirements to support ongoing BI initiative.
• Created Configuration of multiple Database client tools to support connectivity
• Upgraded Tableau environment to 10.5 and configured AD security.

Confidential

SAP BO/ HANA/Epic Administrator

Responsibilities:

• Designed and Installed SAP HANA SP12 on SLES Linux environment for Dev, Test and Production.
• Upgraded SAP HANA 1.0 SPS12 to SAP HANA 2.0 SPS 02
• Created backup and recovery strategy for SAP HANA 2.0 SPS 02
• Have installed distributed SAP Business Objects environment BI 4.2 SP3 on new servers.
• Created completely new architecture for BI 4.2 clustered environment.
• Built BOE 4.2 SP4 environment to 10 application nodes, 4 web nodes and moved the security for 20000+ users
• Created new security profiles for complete environment.
• Migrated BO content from BI 4.1 SP4 to 4.2 SP4
• Created complete Disaster recovery process for Business Objects 4.2 SP4
• Solved many ongoing issues related to CUID and synching CMS database.
• Primary contact for all issues related to Tableau, SAP BO, Epic Reporting and SAP HANA
• Have good knowledge on Epic reporting workbench and Epic BI integration

Confidential

SAP BO - IBM Cognos Administrator

Responsibilities:

• Strong administrative and development knowledge of Cognos environment and tools IBM Cognos BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio)
• Worked on migration of universe and reports from BOXI.3.1 version to BOBJ 4.0.
• Defined and configured Single Sign On security.
• Enabled Auditing databases and produced Auditing reports to capture user metrics around overall usage, no. of actions, refresh times etc.
• Upgraded BOE 4.1 environment with SP7 Patch 3 to make the environment compatible with Windows 10 OS and to add the features like SFTP etc.
• Successfully migrated over 140+ application objects from BO 3.1 environment to SAP BOBI 4.1 environment
• Upgraded Web Logic servers and configured successfully to make Web Application server compatibility with Business Objects 3.1 SP6
• Building and sizing of BO servers in a clustered environment. Assist in certifying Business Objects XI as part of making BO as corporate reporting tool.
• Upgraded BODS environment
• Provided assistance in BOBJ SDK reports with JAVA programmers by providing requirements and SDK code from Business Objects
• Adding user to SAP HANA System, Exporting/ Importing SAP HANA System.
• Managing SAP HANA License, Managing SAP HANA users and monitoring system.
• Managing Table in SAP HANA, Scaling SAP HANA
• Backing up and recovering SAP HANA Database
• Installed Business Objects most recent versions of SAP BIBO 4.1 and 4.0 on Windows Operating Systems
• Heavily involved in Performance Tuning and Troubleshooting activities for various issues in BO 3.1, 4.0 and 4.1 Environments
• Identify the hardware and software requirements for Business Objects Upgrades and Installations by referring Product Availability Matrix for the relevant Business Objects versions
• Involving with SAP MAX Attention Team, Platinum Support Team for addressing the critical issues quickly and most effective manner
• Created security configuration in Qlik view.
• Created Disaster recovery plan for BI platform.
• Conducted hardware sizing and scaling activity for the new 4.1 platform
• Prepared detailed 4.1 upgrade project plan
• Conducted atomic testing, manual testing, performance testing and load testing on 4.1 platform
• Performed various Business Objects Administrative tasks like taking backup of the system (Users, Objects, Universes, Universe Connections, Reports and Folders etc)

Environment: SAP BI 4.1, SAP BO XIR2, Oracle 11g

Confidential

SAP Business Objects/ Cognos Administrator

Responsibilities:

• Worked on Universes and resolved loops using Aliases and Contexts.
• Installation and configuration of all the suites of Cognos 8 products and setting up Content store database, Active directory configuration, and Mail exchange server
• Involved in formatting the reports to the user requirements. Extensively used the Drill mode and the Slice and Dice tools to modify the reports accordingly.
• Worked on migration of universe and reports from BOXI.3.1 version to BOBJ 4.0.
• Defined and configured Single Sign On security.
• Enabled Auditing databases and produced Auditing reports to capture user metrics around overall usage, no. of actions, refresh times etc.
• Conducted hardware sizing and scaling activity for the new 4.1 platform
• Prepared detailed 4.0 upgrade project plan
• Conducted atomic testing, manual testing, performance testing and load testing on 4.0 platform
• Involved in creating reports on the web using Business Objects Web Intelligence training and knowledge transfer to assigned project members.
• Raised SAP cases whenever required and coordinated with them to find a work around or resolution and implemented the same in the business objects enterprise system.
• Involved in solving production issues raised by the user on both standard and adhoc reports.
• Provided extended support and resolved Informatica batch issues on regular basis.
• Modification of the Universe for the client and assist them in their reporting solutions.
• Worked on Administration of BOXIR2 and BOXI CMC Security setup.
• Extensively worked on CMC in maintaining objects, Universes, Connections, Resources, Users, User Groups, Categories in BO XI R2
• Has extensively worked with security issues and user maintenance in XIR2.
• Used Publishing wizard to export different document types as objects to different folders in CMC.
• Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• Has participated in project planning sessions with project managers and team members to analyze business requirements and outlines proposed solutions.
• Has scheduled and published web intelligence reports based on specific time, events and calendars in various formats such as Excel and PDF.
• Expertise in using Import Wizard for taking backups of the universes to BIAR file and migrating the Universes and Reports between different environments like Dev, QA and Production.
• Provided user support and training on Designer for creating Ad-Hoc reports.
• Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode.

Environment: SAP BO XIR2, Crystal Reports, Oracle

Confidential

SAP Business Objects Developer

Responsibilities:

• Has been a single point of contact for Business Objects and SAS report requirements.
• Involved in creation of critical monthly web intelligence reports using various functionalities like Breaks, Alerts, Filters, Sorts, Query Prompts and Drill filters.
• Converted Desktop Intelligence reports to Web Intelligence using Report Conversion Tool.
• Created various reports like Master/Detail reports, Cross Tab reports, Slice and Dice reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Have created various SAS reports on ad hoc basis.
• Have developed year end web intelligence reports and delivered all the reports as per SLA.
• Evaluated reporting environment for performance and efficiency and presented recommendations to client.

Environment: SAP Business Objects XI R3, SAS, Oracle