SUMMARY:

• An accomplished & knowledgeable professional worked and excelled in roles of Developer, Module Lead / Technical Project Manager. Looking forward to be part of organization where I can be part the Analytic division and contribute to solutions for current challenging business environment .
• A competent professional over 8+ years in SAP BW\HANA. Total 14.5 years of experience in IT Industry.
• Hands - on experience in developing & implementing plans for improving business intelligence
• Abilities in delivering deep insights with the appropriate analytic methodologies & techniques to help the different department achieve its BI / Analytics goals
• Significant exposure of working on standard & customized data sources for LO (Purchasing, Inventory, Sales, Shipping, Billing & PP) FI etc.
• Demonstrated abilities in handling projects within time, budget & quality parameters as per project management & best practice guidelines
• Sound knowledge of SD, MM Modules
• Expertise in handling activities related to design, development & testing of Business Intelligence (BI) components
• Well versed with SAP BI, SAP HANA, SAP BO.
• An effective communicator with good analytical, interpersonal, planning and problem solving skills

SKILLS:

• IT Operations
• Requirement Gathering
• Business Intelligence
• Performance Tuning
• Troubleshooting
• Release Management
• Reporting & Documentation
• Risk Analysis
• Team Management

KEY RESULT AREAS:

• Planning, organizing & coordinating activity in assigned technical area (Business Intelligence) to ensure stable & sustainable operations
• Responsible for designing & maintaining reports, reporting processes and supporting documentation as well as providing analytical support
• Managing all phases starting with project preparation / requirement gathering, business blueprint, realization, final preparation & go live with hyper care & support
• Designing, developing and configuring all SAP BI Objects
• Building HANA Graphical views
• Expertise on SAP HANA Analytical View, Attribute View, Calculation View. Well verse with SAP HANA Performance Optimization, Modeling using different types of views on Native HANA, BW on HANA and external Table based environments.
• Expertise on using Optimized joins while building model to improve performance of models.
• Implementing single version of truth in reporting environments using SAP BI Reporting Tools (BEx, Business Objects) to support operational, analytical and management reporting
• Responsible for managing major performance improvement drive in BW application area of extraction, data propagation & reporting; implementing processes to streamline BW health check services & maintenance programs.
• Ensuring translation of user requirements into specifications for complex logical data models and design ETL procedures to load database BI/BW system
• Looking after end-to-end management of multiple projects / programs, monitoring progress of project as per schedule and ensuring timely completion & delivery of project to the client
• Developing project plans & revising them in accordance with clients’ requirements; creating, reviewing and evaluating project plans & objectives
• Troubleshooting performance issue of queries by fine tuning as per execution plan

IT SKILLS:

SAP Skills: SAP BW 7.3, SAP HANA, SAP R/3 and ECC 6.0

Languages: BI-ABAP, VBScript

RDBMS: SQL Server 2005 and Oracle

Reporting Tools: SAP Query Designer, Business Object XI (3.1) and Business Object Enterprise (WEBI).

Operating Systems: Windows 98, NT, 2003, Vista, Windows XP and Windows7 Various SAP modules such as MM, SD, PS. etc. Microsoft Windows Installer, InstallShield, Wise, FileMon, Regmon.

PROFESSIONAL EXPERIENCE:

Confidential

Technology/Software: SAP BW 7.4 on HANA DB, ECC-6.0, SAP HANA 2

SAP BI\HANA Developer

Responsibilities:

• Develop HANA Graphical Views on BW models built on Tables, Native BW Infoproviders as well as on BW on HANA DB.
• Leveraging SQL scripts for lookup and performance.
• Performance tuning by having physical \ virtual partition based views.
• Adding of filters and restriction at the initial level of HANA views, Create selection fields via user prompts.
• Designing Calculated Attributes, Variables, and Input parameters.
• Data Modelling using HANA Modeller - Create Graphical calculation views and views using old methodology in off case scenarios.
• Partitioning tables with more than 2 billion records using Range/Hash/Round robin partitioning methods.
• Importing and Exporting HANA contents using Delivery Units and Developer mode.
• Generating Auto Documentation of HANA models.
• Building Composite Provider, ADSO and dependent HANA views for QlickVIew and Tableau Dashboards.
• Undertaking activities related to development of:
• Generic Extractors and Enhancement of Standard Extractors R/3 System
• BW objects (Info Cube, DSO, Characteristics, Key Figures, Multi Providers, transformations, DTP’s, Info Packages, etc.)
• Creating and maintenance of Custom Hierarchy.
• Generation of Summary based reports for Indirect\Direct Expense leveraging Virtual Characteristic and Link nodes for custom hierarchies.
• Accountable for:
• Designing function module & view/table based extractors and technical & functional specifications
• Modifying custom hierarchy program and exit routines for BAU scenarios.

Confidential

Technology/Software: SAP BW 7.4 on SQL DB, ECC-6.0, SAP HANA 2.8.8

SAP BI Operations Architect

Responsibilities:

• Evaluation of client environment and setup and configuration for SAP BI.
• SLC and SRM module to be implemented and development of parallel BI reports.
• SAP HANA reports for creditor, debtors and revenue accruals.

Confidential

Technology/Software: SAP BW 7.4 on SQL DB, ECC-6.0, SAP HANA 2.8.8

