SUMMARY

• SAP Business Objects Developer wif over 7+ years of IT experience. Managed all phases of Software Development Life Cycle dat includes Requirements, Design, Development, Testing, Implementation and Support.
• Well versed in Business Objects XIR3/4.0/4.1 wif experience in Designer(Universe design tool(UDT) / Information Design tool(IDT)), Webi rich client, Query as a web service(QAAWS), Infoview, BI Launch pad, LCM, Import wizard, Crystal Reports for enterprise applications and other components of Business objects suit as well SAP Xcelsius(Dashboards).
• Extensive knowledge on Design Studio, Explorer and SAP Lumira, SAP BO BI Mobile.
• Experience in SQL/PLSQL and its use in SAP Business Objects.
• Experience in creating universes(IDT),visualizations(Lumira) and applications(Design studio) on HANA.
• Has a good knowledge on modeling using HANA studio dat involves creation of attribute, analytical and calculation views.
• Specialized in designing and building HANA based Universes (IDT), and Web Intelligence Reports.
• Experience in creating Xcelcius dashboards by using Query as a web service (QAAWS) links.
• Experience in migration of teh reports and universes using import wizard and LCM.
• Involved in creating OLAP Connection on Bex queries in CMC &IDT.
• Experience in converting universe from UNV to UNX.
• Expertise in using Business object client tools. Experienced wif OLAP functionalities.
• Worked on creating OLAP universe using BEX queries, multiprovider, info cubes(SAP BW (SAP BI 7.20) ) in SAP BO integrated environment for reporting application.
• Excellent data - analysis skills and ability to translate specifications into a working Universe/Report.
• Created Joins, classes, subclasses, objects, conditions, lov's and parameters, Contexts and Aliases for resolving traps/ Loops, custom hierarchies, cascading list of values, derived tables and checked teh Integrity of teh Universes.
• Implemented Index awareness and Confidential awareness, Confidential navigation functionalities in universe.
• Created complex objects using @ Confidential, @ Confidential, @ Confidential aware functions as per teh universe best practices.
• Used various data providers like universes, Bex queries, personal data providers, stored procedures for retrieving data and creating reports.
• Created Standard/Adhoc Reports utilizing all teh features on Web Intelligence like Optional Prompts, Functions, filters, Input controls, Sections,Breaks,Ranking, drill, scope of analysis, merge dimensions, calculation contexts, force merge, combined queries, hyper linkingand using report level variables etc.
• Created webi Intelligence reports using BICS connection.
• Published, distributed, and scheduled Webi Intelligence reports.
• Implemented Security Features like of Business Objects like Row Level and Object Level security in UDT and data security profile, business security profile using IDT.
• Created different supply chain management, HR and financial reports using web Intelligence and Crystal reports for enterprise applications.
• Experience in creating reports using Crystal reports for enterprise applications.
• Experience in testing teh informatica mappings, universe, reports and dashboards.
• Worked wif various Relational Databases like Teradata, Oracle 11g, Sqlserver 2005, sqlserver Management studio.
• Has a good knowledge on Informatica.
• Has work experience in using Informatica client tools-Designer, Repository Manager, Work flow Manager and Workflow Monitor.
• Experience Working wif MS Office Suite (Word, Excel and PowerPoint skills).
• Has work experience on other tools like rational quality manager, Clear Quest, Reqpro, JIRA, NSI ETL tool etc.
• Expertise in providing BI reporting solutions wif strong hands on experience in designing and developing Business Objects Reporting Applications.
• Involved and keen in Analysis of Business Requirements, Technical Designs, and development of teh Business objects projects
• Capable of understanding teh business environment and translate business requirements into technical solutions.
• Proven troubleshooting skills and committed follower of quality and process standards laid by teh company.
• Ability to understand underlying data sources, relationships.
• Quick learner wif ability to implement new concepts.
• Excellent communication skills and technical documentation skills.

TECHNICAL SKILLS

Business Intelligence tool: BO 4.1/4.0/XIR3- Webi rich client, Info view, Import wizard, QAAWS, DESKI, Universe design tool(UDT),Life Cycle Management tool(LCM),Launch pad, Information design tool(IDT), Dashboards, Explorer, Crystal reports for enterprise applications, SAP Xcelsius, Design Studio, SAP Lumira, BEx Query Designer.

Database: Teradata, Oracle 11g, Sql server 2005, sqlserver Management studio.

ETL tool: Informatica 9.1.0

Operating System: Windows, Unix

Languages: SQL, PL/SQL

Development Packages: MSOffice

