Having ** years of IT experience with extensive development, maintenance and Management Exposures for Global Customers Like, Spectra Labs, Philips, Sage etc...
Primary responsibilities include BI Project management, Estimation, SOW preparation, Risk Management and Resourcing.
Worked on Successful projects that includes Deployment of SAP Business Objects Portlets in Liferay Environment, Integrating Spectra symphony application with BO 4.x, Patient/Test Lab analytical dashboards.
Experience with Design and Installation of large scale Business Objects Enterprise on SAP BO 4.0/XI 3.1/ 3.0/R2. Expertise in SAP BI tools like CMC, CMS, BO SDK, IDT, Lumira, Dashboard, Design Studio and Crystal Reports.
Expertise in Business Objects Security Model and experience with Business Objects Security Implementation in SAP BI 4x, XI 3.1/ 3.0/R2
Practiced standard software development methodologies and full Standard Life cycle development (SDLC) practices to produce high quality reporting solutions in efficient manner
Have extensive working knowledge of all stages of Business Intelligence development in Healthcare, finance, retail, manufacturing Industries. An effective communicator with client and team members, easily interfacing between the technical and non-technical users
Successfully migrated BO xir2 to 3.1, BO 3.1 to 4.2 involving complex security model with thousands of users and groups. Customized the business intelligence platform using java SDK to meet the requirements
Integrated SAP ERP system with web application for real time processing of the sales orders for various users
Automated the Laboratory system by integrating lab equipment’s with web application resulting in error free processing of specimen results.
Developed the HL7 Integration framework for Connecting Radiology equipment’s with Health Care systems for share images (X rays, MRI, etc)
Performance tuned SQL queries using Explain plan and auto trace
Expertise in SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS). with good knowledge on SQL Server Reporting Services (SSRS)
Business Intelligence Tools
SAP Business objects enterprise BI 4.2, 4.1, 4.0, XI 3.1/R2, Crystal Reports 2008, XI, Crystal Enterprise 4.0, Information design tool, Universe Designer, Web Intelligence, Launch pad, Info view, CMC, CCM, CMS, Import Wizard, Upgrade management tool, promotion management tool, SSRS, Analysis for OLAP, SSAS
XCelsius Dashboard 2008/2013,Sap Lumira, Tableau Desktop, Design Studio,
Oracle, SQL Server, SAP HANA, MY SQL
Tortoise SVN, VSS, Qaaws Web service, Service Now, Rally, SSMS, SAP BO Live office, Zira
Data Warehousing Tools
BEA Web Logic Server, Apache Tomcat
Process & Concepts
Agile, SDLC, Object-Oriented Analysis and Design, Test driven Development, Requirements and Use Case Analysis, UML
Health Care, Manufacturing & Financial Industry
IADs, UDs, POCs, TSDs, Checklists
Windows Server 2012/2008,Linux
Professional Experience (Starting from the Current Employer)
Name Of The Organization
NTT DATA, INC
Sr. Principal Consultant
NTT DATA Global Delivery Services Private Limited
Delivery Principal Consultant
Wood Apple Unik Solutions Pvt. Ltd
ID Business solutions
Project Name Symfonie Analytics, Fresenius medical care
Duration July 2017 to Till Date
Environment SAP B0 4.2 SP03, Webi, Crystal Reports 2016,Live office, SSAS, SSIS, SAP Lumira, Analysis for OLAP, Liferay, Oracle 12C,Sql Server 2017
Role Lead SAP Business Objects Consultant
Successfully deployed SAP B04.2 sp03 on production server, implemented complex security model and responsible for day to day BO admin tasks
Implemented Load balancing cluster and sized the BI environment to support future load
Deploy SAP Business Objects Portlets in Liferay Environment and give an option to run Business Objects reports, Dashboards from organization portal
Apply the service packs in production, test environments and train the analyst users and make sure analyst users are familiar with latest product enhancements. Leverage Innovating technological reporting solution like, SAP Mobile reporting, Sap Lumira
Designed complex Dashboards like Test Turnaround time Dashboard, Result Detail report, Cancelled Test Dashboard on Lumira, webi and SAP BO Dashboards, Create multi data source Universes, design various reports on them. Design dashboards on Adhoc request from management
Configured Email, SMTP, SFTP, File system and configure the user security .Create Publications, schedules and customize them as per the requirement
Develop Dashboard templates in Lumira discovery and share with Analyst users for further enhancements
Optimizing Performance of BI environment, Reports, Dashboards and sql queries
Work with SAP support team for the product upgrade and apply the required hot fixes or patches as per sap best practices
Develop framework and Propose solutions for enabling Business Objects reports on Mobile devices (iOS & Android) quick access to data. Design functional specification Documents for New Enhancements and Suggest enhancements to the existing Reporting solutions
Developed, tested and deployed SSIS packages in SQL Server 2017 using Business Intelligence Development Studio.
Created and Managed OLAP Cubes using SSAS.
Project Name Business Objects Upgrade- Billing System, Spectra Laboratories
Duration January 2017 to July 2017
Environment SAP BI 4.2 sp03, Web Intelligence, Crystal reports2016/2008,SAP BO 3.1 SP7
Role: SAP BO Administrator
Participated in Project planning sessions with project managers to analyze the business requirements and outlines proposed solutions
Worked with Infra structure team with list of specification to build the new servers for BO4.2 SP03
Installed, Validated SAP Business Objects 4.2 SP03 on production and test environments and Implemented the BO load blanching cluster
Upgraded the Content from 3.1 to 4.2 using upgrade management tool, Converted .unv universe to .unx using Information Design Tool and fixed issues, Utilize new functionalities comes with BO4.2
Implemented the Windows AD single sign-on(SSO)
Successfully Installed go-daddy SSL certificate on Apache Tomcat
Sized BO cluster environment to support next 5 years of load
successfully migrated users personal content and favorites after SSO configuration
Customized the Webi report Viewing user interface as per Groups and respective user rights
Involved in end user and analyst user training sessions
Migrated the modified content on Go–live day and validated the production environment before opening the floodgates to end users
Project Name Korus- Ordering and Label Printing Application, Spectra Laboratories
Duration November 2014 to December 2016
Environment SAP BI 4.1, Webi, XCelsius Dashboards, SAP BO3.1, Crystal Reports2008,Oracle 11g
Role SAP BO senior consultant
Support all the new initiatives for providing value-added activities which will include providing end to end solutions to clients, transitioning and sustaining production support activities, defining Project Standards, Development of Architecture, Review of Design, and Analysis.
Understand the CR created in Rally and prepare the technical specific documents
Develop New reports using webi, crystal reporting tools,Dashboards, Build Ah-doc Universes as part of client on boarding process and build the security as per Client requirement
Perform Production release and validate,Prepare the Release notes and share with QA team to perform post production release validation
Solve tickets raised by business users, end users in service-now ticketing tool and suggest CR team if we any ticket which involves any change/enhancement in exiting functionality
Optimize the report performance,analyze the servers logs and debug report timeout issues
Work with Infrastructure team to apply OS level patching .Administer and supervise the BO environment by monitoring/granting permissions and rights to a vast Users located all over the world for viewing, creating, Scheduling and publishing reports
Analysis and perform Business Intelligence server upgrade and SDK integration with java and web applications.
Project Name Korus- Ordering and Label Printing Application-Offshore, Spectra Laboratories
Duration September 2012 to October 2014
Environment SAP BO3.1, Crystal reports2008, XCelsius 2008, Java SDK, Oracle 11g
Role BI Team Lead
Understand the business requirements and derived technical specifications from functional specifications and develop Semantic layer and Standard formatted/Ad hoc Reports using Crystal Reports and Web Intelligence.
Responsible for delivering change requests and provide quick fix to Production Issues
Provided Work Estimation and Resource utilization information to Client
Managing the Offshore BI team by assigning development tasks and QA tasks and deliver back to customer after a code/Test case review
Project Name Migrating from Business Objects XI R2 to XI R3.1, Spectra Laboratories
Duration November 2011 to August 2012
Environment Business Objects XI R2, R3.1, Java SDK, Crystal Reports 2008, XCelsius 2008
Role SAP BO Administrator
Successfully installed and configured SAP Business Objects 3.1 on Staging Environment, Applied Service Pack and fix pack
Used Import Wizard tool to migrate all the objects from SAP BO XIR2 to BO 3.1
Tested all the reports that are migrated, and analysed the performance of the BO 3.1 using Load Runner by creating many virtual users
Resolved the performance issues in SAP BO 3.1
Successfully installed and Configured SAP BO 3.1 on Production Environment in various client regions
Expertise in scheduling of repository backup and tuning the Business Objects servers for a better performance
Configured File Repository Servers, Crystal Report Job, Cache and Page Servers, LOV Job server, Web Intelligence Job and Report Servers, Desktop Intelligence Job, Report and Cache Servers, Destination Job Server, Program Job Server, and Event Server
Applying patches, hot fixes, critical fixes, service packs and testing/applying security patch
Project Name Actuate goes BO, Philips Healthcare
Duration March 2011 to August 2011
Environment SAP BO 4.0, Crystal Reports Enterprise, Launch pad, IDT, Oracle 11g
Role Sap BO/Crystal report Consultant
Migrated various reports from actuate tool to SAP BI 4.0
Involved in design and development of reports from scratch using Web Intelligence on Launch pad and Crystal Reports Enterprise
Developed required universes and derived tables for the DB procedures using Information Design tool (IDT)
Acquired good understanding of the actuate tool for migrating reports w. r. t functionality and technical difficulties
Project Name UnikPro, GE India
Duration February 2010 to December 2010
Environment SAP BOxir2, Crystal Reports XI, Sage SDK, SQL-Server 2008,Dot Net, SSRS
Role Technical Consultant
Involved in designing of UnikPro modules like Sales and Forecasting, Manufacturing using sage SDKs.
Developed various reports for above modules using crystal reports and SQL server and tested their layouts to match the requirements.
Designed analytical reports, Dashboards for Sales and Forecasting module.
Project Name IDMsys Health Care Information System
Duration July 2007 to January 2010
Environment Crystal Reports XI, Sage SDK, SQL-Server 2005, SSRS
Role Sage SDK Crystal report/Developer
Designed Laboratory and Radiology applications using sage SDKs and developed related reports for the same.
Strong Understanding of Sage Accpac Financial and Accounting Modules such as AP, AR, GL, Bank etc... Designed Various Reports for Financial Statements on crystal reports.
Involved in Hospital Billing Management and Stock Management with designing the Interface for same in VB forms using Sage Accpac SDKs.
Designed and delivered complex reports like MIS and Statistics Reports, Daily Cash and Credit Statements with Billing Registers using crystal reports and designed SQL queries.
Bachelor of Technology in Electronics Communication – 60.5%, 2006
Jawaharlal Nehru Technological University, Hyderabad