SUMMARY

• Over Seven years of professional experience in design, development and implementation of business applications which includes six years of and 5 years of Business Objects 7 years of experience in IT specifically Business Objects 4.0, XI R3.0/R2/6.X, Business Objects Designer, Info View and Web - Intelligence and five years of SAP BW/BI Net weaver 7.x, BW 3.5
• Involved in 2 Full life cycle implementation and provided key services such as data modelling, design support, and data management as well as cross-functional technical design.
• In depth understanding of SAP R/3 functionality (SD, AR, MM, PM), Standard Business Contents and Data Modeling (like the star schema and the flat structure) in Sap BI/BW.
• Maintained extract structures for Purchasing, Inventory and Sales & Distribution (Sales, Delivery, Pricing, and Shipping).
• Experience in advance reporting using Business Objects (Reporter, Designer, Web Intelligence Rich Client/Thin Client).
• Well versed in Dimensional modeling (Star Schema/Extended Star Schema, Snowflake Schema).
• Good understanding of Data Warehouse concepts, terms and technologies involved in Information Management.
• Developed Universes and multiple reports using Information Design Tool and web intelligence in SAP Business Objects 4.0
• Strong Universe Designing skills. Created Multi Source Universes based on SAP and Non-SAP systems.
• Extracted data using BW extraction structures such as LO Cockpit, CO-PA, and Generic & Standard Extractors.
• Well experienced in Data warehousing concepts, Designing effective client specific BW systems, Data Modeling, Data Extraction and Data loading for both application specific as well as generic from R/3, ECC, and Non SAP systems like Oracle and other legacy systems.
• Extensively worked with Basic Infocubes, DSOs, Multi Providers, Infosets, Data validation and error- handling, Start routines, Transformations, DTP’s.
• Strong ABAP programming, analytical, problem solving, and debugging skills.
• Developed various transformations to cleanse the data and enhance the master and transaction data using Formula Builder and start, end and transfer routines with ABAP to suit the business requirements.
• Created DTPs, Info packages for Full, Initial, Early, Delta and Full repair loads for both Master data and Transaction data.
• Expertise in Data Source enhancements like Loading, Scheduling, Monitoring, Process Chains Maintenance, Reporting, Enterprise and Portal Integration.
• Enhanced the Business Content data sources and extended the structures using user exits to support the business needs.
• Created various types of customer exit variables for BeX query designer and populated these variables using Enhanced user exits.
• Expertise in the front end business warehouse components like BEX analyzer, Query designer, Universe, Web Application Designer, Web Reports, WEBI, XCelsius (Dash Boards).
• Expertise in Business Objects 4.0, XI 3.1/XI R2, Universe Designer, Information Design Tool, Import wizard, Publishing Wizard, Business Views, Desktop Intelligence, Xcelsius/Dashboard Designs, Crystal Reports 2011/2008 and Web Intelligence.
• Expertise in Designing, Building and Maintaining the Universes, resolving the issues like loops and Traps using Alias and Context, designing complex objects using @prompt, @select,@ Aggregate aware function & Cascaded List of Values.
• Extensively used Calculations, Variables, Prompts, and Sorted inputs, Drill down, Slice and Dice, Alerts, Input Controls, Tracking Changes, Sorting and Ranking for creating interactive reports.
• Experienced in creation of Authorizations, Roles/Profiles based on the Client Business Model.
• Experience in QA Life Cycle, including preparing Test Cases and testing the developed programs (Unit testing, Integration testing, Regression testing, System testing).
• Experience in documenting technical functional specifications, test cases and provided extensive post go-live support.
• Positive attitude and very open minded in Sharing and transferring the technical as well as the business knowledge to peers and other project members.

TECHNICAL SKILLS

Modeling Tools: SAP BW

ERP: SAP ECC 7.0, 6.0, R/3 4.6C/ 4.6B/ 4.5B, FI/CO.

Reporting Tools: Business Explorer, Business Objects Webi, Dashboards

Database: SQL Server 2005/2008, MS Access, Oracle 8i/9i/10g.

Programming Languages: ABAP/4, C, PL/SQL.

Platforms: UNIX, Win 98/XP/2000/NT, DOS, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Syracuse, NY

Sr. SAP BW/BO Consultant

Responsibilities:

