Rakesh Motwani

• Analysis of requirement and to provided estimates for the same.
• Created MIS reports using BO XI R2 Deski/Webi.
• Created Sub reports which were called from the main report to implement the business logic.
• Generated Reports using procedures and views for faster execution.
• Based on the users requirement, created parameter driven reports to restrict the volume of data.
• Created and optimized stored procedures to enhance the performance of the reports.
• Modified existing reports according to the user's requirement and exported reports to PDF format.
• Created nested, conditional groups and formatting features in reports.
• Involved in creating various PL/SQL stored procedures, views, functions and temporary tables for data input to the SAP BO/Crystal Reports.
• Optimized queries to run efficiently.
• Raised report alerts when certain conditions are not met as requested by the user.
• Tested output of reports using SQL queries in Toad to verify whether the report has met the user requirements or not.
• Deployment of the reports into the production environment.
• Enhancement of Existing Desktop and web intelligence HR Reports as per the requirement.
• Enhancement of HR Universe for new requirement.
• Providing Rights to user through CMC.
• Support for ongoing issues.

• Coordinated meetings with business users and development teams to gather System requirements and data requirements.
• Involved in design, development and reports creation using Crystal Report 2008.
• Coded each module and merged the same with the other modules.
• Created Several KPI Reports using BO XI R2 Deski, Webi.
• Designed and developed Crystal Reports, the Cross Tab Reports, and Top N Reports for displaying vital data and summary reports with drill-down capabilities.
• Worked on already existing reports to optimize and troubleshoot problems that occurred due to new business requirements.
• Code Debugging, Performing various tests such as Unit Testing, Integration Testing, requirement testing and performance testing.
• User acceptance test at user end and training also being provided.
• Documentation of enhancements being implemented.

• Requirement analysis which covers the task of eliciting and documenting the requirements of all the users, modeling and analyzing these requirements and documenting them as a basis for application design.
• Designed the forms, tables, queries to manage the data flow across the objects of an application.
• Code development for each required functionality.
• Involved in the Design, Development & implementation of Reports in Crystal Reports 2008.
• Tuned reports for faster execution using procedures, views, column Index's.
• Developed database connections, SQL joins, loops, views, aggregates.
• Created complicated formulae and running totals on summarized totals for business measure calculations based upon various end user requirements.
• Continuous support and enhancements and resolving of issues.
• Interaction with Onsite team and Client for overall understanding of the Customer Requirements.
• Developed reports using Crystal Reports.
• Written Stored Procedures and Views on SQL Server 2005 to be used in various Crystal Reports
• Generated the reports and giving those reports to users for verification.
• Used prompts, alerts, drill down analysis as per the end user requirements.