SUMMARY

• Accomplished Senior IT professional with proven 13 years of experience in Business Intelligence (BOBJ/BODS) with SAP platforms (BW & HANA) and Non SAP platforms (Oracle, SQL Server & Teradata)
• Worked in End - To-End implementations with strong understanding ofData warehouse concepts Star Schema, Snowflake Schemas and Multi-Dimensional Models
• Expertise in BusinessObjects reporting and dashboard and integration with BW/HANA, Oracle, SQL Server, Teradata; along with good hands on experience on BusinessObjects Data Service (BODS)
• Expertise in Dashboard development in Xcelcius/ Dashboard Designer/ Design Studio and niche tolls like Lumira and Analysis for MS Office
• Excellent knowledge of full integrated Infrastructure/landscape/system environments along with in depth knowledge of Database/ETL concepts
• Expertise in requirement gathering and business understanding in Domains like Sales & Distribution, Warehouse and Forecast to Schedule.
• Good working experience in industries like Manufacturing, Healthcare, Logistics and Banking

TECHNICAL SKILLS

Tools: Business Objects 4.1, 4.0, XI r3, r2, r1, 6.5, …; CMC; Web Intelligence 4.x, XI, 6.5, …; UD/IDT; Query Builder, Crystal Reports 2011, XI, 8.5; Xcelsius Dashboard 2008 / Dashboard Designer; Design Studio 1.6 SP1 Patch 1 (Version: 16.1.1); Office Analysis for Microsoft Excel/OLAP, SAP NetWeaver BW 7.0/7.1/…7.4/ HANA Studio 2.1.15, BEx Query Designer; TERADATA SQL Assistant, Toad

ETL Tool: BusinessObjects Data Services BODS 4.0/4.2

Languages: PL/SQL; SQL; Transact-SQL; CSS

Databases: HANA DB 1.0 ; Oracle 9I, 8I, 7; Teradata; MySQL; MS Access; SQL Server 2008, 2005, 2000, 7.0, 6.5

Operating Systems: Windows Server 2008/2003/7/Vista/XP/2000/NT/98/95/NT

Industries: Manufacturing, Retail, Health Care, Banking & Finance, Logistics, Commodities, Insurance and Telecommunications

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

SAP Business Objects Architect

Responsibilities:

• Worked in installations/ system validation of HANA-BOBJ-BODS
• Created Functional specification documents while requirement gathering from different capabilities like OTC, RTR, FTS, MTD and ANA
• Created Technical Specification Document while and after development of deliverable Objects
• Created Decision tree document on Reporting & Analytics Tools integrated to HANA/BW to help deciding connectivity & usage depending on used cases and scenarios
• Helped SAP BW/HANA - BOBJ Security team to establish BI security for accessing reports by Employees and external distributors on SAP Enterprise Portal as well as BI Launchpad
• Delivered Ad hoc Universes/ Webi Reports/ Dashboards on top of BW DSOs, Info cubes, HANA Calc Views to various capabilities like Order to Cash, Forecast to Schedule, Production/ Supply planning, Transportation management, Distributor/inventory and order
• Expertise in designing and building universes (relational and OLAP)
• Understanding of Extractors, Complex transformations, DSOs, Infobjects, InfoProviders, Infocubes, MultiCubes, MultiProviders, Bex, BODS, Webis, Universes, Design Studio, Prompts and data manipulation from multiple sources and within BusinessObjects.
• Created Webi reports on BW DSO/Multi providers using BICS connectivity and getting OLAP Hierarchies (expand/collapse functionality), Restricted Key Figure type functionality
• Expertise in Business Warehouse (SAP BW)/ Business Intelligence (BI) concepts - data modeling, EDW, ETL tools, Bex Queries.
• Created Analysis for MS Office workbooks and used powerful excel formulas/ alerts on BW DSOs and Multi providers and scheduled them for daily
• Delivered complex Crystal report on Package Data Sheet
• Used various IDT functions and concepts like @Aggregate Aware, aggregate navigation, Query Parameters
• Provided strength to Confidential Brewery Team by providing complex Webi reports like Brewing Schedule, Weekly packaging schedule, Long term Material Plan by Supplier
• Used Query Builder for querying BOBJ Repository to find answers which cannot be possible by Audit Universe
• Expertise in backup, versioning and recovery related BOBJ administration tasks
• Successfully created BODS Jobs on ETL data from Teradata to HANA DB using BODS
• Created projects, batch jobs, Real time jobs, work flows and data flows in BODS
• Tested data flows and scripts against sample data and real data.
• Experience using,SQL*PLUS, SQL*Loader, TOAD, DTS packages, PL/SQL
• Successfully created User Groups and mapped those with HANA roles and established user/folder based security
• Used CTS+ and Promotion management in CMC for transporting BOBJ objects from one to other environment
• Successfully provided training to team members/users/ client’s solution designers
• Used HANA enterprise Time Table to resolve many issues with data coming from BW as empty values
• Performance tuning/Troubleshooting HANA DB for BOBJ reports and dashboards
• Using Smart measures (delegated Sums) in IDT for various requirements of rolling up values
• Created stories for Sales and retail department in Lumira on HANA, excel. Used Geo Map, various Chart components. Connected Lumira to HANA
• Completed POC on Design Studio 1.3 on BW data source. Created multi component interactive HANA/BW connected dashboard in Design Studio 1.6 contains cascading drop downs, various charts, one geo map, drop, filter panels. Used multiple data sources from same HANA Calc View.
• Created and supported BEx Queries and Design Studio DashBoards in SAP BW Data Warehouse based on reporting requirements

