We provide IT Staff Augmentation Services!

Sr Sap Hana Lead Resume

Charlotte, NC

PROFESSIONAL SUMMARY:

  • Around 13 years’ experience in SAP which includes Embedded Analytics such as SAP HANA,SAP BW, SAP BPC, Business Objects (BO) following ASAP methodologies in various domains like Retail, Travel, healthcare, Oil & Gas, Chemical and Manufacturing. along with extensive work on the areas of Sales and Distribution (SD), and controlling (CO), SRM, CRM, HR, PP, Materials Management (MM), Inventory Management (IM) and Warehouse Management (WM) and have in - depth business process knowledge.
  • Overall 13 years of combined IT industry and Management Consulting experiences in the area of Business Intelligence, Strategic Enterprise Management, Information Management, and Data Warehouse.
  • Successfully led multiple BI teams and implemented several multi-million dollar Enterprise Hana,(Integrated Business Planning), SAP BW, Business Objects (BO), ( SAP FIORI, TABLEAU, Design Studio, Dashboards, IDT, Crystal Reports), SAP BPC, SAP ABAP for several Fortune 500 companies.
  • Successfully implemented 6 full life-cycle implementations for SAP BI/HANA/BPC using ASAP, Prince2, and Agile methodology in methodologies in various domains like Retail, Travel, and healthcare, Oil & Gas, Chemical and Manufacturing.
  • Proactively supported many projects in different phases of life-cycle including business requirement gathering, business blueprint, architect design and solution, data modeling, Cut-over Strategy, UAT testing, post production support, and business user training.
  • Participated in developing several client proposals and creating Statement of Work (SOW) for different project assessments in the area of Information Strategy, Business Intelligence, and Data Warehouse. Successfully managed and implemented $4 million SAP BI/HANA project for a chemical client by enhancing their SAP BI and ECC systems within time and under budget.
  • Specialized in Analytics and reporting along with extensive work on the areas of Sales and Distribution (SD), and controlling (CO), SRM, CRM, HR, PP, Materials Management (MM), Inventory Management (IM) and Warehouse Management (WM) and have in-depth business process knowledge.
  • Rich experience in BW ON HANA migration, information and data architecture, system upgrades, requirement analysis, solution design, enhancements, implementation and support.
  • Having good Project management experience, project planning, resource planning, resource estimation, project cost and managing the finances of the project, Migration projects, upgrade projects.
  • As a Lead Architect, demonstrated excellent technical, strategic and interpersonal skills as well as effective communication, leadership, team dynamics and issue resolution capabilities.
  • Strong success track helping clients implementing large and complex solutions which best suits their needs.
  • Flexible in dealing with changing organizational needs and a strong supporter of technical innovation.
  • 4 Years’ Experience on Enterprise HANA, BW on HANA and Hana Live with 6 full life cycle Implementations
  • 10 Years’ Experience in SAP BW,Data Conversion, SAP BODS 4.0, 4.1,
  • 6 Years’ Experience in SAP Business Objects 3.1, 4.0, 4.1, TABLEAU, Design Studio.
  • 2 Years’ Experience in Integrated Business planning (SAP BI-IBP-HANA PAK).
  • Led teams across broad technical, financial and business disciplines. Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results.
  • Mitigated risk factors through careful analysis of financial and statistical data. Anticipated and managed change effectively in rapidly evolving global business environments.
  • Defined processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.

