We provide IT Staff Augmentation Services!

Sr. Business Intelligence Architect/administrator Resume

5.00/5 (Submit Your Rating)

AtlantA

SUMMARY

  • 12+ years of experience in IT Industry in SAP, SAP Business Objects (Business Intelligence), Technical Analyst, Architecture and System Administration which including all facets of Software Engineering, Implementation and production support for SAP projects for diversified industries.
  • Worked on different versions of SAP Business Objects XI R1/XI R2/XI 3.1/BI 4.1/BI4.2
  • Having administration experience on SAP Business Objects Data Services 3.1,3.2,4.0,4.1 and 4.2
  • Certified in SAP Business Objects Administration and ITIL Foundation in IT Service Management.
  • Successfully completed 5 Migration projects which include Crystal Enterprise 2010 - > BI 4.1, BO XI R2 -> BI 3.1 and BO 3.1 -> BI 4.1.
  • Experienced in applying the service packs and fix packs on BO 3.1, BI 4.1 and BI 4.2 versions.
  • 4 Years’ Experience in Tableau Server Administration & Production Support.
  • Server Administration on Tableau 9.0 and 10.2 versions.
  • Tableau Server Administration with includes Sites, User & groups, Schedules, Tasks, Status, Settings and Alerts.
  • Experience in Tableau Command line utility to create scheduled backup and restore.
  • Experience in creating scripts to handle Administrative Tableau tasks.
  • Experience in using 360 Suit for Administrating the Business Objects 4.1 and 3.1 Environments.
  • Experience in Using the APOS tools to administrating the Business Objects 4.1 which includes migration of Universes and converting the universes and repointing the reports.
  • Experience in Installing and configuration of other BI tools Tableau and SAS.
  • Hosted the Business Objects Servers in AWS EC2 Servers.
  • Created AWS EC2 Instances and Attached EBS volumes for Business Objects environments.
  • Created Cloud watch alerts for EC2 environments based on the requirements.
  • Installed and configured clustered environments in Business Objects 3.1 and BI 4.1.
  • Experienced in Configuring Application Servers like Weblogic 10.x and 12c environments including the proxy changes on Linux platform.
  • Extensive experience migrating Crystal reports, Webi reports and Universes.
  • Experience in SAP Business Intelligence 4.1 tools like UDT, IDT and Promotion Management.
  • Extensive experience in troubleshooting and problem solving ofBusiness Objects infrastructure, security and Architectureand application development related issues.
  • Extensive experience in different Modules of Business Objects like Desktop Intelligence, Web Intelligence, Infoview, Designer, Supervisor/CMC
  • Middleware (Weblogic and Tomcat) administration on Windows and Linux environment.
  • Experience in System Administration, Server Configurations & Trouble shooting of Windows & Linux Servers
  • Performed Pre Migration Assessment, Migration & Post Migration.
  • Identifying Reports Complexity, Implemented Row level/Column Level/Report Level Security
  • Experience in installation of business objects components including BO repository creation, support and administration of Web Intelligence.
  • Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and free hand SQL.

TECHNICAL SKILLS

ETL Tools: SAP Data Services 3.1, 3.2,4.0, 4.1 and 4.2,SQL Data Transformation Services

SAP: ECC 4.7,5.0, 6.0 EHP4,5,6, BI 7.0, BI 4.1, 4.2, Solman 7.1

OLAP: MS Sql Analysis 2000, Business Objects Designer XI R2, 3.1,4.1 and 4.2

Reporting/DSS: Business Objects 4.2/4.1/3.1, XI R2, Web Intelligence, Info View, Zabo, Crystal Reports 10/XIR2/XI 3.1/ XI 4.0, Tableau,SAS, Lumira, Design Studio 1.6,SAP PCM

Operating Systems: UNIX, Windows NT, LINUX, Windows 2000/2003/2008/2012 R2

Databases: Oracle 8/9i/10g/11g/12c, SQL Server 2008 and 2012

Development Tools: Crystal Reports, Webi Intelligence, IDT, UDT, LCM and Promotion Management

