Praveen Kumar

acue9s@r.postjobfree.com ~ 978-***-****

Sr. Crystal Reports Developer

PROFESSIONAL SUMMARY:

7+ years of experience in testing, development and reporting solutions in Pharmaceutical Company and Child Welfare.

Worked in Agile environment and currently working on MiSACWIS Project that follows Sprint Releases

Expertise in Analyzing, planning and designing the business documents.

Expertise in developing, modifying, updating and maintaining SAP BO Crystal Reports.

Worked on SAP Crystal Reports 2008, XIR2 and 2011 and 2013.

Worked extensively in developing Class Diagrams, Sequence Diagrams and Use Case Realization Diagrams based on Business Logic and Design Specification Documents

Worked with different teams in reviewing the reference data scripts (seed data) and promoting the same to higher environment databases

Involved in creating and delivering the reports as requested.

Experience in working with the Business documents and the specifications related to the Michigan State reports.

Experience in creating commands, parameters, grouping data, using calculations within the crystal reports and mapping the stored procedures from packages to the crystal reports.

Experience with the IBM tools used for defect tracking and code check in.

Building and supporting other team members' usage of their reports on Crystal Enterprise.

Complete project lifecycle (SDLC) experience in various projects.

Extensive experience in writing Functional Test Plans, Test Cases and Test Scenarios for Manual and Automated testing for various Business Applications.

Worked extensively with report developers/Database team(s) on improving performance of the report(s)/Underlying queries.

PL/SQL Procedures, functions and packages with databases like Oracle 11g/10/9i

Worked with different database(s) configuring environment(s) using ODBC as well as Native connections.

TECHNICAL SKILLS

Databases Oracle 9i/10/11g, TOAD, SQL Server 8.0/2000, DB2, MS Access

Reporting Crystal Reports 2008, XI R2, Business Objects 3.1 and 4.1 Server, Knowledge on SSRS

BI tool IBM Cognos Software

Languages C, SQL, PL/SQL, Java, HTML

OS Windows 8, 7, XP, 98, 2000/NT, 7, Macintosh OS

PROFESSIONAL EXPERIENCE

STATE OF MICHIGAN PROJECT (UNISYS - Implementing partner)

Location: Lansing, Michigan

Duration: September’11 to Current

Role: Sr. Crystal Reports Developer/ Business Objects

Project: Michigan Statewide Automated Child Welfare Information Systems (MiSACWIS) and Child Care Fund(CCF Budget Reports)

MiSACWIS is a web-based information system that provides a comprehensive case management, intake, investigation, provider, financial, administrative, CCF budget tool for managing all child protection and child welfare in Michigan State. MiSACWIS provides immediate access to statewide data to share information, manage caseloads, and maintain accurate data for reporting and case management. Reports were developed based on the prototypes, data definitions, document parameters and final detailed business rules.

Responsibilities:

Worked on design specification documents and attended Business and Architecture Round Table meetings

Worked with system analyst and was involved in designing Class Diagrams, Sequence Diagrams and Use Case Realization Diagrams in Rational Software Architect IBM tool.

Involved in designing Crystal Reports using Crystal Reports 2008 and then involved in migrating the reports from version 2008 to 2011 and 2013

Developed PL/SQL code for displaying data within crystal reports and mapping each report to its own package.

Experience with the reports related to different modules in the application such as case, intake, investigation, provider, finance, administration and CCF (Child Care Fund).

Experience with the types of adoption subsidies and court reports.

Experience with the creation of Subreports within the crystal reports and have implemented the running totals, grouping of data, usage of formulae for age, date of birth, time period calculations and displaying the check boxes within the reports.

Experience in creating the crystal reports in pdf and word formats.

Worked with the UAT team in analyzing the defects related to the Children’s Protective Services reports, Court reports, Home evaluation reports, Adoption assessment reports and Investigation reports.

Experience in creating the report data within the MiSACWIS Application.

Created Packages, Functions and PL/SQL Stored procedures for processing business logic within different database schemas.

Worked as a seed data/reference data team member in reviewing the seed data scripts and to promote the same to higher database environments (from DEV to INT, QAT, UAT and PRD)

Involved in meetings with Business Analyst regarding the business documents related to the reports and actively worked with the database administrator for saving the code within the repositories and code promotion from DIT, integration environment till the QAT, UAT and PRD environments.

Involved with reporting team during entire life cycle to detect the issues during development phase and avoid those when moved to UAT and Production.

