SUMMARY

• Over 9 years of experience in IT industry with expertise in Data warehousing and Business Intelligence.
• Experience in Data warehousing technologies and methodologies, with in - depth Professional development experience in tools like Business Objects 6.X, BO XI R2, BOXI 3.1,4.1 Crystal Reports 10, Business Objects Designer, Information Design Tool IDT, Web Intelligence, Oracle 8i, 9i, 10/11g.
• Expertise in Implementation and Support using Business Objects (6.x/XIR2, BOXI 3.1, 4.1) in Data Warehousing environment in various projects like Development, Production Support and Migration.
• Involved in creating universes, designing and maintaining various reports using Business Objects 6.5 and XI R2/XI R3.1/4.1, Crystal Reports
• Experience in developing canned / ad-hoc reports and fine tuning reports using variables calculation, multilevel breaks, sections, alerter etc.
• Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, etc.
• Designed and maintained security objects such as Users, User groups, permission and access rights through Supervisor/CMC.
• Created and maintained universe using Information design tool IDT.
• Used Import Wizard and Version Manager for promoting teh reports and universes into different environments
• Involved in Scheduling and publishing reports in Business Objects Enterprise Environment.
• Experienced in Migration from lower to higher versions of Business Objects.
• Extensive experience in writing system specifications, translating Business User requirements to technical specifications.
• Worked in Project using Agile and Scrum Methodology.
• Worked in End-To-End implementation with Data warehousing team and Strong understanding of Data warehouse (DW) concepts Star Schema, Snowflake Schemas and Multi-Dimensional Models.
• Exposure to Data Modeling, Normalization, and Business process Analysis, Reengineering and Logical & Physical database designs.
• Expertise in tuning teh performance of reports using oracle hints,strong SQL and PL/SQL coding background
• Strong background in Data Warehousing, Software Development, Change Management and Scheduling
• Experienced in working with Business Managers, Analysts, End users and all teh stake holders in documenting requirements, creating High and Detail Level design specification
• Expertise in business analysis, data analysis and end user training
• Team-Oriented and focused on delivering user needs in a timely and efficient manner and desire to excel.

TECHNICAL SKILLS

BI Tools: Business Objects XI R2, 3.1, 4.1, Designer, Information Design Tool, Desktop Intelligence, Web intelligence, Rich client, Central Management Console, Central Configuration Manager, Report Conversion Tool, Crystal Reports 10, Xcelsius, EQM, LCM.

ETL Tools: Informatica Power Mart and Power Center 8.5/7.1.

Platforms: Windows, Unix

Databases: Oracle 11g/10g,9i, SQL, PL/SQL coding

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Business Objects Developer

Responsibilities:

• Involved in functional requirements gathering, meeting different Business Groups and preparing teh Technical Specifications.
• Involved in Migrating Business Objects system from version XIR2 to Business Objects XI 3.1, 4.1
• Migrated Users, Universes, Connections, Web Intelligence Reports from teh version XIR2 to XI 3.1, 4.1.
• Involved in Writing Detailed Level Documentation for reports and Universe design.
• Created and maintained universe using Information design tool IDT for business modules and reporting needs.
• Maintenance and enhancement to existing universe and on boarding new tables by creating contexts.
• Created teh reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Master Detail etc.
• Generated reports by using Stored procedures and generated Parameterized, Drill down reports.
• Created report templates, developed Ad-hoc reports, complex reports from multiple data sources, raking reports.
• Created WebI reports with many data providers and synchronized data using teh merge dimensions option.
• Created Web Intelligennce reports and used hyper linking concept to link other WebI documents.
• Scheduling and monitoring of reports for daily and monthly data load process.
• Developed reports using these new functionalities Delegated Search, Smart Measures (Database Delegated), Input Controls, Drop Down filters, Data Tracking and others.
• Generated reports using free-hand SQL as a data provider.
• Responsible for Migrating teh Business Objects Universes/Reports across teh servers / Repositories (Development to Production Servers) using EQM and LCM.
• Applied row level and object level securities to different groups and users using Designer.
• Designed and maintained security objects such as Users, User groups, permission and access rights through Supervisor/CMC.
• Improving performance of reports and queries by using Oracle database hints and restructuring queries.
• Involved in Unit testing, System testing and User Acceptance Testing (of Reports) throughout teh migration process.
• Resolving user queries and data quality issues.
• Responsible for teh quality of delivery and coding standards.

