Crystal Reports, Business Objects, SQL Server

PROFESSIONAL SUMMARY

Presently working with Computer Science Corporation (CSC) as Software Engineer

4.5 Years of experience in developing software and working with SAP BusinessObjects suite of products like Universe Designer, writing Crystal Reports, Web Intelligence, Desktop intelligence, Import Wizard, Publishing wizard, Schedule Manager, and Instance Manager for major clients in industries like Insurance and CRM industries

Worked extensively in developing and implementing Crystal reports/Web Intelligence reports on BusinessObjects Enterprise XI REL 3.1, Crystal Enterprise 10.0 and 2008, BusinessObjects Universe Designer, Crystal Reports Explorer

Expertise in designing Universe(s) from scratch, designing WEBI reports and maintaining them on BusinessObjects

Hands-on experience in design and implementation of Star schema

Hands-on experience in database design and development using SQL, Stored procedures, Functions, Views and triggers in SQL Server 2005, 2008 and IBM DB2

Expertise in creating all kinds of Crystal Reports (General, Cross Tab, Sub Report, Drill Down and Chart Reports)

Experienced in migrating reporting from COBOL mainframe to Web based Reports using Crystal Enterprise 2008

Expertise in deploying and scheduling reports in Info view

Expertise over preparing report specifications, database designs to support the reporting requirements

Hands-on experience in SDLC entailing activities related to requirements gathering, including planning, design, development, implementation, documentation, prototyping, development, testing, implementation and user training

Experience in interacting with business users and rules analysts

Active team player and as an individual with Excellent Communication, Interpersonal skills, self motivated fast learner and good listener

Additional experience working on Windows .NET application, MB unit and N Unit (for automatic unit test cases creation)

SKILLS TOOLS

Operating Systems Windows 95/98/2000/XP/2003

Languages VB.NET, C#, ASP.NET

Database(s) MS SQL Server (2005 and 2008)

IBM DB2 (Windows and Mainframe)

Reporting Tools Universe Designer, Web-I, Desk-I and Crystal Reports (2008 and 10.0)

Database Modeling Star Schema

Tools MS Visual Studio 2005/2008, TFS, VSS, SVN, Araxis Merge, Agent Ransack

Domain Insurance, CRM and Conferencing

TECHNICAL SUMMARY

DURATION ORGANIZATION ROLE

May 2010 – Till Date Computer Sciences Corporation (CSC) Software Engineer

Mar 2008 – May 2010 R Systems International Software Engineer

Sep 2007 – Mar 2008 R Systems International Trainee Software Engineer

WORK HISTORY

ACADEMICS

B. Tech. (Computer Science) from UP Technical University in 2007 with 68%

Senior secondary from CBSE Board in 2003 with 71%

Higher secondary from ICSE Board in 2001 with 66%

WORK EXPERIENCE

Computer Sciences Corporation (CSC), Noida May 2010 – Till Date

Project: Producer Incentive and Compensation System (PIC)

Team Member: 20

Goal of Project: Farm Bureau Limited (FBL) has a large number Producers (Agents) who bring business to FBL by selling the policies of their Marketing and Underwriting companies. These Producers receive Commissions based on various different parameters and business rules. In the current world, FBL has a Mainframe based system called AGTI (Agent Interface), developed in COBOL and VSAM, which takes care of the Commissions calculation. This AGTI system is a legacy system with lot of issues related to maintenance and scalability. The commission cycles are executed in a 5 day Month end process and there are many problems faced by the business users in the current system.

PIC initiative is a Java based solution for the overall maintenance of Producer and Commissions data and eventually phase-out the current AGTI system.

Responsibilities:

Analyzed functional and technical requirements and prepared deliverables including Software Requirement Specifications, User Interface Specifications, screen mock-ups, and report mock-ups

Requirement gathering from the users and business about what they want to achieve through this universe

Involved in migrating reporting from COBOL mainframe to Web based Reports using Crystal Enterprise

Worked with Star Schema and performance tuning of reports

Tested the reports and modified the relevant objects in the Universe as per the user specifications.

Created simple and complex reports like Accounting Balance sheets, Agents Commission Statement

