Manindra Kumar Parida Email & Phone Number

Sharjah, United Arab Emirates

work experience using SAP BI 4.2/Business Objects BO XI 4.0/ XI 3.1/XI R2/6.5 Designer, CMC, Info view, Web-Intelligence, DESKI, Import Wizard, Publishing Wizard, Metadata Manager, Crystal Enterprise 2008/XIR2/10/9,Enterprise Dash Board Manager, Broadcast Agent,SAP Design Studio and SAP Lumira

Dubai, United Arab Emirates

Roles and Responsibilities:• Responsible for designing and development of Universes from relational database sources• Interacted with Business users, Business Analyst, gathered business requirements, and presented the proof of concept• Performing requirements analysis, design, and technical delivery of critical business reports for decision support in the data warehouse sitting on top of Oracle data base• Designed and built Universes using Designer, created and modified Web… Show more Roles and Responsibilities:• Responsible for designing and development of Universes from relational database sources• Interacted with Business users, Business Analyst, gathered business requirements, and presented the proof of concept• Performing requirements analysis, design, and technical delivery of critical business reports for decision support in the data warehouse sitting on top of Oracle data base• Designed and built Universes using Designer, created and modified Web I, Crystal reports from the underlying Oracle and SQL server databases for different business modules• Designed the logical semantic layer using the Universe designer tool by defining joins, cardinalities between tables and applying contexts and aliases to remove cyclic dependencies (Loops/traps)• Resolved complex loop issues by creating multiple contexts and aliases to remove cyclic dependencies in the universes• Applied Row level securities using security restrictions option in the Universe. Created the Object level security in the CMC• Handled Embedded BO Functions like @Prompt, @Select, @ Variable, @Where, @Aggregate awareness in the designer to handle user requests for report generators. Set up Aggregate tables to enhance the SQL performance• Analyzed all tables and created various indexes to enhance query performance working with DBAs• Worked on custom hierarchies in the universe level to enable scope of analysis and various drill options during reporting• Worked on universe level filters to restrict the data at Universe level. Applied filters on the objects. Created derived objects in the universe• Created Derived tables for improving performance and used short cut joins to resolve join problems• Worked extensively on the Web I functions like multiple queries, combined queries, report and block filters, and various reporting cosmetic options like section, breaks, ranking, sorting and formatting options Show less

Al Fujayrah, United Arab Emirates