Candidates About

 

Sri Harsha 

Profile 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 Expertise:

 

Reporting Tools	CrystalReports2008/XI/10/9,SAPBusinessObjects XIR3 / R2 / 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, HP-UX, IBM AIX 4.2/4.3
Documentation Tools	MS WORD, MS EXCEL, MS POWERPOINT, Share point

 

 

 

Certifications:

·         SAP Certified BI 4 platform Innovation and Implementation Consultant-2013

·         SAP Certified SAP HANA Cloud Consultant-2013

 

 

 

 

Professional Experience:

 

Veritiv/HP,Fair Field,OH                                                                                                                       Sept 2015 -Present

BUSINESS OBJECTS AND PREDICTIVE ANALYTICS ADMIN                         

The Project is to maintain the existing Business objects system in HEC cloud, to install SAP Lumira and Predictive analytics and also to   maintain existing reports and repository objects and convert Microstrategy reports to Webi or Crystal.

 

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

 

 

 

New York State, Albany NY                                                                                                                          June2013-Aug  2015

Lead Business Objects Administrator

This project is to build a central cloud system for different New York state agencies and host them on the Cloud Environment.   This project supports each and every citizen and related business groups of the New York state.

Lead the team for developing reports that can be accessible on mobile and establishing the link with the BO server with the add on features and mobile app.

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, HP Open View Service Center, Business Object Data Services, C,C++ MS Access, Xcelsius, Micro Soft Excel, Google Analytics.

 

 

Mayo Clinic, Rochester, MN                                                                                                                     Oct 2012- May 2013

SAP Business Objects Administrator.

The Project is to integrate different tools in the Quality Management Section for mayo clinic and build them a Data Warehouse so that it could be more easy and robust for usage and to build reports.  The data comes from different locations like Arizona, Minnesota and Florida, And also from different tools.

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.

 

 

 

 

Deloitte, Camp Hill PA                                                                                                                    April 2012-September 2012

Sr. SAP Business Objects Admin/Developer

This project is to develop reports for the state government of Pennsylvania and automate the existing process. The Workers Compensation Automated and Integrated System(WCAIS) is to develop the reports for the workers and the insurance companies at different levels and make the system run smoothly without any data discrepancies.  It involves the Labor and Industry department, Treasury and Comptroller ,Jurisdiction and Finance.

 

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, HP open View Service, MS access.

 

 

Synermed Insurance, Monterey Park CA                                                                                             Jan 2012-April 2012

Business Objects Admin/Developer

This project is mainly of migration the reports from the Old IPAs to the new ones and setting up the parameters and filters to the reports accordingly and developing new reports on site while gathering the requirements from different end users across California. Teaching the staff on using the info view and how they could export and use the reports.

Lead the team for developing reports that can be accessible on mobile and establishing the link with the BO server with the add on features and mobile app.

As a Report Developer

 

·         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.

As an Administrator:

·         Maintaine