We provide IT Staff Augmentation Services!

Sap Bi/bo Developer Resume

Dallas, TX

SUMMARY:

  • BI Consultant with 10+ years of experience in Business Intelligence and reporting on OLTP and OLAP systems based on Client/Server technologies utilizing full SAP BO Suite - Universe Design Tool, Information Design Tool, Web Intelligence, Dashboards, Crystal Reports and Informatica
  • Hands on experience on design and maintenance of complex Universes using Joins, cardinalities, conditions, Filters, LOVs, Aliases, Contexts, Index Awareness, Prompts, Aggregate Awareness, Sub queries, Multiple queries, Combined queries and eliminating data issues with loops and SQL traps
  • Experience in generation of visualizations by using various connections like Live Office, SAP BW and QWaas Connections etc. and developed Filters, Label based menus, Flash Variable, SWF loader, Tabsets, According menus, Canvas Containers, List Builder, List Views, Sliders, Fish Eye menu, Play Selectors, Grids in Dashboards using Dashboard designer
  • Expertise delivering Webi reports using various data presentation techniques like Tables (Vertical, Horizontal, Cross Tab and Forms), Charts/Maps, Grouping, Filters, Conditional alerts, Ranking, Sorting, Drill down with Slice and Dice, Sections, Breaks, Formulae and Variables.
  • Experience working with business users to design and implement data visualization solutions that meet business needs using Xcelsius 2008 and Dashboard
  • Administered Servers on CMC & CCM and performed scheduling of reports and maintained support for jobs, using CMC and monitoring users/user group’s rights for viewing, creating and publishing reports.
  • Provided to a variety of end users on Confidential tools and Dashboards.
  • Production Support - Extensive experience in support Bo applications.
  • Excellent team player with analytical & presentation skills and a strong desire to be adept with latest technologies.

EXPERIENCE:

Confidential, Dallas, TX

Sap BI/BO Developer

Responsibilities:

  • Interacted with Business to gather Requirements and translate to Technical specifications for Designing Universes.
  • Created the PL/SQL Stored Procedures, Functions, Views for the Reporting.
  • Created Data foundation and Business layer in IDT UNX file.
  • Created complex SQL queries and built derived tables and joined with universe tables.
  • Developed the Materialized Views to Improve the Report Performance
  • Checked the integrity and cardinality for the potential loops and traps.
  • Developed Crystal Reports based on PLSQL Procs, Views and Universe
  • Created a Crystal report using multiple Sources, for Reconciliation by Inserting 6 sub reports to display the information in one report.

Environment: XI 4.x (CMC, CCM, Designer, BI Launchpad, Web Intelligence, Crystal enterprise, Oracle12c, SQL, and PLSQL)

Confidential, San Antonio, TX

Sr. SAP Confidential /BI Consultant

Responsibilities:

  • Studied the application and application database to understand the data relations, and to identify the data required for the reporting needs.
  • Interacted with Business to gather Requirements and translate to Technical specifications for Designing Universes.
  • Created Data foundation and Business layer in IDT UNX file.
  • Created complex SQL queries and built derived tables and joined with universe tables.
  • Checked the integrity and cardinality for the potential loops and traps.
  • Created the Universe standalone prompts, Parameters and custom lovs and set the Default values for the reporting purpose
  • Worked on Conceptual design of the Dashboard.
  • Provided estimations based on the requirement analysis and completing the deliverables on time
  • Explaining in detail about the report functionality and assigning Work to offshore team to deliver Quality product on time.
  • Worked with Agile as Scrum master involved in iteration planning and demo the iteration to the APO.
  • Created Canned/Ad-hoc reports using web intelligence functionalities like Cross Tab, Master Detail, Slice Dice and Drill Down.
  • Created Authoring, Recommendation Dashboards in Webi Using Multiple Data Providers and created Merged dimensions to drill on all the report blocks
  • Created the dashboards in dashboard designer using Qaaws’s Connection.

Environment: Details: Confidential XI 4.x (CMC, CCM, Designer, BI Launchpad, Web Intelligence, Dashboards, Oracle11g, SQL, PLSQL) QAAWS & WSDL

Confidential

Sr. SAP Confidential /BI Consultant

