We provide IT Staff Augmentation Services!

Sap Bi Developer Resume

Voorhees, Nj

PROFESSIONAL SUMMARY

  • 9+years’ experience in BO 4.0, BusinessObjects XI3.1/R2, IDT, BEx, SAP BW, Universe Design, WebI & Crystal Reports, Dashboard Design, Data Modeling and ETL
  • Full life cycle software development, Business Objects administration, design and implementation with focus on Data Warehousing, SAP BI, Defining Security Roles and Database Applications.
  • Implemented BO security and Row level security, created groups, folders and categories.
  • Extensively worked on Business Objects Universe Designer, CMC, WebI, Rich Client, Xcelsius 2008, Live Office, QaaWS and Crystal Reports XI.
  • Expertise in migration (Universes, Reports, Security etc.) from BO 6.5 to BO XI R2 and BO XI R2 to XI 3.1
  • Experience in using free - hand SQL to validate data in complex reports by linking data from multiple data providers, stored procedures & functionalities like combined queries, performance tuning and providing operational support for OLAP applications.
  • Expertise in reporting with Business Explorer using BEx Analyzer, BEx Query Designer.
  • Expertise in Universe design and generating complex standard reports, dashboard KPIs, business views, LOVs along with UAT and Data Validations.
  • Developed test plans & performed unit level testing, system testing and integration testing.
  • Proactively created and maintained system, support, and process documentation; worked closely with users to ensure accuracy and completeness.
  • Extensively used Business Objects reporting functionalities such as Master, Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
  • Experienced in DataWarehouse, Life Cycle Management, ETL procedures from different sources using Informatica Power Center and DataStage.
  • In depth knowledge of developing database objects, views, stored procedures, user defined functions, cubes, logistics & ABAP.
  • In depth knowledge of Data Warehouse concepts including Dimensional and ER Modeling.
  • Conducted cross team presentations and meetings on best practices for building reports and consistency across BO developers.
  • Excellent communication skills with ability to effectively work individually as well as in a team with analytical problem solving skills.

PROFESSIONAL EXPERIENCE

Confidential, Waukegan,

BO 4.0 Consultant/Administration

Responsibilities:

  • Performed a key role as a defect resolver and develop high complexity HR reports.
  • Created Audit universe and reports for activity tracking and also to track daily data loads to the DWH.
  • Generated real-time reports that are attached to the shipments (Live Office, UNX and WebI reports)
  • Generated Dashboards using Dashboard Design on BO universe (Live office and direct query method)
  • Defined and configured security roles, row level security, user access to various universes, reports and applications.
  • Performed daily migrations from dev to test and prod environments and general administration through CMC.
  • Preached standard practices, cleared cross linking of data sources and multi-source universes.
  • Helped ETL team in resolving long standing DWH issues with data mapping from Oracle source as with requirement gathering.
  • Optimized universes and reports for better performance through various levels by optimizing the SQL, Key figure aggregation and separating object definition to more general objects and implementing report specific logic at the report level.
  • Served as a key hyper care and defect resolving position after project go-live and currently serving in the same role.
  • Co-ordinated with DBA in applying patches and reinstallation of prod environment.
  • Trained team members on new features of BO 4.0 and optimization technics.

Environment: SAP BO4.0, Data Services, IDT, CMC, Promotion Management, Dasahboard Design, Live Office, TOAD.

Confidential, Voorhees, NJ

Data Quality &SAP BI/BO 4.0 Consultant

Responsibilities:

  • Design and develop Data Quality and Data Governance reports, Data model design for the audit tables from SAP real time jobs
  • Involved in guiding offshore teams, creating standard template reports, setting standard practices for BI
  • Implement Data insight (data profiling), metadata management for EAM/CIS data quality
  • Defined security roles and integrated with SAP BW backend security
  • Developed complete data cycle from SAP ECC using standard and custom extractors to DSO, Infocubes and Multiproviders
  • Played the main role in BW- BO integration and was the key point of contact for any problems in this area
  • Developed Dashboards using Dashboard Design (SAP BW queries) and Information Steward for Data Quality
  • Guided other team members and conducted technical knowledge share sessions with offshore and onshore team members
  • Designed Infopackage Groups and scheduling based on time and events
  • Involved in monitoring and scheduling of Info package groups and Process chain
  • Involved in Converting InfoPackage Groups to Process Chains
  • Ensure that all periodic schedules like daily/weekly and monthly are successful
  • Analyze the errors occurred while uploading the data if the request fails and make the latest data available in data target
  • Involved in on going Knowledge Transfer activities including user documents preparation.

