SUMMARY

• Self-motivated and result-oriented professional in Information Technology with 8 years of experience performing Design, Architecture, Development, Implementation, Testing, Documentation, User-Interaction
• Extensive experience with different report development tools such as Crystal Reports, Desktop Intelligence, and Web Intelligence.
• Extensive experience in creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, TOP/Bottom N drill-down reports, Section wise Grouping, Charts and Map , Image overlay, analysis reports, data reports and Portals based on business requirements, technical specifications and followed coding standards.
• Strong Experience writing SQL Queries for Back-End data Extracts and created queries using Add Command object in Crystal Reports XI.
• Connect Crystal Reports XI to different data sources Oracle, SQL Server, MS Access, and XML .
• Strong knowledge In Oracle databases, writing complex SQL queries, Stored Procedures and Triggers for Oracle data modeling.
• Experienced with the administration and management of Business Objects Enterprise XI R1/R2/R3.1 and Crystal Enterprise 10.0
• Strong knowledge in providing technical support for implementation, troubleshooting and fixing of Business Objects/Crystal Reports applications.
• Development experience using Microsoft Technologies including Visual Basic and .NET.
• Experienced with the gathering, analyzing and documentation of business requirements.
• Very good experience in creation of Help manual for Application using HTML Help Workshop
• Highly experienced with multitasking and handling different roles at the same time.
• Excellent interpersonal communication, problem solving skills, documentation skills and Business analytical skills.
• Highly motivated and result oriented professional with strong technical, interpersonal and communication skills.

TECHNICAL SKILL SET

• RDBMS: MS SQL Server 2008/2005/2000/7.x, Oracle 10.x/9.x/8.x/7.x, DB2 7.1, MS-Access 2000/97
• Programming Languages: Java, C, C , Basic, COBOL, Visual Basic, HTML, DHTML, .NET framework
• Database Programming: SQL, PL/SQL
• Database GUI Tools: Toad 7.x/8.x
• Reporting Tools: Crystal Reports XI/10.0/9.0, Business Objects XIR1/X1R2/X1R2 SP2/6.x, Web Intelligence 11/6.x, Desktop Intelligence 11, Crystal Enterprise 11.0/10.0/9.0, Business Objects Enterprise 11
• Change Management Tools: Rational Clear Case, Rational Clear Quest
• Operating Systems: Windows Vista/2000/NT/XP, UNIX, MS-DOS
• Microsoft Office: Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Access, Microsoft Front Page 2000
• Internet utilities: Netscape Navigator, MS Internet Explorer 6.0, Oracle9i Application Server, Install shield and SQL Developer, Mozilla Firefox, Adv. Video Converter, SQL Navigator

Confidential

WORK EXPERIENCE

Confidential

Title: Crystal Report Developer and Requirement Analyst

Description: Designing, creating and exporting reports for Confidential based on the requirements provided by the FEMA people. These reports were developed for the Senate people. National Flood Insurance Program involved the flood and hurricane loss details which involved the insurance companies.

Role

• Designing, creating new reports in Crystal Reports 2008 and debugging existing reports in Crystal Reports Version XI R2 SP4 and incorporated in to Management Products.
• Appending multiple tables, materialized views to create complicated reports as per the user requirements.
• Involved in Writing Complex formulas, parameters and conditions depending upon selection criteria.
• Creating command objects and Linking sub reports without affecting the performances of the existing report
• Preparing complex reports, Top N bottom N reports, Sub Reports, Cross Tab Reports, Parameter Based Reports, Formula Creation, embedding formulas and parameters in text fields.
• Creating reports using XCelsius and multiple sub reports.
• Worked with Business Objects Enterprise version XI R3.1 for maintenance of the reports.
• Scheduling and Publishing /Refreshing Reports in stipulated time.
• Worked with Web intelligence/desktop intelligence in a team.
• Involved in the administration of Info View and Central Management Console CMC for implementation of security at Report level, Folder level. Created Users, user groups.
• Used Instance Manager to find statuses on report executions and Schedule Manager to change the database parameters for multiple reports at once while migrating reports between environments.
• Wrote several database objects like packages, procedures, functions, triggers etc using Oracle PL/SQL.
• Worked with development team to troubleshoot and perform Tuning to increase performance efficiency.
• Change management using Clear Quest.
• Updated the versions of the reports based on FEMA requirements in Visual Source Safe.
• Creating performance information records and auditing it for future improvements.
• Creating reports and charts depicting flood, hurricane affected areas for Federal government employees especially for the senators.
• Tested the reports for data matching with the existing sample bureau reports for historical data.
• Worked on production support issues.
• Exported reports into various formats like PDF, HTML, EXCEL, and WORD for end users.