SUMMARY OF TECHNICAL EXPERTISE:

  • Experience in Data Provisioning using FLAT FILES.
  • Experience in Data Provisioning using BODS 4.0 (ETL Based Experience in Approach - Building AGILE Data Marts).
  • Experience in Building Data Flows in Designer (to Load the Data to SAP HANA).
  • Experience in Loading the Data from diff files to SAP HANA using SAP BODS (Text files, spread sheets, XML files).
  • Experience in Loading the Data from different SAP ERPS (like ECC, CRM) using SAP BODS to SAP HANA.
  • Experience in Loading the Data from SAP BW 7.3 to SAP HANA using SAP BODS (Open Hub Tables, DSO tables etc.).
  • Experience in Loading the Data from Non-SAP Source Systems to SAP HANA using SAP BODS.
  • Extracting ERP data using SLT.
  • Experience in loading data from CSV, MySQL.
  • Experience in Exporting to Binary and CSV.
  • Experience in Extracting Data with SDA and SDI.
  • Experience in Replicating SAP system tables with SLT.
  • Experience in Real-time replication from ECC to HANA with SLT.
  • Experience in Building Data Flows in Designer (to Load the Data to SAP HANA).
  • Experience in creating an attribute view.
  • Experience in creating an analytic view.
  • Experience in creating a calculation view.
  • Experience in Creating Attribute Views with Hierarchies.
  • Experience in Creating Scripted Calculation view.
  • Experience in Calculated columns in an Analytic view.
  • Experience in Calculated columns in an Attribute view.
  • Experience in Using Variables with Analytic views.
  • Experience in Using Decision Tables with update values.
  • Experience in Using Decision Tables with return values.
  • Experience in Creating Tables: Row Store vs Column Store.
  • Experience in Example Calculations in Columns and Views.
  • Experience in Creating Stored Procedures.
  • Experience in Creating SQLSCRIPT for DELTA Merge.
  • Experience in Creating SQLSCRIPT for Aggregation.
  • Experience in Creating SQLSCRIPT Triggers.
  • Experience in Creating SQLSCRIPT for Synonyms.
  • Experience in Handling Currency Conversion.
  • Experience in HANA, Reporting Layer and Connectivity options
  • Experience in SAP Business Objects BI 4.0
  • Experience in Designing Complex Universes in IDT based on HANA Tables and HANA Views.
  • Experience in WEBi 4.0 on HANA.
  • Experience in Crystal Report for Enterprise with HANA
  • Experience in Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
  • Experience in SAP Business Objects BI 4.0 Explorer
  • Experience in Designing Information Space based on SAP Experience in HANA Information Model using BO Explorer 4.0
  • Experience in Creating reporting using Design Studio
  • Experience in Exploring the Data using BO 4.0 explorer based on Information Spaces created on HANA
  • Experience in Creating Analysis Views using Analysis
  • Edition for OLAP (HANA OLAP connection).
  • Experience Creating dashboards in Tableau consuming HANA Data Models
  • Experience in Information Design Tool(IDT)
  • Experience in Universe Designer Tool(UDT)
  • Experience in Web intelligence
  • Experience in Dashboard Design Tool
  • Experience in BI Launch Pad
  • Experience in SAP BO 4.0, BW 7.3 Integration
  • Experience in SAP BO BI 4.0 SAP HANA INTEGRATION.
  • Experience in SAP LUMIRA
  • Experience in Multi-Dimensional Model in SAP BI 7.4
  • Experience in Infocube Designing
  • Experience in DSO Designing
  • Experience in Process Chains
  • Experience in OpenHub, APD to Transfer data to FlatFiles.
  • Experience in Remodeling of Infocube
  • Experience in BEX Query Designer to consume BW Infoproviders.
  • Experience in BEX analyzer for Office
  • Experience in Creating Calculated Key Figure, Virtual KeyFigures, Restricted Key Figures.
  • Experience in Creating Variables with User Entry/ Default Value, Replacement Path, Customer Exits.
  • Experience in Creating Start Routines, End Routines and Expert Routines.
  • Experience in Datasource Enhancements.
  • Experience in LO-Cockpit Extraction.
  • Experience in Generic Extractors
  • Experience in Function Module Extraction
  • Experience in Infoset Query Extraction
  • Experience in View Extraction
  • Experience in Data Extraction and Data Flow within SAP BI 7.3 NW 2004S
  • Experience in New Data source Concept of BI 7.3
  • Experience in Transformation in BI 7.3(ETL)
  • Experience in DTP (Data Transfer Process)
  • Experience in UPGRADING DATAFLOWS FROM 3.X TO BI 7.3
  • Experience in Business Content
  • Experience in Administration of InfoCubes and Aggregates
  • Experience working with Tableau 9.x and 10
  • Experience working with optimizing Tableau Dashboards
  • Experience in Develop, Design and Support Interactive Tableau Reports.
  • Experience in enabling users to interact with data and develop their own insights using Tableau.
  • Experience in effectively using best practices in Business Intelligence while implementing the Tableau reports.
  • Experience in Administer and support Tableau Infrastructure
  • Experience in Create/Manager Users, Groups, Workbooks and Projects.
  • Experience in Creating Database views, Data sources and Data connections.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr SAP HANA Lead

