PROFESSIONAL SUMMARY:

• SAP AG Certified in SAP BI 7.3/BO 4.0 and SAP HANA wif 10 plus years of experience.
• Expertise in all phases of SDLC like Realization, Analysis, Functional and Technical specification, Development, Integration and UAT, End - User trainings and Post Go-Live support.
• Experience in Leading and managing teams. Handled multiple roles like Senior BI consultant, Onsite Coordinator, BW Tech Lead and BW Developer.
• Holding more TEMPthan 5 years of experience in Webi Reporting and Administration.
• Good Experience in Webi reporting on Non-SAP sources and on SAP HANA (Ms Access, Oracle, etc).
• Expertise in ETL and Data Modeling (Data Extraction, Generic Extraction, Data Loading), Scheduling, Monitoring, Reporting Web publishing.
• Extensively worked on Info-objects, Info Sources, Info Cubes, DSOs, Multi Provider, Info Set, Transformations and Process Chains.
• Extensively worked in BW Security on end user authorizations for reporting.
• Good Experience in Experience in Solomon Manager - Charm.
• Strong ABAP programming skills including Data Source Enhancements, Routines (Start, Field, End and Expert Routines), Customer Exit Variables, Info Package and DTP Routines.
• Exclusively worked on BW/HANA testing, Unit Testing, Regression testing and DR testing.
• Experience on Native HANA and SAP BW Powdered by HANA
• Experience on SAP Native HANA Data Provisioning (SLT, DXC and BODS), Data Replication, Modeling and Reporting.
• HANA modeler experience includes creating Composite Providers, Advanced Data Store Objects, HANA Views (Analytic, Attribute and Calculation). Extracted data from ECC and created reports using reports SAP Landscape Transformation Replication Server (SLT). Created reports on external Databases using Smart Data Access (SDA). Business Objects Data Services (BODS) is used as an ETL from extracting data from external systems.
• Involved in Transporting HANA Views from Dev to Production using Delivery Units.
• Has hands on experience in HANA modeling in creating Attribute, Analytic and Calculation Views.
• Extensively Involved in teh SAP BW 7.3 to 7.4 upgrade wif HANA as database
• Extensive noledge in Integrated Planning, resolved teh end user incidents in IP.
• Involved in three full - life cycle BW implementations, upgrade from 3.X to 7.0, Enhancements and Post Production Support in teh areas of SAP SD, MM, PP, PM,PS, FI and SAP CRM.
• Expertise in BW Performance Tuning of Queries by maintaining Aggregates, Compression, partition and indexing of Info Cubes.
• Extensively worked on Tableau Dashboards on top of HANA, BW Systems.
• Proficient in loading data from different sources to HANA using SAP Data Services wif good exposure to all teh transformation available, repository creations and scheduling teh jobs in Management Console. Hand on experience in writing and tuning SQL.
• Knowledge on BW-BPC.
• Good Knowledge in pre and post activities in teh upgrades from BW 7.x to BW 7.5.
• Good Knowledge on Enterprise HANA and Live HANA.
• Worked on LUMIRA as frond end reporting tool.
• Extensively worked on Data Source Enhancement using Customer Exit and Badi (Multiple Implementations).
• Proficient in all kinds of Routines (Start, Field, End and Expert routines). Ability to identify teh suitable routine based on teh scenario.
• Expertise in design and development of Generic Data Source Extraction using Table, View, Info Set Query and Function Module wif delta functionality.
• Extensively worked on Customer Exit Variables using Customer Exit and Enhancement Spot/New Badi (Multiple Implementations).
• Worked on Info Package and DTP routines.
• Expertise in Debugging, Performance tuning of various objects and designed teh documents for best practices in BW environment.
• Extensively worked on Attribute Views (Standard, Time and Derived), Analytic and Calculation Views (Graphical and Script based), Creation of Hierarchies, Variables and Input parameters.
• Proficient in creation and calling procedures, using teh CE functions based on teh requirement.
• Excellent noledge on Data Replication Techniques using SLT, BODS, DXC and SDA.
• Proficient in SLT configuration and replication of tables by using various replication techniques.
• Involved in importing teh BW models from SAP BW HANA to teh HANA Studio.
• Good Knowledge in SAP HANA security including User Management, Roles and Privileges.
• Extensively worked on migration of standard Info cube and DSOs to HANA-Optimized Info Cubes and DSOs by using Tcode ‘RSMIGRHANADB’.
• Good working noledge in creation of Advanced DSO.
• Worked on Open ODS View, Composite providers and Transient providers.
• Proficient in importing HANA models into BW system.
• Developed Webi reports on BW queries and HANA views used teh IDT.
• Created teh connection between IDT and HANA views
• Proficient in importing HANA models into IDT
• Created Interactive design studio dashboards on HANA views.

