Lokesh Kumar

+1-248-***-****

ac16oz@r.postjobfree.com

PROFESSIONAL SUMMARY:

Around 10 years of experience in SAP Business Objects and Business Intelligence technologies.

Experience hands on development and administration of SAP Business Objects Enterprise Suit.

Expertise in end-to-end implementation of small and large BI applications using SAP Business Objects BI 4.1/3.1 Platform using Web Intelligence, Crystal Reports and Dashboard, etc.

Expertise in creating Universes in IDT/UDT from wide variety of databases with resolving join path problems like loops and traps using aliases, contexts in Business Objects.

Rich expertise in handling all modules of BO 3.1 suit like universe designer, cmc, info view, rich client, import wizard, etc.

Experienced installations, configurations in SAP Business Objects 4.1, 3.1 servers.

Successfully applied full build, service pack and fix pack patches on the enterprise servers.

Installed, configured and maintained servers in standalone distributed and cluster environments.

Successfully configured Enterprise, LDAP and SAP authentications.

Upgraded BO 3.1 data into BI 4.1 using upgrade management tool.

Rich experience in SAP Business Objects 4.1/3.1 security administrations like importing roles from BW/LDAP directories to BO and assigning rights to users/groups/folders/universes according to security model.

Experience on reverse proxy configurations in web servers with apache tomcat applications.

Experience hands on sizing of APS/WPS processing services for better landscape and performance.

Knowledge on BI sizing for all processing services with BI system configuration wizard.

Rich experience on web tier/web application server configuration with apache tomcat.

Well versed with promotion management to promote objects from dev to qa and production.

Exceptional abilities in project design and management with organizational and supervisory skills to assure the success. Delegates and monitors work to meet and beat deadlines.

Rich experienced in developing universes, web intelligence and crystal reports on top of relational and non-relational databases.

Rich experienced in developing universes on top RDBMS systems and of SAP BW as well.

Experience hands on Web Crystal Reports 2013, Dashboards, and I on top of BW/BEx queries and RDBMS systems as well.

Well knowledged on ETL such are IBM Data Stage, Informatica.

Strong skills in relational databases like oracle 11g, sql server 2008, etc. and extensively worked on sql and plsql.

Extensively worked on SQL, PL/SQL, and very good exposure to Oracle 11g, SQL Server 2008, etc.

Well knowledged and Intermediate level experience in ETL i.e. in IBM Data Stage 9.1

Periodically backed up the entire environment, disaster and recovery planning.

Experience in analytical tools such are dashboard designer, design studio, explorer, Lumira, etc.

Good knowledge and experienced in Dash Board designer/Xcelsius with Live Office and Qaaws connectivity

Good project experience hands on Tableau 9.1/10.1

In Tableau, created multiple worksheets, dashboards with groups, interactive filters, conditional sets, bins and data blend functionalities.

Experience in production and technical support activities and managing production rollouts.

Confident, independent, leadership skills, good decision-making abilities, strong technical, communication, time management and interpersonal skills.

PROFESSIONAL EXPIRIENCE:

Cisco Systems, Inc., Morrisville, NC Oct’16- Till

Role: Business Objects Lead (BO Admin + Production Support)

Project Description: Cisco Systems Inc. is one of the leader in computer networking domain with vast experience in developing new network protocols and supply network hardware and software solutions to its customers across the world. Cisco has huge Business Objects platforms to host around 70+ business applications in different environments for different entities like Supply Chain, Dynamic Insight Sales Executive, Finance, etc. It is huge responsible & challenge to maintain and support around 40+ servers of BO for all Cisco business applications in different OS environments.

Roles & Responsibilities:

Installed and configured Business Objects 4.2 SP2 on windows and Linux servers and applied fix patches.

Clustered 40+ serves in the production environment to maintain high availability and tested the failover capability.

Designed and implemented the new security model for the Business Objects 4.2 environment.

Provided level two support for Business Objects environment including security administration, server administration, design and creation of universes, and migration of Business Objects reports across environments. Migrated the content from 3.1 to 4.2 using upgrade management tool.

