SUMMARY:

• Over 7 years of experience in the development of Crystal Reports/Crystal Enterprise 9/10/XI/2008, Windows NT, SQL Server 2005 with experience in the software development life cycle.
• Experienced in Analysis, Design, Development and Testing of Reports.
• Worked on various reports using multiple RDBMS including Oracle, MS SQL Server, MS Access and associated SQL Dialects such as Transact SQL (T - SQL), PL/SQL etc. in Windows XP/NT/2000.
• Good experience in generating Sub Reports, On Demand Reports, Linked Reports, Mailing Labels, Cross Tab Reports and Graph Reports. Expert in using global and shared variables across the crystal reports.
• Experienced in developing various Charts and Graphs like Line graphs, Bar charts (Side by side, Stacked), Pie-charts etc., using Chart expert in Crystal reports.
• Expert in writing complex formulas at the summary level and group level to implement the business logic.
• Developed stored procedures, views, functions etc. using SQL, PL/SQL, T-SQL.
• Work experience in Business Intelligence using Crystal Reports, Crystal Repository and Crystal Enterprise, good working knowledge for building enterprise reports.
• Ability to work individually as well as in a team.
• Very good in documenting the testing process and test evaluation summary.
• Experienced in the migration of crystal reports in different versions, writing complex formulas in crystal reports, SQL queries using crystal designer.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle. Excellent communication skills, both written and verbal.

TECHNICAL SKILLS:

Reporting & Analysis Tools: Crystal Reports 2008/XI R 2/10.0/9.0/8.5/8.0, Crystal Enterprise 10/9.0, BO Info View, CMC, SQL Designer, CSP and MS Excel

RDBMS: Oracle 10g/9i/8i, MS Access 2007, SQL Server 2005

Programming Languages: SQL, PL/SQL, T-SQL, C

Operating Systems: WINDOWS XP/NT/00/98/95

Others: TOAD, AQT, SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, Appleton, WI

Crystal Reports Developer

Responsibilities:

• Installation and configuration of Crystal Reports 2008.
• Interaction with users in analyzing the requirements for report development and also involved in help desk support for resolving the user issues.
• Created complex formulas at the summary level and group level to implement the business logic.
• Scheduled the report using Schedule Manager in Crystal Management Console to run every day on a periodic basis.
• Created production/Development reports using Crystal Reports.
• Created Procedures, Views & Functions in database. Set user logons and permissions and securities to the reports.
• Responsibilities include conducting meetings, gathering requirements and users.
• Coordinating with testing team.
• Developed various Drill-down, Cross tab, and Grouping reports using Crystal Reports depending on Business requirements.
• Reviewing and modifying existing use cases.

Environment: Crystal Reports 2008/XI/10, CMC, MS Access, Oracle 11g/10g.

Confidential, Richmond, VA

Crystal Reports Developer

Responsibilities:

• Meetings were coordinated with business users and development teams to gather System requirements and data requirements.
• Unit testing was performed for each and every report.
• Assisted users in organizing the report data into pivot tables after they export it into excel.
• Involved in design, development and documentation on various phases of product life cycle.
• Simple prompts were applied in Crystal reports.
• Developed various DDL and DML procedures as per client requirements.
• Oracle 10g and MS SQL Server 2005 databases and created complex stored procedures or views according to the requirement for the reports.
• Developed reports in Crystal XI and Deployed and scheduled reports in Crystal Enterprise 10.
• Designed and developed Crystal Reports, the Cross Tab Reports, Top N Reports for displaying vital data and summary reports with drill-down capabilities.
• Performed admin tasks related to users, groups, folders, and security using Crystal Management Console (CMC).
• Conducted discussions with Business Analysts (BAs) and end users to create several test scenarios for running the reports.
• Designed reports connecting multiple databases - Oracle and SQL server 2005.
• Developed MS Access Pages using .Net for billing project which is used by Top level management group for better management of the projects.
• Used stored procedures to accommodate user parameters and get rid of database complexities.
• Worked on already existing reports to optimize and troubleshoot problems that occurred due to new business requirements.
• Used ASP to create different intranet portals for Billing project.
• Provided On Call Support and end report testing after reports are deployed to production.
• Added the access management by creating users, user groups and folders.

Environment: Crystal Reports XI/10, Crystal Enterprise 10, Oracle 10g, MS-Access, TOAD, DTS, SQL Server 2005, MS SQL Server Management Studio, Visual Studio 2005, Visual SourceSafe.

Confidential, Madison, WI

Crystal Reports Developer

Responsibilities:

