SUMMARY:

• Having 12 Years of IT experience in Design, Development, Implementation and Testing using SAP Business Objects XI R2/R3, BOBI 4.0, 4.2. SAP HANA & SAP BODS 4.0, 4.2.
• SAP Business Objects certified professional with good knowledge on Business Objects administration
• Strong Knowledge in SQL and PL/SQL
• Experience working on Business Objects XI R2/R3,BI 4.1/4.2. Universe Design (Unv and Unx), Web Intelligence 4.1/4.2, SAP Lumina, SAP Design Studio, Report Conversion Tool, Crystal Reports 2008,2011,2013,2016. Dashboard Design and Xcelsius, Live Office, Query As a Web Service (QAWS)
• Expert in creating OpenDocument URL and Linking Web Intelligence Reports
• Experience in using input Controls,Element Linking in Web Intelligence Reports
• Specialized in creating Web Intelligence/Crystal/Analysis for OLAP reports using BEx queries, Oracle, SQL Server, SAP HANA, MS Access, local files and Analysis Views .
• Experience in creating Dashboards & Visualizations with various components like Column Chart, Stacked Chart, Bar Charts, Pie Chart, Label Based Menu, Combo Box, Grid, Ticker, Gauge, Maps etc.
• Experience in Creating publications and Scheduling Publications using Dynamic recipients
• Experience on CMC with creating Users, Groups, Access Levels, Security, Folders, Categories, and Connections etc. and Managing Services in a cluster environment.
• Experience in Migrating the Business Objects Reports from BO XI 3.x to BI 4.0, 4.2.
• Excellent Experience working on SAP HANA, Data Modelling (Attribute Views, Analytic Views and Calculation Views ), Data Provisioning (SLT, BODS, DXC and Flat files ), SQL Script - CE Functions and Stored Procedures.
• Benchmark application performance periodically and fix performance issues
• Adept in creating & testing end-to-end scenarios in SAP HANA, SAP BI/BW, SAP BO Tools, SAP Design Studio, SAP Lumira, Native HANA SQL Script
• Work with initiative leads, business areas, technical leads, architects, subject matter experts, developers, technical support groups and test teams to deliver value to the business
• Lead end to end solutions delivery of large scale reporting applications on SAP Business Intelligence
• Architect, Design and develop near real time Data Warehouses and BI solutions solutions
• Translate complex business requirements into scalable technical solutions meeting Data warehousing standards
• Provide subject matter expertise to support reporting needs for the multiple functional areas
• Experience in building Data Marts and Enterprise Data warehouse
• Strong in SDLC, Agile and waterfall models, Effort Estimates, Project Plan, Staffing
• Conduct Design and code reviews
• Strong experience in Project Management and Team Management

TECHNICAL SKILLS:

Database: Oracle, SQL Server 2008, SQL Server 2012 & SAP HANA

Languages: SQL, PL/SQL

SAP BO Tools: Web Intelligence, Crystal Reports 2011/2013/2016, Crystal Reports for Enterprise, SAP Business Objects Dashboards, SAP Design Studio, Information Design Tool, Universe Design Tool, SAP BO Explorer, Analysis for OLAP, Analysis for Office

Data Visualization Tools: SAP Lumira & Tableau

Data Modelling: SAP HANA SP 10 & SP11 Modelling & Dimensional Modelling

ETL & Data Provisioning: Informatica, SAP BODS, SLT, SDA & SDI

PROFESSIONAL EXPERIENCE:

Confidential, Torrance, CA

Senior SAP BOBJ/HANA/BODS Technical lead

Responsibilities:

• Having daily discussions, walkthroughs, and weekly meetings/conferences with onsite managers, clients regarding project requirements
• Gathering requirements for creating reports, based on the use cases provided by the end users.
• Gaining good knowledge on the Facets Modelling and understanding of each process areas like Claims, Providers, Subscribers/Members etc.
• Transforming the Use Cases to Functional and Technical requirements by documenting the requirements
• Providing the estimates and timelines for the development tasks
• Actively involved in Data Modelling and EDWH designing
• Created BODS Jobs/Workflows/Data flows to extract Data from Oracle Database to HANA and Oracle DWH
• Used Transformations like Query,Lookup,Table Comparision,Map Operation, History Preserving in the Data flows of the BODS Jobs
• Migrating the Jobs/Workflows/Data Flows from BODS 4.1 to 4.2
• Scheduling and Monitoring the Jobs using the Business Objects Administration Console
• Creating Global and Local parameters and variables at Job/Workflow/Dataflow levels
• Developing HANA Information Models such as Attribute Views, Analytic Views and Calculation Views on the HANA system.
• Creating Scripted Calculation views/Decision Tables in HANA
• Using Join,Union,Aggregate,Rank and Start Join Nodes in Calculation Views
• Performing Query optimization using the optimization techniques in SQL
• Designing Universes in Information Design Tool using Oracle as Source connection.
• Developing Complex Web Intelligence reports in BI 4.2 using Input controls, Element Linking, Open Document URL’s, and Calling Dashboards in Web Intelligence Reports.
• Developing Crystal reports with Drill Down functionality and using graphs like Line chart /Column Chart/Pie Chart
• Writing Custom SQL to create complex Web Intelligence and Crystal reports.
• Designed Dashboards for Kaiser and Anthem Products.
• Designing Analysis Applications in Design Studio 1.6 for the enrolments and submissions.
• Creating Information Space and Exploration view sets in the BI Explorer
• Scheduling the Index of Information Spaces to run on a Daily mode
• Used Different components in Design Studio like Dimension Filters, Filter Bar, Filter Pane, Chart Type Picker, Navigation Panel,Charts,Cross Tabs,Containers,Tabs etc.
• Used CSS coding and Java scripting in Design Studio to customize and format the Applications and to make them dynamic
• Migrating Universes,Reports and Dashboards from BI 4.1 to BI 4.2
• Created Visualizations on Lumira Discovery 2.0 for a POC in the project.
• Created and Implemented BI Applications/Dashboards and Visualization solutions utilizing SAP Design Studio, SAP Lumira, and SAP Web Intelligence Reports
• Creating new Web I Reports and Universes after Migrating the content to BI 4.2.
• Scheduling the Web Intelligence and Crystal Reports Weekly and Monthly
• Setting up Dynamic recipients in scheduling the reports
• Involved in project planning sessions with project managers, business analysts, ETL specialists and team members to analyse business
• Managing the off shore team and worked closely with onsite team to receive daily tasks

Confidential, TX

Senior SAP HANA & BW on HANA/Business Objects

Responsibilities:

• Created technical documents based on the functional requirements gathered.
• Interacting with the functional teams for any gaps in the functional specifications
• Leading the Offshore team in the development of HANA views and dashboards
• Designing calculation views using combination of SAP ECC data and data sourced from Smart Data Access (SDA)
• Performed Data Provisioning using SLT to load data from ECC to HANA
• Assistance to Business Analytics Team for feasibility, scoping and initiation of Projects
• Developed Native HANA Information Model - Calculation Views (Dimension, Cube with/without Star join) to define multidimensional data model using the Web IDE.
• Created restricted, calculated columns to derive from other columns and counter to count based on characteristics
• Created Packages to create information models and Schemas to store tables
• Worked on variables to filter data and Input parameters to convert Unit of measure and Currency
• Worked on decision tables using return value
• Creating ADSO, Open ODS views and Composite providers on top the HANA Calculation views and creating Bex Queries on the Composite Providers.
• Created Universes on HANA Views using the Information Design Tool
• Developed Complex Web Intelligence reports using Universe as a source
• Extensively worked in data analysis on Hana views to create Dashboards with SAP LUMIRA tool.
• Restricted data for particular users using Business Layer Security Profile and Data Foundation Security Profile
• Created Lumira Dashboards on Native HANA views/Bex Queries, using different types of Visualizations like Bar Chart, Line Chart, Pie Chart, Scatter Plot, Tree Map, Heat Map, Bubble chart and Geo Maps
• Different Lumira Story futures like Trend lines, Forecasting, Sets, Date comparisons.
• Creating and publishing stories in Lumira sever, Cloud and in BI Launchpad
• Created user training documents and trained end users in SAP Business Objects, Workspace and building ad hoc reports with Analysis which helps users in building their own queries, adding filters, generating reports, drilling down reports, creating charts performing business essential tasks
• Involved in technical and end-user testing of new reports, and dashboards considering the like to like functionality of the existing system

