Summary:

Expert Level business objects\\Crystal Reports\\Cognos-hyperion \\application Developer with 9+ years of progressive experience in the full life cycle development using Crystal Reports (Version 8,9,10,11),SQl Server 200 and 2005 , Business Objects, Visual Foxpro and Visual Basic in auto insurance,Finance, health insurance, Mystery shopping, manufacturing,wholesale and trading industries.

Education:

BS (Computer Science) from Bharathiar University, INDIA

Experience:

Analysis, Design, Development and Technical Documentation

Skill Set:

Platforms: Windows, UNIX, DOS, Citrix
Languages: Visual Foxpro 6 & 7, Foxpro2.6, Visual Basic 5 & 6
Reporting tools: Crystal Reports 8.x, 9.x and 10.x ,11.x ,PeopleSoft,Crystal Enterprise, Business
Objects/cognos,Hyperion MS - Visio
Dev Environment: Visual Interdev, Visual Studio, Visual Source Safe
Web: ASP, VB Script, Vb.NET,ActiveX, XML, HTML,
Database: MS Access, T-SQL, SQL Server6.0, 7.0 & 2000, postgreSQL, VFoxpro
Others: MS Office, Install Shield Excel, Word, Powerpoint
Industries: Commercial Auto Insurance, HIPAA / Health, National Audit
Services, Transportation, Wholesale, Financial, Web portal and Trading

Professional Experience Details:

Developer - Confidential, Atlanta 06\\07 - current
Design and develop complex reports for the Sales department using crystal reports and publish the report in CMC and Info view in Business Objects. Talk to sales group and management level employees for requirement gathering, create mock up report, design, test and deploy the report to the web. Also involved in training the end users on using \\running the report from website. The reports vary from simple to very complex using cross tab, dynamic parameters, sub reports, formulas, charts etc.Extesive experience with hyperion interactive reporting and dashboard builder. Used Cognos reports to convert them into BO reports and modified the existing reports .Various stored procedure and views were created in SQL for the crystal report data retrieval. Also created several WebI reports for the end users which were then exported to Excel.

Rewrite\\Debug several stored procedure and reports that are being currently used for performance issues and logical issues.

Confidential, Business Objects, SQL Server 2005

Lead Developer-Confidential, Atlanta 06\\05-06\\07

Worked in a lead role to gather information, analysis and development of web based mystery shopping product using Crystal reports 8.5,9.0,and 11.0 in SQL,Oracle etc. modified existing reports to improve the performances and converted several crystal functions in SQL and incorporated in the report using stored procedures, triggers etc. converted several Cognos Report into Crystal Reports and modified the existing reports to fix some of the errors.Incorporated crystal reports in the application. Communicated between different teams located in different states to meet the deadline for the release of the application into the production environment. Created several stored procedures and functions for the reports and for the web to improve the performance, tuning etc. Upgraded, re-wrote several reports from version 8.x to 9 and 11 and from SQL reporting services.

Environment: Crystal reports 11.0/Crystal enterprise, PeopleSoft, Visual Studio, Source Safe,Oracle, SQL Server

Confidential, Atlanta 03/05- 5/05
Working as both a report developer and SQL developer. Wrote adhoc complex queries using SQL server, TOAD. Converted reports from older version to new versions of Crystal reports which also involved writing complex stored procedures and functions. Developed various reports, including sub reports that were then published using Crystal enterprise to different users.
Also working as development research analyst, which include troubleshooting existing reports and their stored procedures. Using VSS for version control.

Environment:
Crystal reports 8.x,9.x,10.0,11.0/Crystal enterprise, Visual Studio, Source Safe, Visual FoxPro, SQL Server 7 & 2000, T-SQL Windows NT,MAS500

Reporting Analyst/Specialist Confidential, Atlanta 09/02 - 11/04

Involved in Analysis, Design and development of reports Crystal reports 11.0 with SQL 2000 backend database. Worked on a lead role and participated actively in gathering information, design planning, flowcharting the old reports and converting them to Crystal Reports 9.0. Designed over 80 reports with sub reports and functions from Crystal reports 8.5 and 9.0 for internal use and also as per the state government specifications with in a limited time frame. Created and maintained new complex stored procedures and functions for the reports with SQL 2000 and T-SQL.

Upgraded over 60 notices from Crystal enterprise 11 which included re-writing various functions use with in the reports and re-designing the report itself. Updated and maintained these production reports in Visual SourceSafe for version control. Investigated user requirement, designed and developed POS reports for the insurance company which included policy declaration pages, billing notices involving complex stored procedures in SQL,T-SQL statements and developed complex reports with sub reports with limited timeframe. Linked and embedded different reports to meet executive level user's needs. Created and modified several crystal reports for testers based on MS Access 2000 backend database.

Developed and modified various reports in Crystal reports version 10,11 and incorporated them into an application which was automatically exported to XML during the nightly and Monthly close procedures in order to outsource the reports to an outside printing company. Some reports were scheduled or queued to run on a server using Seagate Crystal Info while others were executed from an application. Performed test planning and prepared test scenarios, unit testing for QA team. Worked on a lead role in QA team for test execution.

