SUMMARY

• More than 9 years of expertise on ETL, Data warehousing, Data modeling and Business intelligence solutions using SAP BW, HANA, BW on HANA, BODS, BOBI reporting tools, Tableau and other applications.
• Designed and implemented BI solutions for key business areas and stakeholders
• Made recommendations about data collection methods, metrics definition, and analytical evaluation methods, in collaboration with internal and external partners
• Establish close partnership with business users and other IT application teams to provide data strategy expertise ensuring overall data quality and solutions including interfaces to other application
• Strong supervision, organizational, interpersonal and time management skills
• Worked in full life cycle implementations which included gathering Customer requirements through Business Requirement Documents(BRD), Analysts and Users, performing Gap Analysis, creation of Functional Specification documents along with functional team after having business flow walkthrough from the Business users, creation of Technical Design documents, designing and developing complete dataflows up to reporting, doing Customizations, developing test scripts, participating in various testing cycles - Functional Unit Testing (FUT), System Integration Testing(SIT), User Acceptance testing(UAT), and Go-Live activities, Hypercare, Support, providing End-user training
• Participated in design review sessions, testing and post-deployment activities including data accuracy validation
• Worked in the following business areas - Sales and Distribution (SD), Material Management (MM), Customer Relationship Management (CRM), Global Trade Services (GTS), Finance (FI), Human Resources (HR), Supply Chain Management (SCM)
• Extensively worked BW architecture models - LSA and LSA++
• Expertise on reporting and presentation layer tools which includes BEx Query Designer, BEx Analyzer, BO reporting tools such as Web Intelligence, Crystal reports, Live Office, Dashboards (Xcelsius), Analysis Office, Design Studio
• Extensive experience in developing BW processes and models with InfoObjects, InfoCube, DataStore Objects (DSOs), Composite Providers, Advanced DSOs, Open ODS views, Transformations, MultiProviders, InfoSets, Hierarchies, DataSources, Update & Transfer Rules, Process Chains
• Expertise in developing, migrating, testing and supporting BO Universes
• Management of objects and schedules using BO CMC
• Worked in HANA to develop Information models such as Attribute views, Analytical Views and Calculation views
• Good working knowledge on HANA SQL scripting
• Worked in Data Provisioning techniques such as SLT and BODS
• Worked on Data Integration and migration using BODS
• Good working experience with Data Services using the Data Integrator, Data Quality and Platform transforms
• Worked on Upgrade Project from BW 7.0 to BW 7.3 on HANA and BO 3.1 to BO 4.0
• Expertise in BEx reports with usage of Restricted Key Figures, Calculated Key figures, formulas, selections, Variables, exceptions, conditions, report to report interface (RRI)
• ABAP experience in writing DataSource Enhancements, Variable Customer Exits, Routines
• Created Data Service jobs to load data from source into target using Flat file format, Query transform, Case transformation, lookup function, merge, validation, table comparison transformationetc
• Worked on BODS inbound interfaces to BW and outbound interfaces from BW
• Debugging and troubleshooting of code and errors, performance tuning of objects
• Expertise in Tableau data visualization tool to empower with insightful analytics, create visually compelling and actionable interactive reports and dashboards
• Managed and delivered large and complex assignments on time and within the budget
• Worked in Production support and resolved issues within the SLA
• Involved actively in supporting the various issues addressed by the Users from the client side and providing them with required solutions

TECHNICAL SKILLS

BI Tools: BEx Query Designer, BEx Analyzer, SAP BO (3.1, 4.0, 4.1, 4.2) reporting tools which includes Web Intelligence, Dashboards (Xcelsius), Live Office, Analysis edition for Office, Crystal Reports, Design Studio, Lumira, Information Design Tool(IDT), Universe Design tool(UDT), Central Management Console (CMC), Tableau versions 8.X, 9.X, 10.X

ETL / Data warehousing/ Data modeling: SAP BW versions 3.5, 7.0, 7.3 on HANA, 7.4 on HANA, 7.5 on HANA, BODS 4.2, Information Steward 4.2, HANA 1.X, 2.0, HANA Studio

ERP: SAP R/3 4.7, ECC 6.0, CRM 7.0

Databases: SQL Server 2014, 2016

Languages: ABAP, SQL

PROFESSIONAL EXPERIENCE

Confidential, TN

SAP BW /HANA/ DS/ BI Sr. Consultant

Responsibilities:

• Discussed with Customers, Analysts and functional owners in the business flow meetings for gathering requirements
• Created the Functional Specification documents with inputs from the functional owners
• Created the Technical Specification documents
• Worked in Identity Management and Human resources area Data Analysis, ETL and Modeling
• Created InfoObjects, Advanced DSOs, Open ODS views in HANA Studio
• Used Composite providers to join Advanced DSOs, Open ODS views and views
• Created transformations and various routines to implement business rules
• Designed and developed ETL flows in BODS and modified existing flows as per requirement
• Used various transforms like Case, Merge, Query, Validation, Map Operation, Table comparison and History preserving
• Used Conditions, variables and scripts
• Used Visualizations, Dashboards and Report Development
• Created BEx reports on Composite Providers
• Created BEx Variable exits
• Created Analysis Office reports on BEx queries
• Created parameters, running totals, Drill downs, filters, grouping of data in Crystal reports
• Usage of highlighting expert by conditionally formatting the data
• Created reports like Payroll data and time management
• Involved in modification/enhancement of existing reports
• Creation of various Web Intelligence reports on views
• Create of various formulas and variables in Webi
• Create filters, Input Controls, adding rank in Webi reports