Environment: s: Business Objects XIR3,4.1 Universe designer, Web Intelligence, SQL,PL/SQL, Windows

Confidential, Chicago, IL

Sr. Business Objects Consultant

Responsibilities:

• Involved in teh designing and Building of Universes for new Components.
• Involved in creating Universe, Classes, Measure Objects, Dimension Objects, and Detail Objects and applied Hierarchies based on Business logic.
• Modified teh existing Universes according to teh Specifications, which were from different data sources like Oracle/SQL Server/SAP BW.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc to develop teh reports.
• Created reports using multiple data providers such as Universes and personal data files in generating reports. Created Reports with graphical representation such as Bar charts, Pie charts for multidimensional analysis.
• Validating and Verifying Universes and Reports created by teh Off Shore team and making teh necessary changes if needed.

Environment: s: Business Objects XIR2, Xcelsius 2008, SQL/ PLSQL, Windows.

Confidential

Sr. Business Objects Consultant

Responsibilities:

• Responsible for requirements gathering and writing specifications.
• Involved in designing, developing and testing teh universe for report generation.
• Created and tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, Functions, Formulae etc.
• Created graphical representation of reports such as Bar charts, Pie charts etc as per teh end-user requirements.
• Implemented various functionalities like Ranking, Filters, and Alert’s to restrict teh unwanted data and highlight teh required data.
• Developed and modified various database objects like Views to improve performance of reports.
• Developed PL/SQL stored procedures to process and store teh information in teh oracle database.
• Tested resolved loops and contexts to ensure teh correct results from teh query.
• Deployment of Reports via various methodologies Central Management Console (CMC), Publishing Wizard, Confidential, Import Wizard.
• Involved in Migrating Business Objects system from version 6.5 to Business Objects XI R2.
• Involved in Writing Detailed Level Documentation for reports and Universe design
• Involved in creating user roles, security access, server administration, password management using teh Central Management Console (CMC).
• Responsible for Migrating teh Business Objects Universes/Reports across teh servers / Repositories (Development to Production Servers).
• Attend sprint meeting every fortnight with business to gather teh requirement monitor and plan teh execution of enhancement / Support activities

Environment: s: BO 6.5, XIR2, SQL, Windows.

Confidential

Business Objects Developer

Responsibilities:

• Created Report templates, Summary Reports, Parameterized Reports and Cross-tab reports.
• Used Groups, formulas, running totals and summaries in teh reports.
• Building Relationships between different tables according to requirements in database expert.
• Resolved teh Performance issues/Data issues with Reports and Procedures.
• Worked with different universes and used linking of different universes.
• Implemented different level of hierarchies for drill down reports.
• Analyzed Data using Slice and Dice and Drill Mode etc and formatting Reports.
• Automated document Scheduling, Publishing and Distribution for Web me and Info view clients, using teh Broadcast Agent.
• Created Master/Detail Reports, Cross-tabs, Matrix and Charts etc.
• Used various Functions like @Prompt, @Where, and @Select.
• Created customized existing reports using cross-tab reports, sub-reports and charts to present information
• Exported Reports into PDF and Excel from Enterprise and resolved formatting issues.

Environment: s: BO XIR2, Crystal Reports 10, SQL, PL/SQL, Windows and Solaris.

Confidential

SQL, Reports Developer

Responsibilities:

• Created Business requirements documents for teh modifications required for teh reports and Universe, which included testing strategy, Business Objects fix and Business requirements etc.
• Generated Deski reports.
• Prepared program documentation.
• Training users for ad hoc reporting.
• Performed unit and integration testing of reports.

Environment: s: BO 6.5, Crystal Reports, SQL, Window