Kiran

Ph: 703-***-****

adcu4o@r.postjobfree.com

Current location: Herndon, VA

Availability: Immediately

Professional Summary

Over 15 years of experience using various SAP Business Objects Products Suites.

In depth knowledge of SAP Business Objects Administration, Architecture, and Development

SME in Migration of Business Objects XI 3.1 to SAP Business Intelligence 4.0 and 4.1 Platform.

SME in Migration of Data Services 3.2 to SAP Data Services 4.2.

Hands on experience in Installing and Configuring SAP Business Objects BI 4.1, 4.0 Platform on On-Premise and AWS Cloud, SAP Data Services 4.2 and IPS 4.1 on Windows and Linux.

Expertise in Designing the SAP BO Business Intelligence Architecture including High Availability, Fail Over, Disaster Recovery and Backup/Recovery strategies.

Hands on experience in Installing and Configuring Tableau 10.1 on On-Premise and AWS Cloud.

Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.

In-depth knowledge in working and implementation of ALL Versions of SAP Business Objects Business Intelligence Platform & Crystal components

Experience with Business Objects as an OLAP tool for building report, designing universes and managing user profiles. Proficient in using both 2-tier and 3-tier reporting tools like Desktop Intelligence, Reporter and Web Intelligence. Employed sound understanding and knowledge of Business Logic for requirements gathering and designing/developing universes/report to attain that goal.

Good knowledge on ETL for data extraction from disparate sources, data transformations and loading into the target database using Informatica, Data Integrator. Well versed in development of transformations/mappings using designer/workflow manager and monitoring the sessions/worklets using workflow monitor.

Technical hands-on expertise using OLAP tool Business Objects 4/5.x/6.0 /XIR2/XIR3 /BI 4.0/4.1

Created and managed Universes in the Designer from SAP BEX Queries

Expertise on Testing REST API using Robot Framework

Experience in Installation and configuration, Creation of repositories and security domain with user groups and security implementation.

Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Experience on Data Modeling techniques employing normalization and Data warehousing concepts like star/snowflake schema modeling using ERWin.

Production Support (24x7) and Maintenance. Communicating/escalating with Business Objects Support for Issue/Bug Reporting, getting latest Service Packs/Hot Fixes/Patches/Upgrades and LA Fixes.

Proficient in SQL, PL/SQL Procedures, Functions, Triggers and Packages.

Expertise in Linux, UNIX and Windows environment. Good basic knowledge of UNIX Shell Scripting

Migrated Universes, Reports and Users from XI R3 to BI 4.0 using Upgrade Management Tool in BI 4.0, Coordinated and executed Business Objects migration from XIR2 to XI 3.1 SP3 Using Import Wizard and BIAR files applying Business Objects Best Practices

Extensive experience in RDBMS like Oracle 11g/10g/9i/8.x/7.x, SQL Server 2000/8.0/7.0

Worked on Windows 7/XP/2000/98/NT/95 and UNIX/Linux, windows based GUI tools for databases like TOAD, SQL Navigator, Rapid SQL and Enterprise Manager

Worked across various projects like Children welfare, Pharmaceutical, Financial, Mortgage and Retail Industries and utilized best practices based on their BI environments.

Excellent technical, time management, communication, interpersonal and presentation skills

Technical Skills

Decision Support

Solution tools

OLAP Tools Business Objects XIR3/XIR2/XIR1/,BI 4.2/4.1, Xcelcius 2008, Dashboard Manager, Designer, Supervisor, Desktop Intelligence, Web-Intelligence, Info View, Broadcast Agent, CMC Performance Management, Report Conversion tool and Import Wizard, Life Cycle Management.

ETL Tools

Data Integrator 11.7,Informatica Power Center 9.0

(Designer, Workflow Manager, Workflow Monitor)

RDBMS / Database

Oracle 11G/10G/9i/8i/7.x,DB2 v8.1, MS SQL Server 8.0, MS Access

Data Modeling Tools

Erwin 4.1, Microsoft Visio

