SUMMARY

• Over 6 years of experience in Information Technology with strong work experience as Business Objects Developer.
• Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.
• Expertise in Business Objects enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, Info View, Crystal Reports, Xcelsius, CMS, CMC & CCM) and its deployment.
• Hands on experience in extracting master data from various SAP and Non SAP systems.
• Well versed with Business Objects XI 3.1 / XI R2, Info - view/ Web Intelligence, Crystal Reports, and Universe Design with SAP BW Data Sources and BEx Queries.
• Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.
• Experience in creating Adhoc reporting ready universes using Business Objects Universe Designer.
• Excellent data-analysis skills and ability to translate specifications into a working Universe and/or Report.
• Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.
• Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.
• Experience in developing different types of reports using Crystal Reports and Web Intelligence.
• Customized reports based on user requirement using various features available in Crystal Report 2008 like running totals, parameters, grouping of data, alerts etc.
• Extensively used advanced reporting functionalities such as Sections, Breaks, Drill, Filters, Ranking, Alerts etc and using report level variables to mimic user requirements.
• Installation and configuration of Xcelsius and designing complex dashboards using Universe, Webi, Crystal Reports in monitoring business metrics.
• Hands-on experience in developing Analytical Dashboards using Xcelsius with QaaWS and Live Office connectivity.
• Experience and Strong understanding of SAP BW integration with Business Objects.
• Experience in building Multi providers and Info sets as per the query needs. Configured and implemented SAP BW reporting using BEx Query Designer, BEx analyzer/browser and WEB Application designer.
• Experienced (BEx) and publishing the reports on web using Web Reporting tools.
• Experience in Migrating Business Objects from Older versions to newer versions.
• Experience in Training & Supporting end-user reporting needs using Business Objects.
• Strong database experience in using Oracle 10g/9i/8i, MS SQL Server 2008/2005, MS Access.
• Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture including both OLAP & OLTP data and complete lifecycle of project from design to development and implementation.
• Exposure to Dimensional Data modeling- Star Schema modeling and Snowflake modeling.
• Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result oriented dedication towards goals. Capable of working as a Team Member or Individually with minimum supervision.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

Business Objects Tools: Business Objects XI 3.1/3.0, XI R1/R2,6.5, Web Intelligence XI 3.1/3.0/XI R2, Universe Designer XI 3.1/3.0,XI R2, Crystal Reports 2008/ XI R2, Desktop Intelligence, InfoView, CMC, Import wizard, Report Conversion Tool, Data Integrator 11.5/XI 3.0, Xcelsius 2008, Query as a Web Services(QaaWS), Live Office.

Databases: Oracle 10g/9i/8i/8.0, MS SQL Server 2008/2005, MS Access, Siebel, Sybase, Teradata, Informix.

Data warehousing: Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables.

Operating Systems: Windows Server 2003/2000/NT, Windows Vista/ XP/ME/98/95, DOS, UNIX.

Windows Utility: MS-Word, MS-Excel and MS-PowerPoint.

Programming Languages: SQL, PL/SQL, JAVA, HTML, C, C++, C#, .NET

Dimensional Data Modeling Tools: Dimensional data modeling using Erwin modeling (Erwin 4.1/4.0/3.5.5/3.5.2 ), Physical & Logical Data Modeling, multidimensional modeling, Snowflake Schema/ Star Schema modeling (Normalization / De-Normalization Techniques), Erwin, Visio.

Query Tools: TOAD, SQL*PLUS, SQL*Loader, SQLNavigator.

PROFESSIONAL EXPERIENCE

Sr. Business Objects developer

Confidential, VA

Responsibilities:

• Inventory, Accounts Payable and Purchase Orders were the different subject areas within the data warehouse.
• Interacted with Business Users, Business owners to know their Business requirements in developing and modifying Universes and Reports accordingly.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Used advanced universe functionalities like Derived tables, Index Awareness, Aggregate Awareness.
• Customized the list of values (LOV’s) which helps the end users to select the values.
• Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts .
• Created several complex Web Intelligence and Desktop Intelligence reports to help management to track and monitor contract, commodity and price compliance.
• Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting.
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option .
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report.
• Extensively used Calculations, Variables , and User Objects in the creation of reports.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Created User Prompts, Conditions and Filters to improve the quality of report generation.
• Key metrics ‘procure to pay cycle times’, ‘diversity spend’, ‘cash discounts captured and missed’ spanning across different subject areas has been re-created using Xcelsius.
• Consolidation of reports by groups/regions and designing templates catering to the needs of sourcing/financial analysts & material and cost specialists.
• Created universe and reports by extracting data from SAP BEX Query.
• Used Xcelsius to Visualize and to enhance the data presentation along with developing dynamic charts and graphics.
• Worked on building Xcelsius Dashboards on top of universes built using SAP Integration Kit.
• Developed Dashboards using components such as maps, Pie Charts, Staked Bar, List Views etc. creatively using best Xcelsius components effects for better interaction.
• Participated in the complete development lifecycle: analysis, design, build and test reports.
• Providing support for the users on application usage and conducting training walk through of salient features of the application.