Others: SAP HANA, Tableau, Rational quality manager (RQM), Clear Quest (CQ), Reqpro, JIRA, NSI ETL, FileZilla

PROFESSIONAL EXPERIENCE

Confidential

SAP Business Objects Consultant

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications for business object universes and reports
• Involved in creation of High level design document for new requirements.
• Analyzed requirement changes for enhancements and included them in existing HLD.
• Designed and documented Universe and Report Requirements Definition, Security strategies, and Report Distribution strategies
• Created relational and OLAP connections using Information design tool.
• Implemented universes using IDT.
• Created connections, data foundation and business layer in universe.
• Created Joins like equi-join, theta-join, outer join, short cut join, set join cardinalities in data foundation layer of universe.
• Created lov's based on query results, hierachy, static list, SQL expression and customer navigation path, parameters in business layer of universe.
• Applied Index awareness, set up Confidential awareness and implemented data security profile in teh universe.
• Converting Universes .UNV to .UNX and setting up Universe security in InformationDesignTool (IDT).
• Involved in creation of attribute views, analytical views, calculation views, calculated columns in attribute/ analytical views and attribute views wif hierarchies in HANA studio.
• Created a relational connection to SAP HANA.
• Created data foundation and business layer on HANA view/HANA tables.
• Created WEBI reports utilizing all teh features on Web Intelligence like Optional Prompts, Functions, filters, Input controls, Sections,Breaks,Ranking, drill, scope of analysis, merge dimensions, calculation contexts, force merge, combined queries, hyper linkingand using report level variables.
• Formatted Reports as per teh User requirements using extensively teh functionalities in Business Objects, which allows teh users to analyze teh data.
• Created graphical representation of reports such as Bar charts, Line charts as per teh user requirements.
• Publish, distribute and schedule Web Intelligence reports using BI Launch Pad.
• Used publication feature in WEBI to publish multiple reports to dynamic users.
• Involved in teh Performance tuning of teh reports both at teh Universe level and teh report level.
• Modified Universes and changed teh Web Intelligence reports as per teh requirement changes.
• Used Life cycle Management (LCM) tool for migrating reports from one environment to another environment.
• Created Design Studio application and deployed it on iphone by scanning teh QR code using iphone camera to open URL.
• Created design studio application using HANA as data source.
• Has used analytical, basic components like cross tab, charts, buttons, text box, check box, radio buttons etc and scripts to design teh application.
• Created hyperlinking and implemented teh script dat triggers multiple actions in teh application.
• Implemented visualizations using SAP Lumira.
• Acquired a data set from universe.
• Created visualizations and saved stories to Business Intelligence platform.
• Involved in Unit testing and System Integration Testing of Business Object reports, Visualizations and applications.
• Translated teh requirement changes into test scenarios/case.
• Responsible for identifying defects and logging them in Clear Quest (CQ).
• Creation of teh test plan, test execution report, plan requirements coverage document in RQM
• Uploading requirements in RQM from Reqpro
• Creation of test execution summary document (TESD).

Confidential

Senior SAP Business Objects Developer

Responsibilities:

• Interacted wif Business Users and Business Analysts to understand teh business requirements and converted Business requirements into technical specification documents.
• Responsible for creation of universe using Information design tool, reports using webi Intelligence and migration of reports, universes.
• Responsible for creation of servigistics oil and gas demand supply webi intelligence reports and universes using IDT and enhancing existing universes using UDT.
• Implemented universes using IDT.
• Created connections, data foundation and business layer in universe.
• Created Joins like equi-join, theta-join, outer join, short cut join, set join cardinalities in data foundation layer of universe.
• Created lov's based on query results, hierachy, static list, SQL expression and customer navigation path, parameters in business layer of universe.
• Applied Index awareness, set up Confidential awareness and implemented data security profile in teh universe.
• Modified existing universes by creating derived tables, adding new classes, objects, conditions, prompts etc
• Created WEBI reports utilizing all teh features on Web Intelligence like Optional Prompts, Functions, filters, Input controls, Sections,Breaks,Ranking, drill, scope of analysis, merge dimensions, calculation contexts, force merge, combined queries, hyper linkingand using report level variables.
• Used publication feature in WEBI to publish multiple reports to dynamic users.
• Involved in migration of teh BO reports, universes using Life cycle management tool (LCM).
• Responsible for taking universe backup for existing universes (BIAR) in production environment as part of weekly activity.
• Providing and revoking access to teh business objects users. Implemented security setup to authorize all teh users according to their level and privileges to halp them navigate to teh right folders.
• Run teh existing adhoc BO report once in a week for IDM reconciliation process to capture teh count of teh number of users who has actually requested for enabling and revoking BO access.
• Sending teh reconcilation file to IDM FTP server using FileZilla.
• Monitoring scheduled reports and sending teh daily report.
• Performed data quality check on a weekly basis to compare and check for teh right alignment of teh source and target table structure.
• Monitoring TSG ticketing tool everyday to keep track of teh requests, incidents, change requests.
• Responsible for creation of design and change requests if required.
• Worked on NSI ETL tool kit which is used to schedule teh jobs to load data to ODs, DWH and DM tables from teh source database tables.
• Monitoring Queues and troubleshooting in case of any issue wif loads.
• Resolving and closing teh incidents by analyzing teh pl/sql procedures which loads data to targets.
• Involved in troubleshooting issues at report and universe level and fixing those cases.
• Involved in analysing teh procedures for data fixes.

