Sap Business Objects Developer Resume
TX
Summary
- Over 7+ years of experience in Business Intelligence using SAP Business Objects4.0,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.
- Exclusive Experience in SAP BW connectivity with Universe Designer and Business objects Infoview using the SAP Integration Kit
- 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.
- CompleteSoftware 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 4.0, 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, Clarity, Epic.
Education
Bachelors in Computer Science
Professional ExperienceSAP BOBJ Certified
Confidential, Houston, TX FEB 2012 - CURRENT
Role: - Business Objects Developer
Project Details:-Confidential, District is a fully integrated healthcare system which includes 14 community health centers, eight school-based clinics, a dental and dialysis center,mobile health units, a rehabilitation and specialty hospital and two full-service hospitals; Ben Taub General Hospital and Lyndon B. Johnson General Hospital. They had Epic as an eMar and Clarity as their primary reporting data warehouse. They implemented functional specific data marts on top of Clarity and had requirements of creating universe, webi reports and dashboards. I have extensively worked on developing their provider incentive scorecard reporting and dashboard, which they use to track their provider performance across all facilities under their healthcare umbrella
Responsibilities:-
- Created two complex dashboards which uses live office to feed the data into xcelsius from the source webi reports
- Developed Provider scorecard reports using Webias the reporting tool
- Developed complex webiCore Measures Scorecard report which is used by the organization to track various core measures of the hospitals by month, quarter, year against the benchmarks
- Developed a complex provider scorecard dashboardwith multiple tabs using dynamic visibility. This dashboard shows the high level information of rolling 12 months of provider performance data varying across different areas like productivity, machine utilization, compliance and quality. The dashboard also has the capability of drilling down to the detail data on to the detail webi reports
- Re-Developed an existing dashboard which shows the high-level rolling 12 month information of patient medication administration. This dashboard also had drill down capabilities to get to the detail data by month and by facility.
- Worked on optimizing the performance of the dashboards. Reduced the dashboard loading time by scheduling the backed source webi reports for the live office and changing the live office refresh option to pick from the latest instance.
- Modified the existing universes for performance tuning and maintained common dimensions across all the universes with unique naming as a part of clean up activity
- Developed a complex provider scorecard universe which involved multiple fact tables. Created multiple contexts to resolve loops. Performed integrity checks and documented them
- Validated the source to target data for referral and medications scanning data marts.
- Created sql test scripts to validate the source to target data for the provider scorecard datamart.
- Created complex webi reports with multiple queries, custom sql, using complex fuctions, merging dimensions at report level, drill down, drill up, drill across, complex filters etc
- Worked on creating Webi reports as a part of the homeless project
- Created trending images and published them to the server images folder and used them in the webi reports to show trending of the data
- Formatted webi reports and scheduled them to be bursted as pdf to the report to web server.
- Created information spaces in business objects explorer and performed indexing on them
- Worked on a different internal project Radiation Oncology software upgrade from Lantis to Mosaiq 2.3
- Worked on validating the canned crystal reports with the end user and customized some of canned reports and created new reports as a part of new user requests
- Created an user log crystal report with input optional prompts, to report all the fields which were required for the internal security compliance which were not there in the user log which was shipped with the application
- Involved in scheduling the crystal reports as object packages, creating the schedule events on test server using CMC
- Actively involved in knowledge sharing, documentation and troubleshooting any SAP business objects related problems
Environment :- SAP Business Objects XI 3.2, SAP BI/BO 4.0,Xcelsius 2008 sp4, Crystal Reports XI/2008, Web Intelligence, Report2Web, Business Explorer/Polestar, Oracle 10g/11g, MS Sql Server 2008, Sql Developer, Sql Server 2008 Management Studio, Clarity, Epic Hyperspace
Confidential, Plymouth, MN Oct 2011 - Jan 2012
Role:-Business Objects Developer/Admin
Project Details: -Confidential, a child company under the Omnicom Group is an advertising media agency, which acts as a liaison between the advertiser and the advertisee for ad publishing. They had very complex requirements in desinging and building universes, webi reports and dashboards various business needs.
Responsibilities:-
- Fulfilled the business objects development needs for various departments. And also performed the day to day admin tasks.
- 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.
- Handled various tickets for business objects issues for the end users.
- Performed Admin tasks like monitoring DB Services, monitoring BO server running with optimal performance, monitored licenses, monitoring of user activities/ sessions etc.
- Some daily admin tasks 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)
- 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 Bobj Administration tasks, to create new usersand groups, handle password resets and assignsecurity. 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
- Scheduled Webi reports and Hyperion reports based on the requirement.
- Moved the developed webi, crystal 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 Nov2010- Jul 2011
Role: - SAP BOBJ Developer/Admin
Project Details: -Confidential, manufacturer of the entire line of quality sleeping products. They have a very robust SAP infrastructure and had requirements dealing with SAP BOBJ to Build Universe, Reports, and Dashboards for various department needs.
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.
- Involved in establishing SAP BW connectivity with Universe Designer and Business objects Infoview, using SAP integration kit. And also installed java connector to import the roles of the SAP user to Business objects.
- Performed day to day admin tasks like monitoring DB Services, creation ofuser groups and handled password resets, monitoring of user activities/ sessions, universe connection and availability checks.
- 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, barsetc 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 Nov 2009 - Sep 2010
Role: - SAP BOBJ Developer
Project Details: - Confidential, is a content management company; I have worked extensively on developing their new product, Dynamic Open text vendor Invoice management Interactive Dashboard which is sold by old by SAP asSAP Invoice Management by OpenText. This Dashboard is to be used in around 114 countries around the world. One Single Dashboard dynamically adjusts to various requirements without any modifications.
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, Indexetc 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.
Confidential, Houston, TX Dec 2008 - July 2009
Role: - SAP BOBJ Developer
Project Details: -A top-tier oilfield service company, Baker Hughes delivers solutions that help oil and gas operators make the most of their reservoirs. Work included developing Universes, Dashboards, and Scorecards etc. Worked with Data services to move data from legacy systems and enforce quality and reduce redundancy.
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 Formulaeetc 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, barsetc 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 Feb 2007 - Dec 2008
Role: - SAP BOBJ Developer
Project Details: -Confidential, is the world's top financial institution. I was assigned to use SAP BW to extract data and build dashboards in Xcelsius, and build and modify existing reports and simultaneously create and design reports using SAP BOBJ.
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 fromSAP 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 May 2006 - Jan 2007
Role: -BOBJ Developer
Project Details: -Vertis Communications is a premier provider of targeted advertising and marketing solutions to America's leading retail and consumer services companies. Building and Updating Universe's and Reports based on requirements. Have Developed Monthly, Quarterly Reports as required by the Management.
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 Oct 2005 - Mar 2006
Role: -BOBJ Developer/Admin
Project Details: -Confidential, one of the top beverage and snacks manufacturers in the world. Work required maintaining, documenting, designing needs for various departments according to their requirements involving various Customer details, Groups etc. Designed, Updated Universes and also build reports utilizing various functionalities of Crystal reports. Maintained User Security, Publishing and Other Monitoring Duties as needed.
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 andFree-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 Decodefunctions,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 - Chennai, India April 2003 - Aug 2005
Role: -BOBJ Developer
Project Details: -Worked for Several Clients who needed a Semantic layer and easy platform to Query and get reports to answer several questions regarding their Business. So mainly set up roles, rights, built Universes, and designed reports to provide better interaction and better Data Visualization.
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/10with 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.