SUMMARY

• End to End SAP BObj/BODS & Tableau Server Implementations in Windows, Linux & UNIX operating Systems.
• Upgrade and Migrations of SAP BObj & Tableau servers.
• Implementation of WINAD SSO, Trusted Authentication, SAML SSO, SSL for SAP BObj & Tableau.
• Configuration of SSO certificates to SAPBW/HANA for data level security.
• Troubleshooting performance Issues, Memory tuning & Capacity planning.
• Technical Architect/Admin with around 11+ years of experience in BusinessIntelligence Tools in delivering problem solving skills and ability to follow through with projects from inception to completion.
• Strong experience in installation, administration, migration, configuration, technical support, troubleshooting, maintenance in a distributed environment and overall health of the BI Tools (SAP BObj BI/BODS & Tableau) implementations.
• Solid experience in Implementing patches, upgrades to ensure the Business Objects systems have constant uptime and proper tuning.
• Expertise in providing guidance in the design, development, sizing and implementation of business intelligence capabilities with emphasis on products offered by SAP Business Objects & Tableau.
• Experienced in configuring timeout settings, modifying memory settings and deploying war files on Web Application servers.
• Developed various automation scripts &SDKs for enhancement of project.
• Experienced in troubleshooting performance issues, capacity planning, identifying and resolving bottlenecks at various levels.
• Extensive experience in design, implement, and managing SAP Business Objects & Tableau user security in a large enterprise Landscape Environments.
• Experienced in migrating objects between environments.
• Proven ability to work with end - user community, responding to help desk calls and trouble tickets, working with vendors to resolve HW and SW problems.
• Expert in taking E2E trace, BOE Trace, server tracing and reading server logs.
• Expert in creating audit reports on BObj Audit Repository and CMS Repository using JAVA SDKs & Tableau Repository.
• Expertise in SSO/Authentication/Deployment and integration with other applicationsand SAP ECC/BW/HANA integration and SSO implementation.
• Excellent interpersonal skills, motivated, energetic team player with demonstrated proficiency for learning new tools with excellent communication and analytical skills.

TECHNICAL SKILLS

Reporting Tools: SAP Business Objects 4.2/4.1/4.0/XI 3.1/R2/5.7, Explorer 4.1, Lumira 1.x,2.x, Design Studio 1.6/2.x, Information Design Tool(IDT), Universe Designer, Desktop Intelligence, Web Intelligence, Crystal Reports 2016/2013/2011 ,2008/XI/10, Dashboards 4.1/ XCelsius 2008, IPAD &Android Apps - SAP Mobile BI, BO Explorer

ETL: SAP Data Services 4.2, IBM Data Stage 11.x/10.x, SAP BW 7.4/7.1, Informatica 8

RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , DB2 UDB, Teradata V14/V13/V12, MS-Access, Hadoop

Languages: PL/SQL, T-SQL, VB Script, HTML, XML, UNIX Shell Scripting, Perl Scripting, Java

O/S: Windows 206/2012/2008/2003 , RED HAT LINUX 5.7/5.11/6, IBM AIX 5.1/5.3

Web Servers: TOMCAT 7/6/5.5, Web Logic Application Server 9.x, Web Sphere 8.0/6.1/5.0,IIS

Tools: TOAD 6.5, SQL Navigator 4.1, SQL Developer, Load Runner 7.5/9.0

PROFESSIONAL EXPERIENCE

Confidential, Melville, NY

Sr. SAP BObj /DataServices Technical Architect/Admin

Responsibilities:

• Responsible for Maintenance, Implementation of SAP Business Objects BI/BODS 4.X including Architecture Design, Installation, Sizing, Server maintenance, Performance tuning, Migrations and optimization, Test planning and execution.
• Installed & Configured SAP Business Objects BI 4.2 SP3 & SP 3.5 Patch on Windows 2016 physical servers and migrated content from Sterling Datacenter to Melville Datacenter using CMSDB copy and reconfigured SIA for Insight BObj environment.
• Installed, Configured SAP Business Objects 4.1 SP6 on Windows 2012 VM Servers & migrated content from BObj 3.1 to BObj 4.1 using Upgrade Management Tool for S21 CCI BObj Environment.
• Designed/Updated and implemented security model by creating of user groups, access levels and granted access to BOE applications to users and adding security restrictions (application level, folder level and object level) based on user profile and user groups for BObj BI 4.2 S21 CCI environment.
• Installed and configured Lumira 2.1 Add-on for SAP Business BI 4.2 Insight environment.
• Configured SAP Mobile configurations for to see the SAP BObj reports on SAP Business Objects Mobile.
• Optimized entire SAP BOBJ landscape including server sizing and configuration.
• Configured APS(Adaptive Processing services) Split, increase java heap size and Tomcat heap size/session time outs,Adaptive job server, Crystal Reports, Crystal RAS, WebI Processing server, Tomcat Web Application memory & timeout settings.
• Configured Email, FTP and Inbox settings for Adaptive job Server.
• Configured Input FRS (File Repository) & Output FRS(File Repository) repoint to NAS Shared Drive.
• Configured BOE Webapp custom configurations for logo and company Name in BIlaunchpad.properties, global.protperties file.
• Configured and deployed BI web applications with required customizations in Tomcat application server.
• Converted old Lumira 1.31 reports to Lumira 2.1 using Lumria Designer 1.3.10 Version Tool.
• Implemented BOBJ Monitoring script using Perl Script and deployed to all BObj Environments
• Developed BObj JAVA SDK Scripts for CMS Data Extraction, User Extraction.
• Administrated BO security and users using CMC, Implemented the security skeleton in Business Objects BI 4.2 Environment.
• Configured Sharepoint Integration by enabling WebDev Service for to schedule BObj Reports to Sharepoint server.
• Worked with firewall team to open ports 6400-6400 bidirectional for BObj BI environments & Database ports.
• Configured Platform Schedule from Crawling to Schedule daily once at 9 PM.
• Created Webi reports for Audit on BObj Audit Repository and CMS Repository using JAVA SDK.
• Installed Oracle 32bit & 64ibit Client Drivers and configured TNS entries in tnsnames.ora file.
• Installed ODBC Drivers for Teradata,DB2,Sybase,MySql,MS Sqlserver and configured ODBC entries.
• Configured printers on BObj 4.1 servers & added printer names in CMC
• Configured barcode fonts by modyfiny fontalias.xml & i18.xml files.
• Updated SIA service to start with service account in CCM.
• Worked with developer’s/power users and assisted data sources configurations/connections setup.
• Worked with Network/Load Balancer team and implemented BOBJ Load Balancer configuration/setup.
• Troubleshoot user/content/platform issues, report environment issues to SAP, work with SAP to troubleshoot the platform issues to provide workaround/solution and apply the patches/fixes based on SAP recommendations.
• Initiative to address root cause in problem resolution.
• Provided 24x7 on call BOBJ platform support with proactive solutions to ensure all BO systems in high performance including investigate/identify production report/universe issues.
• Configured/Implemented SSO on BObj environments with trusted authentication and http header option to enable the SSO between Canon Web and BObj applications using IIS as reverse proxy.
• Promoted the BI 4 content between Dev/Test/Prod environments using LCM application with promotion jobs.
• Installed and configured Introscope for monitory Java Memory analysis.
• Installed Information Platform services 4.2Sp5, SAP Data Services 4.2 Sp10 on Windows 2016 server.
• Installed the SAP Data services 4.2 Sp10 client tools on Citrix Environment
• Created user based repositories (local repositories), Central Repositories through Data Services Repository Manager and added in Job server.
• Responsible for promoting the new/updated jobs from development to production using .atl import/export and object promotion.
• Configured and migrated local repos from Sterling Data Center (SAP Data Services 4.2 SP5) to SAP Data Services 4.2 SP10.
• Configured and Migrated Address validation Adapter Instances configurations from Sterling Data Center (SAP Data Services 4.2 SP5) to SAP Data Services 4.2 SP10.
• Created & configured Server Group for Job servers.
• Copied & Configured Address reference files for address validations of USA Regulatory Address Cleanse transforms and Global Address transform.

Environment: SAP Business Objects(BOE) BI4.2, Crystal Reports 2016, Lumira 2.1, SAP Business Objects Mobile, Upgrade Management Tool,, SAP Data Services 4.2 Sp8, Oracle 11g, MS SQL Server 2012,, MS Access 2013, SQL Developer 1.5, Tomcat 7/6, Vmware 6.5, HP PPM, Windows 2012/2016

Confidential, Lisle, IL

Sr. SAP BObj Technical Architect/Admin

Responsibilities:

• Installed & Configured SAP Business Objects BI 4.2 SP3 on Windows 2012 VM servers hosted by Virtustream Cloud on multiple SAP instances that comprise the SAP environment(development, quality assurance, training, and production).
• Installed and configured Lumira 1.31, Design Studio 1.6 and Analysis for Office 2.3 Add-ons for SAP Business BI 4.2 on Windows 2012 servers.
• Configure SAP Mobile configurations for the see SAP BObj reports on SAP BusinessObjects Mobile.
• Applied fixes/service packs for registered bugs and involved in tuning and monitoring the server performance.
• Configured & Registered DAA agent with SLD and SMD with SAP Solution Manager and registered BObj with Wily Introscope.
• Configured SAP BO SSO with SAP BW/ECC Trusted certificate to configure BO SSO with SAP ECC /SAP BW systems & HANA SAML SSO with HANA system.
• Monitor & Optimize entire SAP BOBJ landscape including server sizing and configuration.
• Configured SAP Trusted certificate to configure BObj SSO Connection between BOBj and SAP ECC /SAP BW systems using STS Configuration.
• Configured Windows AD SSO with SAP Business Objects 4.2.
• Created RSTT Traces for Analysis Office (A40) reports for load test and coordinated with HP load runner team to run the load test and analyzed results.
• Configured APS(Adaptive Processing services) Split & Memory settings, Adaptive job server memory settings.
• Configured all Job servers for Email, FTP and Inbox settings.
• Configured Input FRS (File Repository) & Ouput FRS(File Repository) repoint to NAS Shared Drive.
• Configured & modified default connection timeout settings, Memory settings for Crystal processing server, Crystal Cache server, Web Intelligence Servers.
• Configured Apache Tomcat Web Application server custom configurations for logo, session time out and memory settings and SSL.
• Monitor & Optimize entire SAP BOBJ landscape including server sizing and configuration.
• Implemented BOBJ Monitoring script using Perl Script and deployed to all BObj Environments
• Developed BObj JAVA SDK Scripts for CMS Data Extraction, User Extraction.
• Administrated BO security and users using CMC, Implemented the security skeleton in Business Objects BI 4.2 Environment.
• Categorized the users such as Power users, Casual Users, Authors and identified their roles and usage with Web Intelligence and crystal reports and applied rights accordingly and handled the user security for supporting various organization views.
• Monitor / tuned Business Objects environment based on performance and usage levels.
• Design, implement and maintained disaster recovery strategies and plans including backup plans scripts, recovery procedures for FRS backup and CMS backup.
• Added SAP roles in SAP authentication to add SAP users in to BO system.
• Facilitated with tech Support to Formulate a Strategy for Implementing good User support.
• Monitor / tuned Business Objects environment based on performance and usage levels.
• Used Promotion Management Tool (LCM) to promote reports, universes, publications between environments and used LCM biar command line properties to take backups.
• Facilitate with tech Support to Formulate a Strategy for Implementing good User support.
• Tuned Business Objects system at OS Level, Network level & Application Level and optimization for better performance.

Environment: SAP Business Objects(BOE) BI4.2, Crystal Reports 2016, Dashboard Designer 4.2, Analysis Office 2.4, Design Studio 1.6/2.x, Lumix 1.31/2.x, SAP Business Objects Mobile, Crystal Reports 2016, Crystal Enterprise 4.2, Upgrade Management Tool,, SAP Data Services 4.2 Sp8, MS SQL Server 2012,SAP BW 7.4/SAP ECC, SAP HANA/S4,HANA 1.8,, SQL Developer 1.5, Service Now, Tomcat 7/6, Vmware 6.5,Remedy 8.1,HP ALM, Windows 2012

Confidential, Peoria, IL

Sr. SAP BObj/BODS Architect/Technology Lead

Responsibilities:

• Installed & Configured SAP Business Objects BI 4.1/4.2/XI 3.1 on RED HAT Linux 5.11 64 bit servers and Windows 2008/2012 servers.
• Applied fixes/service packs for registered bugs and involved in tuning and monitoring the server performance.
• Installed and configure Lumira 1.31, Design Studio 1.6 Add-ons on Windows 2012 servers.
• Installed and configured SAP Business Objects Explorer 4.1 Add-on for IPAD mobile application.
• Installed and configured BO 4.2 Patch on top BO 4.1 Sp 5.3.
• Implemented BOBJ Monitoring script using Perl Script and deployed to all BObj Environments
• Developed BObj SDK Scripts for CMS Data Extraction, User Extraction.
• Installed SAP Data Services 4.2 Sp5, Information steward 4.2 Sp 5 & Information Platform services 4.2
• Installed the SAP Data services 4.2 client tools on Citrix Environment
• Involved in the Check in, Check out, get operations with other local repositories from Central Repositories.
• Created user based repositories (local repositories), Central Repositories through Data Services Repository Manager and added in Job server.
• Design and implement security by creating of user groups, granting access to BOE applications to users and adding security restrictions (application level, folder level and object level) based on user profile and user groups.
• Create access levels (Power/Casual/ Developer/Project Admin) based on project needs.
• Migrated Windows BObj Platform to Linux Platform by repointing old BObj Windows Platform CMS repository and FRS NAS Storage to New Linux Platform using Cmsdbsetup.sh & Serverconfig.sh
• Recreated SIA & repointed CMS database using serverconfig.sh and cmsdbsetup.sh for to restore BObj from backups and to restore deleted content.
• Configured LDAP Single Sign on (SSO) using Trusted Authentication.
• Converted CPU Licensing to Named/Concurrent user licensing and also deployed java script to convert selected users to Named users Java SDK code.
• Migrated Crystal reports from BO XI R2 to BO 4.1 using Upgrade Management Tool.
• Administrated BO security and users using CMC. Implemented the security skeleton in Business Objects BI 4.1 Environment.
• Monitor / tuned Business Objects environment based on performance and usage levels.
• Applied patches for Business Objects XI 3.1 registered bugs for current environment and also for BO 4.x new environments.
• Design, implement and maintained disaster recovery strategies and plans including backup plans scripts, recovery procedures for FRS backup and CMS backup.
• Facilitate with tech Support to Formulate a Strategy for Implementing good User support.
• Extensively Used CMC (Central Management Console) for user management, content management, and server management tasks and CCM (Central Configuration Manager) to manage local and remote servers in both BO 3.1 and BO 4.0 environments.
• Used APOS Webi Migrator Tool for Converting .unv to .unx universes and to repoint reports pointing to old .unv to .unx in bulk.
• Defined server statistics & load balancing test across enterprise environment.
• Monitor / tuned Business Objects environment based on performance and usage levels.
• Used Promotion Management Tool(LCM) to Promote Reports, universes, Publications, Infospaces, eviews from environment to environment.
• Facilitate with tech Support to Formulate a Strategy for Implementing good User support.
• Installed and configured BObj 3.1/4.1 Client tools on Citrix Server.
• Migrated BObj 3.1 Content (Reports, Universe, User security) using Upgrade Management tool to BObj 4.1.
• Configured & modified default connection timeout settings for Crystal processing server, Crystal Cache server, Web Intelligence Servers, BI launch Pad, Tomcat.
• Tuned Business Objects system at OS Level, Network level & Application Level and optimization for better performance.

Environment: Business Objects XI 4.2/4.1/3.1/XIR2, Crystal Reports 2016/2013/2008/ XIR2, Xcelsius 2008, Dashboard Designer 4.0,Lumira 1.31, Informatica 8.6, Oracle 10g,MS SQL Server 2005, TeraData V2 R6.2, MS Access 2003, SQL Developer 1.5, Vmware 6.5,Peregrine 6.1, Windows 2008/2003.,RED HAT LINUX 5.11

Confidential, Costa Mesa, CA

Sr. Business Objects Admin

Responsibilities:

• Responsible for administration, upgrade patches, resolve existing issues and migrate content between environments.
• Maintained Central Management Console (CMC) for Folder Level security set-up, Report Scheduling, Users, User Groups, Servers and Server Group administration.
• Resolve all issues related to Business Objects (including all server, network, database, SSO and client applications) functionality - coordinate troubleshooting activities with SAP Business Objects Technical Support and required resources - all break/fix issues.
• Installed Clustered/Distributed Production BOXI 3.1 SP3 on Windows 2008 R2 server with CMS/Audit databases on MS SQL Server 2008.
• Installed and configured Tomcat server for clustered BOXI environment along with F5 load balancer.
• Worked with networking team to enable/configure required ports, firewall rules and implement load balancing/fail over content switch rules using Cisco ACE hardware load balancer.
• Worked with F5 Load balancer team to update stickybit session setting and session timeout settings.
• Successfully configured the Windows AD authentication for BOXI authentication and implemented Single-Sign on functionality using vintela and configured Apache web-server accordingly.
• Updated and Applied BOXI 3.1 SP3 and required Fix Packs to Production and Non Production environments.
• Configured Input/output FRS, BOXI logs on SAN to support clustered architecture and enabled E-Mail and FTP on BOXI 3.1 Servers successfully.
• Design and implement BO system security including details security groups and access control list to meet business requirements.
• Scheduling of the report on successful event and save on specific servers using FTP/File System Configuration in Business Objects XI 3.1.
• Promoted the content form Development to Test, Test to Pre-Production and Pre-Prod to Production using Life-Cycle Manager.
• Provided production support role with daily hands on support of production activities including system enhancements, break-fix, requirements gathering and end user support.
• Facilitated meetings across Departments for implementing a standard Architecture for deploying.
• Created High-level and Detail-level documentation of the project.
• Created users and groups in CMC and created user profiles.
• Extensively worked on scheduling of the Business Objects reports, configured SMTP, FTP.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Directed and implemented entire BO life cycle for migration and Universe & report development.
• Defined users and their profiles with appropriate access privileges.
• Designed Production System support and handling opened user cases.
• Involved server sizing, load testing & performance testing of Business objects in shared environment.
• Exported the Universes to the Repository to make resources available to the users.
• Provided 24X7 production support.

