Summary:

• 8+ years of experience in Designing, Analysis, Development, Maintenance, Implementation using Crystal Reports 8.5/9.0/10/XI/2008, Business Objects XI.
• Experience in Finance and Insurance domains.
• Experience with multiple RDBMS including MS SQL Server 2000/2005/2008, Oracle 10g/9i/8i, DB2, and Microsoft Access.
• Extensive knowledge in SQL & PL/SQL programming, writing Stored Procedures, Functions, Packages using SQL Server Management studio, PLSQL Developer, SQL Plus, SQL Navigator and TOAD.
• Experience in developing different types of reports using Crystal, WebI and DeskI.
• Designed reports with complex sub reports, Drill down, Cross Tabs, formulas, functions, parameters, scheduled reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections, mailing label.
• Good experience in report customization via the use of Grouping, Sorting, Field Highlighting, Conditional Formatting, Running Totals, Summaries, Static & Dynamic Parameters, Static & Dynamic Graphic Objects, Custom Formulas and Custom Functions (SQL Queries).
• Expertise in Creating Web Intelligence Reports. Developed Universes and Canned/Ad-hoc Reports using various Sources.
• Good knowledge CMC (Central Management Console) for user management, content management, and server management tasks and CCM (Central Configuration Manager) to manage local and remote servers
• Sound working knowledge of MS Access, Excel, MS Project and Version Control tools (PVCS, subversion, TFS).
• Experience in developing report specifications based on business requirements.
• Experience in developing test plans, preparing test data and performing unit and integration testing
• Scheduled and published reports using CMC and Info view.
• Experience with .NET application platform and development using Visual Basic.
• Extensive experience in preparing Use Cases, Functional Specifications, Scenarios, Source-to-Target Mapping doc, Business processes, Workflows, Process flows,Test cases and Test Plans.
• Sound knowledge of Software Development Life Cycle (SDLC) and Project management.
• Good exposure to onsite offshore model.
• Excellent problem solving and interpersonal skills with documentation and communication skills and an excellent team player to maintain effective work relationships with all levels of personnel.

Skills:

Reporting Tools: Crystal Enterprise 10.0/9.0/8.5, Crystal reports 2008/XI/10.0/9.0/8.5, Xcelsius 2008,
Business Objects XI 3.1/3.0/XI R1/R2/R3, WebI, DeskI, Infoview
Database: MS SQL Server 2000, 2005, 2008, Oracle 10g/9i/8i, DB2 (AS 400), My SQL, MS Access
Source Control: PVCS, VSS, TFS and Subversion.
ETL: Informatica 8.6.1/8.1.1
Tools: Remedy, Service Now, Test Director, Quality Center, TOAD, SQL Developer, PLSQL Developer, Microsoft Outlook
Operating Systems: Windows XP/2003/2000/98/95/ XP /NT
Languages: VB 6.0, VBScript, JavaScript, HTML, XML

Professional Experience:

Confidential,IL. Jun 11 - Till Date
Title: Sr. Crystal Reports and SQL Server Developer
Leading health insurance administrator. Life, medical, dental, managed care, disability, critical illness and accident insurance, and benefit administration services are available through CoreSource, Starmark, Voluntary Benefit Solutions and other subsidiaries and divisions
Responsibilities:

• Interacted with Users and gathered requirements for Insurance Billing reports.
• Major responsibilities include getting requirements from the user, writing stored procedures for reports and developing reports using Crystal Reports 2008. Maintaining proper documentation of the reports for future reference.
• Involved in writing stored procedures to get data from database.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Developed complex reusable formula, parameter reports and reports with advanced features such as conditional formatting, built-in/custom functions and stored them in repository explorer.
• Exported reports from crystal to excel

Environment: Crystal Reports 2008, MS SQL Server 2008, .Net, Windows XP, Microsoft Outlook
Confidential,NY. Nov 05 – May 11
Projects: Client Reporting System (CRS) & Advanced Reporting System (ARS)
Title: Sr. BO Developer/Crystal Reports/Lead
Publicly traded global asset management firms in the world with approximately $490 billion assets under management.

Responsibilities:

• Interacted with Users and gathered requirements for Equity and Fixed Income reports.
• Major responsibilities include getting requirements from the user, writing stored procedures for Transaction and Appraisal reports and developing reports using Crystal Reports 2008 and WebI. Maintaining proper documentation of the reports for future reference.
• Worked closely with the DBAs, BA team and Marketing team to identify resolve bugs and issues related to the crystal and WebI reports.
• Involved in writing stored procedures (PL/SQL) to get data from database.
• Involved in User management tasks such as setting up authentication and adding users and groups
• Worked extensively on modules Web Intelligence, Desktop Intelligence and Central Management Console (CMC).
• Involved in setting security levels for all of the Business Objects Enterprise content.
• Created and maintained Universe supporting multiple levels of hierarchies for drill reports.
• Created Joins, Contexts, and Aliases for resolving Loops and checked the Integrity, Cardinalities of the Universe.
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements
• Used Linked Universes to share the common components usingComponent approach.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Developed complex reusable formula, parameter reports and reports with advanced features such as conditional formatting, built-in/custom functions and stored them in repository explorer.
• Wrote Formulas to calculate the Percentages and Summaries based on the group levels.
• Implemented logic to avoid orphan header and orphan footer.
• Developed pie and bar Charts using chart expert and customized them according to users’ requirements.
• Automated document Scheduling, Publishing and Distribution for Webi and Info view clients, using info view
• Used third party macros to implement new chart functionalities in crystal reports.
• Published and scheduled reports in Business Objects Enterprise XI.
• Exported reports from crystal to PDF and Microsoft excel formats
• Migrated reports from version Crystal XI to Crystal 2008.
• Interacted with users in resolving the Help Desk Tickets (Remedy Tickets, Service Now).
• Worked with offshore team to develop reports/ resolve issues
• Trouble shooting of all issues in BO Enterprise XI and Reports.
• Used PVCS/TFS/Subversion to store all the source code and its versions.