Environment: SAP BW 7.5 on HANA, BODS 4.2, BO 4.2, Crystal reports 2016 SP2

Confidential, CT

SAP BW /HANA/ DS/ BI Sr. Consultant

Responsibilities:

• Discussed with architects, Business managers and Analysts to gather the requirements
• Handle various Change Requests for enhancements and new developments in SD, FI and SRM areas
• Created Technical Design documentation and Test documents
• Worked on BW in GUI and HANA eclipse environment
• Created Report design specification documents Data Analysis, ETL and Modeling
• Worked on HANA information models such as Analytical and Calculation views
• Developed Calculation views using Dimension, Cube and Cube with Star join
• Used Joins and Union feature to combine the tables in views
• Developed Field-based modeling flow using Advanced DSOs, Open ODS views
• Developed Composite Providers by joining disparate InfoProviders like ADSOs, Open ODS views and HANA views
• Built extractor to extract Flat file data from application server
• Enhancement of existing Datasources and routines using ABAP
• Created ETL batch jobs, workflows, dataflow, scripts using BODS
• Used Change data capture (CDC) methods for delta logic Visualizations, Dashboards and Report Development
• Developed document flow reports such as PO, receipts, Invoice and payments
• Created Spend analysis reports consisting of invoices, credit memos, gross spend amount
• Created supplier evaluation reports to identify the reliability at product category, product levels
• Developed BEx queries and created multiple Variable exits
• Created multiple Web Intelligence reports using BICS connection using BEx queries as source
• Created Web intelligence reports on HANA views
• Developed Workbooks using Analysis Office
• Development of Dashboards using Design Studio
• Used custom CSS on Design Studio to enhance the components
• Convert BEx workbooks to Analysis Office workbooks

Environment: SAP BW 7.4 on HANA, BODS 4.2, BO 4.2, Design Studio 1.5, Analysis Office 2.4, Lumira 1.30

Confidential, TX

SAP BW /HANA/ DS/ BI Sr. Consultant

Responsibilities:

• Involved requirement analysis and implementation of Solution Manager for BW monitoring activities such as Process Chain monitoring and tRFC monitoring
• Work in liaison with the data management team to advice on the data archival Data Analysis, ETL and Modeling
• Involved in Data analysis in Business Warehouse and worked on reduction of Cold data from BW and BWA
• Analyze the BEx and BO report usage
• Involved in analysis of data redundancy and content in Corporate memory area
• Management of DS jobs and schedules Visualizations, Dashboards and Report Development
• Developed reports on BW data usage analysis
• Develop dashboards on dataset to show Peaks and valleys in graphs on BW data loads
• Formatted Webi reports using Section and Break
• Created prompts, formulas, variables, input control added ranking in a webi report
• Management of reports, universes and scheduling of reports

Environment: SAP BW 7.3, SAP BO 4.2, BODS 4.2

Confidential, CA

SAP BW/HANA/DS/ BI Sr. Consultant

Responsibilities:

• Gathered requirements from Business Users through Business Requirement Documents (BRD)
• Developed Functional Specification Documents along with functional team
• Created Gap analysis, Technical Design Documents and test scripts
• Develop Report specification documents based on inputs from the Business users
• Involved in functional unit testing of the program objects, Go-Live activities and hypercare
• Designing and building of optimized ETL processes
• Worked on areas related to CRM and GTS
• Installation of required standard BI content
• Worked in Information Steward for data profiling and metadata management Data Analysis, ETL and Modeling
• Designed data modeling such as InfoObjects, DataStore Objects and MultiProviders
• Developed various Composite Providers to join various DSOs based on requirement
• Performed CRM Standard data source enhancements through BAdis (using CRM BWA MFLOW)
• Debugging of ABAP code to analyze and optimize the performance and fix errors
• Created transformation routines and developed Customer exits for BEx variables
• Created HANA information models such as Attribute Views, Analytical Views and Calculation Views
• Performed Data Provisioning to HANA using BODS and SLT
• Worked on Logistic extractors
• Created Open Hub destinations for consumption to downstream systems
• Developed Inbound interfaces using BODS to BW system to get Leads and Opportunities data from SFDC
• Developed ETL jobs with creation of various interfaces using BODS like inbound (SFDC, Siebel CRM) and outbound (Demantra, Hyperion, OBIEE, Serus)
• Created data flows using various Integrator and platform transforms
• Created job involving Conditions and Scripts
• Used Change data capture (CDC) methods for delta logic
• Created Universes on using Information Design Tool
• Created Multiple Universe Schemas having various joins like Inner join, outer Join, Shortcut join, theta join
• Create various Predefined filters and navigations paths in Universe Visualizations, Dashboards and Report Development
• Developed reports to provide 3600 view of Business Partner involved in CRM document flow
• Created various Webi reports relevant to Leads and Opportunities
• Created snapshot reports such as Weekly and Quarterly on Open Opportunities
• Created several Webi reports in CRM flow on Quotes, Contracts and Orders
• Created reports such as Export/ Import analysis, Transits and Exports from GTS
• Created various CRM Service analysis reports
• Created service document flow reports showing Service Quotes, Service Orders, Service Contracts
• Created Web Intelligence reports using BICS connectivity with BEx queries as source
• Used various Webi report features such as Rank, Break, Section etc
• Developed/supported Tableau dashboards on SAP BW
• Developed Tableau data visualization using cross tabs, scatter plots, pie charts, bar charts and density charts
• Distributed Tableau reports using techniques like Package workbooks to different User Community