Environment: Business Objects XI3.1, Designer, Web Intelligence, Import Wizard, Crystal Enterprise 10, Informatica 8.1/7.1.3 (Power Mart &Power Center), Erwin 4.1, Oracle 10g, MS-SQL Server 2005, Teradata V12.0, TOAD 6.5, Tomcat 5.5,Windows 2008

Confidential, Pleasanton, CA

Business Objects Admin

Responsibilities:

• Responsible for Installation, configuration, administration and support of Business Objects XI3.1/XIR2 & 5.7 Enterprise Environments.
• Responsible for Migrating the Users, Groups, Universes and Reports across the Servers (Development and QA to Production Servers) in BO XIR2/XI3.1 using Import Wizard.
• Responsible for day to day operations of the reporting environments. Respond to and resolve assigned support tickets on Business Objects issues 5.7/XIR2 and XI 3.1 environments within defined SLA's.
• Responsible for migration of Universes, Connections, DeskI / WebI Reports and Personal/Inbox documents from the existing versions 5.7 to XIR2 using Import Wizard.
• Key Person for Designing Architecture for New BO XI Migration and Prepared Migration Plan. Successfully migrated Business Objects system from versions BO 5.1.7 and BOXI R2.
• Converted migrated Full Client (DeskI) reports to WebI reports using Report conversion tool.
• Installed, Configured and applied patches for Business Objects XI 3.1 on IBM AIX 5.3 UNIX & Windows 2008.
• Applied patches for Business Objects XI R2 &Business Objects XI 3.1 registered bugs.
• Installed fix packs and service packs on DEV, QA and PROD BO XIR2 servers.
• Created/Administered users/user groups/Security in Crystal Server XI CMC
• Involved in all phases of migration from Crystal Enterprise 10 to Business Objects XI R2.
• Performed Lead Role in Universe, Report Migration, Report Remediation Process and Report Development.
• Designed and implemented security by creating user groups and granting access to Business Objects XIR2 environment.
• As well as security restrictions (application level, folder level and object level) based on user profile and groups as per the existing and new requirements in BOXIR2.
• Involved in testing (Users, Universes and Reports (DeskI/WebI) throughout the migration process across the old system.
• Responsible in setting up users through BO 5.7 Supervisor and assigning privileges to these users to meet security requirements, setting up object level and data level securities on the universes to various groups and users using supervisor.
• Designed Architecture & Security set up for Development, Test and Production Business Objects Enterprise environments.
• Provided production support for troubleshooting server issues on daily basis
• Assisted in development of disaster recovery strategies and plans including backup plans, recovery procedures and periodic DR drills.
• Actively involved in gathering server sizing requirements for software/hardware.
• Defined standards & production support documentation for other developers to follow.
• Defined server statistics & load balancing test across enterprise environment.
• Tested and implemented SMTP email and FTP scheduling feature of Business Objects Enterprise.
• Optimized system with load balancing with distributing components on different servers.
• Implemented Business Objects Clustering, Load Balancing, Disaster Recovery.
• Facilitate with tech Support to Formulate a Strategy for Implementing good User support.
• Prepared user documentation for hand on training for end user community.

Environment: Business Objects XI3.1/XI R2/5.7,Crystal Reports 10/XIR2,Web Intelligence, Desktop Intelligence, Universe Designer, Informatica 8, Oracle 9i, DB2 UDB V8.1, Remedy 7, TOAD, Load Runner 7.5, WebLogic Server 9.1,Tomcat 5, AIX 5.3, Windows 2008/2003