SUMMARY:

• Over 7 years of experience with 2 Full life Cycles in SAP BI/BO in back end modeling and front end development.
• Nearly 3 years of experience in Modeling, 4 years of experience in Extraction from ERP, Non SAP Systems, 3 years of Experience in Report Development.
• Over 4 Years of experience in Business objects.
• Experience with BI/BW components including Info Cubes, DSO’s (ODS), Transformations, DTP’s, Info sources, BI content, Info objects among others.
• Analyzed the business requirements and translated into dimensional data models by using extended star schema techniques
• Excellent cross-functional experience in SD, MM and FI/CO modules.
• Good knowledge in extending the Business content based on requirements.
• Performed Data load management, CTS, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, Multi Cubes, Data Mart and Open Hub Service.
• Expertise in BW Performance Tuning: Experience in Performance tuning of Queries by maintaining Aggregates, Compression, partition, Process chains, indexing of info cubes and use of statistics for the same. Extensively used variety of techniques to boost the performance of BEx Query.
• BW reporting using BEx Analyzer, BEx Browser, Web Application Designer, and implementing BEx Queries, Calculated and Restricted Key figures, variables, workbooks, security roles and profiles.
• Designed/maintained universes, created/designed/maintained/scheduled reports.
• Familiarity with Business Objects Reporting(Webi, Crystal, Xcelsius), Data modeling, Design, Development, Implementation
• Proficient in optimizing, debugging and testing SQL queries
• Ability to assist in the design and creation of Universes and Reports.

TECHNICAL SKILLS:

SAP BI/BW Versions :

BI 7.0, BW 3.5, 3.1C, 3.0B, 3.0A, 2.1C, 2.0B.

ERP :

ECC 6.0,ECC 5.0, 4.7, 4.6C,

Front ends :

BEx Analyzer, Web Application Designer, Net weaver, Crystal Reports (BO),SAP BOXI R3, Xcelcius 2008

Languages :

ABAP/4, JAVA, SQL, PL/SQL

Operating systems :

UNIX, Windows95/98/2000/NT, XP

Scripting Languages :

JavaScript, HTML, DHTML

PROFESSIONAL EXPERIENCE

Client: Confidential,Evansville, IN Jan 2011- Present
Role: SAP Senior Business Objects Developer
Environment: SAP BI7.0, SAP BO XIR3.1, Crystal Xcelsius 2008, QAAWS(Query as webservice)

Responsibilities:

• Conducted user meetings to analyze the user requirements, identifying the sources data.
• Attended meetings to analyze the gaps (Gap Analysis)
• Created UAT test Cases, Test Plans in Mercury Quality Center to resolve data issues per the user requirements
• Involved in resolving the Defects.
• Involved in creating and analyzing the Data model for the Genentech and Roche fields.
• Designed, developed and managed universes.
• Resolved the loops using Contexts/alias/shortcut join.
• Used functionalities like Hierarchies, @ aggregate Awareness.
• Used optimization strategies for improving the performance.
• Created new classes & new objects in designing the universes, Importing/Exporting the universe from/to repository to make it accessible to end users.
• Created Universe to provide ad-hoc reporting capabilities.
• Created reports using Web-I and Desktop Intelligence (sample reports for users).
• Created built in filters, prompts, alerts, breaks for reporting.
• Designed reports using functionalities like Slice and Dice, Drill down, cross tab, charts, Master/Detail, Formulae and prompts.
• Created Xcelsius (crystal Xcelsius reports) for users using the QAAWS
• Migrated reports, Universe from Dev to Test and Production.
• Updated User groups and granting user rights to users.
• Created technical and user documentation.

Client: Confidential,Princeton, NJ Mar 2009 – Dec 2010
Role: Business Intelligence Analyst.
Environment: Business Objects XI R2\\ 3.0, Teradata, Oracle10g, Crystal Xcelsius 2008, QAAWS, MS Office.

Responsibilities:

• Attended User Meetings to analyze the user requirements.
• Worked with users on identifying the enhancements needed to in the new release to meet the user requirements.
• Interacted with the database developers, data modelers regarding the enhancement updates.
• Interacting with the Dev and UAT teams to see the enhancements are taken care off in the new releases.
• Created user forms to train users and help them create their own Adhoc reports.
• Conducted office hours to help user with reporting issues.
• Used Remedy IT Service management tool to raise incidents to resolve data issues, reporting issues, Access to BO, critical Business Issues and escalate issues to It support Team.
• Created reports using WebI and WebI Rich client.
• Created Quick filters, prompts, functions, alerts, Sections, breaks for reporting.
• Scheduled reports for the users.
• Created Xcelsius (crystal Xcelsius reports) for users using the QAAWS.
• Provide Production support to the existing reports.