Automation/Monitoring: Jenkins, Manage Engine

Middleware: Weblogic 10.3, 12c, Tomcat.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

Sr. Business Intelligence Architect/Administrator

Responsibilities:

  • Gathering technical requirements from various business partners for architecting the SAP Business Objects systems.
  • Installed and configured clustered Business Objects XI 3.1, BI 4.1, BI 4.2 on Red hat Linux EL 4, 5 and 6.
  • Configuring SAP Lumira 2.0 for the SAP Datasources. HANA,UNX.
  • Creating dashboards using SAP Lumira 2.0 Desginer and discovery.
  • Creating the Business Objects Servers in AWS EC2 Servers from Gold Image.
  • Implemented the Disaster Recovery procedure for Business Objects 4.1 environments.
  • Created AWS EC2 Instances and Attached EBS volumes for Business Objects environments.
  • Created Cloud watch alerts for EC2 environments based on the requirements.
  • Implemented end to end migration from Business Objects 3.1 SP7 to BI 4.2.
  • Installing and Configuring Design Studio 1.6 BI platform add-on to UNIX platform.
  • Installation of Upgrade Manage Tool and Migrating the Universes and reports from TEST to Production environments.
  • BI Platform Configuration for Universes in Design Studio.
  • Applying patches, service packs, fix packs and maintenance
  • Configuring the services for Designer Studio (Mobile, Dashboard)
  • Configured the SMTP settings to send the reports to users email after scheduling the reports in Crystal Enterprise Server and Business Object Server.
  • Implemented Custom Access Levels to use of efficiently the security methods.
  • Implemented monitoring (watches, alerts) using Auditing Database.
  • Server Sizing, Installing and Configuring of Tableau Server 9.2 on Windows 2008 R2.
  • Successfully Upgraded Tableau Server from 9.2 to 10.2.
  • Tableau Server Administration with includes Sites, User & groups, Schedules, Tasks, Status, Settings and Alerts.
  • Installed and configured Tableau on Three-node and Optimized for a balance between extracts and user traffic.
  • Configured failover (Repository Active - Repository Passive)
  • Separated the Backgrounder process to improve the performance of processes and servers.
  • Configuring SMTP settings on Server configuration console and setting the thresholds for disk space.
  • Coordinating with SAN storage team to increase the disks based on requirements.
  • Worked with Network team to open the TCP ports which tableau server uses for the processes.
  • Log Management (Zip log nightly (Over-write), clean up log files periodically)
  • Successfully Implemented SAML Authentication for Server.
  • Used Tableau Command line utility to create scheduled backup and restore.
  • Used tabcmd to creating group and adding users, exporting a PDF from tableau online.
  • Security Implementation on Tableau server (Permissions& Site roles, Groups& Users, Projects & Project Permissions)
  • Assigning Permissions, Adding a group rile, Editing permissions and Locking permissions to the project.
  • Data Security with user filters (Tableau & Hybrid).
  • Creating Data Connections for MSSQL Server, Oracle 11g, 12c, ODBC connections, Amazon Aurora, Amazon RDS, Redshift and SAP HANA.
  • Administrating the Schedules (Assigning an Extract to an Extract Schedule, Subscription Schedules, Creating New Schedules and Best Practices).
  • Handling change management (Service Now, JIRA) tickets for the software upgrades and patches.

Environment: Oracle 12c, SAP BI 4.2, SAP BI 4.1, Business Objects Enterprise 3.1, Tableau 9.2 and 10.2, Business Objects Designer, Webi Rich Client, Windows XP/2003/2000, Crystal Reports XI R2, Crystal Reports 2008, Crystal Enterprise 10, Weblogic BEA 10.3, Weblogic 12.1.3

Confidential, Alpharetta, GA

Sr. Business Intelligence Architect/Administrator

