SUMMARY:

• Accomplished IT professional with over 7 Years experience in Crystal Reports and business objects report development.
• Extensive experience with Designing, Business Objects XI R2/ Crystal Enterprise Server (Publishing, Scheduling, Export/Import, Mailing reports to respective target users in Intranet/Internet).
• Experience with Business Objects XI R2 Components like Central Management Console (CMC).
• In - depth knowledge in working and implementation of Crystal Reports 8.0/9.0/10/XI.
• Managed, instructed, and delegated the development of reports, from the simplest Crystal reports to the most complex projects.
• Created Drilldown Reports, Sub Reports, On-Demand Sub Reports, Label Reports, Chart Reports, Styles and GUI’s.
• Professional in writing complex formulas in crystal reports, SQL queries using Crystal Designer, Crystal Dictionaries, and migration of Crystal Reports in different versions.
• Professional in writing complex formulas in crystal reports, SQL queries using Crystal Designer, Crystal Dictionaries, and migration of Crystal Reports in different versions.
• Experienced in writing SQL statements, PL/SQL code for the database objects.
• Excellent knowledge of data warehousing concepts like, star schema and snowflake schema, data marts used in relational and dimensional modeling.
• Expertise in creation of Views and Stored Procedures.
• Strong Knowledge with Star Schema and Snow Flake Schema Data Models.
• Experience in using SQL Developer.
• Experience in using vlookup, Pivot Table and other advanced features in Excel.
• Capable of working in a team and/or individually, self-motivated.
• Experience in working with End Users directly.

TECHNICAL SKILLS:

OLAP Tools: Crystal Reports 2008/XI, Business Objects XI

Database: Oracle 10g/9i/ 8i, MS Access, MySQL, MS SQL Server

Languages: SQL, PL/SQL, HTML, XHTML, XML

Operation Systems: Windows 2000, XP, Windows 2003, UNIX, Mac OS X 10.6

Service Management: Web Help Desk 10.0.18.7

Data Modeling: Oracle SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, Bethesda MD

Data Manager / Crystal Reports Developer

Responsibilities:

• Interacted with Users and gathered Business Requirements. Mostly involved in making Changes to the existing Reports and updating the reports as per the Requirements.
• Involved in requirements study, design reviews and analysis of input/output flow.
• Responsible for analyzing business requirements and developing queries and reports using BO full client and info view to provide Web-enabled data analysis solutions to business clients.
• Involved in Creating store procedures in MySQL to extract data.
• Coordinating with team members for the database design and Created SQL queries to extract data from MYSQL database.
• Responsible for day-to-day database and reporting problems.
• Handled production issues and tickets using Web Help Desk.
• Responsible for data archiving.
• Responsible for data analysis to clean up data that are not being used by any applications.
• Used Excel to create insert and update statements for database.
• Expert in data formatting and use of pivot table in Excel to analyze data.
• Responsible for uploading backup data for development environment using UNIX command.
• Responsible for writing simple Unix Shell Scripts for base automation of processes for loading and testing.
• Reviewed User Requirements. Created detailed Functional Design Documents and Report design details documents for the reports.
• Resolved the Performance issues/Data issues within the Reports and Procedures.
• Performed Administration tasks for the Project, Which Included Creating Folders, creating users/ Groups on Central Management Console and giving Appropriate Access levels.
• Involved in creating Views and Stored Procedures for Reports.
• Created reports (Canned & Ad-hoc) based on the business requirements using Web Intelligence tools and database.
• Installation and Configuration of BO & Web Intelligence applications for different developers and users.
• Scheduled the Crystal reports & E-mail them to the necessary departments through Info view.
• Created customized existing reports using sub-reports and charts to present information.
• Created the Crystal reports using MySQL tables and tested the reports by cross checking and verifying data against the reports generated from the legacy system.
• Published the reports to the Folders in CMC.
• Created complex report using with Sub report, cross tab, custom functions, formulas and Suppressing conditions and Used advanced features like Dynamic and cascading Prompts.
• Created Graph and chart reports in Crystal Reports.
• Converted Lasso reports into Crystal Reports.
• Exported Reports into PDF, Excel, word & RTF from Enterprise and resolved formatting issues.

Environment: MYSQL, Crystal Reports, UNIX, Mac OS X, Windows Server 2003, Business Objects XI, Web Help Desk 10.0.18.7

Confidential, Baltimore MD

Crystal Reports Developer

Responsibilities:

• Worked as a part of the team responsible for generating reports for the End users and different business teams across different energy plant units.
• Interacted with Users and gathered requirements for the Reports. Mostly involved in making Changes to the existing Reports and updating the reports as per the Requirements.
• Created Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.
• Crystal Reports design, development and Resolve the database connectivity issues.
• Designed, developed and maintained various Complex reports like Sub Reports, Detail Reports and Parameterized Reports, Cross tab.
• Monitored report executions and identified performance issues, worked with DWH SMEs / DBAs to identify root causes for potential database-related issues.
• Published and scheduled the reports in eSOMS (Shift Operations Management System).
• Based on Requirement, Created complex crystal report using the data from SQL Server and Oracle server database.
• Developed Reports using Sub reports and Sub report Links.
• Tested the developed reports and created a report-promotion model for moving the reports in to the production environment.
• Responsible for Installation and Configuration of Crystal Reports XI.
• Responsible for improving report-processing performance.
• Responsible for Creating Views in SQL to protect some of the columns of a table from other users, to hide complexity of a query and to hide complexity of calculations.
• Responsible for Writing Stored Procedures in PL/SQL for better performance.
• Scheduled Reports from Crystal Enterprise enabled Email notification on failure reports.
• Converted all home-developed web reports into crystal reports.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Responsible for creating xml schema for passing parameters to run reports in eSOMS (Shift Operations Management System).
• Passed default values through xml for the parameters used in the report to eliminate the burden of entering parameter values.
• Responsible for preparing requirements, dependency scenarios documents for the reports.

Environment: MS SQL Server 2000, Oracle 10g, PL/SQL, SQL Developer, Crystal Reports XI, eSOMS

Confidential

Crystal Reports Developer

Responsibilities:

• Reviewed User Requirements, Created detailed Functional Design Documents and Report design details documents for the reports.
• Involved in gathering requirements and requirements study, design reviews and analysis of input/output flow.
• Created Crystal reports using the legacy Requirements Documents.
• Created Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.
• Crystal Reports design, development and Resolve the database connectivity issues.
• Designed, developed and maintained various Complex reports like Sub Reports, Detail Reports and Parameterized Reports, Cross tab.
• Published and scheduled the reports in Crystal Enterprise using Crystal Management Console so that reports are accessed from Front-end application.
• Involved in Trouble Shooting all the issues in Crystal Enterprise 10 and Business Objects Enterprise XI.
• Based on Requirement Created complex crystal report using the data from SQL Server and Oracle server database.
• Convert version 8.5 Crystal Reports to version XI using migration tool supplied by Business Objects.
• Responsible for creating triggers in PL/SQL to restrict access to specific data and data modifications.
• Scheduled Reports from Crystal Enterprise enabled Email notification on failure reports.
• Written complex SQL statements using joins, sub queries and correlated sub queries.