Environment: SAP BusinessObjects 4.1 SP2, SAP HANA Studio 2.1.15, SAP BODS 4.2 SP2, SAP BW7.3/7.4, BEx queries, CMC Administration, IDT, Design Studio, BI LaunchPad, Lumira, Version management/Promotion Management

Confidential

SAP Business Objects Lead

Responsibilities:

• Successfully delivered & supported Universes/ Reports/ Dashboards
• Supported BOBJ Administration activities which includes webi server, adaptive processing server, job server monitoring/tuning, Scheduling strategy/implementation, transportation strategy/ implementation, user and group creation in CMC
• Created Ad Hoc Universes for Retail Banking, Consumer Lending, Mortgage, Deposits, Credit cards, Customer Product, Dashboards Using QWAAS and optimized performance at Universe and Query level.
• Extensive discussions with Business and Power users, to determine the Business needs and other issues
• Configured SMTP in Destination server to get scheduled instances delivered via email to business users in CMC
• Solved issues in Web Intelligence server, Adaptive Job Servers, Aliasing, Transports, Tomcat server
• Created/ Supported 350 + jobs, set email alerts for success and failure for every job chain in CMC
• Provided support on Webi reports, universes and Dashboards on BW 7.1 Info providers/ BEx queries
• Provided Report Scheduling/Bursting support using CMC Administration
• Business requirement gathering on KPIs and design of Xcelsius dashboards
• Implemented cascading prompt based drop downs in Xcelsius dashboard
• Designed and developed various components like Accordion menu, Slider, Different charts and scorecards
• Created Repositories, Users & assigned the security in the Multi-Team Environment.
• Worked in theBODS4.0Environment, the entire project implementation was on 4.0
• Worked on the BW open Hub tables to extract the data from the BW.
• Extracted Data from all the Relational Databases including oracle, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.

Environment: SAP BusinessObjects 4.0, SAP BW 7.1, CMC Administration, Information Design Tool IDT, WebI, Info view, Dashboard, Crystal reports, BODS 4.0

Confidential

Senior Consultant/Developer

Responsibilities:

• Migrated 1500+ Crystal, Webi reports, Universes, 60+ Dashboards and BOBJ applications along with their data sources.
• Administrated six servers for 3.1 environment and three servers for XIR2 environment.
• Enabled SAP authentications with Kerberos along with enterprise aliases for 3.1 and created aliases script for password same as user id for enterprises aliases.
• Installed and configured BOXI3.1 and updated it to SP4.
• Updated webs XML, aliases, add scripts, Tomcat, HTTP Scripts as per the requirements.
• Added Microsoft plug-in and java plug-in for 3.1 Environment.
• Configured SMTP, destination job servers, crystal reports servers, web intelligence servers, RAS, Adaptive job servers, CMS servers in 3.1 development and Production environments. Added commands and parameters in the server command line.
• Extensively used CMC for administration task like folder / user security and authentication between BW and BOBJ
• Cloned WEBI servers, Crystal reports servers and Cache servers to enhance the performance in 3.1 environments.
• Customized 3.1 Infoview portals and created DSN for 32 bit and 64 bit OS.
• Developed technical documents and scripts for Migration Plan.
• Extensively used Import wizard for transporting objects and folders to new environment.
• Migrated Personal content, report instances and personal categories for 9600+ users.
• Migrated Xcelsius dashboards and deployed QWAAS to the new servers and fixed the hyperlinks and excel spread sheet to be compatible in new environment.
• Used Query builder to query Repository and to recognize number of groups, users, active users, frequent users.
• Enabled auditors for XIR2 and XI3.1 and created auditing reports.
• Developed testing scripts and test cases. Extensively tested BOBJ reports, dashboards and other BOBJ Applications in new environment.
• Troubleshoot errors for reports, universes and dashboards. Fixed them to work as per the business needs.
• Understanding of Extractors, Complex transformations, DSOs, Infobjects, InfoProviders, Infocubes, MultiCubes, MultiProviders, Bex, BODS, Webis, Universes, Design Studio, Prompts and data manipulation from multiple sources and within BusinessObjects.
• Designed and developed BEx queries and created Web intelligence reports with utilization of BEx query properties of restricted and calculated key figures and hierarchy variables

