We provide IT Staff Augmentation Services!

Business Objects And Predictive Analytics Admin Resume

Fair Field, OH

SUMMARY:

  • Certified BI 4 Innovation and Implementation, SAP Data Science, SAP HANA cloud and Software on HANA Consultant with around 9 years of experience in Information Technology with a thorough knowledge in Analysis, Design, and Development and Implementation of Data Warehousing applications for Financial, Healthcare, and Insurance & Pharma.
  • Over 6 years of experience in SAP Business Objects Administration/Architecture.
  • Expert in Business Objects BO Administrator 4.1/4.0/XI 3.1/ 3.0/R2/6.5.
  • Designing, Configuring and Managing Servers and Service properties in SIA, CCM and CMS.
  • Expertise in Business Objects XI R4.1 installation, migration, configuration, Administration, security maintenance, technical support and troubleshooting of Business Objects implementation in shared and dedicated environments.
  • Expertise in Upgrade issues / procedures from XIR3 to XI4.0/4.1/4.2 with products like Lifecycle Management, Promotion Management, Upgrade Management.
  • Expertise in Business Objects XIR4.0 / 4.1 - Report Conversion Tool, Webi Rich client, Crystal Reports Designer, Business View Manager, Upgrade Management, LCMBIAR concepts, Promotion Management, Lifecycle Management, Business View manager, Query Builder, web intelligence, CMC,CCM.
  • Security Administration in XI4 - Including Access Levels, User-Group Management, Folder security, row and data security, object level security
  • Promoting Code and Migration between the three environments by using manual or GUI methods - between DEV/UAT/ PROD for both XIR2,XIr3 and XI4x
  • Working knowledge of configuring the SAP integration Kit and Windows AD SSO.
  • Installing Business Objects Enterprise Server in a Unix/Linux hosted environment for DEV/UAT/PROD environments.
  • Strong understanding of relational and in-memory databases like Oracle 11G, SAP HANA, Vertical, Teradata, SQL Server and SAP multi-dimensional systems.
  • Provided 24X7 supports to the users and make sure the environment is Highly Available.
  • Worked with all the dependent server teams to provide them with list of specifications need to build the servers for BO4.0. And troubleshooting server errors and utilizing management console for monitoring, requesting start and stop servers as required from infrastructure team.
  • Involved in the site to site VPN implementation of the data exchange between the servers.
  • Worked on configuration of SAP business Object Mobile server and installation.
  • Worked with Developers to consolidate the Business Objects repository before migrating to BO4.1.
  • Experience with Installing and Administration of entire hardware, and software products like Tomcat, and Apache (Clustered and Standalone environments).
  • Good understanding of IIS and Tomcat, web servers as it relates to the Business Objects infrastructure and understanding of Web Infrastructure (Web Servers, Application Servers, BigIP and Firewalls).
  • Good knowledge of Unix/Linux and scripting.
  • Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.
  • Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture including both OLAP & OLTP data and complete lifecycle of project from design to development and implementation.
  • Good knowledge and experience in data warehouse development life cycle, requirement analysis, dimensional modeling, and implementation of STAR, Snowflake schemas and Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and
  • Experience in generating complex queries by linking data from multiple data providers using free hand SQL, PL/SQL, Stored Procedures, Triggers, Functions and packages with development tools like TOAD and SQL Developer.

TECHNICAL SKILLS:

Reporting Tools: CrystalReports2008/XI/10/9,SAPBusinessObjects XIR3 / R 2 / 6.5 / 6.0 /5.1 (Designer, WebI, DeskI, CMC, Dashboard Manager InfoView, Crystal Xcelsius, Live Office, Import Wizard),SSRS, Cognos

Data Warehousing Technologies: Business Objects Data services, Data Federator, IBM Infoshere/Ascential(Datastage 8.0.1, 7.5),SSIS, Informatica 5.1, 7.x

Databases: Oracle 10g/9i/8i, SQL Server 2000/05/08, Teradata, DB2, Sybase

Database Tools: TOAD, SQL Navigator, Quest Central, SQL*PLUS, Query man

Programming: C, C++, JAVA, ASP.NET, VB, HTML

Operating System: Windows NT/98/200/2003, Windows XP, Sun Solaris 2.6/2.7/2.8, Confidential -UX, IBM AIX 4.2/4.3

Documentation Tools: MS WORD, MS EXCEL, MS POWERPOINT, Share point

PROFESSIONAL EXPERIENCE:

Confidential, Fair Field, OH

BUSINESS OBJECTS AND PREDICTIVE ANALYTICS ADMIN

