PROFESSIONAL SUMMARY

• Accomplished IT professional with over 4 Years experience in software development including 4 years of experience in Crystal Reports 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 Decisions & Crystal Reports 7.0/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 using PL/SQL wrappers to protect the PL/SQL procedures or packages.
• Strong Knowledge with Star Schema and Snow Flake Schema Data Models.
• Experience using SQL Developer.
• Capable of working in a team and/or individually, self-motivated.
• Experience in working with End Users directly.

SKILLS

OLAP Tools

Crystal Reports 2008/XI/10/9/8,8.5 / Business Objects XI, R2 / R1 / 6.5 / 6 / 5.1

Database

Oracle 10g/9i/8i, MS Access

Languages

SQL, PL/SQL, HTML, XHTML, XML, JavaScript, VBScript, Java(J2EE)

Operation Systems

Windows 9x, NT, 2000, XP, Windows 2003, UNIX

Data Modeling

Oracle SQL Developer

PROFESSIONAL EXPERIENCE

Client: Confidential, BALTIMORE, MD. Aug 2009 Till Date
Role: Crystal Reports Developer

Description:

Confidential, Maryland generates, trades, supplies, and distributes energy. The company operates over 35 power plants in 11 states (mainly Maryland, Pennsylvania, New York, West Virginia, and California) under its operating company Constellation Commodities Group and/or Constellation Generation Group.

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.
• 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.
• 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.
• 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: Oracle 10g, PL/SQL, Crystal Reports XI.

Client: Confidential, Nepal Aug 2001 - June 2003
Role: Crystal Reports Developer

Description:

Confidential, leading software company of Nepal, promoted by IT professionals\' with more than 20 years of experience in the field. It has been working mostly in databases, tools and application products, along with software development and consulting since 1988.

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.

Environment: Crystal Reports 8.0, PL/SQL, Oracle 8i