PROFESSIONAL PROFILE

• Accomplished IT professional with around 12 Years experience in software development.
• Over 8 years experience and exposure with all modules in Business Objects, Business Objects XIR3/XIR2/6.5 Infoview, Web Intelligence, Desktop Intelligence, Central Management Console CMC , Crystal Reports XI/ Crystal Reports 2008.
• 2 years of experience in SAP Business Intelligence with BO and Crystal XCelsius 2008, Live Office QAAWS.
• Experience in designing and developing standard and custom Info cube, DSO objects, info object catalogs, Infoobjects, Transformation, Info package, DTP, Data source, Characteristics and Key figures, Multiproviders, Business content.
• Experience with Data Warehouse Concepts, Methodologies and SDLC.
• Strong Knowledge with Star Schema and Snow Flake Schema Data Models.
• Experience in Reporting using SQL SSRS.
• Skilled in Relational Databases like Oracle, MS SQL Server and MS-Access.
• Experience using Oracle, SQL, PL/SQL Developer, TOAD and Teradata.
• Created reports using stored procedures and views in Oracle database
• Extensive experience in Performance tuning the Queries for report performance
• Experience in creating Universes with Aliases, Contexts, and Linked Universes
• Created Drilldown Reports, Sub Reports, On-Demand Sub Reports, Label Reports, Chart Reports, Styles and GUI's. Prompt using Crystal Reports XI/2008.
• Created the dashboards using Xcelsius 2008
• Experience performing Unit Testing and Performance Testing for the reports.
• Experience using Microsoft Excel, Microsoft word, PowerPoint, PDF's interaction with Business Objects
• Excellent analytical, communication and interpersonal skills.
• Capable of working in a team and/or individually, self-motivated.
• Analyzed, designed, developed and performed self-QA on applications while working directly with end-users and technical members of the teams

TECHNICAL SKILLS

• OLAP Tools: Business Objects XI R3/R2/ 6.5, Crystal Reports 2008/XI/9, Crystal Xcelsius 2008, Web Intelligence, Info view, LDAP, ETL Data Integrator , SAP integration with BI/BO.
• Database: Oracle 10g/9i/8i, SQL Server Reporting Services SSRS , MS SQL Server 7.0/2000/2005/2008 DB,2, Microsoft office, MS Access, Teradata
• Languages: Oracle Developer 2000 Forms/Reports, SQL, PL/SQL, HTML, XML, SQR, JavaScript, VBScript, Visio Flowcharting .
• Technologies: Servlets, Java AWT, JDBC/ODBC, .Net, ASP.NET 2.0/3.0
• Operation Systems: Windows 7, 9x, NT, 2000, XP, UNIX and Sun Solaris, AIX
• Tools: PVCS, Tivoli, Peregrine

ACCOMPLISHMENTS

Confidential

Crystal Reports Developer

Responsibilities:

• Created the Reports, Using Crystal Reports 2008 and MS SQL Server 2008.
• Developed the Para Transit and Fixed Transit Reports using parameters, formulas, filters and group by etc.
• Created different types of reports, Cross-tab, Sub reports, On-Demand Sub Reports, Conditional, Drill down, Summary and Tested the Reports.
• Created New Reports and modified existing Reports.
• Scheduled the Reports using Infoview.

Environment: MS SQL Server 2008, Crystal Reports 2008, Business Objects XIR3.1. Windows 7.

Confidential

BI Reports Developer

• Project: Gate Tools
• Owens Corning Company is a global industry and leading innovator glass and fiber technology.
• The purpose of this project is designed developed for the Foam, Roofing and Insulation Attainment Reports.
• Responsibilities:
• Created Web intelligence reports for Sales, Rebate, Price Impact Volume Impact Funding and Incremental price Impact, Incremental Volume Impact and using all the functionalities
• Developed Business Views on top of universes
• Deployed the reports to CMC for the users to able to see the reports in Info View and run, schedule and view the reports in different formats PDF, Excel

Environment: Oracle 10g, Business Objects XIR3.1, Excel, SAP BW, Windows Vista Enterprise.

Confidential

Crystal Reports Developer

Responsibilities:

• Created the Crystal Reports, Using Crystal Reports XI and Oracle 10g.
• Tested the reports by cross checking and verified data against the reports generated from the Crystal Reports v9 and the legacy system.
• Created the group by reports using formulas, filters and with and without parameters etc.
• Created different types of reports using Crystal Report XI: Sub reports, On-Demand Sub Reports, Conditional, Drill down, Summary and Parameter prompts.
• Designed Report Template according to the Company standard requirements.
• Scheduled the Reports using Infoview.
• Extensively used Toad to understand the data.

Environment: Oracle 10g, MS SQL Server 2008, Crystal Report XI, Business Objects XIR3, Windows Vista Enterprise.

Confidential

Crystal Reports/BO Developer

Responsibilities:

• Created the Scorecard automation report using Crystal Report 2008 including Standard, Grouping, and Conditional.
• Created Sub-Reports for YTD Impacted View, YTD Accountable View, Current Month Accountable View.
• Developed and Tested the Reports
• Prompts for Filter
• Drill-down capability
• Summarization
• Formula based conditional parameters.
• Published Reports to CMC Central Management Console and involved in Scheduling and exporting the reports in different Formats.

Environment: Crystal Reports 2008, Business Objects XIR3, Oracle 10g, SQL Server Reporting Services SSRS , MS SQL Server 2008, Windows XP.

Confidential

Crystal Reports/BO Developer

Responsibilities:

• Created Production monitoring reports using Crystal Report 2008 including Standard, Grouping, and Conditional.
• Created the Post Assembly Report for Production Monitoring.
• Created Sub-Reports for Crate Goal totals, Top 10 Repairs, Roll Test Acceptance, Repairs by Mechanic.
• Developed and Tested the Reports
• Prompts for Filter
• Drill-down capability
• Summarization
• Formula based conditional parameters.
• Scheduled the Reports using InfoView

Environment: Crystal Reports 2008, Business Objects XIR3, Oracle 10g, SAP BW, MS SQL Server, SQL Server Reporting Services SSRS , Windows XP.

Confidential

Responsibilities:

• Designed SAP BO Universes both in OLTP Data warehouse and OLAP environments.
• Used Designer to create universe set universe parameters, link tables, create classes, classified objects into classes based on business logic, create contexts and aliases to avoid traps, create derived tables, create hierarchies .
• Created Financial Management Reports Using BO WEB Intelligence Rich Client
• Created reports using Business Objects functionality like queries, slice and dice, drill down, crosstab, master detail reports, formulas, etc.

Environment: Business Objects XIR3, Crystal Reports 2008, Oracle 10g, SAP BW, MS SQL Server, Windows XP, InfoView, WEBI

Confidential

Crystal Reports/BO Developer

Responsibilities:

• Created different types of reports using Crystal Report 2008 including Standard, Grouping, and Conditional.
• Created reports for Current General Ledger Account Balances.
• Created reports for G/L Reconcilement, Sub- Application Balance systems and Matched G/L Items.
• Drill-down capability
• Summarization
• Formula based conditional parameters.
• Published the Reports using InfoView Daily, Weekly, Monthly.

Environment: Business Objects XIR3, Crystal Reports 2008, Oracle 10g, MS SQL Server, Windows XP, InfoVIew, WEBI, Frontier, and Desktop Intelligence.