Environment: Business Objects XI 3.1, Web Intelligence , Desktop Intelligence, CMC, Import Wizard, Universe Designer, Xcelsius 2008, SQL Server 2008, Windows 2003 advanced server.

Sr.Business Objects Developer

Confidential, VA

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Working on the SQL tuning and optimization of the Business Objects reports.
• 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.
• Designed and maintained complex Universes, resolved loops by creating aliases and contexts.
• Exported the ad-hoc ready universes to the for making semantic layer available to the users.
• Extensively used the @functions and Aggregate Aware feature. Worked on back end views, tables required by the business objects universes.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Created Xcelsius dashboard for executive view covering selected KPI for the business function
• Created WSDLs using Query As a Web Service (QaaWS ) from different Data sources.
• Migrated Xcelsius dashboards and deployed QaaW S to the new servers and fixed the hyperlinks and excel spreadsheet to be compatible in new environment.
• Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs.
• Created complex reports by linking data from multiple data providers, stored procedures and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.
• Extensively worked with Ranks, Alerter, filters, prompts, variables and calculation contexts in designing reports.
• Built WebI reports Provided OLAP functionality and worked extensively with data warehousing.
• Set up groups and users for Business Objects deployment.
• Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
• Extensive testing and migrating the reports or objects from development to Production system.
• Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards and other Business Objects Applications in new environment.
• Extensively involved in SQL coding, creating complex queries, views, Stored Procedures, Stored Functions to give better results for Crystal Reports.
• Designed Criteria to handle the customer’s request from Tables, Stored procedures, Views and Command objects using Crystal Reports.
• Added sorting, grouping and summarizations to Crystal Reports .
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.

Environment: Business Objects XIR3.1, Web Intelligence, Xcelsius, Crystal Reports, Universe Designer, Oracle 8i/9i, PL/SQL, Windows XP/7.

Business Objects Developer

Confidential, California

Responsibilities:

• Involved in understanding the end-user requirements and business processes in creating and designing universes, queries and reports.
• Designed Universes, incorporating all the business requirements.
• Implemented object level security universe to incorporate security for sensitive information.
• Worked in migration of universe and reports between environments .
• Designed universes, solved loops by creating aliases, contexts and resolved traps.
• Created complex variables, breaks, sorts, filter and conditions for various reports.
• Created complex reports involving m aster/detail and cross-tab and Combined queries and sub-queries
• Linked multiple data-providers and Used calculation contexts/extended contexts
• Coordinated with DBA and Business objects designer group in solving various technical issues.
• Created multiple contexts for catering different functional areas in a single user query.
• Used Aggregate awareness function of Business Objects to route the query objects through the appropriate path while selecting from multiple contexts..
• Used prompts in the reporter as well as in the universe to create more interactive reports for running different kind of campaigns.
• Extensively used scheduler for report scheduling and deployment
• Generated various report templates for standardizing the reports throughout the organization.
• Created Xcelsius dashboards for visual understanding of information and publish to BO Enterprise.
• Involved in developing the financial reports for the Financial services Dept and successfully published the highly formatted reports and met with the end user requirements
• Resolved Year Ago Variance Calculation, Percentage Calculation in Cross Tab in WebI XI R2.
• Scheduled pre-canned reports through Scheduler for distribution and printing. Designed Complex reports using sub reports, manual cross tabs using Crystal syntax with extensive usage of Local, Global, and Shared variables at report formulas.
• Created a wide variety of charts like pie chart, 2d and 3d charts.
• Created productivity and financial reports for management using Crystal Reports.
• Involved in end user training and documenting the procedures.

Environment: Business Objects XI R2, Web Intelligence, Crystal Reports, Xcelsius 2008, Oracle 9i

Business Objects developer

Confidential, CA

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Designed several universes and used various methods to optimize queries on database, universe and reporting level.
• Worked towards optimal development of universes by removing loops through the use of aliases and contexts.
• Creating Universe with number of Classes, many objects, Derived Tables using inner/outer and equiv. joins as per requirement.
• Created and tested classes and objects to organize the universe.
• Exported the universes to the Repository to make resources available to the users.
• Created reports for various Portfolios using the Universes as the main data Providers.
• Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s etc.
• Applied drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Extensively worked with Ranks, alerters, filters, prompts, variables and calculation contexts in designing reports.
• Created Business Objects Repository while building Business Objects solution.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Created Derived tables, Developed Stored Procedures, Packages and Triggers database using PL/SQL.
• Extensively involved in SQL coding, creating complex queries, views, Stored Procedures, Stored Functions to give better results for Crystal Reports.

Environment: Business Objects XIR2, Web Intelligence, Crystal Reports, Universe Designer, Oracle 8i/9i, Windows NT.