Development Tools

Toad, SQL Navigator, Rapid SQL, Enterprise Manager,

MS Excel, MS Visual Studio, Microsoft Project Professional

Languages/ Scripting

J2EE, SQL, PL/SQL, C++

Operating Systems

Windows XP/2000/98/95/NT, MS-DOS, Linux, UNIX Sun Solaris

Others

Credit Loss Management (CLM), Concurrent Versioning System (CVS), MVS (Multiple Virtual Storage), JCL (Job Control Language)

Work Experience

State of Michigan Mar’12 – Till date

Department of Human Services (DHS)

Lansing, MI

Sr. SAP Business Intelligence Consultant / Architect

Responsibilities:

Responsible for performing POC of SAP Business Objects BI 4.2 SP04

Performed Assessment of current SAP BI 4.1 SP5 Environment using Query Builder and Sherlock Quick sizer

Performed Capacity Planning, Server sizing using SAP Sizing Estimator and SAP Sizing guide

Installation and Configuration of SAP Business Objects 4.2 SP04 on Sandbox, Dev, Test, UAT and Production on Windows 2016 and SQL Server 2016 SP1.

Responsible for splitting Adaptive Processing Server as required

Provided Support for SAP Business Objects 4.2 Upgrade issues.

Worked with SDA to Expose Business Objects Reports from a third party tool and setting up SSO by generating Logon Token using RESTful Web Service.

Configured Active Directory (AD) Manual Authentication and imported Windows AD groups

Redefined security, created new custom access levels and user groups as per the business requirement

Created universes with Classes and Objects for investment management system.

Defined contexts, aliases and used multi parse SQL in the universes to address loops, chasm traps and fan traps, which support Ad-hoc and canned reports.

Used Index awareness, @aggregate aware and Aggregate tables for optimized query performance. Created universe on top of views build in composite coming from multiple data sources.

Used @aggregate aware function and Aggregate tables for optimized query performance. Used @prompts to create predefined conditions and prompts to filter the data and dynamic user selection

Worked extensively with @functions (@select, @prompt, @where) in designer, created optional prompts, also created objects using complex case functions.

Created Multiple Custom Hierarchies for several groups to provide drill across functionality. Wrote functional specification documents for the project scope to be created in security to be implemented in Business Objects XI R 3.1

Extensively involved in developing Web Intelligence reports' publications, scheduling and monitor publications.

Upgraded Lab environment to BO BI4.1 SP4 in order to test for IE 11 compatibility

Scheduled weekly automated therapeutic restarts of SIA and Tomcat services

Scripted and Scheduled preventative and informative checks on system

Created User groups and defined different access levels for Universe, Crystal reports, Web Intelligence and Xcelsius Dashboards

Created Universe from scratch and Web Intelligence reports to support Xcelsius dashboard using Live Office

Created Xcelsius Dashboards for Marketing online clients assigning user lever securities at Universe

Performance tuning on Existing dashboards and skimmed down the Live Office connection to improve dashboard performance

Provided feasibility and gap analysis for upgrading BO XI R3 to BO XI R4 version and gave recommendations

Implemented Row level restriction for managers profiles using designer. Resolved tickets to support production environment, modified and tweaked report content and distributed reports in multiple formats such as Excel and PDF.

Worked with Crystal Report 2008/XI for creating complex reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports and analysis reports.

Developed Graphic Reports, Pie charts for the statistical representation of the data. Tested the Web Intelligence reports in System Integration and Testing (SIT) environment and Performance Testing (Staging) environment to validate performance of all the reports, which helped in analyzing its performance before moving into production environment.

Environment: BI 4.1, Business Objects XI R2, BO 3.0, 3.1 Business Objects Universe Designer, Business Objects XI,3.1, Web Intelligence Rich Client 3.1, Dashboard Manager, Xcelsius, Business Objects Information Design Tool (IDT), J2EE, BI Portal, Oracle 10g, 11g,Teradata 13.0, SQL Server 2000/ 2005/ 2008, Manual QA Testing and front end application Testing.

