SUMMARY

• Sr. Business Intelligence(BI) Consultant with exceptional skills in Analysis, Development, Testing of Business Intelligence applications in the area of Business Objects, Data Warehouse, Relational Database Management System (RDBMS), Client/Server environment applications on Windows platforms across various Business Units.
• Over 7 years of IT experience in SAP Business Objects 5.1/6.0/6.1/6.5/ XI R1/R2/3.0/3.1/BI 4.0(Info View, BI Launchpad, Web Intelligence(WEBI), Desktop Intelligence(DESKI), Web Intelligence Rich Client, Universe Design tool, Import Wizard, Report Conversion Tool, Central Management Console(CMC)/Supervisor, Crystal Xcelcius 4.5/2008, Crystal Reports XI/2008)
• Extensive experience in planning, designing, developing, modifying, updating, maintaining and distributing efficient and user oriented Universes using Universe Optimization Techniques on Business Objects XIR2 and Business Objects XI R3
• Good experience in Business Objects Administration. Creating Repository, Creating Users and User Groups and assigning Access level security using Central Management Console (CMC) and Supervisor.
• Involved in Unit Test Case, Integration Test, User Acceptance Test (UAT), Load Test and System Testing preparation and testing of the applications.
• Introduced and implemented the new interactivity available in XI R3 to business, like Ad hoc reporting, Hyperlinked reports
• Implemented Live Office, Created Xcelsius and score cards in XI R2 and R3.1.
• Worked with End - To-End implementation with Data warehousing team - Strong understanding of Data warehouse concepts Star Schema, Snowflake Schema and Multi-Dimensional Models, Operational Data Source and Marts, Extract Transform Processing (OLTP).
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) supporting on various platforms like UNIX and Windows /2003/2008/XP.
• Proven ability to effectively handle multi-task levels of project management responsibility with minimal direction from supervisors while supervising personnel, providing team leadership, motivation and development.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, Java, HTML, COBOL, Shell scripts Structured Query Language (SQL).

OLAP/DSS Tools: SAP Business Objects 4.0,XI 3.1(R3.1)/R2/R1/, Business Objects 6.x/5.x/5i/4.x, SDK, SAP Crystal Reports XI, Translation Manager, Crystal Xcelsius 2008/4.5,Deployment Tool, Dashboard manager, Scorecards, Tomcat 4.0.6,Oracle Warehouse Builder, Apache 1.3.x. Crystal Decisions, Microsoft, Oracle Microsoft Visual Basic, SAP Business Objects XI R II, SAP Crystal Reports Server XI.

RDBMS: Oracle, SQL Server 2003, MS Access Oracle, Microsoft SQL

Web Expertise: CSP, ASP, DHTML, JavaScript HTML, JAVA 1.2,JSP

Web/Application Servers: Tomcat, Apache Server, BEA’s Weblogic 5.1/6.1 BEA’s Weblogic 4.5/5.1/6.1

Operating systems: Windows 2000/2003/2008 , UNIX, Red Hat LINUX Windows NT, Windows 95/98.

PROFESSIONAL EXPERIENCE

Confidential, Windsor, CT

Sr. SAP Business Objects Consultant

Responsibilities:

• Built the Security Model from scratch - This included setting up Custom Access Levels after understanding the client’s Security needs.
• Responsible for assigning rights and access levels for the Users/Usergroups on Universe, Connections, Applications and Folders.
• Involved in Re-designing the Universe objects based on change in Business requirements.
• Implemented advanced concepts like Aggregate Awareness, Derived Tables besides Row - Level Security in the universe design
• Created Business requirements documents for the modifications required for the reports and Universe, which included testing strategy, ETL fixes and Business Objects fix and Business requirements etc.
• Acted as the point of contact for production support and resolving issues.
• Assisted ETL team for analysis in fixing the ETL defects.
• Participated in data validation for the claims and balance reports.
• Participated in Business user meetings, fixing and explaining the reports for its errors.
• Participated in status meetings and prepare status reports as necessary - highlighting issues and constraints that would impact timely delivery of work program items.
• Created Adhoc reports, Modified reports based on demand.
• Resolved performance issues in Business objects reports by recommending alternatives.

Environment: SAP Business objects BI 4.0, SAP Business Objects Dashboard 4.0 (Xcelsius), BI Launch Pad, Oracle 10g/11g,MS Visio 2007, Quality Centre and Informatica 9.0.1

Confidential, Louisville, KY

Sr. SAP Business Objects Consultant

Responsibilities:

• Installed and configured BOXI 3 Server Components and Administered Central Management Server.
• Responsible in creating users and user groups using Central Management Console (CMC) and assigning the privileges to the users to access the Business Objects applications.
• Applied Business Objects SP5 services pack in dev, test & prod environment.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Webi Reports.
• Created the security model (content plan, Access Control list) for the project. Implemented row level security on restricted user groups.
• Built customized hierarchies in the universe to support drill down and drill up functionality.
• Created reports likeMaster/Detailreports,Cross Tab reports, chart reports, anddrill down.
• Responsible for scheduling the reports on a daily, weekly & monthly basis.
• Created both dynamic and static dashboards using Xcelsius from SAP and Non-SAP data using both QAAWS (Query as a Web Service) and Live Office.
• Coordinated with thePackagingteam for the creation ofBusiness Objects 3.1 Client Products and Xcelsius 2008packages forWindows Clientsfacilitating the installation for the users from the Helpdesk directly.