Responsibilities:

  • Architecture and Installation of SAP Business Objects on the Cloud.
  • Migration of Business Objects from SAP HEC to AWS Cloud
  • Upgrade from SAP 4.1 SP04 to SAP 4.2 SP03
  • Installation of predictive Analytics and Lumira on Cloud and local machines
  • Maintain and perform BO admin activities
  • Migration from SAP 4.1 SP4 to SAP 4.1 SP7
  • Recommended changes to the environment for better performance
  • Work closely with SAP to implement changes in BI4
  • Work with Customers and gather requirements
  • Created BI Web services (BI Services) directly from Web Intelligence Rich client as middle layer and used in creating the Xcelsius Dashboard.
  • Revised plan for backup and restoration on the cloud and for local power user folders
  • Solve Prod Tickets on performance, Migration and Security.
  • Install and build dashboards with Design Studio
  • Install Lumira on client machine.
  • POC on SAP Roambi Analytics.
  • Participate in Migration and Report Bursting Activities in Microstrategy.
  • Working on Business Objects and Sales Force Integration
  • Installed and configured Predictive Analytics.

Environment: Oracle 12C, SAP BI 4.1 SP7, Predictive Analytics 2.5, SAP HEC Cloud Environment, SAP HANA 1.0

Confidential, Albany NY

Lead Business Objects Administrator

Responsibilities:

  • Full cycle development experience with BusinessObjects, Data warehousing and reporting projects.
  • Develop the BO environment to accustom according to the Cloud Environment.Clustering Business Objects and Load balancing the environment.
  • Wrote SDK programs for BO with requirement to the Client
  • Experience in Install, upgrade, backup, patch SAP Business tools in windows environment, to support different projects/initiatives.
  • Developed Adapter files to accustom to Cloud ENvironment
  • Installed and configured Business Object Enterprise XI 4.1 in clustered environments for development, Test and production including installation of BO Tools and Integration Kit. Creating Initial configurations in CMS and CCM.
  • Perform capacity planning and Load Balancing of servers to support job loads and suggest infrastructure upgrades .
  • Exposure to Informatica power exchange and other connectors offered by Informatica SAP.
  • Strong Business Objects troubleshooting experience.
  • Hands on experience in Web Sphere Administration for Business Objects.
  • Installed and Supported the verity of BI tools like Crystal reports, Qwaas, Tableau Reporting tools.
  • Documented the issues for the future reference
  • Created the guided Environment for Healthcare Management system
  • Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues.
  • Used Global variables, Local Variables and Parameters between Work flow and Data flow as per businessrequirements.
  • Created batch scripts For to run BODS extracts .
  • Managed end users, Exporting/ Importing SAP HANA System.
  • Managing SAP HANA License, Managing SAP HANA users and monitoring system.
  • Managing Tables in SAP HANA, Scaling SAP HANA.
  • Involved in production support and fixed the issues on the jobs while running in production.

Environment: Business Objects 4.1/3.1, Crystal Reports 2011/2008,SAP HANA, SQL Server, Oracle, PL/SQL, Crystal Reports (V9, V8), OLAP, Share point 2010, Confidential Open View Service Center, Business Object Data Services, C,C++ MS Access, Xcelsius, Micro Soft Excel, Google Analytics.

Confidential, Rochester, MN

SAP Business Objects Administrator

Responsibilities:

  • Involved in requirements gathering, analysis, design, architecture and documentation
  • Installed and configured Business Object Enterprise XI 4.0 in clustered environments for development, Test and production including installation of BO Tools and Integration Kit. Creating Initial configurations in CMS and CCM.
  • BOBJ Administration, security groups, adding users and trouble shootings issues
  • Created of users/user groups and user roles, scheduling jobs and alerts
  • Migrated Universes, Reports, Dashboards from XI 3.1 to BI 4.X
  • Resolved production issues which were related to Universe, Webi, Deski, Dashboards, Crystal Reports
  • Scheduled & monitored reporting jobs and distributed the reports
  • Rescheduled failed jobs and identified the root cause for jobs fail
  • Resolved various server, configuration issues and performance issues
  • Resolved couple of migration issues from XI3 to BI 4.0
  • Migrated/Reverse migrated Universes, Webi, Deski, Dashboard reports from QA to Prod
  • Resolved various user login issues with LDAP, Windows AD
  • Configured Monitoring services and created Watch list on the servers to receive alerts/emails
  • Extensively worked on performance tuning, sizing and maintain system stability
  • Created/Resolved Universe connections, Universes issues and added new tables, classes and objects
  • Worked on Dashboard/Xcelsius 2008 by using QAAS and Live Office connections
  • Analyze and work with stakeholders to prioritize application defects/enhancement and participate in The change management process.
  • Performance tuning and maintenance of the BOBJ environment and presentation layer tool sets
  • Extensively working on 24/7 production support and go-live activities
  • Involved in Unit, Integration Testing, post migration testing

