We provide IT Staff Augmentation Services!

Sap Hana Consultant Resume

3.00 Rating

MI

SUMMARY

  • Having Dynamic 12 years of experience in project designing, development and deploying solutions using SAP BI/BW & SAP BO Reporting Tools.
  • Experienced in SAP BI/BW (BW 7.4, BW 7.3, BI 7.0, BW 3.5), SAP BO (4.0), BPC and HANA
  • Strong knowledge of Extraction, Transformation and Loading (ETL) processes.
  • Extensively worked on Extraction which involves Extracting the data from R/3 to BW by using Generic Extractors for FI - CO & SD Models.
  • Creation and Realignment of COPA data source based on operating concern.
  • Extensively involved in setting up the procedures for extracting the data from ECC by using the LO COCKPIT and GENERIC extractors.
  • Good Hand-on on SAP Integrated Planning.
  • Created and maintenance of Info Objects, DSO, Cubes, Transformations, DTP, Data sources.
  • Created and maintained queries in BEx Query Designer and BEx Web Application Designer for analysis and web reporting respectively which are published in Enterprise Portal
  • Involved in prioritized tickets regarding extractions, performance issues and load failures.
  • Analyzed and corrected production problems as they occur in the SAP BI.
  • Successfully scheduled repair full loads for master data attributes and master data texts whenever new attributes or texts enhanced.
  • Developed and modified end routines for extracting data using extractors and data targets as per customer requirements and Scheduled data loads from SAP R/3 to BW, Monitored data loads which are running hourly, daily, weekly & monthly basis and solving errors when errors occurred.
  • Designed queries using BEx Analyzer Reporting tool for data presentation.
  • Handling on reconciliation issues by checking the data between R/3 and BW systems.
  • Working on process chains to automate the Deleting indexes in Infocube, Process Infopackages, creating indexes, DSO activation, further updating, PSA request deletion & Attribute change run.
  • Involving in Unit testing, Integration testing, Regression testing and User acceptance tests.
  • Regularly involved in Load monitoring of daily, weekly & monthly Data Loads using Process chains.
  • Developed queries for overhead management and profitability analysis and integrated in Workbooks.
  • Worked on Designing dashboards using Web services & Live Office connections to generate dashboards for Live Data.
  • Worked with multiple charts i.e. pie chart, bar chart, straight table, Radar chart, Gauge chart, pivot table & different functions in Explorer
  • Worked on SAP BO 4.0, designed, development and managed Universes in Information designing tool (IDT) which include creation of data foundation, business layer based on adhoc requirements which caters several business units.
  • Used Life cycle manager tool for taking back up's and for transporting across the environments. Used Promotion Management Tool to migrate Universe & Reports from DEV to QA to PROD
  • Scheduled various reports on a weekly and monthly basis and sent the output to users. Developed WEBI and Xcelsius Dashboard's using LIVE Office, QAAWS.
  • Fine tuning of the performance issues by handling the indexes, aggregates and compression.
  • Shared knowledge to team members for different objects and maintained healthy people relationship management, to maintain good team work and Quick learner and good team player with strong interpersonal and communication skills.
  • Worked on implementation and support projects, with expertise in designing the Graphical Star schema view by following the necessary standards to deploy optimized InfoCube data model at the database and reporting levels
  • Proficiency in designing BEx Reports using formulas, selections, structures, calculated key figure, restricted key figure, and used variables, with user entry/ default value, replacement path, and customer exit to provide insight of business intelligence
  • Proven hands-on expertise in setting up the procedures for LO cockpit, involving activating the business content data sources, maintaining the extract structure, generating the data source, activating the data source, enhancing the data source, and using the enhancement RSAP0001 to fill the data into the enhanced fields
  • Thorough knowledge about the connectivity between SAP R/3 and SAP BW systems.
  • Deep Understanding & expertise in SAP In-Memory HANA Architecture, Column store, row store tables in SAP HANA studio.
  • Extensive Experience in activities of developing schemas, importing table definitions, adding connections.
  • Experienced implementing SAP FICO, S4/HANA EMBEDDED with BW/BI - Accounting.
  • Experience with HANA scripts while creating complex SQL views for custom based HANA applications including BO integration with SAP Native HANA.
  • Developed solutions in HANA with various scenarios including multiple parameters, variables.
  • A highly motivated, energetic, and professional team player with excellent analytical, problem solving, communication, and interpersonal skills.

TECHNICAL SKILLS

OPERATING SYSTEM: Windows XP/ Windows 7/ NT/ and UNIX

ERPs: SAP R/3 4.6B, ECC 6.0,SAP BI/BO,BODS, BPC and SAP HANA

Programming Language: ABAP/4 (BDC, ALE, BADI), C, Java 1.2/ 2.0, EJB, Java Servlets, HTML,, ASP 3.0, JSP 1.0, VBScript, Visual Basic 6.0,ABAP Basics-Specific to BW, SQL and CE Functions.

DATABASES: MS SQL Server 7.0, Oracle 8i

Data warehousing And ETL: SAP BW 3.5, BI 7.0, BI 7.3, SAP BI 7.4

