SAP BW / HANA Consultant Resume Profile

Reference Id: 3714     Posted on Tuesday 17th February 2015      SAP



Please note that this is a not a Job Board - We are an I.T Staffing Company and we provide candidates on a Contract and Full-time basis. If you need I.T.Professionals to fill a Contract or a Full-time Position, please call (800) 693-8939

SAP BW / HANA Consultant  Resume Profile
  Professional Summary
  • Successful information technology professional with more than 8 years of diverse and extensive experience focusing on systems analysis and design, training, documentation and systems migration. Proven achievements in providing hands-on guidance with SAP BW /BI, SAP HANA and other software applications deployment.
  • Strong Knowledge and expertise in SAP HANA, SAP BW 3.5, SAP BI/BW 7.x and Microsoft Dynamics ERP.
  • Around 4 Years of experience in SAP BI/BW ,1 Year in SAP HANA and 3 Years in Microsoft ERP. Worked on projects like Implementation, Development, Maintenance and Support projects.
  • Experienced in SAP HANA implementation, SAP System Landscape transformation (SLT), SAP HANA data modeling using Attribute View, Analytic View and Calculation Views. Knowledge in using SAP BODS.
  • Experienced in importing SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.
  • Understanding of SAP In-Memory Computing Architecture, Column store, Row store tables in SAP HANA studio.
  • Undergone complete life cycle Implementation of BW 7.x which includes Data-Modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring, LO-Cockpit, Info-cubes, Multi-Cubes, SPOs, DSO objects, InfoPackages, Transformations and DTPs ,BEx- Analyzer and BEx Query.
  • Extensively worked on SAP R/3 LO-Cockpit CO-PA, Generic Extraction and different modules like SD, MM and FI .
  • Developed flexible queries using filters, navigational attributes, variables, Cell Editor in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detail level of information.
  • Created the Process Chains to automate the data load and data target administration and monitored the processes.
  • Comprehensive knowledge using SAP ASAP methodologies in Business Information Warehouse.
  • Knowledge on Business Objects Designer, Web Intelligence (WEBI) and Dashboard reports.
  • Involved in design, development of tables, forms, reports, data ports, code units and xml ports debugging/error fixing, testing of completed tasks, Merging, Upgrades and deployment of the whole solution in Microsoft ERP.
  • Expert on Dynamics NAV upgrades, developer’s toolkit. Merging Microsoft service packs on ongoing customer databases
  • Understanding of Sales, Purchase, and Inventory management modules on Dynamics NAV. Experience of add-on module development. Onsite post go-live support to users, client handling.

   

Technical Skills

  ERP                                         SAP R/3 version 4.7, ECC 6.0, Microsoft ERP Data Warehousing                     SAP NetWeaver (BI 7.X), HANA 1.0 Reporting                                  SAP BEx, Web Application Designer Languages                                ABAP/4, C, C++, C/AL, SQL Web technologies                     HTML, XML  