Analyzed the Queries being submitted for monthly and weekly reports from Crystal reports Enterprise system and optimize the SQL queries.

Experience in troubleshooting the existing reports at the time of performance testing and validating them in different testing environments.

Experience to determine the best formats to use to display the data within the reports.

Performed end to end testing of the reports designed against Oracle database.

Modified existing Stored Procedures and ‘Command’ which were being utilized by Crystal Reports.

Design, Develop and Unit test the reports against development and publish the report in development Business Objects Enterprise.

Environment: SAP Crystal reports 2008, 2011 and 2013(SAP Business Objects), 11g -Oracle, SQL Developer, SQLPLUS editor, IBM Clear Case, IBM Clear Quest, RSA/RAD (Rational Software Architect/Rational Application Development) Web Sphere Application Server, Info View, Launch Pad and Windows 7.

Gilead Sciences., Inc (Pharmaceutical Company)

Location: Foster City, California

Duration: July’10 – August’11

Role: Crystal Reports Developer

Project: Submission Management System (SMS)

The Gilead Submission Management System (SMS), based on the Liquent (Parexel) Insight Manager Suite version 4.7 and 5.1, is in use at Gilead as a global standardized central platform for the planning, creation and electronic & paper publishing of regulatory submissions to worldwide regulatory authorities, as well as for the management of Chemistry, Manufacturing, and Control (CMC) product details for use by Gilead’s Quality, Commercial and Pharmaceutical Development departments.

Responsibilities:

Involved in development of SMS reports version 4.7 and 5.1 within the Crystal Reports Tool XIR2 and 2011

Involved in multiple meetings with Liquent Vendor for gathering the data model changes and implementing the approved changes within the code.

Worked on migration of Crystal Reports from XIR2 to the Crystal Reports 2011 Tool.

Involved in deployment of reports in Central Management Console(SAP BO server).

Develop technical system documentation based on the business process workflow.

Code development and support of Oracle PL/SQL packages, procedures, views and functions

Develop Submission Management System (SMS) reports design, using the SAP BO Crystal Reports Tool.

Experience in creating the report data within the SMS Application

Created Subreports, formulae, grouping, running totals, commands and cascading parameter screens implementation in crystal reports.

Worked with the business team and gathered requirements for on-the-fly reports development

Created views, functions, and packages within the Oracle SQL developer.

Created the connections within the Oracle Client using the NetManager to access the queries through Crystal Tool

Supported the Off shore team in fixing the issues related to the reports.

Worked and attended meetings on Project planning and requirements gathering.

Involved in Design and development of business logic using the report specification documents and was responsible for reports deployment at the server end.

Worked on periodic maintenance, enhancement and defect fixing in testing and UAT environment.

Worked with the testing team in reports and application testing (eg: requirements, testing).

Worked under the supervision of team lead to support the existing IT applications.

Environment: Crystal Reports XIR2, 2011(SAP Business Objects), Oracle, SQL Developer and Windows XP.

Supremesoft Corporation

Location: Vienna, Virginia

Duration: Jan’ 09 – May’ 10

Role: Crystal Reports Developer

Project: Benefit Systems

It is a custom designed project to process Incentives and Corporate Benefits for its employees. The Application was developed with Oracle database and Java as front end in Windows environment.

Responsibilities:

Perform data analysis and data validation to ensure accurate reporting results.

Developing complex SQL scripts, stored procedures and worked on SQL tuning.

Create report templates using SAP BO Crystal Reports 2008.

Involved in migration process of crystal reports.

Creating, revising and documenting database procedures and packages of each report in the design specification document for the code flow.

Involved in database testing, wrote SQL queries using SQL developer.

Created and generate complex and ad hoc reports.

Experience with an in-depth understanding of the data model.

Experience in problem solving appropriately while working with a diverse group of individuals.

Worked well independently with organizational and time-management abilities.

Experience with accessing and manipulating data based on the requirements provided by the business team.

Driven to provide timely and accurate reporting.

Investigated, documented software faults and worked with front end application developers to resolve technical issues.

Worked with testing team in providing the navigation details and report execution for completed end to end reports testing.

Environment: HTML, Java, JSP Screens, Rational Software Architect, Oracle SQL Developer, SAP BO Crystal Reports 2008 Tool, Windows NT and Test director

EDUCATIONAL QUALIFICATION

Master’s in Software Engineering from Stratford University

Bachelor’s in Computer Science and Engineering affiliated to J.N.T.U

Contact this candidate