SUMMARY:

• Around 7 years of experience. Business Intelligence experience with a skill set of Business Objects XI 4/R3.1/R2/6.5, Designer, Desktop Intelligence, Web Intelligence Rich Client, Dashboard Manager, Central Management Console, Crystal Reports, Crystal Xcelsius, Query as Web Service, Live Office, good understanding of Data warehousing Concepts.
• Experience in creating visualizations/Dashboards for managers using Xcelsius.
• Experience in creating universe from SAP and Non SAP sources, Store Procedures, Cubes, XML. Extensively worked on Reporting, Admin and Designing module
• Created BO reports using SAP BI, enhancements of universe. Creation of universe from BEX query. Integration of Business Objects with SAP ECC system (SAP BO).
• Involved in ETL process which loads the information of Business customers into the database after extracting, cleansing and aggregating.
• Expert in working with Business Objects Performance Management to create
• Dashboards, Scorecards and Analytics. Experience with Data Warehouse Concepts, Methodologies and SDLC.
• Knowledge in configuring LDAP and SSO based on Site minder, Implemented Enterprise wide Back up Strategies.
• Migrated XI R2 Business Objects Enterprise system to XI R3 using Import Wizard.
• Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness using Business Objects Designer.
• Experience in Installing and Configuring Business Objects XIR2/3.1 on Dev, Prod and Test servers.
• Worked with CMC creating user/groups, apply restriction define access and apply securities.
• Hands on with Business Objects Explorer and Info burst, new features of SAP Business Objects 4 and
• BIOD (Business Intelligence on Demand).
• Diversified experience in implementation of Business Objects in Financial sectors.
• Full life cycle development experience including analysis, design, development, support & maintenance for BI applications along with good skills in installation, troubleshooting, performance tuning and optimization of business objects.
• Involved in ETL process using Data stage 8.0, Data Services XI. Experience in Oracle Database administration (Oracle10g DBA) on Linux and Windows platform. Exposure to SQL*Loader, TOAD, Linux, SQL*PLUS. Exposure with SAP ABAP ECC
• 6.0.
• Experience in developing web based applications using ASP.Net with C# using SQL Server 2005/2008
• Strong skills in Oracle 9i/10g, Teradata, MS SQL Server 2000/2005, SQL, PL/SQL.
• Hands on Working knowledge in Oracle and PL/SQL Writing Stored Procedures, Packages, Functions and Triggers.
• Experience in interaction with the Business Analysts, identifying the needs & the requirements of the system and involving in requirement study of the system.

TECHNICAL SKILLS:

Desktop Intelligence: Data Modeling

Database: Oracle 9.x/10.x SQL Server 05/08 Teradata

ETL: IBM Data Stage 8.0 Data Services XI

Systems: Windows 7/2003/XP Linux

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, TN

Business Objects Architect (Project/Technical Lead)

Responsibilities:

• Provide technical support to resolve Production issues involving Web Intelligence Reports.
• Interaction with the Business Analysts, users and business leads to understand Business needs.
• Constant Interaction with users in going over the use cases for new Business needs and validation of the existing implementations.
• Creation and testing of complex reports and documentation of test cases and report specifications.
• Drill down the Analytics to the detail level data by a Web Intelligence Report.
• Involved in the extensive standards & guidelines documentation.
• Created Derived tables in the Designer to enhance performance of the universe.
• Created Aliases and Context to resolve loops, defined the cardinalities as defined in data model.
• Worked extensively with @functions (@select, @prompt, @where) to overcome the problems with database when integrating with business objects.
• Set up Aggregate Awareness to enhance the performance of SQL transactions.
• Updated Universes based on changing user requirements and data source changes.
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts.
• Resolved issues related to RDBMS flaws such as Fan Trap, Chasm Trap using BO multi parse SQL functionality.
• Created WEBI Reports with multiple variables at report level to get %, Average, variance etc values.
• Created Hierarchies according to the business rules for viewing data at selected level of detail.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Extensively worked with alerts, filters and conditions in Business Objects.
• Created templates to generate different styles of reports, which are not, belong to Business Objects standard documents.
• Tuned the reports for better performance using SQL.
• Created various 3D pie charts, Pie charts, Bar Charts, Line Charts.
• Regressional Testing of the reports in Dev and Test environment and Scheduling of reports in info view.
• Check the integrity of the Universes and export the universes to Repository for making available to users.
• Involved in Moving Universes and report from Dev to UAT and UAT to Pre - Prod using Import Wizard.
• Regularly took back of reports and Universe using Import Wizard and creating BIAR files.
• Interacted with Business Objects technical team to get the resolution of problems / bugs in Business Objects.
• Production support for Web Intelligence reports and Business Objects Universes.
• Validated the data and the joins in the Universe by running BO reports and exporting the output to the Excel Spreadsheets and again testing it against the data that was fetched from backend tables using TOAD/ PL SQL Developer/ Teradata Client.