Environment: SAP ECC 6.0, SAP HANA, SAP BI 7.4, SAP BO 4.0

Responsibilities:

  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Experience working with optimizing Tableau Dashboards
  • Experience in Develop, Design and Support Interactive Tableau Reports.
  • Experience in enabling users to interact with data and develop their own insights using Tableau.
  • Experience in effectively using best practices in Business Intelligence while implementing the Tableau reports
  • Building SAP HANA Strategy & Managing a team of consultants and developing a go-to market strategy for SAP HANA including demand generation, marketing propositions.
  • Propose unique strategy on adopting HANA, more specific to customer Business case.
  • Ability to Re-architect the current BI solution with SAP HANA as Database, BW as EDW layer & BO BI as Analytics solution.
  • Having expertise in delivering HANA projects like BW on HANA Implementations.
  • Adopt and follow SAP’s roadmap on various products like Design Studio, Predictive Analytics & SAP Lumira.
  • Experience in building Hana Views, SDI/SDA and ETl Processing using BODS
  • Experience in writing SQLScript, Writing Procedures, and Triggers
  • Experience in Understanding the Business requirements & convert them into Blueprint
  • Experience in Defining the Design Documents for the Native HANA data models
  • Experience in Essential Configurations for SAP ECC Accelerations using SAP HANA
  • Experience in Translating Functional Specifications into Technical Specifications
  • Experience in Translating the Business KPIs into HANA & Define the Reporting Layouts
  • Translate the Business KPIs for Dashboards & Define the dashboard Layouts.
  • Designing and Developing real time operational reports using HANA live
  • Working with Calculation views of VDM's (Virtual Data Models)
  • Working extensively with Private Views, Reuse Views and Query Views
  • Modeling customized views using Query view in suite on Hana
  • Analyzing customized views using Hana Live Browser
  • Creating report on customized views using SAP Lumira
  • Creating reports on customized views in Web Intelligence (WebI)
  • Generating reports that are accessible from mobile devices like phone and iPad
  • Experience in SAP HANA data modeling using HANA Studio
  • Defining the SAP HANA components (ECC Tables and Non ECC sources to replicate) Replication Process Define HANA Views (Which are basis for Data Reporting/Analysis), Defining the Data Analysis components in BOBJ Define Reporting aspects, analysis components. Reporting Decision Tree, Creating BW and HANA Use cases. Report Rationalization, Defining Strategy and Direction.
  • Data Integration architecture, Define Project Plan, Governance model, Identify the various teams and their responsibilities.

Confidential, Richardson, TX

Sr SAP HANA/BW/BI/BOBJ Lead

Environment: SAP ECC 6.0, SAP FI, SAP HANA, SAP BI 7.4, SAP BO 4.0