Client: Confidential,Sacramento, CA Feb 2008- Mar 2009
Role: Business Objects Developer/Admin
Environment: Oracle10g, BO-XI, SQL, PL/SQL, Windows 2000, WebI, Desktop Intelligence, MS Excel

Responsibilities:

• Attended user meetings to clarify/analyze the user requirements
• Involved in data analysis and validation of data from MYSQL to Oracle
• Migrated the reports, Universe, universe connections, users, user groups, folders, events, Calendars, Server groups, servers using the Import wizard from BO 6.X to BO XIR2
• Updated User groups and granting user rights to users.
• Migrating the universes, reports, documents from Dev to QA to Prod using import wizard.
• Converted Desktop report to WebI reports using report conversion tool.
• Designed, developed and managed universes for sales in, sales out, Point of Sale.
• Used optimization strategies for improving the performance.
• Created new classes & new objects in designing the universes, Importing/Exporting the universe from/to repository to make it accessible to end users
• Created metrics and dashboards/ Performance management for high level management for the analysis of the business.
• Created the Business Objects reports (WebI, DeskI) for analysis, and forecast.
• Scheduled reports on daily and weekly bases.
• Performed both unit and integration quality assurance testing prior to release.
• User Training on ad-hoc reporting and Demonstrations for various sites.
• Attending user calls and finds solutions to high-level issues (on-call support).

Client: Confidential,Melrose Park, IL Mar2007 - Jan2008
Role: SAP BI Consultant (Functional/BI Architect)
Environment: SAP BI 7.0, SAP ECC 6.0

Responsibilities:

• Attended all functional business workshops to gather the requirements and to analyses the gaps.
• Prepared the Business content and BI Strategy documents (Including Customer object standards, Extraction Strategy, Legacy Historical data Strategy, Reporting Strategy e.t.c).
• Designed and developed documents and reviews conducted time to time.
• Created the Functional and technical design documents for OTC(Order to Cash),MTS(Make to Ship),PTP(Procure to Pay),ATR(Account to Report),HTR(Hire to Retire),DTB(Demand to Build).
• Data Logical flow documents created for the developers.
• Coordinated the entire developing process with the Offshore team (India).
• Conducted design reviews with the client for clarifications while developing.
• Installed Technical content.
• Extracted data from the ECC system to BI. Created process chains on daily and As needed Loads.

Client: Confidential,Bannock Burn IL Sep 2006 – Mar2007
Role: SAP BI Consultant (Onsite Support)
Environment: SAP BI 7.0, SAP ECC 6.0

Responsibilities:

• Involved in extensively Onsite Support for the Client by coordinating with offshore team.
• Performed Daily Monitoring and Maintenance of Performance of Process chains.
• Performed Data load Monitoring and ongoing Maintenance.
• Identified Production problems, Issues. Suggested Fixes.
• Besides Production support Uploaded master and transactional data from flat file and SAP R/3 as the OLTP source.
• Created Info packages for initial, full and delta uploads for both master data and transactional data.
• Developed basic cubes for Customer and Quotations, Created aggregates and indexes for Info Cubes to improve the query performance.
• Extensively used BEx Analyzer, created queries MM data targets.
• Loaded business content, and performed activation of SAP supplied Info Objects.
• Extensively used Process Chains to automate data loading process.
• Transported the objects from Development to QA and then to Production.

Client: Confidential,CA Jan 2004 – July 2006
Role: SAP BW Developer
Environment: SAP BW 3.0B, SAP R/3 4.6C

Responsibilities:

• Involved in Analysis, design, development of Info cubes and ODS objects
• Enhanced the update rules for COPA Info Cube to meet the new business requirements for Total Discounts, Gross Trade Sales and Net Sales
• Developed Info objects, Info cubes, ODS, transfer rules, communication structure, update rules and Info packages
• Involved in performance tuning by maintaining aggregates, compression, partitioning, indexing of info cubes and use of statistics for the same
• Worked on info cubes to analyze the accounts receivable transaction figures and line items for the customers.
• Used ODS objects to stage the data before transferring the ODS object contents to the Info Cube.
• Uploaded master data and transactional data from files and SAP R/3 as the OLTP source.
• Using Business Explorer (BEx) created custom queries based on the detailed query and business requirement
• Used Filtering, Conditions, Variables, and Navigational Attributes.
• Created queries, reports, Workbooks and web-reports on Bex Analyzer and posting of reports on the web/portal with drill down and execution capabilities.
• Created variables calculated key figures, formulas and structures in query development, working with workbooks, exception reporting, and conditional reporting.

Education: B.Tech (Bachelors’ of Technology) Mechanical Engineering