Management Crystal Reports

BEERAM

*********@*****.***

SUMMARY

Software Developer with more than 14 years of experience in developing software in Analysis, design,

development, testing and validating the applications and working with Crystal Reports, Business

Objects Reports, Universe Design, Sybase/Oracle, SQL, SQR, XML, Visual Studio.Net, Remedy, Quality

Center, Document Management System for major clients in industries like Pharmaceutical, Insurance

and Telecommunication. Highly motivated team player, self-starter with excellent interpersonal

partnering skills, with ability to interact effectively with all levels of staff. Excellent presentation,

interpersonal and communication skills. Ability to work under pressure and meet aggressive deadlines.

TECHNICAL SKILLS

RDBMS: Oracle, Sybase, Access, MS SQL Server 2005

Operating Systems: Win XP, Win 2000, Win NT, Win 98, UNIX, MS-DOS

Software: Crystal Report XX, Crystal 2008, Crystal Enterprise, SQR, Business Objects

Development App: TrackWise 8.x, Webadmin, Remedy, Document Management System (DocSpace

version 6.7), HP Quality Center 10.0, T-SQL, Stored Procedures, Views,

Triggers, HTML, Shell Scripts, Crystal Reports, Crystal Enterprise, Crystal SQL

Designer, Business Objects, SQR, SQL Plus, PL/SQL & Toad

PROFESSIONAL EXPERIENCE

Johnson and Johnson, Raritan, NJ

Lead Analyst/Crystal Reports Developer March 2012 - Present

Working as a consultant for several TrackWise applications in Johnson and Johnson, such as Event

Tracking System (ETS), Change Control, Commitment Tracking System (CTS) and Audit

Management.

• Worked in a Lead analyst role for development project – Audit Management. Created user

requirements, functional requirement, reports functional specification document, writing system test

scripts, report test scripts and executing system and reports test scripts.

• Contributed in writing and reviewing different Validation documents – User and Functional

Requirements, Test protocols (IQ/OQ) for Change Control, and Audit Management.

• Managed all test activities in Quality Center.

• Developed several new reports/update existing reports (using Crystal Report XI and 2008)

for ETS – Batch release detail report, Full detail reports, Audit reports, Change Control Summary report

etc.

• Created different types of Crystal reports including: Cross-tab, Conditional, Drill-

down, Summary, Details and Sub reports.

• Carried out the migration of existing reports from Crystal Reports version XI to Crystal

Reports 2008.

• Participates in all phases of the report development lifecycle, including analysis, design,

creation, test, and maintenance of reports.

• Provided production support for Level-3 issues (users unable to login, system issue records

are stuck, unable to approve the records..) represented Application support team in the Change Control

Board (CCB) meetings, prepared and presented Monthly Metrics for support activities.

• Provided support for maintenance of the TrackWise system : user account management, static

data management (selection values), data management for record resets (TR resets), login

issues, system issue using webadmin and other TrackWise tools in TrackWise System.

Created/processed/closed the request using Incident management tool (Remedy) .

• Loaded master data using selection Import Utility.

• As a lead analyst involved in ensuring that the Change Control and Audit Management were

configured and validated to be in compliance with 21 CFR Part 11 regulations and GMP regulations.

• Document Management System (Docspace) used to create and manage controlled

documents, reference documents and change notices.

• Described the test approach for Base Business and Projects using the Quality Center tool to

support the testing activities. Quality Center has four modules that will be utilized for testing. They are

Requirements, Test Plan, Test Lab, and Defects.

MERCK & CO., INC., Summit, NJ August 2005 – February 2012

Lead Analyst/Crystal Reports Developer

Successfully collaborated cross-functionally with business users, site users, and technical lead to gather

requirements and developed approximately 300+ reports in Oracle and Crystal Reports, version XI for

several Quality Management Systems. These were in commercial Pharma business such as Cycle time

reports, Change volume status, CAPA reports, Workload reports for various business processes such as

CAPA, Global Change Management, Deviations Management, Validation Document Tracking, Internal

Audits and Customer Complaints. These reports facilitated efficiency in business processes. Additionally

provided application support responsibilities for TrackWise System.

Analyzed and made Specifications for the development of the reports. Designed and developed

•

Crystal Reports (main and sub reports) using Queries, Stored Procedures & Views.

Created different types of Crystal reports including: Cross-tab, Conditional, Drill-down, Summary,

•

Details and Sub reports.