Environment: Business Objects 4/XIR 3.1, Crystal Reports 2008, Teradata, Oracle 10g.

Confidential, Chicago, IL

Business Objects Admin/Developer

Responsibilities:

• Created detailed Webi reports and linked them to open in Xcelsius with the help of OPENDOC.
• Created BO Project Margin reports.
• Developed the universe and deployed it on BIOD.
• Used context operators like In, For Each, For All in Webi reports in order to meet the business requirements.
• Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap using Multi Parse SQL
• Analyzed data using Slice/Dice and Drill Mode. Created Web Intelligence reports Ad-hoc and canned reports.
• Tested the Web Intelligence reports in System Integration and Testing environment and Testing (Staging) environment to validate performance testing of all the reports, which helped in analyzing its performance before moving into production environment. Created report designing documents for further .
• Redesigned the data by using various V-lookup and H-lookup functions for finance dashboard reducing from
• 60 to 15 components. Scheduled the Web intelligence reports and published them on weekly basis.
• Tuning the queries to improve the performance of the report refresh time.
• Extensively created and used Alerter, rankings, sorts, and drill-down (using custom hierarchies) in reports, contingencies for multiple teams to meet project needs and requirement changes.
• Created a large number of Web Intelligence reports. Queries with constant interaction with the end users.
• As a part of report development, created the reports using universe as a main data provider and using the Powerful business objects functionalities, and formulae. Involved in trouble shooting of various reporting errors.
• Installed & configuredSAP IntegrationKitwith Business objects, integratedcrystal with SAP BWand build reportsbased fromBW Cubes, Info sets, R/3 tables.

Environment: SAP BI, Business Objects XI R2,Apache Tomcat, SQL Server, Windows 2003 Server.

Confidential, Columbia, SC

Business Objects Developer

Responsibilities:

• Worked with the assigned SCITS Business Analyst to gather, analyze, and understand the business user requirements for SCITS reports.
• Worked with the assigned SCITS Data Analyst to develop Business Objects universes based on the SCITS data model and SCITS reporting requirements.
• Created Sales, Withholding and Liability monthly reports for the counties.
• Created complex Universe and reports for General Ledger and Accounts.
• Utilized Business Objects Web Intelligence, Desk Intelligence, and Xcelsius tools to develop, test, and deploy reports, templates, and dashboards to meet SCITS business requirements.
• Worked with DOR technical support staff to publish reports to Share Point or to Business Objects production site as appropriate.
• Resolved production issues reported by business users with any of the deliverables produced.
• Provided liaison to DOR Database Administrators, and Operations & Support section as needed for support of reports development and deployment, including analysis and resolution of technical issues.
• Report on weekly basis to Business Objects Project Manager and SCITS Project Manager.
• Deployed Business Objects XI R3 on Windows 2003 server using Apache / Tomcat.
• Migrated reports from XI R2 to XI R3.1, used migration wizard to migrate repository and its components
• (Universes, documents, users, privileges), reported migration wizard bugs related to report formatting.
• Analyzed the reporting requirements with the business users and come up with the technical specifications.
• As a part of Universe designer team, created Semantic Layer, resolved loops, chasm and fan traps using contexts, aliases and integrity checks.
• Created Classes and Objects taking the information from the database. Also created measured objects.
• Checked the Cardinalities, Contexts, Joins and Aliases for resolving Loops.
• Developed universe in Business Objects XIR3.1.
• Scheduled reports through CMC and Info view.
• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report.
• Interacted with the users to analyze the changes for improvement they need in existing reports and develop the reports to satisfy their needs and requirements.
• Created alerts, breaks, filters and ranks in the report.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, @FunctionsCross Tab, Master Detail and Formulae’s etc.
• Created WEBI Reports with multiple variables at report level to get %, Average, Boolean etc values.
• Closely work with Database Administrators to validate month end data process for reporting needs.