Environment:Crystal reports 10.x /Crystal enterprise, Visual Studio, Source Safe ,C++, Visual FoxPro , SQL Server 7 & 2000, T-SQL Windows NT,MS Access

Report developer/Analyst FL State Departments 01/'02 - 09/\'02

Development & Enhancement of an HIPAA compliant software product TEC (The Total Environmental Control system) for Florida State Department of Health using SQL Server2000, Oracle 8i,and Crystal Report which was a software to manage different reports used by DOH (department of Health).

Systems Analysis, effort estimation & Enhancement of a Contract Management System (CMS) for Florida State Department of Transportation using Crystal Enterprise 8.0 with Oracle 8i backend database. Designed and developed various reports which involved complex queries against an Oracle database.

Developed /modified programs to track contract documents from inception to expiration. Enhanced the system by adding FoxPro routines to manage Supplemental, Amendment and renewal of contracts. Selective conversion of Summary reports which was developed using Crystal reports 8.5 reports and memorandum for GUI enhancements and external applications integration

Modified user interfaces for the FISCAL module, an OLAP application and crystal reports. Created and modified stored procedures in SQL server 7.0,T-SQL etc for the DoT (Department of Transportation) Web Interface. Developed complex ad-hoc reports using Crystal Reports for Accounting, Insurance users.

Planned, prepared and executed system tests and documented the test results for defect resolution and tracking on DoH modules.

Coordinated the Version Control & Release notes for different releases of TEC on Microsoft Visual Source Safe.

Environment:Crystal Enterprise, Crystal reports 8.x, Visual Studio, Source Safe, OLAP, Oracle 8i, SQL Server 6 & 2000,T-SQL, Windows NT

Programmer Analyst Confidential, Dallas 09/ '99 - 10/ '01

Development & support of Global Trading Management system for CN World Trade, using Visual Foxpro, Visual Basic , MS Access & Oracle 8i. Performed detailed Systems Analysis and prepared documentations and flow charts using MS Visio.

Design & development of a corporate-wide inventory transaction management system using Oracle 8i and Crystal Enterprise reports 8.5 and integrated with logistic & Cargo Insurance services.

Developed Programs for Trade Lead Identification & notifications, Trading Partner Management and Distribution services using Visual Foxpro.

Created Visual Foxpro program components to integrate with other applications such as MS-Excel, MS-Graph for Trade Data collection and visual representations.

Developed modules for customer authorization, trade enquiries, and reports using crystal reports, Access & HTML for the company portal.

By using MSDE (Microsoft Data Engine) created Access - based front ends for an SQL Server database for customer enquiries. Created programs to query Oracle database to generate custom reports. Performed Version Control activities using Microsoft Visual Source Safe. Implemented a common Error Handling routine for the entire application using visual Foxpro.

Documented methods & procedures for Systems Development and assisted in user documentation & training.

Environment:Crystal reports, Crystal Enterprise, Visual Studio, Source Safe, Oracle 8i,T-SQL,SQL Server, MS Visio

Programmer / Analyst Confidential, INDIA 09/ 1997 -08/1999

Developed applications for department stores and medium sized financial institutions using Foxpro 2.5 , Visual Basic, Oracle, Access in windows, Netware platforms.

Involved in requirement gathering and analysis, Design, Development and Documentation using Systems Analysis and Design methods for various in-house projects.

Developed a Store Management system for departmental stores using Foxpro on Novel Netware LAN. Developed programs in Visual Basic for data entry templates using forms and Active X controls. Create COM objects containing common business rules and tax information.
Documented the department store project and coordinated user training sessions.

Coordinated user manual documentation with other team members and reported to the Regional Manager for the software development division.

Designed and developed a Library Management System using Foxpro2.5.

Environment: Visual Basic, FoxPro, Crystal Report, MS Office, Windows, Novel Netware, UNIX , C,C++, ORACLE , System Analysis & Design principles

Programmer Confidential, INDIA 06/'96 - 06/'97

Performed Analysis, design and development of a Transaction Reporting utility for a co-operative Bank on Windows environment using Foxpro, dBase III & IV, Visual Basic and Access.

Developed Real time customer transactions modules and created various reports for the Bank Management using Foxpro, dBaseIII.

Created Data flow diagrams and flow Charts for the transaction report utility.

Designed and developed forms for the data entry and data maintenance screens using Foxpro/dBase .

Wrote programs to map MS Access data to Foxpro applications using C, Visual Basic and Foxpro.

Created Database maintenance routines using visual Basic forms and event procedures with detailed routines for data validations.

Designed and created customized reports using Foxpro Report wizard and Crystal Report Writer..

Developed User interfaces for Banking transactions and designed custom reports using SQL and Crystal Report Writer.

Environment: Foxpro, dBase III & IV, C, Foxpro, Office, MS access.