Responsibilities:

  • Working very closely with internal client team as well as with the implementation team.
  • Will be walking into the very early stages of the project and will be responsible for blueprinting, requirement gathering, design, strategy and eventually the build of SAP HANA.
  • Experience in Hadoop when there is a large volume and format of data that is unpredictable/undefined.
  • Experience in building Hana Views, SDI/SDA and ETl Processing using BODS
  • Experience in writing SQLScript, Writing Procedures, Triggers
  • Experience in Creation of Synonyms, Sequences, Currency Conversion
  • Experience in Performance Tunning
  • Performed Perform predictive analytics on top of SAP HANA using SAP Predictive analysis tools, and also using open source technologies on top of SAP HANA.
  • Will be leveraging SAP BW with BPC alongside HANA and also installing SAP HANA studio and HANA Live
  • Responsible conducting workshops, providing long term strategy and directions, developing base line and detailed scoping and working with functional teams and steering committee closely. Manage team of 15 team onsite and offsite.
  • Technical development on BW data providers, EDW architecture, configure SMS, single single-on, configure BODS to extract non-sap databases to BW data providers, develop complex reports, develop complex Webi reports and dashboards using BI4.0 tools.
  • Responsible in high level deliverables to implement SAP HANA and BW are System Blueprint, Detail Design Documents, Configured System, Configured interfaces, Test Plans/Test Data/Test Results, User Training, Technical Documentation, and Future Roadmaps.
  • Expert in understanding of the complete Architecture (Data loading, Data modeling & Reporting)
  • Expert in SAP HANA extraction from SAP BW/SAP-ECC/Non-SAP Data sources using SLT, Data Services and SAP HANA Direct Extractor Connection (DXC).
  • Designing and Developing real time operational reports using HANA live
  • Working with Calculation views of VDM's (Virtual Data Models)
  • Working extensively with Private Views, Reuse Views and Query Views
  • Modeling customized views using Query view in suite on Hana
  • Analyzing customized views using Hana Live Browser
  • Creating report on customized views using SAP Lumira
  • Creating reports on customized views in Web Intelligence(WebI)
  • Generating reports that are accessible from mobile devices like phone and iPad
  • Experience in SAP HANA data modeling using HANA Studio
  • Defining the SAP HANA components (ECC Tables and Non ECC sources to replicate) Replication Process Define HANA Views (Which are basis for Data Reporting/Analysis), Defining the Data Analysis components in BOBJ Define Reporting aspects, analysis components. Reporting Decision Tree, Creating BW and HANA Use cases. Report Rationalization, Defining Strategy and Direction.
  • Data Integration architecture, Define Project Plan, Governance model, Identify the various teams and their responsibilities.
  • Implementing SAP HANA solution: SAP HANA Hands-on Experience
  • Modeling (Analytic, Attribute and Cal. Views), Data provisioning, Complex SQL Statements
  • Configure SLT, creating schemas, Implementation of transformation rules by maintaining table IUUC ASS RUL MAP on the LT server, Configuration for non-SAP source system, within the LT replication server, defining RFC connection to source system, defining DB connection to HANA system, defining no. jobs for data replication, SLT issues and resolution on jobs.
  • Created Analytic Privileges, Calculated Attributes, Complex Calculation views, SQL Scripting, created Procedures using SQL.
  • Direct Extractors(DXE) in BW 7.3 (Ex: Sales Order Item Content) using Data Provisioning
  • Developed Reports using Universe (Webi, Explorer, dashboard and analysis tools)
  • Connecting non-sap DB using BODS to HANA DB
  • Experience in SDA and SDI.
  • Migrated MS SQL Database into SAP HANA

Confidential

Sr. SAP HANA/BW Lead

Environment: SAP ECC 6.0, SAP HANA, SAP BI 7.3, SAP BO 4.0