Reporting Tools: SAP BusinessObjects BI4.1/ BI4.0 and BEx Reporting, Information design Tool (IDT),Universe Design Tool, WEBI, WEBI Rich Client, Explorer, SQLServer 2008.

PROFESSIONAL EXPERIENCE

Confidential, MI

Sap HANA Consultant

Responsibilities:

  • Involved in requirement gathering from Client.
  • Documented Technical designs for the build.
  • Created various objects and documented the entire built.
  • Worked in unit testing and product testing and supported the build phase till go live part.
  • Provided test scripts and executed test cases for master and Transactional data models.
  • Involved in the Integration Process Testing also responsible for Unit testing, Component testing and peer reviews and documenting the results and tracking the review results.
  • Worked extensively on BEx Analyzer (RRMX) and created queries using BW- Reporting variables, navigational attributes and Filters. Developed workbooks, info set Queries and used RRI jump queries to drill down to other queries.
  • Created Transports and transported the objects from development system to ALT Production System.
  • Involved in discussions with the functional teams, Users and End Users on BI requirements.
  • Involved in Performance Tuning and Data Maintenance by creating and maintaining Aggregates, Compression, Partitioning, Indexing of Info Cubes, and use of Statistics for the same.
  • Created reports using BEx Analyzer such that the execution time is evenly distributed throughout the report by using free characteristics, restricted key figures, calculated key figures, variables, exceptions, navigational attributes, text variables, filters, structures, and conditions
  • Uploaded master and transactional data from flat files, SAP BW, and SAP R/3
  • Worked on production support issues which involved debugging ABAP Routines, Process Chains Monitoring, Data source Enhancement, Remote Cubes, Multicubes, fixing errors and daily ETL Data load (Full/Delta upload) Monitoring of the BW jobs and designed Process chains for Daily, Weekly, Bi-Monthly and Monthly data loads.
  • Developed custom enhancements, editing functional modules, and developing start routines, end routines, conversion routines and lookup from other targets for data transformation.
  • Expert in designing and developing of Modeling, Extraction & Reporting like standard and custom Info Cubes, Info objects, Transformation, Info package, DTP's, DSO, Data source, Characteristics, Key figures, Multiproviders, Enhancement of extractors, Business content Installations, Creating Process chains, Semantic Partition, Objects, Composite Providers, Data Flows & Query-designing.
  • Logic change in End Routines for looking up the fields from one target to different targets as per customer need and on User Exit Programs in BEx queries for populating time periods as per user requirement.
  • Requirement gathering, team member and extensively contributed to HANA Modeling.
  • Worked fundamentally in creating the Technical Document based on Functional Document.
  • Design and development of HANA attribute, analytic and calculation views to meet reporting requirements of sales by material and sales by customer.
  • 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.
  • Worked extensively on SLT to replicate the data from BW to native HANA.
  • Demonstrated to the end user's utilization of the HANA views in the front end tools such as Tableau and SAP Business objects - Web Intelligence.
  • Hands-on in implementing SAP FICO, S4/HANA EMBEDDED with BW/BI.
  • Loaded the Data from Different Files such as Flat Files, Spread Sheets, and XML Files etc. to SAP BW on HANA.
  • Worked on designing SAP BW data Flows (DSOs, Transformation, and DTPs) on the BW on HANA database Scenarios and imported them to the HANA studio tool.
  • Developed various HANA Models/Views, using non SAP Source system for real time data reporting requirement in Financial Month End Closure reporting
  • Design, build and deploy the provisioning of SAP data into SAP HANA platform to support real time report replacing BW extractors.
  • Design, build and maintain virtual data model (SAP HANA views) using SAP HANA Studio.
  • Developed Virtual Provider with BW objects upon HANA Models to use Navigational attributes and Master data related to BW Objects.
  • Responsible for building different Data Models (Attributes, Analytical and Calculation Views) in SAP HANA extracting data from multiple sources.
  • Developed Composite Provider to combine both data from BW & HANA and designed BEx queries upon these Composite Providers.
  • Transported various HANA views to higher landscapes.
  • Worked on Performance Optimizations by using Input Parameters to avoid the performance breakdowns.

Environment: SAP BW 7.4, SAP 7.3, BEx Reporting, SAP Business Objects BI4.1/ BI4.0/ XIR3.1, SAP HANA, Information design Tool (IDT), Universe Design Tool, WEBI, WEBI Rich Client, Explorer, SQL Server 2008.

Confidential, MI

Sap BW / HANA Consultant

Responsibilities:

  • Onsite Coordinator and was responsible for BI and BO RICEWF Objects.
  • Involved in requirement gathering from Client and Provided Estimates to BI and BO RICEWF Objects also Worked on Work plan on BI and BO for the Build phase.
  • Involved in Functional Design transitions also discussions with the functional teams, Users and End Users on BI requirements.
  • Ensured LSA standards, naming conventions during the development of data flows for various areas like FI, MM, SD and PP areas.
  • Worked on SAP BO 4.0, designed, developed and managed Universes in Information designing tool (IDT) which include creating data foundation, business layer based on adhoc requirement which caters several business units.
  • In Web Intelligence, developed wide variety of advanced and complex reports using functionalities like, Cross Tabs, Forms, Tables, Sections, Breaks, Sorts, Ranking, Prompts, Drill-Up, Drill-Down, Drill-Across, Drill-By, Charts, Formatting Cells and Blocks, Conditional formatting using Alerts, Formulas, Variables, Functions, Report Filters, Combined Queries, Sub Queries, Merged Dimensions.
  • Created Technical specifications and standard modeling documents for HANA.
  • 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.
  • Created virtual info provider based on HANA models. Created WEBI report based on HANA models using IDT.