Responsibilities:

  • Interacted with Business Users and Business Analysts to gather Requirements and translate to Technical specifications
  • Provided estimations based on the requirement analysis and completing the deliverables on time
  • Created the Universes and modified existing Hierarchies in the universes to meet Drill Analysis of the users reporting needs.
  • Developed SQL queries for derived tables in universe.
  • Merged dimensions to Synchronize data from multiple queries.
  • Created Canned/Ad-hoc reports using web intelligence functionalities like Cross Tab, Master Detail, Slice Dice and Drill Down.
  • Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculation contexts and Ranking.
  • Migrated Confidential XI 3.0 content (users user groups, Universes, reports) in to Confidential 4.0 environment using the Upgrade Management tool.
  • Implemented weekly report releases and involved in build release documentation of reports as per build schedule standards
  • Worked on production support activities reports monitoring, user administration, report failure analysis and debugging.
  • Documents Created and performed the Unit and integration testing
  • Provided Productions support for two Bo applications in parallel, Scheduling, monitoring, User creation, created file based events for scheduling.
  • Trouble shooting schedule failures.
  • Make sure the scheduled reports sent to the destination on time for the users to enable to submit reports to the regulatory bodies

Environment: Details: Confidential XI 4.x, XIR3.X (CMC, CCM, Designer, Bi Launchpad, Web Intelligence, Dashboards, SQL, PLSQL) Crystal Reports, Oracle 10g

Sr. SAP Confidential /BI Consultant

Confidential

Responsibilities:

  • Developed WEBI report/dashboards / Universes (using IDT) in BI Environment.
  • Use of Designer module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables.
  • Created the user-groups in CMC and implemented the security model on the groups created
  • Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.
  • Participated in the complete development lifecycle: analysis, design, build and test reports
  • Created complex reports using functions like @variables, @prompt, condition objects and aggregate awareness functions.
  • Created User Prompts, Conditions and Filters to improve the quality of report generation.
  • Design and Developed various ad-hoc and canned reports using Webi Rich Client on Market and Regions for marketing team to do trend Analysis, Stacked Bar/Column Chart, Heat Map, Tree Map, Bubble Chart etc.
  • Analyzed the data and develop/understand the ETL specifications.
  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center
  • Worked on complex mappings, mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
  • Pre validating the source File Data before loading into the Staging by comparing the source file data against the base s
  • Extensively used ETL to transfer and extract data from source files (Flat files and MS-SQL, oracle) and load the data into the target database.
  • Extensively used Autosys and Unix for Scheduling and monitoring
  • Designed and developed efficient Error Handling methods and implemented throughout the mappings.
  • Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads
  • Prepared Unit/ Systems Test Plan and the test cases for the developed mappings
  • Involved in migrating objects to different environments using Deployment groups and Labels

Environment: Details: SAP BO, CRYSTAL REPORTS, Informatica 9.5, Unix, Autosys, Oracle 10g,Ms-SQL server 2012, WinScp, Putty, SFTP/FTP,XML Editor, MS-Excel, MS-Access

Confidential

Sr. SAP Confidential

Responsibilities:

  • Interacted with Business Users to gather reporting requirements.
  • Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
  • Created Joins, Contexts, and Aliases for resolving Loops, Chasm & Fan traps and checked the Integrity of the Universes.
  • Modified existing client Eikon universes and created new universes as per the business requirements using @Aggregate Awareness and @prompt functions.
  • Created Standard Web I reports with client customizations and formatting to serve as templates for the canned and ad hoc reporting.
  • Created & tested reports using Confidential functionality using Queries, Slice and Dice, Drill down, @Functions.
  • Used Import wizard to import existing user accounts, groups, categories, Webi documents, universes, connections and universe restrictions to BO 3.1 environment.
  • Created users and groups and applied row level and objects level securities at Universe level.
  • Trained Business Users in report creation and also new features of Confidential 3.1
  • Created graphical representation of reports such as Bar charts, Line charts as per End user additional requirements.
  • Created new objects (measure, dimension & detail) classes and sub classes to meet the needs of end user requirements
  • Trained the end user in basic and advanced ad-hoc reporting as well as create queries format results and share them with others within the enterprise and beyond using
  • Performing Unit Testing of the Reports.
  • Performing performance tuning of the Reports.