PROFESSIONAL EXPERIENCE

Confidential, Plano,Tx

Sr SAP BW/HANA/BO/ Developer/Lead

Roles and Responsibilities:

• Extensively worked on FI reporting, created teh FL flow from scratch.
• Managed, Configured and Performed Transports between multiple BW environments. Defined practices for BW transport management. Created multiple process chains for Delta & Full Data sources. Troubleshooting data and technical issues related to SAP BW.
• Interaction wif business users and gathered teh requirement and built teh BI reporting accordingly.
• Extensively worked on teh custom/standard Info-objects, Info Sources, Info Cubes, DSOs, Multi Provider, Info Set, Transformations and Process Chains.
• Led efforts on handling of UAT and coordinating wif offshore team for quick closure of bugs reported
• Worked on SAP MM, SD, FI, HR and all other modules.
• Created customer data sources and worked on SAP defined data sources and built teh BW flow according to teh requirement.
• Worked on SAP BW on HANA and worked on mixed modelling scenarios.
• Worked on HANA studio, created teh Information Views.
• Worked on APD’s and OHD’s extensively.
• Worked on pre and post BW version upgrade activities.
• Worked in Solomon Manager, used CHARM as teh transport mechanism to transports teh objects throughout teh landscape.
• Worked extensively on DVM activities.

Confidential, Pheonix, Arizona

Sr SAP BW/HANA/BO/ Developer/Lead

Roles and Responsibilities:

• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Involved in Test final output based on requirements and business needs.
• Extensively worked on Info-objects, Info Sources, Info Cubes, DSOs, Multi Provider, Composite Providers, Transient Providers and Transformations and Process Chains.
• Created BEx Reports providing insight of Business Intelligence to aid teh analysts in decision-making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Customer Exit.
• Developed BOBJ Webi reports on BW queries and HANA views used teh IDT.
• Worked on SAP Native HANA and BW on HANA used teh Data Provisioning (SLT, DXC and BODS and SDA), Data Replication, Modeling and Reporting.
• Worked on HPQC tool for BW testing, created test scripts, test plans.
• Worked Extensively on Webi reporting using BICS connection to connect teh Bex Queries.
• Exclusively worked on BW/HANA testing, Unit Testing, Regression testing and DR testing
• Worked on DSO look-ups at start routine and end routine using Classes and Methods.
• Creation/Change of Process Chains for teh entire Daily / Weekly/Hourly Loads..
• Provided hyper care- Post Implementation Production Support includes Monitoring teh Process Chains Daily, Weekly and Monthly. Troubleshooting and Correcting teh Data Load Errors.
• Involved in Data Source Enhancement using teh BADI-Enhancement Spot.
• Involved in all support pack activities every quarterly.
• Created teh connection between IDT and HANA views
• Proficient in importing HANA models into IDT
• Created Interactive design studio dashboards on HANA views
• Created Info objects, DSO’s, and Cubes & Multi providers as per teh data model. Defined several transformations as per teh need. Performed clean-up activities for teh pre-emigration of BW on HANA implementation. Optimized BW cubes for HANA purpose.
• Created generic data source for custom requirement and enhanced data sources as required.
• Managed, Configured and Performed Transports between multiple BW environments. Defined practices for BW transport management. Created multiple process chains for Delta & Full Data sources. Troubleshooting data and technical issues related to SAP BW.
• Created Complex Bex reports using Composite Providers.
• Create Open ODS view and Advanced DSO’s in HANA Studio.
• Reconciled Inventory and purchasing data from BW to R/3 for existing Production reports

