PROFESSIONAL SUMMARY

• A self motivated professional with 6+ years of experience in the Information Technology industry.
• Extensive experience as a Report Developer / Analyst. Developed reports using Business Objects XI 3.1/R2/6.5 (Designer, Web Intelligence, Desktop Intelligence), Info view, Dashboards, Crystal Reports 2008/10/9.0, Import Wizard, Excel Pivot Reports and Macros.
• Experience in building Universes and involved in distribution and maintenance of universe.
• Experience in creating canned/ad-hoc Reports using the Web Intelligence and Desktop Intelligence modules using Universes and Personal data files.
• Design and develop Crystal Reports cross-tab reports, summary reports with drill-Up/down capabilities and sub-reports.
• Experience in creating Dashboards using Crystal Xcelsius.
• Experienced in scheduling documents using Central Management Console and Broadcast Agent.
• Efficient working with the following databases Oracle, MS SQL Server and MS-Access.
• Interacted with Business Users for the revamp of reporting modules.
• Efficient in Optimizing, Debugging and Testing SQL queries and stored procedures in Oracle and SQL Server.
• Manage the entire reporting process from design through implementation including gathering business requirements, report design, development, testing, and implementation, scheduling and publishing of reports.
• Self-motivated, team player with organizational and project management skills.

Areas of Expertise

Databases : Oracle 10g/9i, MS SQL Server 2003, DB2 9.0, MS Access 2003
Reporting Tools : Business Objects XI 3.1/R2/6.5 (Designer, Universe builder, Web Intelligence, Desktop Intelligence), Central Management Console, Broadcast Agent, Crystal Reports 2008/10/9.0, Crystal Enterprise 10/9.0, Crystal Xcelsius 4.5 and Excel Pivot Reports
Application Knowledge : BMC Remedy 7.0/6.0 ITSM Suite - Service Management disciplines
Languages : UNIX, C, HTML
Other Tools : Toad for Oracle, SQL * Plus, Visual SourceSafe, Adobe Acrobat, Share Point site administration
Operating Systems : Windows 2000/XP/Vista/Server 2003
MS Office : MS Office 2003/2007

Master of Science in Software Engineering

PROFESSIONAL EXPERIENCE

Confidential,New York July 2009 Dec 2009
Confidential, is a family of companies offering a range of health benefit plans and options combined with leading-edge wellness programs that help reduce health risks and control health care costs.

Role: Report Developer/Analyst
Providing reporting service and support for the Information Technology department.
Responsibilities:

• Responsible for the support of reporting modules in multiple projects and demonstrate advanced understanding of how reports can be used in support of business operations.
• Involve in gathering requirements from the business users related to projects that require new report and enhancements to existing reports and convert them into technical design.
• Manage the entire reporting process from design through implementation including report design & development, database connectivity, testing report functionality, scheduling, automated distribution and publishing of reports.
• Develop various reports including daily operational reports, management & metrics reports and functional reports for various projects using Business Objects (Web Intelligence and Desktop Intelligence), Crystal Reports and Excel Pivot reports based on customers current and future needs.
• Develop Business Objects Universes and visualize and design reports, dashboards, and balanced scorecard to align both objectives and measurements.
• Developed several Complex Reports (various features used include multiple groupings, drilldowns, parameter fields, formulas) using Business Objects Reports.
• Create database tables and views related to reports and connect using ODBC / OLE DB data sources.
• Export reports into various formats like PDF, HTML, EXCEL, and WORD by using Business Objects and Crystal Reports based on user requirements.
• Use Broadcast Agent and CMC to run and schedule reports.
• Responsible for Production support and also supported users to resolve reporting problems.
• Create test cases based on the requirements and performed report functional testing and user acceptance testing.

Environment: Business Objects XI R2/6.5 (Designer, Desktop Intelligence, Web Intelligence), Info view, Crystal Reports 10/9.0, Crystal Xcelsius 4.5, CMC, Excel Pivot Reports, MS SQL Server 2003, MS Access 2003, Excel Pivot Reports, MS Office.

Confidential, Hartford, Connecticut Aug 2008 June 2009
Confidential,is one of the largest investment and insurance companies based in the United States. The Hartford is a leading provider of investment products annuities, mutual funds, college savings plans as well as life insurance, group and employee benefits, automobile and homeowners insurance, and business insurance.
Role: Report Developer / Business Analyst
Providing reporting support for the Information Management department Personal Lines business
Responsibilities:

• Demonstrate advanced understanding of how reports can be used in support of business operations.
• Manage the entire reporting process from design through implementation including gathering report requirements, report design & development, scheduling reports and publishing reports on the web using Sharepoints.
• Develop Business Objects Universes and created custom canned reports using web Intelligence, Crystal Reports and Excel Pivot reports based on client’s current and future needs.
• Interacted with Business Users for the revamp of reporting modules.
• Collaborated with customers and requirements team to visualize and design reports, dashboards, and balanced scorecard to align both objectives and measurements.
• Design and develop Crystal Reports cross-tab reports, summary reports with drill-down capabilities and sub-reports.
• Export reports into various formats like PDF, HTML, EXCEL, and WORD by using Business Objects and Crystal Reports based on user requirements.
• Use Crystal Management Console to run and schedule reports.
• Create Oracle Tables / Views for data extraction. Configured using ODBC / OLE DB data source.
• Reduce cost and development time by creating report parameters, report templates for re-use.
• Create test cases based on the requirements and worked with Business Analysts to test the reports.
• Effective self-starter with a can-do attitude who takes ownership and accountability for project deliverables with a demonstrated ability to multitask.

