SUMMARY

• 4.5 years of IT experience in SAP Business Objects 4.0/XI 3.1/XIR2/6.5(Universe Designer, Info View, Web Intelligence, Desktop Intelligence, Webi Rich Client, Import Wizard, Report Conversion Tool, CMC/Supervisor, Auditor and Broadcast Agent).
• 1+ Years of experience in Crystal Reports, Creating/modifying detail and summary reports using features such as cross - tab, sub reports, complex formula objects, parameter values etc.,
• 1+ Years of experience in Xcelsius 2008, Creating dashboards using Combo Box, List Box, Dynamic Visibility, What-if presentation, Slider, Filtered rows and Alerts.
• Good Knowledge in SAP Business Objects 4.0(Interactive Analysis, Dashboard Design Tool, Information Design Tool, Upgrade Management Tool) and BO Explorer.
• Experience working in various industry sectors such as Health care, Retail, Insurance, Financial and Banking Business.
• Involved in various stages of project life cycle such as Design, Development, Implementation, Testing and Maintenance.
• Expertise in creating and linking complex universes using Joins, conditions, Filters, LOV, cardinality, Aliases, Contexts, Index Awareness, @Prompts, @Aggregate Awareness.
• Expertise in developing complex reports using multiple data providers, employing functionalities like Merge Dimension, Prompts, Slice and Dice, Drill down, Variables, Functions and Filter.
• Experience in Migration of Business Objects from 6.5 to XIR2 and XiR2 to XI 3.1
• Extensive knowledge in Data Warehousing concepts and Dimensional data modeling, Star Schema, Snow-Flake Schema, Normalization/Denormalization, Physical and Logical modeling.
• Extensive experience in working with Relational databases such as Oracle, SQL Server, and Teradata.
• Coordinated with ETL teams to identify the source systems and extract data.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team.

TECHNICAL SKILLS

Business Intelligence Tools: SAP Business Objects 4.0/XI 3.1/XIR2/6.5 (Designer, Deski, Webi, Webi Rich Client, Import Wizard, CMC, Auditor, ZABO and Broadcast Agent), Crystal reports 2008, Xcelsius dashboards, Qaaws, and Live Office

Databases: Oracle 8i/9i/10g/11g, SQL Server 2005/2008, Teradata, DB2, MS Access, TOAD, SQL Developer.

ETL: Data Integrator, Data Services 4.0/3.2, Informatica Power centre 7.x/6.x

Bug Tracking Tools: HP-QC/Remedy / Bugzilla/ SunGard

Languages: SQL, PL/SQL, HTML, XML

Data Modeling: ERWIN 7.0/4.0, Visio

Operating Systems: Windows 7/NT/XP/2003/2008, UNIX, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Business Objects Developer/Administrator

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements for universe, reports and dashboards.
• Created sales and operation universe from scratch as a part of decision-making system in data warehouse environment.
• Modified BO Universe by integrating new additional data elements used for both Adhoc Reporting and Standard Reporting.
• Coordinated with BO Admin for migrating universes and reports from development to test to production and validated after that.
• Extensively used Universe features like @functions including @Aggregate awareness and Derived Tables.
• Build Ad-hoc reports using a native SQL and extracted data based on users request and assisted them further with the data related questions.
• Performed fit gap analysis. Worked with the DBA to create aggregate tables and materialized views to improve the performance of the query by cutting down on the size of the result set at the data provider level.
• Diagnosed, investigated, analysed and resolved issues regarding application and end user support.
• Extensively used QaaWS (Query as a Web Service) and Live Office to retrieve the data from the universe objects and build dashboard on top of them.
• Extensively used Open Document functionality to seamlessly pass prompt values from summary report to detail report.
• Provided training to power users and end users.
• Involved in a POC for testing the new functionalities offered by SAP BI 4.0 in a Sandbox environment.
• Documented all the changes made to the Universes and Reports for future references.
• Involved in performance tuning and optimization of Business objects reports.
• Created backup of repository on regular basis using Import Wizard.
• Implemented row-level security using Designer and Application, object-level security using CMC

Environment: SAP BusinessObjects (SAP BOBJ) Enterprise XI 3.1 SP4/ SAP BusinessObjects Business Intelligence 4.0, BI Launch Pad (Info View), Web Intelligence, Desktop Intelligence,, Live Office, Xcelsius 2008 SP3, SAP BusinessObjects Dashboards 4.0, Import Wizard, Oracle 10g, Toad, SQL,PL/SQL.

Confidential, NJ

SAP BO Developer/Administrator

Responsibilities:

• Involved in constant Requirements gathering and business needs with executives and traders for Dashboard design and development.
• Lead a team of 4 developers and 3 BA’s for business Objects implementation.
• Converted Reporting business requirements in to Functional design and Technical design documents for Developers and testers.
• Working along with DBA/s, BA’s and Data modelers for data design and report design.
• Involved and designed the Enterprise level data security, report security level set up folder structure and User group access.
• Created Unit Test cases for Unit testing, UA testing and System testing.
• Administered user privileges, access, training and implementation for SAP BO XI R3.1.
• Worked along with QA team to get the SIT and UAT process to be complete align with Unit Testing and perform code reviews.
• Upgraded the Medicare XI R2 environment on to XI R3.1 environment.
• Created multiple Universes specific to Medicare and Providers subject area.
• Implemented user friendly universes for users to create Ad hoc reports.
• Implemented aggregated data for Xcelsius dashboards and exported Xcelsius to BO environment (Info view).
• Xcelsius dashboards include drill down from reports, Combination charts, and Goal declaration.
• Created Executive dashboards with Drill, Drop down, details, Linking to BO Reports, Tabbed and also with Open doc statement.
• Implemented high data intensive reports using Crystal Reports against Crystal enterprise Business views.
• Interacted with Informatica ETL team for issues related to dataflow.
• Created hands on 40 + interactive reports
• Working on Post Production scripts to deploy Reports, Dashboards and Universes.
• Implemented in total of 45 scheduled and daily reports developed using Crystal reports and Desktop intelligence based.
• Implemented live office via QAAWS to generate reports against MS products.
• Created Technical Support documentation for Reports and universes.
• Implemented and trained Developers as well as users on new BI standards.
• Created BIAR backup of repository on regular basis using Import Wizard.
• Used Import wizard extensively to promote Universes and reports between environments.
• Monitored system usage, trace & application logs of reporting servers regularly for bottlenecks.
• Designed & Implemented security model architecture.
• Designed and managed groups and users using CMC and assigned them universes and documents specific to their Folders.

Environment: SAP Business Objects XI R3.1 (Web I/ Desk I), SAP BO XI R2, BO DI, Business Objects V6.5, Crystal Reports 11.5, .Net, Business views, Info Cubes, Xcelsius 2008, Performance Manager, Dashboard Manager, Project Management and SQL Server 2005, SAP BI/BW 7.0, Pl/SQL, IBM DB2.

Confidential, Columbus, OH

Business Objects Developer

Responsibilities:

• Involved in Full life cycle design and development of Business Objects reporting Applications.
• Designed and developed various Universes by defining classes, objects, and defined Joins, Cardinalities between tables.
• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, @Functions and more.
• Analyzed the business requirements and worked with different application teams to develop various inventory and supply chain reports.
• Developed Master/Detail and company trending analysis reports using bar graphs and used Drill Filters for drilling down on graphs and tables to display data at various organizational levels.
• Extensively used Alerts, Variables, Prompts, and also generated hyperlink reports using Webi XI R2.
• Migrated Business Objects 6.5 to Business Objects XIR2.
• Developed accounting reports based on the requirements, which involved complex calculations and use of calculation contexts.
• Developed various complex reports which involved use of combined queries and sub queries from multiple data providers.
• Created various summary reports that involved use of formulas, Grouping, Parameters, and Selection Criteria to handle the customer’s request from Tables, Stored procedures, Views and Command objects using Crystal Reports.
• Used personal data file data providers along with RDBMS data providers.
• Prepared Unit test cases using Quality Center and developed detail design documents for each report.
• Resolved number of defects discovered during System/UAT testing.
• Worked with Support team to complete design/code review.

Environment: BO XIR2/6.5, Designer, Web Intelligence, Desktop Intelligence, Info View, Import Wizard, Crystal Reports 2008, Data Integrator, Oracle 9i, Teradata, PL/SQL, UNIX, Windows 2000/XP.

Confidential, MN

Business Analyst

Responsibilities:

• Used advanced-level data analysis to support standard business offerings, identify, track and resolve client data issues to meet the needs of internal business customers and external clients.
• Worked in partnership with Project Team, Functional Team Leads and functional end-users to identify and document business process improvement opportunities and complete the definition of requirements for system design, implementation & training.
• Trained users to understand use cases and methodology.
• Introduced RUP to current working environment.
• Created Use Cases, Activity diagrams and State diagrams.
• Constructed, and maintained UML model using Rational Rose and created use case and design-specific diagrams.
• Designed workflow to understand flow of data from one level to other.
• Used the MS Office Suite, which includes MS Excel, MS Access, MS Word and MS Visio.
• Prepared Business model document (BMD) and Business requirement document (BRD).
• Followed Iterative process.
• Used the Office Suite extensively which included MS Word, MS Excel, MS Access, MS Project, MS Visio for various documentation and analysis reports.

Environment: MS Visio, MS Project, MSWord, MS Excel, RUP and Oracle.