Sr . Crystal Reports / Business Objects Developer

Rahul Kumar

Phone No: 443-***-****

E-mail: *.*****@*******.***

(Senior Crystal Reports Business Objects Developer)

• 7 years of total IT experience.

• 5+ years of Crystal reports Development.

• 3+ years of Business Intelligence Business Objects experience.

• 2+ years of Data Modeling.

Summary

• IT experience: 7 years of Total IT experience including 5+ years of experience in Crystal Reports development.

• Crystal Reports: 4 years of experience in Crystal XI /10/9/8.5 and 1+ year of experience in crystal 2008. Worked in various Crystal Environments extracting data from multiple sources, applying several functionalities and used different Data providers like OLEDB, ODBC, etc. Created compelling reports with stunning visualizations using Crystal 2008.

• Business Intelligence: 3+ years of Business Intelligence experience in building universes, developing reports, and analyzing OLAP data. Worked in various BO environments linking data from multiple sources, applying several functionalities, and using various Data Providers. Trained users in producing documents and running queries. Trained users to use the tool and create Ad-hoc business objects reports. Worked with many types of team members for different tasks. Set up LDAP and NT authentication for Crystal and Business Objects users.Tested reports for validating and verifying data.

• Business Objects: 3+ years of Business Objects XIR2/XI/6.x/5.x/2.x experience - Central Management Console, Central Configuration Manager, Platform Info View, Web / Desktop Intelligence, Data Integrator, Designer, Supervisor, Administrator, Application Foundation, Enterprise Performance / Information Manager, Dashboard Manager, Crystal Reports, Crystal Xcelsius 4.5/3.5/3.0, Crystal Decisions, Reports, and Xcelsius Data Visualization, Import Wizard, and Report Conversion Tool and Services, and Broadcast Agent Scheduler, Publisher, and Auditor.

• Data Integrator: 1 year experience of using BO Data Integrator. Informatica ETL, Informatica Power Mart/Center 6.2/5.1/4.7/1.7, FACT Tables, Dimension Tables, Star Schema Modeling, MS Access 2000/97, Erwin 4/3.x, Windows NT/2000, Windows 2000/98/95.

• Dash Board Manager: 1 Year of Dash Board experience using Dashboard Manager, Report Writer, Application Foundation 6.0/2.5 & Dashboard Manager.

• Dimensional Data Modeling: 3 years of experience in Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.5/4.0/3.5/3.x, Oracle Designer.

• Database experience: 6+ years of experience in Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2005/2000, (database triggers, materialized views, In-line views, Packages, stored procedures, functions, and database constraints), SQL Loader, SQL*Plus, PL/SQL and oracle DBMS Packages, oracle supplied utilities, Developer 2000 (Forms 6i/5.0, Reports 3.0/2.5), TOAD.

• Expertise in building Universes & Creating Canned/Ad-hoc Reports using Desktop Intelligence and Web Intelligence.

• Expertise in Planning, organizing, scheduling, and managing Business Objects report implementations.

Education:

Bachelor’s Degree in Information Technology, JNTU, INDIA.

Technical Skills

Business Intelligence Crystal Reports XI R2/2008,Business Objects 5.x/6.1b/6.5/XI R2/XI 3.0 (Central Management Console, Designer, Desktop Intelligence, Info View, Web Intelligence, Xcelsius, Supervisor, Enterprise Performance Management and Import Wizard)

Operating Systems Windows NT/XP/95/98, Windows 2000/2003, Ms-Dos, Unix/Linux/Solaris.

Business Analysis MS Project 2000, User Interviews, Business Requirements Gathering, Process flow diagrams, Microsoft Visio.

Languages C, C++, Java, SQL, PL/SQL, JavaScript, VBScript and Shell Scripts.

GUI Tools Visual Basic 5.0/6.0, Developer 2000, Forms 4.5, Reports 2.5.

Database SQL Server 2000/2005, MS Access 2000, Oracle 7.3/8i/9i/10g, Teradata

Packages & Tools Ms-Office, TOAD, SQL Developer, DB2 Visualizer

Data Modeling Erwin 4.1/3.5.5/3.5.2 (Dimensional data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling), Visio 6.0.

PROFESSIONAL EXPERIENCE

Client: Wachovia, Winston-Salem, NC Nov 2009 – Till Date

Role: Sr. Crystal Reports and Business Objects Developer

Description:

Wachovia which is a Wells Fargo company now is a diversified financial services company providing banking insurance, investments, mortgage and consumer finance. They are the number 1 in the U.S. in community banking presence (6,600 stores), mortgage originations, small business lending, middle market commercial banking, agricultural lending, commercial real estate lending, commercial real estate brokerage and bank-owned insurance brokerage.