Confidential, Dallas, Texas

Sr SAP BW/HANA/BO//Lead

Roles and Responsibilities:

• Facilitate requirements gathering and reconciliation of data definitions wif business and IT experts.
• Playing a Lead role for onshore and offshore.
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Involved in SAP HANA Security including User Management, Roles, and Privileges.
• Evaluate teh information gathered from multiple sources, reconcile conflicts, and decompose high level information into details, abstract up from low-level information to a more general.
• Understanding, distinguish presented user requests form underlying true needs and distinguish solution ideas from requirements.
• Involved wif basis team in teh upgrade process from BW 7.3 to BW 7.4 version HANA as a database.
• Prepare requirements documents to be used as teh basis for project development.
• Leading Onshore and Offshore teams.
• Involved in BO and Tableau server maintenance and installation, configuration.
• Experience in publishing reports, dashboards and data sources to Tableau Server.
• Test final output based on requirements and business needs.
• Using Design Studio created teh dynamic dashboards.
• Coordinate wif global IT and Business teams to deliver teh requirements
• Created teh Open Hubs for PS Flow, HRMS, Time Entry and COPA Data Flows to transfer teh data to Third Party PDW System.
• Extensively worked on Info-objects, Info Sources, Info Cubes, DSOs, Multi Provider, Info Set, Transformations and Process Chains.
• Extensively worked on Data Source Enhancements.
• Data provisioning using SAP Landscape Transformation and SAP Dataservices, DXC, Flat File Uploader, SAPHANA Architecture Participated in year-end Rollover to gather requirements from business, do impact analysis and Implement changes.
• Used DSO look-ups at start routine and end routine.
• Worked on SAP Native HANA Data Provisioning (SLT, DXC and BODS), Data Replication, Modeling and Reporting.
• Expertise in SAP Native HANA data modeling using Attribute View, Analytical view and Calculation view where non BW sources where used.
• Experience on Open ODS View, Composite providers and Transient providers
• Created BEx Reports providing insight of Business Intelligence to aid teh analysts in decision-making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Customer Exit.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc. using tableau.
• Involved in writing teh td and fd documents, and developing and deploying technical components of Tableau BI Solution.
• Created daily, weekly, monthly and quarterly reports for teh management team and Regional Managers
• Create parameterized reports (these reports show information from highest level by company and can be drill-down to single product using hyperlinks), cross-tab, conditional, and Top N, Summary and Sub reports in Web Intelligence.
• TEMPEffectively used data blending, filters, actions and Hierarchies feature in Tableau
• Experience wif Single Sign on wif Tableau.
• Worked on data blending for data extracts and ability to work wif multiple data sources.
• Built teh tableau dashboards and bubble charts as teh source as SAP BW (bex query) and SAP HANA views.
• Developed story boards and dashboards on HANA Information models using SAP Lumira.

Confidential

Sr SAP BW/HANA Developer

Responsibilities:

• Creation/Change of Process Chains for teh entire Daily / Weekly/Hourly Loads as and when required.
• Supporting multiple projects wherever necessary.
• Worked on LO-Extraction, CO-PA extractions and F1 Extraction.
• PFCG & RSECADMIN transactions for creating, maintaining roles and authorizations in assigning authorization values to teh BW Custom objects.
• Involved in designing teh functional and technical specs for teh ECC 6.0 and HANA Models.
• Involved in SAP BI wif HANA Migration.
• Experience in SAP Native HANA data provisioning using SAP LT Replication Server (SLT) and data services and Flat files.
• Worked on HPQC tool for BW testing, created test scripts, test plans.
• Develops specific test conditions and expected results for functional and regression Test Scenarios and Test Cases based on Functional requirements, and Technical & Interface specification
• Maintained QA Status Report, QA Summary Reports, QA Test Logs, Maintain issue and defect databases.
• Created Tableau scorecards using stack bars, bar graphs, scattered plots, geographical maps
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
• Provided 24/7 production support for Tableau users and conducting trainings to interact, filter, sort and customize views on an existing visualization generated through Tableau Desktop.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau
• Worked in BW IP(Integrated Planning), resolved teh IP issues when users had issues wif their budgeting their five year plan.
• Created Planning Function, Planning Sequences and Filters on Aggregation Levels for Planning in IP.
• Worked closely wif end user to handle teh budgeting and forecasting issues.
• Exclusively worked on BW/HANA testing, Unit Testing, Regression testing and DR testing
• Experience in SAP Native HANA data modeling using Attribute View, Analytical view and Calculation view where non BW sources where used.
• Involved in full project life cycles (i.e. requirements gathering, design, development, test, cut-over and support) as SAP BW developer, and one full project life cycle as SAP HANA Modeler
• Created BEx Reports providing insight of Business Intelligence to aid teh analysts in decision-making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Customer Exit.
• Extensively Involved in teh SAP BW 7.3 to 7.4 upgrade wif HANA as database
• Cross Verifying teh Daily data load as per teh checklist for ensuring teh proper data upload in BI.
• Extensively worked in developing and enhancement in WEBI Reports
• Checking teh daily time schedule for teh run & ensuring that teh jobs are finished wifin teh specified time frame.
• Interacting wif teh clients from time to time to discuss teh open issues.
• Worked wif all teh SAP modules, FI, PM, COPA, MM, SD, CLM, RLM, and HR.
• Changes to teh existing Reports & Creation of new Reports as per Clients requirements.
• Fixing teh High and Medium, low priority incident raised by users.
• Actively involved in end user training as well as developer training. Created technical documentation, user training manuals etc.
• Led efforts on handling of UAT and coordinating wif offshore team for quick closure of bugs reported
• Monitoring teh Production/ Pre- Production system and fixing teh Master data, Transaction data and Process Chains load failures.
• Worked on creating BW Security related objects for end user reporting.
• Extensively involved in writing Routines, Start Routine, End Routine, Info package routines.
• Enhanced teh Standard Data Sources and Variables using Customer exit and BADI.
• Having noledge on Creating PM Orders in ECC (OLTP) for testing BI (OLAP) reports.
• Extensively involved in SR Process and incident Management Process.
• Working major issues on integrated planning.
• Develop WEBI Reports based on client requirements.
• Created SAP Lumira reports and Webi reports on HANA studio.
• Analyzed existing business requirements in Tableau.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Experience integrates output wif mobile platform and delivers on end user mobile devices and provides training to teh end users to view teh order in PM module.

Confidential

Sr SAP BW/BO Developer

Responsibilities:

