Sap Bi Consultant Resume
Eagan, MN
PROFESSIONAL SUMMARY:
- Over 9 years of IT experience in SAP Business Intelligence Developer Suite 4.2/4.1/4.0/XI 3.1 and experience in all phases of the Software Development Life Cycle (SDLC) such as requirements gathering, Analysis, Design, Implementation, Maintenance and involved in the Production Support.
- Extensive experience with SAP BW such as Info cubes, BEx Query designer, BEx Analyzer, Data Modeling.
- Over 3 years of Experience in Tableau Desktop Server 10.x/8.x/7.x in analyzing and creating highly actionable and interactive reports and dashboards by connecting to various data sources.
- Followed best practices suggested by IBM Cognos where and when applicable in the 3 - tier architecture.
- Experienced in Installation, Administration and upgrading versions of SAP Business Objects in development and testing environments, extensively used CMC for management tasks and CCM to manage local and remote servers.
- Strong experience in Performance Tuning and Query Optimization, Optimizing Universe through Linked universes, Aliases and Contexts.
- Knowledge in migration of BI versions from 3.1 to 4.1/4.2 and Crystal Reports from.
- Solid Experience in writing SQL, stored procedures, functions, packages, Cursors.
- Experienced in the use of Agile and Waterfall methodologies to meet BI requirements.
- Exposure to Agile and Six Sigma methodologies.
- Knowledge in Hadoop reporting tool.
- Created multi-source universes to combine more than one source data.
- Created WebI Reports with breaks, sections, merged dimensions, formulas, variables, alerts, filters and query drill.
- Create complex ad-hoc/scheduled WebI Reports using slice and dice, drill down, cross tab, complex variables, Case/If else conditions, multiple data-providers, multiple table/section and master detail type reports.
- Expertise in generating drill-down report, sub reports, OLAP, query based reports, custom made template, report scheduling, publishing using Crystal Reports.
- Worked on Crystal Reports in Creating Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.
- Created Dashboards using Live Office, QAAWS, Universe and BEx queries using Dashboard designer.
- Created Dashboards using Dashboard Manager with metrics, alters, speedometers and analytic templates to monitor and track business performance.
- In the latest version of design studio worked on Application Bookmarking and personalization, drag and drop, context menu, RRI, advance printing and exporting.
- Created custom charts, visualization & extensions in design studio & SAP Lumira.
- Created info spaces on universes for ad-hoc reporting in Explorer.
- Performance tuned indexing process and scheduled to run every day.
- Dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, Physical and Logical data modeling.
- Strong knowledge in designing and developing Data marts, Data Transformation, Data Analytics, Data Architecture, Data Management and Data Warehouse using multi-dimensional models such as Snow Flake and Star Schema.
- Strong Database experience in Oracle 11g,10g/9i/8i/8.0/7.x, DB2, MS Access, MS SQL Server 2008/2005/2000 , SQL Loader, PL/SQL, Oracle DBMS Packages, TOAD, SAP BW and SAP HANA.
- Extensive knowledge in SQL, Rapid SQL, PL/SQL & T-SQL programming and trouble shooting.
- Extensive experience working with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.
TECHNICAL SKILLS:
Business Intelligence: Business Objects BI 4.2/4.1/4.0/XI R3.1, Xcelsius, Dashboards, Crystal Reports 2013/ 2008/10/9 , SAP BO DQM 4.0, Design Studio, Lumira, Central Management Console, Central Configuration Manager, Universe Designer, Desktop Intelligence, Web Intelligence, WebI Rich client, Import Wizard, Report Conversion Tool, Tableau Desktop 8.1/v9/v10, Hadoop, Translation Manager, Query as A Web Service (QAAWS), Performance Manager, Crystal reports Enterprise, Auditor, Crystal Report Explorer, Dashboard manager, Tomcat, Data Services, SSIS, SSRS, SAS.
Databases: Oracle 11g/10g/9i/8i, Teradata, IBM DB2, UDB 8.0/7.0, MS SQL Server2005/2000, Sybase, SAP HANA, SAP BW
Utility Tools: Erwin 6.1/4.5/4.1/4.0 , Toad 8.5.1, SSMS, Rapid SQL 2016, AQT (Advanced Query Tool).
Programming Languages/Web technologies: Visual Basic 6, PL/SQL, HTML, PHP, JavaScript, MS Front Page, Tomcat Apache Web Server, IIS 7.0/5.0/4.0
Environment: Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win 2003, Win XP. MS-Dos, Win NT, Red Hat Linux.
PROFESSIONAL EXPERIENCE:
Confidential, Eagan, MN
SAP BI Consultant
Responsibilities:
- Involved in all phases of Software Development Life Cycle. Gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
- Created complex Universes and Reports and Checked the Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
- Created predefined condition, prompts, variables and customized LOV’s in the process of building the Universes.
- Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and scheduling reports using central management console.
- Extensively created reports in WebI module and implemented drill down features and created reports including horizontal table, vertical tables.
- Developed and analysed reports using AQT (Advanced Query Tool) using custom SQL queries with backend DB2 and given support to reports in prod.
- Created reports on web using BI Launchpad Portal and published the reports on the World Wide Web to different users.
- Created several Classes, Objects, Conditions, and Measure objects
- Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
- Resolving join path Problems like Chasm Trap and Fan Trap and loops by creating Context and Aliases.
- Exported the Universes to the Repository to make resources available to the users. Created reports from the Universes as the main Data Providers
- Created reports using Universe, Free-Hand SQL, and Stored Procedures Data providers.
- Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where). Created complex reports using different data sources.
- Tested the created reports and modified the relevant objects in the Universe.
- Created a set of Ad hoc reports with Business Objects and finally deploying them in Web Intelligence
- Optimized the reports at the universe level and report level to enhance their performance which involved working on SQL parameters, aggregates and joins.
Environment: Business Objects 4.1/3.1, Tableau Dashboards v9, Data Stages, SAS, Designer UDT, Web Intelligence, CMC, DB2, SQL Server, Teradata, AQT.
Confidential, Rochester, MN
SAP BI Consultant
Responsibilities:
- Involved in all phases of Software Development Life Cycle. Gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
- Created complex Universes and Reports and Checked the Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
- Created predefined condition, prompts and customized LOV’s in the process of building the Universes.
- Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.
- Extensively created reports and given production support to Crystal reports 2016 and implemented distinctive features and created reports including horizontal table, vertical tables, forms and charts.
- Created reports on web using Info View Portal and published the reports on the World Wide Web to different users.
- Created several Classes, Objects, Conditions, and Measure objects
- Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
- Resolved loops, defined contexts and aliases to resolve loops and tested them to ensure that correct results are retrieved.
- Resolving join path Problems like Chasm Trap and Fan Trap and loops by creating Context and Aliases.
- Exported the Universes to the Repository to make resources available to the users. Created reports from the Universes as the main Data Providers
- Created reports using Universe, Free-Hand SQL, and Stored Procedures Data providers.
- Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where). Created complex reports using different data sources.
- Tested the created reports and modified the relevant objects in the Universe.
- Developed and given production support to SAP Lumira Dashboard reports.
- Created a set of Ad hoc reports with Business Objects and finally deploying them in Web Intelligence
- Optimized the reports at the universe level and report level to enhance their performance which involved working on SQL parameters, aggregates and joins.
Environment: Business Objects 4.2/3.1, Dashboards, Crystal Reports 2013/2016, SSRS, Informatica, Designer, Web Intelligence, Info View, Lumira, CMC, SSIS, DB2, SQL, PL/SQL, SQL Server 2012, Oracle 11g, Teradata, TOAD, Rapid SQL 2016.
Confidential, Auburn Hills, MI
SAP BI Consultant
Responsibilities:
- Involved in Full life cycle of Business Objects reporting Application right from requirements gathering till the deployment of the Business Objects reporting system on to the production.
- Installed and upgraded BO 4.1 and crystal reports 2013.
- Interacted with Business Users and Business Analysts and Data Analysts to gather and document the requirements and translate these to Technical specifications for designing Universes.
- Developed a complex universe which involved multiple fact tables. Created multiple contexts to resolve loops and performed integrity checks.
- Resolved Loops, Chasm and Fan Traps using Contexts and Alias tables in Universe Designer.
- Created complex WebI reports with multiple queries, custom sql using complex functions, merging dimensions at report level, Drill Down, Drill Up, Drill across, complex filters etc.
- Optimized the reports at the universe level and report level to enhance their performance which involved working on SQL parameters, aggregates and joins.
- Worked with end users to gather and document requirements for a SAP Business Objects reporting solution.
- Created the WebI and crystal reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions and Formulas etc. and several Queries (Union, Intersection, Minus)
- Migrated reports from crystal 10 to crystal 2013.
- Publish, distribute and schedule Web Intelligence reports using Info view.
- Designed, developed and tested the reports based upon data generated by enterprise transaction, financial and customer information systems using Business Objects XI connected to Oracle data source.
- Performed unit testing, system testing and user acceptance test (UAT) for universe, reports and security management.
- Worked on many components of design studio 1.3 such as tables, crosstab, maps.
- Experienced in working on design studio with Oracle and HANA as the data source.
- Analysed reports using SQL server management studio.
- Responsible for improving the Business Objects query performance by tuning the Queries, Database and server parameters.
Environment: Business Objects 4.1/3.1, Dashboards, Crystal Reports 2013, Designer, Web Intelligence, Info View, CMC, Informatica 8.1, DB2, SAP HANA, Design Studio, SQL, PL/SQL, SQL Server 2012, Sybase, Oracle 11g, Teradata, TOAD, Erwin 6.1
Confidential, San Diego, CA
BO Tableau Developer
Responsibilities:
- Involved in Full life cycle of Business Objects reporting Application right from requirements gathering till the deployment of the Business Objects reporting system on to the production.
- Involved in conversion of Micro strategy reports to Tableau Workbooks.
- Based on requirements Designed, Developed and Maintained Tableau functional reports.
- Involved in creating data visualization dashboards by extracting data from different sources.
- Defined and created Hierarchies as per the business rule for the reports to be viewed at selected level. Checked the integrity of the Universes and exported the universes to repository for making available to users.
- Developed LOD reports on various KPI’s.
- Performed Tableau type conversion functions when connected to relational data sources.
- Maintained and Installed Tableau Server in all the environments.
- Created incremental refreshes for data sources on Tableau server.
- Provided support for Tableau developed objects and understand tool administration.
- Worked in tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop publish them to server.
- Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
- Created different KPI using calculated key figures and parameters.
- Optimized the reports at the universe level and report level to enhance their performance which involved working on SQL parameters, aggregates and joins.
- Worked with WebI for creating complicated reports including sub-reports, graphical reports, formula based, well-formatted reports, drilling reports, along with LOVs and data reports.
- Developed Crystal Reports and formatted the same with respect to the requirements, added parameters, special fields and used multiple data sources to create the reports.
- Experience in data analytics and performance tuning of the BOBJ reports at the universe level and report level.
- Knowledge in architecture design of Extraction, Transformation & Loading environment using Informatica.
- Created information spaces in business objects explorer and performed indexing on them.
- Designed, developed and tested the reports based upon data generated by enterprise transaction, financial and customer information systems using Business Objects XI connected to Oracle data source.
- Developed front end queries using Query Designer and Web Application Designer (WAD) and published results on the web.
- Responsible for maintaining the BOBJ Landscape (Development, Quality, Staging and Production repositories, universes, reports and connections) and providing round the clock support during the production stage.
Environment: Business Object BI 4.2/4.1, Dashboards, Tableau Desktop 8.x/9.x, Tableau Server, Crystal Reports 2013, Designer, Web Intelligence, Info View, CMC, Informatica 8.1, SDK, DB2, SQL, PL/SQL, SQL Server 2012, Oracle 11g, Teradata, TOAD, Erwin 6.1
Confidential, Cheshire, CT
BO Crystal Reports Developer
Responsibilities:
- Involved in gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
- Involved in interacting with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
- Gathered and captured all existing Customization/enhancements in available BO system. Involved in preparation of BRD (Business requirement document) and GAP analysis in order to include each and every enhancement during Upgrade. Understand the business data flow.
- Responsible for Designing and building Universes using Universe Design Tool (UDT).
- Resolved Loops, Chasm and Fan Traps using Contexts and aliases in Universe Designer.
- Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
- Installed crystal reports 11 version.
- Migrated reports from crystal 2008 to crystal 11.
- Created parameterized Crystal Reports and customize existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, used Crystal syntax to create formulas for the reports.
- Published and scheduled the reports in Crystal Enterprise using Crystal Management Console so that reports are accessed from Front-end application.
- Handled Incompatibility issues between Crystal Reports 2011 and Excel and between Crystal Reports and PDF.
- Created parameterized Crystal Reports and customize existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, used Crystal syntax to create formulas for the reports.
- Created Ad-hoc reports using BO functionalities like Master Detail, Formulas, Breaks, Calculations, Alerts, Slice and Dice, Drill Down and @Functions.
- Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
- Built Dashboards with high variation of data using Live Office, QAAWS and BI Web Services.
- Implemented security features of Business Objects like row level, object level and report level to make the data secure.
- Provided end user and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software.
Environment: Business Object 4.1, Xcelsius, Dashboards, Crystal Reports 2011, Designer, Web Intelligence, CMC, DB2, SQL, PL/SQL, SQL Server 2008, Teradata, TOAD, Erwin 6.1
Confidential, Phoenix, AZ
Business Objects Developer
Responsibilities:
- Interacted with Business Users and End Users to know their Business views in developing and modifying Universes and Reports accordingly.
- Worked on full life cycle of the project including requirements gathering, prototyping, Effort estimate, Impact analysis, development, UAT, Production and Postproduction support.
- Understanding business requirements in terms of technical specifications for reporting and data analysis.
- Extensively used Business Object Universe, WebI Reports & DeskI Reports and Oracle database.
- Extensive analysis to design the Universes and assigned those to respective domains.
- Created universes, classes and objects by retrieving the data from data sources like BW queries and defined data loads and query performance issues.
- Created WEBI Reports on OLAP Universe using various formats like Cross tabs, Sections, Breaks, Sort options, Font, Colors and Charts.
- Created WEBI reports and deployed them through info view with BW universe as source.
- Extensively used calculations, variables, prompts, sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
- Created complex views to overcome loops and contexts.
- Created Queries by defining structures, variables, formulas, exceptions, navigational attributes, conditions providing drill down functionality in reporting.
- Created complicated reports including sub-reports, data visualization reports, graphical reports, formula base and well formatted reports according user requirements.
- Created Crystal Reports with Standard Cross Tabs and Grouping.
- Knowledge in architecture design of Extraction, Transformation & Loading (ETL) environment using Informatica, Power Mart and Power Center, Accentual Data Stages 7.5, Data Integrator.
- Created visualizations for Finance department to display important KPIs and metrics in one single view.
- Used live office and QAAWS to give visualizations live data connectivity.
- Developed critical reports having complex drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
- Generated Reports using the Universe as the main Data provider and using the personal data files provided by the users.
- Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user.
- Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
- Implemented Security Features of SAP Business Objects like row level, object level and report level to make the data secure.
- Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using aliases and contexts.
- Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe.
- Generated the SAP Business Objects reports involving complex queries, sub queries, Unions and Intersection.
- Responsible for SQL tuning and optimization using Explain Plan, Indexes and optimizer hints.
- Involved in Business Objects support, Problem solving, trouble shooting and developing End user notes.
Environment: Business Object XI 3.1, Crystal reports 2008, Xcelsius 2008, Designer, Desktop Intelligence, Web Intelligence, InfoView, CMC, Teradata V2R7, SQL, PL/SQL, SQL Server 2008, SQL Assistant.
Confidential, Houston, TX
Business Objects Developer
Responsibilities:
- Involved in all phases of Software Development Life Cycle. Gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
- Created complex Universes and Reports and Checked the Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
- Created predefined condition, prompts and customized LOV’s in the process of building the Universes.
- Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.
- Extensively created reports in WEBI and DESKI module and implemented drill down features and created reports including horizontal table, vertical tables, forms and charts.
- Created reports on web using Info View Portal and published the reports on the World Wide Web to different users.
- Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
- Resolved loops, defined contexts and aliases to resolve loops and tested them to ensure that correct results are retrieved.
- Resolving join path Problems like Chasm Trap and Fan Trap and loops by creating Context and Aliases.
- Exported the Universes to the Repository to make resources available to the users. Created reports from the Universes as the main Data Providers
- Created reports using Universe, Free-Hand SQL, and Stored Procedures Data providers.
- Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where). Created complex reports using different data sources.
- Tested the created reports and modified the relevant objects in the Universe.
- Created a set of Ad hoc reports with Business Objects and finally deploying them in Web Intelligence
Environment: Business Objects XIR3, Xcelcius 4.5/2008, Web Intelligence, Desk I, Oracle 10g, PL/SQL, SQL Server 2005, Toad, Erwin, Windows 2007 Server/XP/Professional
Confidential, Denver, CO
Business Objects Developer
Responsibilities:
- Analyzing system functionality requirements, documents and scope of the work.
- Work included Developing, Testing and enhancing existing Business Objects Universes; work required modifying, testing and promoting to the Repository.
- Developed, Tested, Promoted and Maintained the WEBI Reports, also had modified the existing reports based on user requirements, also solved any issues/errors encountered
- Responsibilities required acting as the Key Person for maintaining Universe's with creation of joins, Cardinalities, Contexts, and solving the loops, Testing, Data analysis etc.
- Have resolved loops, Fan Traps and Chasm traps using context and alias and have built custom hierarchies and predefined filters to facilitate easy drill down and addressed performance issues.
- Created reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Alerter and Formulae etc. using Web intelligence.
- Scheduling daily, weekly and monthly reports using BO XI Scheduler using Events, creating Calendars. Upgraded BO XI R2 to BO XI R 3.0 Enterprise Environment.
- Used Polestar for better interaction with predefined data sets to generate quick visualized reports
- Extensively used Calculations, Variables, break points, and Sorted inputs, drill down, Slice and Dice, Alerts etc. in Creating Reports, formatted old reports, generated charts, bars etc. as per user requirements using Crystal Reports 2008, Xcelsius 2008 and integration as well.
- Designed interactive Dashboards such as Popup, Tabs etc. and many creatively styled Xcelsius Reports to best support needs using effective HCI Principles.
- Manipulating data through various presentation styles using Crystal Reports 2008 such as charts cross tabs, slice and dice, user response, alerts, prompts, nested loops and filters.
Environment: Business Objects, Crystal reports, WebI, Designer, Oracle 8i/9i, PL/SQL, Windows.
Confidential
Business Objects Developer
Responsibilities:
- Created balance sheets- Monthly and Quarterly Breakdowns, Profit & Loss reports for financial accounting needs.
- Created data sources using generic and application specific extraction (LIS) for SD and MM modules and loaded the business content.
- Participated on teams and projects to understand business needs, recommended solutions, and provided support on the evolving BO environment.
- Created canned and Ad-hoc reports using WebI/ DeskI/ Crystal Reports.
- Extensively Worked on Tables, Charts, Formulas & Variables, Prompts in WEBI.
- Created different types of reports like Master/Detail, Cross Tab, Chart and Ad hoc Reports using End User module in Business Objects.
- Created and managed Universes of different sources and linking them in the Designer.
- Extensively used Calculations, Variables, break points, Sorted inputs, drill down, Slice and Dice, Alerts etc. in Creating Reports, formatted old reports, generated charts, bars etc. as per user requirements using Crystal Reports XI.
- Worked on tickets and tasks such as load monitoring issues, user issues and enhancements of existing objects.
- Ensured a high-quality solution for all the delivered objects to the client within the schedule.
- Performed end user training sessions in reporting scenarios, and documentation.
Environment: Business Objects XI R2, Crystal Reports XI, Xcelsius 4.5, WebI, DeskI, SQL Server 2005
Confidential
BO Developer
Responsibilities:
- Work included Developing, Testing and enhancing existingBusiness Objects Universes.
- Developed, Tested, Promoted and Maintained the WEBI Reports, also had modified the existing reports based on user requirements,also solved any issues/errors encountered.
- Responsibilities required acting as the Key Person for maintainingUniverse's with creation of joins, Cardinalities, Contexts, and solving the loops, Testing, Data analysis etc.
- Have resolvedloops, Fan Traps and Chasm trapsusing context and alias and built custom hierarchies and predefined filters to facilitate easy drill down and addressed performance issues.
- UsedPolestarfor better interaction with predefined data sets to generate visualized reports.
- Extensively usedCalculations, Variables, break points, Sorted inputs, drill down, Slice and Dice, Alerts etc.inCreating Reports, formatted old reports, generated charts, bars etc. as per user requirements usingCrystal Reports XI, Crystal Xcelsius 4.5.
Environment: Business Objects XI R2, Xcelsius 4.5, Crystal Reports XI, WebI, DeskI, SQL Server 2005.