Clement Medishetty

✔ Overall 12 years of work experience and relevant 8+ years in Development and Implementations of Power BI and SAP Business Objects reporting solutions.

✔ Worked with SAP Business Objects, Microsoft Sql Server 2008\2005 database to generate WEBI report as per business requirements ,few Power BI reports and few SSRS reports also.

✔ Extensively worked on the Information Design Tool & Universe Designer tool for designing universes.

✔ Extensively worked on WEB Intelligence Tool for creating WEBI Reports.

✔ Used WEBI & Universe’s functionalities like, custom queries, complex queries Filters, drill down, @Functions (like @Prompt, @Aggregate awareness, @Select, @Where, @Variable), tracking data changes, multiple data sources in universe, merge dimensions, calculation context, hyperlinks, cross tabs and dynamic linking of objects in WEBI report.

✔ Developed complex queries using different data providers in the same report.

✔ Created new Universe, Web Intelligence reports, Crystal Report and Business Views according to the requirement.

✔ Implemented Security Features of Business Objects like Row level, Connection, Sql, Table & Objects and Report level (report permissions) to make the data secure.

✔ Designed crystal reports using various data sources on Crystal Reports 2011 & 2008.

✔ Awareness of new BO tool Design Studio 1.4 & SAP Lumira.

✔ Setup Business Object client tools on client machine to access BOE environment.

✔ Cleanup & maintenance of BO servers.

✔ Migration of BO content to another environment/servers.

✔ Setting rights and privileges on objects, folders, connections depending upon the requirement. Creating and maintaining different user groups and access levels as per the business need.

✔ Worked on CMC, CCM, Universe Designer, IDT, Web Intelligence, BI Launch Pad, Promotional Management Tool, Business View Manager, Crystal Report 2011 & 2008, Import Wizard, Publishing wizard, Instance Manager, Business Objects XI R3 and Query as a web services.

✔ Setup replication between two BO environments for backup of BO objects as a part of disaster recovery management.

✔ Created Users, User groups and setting up the user profiles.

✔ Create, Configure and Monitor all the BO Servers.

✔ Enabled/Disabled different servers in Central Configuration Manager and Central Management Console.

✔ Managing different server’s services and configurations.

✔ Published the Reports by using the Publication from the CMC.

✔ Worked on Custom, Schedule and Event based report scheduling from the CMC.

✔ Setup multiple server groups to maintain BO System easily.

✔ Creation of New Custom Access levels and Enable the Auditing in BI 4.0.

✔ Configure Windows AD in SAP BI 4.0 along with single sign on.

✔ Experience in migrating from one environment to another environment.

✔ Extensively worked on Upgrade Management Tool for upgrading reports from one BO environment to another.

✔ Created and used user profiles in report publications.

✔ Setup Mobile BI in SAP BO 4.0 for IPAD users.

✔ Worked on ETL tools SAP Business Objects Data Services 4.2 & 3.1 and used all transforms of Data Services (Data Integrator, Platform & Data Quality transforms and Text Data Processing).

✔ Worked with different databases like SQL Server 2012\2008 R2\2005\2000 & SAP Sybase 15.0 as database developer.

✔ Extensively work on database object like triggers, stored procedures, cursors, tables, user functions, views, indexes etc.

✔ Good understanding of MS - Sql Server.

✔ Experience in designing, implementing, maintaining, and documenting complex database applications.

✔ Coding and design of Windows applications with attractive graphical user interface using Visual Basic 6.0 & C# 2005.

✔ Created triggers, stored procedures, triggers, cursors, tables, user functions, views, indexes, Sql queries, and relational database models on Databases like MS - Sql Server & SAP Sybase.

✔ Hands-on experience in SDLC entailing activities related to requirements gathering, planning, design, development, implementation, documentation, testing.

• Date of Birth: 05/09/84
• Nationality: Indian
• Marital Status: Married