• Involved in the Design, Development and Implementation of Crystal Reports 10.
• Migrated reports from Crystal Enterprise 9 to Crystal Enterprise 10.
• Deployed the reports in the Corporate Intranet using Crystal Enterprise.
• Responsible for creating the Complex Crystal Reports (On demand, AdHoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-down, Dynamic grouping, Cross-Tab, graphical, aging reports).
• Created complicated formulas and running totals on summarized totals for business measure calculations based upon various end user requirements and also used functions.
• Created nested and conditional groups and formatting features in reports.
• Involved in creating various PL/SQL stored procedures, views, functions and temporary tables for data input to the Crystal Reports.
• Exported reports to various formats like MS Excel, PDF, MS Word, Text, CSV etc.
• Raised report alerts when certain conditions are met as requested by the user.
• Scheduled the reports, maintained the events using Crystal Management Console.
• Existing Crystal 9 reports are migrated to Crystal 10.
• Published reports on web using the ePortfolio to make the reports available on the web.
• Administered user access and published permissions to the reports. Created and managed user groups and folders.
• Generated reports on various databases. Developed reports by using two different databases at a time.
• Tested output of reports using SQL queries in Toad to verify whether the report has met the user requirements or not.
• Responsibilities include conducting meetings, gathering requirements and users.

Environment: Crystal Reports 10/9, Oracle 10g, MS Access, SQL Server 2005, Windows NT.

Confidential . Goldsboro, NC

Crystal Reports / SQL Developer

Responsibilities:

• Migrated Existing Crystal 9 Reports to Crystal 10.
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports 10.
• Developed new reports along with modifying existing reports to support new and additional Business requirements.
• Used prompts, alerts, drill down analysis as per the end user requirements.
• Developed Database connections, SQL joins, loops, views and aggregates.
• Used Shared and Global variables to pass data from Main report to Sub report & Vice Versa.
• Developed several Complex Reports, various features used include Multiple Groupings, Drilldown, Parameter fields, Formulas and Conditional formatting using Crystal Reports.
• Involved in the development of client side program units and sharing them among multiple applications for processing business logic in the database.
• Developed database objects like Tables, Views; created Indexes, and Sequences.
• Gathered the requirements from the varied clients from different departments and translated the business details into technical design.
• Responsibilities include conducting meetings, gathering requirements, users, also setting up and troubleshooting final product on user’s desktops.

Environment: Crystal 10/9, Oracle 10g/9i, SQL, Windows XP, UNIX.

Confidential, Smyrna, GA

Crystal Reports Developer

Responsibilities:

• Designed, Developed and Implemented Reports in Crystal Reports 10/9.
• Created the Complex Crystal Reports (On demand, AdHoc Reports, Summary Reports, Sub Reports, Drill-down, Dynamic grouping, Cross-Tab, graphical).
• Created Sub reports called from the main report to implement the business logic.
• Created Reports using Procedures and Views for faster execution.
• Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie -Charts etc., by using Chart expert of Crystal Reports.
• Based on the users requirement, Created Parameter driven reports to restrict the volume of data.
• Used Global Variables & Shared Variables to attain the crystal functionality
• Developed Reports on both projects for Oracle and SQL server
• Tested output of reports using SQL queries in SQL Enterprise Manager/Query Analyzer to verify whether the report has met the user requirements or not.
• Modified existing reports according to the user’s requirement and exported reports to PDF format.
• Used Crystal Viewer for running the reports and exporting them to various formats.
• Scheduled reports to run on daily/weekly/monthly basis and to distribute the output in different formats to various users.
• Conducted meetings with Business Analyst and users to get the requirement correctly and finished the tasks within the time frame.
• Created new reports and also modified many reports and successfully completed the project within the time given.

Environment: Crystal Reports 10/9/8.5, Crystal Enterprise 10, Oracle 10g/9i, Windows and MS Access, PL/SQL, Win NT, Visual Studio

Confidential

PL/SQL Developer

Responsibilities:

• Wrote PL/SQL stored procedures and triggers to implement business requirements.
• Involved in fine tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features.
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Involved in optimizing SQL statements using Indexes and Hints.
• Used SQLLoader and external tables to load data from text files into the database.
• Involved in creating and maintaining Partitioned Tables and Indexes
• Made use of the REF CURSORS in stored procedures for report generation.
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.
• Extensively worked with DML Triggers.
• Involved in writing complex SQL statements.
• Created UNIX shell scripts to invoke the SQL scripts which are run daily.
• Involved in creating stored procedures and packages with DYNAMIC SQL.
• Involved in analyzing the schema, so that the costs can be efficiently utilized by the optimizer.
• Involved in creating user roles.
• Involved in comparing Production data with Test data for identifying and cleaning corrupted data.

Environment: SQL, PL/SQL, Oracle 9i, TOAD, SQL Plus, PL/SQL Developer, HP-UX 11i v2.