Profile:

Worked as a Crystal Reports Developer for around 6 years and have a diverse experience in the industry. Have a sound knowledge and understanding of all the stages of Software Development Life Cycle, Testing Life Cycle, and OOAD and about all the aspects of Functionality, Usability, Reliability and Performance testing.

Exposure to Business Objects XI Enterprise suite using Desktop Intelligence, Designer, Web Intelligence reporting and Publisher.

Four years (4+) of Business Intelligence experience using Crystal Reports 11/10/9/8.5, Business Objects XIr2/6.5, Info View, Web Intelligence and ZABO

Worked on complex reports that require running totals, sub-totals, sub-reports, cross-tabs and conditional display of groups, fields and messages.

Worked on Central Management Console for managing, deploying and configuring the entire infrastructure.

Developed Drill Down Reports and used Open Document Syntax in Crystal to get the drill down functionality for the report.

Strong BI, OLAP, Data warehousing experience with Crystal Reports Xir2, Business Objects, Web Intelligence, CMS (Central Management Server), CMC (Central Management Console), Import Wizard, Publisher, Broadcast Agent.

Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie -Charts etc by using Chart expert of Crystal Reports.

Experienced in writing complex formulas in crystal reports, SQL queries using Crystal Designer, migration of Crystal reports in different versions.

Responsible for development, publishing & scheduling Crystal reports in Crystal Enterprise. Experienced in design and development of Complex Universes.

Working knowledge of Crystal Xcelsius.

Published Reports in Crystal Enterprise via. Crystal Publishing Wizard and Crystal Management Console. Experience in Scheduling the Reports using Crystal Enterprise.

Education:

BE in Electronics and Telecommunication .

Programming:

SQL, SQL*Plus, SQL*Loader, JavaScript, HTML.

OLAP and Reporting Tools:

Crystal Reports 9/10, BusinessObjects 5.x/6.x/Xir2 (Supervisor, Designer, Business Object Reports) Web Intelligence, desktop Intelligence, Broadcast Agent, ZABO, EPM and PM.

Tools:

ERWin, TOAD, HTML, Excel, Word, MS-Project

Workflow Tools:

MS-Visio2000, MS-Excel, MS-Word, MS-PowerPoint, MS- FrontPage.

Environment:

Windows NT/98/95/2000/XP .

Client: Confidential,
Role: Project Manager (Dec’08 – Current)
Project: Essex Credit Corporation (now owned by Bank of the West) is one of the nation’s leading financial services firms focused exclusively on the pleasure boating and recreational vehicle market. The IT division of Essex Credit Corporation is mainly divided in two parts, the internet and the Intranet. One of the main projects it the new and improved online loan application which is associated to the internet division. The information entered by the customer in the online application is to be made available to the employees of Essex Credit in a structured fashion through the intranet applications. That is the second scope of the project.
Essex Credit has also decided to incorporate Crystal Reports as the primary reporting tool and hence all the reports are to be migrated to Crystal Reports.
Responsibilities:

Set up meetings with the client in order to gather requirements for enhancements and also suggest possible future enhancements and document it.

Coordinate with the development and testing team to ensure that all the enhancements are incorporated in the application.

Monitor the UAT team and document the feedback for defects and future enhancements.

Review the XML post and test the data that is being sent to the cache server and database to ensure that the data gets populated in the required areas and also to make sure that unnecessary data gets scrubbed in the XML post so as not to cause problems to the risk processor.

Make changes to the PHP and ASP files to incorporate minor changes using Dreamweaver CS4.

Understand the table structure and views present in the database and submit SRS to the bank if modifications were required.

Prepare deployment packages for the bank with detailed instructions for the release of certain intranet applications.

Understand the current reporting requirements in order to migrate to Crystal Reports.

Made a presentation to highlight the virtues of Crystal Excelsius as the bank was going to use it along with crystal reports.

Successfully deployed the online loan application after two prior failed attempts.

Enviornments: Dreamweaver CS4, VMWare workstation with Windows 2003 Server, Microsoft SQL server 2000/2003, FTP tools, Remote Desktop, Windows XP.

