PROFESSIONAL SUMMARY:

• Dynamic, result oriented Technical design developer with 7+ years of experience as a Business Analyst and developer with Business Intelligence Reporting and Data Warehousing in IT industry.
• Worked on full life cycle of the project including requirements gathering, prototyping, Effort estimate, Impact analysis, development, UAT, Production and Postproduction support.
• Experience in identification of Business and Data requirements and converting them into conceptual and data models.
• Excellent communication and interpersonal skills. Ability to work TEMPeffectively while working as a team member as well as individually and above all a positive attitude to shoulder successfully, any responsibility or challenges.
• Expertise in all modules of Business objects suite SAP BO 4.1/4.0/ 5i/6i/XiR1/XIR2/XIR3/XIR4 (BO Reporter, Designer, WebI, Info view, Broadcast Agent, Central Management Console).
• Trained SAP Business Objects end users in Business Objects reporting features.
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure by creating Users/Groups/Sub - groups & assigning the privileges.
• Gathered, analyzed and documented business requirements, clarifying business rules and data design requirements, functional requirements and data specifications for business Objects Universes and Reports.
• Worked with End-To-End implementation with Data warehousing team and Strong understanding of Data warehouse concepts Star Schema, Snowflake Schema and Multi-Dimensional Models.
• Experience in designing and developing the universes (business view of the database), developing complex/canned/ad-hoc reports, scheduling the processes using and administering the BO activities
• Strong background in Oracle RDBMS, Data Warehousing, Data Modeling, and Reporting.
• Knowledge on new features of SAP Business Objects XI R2/R3/R4 and 6i including Derived tables, Central Management Console, Index awareness, Live Office, Encyclopedia, Discussions
• Created a SAP Business Objects User’s power point presentation for an introduction to first time users and also as a handy guide.
• Created new objects in the Universe based on the report creation requirements
• Experience in SAP Design studio for developing report using Xcelsius to create interactive dashboards by using SAP.
• Worked on Tableau for data analysis.
• Complete project life cycle (SDLC) experience on various projects.
• Good communication skills, strong decision making skills, organizational skills, and customer service oriented. Excellent analytical and problem solving skills.
• Sound noledge of SAP Lumira.
• Designed and developed custom DataSources, Info Sources, Extractors, Info Cubes and DSO'S to fulfill user requirements.
• Expert in designing data sources for LO- extraction, generic extraction, Data loading (ETL process) based on business requirements.

TECHNICAL SKILLS:

SAP Skills: SAP Business Objects XI 3.x; 4.x, SAP BW NetWeaver 04s 7.x, Extended Star-Schema Modeling, SAP Business Objects Integration kit. BPC 10.

Reporting tools: SAP BEx Analyzer, SAP BEx Query Designer, Enterprise Portal, Crystal reports, Web Intelligence, Xcelsius/Dashboard Designer, Analysis for OLAP, Business Explorer.

Operating systems: Ms-Windows, Unix, Linux, Solaris

Languages: C, C++, HTML, XML, Java script

Database: M SQL Server 6.5/7.0/2000/2, Oracle 12c, 11g, 10g/9i/MySQL, MS Access 2010/2013

PROFESSIONAL EXPERIENCE:

Confidential, Dearborn, MI

Senior SAP Business Objects Developer

Responsibilities:

• Involved in Business meeting with the Business users for requirements gathering, business analysis and making technical specifications for the reports.
• Worked with Functional Managers / BA’s / End Users to gather reporting requirements to implement business logic for successfully implementation of reporting system to satisfy the needs of Business Units.
• Designed Mock up of the reports and presented to users.
• Created APS Dashboard, APS Process Monitor reports.
• Designing, Developing and supporting SAP BusinessObjects reports using SAP Design studio (Xcelsius Dashboards, Advanced analysis) based on SAP BW (BICS),
• Created joins and implemented Aggregate awareness in the APS Operational View and APS Reporting View universe.
• Created and involved in Most of the views and MT tables which we have used in the universe and reports.
• Involved in performance tuning and optimization on business objects universes by creating aggregate tables.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Extensively worked on creating contexts for the Universe based upon the Business Flow.
• Developed Hierarchies to support drill down reports.
• Created Cascading prompts in the universe as per the user requirements.
• Customized LOV’s(List of Values) as per the user requirement.
• Performed Integrity testing of Universes(Universe Structure checking, Objects Parsing, Join Parsing, Conditions Parsing, Cardinalities checking, Loop checking and Contexts checking) after any modifications to them in terms of structures, classes and objects.
• Exported the universes to the Repository to make resources available to the users.
• Updated and maintained existing universes based on changing user requirements and changes in data source.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Created hyperlink WEBI reports using open doc function and created some drill down and drill up reports.
• Detected loops in the universe and resolved the loops by creating Aliases and Contexts and checked the Integrity of the Universes.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Generated various numbers of reports on a daily, weekly and monthly basis using Business Objects Report module.
• Worked with testing team in validating various reports.
• Managed all phases of the application testing process, including specifying testing requirements, planning tests, executing tests, and tracking defects through Mercury Quality Center application.
• Migrated the reports from DEV to SIT and DEV to UAT using Import Wizard.
• Generated report using Tableau workbook design.
• Involved in Tableau server installation.
• Used PL SQL for triggers and scripting
• Formatting the Reports based on the Users requirements using the functionalities in Business objects like Drill Down, Alerters, User response, @Functions.
• Scheduling the reports through CMC and WEBI level by refreshing and sending to the in box/corporate documents
• Involved in training end users located all over globe in basic and advanced adhoc reporting.
• Worked on SAP Lumira to generate the reports related to sales and inventory.
• Tested and validated universes for sales and inventory by using unit testing