Environment: SAP BO 4.0, BEx, SAP BW, IDT, CMC, SAP Data Services, SAP Information Management, LCM.

Confidential, Rochester, NY

SAP BI/BO 4.0Architect

Responsibilities:

  • Configuration and Installation of BO 4.0, assign security roles and rights
  • Windows AD SSO configuration with SAP alias for direct access
  • Development of Transformations, DTP, Data Sources (flat file source system), Update Rules and Transfer rules for BI data flow and 3.x data flow
  • Creation and maintenance of BI objects (InfoCubes, DSO objects, Infoset, Multi Providers)
  • Scheduling and periodic monitoring of extractions through Info Packages and Process Chains
  • Involved in documentation for the mapping, technical specifications, data validations and test cases
  • Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections
  • Involved in migration and deployment of the universes and reports across multiple domains
  • Involved in the development of ODS, Generic DataSources and InfoObjects
  • Preparation of Technical Specifications

Environment: BO 4.0,BEx, SAP BW, Analysis Office, CMC, IDT, Rich Client, Dashboard Design

Confidential, Hopkins, MN

SAP BI Developer

Responsibilities:

  • Gathered requirements to create “Mean Absolute Percentage Error” reports on forecast reports for Supply and Demand.
  • Created WebI reports and customized the “Activity” universe to track various reports usage by End Users.
  • Analyzed usage of reports at the front end and backend to derive conclusions on usage of standard and adhoc reports and reports saved to personal favorites.
  • Demonstrated how the activity universe tracks front end usage data as compared to the backend tracking and presented the analysis to senior management.
  • Created BEx queries using BEx Query designer, defined filters, key figures, functions and Unit of Measure needs as per end user requirements.
  • Designed Universes from OLAP sources, refreshed Universes after BEx query modifications and later customized objects to create WebI reports matching the given requirements and business needs.
  • Modified dashboards in Xcelsius using BEx queries to give an overall picture of the recent trends in forecast demand & supply and various other analyses.
  • Provided support to product testing, Interacted with Analysts to fix defects and provide scope of possible improvement in WebI reports and Xcelsius Dashboards.

Environment: Business Objects XI3.1(Designer, WebI, Rich Client), XCelsius 2008, BEx Query Designer, SAP BW, Remedy

Confidential, Cleveland, OH

Sr. BusinessObjects Developer

Responsibilities:

  • Interacted with project manager & business users to understand the business needs, modify Universe and gather report specifications.
  • Designed Universes from multiple data sources to create several reports with additional variables and report level filters.
  • Created new classes, objects and made structural changes to Universes in Designer which includes adding new objects, updating tables, joins etc.
  • Defined Alias and Contexts to resolve loops, traps and also tested them to ensure retrieval of correct results.
  • Created sample dashboards to explain the team about available features and possible ways to display data.
  • Designed several dashboards in Xcelsiusfrom multiple data sources with additional variables and filters.
  • Provided feedback to users and senior management about the future developments possible in the dashboard application developed.
  • Created various user defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data.
  • Improved the performance and reduced coding with the use of @functions (@aggregate aware, @select, @prompt, @where).
  • Updated Universes & reports continuously to rolling user requirements & data sources in an agile environment.
  • Created and modified existing Hierarchies in the Universes to meet user’s Drill Analysis reporting needs.
  • Extensively used free-hand SQL to validate the results generated in complex reports.
  • Designed ETL task using Informatica to extract data from Oracle Database.
  • Created several types of Crystal Reports using sub-reports, Cross-Tab Reports, Graphs, Complex Formulas, and Conditional Formatting.
  • Involved in performance tuning & optimization on BO Universe Design by creating Aggregate tables.
  • Created Users & Groups, Folders, Categories, Events in the CMC.
  • Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
  • Conducted info-sessions with end users on recurring basis to educate and communicate all existing and new functionalities of Business Objects and Xcelsius.

Environment: Business Objects XI3.1(Designer, WebI, DeskI, Rich Client, CMC), XCelsius 2008, QaaWS, Informatica 8.1, Oracle 10g, Unix.

