| Resume |
To give my career a good growth by joining an eminent and a highly professional organization and contribute to the success of the company by outstanding performance.
1)Organization : SAB MILLER (UK) LTD, Murthal/ Gurgaon
Designation: IT Executive
Project Undertaken: Enterprise Datawarehouse (EDW) Reporting
Duration: Jun14 - Present
Technology: SAP Business Objects Xi 3.1, Oracle 10g, and Dimensional (Star Schema/ Snow Flake) Modeling
Involved in gathering the requirements from Business Users to capture the Candidate Objects. Analyzed these requirements and prepared Technical Specifications Document for Business Objects Universe and Reports.
Created mock-up reports for initial user presentation in the process of designing Technical Specifications.
Designed and modified the Universes, which suits the standard, analytical reporting requirements of the business users using BO XI Designer application.
Created new Classes, Sub-classes and Objects as per the standards that were put in place during the Strategy process and identified Objects as Dimensions, Details or Measures.
Created List of Values (LOVs) and custom Hierarchies to support drilling functionality for in depth analysis in reports.
Involved in the migration of Universes/ Reports from Development to Test environment and finally into Production environment after UAT (User Acceptance Testing).
Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report.
Created Templates to customize style and structure of the canned reports to maintain company standards.
Reports were formatted according to the user requirements using different functionalities like Breaks, Sorts, Sections, Filters and Calculations.
Prepared many critical WebI reports by using master detail and drill mode on tables and graphs as per the requirements of the end-user.
2)Organization: Pepsi Bottling Company (PBC) Inc, New York, USA
Designation: BO Developer
Project Undertaken: Business Sales Reporting
Duration: Mar12 Apr14
Technology: Business Objects XI R2, Deski, WebI & Rich Client
Created complex and adhoc reports using Desktop Intelligence, Web Intelligence and Web Intelligence Rich Client.
Created POCs for specific customer needs
Extensively used report organization and formatting techniques like Sectioning, Ranking, Filtering, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae to develop the reports.
Enhanced the data warehouse per business requirements
Responsible for requirements gathering of development objects like universe and reports.
Studied the existing application to understand the business requirements and business rules.
Implemented Row-Level Security in the universe. Utilized the concept of Materialized views to simplify the data load in reports.
Involved in Performance testing of the reports and universe module created by the team and suggested solutions to improve the performance.
Trained the business users and conduct training workshops for the Business Analysts and Business Users on BOXI 3.1.
3)Organization: Roulunds Braking Ltd
Designation: IT Trainee
Project Undertaken: HR Data Mart Reporting
Duration: Jan11 Dec11
Technology: Business Objects XI R2, Web Intelligence, Designer, Desktop Intelligence, CMC, Oracle 10g
Got trained as Business Objects developer and was responsible for the creation and maintenance of all Universes to support WEBI reporting for HR Dept.
Played an instrumental role in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and reports.
Created complex universes by employing various techniques including loop detection, prompts, conditions, classes, objects, dimensions, measures, details, joins, cardinality, keys, data integrity, LOVs (list of values), aliases, derived tables, multiple contexts, and hierarchies.
Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formulas.
Exported reports to Broadcast Agent Server, and used the Broadcast Agent to schedule and monitor the reports.
Tested and migrated universes and documents across testing/ production repositories.
Built WEBI reports according in collaboration with HR Managers.
Created reusable report templates to maintain a uniform standard across all the reports.
Provided support to the WebI Users on a variety of issues related to the reports.
Created custom List of Values (LOVs) and Hierarchies that enable report users to select the list of values and also to drill down to lower levels.