Accident Fund Insurance Company of America Jan’11 – Feb 2012

Lansing, MI

Sr. BI Platform Consultant

Accident Fund Insurance Company of America is a workers' compensation insurance company. The company is an operating unit of Accident Fund Holdings, the 10th largest writer of workers compensation insurance in the United States according to A.M. This project involved migrating existing BI applications from BOXI R2 to BOXI R3.1 and administering and development of BO.

Responsibilities:

Designed and implemented Business Objects architecture, including hardware and software requirements, CMS information, security, and migration from XIR2 to XIR3.1

Setup and initial configuration of XI R3 on Windows platform using Oracle11g as the repository database.

Used the import wizard to import existing user accounts, groups, categories, Webi documents, universes, connections and universe restrictions to BOXI R3 environment.

Involved in Conversion of Deski reports to Webi reports using Report Conversion Tool.

Performed Administrative tasks like Setting up user profiles, assigning rights and privileges for groups, setting up categories using CMC, and maintain Bo servers

Built of a new security model with the BOE environment to support the Accident Fund real time and historical dashboards.

Modified existing client analyst universes and created new universes as per the business requirements using @Aggregate Awareness, @prompt and @BOUSER functions

Developed real time and historical dashboards within Xcelsius 2008 utilizing Query As A Web Service and Live Office.

Scheduling of the report on successful event and save on specific servers using FTP/File System Configuration in Business Objects XI 3.1.

Promotion of Universes, Reports, Users, Groups, User Rights and Privileges from different environments Dev, QA, UAT and Production.

Created Standard WebI reports with client customizations and formatting to serve as templates for the canned and ad hoc reporting.

Documented all the changes made to the Universes and Reports for future references.

Environment: Business Objects XI 3.1/R2,SQL, Oracle 11g, Sybase, Web Intelligence, Crystal Reports, Import Wizard, Xcelcius 2008, QAaWS, Live Office, .Net, Web services, Apache Tomcat, SQL Developer, Windows 2008, Weblogic 5.1/6.1, Shell scripting,

Fannie Mae, Nov’08 – Dec’10

Herndon, VA

Sr. SAP Business Objects Administrator/Developer

Fannie Mae (Federal National Mortgage Association), works to ensure that mortgage money, is available for people in communities all across America. This project involved administering and developing reports for different business groups in Fannie Mae’s Multifamily/HCD portfolio Data Warehouse.

Responsibilities:

Responsible for Administration, development and troubleshooting of different agency reports through Business Objects XI R2/3.1 and development of dashboards through Crystal Xcelcius.

Migrated Business Objects XI R2 content in to Business Objects XI R3 environment using the Import Wizard.

Managed all the BO Servers and Clusters through CCM and CMC.

Installed & Configured BO Enterprise XI R2 SP2 on Windows 2003 server.

Resolved slow down issues and improved the performance of production servers.

Responsible for the administration of transactional and analytical data constructs/structures.

Configured .war files on BOXI server to receive authentication.

Responsible for the design and development of Business Objects Crystal Reports & Business views, Universes and analytical data constructs/structures.

Created access Restrictions to secure data based on users’ access levels.

Prepared Business/Technical Requirements, Design Templates, Development Standards document and Detailed Design documents.

Created various Reports by pulling the OLAP data from Data Warehouse of SAP BI 7.0

Designed and developed Universes and reports according to the user requirements.

Created hyperlink reports using open doc functionality.

Migration of Canned Reports/Universe/Personal Documents/Inbox.

Created Analytics and Dashboards using Performance Management tools to enable executives get a bird’s eye view of the business performance.

Accessing data from the database using SQL Developer (running on Oracle 10g) to cross check the data accuracy and creating reports on the same if needed by the business.

Implemented and conducted training session to train Power Users/Managers in BO functionality and to use the reports in Web Intelligence.

Documented all the changes made to the Universes and Reports for future references.