Prepared month-end reports for General Ledger

Optimize SQL queries for better performance

Involved in writing detailed level documentation for reports

Performed Integrity Checks to Universes to detect loops, cardinalities and joins

Involved in designing Universe and designing web intelligence for ADHOC reporting

Involved in creating event in BusinessObjects and scheduling the reports

Developed universe user documentation guide for the end users reference

Tested the reports and modified the relevant objects in the Universe as per the user specifications

Environment: BusinessObjects XI REL 3.1, Crystal Reports 2008 and IBM DB2.

R Systems International, Noida Sep 2007 – May 2010

Project: Personify 7.0 (Upgraded from TIMSS 6.0) - Sep 2008 – May 2010

Team Member: 30

Goal of Project: Over the past three decades, TMA Resources has introduced many innovations that help member-centric organizations streamline operations, satisfy member expectations, and increase revenues. TMAR has raised the bar for membership management with TIMSS™ -- the first software suite designed to support Membership Relationship Management (MRM). MRM is an innovative technology approach that's been successfully applied in many private sector companies in the form of Customer Relationship Management (CRM). TIMSS harnesses the full power of MRM, enabling you to build close member bonds, attract more members, and generate increased revenue from your existing members and customers.

TIMSS (TMA Resource Integrated Membership Management Software Solution) helps you build powerful data reservoirs and unlock their treasures to take member management to the next level. It also integrates every aspect of your operation - from advanced customer support across multiple touch points to rapid-cycle marketing - improving your ability to engage, transact, fulfil, and service members on an individual basis.

TIMSS encompasses more than 32 inter-connected software modules, expertly designed for high performance, solid reliability, and seamless integration.

Responsibilities:

Understanding of client requirements & preparation a functional requirements document, external design, program specifications & test cases document

Development in VB.NET to create Interface library to perform actions like scheduling, Run etc.

Optimize SQL queries for better performance

Creating new Universe(s), Web-I, Desk-I reports and Crystal Report according to the requirement

Involved in development and deployment of Complex Reports

Created Objects and prepared Reports like financial reports, Order summary, Membership Info reports, standard and adhoc reports, and universes

Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections

Dealing with WEBI and CR reports. Rectifying all the issues related with scheduling, connection, Server failures, CR viewer problems, Database connectivity problems

Database development (including programming procedures and triggers) in SQL Server 2005/08

Provided training for end users for generating their own report including complicated report

Environment: Business Objects XI-R2, VB.NET, MS SQL Server 2005/08 and Crystal Reports 10.0

Project: POWELLS BRS (BOOKSCAPE Reporting System) (Sep 2007 – Sep 2008)

Team Member: 6

Goal of Project: Powell's Books is the largest independent used and new bookstore in the world. Powell's Books operates five Portland, Oregon stores and one in nearby Beaverton. They also have a number of warehouses and book sources locally, nationally, and internationally.

They were having the requirement of powerful tool that can manage the online reports and batch job processing/ reporting I.e. BRS (BOOKSCAPE Reporting System).

It takes care of submission, scheduling and tracking of reports and batch processes. It enables authorized user to easily select and run reports/ batch process, and check the status of reports and batch process jobs instantly. The Reporting System supports multiple report execution simultaneously; thereby providing ultimate flexibility with all reports deployed at centralized location i.e. Business Objects.

Responsibilities:

Created Web Intelligence Reports and Desktop Intelligence Reports

Created various packages in database and dashboard Reports in WEB I to show the data.

Performed Data testing and report testing at the unit level.

Environment: VB.NET, MS SQL Server 2005, BO-XI, Crystal Report 10.0

WORKSHOPS/TRAINING PROGRAMS ATTENDED

Internal Behavioral training: Presentation skills, Communication Skills, Business Etiquette, Team Work and Corporate behavior.

Initial Training Program: Business Objects, VB, VB.NET, SQL server 2005, Advance DB2, Testing Methodologies and Crystal Reports.

Corporate (Project Specific) Training: INS21 Certification for P & C Insurance, Basics of Insurance (Life and P & C).

Contact this candidate