SUMMARY

• More than 16 years of IT experience in Application design and development, Database, ETL, Data warehousing, Data modeling, Analytics and Business intelligence solutions
• 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, client relationship management 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 (FSD) along with functional team after having business flow walkthrough from the Business users, creation of Technical Design documents (TDD), designing and developing complete data - flows up to reporting, doing Customizations, developing Test scripts, participating in various testing cycles encompassing Functional Unit Testing (FUT), System Integration Testing (SIT), User Acceptance testing (UAT), and involved in Go-Live activities, Hypercare, Production Support, Migration, Upgradation, providing End-user training
• Participated in design review sessions, testing and post-deployment activities including data accuracy validation
• Worked in BI in the following business areas - Sales and Distribution (SD), Material Management (MM), Customer Relationship Management (CRM), Global Trade Services (GTS), Finance and Controlling (FICO), Trade Promotion Management (TPM), Supply Chain Management (SCM), Supplier Relation Management (SRM) and Advanced Planner and Optimizer (APO)
• Expertise on modeling SAP HANA using Attribute view, Analytical view and Calculation view
• HANA SQL Scripting, procedures, table functions and Data Provisioning Techniques like SAP Landscape Transformation (SLT), Data Services, SDI/SDQ
• 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, Lumira, SAP Analytics Cloud
• Extensive experience in developing BW processes and models with Info Objects, Info Cube, Data Store Objects (DSOs), Composite Providers, Advanced DSOs, Open ODS views, Transformations, Multiproviders, Info Sets, Open Hubs, Data Sources, Update & Transfer Rules, Process Chains, Integrated Planning (FOX functions, ABAP/AMDP functions)
• ABAP experience in writing Data Source Enhancements, Variable Customer Exits, Routines
• Designed and developed various interfaces using BODS with various systems such as Oracle, MS SQL Server, Salesforce, Demantra etc.
• Good working experience with Data Services using the Data Integrator, Data Quality and Platform transforms
• Worked on Upgrade Projects involving BW, HANA, BOBI
• Management of BI Content, report schedules and Instance management in BO CMC
• Expertise in developing, migrating, testing and supporting BO Universes
• Expertise in BEx reports with usage of Restricted Key Figures, Calculated Key figures, formulas, selections, Variables, exceptions, conditions, report to report interface (RRI)
• Expertise in Tableau data visualization tool to empower with insightful analytics, create visually compelling and actionable interactive reports and dashboards
• Debugging and troubleshooting of code and errors, performance tuning of objects
• Worked in Production support and resolved issues within the SLA

TECHNICAL SKILLS

BI / Analytics Tools: BEx Query Designer, BEx Analyzer, WAD, SAP BOBJ reporting tools which includes Web Intelligence, Xcelsius, Dashboards, Analysis edition for Office, Crystal Reports, Lumira Designer, Lumira Discovery, Information Design Tool (IDT), Tableau, SAP Analytics Cloud (SAC)

ETL / Data warehousing / Data modeling: SAP BW versions 3.X to 7.5 on HANA, SAP BODS 4.2, HANA 2.0

ERP/ Business Suite: SAP R/3 4.7, SAP ECC, SAP CRM/TPM, SAP SCM, S/4 HANA

Databases: SQL Server 2014, 2016, Oracle 9i, 11g

Languages: ABAP, SQL, HANA SQL

PROFESSIONAL EXPERIENCE

Confidential, Tucker, GA

Sr. SAP BI Developer

Responsibilities:

• Work with cross-functional teams; liaise between IT team, business partners, End customers and decision makers
• Do requirement analysis, document all the specifications, deliver under specified timelines
• Involved in SIT, UAT and Go-Live activities for BW/TPM
• Supported Business group primarily in the FI, Sales, CRM, TPM areas
• Work on native HANA modeling (calculation views), Table functions, SQL Scripting, Procedures
• Understand and use of relevant calculation nodes to develop calculation views
• Use hybrid modeling of BW and native HANA objects
• Work on BW-IP( Integrated Planning models)
• Work on BW data flows transformations, ADSOs, Composite providers, BEx queries
• Work on AMDP scripts used in transformations and Planning functions
• Work on ABAP (Transformation routines, variable exits, enhancements, Planning functions)
• Handle new User Requirements/enhancements via Change Requests/Service requests
• Handle User incidents; work with End User to guide and resolve issues, troubleshoot business and production issues
• Work on SLT configuration setup and data provisioning
• SAP Analytics Cloud(SAC) - Create engaging visualizations using Models and Stories
• Analysis for Office(AFO) - Create workbooks and publish to BI Portal, help user incidents/issues with reporting
• Lumira Designer - Create Pre-authored Dashboards, use scripts to enhance functionality
• Monitoring and maintenance of BW/HANA System, User authorizations
• Worked of SAP BW/HANA upgradation activities
• Provided End user training on using tools like Analysis for Office and SAP Analytics Cloud