Environment: SAP BusinessObjects3.1, Web Intelligence, Central Management Console (CMC), Oracle 9i/10g, PL/SQL, Info View, Windows 2003 server, Live Office,Xcelsius 2008.

Confidential, Sharon, PA

SAP Business Objects Migration Analyst

Responsibilities:

• Migrated from Business Objects XiR2 to Business Objects 3.1
• Created Migration Plan for the entire migration.
• Involved in Assessment (Pre-migration), migration & Post migration activities.
• Enhanced, Maintained and supported newly created multiple universes.
• Utilized Universe Optimization techniques like Aggregate Awareness, Index Awareness and Short Cut joins.
• Created Ad-hoc reports using Business Objects functionalities like Drill Down, Cross Tab, Master Detail and Formulas etc.
• Involved in designing Credit Summary Dashboards for higher level executives in Confidential using Xcelsius 2008.
• Developed various multi-chart models that connect to real-time enterprise data using Query as a Web Service (QAAWS).
• Created Dashboards to the residents of Pennsylvania State for extension of loan payments with the KPIs using the categories and components on Xcelsius.

Environment: SAP Business Objects (BOBJ) XI R2\3.1 Enterprise, Xcelsius 2008,Oracle 10g, Access 2000, Windows XP

Confidential, Los Angeles, CA

SAP Business Objects/ Crystal Reports Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Crystal Reports.
• Designed, developed, maintained and tested universes for supporting ad hoc and canned reports according to the business requirements.
• Developed Crystal Reports by writing SQL based on the database tables.
• Formatted the reports with respect to the requirements. Added parameters, special fields, formulae and used multiple data sources to create the reports.
• Created contextual links between Crystal reports and Webi documents using open document feature.
• Built new Universe following the standard procedure like linkages between tables, creating prompts and queries, applying contexts and alias tables to resolve loops and SQL traps
• Performed Universes optimization procedure according to business requirement using aggregate awareness, index awareness and shortcut joins.
• Installed Business Objects XIR2 on Apache Tomcat Server.
• Involved in migrating Business Objects 6.5 version to XI R2.

Environment: SAP Business Objects XI R2 Enterprise, SQL Server 2008, SQL Server 2005, Crystal Reports, Windows XP.

Confidential, Peoria, IL

Business Objects Developer

Responsibilities:

• Created Requirement Specifications reports, Mapping Documents, Report Mockups and modified existing requirements.
• Concierge Project involved the study and analysis of the required data and pooling up different data from three different data warehouses for the sake of building up a common universe
• Created data models, ODS and cubes based on business requirements and business transaction types like service ticket, complaint and follow-ups.
• Designed, developed, implemented and maintained Universes using Business Objects Designer, Resolved loops by creating Contexts and Aliases.
• Extensively used Universe Optimization Techniques such as Aggregate Awareness and Index Awareness.
• Implemented Row level security and Object level security in the universe to certain groups of Users.
• Involved in developing, designing and maintaining new and existing universes with Classes and Objects using SAP BW Info Cubes.
• Created Reports like, Reports by Category, Reports by Region, and Reports by Time (Year, Quarter, and Month Date).
• Organized data in report Inserting Filters, Sorting, Ranking & highlighting data. Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Developed complex reports using Local, Global, and Shared Variables and shared the data between main and sub reports.
• Creating linked reports for WEBI reports using open document functionality.
• Maintained and modified existing crystal reports, created new ones and linked them to Webi report

Environment: Windows 2000, Business Objects 6.x, Web Intelligence, Info View, HTML, Oracle Warehouse

Confidential, St Paul, MN

Business Object Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Deski Reports.
• Reviewed and analyzed the data from the operational & data warehouse systems.
• Defined Classes, Objects, Dimensions, Measures, Details, Conditions, Joins, Aliases and Contexts. Creating complex objects, @prompts, @variables, and resolving traps (chasm/fan) among others and verifying Integrity of universes.
• Designed developed, maintained and tested universes for supporting Ad hoc, canned reports and implemented advance features such as aggregate awareness, context, etc.
• Created Hierarchies to facilitate drill-down in the Full Client reports.
• Expertise in creating simple & complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking & multiple data providers. Created reports using Business Objects functionalities like Queries, Slice & Dice, inserting and organizing multiple breaks, Cross Tab, Master Detail & Formulas.
• Used sorts and ranks in reports, where the sorting and ranking takes place based on the user Criteria through prompts.
• Developed complex reports in Business Objects6.5 using OpenDoc functionality, creating local variables and utilizing the concept of scope of analysis in limiting drill down functionality.

Environment: Business Objects 6.5.1/5.1.2 , Sql Server 2005, DB2 (UDB), ZABO, Pl/Sql, Erwin 4.1, Excel and Windows 2003.

Confidential

SQL Server Developer

Responsibilities:

• Expertise in SQL Query Analyzer and Enterprise Manager
• Comfortable with Sql Server 2005 and in other RDBMS like Oracle (SQL, PL/SQL, Forms and Reports).
• Responsible for Development, Implementation and Support of the database of the server.
• Expertise in writing and debugging Stored Procedures and Triggers.
• Assisted in backup and recovery and general maintenance procedures.
• Experience in managing Alerts, Security and Isolation levels.
• Responsible for dealing with problems, bug fixing and troubleshooting.

Environment: SQL Server 2000, SSIS, MS Access, Java, JSP.