OBJECTIVE

• Looking for the greatest opportunity to work as reports developer for a reputed company. I want to associate as a SR Crystal Reports / Business Objects lead with an organization where I can be a resource of productivity owing to my vast knowledge and experience.

SUMMARY

• Information Technology professional having Ten years of experience in reports development using Crystal Reports and Business Objects.
• Designed and developed a series of complex Business Intelligence solutions using Business Objects Designer, Desktop Intelligence, Web Intelligence and Crystal Reports.
• Strong Administration experience using Central Management Console (CMC) including granting access levels to users and creating/maintaining folders and groups.
• Expert in creating reports using Crystal reports and deploying/scheduling them in InfoView.
• Expertise in Analyzing, Coding and Implementing SQL queries and views using various RDBMS Databases.
• Create different type of reports including Cross - tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub-reports.
• Experience in creating reports with different options as Charting, Mapping, Grouping, Sorting, Alerting and Field highlighting.
• Expertise in Creating Business Views and LOVs using Business View Manager.
• Experienced in writing complex formulas in Webi/Crystal reports.
• Proficient in Data Warehousing Concepts, OLAP tools and creating reports.
• Excellent interpersonal communication, problem solving skills, documentation skills and business analytical skills.
• Excellent ability to develop complex reports using custom sql, use of unions, creating sub query sections etc.
• Brainbench certification in Crystal Reports.
• Excellent communication and writing skills.

TECHNICAL SKILLS

Reporting Tools: Crystal reports 8.5/9.0/10/XI/2008, Crystal Enterprise 8.5/9.0/10, Business Objects 6.x/XI

Operating Systems: Windows 7.0/8.0/2003/ NT 4.0, UNIX Sun Solaris, Linux

Databases/RDBMS: Oracle 7.3/ 8.x/9i/10g, MS SQL Server 7.0/2000/2005 , Sybase12.0, Teradata v2r6/v2r5, MS Access

Languages: C, C++, VBScript, PL/SQL, Eclipse

Other Tools: Visual Source Safe, Business View Manager, Visual Interdev, TOAD, PVCS, Clear Case, Ms Excel.

PROFESSIONAL EXPERIENCE

Confidential

SR Reporting Developer

Responsibilities:

• Involved in gathering the requirements and developing the reports using Crystal Reports 2008.
• Wring the reporting requirements for the new reports.
• Designing different types of charts to compare the SLAs for the requests.
• Involved in creating technical designs for the reports.
• Optimized the old reports to improve the performance.
• Created reports with groups, parameters, formulas, sub-reports, section formulas and conditional formatting.
• Involved in creating Standard, Drilldown, Score cards and many other reports using different data sources.
• Published the reports in CMC and specified the report access for different groups.
• Involved in scheduling the reports in CMC.
• Involved in providing the training to the users on InfoView.
• Creating the groups to provide the access to the reports.
• Writing the documentation for the reports.

Environment: Crystal Reports 2008, BOXI R3.1, InfoView, CMC, Excel, Oracle 12 and Windows XP

Confidential, New York, NY

Assistant VP / HRIS Reporting Developer

Responsibilities:

• Gathered requirements, created standardized templates that the MI/Comp Team can use in developing specifications, requirements gathering, data checklists and manuals.
• Involved in creating different types of reports using Web Intelligence, Crystal reports XI / 2008.
• Designed different types of charts to compare the compensation information.
• Involved in creating bonus books and analytical reports for the SR Exco meetings.
• Optimized and reduced the number and types of the reports to manage by introducing ways to re-use reporting templates to facilitate varying needs.
• Involved in creating the Excel reports by writing the Macros / VBA code.
• Created reports with groups, parameters, formulas, section formulas and conditional formatting.
• Involved in creating Standard, Drilldown, Score cards and many other reports using different data sources.
• Created the very complex analytical reports using various features in Crystal reports.
• Optimized the old reports to improve the performance.
• Published the reports in the reporting application and specified the report access by different roles.
• Involved in scheduling the reports.
• Trained the users on the reporting applications.
• Maintained the compensation system to include day to day changes.
• Created the ad-hoc reports for the users.
• Created the documentation for the reports
• Created various reporting documents to gather the requirements.