Confidential, New Jersey

SAP BW HANA/ BOBI/ DS Sr. Consultant

Responsibilities:

• Discussions with Customers, Analysts and functional owners in the business flow meetings for gathering requirements
• Review the requirement documents, take inputs from the functional owners, create the Functional Specification documents and translate into Technical specifications
• Developed data models - Advanced DSOs and Open ODS views
• Created Composite Providers to join various field based and Object based models
• Design and develop optimal ETL processes
• Used SQL Scripting and worked on creating information models and
• Created various connectors/data store configuration in Data Services
• Designed and developed ETL flows in Data Services and modified existing flows as per requirement
• Developed Workbooks using Analysis Office
• Worked on Crystal reports
• Involved in modification/enhancement of existing reports
• Creation of various Web Intelligence reports
• Create Lumira visualizations, Stories and publish the dashboards to BI Portal

Confidential

SAP BW HANA / BOBI/DS Sr. Consultant

Responsibilities:

• Handle various Change Requests for enhancements and new developments
• Created Technical design documentation, test documents, Report design specification documents
• 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, data flows using BODS
• Worked on Data Provisioning to HANA using SLT and BODS
• Created Developed BEx queries, Variable exits, Calculated Key Figures and Restricted Key Figures
• Created various Webi reports on HANA views and BEx queries as source
• Developed Workbooks using Analysis Office and converted existing BEx workbooks to Analysis Office workbooks
• Development of Dashboards using Design Studio
• Creation of Visualizations, Stories and publishing Lumira Dashboards to BI portal

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
• Worked on analysis of objects which can be migrated to HANA system
• Management of Data Services schedules and inventory cleanup by retiring obsolete flows and ETL jobs
• Developed reports on BW data usage analysis
• Management of BO reports and scheduling of reports

Confidential, Sunnyvale, California

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 Logistics and FI Content
• Designed data modeling such as Info Objects, Data Store Objects and Composite Providers
• 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
• Created various inbound and outbound interfaces using BODS on systems like Serus, Siebel CRM, SFDC, Demantra, Hyperion
• Used Change data capture (CDC) methods for delta logic in DS
• Created data flows using various Integrator and platform transforms
• Used various transforms like Query, Case, Merge, Validation, Map Operation, Table Comparison, History Preserving
• Worked in creation of HANA information models
• 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 several Webi reports in CRM flow on Leads, Opportunities, Quotes, Contracts and Orders
• Created Web Intelligence reports using BICS connectivity with BEx queries as source
• Developed/supported Tableau data visualizations and dashboards
• Scheduling of various reports to User Community

Confidential, Mountain View, California

SAP BW / BOBI Consultant

Responsibilities:

• Gather requirements from Business Analysts
• Designed and developed various ETL processes and worked on data modeling
• Installed required BI Content and worked majorly on logistic extractors such as SD, Inventory and Purchasing
• Designed data modeling such as Info Objects, Data Store Objects, Info Cubes, Info Sets and Multiproviders
• Developed and enhanced LO Cockpit extractors
• Performed data source enhancements through BAdis using RSU5 SAPI BADI
• Created generic extractors for custom requirements
• Created various transformation routines - Start routine, end routine, expert routine
• Worked on COPA data source 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, Derived tables and resolve loops 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.
• Developed Customer exits for BEx variables
• Created CKFs, RKFs, Cell definitions, structures
• Created Web Intelligence reports using BICS connectivity with BEx queries as source
• Worked on optimization of existing BEx queries
• Created Live office reports and using them as source for Xcelsius Dashboards
• Involved in Migration of BW 7.0 to BW 7.3 on HANA
• Involved in migration of BO 3.1 to BO 4.0
• 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

Confidential

SAP BW Consultant

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 Info Providers
• Developed custom Info Sets and created Multiproviders to utilize the existing data of the basic cubes and enhance the reporting flexibilities
• Worked on performance optimization by creating Aggregates, Info Cube 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 templates using WAD

Confidential

SAP BW Consultant

Responsibilities:

• Designing and building ETL processes
• Installed required BI Content of FIAR, FIAP and relevant extractors
• Designed data modeling objects such as creation of Info Objects, Operational Data Stores, Info Cubes, 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

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

Confidential

SQL Developer

Responsibilities:

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