Responsibilities:

  • Gathering technical requirements from various business partners for architecting the SAP Business Objects systems.
  • Installed and configured clustered Business Objects XI 3.1, BI 4.1, BI 4.2 on Red hat Linux EL 4, 5 and 6.
  • Implemented end to end migration from Business Objects 3.1 SP7 to BI 4.1 SP4.
  • Installed and configured SAP Crystal Enterprise Server 2013 SP8 on Windows 2012 Server.
  • Created POC’s on SAP Lumira, Tableau 9.3 and APOS tools.
  • Installing and Configuring Design Studio 1.6 BI platform add-on to UNIX platform.
  • BI Platform Configuration for Universes in Design Studio.
  • Configuring the services for Designer Studio(Mobile, Dashboard)
  • Implemented monitoring (watches, alerts) using Auditing Database.
  • Implemented the automation deployment script to deploy the crystal reports on Business Objects environment using Jenkins tool.
  • Installed and Configured the Manage Engine monitoring tool and configured the Crystal and Webi Services ports in Manage Engine.
  • Migrated the Crystal Enterprise 10 environment to SAP Crystal Enterprise Server 2013 including the
  • Experience in using 360 Suit for Administrating the Business Objects 4.1 and 3.1 Environments.
  • Experience in Using the APOS tools to administrating the Business Objects 4.1 which includes migration of Universes and converting the universes and re-pointing the reports.
  • Server sizing for Adaptive Job Servers, CMS, Webi Processing servers, Input and Output servers according to the requirements gathered.
  • Configured Business Objects cluster environment in Unix Environment and Windows environment as well.
  • CMS, Job Servers, Input and Output Services/daemons monitoring configured in SAP BI 4.0.
  • Applying patches, service packs, fix packs and maintenance.
  • Deployment of Universes and Webi Intelligent reports.
  • Migrated the processing extensions (row level security) from Crystal Enterprise 10 to CR 2013 server.
  • Used promotion management while migrating the reports/users/groups from QA to UAT and to PROD.
  • Extensively used the Report Inspector tool to change, multiple reports database schemas, scheduling multiple reports, deploying and publishing.
  • Implemented back up procedure using Import Wizard to BIAR files and also Schema backups from Database.
  • Installing the Weblogic Application Servers for Business Objects and deploying the war files.
  • Created Auto Scripts to restart the servers and services in maintenance window.
  • Proxy related administration for BO URL’s and WMS applications.
  • On-call support over the weekend or off hours including on-call rotation.

Environment: Oracle 11g, SAP BI 4.2, SAP BI 4.1, Business Objects Enterprise 3.1, Business Objects Designer, Webi Rich Client, Windows XP/2003/2000, Crystal Reports XI R2, Crystal Reports 2008, Crystal Enterprise 10, Weblogic BEA 10.3, Weblogic 12.1.3

Confidential, Charlotte,NC

Sr. Business Objects Architect/Administrator

Responsibilities:

  • Installed and configured Business Objects XI R2, XI 3.1, BI 4.1 on Windows 2008 Server .
  • Server sizing for Processing Job Servers, CMS, Input and Output servers according to the requirements gathered.
  • Implemented SSO-Single Sign Windows AD authentication.
  • Configured Business Objects cluster environment in Unix and Windows environment as well.
  • Migrated XI R2 and 3.1 SP3 environments to SAP BI 4.1.
  • CMS, Job Servers, Input and Output Services/daemons monitoring configured in SAP BI 4.0.
  • Applying patches, service packs, fix packs and maintenance.
  • Deployment of Universes and Webi Intelligent reports.
  • Training provided on LCM (Life Cycle Management) to Developers and Admins.
  • Configured the SMTP settings to send the reports to users email after scheduling the reports in Crystal Enterprise Server and Business Object Server.
  • Implemented Custom Access Levels to use of efficiently the security methods.
  • Implemented back up procedure using Import Wizard to BIAR files and also Schema backups from Database.

Environment: Oracle 11g, SAP BI 4.1, Business Objects Enterprise 3.1, Business Objects Designer, Webi Rich Client, Windows XP/2003/2000, Crystal Reports XI R2, Crystal Reports 2008, Crystal Enterprise 10, Weblogic BEA 10.3

Confidential, Alpharetta, GA