Environment: BOXI R2, Crystal Reports 2008, SAP, DESKI, WEBI, InfoView, HRIS, Xcelsius, CMC, MS Access, Excel, SQL Server 2005, Windows XP

Confidential, New York, NY

Senior Report Developer

Responsibilities:

• Involved in gathering the requirements and developing the reports using Webi / Crystal Reports XI.
• Created Standard, Cross-tab, Drill-down, Sub-reports, On Demand reports using the XSD/XML and SQL server data sources.
• Reports include P & L attribution recon, daily recon, daily portfolio, P& L allocation and many other analytical reports.
• Scheduled the reports into required formats (PDF, Excel, HTML, Word…etc..,).
• Involved in designing different types of charts (Line, Bar, Histogram, Stacked Bar chart, Percentage Bar Chart, etc.,) to show the statistical information.
• Created groups, parameters (linked & unlinked), formulas, section formulas, suppression formulas, sorting and conditional formatting to meet the requirements.
• Used to interact with CRT’s and business users to get the requirements and used to build the analytical reports.
• Worked on the ad-hoc report requests.
• Involved in modifying and performance tuning of the existing reports.
• Created the documentation for all the reports.
• Responded expediently for requests to create, modify and fix reports.

Environment: BOXI R2 / Crystal Reports XI, XML, XSD, MS Access, Excel, SQL Server 2005, Windows XP

Confidential

S/W Programmer / Crystal Reports Developer

Responsibilities:

• As a Crystal reports developer for a consulting firm, identified best practices and methods that allowed corporations to better create and deliver analytics based on the best available tools to fit their needs.
• Involved in gathering the requirements and developing the reports using Crystal reports XI / v10.
• Developed Standard, Cross-tab, Sub-reports, On Demand and Drill-down Reports using Crystal Reports.
• Understanding Oracle reports and converting them into Crystal Reports.
• Created Groups, Parameters, Linked and UN Linked Sub Reports.
• Wrote formulas, Selection formulas and conditions depending upon selection criteria.
• Wrote SQL queries to pull the data from different databases (SQL server, Oracle, TOAD, DB2...etc.,).
• Migrated the reports to different environments (Dev - Test / UAT - Prod) using Migration Wizard.
• Developed LOV’s (List of Values) for the dynamic parameters using Business View Manager.
• Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats (PDF, Excel…etc..,).
• Trained the business users on how to run / export / print the reports from the InfoView.
• Involved in creating Folders and assigning the users to the folders according to the roles.
• Created various formulas for the calculations in the reports.
• Created Static and Dynamic Parameter fields for the filtering of the data.
• Involved in Writing Views and Sql Queries for the Reports.
• Involved in creating the documentation for all the different projects.
• Implemented dynamic cascading prompts and defined business views.
• Exporting the reports into the required formats.
• Involved in modifying and performance tuning of the existing reports.
• Worked with Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC), managing Schedules/refreshes, Instances and monitoring.

Environment: Crystal Reports XI / v10, BO Enterprise XI, DB2, Sql Server 2000, AS400, WMS (Manhattan Associates Warehouse Management System) Oracle 10g, Oracle Reports 10g, ClearCase and Windows XP

Confidential

IT Developer (Internship)

Responsibilities:

• Involved in analyzing and designing of the project.
• Worked on the report development and implementation process.
• Designed and developed reports using Crystal reports 7.0.
• Created ad-hoc reports, sub reports and cross-tab reports using crystal reports.
• Created formulas using Crystal syntax.
• Created the reports with parameters, section formulas, charts, sorting and grouping options.
• Involved in doing the unit testing of the reports and the application

Environment: Crystal Reports 7.0, Crystal Info, Oracle 8i, IIS, ASP and Windows 95/ NT 4.0