Responsibilities:

  • Working very closely with internal client team as well as with the implementation team.
  • Will be walking into the very early stages of the project and will be responsible for blueprinting, requirement gathering, design, strategy and eventually the build of SAP HANA.
  • Will be leveraging SAP BW with BPC alongside HANA and also installing SAP HANA studio and HANA Live
  • Worked as Solution Architect with progressive experience in Design/Development and Consulting in SAP specializing in SAP HANA 1.0 SP06, SAP Net Weaver Business Warehouse & Business Objects Reporting Tools.
  • Experience in SAP BW/BOBJ with subject matter expertise in Business Intelligence domain integrating to SAP HANA.
  • Worked as Solution Architect with progressive experience in Design/Development and Consulting in SAP specializing in SAP HANA 1.0 SP06, SAP Net Weaver Business Warehouse & Business Objects Reporting Tools.
  • Experience in SAP BW/BOBJ with subject matter expertise in Business Intelligence domain integrating to SAP HANA.
  • Experience includes end to end Implementations, support and upgrade, roll up projects as well as solution architecture and Pre Sales.
  • HANA Modeling and Reporting:
  • Data Provisioning using FLAT FILES
  • Preparation of data, designing and implementing HANA analytical models, data provisioning into HANA tables, and designing and implementing BO reports on HANA data.
  • Data Provisioning using BODS 4.0
  • Experience in building Hana Views, SDI/SDA and ETL Processing using BODS
  • Experience in writing SQLScript, Writing Procedures, Triggers
  • Experience in Creation of Synonyms, Sequences, Currency Conversion
  • Experience in Performance Tuning
  • Building Data Flows in Designer (to Load the Data to SAP HANA)
  • Data Modeling
  • Creating Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
  • SAP HANA SQL
  • HANA, Reporting Layer
  • WEBi 4.0 on HANA
  • Migration of BW to HANA.
  • Migrated HANA content from development, testing environment to Production environment using delivery units.
  • Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
  • BW to HANA Migration and configuration Experience:
  • Migration from BW to BW-HANA.
  • Done the migration with PCA - Post Copy Automation Tool which is an automated solution for delta queue cloning and synchronization on the production systems for BW on HANA migrations based on a BW system copy.
  • Rapid database migration of BW on RDBMS to BW on HANA
  • BW on HANA fresh installation and moving only the required, data models & content, in the process optimize and cleanup the BW system
  • Carving out a part of large BW and moving only relevant content (like for a business unit or region)
  • HANA as real time, high value agile/custom data mart and later migrating BW to BW on HANA
  • New projects, initiatives on new BW on HANA installations.
  • Performs activities required after the initial system copy of a SAP NetWeaver BW system reliable.
  • Done with post migration activities.
  • Worked on creating Data Models - Creating InfoObjects, Datasource, InfoPackage, DTP, Transformations, DSO, Infocubes, Multi providers etc. and optimized the relevant objects for HANA in accordance with LSA++ architecture.
  • Worked in ABAP routines - Start routine, End routine, field routine and Expert Routines in transformations - written codes for master data look-up, filtering data based on complex conditions, used function module for various conversions, etc.
  • Created Transient Providers, Composite providers to import native HANA models to BW and also exported cubes to HANA Studio to leverage HANA optimized BO reporting tools.
  • Created Open Hub Destination to load the BW data to 3rd party system.
  • Created, published and scheduled reports as per requirement on BO OLAP analysis, Explorer and Webi.
  • Implemented cells, workbooks and OLAP variables (like Customer exits, formula variables etc.) in BEx.
  • Extensively worked on BEX analyzer for Office for drilldown reports
  • Created and scheduled Master data and Transactional Data chains to automate data load process.
  • Extensively worked on Business Objects (BO) integration with BW for reporting requirements.
  • Extensive experience on developing Web Intelligence Reports and Crystal Reports.
  • Experience in Business Objects universe designing (OLAP Universes), Business Objects Web Intelligence (Webi), Business View Manager, InfoView, and Business Objects Enterprise (BOE).
  • Below are the activities done exclusively on enterprise HANA:
  • Created Functional Designs and Technical Design documents based on real-time report
  • Requirements to be implemented on HANA enterprise along-with requirements of accelerated BW based reports.
  • Worked on data provisioning from Teradata systems using Data Services and from SAP ECC using SLT servers.
  • Worked on creating Attribute views, Analytical views & Calculation views based on requirements and data-warehousing standards.
  • Worked on SQL based authorizations and CE functions.
  • Worked on row level authorizations & hierarchies

Confidential

Sr.SAP BW/HANA Lead

Environment: SAP ECC 6.0, SAP HANA, SAP BI 7.3, SAP BO 4.0

