Work Experience Summary

Around 9 years of total IT experience in developing software and working with SAP Business Objects suite of products like Designing BOBJ Architecture, Business Objects Reporting -Desktop Intelligence, Web Intelligence, Crystal Reports, Universe Design, Xcelsius Dashboard for major clients.

Worked on different versions of SAP Business Objects- BO4.0, BOXI3.1, BOXI3.0, BOXIR2, BO6x, and have successfully Installed/Deployed Configured BOXI Systems.

Knowledge in all phases of Software Development Life Cycle SDLC such as developing, testing, Migrating, Administrating, security management and production supporting.

Extensively worked on BO XI Architecture, BO6.5 Architecture, CMC, Import wizard and Report Conversion tool. Migration from one version to another. Creating Users, Groups, and Setting up of Security Profiles for Users and scheduling the reports using CMC.

Expertise in using Business Objects reporting functionalities such as Slice and Dice, Filters, Sections and Breaks, Drill-down option. Extensive knowledge in Creating Publications with Dynamic Prompts.

Experience in designing Universes. Experience in migrating Universes, Reports, Users, User Groups, Access Levels, and Profiles etc successfully using Import Wizard.

Proficient in developing Crystal Reports using versions CR10, CRXIR2 and CR 2008 for creating complicated reports including sub-reports, parameter based reports, formula based, well-formatted reports, drilling reports, Grouping, Running Totals and Summary reports using Static, Dynamic Cascading Prompts and Live office.

Experience in documenting Functional, Technical Specifications and Test Cases.

Creating complex reports by linking data from multiple data providers, using free hand SQL.

Experience in using databases like Oracle, Teradata, SQL Server, MS Access etc.

Skilled SQL Tools for performance maintenance of Reports.

Knowledge in building, extraction, transformation and loading ETL . Involved in Extraction, Transformation Loading of data from multiple sources into Data Warehouse using ETL tool such as Informatica, Pervasive Data Integrator very similar to Informatica .

Excellent team player at all levels with ability to perform independently with exceptional communication, analytical, presentation and problem solving skills. And providing training.

Exposed to Data Warehouse assignments in various domains like Sales, Insurance, Financial and Bank, Oil and Natural Gas, Healthcare and Production Data warehouses.

An enthusiastic and project-oriented team player with excellent communication skills.

Technical Skills

BI Tools: Business Objects 4.0/ XI3.1/XIR2/XIR1/6.X/5.X, Crystal Reports using versions CR10, CRXIR2 and CR 2008, Designer, Supervisor, Desktop Intelligence, Web-Intelligence, Info View, Scheduler and Publisher, Broadcast Agent, CMC, CCM, Report Conversion tool, Live Office, Xcelcius and Import Wizard

RDBMS: Oracle/9i/10g/11g, SQL Server 2000/2005, Teradata, MS Access, MS Excel.

IDE: Toad, PL/SQL Developer, SQL Developer, SQL Plus,

Languages: SQL, PL/SQL, C, C

Multimedia

Web Designing: HTML/DHTML, MS Office, Adobe Photoshop.

Utilities: MS Word, MS Excel, MS PowerPoint, BMC Remedy.

Operating Systems: Windows NT/XP/2000/98, MS DOS and UNIX.

Professional Experience:-

Confidenital

Role:Senior Report Developer- BI

• Confidential is internet-based system designed for determining eligibility, issuing benefits, collecting data, and developing reports. The legacy systems will be replaced by the new system to determine eligibility for medical and family programs.
• The new system will minimize welfare fraud through improved, efficient record keeping, and verification checks by multiple agencies. It will determine eligibility for programs and family service programs, such as food assistance, child care, and cash assistance.

Responsibilities:

Interacted with functional users to gather requirements of core reporting system to understand exceptional features users expecting with reporting system and also to successfully implement business logic.

Analysis of business problems and planning the Universe solution, Designing the Schema, Building the Universe and distributing the Universe to users.

Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.

Designed universes, defining the necessary connections and exported them to specified universe domains.

Created standard and Ad hoc reports using Business Objects functionality's like Slice and Dice, Templates, Drill Down, Functions, Cross Tab and Master Detail in reporting.

Generated reports from multiple databases in Web Intelligence.

Worked with Web Intelligence Rich Client.

Created Hyperlinks to Drill Down for Detailed Analysis Reports.