SAP BI Operations Team Lead

Responsibilities:

• Ensuring Delivery of all BW / BO work products
• Responsible for planning and defining scope of the project
• Undertaking activities related to:
• Requirement gathering, communication with client /customer or user’s
• Activity planning & sequencing, risk analysis and managing risks & issues
• Development of schedules & time estimating, resource planning, work allocation and execution of work
• Looking after execution & delivery and streamlining the process thus increase client / customer or user satisfaction; monitoring & reporting progress to management
• Engaged in board communities of practice, recruiting, upgrade planning etc.
• Expertise on SAP HANA Analytical View, Attribute View, Calculation View. Well verse with SAP HANA Performance Optimization, Modeling using different types of views on Native HANA, BW on HANA and external Table based environments.
• Expertise on using Optimized joins while building model to improve performance of models.
• Transferring data from Replication servers to SAP HANA using SLT. Data loads into BW on HANA system and provision data validations on HANA views for Tableau reports.
• Transporting objects using HANA Developer Mode Export and Import Process.
• Undertaking activities related to development of:
• Generic Extractors and Enhancement of Standard Extractors R/3 System
• BW objects (Info Cube, DSO, Characteristics, Key Figures, Multi Providers, transformations, DTP’s, Info Packages, etc.)
• Accountable for:
• Designing function module & view/table based extractors and technical & functional specifications
• Managing Info Cubes including compression, rollup, indexing & creating aggregates to improve load & query performance
• Directed Basis Team to install new SAP GUI release 7.4 with latest patch level 12.
• Responsible for checking Table RSZCOMPDIR before & after migration: Field VERSION in Table RSZCOMPDIR should have value below 100, it means query was in 3.x version, if the value more than 100 means it was already Migrated; took pre & post snap to ensure the queries working fine.
• Generic Extractors and Enhancement of Standard Extractors R/3 System
• BW objects (Info Cube, DSO, Characteristics, Key Figures, Multi Providers, transformations, DTP’s, Info Packages, etc.)
• Accountable for:
• Designing function module & view/table based extractors and technical & functional specifications
• Managing Info Cubes including compression, rollup, indexing & creating aggregates to improve load & query performance
• Ensured migration of queries and work books from BW 3.x to BI 7.10
• Directed Basis Team to install new SAP GUI release 7.10 with latest patch level to make sure front end must be in the same version for all systems while migrating queries & work books; especially when we were working on global standard model i.e. onsite & offshore model, need to be very careful in GUI versions of all the systems in the project

Confidential

Technology/Software: SAP BW 7.0 on SQL DB, ECC-6.0

SAP BI Developer

Responsibilities:

• Involved in creating and managing of Info Areas, Info Object Catalogs, Info Objects, Application components, PSA, DTP, Info package, transformation, Multiproviders,
• Hands on experience in BW reporting using BEx Query designer, BEx Analyzer and creating Queries.
• Involved in front-end BI Components like Queries, Formulae, Variables, Calculated Key figures, restricted key figures, Structures, Selection, Exceptions, and Conditions.
• Uploading master data and transactional data both from flat files and SAP R/3.
• Creation of Process Chains, Meta Chains for upload of Transaction Data and Master Data.
• Monitoring and Error handling in PSA like modifying the error records and reloading the data.
• Installed objects from business content.
• BI Reporting & Analysis - Ad-hoc Queries, Query Designer, Bex Analyzer, BW Transformations
• BW Operations - Data load management, Job scheduling, Loading (Full /Delta Up-Load), Process Chain Monitoring, Data Reconciliation.
• Generic Extractors based on Tables, Views & Function Modules.
• BW Transports - Transport strategy, Object Collection & Transports Movements across Landscapes
• Monitoring daily, Weekly, Monthly and on demand Process Chains.
• Monitoring of data loading through Process chains.
• Monitoring of Process chains and analyzing the reasons for frequent failures of Extractions.
• Maintaining Work History for all the tickets until it is closed down.
• Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW is same.
• Data loading was monitored and the failed data packets were analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded to ODS.
• Used delta upload mechanisms to upload SAP R/3 source system data to SAP BW and also involved in uploading of Master and Transaction data.
• Data Extracted from R/3, Creating Info packages, Scheduling and Monitor settings.
• Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.

Confidential

Technology/Software: SAP BW 7.0 on SQL DB, ECC-6.0

SAP BI Consultant

Responsibilities:

• Major activity of enhancing flows and reports already available in Production as part of hyper care Support
• Involved in creating and managing of Info Areas, Info Object Catalogs, Info Objects, Application components, PSA, DTP, Info package, transformation, Multiproviders,
• Hands on experience in BW reporting using BEx Query designer, BEx Analyzer and creating Queries.
• Involved in front-end BI Components like Queries, Formulae, Variables, Calculated Key figures, restricted key figures, Structures, Selection, Exceptions, and Conditions.
• Uploading master data and transactional data both from flat files and SAP R/3.
• Creation of Process Chains, Meta Chains for upload of Transaction Data and Master Data.
• Monitoring and Error handling in PSA like modifying the error records and reloading the data.
• Installed objects from business content.
• BI Reporting & Analysis - Ad-hoc Queries, Query Designer, Bex Analyzer, BW Transformations.