SUMMARY

• Over 7+years of experience in IT industry wif Data warehousing, SAP Business Objects Suite: Desktop Intelligence, WebIntelliggence, Business Objects Designer, Crystal Reports 2008, Info View and Xcelsius.
• Workable noledge on 4.0.
• Experience in Business Objects Development through versions Business Objects XI 3.1(R3.1)/XIR2/R1/6.x/5.x/5i/4.x(Designer, CMC, Desktop Intelligence, Web Intelligence and Info View, Import Wizard, Report Conversion tool, Publishing Wizard, CCM).and Xcelsius 4.5.2008.
• Expert in creating Ad - Hoc reports using Business Objects, Web Intelligence, Desktop Intelligence, Web Intelligence and Info View, Import Wizard, Report Conversion tool, Publishing Wizard
• Expertise in planning, designing, developing, modifying, updating, maintaining and distributing Universes and Reports.
• Expertise in designing Universe and creating reports on 6.5 and XIR2, XI R3.0.
• Good work experience in migration of SAP BusinessObjects XI R3.1.
• Experience in building efficient and user oriented universes using Designer and creating adhoc and canned reports using Desktop Intelligence, WebI and WebI Rich Client.
• Experience in building Desktop Intelligence reports using Universes, Personal Data files and Free Hand SQL Methods.
• Experience in Querying and Reporting modules of Business Objects Enterprise XI.
• Implemented SAP Business Objects Voyager as an interface wif OLAP cubes and enhance it for adhoc reporting.
• Implemented and migrated 6.5 Reports/ XI Release 2 reports to XI Release 3.1 environment.
• Introduced and Implemented teh new interactivity available in XI R3 to business like Offline Ad hoc reporting, Data Tracking of Medicare members, Hyperlinked reports and Stored Procedures implemented at teh Universe level.
• Worked on InfoView to create Web Intelligence, Desk Intelligence Reports over teh Universe Created.
• Worked on Combination Queries. Created Web I reports over Multiple Queries.
• Good noledge and Experience in using Informatica Power Center/Power Mart 8.6/6.2/5.2/4.7 , Oracle 11g/10g/9i/8i, DB2 UDB 8.x/7.x (control center, configuration assistant), MS SQL Server 2000/2005, Enterprise manager, Query analyzer.
• Involved in developing and designing ETL mappings, workflows, data loads and schedule teh workflows using various scheduling tools.
• Experience in Software Development Life Cycle of Business Intelligence and Data warehousing projects.
• Experience wif Central Configuration Management (CCM), change control and source control Systems
• Ability to quickly adapt to new technologies very quickly and different project environments
• An excellent team member wif interpersonal and communication and presentation skills along wif Time management.

TECHNICAL SKILLS

Business Intelligence: SAP Business Objects XI R2/R3.1/6.1 (Designer, Desktop Intelligence and Web Intelligence), Crystal Reports 5.0/6.0/7.0/8.0/8.5 , Forms 4.5, Reports 2.5, SAP BI 7.0, Xcelsius 2008.

DataModeling: Star-Schema Modeling, Dimensional Modeling, Snowflakes Modeling, FACT & Dimensions.

Programming: C, C++, ASP, SQL, PL/SQL.

Utilities & Tools: Make, SCCS, PVCS, OLAP/OLTP, Rational Rose, GDB, Toad.

Networking tools: FTP, Connect Direct, Unix IPC.

Database: Oracle 10g/9g/8g, Adaptive Server Enterprise 11.9.2 (Sybase), Informix, Teradata Database, MS Access, DB2, SAP BW 7

Project Management: Oracle ADI 11.2, MS Project, MS Access, MS Visio and MS Excel.

Environment: Win 3.x/95/98, Win NT 4.0, Windows 2000/2003 server, Sun Solaris 5.8/2.6, Sun OS 4.0, MP-RAS Unix, MS-DOS 6.22, Novell NetWare

PROFESSIONAL EXPERIENCE:

Confidential, MN

Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about teh IT incident system for Business Objects Universes and Reports.
• Designed, developed and managed Universes in Business Objects Designer for generating teh Closed Incident Report, Closed Interactive Reports, Incident by Service and CI.
• Setting up rights to Business Objects Applications (Info view, WEBI, Designer, Dashboard Manager, Crystal reports, Desktop Intelligence(DESKI) for User groups in Central management console(CMC) .Setup access to WEBI reports in Info view for View on Demand reports, Ad-hoc reports, modify rights.
• Created Xcelsius Visualizations and published them to business objects Enterprise, which showed key performance indicators graphically.
• Created Dashboards using Dynamic data from data source options such as query as a web service and live office.
• Using live office imported Web Intelligence reports in Excel and Created Xcelsius visualization based on these reports.
• Implemented Business Objects security to do User/Group management, Folders, Universes and Reports management, job scheduling and monitor teh job scheduler to optimize teh server performance.
• Worked wif Import wizard to move teh objects between DEV, QA and Production systems, to create users in bulk.
• Created an IT Service Management Dashboard of dynamic data fetching from teh oracle Database through a Live Office.
• Created an IT Change Management Dashboard, dynamic data fetching from oracle database through Query as a Web Service.
• Worked extensively wif @functions (@select, @prompt, @where) to overcome teh problems wif database when integrating wif Business Objects.
• Created predefined conditions in teh universe level to restrict teh volume of data to be pulled in teh report.
• Generated Reports wif Free hand SQL and Stored Procedures using Oracle 10g.
• Assisting teh client, through analysis of their existing system, challenges, and business needs. Documented teh reporting requirements and interacted wif Business users and collected business information and their requirements for developing teh project Work Force Reports.
• Created a report like all teh individual policies dat covered childrens 19 & under at any time during teh last five years and dis is was created in Crystal Reports.
• Analyzed business model and created Business Intelligence Architecture plan, created Business Functional Specifications, Functional Design Specifications, and Detailed Design Specifications.
• Design teh presentation for a strategy on SAP Business objects module like SAP BI Solutions, SAP EIM Solutions, SAP EPM Solutions and SAP GRC Solutions.
• Gathers teh Client requirement for designing, configuring and implementation phases for Business objects BI solutions Architecture.
• Involved in teh development of teh Unified Database, which is a data warehouse application, which stored and reported on repair data for over two thousand dealerships, using Teradata as its data repository
• Given teh presentation on Business objects architecture design document.
• Design teh Business objects architecture (3-tier) for teh entire environment dat is Dev, QA and Prod.

Environment: Business Objects XI 3.1/R2, Crystal reports, Web Intelligence, Infoview, Live Office, QaaWS, Windows XP, SAP BW, Teradata, SQL Server2005/2008, Oracle 11g/10g/9i, TOAD, Windows 2003 Server.

Confidential, Overland Park, KS

Business Objects Developer

Responsibilities:

• Designed and developed BO reports and universes accessing Oracle data warehouses
• Worked closely wif DBA to design data warehouse for reporting requirements
• Created customized lists of values for dimension codes and descriptions
• Implemented aggregate awareness to enhance teh performance of SQL transactions
• Coded PL/SQL functions and packages to create reporting objects
• Utilized TOAD and SQL*Plus for creating/testing queries

Environment: Business Objects XI 3.1/R2 SP2 (Supervisor, Designer, Business objects), Xcelsius 2008, QAWS, Live office 3.1, Oracle 9i (SQL and PL/SQL), Teradata, SQL Navigator,TOAD, SQL server, MS Excel, Crystal Reports XI MS Access, ERWIN 3.5.2.

Confidential, PA

Business Objects Developer

Responsibilities:

• Working on Installing and configuring BO XI R3 servers, along wif configuring User groups, folder structures for card team.
• Working on Requirements gathering and raw data analysis for business users and for report development.
• Working on design and developing business objects WEBI reports against multiple data domains like SCRA, CDA, CDW and home loans.
• Created reports against Oracle database doe CDW/ SCRA team, Oracle database for home loans team and Sybase ASE for US card (NPI data).
• Responsible for administering BO CMC servers and implementing various security levels.
• Created performance analytics dashboards using Xcelsius 2008 against Web I reports using live office.
• Migrated legacy reports from 6.5 to XI R3.1.
• Created complex universes, wif derived tables and created best practices to leverage more on Universe rather TEMPthan report for Performance.
• Standardized BI development by creating Design document, BI checklist, SQL checklist for developers and CBT’s for new users.
• Followed data governance instructions for NPI and non NPI data.
• Involved in System testing, unit testing and UAT for deployed reports and dashboards.
• Created manuals for teh deployed User reports and conducted Status meetings wif developers.
• Currently, working on Performance dashboards based on revenue, finance charges, Payments due, Balance transfer, Overdraft and Stop payments using Xcelsius for teh divisional managers.
• Worked on Star Schema and Snow Flake Schema in teh data modeling phase and Contexts and Aliases for resolving for resolving Loops and context in teh Universes
• Created breaks, master detail, sorting, drill down, slice and dice, alerts, joins, hierarchies, ranking features to generate Adhoc, automated and complex Web Intelligence and Desktop Intelligence reports.
• Created custom calendar to schedule teh Web Intelligence reports.
• Utilized Business Objects built-in @functions (@aggregate aware, @select, @prompt, @where) to improve teh performance and to overcome intricacies related to data integrity.
• Create custom Audit Webi and Crystal report to monitor user activity.
• Designed and Created Business Objects Voyager Workspace reports against OLAP cubes as data source.
• Designed and Created Dashboard using Xcelsius, Qaaws, Live Office for Proof concept for Xcelsius Products.
• Responsible for Xcelsius Dashboard System Implementation
• Implemented Single Sign on for Live Office Add on tools
• Created Qaaws(Query As Web service), Multi-Layer Dashboard, new components in Xcelsius charts like Line Chart, Pie Chart, Bar Char, Combination Chart, Container like Tab sets, Selectors like Accordion Menu, Check Box, Combo Box, List box, List view, Single value like Gauge, Slider, Alerts Dynamic Selection, Dynamic Visibility.
• Worked as Backup for Informatica Administrator and NDM Administrator.

Environment: Business Objects XI 3.1/R1/R2/R3, Designer XI R1/R2/R3, Desktop Intelligence, Sun Active Directory, Web sphere 6.0, Sun one 6.1 SP1, Site minder 5.5, Business Objects Voyager R2/R3, Dashboard Manager, Performance Manager XI R2/R3, Xcelsius 4.5/2008, Live Office R2/R3, Crystal Reports R2, SSL,Tomcat, Oracle 9i/10g, SQL, PL/SQL, Sun Solaris 5.8/5.10., QAAWS (Query as Web Service), Auditor Xi R2/R3, Tivoli, Informatica 7.1.5

Confidential, MO

Business Objects Developer

Responsibilities:

• Responsible for creating teh reports in teh development environment and to promote them to production using teh import wizard.
• Installed Business Objects Enterprise Product client tools on local machine.
• Analyzed teh Functional Design requirements and converting them to technical requirements.
• Preparation of Detail Design Specification documents for Universe and Report Development.
• Assisted teh Data Services team in teh design of database summary tables and preparing teh detail design document on ETL Process to load these tables.
• Involved in development of Business Objects data integrator jobs, workflows, data flows to extract, transform teh source data and loading teh target tables.
• Created Universes in such a way, dat would enable to create Ad-hoc reports and analyze them in different angles using techniques like slice and dice, drill down, using Oracle as backend data bases.
• Created Classes, Objects, Measure objects, Joins, short cut joins, @prompts and predefined conditions in teh universes.
• Defined Custom Hierarchies at Universe level to implement drill down functionality in teh reports.
• Resolved loops in existing universes using Aliases and defining Contexts.
• Implemented Aggregate aware function and set up aggregate navigation wif objects derived from standalone tables wifin teh universes.
• Applied index aware functionality on non indexed column objects to increase teh performance by directing teh report query to select teh index fields from teh database for faster retrieval of data.
• Created Cascading Prompts at universe level for dynamic selection of data wifin a hierarchy as per teh user requirement.
• Built drill-down reports using Scope of Analysis and drill filters functionality wifin Business Objects Web Intelligence.
• Created templates to customize style and structure according to teh employer's needs.
• Involved in writing and documenting unit test cases and exporting teh results to HP Quality Center.
• Involved in system testing of already existing universes in Production Test Environment.
• Involved in building applications from an ASP based environment dat helps users for exporting reports and handling scheduling tasks.
• Performed certain SQL performance tuning of queries using DB Visualizer 6.0.2.
• Used Crystal Xcelsius 2008 as a Data Visualization Tool to transform some Microsoft Excel spreadsheet data into visuals such as Pie-Charts, Bar Graphs, Scorecards dat can be shared via PowerPoint and PDF files
• Involved in Migrating Business Objects system from version BO XI R2 to BO XI 3.1 using teh Import Wizard Tool.
• Involved in converting various Reports from BO XI R2 to BO XI 3.1 using teh Report Conversion Tool.

Environment: BO XI R 3.1 (Universe Designer, Reporter), BO XI R2 (CMC, CMS, Designer, Desk I, Web I), Web I XI R2, Info view, BO XI 3.0,IBM DB 2 version 6, PL/SQL, SQL, Crystal Xcelsius 2008, DB Visualizer 6.0.2,BO SDK, MS Access 2003, Windows XP Professional.

Confidential, TN

SAP BO Developer

Responsibilities:

• Involved in constant Requirements gathering and business needs wif executives and traders for Dashboard design and development.
• Lead a team of 4 developers and 3 BA’s for business Objects implementation for a limited period.
• Converted legacy BO 6.5 and BO 5.1.8 reports to SAP BO XI R3.1 Reports.
• Converted Reporting business requirements in to Functional design and Technical design documents for Developers and testers.
• Working along wif DBA/s, BA’s and Data modelers for data design and report design.
• Involved and designed teh Enterprise level data security, report security level set up folder structure and User group access.
• Created Unit Test cases, Test scripts for Unit testing, UA testing and System testing.
• Administered user privileges, access, and implementation for SAP BO XI R3.1.
• Worked along wif QA team to get teh SIT and UAT process to be complete align wif Unit Testing and perform code reviews.
• Upgraded teh Medicare XI R2 environment on to XI R3.1 environment.
• Created multiple Universes specific to Medicare and Providers subject area. Implemented user friendly universes for users to create Ad hoc reports.
• Implemented aggregated data for Xcelsius dashboards and Imported Xcelsius on to BO environment (Info view).
• Wrote Autosys jobs and scripts for scheduling BO reports.
• Implemented SAP Business Objects Data Integrator XI R3 as a Standard ETL tool to retrieve and clean up data from multiple scattered data sources.
• Implemented IBM DB2 database as teh data source for BO Reporting.
• Involved in DB2 data modeling and data structures during teh initial stages of teh product.
• Linked Performance management dashboards to Xcelsius dashboards.
• Xcelsius dashboards include drill down from reports, Combination charts, Goal declaration, Medicare History Score card and IMS forecast.
• Created Executive dashboards wif Drill, Drop down, details, Linking to BO Reports, Tabbed and also wif Open doc statement.
• Implemented Snow flake design and modeling based on teh report requirements.
• Implemented high data intensive reports using Crystal Reports against Crystal enterprise Business views.
• Interacted wif Informatica ETL team for issues related to dataflow.
• Created stored procedures to support teh Crystal Reports.
• Defined Metadata information for teh reports.
• Implemented Confidential data as a 3rd party data source for Health reports.
• Created hands on 40 + interactive reports and designed them to satisfy 3rd party front ends like Compleo and TMHP.com
• Working on Post Production scripts to deploy Reports, Dashboards and Universes.
• Implemented Mobile Information delivery of teh Reports.
• Implemented .Net based frame work using BO SDK to convert Crystal Report files in to PDF documents to a local LAN folder for Auditing purposes.
• Implemented in total of 45 scheduled and daily reports developed using Crystal reports and Desktop intelligence based on teh Data intensity.
• Implemented live office via QAAWS to generate reports against MS products.
• Leading a team of 4 developers and 3 BA’s for business Objects implementation.
• Created Technical Support documentation for Reports and universes.
• Implemented and trained Developers as well as users on new BI standards.
• Created PL/SQL based stored procedures for data intensive reports.

Environment: Business Objects XI R2 (Universe Designer, Reporter), Web Intelligence XI (Info view), BO XI R2 (CMC, CMS, Designer, Desk I, Web I), Crystal Reports XI, Crystal Xcelsius 4.5,SQL, PL/SQL, MS Access 2003, Windows XP Professional, IIS, Oracle10g,Informatica 7.1.1.

Confidential, TN

Business Objects Developer

Responsibilities:

• Involved in functional requirements gathering meeting different Business Groups and preparing teh Technical specifications.
• Set up groups and users for Business Objects deployment. Managed user profiles using Supervisor.
• Involved in teh designing and Building of Universes from different data sources like Oracle/SQL Server.
• Linked Universes to share teh Universes which had common dimension tables and teh classes and objects.
• Created Contexts, Joins and Aliases for resolving Loops and checked teh Integrity of teh Universes.
• Involved in Writing Detailed Level Documentation for reports and Universe design.
• Responsible for designing teh reports according to clients requirement using Business Objects 6.5.1.
• Created teh reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Used multiple data providers such as Universe and personal data files in generating report.
• Created charts like pie charts, bar graphs, line graphs. Analyzed teh data in charts using slice/dice, drill up/drill down.
• Responsible for developing all types of reports including Cross-tab reports using Crystal Reports 8.5.
• Generated reports using free-hand SQL as a data provider.
• Involved in production Support and gave to teh users in Reporter and Web I.
• Designed, developed and tested teh reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects connected to Oracle 10g data sources.
• Scheduled Business Objects reports through Schedule manager in on regular basis.
• Created full client and Web I reports. Modified teh existing by adding new columns based on teh result set.
• Responsible for Migrating teh Business Objects Universes/Reports across teh Servers/Repositories (Development to Production Servers).
• Installed and configured Business Objects Enterprise XI R2Suite of Products in teh development environment.
• Involved in Migrating Business Objects system from version 6.5.1 to Business Objects XIR2.
• Migrated Users, Universes, Connections, Full Client / Web I Reports from teh existing version 6.5.1 to XIR2 using Import Wizard in single parse.
• Involved in Unit testing, System testing and User Acceptance Test (Universes and Reports) throughout teh migration process.
• Converted all reports from BO 6.5 to XI using Report Conversion Tool.
• Involved in support, for fixing teh bugs reported from System and UAT test and keeping track of teh bugs using Bugzilla and Mercury Test Center.
• Created new users in XI R2 using Central Management Console and set restrictions, assign privileges based on their profiles.
• Created new Universes for new reporting needs.
• Applied row level and object level securities to different groups and users using Designer.
• Developed Desk I Reports using functionalities like cross tab, master detail, drill down, using filters, breaks, alerters and formulae.
• Created user response objects, user prompts in various Desk I Reports.
• Created Deski Reports using user variables, aggregates and other functionalities.
• Created Web I reports wif more TEMPthan 10 data providers and synchronized teh data using teh merge dimensions option.
• Created reports in Crystal Reports using Business View and Universe as data provider.
• Generated dynamic cascading values in teh process of building crystal Business Views.
• Developed Performance Management Dashboards to set Goals, Measures and monitor KPI for Balance Scorecard initiatives.
• Created Interactive Metric Trends (IMT) and score cards using Performance Management according to teh user requirements.

Environment: Business Objects 6.5.1/XI R2(CMC, CMS, CCM), Designer, DeskI, WebIntelligence XIr2/6x, Supervisor, BCA, Oracle 10g, MS SQL Server 2005, TOAD, PL/SQL, Windows 2003 Server, Red Hat Linux 8.0/9/1

Confidential

Business Objects Consultant

Responsibilities:

• Interacted wif Business Users and Business Analysts to gather teh requirements and business logics.
• Interacted wif end users, regularly in order to generate teh reports requirements, these reports were generated using Business Objects functionalities such as Slice and Dice, Master/Detail, User Responses, Formulas, etc.
• Checked Universes for Integrity and exported them to teh Repository to make resources available to teh users and groups.
• Created Universes and Reports based on requirement and Involved in Migrating Reports from BO 6.0 to BO 6.5
• Resolved loops in Universes using table aliases and contexts to remove cyclic dependencies.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked teh Integrity of teh Universes.
• Involved in creating reports on teh web using Business Objects Web Intelligence 6.x.
• Created and managed users and their groups for different areas, repositories, and documents through Supervisor module.

Environment: Business Objects 5, Business Objects 6x, Central Management Server, Designer, Oracle 8i, Windows 2000.