Environment: SAP BusinessObjects 3.1/XI R2, SAP BW7.0, CMC, Info View

Confidential

Senior Consultant/Developer

Responsibilities:

• Gathered requirement on Sales Dashboard Views i.e. Customer Tab, Overview Tab, Sales Volume Tab
• Design Multi Tab view based dashboard with dynamic data retrieval for enhanced performance
• Used Live office connectivity, web intelligence reports, query as web service to achieve scheduled and direct retrieval based dashboard tabs
• Designed and created What - if analysis in dashboard
• Utilized formulas like v-lookup, h-look up, index and calculation/functions of Excel sheet to provide complex functionality in dashboard components
• Implemented cascading prompt based drop downs in Xcelsius dashboard
• Implemented maps of Asia-Pacific region and provide geo-drill down
• Used line chart, waterfall chart, histogram, radar chart, interconnected click facility, navigation through one to another component
• Designed and developed various components like Accordion menu, Slider, Different charts and scorecards
• Assisted team to integrate SAP Enterprise Portal with SAP BW and BO to publish Dashboards on Portal using KM.
• For supporting Dashboards ; created web data provider reports along with scheduling them in CMC

Environment: SAP BusinessObjects 3.1, Xcelsius Dashboard 2008, SAP BW 7.0

Confidential

Consultant/Developer

Responsibilities:

• Assisted IT team in the installation of BusinessObjects Enterprise XI 3.1 on AIX 5.3 and Integration with SAP
• During installation raised OSS message to SAP and resolved issues related to SAP-BO environment and RFC
• Understood the current Architecture, data sources as Info cubes from SAP BW.
• Interacted with the Business Users to analyze the business process and gathered the requirements for desired dashboards which are 20 in number. Used Xcelsius and Live office combination.
• Used SWF Loader for integration purpose, dealt many issues related to Clive office connectivity and Performance
• Designed and created user security in CMC Administration
• Worked on different options to refresh the data of dashboard components as per user requirement
• Worked on OLAP Universes based on SAP BW Data sources and designed summarized dashboards
• Implemented the Dashboards and Reports in the integrated environment of SAP and BO using Xcelsius.
• Understanding of Extractors, Complex transformations, DSOs, Infobjects, InfoProviders, Infocubes, MultiCubes, MultiProviders, Bex, BODS, Webis, Universes, Design Studio, Prompts and data manipulation from multiple sources and within BusinessObjects.

Environment: SAP BusinessObjects 3.1, SAP BW, Xcelsius 2008, InfoView, Webi, Dashboard, Designer, CMC Administration

Confidential, Lexington, KY

Consultant

Responsibilities:

• Gathered, analyzed the requirement and build specification/ strategy documents.
• Created universes, reports using Business Objects functionalities like queries, Slice & Dice, Drill Down, Cross Tab, Master/Detail and Formulas etc.
• Resolved many issues in universe/ reports related to looping, cardinality, data, aggregation, summation and projection
• Worked on many features of BOBJ like Drilling, Charting, cross tabs, report linking, open doc, aggregate awareness, merging, derived tables
• Conducted end user training for basic and advanced reporting skills.
• Trouble shooting and Performance tuning of the reports and Universe.
• Used Info view for scheduling the reports, monitored and leaded the onshore team.
• Installed the SAP integration Kit and performed ETL on Oracle sources and SAP sources data on SAP authentications.
• Configured and enhanced the security of universes, Row level security, and provided privileges and rights to different users
• Report bursting, User Security, profile creation using CMC

