SUMMARY

• 11+ Years of IT experience with strong background in Business Intelligence tools.
• Experience as an administrator from an infrastructure perspective supporting multiple Business Objects Reporting, BODS and Tableau
• Solid experience in development, installation, administration, migration, configuration, technical support, troubleshooting, maintenance and overall health of the BusinessObjects and Tableau implementations.
• Expertise in Administering of SAP Business Objects 4.X, Business Objects 3.6, 3.1 and XI R1/XIR2 Enterprise suite using Central Configuration Manager, Central Management Console, Life Cycle Manager, Desktop Intelligence, Web Intelligence reporting, live office, Publisher and Crystal Reports, Mobile technology.
• Expertise in Tableau Administration and development on multiple versions
• Expert in Data Extraction, Transforming and Loading (ETL) usingBusinessObjects Data Integrator XI (BODI), Data - services xi3.2, 4.0,4.1(BODS)
• Substantial experience in Business Objects Migration /BODS Migration/Tableau Migration
• Expertise in file and security administration in SAP Business Objects 4.2, 4.1, 4.0, XI 3.1, XI 3.0, XIR1 and XIR2 environments.
• Expertise in building clustered Business Objects Application services, BODS and Tableau
• Expertise in single sign on and LDAP configuration.
• Experience in server sizing and capacity planning of Business Intelligence Applications.
• Experience in Disaster Recovery of Business Objects Universes and Reports from BIAR backups.
• Expertise in use of Query Builder and Instance Manager to support Audit functions of the Business Objects Application
• Experience of Installation and administration of Business Objects Data Services client tools.
• Creating Users, installing client software on local machines, Creating Profile server, Configuring Web administrators, creating users to monitor Jobs onCMCofETL tool BO Data Integrator.
• Built dashboards/reports using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Tracking of application issues with Issue tracker.
• Working with executives and providing technical support to users by directly interacting with Business Objects technical support team and Tableau Support team.
• Extensive knowledge in software testing methodology and developing Test Plans, Test Procedures, Test Case Design and Execution, Modification Requests.
• Unique ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts. A strong team member with good Communication and Analytical skills.

TECHNICAL SKILLS

Business Intelligence: SAP BI 4.2 SP04, 4.1 SP7, SAP BI 4.0 SP6, Business Objects 3.1, 3.6 and Business Objects XI R1 and XI R2 environments, Tableau 2018.2.2, 2018.1, 10.5.2, 9

ETL: SAP Business Objects Data Services 4.1sp1, BODS 12.2.2, BODI 11.2

SAP Tools: SAP Solution Manager 7.1, Vertex O Series Sales & Consumer Tax 4.1/6.0, Ancile uPerform 4.1/4.31/4.51

Operating Systems: Windows 2012, 2008 R2, Windows 2003, Unix, IBM AIX, Windows 2000.

Databases: Teradata, DB2, Oracle, MS-SQL Server, AWS Redshift, AWS Athena

Other Tools: SQL*Plus, SSH, MS Office, MS Visio, MS Project, BMC Remedy

Web Servers: IBM Web Sphere, Microsoft IIS, Apache Web Server.

Change Management Tools: Life Cycle Manager, Promotion Management, CVS

PROFESSIONAL EXPERIENCE

Confidential, IL

Business Intelligence Enterprise Analyst

Responsibilities:

• Gather & convert the business requirements into the technical documents for Proof of concept.
• Analyzed Business Required Document to understand the reporting requirements
• Extensive testing and migrating the reports & dashboards from development to Production system.
• Created the Test Case scenarios for the developed source systems which should be loaded in the database.
• Delivering the products as per assigned Sprints.
• Support on call for executive dashboards
• Install, Upgrade & maintain Tableau Server & propose upgrades as per the Tableau releases.
• Experience for hosting Tableau Server on cloud environment using Windows OS.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau Audit Dashboards to monitor the server performance & server usage.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Developed Tableau workbooks from using various connectors like Excel, Spatial file, Amazon Redshift, Amazon Athena, WDC etc.
• Created shared extracts, published data sources to Tableau Server.
• Provided business solutions using Tableau Dashboards
• Utilized TSM scripts to maintain servers, backups and import logo s
• Installed Business objects 4.2 on windows servers
• Expertise in Designing reports using SAP Business Objects Suite.
• Creating Universe with number of Classes, objects, Derived Tables for Operational reporting requirement.
• Maintained canned reports, simple reports and Ad-hoc reports
• Scheduling Reports in Business Objects using different types of events.

Confidential, IL

Business Intelligence Enterprise Analyst

Responsibilities:

• Design, build, and provide administrative/technical/consulting support for SAP Business Objects XI 4.1 experience - Central Management Console, Central Configuration Manager, BI Java Launch Pad, Promotion Management, Information Designer tool infrastructures utilized across various Client division organizations
• Inventory cleanup of XIR2 Production environment by running auditing reports to collect the user activities.
• Transferred CMC data between old (XIR2) and new version either through CMC/BIAR File/Import Wizard
• Split the Business Objects environment from a single machine to 3-Tier VMware servers for better performance and utilization of the hardware resources.
• Upgrade from BI XI R2 to BI 4.1 SP 6 and later upgraded to BI4.1SP7 P1 on all the environments and expand one node to three node environments in Test & Production systems.
• Configured Tomcat clustering by editing the server.xml & Web.xml files on the server
• Collaborate with Network Team, LAN Team & Load balance team to load balance the Tomcat URLs & generated two different URLs, one for Internal & External users on two different domains
• Worked with the Firewall team to open communication between the external networks to the internal network
• Validated the installation by checking the public folders, Reports in Personal folders, Groups, Row level security, Scheduling and by running some sample reports.
• Resolved 95 different migration issues
• Provided support to application teams both Java and .Net based by helping them analyze and implement customer requirements
• Business Objects BI 4.0 SP6 to BI R4.2 SP04 Upgrade
• Migrated from BI 4.1 to 4.2 SP04 and provided support to new Environment.
• Configured servers in 4.2 SP2 for Development, Test and Production environments and created group structure
• Performed Repo Scan as part of pre-requisites
• Designed BO Report templates on Auditing DB
• Involved in day to day Business Objects Server maintenance
• Provided support to resolve client technical issues.
• Expertise in BI 4.2 CMS and complete security model at BO enterprise level.
• Conducted end user training sessions and prepared training material.
• Performing troubleshooting and tuning CMS and server tuning parameters for Business Objects XI R3 environments
• Auditing of the application usage of reports and security through the repository or auditing features
• Maintaining procedures and perform tests for Business Contingency Planning/Disaster Recovery
• Manage objects, reports, universes and database connections within Business Objects, Report Job Scheduling
• Created a High-Level Security Frame Work and Access Levels according to Client Specifications.
• Co-ordinated and Supported with SAP Team for the Technical Integrity Check on BO 4.X infrastructure and Performance of the Current environment for End- User.
• Created and updated server architecture for scheduling tasks
• Prepared backups using Tabadmin and Tabcmd commands
• Formulated procedures for installation and configuration of Tableau desktop
• Support multi environment Tableau infrastructure including security, troubleshooting and general system maintenance
• System Admin (includes new site creation, Server maintenance, upgrades, patches, and Schedule control. * Working with Windows Servers (2008/2012) & networking technologies, Windows Active Directory, SAML for security architecture
• Working with Site admins and user community in getting QA and user signoffs
• Creating administrative dashboards and reports for tracking server and resource utilization
• Analyzed and resolved performance and server-based issues
• Document best practices in current version for Admins & Developers
• General Admin / Maintenance tasks assistance required
• Work with Server admins on the implementation rollout plan, change management and release management activities

Environment: Business Objects 4.2 SP04, 4.1 SP7, Business Objects 4.0 SP6, Business Objects XI r2, Sql 2008, Sql 2012 Oracle 12c, 11g, Windows 2008 R2 server, Windows 2012 R2, Crystal XI R2, 2011, 2013, 2016 SAP Dashboard Designer and SAP Business Objects Mobile 4.0

Confidential, NJ

Business Objects Enterprise Consultant

Responsibilities:

• Hands on experience with implementation on large installations on Unix/windows environment
• Prototypes of the approach along with documentation describing requirement, limitations, and future plans
• Worked as Subject Matter Expert (SME) for Business Objects
• Review an Architecture Assessment Analysis (Sizing Analysis).
• Review and discuss and assess the current Security Model.
• Discuss Integration and Road mapping for future SAP BusinessObjects products.
• Having experience on all BusinessObjects product suites.
• I have expertise in BusinessObjects 4.0 software installation, configuration, tuning, performance monitoring, issues resolution and user assistance
• Installed SAP business objects mobile client and server to view reports from I pads.
• The Mobile client application enables access to Web intelligence and provides users with document rendering, refresh, snapshot sharing, and navigation options.
• Implemented BusinessObjects on multiple servers performing load balancing and clustering to have high availability all the time to the clients.
• Upgraded BusinessObjects XI 3.1 Sp3 to BusinessObjects 4.0 and BusinessObjects 4.0 to 4.1
• Clustered multiple Business Objects servers together for load balancing
• Used SAP security authentication in BusinessObjects 4.0
• Did the Administrative Tasks like setting up new Users, Groups and assigning security at Folder level and I did LDAP/AD authentication for the business objects
• Trouble shouted the environment related issues by looking the Business Objects logs and Event logs and worked with SAP Technical support to resolve multiple issues.
• Worked with DBA to back up the entire environment on a daily, weekly and monthly basis
• Having extensive knowledge on audit reviewing, advanced troubleshooting and experience to provide solutions (or) suggest solutions
• Deployed single sign on BusinessObjects Enterprise and its other Reporting tools
• Knowledge transfer sessions with IT team responsible for taking it over and maintaining it
• Having good knowledge on Central Management Console (CMC), Info view (BI)
• Experience installing configuring BO Lifecycle Manager (LCM)/Promotional Management & creating promotion jobs
• Experienced in promoting SAP BusinessObjects environments through development, QA, UAT, DR and production using LCM (Life Cycle Management)/Promotion Management/ Import wizard
• Perform environment refreshes, and apply software patches and fixes.
• Clustered the servers successfully by distributing the Business Objects Services effectively between all the servers to make the Business Objects Environment Highly available and get the "FAILOVER" to work efficiently.
• Experienced in scheduling the reports, programs in CMC
• Involved inday to dayBusinessObjects Server maintenance
• Experience in scheduling of repository backup and tuning the Business Objects servers for a better performance.
• Customization of Business Objects Enterprise using SDK
• Developed Web service to generate text files (events),
• Scheduled jobs through TWS based on File based events
• Responsible for the Administration of CMC, LCM. BOBJ Security settings and setting up user, user groups and application security
• Excellent written and oral communications skills with demonstrated commitment to production of high quality documentation
• Completed capacity planning for Business Objects to support large number of End-users
• Expert in using Custom Access list for user and group management in Business Objects XI 3.1
• Working on Business Objects 4.1 upgrade from 4.0 by performing analysis on resolved ADAPT numbers and based on use of new improved functionalities.
• Installed SAP GUI on BusinessObjects servers for SAP connectivity worked with SAP BI team to Import SAP transport required for SAP integration
• Enabled SAP authentication through CMC
• Imported SAP users and Roles
• Configured SIA for Secured Network Communication (SNC) on BusinessObjects servers
• Configured SNC setting on CMC
• Configured program ID, Gateway Host and Gateway service parameter on registry of BW publisher service worked with BI team to configure RFC destination and Create BusinessObjects enterprise definition on SAP BI servers

Environment: Business Objects 4.1, Business Objects 4.0 sp6, Business Objects 3.1, AIX 6.1, Oracle 11g, Windows 2008 R2 server, Windows 2003, Crystal 2011, SAP Dashboard Designer, Xcelsius 2011 and SAP Live Office, SAP Business Objects Mobile 4.0

Confidential, CT

Business Objects Data Services Administrator

Responsibilities:

• Expertise in providing guidance in the design, development and implementation of business intelligence capabilities with emphasis on products offered by BusinessObjects Data Services
• Experience with Data Integrator for ETL (Extraction, Transformation, and Loading) of data from multiple sources database systems to Data Warehouses.
• Upgraded Data Services 12.2.2 to 4.1
• Created Global variables to read the files from the shared location from the BODS Designer Also worked on the FTP process to put & get the files on the data-exchange servers.
• Migrated all the Projects of the team fromDEV TO TEST TO PS TO PROD, & scheduled the jobs as part of the Administrator.
• Worked on all the standards & guidelines Best Practices Documentation, and the functional & Technical design specification documentation.
• Experience maintaining and monitoring connections and extractions between Data Services and multiple source systems
• Provided the technical guidance & knowledge transfer of effectively using BODS4.0
• Created user based repositories through Data Services Repository Manager
• Scheduled BODS batch jobs through IBM TWS on daily basis
• Installed the client tools on all the developer machines created their local repositories and added them to central repository. Involved in the Check in, Check out, get operations with other local repositories from Central Repositories.
• Daily Health check performed to analysis on SAP RFC Steps count, Jobs execution time, Datastores connections
• Implementation of Training and Mock systems for users, providing technical & system documentation for Business owners and users.

Environment: SAP Business Objects Data Services 4.1 SP1, BODS 12.2.2, SAP BI 7.1, AIX 6.1, BMC Remedy 7.5, MKS Integrity 2009

Confidential

SAP Consultant

Responsibilities:

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation
• Developed Alpha reports which were solely for those working in the hedge fund industry
• Developed premium reports for various industries with coverage on Alternative Investments, Money Management, Pension Funds, Banking and Brokerage
• Involved in creating the ranking criteria for the top CEO and CFO for various firms by sector and location
• Created standard BusinessObjects templates to be used for various surveys which help project managers to take effective decisions in choosing the breakouts for revenue and regions
• Resolved loops, chasm and fan trap using contexts, aliases and integrity checks
• Created Repository for BusinessObjects development and distributed Domains
• Involved in Ongoing maintenance of developed applications, and handling the change requests
• Developed design and Hierarchy Building for Data Analysis and apply conditions in Objects
• Ability to tune queries in a Teradata environment
• Uploaded Master and Transactional data from flat files
• Extensive data extraction from numerous Teradata data tables
• Involved in creating crystal reports with complicated Queries, Document Centricity, Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice, Alerts, and Formatting Presentation Styles
• Created Web based reports using Web Intelligence and Scheduling and timely refresh of documents through Broadcast agent
• Providing user support and training in using Report Designer for creating AD Hoc reports
• Provided 24-hour on-call support for all systems with on-rotation pager.

Environment: Business Objects XI R2/6.5, Info view, Web Intelligence, SQL Server 2005, Windows XP, Xcelsius, CMC, SSIS, BCA Publisher, Auditor, Teradata, Crystal Reports, Oracle 9i, DB2, PL/SQL.