Sr. Business Objects Architect/Administrator

Responsibilities:

  • Installed and configured Business Objects XI R2, XI 3.1, BI 4.0 on Red hat Linux EL 4 and 5.
  • Server sizing completed for Processing Job Servers, CMS, Input and Output servers according to the requirements gathered.
  • Implemented SSO-Single Sign On with Vintela on Windows platform.
  • Configured Business Objects cluster environment in Unix Environment and Windows environment as well.
  • Migrated XI R2 environment to Business Objects 3.1 SP5.
  • Migrated XI R2 and 3.1 SP3 environments to SAP BI 4.0.
  • CMS, Job Servers, Input and Output Services/daemons monitoring configured in SAP BI 4.0.
  • Applying patches, service packs, fix packs and maintenance.
  • Deployment of Universes and Webi Intelligent reports.
  • Training provided on LCM (Life Cycle Management) to Developers and Admins.
  • Extensively used the Report Inspector tool to change, multiple reports database schemas, scheduling multiple reports, deploying and publishing.
  • Configured the SMTP settings to send the reports to users email after scheduling the reports in Crystal Enterprise Server and Business Object Server.
  • Implemented Custom Access Levels to use of efficiently the security methods.
  • Implemented back up procedure using Import Wizard to BIAR files and also Schema backups from Database.

Environment: Oracle 11g, SAP BI 4.0, Business Objects Enterprise 3.1, Business Objects Designer, Webi Rich Client, Windows XP/2003/2000, Crystal Reports XI R2, Crystal Reports 2008, Crystal Enterprise 10, Weblogic BEA 10.3

Confidential

Jr Business Intelligence Developer

Responsibilities:

  • Involved in SAP CRM Base Customizing Project from March -2006.
  • Created a report Called ZV SALES DOC CHANGE LIST. If any user changed the sales document details, this report shows that employee id, time and date details.Created following functional test cases for regression testing.
  • Intercompany Billing Process, BPO Process, CBAC Billing Process, LTPA (Long Term Assignment Project, Consulting Revenue Generation Process. Created Test Cases in Consulting and Software Area for SOX Compliances.
  • Clearing the CSN Ticket Messages in Components.
  • Extensively worked in front-end BW Components Queries, Calculated key figures, formula key figures, restricted key figures, Structures, re-usable structures, Variables and workbooks, alert monitor, Job schedule monitor, Exceptions handling.
  • Worked on query development and formatting techniques in both BW and MS Excel.
  • Prepared end user training documents and developed business process documentation.
  • Worked extensively in BEx analyzer and BEx browser in defining queries using variables for characteristics, worked on jump queries and Info Set queries.

Environment: Oracle SAP Enterprise Portal 6.0, mySAP CRM 4.0, Portal Services and web services, NetWeaver Developer Studio 4.0, HTMLB, JSPDynPages, SAP BW 3.OB.

Confidential

Network/System Administrator

Responsibilities:

  • Supported and implemented multiple LAN and WAN subnets
  • Support to ERP modules like SD, MM (Inventory) and Accounts.
  • User Administration in Windows AD
  • Troubleshooting & Up gradation of Hardware
  • Windows 2K Server/Client Administration
  • Lotus Notes mail Client Administration
  • Creating mail file in local server.
  • RAS Connectivity and maintenance
  • Anti-virus Administration, Citrix client Administration
  • Configure VPN tunnels for secure access to main office
  • Co-ordination with Vendors, ISP & DOT etc.
  • Implemented DNS, DHCP, and Web Proxy services.
  • Network administration and desktop support for the LAN users
  • Configuring VPN and RAS for LG Remote Offices& LG Service Centers
  • Cisco router installation and configuration.
  • Lotus Domino Server Configuration and Maintenance.
  • Developed and maintaining over 45 Notes databases.
  • Involved in installation, configuration and administration of Lotus Notes servers and clients, including, monitoring replication, registering users, backup and restoring and trouble shooting
  • Deployment of databases according to the Corporate Instructions

We'd love your feedback!