We provide IT Staff Augmentation Services!

Business Intelligence Analyst Resume

0/5 (Submit Your Rating)

Plymouth, MN

SUMMARY

  • Over 8+ years of experience in Business Intelligence using SAP Business Objects XI - R3.1/R2/6.x with Info view, Web Intelligence, Data Integrator & Quality, Webi Rich Client, Desktop Intelligence, Crystal Reports 9/10/XI/2008, Xcelsius 4.5/2008, Central Management Console (CMC), Central Management Server (CMS), Central Configuration Management (CCM), Query as a Web Service, Live Office, Business Explorer/Polestar XI 3.1, Publishing Wizard, Import Wizard and Report Conversion Tool.
  • Strong Knowledge and Experience in Business Objects tools & SAP Business Objects from 2003. Strong knowledge and Skill in Data Integrator & Data Quality Tools.
  • Excellent experience in designing Business Objects universes, complex BO reports both full client and Web Intelligence Reports.
  • Strong SAP ECC Knowledge in SAP ECC 6.0 (FICO,MM,PP,SCM,SD)
  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
  • Extensive experience on Prototyping the new technologies like Business Explorer/Polestar XI 3.1,
  • Used Live Office and QAAWS (Query as a Web Service) to feed live data into Xcelsius 2008 (both Dashboards & Scorecards).
  • Extensively worked on Business Objects Architecture & Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis. Debugging the Problems in the Crystal Reports.
  • Created reports from multiple sources & functionalities like slice & dice, drill down in Crystal Reports.
  • Extensive experience with SAP BW such as Info cubes, BEx Query designer, BEx Analyzer, Data Modeling.
  • Extensive knowledge in SQL, PL/SQL & T-SQL programming and trouble shooting
  • Extensively used ETL methodology for Data Extraction, transformations, loading using Data Integrator.
  • Strong organizational, time-management and planning skills to deliver projects on time/budget, despite intense pressure and aggressive timelines.
  • Good Knowledge of Data Warehouse Concepts including Schemas and Data Modeling.
  • Complete Software Development Life Cycle experience including requirements gathering, analysis/design, development and testing.
  • Excellent communication, interpersonal, training, analytical and technical skills.

TECHNICAL SKILLS

BI Tools: SAP Business Objects XI 3.1, R1/R2 6.5.x,Crystal Report 9/10/ XI/ 2008,Xcelcius 4.5/2008, Info view, CMC, CCM, CMS, BEx Query, BEx Analyzer, Desktop Intelligence XI, Full Client, Web Intelligence, Business View Manager, SAP ECC 6.0, SAP BI/BW 7.0, Live Office

ETL Tools: BO Data Integrator (ETL), Data Services

Platforms: Windows (all flavors), Debian Linux

Databases: SQL Server 2000/7.0/6.5 , Terawatt, Oracle 10g, 9i/ 8i, Access, DB2

Languages: C, Java, SQL, PL/ SQL, T-SQL, HTML/CSS

Products: SAP ECC 6.0/ BOBJ, SAP BI/BW 7.0, Microsoft Office, Erwin, Toad.

PROFESSIONAL EXPERIENCE

Confidential, Plymouth, MN

Business Intelligence Analyst

Responsibilities:

  • Fulfilled the business objects development needs for various departments.
  • Modified existing universes and implemented new universes according the reporting needs by detecting cardinalities, resolving traps and using contexts and also developed hierarchies and derived tables.
  • Developed complex webi reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement.
  • Performed some daily admin tasks which included verification of all BO user logins and security checks, Testing the availability of all universe connections, Monitoring day to day scheduled jobs on Broadcast Agent (BCA)
  • Handled various tickets for business objects issues for the end users.
  • Modified the default session timeout, for the infoview as the users complained about being session timeouts frequently.
  • Migrated some of the Hyperion reports to business objects, developed similar reports in webi
  • Edited the existing Hyperion Reports, to add new prompts for the reports by changing the front end scripts and sql queries.
  • Handled some Bobj Administration tasks, to create new users and groups and assingn security. Was involved in upgrading the service pack.
  • Created a stable environment for Business Objects XI 3.1 by scaling the number of processing servers based on the user base and access frequency.
  • Modified existing crystal reports and created new reports with cross tabs and sub reports based on the client requirements using Crystal Reports 2008.
  • Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate), complex report level filters and contexts and complex SQL queries and joins involving case statements, some analytic functions like partition by etc. Thus Considering best business Practices using Web intelligence Rich Client
  • Moved the developed reports and universes between development, QA and production environments using import wizard.
  • Was involved in training the end users over the newly developed crystal and webi reports.