Implemented LDAP authentications.

Promoted the tested content form development to quality and production using promotion management tool.

Worked on sizing of adaptive processing and web intelligence processing services for better performance.

Configured and customized tomcats for Business Objects login pages.

Adding/removing SIA nodes in BO based on necessity.

Scheduled business reports with SMTP, email, BI Inbox destinations.

Weekly server maintenance for better operations.

Backup and recovery mechanism implementation by backing up the FRS and CMS databases.

Assist BO developers and power users with report development/runtime issues.

Interacted with the business users to analyze the business process/gathered the requirements and made necessary changes to schema objects to fulfill their reporting and business needs.

Involved in requirements/business process and transformed them into functional & technical details

Involved in use case and report specification design for BO Reporting

Designing the Business Object universes using UDT, IDT.

Responsible for creating the complex reports (on demand, adhoc reports, frequency reports, summary reports, sub reports, drill-down, dynamic grouping, cross-tab, graphical, aging reports involving parameters formulae, running totals and created reports against views & base tables)

Provided standards, best practices and checklists for reports and universes to improve the performance and maintain consistency across the environment.

Debugging reports scripts like SQL queries to analysis report design in part of improving reports performance issue.

Created complex reports master/detailed reports by using of open doc functions.

Worked with SAP technical support to troubleshoot various deployment and performance issues.

Member of the production support team and provided 24*7 support to keep the environment up and running and continuously monitor, tune and upgrade the environment.

Supports users to provide access to reports, universes and conducts training to business users for their day-to-day BO operational.

Technologies: SAP Business Objects 4.2/4.1, Crystal Reports 2016, Dashboard, Design Studio, Oracle 11g and Teradata 14.

JP Morgan Chase Bank., Houston, TX Apr’16- Oct’16

Role: Sr. Business Objects Consultant.

Project Description: Prime brokerage is one of the package of services offered by JP Morgan Chase investment banks and securities firms to hedge funds which need the ability to borrow securities and cash in order to be able to invest on a netted basis and achieve an absolute return, the project scope was to convert complex database packages/stored procedures into BO reports using with base tables.

Roles & Responsibilities:

Gathered user requirement by understating existing customized legacy reports which are required to convert into BO and designed future state business processes.

Worked with database architecture & Sr. Business Analyst to understand the existing customized reports, which were built on complex oracle, packages/stored procedure.

Created Universe using IDT in BO BI 4.1 for creating Web Intelligence reports.

Designed the BO universe by using physical tables & private synonyms of complex procedures to meet the user requirements.

Worked with the data model team to create the necessary backend tables and integrate the business logic to have the aggregated data available for Web Intelligence reports.

Designed developed, maintained and tested universes for supporting adhoc and canned reports and implemented features such as aliases, context, etc.

Created contexts, joins and aliases for resolving loops and checked the integrity of the universes.

As a part of universe development, create classes, sub classes and different kinds of objects, predefined conditions, prompts and hierarchies.

Created complex reports with multiple data providers along with combined, sub-queries.

Created nested section report with different structured templates to meet existing PDF bookmarks.

Created a complex report with different block structure with dynamic selection.

Migration of universes and reports from development, test to production using promotion management.

Designed the access levels, security model for folder, universe in CMC.

Organized data in the reports by using filters, sorting, ranking and highlighted data with conditional formatting.

Created complex variables and calculation to meet the user requirements.

Technologies: SAP Business Objects 4.1, Oracle 11g.

Johnson Control Inc., Holland, MI Aug’14- Apr’ 16

Role: Business Objects Lead.

Project Description: Johnson Controls automotive experience is a global leader in automotive seating, overhead systems, floor consoles, door panels and instrument panels. The project mainly deals with Business Best Practice (BBP) & MFG plants data collected from different products and consolidated into DataMart’s which are used for report generations. Also another scope of the project is upgrading technologies from old versions to new mainly in Business Intelligence and support.

Roles & Responsibilities:

Performed Installation/ upgrades activities for several Business Objects servers.

Performed configuration changes in Business Objects environment.