Responsibilities:

• As a part of merger transition process was responsible for smooth transition of reports to the reporting environment.

• Modifying existing reports and to develop new reports by analyzing databases, data sources, and structures for the benefit of internal users.

• Responsible for asserting data needs data analysis, data extraction, report maintenance and design.

• Responsible for report development, report testing and report implementation for Credit Risk and Performance Measurement.

• Installed Crystal Xcelsius 4.5 /2008 and Crystal Reports 2008.

• Created Crystal Xcelsius documents, prepared dashboards and presentations (for external users).

• Created Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.

• Demonstrating familiarity with standard business reporting processes and also to refine data needs in a changing environment to meet specific business objectives.

• Responsible for both recommended and completed detailed report customizations to narrow report focus to meet specific business needs for the Credit Risk team.

• Creating complex queries against Oracle, SQL Server, Teradata and the MS Access database.

• Using Crystal 2008 to generate reports based on requirements from Risk Management and some other Line of Business.

• Created reports from Enterprise Information Warehouse that is based on Teradata Source.

• Responsible for posting the generated reports to Report Delivery Online tool (an intranet based repository).

• Published and scheduled the reports in Crystal Enterprise using Crystal Management Console so that reports are accessed from Front-end application.

• Handled Incompatibility issues between Crystal Reports XI and Excel and between Crystal Reports and PDF.

• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.

• Responsible for taking care of the additional reporting requests that were not part of the initial Merger transition plan.

• Worked with different data sources and when the need arises had to combine data from different sources to generate a single report.

• Working closely with Corporate Risk and Performance Measurement to facilitate resolution.

• Responsible for dealing with ADW (Active Data Warehouse) which houses several databases and then based on the request pertaining to each database generate reports.

• Worked with Teradata SQL Assistant to access different databases in ADW from different environments like SIT/UAT, PROD and DEV.

• Using the detailed Tech Specs, developed mappings and tuned them for better performance.

Environment: Oracle 10g / 11g, Business Objects, Web Intelligence, Crystal Reports 2008, Windows XP, Teradata, SQL Server , MS Access, DB2 Visualizer, Data Stage, Xcelsius and PL/SQL.

Client: Advertsing.com, Baltimore, MD May 2008 – Oct 2009

Role: Sr. Business Objects Developer

Description:

Advertising.com is now a part of Platform-A, the industry's largest online advertising network. Advertising.com operates the largest display advertising network in the United States. Advertising.com can do a whole heap of things for all kinds of businesses, like behavioral targeting, promotions, creative services, video ads, search and so on.

Responsibilities:

• Worked as a Report Developer in generating reports for financial teams and customers across Advertising.com.

• Worked with the business analyst team to interview the business users and capture simple, moderate and complex business requirements. Collaborated with business technicians to research existing business and system processes.

• Performed Administration tasks for our Project, Which Included Creating Folders, creating users/ Groups giving Appropriate Access levels.

• Review the business requirements with the Analysts, Business Users and Developers to construct SQL queries for implementing the same in PL/SQL packages.

• Construct complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD).

• Train users to use the tool and create Ad-hoc business objects reports (With my own documentation).

• Published and scheduled the reports in Crystal Enterprise using Crystal Management Console so that reports are accessed from Front-end application.

• Handled Incompatibility issues between Crystal Reports XI and Excel and between Crystal Reports and PDF.

• Created customized existing reports using sub-reports and charts to present information.

• Created the Crystal reports using tables and tested the reports by cross checking and verifying data against the reports generated from the legacy system.

• Wrote formulas to calculate the group summaries based on the group levels in Crystal Reports.

• Created reports across the channels (Sub Reports Drill-down, dynamic grouping, Master/Detail, Cross-Tab, graphical, aging reports etc).

• Extensively involved in creating Parameters and Record Selection Formulas to allow the users to filter the data in Crystal Reports.

• Created Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.

• Created Users, User Groups. Granted access to BOE applications to users and added security restrictions (Application level, Folder level, Object level) based on the user profile and user groups.

• Created Universe with available tables from Auth Data mart. Created Dimension, Measure and Condition objects in Universe and named the objects as per the business naming standards and filled in the Meta-Data for objects. Setup Custom Hierarchies for Drill down Reports.

• Develop the Stored procedures to be able to customize the report according to specifications.

• Responsible for re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.

• Responsible to make reports on checking the database and recommend the updating in database if any.

• Created table spaces in SQL to manage space for database sort operations and for storing global temporary tables.

• 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 maintaining data integrity in SQL through a set of rules that restrict the values of one or more columns of the tables based on the values of primary key of the referenced table.

• Involved in writing Use cases with the help of UML and using them to capture requirements.

