SUMMARY

• 6 years of experience in Analysis, Design, Development, Unit testing and Implementation on BI platform using Business Objects reporting tool.
• Extensive experience in Business Objects XI R2, 3.1 comprising of Designer, Web Intelligence, Infoview, Central Management Console and Import Wizard.
• Worked on Crystal Reports for developing reports.
• Experience on Xcelsius to develop dashboards.
• Experience on Business Objects integration with web services using the JAVA SDK.
• Excellent experience with Data Warehouse Concepts such as Star schema, Snowflake Schema, Fact and dimensional tables.
• Worked on migration of the Business Objects XI R2 to XI R3.1.
• Experience in improving performance of Business Objects reports.
• Thorough and complete understanding of installing and configuring SAP Integration Kit and also creating reports on SAP BW Queries BEX Queries using Business Objects XI 3.1.
• Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.
• Very strong communication and interpersonal skills. Experience in training users to create Ad-hoc reports using Business Objects Infoview.

TECHNICAL SKILLS:

• Business Intelligence Tools: Business Objects XI R1/R2, 3.1 , Crystal Reports 2008, Xcelsius 4.5/2008, SAP Integration Kit.
• ETL Tools: Informatica 8.x
• Data Modeling Tools: Erwin, VISIO
• Databases: Oracle 9i/10g/11g, Teradata V12, SQL server 2000/2005, DB2.
• GUI Tools: SQL PLUS, TOAD.
• Web Application Servers: WebLogic 7.0, Apache Tomcat.
• Operating Systems: Windows XP/7, UNIX.

PROFESSIONAL WORK EXPERIENCE:

Role: ETL/Business Objects Developer

Description: The Project is about maintaining the suspicious accounts, transactions to track them from multiple vendors. Maintained a data mart capturing the data related to suspicious activities, generated the reports to users and provided the Ad hoc extract as and when required by users.

Responsibilities:

• Strong experience in Universe development using Designer.
• Worked with users and business analysts to understand the reporting requirements.
• Worked on different data marts to meet reporting requirements.
• Experience using Derived tables, Aggregate awareness, Index awareness, Hierarchies, resolving loops and row level security in Designer.
• Created many standard and ad-hoc reports using Web Intelligence.
• Used all the functionalities to create reports like prompts, combining queries, filters, drill down, functions and formulae, different types of charts.
• Performed unit testing on reports by validating SQL using database.
• Created different folders and user roles for maintaining security.
• Worked on complete lifecycle management from analysis to implementation and used Import Wizard for migrations.
• Worked on Oracle and Teradata databases sources to create Web Intelligence reports.
• Worked with Business analyst and product managers to identify the business rules for data migration, parsing design specifications to ETL coding following mapping standards.
• Worked with high volume data, tuning, trouble shooting of mappings and created documentation to support the application.
• Extensively used push down optimization technique in Informatica to achieve high performance processes.
• Experienced in deploying the control M jobs to automate the daily, monthly jobs.

Environment: Business Objects XI 3.1 Universe Designer, Web Intelligence Rich Client, Infoview, Informatica Power Center 9, Oracle10g and Teradata V12.

Confidential

Role: Business Objects Developer

Description: JP Morgan Chase in Delaware offers Credit Card Services. There are different projects belonging to CDW Cards Data Warehouse . PRE promotional rewards engine is the project that deals with rewards for different accounts. CPLAN Marketing project as part of PRE has all offers belonging to cards. Worked on FDIC project which has FICO scores for accounts.

Responsibilities:

• Experience on understanding the reporting requirements and involved in requirement gathering sessions with Business Analysts.
• Strong understanding on Data Models for PRE, CPLAN and FDIC projects.
• Experience on documenting functional specifications, design and technical response documents.
• Experience on creating LDAP groups for each user role for each application to access reports in Infoview. Depending on Interactive, Ad-hoc and power roles are created in EURC Portal in Chase to request access .
• Experience on creating Folders and setting up securities for LDAP groups in CMC.
• Worked with Administrators to get the reports migrated from one environment to other. For this we followed ITSM Change Management tool where we need to get approvals from different groups .
• Created new universes for each application using Designer.
• Experience on resolving loops using contexts.
• Created Canned and Ad-hoc reports. Experience on scheduling reports event based and publication reports.
• Created many complex reports with more than 100 fields in a single report. Experience on all reporting techniques using different formulas and functions.
• Worked on Open Document functionality to navigate from one report to another.
• Experience on creating variables using ForEach/ForAll functions.
• Experience on giving training to new users on Infoview and walk through of reports and documented how to access BO reports and detailed explanation of how to work with Infoview.
• Used Teradata SQL Assistant 12.0 and Oracle 10g for different projects.

