SUMMARY:

• More than 12 years of IT experience with 9.5 years of expertise on ETL, Data warehousing, Data modeling and Business intelligence solutions using SAP BW, BW on HANA, BO tools (BI and DS), 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 and Controlling (FICO), Supply Chain Management (SCM-EWM)
• 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, Open Hubs, DataSources, Update & Transfer Rules, Process Chains
• Worked on HANA information models and developed reports consuming them
• Management of BI Content, report schedules and Instance management in BO CMC
• Expertise in developing, migrating, testing and supporting BO Universes
• Good working experience with Data Services using the Data Integrator, Data Quality and Platform transforms
• Designed and developed various interfaces using BODS with various systems such as Oracle, SQL Server, SFDC, Demantra etc.
• Worked on Upgrade Project from BW 7.0 to BW 7.3 on HANA and BO 3.1 to BO 4.0
• Good knowledge on HANA scripting and Data Provisioning activities
• 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
• 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
• Worked in Production support and resolved issues within the SLA

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), 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

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

Databases: SQL Server 2014, 2016, Oracle 11g

Languages: ABAP, SQL

PROFESSIONAL EXPERIENCE:

Confidential, Princeton, New Jersey

SAP BW HANA/ BOBI/ DS Sr. Consultant

Responsibilities:

• Discussed with Customers, Analysts and functional owners in the business flow meetings for gathering requirements
• Review Business requirement documents (BRD), take inputs from the functional owners, create the Functional Specification documents and translate into Technical Specification
• Worked on BW in GUI and HANA eclipse environment
• Developed Advanced DSOs and Open ODS views
• Created Composite Providers to join various field based and Object based models
• Create Virtual tables via SDA and access them in HANA
• Worked on HANA Analytical, Calculation Views, SQL Scripting and Stored Procedures
• Developed transformations and routines
• 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, History Preserving
• Developed Workbooks using Analysis Office
• Created parameters, running totals, Drill downs, filters, grouping of data in Crystal reports
• Usage of highlighting expert by conditionally formatting the data
• 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
• Create Visualizations, Stories and publish the dashboards to BI Portal

Environment : SAP BW 7.5 on HANA, HANA 2.0, BODS 4.2, BOBI 4.2 (Webi 4.2, Lumira 2.0, Analysis Office 2.4, Crystal reports 2016)

Confidential

SAP BW HANA / BOBI/DS Sr. Consultant

Responsibilities:

• Handle various Change Requests for enhancements and new developments
• Created Technical Design documentation and Test documents
• Worked on BW in GUI and HANA eclipse environment
• Worked HANA information models and BW on HANA models such as Composite Providers, Advanced DSOs, Open ODS views
• Built extractor to extract Flat file data from application server and develop process chain to continuously extract from server upon availability of source file
• Usage of ABAP for Customizations and enhancements
• Created ETL batch jobs, workflows, dataflow, scripts using BODS
• Create various DS transforms like Query, Case, Map Operation, Table Comparison etc
• Worked with Basis team to configure ECC datasource to transfer data from SLT using Web Service
• Developed BEx queries and created multiple Variable exits
• Created various Calculated Key Figures and Restricted Key Figures
• 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
• Created multiple Web Intelligence reports using BICS connection using BEx queries as source
• Developed Workbooks using Analysis Office
• Convert BEx workbooks to Analysis Office workbooks

Environment : SAP BW 7.4 on HANA, HANA SPS11, BODS 4.2, BOBI 4.2 (Webi 4.2, Analysis Office 2.4, Design Studio 1.5)

Confidential

SAP BW HANA / BOBI/DS 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
• Involved in Data analysis in Business Warehouse and worked on reduction of Cold data from BW and BWA
• Involved in analysis of data redundancy and content in Corporate memory area
• Management of Data Services schedules and inventory cleanup by retiring obsolete flows and ETL jobs
• Developed reports on BW data usage analysis
• Develop dashboards on dataset to show Peaks and valleys in graphs on BW data loads

Environment: SAP BW 7.3, BODS 4.2, BOBI 4.2 (Webi 4.2)

Confidential

SAP BW HANA / BOBI/DS 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, GTS and supported Logistic and FI Content
• 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 and routines
• Worked on DS activities for various inbound and outbound interfaces using BODS on systems like Serus, Siebel CRM, SFDC, Demantra, Hyperion
• Used Change data capture ( Confidential ) methods for delta logic in DS
• Created data flows using various Integrator and platform transforms
• Created BEx reports on Composite Providers
• Created BEx Variable exits, CKFs and RKFs
• Worked on CRM Sales and Service analysis reports
• 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 Web Intelligence reports using BICS connectivity with BEx queries as source
• Used various Webi report features such as Rank, Break, Section, Variables, Formulas etc
• Developed/supported Tableau data visualizations and dashboards
• Used different Mark types and Mark properties in views to provide better insights into large data sets
• Created various Sets, Groups, Parameters and Filters in Worksheets

Environment : SAP BW 7.4 on HANA, HANA SPS09, BODS 4.1, BOBI 4.1, Tableau 8.X, 9.X, CRM 7.0, ECC 6.0, SFDC

Confidential

SAP BW / BOBI Consultant

Responsibilities:

• Gather requirements from Business Analysts
• Designed and developed various ETL processes, data models and installed required BI Content
• Installed required BI Content and worked majorly on logistic extractors such as SD, Inventory and Purchasing
• Designed data modeling such as InfoObjects, DataStore Objects, InfoCubes, InfoSets and MultiProviders
• Developed and enhanced LO Cockpit extractors
• Performed datasource enhancements through BAdis using RSU5 SAPI BADI
• Created various transformation routines - Start routine, end routine, expert routine
• Worked on COPA datasource and set up the extraction structure based on Cost-based profitability analysis requirements
• Worked on creation of process chains and enhancing existing chains
• 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.
• 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 and created CKFs, RKFs, Cell definitions, structures
• 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 and using them as source for Xcelsius Dashboards
• 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 (Webi, Crystal reports, Live Office, Xcelsius)

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

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