Summary of Qualifications

• 7+ years experience developing enterprise reporting solutions.
• Excellent experience working with Crystal Reports, Business Objects XI - R2
• Experience working on universes (Business Objects XI R2 and R3) using Designer
• Knowledge of data design models - Entity Relationship, Multi Dimensional/ Star Schema modeling for Business Objects Universe from Dimensional data mart / data warehouse.
• Knowledge of creating dashboards using Xcelsius
• Good working skills using Databases- SQL Server and MS Access
• Good SQL query writing skills
• Performance Tuningin Reports.
• Involved inproduction support.
• Training business users in developing/using various Reports
• Stronganalytical, pattern detection andproblem solving abilities.
• Experience in interacting with business users
• Good team player with excellent communication and interpersonal skills; self motivated, fast learner and good listener

Skills/Technologies

Operating Systems/Networks: UNIX, Windows NT/XP/2000/9x, Sun Solaris, DOS
Databases: SQL Server 2000, IBM UniVerse, MS Access
Reporting Tools: Crystal Reports 9, 10, XI, 2008, Xcelsius 2008
Business Objects Tools: Universe Designer, WEBI, Data Integrator Management Console
Applications: Peoplesoft (Oracle) EnterpriseOne, Total Return, TRIRIGA, Visual Studio 2005
Languages: HTML, C, C++, TSQL

Education

Master in Electrical and Computer Engineering
Bachelors of Engineering,

EXPERIENCE:

Crystal Reports Developer
Confidential, Dallas, TX 9/2011 to Present

Creating and maintaining reports used for systems and process monitoring and reports supporting operational processes that require quick turnaround/action. The report definition and development runs on a 2 week Agile sprint cycle.

Responsibilities include

• Working with users to gather the requirements for data analysis
• Developing Crystal Reports in version 2008 against SQL commands - developed and tested in query analyzer; and creating test data in the SQL test database
• Creating reports with subreports, crosstabs, grouping etc.
• Conducting UAT labs and interacting with the users as part of the report testing process
• Publishing the reports in CMC
• Creating and modifying universes in BO Designer
• Creating universe with derived tables and creating dimensions and measures
• Creating and modifying WEBI reports, in thin client as well as rich client
• Collecting meta data for the reports

Environment: Crystal Reports 2008, Business Objects XI R3 - Designer, WEBI - Rich Client, Crystal Management Console, SQL Server 2005, Query Analyzer

Crystal Reports Developer
Confidential, Chicago, IL 11/2010 to 8/2011

Client recently went live after implementing Total Return, a Portfolio Management and Partnership Accounting system, with IBM UniVerse database at the backend. My responsibility is to build new reports and packages for the users: Balance Sheets, Income Statements, Trial Balances, Audit Reports, Cash Balance, and various other investment and accounting reports. These reports would be used for presentations and analysis purposes. These reports are complex to design as they have to adhere to strict formatting and display standards along with having good performance.

• Work with the users to gather requirements for reports and data analysis
• Create reports using Crystal Reports 2008 (Crystal Reports XI before the company upgrade) against IBM Universe database, MS Access, SQL Command objects
• Implement different strategies to improve the performance of reports
• Involved with implementation team for data setup from reporting perspective
• Create reports for multiple modules: Investment and G/L.
• Create Standard, Summary reports with Cross Tabs, Charts, Selection Criteria, Subreports, custom functions and formulas, arrays, alerts and grouping.

Crystal Reports Developer
Confidential, Minneapolis, MN 05/2008 to Present

The project was a new implementation of Total Return application. As part of this, a series of reports were created for the users: Balance Sheets, Trial Balances, Income Statements, Audit Reports, Cash Balance, and various other investment and accounting reports. Some of these reports were used for presentations apart from analysis purposes; a strict standard for formatting and display were followed and they made the reports a bit more complex to design. Performance also played a crucial role in designing and developing the reports.

• Worked with the users to gather requirements for reports and data analysis
• Created reports using Crystal Reports 10 against IBM UniVerse database
• Implemented different strategies to improve the performance of reports
• Tested the new data for the users and made suggestions for data setup
• Created reports for multiple modules: Investment, AP, G/L.
• Created Standard, Summary reports with Cross Tabs, Charts, Selection Criteria, Subreports and arrays and grouping.

Environment: Crystal Reports 10, Total Return, IBM UniVerse

Business Objects/Crystal Reports Developer
Confidential, Minneapolis, MN 07/2006 to 04/2009

Opus E1
This was a new implementation of JD Edwards EnterpriseOne (now part of Oracle). Apart from the native reporting application the client used Crystal Reports for their presentation needs as well as analysis needs. Initially, Crystal Reports 10 was used and later the client upgraded to Crystal Reports XI. After Business Objects Data Integrator and Universes were successfully implemented, Universes became the data source for all the reports, hence had to be rewritten.

• Worked with the users and higher management to gather requirements for reports and data analysis
• Created various G/L, A/P, A/R, Payroll reports
• Created reports using Crystal Reports XI and Crystal Reports 10 with Standard, Summary, Cross Tabs, Selection Criteria, Subreports and arrays, SQL expressions and grouping
• Created various WEBI reports
• Created reports with various data sources - MS SQL Server 2000 Tables, SQL Commands, Business Objects Universes, XML
• Fine tuned existing reports for performance, keeping in mind the ease of use and giving the users more control options.
• Responsible for rewriting all existing reports against Universes in Crystal Reports XI
• Maintenance of General Ledger, A/P, A/R, Payroll Universes. Customizing the universes by adding new tables, incorporating complex joins, and creating new dimensions and measures in BO Designer tool.
• Published Crystal Reports in web based environment using Crystal Enterprise 10 and Business Objects Enterprise.
• Provided Crystal Reports training on basics of report design

Environment: Business Objects XI R2 - Crystal Reports XI, Universe Designer, Microsoft Sql Server-2000, Oracle EnterpriseOne, Web Intelligence, Crystal Reports 10, Crystal Enterprise 10

Crystal Reports Developer
Confidential, Alpharetta,GA 07/2004 to 06/2006

A series of reports were developed in Crystal Reports 10 and published using CMC. The backend was SQL Server 2000.

• Worked with the users and higher management to gather requirements for reports and data analysis
• Created various G/L, A/P, A/R, Payroll reports
• Created reports using Crystal Reports 10 with Standard, Summary, Cross Tabs, Selection Criteria, Subreports and arrays, SQL expressions and grouping
• Created reports with various data sources - MS SQL Server 2000 Tables, SQL Commands, MS Access
• Fine tuned existing reports for performance, keeping in mind the ease of use and giving the users more control options.
• Published Crystal Reports in web based environment using Crystal Enterprise 10
• Provided Crystal Reports training on basics of report design

Environment: Microsoft Sql Server-2000, Oracle EnterpriseOne, Crystal Reports 10, Crystal Enterprise 10, MS Access

References available upon request