Environment: SAP BW 7.3, BEx Reporting, SAP Business Objects BI4.1/ BI4.0 and SAP HANA.

Confidential, GA

Business Analyst

Responsibilities:

  • Involved in BI requirements gatherings by interacting closely with the Users & Functional team.
  • Documented BI requirements.
  • Involved in Workshops end users & Power Users.
  • Involved in transformation for writing routines and Involved in Master & Transactional data load
  • Creating objects for Billing Document Header Data and Billing Document item Data model for Aqua, Harmon and Reporting Layers .
  • BW enhancement on Billing and FI data sources and Extraction of Billing Data from ECC to BW.
  • Conducted brownbag sessions on prioritized topics identified by BW team which included BI topics.
  • Worked on incidents and problem tickets, as well as data load issues.
  • Created Process chains of Master and Transactional Data loads and Created Queries / reports for the Users.
  • Assisted the team in analyzing the incidents, problem tickets, data load issues as well as in attending meetings with the users to clarify the issue and to get additional information.

Environment: SAP ECC 6.0, SAP BI 7.0, and SAP BW 3.5. & BEx Reporting.

Confidential, GA

Business Analyst

Responsibilities:

  • Lead the SAP BI, BO and BPC teams for the deliverables.
  • Involved in designing Architectural diagrams for SD, CRM, FI and Vistex modules using Visio.
  • Involved in Functional Design for SD, CRM, FI, Vistex and Master Data.
  • Worked on Identifying fields on ECC and CRM data sources.
  • Worked on CRP System for BI development.
  • Worked with APO team (Demand planning)for SAP-BI requirements.
  • Involved in BI requirements gatherings by interacting closely with the Users & Functional team.
  • Involved in Workshops end users & Power Users and Documented BI requirements.
  • Involved in transformation for writing routines, Created Cubes, Multiproviders, Master Data & Transactional data loadings and Created Queries / reports for the Users.

Environment: SAP ECC 6.0, SAP BI 7.0, and SAP BW 3.5. & BEx Reporting.

Confidential, NE

Sr.BW Consultant

Responsibilities:

  • Worked as an Team Lead, Interaction with onsite and Offshore Team, task distribution responsible, maintaining issue tracking tool for all the deliveries from offshore .
  • Responsible for daily loads, reports availability of (BW 3.1C & 7.0) for clients and to the users. Always direct interaction with the Users of and resolving their issue and Responsible for the Daily, weekly& Monthly status reports.
  • Involved in Daily Data Load Monitoring (BW 3.1C& 7.0) analyzing the reasons for frequent failures of jobs & maintained in a file. Identifying the correct OSS notes when it is required.
  • Worked on SAP Integrated Planning data models
  • Unit testing for different tasks executed within the team for delivering Quality work.
  • Created Transports and transported the objects from development system to ALT Production System and Involved in Extraction And Loading the Data in Quality & Testing Systems
  • Extraction Of the Data from Info spoke to Files through Open Hub Service Process .
  • Reconciliation of the Data b/w R3 and BW wrt MTD & YTD and updating them on the Portals.
  • Involved in creation of reports using BEX Analyzer such that the execution time is evenly distributed through out the report by using Free characteristics, Restricted key figures, Calculated key figures, Variables, Exceptions, Navigational Attributes, Text Variables, Filters, Structures and Conditions and Transporting Queries from one system to another as well testing the queries& Validations.

Environment: SAP ECC 6.0, SAP BI 7.0, and SAP BW 3.5. & BEx Reporting.

Confidential, IL

BW Consultant

Responsibilities:

  • Worked with the Users on Production Support issues of (High Medium and Low Priority Tickets) and Involved in escalating high-prioritized tickets regarding reports, performance issues and also loads failures.
  • Monitoring the Dependant& Non Dependant R/3 Jobs of the Data Loads & Informing the Data Centre Team to Bump the BI Jobs if the R/3 Jobs are not released or Active in Status.
  • Resolved Priority Tickets of the End Users based on SLA (Incidents & RFC’s).
  • Involved in Upgrading from 3.1c to BI 7.0 Process and Key Role in resolving Issues related to insufficient of Table Spaces.
  • Created process chains for SD, MM, module and Enhanced process chains whenever the data model is changed also Involved in writing ABAP codes in infopackage to bring in data according to business needs.
  • Provided high level of customer service to end users, business units and groups.
  • Coordinating with functional teams to solve BW Incident tickets.
  • Creating Multi providers and comparison reports for monthly validation and reconciliation.

Environment: SAP ECC 6.0, SAP BW 3.5. & BEx Reporting.

We'd love your feedback!