Performed integrity testing of the Universes Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking after any modifications to them in terms of Structure, Classes and Objects.

Implemented Web Intelligence Reporting on Universes and developed Ad-hoc/Complex Reports.

Exported the universe to the Repository to make resources available to the users.

Supported the application by solving the trouble tickets, which was created by the users.

Created new Webi reports using BI4.0.

Creating Universe using BO IDT tool and converted existing universe from .unv to unx file. Created row level security.

Migrating reports, Universes from one environment to other using Life Cycle Manager.

Troubleshooting the issues related to Webi reports and universe.

Monitored and solved the issues encountered in Universes and reports.

Worked extensively on modules CMC, Designer, Web Intelligence and Info view.

Set up groups and users for Business Objects deployment. Managed user profiles using CMC and Set object-level security and row level security restrictions, to restrict sensitive client.

Coordinated with Business Objects Deployment and documented the entire project.

Involved in production support role 24/7 to resolve the issues.

Involved in installing Business Objects, creating Repository, Users, User Groups and prioritizing Security Levels for Users and User Groups.

Involved in testing functionality to ensure all features have been migrated successfully.

Environment: BO4.0, Business Objects XI R3 Administrator, Designer, Desktop Intelligence, Web Intelligence, CMC Info View , SQL, PL/SQL, TOAD, Oracle 10g, Teradata and Windows 2003.

Confidenital

Role:FMS Senior Query and Business Objects Data Warehousing - Architect.

Responsibilities:

Working with Query Reporting team to analyze, design and construct reports from data warehouse using Business Objects XI.

Identify end user data access and reporting needs and help business users towards defining detail requirements.

Analyze data and reporting requirements to recommend and design solutions through the creation of reports and query structures.

Creating universes using BO designer tool and Information design tool.

Design and develop new reporting structures, BO universes, reports, queries using BOXIR3.1 support the business data access needs of the FMS project as well as FISA and city agency personnel.

Gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes, Reports and Crystal Reports.

Developed new and making modifications in existing Crystal reports, using Grouping, customized sqls and drill-down options.

Creating Analysis and detail design documents for new reports.

Running job cycles on UNIX environment.

Used Remedy tool for version controlling. Check-in / out the code.

Creating Publications for distributing reports to multiple departments and over monthly weekly or daily cycle.

Creating scripts for Publication.

Review technical designs for FMS BO reporting solutions, identify and remedy design related issues.

Maintain detailed documentation for query and reporting design and development for the FMS project.

Review technical code, test scenarios, test scripts and proactively address any gaps and identify any potential pitfalls.

Created and modified Webi reports using BO Universe as data source

Involved in the troubleshooting of problems/errors related within Webi reports.

Used Import Wizard Tool to create BIAR files and assisted CM team to deploy them onto Integration environment.

Environment: Business objects XIR3.1, Oracle 11g, Crystal Reports 2008, Webi, CMC, PDI Pervasive Data Integrator , SQL, PL/SQL, Windows XP, UNIX, TOAD.

Confidenital

Role: Senior Business Objects Developer.

Responsibilities:

Leading and assigning the tasks to team.

Providing time estimation to different modules within project.

Working on Business objects XIr3.1 and BO6.5.

Designing Universe and WebI reports based on the requirement.

Migration from BOXIR2 to BOXIR3.

Developing Crystal reports.

Converting reports from Deski to Webi using report conversion tool.

Resolving End users issued related to Webintelligence and Desktop intelligence reports.

Resolving issues related to Universe.

Making enhancements in the Universe and reports based on the user requirements.

Design, develop, and implement Xcelsius dashboard. Established the design pattern for all future Xcelsius development using Live Office and QaaWS as connectors

Resolving issues related to Crystal reports.

Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Web XI R3.

Administrating BO servers. Creating Users and providing access using CMC.

Providing Training on Business Objects to end users and freshers.

Migration using LCM tool.

Environment: Business objects 6.1 and XIR3.1, Oracle 9i, 10g, Crystal Reports XI, Webi, CMC, Qwaas, Xcelsius 2008, SQL, PL/SQL, Windows XP, UNIX, TOAD, SQL Developer.

Confidenital

Role: Senior Developer

Responsibilities:

Involved in requirements gathering, functional/ technical specification, deploying and testing. Developed Business Objects Reports based on the new business Specifications and Report Standards.