Confidential, Houston, TX

Senior SAP HANA/Business Objects Developer

Responsibilities:

• Responsible for gathering the functional specifications with respect to QM and Finance.
• Work with the business users in gathering the project specifications by conducting user requirements gathering sessions.
• Analysing the requirements and technical specifications by partnering with Business owners to develop the reports that confirm to the enterprise standards.
• Configured and managed Repositories using administrator console as per business requirements.
• Configured the mappings to handle the updates to preserve the existing records using History Preserve Transformation (Slowly Changing Dimensions Type-2)
• Worked on Dimension modelling as per business needs.
• Used various Transforms like: Map Operation, Table Comparisons, Row-Generation, History Preserving, Key Generation, Pivot, Reverse Pivot and Functions like lookup, index search for transforming data.
• Developing and modifying changes in data flows according to the business logic.
• Recovering Data from Failed sessions and Workflows.
• Most of the transforms used were like the Source Lookup, Case, Merge, & Sequence Generator, Query Transform, Map Operations, Table Comparison, SQL, and Validation Transforms
• Created mappings using BODS Designer and designed workflows using Workflows to build DW as per business rules. &analyse the types of business tools and transforms to be applied.
• Understand technical issues and identify architecture and code modifications needed to support changing user requirements for multiple Data Services jobs and application
• Developed Native HANA Information Models - Attribute, Analytic and Calculation Views(Dimension, Cube with/without Star join) to define multidimensional data model
• Created restricted, calculated columns to derive from other columns and counter to count based on characteristics
• Created Packages to create information models and Schemas to store tables
• Worked on variables to filter data and Input parameters to convert Unit of measure and Currency
• Worked on decision tables using return value
• Worked on Plan Visualization to check the performance and created partition on tables accordingly
• Created Universes using IDT on top of Native HANA calculation and analytical views and developed Web I reports and dashboards.
• Created Lumira Dashboards and stories on Native HANA views, using different types of Visualizations like Bar Chart, Line Chart, Pie Chart, Scatter Plot, Tree Map, Heat Map, Bubble chart and Geo Maps
• Developed Lumira Dashboards to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
• Created user training documents and trained end users in SAP Business Objects, Workspace and building ad hoc reports with Analysis which helps users in building their own queries, adding filters, generating reports, drilling down reports, creating charts performing business essential tasks
• Involved in technical and end-user testing of new reports, and dashboards considering the like to like functionality of the existing system.
• Involved in the process of User Acceptance Testing activities with Business Owners.

Confidential, Houston,TX

SAP HANA/BW/BOBJ Consultant

Responsibilities:

• Work with the business users in gathering the project specifications by conducting user requirements gathering sessions..
• Analysing the requirements and technical specifications by partnering with Business owners to develop the reports that conform to the enterprise standards.
• Developed Native HANA Information Model - Attribute, Analytic and Calculation Views(Dimension, Cube with/without Star join) to define multidimensional data model
• Created restricted, calculated columns to derive from other columns and counter to count based on characteristics
• Created Packages to create information models and Schemas to store tables
• Worked on variables to filter data and Input parameters to convert Unit of measure and Currency
• Worked on decision tables using return value
• Worked on Plan Visualization to check the performance and created partition on tables accordingly
• Remote system data is accessed using Smart Data Access
• Knowledge on replicating and loading data into SAP HANA from different data sources using Direct Extractor Connection (DXC)
• SAP tables are replicated into HANA system through SLT and monitored in SLT system
• Developed BODS jobs and scheduled them to fetch data from non-SAP systems to HANA system
• Developed Eclipse based Composite provider to consume data from Information models and BW targets
• Created Advanced DSO in Eclipse, loaded in BW system and consumed in HANA views
• Created ODP extractors in BW to extract HANA Views into BW system for reporting
• Created Analytic Index on HANA view and consumed in BW
• In BW 7.3 worked on Info-Objects, DSOs, BEx queries, Composite providers, Transformation logics, DTP, Info-package
• Developed BEx queries, Formula, Restricted key figure, Characteristic key figure, Variables, Attributes, Restrictions, Structure, Cell editor, Conditions, Exceptions
• Developed Web I Reports/Crystal Reports in BI 4.0/4.1 on top of BEx Queries
• Created Universes using IDT on top of HANA calculation and analytical views and developed Web I reports and dashboards.
• Created BEx queries for the Dashboards and RKFs & CKFs as per the requirement.
• Created user training documents and trained end users in SAP Business Objects, Workspace and building ad hoc reports with Analysis which helps users in building their own queries, adding filters, generating reports, drilling down reports, creating charts performing business essential tasks
• Perform Scheduling of the Crystal reports using the Dynamic Recipients in publications.
• Managing the instances of the Scheduled reports from CMC
• Involved in technical and end-user testing of new queries, reports, and dashboards considering the like to like functionality of the existing system.
• Involved in the process of User Acceptance Testing activities with Business Owners.
• Created Advanced Analysis Workbooks on BW Info provider and BEx queries.
• Design and develop Xcelsius dashboards on top of Bex queries using BICS connection.
• Designed and deployed Web Intelligence reports with Drill Down, Drill Through and and linked reports using Opendoc functionality
• Scheduled the reports to be emailed to end users daily in PDF/Excel formats in Info view.

Confidential, Houston,TX

SAP BOBJ Consultant

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs document for all the mappings.
• Worked on Informatica Power Center tool - Source Analyzer, Target designer, Mapping & Mapplet Designer and Transformation Designer.
• Resolved issues that cause the production jobs to fail by analyzing the ETL code and log files created by the failed jobs on the Informatica server.
• Used Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Worked on slowly changing dimension tables data.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Stored Procedure, dynamic Lookup and Router transformations for populating target oracle tables in efficient manner
• Tuning Informatica Mappings and Sessions for optimum performance
• Involved in enhancements to the existing Web Intelligence reports and Xcelsius dashboards.
• Managed the reporting team from Off-Shore.
• Extensively involved in Production support by monitoring SM7 ticket tracking tool.
• As a part of Major Enhancements, developed Universes Web Reports with Be Queries and Crystal Reports
• Performed baselining of the projects
• Played the role of Transition to Support Lead for the KT transfer from Development team to Support Team
• Review the Coding of the developers and provide the solutions as a Subject Matter Expert
• Reported the Project Metrics to the Senior management using internal tools
• Managed the Demand and Supply of the Project.
• Provide Project Review to the client in the Client Review Meetings on a weekly basis
• Designed Complex Xcelsius Dashboards using the SAP web Services.
• Played a key role in transitioning the support project from Manila to India.
• Helped the project by solving major incidents and reducing the count of incidents.
• Handled the tickets of all priorities and closed within the (SLA) Service level Agreement.
• Involved in Incident Management, Change Management and Problem Managements following ITIL process.
• Modified the existing universes by adding new classes and objects
• Performed reconciliation to verify the data in Web reports with SAP R/3 and SAP BW.
• Analyse Performance issue and provide the solutions.

Confidential, Minneapolis

Senior SAP BOBJ Developer

Responsibilities:

• Managed the team from offshore and co-ordinate with the client during the new requirements phase and UAT.
• Involved in Analysis, Development, Testing, and Maintenance and resolved problems during implementation.
• Designed crystal reports on top of Oracle database.
• Managed report migration across environments (Dev, QA, and Prod).
• Designed universes using Universe design tool
• Resolved Loops and Traps in the Universe Designing.
• Developed sub queries, used groups functions for aggregating data. Used joins to retrieve rows from multiple tables.
• Developed Crystal reports with drill down functionality. Created sub reports and linked them to the main reports.
• Created Master/Detail, Cross Tab and Chart templates using the Business Objects and Web Intelligence tools.
• Organized data in the Report Inserting Filters, Sorting, Ranking and highlighting data.
• Involved in preparation of Technical Design document.
• Developed complex queries using different data providers in the same report

Confidential

BOBJ Developer

Responsibilities:

• Modified the existing universes by adding new classes and objects.
• Used joins, aliases and contexts to resolve loops.
• Tested the integrity of the Universes and exported the Universes to Repository for making it available to users.
• Used Aggregate aware feature to improve the query performance
• Implemented Drill down and Drill Up features in reports.
• Used Sections, conditions, Alerts and Breaks.
• Organized data in the reports inserting Filters, Sorting, Ranking and highlighting data.
• Exported the universes to repository for making resources available to users.
• Creating schedules for the business objects reports.
• Rebooting the BO Servers as part of maintenance. Checking if all the servers are up and running.
• Created users and groups using CMC. Resolving the login issues for the users

Confidential

BOBJ Developer

Responsibilities:

• Design & document ETL Mappings according to the business requirement.
• Gathering the Requirements from client, preparing the Design documents for mappings.
• Extraction of data from various sources using Informatica.
• Developed mapplets, mappings using Designer, Created Command Tasks, E-mail Task, Sessions and Workflows using Workflow Manager.
• Transformations like Source Qualifier, Connected Lookup, Unconnected Lookup, Stored Procedure, Aggregator, Expression, Filter, Sequence Generator and Update Strategy are used in Mappings.
• Analysis on Fallout records (Rejected records).
• Developing mappings to load the data in slowly changing dimensions such as Type1 and Type 2 according to the requirements
• Created mapping parameters and Parameter file in particular root directory path.
• Prepared Unit test case (UTC's) document and Performed Unit Testing.
• Modified the existing universes by adding new classes and objects.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables and by using contexts and alias tables to remove cyclic dependencies.
• Setting up row level restrictions in the universes.
• Created predefined conditions, prompts and custom hierarchies in the process of building the universes.
• Setting up Scheduling of the Web Intelligence Reports and managing the instances of the reports.
• Customized the list of values (LOV’s), which helps the end users to select the values.
• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
• Used section, break, rank, Alerts, Filters, Sorts chart features in Web I document
• Installed & Configured Business Objects XI R2 Enterprise Suite of Products.
• Created users and groups using Central Management Console (CMC) and assigned privileges to different groups and users.
• Imported existing users, groups, categories, Web I documents, connections, universes and restrictions to BO XI R2 environment using Import Wizard.
• Created reports using Business Objects functionality like slice and dice, drill down, cross tab, master detail tables and formulas, etc.

Confidential, New Jersey

BOBJ Developer

Responsibilities:

• Created functional requirement specifications through end-user meetings and analysis of business requirement documents.
• Designed Universes using oracle database connection.
• Resolved Loops, traps and Integrity issues in the universes.
• Created standard full client reports, created canned and ad-hoc Reports Using Business objects user module.
• Used @functions like @select, @where, and @prompt function to create prompts, which helps the user to select the values dynamically.
• Monitored the Data Integrator Jobs run to fetch data into the data ware house.
• Created reports using Business Objects features like Slice/Dice, Drill Down, Cross tab etc.
• Formatted the reports as per the Users requirements using all the facilities in Business Objects, which allows the users to analyse the data.
• Applied row level and object level securities to different groups and users in the universe designer.