Responsibilities:

  • Actively involved in the requirement analysis, data modeling and technical implementation.
  • Responsible for Design the FDD's and TDD are based on business requirements.
  • Taking care of production support activities like loading the data, monitoring and improve the System Performance.
  • Worked on Data modeling Considerations.
  • Updating the Marketing attributes from BW to CRM Using APD Interface.
  • Worked on Customer 360 view to increase the effectiveness of employees who are interacting with Customers.
  • Designed and developed the multiple Infocubes and Multiproviders to analyze the Opportunities, Activities, Quotes, and Contracts.
  • Developed the Sales order, Delivery, Backlogs, and Billing info cubes based on the client reporting requirements.
  • Worked on reports (Billings, Bookings and Backlogs) using Bex.
  • Worked on Campaigns (Saves and MSF).
  • Worked on reports (Order process, Saves, Student services, Coaching, Retentions, and Inside sales) using BEx published the reports into the roles.
  • Created the process Chains and automated the load process based on the business needs.
  • Worked with SAP on CRM Extractor Delta Issues and suggested the Basis Team to Apply the OSS Notes in the system.
  • Resolved many issues that came in Production support
  • Environment: SAP BW 3.0B, Oracle, CRM 3.1, R/3 4.0, Java Script, and Non SAP systems.
  • Worked extensively in the finance modules like FI-AR (Accounts Receivable), FI-AP (Accounts Payable) and FI-GL (General Ledger).
  • Installed Business content for FI-GL, FI-AR and FI-AP business content cubes according to the business requirement.
  • Extracted Data from Purchasing and Inventory Management.
  • Extracted data from MM module and uploaded the data into the procurement cubes.
  • Developed and scheduled Business Content data extraction from SAP R/3 Source System and data load procedures.
  • Business Blue Print Phase
  • Preparation of data, designing and implementing HANA analytical models, data provisioning into HANA tables, and designing and implementing BO reports on HANA data.
  • Designing SAP HANA Tables, HANA models (Attribute Views, Analytical Views and Calculations Views) for Sales and Inventory scenarios.
  • Developed complex SQL scripts in Calculation views.
  • Worked on Schemas, table definitions, Attributes, Measures & Hierarchies in HANA.
  • Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application.
  • Involved in SAP HANA Security including User Management, Roles, and Privileges
  • Reporting, Accessing Analytical and Calculation views from EXCEL.
  • Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.
  • Creating Attribute Views, Analytical Views, and Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios.
  • Hana Migration and Configuration Experience:
  • Migration of Oracle 11.2, IBM DB2 LUW 9.7 to HANA.
  • Done with Unicode conversion.
  • BW on HANA fresh installation and moving only the required, data models & content, in the process optimize and cleanup the BW system.
  • Performs activities required after the initial system copy of a SAP NetWeaver BW system reliable.
  • Done with post migration activities.
  • Utilized new BI 7.3, Data flows, transformations and DTPs for all new developments.
  • Developed numerous custom data sources using database views and custom function modules.
  • Implemented new BI 7.3 security authorization objects.
  • Responsible for developing BI data models and designs, configuring custom and delivered BI content, analyzing BI reporting requirements, developing detailed reporting specifications.
  • Involved in activating Business Content for Standard Info Objects, DSO, InfoCubes related to FI, CO-PA, SD.
  • Experience in upgrading to BI 7.0/7.3 and in depth knowledge of migrating data sources from BW 3.5 to BI 7.0/7.3.
  • Involved in creating many complex OLAP variables, DTP routines.
  • Generated CO-PA redesign which involves addition of more fields with complete different flow and was involved in complete end to end testing for all the developments assigned.
  • Performed LO-Cockpit extraction for Sales Order, Sales Delivery, and Billings by extracting Standard Data Sources from the Business Content using LO-Cockpit extraction methods for Transactional data and enhanced them to meet the reporting requirements.
  • Extensively worked on BEX Query Designer, BEX Analyzer for Office, BEX Web Application Designer.