Created reports include formatting options such as Charting, Grouping, Sorting, Parameter prompts.

•

Carried out the migration of existing reports from Crystal Reports version 8.5 to Crystal Reports

•

version 9.0 and also from Crystal Reports version 9.0 to Crystal Reports version XI.

Scheduled the reports for delivery via Crystal Enterprise Version 10.

•

Developed and executed developmental testing and user acceptance testing of the reports and

•

managed testing activities.

Prepared, performed and participated in execution of test scripts during development and user

•

acceptance testing. Prepared the Design specification documents and testing documents for Crystal

reports. Qualified the reports into production using Change Management. Provided Crystal Reports

training for other programmers.

Provided support for maintenance of the TrackWise system: user account management, static data

•

management (selection values), data management for record resets (TR resets) using webadmin and

other TrackWise tools in TrackWise System.

Validations Testing

Duties included conducting testing and validation of software utilizing 21 Code of Federal Regulations

(21CFR, Part II) guidelines. Used corporate standards and templates in writing Test Protocols, IQ/OQ/PQ

Protocols, executing them and writing their respective summary reports.

• Tested protocols and prepared their test reports.

• Organized meetings with the users to analyses and gather requirements.

• Supervised testing team for the progress of work.

• Analysis, design, development, testing and validating the applications.

• Involve in writing and updating Standard operating procedures (SOP) for GMP (Good

Management Procedure application).

Maintained Global Quality Tracking website which contains instructions for getting access to the

application, the type of training users need to take, procedure users need to follow, contact information,

etc.

PRUDENTIAL, Roseland, NJ May 2000 – July 2005

Crystal Reports Developer/ Business Objects

Developed reports in Oracle and Crystal Reports to track the number of applications submitted to

Prudential either as result of informal inquiry process or a formal application. Quantified number of cases

requesting quote from Prudential of the total cases entering informal inquiry process.

Designed and developed reports using Queries, Stored Procedures & Views.

•

Created different types of reports including: Cross-tab, Conditional, Drill-down, Summary, Details

•

and Subreports. Modified reports content and export reports in multiple formats based on user input.

Wrote documentation for users on how to select necessary parameters and date frames for different

•

selections.

Designed and developed universes and reports Using Sybase and Business Objects to generate

Commissions reports for Prudential General Agency and Third Party General Agency to produce amount

of commission earned on Monthly, Quarterly and Yearly basis. Main purpose of system is to generate ad

hoc reports and manage data. Prepared the document for how to retrieve the reports from the repository

and how to run the reports for first time users using Business Objects Report Module and Web

Intelligence tool, also conducted training to some of our developers how to develop complex reports

using Business objects.

Designed and developed Universes or semantic layer for reports generation.

•

Created Reports using Web Intelligence with multiple data providers and writing complex queries.

•

Created User Objects including Dimensions, Details and Measures.

•

TSR CONSULTING COMPANY

(Credit Suisse First Boston), New York, NY February 1999 – April 2000

Crystal Reports Developer

Developed complex reports for Loan Syndication department using Crystal Reports with Sybase

backend for Commercial Loan Project. The report covers all aspects of the Loan syndication business

from Customers, (Sub) Participants to Deals, Facilities and Outstanding. The information resides in more

than three hundred tables; it requires both understanding of the business concept and in-depth skills of the

SQR language to implement the reports.

Created different types of reports including: Cross-tab, Conditional, Drill-down, Summary, Details

•

and Subreports. Modified report content and export reports in multiple formats based on user input.

Carried out application maintenance as per customer requirements, which involved altering of

•

existing reports and the addition of new ones.

AT&T, Short Hills, NJ March 1997 – January 1998

Programmer

Designed and developed Billing and Order Tracking systems using Sybase and Crystal Reports for

AT&T internal clients.

System tracked the information such as billing, promotions and customer status. Loaded data

•

from flat files to database, and ran programs to generate daily, weekly, monthly, yearly reports.

Wrote documentation for users on how to select necessary parameters and date frames for different

selections.

SYSTEM HOUSE INC., New York, NY January 1996 – February 1997

Programmer

Developed Accounting and Taxing subsystems using Sybase and People soft SQR, Crystal Reports in

UNIX Environment.

Verified the license information for a given trade and also to compute and generate tax information

•

for trade. Tested and maintained existing application and created Shell Scripts to run the applications.

EDUCATION

BS, Computer Applications, Osmania University, India

Contact this candidate