Summary

• 6+ years of Information Technology experience and Expertise with Business Objects, Crystal Reports
• Expertise in working with OLAP tool Business Objects XIR3.1/R2 (Designer, Reports, Info view, Web Intelligence (WEBI), Desktop Intelligence (DESKI), CMC
• Hands-on Experience in working and implementing Crystal Decisions, Crystal Reports XIR2.
• Expertise in Universe designing/developing and generating complex reports, business views, ad-hoc reports, dashboards, list of values (LOV) along with user acceptance test (UAT).
• Extensively used Business Objects Reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks
• Expertise in using Import Wizard to migrate reports and universes between different environments like development, testing and production.

Experience in Star-Schema Modeling, Snowflake Modeling, Fact, Dimension tables and Dimensional modeling using Erwin tool.

• Experience in Migrating Universes, Reports to newer versions and documenting the whole process during the project life cycle.
• Worked with Crystal Report XIR2 for creating complicated reports including parameter based reports, graphical reports, sub-reports, formula based, well-formatted reports, analysis reports, drilling reports, data reports along with LOV.
• Excellent ability in creating specifications and gathering requirements from users and to develop Reports solutions.
• Expertise in designing Universes, WebI Reports, DeskI reports, and Client-Level Reports.
• Involved in design, prototyping, development, testing, maintenance and support of multiple universes.
• Worked with various databases including Oracle 10x/9i/8.x, MS SQL Server2000/7.0, etc.
• Experience in gathering customer requirements and functional requirements and converting them to technical requirements.
• Aptitude for analyzing, testing, identifying problems and creating solutions, excellent time management skills, good team player with excellent communication skills.
• Exposure on Crystal Reports.

Technical Skills:

Reporting Tools Business Objects XI R3.1/R2, Web-Intelligence 2.x,Crystal ReportsXI
Operating Systems Windows 2000, Windows NT, Windows 95/98, UNIX

Data Ware Housing Business Objects XI R2, Designer XI R2,WebI, DESKI

RDBMS Oracle 10 X/9i, MS SQL Server2000/7.0. 

Education: M.C.A (Master of Computer Applications)

Professional Work Experience

Confidential, IL May 09 – Mar11

BO Developer

Walgreens is one of the largest retailers in the US with primary business of pharmacy. Currently they have 6000+ stores nationwide. The 340B program resulted from an enactment of Public Law 102-585, the Veterans Health Care Act of 1992, which is codified as Section 340B of the Public Health Service Act is used to provide discount for eligible patients.

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications to generate the Reports.
• Interpreted business requirements and created System Requirement Specifications.
• Created universes, classes, objects, complex measure objects, prompts, pre-defined conditions.
• Created universes for the users to do ad-hoc Reporting.
• Resolved loops by either creating aliases or contexts or by defining shortcut Joins.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Created Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Created billing reports, charts using Universes as the main data provider
• Created graphical representation of reports such as Bar chart, Pie chart etc. as per the end user requirements.Created number of formulae, conditional display of fields for complex calculations and used them in different sub reports.
• Built queries to retrieve data in Oracle through a universe and set up query conditions.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc by using Chart expert of Crystal Reports .
• Worked on crystal complex reports that require running totals, sub-totals, sub-reports, hierarchies, cross-tab, multiple groups and conditional display of groups, fields, and messages.
• Developed several complex reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) using Crystal Reports.
• Developed several complex reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) using Crystal Reports.

Environment: Business ObjectsXI R2 ,WEBI, DESKI, Designer, Info View ,Crystal ReportsXI,
Oracle 10g , Windows2000/XP.l

PNB is the first nationalized bank in India to have initiated the implementation of Enterprise Wide Data Warehouse (EDW) to meet the business critical needs.
The Enterprise Data Warehouse (EDW), which will be an integrated repository of current and historical data for MIS and decision support, will meet both external and internal analytical reporting requirements. The data warehouse would provide the top management, executives at both the operational and policy-making level, with instant access to the warehouse containing integrated information from wide-ranging sources within the bank.

• Analyzed the business requirements of the project by studying the Business Requirements

Specification document.

• Involved in peer review meetings with end user community. Developed ad-hoc reports for end users.
• Developed functional specifications
• Created several full client reports using Business Objects XI R2
• Wrote test cases for newly generated database schema

Environment: Business Objects XI R2, SQL, Oracle9i, Windows NT.

Confidential Nov-04 to Dec-05

NBPGR is to plan,conduct n coordinate all the germplasm collection,introduction,exchange,evaluation,
Documentation,conservation and sustainable management of diverse germplasm of crop plants.

• Developed functional specifications
• Maintain the Quarantine database
• Create the several reports using MSAccess

Environment : ASP,MS-Access 2000,Windows 2000