• Involved in enhancement of teh data sources in order to add new field as per client requirement.
• Populated teh historical data for new infoobject in infocube by using remodeling method.
• Designed user’s manual for training.
• Extensively worked in end to end implementation in BW-IP for teh budget forecasting.
• Worked in theBODS4.0Environment, teh entire project implementation was on 4.0
• Extracted Data from all teh Relational Databases including oracle, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
• Creating Jobs, Work flows, data flows and scripts in Data Integrator to pull data from teh legacy systems and load teh data into target database. Writing SQL Statements in DI scripts to modify data. Created initial and delta loads.
• Involved in teh production support, and interacted wif teh Reporting developers to change teh code of teh Tables based on their reporting requirements.
• Worked on comprehensive process of Order to Cash cycle posting and reporting.
• Create Functional Requirement Documents based on Adhoc requirements gathered from user
• Worked on simplified Order to Cash cycle like order-to-invoice and invoice-to-cash
• Worked on SD business processes OTC and sales order processing, Delivery, shipping and billing
• Responsible for design of teh data flow and developing DSOs for Line items, InfoCubes for summarization, and MultiProviders for Cross reporting
• Built new DSO’s infoCubes, multi-providers to support SD, FI-CO, GL, PP, GR, and AP reporting requirements.
• Enhanced extract structures for Master Data to bring additional fields in to BI and created custom Data Sources for transaction data to meet teh business requirements.
• Advised teh functional team about teh impact in BI and wif teh extractors when they require a configuration change in ECC.
• Utilized BI 7.0 transformations and DTPs for all new developments.
• Developed new BEx Queries, workbooks based on teh different InfoProviders.
• Involved in performance tuning by maintaining aggregates, compression, partitioning, indexing of info cubes.
• Maintenance of Hierarchies Structures
• Create CKF and RKF as needed and adopt performance on all queries
• Created queries in Query Designer and deployed to teh Portal
• Activated required BW Statistics Objects and created a virtual Cube that is required for Reports.
• Developed process chains to automate teh initialization and delta updating of all data.
• Created over BEX queries and assigned them to roles by department.
• Provided Post Implementation Production Support includes Monitoring teh Process Chains Daily, Weekly and Monthly. Troubleshooting and Correcting teh Data Load Errors
• Resolved Tickets Raised by Users.
• Enhanced teh Existing Reports based on User Requirements to include New Functionality.
• Created Generic extractors for custom table and loaded data into BI.
• Created/Modified custom Infocubes, DSOs, Transformations, Infopackages, DTPs as per teh requirement.
• Created Open Hub Destination for Info Cubes, DSOs and Infoobjects to generate Flat Files.
• Performed Unit testing for teh changes and new functionality and transported dependent objects to test environment and into Production.
• Identified teh necessary Business Content using content browser and content analyzer, mapped teh business process requirements wif teh available Business content.
• Installed and activated teh relevant Business content for master data and transactional data.
• Implemented standard Business Content FI-GL, FI-CO and FI-AP cubes for transaction figures reports.
• Prepared Technical specifications for teh Functional Specifications.

Confidential

SAP BW/BO Developer

Responsibilities:

• Worked on requirements gathering for HR reports from various Modules like PA & OM.
• Worked on data modeling and created Info objects, DSOs, Multiprovider, Infocubes, Infosets, Transformations, DTPs and Info packages.
• Enhanced many datasources and wrote customer exit to get teh data for additional fields.
• Created generic data sources to extract teh data from PA & OM modules.
• Worked on HR Employee, Personnel Actions, Head count and Payroll extractors to pull teh data from R/3 system.
• Configuring master data and business content for POSDM to BW.
• Thorough understanding of SAP BW cubes, POSDM data aggregation, POSDM reports
• Worked on Start routine, Update routine and End routine to extract data for various field.
• Created Process chains to automate teh HR data load process for both Master data and Transactional data info cubes.
• Worked on Transports Maintenance for all developed objects for HR module.
• Created delegation reports for both Org Management and Personnel Actions.
• Worked on HR Structural Authorizations to implement security on HR reports.
• Interacted wif Power users by providing demo and user training on how to use teh various HR reports and BEx tools.
• Delivered teh documents for all new objects and enhancements.
• Worked on support tickets from end users on various issues related to BI reports.
• Monitored Process Chains, loading errors and analyzed system logs and ABAP/4 dumps.

Confidential

SAP BW/BO Developer

Responsibilities:

• Installed Business Content and activated teh SAP delivered Standard InfoCubes and InfoSources
• Worked on Generic Data Extraction (RSO2) to create DataSources for transaction and master data
• Created Views in teh non-SAP database systems and generated Data Source for teh tables/views.
• Maintained customized InfoCubes, Operational Data Sources, and MultiCubes for teh business requirements.
• Defined update and transfer routines in transformation rules.
• Worked on Process Chains to load InfoCube, ODS, aggregate roll up etc.
• Extensively used BEX Analyzer to build queries, queries wif maps and charts and Worksheets to access data from BW data targets.
• Involved in teh development of programs for data conversion, interfaces, custom reports and transmission of data to vendors using advanced concepts like BDC, LSMW, and SAP Scripts