PROFESSIONAL SUMMARY:

• Over 8+ years of experience in Information Technology including expertise in Creating Complex Reports using Business Objects and Crystal Reports.
• Strong experience in Business Intelligence (BI) using Business Objects 4.X/XI 3.1/XI 3.0/XI R 2/6.5.1/5.1.5 (Universe Designer, CMC, Web Intelligence, Report Bursting, Import Wizard, Reporter modules, Info view), Xcelsius 200X, Crystal Reports 200X/XI, OBIEE and experience in Informatica Power Center 9.X/ 8.6/8.5/8.1/7.1/6.2.
• Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Involved in various stages of project life cycle such as Design, Development, Implementation, Testing and Maintenance.
• Expertise in creating and linking complex universes using Joins, conditions, Filters, LOV, cardinality, Aliases, Contexts, Index Awareness, @Prompts, @Aggregate Awareness
• Excellent Business Analysis skills: ability to transform business users input to software requirements and specifications.
• Gathering requirements from Business Users and analyzing the data to create functional specs as per the requirements and implementing the BI project.
• Expertise in pulling the business requirement and building Universes using Designer, retrieving data using Universes, Personal data files(MS - Excel), Stored procedures, Free hand SQL methods and creating complex ad-hoc Reports using data access and developing reports using Web Intelligence modules.
• Expertise in developing dashboards using Xcelsius from Live Office. Used Query as a Web Service.
• Tuned SQL, PL/SQL, analyzed tables and used TOAD.
• Strong background in Data warehouse concepts - ETL, Data modeling, and Reporting
• Knowledge on Migration from one version to another.
• Experience in creating reports and accessing queries using Business Objects Query Builder, Web application Designer.
• Experienced in conducting design sessions to evolve System Specifications and Test Plans with the ability to handle training sessions and documentation.
• Strong knowledge of Data Warehouse techniques and practices, including dimensional data modeling, OLAP, implementing Relational Database (OLTP) and Database performance tuning.
• Experience in Creating, Testing and Executing Data Integrator jobs using Data Integrator Designer to transfer data from source to target.
• Extensive database experience using Oracle (10g, 9i & 8.x), MS SQL Server 2000/2005/2008, DB2, Terra Data, MySQL and MS Access.
• Experience in Business Objects Administration and building universes, Retrieving Data using Universes, Personal data files (MS-Excel), stored procedures and free hand SQL methods.
• Experience in creating Regulatory, Customized, Ad hoc and canned reports using Business Objects.
• Excellent understanding of Dimensional Data modeling- Star Schema modeling, and Snowflake modeling.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS:

Business Intelligence Tool: Business Objects 4.0, 3.1, XI-R2/6.x/5.x, Crystal Reports, Xcelsius Dashboard, Oracle Discoverer, OBIEE, Explorer

Databases: Oracle 8i/9i/10g/11i, SQL Server 2005/2008, Teradata, DB2

ETL: Informatica Power centre 9.x/7.x/6.x, SAP Data Integrator/ Data Services, 4.0,XI3.0, 3.1, 3.2

Languages: SQL, PL/SQL, HTML, XML, Unix

Data Modeling: ERWIN 7.0/4.0

Operating Systems: Windows 7/NT/XP/2000/95/98, UNIX, MS-DOS and Linux

Middleware: Web logic 10.1, 10.3g

PROFESSIONAL EXPERIENCE:

Confidential, DC

Sr. Business Objects Developer

Responsibilities:

• Gathered and captured all existing Customization/enhancements in available BO system. Involved in Preparation of BRD and GAP analysis in order to include each and every enhancement during Upgrade. Understand the business data flow, worked with Business Analyst in Preparing TDS(Technical Design Specifications)
• Gathering and Analyzed the reporting requirements with the business users/architects and come up with the technical Specifications for universe and BO reports.
• Resolved universe problems such as loops, charm and fan traps using aliases and contexts by testing the overall integrity of the structure using check integrity.
• Implementing Object-level and Row-level security using Manage Restriction on the developed universe restricting the end-users in accessing certain objects.
• Designed and develop of various reports using BI4.0. Designing the Universes in Information Design Tool (IDT), Classes and Objects are created in Business Layer (blx), Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and Checked the Integrity of the Universes in the Data Foundation Layer (dfx).
• Tracked defects through ALM (Application lifecycle Management)and interacted with testing team on the defects raised by them.
• Extensively worked on ETL, created Informatica workflows and sessions to write the data into the Staging tables.
• Created Crystal Reports in version Crystal Enterprise Version 8.5.
• Created Custom Hierarchies for using scope of Analysis and Drill Down options.
• Improved the performance of the reports by removing any additional filters or alerts on the report. Turned the formula into a variable if it has any multiple uses.
• Created Aggregate tables and Aggregate awareness implementation and Aggregate Objects Creation and using in the reporting.
• Used functionalities such as sub-reports, cross-tab reports with Drill down feature of WebI reports to generate inventory, account receivable & payables, cycle and monthly reconciliation reports for billing purposes.
• Publish, distribute and schedule Web Intelligence reports using Info view.
• Worked with Users to troubleshooting issues during UAT and Production support.
• Migrated Universes, Reports, and Securities from Development to Testing environment after System Integration Testing (SIT) and then followed by Business Acceptance Testing (BAT).
• Created Data mapping document for the project.
• Used ETL tool Informatica when needed for loading data into another Database DB2.
• Used Import Wizard, Life Cycle Manager and Promotion Management in BI4.0 for the Migration process across the environments.
• Created reports using free-hand SQL, PL/SQL, and Universe.
• Provided end user training for basic and advanced reporting skills on how to use templates to create their own reports and explained the hierarchy levels and incompatibility between the objects to make sure users take advantage of the existing universes.

Environment: Business Objects 4.0/XI 3.1, Central Management Console, Launchpad, Webi Rich Client, Information Design Tool, Launch Pad, Web Intelligence, Import Wizard, Crystal reports 2008, Xcelsius 2008, Dashboard 4.0, SAP BW BEx, QAAWS, Live Office, OBIEE, Oracle 11g, Toad, Microsoft Excel, Windows XP.

Confidential, Wilmington, DE

Sr. Business Objects Developer

Responsibilities:

• Involved in Full life cycle design and development of Business Objects Enterprise Applications.
• Involved in gathering the requirements from Business Managers for reports development
• Designed specification documentation and get the approval from Business Managers about the reports layout.
• Designed and developed Business Objects reports as per the Business requirements.
• Currently upgrading to Business Objects 4.0. Involved in installing and configuring Development/Test.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections in Information Design tool.
• Developed reports according to the report design specifications using Launch Pad.
• Managed Users, Groups and their access privileges on the documents.
• Created Classes and Objects (Measure, dimension and detail) in the universe.
• Used Designer Module to implement Universes, Joins between Tables, and created prompts and queries, parsing of Universes, and created Contexts and Alias Tables to remove cyclic dependencies.
• Resolved Chasm traps, Fan traps and Loop problems.
• Designed and Maintained Universes and exported them to the repository.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• Created reports using standard company templates. A few of them were created based on the Department requirements.
• Formatted reports as per the user’s requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Gathered report requirements from business end users/clients and assisted business partners in retrieving business information from data warehouse and resolved any SQL query issues.
• Created user Prompts, conditions and Filters to improve the report generation in Web Intelligence. Also used Alerts to improve the readability of the report.
• Built reports using multiple data providers, external data providers and used merge dimension functionality.
• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, and Drill filters.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Provided extensive support for the users on application usage and trained users in the functionality of the software.
• Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis.
• Tuning SQL query performance, working with data warehouses, managing metadata, and developing Web services using DB2.­­­­­
• Involved in reviewing and analyzing 2/3 level support issues.
• Coordination and work along with the ETL team to ensure the timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs to them.
• Worked with the ETL team in populating the necessary tables and data for the development of universe.
• Involved in creating single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008. Used QAAWS and Live office functionalities of BO to pull Data from SAP Universes.
• Developed the dynamic and customized prompts based on the hierarchy level information for predictive analysis of the reports.
• Identified the Metrics and sub metrics, Key performance indicators (KPI’s) for Dashboard development.
• Involved in creating graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, and Bubble chart using Xcelsius 2008.
• Exported the reports and dashboards into centralized database to access them for daily business analysis.
• Created Dashboards to monitor business performance, insightful analytics, and role based dashboards with dashboard manager.