Client: Confidential,
Role: Sr. Crystal Reports Developer (April\'08 – Nov’08)
Project : The project was the first and the main phase (i.e. Release 1.x) of the complete overhaul of the online systems of PennDOT. In this release the Financial Administration, Inventory & warehouse and Product lists & Correspondences were covered. Delloit, one of the leading consulting companies, was awarded the contract for release 1.x. As reporters our job comprised of understanding the Client’s requirements in each of the sectors of Finance, Inventory and Correspondences make the reports and also make sure that the reports were interfaced properly with the Java Application front end with the proper use of the correct Java SDKs provided by Business Objects. As the only reporter of the current maintenance team I had to debug complex issues and deal with enhancements requested by the client and implement them.
Responsibilities:

Understanding the existing reports and tuning them to improve performance.

Interacted with the client to understand the working and business requirements of the various departments like Finance, Inventory, Warehouse, etc.

Designed complex reports involving multiple subreports or reports based on ORACLE SQL commands and Stored Procedures.

Created parameters, running totals and summaries for calculated fields within Crystal Reports.

Developed several Drilldown Reports, Cross Tab Reports, Summary reports and Detail reports using Crystal Reports.

Created reports off both OLAP and OLTP databases. OLTP database connections were required to generate automated correspondence letters from real time production data.

Most of the financial reports created were Daily reports. But there were Monthly and Six Monthly reports too. These reports were scheduled on the basis of whether they were daily, monthly or six monthly. The Business Objects scheduler was used to schedule these reports.

Converted Crystal Reports into Business Objects Reports using InfoView and Central Manageent Console (CMC) for the JAVA API and application front end.

Configured numerous Business Objects Infoviews for the client to meet their various requirements.

Modified and managed the security privileges for the various user groups on the client side based on the User Priviledge Matrix created with the help of the client.

Migrated all the reports to the various environments and finally published to production in the Business Objects Central Management Console after final UAT testing and made the post migration changes needed in order to run the reports.

Made reports using multiple data sources and created Canned as well as parameterized reports.

Worked with the DBAs from both the client side as well as Delloit in order to create the required Views and Stored Procedures.

Extensively used Toad for ORACLE in order to debug and track down errors and also execute SQL code snippets to test for effeciency and also too check the cost/load on the database.

Created detailed documents for all the reports which included the business logic, database connections, type of joins used, the different filter conditions, details of all the formulas and parameters used, etc. in order to conduct efficient knowledge transfer.

Maintained the versioning of all the reports and the documentation for the reports using Clear Case 7.0.0.1.

Enviornments: Crystal Reports XI SP 4and XI R2, Business Objects Enterprise XI SP 4, Toad, ORACLE 10g, Clear Case 7.0.0.1, Clear Quest 7.0.0.1, Windows XP.

Client: Confidential,Scottsdale, AZ
Role: Sr. Crystal Reports Developer (Jan’ 07– Feb’08)
Project: SA Sales/SA-Sales Analyzer Data Mart.
The Dial Corporation is $1.7 billion Company and is one of America\'s leading manufacturers of consumer products, including Dial soaps, Purex laundry detergents, Renuzit air fresheners and Armour Star canned meats. The company\'s Sales Analyzer data mart is used to integrate data from daily shipments and open orders, giving Dial the capability to track and analyze daily sales performance from an actual and budgeted perspective. This data mart also provides Dial\'s field sales team with daily reports on different sales-related metrics so they can continually refine their sales efforts.

Responsibilities:

Conducted JAD sessions with extensive involvement from Business, Development and Testing teams, Architects, ETL(Informatica) developers and Managers of various Business Units. Created PowerPoint presentations incorporating MS Office Suite, Excel, Word and Access. Used the scheduler to generate monthly financial review of the project status.

Extensively worked on Installing and Configuration of Crystal Reports Xir2.

Created Custom Functions, Manual Running Totals, Stored Procedures, Complex Formulas and complex data and sub Reports for the client.

Created Reports On-Demand, Scheduled, and Ad Hoc Reporting.

Met with end/business/power users to determine functionality and release from development to production both via in-person and via numerous conference calls.

Scheduled reports with different options using Crystal Enterprise.

Daily, weekly, monthly reports for various users and scheduled the reports for various targted groups.

Created various Reports using Business objects Functionalities like Master/Detail, Slice/Dice Drill Down and Drill Up, Formulas and Cross-Tab reports.

Used drill analysis in Business Objects which will allow the users to view data at a more detail level, than current level.

Created SalesModel using Crystal Xcelsius for Executives to forecast their annual sales.

Created personalized and corporate Dashboards and Score cards using EPM for the higher Management.

Environment: Crystal Reports 9/10/XI, Business Objects XiR2/6.5, Oracle 10g , TOAD, SQL, SQL*PLUS, and Windows NT.

Client: Confidential,Los Angeles, CA
Role: Crystal Reports Developer (Nov’ 05 – Oct’ 06)
Project: The Farmers Insurance Group of Companies is the third largest home and auto insurer in the United States. Headquartered in Los Angeles, California, Farmers provides a range of insurance services to more than 10 million households. Farmers wanted to streamline its automobile claims management process to eliminate inefficiencies. It wanted to monitor repair shop performance, make better use of claims staff, quickly add new functionality to key systems and improve the customers experience after an accident. Although Farmers had implemented many standards and efficiencies in its claims-settlement process, some aspects were still manual, paper-based and complex. The Process Claims- Claims Port solution has automated Farmers’ claims-processing system, providing an all-digital workflow and the ability to track performance. Claims Port integrates seamlessly with Farmers claims-processing system. The automated, Web-based solution gives Farmers the ability to monitor repair facilities, eliminate manual handoffs, reduce cycle time, and make the claims-settlement process more satisfactory for customers.
Responsibilities:

Interacted with the project team to help define the business and system objectives, confirmation of scope, identify constraints and the measures of success for the system to be developed. Gathered requirements, business and technical design sessions with clients, DBAs, ETL developers, and QA analysts using integrated JAD sessions. Conducted user interviews with auto repair shops, claims department staff, customers and management to get a better understanding of client business processes.

Managed Scheduled Tasks processed by using Broadcast Agent.

Managed the resources, granted permissions to Crystal and BO product users, WEBI users, managed the connections.

Was responsible for writing complex SQL, Stored procedures, triggers, functions and views and optimizing the query performs.

Designed the report templates for Crystal Reports.

Used Crystal Xcelsius to dynamically represent data for the Claims department.

Participated in defining object-naming conventions and in determining user hierarchies.

Participated in detailed report design and created design specifications documents at report level.

Created Drilldown, parameter, sub report and hierarchy reports using Crystal Reports 10.

Used Crystal Publishing Wizard for publishing and scheduling the reports on Crystal Enterprise Systems for printing and published several reports for On-Demand as well as recurrent viewing.

Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.

Extensively used Supervisor Module for Creating and Managing user groups and users.

Environment: Crystal Reports 10, Crystal Enterprise 10.0, Oracle 9i, Toad, Microsoft Excel, Adobe Acrobat 6.0, Visio and Windows XP.

Client: Confidential,Mumbai, India.
Title/Position: BO/Crystal Reports developer (April 04- Aug’ 05)
Project 1: Performed requirement analysis, Designed a comprehensive export and import costing application. The Application keeps track of inventory information, sales analysis and delivery Details, Developed using Developer 2000 with Oracle 7.3 database in windows’95 using VBX controls.
Responsibilities:

Assist in planning, designing, and implementing of Reports.

Implemented Crystal reports for standard reporting, Adhoc query and business users.

Enhance the existing reports as per client requirements and business team.

Advanced reports of varying complexity including slice and dice, drill down, cross tab, multiple table/section, and master detail type reports

Responsible for providing support to QA testing team to clarify changes of continuous release of software build and resolve testing issues or bugs reported by QA team.

Follow-up with Client on various proposed initiatives.

Involved in the module testing, functional testing and integration testing.

Participating in Weekly and Monthly status calls.

Meeting with programmers, test engineers and product management team to gain an understanding of the business requirements.

Designed the reports like all accounts details, cross sell, home, life, commercial, umbrella and miscellaneous reports.

Tested the reports thoroughly created by other developers, as per the report specifications.

Written documentation for the newly created reports.

Developed pie charts, bar graphs more understandable for top-level management using Analyzer in the reports.

Estimate the time frame to design the reports.

Exported reports to document agent server to schedule and monitor reports. Created complex reports using multiple universes.

Translate business requirements to design the ER model using ERWIN tool.

Environment: Crystal Reports 8.5/9, Crystal Enterprise 10, Business Objects 5.x, Oracle 8i/, PL/SQL, SQL Loader, SQL*PLUS and Toad, Test Director 5.0

Company: Confidential,Mumbai
Position: Test Engineer / Feb 03 –Mar 04
Project: Provide QA and Implementation Planning for GE Fanuc Automation software ‘iFIX’.
Sarla Technologies is India’s leading software solutions provider for industrial automation and MES. Established in 1991, Sarla Technologies today has expanded its operations in India, Dubai, USA, UK, and Ireland. Sarla Tech ia also a Global Software Solutions Business Partner of GE Fanuc Automation.
Responsibilities:

Testing new builds of iFIX according to given test plans and test cases and also conducted Self testing.

Using VBscript to modify and test custom configurations for stability and reliability of the SCADA system.

Checking for compatibility of iFIX and Virtual Tables with various RDBMS.

Actively participated in Test Plan preparation

Involved in Test cases Review.

Performed Manual Testing prior to Automate Testing on the Application.

Involved in loading the test flat files to Derived table to testing tables.

Involved in team meetings with QA Manager and Participated in client meetings for weekly updates.

Strong skills in writing SQL queries, generating reports to ensure data integrity and validate business rules.

Planning the installation and configuration of iFIX for a milk pasteurizing company.

Environment: Windows 2000/NT/XP, MS Word, MS Access, SQL Plus, Oracle 8i, Test Director, VB and SCADA.