• Involved in showing how business rules can be captured within Use Cases and directly used by Developers.

Environment: Oracle 10g, Business Objects, Crystal Reports XI, Windows XP, UML, and PL/SQL.

Client: Bare Escentuals, SFO, CA. Dec 2007 – Apr 2008

Role: Crystal Reports Developer

Description:

Bare Escentuals is a Cosmetic based company, which is known for breaking all the rules about makeup with the introduction of revolutionary foundation called bareMinerals.

Responsibilities:

• Worked as a part of the team responsible for generating reports for the End users and different business teams across Bare Escentuals.

• Responsible for Coordinating with Application Developers in the integration and utilization of Crystal Tools in the development of applications.

• Modify report content and export reports in multiple formats based on user input in Crystal XI.

• Reviewed User Requirements. Created detailed Functional Design Documents and Report design details documents for the reports.

• Created parameterized Crystal reports and customized existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting.

• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.

• Study the existing system, analyze the existing reports, understand the data and derive business rules for the new system for cross channel reporting.

• Used Cross-tab expert to generate aggregate (SUM, Count, MAX, MIN) functions for a field or a column.

• Configured and trained users to use Crystal Reports XI.

• Involved in Trouble Shooting all the issues in Crystal Enterprise 10 and Business Objects Enterprise XI.

• Exported Reports into PDF, Excel, word & RTF from Enterprise and resolved formatting issues.

• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.

• Developed Reports using Sub reports and Sub report Links.

• Responsible for Installation and Configuration of Crystal Reports XI.

• Responsible for handling numerous queries with complex criteria using Snowflake schema.

• Responsible for Data abstraction in PL/SQL that will extract the essential properties of data while ignoring unnecessary details.

• Responsible for using dynamic SQL in PL/SQL which is an advanced programming technique that makes the applications more flexible and versatile.

• Extracting the data from the existing systems and loading it into the repository.

• Troubleshooting, Optimizing, and fine-tuning the SQL Queries using Explain Plan utilities for better performance.

• Responsible for Writing Stored Procedures in PL/SQL for better performance.

• Responsible for preparing requirements, dependency scenarios documents for the reports.

Environment: SQL Server, PL/SQL, TOAD, Business Objects, Crystal Reports XI.

Client: CNA Insurance, Chicago June 2007 – Nov 2007

Role: Crystal Reports Developer

Description:

A multi-line business and personal insurance agency CNA is the 7th largest U.S. commercial insurer and the 13th largest U.S. property & casualty insurer. CNA provide insurance protection to more than 1 million businesses and professionals in the U.S. and internationally. CNA products and services are sold by highly professional independent agents and brokers. Headquartered in Chicago, CNA has offices throughout the U.S., Canada and Europe. CNA stands for its focus on customers, values and financial strength.

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.

• Responsible for developing and maintaining required standards including security, application integration, naming conventions, report version control and delivery formats.

• As an Admin responsible for preparing all required documentation for standards, projects and SEMM requirements.

• Responsible for Installation and Configuration of Crystal Reports 10/XI.

• Responsible for Upgrading Reports from Crystal 9.x to Crystal Reports XI.

• Created complex report using with 46 Sub reports, cross tab, custom functions, formulas and Suppressing conditions and Used advanced features like Dynamic and cascading Prompts.

• Exported Reports into PDF, Excel, word & RTF from Enterprise and resolved formatting issues.

• Scheduled the Crystal reports & E-mail them to the necessary departments through Info view.

• Converted the reports into different formats like Excel, PDF and HTML based on the user’s requirement using Business Objects.

• Performed Administration tasks for our Project, Which Included Creating Folders, creating users/ Groups on Central Management Console and giving Appropriate Access levels.

• Worked extensively with the different functionalities of BO like Breaks, Alerter, Filters, Sorts, and Query Prompts.

• Created reports (Canned & Ad-hoc) based on the business requirements using Web Intelligence.

• Installation and Configuration of BO & Web Intelligence applications for different developers.

• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).

• Performed Unit testing and System Integrated Testing and Documented test results.

• Based on Requirement Created Complex Crystal report using the data from Sybase, SQL Server and Oracle server data base.

• Responsible for preventing client applications from manipulating sensitive Oracle data using stored procedures in PL/SQL.

• Coordinating with Database team for the database design and Created SQL queries for extract data from oracle data base.

• Resolved the Performance issues/Data issues with in the Reports and Procedures in PL/SQL.

• Involved in writing Use cases to show the actors involved in the system with the help of UML.

Environment: Crystal Reports XI R2, BO XI, Info View, Pl/SQL, UML, Oracle 10g

Client: Marriott ExecuStay, Gaithersburg, MD Jan 2007 - May 2007