Environment: -SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Crystal Reports 2008, Web Intelligence, SQL Server 2008/2005

Confidential, Lexington, KY

SAP BOBJ Developer

Responsibilities:

  • Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes meeting User Needs and Requirements from both technical and strategic views of an organization.
  • Conducted Study to Build Universe’s Classes and Objects involving everyday terms that supports Users. Object properties defining Measure, Dimension and Details were created.
  • Implemented Universes by detecting Cardinalities, resolving loops, Chasm Traps and Fan Traps using Contexts and Aliases etc, and also Developed Hierarchies to support users with the option to drill down on reports. Also implemented User Security.
  • Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate), complex SQL queries and joins. Thus Considering best business Practices using Web intelligence Rich Client.
  • Involved in creation of Reports, formatting reports, generation of charts, bars etc as per user requirements using Webi, Xcelsius 2008.
  • Developed new set of standard Web Intelligence reports against the new universe. Completed ad-hoc data requests as required.
  • Working with different transformations like Query, Key Generation, Pivot, Map operation, Table Comparison in Data Integrator.
  • Involved in writing scripts and also used some built-in functions like To Date, lookup, key generation and Custom Functions like checking whether the load is a initial load or a bulk load.
  • Creating complex Data flows with inner R/3 data flows and declaring parameters at different levels of Workflow.
  • Creation of different data stores to get SAP tables.
  • Used Business Objects Data Integrator XI R2 for ETL extraction, transformation and loading data from heterogeneous source system.
  • Worked on Polestar to generate complex reports for the data required. Simultaneously export reports and making it easily available to Decision makers.
  • Used BEx Analyzer and Query Designer to Query and analyze SAP BW OLAP Cubes.
  • Developed Dashboards using Xcelsius 2008 components using maps, Pie Charts, Staked Bar, List Views etc creatively using best Xcelsius components effects for better interaction.
  • Performed ETL activities using Data Integrator and Data Services, by extracting data from various Sources.
  • Design, develop, and implement Xcelsius dashboard against SAP BW data sources. Established the design pattern for all future Xcelsius development using Live Office and QaaWS as connectors
  • Developed Cross Tab Reports, Sub Reports by using Crystal Reports 2008 and embedded Xcelsius onto Crystal Reports for better results and also provide users with clear understanding.
  • Worked on certain issues and dealt with Info View, CMC.

Environment: -SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Crystal Reports 2008, Data Integrator & Services, Web Intelligence, Business Explorer (Polestar) XI 3.1, SAP BI/BW 7.0, T-SQL, Oracle PL/SQL, Info View, CMC.

Confidential, Philadelphia, PA

SAP BOBJ Developer

Responsibilities:

  • Build Xcelsius Dashboards using SAP Web services created from SAP NetWeaver. Without the need of any BOBJ Platform to import data into excel sheet to serve as the input for the dashboard.
  • Various SAP Functional Modules have been used as a source and ABAP programming to extract, aggregate and deliver the data to Xcelsius using SAP Web services.
  • Highly Interactive Dashboard completely based on dynamic user input and varying amount of information to analyze without limitations being provided to the user.
  • Various other forms of dashboard development also performed including Data from SAP BW through Bex Queries, Data from Universe using QAAWS, Data from Webi reports, Crystal Reports using Live Office etc.
  • Dashboards Using Advanced Multiple Drills Down, Dynamic Visibility, and Alert Features were designed to support Complex Requirement Scenario.
  • Designed dashboard using best practices and advanced filtering techniques to dynamically filter and serve as the source for the dashboard.
  • Optimized dashboard performance for speed of thought analysis even with large data volumes and simultaneously allowed user customization on the fly.
  • Worked Extensively with Flash Variables, web services and made Generic Dashboards to enhance Performance in Situation to Decrease Load on the Parent Dashboard, and Designed Child Dashboards to Distribute Load among Various Child Dashboards to Mitigate the Performance Issues
  • Used Complex excels functions and logics to support data requirement. Ex: - Vlookup, hlookup, choose, Nested IF’s, Value, ISNumber, ISNA, Match, Index etc to name a few.
  • Built Password Protected Dashboard and Created a Scenario to Trigger Multiple Web Services on User Authentication.
  • Built Many Static Dashboard Models during all my Work Requirement in due process to Create Generic Live Model Using Web Services, Flash Variables etc.
  • Done extensive testing across various scenarios to see the dashboard working across multiple complex and varying scenarios.
  • Used various Custom SAP functions exclusively for Xcelsius to help in this process to additionally implement thousand separators and decimal Operators to support various different number formats.