Confidential

Sr. SAP BW/BI/BOBJ Consultant

Environment: SAP Net weaver 04s (BI 7.0), ECC 6.0, CO, FI-GL, SD, BEx Analyzer.

Responsibilities:

  • Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
  • Interacted with the Business Users to analyze the business process and gathered the requirements.
  • Responsibilities included interacting with clients’ business process team; collect all the business requirements, create functional specifications, which would be used by the construction/programming team.
  • Worked with the business in designing and implementing complex technical and functional solutions, identified gaps and addressed the gaps with solutions.
  • Involved in decision-making for the screen layout of Master Records including General Ledger, Vendor Master Record and Customer Master Record.
  • Customized Operating Chart of Accounts, Group Chart of Accounts & Country Chart of Accounts.
  • Created different G/L accounts centrally and at company code level, like expenses, revenue, cash, asset and liability.
  • Performed different transactions like clearing, post with clearing, credit memo etc.
  • Configured vendor account groups & assigned number ranges to vendor groups.
  • Maintained Vendor Group Field Status for General Data, Company Code Data & Purchasing Data which reflected on the Vendor Master Records.
  • Configured Cash discount lost account and set tolerance limits for customers for posting AR documents.
  • Customized the Payment Program to in corporate Company Code Data, Paying Company Code Data, Country Payment Methods, Company Code Payment Methods, and House Banks etc.
  • Designed functional and Technical specifications for Implementation and Development of BO XI R2 over SAP BI.
  • Involved in BW 3.5 to BI 7 upgrade processes and was responsible for design, development and extraction from R/3 Source system and flat files to BW for FI & CO.
  • Extensively worked on SD InfoCube 0SD C03 and data sources 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VCITM and financial data providers, multi provider’s 0FIAP M40 data sources 0FI GL 40 according business needs in SAP BI.
  • Involved in development, integration testing, UAT to Go live production support of OTC, RTR reports.
  • Created new info providers in SAP BI depending upon the end user needs.
  • Developed extract structures and Data Sources in Financial Accounting to facilitate the data extraction to
  • Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC generic extractions and also in BI data modeling like Start Routines and End Routines.
  • Extensively worked on BEx reporting and workbooks using RRI, cell definitions, variable offsets, exceptions, conditions.
  • Master and Transaction Data extraction from Flat files and loading into Info Objects, DSOs and Info Cubes.
  • Performed analysis, design, development and implementation of standard/customized Info Cubes and DSO Objects for SD, FI and SCM modules.
  • Created intermediate write optimized DSO Structures and APD’s in BI7.0 to improve performance while loading AP data.

Confidential

Sr. SAP BW/BI/BOBJ Consultant

Environment: SAP Net weaver 04s (BI 7.0), ECC 6.0, CO, FI, SD, BEx Analyzer.

