Projekt‐ & Berufserfahrung
4/2012 – 11/2012Tätigkeitsbeschreibung
• Involved in the Project Requirement Analysis and Preparation of System Requirement Specification Document.
• Involved in the Data mart (Pricing) Design and creation, preparing the Codification Schemes of Project.
• Involved in Unit and Integration Testing of all data load into Data mart (Pricing)
• Interacted with End-Users for reporting requirements.
• Created functional and technical specifications based on business and technical requirements.
• Involved in design and creation of Universes and Reports
• Extensively Involved in resolving Loop trap, Chasm and Fan trap by creating BO-Universe
• Involved in the Design of BO report models
• Configuration of BO CMC: Creation of BO universes, work files, users and groups, connections to databases, configuration actions publication: PDFexport ,Excel export, backup documents BO.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Extensively use of @Aggregate Awareness, @prompt,@Select feature of Business Objects for the Optimization and Performance tuning of Universes.
• Used of Calculations, Variables, Slice and Dice for creating Business Objects reports.
• Creating BIARS to deliver reports to Production and Acceptance environments.
• Created various analytical reports like Price index analysis, Margin analysis from multiple data providers with WebI and sometime with BO-weight Client, and sharing these with all different users.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
• Automated document Scheduling, Publishing and Distribution for WebI and Info View clients
• Developed universe and report user documentation guide for the end users reference
• Provided training for end users for generating their own report including complicated report.
Datastage PX 8.1, 8.7.
Oracle Data Integrator 10.0.3
Business Object Xi R 2 and 3
- Strong knowledge of Data modeling, Design, Development
- High proficiency in optimizing, debugging and testing SQL queries, BO-Universes, BO-Reports, ETL-stages
-Strong experience in Database programming for Data Warehouse (Schemas),
-High proficiency in dimensional modeling (Star Schema modeling, and Snowflake modeling)