Role: Crystal Reports Developer

Data Mart Financial Reporting

Description:

Marriott ExecuStay provides fully furnished corporate housing to executives and travelers who need temporary accommodations for a month or longer. We developed the reports on Reservations, Customer Billing, and Services that were provided to the customers and locations.

Responsibilities:

• Designed standard reports and cross-tab reports according to the specifications using Crystal Reports 9.0.

• As an Administrator responsible for providing technical assistance, problem resolution and integration designs to developers and users as required.

• As an Administrator responsible for acquiring and maintaining required technical knowledge for the technologies supported.

• Responsible for Installation and Configuration of Crystal Reports 9/10.

• Responsible for Upgrading Reports from Crystal 8.5 to Crystal Reports 9.

• Created linked and unlinked Sub Reports to create applicants experience/qualifications reports.

• Published reports on the web using Crystal Enterprise 9.0 and Crystal Reports 9.0.

• Extensively involved in writing various formulas for calculations and combining the data.

• Created various charts using the Chart Expert in Crystal Reports 9.

• Involved in writing Custom Functions to be used in other functions in Crystal Reports.

• Published the reports to the Folders in CMC.

• Involved in generating the reports in PDF and Excel Formats depending on the user requirements.

• Scheduled the reports to run for each month and quarter by using CMC.

• Involved in migration of Business Objects 5.1.3 reports to 6.5.1.

• Used UNIX Shell scripts (KORN Shell) for Extracting and Parsing data from the files.

• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.

• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.

• Responsible for using specific stored procedure to create a customized error message in PL/SQL.

• Extensively involved in coding Views and Queries in Oracle using TOAD.

• Involved in creating functions and Stored Procedures in PL/SQL for Reports.

Environment: Crystal Reports 9, SQL Server 2000, UNIX, Pl/SQL and Windows XP.

Client: InterFirst Financial Services, Michigan Aug 2006 – Dec 2006

Role: Application Support Developer

Description:

As part of application support group, handled Medium and small ad-hoc requests/Defects to MOAI and MUPIT Mortgage Applications. Analyzing, investigating and providing fix for day-to-day help desk tickets raised for applications. Developed Batch Reports using SQR and enhanced SQR reports for production. Provided Production Support Document, Help Desk Support Document and participated in Code reviews.

Responsibilities:

• Developed GUI using Oracle Forms.

• Developed Reports using Oracle Reports.

• Developed Reports using dynamic cascading parameters.

• Developed Batch Reports using SQR.

• Developed Database Triggers, which checks the data integrity.

• Responsible for writing simple Unix Shell Scripts for base automation of processes for loading and testing.

• Create various scripts for enhancing loading process and techniques for restart ability of jobs.

• Identified and mapped the various entities, referential integrity constraints and relationships.

• Loading data from flat files into to database tables using SQL* loader.

• Responsible for code migration of existing application from SQL Database to Oracle Database.

• Performed the uploading and downloading flat files from UNIX server using FTP.

• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.

Environment: Oracle 8.1.6 / 9i, Oracle Developer (Forms 6i, Reports 6i), PL/SQL, SQL, UNIX, Windows, Oracle Application Server.

Client: Syswiz Technologies, India. Aug 2004 – July 2006

Role: PL/SQL Developer

Description:

Syswiz specializes in outsourcing & consulting services in the fields of Information Technology and Information Security. It also specializes in developing software packages. The main domains of Expertise would be Automotive, Engineering, and Financial Services. It uses different types of databases such as Oracle, SQL server and Sybase Adaptive Server enterprise.

Responsibilities:

• Played key role in Design and Development of Database.

• Involved in the entire software development process, established the goals and requirements of the application, data collection and analyzing the data as well as business flow.

• Extensively worked with stored procedures in Oracle for retrieving the data from the database for solving complex queries. Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application. Developed job queues, which work similar to Queue series for running the program asynchronously.

• Created Stored Packages, Procedures and functions in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend.

• Worked on table partitioning (Range and List) and deploying various methods of indexing like local indexes and global indexes on portioned tables.

• Extensively worked on Explain plans and various hints for Performance tuning.

• Involved in extracting Data from the Heterogeneous databases residing on Mainframe, UNIX.

• Used Oracle 9i new features such as merge for various transformations.

• Involved in creating procedures for Raw Data Reports using PL/SQL.

• Created linked sub reports (regular and On-demand) as well as unlinked Sub-Reports along with the Primary reports.

• Troubleshooting for all the issues in Crystal Enterprise and Reports.

Environment: SQL Server 2000/2005, SQL and PL/SQL Oracle 8.X/9i, Crystal Reports, TOAD.

References: Available on Request.

Contact this candidate