Performed production support activities related to Business Objects environment and responding to the Business Objects related requests.

Promoted the tested content form development to quality and production using promotion management tool.

Worked with enterprise architect to configure reverse proxy and site minder for balance the load.

Worked on sizing of adaptive processing and web intelligence services for better performance.

Scheduled and executes weekly reboot scripts tomcat and BO processing servers.

Backup and recovery mechanism implementation by backing up the FRS and CMS databases.

Worked on to add bulk user into BO user group to minimize manual efforts.

Assist BO developers and power users with report development/runtime issues.

Interacted with the business users to analyze the business process/gathered the requirements and made necessary changes to schema objects to fulfill their reporting and business needs.

Involved in requirements/business process and transformed them into functional & technical details

Involved in use case and report specification design for BO Reporting

Worked with SAP technical support to troubleshoot various deployment and performance issues.

Worked with DBA’s and system administrators to back-up the repository and database and scheduled daily and weekly back-ups for both environment and repository.

Member of the production support team and provided 24*7 support to keep the environment up and running and continuously monitor, tune and upgrade the environment.

Supports users to provide access to reports, universes and conducts training to business users for their day-to-day BO operational.

Technologies: SAP Business Objects 4.1, Crystal Reports 2013, Dashboard, Design Studio, Oracle 11g and Progressive DB.

Harley-Davidson, Milwaukee, WI Aug’12- Aug’14

Sr. Business Objects Administrator/Developer.

Project Description: Harley-Davidson is a major US maker of motorcycles and the nation's #1 seller of heavyweight cruisers. The company offers touring and custom Harleys through a worldwide network of more than 1,300 dealers. Harley-Davidson sells its brand-name products, which include a line of clothing and accessories (Motor Clothes). Harley-Davidson Financial Services (HDFS) offers financing to dealers and consumers in the US and Canada. The SAP & Non SAP ERP solution for Harley-Davidson included the following modules: Finance and Controlling, Materials Management, Sales and Distribution, Vehicle Management System, Financial Supply Chain Management and Dealer Portal...

Roles & Responsibilities:

Installed and upgraded BO 3.1 environment to services pack 5.

Configured and imported SAP/LDAP group in BO environment.

Implemented security model in dev, quality and production environments.

Monitoring overall system performance and availability

Regular weekly backup of entire BOE in BAIR files.

Automated and scheduled scripts to reboot Business Objects servers weekly.

Maintenance of activities related to universe, reports and user profiles.

Experience in migration of reports from different environments using Import Wizard.

Creating, developing, distributing, migrating and modifying universes in Business Objects.

Extensively involved in managing repositories, connections, creating, managing users/groups and importing/exporting documents into repository with using of import wizard & scheduling reports.

Created complex reports by using linking data from multiple sources using functionalities like synchronization, combined quires, drill through, master details.

Involved in the identifying BEx queries and designed, built universe and classes/objects.

Retrieved and published documents from and to corporate repository respectively.

Created the webi reports using Business Objects XI 3.1 functionalities like multiple data providers, prompts.

Organized data in the reports by using filters, sorting, ranking and highlighted data with alerts.

Created a large number of Web Intelligence chart reports and resolved database delegate aggregation key figure issues reporting level.

Experienced in scheduling the web intelligence reports to different recipients in diff format.

Used different type of data provider universes which are on top of SAP BW BEx queries.

Involved in training the end user in basic and advanced adhoc reporting as well as create queries, format results, and share them with others within the enterprise and beyond using web intelligence.

Created adhoc reports according to the user requirements.

Tuning the reports to improve the performance of the report refresh time.

Technologies: SAP Business Objects 3.1, crystal reports 2008, xcelsius 2008, live office, and SAP BO integration kit, infosol infoburst.

Isola Group, Chandler, AZ Apr’10 – Aug’12

Business Objects Administrator/Developer.

