D Sarao

D Sarao

Sr BO developer in HBO

patiala, Punjab, India
Current:HBO
Past:BOA
Education:Information Systems

Job Experience

Sr BO developer

HBO

September 2010 to January 2015

? Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing Universes.
? Created WEBI Reports with multiple variables at report level to get % Average, Boolean etc values. Also created User Defined Variables on report site upon user?s requests.
? Created Multi tab reports using multiple data providers and applied different Webi functionality such as hiding and filtering tables based on specific prompt conditions. Also used Union, Intersection, minus, Master/Detail, cross tab and Charts using Webi functionalities.
? Created a Detail Analysis Report for Auditing Purposes in Webi. Auditing Statistics were analyzed to check user interaction and login in specific time slot.
? Created prototype SQL Server Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM)
? Scheduled and Distributed reports to different users by using CMC, Info View and Publisher.
? Created repository, created users and groups, assigned rights to users and groups.
? Deployed Business objects
? Created Universes, Classes and Objects for management systems Business Objects XI.R2/ XIR3.0 XIR3.1
? Resolving Loops using Aliases and Contexts and check Integrity of the Universe and exported them to the Repository to make resources available to the users and groups.
? Involved in Business Requirements Analysis & Documentation.
? Developed custom reports, Cross-tab reports and sub-reports using Crystal Reports XI.
? Updated and maintained Universes based on changing user requirements and data source changes.
? Worked on using the import wizard in moving reports and universes from Dev to UAT and to Production environments. Also used Import Wizard to create BIAR files for repository back up.
? Conducting UAT (User Acceptance Test) and working with QA and QC Teams
? UAT includes both manual and automated testing tools to troubleshoot systems, integration, user acceptance, positive and negative, functionality, object, and regression
? Used QaaWs (Query as a Web Service) to feed data into Xcelsius 2008 to show product portfolio
? Created dashboard by using Xcelsius retrieved data from Excel file by using Live Office
? Created complex Xcelsius dashboards to reflect User Adoption Metrics
? Created complex Xcelsius dashboards by connecting directly with existing Crystal Reports and XML files.

BO Developer

BOA

May 2010 to September 2010

? Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing Universes.
? Created WEBI Reports with multiple variables at report level to get % Average, Boolean etc values. Also created User Defined Variables on report site upon user?s requests.
? Created Multi tab reports using multiple data providers and applied different Webi functionality such as hiding and filtering tables based on specific prompt conditions. Also used Union, Intersection, minus, Master/Detail, cross tab and Charts using Webi functionalities.
? Created a Detail Analysis Report for Auditing Purposes in Webi. Auditing Statistics were analyzed to check user interaction and login in specific time slot.
? Created prototype SQL Server Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM)
? Scheduled and Distributed reports to different users by using CMC, Info View and Publisher.
? Created repository, created users and groups, assigned rights to users and groups.
? Deployed Business objects
? Created Universes, Classes and Objects for management systems Business Objects XI.R2/ XIR3.0 XIR3.1
? Resolving Loops using Aliases and Contexts and check Integrity of the Universe and exported them to the Repository to make resources available to the users and groups.
? Involved in Business Requirements Analysis & Documentation.
? Developed custom reports, Cross-tab reports and sub-reports using Crystal Reports XI.
? Updated and maintained Universes based on changing user requirements and data source changes.
? Worked on using the import wizard in moving reports and universes from Dev to UAT and to Production environments. Also used Import Wizard to create BIAR files for repository back up.
? Conducting UAT (User Acceptance Test) and working with QA and QC Teams
? UAT includes both manual and automated testing tools to troubleshoot systems, integration, user acceptance, positive and negative, functionality, object, and regression
? Used QaaWs (Query as a Web Service) to feed data into Xcelsius 2008 to show product portfolio
? Created dashboard by using Xcelsius retrieved data from Excel file by using Live Office
? Created complex Xcelsius dashboards to reflect User Adoption Metrics
? Created complex Xcelsius dashboards by connecting directly with existing Crystal Reports and XML files.

Education

Information Systems

The college of staten Island

Currently studying

Languages

IT skills

Other Skills

More D

Career Goals

Industries of interest

Areas of interest

Availability to travel and work outside the city

No

Interests and hobbies