Environment: Business Objects XI R2/3.1 (Designer, Web Intelligence), Info view, Crystal Reports 10/9.0, Crystal Enterprise 10/9.0, Excel Pivot Reports, Oracle 9i/10g (SQL, PL/SQL), Toad, SQL * Plus, MS Access 2003, Excel Pivot Reports, MS Office, SharePoint site administration.

Confidential,Northbrook, Illinois May 2007 June 2008
Confidential, is one of the fortune 100 companies in the United States. It sells different lines of insurance including auto, life, property and commercial.
Role: Report Developer
Providing reporting service and support for the Infrastructure Solutions department.
Responsibilities:

• Develop, implement and supported various reports including management reports, strategic & operational reports, metrics and service level reports that have high quality and standards for various customers across the company using Business Objects, Crystal Reports, MS Access and Excel (Pivot report).
• Managed the entire reporting process from design through implementation including gathering report requirements, report design & development using Crystal Reports 9.0, scheduling reports using Crystal Enterprise 9.0, and publishing reports on the web using Sharepoints.
• Developed Business Objects Universes and created custom canned reports using web Intelligence based on client’s current and future needs.
• Developed Crystal reports using cross-tab and sub reports to show necessary information. Created Drill Downs from the Graph and Charts like Bar Chart, Line graphs, Pie Charts based on user requirements.
• Created Excel reports by extracting the data directly from database by writing Free Hand SQL.
• Used Crystal Enterprise to run and schedule reports. Responsible for Crystal Enterprise Server administration which include account creation for various users and granting them access to view and schedule reports as required.
• Created Oracle Tables / Views for data extraction. Configured using ODBC / OLE DB data source.
• Remedy application is used in data extraction for reports related to the ITIL Incident, Problem, Change Management and Service Requests processes.
• Developed in-depth understanding of all the Remedy data sources, tables and data relationships for purpose of reporting.
• Responsible for Production support and also supported users to resolve reporting problems.
• Performed User Acceptance testing and documentation for user reference.

Environment: Crystal Reports 10/9.0, Crystal Enterprise 10/9.0, Business Objects XI R2 (Designer, Web Intelligence), Info view, Oracle 9i (SQL, PL/SQL), Toad, SQL * Plus, MS SQL Server 2003, Excel Pivot Reports, BMC Remedy ITSM 6.0, MS Office, Sharepoint site administration.

Confidential,Towson, Maryland Oct 2005 April 2007
Confidential, is a global manufacturer and marketer of quality power tools and accessories, hardware and home improvement products, and technology based fastening systems. Throughout businesses, it has established a reputation for product innovation, quality, end-user focus, design, and value.
Role: Report Developer
Providing reporting analysis and support for the Marketing unit.
Responsibilities:

• Demonstrated understanding of how reports can be used in support of marketing operations.
• Developed, implemented and supported various reports including market analysis reports, operational reports using Crystal Reports, MS Access and Excel (Pivot report).
• Responsibilities include gathering report requirements, report design & development using Crystal Reports 9.0 and Excel Pivot Reports; create Oracle tables and views for data extraction, configure using the ODBC data source.
• Use Crystal Enterprise to run and schedule reports on the web.
• Developed various report Charts and Graphs like Bar Chart, Line graphs, Pie Chart based on user requirement. Used generalized formulas using both Crystal and Basic Syntax.
• Designed Test Cases based on the requirements and worked with Business Analysts to test the reports.
• Responsible for report documentation and data mapping.
• Reusable report applications, report parameters, report templates were created to reduce cost and development time.
• Perform Unit, Integration and Functional testing.

Environment: Crystal Reports 10/9.0, Crystal Enterprise 9.0, Oracle 9i (SQL, PL/SQL), Toad, MS Access, Excel Pivot Reports, MS Office.

Confidential,Chennai, India June 2003 July 2005
An IT based company that offers an exhaustive range to IT services and products. The company provides innovative and high end technology solutions with superior quality focused towards timely delivery.
Global Data Management System is the operational software. It is an integrated solution to manage the operations of the enterprise. The system is multi-client and web-based.
Role: Report Developer / Analyst
Responsibilities:

• Involved in the analysis and design phase of the project.
• Mainly involved in the entire reporting phase which includes report requirements gathering, report design, testing, implementation, scheduling of reports.
• Created technical and functional specification based on project requirement for reporting.
• Designed and developed Crystal Reports, Cross Tab reports and Sub reports for highlighting significant data and summary reports with drill-down capabilities.
• Created sub reports, drill down reports, various Charts and Graphs like Bar Chart, Line graphs, Pie Charts.
• Used Crystal Enterprise for scheduling and exporting reports into various formats like PDF, Excel and Word.
• Created tables and views using Oracle for reporting and data extraction.
• Performed user acceptance testing and documentation for all the reports.

Environment: Crystal Reports 9.0, Crystal Enterprise 9.0, Oracle 9i, ASP.NET and VB.NET.