SUMMARY:

• Sr. SAP BW/BI, HANA and BOBJ Consultant with hands on experience on various full life cycle (FLC) implementations of SAP BI and SAP ABAP projects and has 10+yrs of strong working experience in SAP BI 7.0, 7.3, 7.4 BOBJ NW2004S, 6+ years of ABAP programming expertise in SAP R/3 ECC6 both in different functional areas like Sales and distribution (S&D), Material management (MM), Inventory Management (IM), Financial (FI), Controlling (CO).
• Has experience in both Front end BEx reporting and modeling includes ETL (LO Cockpit and Generic extraction, data modeling, extensively experienced using Administrator workbench tools for designing and development of Info cubes, DSO's (Standard, Direct Update, Write Optimized), ADSO, Composite Provider, Semantic Partitioned Object (SPO), Info Sources, Info Objects, Transformations, Data transfer Process (DTP), Analysis Process Designer (APD) and Data sources, and enhancements for the existing data sources.
• SLT: replication, table configuration(filters, structure modification, ABAP complex exit specially for STXL table.
• Extraction: Data Extraction (ETL) from SAP Sources using LO - Cockpit and Generic Extractors, and from Non - SAP Sources using Flat Files and Data Services 4.0. Automated data loads using process chains or Data Services jobs.
• Performance Tuning: Created Aggregates, Partitions, Info Cube Compression, Indexes and line item dimensions for better performance for queries and data load.
• Experienced in business processes across the Functional modules SD, MM and FICO.
• Experience working on Business Objects 4.0, CMC, Information Designer tool, Business Intelligence Consumer Services (BICS), Web Intelligence 4.0, Crystal Reports 2001, Good understanding of BEX.
• Experienced in Business Explorer Suite - BEx Query Designer, BEx Analyzer and BEx Web Analyzer.
• Experienced in using Information design tool (IDT), to create universes using multiple Data Sources.
• Created connections to BEx queries and BW Info providers using Business Intelligence Consumer Services (BICS) in IDT
• Excellent skills to develop reports using Web Intelligence Rich Client 4.0.
• Developed WEBI reports on SAP BW Queries using BICS.
• Modified BW queries in to generate WEBI reports in BO to meet user requirements.
• Proficient in Business Objects Reporting using Crystal Reports, WEBI Rich Client 4.0 for both SAP and Non SAP sources.
• Experienced in Business Objects reporting (BOBJ 4.0) in creation of universes using Information designer tool, Info views, Webi Reports using webi reporting tool and crystal reports has a good knowledge in BOBJ administration using the tool CMC (central Management Console) like creating and managing repositories, monitoring/granting, permissions and rights to users, user groups through Central Management Server.
• Experienced in SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views
• Experienced in SAP HANA Data Modeling with Variable/Input Parameter, Filters and Calculated Column
• Experienced in SAP HANA Data Modeling using Stored Procedure and Table Function
• Experienced in SAP HANA Data Provisioning using SLT (SAP Landscape Transformation) with ABAP transformation, SDA (Smart Data Access), ODP (Operational Data Provisioning)
• Experienced in Analysis for Microsoft Excel Reporting Tool.
• Experienced n Business Objects reporting (BOBJ 4.0) using BI launch pad getting data from different databases including HANA
• Extensively used Business Objects Reporting functionalities such as Aliases, Context, Slice and dice, Drilling Methodology, Filters, Sorts, Ranking Sections, Variables, Relative Position, Merge, Link, Input Control, Graphs, Query Prompts and Breaks.
• Experienced in developing Dashboards using Dashboard manager.
• Experienced in developing ABAP RICEF (REPORTS, INTERFACES, CONVERSIONS, ENHANCEMENTS, FORMS) which includes ALV, ALE, IDOCS, BDC, BAPI, USER EXIT, CUSTOMER EXIT, SAP SCRIPT, SMART FORMS .
• Experience in Unit testing which included data validation, data integrity, functional testing, integration testing, regression testing and system testing, post production support.
• Experience in SAP EC (Environmental Compliance) configuration List Of Value (LOV), User Define Field (UDF), Element and Facility Hierarchy. Activation of SAP EC standard business content such as Facility, Task, Exception, Measurement and Limits.
• Proven Leaderships skills with the ability to organize complex projects, defining project priorities, build and manage teams with efficient processes and communication protocols. Highly motivated and ability to handle the issues independently communicating with the cross functional for its needs to develop and rebuild and improve the current existing system, eager to learn and take on greater responsibility.

TECHNICAL EXPERTISE

• SAP Business Warehouse 3.5 and BI 7.0, 7.3, 7.4
• Business Information Warehouse Administrator Workbench
• Datasource Configuration and Extractors in SAP R/3 systems
• Datasource setup from Flat file systems (i.e. file server, third - party customized Databases)
• SAP-R3 IMG Configuration for BW extraction from R3
• SAP-BW Data Modeling (InfoObjects, InfoSources, InfoProviders, DataSources)
• LO Cockpit Analysis and Solution
• Extraction Transformation and Loading (ETL) Strategy
• Business Explorer
• Web Reports
• Transport Management
• Upgrade to BI 7.0 Analysis of Scope and Implementation
• Integration Testing of BI 7.0 Migrated objects
• BI 7.3 Analysis Process Designer (APD) to Direct Update DSO and other Source and Target Objects
• BI 7.3 Semantic Partitioned Object (SPO)
• BI 7.3 DSO's (Standard, Direct Update and Write Optimized)
• BI 7.3 Data Flows
• BI 7.4 ADSO, Composite Provider
• Conversion of Bex Reports
• Design Bex queries and Web reports
• Create Bex RRI report
• Activate, configure and initialized Business Content Extractors for Logistics, Sales and Finance in ECC side
• DB View, SAP Query and Function Module custom extractor creation
• OLAP Universe using Business Objects Enterprise
• Open Hub Destination
• Business Intelligence Tools Business Objects CCM, Information Design Tool, Business Intelligence Consumer Services (BICS), Web Intelligence 4.0, Business Intelligence Services (BIWS), BI Launchpad, Query Designer, CrystalReports, Bex Query Analyzer
• Analysis for Microsoft Excel Reporting tool (AO)
• Universes using Information Design Tool (IDT)
• Data Services
• Data modeling: SAP HANA Studio
• SLT replication, table configuration(filters, structure modification), ABAP ETL exit.
• Having strong knowledge on SAP HANA Studio and WEB IDE
• Create SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views
• Create and Modify SAP HANA custom tables
• Create/Configure SAP HANA Data Provisioning using SLT (SAP Landscape Transformation) with ABAP transformation
• Create/Configure SAP HANA Data Provisioning using ODP (Operational Data Provisioning)
• Create/Configure SAP HANA Data Provisioning using SDA (Smart Data Access)
• Create SAP HANA Stored Procedure and Table Function
• Create SAP HANA Decision Table
• Good exposure on Schemas, table definitions, Attributes, Measures and Hierarchy in HANA
• Activation of Standard Business Content for SAP EC
• Configure SAP EC Extractors
• Configure SAP EC List of Value (LOV), Element, User Define Field (UDF)
• Configure SAP EC Facility Hierarchy
• Create Data Source SQL statement for EC table view
• Online/Modular programming
• Batch Input Recording (BDC)
• Table Control
• FTP
• Table maintenance event
• ABAP Report programs
• ALV Report programs
• Call Transaction
• SAP Scripts
• Smartforms
• BAPI
• Upload and Download programs
• Database Updates
• Function Module programs
• Performance Tuning
• ABAP Events and Modification
• SAP Users Authorization
• IDOC
• LSMW
• Macros

PROFESSIONAL EXPERIENCE:

Senior IT Software Engineer

Confidential, San Diego, CA

Responsibilities:

• Handles all SAP HANA Data Provisioning using SLT configuration, transformation and loading/replication
• Support and develops HANA objects
• Designs and develops customer requirements for BW and ABAP
• Developed a set of Bex reports based on user requirements for BO Web Intelligence reporting
• Create, Modify Web Intelligence reports
• Support user in validating report with ECC Dassian snapshots data
• Provides assistance to users
• Responsible for all SLT replication and configuration.

IT Data Engineer

Confidential, Boise, Idaho

Responsibilities:

• Handles all BW related issues raised in JIRA
• Handles all SAP HANA Data Provisioning using SLT configuration, transformation and loading/replication
• Handles all SAP HANA SDA
• HANA Data Vault concept (Satellites, Hubs and Links)
• Create SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views
• Create SAP HANA Stored Procedure and Table Function
• Create SAP HANA Column/Row store table
• Help user to create SAP HANA Decision Table
• Handle all SLT requirements
• HANA Live
• Native HANA

SAP BW/BI Consultant

Confidential, Louisville, Kentucky

Responsibilities:

• Interacted with the management and business Decision - makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting
• Create DataSource extractor, ODS/cube/multiprovider/infoset, ABAP routine and query/web template.
• Designs and develops customer requirements for BW and ABAP
• Developed a set of Bex reports based on user requirements for BO Web Intelligence reporting
• Create, Modify Web Intelligence reports
• Provides assistance to BW users

SAP BW Backend SME

Confidential

Responsibilities:

• Configure SAP EC (Environmental Compliance) Extractors
• Create SAP EC List of value (LOV), Elements, User Define Field (UDF)
• Activate SAP EC Standard Business Content for Facility, Task, Exception, Measurement and Limit
• Create, Modify EC Facility Hierarchy
• Developed a set of Bex reports based on user requirements for BO AO (Analysis for Microsoft Excel) and Web Intelligence reporting
• Create, Modify AO (Analysis for Microsoft Excel) reports
• Create, Modify Web Intelligence reports
• Configures SAP - BW Data Modeling (InfoObjects, InfoSources, InfoProviders, DataSources)
• Create ODS/cube/multiprovider, ABAP routine in update rules/transfer rules and query/web template.
• Create and Schedule Process Chain
• Data loading
• Provides assistance to BW users
• Generates SAP-BW star-schema model for approval of SAP-BW architects
• Provided first level production support through trouble-shooting of data load errors
• Supports users inquiries on report related issue

Senior SAP Consultant

Confidential, Massachusetts

Responsibilities:

• Create and Schedule Process Chain
• Data loading
• Provides assistance to BW users
• Provided first level production support through trouble - shooting of data load errors
• Supports users inquiries on report related data accuracy issues

SAP BI Lead Consultant

Confidential

Responsibilities:

• Create global data warehouse that will facilitate the collection of data from across different regions which are Europe, AAC and Americas and provide global reporting solution access different functional areas.
• Activating, configuring and initializing about 360 Business Content extractors which will enable extraction of Logistics, Sales, Finance and a lot of other data out of S1P Sirius (Production system) and APO
• Deliver change requests based on Business Content extractors and custom tables
• Resolves issues on different kind of extractors
• Handles all ECC ABAP related extractors
• Interacted with the management and business Decision - makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer
• Experience in creating universes using information design tool 4.0 and also connecting to multiple data sources.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.
• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
• Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
• Developed WEBI reports on SAP Bex Queries using BICS.
• Created monthly and summary reports in WEBI 4.0 for the different domains like Finance and Marketing domains.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Created WEBI reports & Crystal reports and deployed them through BI Launch Pad with Bex as source
• Handles all BI ABAP routines.
• Create Open Hub Destination required by MS reporting.
• Connect and extract data from BW system to BO Data services tables
• Create SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views
• Create SAP HANA custom tables
• Create and Load Data using SAP HANA Data Provisioning SLT (SAP Landscape Transformation)
• Create Virtual Cube on top of the SAP HANA view model
• Load Excel file to SAP HANA table
• Create APD (Analysis Process Design)
• Create RRI Bex Report
• Acted as Principal Consultant for the SAP BI Offshore Team
• Handles Incident Management of Service Requests for Bug Fix
• Supports the US counterparts in ticket resolution
• Creates solution proposals for known product defects
• Participates in new Product release bi - monthly
• Assists the scheduling of product releases
• Led the knowledge transition sessions for SAP BI projects and documentations
• Served as the 0perations and Offshore Team Subject Matter Expert
• Project: Shell (Shell Malaysia)
• Acted as the Principal Consultant for the Support and Maintenance team
• Handles Incident Management of Service Requests for Bug Fixes pertaining to BO Universes and Web Intelligence Report
• Resolves issues raised by BW users of Sales and Distributions queries and reports
• Maintains and creates BW objects in the Administrator Workbench in BI 7 to resolve loading issues, object inconsistencies, process chain errors and other Production issues
• Create and Maintains BO Universes
• Create, Modify Web Intelligence, Crystal and Dashboard Reports
• Advises and proposes solutions to Incidents and prepares the Problem Analysis and Fix Approach document to be passed on to the BW support team
• Resolves recurring issues by looking into the root cause of the problem
• Maintained 100% resolution level for all incidents
• Leads a team of 7 BW developers
• Acted as the SME (Subject Matter Expert) for the SAP BI implementation and is reporting directly to the Project manager
• Participated in the bug/fix investigation and resolution with an experience BI team made up of Developers and Analysts
• Handled incidents pertaining to mainly ETL Loading issues, performance tuning and report generation
• Used BI 7.0 version to support and maintain over 20 Cubes and ODS mainly used for FI CO reporting
• Recommended OSS Notes to solve known problems /bugs in the system
• Raised OSS messages for BI Standard Extractors
• Provided Solution Proposals and Bug Fix approach
• Documented strategy and aided in the of the new BI users and developers in the team
• Prepared the plan for the Business Explorer to be conducted to the members of the BI team
• Completed a comprehensive Course for Business Explorer which includes Bex Analyzer Navigation and integrated the basic Bex features from the Query Designer

Senior SAP BW Team Lead

Confidential

Responsibilities:

• Acted as a Senior Consultant for the Regional Sales Department Business Warehouse Implementation
• Participated in the business user presentation of BW reports that resulted to a commitment a long term contract for BW usage in the Confidential Product Marketing groups.
• Lead a team of 3 in the decision making of the Solution Proposal based on user requirements
• Completed a Sales Consolidation Report which integrates Customer - wise breakdown of Billing Document daily sales reporting
• Spearheaded the design of the support framework (maintenance and resource planning) for this Consolidated Reports
• Completed and deployed 2 Cubes, 2 extractors, 5 reports and 2 workbooks to end users
• Participated in the design of the ETL process for a new Regional Reporting mechanism that integrates the standard LIS extractors and 2 customized extractors for Flat TV sales reporting.
• Maintained and supported the BI 7.0 system for 16 countries in the Asia Pacific region with ETL troubleshooting and operational questions.

SAP BW Consultant

Confidential

Responsibilities:

• Acted as the SAP BW and ABAP coordinator for a new project
• Designed a cost - effective and comprehensive solution for the Sales Adjustment functionality utilizing the SAP BW reports
• Developed an ABAP program that would allow manual adjustments to pre-loaded figures in the Infocube that would later be reloaded as adjusted records
• Designed and lead the implementation the SAP SD Sales and Billing Document
• Utilized the LO Cockpit in activating the SAP standard datasources 2LIS VDKON and 2LIS VAKON
• Developed a set of Bex reports based on user requirements
• Published the performance-tuned reports in the Web Browser

SAP BW / ABAP Consultant

Confidential

Responsibilities:

• Configures SAP - BW Data Modeling (InfoObjects, InfoSources, InfoProviders, DataSources)
• Create DataSource extractor, ODS/cube/multiprovider, ABAP routine in update rules/transfer rules and query/web template.
• Configures SAP-BW Source Systems (Extract data from flat file and SAP R/3 using RFC)
• Configures SAP-R3 IMG for BW extraction from R3
• Create and Schedule Process Chain
• Data loading
• Generates SAP-BW for management use
• Designs and develops customer requirements for BW and ABAP
• Provides assistance to BW users
• Generates SAP-BW star-schema model for approval of SAP-BW architects
• Provided first level production support through trouble-shooting of data load errors
• Supports users inquiries on report related data accuracy issues
• Formed part of the pioneer team to execute the BW BI 7.0 Upgr
• Involved in requirement gathering for Project Preparation, Busin
• Involved in the Pre Upgrade Activities (BW version 3.1 to BI 7.0
• Assessed impact of BI 7.0 objects in existing production programs and interface of SAP SD, MM and FI to SAP BW
• Initiated change requests for objects that will be affected by the changed functionality of BI 7.0
• Developed a work plan for all program changes to be done prior to the upgrade
• Involved in the preparation of the BW 7.0 version sandbox for BI 7.0 requirement analysis
• Created test infosources using direct table setting in R/3 in the BI 7.0 sandbox
• Created test cubes and ODS in the BI 7.0 sandbox
• Created test queries in the BI 7.0 sandbox

Senior SAP ABAP Consultant

Confidential

Responsibilities:

• ABAP/4 Programming
• Systems Analysis and design.
• Programming based on user requirement.
• Designed ABAP/4 programs based on company standards, user requirements and system flexibility focusing on SD, MM, FI and PP modules
• Trouble - shooting (i.e. analyzing why programs abort or behave in unexpected ways)
• Technical Designer base on Functional Design
• TD reviewer
• Code reviewer
• Create component test plan
• Developed/Enhanced ABAP/4 applications such as
• Online/Modular
• Batch Input Recording (BDC)
• Table Control
• FTP
• RFC programs
• ABAP Report programs
• ALV Report programs
• Call Transaction
• SAP Scripts
• BAPI
• Upload and Download programs
• Database Updates
• Function Module programs
• ABAP Events and Modification
• IDOC

SAP ABAP Consultant

Confidential

Responsibilities:

• Performed different ABAP programs on R/3 and SAP APO
• Online/Modular, Batch Input Recording (BDC), Table Control, FTP, RFC programs, ABAP Report programs, ALV Report programs, Call Transaction, SAP Scripts, BAPI, Upload and Download programs, Database Updates, ABAP Events and Modification.
• Create, Delete and Update Z Tables, Search Help, Table Indexes, Function Groups
• Trouble - shooting on different errors encounter if programs behave in unexpected way.
• Debug Modify and Updates of program.

IT Application Specialist

Confidential

Responsibilities:

• Performed ABAP programs
• Online/Modular, Batch Input Recording (BDC), Table Control, FTP, RFC programs, ABAP Report programs, ALV Report programs, Call Transaction, SAP Scripts, BAPI, Upload and Download program
• Database Updates, ABAP Events and Modification.
• Create, Delete and Update Z Tables, Search Help, Table Indexes, Function Groups
• Trouble - shooting on different errors encounter if programs behave in unexpected way.
• Debug, Modify and Updates of programs
• Performed Users Authorization
• Create, Change, Delete Users id with assign authorization
• Create, Change, Delete Activity Group
• Create, Change, Delete Responsibilities
• Create, Change, Delete different Profiles
• Different configuration on Material Management
• Create and set-up different materials
• Create, Delete and Update Customer
• Create, Delete and Update Discounts
• Provides on-line support on all sales offices
• Performed sales office reconfiguration
• Conducted basic of CKAG- SAP

PD SAP Support / Hand-holder

Confidential

Responsibilities:

• PD SAP Support/ Hand - holder
• Teach the users in the correct encoding of the various PD transactions following the SAP PD blue prints
• Train users in the analysis of reports and more importantly analyze problems related to inventory management (i.e. trace stock-in-transit, inventory difference)
• Transfer of skills from PD SAP Support/ Hand-holder to the PD Clerk, PD Supervisor and PD
• Superintendent within 4 to 8 weeks from deployment
• Ensure a correct SAP implementation at the plant or sales office assigned
• Analyze SAP PD reports and know how to reconcile these with the transactions processed and determines it there are any errors
• Analyze errors encountered and knows what and how to correct these
• Conduct formal classes and on-the-job coaching of PD users