Environment: Oracle 10g, SAP BusinessObjects 3.1, QC, Info view, MS Office, Lotus notes, Windows XP, WEBI, Service manager 7, BODS 3.1, CMC

Confidential

Consultant

Responsibilities:

• Played key role in documentation of HLD, LLD, Unit Test Plans to universe Creation and report making.
• Distribution of Work, preparation of status sheets, work flow sheets, Estimation of deliverables and knowledge transfer to team members
• Developed complex universes by using features like derived tables, aggregate awareness, conditions and hierarchies, linking of multi universe
• Used powerful business objects functionality's like @functions, Variables, user response and formulae.
• Used CMC for administration of servers, report scheduling, user security
• Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements
• Effectively documented the differences between the BOXIR2 and BO3.0 for developers and end user reference.
• Effectively prepared and customized the training documents, White papers, Best Practices, Template documents.
• Efficiently trained both the developers and business users with limited or zero experience using Business Objects XI R2

Environment: SAP BusinessObjects XIR2, SQL Server 2008, CMC, WebI, Universe Designer, Crystal Reports

Confidential, Saint Paul, MN

Consultant

Responsibilities:

• Worked on Reports Rationalization of 120 reports based on functionality, usability.
• Installed & configured Business Objects development, production environment and DR environments.
• Report Bursting, e-mail configuration, File server config, report scheduling, transports using CMC
• Built an exceedingly complex universe that encompasses different subject areas like Assets, Transactions, and Performance.
• Built the security model that includes defining customs access levels and was responsible for administration using CMC and CCM.
• Performed report bursting for group user using Business objects CMC.
• Built around 28 highly personified and cooperate reports using Web Intelligence and many full client reports across subject areas along with 3 Dashboards using Xcelsius 2008.
• Installed Integration Kit and made local gateways for integration purposes.
• Utilized Aggregate Awareness Functionality that included at least 12 aggregate tables with high volume fact tables.
• Used various transformations like Map Operation, Table Comparison, Row-Generation, Query History Generation, Key Generation, Pivot and Query.
• Resolving join problems in universe and optimizing the universe and Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Performed Business Objects like Slice and Dice, Drill Down, Drill Through, @Functions and formulas.
• Used QAAWS for pulling information from the universe and developing Dashboards.
• Performed tuning of data both at ETL level and DB level, optimized the disk space, eliminated the null values and updated data in the tables at database level.
• Supported/ Administrated 200 users that included 10 power users in the first phase of the project.
• Configured the security setting on universe levels and worked on enhancing the performance and tuning of universes.
• Developed complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Implemented backup and recovery for reports and universes in legacy system before importing to new environment.

Environment: Business Objects Enterprise XI R2, CMC/CCM Administration, BO Designer, TOAD, Web intelligence, crystal reports, QWAAS, Xcelsius Dashboard 2008, Bex Analyzer/ Explorer, Windows XP/2008, Windows XP/2008, Informatica 8.1, Visio, BODI 6.5,Oracle 10g,PL/SQL,SAP BW 7.0

Confidential

Business Objects Developer

Responsibilities:

• Developed and designed POC for implementation of BI.
• Preformed Scheduling reports, creating user groups like Administration activities using CMC/CCM
• Played an architectural role, in establishing user access and system set up in various environments (Clustered Network).
• Involved in database development by creating PL/SQL functions, procedures, triggers, and packages and materialized views.
• Worked as an Application developer in designing Universes and Web I (XIR2) Reports.
• Involved in setting up of folders, groups, LDAP security, Object Migration and Performance tuning.
• Implemented new XI R3 - Oracle Server based environment and transferred data from SQL Server sources and loaded it to the Oracle targets.
• Implemented SQL stored procedures for performance intensive reports, which also requires constant scheduling.
• Created multiple universes to support as hoc reporting environment and implemented Crystal Xcelsius 4.5 as the dash boarding tools, created links to flash files from the Web content.
• Introduced BO voyager for report development using cubes and used clear case and PVCS for versioning for the reports.
• Developed complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Leaded offshore team of 4 people for report design and development of SP's and reports.
• Planned, Designed and scheduling the training power users on Ad - hoc reporting.
• Implemented and created a plan for XI R2 migration from 6.5.

Environment: Business Objects XI R2/6.5, CMC Administration, Web Intelligence, BO Voyager, Broad cast agent, Crystal Reports 11.5, Business Views, QAAWS, Windows XP, PVCS, Oracle discoverer, Oracle 9i,SQL Server 2005, Oracle warehouse Builder