Confidential

SAP Business Objects Developer

Responsibilities:

• Collaborated wif Business users, business analyst and DBA's to understandexisting landscape.
• Gatheird and analyzed business requirements to fulfill reporting needs.
• Created new Business Objects users and User Groups using Business Objects Central Management console
• Extensively involved in teh development and enhancement of teh universe design using universe design tool (UDT) and Information design tool (IDT), reports (WEBI/Crystal) and creation of teh new reports.
• Generated reports using Crystal Reports functionality such as parameters, formula workshop, and alerts.
• Used teh advantages of Experts in Crystal Reports for Grouping, Sections, Selection and Sorting.
• Created webi reports wif multiple queries, custom SQL, using complex functions, merge dimensions at report level, drill and complex filters.
• Created custom hierarchies to aid in Drill-down analysis of Web Intelligence documents and built cascading prompts.
• Responsible for parameterization process of teh BO reports in oracle database to make them reflect in teh Confidential reporting portal.
• Responsible for adding teh report, category and parameter.
• Adding teh report details to teh BO PORTAL REPORT REP table and relevant category for teh report in central management console (CMC).
• Adding teh parameters or objects to teh BO PORTAL REPORT OBJECT ROB table.
• Creation of teh fix scripts for deployement of paremeterization code.
• Worked on optimizing report queries for efficient performance both at report level and query level.
• Scheduled and Broadcasted reports (Crystal and Webi) to individual recipients using BI Launch pad scheduling functionality.
• Responsible for scheduling teh daily, weekly and month end reports.
• Creation of JIRA ticket for assigning task to BO admin for deployment of teh reports, universes and fix scripts.
• Testing teh reports in teh reporting portal to make sure dat they are working wifout any issue and can be exported to required output formats.

Confidential

SAP Business Objects Developer

Responsibilities:

• Involved in teh compilation of requirement specification document and low level design document.
• Involved in identifying number of universes required for meeting teh requirements.
• Involved in designing universe on top of Lube Analyst (LA) reporting database.
• Involved in identifying tables and columns of source system dat are mapped to business terms in teh universe design.
• Created stored procedures in such way dat when triggered, it loads data into table and imported those tables to universe for some reports to simplify teh design of universe
• Created and views, materialized views and stored procedures in sql server.
• Created Universe using universe design tool based on SQL server tables
• Created customer count report to find teh number of customers and sites of customers per domain.
• Created Lubricant performance report to compare teh performance of different lubricants in specific application from different manufacturer and for a different model.
• Designed WEBI reports as per teh report specification using Universe(.unv) as data provider
• Resolved loops, Fan traps and chasm traps by defining context and alias tables in teh design of universe.
• Implemented row level restriction, Edit lov’s, custom hierarchies, cascading Confidential, Confidential awareness, Index awareness functionalities and created derived tables in Universe.
• Designed reports, created variables in teh report level.
• Applied report level formatting, sorting, ranking and implemented filters, breaks, sections, drill, scope of analysis, input controls, calculation contexts, force merge, combined queries, sub queries, merge dimensions as per teh requirement.
• Exported reports into various formats like excel, pdf etc for user
• Interacting wif users for customized and standard reports, gap analysis and associated solutions.
• Testing of report SQL’s and validating report data.
• Promoting reports from one environment to another using import wizard.
• Testing of reports in QA, UAT and production environment.

Confidential

SAP Business Objects/Crystal Reports Developer

Responsibilities:

• Responsible for teh development of NG USFP R&me corporate reporting.
• Involved in creation of functional and technical specification documents for reporting.
• Designed developed various WEBI/Crystal reports to fulfill department’s reporting needs leveraging Business Objects Business Intelligence Suite 4.0. Using BW as source system
• Designed universes using Universe Design Tool and Information design tool.
• Responsible for Development of different SCM, HR and financial reports using webi Intelligence and crystal reports.
• Headcount Summary, Month end/Quarter end and year end reports were developed using Web intelligence.
• Designed and developed various dashboards to analyze actual performance and variances based on Finance related BEX queries me.e. financial statements, Profit analysis etc
• Created webi reports on top of universes (.Unv/.unx) and Business Intelligence consumer services(BICS).
• Published Web reports to email recipients using CMC and BI Launch Pad
• Migration of teh universe and reports from one environment to another using Life Cycle Management tool.
• Performed Unit testing, System Integration testing, Defects Fixes raised during UAT
• Involved in promoting reports, Universes, connections from one environment to another environment using Life Cycle Management tool (LCM).
• Responsible for analyzing and fixing defects raised by user in PT and User acceptance testing.
• Worked on customizing and look and feelof Crystal and webi reports.
• Participated in Internal and external meetings and worked extensively wif team to deliver teh tasks on time.

Confidential

ETL developer

Responsibilities:

• Responsible for teh development of transmission data warehouse.
• Participated in all phases of development life-cycle wif extensive involvement in teh definition and design meetings, functional and technical walkthroughs.
• Extracted data from different sources of databases. Created staging area to cleanse teh data and validated teh data.
• Extracted data from a wide variety of Sources like Flat files, XML files, Relational Databases.
• Developed transformation logic to cleanse teh source data for inconsistencies in source to staging area mappings.
• Implemented teh code required for dimension and fact Initial and Incremental loading.
• Created different mappings, sessions, work lets and workflows. Worked on optimization of code and resolved issues during implementation.
• Used Source qualifier, Expression, Joiner, Lookup, Filter, Router, Sorter, Aggregator, Union, Router transformations to do necessary data calculations and manipulations according to teh business rules and loaded data into target systems
• Identified source attributes, tables as a part of data profiling and gave inputs for building logical and physical data model.
• Worked on compilation of low level design and source to target mapping.
• Troubleshoot loading failure cases, including database problems.
• Played a key role in building and unit testing transmission data warehouse.
• Extensively worked in writing SQL Queries for unit testing and involved in documenting teh test results.

Confidential, UK

SAP Business Objects developer

Responsibilities:

• Developed reports on existing data flow of BI as needed by teh business and fixed issues.
• Created universes on top of Bex queries.
• Created WEBI reports on top of teh universes based on bex queries.
• Worked on BEx Query Designer in designing queries using filters, calculated key figures, restricted key figures, Variables, Customer exits for various business requirements
• Responsible for Development of different SCM, HR and financial reports using webi Intelligence.
• Migrated code to Quality and production regions using import wizard.
• Validated data in teh report wif Bex query, Infoprovider, Multiprovider as well wif ECC.
• Created UTC’s, STC’S, RIG-A and RIG - P.
• scheduled reports to email recipients using CMC and Info view.
• Follow-up wif SAP support on teh failures and issues related to reports.
• Worked extensively on Business objects to understand teh limitations of Business objects when connected to a BI system through Integrator.
• Worked on compiling list of limitations when using Business Objects wif BI 7.0 and provided viable alternatives to said limitations.
• Analyzed and fixed all report level issues and ensured all servers are up and running.
• Created support and service brief and initial support maintenance technical documents which are required in support transition.

Confidential, UK

SAP Business objects/Dashboard developer

Responsibilities:

• Extracted, transformed and loaded data from source systems, flat files to warehouse.
• Installation of business object tools and Xcelcius 2008.
• Created universes on top of Warehouse and source systems wif high performance and feasibility for fetching real time data.
• Worked on Universe Designer, Web Intelligence and QAAWS.
• Developed Dashboards using Xcelsius 2008.
• Developed Xcelsius Dashboards on top of universes and used QAAWS connections in Xcelsius wif Refresh on Load option which enables pulling of Live Data from Universes on Demand from Database.
• Created QAAWS links and imported links, xmls to Xcelsius and mapped objects wif KPI’s.
• Extensively worked onSAPLive Office to create connections between WEBI and Xcelsius.
• Created dashboards dat includes key performance indicators related to contact center regulatory like average call taken, abandoned rate etc.
• Used Bar chart, Pie chart, Spread Sheet, Confidential selector, Column chart, List box, gauge, Combobox, slider Ticker etc
• Created TS, RIG-A, RIG-P and CR’s. Follow-up for teh CR approvals.
• Migration of connections, universes, QAAWS and dashboards to QA and Production regions.
• Been part of Unit testing, System testing and User acceptance testing.
• Creation of Utc’s and STc’s. Fixed issues in User acceptance testing raised by user proactively.