SUMMARY

• A multi-faceted SAP Consultant with 8 years of techno-functional expertise in SAP with specialization in SAP NetWeaver BI / BW and BO.
• Strong in all aspects of BI: BI data modeling, data staging and Activating & Enhancing standard Business Content, scheduling and process chains Partitioning & Compression, OLAP Cache, secondary Indices, Pre-calculations etc.
• Upgrade Experience in SAPBW from 3.5 to BI 7.x and in depth knowledge of migrating data sources from BW 3.5 to BI 7.x and maintaining Transformations and DTPs.
• Strong experience in various phases of project including analysis, blueprinting, design, development, configuration, testing, documentation, and end-user training.
• Proficient in Data Extraction from SAP R/3 (FI/CO, MM, SD, PM and QM), flat files and BW using extraction structures such as LIS, LO Cockpit, CO-PA, FI and Generic Extractors.
• Expertise in the front end business warehouse components like BEx analyzer, Query designer, Web Application Designer, Web Reports, WEBI, Xcelsius and Dash Boards.
• Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques.
• Extensively used Calculations, Variables, Prompts, Sorted inputs, Drill down, slice and Dice, Alerts for creating Business objects reports.
• Good exposure and knowledge of SAP modules such as FICO, CRM, HR, MM, PP, SD.
• Excellent in creating WEBI reports and Crystal reports and deploying them through Info view with BWuniverse as source and creating Inventory accuracy dash boards using Xcelsius.
• Expertise in designing, developing and deploying using Universe designer, web intelligence, desktop intelligence, info view, CMC, Workbooks.
• Extensive experience in creating reports with Charts (bar chart, Pie chart...etc), cross tabs and sub reports.
• Created advance analytics like speedometers, interactive metric trends to gauge the performance of the key businesses and enabled dynamic report linking by passing variables (prompts) between reports.
• Strong experience with resolving performance issues in crystal reports and excellent with unit testing, system integration testing, and user acceptance testing at various levels.
• Excellent team player with good logical reasoning ability, coordination and interpersonal skills.
• Solid communication skills have always been an asset in completing business venture and projects with success.

Skills
Primary Skills: BI 7.3/7.0, BW 3.5/3.1c/3.0b, SAP R/3 ECC 6.0,5.0,4.7E/4.6C
Secondary Skills: FI/CO, Logistics (SD, MM, PP) CRM, SRM, QM, HR, SCM, COPA, MS Excel,VBA
Languages: ABAP/4, C, C++,PL/SQL
Web Servers: IIS 5.0/6.0/7.0
Database: SQL Server 2000/2005, Oracle 8i/9i/10g, MySQL, MS ACCESS.
Operating Systems: Windows 95/98/NT/2000/XP/Vista, Windows 2000/2003 Server, MS-DOS, UNIX, LINUX
Reporting Tools: BEx Analyzer, Crystal Reports, Xcelsius 2008, WEBI, DESKI, Cognos, BO 4.0
Dashboards, MS-Excel.

PROFESSIONAL EXPERTISE

Client: Confidential (Palo Alto CA) May 2012 to Present

Role: BI/BO Consultant
Environment: Business Objects XI4.0/XIr3.1, SAP BI 7.3, SD, MM, PP, HR, FI, SAP ECC 6.0, Crystal Reports XIR2/2008, Xcelsius 2008, Designer, WebI, Publication Wizard, Import Wizard, Dashboard Manager, Web Intelligence and Info View, Windows XP, server 2003.

Industry: The Electric Power Research Institute (EPRI) is an independent, non-profit company performing research, development and demonstration in the electricity sector for the benefit of the public.

Contribution:

• Involved in the Full life cycle implementation, right from requirement gathering to Go-live.
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Assisted Client's process teams for writing reports and performing Ad hoc Queries.

Responsibilities:

• Data Extraction from SAP FI, MM, SD, PP and HR of SAP R/3.
• Worked extensively on LO Cockpit. Loaded the data from R/3 to BW and used Initialization with Delta Update and Full Update methods.
• Involved in Activating Business Content for Standard Info Cubes, ODS objects, Info Sources and Info Objects of FI, SD and MM module.
• Worked with Info Cubes like Sales Overview, Delivery Services, purchase order and Info Sources like Sales Order and Delivery.
• Created BW Objects, Update rules and Info Packages, Data Targets and Multi providers in accordance to the application.
• Involved in building logistics reports and applying functions based on requirements.
• Built and distributed functional specification documents to BO developers and Business users across the organization.
• Analyzed existing database and designed Universe
• Created Classes, Dimension objects, Measure objects and Detail objects in the universe
• Analyzed data using Slice/Dice and Drill Mode
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts
• Created and published various reports through Web Intelligence, Info view portal
• Synchronized data from multiple data sources in Web Intelligence
• Used various @functions i.e. @Select, @Prompt, @Where in the Designer for different report creation
• Created dashboards using Xcelsius 2008.
• Created Ad-hoc and standard reports using functionalities such as Multiple Data Providers, Merge Dimensions, Master/Detail, Cross tab, Multi Dimensional Analysis, Drill Analysis, Scope of Analysis, Filters, Charts, Alerts, Breaks, Ranking, Sorting, LOV, Formulas, Variables, Sub Queries, Combined Queries (Union, Intersection, Minus).
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies. Used various functions such as @Aggregate aware, @prompt, @select, LOV's, Index Awareness, Custom Hierarchies etc.,in Designer.
• Updated and maintained Universes based on changing user requirements and data source changes
• Interacted with Business users, Business Analysts to understand and document the requirements and transform them into technical specifications.
• Experienced with Multiple Relational Databases including Oracle, MS SQL Server, MS Access and DB2.
• Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports as per user requirements. Scheduled recurring daily, weekly and monthly reports.
• Assigned privileges to users and user groups to access and work with universes and reports
• Created templates to standardize the structure of corporate documents.
• Designed and developed Dashboard to provide visibility, alignment and insight across the enterprise.