Environment: Business Objects XI 3.1/R2/6.5, Crystal Reports XI, SQL, Oracle 9i/10G, Sybase, Windows 2003 Server, Web Intelligence, Xcelcius, SAP BI 7.0, SAP BEX Query Designer, SAP BEX Report Designer, CVS, Apache Tomcat, SQL Developer, Sun Solaris (UNIX), Weblogic 5.1/6.1, Shell scripting, Clear Quest.

CGI,

Tallahassee, FL Jan’07 - Nov’08

Sr. Business Objects Administrator/Developer

Working on Statewide Automated Child Welfare Information System (SACWIS) for the Florida Department of Children and Families (DCF) developing the Florida Safe Families Network (FSFN) BOE.

Responsibilities:

Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Created Publications based on Agency and District and distributed to the Users.

Created Events and Calendars for scheduling purpose using CMC.

Managed all the BO Servers and Clusters through CCM and CMC.

Migrated the CMS database from DB2 to oracle

Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.

Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.

Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.

Applied rights and privileges to users/groups, folders and categories, using CMC.

Created Cascading LOVs, Hierarchies and Filters.

Developed universe user documentation guide for the end users reference.

Deployed and scheduled reports through CMC.

Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.

Created Auditor reports and tracked user access of reports and Universes.

Worked with Crystal Report XIR2 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.

Experience in handling development team onside or offshore.

Provided training for end users for generating their own report including complicated WebI reports.

Environment: Business Objects XI r2, Crystal Report XIR2, CMC, Import Wizard, Conversion Tool, Web-Intelligence, Desktop-Intelligence, Designer, Info View, Data Integrator, Tomcat, DB2v8.1, Oracle 10g, SQL, Windows 2000/XP.

Fannie Mae, Mar’06 – Dec’06

Dallas, TX

Sr. Business Objects Developer

Fannie Mae (Federal National Mortgage Association) is a shareholder-owned company and a part of the US Housing Industry that works to ensure that mortgage money is available for people in communities all across America. The public mission and the defining goal of the company are to help more families achieve the American Dream of homeownership. This project was about developing various reports for different business groups for the NPDC (National Property Disposition Center) in Fannie Mae.

Responsibilities:

Involved in the Migration of the UAT and Production Environments from Business Objects 6.5 to Business Objects XI R2 for the Federal National Mortgage Association Fannie Mae.

The migration included:

Design of an architecture to support full-lifecycle development of universes and reports,

Setup and initial configuration of XI R2 on Windows 2003 using Oracle10g as the repository database.

Migration of content from the 6.5 system to XI R2 using the Import Wizard.

Conversion of desktop Intelligence documents to Web Intelligence documents using the Report Conversion Tool.

Integration of XI R2 with Windows Active Directory for authentication.

Mapping of the 6.5 security requirements to the XI R2 security model.

Provided assistance to users regarding reporting issues and help them to better understand the requirements.

Designed the report template and applied new templates to existing reports in various formats like cross tabs, master-detail, charts and breaks.

Built and modified different canned reports like workflow, exception and performance reports.

Generated various reports with complex queries, formulae, variables and different in-built functions and calculation with contexts.

Define detail variables and linked different objects from different data providers and to resolve incompatibility to display without dropping cases in a block.

Improved readability in report by adjusting format such as, sorts, ranking and alerters.

Generated reports with Drill options to facilitate drilling and filtering on different hierarchies present in the universe.

Tested new and modified reports with different test cases and verified data against GUI application CLM for DARTS and TRAX) before sending report for user acceptance.

Gathered requirements with business analyst and direct interactions with business-users to understand their need and documented it to be sent for sign off by business users.

Rectified errors and faults in existing reports by cross checking the result objects used and also optimized them for faster execution. Submitted Problem Requests (PR) for enhancement changes required for universe and tested the PR modification in production environments.

Checking versions of different requirements and reports with the versioning tool CVS.

Environment: Business Objects XI R2/6.5, Desktop Intelligence, Web Intelligence, COBOL,

Credit Loss Management (CLM for DARTS, TRAX), Concurrent Versioning System (CVS)