Responsibilities:

  • Co-ordination of problem tickets with offshore resources (functional as well as technical) to ensure that the tickets are resolved within the stipulated SLAs.
  • Conducted various meeting with key Management in the Financial Management department to discuss various intricacies in the business and the needed development strategies.
  • Extensively worked as Business Analyst, very good experience in User Requirements Gathering, Writing Functional/Technical Specs, Creating BPPs (Business Process Procedure Documents).
  • Configured automatic payment program for out-going payments in A/P.
  • Bank Configuration: Setup House banks for the newly added banks to the company
  • Involved in Functional unit testing, Integration testing and user acceptance testing (UAT)
  • Extensively took part in designing and writing Functional Specifications for various procedures
  • Involved in Conducting Interviews with users to gather requirements and understanding the workflow of the As-Is system. Analyzing workflow to design solutions and designing the To-Be solution.
  • Created, Reviewed and Updated the functional design documents FDS for FI/CO developments.
  • Worked on Customer Master, House Banks, Payment Programs, Electronic Bank Statements and Lock Box and had successfully configured Clearing to clearing open items in GL/AR/AP Modules.
  • Setup the interfaces for the information flow, mapping, and customized the changes
  • Involved in End User Training for FICO and preparing BPP Business Process Procedure
  • Involved in GHR upgrade project and made sure all financial areas are working well by doing regression testing using HPQC system.
  • Developed documentation for customizing automatic payment program (changes in segments according to the bank requirements, SAP bank payment related interfaces).
  • Configured organization structure for company code, field status variant, fiscal variants, and posting periods.
  • Provided user training and prepared user documentation for all important business processes.
  • Payment terms and its application in invoices.
  • Prepared Test Plan and executed the same.
  • Extractions From SAP MM, FI, PP, SD, HR, SRM & Generic Data-Sources
  • Performance tuning -- For Data load, Queries by using HINT table concepts, Aggregates, BWA indexes, Compression, implementing dynamic Semantic partitions (SPO) & analyzing by client Statistics data
  • Reporting Experience in creating complex financial queries with BEX Query Designer, Report Designer, BEX Analyzer, BEx Broadcaster/ Scheduling reports, Web templates, Pre calculated web templates publishing using WAD (Web Application Designer) and integration with BW/BI Security and publishing reports to Enterprise Portal. RRI, Pre-Queries on user roles & Dashboard
  • Reporting Automation of Data loads -- Creating Process Chains and Monitoring, Scheduling Delta loads & Performing Error Handling
  • Moving data to Upstream -- Experience in Data Mart, Open Hub Services, APOs Defect/Change request tracking -- Experience with Mercury Quality Center & Remedy tools for test management, requirements gathering and defects tracking; functional testing and regression testing.

Confidential

SAP BW Consultant

Environment: BW 3.5/7.0, R3 4.6C, BEx, FI, SD, MM, PP.

Responsibilities:

  • Involved in the project from User requirements gathering, Business Blueprint, Realization and Testing Phases.
  • Integrated FI with CO, SD, MM and PP for the logistics and order management trade and Inter-company transactions.
  • Configured the integration steps for Account determination and Revenue account Determination for inter-company transactions
  • Maintaining consistency in the Master Data across systems.
  • New GL Accounting: - Mapping business needs to New GL functionality, Activation Concept, Real time integration of CO with FI, Document Splitting Concept, Parallel Ledger Concept, Segment Reporting, FI Allocations, and Changes from earlier versions, important new GL tables.
  • SAP FICO Security aspects and its implementation.
  • In Cost Center Accounting created the Standard hierarchy, cost centers, assigned cost centers to cost elements. Configured Activities, Statistical Key Figures. Developed assessment, distribution periodic reposting cycles and segment.
  • Setup internal orders and cost collector configuration. Customized order classification establishing a sophisticated system of order settlements and cost center assessment cycles. Statistical key figures and cost element planning.
  • Participated in teams and projects to understand business needs, design and recommend solutions, and provide support on the evolving BI environment.
  • Interfaced the business users to develop an understanding of the business processes and user requirements at a depth sufficient to recommend and implement an appropriate BI solution to meet business needs and address the enterprise BI vision within the company.
  • Involved in BW 3.5 to BI 7 upgrade processes and was responsible for design, development and extraction from R/3 Source system and flat files to BW for FI & CO.
  • Extensively involved in the scheduling and monitoring using process chains in Administrative Workbench.
  • Provided complete solution in BW in the following metrics analytics Sales and Distribution, Account Receivable, Account Payable, and Profit Center Accounting.
  • Managed, and monitored several data loadings, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.
  • Ensured BW data quality, reconciliation and validation with R/3 and external Source Systems, governance, and master/transactional data alignment/realignment.
  • Created queries with variables, filters, exceptions, conditions and developed different reports in SD, AR, AP and PCA functional areas using BEx analyzer.
  • Developed and Tested Web Reports for drill down functionality including updating rules and transfer rules & verifying queries.
  • Extensively used BEx analyzer, created queries with variables, filters and performed detailed reporting, published several web reports and worked on InfoSet queries using BEx analyzer.

Hire Now