Professional Summary
Overall 6 years of experience as a Business Objects Developer, Sap BO XI 4.0 and 4.1. In debt understanding of Universe Design, Development, Alteration, Maintenance, using Information Design Tool and Universe Design Tool (IDT and UDT). Experienced in developing complex reports using Webi Rich Client, Crystal Reports, Dashboard designer and Design Studio. Excellent understanding of of Data Warehouse concepts, OLAP, Star Schema, Snowflake Schema, Extended Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, Physical & l & Logical Data Modeling. Strong understanding of OLTP/ERP and BI/OLAP Systems. Competent in handling all levels of data warehouse life cycle, including requirements gathering, analysis, preparing business specifications, designing technical specifications, and system requirement specifications. Performance tuning, testing, migrating to production and post-production support. 1, BO Data Services XI 3.2, BODI 11.5. Expertise in working on SQL with Databases such as Oracle 11g/10g/9i, MS SQL Server 2005, 2012 IBM DB2 V8 and Tera data V12. Proven ability to work in cross-functional teams with high sense of ownership and strong customer focus. Experienced using BEX Query Designer. Worked extensively with Web Intelligence functions, formulas, and variables. Applied/Used functions, such as filters, conditions, breaks, sorting, drill down, slice and dice, Input Controls, Master/Detail, Cross Tab, Charts and alerts to name a few in Web Intelligence. - Excellent ability designing, developing and troubleshooting simple to complex reports in SAP BusinessObjects.
Experience
SAP Business Objects DeveloperCity, STATE. 01/2017 - 05/2017
American Society Of Quality
- Analyze, design, development and configuration of Web Intelligence and Crystal reports for high profile business users.
- Activities also included working with business users to establish requirement gathering for new reports and modify existing reports.
- Created various simple and complex reports, mainly using business objects universes as data providers.
- Created and defined the Hierarchies for various reports based on user requirement.
- Utilized Web Intelligence reporting tool to create graphical representation of reports such as Bar charts, Pie Charts as per requirement.
SAP Business Objects Developer
Raytheon CO
- City, STATE 08/2015 07/2016
- Created Web Intelligence reports utilizing SQL Queries, as per the Functional Specifications. Reading, writing, executing and maintaining Microsoft Access queries, logic, macros, reports, and forms.
- Used formatting options such as Cross Tab Representation, Section Breaks, Data Sort Options, Calculations, Fonts, Colors, And Conditional Formatting "IF", "Then" and "Else" in Web Intelligence. Developed various Charts, Graphs, drill down reports, Vertical and Horizontal Tables using Web Intelligence.
Exported reports as Power Point, PDF, Excel or CSV.
- Involved in creating Conditions, Operators, Formulas, Filters, Ranking, Sorting, SubQueries, Combined queries, Prompt, Section, and Scope of Analysis (Input Controls) in Web Intelligence. Utilized Merged Dimensions feature to allow linking of two or more data provider (queries). Converted Deski reports to Webi using Report Conversion tools.
Created / I various dashboards using Crystal Dashboards and Xcelsius.
- Assisted with developing Crystal Reports in team environment - Creating, formatting, applying
- templates, linking to to proper roper data source, sorting, grouping, summarizing, and aggregating data.
- Involved in effort estimations for development of the reports and Universes.
- Requirement gathering from Business Analyst and create the specs for development of Universe
using Universe Designer Designer - IDT. / Modified and I maintained
- | Universes using Designer module to include objects such as Dimensions, and Measures according to the functional specifications.
Details and
- IDT- Worked with Connection Layer, Data Foundation Layer, Business Layer, aliases, Contexts, Aggregate Awareness, Index Awareness, Navigation Paths and Predefined Conditions. Created Aliases and Contexts for resolving Loops, checked the cardinality and Integrity.
Developed Universes using OLAP data sources. / Assisted in Database Design Star and Extended Star Schemas.
- Assisted transfer of data from SAP/R3 to Bl.
Created Multiproviders on infocubes and DSOs. / Assisted generating reports using BEX Analyze and Query Designer.
- Testing and Validating data values.
SAP Business Objects DeveloperCity, STATE 03/2013 - 08/2015
Walgreens CO
- Performed complex Web Intelligence report conversions from Excel workbook to Webi.
- Performed unit and integration testing and participated in report validation and QA efforts as they pertain to reporting and data analytics.
- Written simple and complex SQL queries.
- Excessively worked with internal teams to analyze and recommend reporting solutions to meet business requirements.
- Developing highly visual reports using Xcelcius Dashboard.
- Designed, programmed, and implemented new reporting documents and processes, modified
- existing reports and produced ad-hoc reports as needed utilizing Webi. existin
- Maintained and adhered to standard report writing practices to ensure consistency of data and format between various reports. Validated report data values.
Scheduling reports utilizing CMC.
- Coordinate security requirements and administration.
- Design/Deletion and management of groups, users, and objects.
SAP Business Objects DeveloperCity, STATE. 08/2011- 02/2013
Fifth Third Bank
- Develop and Support Data warehousing reporting and maintenance requirements. Responsible for technical design and requirement Analysis.
- Responsible for effort estimations for Business Objects Universe and reports requirement. Created the new Universes as well as customizing the old Universes (using aliases, contexts, aggregate awareness, aggregate navigation and hierarchies) as per the requirements. Creating Deski Reports, Webi reports (used alters, merge dimension, filters, prompts, user response, multiple data providers) as per the request.
- Involved in dashboard maintenance including updating existing dashboards as per user needs, which involved updating the underlying Webi Reports and Queries and displaying the updated data in dashboard.
- Creating Unit test cases and conducting unit testing of individual reports.
- Participated in reviews of the reports and Universes and creating the review logs and review checklists.
- Responsible for migration of reports and Universes from BO XI R3 to SAP BO 4.0.
- and fixes after migration issues in Webi Reports.
- Worked on SAP BO 4.0 Webi rich client, Universe Design Tool and LCM tool.
- Interacting with customers to fix the issues found in UAT.
SAP Business Objects DeveloperCity, STATE. 01/2011- 07/2011
Sprint/Nextel Corporation
- Recreated the existing reports from Excel format to Webi (.Wid) format.
- Interacting with the client for understanding the project requirements and planning the project and resource accordingly.
- Creating low level design documents.
- Customizing the Universes as per the requirements.
- Recreating Webi reports as per the requirement specs.
- Designed reports that include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.
- Creating Unit test cases and conducting testing of individual reports.
- Interacting with customers to fix the issues found in UAT.