Environment: SAP BW 7.4 on HANA, CRM 7.0, ECC 6.0, BO 4.1, BODS 4.1, IS 4.1, Oracle ERP, Tableau 8.X / 9.X

Confidential, Mountain View, CA

SAP BW/BI Consultant

Responsibilities:

• Gather requirements from Business Analysts
• Designed and developed various ETL processes and worked on data modeling
• Installed required BI Content Data Analysis, ETL and Modeling
• Installed required BI Content and worked on SD, Inventory and Purchasing extractors
• Designed data modeling such as InfoObjects, DataStore Objects, InfoCubes, InfoSetsand MultiProviders
• Developed and enhanced LO Cockpit extractors
• Created Generic extractors for custom requirements
• Performed datasource enhancements through BAdis using RSU5 SAPI BADI
• Created various transformation routines - Start routine, end routine, expert routine
• Implemented process chains
• Created Open Hubs as DB table and file
• Developed Semantically Partitioned Objects
• Implemented APD to provide BI solutions
• Created Open Hubs for distribution of data to external systems
• Created universes using Information Design Tool (IDT) in BO 4.0 and using Universe Design Tool (UDT) in BO 3.1
• Created schemas in Universe with Oracle Database as source
• Created Calculated columns and Derived tables in Universe to enhance the capabilities
• Resolved loops through aliases and contexts in Universe
• Performed performance tuning of various BW objects like creation of aggregates, compression, line item dimension, filling up of OLAP cache etc.
• Visualizations, Dashboards and Report Development
• Worked extensively on BEx reports and developed various Sales analysis reports.
• Created BEx reports relevant to analysis reports of material groups, vendors and materials
• Developed Customer exits for BEx variables
• Created Web Intelligence reports using BICS connectivity with BEx queries as source
• Created dashboards, crystal reports, analysis views, analysis workbooks and analysis workspaces
• Worked on optimization of existing BEx queries
• Created Live office reports
• Create Xcelsius Dashboards with Live office as source and QaaWs as source
• Performed optimization of Web Intelligence reports
• Involved in Migration of BW 7.0 to BW 7.3 on HANA
• Involved in migration of BO 3.1 to BO 4.0
• Conversion of .unv to .unx universes
• Replacing SAP OLAP universes with BICS connectivity and migrating reports
• Worked on Pre-upgradation and Post-upgradation activities by doing inventory cleanup, testing of objects and metadata

Environment: SAP BW 7.3 on HANA, BW 7.0, ECC 6.0, BO 4.0, BO 3.1

Confidential

SAP BW Developer

Responsibilities:

• Handle user tickets to resolve various support issues
• Uploading the data from source systems to BW system, monitoring the data loads and checking data quality as part of Post production support
• Worked with BI operations team in initialization of loads, setting master data and transactional delta data loads
• Built the master and transactional data process chains and scheduled accordingly to upload data into InfoProviders
• Developed custom InfoSets and created MultiProviders to utilize the existing data of the basic cubes and enhance the reporting flexibilities
• Worked on performance optimization by creating Aggregates, InfoCube partition, OLAP cache maintenance etc.
• Worked on enhancement of data sources and data targets
• Created and enhanced various BEx queries
• Created dashboards using Web Application Designer and published to role
• Modified existing dashboards and templatesusing WAD

Environment: SAP BW 7.0, ECC 6.0

Confidential

SAP BW Developer

Responsibilities:

• Designing and building ETL processes
• Installed required BI Content of FIAR, FIAP and relevant extractors
• Designed data modeling objects such as creation of InfoObjects, Operational Data Stores, InfoCubes, and MultiProviders
• Created update rules, transfer rules and routines
• Implemented process chains for automating process flows
• Created several Bex queries using Query designer
• Created Workbooks using BEx Analyzer
• Created dashboards using Web Application Designer to bind BW data to Web items and publish to role

Environment: SAP BW 3.5, R/3 4.7

Confidential

SQL Developer

Responsibilities:

• Designed and developed database tables and views
• Developed Stored Procedure and complex Packages
• Created triggers, cursors, indexes, functions
• Performed tuning of DB queries

Environment: Oracle 9i / 10g

Confidential

SQL Developer

Responsibilities:

• Designed and developed database tables
• Created tables and views,
• Worked on procedures and functions
• Performed tuning of DB queries

Environment: SQL Server 2000