Project Description: Isola is a leading global material Sciences Company that designs, develops and manufactures laminate materials used to fabricate advanced multilayer printed circuit boards, which provide the physical platforms for the semiconductors, passive components, and connection circuitry that power and control virtually all modern electronic products. Isola high-performance materials are used in a diverse range of electronic end-markets including applications in computers, networking and communications equipment, high-end consumer electronics, as well as products designed for use in the advanced automotive, aerospace, military and medical markets.

Roles & Responsibilities:

Installed, upgraded, configured and tested SAP Business Objects BI 3.1 to 4.0.

Implemented BO authentication with SAP and enterprise.

Imported BO 3.1 content into BI 4.0 using Upgrade Management Tool.

Modified web.xml files as per infoview application customization.

Experienced in designing and developing security model in dev, quality and production environments.

Experience in developing a user security rights to Business Objects enterprise.

Regular weekly backup of entire BOE in BAIR files.

Shutting down & Running up all Business Objects Servers in case of server Initializing issues.

Maintenance of activities related to universe, reports and user profiles.

Experience in migration of reports from different environments using import wizard.

Creating, developing, distributing, migrating and modifying universes in Business Objects.

Extensively involved in managing repositories, connections, creating, managing users/groups and importing/exporting documents into repository with using of import wizard & scheduling reports.

Created complex reports by using linking data from multiple sources using functionalities like synchronization, combined quires, drill through, master details.

Involved in the identifying BEx Queries and designed, built universe and classes/objects.

Retrieved and published documents from and to corporate repository respectively.

Created the webI reports using Business Objects XI 3.1 functionalities like multiple data providers, prompts.

Organized data in the reports by using filters, sorting, ranking and highlighted data with alerts.

Created a large number of web intelligence chart reports and resolved database delegate aggregation key figure issues reporting level.

Experienced in scheduling the web intelligence reports to different recipients in diff format.

Used different type of data provider universes which are on top of SAP BW BEx queries.

Involved in training the end user in basic and advanced adhoc reporting as well as create queries, format results, and share them with others within the enterprise and beyond using web intelligence.

Created adhoc reports according to the user requirements.

Tuning the reports to improve the performance of the report refresh time.

Prepared of unit test cases & technical design documents for further reference.

Technologies: SAP Business Objects BI 4.0/ 3.1, crystal reports 2008, xcelsius 2008, live office, and SAP BO integration kit

NBC Universal, New York, NY Apr’08 – Apr’10

Business Objects Developer.

Project Description: NBC Universal is one of the world's leading media and entertainment companies in the development, production, and marketing of entertainment, news, and information to a global audience. Formed in May 2004 through the merger of NBC and Vivendi Universal Entertainment, NBC Universal owns and operates the No.1 television network, the fastest growing Spanish-language network, a valuable portfolio of news and entertainment networks, a premier motion picture company, significant television production operations, a leading television stations group and world-renowned theme parks.

Roles & Responsibilities:

Studied the client/ owner specifications before starting the project.

Involved in the designing and building of universes, classes and objects.

Designed developed, maintained and tested universes for supporting adhoc and canned reports and implemented advance features such as aliases, context, etc.

Created cardinalities, contexts, joins and aliases for resolving loops and checked the integrity of the universes.

As a part of universe development, create classes, sub classes and different kinds of objects, predefined conditions, prompts, pseudo optional prompts and hierarchies.

Migration of universes and reports from development, test to production using import wizard.

Scheduled and distributed the documents through infoview and CMC as well.

Retrieved and published documents from and to corporate repository respectively.

Created the reports using Business Objects XIR2 functionalities like multiple data providers, prompts and drill down.

Created complex reports master/detailed reports by using of “Open Doc” functions.

Organized data in the reports by using filters, sorting, ranking and highlighted data with alerts.

Created complex variables and calculation to meet the user requirements.

Created various geographical and time dimension reports of fiscal year, quarter, month, week and daily reports for all domains and published through web intelligence.

Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects XIR2.

Created a large number of full client and web intelligence reports, queries with constant interaction with the end users.

Used different type of data provider universes, free-hand SQL’s

Created adhoc reports according to the user requirements.

Technologies: Business Objects XI R2, crystal reports 2008, xcelsius 2008, Oracle 9i.

Contact this candidate