Professional Experience

  Project #1   Client                           Confidential Company Role                             SAP BW / HANA Consultant Responsibilities:
  • Created attribute, analytic and calculation views for Sales and Procurement modules as part of the current POC.
  • Data Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services.
  • Replication of the selected tables of SD from ECC to SAP HANA. Performed transformations during the replication process.
  • Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
  • Monitoring the replication process using SAP HANA studio and SAP LT replication server for transactional integrity.
  • Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE(In memory calculation Engine) studio.
  • Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
  • Migrating standard Infocubes to In memory optimized Infocubes using migration Tool.
  • Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool.
  • Importing the BW Models in to HANA using HANA Studio.
  • Consuming the HANA Models in BW by creating the Transient Providers.
  Project #2 Client                            Confidential Company     Role                             SAP BW / BI Consultant Responsibilities:
  • Oversee the build out of new and enhancement of existing cubes and reports within newly deployed SAP BW / BI Financial Data Warehouse to meet business needs.
  • Involved in designing and creating the respective DSO, Infocube and MultiProviders to best meet the user requirements in a much more flexible way to meet any future change requests.
  • Created various queries and extensively worked on Query Builder objects viz. filters, Structures, Exceptions, Free Characteristics, Restricted Key Figures, calculated key figures, Variables, Offsets and Query Variants.
  • Extensively worked on Web Application Designer (WAD) to develop the templates to meet the business requirements.
  • Responsible for design, development and extraction of data from R/3 Source system and Flat files to the BW system.
  • Created Aggregates and Multi Cubes for performance and efficient utilization of data.
  • Created Process chains for effective scheduling of various processes.
  • Involved in transporting the BW objects from development system to QA for unit testing and integration testing.
  • Created Process Chains which deletes the PSA Data Based on the Retention Periods.
  • Used both initializations with delta update and Full update methods depending on the business requirement.
  • Scheduling settings and Monitor complete flow of data from R/3 cost center, Profit center and Daily data loads of distributor data stored in Flat files.
  • Extracted data from LO Cockpit for SAP R/3 PM Module.
  • Created Info-Packages and scheduling nightly jobs to run using the BW scheduler and handling Process Chains.
  • Extensively worked on improving the performance of queries by creating aggregates and compressions on Info Cubes.
  • Designed and created several Queries using BEx Analyzer, with drilldown functions, calculated key figures using formulas and variables.
  Project #3 Client               Confidential Company   Role                 SAP BW / BI Consultant Responsibilities:
  • Involved in determining the data flow for the business requirements extraction and reporting, and translated these requirements into Dimensional Data Models in BW for Warehouse Implementation.
  • Performed Data Extraction for master data (attributes, texts and hierarchies) and transactional data from CRM system.
  • Scheduled and automated data loads from R/3 to BW, 3rd party systems to BW and also from flat files to BW and optimized the load performance by data selections and number of Info Packages.
  • Created various queries and extensively worked on Query Builder objects viz. filters, Structures, Exceptions, Free Characteristics, Restricted Key Figures, calculated key figures, Variables, Offsets and Query Variants.
  • Extensively worked on Web Application Designer (WAD) to develop the templates to meet the business requirements.
  • Full Implementation of BW which includes Extraction, LO Cockpit, DSO/Cubes, BEx Queries and Work Books.
  • Worked with Report to Report Interface (RRI) to drill down from Info Cube to DSO item and schedule line level information.
  • Worked on design and development of Data Model, which includes General Ledger (GL), Accounts Receivable (AR) and Accounts Payable (AP).
  • Development of Process Chains for Automated Scheduling of all Data Loading Jobs
  • Participating in requirements gathering, design, configuration and testing activities for SAP BI and SAP Net weaver environments.
  • Responsible creating the transport requests and moving the same to Quality Environment.
  • Systematically accommodated complex business rules for pulling SAP R/3 data for MM purchasing.
  • Full Implementation of BW which includes Data-Modelling, Extraction, LO Cockpit, DSO/Cubes, BEx Queries and Work Books.
  • As a part of the BW implementation team, involved in gathering user requirements and data modeling using star schema concepts.
  • SAP BW delta load, Info package creation, transformations and DTP creation.
  • Worked extensively on BEx analyzer and BEx browser. Developed flexible queries using filters navigational attributes in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
  • Extraction Transformation and Loading (ETL) from SAP R/3 system to SAP BW.
  Project #4 Client                         Confidential Company   Environment Role                           SAP BW / BI Consultant Responsibilities:
  • Uploaded master and transactional data from files and SAP as the OLTP source. Worked extensively on administration workbench (RSA1). Customized Infoobjects and Infocubes.
  • Migrated SD, HR, CRM, FI data flow from BW 3.5 to BI 7.0. Migrated transfer & update rules to BI Transformation.
  • Created Info-Packages and scheduling nightly jobs to run using the BW scheduler and handling Process Chains.
  • Created numerous transformations and DTPs.
  • Designed custom Infocubes for company wide Sales, delivery, billing and profitability Analysis with various aggregate periods (business day of the year, business day of the month etc).
  • Worked extensively on BEx Query Designer. Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
  • Worked on monitoring the data loads and correcting the data load errors.
  • Analysed global requirements for conversion into technical specifications.
  • Involved in gathering the Business requirements and worked on to list out the KPI’s to meet Business requirements.
  • Scripted extraction routines for Master data, Texts and Hierarchies. Modified the Application-Specific to Generic data Extractors in CO/PA, LO and cross-application generic extractors.
  • Transport the objects from Development to QA for testing.
  Project #5 Client                           Confidential Company Role                             NAV Technical Consultant Responsibilities:
  • Preparation of the technical specification by understanding business functionality from the functional specifications, according to the client's requirement.
  • Designed & developed custom tables ,forms ,reports related to Sales and FI modules
  • Worked on enhancements in HR & payroll module related to leave encashment, full & final settlement, Time entry, Tax, Attendance, Salary processing & Perquisite on Loan functionality.
  • Developed dataports, XML ports for importing data into Navision & exporting data from Navision to other applications.
  • Upgraded the Navision 3.7W1 version into Navision 4.0SP3 version by using Developer toolkit.
  • Develop data migration tools for migrating customer’s data into NAV
  • Developed Custom reports related to hr & payroll module.
  • Reviewing Coding Standards, preparation and review of test cases.
  Project #6 Client                            Confidential Company   Role                             NAV Technical Consultant Responsibilities:
  • Analyzed and mapped Business processes to Navision and participated in design, development, unit testing and Implementation support.
  • Customized the objects related to sales, purchase, manufacturing, finance and warehouse.
  • Developed complex reports for delivery performance, MIS and order lead time
  • Design and developed code for the customizations recommended for Quality Control ,QC validation ,scrap approval ,inventory, Clearing Account Reconciliation & Commissionable Sales.
  • Involved in Data Extraction & data loading.
  • Testing code for validity of results, accuracy and conformance to specified development specifications
  • Developed dataports ,XML ports for importing & exporting data
  • Developed Gate Inward, Outward Functionality and SMS Alerts
  • Created Custom tables, forms and reports for SD module, debugging and troubleshooting issues related to NAV code
               

Search Resumes

Looking for I.T Professionals on a Contract basis?