Environment: Crystal Reports 2008/XI/9, Business Objects XI 3.1, WebI, Infoview, Oracle10g, MS SQL Server 2008, PL/SQL, TOAD, Quality Center, Windows XP, PVCS, Subversion, Microsoft Outlook, Share Point and MPP

Confidential,DE Apr 05- Nov 05
Title: BO/ Crystal Reports Developer
Provides Life, accident and supplemental health insurance to individuals via direct marketing, specialized health care and related employee insurance benefits to expatriate employees of multinational companies on international assignments and health care and medical care management services to workplace and consumer markets.
Responsibilities:

• Actively participated in team meetings for business requirement analysis, functional and technical specification for Business Objects Universes and Report.
• Involved in the Installation and configuration of Business Objects XI.
• Involved in User management tasks such as setting up authentication and adding users and groups
• Major responsibilities include getting requirements from the user, writing reports in Crystal Reports XI.
• Worked extensively on modules CCM, Designer and CMC, Infoview, Crystal Reports XI.
• Involved in setting security levels for all of the Business Objects Enterprise content
• Worked closely with designers to design and build Universe, Classes and Objects.
• Created complex reports using Crystal reports XI.
• Developed custom reports as per the business user teams requirements specifications document.
• Created reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts
• Making report objects universally available to users by incorporating them into the enterprise repository.
• Worked on Sub Totals, Running Totals according to report requirements.
• Verifying database design and structure to ensure all reports are in-sync and up-to-date.
• Extensive knowledge in writing formulas using crystal /Basic syntax and shared variables.
• Exporting reports to other formats.
• Worked closely with production support team to move the reports to Production once they are finalized by the users.
• Worked in time constraints and met deadlines.
• Used PVCS to store all the source code and its versions.

Environment: Crystal Reports XI, Business Objects Enterprise XI, Windows XI and SQL server 2005, PVCS.

Project: Thahsil Level Information Center Application (TLIC)
Title: Application and Report developer

Project: Municipal e-Governance System (MeGS)

Municipal e-Governance System is a complete and comprehensive solution for the Municipal councils in the State of Maharashtra which automates the entire gamut of operations of this office. The system automates the most complex to routine municipal functions viz. Accounts and Budget, Establishment and Payroll, Property Tax, Water Tax System, Birth and Death Registration, Engineering Works and Tender Process
Responsibilities:

• Involve database analysis and design. Also responsible for designing the forms for the entire application.
• Developed stored procedures using PL/SQL.
• Developed efficient front-end interface utilizing Visual Basic 6.0.
• Responsible for writing stored procedures and triggers.
• Used Visual Source Safe effectively for Source Control like file tracking, simultaneous checkouts, merging etc
• Created Report templates, Detail Reports, Parameterized Reports and Cross-tab reports.
• Create Crystal Reports with multiple drilldown and sub-reports.
• Published and scheduled the reports in Crystal Enterprise using Crystal Management Console so that reports are accessed from Front-end application
• Conducted user-training sessions and technical support customers and troubleshoot data validity, connectivity access issues, and web issues.

Environment: Visual basic 6.0, Crystal Reports 8.5, Crystal Enterprise 8.5, Access, Oracle8i, Visual Source Safe, Acrobat and Excel

Project - 2

We have developed a large number of application software in order to integrate the front-end and backend of various government services. The following applications are developed in order to be delivered from the IT enabled Front end.

• Land Record management
• Community Certificates
• Affidavits
• RTO Licenses
• Property Tax Assessment and billing
• Water tax Billing
• Birth and death Certificates

Responsibilities:

• Involve database analysis and design. Also responsible for designing the forms for the entire application.
• Created Reports using Procedures and Views for faster execution.
• Developed efficient front-end interface utilizing Visual Basic 6.0.
• Responsible for writing stored procedures.
• Used Visual Source Safe effectively for Source Control like file tracking, simultaneous checkouts, merging etc
• Created Report templates, Detail Reports, Parameterized Reports and Cross-tab reports.
• Create Crystal Reports with multiple drilldown and sub-reports.
• Published and scheduled the reports in Crystal Enterprise using Crystal Management Console so that reports are accessed from Front-end application
• Worked on the troubleshooting of servers for application performance efficiency
• Interacted with the users and made report modifications according to their needs.

Environment: Visual basic 6.0, Crystal Reports 8.5, Access, SQL Server 2000, Visual Source Safe and Excel