SUMMARY:

• Over 8 Years of professional experience in Software System Design, Development, Testing and Implementation of Client/Server Applications using Oracle/ SQL - Server and Visual Basics, Generating Reports using Crystal Reports, Business Objects with data source of SQL, MS-Access 2003/2007, SQL-Server2005/2008, DB2, Oracle Trackwise database, Cache database, Oracle8.0/8i/9i/10g/11g and their earlier versions.
• Including Over 8 years of experience in Crystal Reports: Five plus Years of experience in Crystal Reports XI R1, R2 and Three years of experience in Crystal Reports 2008.
• Including Over 4 Years of experience in Crystal Enterprise and CMC, Business Objects InfoView of Business Objects Enterprise.
• Created summary and Drill Down reports, Implemented summary operations of Grand totals, Subtotals and other Summary fields as Minimum, Maximum and Average etc.
• Declared Local and Shared variables between the Main report and Sub-report, created Running Totals with variables.
• Did Record selection using Select Expert and edited the Select formula directly.
• Did Group selection and adding Parameters and LOV'S to the report
• Built Linked and Unlinked Sub-reports.
• Built Cross-tab reports to show data in grid.
• Created Business Views for several reports with Dynamic Cascading Prompts.
• Creating Folders and Managing Folders, Users and User Groups in Central Management Console (CMC) and setting up user and folder access level controls.
• Involved in Publishing and Scheduling of reports in Crystal Enterprise/ Business Object Enterprise environment.
• Assigned user rights with passwords and user access level rights on Infoview for viewing of specific reports only assigned to the designated users to test and run reports and evaluate report data.
• Expertise in defining queries, testing queries, Performance tuning and Query Optimization.
• Exported Reports to Excel, PDF, Word and CSV files.
• Created Queries using Oracle SQL Developer and TOAD.
• Used PERFORCE, Rational Clear Case, Visual Source Safe (VSS) and Subversion (SVN) Version control tools.
• Involved in Unit testing and Integration testing of system interfaces.
• Very good analytical and teamwork skills.
• Excellent communication and interpersonal skills.

COMPUTER SKILLS:

• Operating Systems Windows 95/98/NT/2000/XP, UNIX
• Programming Environment Visual Studio 6.0, Visual Studio.NET 2003, Home Site editor
• Programming Languages C, Pascal, She ll scripting.
• Reporting Tools Crystal Reports 8.5/9.0/10.0/ XI R1/R2/2008, SSRS 2005/2008, SAP Business Objects XI R1/R2 and R3, WEBI Reports, Data Reports and MS Access Reports Internet Programming HTML, DHTML
• Tools Oracle SQL Developer and TOAD
• Database MS-SQLServer 2000/2005/2008 , MS-Access97/2000, Visual FoxPro, Oracle7.3/ 8.0/8i/9i/10g, Cache database and Oracle Trackwise database
• GUI Visual Basic 6.0 (ODBC, DAO, ODBC-Direct, RDO, OLE DB, ADO),
• Oracle Forms 6i
• Developer2000 (Forms4.5/5.0, Reports2.5/3.0)
• Web Servers Personnel Web Server (PWS), Internet Information Server (IIS 5.0/6.0
• Testing Tools Load Runner, WinRunner 7i and Test Director 6.0i/7
• Configuration PERFORCE, Rational Clear Case, Visual Source Safe (VSS),
• Management Tools Subversion (SVN)

PROFESSIONAL EXPERIENCE:

Confidential , Whitehouse Station, NJ

Crystal Reports Developer.

Responsibilities:

• Gathering requirements from business users and creating Design Documentation for Reports
• Creating new Reports in Crystal Reports with the source of Oracle Trackwise database.
• Deploying the Reports in to Development server and running from Trackwise development application.
• Creating customized queries in Trackwise and running the reports for current query to make sure getting the expected results.
• Displaying the records of the reports based on the record state.
• Creating Dynamic parameters for the Crystal Reports to maintain update database LOVs.
• Creating Running Totals for the approval information page of the reports, formulas and handling null values in report formulas.
• Updated report record selection according to new business requirements and updated new project names
• Creating Sub reports and linking the Sub reports to main report for the Grid fields.
• Reviewing the created reports in the meetings with business users.
• Attending Domain, application and project specific trainings within the organization.
• Maintaining the reports in Tortoise Subversion version control tool for version history.
• Exporting reports into PDF, Excel formats to analyze the data.
• Experience working in cGMP/ Compliance.
• Working on environment migration related documents.
• Created revision history documentation for Crystal reports.
• Completed GMP Trainings within the organization.
• Woking on Analytical, Drug product, Drug Substance and Equipment/ Facilities/Computer Systems projects.
• Maintaining the meeting related notes on SharePoint folder.
• Modified Single record reports for workflows.

Environment: Windows XP, Share Point, Crystal Reports 2008, Oracle 10g and Oracle Trackwise Application 8.3.2, TOAD, MS-Access 2010 and MS Office 2010, Tortoise Sub Version(SVN).

Confidential ., Peapack, NJ

Crystal Reports Lead

Responsibilities:

• Responsible for migration of Crystal Reports from XI R1 to Crystal Reports 2008 for QTS Latin America, QTS Italy, QTS Asia, QTS Ireland/Singapore, QTS Australia\New Zealand, QTS Europe, SLS and L- Wyeth sites.
• Documented RSV (Requirements Specification Verification) and DS&TS (Design Specification and Technical Specification) of Crystal Reports for QTS Latin America, QTS Italy, QTS Asia, QTS Ireland/Singapore, QTS Australia\New Zealand, QTS Europe, SLS and L- Wyeth sites.
• Worked extensively on Single, Multi Record Crystal Reports of Trackwise.
• Extensively involved in using of Formula Fields, Parameter Fields, Group Selection and Record Selection and Running Total fields in Crystal reports.
• Modified Action Item Detail, Audit Trail, Change Control, Commitment Tracking, Interim Report, Parent Chid Reports and Investigation Detail etc.
• Published Crystal Reports to Business Objects Enterprise Server.
• Involved extensively working on improving performance of slow running reports.
• Presented Crystal Reports to Business Users in cell meetings for Review to make sure standards are followed.
• Involved in Unit Testing and fixing issues in the Reports.
• Created Ad-hoc reports in WEBI to make sure PGS DW Universe is returning correct data.
• Provided Data Analysis capabilities within WEBI report by using Drill features.
• Worked with Microsoft VSS (Visual SourceSafe) 6.0 to manage different versions of Reports.
• Prepared Documentation for user training and trained the users on ad-hoc reporting.
• Tested modified Reports with UAT data to make sure getting the correct results.
• Point of contact for any UAT/Production issues.
• Implemented and Tested the SQL queries in TOAD
• Completed GMP training and created compliance documents.
• Involved in resolving exceptions/ deviations in the reports and RSV documents during UAT and Production.
• Provided training to Users on Scheduling Reports on Demand.

Environment: Windows XP, Share Point, Crystal Reports 2008, SAP Business Objects XI 3.1 (Business Objects Enterprise Client Tools Infoview ), Oracle 10g and Oracle TrackWise Application 8.0, TOAD, MS-Access 2003 and MS Office 2003, Microsoft Visual SourceSafe 6.0

Confidential ., Peapack, NJ

Crystal Reports Developer

Responsibilities:

• Installation of Crystal Reports 2008, Business Objects XIR2, Business Objects XI 3.1 (Business Objects Enterprise Client Tools), Oracle10g and SQL Server2005, Microsoft Visual Studio2005 software’s.
• New development of Crystal Reports and modification in the existing Crystal Reports.
• Creating new WEBI Reports
• Published the newly created reports to Production.
• Completed GMP training and created compliance documents.
• Provided support to Oracle Trackwise Crystal Reports and Updated report record selection of the reports, created new parameters and updated and mapped new fields to the reports.
• Managing groups, Users, Folders in Business Objects Enterprise Server
• Grant permission to groups for running reports In the Business Objects Server
• Password management for end users
• Resolving the user logon issues to the Info view
• Knowledge Transition Sessions
• Providing support to multiple applications within the Pfizer
• Responsible for resolving the ticket with adherence to SLA
• Converting the entire .Net Application to Crystal Reports
• The .Net search logic was implemented with the help of Crystal Reports Dynamic Cascading prompts.
• Built Sub Reports, Drill Down Reports and Cross Tab Reports.
• Passed the sub report values to the main reports Using Shared Variables
• Publishing the newly created Crystal Reports to the BO Enterprise Server.
• Implemented and Tested the SQL queries in TOAD
• Tested the modified Reports with UAT data to make sure getting the correct results.
• Provided training to the Users on Scheduling the Reports on Demand.

Environment: Windows XP, Share Point, Crystal Reports 2008, SAP Business Objects XI 3.1 (Business Objects Enterprise Client Tools), Business Objects XI R2, QlikView9.0, Oracle 10g/11g/9.0, TOAD, SQL-Server 2008/2005, SSRS 2008/2005, MS-Access 2003 and MS Office 2003, Oracle Trackwise, Visual Basic 6.0,and Microsoft Visual Studio2008

Confidential, Berwyn, PA

Crystal Reports Developer

Responsibilities:

• Gathering the requirements from business users and create the design documentation.
• Data mapping from the old legacy system to new s42 system
• Created Quote, Lease, Sale and Purchase Order Report documents
• Created the Legal document reports for the Quote, Lease and Sale docs
• Created Accounting, Collection and Sales reports
• Implemented conditional groupings, sorting for the reports
• Developed the reports in Prototype Schema and Published them in to the S42 System
• Implemented and Tested the SQL queries in TOAD.
• Created SQL command objects for the report generation.
• Built sub reports, Cross Tab Reports
• Created Drill Down Reports
• Passed the sub report values to the main reports Using Shared Variables
• Managed null values in data table and in selection formula
• Created Reports Using the Crystal Reports 2008 version.
• Converted reports from Oracle database to SQL-Server database.
• Installation and configuration of SQL Server Reporting Services (SSRS) 2008.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, adhoc reports through Report Builder.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
• Involved in creating report models and applying row level security filters for report model.
• User signoff, QA and User training, Interaction with the End Users.

Environment: Windows XP, Share Point, Crystal Reports 2008, S42 Application, Oracle 10g, TOAD, Tortoise Sub Version(SVN), SQL-Server 2008, SSRS 2008, MS-Access 2003 and MS Office 2003.

Confidential, Boston, MA

Crystal Reports Developer

Responsibilities:

• Involved in identifying, studying and analyzing the requirements from business users.
• Resolved the Business questions through emails and Phone communication.
• Created various kinds of reports using Crystal reports XI R2
• Created Service Agreement Letter and Service Authorization Reports
• Created Mailing Label Reports
• Created Billing Invoice and Billing authorization Reports
• Created reports using the Crystal Drill Down functionality and Group Sort functionality
• Created reports using the Sub Reports report category
• Created formulas for conditional formatting of the reports.
• Passed the sub report values to the main reports Using Shared Variables
• Created Parameterized drill down reports for Operational and Account reports
• Created Reports in Crystal client and copied the created reports in to the Third party Avatar Application.

Environment: Windows XP, Cache database, SQL- Server 2005, Crystal Reports XI R2, MS-Access 2003 and MS Office 2003, Epic, Citrix Server and Avatar application

Confidential, Herndon, VA

Crystal Reports Developer

Responsibilities:

• Studying and analyzing the requirements from business users.
• Created detailed understanding document on business needs and created process flow
• Participated in improving existing process to meet business needs
• Provided support to the Web Users for any specific or performance issues related to the reports
• Wrote formulae’s to display the result’s on the report the way user’s wanted.
• Deployed the reports to Test, UAT, and ACCPT, IP and Production Environment’s and resolved issues related to deployment.
• Created various crystal functions for enhancement of Crystal reports.
• Worked Extensively with CMC (Central Management Console) and all the tools of Business Objects Enterprise.
• Trained end user’s how to access reports from INFO VIEW.
• Scheduled reports and exported them to PDF, Excel formats.
• Worked as production support and resolved issues related to servers, reports and end user access.
• Worked with chain management tools like Clear Quest, Requisite pro and Rational Clear Case.
• Created detailed understanding document on business needs and created process flow.
• Participated in improving existing process to meet business needs.
• Interacted with other analysts in team to identify impacts on current system.

Environment: Windows XP, Crystal Reports XI R1, Crystal Reports XI R2, Business Objects XI, Business Intelligence (Info view), Business Objects XI R1, Business Objects XI R2, Ab Initio

(GDE 1.13, Co-Op 2.13), Oracle 10g/11g, Rational Clear Case, Rational Clear Quest, Rational Requisite Pro, MS-Access 2003 and MS Office 2003.

Confidential, Herndon, VA

Crystal Reports Developer

Responsibilities:

• Created detailed understanding document on business needs and created process flow.
• Participated in improving existing process to meet business needs.
• Created Sub reports in crystal reports. Implemented conditional grouping, sorting and messages in Crystal reports
• Created a Report template and reused the same template again and again to create Crystal reports
• Gathered user inputs and incorporated business requirements to generate functional specs and subsequently created customized reports.
• Created views and updated the views when requirements changed.
• Developed Crystal reports using Command prompts.
• Developed Crystal Reports with Dynamic prompts and Cascading prompts
• Developed Crystal reports with Sub-report.
• Used shared variables to pass values from sub report to main report to get the excepted results.
• Developed Cross Tab Report’s.
• Deployed the reports to Test, UAT, and ACCPT, IP and Production Environment’s and resolved issues related to deployment.
• Worked Extensively with CMC (Central Management Console) of Business Objects Enterprise.
• Changed the Database connections in the CMC for the reports according to the business requirements.
• Worked with the ETL team to resolve issues related to data.
• Trained end user’s how to access reports from InfoView.
• Scheduled reports and exported them to PDF, Excel formats.
• Worked with chain management tools like Clear Quest, Requisite pro and Rational Clear Case.

Environment: Windows XP, Crystal Reports XI R1, Crystal Reports XI R2, Business Objects XI, Business Intelligence (Info view), Business Objects XI R1, Business Objects XI R2, Ab Initio

(GDE 1.13, Co-Op 2.13), Oracle 10g/11g, Rational Clear Case, Rational Clear Quest, Rational Requisite Pro, MS-Access 2003 and MS Office 2003.