We provide IT Staff Augmentation Services!

Data Manager / Crystal Reports Developer Resume

Bethesda, MD

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.

Hire Now