Environment: Crystal Reports 2008/ XI R2 SP4/XI R3.1, Business Objects Enterprise XI R1/R2, Oracle 10g, Universe Designer, Web Intelligence, Import Wizard.

Confidential

Title: Crystal Report Developer and Application Analyst

Description: Designing, creating and exporting reports using Crystal Reports and incorporated in to Health care Scheduling for Resource Management and Billing System.

Role

• Designing, creating new reports in Crystal Reports 2008 and also in Crystal Reports Version XI R2.
• Creating reports using Command Objects to retrieve data with date ranging for multiple years and produce annual total for each year without using sub reports.
• Creating and Linking sub reports without affecting the performances of the existing report
• Preparing complex reports, Top N bottom N reports, Sub Reports, Cross Tab Reports, Parameter Based Reports, Formula Creation, embedding formulas and parameters in text fields.
• Used Desktop Intelligence and Web Intelligence reports to deliver them to clients.
• Performance tuning for complex SQL queries.
• Worked with Business Objects Enterprise version XI R3.1 for maintenance of the reports.
• Scheduling and Publishing /Refreshing Reports in stipulated time.
• Involved in the administration of Info View and Central Management Console CMC for implementation of security at Report level, Folder level. Created Users, user groups.
• Wrote several database objects like packages, procedures, functions, triggers etc using Oracle PL/SQL.
• Extensively involved in SQL, PL/SQL coding creating complex queries and stored procedures to give better results at Crystal Reports.
• Change management using Clear Case and Clear Quest.
• Creating performance information records and auditing it for future improvements.
• Creating reports and charts depicting doctors and patients performance against hospital allied utilization, stores items utilization, Resource Management and billing history.
• Tested the reports for data quality.
• Creating folders for Custom made reports and implemented in to the application.
• Exported reports into various formats like PDF, HTML, EXCEL, and WORD for end users.

Environment: Crystal Reports 2008/ XI R2 SP4/XI R3.1, Business Objects Enterprise XI R1/R2, Oracle 10g, Universe Designer, Web Intelligence, Publishing Wizard, Import Wizard.

Confidential

Title: Business Objects/Crystal Reports Developer

Description: Confidential is one of the oldest insurance companies in Massachusetts. They Specialize in property and casualty insurance. There are different applications for different areas of Business. This project involved in bringing data from different sources and loading it into a data mart and upgrade of Business Objects enterprise XIR1 to XIR2.

Role:

• Reporting to team leader for report designing, deployment and also involved in gathering requirements, analysis and implement specifications of the system.
• Coordinating with a team of three developers, Team Leader, Project Manager, department managers, and business owners.
• Created Standard reports, Cross-tab Reports, Sub Reports and Drill down Reports using Crystal reports XI versions R1/R2.
• Created linked, unlinked , on-demand sub reports using formula fields, parameter fields, Group selection and record selection, Top N /Bottom N and drill down in Crystal reports
• Displayed pie charts, bar graphs more understandable for top-level management using Analyzer in the reports.
• Created Static and Dynamic Parameter fields for the filtering of the data.
• Created Desktop Intelligence and Web Intelligence reports.
• Used BOE version XI R1/R2 in order to schedule reports on a weekly basis using Schedule Manager.
• Worked with Central Management Console, which is web based administration component for setting up security and user creation.
• Resolved conflicts and issues in relation to the technical architecture and published reports on the web using Crystal Enterprise XI Publishing Wizard.
• Tested the reports developed by other developers in team before submitting it to web team to publish these reports in Crystal Enterprise Production environment.
• Deployed reports on to Business Objects Enterprise by using Publishing Wizard, Import Wizard.
• Involved in Writing Views, creating Indexes, Packages and Sql Queries and Stored Procedures for the Reports.
• Assisted with project planning, workflow analysis and documentation, including methods, processes, tasks and schedules.
• Participated in bi-weekly crystal developers meeting to discuss about the issues and solutions we had/found during last weeks so that this helped all the crystal developers to be on one page.