Environment: -SAP Business Objects XI 3.1/3.2,Xcelsius 2008 SP3, Excel Functions, SAP BI/BW, SAP Net weaver, Bex, Webi, Crystal, Universe, QAAWS.

Confidential, Houston, TX

SAP BOBJ Developer

Responsibilities:

  • Analyzing system functionality requirements, documents and scope of the work.
  • Work included Developing, Testingand enhancing existing Business Objects Universes; work required modifying, testing and promoting to the Repository.
  • Developed, Tested, Promoted andMaintained theWEBI 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 also 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 Java SDK’s.
  • Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
  • 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: -SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Crystal Reports 2008, Web Intelligence, Business Explorer (Polestar) XI 3.1, SAP BI/BW 7.0.

Confidential, Dallas, TX

SAP BOBJ Developer

Responsibilities:

  • Worked as a Business Analyst for requirement gathering for business and functional reporting.
  • Work included Universe Designing, Requirement Gathering, Setting up Joins, Cardinalities, and Solving Traps using Contexts and Aliases and Updating Universes based on additional Requirements etc Using Designer.
  • Developed Crystal Reports from SAP BW (Business Warehouse) using BEx Query as the extraction tool.
  • Created Crystal Reports with ole object extracting image file from the database and URL links.
  • Created custom formulas to display RGB colors in crystal reports.
  • Customized the formatting of the Crystal Report using formula’s at the section level.
  • Created formula’s for Crystal Reports 2008 and stored it on the Crystal Repository to be used across the organization. Created reports with dynamic grouping based on parameters.
  • Designed logic for Xcelcius 2008 dashboard in Microsoft Excel for Data Visualization.
  • Involved in using Job Server in creation of real time jobs. And also involved in Performance tuning at source, transformation, and target levels.
  • Creation of ETL Processes for the added new Subject areas, Develop Data Extraction, Transformation and Loading Program using Data Integrator.
  • Involved in Creation of jobs that specify data mappings and transformations by using Data Integrator Designer.
  • Used Data Integrator to load data from different sources (SQL, Text files) to the target database
  • Performed Unit, System and Regression testing of the Business Objects Data Integrator ETL jobs
  • Developed jobs using Business Objects Data Integrator XI designer to extract data from source databases and flat files into staging area
  • Created Jobs, Workflows, Transformations and Data Flows according to requirement to integrate source data in to Target data ware house
  • Analyzed various Data Warehouse Models like slowly changing models, Conceptual Models, Logical Models. Also Designed and developed Data Integrator scripts for data transformation.
  • Extracted data source for cube from SAP transactional system and flat files.
  • Created BEx queries for analysis of data using BEx analyzer as the tool.
  • Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc by using Chart expert of Crystal Reports.
  • Used and monitored Info View, CMC and also assigned Roles, and set User Groups and rules and according principles and also monitored security and other CMC controlled functions.
  • Developed Drill Downs report using Graphs in Crystal Reports 2008.

Environment: - Windows Server 2000/2003/XP, Universe, Crystal Reports 2008, Data Integrator, Xcelsius 2008, BEx Query designer& Analyzer, Info View, CMC, Oracle 10g, SQL Server 2005.

Confidential, Bellmawr, NJ

BOBJ Developer