Developed and managed existing Universes, Classes, Objects and Hierarchies based on Business logic. Created Contexts and Aliases for resolving loops and checked the Integrity of the Universes.

Worked on Query Panel, Prompts, Report Layout and Re-formatting.

Generated analytical reports using Slice and Dice, Drill Down, Cross Tab and Master Detail.

Involved in the defect fixing and Performance tuning of reports

Developing customized WebIntelligence reports using universe based on Teradata database.

Created link objects using open document function to link reports within outside repository deployed them onto info view.

Developing Crystal reports.

Developed reports using- Customized SQL, Drill-down option and linked reports.

Created Dashboards and Scorecards Xcelsius Dashboard.

Creating the unit test cases for the reports.

Unit test and smoke test the reports.

Environment: Business objects 6.1 and XIR2, Oracle 9i, 10g, Crystal Reports XI, Webi, CMC, Broadcast Agent, Informatica, Xcelsius 2008, SQL, PL/SQL, Windows XP, UNIX, TOAD.

Confidenital

Role: Software Engineer.

Responsibilities:

Installation and configuration of Crystal Report XI R2 and Teradata client.

Developing customized Crystal Reports XI R2 using Teradata database and SQL query based on the functional requirement from the client end.

Developed reports using- Customized SQL, Drill-down option, Grouping, Running Totals and Summary reports.

Designed and developed cross tab reports, reports with sub-reports linked and unlinked and chart reports. Reports were based on a command object.

Developed Sub Reports with Parameter Passing, Custom Running Totals, Formulas, and use of Section and Field Suppression.

Exported the reports into various formats such as Excel including data only, Excel export and PDF.

Created Detail Design Document and user training documents.

Worked on integrating the reports with SAP Net-weaver portal.

Creating the unit test cases for the reports.

Done Unit testing of reports and Smoke Test.

Environment: Crystal Reports XIR2, Windows XP, Teradata, Toad, SQL Server and PL/SQL.

Confidenital

Role: Software Engineer.

Responsibilities:

Developing Crystal and Web Intelligence, BOXIR2 reports using Universes.

Developing interactive and predictive reports.

Modifying existing reports and to develop new reports by analyzing databases, data sources, and structures for the benefit of internal users.

Responsible for asserting data needs data analysis, data extraction, report maintenance and design.

Created Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.

Published and scheduled the reports in Crystal Enterprise using Crystal Management Console so that reports are accessed from Front-end application.

Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.

Responsible for dealing with ADW Active Data Warehouse which houses several databases and then based on the request pertaining to each database generate reports.

Creating the unit test cases for the reports.

Peer Review of the reports.

Creating Technical design document after developing the reports.

Providing guidance to peers and reviewing their work.

Environment: Oracle 10g / 11g, Business Objects, Web Intelligence, Crystal Reports 2008, Windows XP, Teradata, SQL Server , MS Access, Data Stage and PL/

Confidenital

Role: Engineer Architect

Responsibilities:

Providing high-end solutions to issues related to BO XI R2, BO XI R1, BO 6.x 3 Tier Architecture , Crystal Reports XI, Crystal report Server XI.

Creating users, groups, and folders and providing rights.

Directly working in collaboration with Business Objects an SAP company.

Creating interactive and scheduled reports.

Hands on experience in Clustering, Publishing Reports, Business View Manager and Info view, Publisher, Designer, Desktop intelligence, Web Intelligence.

Migration from BO6.5 to BOXI.

Developing, generating and maintaining reports with multiple data providers.

Viewing the reports in thin client, WebIntelligence WebI , publish the reports to corporate documents.

Migration from BOXI TO BOXIR2.

Environment: Business Objects, Web Intelligence, Crystal Reports XI, Windows 2003/XP, SQL Server 2000/2005, MS Access, PL/SQL.

Confidenital

Responsibilities:

Creating users, groups, and folders and providing rights using Central Management Console.

Creating Webi reports based on end users requirement.

Resolving problems related to Business Objects.

Coordination and work assignment to my team members

Hands-on experience in server management, Remote Server administration

Handling packages such as MS-office, Outlook, Outlook Express and applications running at customers end and Network related problems.

Setting up SSO in BOXIR2.

Installing/Download the patches and updates.

Management of intranet sites, clients developed software's.

Environment: Business Objects, Web Intelligence, Windows XP, SQL Server, MS Access, and PL/SQL.