Oracle10G, Sybase, Win XP

Innova Tech Inc. Sep’05 – Feb’06

Arlington, VA

Business Objects Developer

Project: US Patient & Trademark Office (USPTO)

Responsibilities:

Gathered information from business users.

As a Business Objects developer responsible for designing, developing and maintaining Repository in Oracle 9i database.

Migrated BO 6.5 to BOXIR2.

Created Business Objects groups, users and assigned privileges to their accounts

Created one or more document and universe domains in Repository and maintained throughout the assignment successfully.

Comprehensively Used Business objects Designer for Universe development- Involved creating Classes, different kind of objects, Cardinalities, Strategies.

Created derived tables to meet the reporting requirement.

Created user defined @prompts and complex conditions at Universe level for better performance.

Solved database loops, chasm, fan traps by using alias and context.

Used all types of methods in reporting technology to represent data on report like (filters, alerter, breaks, sorts, ranking, master/detail and Drill).

Recommended and implemented design changes to warehouse fact tables and indexes to improve query performance.

Generating Reports from different data providers using Business Objects.

Created Classes, Objects in universe for Oracle and using Business Objects 6.5 and exported to the repository.

Published Documents on the World Wide Web for access to authenticated users via Info View.

Categorized Documents based on the Departments & Users.

Creating Dashboard and Scorecards with Dashboard Manager.

Tuned the SQL using Explain Plan to increase performances of Reports.

Tested the Universes and Reports in different environments for the data representation and the performance issues.

Involved in training end users, business users and customers in creating, modifying and interpreting Bo reports and WebI reports.

Created indexes and analyzed tables for better performance.

Environment: Business Objects XIR2, 6.5, DB2,PL SQL, Web intelligence 6.5, BCA, Data Integrator, UNIX Scripting, SQL Server, MVS, JCL,Windows NT, and Windows XP

Triad Financials Corporation,

Huntington Beach, CA Aug’03 – Sep’05

Business Objects Developer

Triad Financial is an independent, wholly owned subsidiary of Ford Motor Credit. Triad focuses on non-prime lending for new and late model used automobile purchases. It primarily provides loans to borrowers through new and used car dealerships throughout the US. The project was concerned with building universe for Road Loans and producing various reports for marketing and sales.

Responsibilities:

Coordinated with the end users to gather their requirements and discussions with database and ETL personnel to come up with the project design.

Generated complex reports using Complex Queries, Sub Queries, Unions and Intersects.

Organized Charts, Master/Detail and Cross tab reports with Slice and Dice

Created report for Valuation, Growth, Profitability, ROI Ratio and other Financial Ratios.

Manipulated data in reports with breaks, sorts, ranking and alerts using both full client and Web Intelligence.

Published ad hoc and canned reports to corporate documents and scheduled via the Broadcast Agent Server and Publisher.

Built universes and set up parameters like Strategies, Controls, SQL and Links.

Defined cardinalities and set up equi-joins, theta-joins and outer-joins.

Detected loops and traps (chasm/fan) if any and resolved them with universe parameters, aliases and contexts.

Inspected the integrity of the Universe to resolve faults and errors.

Grouped objects into classes as per the end-user requirements.

Exported/imported universes to/from the repository.

Built Crystal Reports based on the business objects universes.

Managed users and set up privileges for universe and report access.

Provided Training to end users for ad hoc reporting.

Environment: Business Objects 5.1, Designer, Reporter, Web Intelligence 2.6, Supervisor,

Broadcast Agent, Crystal Reports 8.5, Oracle 8i, SQL Server, PL SQL, and Win NT

Indus Networks Limited, Aug’02 – July’03

Hyderabad, India

Business Objects Developer/Analyst

Environment: Business Objects 5.1.6, Designer, Reporter, Web Intelligence 2.6, Broadcast

Agent, Crystal Reports 8.0, Oracle 8.x, Erwin and Windows NT

Education

Bachelors of Engineering, India

Contact this candidate