Client: Confidential (Thousand Oaks, CA) Apr 2011 to May 2012

Role: BI/BO Consultant
Environment: SAP BI 7.3, SAP ECC 6.0, SAP BO 4.0/3.1.

Industry: Amgen discovers, develops, manufactures and delivers innovative human therapeutics. It is biotechnology Pioneer since1980.

Contribution:

• Full life cycle implementation, which involve Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Worked along with the Clients process teams in identifying and documenting necessary KPI and reporting requirements to build a reporting architecture.
• Modeling:
• Built and enhanced BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set.
• Data Source Objects are created for staging for AP, AR line item data, multi cubes and Infosets are created to satisfy reporting requirements.
• Enhanced CO-PA and FI cubes such as 0FIAR_C02, 0FIAR_C03, and 0FIAP_C03 with proper transfer rules and update rules.
• Activated Business Content for Accounts payable (AP), Accounts Receivable (AR), Profitability Analysis (PA), General Ledger (GL), Special Ledger (SL), Purchasing (MM), Cost Center Accounting (CO-CA), CRM activity items cube and customized them as per the client requirement.
• ABAP programs are used to populate user exit variables.
  
• Reporting:
• Integrated BO with SAP ECC and SAP BI 7.3 to build Universes.
• Used BICS connections to make Webi, Analysis for OLAP reports.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Developed Business Objects Universes with classes, objects and condition objects.
  Hierarchies are implemented to support drill down reports.
• Customized queries using navigational attributes and filters in BEx analyzer and used customer exits as per client requirements.
• Using complex queries reports are created where universe is the main data provider for reporting.
• Several complexes-cross tab reports and sub-reports are published using Crystal Reports and Business Objects Reporter.
• Designed reporting templates with BEx Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition. Designed, developed, performed testing and implemented Crystal Reports, Webi, Xcelsius (Dashboards). Cross tab and Drill down options are enabled using Crystal Reports.
• Xcelsius dashboards are created on top of crystal reports and live office. Webi Reports have been created deployed through Info View.
• Worked in QaaWS to create connections between Webi and Xcelsius Dashboards.
• Trouble shooting and tuning of the reports.
• Assisted end users writing reports and performing Ad hoc Queries.

Client: Confidential (MO, St. Louis) Feb 2010 to Mar 2011
Role: Senior SAP BI/BO Consultant
Environment:SAP BI/BW 3.5/7.0, SAP ECC 6.0, FI-AR, FI-AP, FI-GL, FI-SL, MM,SD,MTO, CRM, COPA,SCM, HCM, HR, BEx Analyzer, Query Designer, Open Hub, Xcelsius, WebI, Crystal Reports, WAD.

Contribution:

• Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Report development on manufacturing modules like MM, PP, QM and integration experience with FICO.
• Created many complex and customized SD (Order to Cash OTC) reports which specific business requirements.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets, Time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP) etc.
• Designed, developed and implemented Crystal Reports, Webi, Xcelsius(Dashboards).

Client:Confidential, MN Nov 2008 to Dec 2009
Role:SAP BI Consultant

Environment: SAP BI-7, SD,MM, FIAR, FIAP, FIGL, HR,SAP R/3 ECC 6.0, Business explorer, Web application designer, Portal, Business Objects XI , Pharmaceutical industry.
Contribution:

• Involved in Production Support stages of the Full lifecycle Project implementation from Blue print to go-live.
• Created multiple BEx Reports based on user requirements in sales, delivery, billing & customer analysis Reports.
• Created Web Intelligence reports using Business Objects WEBI.
• Generated the BEx Query reports in crystal report Designer.

Role:SAP BI Consultant
Environment: SAP BI-7, SD, FI,HR, SAP R/3 ECC5, Business explorer, Web application designer, Portal, Business Objects and Crystal reports, Retail Industry.

Contribution:

• Developed flexible queries using filters, Free Characteristics, Navigational attributes in BEx analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels.
• Fixed and modified the existing reports according to the user enhancements.
• Created Cross-tab, Sub-reports and drill down reports using Crystal reporting tool.
• Used Crystal Xcelsius for Dashboard reporting needs with Query as a Web service as source.

Client: Confidential (NJ) Mar 2006 to Jan 2007
Role: BW Consultant

Environment:SAP R/3 3.1C, SAP BW 3.5, ABAP/4
Contribution:

• Solution furnished client with capability to track production, order time, utilization, efficiency and attainment by work centers. Orders with an inventory adjustment were also tracked.
• Configured classification extractor to enhance Work Center business content InfoObject.

Client: Confidential, Daman, India Nov 2004 to Feb 2006
Role: SAP BW Analyst

Environment:SAP R/3 3.1C, SAP BW 3.1C, ABAP/4,Oracle 9i

Contribution:

Designed Physical and Logical data models, Created BW objects (InfoSources, InfoObjects, ODS Cubes, InfoSets, MultiProviders, Transfer/update rules and process chains).Created multiple queries for P/L and sales reporting. Defining query in BEx analyzer and presenting the result in workbook and integratingthe workbook with BEx Browser.