Environment: Business Objects XI 3.1, Business Objects XI 4.0, Central Management Console, Infoview, Webi Rich Client, Information Design Tool, Launch Pad, Web Intelligence, Import Wizard, Crystal reports 2008, Xcelsius 2008, Dashboard 4.0, SAP BW BEx, QAAWS, Live Office, Oracle 10g, Microsoft Excel, Windows XP.

Confidential, MA

Business Objects Developer

Responsibilities:

• Involved in Full life cycle of migration process from legacy BO 5.1.7 to BO XI 3.1.
• Migrated SCMDW universes, reports and users from BO 5.1.7 to BOXI3.1 using Import wizard and converted them in BO XI3.1 WEBI Reports by using Report Conversion tool.
• Converted reporting environment from oracle to Teradata. This included migrating existing universes and reports.
• Created Standard technical documents for validation process for universes and reports in BO XI
• Develop a strong working relationship with the appropriate business users to understand the key business drivers and priorities.
• Worked with Business Object vendor to improve the application performance by using advance functionality of new BO XIR3.1.
• Develop detailed functional specifications and requirements for new reports
• Created free hand SQL reports into new WEBI reports in BO XIR3.1.
• Responsible for the performance tuning of SQL queries on Oracle database by using features like creating the materialized views and function based indexes depending on the reporting requirements.
• Created new users, groups, folders in CMC while upgrading to BO XIR3.1.
• Created user Prompts, Conditions and Filters to customize the report generation in BOXI R3.
• Involved in creation of BOXI R2 Desktop Intelligence and Web Intelligence Reports with different functionalities like Filters, Sorts, and Breaks. Merging common dimensions drill down and drill up.
• Used Publishing wizard to export different document types as objects to different folders in CMC.
• Involved in Migration of Repositories from Development, Test and Production environment using Import wizard.
• Worked with Users to troubleshooting issues during UAT and Production support.
• Provided training for end users for generating their own report including complicated reports.

Environment: Business Objects XI 3.1, WebI, Crystal Reports XIR2, Xcelsius, Designer, Desktop Intelligence, CMS, InfoView, SQL 2008, Windows XP, Oracle 10g/9i,Project Management.

Confidential, PA

Business Objects Developer

Responsibilities:

• Gathered requirements from the business users.
• Involved with Development team for Migration of SAP Business Objects from XIR2 to XIR3 version and also involved in CMC to provide the User Security settings and Creating User groups in Rich Client 3.1.
• Provided Business Objects Universe design changes to address performance, usability and data reliability issues.
• Used QAaWS (Query as a Web Service) and live office to feed data into Xcelsius.
• Unit tested Web Intelligence reports before pushing them to complete testing phase and wrote complete report specs.
• Extensively worked with Clarity to generate and test the reports.
• Created standard reports, sub reports and drill down reports using Crystal Report XI R2.
• Extensively involved in using of formula fields, parameter fields, Running Totals, Sorts, Group selection and Record selection in Crystal Reports XI R2.
• Modification of the WebI reports and universes and creation of new reports.
• Created business views for the dynamic parameters using the Clarity Universe.
• Created number of complex formula in sub report using different type of variables likes shared variable and retrieved them from master report.
• Analyzed and manipulated the data using spreadsheets, pivot tables, MS Access.
• Developed SQL queries in SQL command and stored procedure to reduce crystal report processing time and efficient performance.
• Customized data by adding Filters Calculations, Prompts, Summaries and Functions.
• Developed various Charts and Graphs like bar charts, line charts, pie charts etc by using Chart Experts.
• Defined row level and column level data security in crystal reports.
• Defined project view rights to maintain the data security in crystal reports.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
• Added/modified Users, Groups, folders and rights using Central Management Console (CMC
• Involved in the design and implementation of Business Object Universe for the reports.
• Created, maintained and supported Web Intelligence reports in Business Objects.
• Designed ETL architecture to move data from various data sources into Data Warehouse.
• Converted and migrated SSRS reports into Crystal Reports XI and performed Unit testing.
• Modified existing reports according to requirements of the end users.
• Managed all indexing, debugging, optimization and performance tuning.
• Created Tables, Views, SQL Joins and other Confidential -SQL and PL/SQL code to implement business rules.
• Created reports in Crystal Reports 2008 for testing purpose.

Environment: Business Objects XI 3.0/XI R2, Info view, Desktop Intelligence, Web Intelligence, Crystal Reports XI R2, Oracle 9i, Teradata, PL/SQL, UNIX,, Xcelsius, Qaaws, Live office

Confidential, Atlanta, GA

Business Objects Developer

Responsibilities:

• Interacting with Business Users to understand and document the requirements and translate these to Technical Specifications for Universes and Business Object Reports.
• Managed Users/User Groups and Implements security in CMC.
• Used report conversion tool to convert DESKI to WEBI.
• Used Import Wizard to migrate reports and universes from 6.5 to XI environments
• Involved in data validation and advanced SQL Query writing skills.
• Team lead for crystal development with responsibilities to set up the Crystal Server, Info view, reporting structure, role and rights.
• Developed new reports using Crystal Reports XI and Oracle 10g as database.
• Designed, Created and Maintained Universe as per business requirements.
• Resolve the join problems such as loops, chasm trap and fan trap.
• As a part of universe development, created Classes, different kind of objects, Cardinalities.
• Resolving the Loops, Fan Traps, Chasm Traps by creating table Aliases and Contexts.
• Extensively used Aggregate awareness Functionality while creating Universes to choose appropriate aggregate table based on hierarchy.
• Exported Universes to repository for making it available to users.
• Involved in Unit testing, System testing and User acceptance testing.
• Formulae, Variables, Cascading prompts and Alerters are used to create reports.
• Extensive experience in creating reports with Charts (bar chart, Pie chart…etc), Cross-tabs and linking reports using OpenDocument.
• Developed Cross Tab Reports, Sub Reports by using Crystal Reports version XI.

Environment: Business Objects XI R2, Infoview, Desktop Intelligence, Web Intelligence, Oracle 9i, PL/SQL, Toad, SQL Server, Erwin 4.0 and UNIX, Performance Management

Confidential, CA

Business Object Developer

Responsibilities:

• Analyzed the warehouse Tables to design Universes by creating Classes and Objects.
• Designing the Universe, created Contexts and Aliases for resolving Loops in the Universes.
• Created Objects using different Business Objects functionalities like @ prompt, @variable, @select in the process of designing the universes.
• Linked the Universes to share the common objects between them.
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Updated and maintained Universes based on changing user requirements and data source changes.
• Conducted Performance tuning of Universes for time management purpose by creating alternate views and indexes.
• Created Complex Reports using Reporter module in Desktop/Web Intelligence functionalities like Slice and Dice, Drill Down, @Functions, Cross Tabs, Master/Detail, and Formulae.
• Created Alerts in various reports according to user requirement.
• Created templates for standardizing the structure of corporate documents and dashboards using DashBoard Manager.
• Worked on major functionalities like Breaks, Filters, Sorts, Query prompt and Drill filters.
• Developed data Mappings between multiple source systems and warehouse components

Environment: Business Objects XI, Web Intelligence, Info View, Oracle 8i, Windows 2000, UNIX.