Environment: SAP Business Objects 4.x, BO 3.x, Crystal Reports, Xcelsius, BODS, Oracle and Windows Server 2008 R2. SAP Data Services.

Confidential, Camp Hill, PA

Sr. SAP Business Objects Admin/Developer

Responsibilities:

  • Installed & Configured Business Objects 3.1 on Windows server 2003
  • Involved in Migration and upgrade of Business Objects Universes and reports from earlier versions to XIR3.1
  • Involved in Trouble Shooting and resolving issues with in Business Objects Enterprise.
  • Configured Business Objects Enterprise XI 3.1 InfoView with .NET and Active Directory authentication (including single sign-on using Kerberos in a Windows Server 2003 environment
  • Configured the Authentication options in the Central Management Console
  • Installation & Configuration of Crystal 2008 Enterprise Suite of Products.
  • Defined the CMC Security Skeleton of the Business Objects Enterprise XI 3.1 right from the
  • Scratch.
  • Created/Administered users/user groups/Security in Supervisor/CMC.
  • Installed SAP Integration kits for Crystal Reports
  • Delivered the Best Practices and Recommend settings documentation of Business Objects
  • Enterprise XI 3.1 to the customer.
  • Implemented Migration process for Business Objects XI R2 to XI 3.1
  • Defined server statistics & load balancing test across enterprise environment.
  • Implemented 3-Tier Business Objects with Cluster environment.
  • Installed and set the Central Management Server, Processing Servers & Report Application Server.
  • Actively involved in gathering Server Sizing requirements for software/hardware.
  • Monitored / tuned Business Objects environment based on performance and usage levels
  • Customized info view page and added new frame works. scheduling reports, and viewing report on demand with high performance
  • Provided End user support and guidance to use reports

Environment: Business Objects 4.0, Crystal Reports 11, SQL Express 2008, SSIS, Confidential open View Service, MS access.

Confidential, Monterey Park, CA

Business Objects Admin/Developer

Responsibilities:

  • Install the Business objects Server on the machine and assign the logins to the users using their windows Authentication.
  • Develop new reports from the scratch and develop them according to the users and making continuous changes on the new requirements from the users.
  • Involved in gathering the requirements to create the reports by conducting user interviews.
  • Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in Crystal Reports.
  • Created BI Web services (BI Services) directly from Web Intelligence Rich client as middle layer and used in creating the Xcelsius Dashboard.
  • Participated in requirement gathering and converted them to technical specifications for report generation and did proof of concept.
  • Modifying and enhancing universes as per business/reporting needs which would be the data source for Dashboards and also all ad-hoc/canned reports.
  • Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets. .
  • Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008.
  • Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using Xcelsius 2008.
  • Used Xcelsius for presenting dashboards to End users.
  • Created Revenue Dashboard, Sales figure Dashboard using Xcelsius 2008
  • Used the BVM for designing the universe.
  • Exported the reports to PDF and Excel, word.
  • Created various simple and complex reports using drill down, filters and alerts.
  • Optimized the usage of user objects, conditions and universe level filters
  • Extensively used multiple data providers for building reports.
  • Maintained the BO admin responsibilities.
  • Training the employees in the company on usage of Info View.
  • Reviewed the formulae on different reports and re wrote many of the formulae.
  • Created users groups for respective departments in the company like finance, claims, doctors, IT team accordingly.
  • Developed reports on the Employee Working hours in the company and schedules those reports to the respective team managers so that they receive it every week.
  • Uploaded numerous reports to CMC and assigned data bases and scheduled them.
  • Extensive experience in creating reports with Charts (Bar Charts, Pie Charts, etc), Cross tabs and Sub reports.
  • Carried out User Acceptance Testing to validate customer acceptance criteria.
  • Changed many reports for the Client and End user meetings to brief them on the reports.
  • Use Confidential Open View Service Center client 6.2 Tool for tracking/open Incidents, RM, RFCs and work on them on priority and timely delivery.
  • Role as a SAP HANA Developer:
  • Created Analytical, attribute and Calculation Views.
  • Created Stored Procedures in SAP HANA Database.
  • Created connections between SAP HANA and Universe connections.

Environment: Business Objects/Crystal Enterprise Server 2011, 2008(Both the CAL and NUL Versions), Crystal Reports 2011/2008,SAP HANA, SQL Server, Oracle, PL/SQL, Crystal Reports (V9, V8), OLAP, Share point 2010, Confidential Open View Service Center, Business Object Data Services, C,C++ MS Access, Xcelsius, Micro Soft Excel

Confidential, Washington, DC

SAP Business Objects ADMIN/ DEVELOPER

Responsibilities:

  • Develop Dash boards using the Xcelsius (Crystal Dash Board Design) and used the pie charts, bar charts, Maps and the Selectors and Containers.
  • Developed Enterprise-level Scorecards in Xcelsius based on data retrieves from Universe.
  • Developing project with the Information Design tool and the Business View Manager.
  • Participated in the project with the project manager and project lead for information gathering.
  • Developed reports on the client side on SSRS as per the requirement of a client.
  • Used dynamic parameters in SSRS to enable/disable the parameters based on user selection
  • Continuously updating the reports on request by the Customers.
  • Developed several types of reports like the Cross tab, Adhoc reports, Slice and Dice, Drill down and Formulae reports.
  • Developed views and Stored procedures for some specific Functions to be used in the Reports.
  • Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.
  • Used Report Builder to do Ad-hoc Reporting.
  • Scheduling and Tuning the Crystal Server..
  • Managed Crystal Enterprise server with Crystal Management Console and Crystal Configuration Manager by Using Crystal Enterprise.
  • Developed Reports such that the Reports and identified with ease and implements some colors.
  • Used parameters and functions such that some particular reports cannot be viewed by an unauthorized official.
  • Developed Excel sheets for the Budget Presentations and consolidated them dynamically.
  • Providing support to existing reports routed through Remedy
  • Created several users and groups and defined the security for all the BO objects and
  • Universes using Central Management Console (CMC).
  • Installed and configured Apache Tomcat .
  • Maintain the security for users, groups, folder, universe, reports and database
  • Creating Publications to schedule the report
  • Creating BIAR file to migrate the code to different environments
  • Creating custom level access as per the security requirements
  • Business Object Info View configuration and administration
  • Business Object Repository Back Up and Restoration
  • Have Good knowledge on query builder

Environment: Business Objects/Crystal Enterprise Server 2011, 2008(Both the CAL and NUL Versions), Crystal Reports 2011/2008, SQL Server, SSRS, Solomon, Crystal Reports For Solomon, Xcelsius,, Business Objects Data Services OLAP,MS Access, Sharepoint, VBA, Micro Soft Excel

Confidential

Business Objects Developer

Responsibilities:

  • Design and development of the complete Decision Support System using Crystal Reports and created reports like, Reports by accounts, loans, check ins and savings, etc.
  • Created complicated formulae and running totals for business measure calculations. Created nested and conditional groups and formatting features in reports.
  • Implemented Crystal enterprise server with apache & tomcat as middle servers.
  • Used PL/SQL Stored Procedures, cursors and functions for the input of data into Crystal Reports.
  • Optimized the usage of user objects, conditions and universe level filters
  • Extensively used multiple data providers for building reports.
  • Created reports like Slice and Dice, Drill Down, Combined Queries, Functions, Cross Tab, Master Detail and Formulae for easy-to-use benefit information system by using Crystal Reports.
  • Ability to work with different Databases and use the reporting tools efficiently.
  • Created Linked, Unlinked, Parameterized and On-demand sub reports for various business needs, reports scheduled for different file based / schedule based events, distributed in email, PDF, HTML, EXCEL, EXCEL2K format.
  • Worked on Parametric fields, formula fields and summary fields.
  • Working on SQL for Complex reports.
  • Involved in meetings with client and gathered business requirements and developed mapping document.
  • Worked with all transformations in Data Integrator and created Global variables, Local Variables in DI.
  • Used various transformations like lookup, Case, Merge, Date Generation, Query, Sql, Table Comparision on data extracted according to the business rules and technical specifications.
  • Designed Summary and Aggregation tables according to the functional requirement specifications and loaded data to support reporting.
  • Prepared monthly closing entries and financial reporting package reports.
  • Tuned sql queries for improving the reports performance.
  • Back end SQL Queries and implementing Stored Procedures.
  • Created interactive excel dashboards and charts and graphs, created scorecards, metric analytics with Crystal Xcelsius.
  • Created users & groups managed users like (resetting password, assigning privileges, enabling their ID's) & managed groups.
  • Migration of universes and documents from one domain to another.
  • Involved in designing logical and physical data Model designing.
  • Analyzed and created facts and dimension tables.
  • Presentation of the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.

Environment: Crystal Reports XI, Business Objects XIR2/6.5.1, Crystal Reports XI, Web Intelligence, Desktop Intelligence, Crystal Xcelsius, TOAD, Oracle 9i, SQL, PL/SQL, Dashboard Manager, C++, HTML, Windows, UNIX.

Hire Now