Environment: SAP Business Objects 4.1/4.0, Desktop Intelligence, Web Intelligence, Designer, Import Wizard, Central Management Console, Oracle, Tableau, SAP Lumira.

Confidential, Lackforest, IL

SAP Business Objects Developer

Responsibilities:

• Involved in Business meeting with the Business users for requirements gathering, business analysis and making technical specifications for the reports.
• Responsible for analysis of the systems, meeting with end users and business units in order to define the requirements.
• Created Business Review and Retail Business Review consolidated reports.
• Developed ‘Retail Business Review’ and Reports.
• Created multiple data providers for consolidation of various category reports.
• Created complex variables and reports.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Created WebI reports with more than 10 data providers and synchronized the data using the merge dimensions option.
• Created crosstabs, Charts for various presentations as per requirements. Tested scripts execution as part of validating Scorecard, TSM, UM dashboards using validation tool Universe.
• Worked with testing team in validating Xcelsius Dashboards.
• Validated Scorecard, TSM, UM Dashboards.
• Use Tableau for report generation and analysis.

Environment: Business Objects XIR3, Desktop Intelligence, Web Intelligence, Designer, Central Management Console, Oracle, SQL Server, Tableau

Confidential, Richmond, VA

SAP Business Objects Developer/Business Objects Admin

Responsibilities:

• Involved in migration and deployment of the universes and reports across multiple domains.
• Moved the reports from DEV to TEST and TEST to UAT using Import Wizard.
• Converted the Deski reports to Webi using Report Conversion Tool.
• Fixed the reports which are not converted properly.
• Involved in moving the reports from IE6 to IE8 and also involved in IE8 testing.
• Created the reports which are not migrated.
• Fixed #Data Type, #Syntax, #Context issues in various reports after migration from 5i to XIR2.
• Troubleshooted the data issues and performance issues in the reports and universes.
• Worked with DBA’s in tuning the queries which were running more than 30min.
• Worked with DBA in creating indexes and partitions on the table.
• Used @variable and @prompt in SQL corrections.
• Created complex variable and multiple breaks in the reports.
• Created complex crosstab reports using multiple data providers
• Created reports involving complex queries, sub queries, Union and Intersection.
• Created predefined filters in the universe.
• Involved in development and deployment of complex reports.

Environment: Business Objects 5.1.7, XIR2, Desktop Intelligence, Web Intelligence, Designer, Central Management Console, Oracle, DB2,SQL Server 2008

Confidential

Jr. Business Objects Developer

Responsibilities:

• Worked with the Business users for requirements gathering, business analysis and making technical specifications for the reports.
• Created reports using Business Objects using functionalities like slice and dice, drill down, @functions, cross tab, master detail tables and formulas, etc.
• Created Objects, Predefined Conditions, Joins in the Universe.
• Applied aggregate awareness to speed up query time.
• Used Prompts in the reports as well as the Universe to create more interactive reports for the users
• Trained the power users/end users in Business Objects
• Extensive noledge in all phases of Software application development life cycle.
• Extensively used Designer to design various universes for different business groups.
• Created Contexts and Aliases for resolving Loops, and synchronization problems in the SQL and created cascading prompts in the universe
• Created complex reports using cascading prompts, decode objects etc.
• Worked on RDBMS like Oracle, SQL server, Sybase, MS Access.
• Created Dashboards using Xcelsius.
• Extensively used Web Intelligence Info view, reporter and explorer for querying, reporting and analysis tasks.
• In Info view, implemented customized logins at application level and provided password-reset options to the users.
• Scheduling the reports through CMC and WEBI level by refreshing and sending to the in box/corporate documents.
• Analyzed the business requirements of the project by studying the Business Requirements Specification document.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL,SQL *Plus, SQL*Loader and Handled Exceptions.
• Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
• Created PL/SQL stored procedures by using bulk bind for inserting, updating data in process tables.
• Created Dynamic generalized procedures for truncating current and old partition data.
• Designed the front end interface for the users using Forms 6i.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Performed Unit Testing.
• Environment: Business Objects 5i, Web Intelligence, Broadcast Agent, Oracle 9i, DB2 Version 7.0, PL/SQL, UNIX, Windows NT and TOAD.