• Created various BW backend objects which includes real time cubes, Basic cubes, DSOs, Datasources, Infosources, Transformations, DTPs, Open hub spokes and Process chains.
• Worked on Upgrade from BW 7.0 to BW 7.3.
• Developed DTPs and Infopackages and created various routines with ABAP for the selections.
• Extensively performed huge data loads into DSO and Infocubes from ECC as well as the legacy systems.
• Created Process chains for parallel data loads, and scheduled them at off-peak hours to reduce the system load.
• Extensively worked on BEX Query designer, Analyzer, WAD and Report designer.
• Developed Queries to access data from various BW Infoproviders like ODS, Infocubes, Infoobjects, Multiproviders and Infosets using BEx query designer.
• Created BEX Queries using Filters, Structures, Restricted key figures, Calculated key figures, Conditions, Exceptions, Variables.
• Created various Customer exit variables to support the queries. Used ABAP in the enhancements to fill these variables
• Created 38 complex Bex queries on the Multiproviders for sales analytics.
• Extensively worked on SAP Business Objects, Xcelsius, Crystal reports, WEBI, Analysis for OLAP.
• Created universes using Information design tool(IDT) on top of Bex queries and Non-Sap Sources.
• Created Advance multiple Reports, Ad hoc query, tables, charts using WEBI.
• Created different types of reports (Crystal, WEBI) such as Master/Detail, Top N Reports for highlighting significant data.
• Deployed BO Reports/Dashboards in SAP Enterprise Portal.
• Created various transports, collected the required objects and migrated to the target systems.
• Involved in Unit and QA testing and performed the tuning to improve the query as well as the loading performance.

Environment: SAP BW 7.0, SAP BO 4.0, SAP ECC 7.0, Crystal Reports, Web Intelligence, Xcelsius/Dashboards, IDT, Enterprise Portal, Info view, ABAP.

Confidential

Sr. SAP BW Consultant

Responsibilities:

• Involved in full life cycle implementation, right from requirement gathering, blue printing, development, testing, go-live and post go-live support.
• Participated in design reviews, spec reviews, code reviews, test plan reviews.
• Extracted data from SAP R/3 using LO Cockpit, Generic and Business Content Extractors.
• Activated the Business Content for FI-AP, FI-CO, FI-AR, SD, PP, MM & Purchasing Data sources.
• Configured General Ledger Accounting (FI-G/L), New G/L, Accounts Payable (FI-AP), Accounts Receivable (FI-AR).
• Controlling experience includes Cost Center Accounting (CO-CCA), Internal Orders (CO-IO), Profitability Analysis (CO-PA), and Profit Center Accounting (CO-PCA).
• Designed and developed various Data targets and Infoproviders like DSO (ODS), Infocubes, Info objects, Multiproviders and Infosets using Admin workbench.
• Populated various data targets like Infoobjects, ODS and Infocubes, with Master data and Transactional data from ECC, Oracle using DB Connect.
• Understanding on various functional processes like SD, AR, MM.
• Maintained extract structures for Purchasing, Inventory and Sales & Distribution (Sales, Delivery, Pricing, and Shipping).
• Extensively performed data loads into DSO and Infocubes from ECC as well as the legacy systems.
• Used ABAP Routines in the Transformation to meet customer requirements.
• Experience in writing ABAP for complex routines in Start Routine, End Routine, Rule types and Formulas.
• Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, init fills, roll up, attribute change run and DBstats etc.,
• Expert in Report generation and extensively worked on BEx Analyzer, Query Designer
• Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures.
• Proficient in Business Objects Reporting using Web Intelligence, Crystal Reports, WEBI Rich Client, Live Office and Xcelsius/Dashboards for both SAP and Non SAP sources.
• Worked on creating Universe using Universe Designer/Information Design Tool from various Source Systems and exporting them onto Info view/BI Launch Pad.
• Designed and Built the Universes, Classes and Objects and checked the Cardinalities on OLTP sources.
• Strong knowledge In creating connections using Data Connection manager like Live Office, Query As A Web Service (QAAWS), Flash Variables, SAP BI connectors, UD connecters, DB connectors.
• Created UNX Universes, UNV Universes, WEBI Reports on BEX Queries.
• Performance troubleshooting existing user roles, security objects and authorizations to resolve security conflicts.
• Supporting users at different levels for the security issues in different modules.
• Worked on production support issues like data reloads as required, fixing bugs. Resolved issues connected with running the query.
• Documented functional specifications, technical specifications, test cases, performed unit testing, UAT and supported the project after go-live by assisting users and resolving bugs.

Environment: SAPBW 7.0, BW 7.3, R/3, SAP ECC 7.0, Business Objects XI R/3 SP4, and Business Objects 4.0, Crystal Reports 2008, Dashboard / Performance Manager, Web Intelligence XI 3.1 Info view, CMC, universe designer, BI launch pad, Information Design Tool, ABAP.