Environment: Details: Confidential XI 3.x (CMC, CCM, Designer, InfoView, Web Intelligence, Xcelsius) Crystal Reports 2008, Oracle 10g.

Confidential

Sr. SAP Confidential

Responsibilities:

  • Worked with business users to analyze Reporting Requirements and Metric Analytics to come up with technical specifications for BO Reports from different sources.
  • Adopted strategies for List of Values involving customizing the list of values, Cascading list of values and exporting the List of Values with the universe.
  • Used LCM (Life Cycle Manager) for exporting BO Objects from one environment to other, used Database Expert, Group Expert, Select Expert, and Section Expert to create different Crystal reports.
  • Worked extensively with the major functionality of BO like Breaks, Ranks, Variables, Alerters, Formulas, Calculated data items, Filters, Sorts, and Query prompt.
  • Created reports using Confidential functionalities like Multiple Data Providers (Merging), Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail Created Complex Queries in Desktop Intelligence and Web Intelligence including Complex Conditions (wildcard characters, In List, Different From), Sub queries, and Grouping Conditions .
  • Created complex reports using SQL queries, procedures and user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
  • Performed Administrative tasks like Setting up user profiles, assigning rights and privileges for groups, setting up categories using CMC, and maintain Bo servers
  • Worked on optimizing report queries for efficient performance both at report level and query level.

Environment: Details: Confidential XI R2 (CMC, CCM, Designer, InfoView, Web Intelligence and Desktop Intelligence), Informatica, Oracle 10g

Confidential

Sr. SAP Confidential Consultant

Responsibilities:

  • Involved in gathering and analyzing the business requirements with team.
  • Designed and developed Universes for report generation by using Designer.
  • Generated several canned reports using Confidential Universes as the Data provider against the multiple data providers.
  • Developed Ad-hoc reports using web intelligence and publish them to Enterprise.
  • Testing reports before posting them to the repository (Query optimization and performance).
  • Created dimensions, detail as well as complex measure objects.
  • Created aggregate tables and used aggregate awareness functions in design for report performance.
  • Universe tuning by creating joins contexts and aliases for resolving loops and checked the integrity of the Universes using Confidential Designer.
  • Implemented row level and object level security.
  • Used calculations, variables, breaks, sorting, alerts and drill down/up functionality for creating master detail reports related to the company’s marketing, sales, accounting and financial planning design and implement of reports.
  • Created various reports with Crystal Reports XI.
  • Created reports from personal data files like SQL,EXCEL sheets
  • Involved in interacting with end-users.
  • Performing Unit Testing of the Reports.
  • Performing tuning of the Reports.
  • Peer Reviewing of Reports and Universes.

Environment: Details: BusinessObjectsXIR2 (CMC, CCM, Designer, InfoView, WebI), Informatica 7.5, Oracle 9i, Win 2003

Confidential, San Jose

SAP BusinessObjects Consultant

Responsibilities:

  • Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
  • Involved in the designing and Building of Universes, Classes and objects.
  • Created various reports charts, bar graphs using Xcelsius, Dashboards.
  • Resolved loops and Traps using Contexts and Aliases while designing Universes.
  • Set up Universe level conditions to restrict data based on report requirements.
  • The project involved development of reports using Confidential and WEBI to cater Ad-hoc reporting needs.
  • Created reports using Confidential functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.
  • Worked with Multiple data providers including Personal Data files, Stored Procedures and Freehand SQL to create reports.
  • Used Filters and Conditions to achieve report functionality.
  • Published Confidential Reports to users and Repository.

Environment: Details: BusinessObjectsXIR2 (CMC, CCM, Designer, InfoView, WebI, Crystal Reports XI, Xcelsius, Dashboards) Informatica 7.5, Oracle 9i, Win 2003

Confidential

SAP BusinessObjects Consultant

Responsibilities:

  • Converting the BO6.5 .Rep into web intelligence documents using RCT
  • Creating New Web Intelligence documents of Non-converted documents.
  • Worked on the reports which are partially converted
  • Achieved the same functionality in WebI as DeskI using work-arounds
  • Testing the Web Intelligence Documents

Environment: Details: Confidential 6.5.1 (Supervisor, Designer, Confidential, Web Intelligence), Informatica 6.1, Oracle 8i, Win 2000

Hire Now