Sap Business Objects Analyst/developer Resume
North Hollywood, CA
SUMMARY
- Over 8 years of total experience in Information Technology Industry with 7 plus years of expertise in developing SAP Business Objects 4.0/XI3.1/XIR2 reporting applications along with knowledge in ETL SAP BO Data Services and SAP BW System.
- Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/XP/98.
- Worked on the latest version of SAP Business Objects Enterprise (Information Design Tool, Dashboard Designer, Web Intelligence, Crystal Reports Enterprise, Explorer) on Business Objects BI Platform 4.0.
- Developed front - end queries and reports using BEx Analyzer, BW Infoproviders.
- Experience in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable
- Experienced in creating interactive dashboards using Xcelsius / Dashboard Designer by importing data files to create the visualization utilizing QA AWS.
- Creating full-fledged WEBI reports, building combined and complex queries, applying query filters and report filters, ranking, graphical presentation, merge dimension, drill down queries and reports, activating alerts.
- Worked with Crystal Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based reports, drilling reports, analysis reports and data reports.
- Data Services: Data Migration using Baseline Jobs for Master tables - Customer Master, Material Master, Vendor Master, and Sales Order with IDOC Targets. Experienced working with source and target CDC (Change Data Capture) type 1, type 2, type 3 and implementing the SCD (Slowly Changing Dimension).
- Expertise in Universe designing, developing and generating complex, Ad hoc, dashboard Reports, List of values along with User Acceptance Test and data accuracy test.
- Expert in tuning the performance of SQL queries and ETL process
- An enthusiastic and project-oriented team player with solid communication and ability to develop creative solutions for challenging client needs.
TECHNICAL SKILLS
Business Intelligence and OLAP Tools: SAP Business Objects 4.0, Xi3.1, Xir2, UDT, IDT, Designer, CMC, Import Wizard, Crystal Report 2008/2011,, Web Intelligence, Desktop intelligence, Dashboard Manager, Performance Manager, QAAWS, Xcelsius and Live Office
ETL Tools: BO, Xi3.2, Xir2 Data Integrator, Informatica Power Center 8.1.1, 7.1, Designer, Workflow Manager, and Workflow Monitor, Power Connect, and Power Analyzer, DTS, PL/SQL
Operating Systems: Windows 95 - 2000/NT/XP/2003 Server, Unix, AIX, Linux, Tomcat Apache
Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008,DB2, PL/SQL
PROFESSIONAL EXPERIENCE
Confidential, North Hollywood, CA
SAP Business Objects Analyst/Developer
Responsibilities:
- Created Universes for report generation using SAP BOBI 4.0 Information Design Tool module Design, build and publish a set of webi reports and SAP BOBI 4.0 dashboard with interactive analytical capabilities
- Designed and built new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections
- Extract data from SAP BW/BexQuery for SAP BOBI 4.0 multi source Universe/IDT.
- Extract, Transformed and Load data from multiple data sources by SAP Data Service 4.0 ETL Tool
- Developed financial dashboards for high level reporting needs using QAAWS and also by MS Excel for local reference.
- Created OLAP connection in IDT (Information Design Tool) to build WEBI reports on top of BEX Queries through BICS.
- Built complex WEBI reports by combining 3 OLAP universes using Merged Dimension.
- Exclusively worked on WEBI by using variable calculations, merged dimension, sections, Input Controls, Rankings, Query filters as well as Table filter functionalities.
- Built Cross Table, Column and Stacked Charts according to functional requirement provided by business users.
- Mockup designs helped users visually see screens and functionality while gathering requirements.
- Written Functional Design Document for WEBI and Dashboard requirements.
- Evaluated different approaches for implementing Dashboards.
- Created report filters in the UDT (Universe Design Tool) to improve WEBI report performance.
- Generated BO exclusive reports in BEx Query Designer using filters, calculated key figures, and restricted key figures.
- Created Objects and classes in Universe which intern used in WebI Reports.
- Created new WEBI reports showing the data in different views like graphical representation, product wise, monthly and weekly.
- Created row level security based on user requirements.
- Created different types of reports Like Master/Detail, Cross Tab and Chart.
- Created Alerter, Filters, Ranking and Inserted Breaks in designing reports.
- Used Prompts & Nested Prompts to make the reports confined to a particular case as per the business Requirement.
- Developed Complex formulae and running totals for business measure calculations as per requirements
- Defined User Hierarchies so that report users can Drill from Summary report to Detail report
- Developed Standards Documents, Creation and Maintenance of Change Control Documents and User Guides
- Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount
- Skilled in Management of performance tuning activities to improve system performance
- Applied sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks
Environment: SAP Business Objects BI 4.0, XI3.1, CMC, Information Design Tool, BI Launch Pad/InfoView, Web Intelligence, SAP BOBI 4.0 Dashboard, SAP Data Service 4.0, Crystal Reports, SAP BW 7.3, Oracle 10G
Confidential, Burbank, CA
SAP Business Objects Developer
Responsibilities:
- Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
- Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections from Teradata/Oracle Data sources.
- Designed and deployed Xcelsius 2008 Dashboard solutions on Dashboard Builder along with Webi reports
- Design, build and publish a set of webi reports and Xcelsius 2008 dashboard with interactive analytical capabilities
- Developed WEBI reports for accounting department.
- ProgrammedQAAWSlinks from dashboard for additional functionality.
- Created Dashboard Chart and Container Selectors using theXcelsius components.
- Extensively involved in the complete implementation of Xcelsius Dashboards 2008.
- Created Xcelsius Dashboards using Live office plugins in MS Excel and Trained end users on the usage of Live office.
- Developed and designed Xcelsius dashboards for end customers and provided support.
- Used Single and Multi selectors, stacked charts, combination chats, Dual sliders etc in developing the dashboard.
- Worked on creating Attribute Views, Analytic Views & Calculation Views.
- Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs
- Designed Data Services jobs for loading data from different sources and also used Data Quality tool for Quality data before extracting data from sources.
- Extracted data from different source systems like Oracle, SQL server, flat files and loaded into the warehouse.
- Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
- Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements
- Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
- Developed universe user documentation guide for the end users reference
- Provided training for end users for generating their own report including complicated report.
Environment: SAP Business Objects Enterprise BI 4.0/3.1, XIR3 (Dashboard Designer, IDT, Universe Designer, Web Intelligence, Info view, BI Launch Pad, Crystal Reports Enterprise), BO Data Services 4.0, Oracle 10g.
Confidential, Stamford, CT
SAP Business Objects Developer
Responsibilities:
- Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution
- Created Universes for report generation using Designer module in Business Objects
- Designed and built new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections
- As a part of Universe development, created classes, different kinds of objects, cardinalities, strategies, resolved the loops using aliases and contexts
- Customizing existing Crystal reports for presentations using cross tab reports, sub reports, running totals, sorting and alerting
- Design, build and publish a set of webi reports and Xcelsius 2008 dashboard with interactive analytical capabilities
- Developed and maintained Key management Crystal reports like Key performance reports and Key indicator Reports.
- Installed the Repository, created users and assigned profiles
- Developed Standards Documents, Creation and Maintenance of Change Control Documents and User Guides
- Tested the Universe model for integrity and user acceptance
- Designed and implemented summarized Universe for easier and faster Reporting
- Checked the integrity of the Universes
- Analyzed the requirement for Reports and performing feasibility study
- Created advanced reports with “if then else syntax,” calculation context, user defined objects, character strings functions combined queries and sub queries.
- Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount
- Skilled in Management of performance tuning activities to improve system performance
- Generated reports with Business Objects Webi
- Applied sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks
- Publishing reports online for web users and creating access to reports online (via Info View) using Webi
- Migrating universes from the test domain to production domain
- Conduct the transfer of knowledge sessions, coaching and mentoring less experienced staff members
Environment: SAP Business Objects Xi, Universe Designer, Deski, Webi, Oracle9i, PL/SQL, and Windows NT/XP Windows NT, and Teradata
Confidential, Chester Brook, PA
Business Objects Analyst/Developer
Responsibilities:
- Identified client business analytical needs and translated them into business intelligence solutions
- Developed, managed, and tracked the Enterprise-wide Business Intelligence/Reporting initiative
- Implemented and Installed Business Objects
- Maintain the repositories for different environments like DEV, QA and PROD
- Created reports using queries, slice and dice, drill down, @functions, cross tab, master detail, formulas, merge dimension, alerts, calculation context
- Designed Universe from scratch, migrating to different environments, designed WebI documents and maintaining them on Business Objects
- Design, build and publish a set of webi reports
- Analyzed Existing Universe and Database to enhance the existing Universe and Create new Universe Imported existing Universe to modified Resolved Loops in Universe by creating Aliases and Contexts.
- Checked Universe for integrity and exported to repository to make it available for user groups
- Provided business intelligence and data warehousing solutions.
- Assisted clients in managing project scope, risk, resources and budget.
- Responsible for the management, administration and coordination of the BOBJ reporting environment
- Developed universe user documentation guide for the end users reference.
- Provided training for end users for generating their own report including complicated report
Environment: SAP Business Objects Enterprise 6.5 Web Intelligence, Universe Design, Info View, SAP CRM, SAP BW 3.0, 3.5, BI 7.0,DB2, Oracle 10 g, PL/SQL, Toad, ER Win, Microsoft Visio
Confidential
ETL Developer
Responsibilities:
- Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
- Used Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis.
- Developed ETL jobs as per business rules using ETL design document
- Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
- Used DataStage maps to load data from Source to target.
- Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs.
- Imported the data residing in the host systems into the data mart developed in Oracle 10g.
- Wrote complex SQL queries using joins, sub queries and correlated sub queries
- Performed Unit testing and System Integration testing by developing and documenting test cases in Quality Center.
- Validated the report generated using Business Objects using PL/SQL queries.
- Worked on troubleshooting, performance tuning and performances monitoring for enhancement of DataStage jobs and builds across Dev, QA and PROD environments.
Environment: Data WareHouse Tools, Oracle 10g, SQL, PL/SQL, UNIX, SQL*Loader, Autosys, Business Objects 6.1, Windows 2003, IBM AIX 5.2/5.1, HP Mercury Quality Center 9.0
Confidential
ETL/Crystal Reports Developer
Responsibilities:
- Studied the existing data sources with a view to know whether they support the required reporting and generated change data capture request.
- Used Quality Stage to check the data quality of the source system prior to ETL process.
- Worked closely with DBA's to develop dimensional model using Erwin and created the physical model using Forward Engineering.
- Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.
- Imported table/file definitions into the DataStage repository.
- Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
- Used various @Functions like @Prompt, @Where (For creating conditional filters) and @Select and @Variable.
- Formulated project plan outlining scope, requirements and steps required to develop Crystal reports within specific timelines
- Worked with Crystal Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based reports, drilling reports, analysis reports, data reports.
- Controlled jobs execution using sequencer, used notification activity to send email alerts.
- Used Aggregator stages to sum the key performance indicators used in decision support systems.
- Scheduled job runs using DataStage director, and used DataStage director for debugging and testing.
- Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
- Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis.
Environment: Data Warehouse Tools, Quality Stage, Flat files, Crystal Reports, Oracle10g, SQL Server -2005/2008, Erwin 4.2, PL/SQL, UNIX, Windows NT/XP