Environment: SAP Business Objects XIR 3.1, Xcelsius 2008, Windows XP, SQL Server 2005/2008, Apache Tomcat web server.

Confidential, Waltham, MA

Business Objects Admin/Developer

Responsibilities:

• Gathered Business Requirements from the end users and clients.
• Developed the universe and deployed it on BIOD.
• Involved in designing Universe and migrating existing Deski to Webi.
• Responsible for supporting issues with reports.
• Managed Servers using CCM.
• Installed and Configured Business Objects XI R 3.1 on Dev, Test servers.
• Validate the raw data in SQL 2005 Management Studio
• As an iterative process updated the modifications suggested by the Client.
• Resolved the testing issues related to the Dimensions, Contexts and Joins in the Apex Universe.
• Fine-tuned the universe objects in order to improvise the Query Performance.
• Extensively worked on creating contexts for the Universe based upon the Business Flow
• Updated the Joins and applied shortcut Joins where ever necessary.
• Involved in ETL process which loads the information of Business customers.
• Run queries in Database as well in BIOD to match up the result set
• Created Filters to drag in the reports as per user requirement.
• Created the measure objects as per the reports requirement.

Environment: Business Objects XIR 3.1, Data Services XI 3.0, Windows XP, SQL Server 2005/2008, Apache

Confidential

Business Objects Developer

Responsibilities:

• Created Different Universes for separate reporting requirements .
• Created Full Client reports using different Data providers like Excel sheets, SQL server, Oracle.
• Extensive use of slice and dice for generating master/detail and tabular reports.
• Created User Prompts, Conditions and Filters to implement the reporting requirements.
• Involved in writing SQL queries and stored procedures by using Cursors, indexes in stored procedures.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Documented and maintained database system specifications, diagrams, and connectivity charts
• Checked the coding standards followed by peers of the team
• Designed, tested DTS packages required for data transfer from consolidated files to database tables
• Performed Database Normalization
• Creation, manipulation and supporting the SQL Server Database
• Designed and optimized indexes, views, stored procedures and functions using T-SQL
• Designed the Logical Model & Physical Model and Generated Physical Model by gathering requirements from the end users.
• Extensively worked on Oracle Packages, Procedures, Triggers to create interfaces

Environment: Business Objects 6.5/R2, SQL Server 2005,2008, Oracle 10g.

Confidential

Programmer/Database Administrator

Responsibilities:

• Installing, configuring and upgrading of Oracle server software and related products
• Design Physical and Logical structure of the Database. Managing Production, Development Database.
• Checking Alert logs to find out Bottlenecks if any and fixing them.
• Managing Physical structure of Oracle database like Data files, Redo log file and Control files
• Planning and Performing Daily, Weekly and monthly Cold and Hot Backups.
• Testing and Implementing Restore procedures for Complete and Incomplete Recovery.
• Wrote RMAN scripts for backups. Administrating all Database objects like Tables, Indexes
• Under took the reorganization of tables. Monitoring Rollback Segments and taking proper actions.
• Monitoring the growth of Table space and taking proper actions.
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Moving Data between Database using utilities like Export/Import, Sql * Loader and Transport Table spaces.
• Evaluate the performance of SQL statement and PL/SQL blocks using utilities like SQL Trace, TKPROF, Auto trace and Explain Plan.
• Monitoring and Optimizing the performance of the database and offering assistance to developers in optimizing their applications and queries.

Environment: Java, Oracle 9i, Linux, Apache Tomcat, Dreamweaver.