Confidential, Houston, TX

Sr. Business Objects Developer

Responsibilities:

  • Interacted with Business users to gather requirements, analyzed database & discussed with subject matter experts to get knowledge of table structure and the linkage between the tables.
  • Designed, Developed, Maintained and Implemented Universes by creating Joins between Tables, Prompts and created Contexts and Alias to remove cyclic dependencies.
  • Created Customized Hierarchies in universe for various reports and created user variables with calculations beyond those provided by the base universe objects.
  • Extensively used formulas, Filters, variables, prompts, Alerts based on Universes.
  • Developed Web I reports using advanced features like Hyperlinks.
  • Converted some existed Desk I reports to Web I Reports using Report conversion tool.
  • Worked with ETL team in Extracting, Transforming and Loading the data from source files to Oracle 10g using Informatica tool.
  • Developed mapping to implement Type 2 Slowly Changing Dimensions.
  • Involved in designing and updating the data model using Erwin 7.1.
  • Created Confidential dashboards, scorecards and business presentations by importing data from excel sheets using XCelsius 2008.
  • Developed flexible queries using navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information. Created custom queries using variables and structures.
  • Developed and supported front-end enterprise reporting, Dashboards, query views/elements through Business Explorer (BEx) QueryDesigner & Analyzer.
  • Generated queries in BExQuery Designer with filters, free characteristics, formulas, selections (restricting), reusable objects like calculated (CKF)/restricted (RKF) key figures, structures, hierarchies, conditions in BEx Analyzer/Report Designer.
  • Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.
  • Validation of data by doing query balancing using free hand SQL before moving to Production Environment.
  • Involved in Report performance tuning and universe optimization to minimize the execution time.
  • Provided support to QA testing team to clarify changes and resolved testing issues or bugs.
  • Actively participated in various team meetings& Involved in Unit testing and documentation.
  • Involved in production support and trained business users about the various features in WebI.

Environment: BO XI R2, CMC, Designer, Web I, Performance Manager, XCelsius2008, QaaWS, Live Office, SAP BW, Import Wizard, Crystal Reports, SQL\PL-SQL, Unix.

Confidential, Chicago IL

Business Objects Administrator

Responsibilities:

  • Interacted with Business users to gather requirements, analyzed database & discussed with subject matter experts to get knowledge of table structure and the linkage between the tables.
  • Installed and configured BO XI3.1 applications (Tomcat apache, QaaWS and Xcelsius) on Windows Cluster with LDAP authentication.
  • Involved in the Business Objects upgrade project from XI R2 to XI 3.1, migrating Universes, users, reports and security groups.
  • Analyzed object compatibility, connections and Universes and involved in troubleshooting issues encountered while migrating.
  • Created, modified/maintained Projects Universe by inserting tables, joins, self joins, views and derived tables.
  • Optimized the usage of user objects, conditions, measure objects and Universe level filters.
  • Enhanced report performances by making changes to the existing Universe design.
  • Extensively worked in resolving timeout issues with WebI and DeskI products.
  • Defined the Universe/report deployment across multiple Universe domains and multiple document domains.
  • Added/created complex objects to the Universe to enhance the report functionality and validated report data by creating ad hoc reports.
  • Involved in Migration (Universe, Reports, Users & Groups, Folders, Categories) from BO XI R2 to XI 3.1.
  • Created reports using free-hand SQL (custom SQL), built hierarchies and facilitated drill down in the reports.
  • Designed and created web templates by Cascading Style Sheet (CSS), Java SDK, Web Application Designer, integrated Web Items, ad-hoc query designer linked with SAP Enterprise Portal, BEx Broadcaster, and migrated 3.x web templates.
  • Created and documented business procedures with respect to Business Objects administration.
  • Documented changes to the Universe, reports functionality and deviations from the original specifications.
  • Involved in preparation of users guide and fine-tuning the specification.
  • Defined production support strategy for the reporting issues.
  • Trained the business users with report generation using WebI XI 3.1.

Environment: Business Objects XI 3.1/ XIR2 (Designer, WebI, DeskI, Rich Client, CMC), Crystal Reports XI, SQL Server 2005/2008, SQL Server Reporting Services, Teradata, DataStage

Hire Now