SUMMARY:

• 8+ years of IT experience in Business Analysis, Business Intelligence, Data Warehousing, Data Mining, Data Analysis, Design, Development, Implementation, OLAP and Testing of BI, Database & Data Warehousing applications
• Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing.
• Excellent data - analysis skills and ability to translate specifications into a working Universe and Report.
• Expertise in planning, designing, developing, distributing and maintaining Universes.
• Expertise in Universe designing, developing and generating complex, Adhoc, dashboard Reports.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Experience in migrating and converting DeskI reports into WebI reports.
• Experience in creating Adhoc reports using Business Objects Web Intelligence tools.
• Expertise in working with all modules of SAP Business Objects XIR3/XIR2/6.X/5.X,Crystal Reports 2008 & Xcelsius 2008.
• Worked with End-To-End implementation of Data warehousing team and Strongunderstanding of Data warehouse concepts, Technology using Star Schema, Snowflake Schema’s and Multi-Dimensional Model’s in respective to query and analysis requirements.

TECHNICAL SKILLS:

BI and ETL Tools: Business Objects XIR4/XIR3/XIR2/6.x/5.x, Informatica 6.1/9BCA, Crystal Reports 2008, Xcelsius 2008.

Operating System: WINNT/2000/98/XP, Win 2003/2008, Unix/Linux

Management Tools: MS Project, Word, Excel, PowerPoint

Database: Oracle 11/10g/9i/8i/, DB2 DWE, MS-Access

Data Modeling: Erwin 4.x/3.x, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Fort Wayne, IN

Senior BO Developer

Responsibilities:

• Involved in Full life cycle design and development of ODS and Business Objects reporting Applications.
• Involved in analysis and evaluation of the Business Functional Requirements and converting them to technical requirements for developing Key Performance Metrics in the universe.
• Worked with ETL and Data Architect team assisting them in the creation of database objects to build the appropriate Universe and configure the reports accordingly.
• Extensively involved in providing gap analysis between the existing legacy system and current ODS to help the core management team to take decisions for better Business Intelligence Solutions.
• Worked with onsite and offsite teams to develop the reports and assigned the work as per the priority.
• Performed code walkthroughs, formal reviews and participated in design and development reviews.
• Involved in testing and performance tuning of several key components of the Business Objects system.
• Architected, designed and developed event based scheduling process of the reports.
• Involved in building enterprise shared services folder access as per the security of theindividuals.
• Involved in writing Test scenarios, test scripts for System testing, UAT and uploading toQC to test and resolve assigned defects.
• Extensively involved in the development and implementation of ad-hoc reporting systemusing Business Objects Web Intelligence, and WebI Rich Client and developing the universes to suit Business Requirements.
• Involved in converting DeskI reports into XIR4 WebI reports and resolved issues while converting.
• Involved in user and Knowledge transfer of the reports.

Environment: Business Objects XIR4/XI R3.1 SP5/XI R2, Xcelsius 2008, Business Objects Live Office, Informatica Power center 9.0.1, Oracle 10g/ 11, SQL, HP Quality Center 11,VMMS Visio, Erwin.

Confidential, Mclean, VA

Sr. BO Developer

Responsibilities:

• Involved in gathering business requirements, functional requirements & data specifications
• Migrated reports from BOXI R2 to BOXI R3.
• Designed complex Web Intelligence and Desktop Intelligence Reports.
• Created and tested classes and objects to organize the universe.
• Created complicated reports including sub-reports, graphical reports, formula based and well formatted reports according user requirements.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Created Objects using different Business Objects functionalities like @ prompt in the process of designing the universes.
• Linked the Universes to share the common objects between them.
• Created Alerts in various reports according to user requirement.
• Used Broadcast Agent to schedule the reports depending on the user profile.
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and predefined Conditions to use in Business Objects.
• Involved in designing Business Objects Universes, Queries, and Reports.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in Reports.

Environment: Business Objects XI R3/XIR2 (DeskI, WebI), Import Wizard, Repository Migration Wizard, Xcelcius, Crystal Reports XI, SQL server 2005, Oracle 10g.

Confidential, Rosewood, IL

Business Objects Developer

Responsibilities:

• Worked with business to gather requirements and document them.
• Created statement templates (Business Objects reports).
• Created requirement documents using legacy power builder code and regular meetings with business.
• Involved in database design and feed processing.
• Created and maintained universe using designer.
• Created statement templates (Business Object reports) this can be used to generate statements for clients with different requirements.
• Created Webi reports which can be used by business to get aggregated view of multiple clients and their outstanding positions.
• Prepared test cases and executed them in development and SIT environments
• • Implemented various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select...
• Created complex reports by linking data from Multiple Data Providers, using Free Hand SQL and functionalities like Combined Queries
• Extensive involvement with the testing team to derive test cases for efficient Data reporting and testing of new reports and mocking up data as necessary
• Converted the existing full client reports to WebI reports using Report Conversion Tool.

Environment: Oracle 10g, Business Objects XI R2, Sub Version, Solaris, TOAD.

Confidential, MO

Business Objects Report Developer

Responsibilities:

• Responsible for gathering, analyzing, cleansing and loading of data into the database.
• Analysed the existing reports in Excel and developed the reports in Business Objects.
• Used many Data Providers to create a single report and also multiple reports.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice,
• Drill Down, Cross Tab, Master Detail and Formulae’s etc.
• Formatted the reports to match exactly with the predefined styles.
• Used filters to format the tables in a report.
• Used MS-Access to load data into database.
• Published reports to Corporate documents and to User documents.
• Linked data providers to create complex reports and Ad hoc reports.
• Created formulas as variables, so that variables can be used for different purposes.
• Created report in such a way that when it is exported to excel, it should exactly match cell to cell with that of pre created excel sheet.
• Involved in Analysing, Developing, Implementation & testing phases in the project
• Involved in presentations and project documentation.

Environment: BusinessObjects 6.5.1, WebI 2.7,Oracle 9i, PL/SQL,DB2,MS-Access, Lotus Notes 6.5, UNIX(AIX 5.2).