PROFESSIONAL SUMMARY:

• SAP Certified SAP BI/BW Solutions Architect with SAP BW HANA implementation Experience.
• 12+ years of SAP BI Data Warehousing ( ), 19 years of IT experience ( ) IT experience in Design and Development of Business Intelligence Solutions primarily using SAP product suite.
• Six full cycle implementations experience - Blueprint to production support, Working Fortune 500 clients and with SAP America and SAP Partners.
• Has extensive knowledge in Back-end data modeling, Front-end Development and ASAP Methodology
• SAP Functional exposure to SD, MM-IM, FI and PP modules.
• Possessing thorough understanding of Business Objects development tools including Information Design Tool, Universe Design Tool, Web Intelligence, and Crystal Reports for Enterprise, Crystal Reports 2008/2011, Dashboards/Xcelsius, and Analysis for OLAP/Office, Explorer & Lumira.
• Creating complex ad-hoc Reports using Business Warehouse, Business Objects Web Intelligence.
• Experience in Data Analysis, Dimensional Data Modelling (Snow Flake and Star Schema), End User Reporting, Web based Reporting & Implementation, Creating Test scripts and user signoff documents.
• Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, and Web application designer.
• Assist in large-scale SAP Business Objects platform migrations and upgrades.
• Devise Business Objects Governance, backup and Dara Recovery strategy.
• Good understanding of BW platform security concepts: Access Levels, Data security profiles, Row level and Object level security.
• Proficient in Business Objects report distribution methods: Scheduling and Publication.
• Understanding user/business requirements, designing the functional specification document and implementing the technical code.
• Experienced working with databases like Teradata,SAP BW, IBM DB2, Oracle, MS SQL Server.
• Excellent communication, interpersonal, analytical and technical skills with a strong result oriented approach to problem solving.
• Having good knowledge on performing ETL Based replications in SAP Business Objects Data Services from SAP, Non-SAP & File Systems into HANA Database.
• Strong Knowledge on Data Provisioning techniques to bring Source Objects to HANA Data Base from SAP & Non-SAP Sources.
• Extensively used Business objects ETL tools such as Data services Designer, Data services Server Manager, Data services Repository Manager, and Data services Management Console in developing the data models.
• Good exposure on HANA which includes Data Provisioning, Data Replication, Modeling, Reporting, Information Composer.

TECHNICAL SKILLS:

Environment: Business Information Warehouse BI 7.0 NW2004S, BW 3.5, 3.0bSAP R/3 4.7, 4.6c, 4.6b, 4.5b, ECC, Solution ManagerReporting & Portals: SAP Enterprise Portals 5.0 SP3/SP4, BEX Analyzer, BEX WEB, Web Application Designer WAD, Report Agent, Business Explorer

OLAP Tools:: SAP BW, BEX Analyzer, BEX WEB and WAD BEx Analyzer, BEx WEB, WAD, Basic ABAP/4, User Exits

RDBMS: Oracle 8i, Oracle client 8.0.1, SQL 2000, Supra, Sybase, DB2

Tools: and Utilities: Assential Datastage, Tivoli, Mercury/HP Quality center, TOAD, Crystal Reports, JDBC, ODBC, OLE DB, MS VISIO, MS PROJECTSAP BW BISAP BI 3.5/7.0/7.3/7.4 , IP, BPC EPM 10 BW Integration

ERP: SAP R/3 4.7/4.6, ECC 6.0HANAHANA 1.0 SP SP04 09, Flat files /SLT / DCX

Languages: ABAP/4, C, C++, JavaScript, HTML, HTML 5, SQL, SQL Script

ABAP: Customer modifications, Function Modules, Update Rules and Transfer Rules reports, BADIs

Web: Dynpro Applications, BSP Applications

PROFESSIONAL EXPERIENCE:

Sr. BI Consultant

Confidential - San Diego CA

Responsibilities:

• HANA Migration from SAP BI 7.3 to 7.4 SPS5 HANA
• Data clean up, system prep
• Upgrade related housekeeping activities
• System migration
• Data quality check between HANA and Older BW System
• Conversion of reports
• Consolidate Sales and distribution system reports - simplified model
• Design simplification - Technical Specifications, Reduced Layer BI modeling, Development, Deployment and user-signoff of BI/BW solutions supporting
• Developed, converted and tested SAP BW Datasources, HANA optimized Infocubes, DSOs, HANA Composite providers, Transformations
• Analysis Workbooks to meet technical specifications and business requirements.
• Assist in development of a current and future state architectural roadmaps that ensures initiatives are aligned with the goals of the business and projects are completed with the highest level of quality.
• Manage change requests and do impact analysis on the Data Warehouse and OLAP, working with stakeholders to do upstream and downstream analysis.
• Coordinated Transport activities
• Gather and articulate business and information requirements from business analysts across the various functional and business areas.
• Analyze and assess the impact of production system changes and new business requirements to the existing data architecture.
• Ensure that systems are developed that use reliable fact data and consistent dimensions.
• Collaborate with the BI Architecture team, business analysts and application developers to develop a high availability operational data store and data warehouse environment.

Sr. BI Sr Consultant

Confidential, Phoenix AZ

Responsibilities:

• Attended Blueprint Workshops, collected reporting requirements, Legacy to ECC Business Process Mapping, Translation from legacy to SAP terminology
• Developed Prototypes, Activated Business Contents and Customized them
• Define Reporting Strategy, Delivery methods and Initial s
• Business Objects - Create Excelsius Dashboard - defining Standards
• Configured Backend - LO, Custom DataSources and InfoProviders for Sand Distribution (Quote to Cash) and Service orders.
• SAP BW HANA Implementation, redesign and removing InfoCubes and replacing DSOs as InfoProviders.

Sr. BI Consultant

Confidential, Dunwoody Gorgia

Responsibilities:

• Designed logical partitions for regional data and implemented Localization options for non standard process. Logical and Physical partition on Multi Bottler solution environment
• Enhanced Standard Logistics Cockpit LO extractors in Production planning area.
• Production Efficiency
• Scrap and empties planning
• Enrich production order data with Machine and environment information
• Addition of new fields, enhance extract structure, populating fields with look-up routines
• Created Management Dashboards using Query views, Web templates.
• Performance tuning existing queries.
• Developed simple Business objects evaluation prototypes, integration to BI, Desktop Intelligence, Integration Toolkit transport imports.

Sr. Consultant

Confidential

Responsibilities:

• Analyzed the Upgrade Scope Prepared Upgrade Plan, coordinated Change control process
• Prepared the system for Migration - Consistency checks, Check lists, Standards
• Performed Functional part of the Upgrade, post upgrade activities
• Completed Technical configuration
• Performance tuned the system for upgrade optimization
• Conducted Go Live verification check
• Prepared Early watch report, analysis
• Coordinated Testing, modified test plan, cases for upgrade
• Trained Business analysts, end users on the new tools
• Supported Post Upgrade, Go-live phases
• Retrofit parallel development objects using Query Designer, BEx Analyzer, Web Application Designer - Web templates
• Data Modeling of the new modules
• DataSource Customization - Custom Extractors - Phase II
• Converted Dataflow to new concept, Eliminated InfoSources
• Rescheduled process chains for optimal performance
• Functional:
• Enhance FI datasources - General Ledger (FI-GL), Profit Center account (PCA), Cost Center(CCA)
• Optimize Financial data extractions - Minute based extractions
• Custom extractors - Data Extraction from External /Non-SAP systems
• Financial Data - Logical Partition for Archival
• Operational reports and users.
• New Master data extraction design
• Data Distribution using Open hub
• Data Retraction for FI Consolidation

Environment: BI 7.0, ECC 6

Sr. Consultant

Confidential, Federal Way, WA

Responsibilities:

• Analyze the existing business process
• Collect, document and manage BI requirements
• Blueprint activities, Gap Analysis,
• Design BI solution
• Prototype Development
• Technical Configuration
• Testing co-ordination, implementation
• Business Analysts, End user
• Go-live support
• Technical tasks overview
• Solution manager - Documentation, Blueprint
• Business content analysis
• BCT customization
• Implement Logistics Cockpit LO extractors for Logistics - PP module
• Including Fields
• Populating them using user Exits
• Validation using R/3 Transactions
• Extract Checker
• Performance improvement on Lookup
• Defining Secondary Keys on R.3
• Design and implement Enterprise Data warehousing layers
• UoM conversions in Transformations
• UoM conversion during report run time
• APD - Analysis process designer
• OpenHub using IBM Datastage
• Custom extractors for Dunn and Bradstreet external system
• Job scheduling -Process chains and Tivoli
• Open Hub
• BIA
• Runtime Analysis, Performance tuning
• Publish Reports - BI Portal
• Upgrade from BI 3.5 to 7.0
• Basic ABAP - Transformations, BEx Variables
• Mercury Quality Center to document testing
• Production support, Issue analysis
• SAP BI Authorizations setup for Authors, Analysts, consumers

Environment: BI 7.0, ECC 6

BW Consultant

Confidential, Palo Alto CA

Responsibilities:

• Developed Web Reporting, Web Application designer, Pre-calculated Web templates
• Gather and interpret their documented reporting requirements
• Data extraction from R/3 and flat file, Creating Info packages, Scheduling and Monitoring.
• Set up procedure for extracting R/3 data for SD using LO-cockpit and into InfoCube.
• Modified standard and created custom Info Source/Data Source, ODS, and Info Cubes
• InfoPackages by using after jobs & after events.
• Generated reports using BEx Analyzer, RRIs.
• Created queries using variables restricted Key figures, filters, exceptions, conditions and free characteristics.
• Fine Tuned performance by creating info cube partitions and creating aggregates.
• Efficient in handling the support problems after going live.
• Analyzed Query performance, post-production Support- and preparing manuals for end users.

Environment: BW 3.0B, R/3 4.6C, BEx, WAD, WAS

BW Consultant

Confidential, Springfield AR

Responsibilities:

• Business Blueprint development
• Estimation of components, defining phases
• Workshops, Demos for Core business initial
• Requirement Gathering
• Business and Technical Analysis
• Business Content analysis
• Realization

Environment: BW 3.0, CRM 4.0, R/3 4.6C, BEx, WAD, WAS