Responsibilities:

  • Created finance, sales, retail reports using Crystal Report.
  • Collected requirements from business and functional user and transformed into design specification for other developers in the team.
  • Developed Existing Universes and added additional Links, Joins according to the requirement and sorted Loops, Traps.
  • Created Views, Stored Procedures, Queries and tables to create the reports.
  • Team lead for crystal development with responsibilities to set up the Crystal Server, Info view, reporting structure, role and rights.
  • Developed new reports using Crystal Reports XI and Oracle 10g as database.
  • Developed reports out of legacy database such as Microsoft Access.
  • Developed reports by joining more than one database such as SQL server, Oracle database.
  • Created dynamic and static parameter based report and scheduled it on the Crystal Server.
  • Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc by using Chart expert of Crystal Reports XI.
  • Created company specific formula and used Crystal repository to store generalized formulas for reusability. Also Used Stored Procedure to generate reports.
  • Developed Cross Tab Reports, Sub Reports by using Crystal Reports version XI.
  • Used Data Integrator in ETL activities. Working with different transformations like Query, Key Generation, Pivot, Map operation, Table Comparison in Data Integrator.
  • Creation of different data stores to get SAP tables, Developed jobs using Business Objects Data Integrator XI designer to extract data from source databases and flat files into oracle staging area. Performed Unit, System and Regression testing of the Business Objects Data Integrator ETL jobs.
  • Created On-Demand Sub reports and Hierarchical Grouping.
  • Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD for user.
  • Passed parameters dynamically to Crystal Report in .net application at runtime.
  • Developed Drill Downs report using Graphs in Crystal.
  • Trained all the Users of the Reports on using Info view and exporting reports to various formats.
  • Tested the reports in for quality and end user validation to match the amount and quantities figures against the transactional system.
  • Developed Crystal OLAP reports using Microsoft Analysis service as the Data Warehouse.
  • Developed Dashboards using Crystal Xcelsius.

Environment: - Windows Server 2000/2003/XP, Data Integrator, Designer, Crystal Xcelsius, Crystal XI, Data Integrator, Oracle 10g, SQL Server 2005, Microsoft Access.

Confidential, Dallas, TX

BOBJ Developer

Responsibilities:

  • Creating, developing, maintaining and testing the Universe for running the queries against the Database using Designer.
  • Involved in Installation and Configuration of all products of Business Objects 6.5.
  • Analyzed the existing database and designed Universes using Designer module for generating reports.
  • Used various data providers like Freehand SQL and Stored Procedures to extract data from different sources and tuned for better performance.
  • Resolved loops by creating Aliases & Contexts and checked integrity of universes.
  • Exported universes to the repository to making resources available to the users.
  • Created reports using the Universes and Free-hand SQL as data providers.
  • Involved in development and deployment of Complex Reports.
  • Exported the Reports to the Broadcast Agent and used the Broadcast Agent server to Schedule and Monitor the Reports which offered robust performance and ability to balance Loads.
  • Generated analytical reports using Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
  • Automated document Scheduling, Publishing and Distribution for Webi and Info View clients using Broadcast Agent server.
  • Used Supervisor to Grant User rights and roles etc.
  • Involved in optimizing the universe developing time and SQL Tuning to increase the query performance.
  • Used Designer as a part of Universe Development for Defining the Parameters of Universe, Inserting the table, making Joins, Resolving Loop's, Creating Classes, and Objects.
  • Involved in creation of Filters, prompts and setup Hierarchies for Multidimensional Analysis.
  • Created the Reports using the Universes as the main Data providers and wrote complex queries including Sub Queries, Case and Decode functions, using Crystal reports XI.

Environment: - Business Objects 6.5, Designer, Webi, Full-client, broadcast Agent, Supervisor, Crystal reports XI, Oracle9i, PL/SQL, and Windows NT/XP.

Confidential

BOBJ Developer

Responsibilities:

  • Created & Modified Universes for various functional areas of high level reports group using Designer.
  • Customized LOVs in Universes for quicker performance of reports.
  • Created Joins, Contexts, and Aliases for resolving Loops & Universe Tuning and checked the Integrity of the Universes.
  • Used SQL against the database to check data retrieved.
  • Changed the universe parameter settings to optimize the performance of universe.
  • According to the customer information created complex report using Universe as main data provider.
  • Exported the universes to the Repository making resources available to the users.
  • Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Custom sorts, Cross Tab, and Formulae's etc.
  • Created reports according to different requirements Such as Summary Charts etc Using Wizards and Web intelligence2.x.
  • Exported the Reports to the Broadcast Agent and used the Broadcast Agent server to Schedule and Monitor the Reports.
  • Used Supervisor, Info View to manage Users etc.
  • Various Programming tasks included developing Reports using free hand PL-SQL, and T-SQL procedures.
  • Created reports using Crystal Reports 9/10 with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
  • Created various analytical reports like Market Share, Trending, Rank reports from multiple data providers. Interacted with the various users for reporting requirements.
  • Provided end user support and problem resolution for various issues related to BO.
  • Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.

Environment: - Business Objects (Designer, Reporter) 6.1, Supervisor, Broadcast Agent, Crystal Reports, Oracle 9i, PL/SQL, T-SQL, Web intelligence2.x.

We'd love your feedback!