Environment: Business Objects XI 3.1 SP4, Universe Designer, Web Intelligence Rich Client, Infoview, Teradata V12, Oracle 10g.

Confidential

Role: Business Objects Developer

Description: Well Point Inc is a Health Insurance firm which is collaborated with Anthem Inc. This project PROVIDER TRANSPARENCY deals with the rewards summary for the Individual or group providers within the state and across different states for different programs. Reports are created on the Rewards and also on the survey information which is submitted by a provider. Claim line detail reports are also built in this project. Additionally, reports are built on the classification of generic and branded drugs along with the prescriber's information.

Responsibilities:

• Very strong understanding on Rewards and Recognitions Datamart and the business followed by the client.
• Involved in business analysis sessions with users, to build new reports as per the requirements.
• Prepared technical response and detailed design documents for the requirements.
• Created POC which helped for clear understanding when Business Objects is integrated with JAVA Report Engine SDK using Web Services.
• Developed Universes in the Designer using Business Objects XI 3.1 with complex joins.
• Created Hierarchies and conditions on date ranges in the Universe.
• Resolved loops using aliases as well as contexts.
• Created many reports on rewards and programs for different providers using Infoview.
• Different graphical components were used in the reports like PIE charts for data analysis.
• Complex reports were built with many data providers including the Open Document functionality. Used all the functionalities in the Infoview for report creation.
• Integrated the Business objects reports with the portal named POIT using the JAVA SDK via the Web services. Based on the TaxId's the security was set up, so that the provider could only view his information.
• Worked on Crystal reports XI R2 to create reports.
• Used Teradata SQL Assistant 12.0 for analyzing complex queries for reporting needs.

Environment: Business Objects XI 3.1 SP2, Universe Designer, Web Intelligence rich client, Infoview, Crystal Reports 2008, Oracle 10g, Teradata V12, Sybase Power Designer 15.2, IBM Rational Software Architect for WebSphere Software 7.5.0, Report Engine SDK API guide.

Confidential

Role: Business Objects Developer

Description: St. Jude Medicals is a manufacturing company that produces implanting devices for heart abnormalities. There are selling divisions across many sales divisions again classified into divisional, area and regional basis. It deals with sales in US division. This project, PULSE is for creating reports on sales made across different divisions, areas and regions that are distributed accordingly. Other applications are building reports on implants made, commissions paid to sales reps and Pricing. These reports would primarily help the client to have an analysis of sales made in different hospitals.

Responsibilities:

• Designed universes by defining joins, cardinality between tables, linked the existing universes in Business Objects XI 3.1.
• Developed complex universes for Ad-hoc and standard reports using Business Objects XI 3.1 SP2 using features like aggregate awareness, prompts, index awareness and hierarchies.
• Undergone all the implementations that are used for developing universes using designer.
• Built various reports on sales and implants made across different divisions, areas and regions according to various product categories using Infoview.
• Created mock-ups for many Ad-hoc reports to meet the actual requirements and also scheduled standard reports on daily basis.
• Used functionality's like functions, Variables, user response and formulae.
• Experience on using drill down, adding queries and also combining queries.
• Built various standard reports using graphical components like bar charts, line charts and pie charts to resemble a dashboard.
• Also built many complex reports using hyperlinks using Open Document Functionality to connect different reports.
• Used Oracle 10g as a data source to build universes and reports.

Environment: Business Objects XI 3.1 SP2, Universe Designer, Web Intelligence, Infoview, Oracle 10g.

Confidential

Role: Business Objects Developer

Description: Satyam Computer's is one the leading IT firms that served many clients across the globe.

Responsibilities:

• Built universe on the designed schemas, well tested and exported them to repository using Business Objects Designer.
• Developed universes by using features like aggregate awareness, index awareness, conditions and hierarchies.
• Used row level security to secure the data, based on user access.
• Created various reports like master/detail reports, cross tab reports, and drill down reports.
• Experience in creating reports using prompts, filters, variables and hyperlinking using open document functionality.
• Worked on report performance issues.

Environment: Business Objects XI R2, Universe Designer, Web Intelligence rich client, Infoview, Oracle 10g, SQL Server 2005.