SUMMARY

• SAP BI Consultant with 9 Yrs. of extensive IT Experience in Data warehousing Decision Support Systems, which includes implementation of Business Applications by using Business Objects 4.1\ 4.0\XI R3\XI R2\BO 6.x, BODS 3.X, BODS 4.0, 4.1, BW 7.3 and SAP HANA SP9
• Experience in the design and implementation with SAP Business Objects BI Product Suite ( IDT, Web Intelligence, Dashboard, Analysis for Office, Explorer, Design studio and Crystal report for enterprise) by leading three SDLC project life cycle.
• Experience in client facing role for Business Analysts, identifying the needs and requirements of the System and involving in requirement study of the System and convert into Technical design, preparation of estimation effort plan, and solution design document with scope and gap analysis.
• Experience creating projects, performing data integration and platform transformations, and creating local & central repositories with SAP Business Objects Data Services system.
• Designed and Prepared High level and Detailed ETL Test case’s, Executed BODS ETL Test Case Scenarios
• Experience with lookup functions and all other BODS predefined Functions Hands on experience in Data Quality components of Business Objects Data Services
• Understand Debug, Break Points, Filters, Aggregation level within BODS to evaluate the data according to business requirements Understand creating Local and Global Variables, and Parameters with BODS Use various sources like .CSV files, RDBMS, SAP ECC/CRM to load the data using BODS to HANA DB target
• BODS knowledge of Table comparison, History preserving, Key generation, Validation, Merge, Case, Data transfer Date generation, Pivot, SQL Transforms Having experience importing and exporting the BODS project within different non - prod landscapes to PROD Design and implement ETL processes
• Checking for failed or cancelled jobs in Background Job Monitor. Loading any of the missing master data attributes/texts. Maintain work history of the loads and the errors.
• Expertise on HANA data modeling using Attribute View, Analytic View, and Calculation Views and SAP HANA Data provisioning technology including SAP LT Replication Server, Data Services.
• Worked on SAP HANA Security including User Management, Roles, and Privileges. Experience with SAP HANA Data Administration including managing schemas, data model objects, import/export content
• Modelling experience of building universes from Relational, OLAP system and ECC for Finance, SCM and OTC business users.
• Expertise on building Expense Analysis, Monthly Income, Balance sheet, Trail balance reports. For FINANCE user .Transport management, Warehouse management,, Material management reports. For SCM business users.
• Experienced on Migrating the Objects from BW on HANA and building the Transient provider and Composite provider for self-service BEX reports.
• Experienced in migration on Business object 3.1 to BO 4.0 with Upgrade management tool and handled the migration issues by coordinating with SAP support. Upgrade from BO 4.0 to Bo 4.1 testing activities and implementing across the landscape.
• Experience in Application Security in CMC Administration activities like, migration, creating and managing repositories, monitoring/granting, permissions and rights to users, user groups through Central Management Server, version Management for migrated reports, Row level Security and tracing the log. Well experienced with installation, configuration and environment set up.
• Work with vendors and internal team members to assure adherence to client development/process standards and to assist with issue resolution, testing, and customer care in the BI area
• Expertise on Domain knowledge in Finance, Banking and Manufacturing business. Good understanding of Income and Expenditure, Balance sheet, Cash flow, Department Cost, Project Cost
• Involved in QA Testing and Data validation Mechanism with business users. Strong database knowledge in Oracle and SQL server and ER/Dimensional Modelling.
• Demonstrated general understanding of key business strategies, providing the reporting solution
• Played the Production support lead by handling multiple offshore team from India and Philipines by trouble shooting the BI system issue and supporting dependency team.
• Experienced in the management of projects by assisting in establishing and following project timelines as well as ensuing that all project deliverables and milestones are completed on time in an efficient manner.
• Design BI training plans and lead training efforts for end users in self-services design tools and trained multiple Greenfield batches every year.

TECHNICAL SKILLS

ETL Tools: BODS

OLAP Tool: DESIGNER,BI LAUNCHPAD,CMC,DESIGN STUDIO,WEBI, EXPLORER,TRANSLATION MANAGEMENT TOOL,CTS+, Crystal Report, ANALYSIS, DASHBOARD, IDT,Upgrade management Tool, BW, BEX, HANA

Databases: Oracle 10\11g, SQL server

Language: SQL, PL/SQL, C

OS: Windows XP/NT4.0/95/98, UNIX.

PROFESSIONAL EXPERIENCE

Confidential

SAP Business Object Lead

Responsibilities:

• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
• Work with vendors and internal team members to assure adherence to client development/process standards and to assist with issue resolution, testing, and customer care in the BI area
• Extract the tables on complex requirement applying multiple transforms for CDC data in BODS to HANA using designer.
• BODS knowledge of Table comparison, History preserving, Key generation, Validation, Merge, Case, Data transfer Date generation, Pivot, SQL Transforms Having experience importing and exporting the BODS project within different non-prod landscapes to PROD Design and implement ETL processes, programs, scripts with try catch mechanism within BODS Compare the existing aggregation on Measures within HANA views
• Checking for failed or cancelled jobs in Background Job Monitor. Loading any of the missing master data attributes/texts. Maintain work history of the loads and the errors.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio
• Developed data models for the operations, PP, Expense analysis, Sales distribution, Order to Cash, Material Management business area.
• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Developed Webi reports and dashboards for different operations and finance KPI'S like Project planning, warehouse management, Material management, order tracking, Sales analysis.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Experience in creating universes using information design tool 4.0 and also connecting to multiple data sources such as INFOCUBE, MULTIPROVIDERS and BEX query for FIN, SCM and OTC business area.
• Developed WEBI reports on SAP BEX Queries using BICS in Webi Rich client.
• Created monthly and summary reports in WEBI 4.0 for the different domains like Finance, Sales, OTC, Marketing and SCM domains.
• Created Dynamic Dashboards using SAP BI data/ BEX Queries using Design Studio. Have Valuable Knowledge on Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.
• Assessment of Resources for multiple roles in business Objects skill From Onshore.
• Participate in the requirement gathering process with the business, SAP Technical group, and Project Management
• Create technical specifications from functional requirements through analysis of business processes and discussion with the business process owners
• Coordinate security requirements and user administration rights and user groups supporting various organization views with Basis Team
• Involved in the POC activities on SAP HANA for 6 months..
• Leading Philippines offshore team for production support activities.
• Experienced in implementing in SAP BO4.1 in sandbox and dev.
• Created the Storyboard, views and publish using on SAP LUMIRA report distribution on top of HANA.

Confidential

BI LEAD

Responsibilities:

• Experience in interaction with the Business Analysts, identifying the needs and requirements of the System and involving in requirement study of the System..
• BODS knowledge of Table comparison, History preserving, Key generation, Validation, Merge, Case, Data transfer Date generation, Pivot, SQL Transforms Having experience importing and exporting the BODS project within different non-prod landscapes to PROD Design
• Checking for failed or cancelled jobs in Background Job Monitor. Loading any of the missing master data attributes/texts. Maintain work history of the loads and the errors.
• Designed Universes using IDT with Multi source data sources and defined Connection layer such as Data Foundation Layer and Business Layer, published the universes..
• Used BI Launch Pad for scheduling different reports and for developing Web Intelligence documents.
• Created Ad-hoc reports using web intelligence 4.0 functionalities like Cross Tab, Master Detail, Slice & Dice and Drill Down for Loss, loss item, loss party, coverage, exposure and allocation.
• Prepared and Reviewed the FSD and TD for WEBI report requirement.
• Played As Report lead in the project for design and manage the development team in offshore
• Migrated Business Objects XI 3.0 content (users/user groups, Universes, reports) in to Business Objects XI 4.0 environment using the Upgrade Management tool.
• Handled 8 team members in Offshore and delivered the assignments.
• Good exposure with CISCO Finance and Order Management business area

Confidential

Business Object Principal Consultant

Responsibilities:

• Responsible for handling the design,build,testing and deployment process for Managed Care and Chargeback business area reporting stream
• Experienced with Business Object XI R3 universe designing, building Web Intelligence reports
• Involved in Unit Testing, System testing and Fixing UAT defects and preparing the technical documents, mapping documents & migration documents for Go-live
• Handled the Managed Care/Chargeback business area of Confidential business issues on daily basis
• Provide user support for Adhoc reports on some applications
• Worked on 24/7 support model on rotation basis for BO environment performance and customer issues.
• Handling the offshore team and trained the juniors in Business Objects XI R3.
• Worked in The Government Pricing Application development for creating the multiple price setting, running the Submission report, verifying the data loaded from rebate\Chargeback to GP on daily basis.
• Involvement in GP Cognos report system testing and UAT Testing activities.
• Prepared the SOP documents for production deployment process and monitored the dry run of Government pricing Reports during deployment.

Confidential

Responsibilities:

• Developed the security for users and groups using CMC.
• Developing and modifying reports using Web Intelligence in BO XI.
• Developed Universe in BO XI and migrate from DEV/UAT/PRODUCTION
• Lead test integrator for our Data Conversion project, in charge of the team of 2 developers.
• Prepared the Defects sheet while Testing and raised the Defects as Static or System issue Defect management Tool (JIRA) and Assigned to Developer group
• Retested all Defects and Scripts after the Issue solved.
• Involved in development of crystal reports from universes.

Confidential

Responsibilities:

• New project On boarding.
• Daily Checkout (Refreshing & Scheduling), Weekly Checkout of all DEV,UAT & PROD environments, EERS feed run.
• Support the user’s issue in DEV/UAT/PROD Environments.
• Created Universe connection, assigning rights to connection at UNIX server.
• Report migration & Universe migration.
• Created VC for Requests for PROD & COB environments (Infoman) & a Taskman ticket. The Virtual Change Approval Class for the Business Objects STE Support team is SBBOSTEM.
• Familiarity with CitGroup financial system PEARL..
• Thorough knowledge of commonly-used concepts, practices, and procedures within the banking and credit risk system

Confidential

Responsibilities:

• Understanding of Existing Reporting System
• Prepared TSD, peer review of TSD and developed the report in BOXI R2 using WEBI
• Prepare the unit test cases for BO 4.1 & BOXI R2 reports.
• Prepare the IUT for BO 4.1 & BOXI R2 by File comparing method.
• UAT testing with Business users and data validation.
• Deployment of the reports into production environments.