Environment: Business Objects Enterprise XI R1/R2, BO Designer, Web intelligence XIR2, Desktop Intelligence XIR2, Crystal Reports XI R1/R2, Windows XP/2003, Oracle 10g, SQL Server 2005.

Confidential

Title: Crystal Report Developer

Description: Confidential is a leading provider of fully integrated wireless communication services. This project involved customer segmentation and aimed to design and build reports from an online billing system. Application provides historical summary of customer usage profiles, categorized across different regions and different age groups. Reports were made to facilitate the end user to extract detailed customer information, service usages, billing information, and account details.

Role:

• Involved in gathering requirements, analyzing and creating reports for various departments.
• Created standard reports, sub, drill down and cross-tab Reports using Crystal reports XI.
• Created static, dynamic and dynamic cascading prompt parameters.
• Provided inputs for consolidating data from different sources.
• Gathered requirements for Universe development
• Designed Ad-hoc reports in Desktop Intelligence and WebI.
• Created Crystal reports against the universe instead of writing separate queries and scheduled the reports.
• Created requirements documents and wrote technical specifications for the Web intelligence and Crystal reports
• Functionality available through existing Crystal reports was included in the universe design
• Upgraded Business Objects Enterprise XIR1 to Business Objects Enterprise XIR2
• Moved the CMS from MS SQL Server 2000 to Oracle 10g
• Involved in scheduling the daily and Weekly reports using Business Objects Enterprise XI.
• Created derived tables at the universe level to reduce the complexity of universe building
• Involved in writing SQL queries, Stored Procedures, Views and created Tables for company related data analysis.
• Made modifications to the security model.
• Proposed row-level security for the policies and claims data
• Designed, developed, and documented an Executive Dashboard for business metrics like Quoting and Issuing policies and presented to CEO and senior vice presidents.
• Worked as production support analyst so as to estimate the level of effort and resolution time

Environment: Oracle Apps., Oracle 9i, Crystal reports version XI R1, Business Objects, Crystal enterprise 10, TOAD, Windows NT, Ms-Excel, SQL Server 2000

Confidential

Title: System Report Analyst

Description: To perform the requirement analysis in the core area and to develop Entire hospital management Systems and published reports through browser.

Role:

• Developed reports using cross-tabs and sub-reports.
• Created custom reports and written documentation for users on how to select necessary parameters and date frames for different selections.
• Provided training to the end users to use the e-portfolio, to obtain web based reports, access and logging e portfolio, describing interface.
• Maintaining scheduler to print report in scheduled periods.
• Creating and maintaining users/patients list, log on details, password management and security analysis.
• Creating table and Inserting, Updating and Deleting of records that holds the patients name and details.
• Allotting roles to hierarchy of users and requirements.
• Developed reports and templates for custom reports created summary reports.
• Migrated data from MS-Access to Excel based on requirement.
• Exported reports into various formats like PDF, HTML, EXCEL, and WORD for end users.

Environment: Windows NT/2000/XP, SQL server, VB6, Oracle, MS-Access 2000, Crystal reports

Confidential

Title: Consultant / Team Leader

Description: Work involves designing of reports based on the performance of systems and electrical equipments and constant monitoring over the variation of the unit performance.

Role:

Consultant for Business Analysis and Report Designing.

• Duty involves designing, testing, deployment and training of reports, creates work flow diagrams, deployment diagrams, sequence diagrams, context analysis diagrams and to define the architecture of software systems in terms of complicated areas and non compromised 100 public safety oriented module.
• Designing analytical based reports, Cubes, TOP N, Bottom N, and Turn Round Reports for analysis using crystal Analysis.

Environment: VB6, CR9, HTML, VB Script, SQL Server 7/2000