We provide IT Staff Augmentation Services!

Sap Bi/bw Consultant, Bw On Hana 1.0. Resume

Dallas, TexaS

SUMMARY:

  • 7 years of professional experience as a sap BI - BW consultant involved in implementation and support applications with client and company satisfaction background.
  • A SAP BW Certified professional in Business Intelligence with NetWeaver.
  • Sound understanding of BI Best Practices/Methodologies, relational structures, dimensional data modeling (OLAP, OLTP, etc.), data warehouse and reporting techniques
  • Handled the assignments alone and as a team by having precise communication with business users in development, enhancement and support projects.
  • Experience in Data Warehousing Workbench applications including creation and maintenance of SAP objects, info providers and data flows.
  • Expertise in master data extraction and transaction data extractions from SAP R/3 using the LO Cockpit, FI and Generic Extractions. Also extracted data from the flat files.
  • Experience in automating loads using Process Chains and Created Process Chains For Master Data, Transaction Data Loads, PSA Deletions and process associated requirements.
  • Handled production support service calls having different priorities involving in reporting, query designer, downloading, extraction and load failures by following SLA standards.
  • Extensive work experience with performance tuning tools. Have good knowledge on functionalities Aggregates, Partitioning, Compression, and Indexes.
  • Involved in transportation process from development to testing and then import the requests to production environments. Have good knowledge on migration process.
  • Proficient in BI related ABAP analysis and have clear awareness of Start Routine, Update Routine, End and Expert Routines, Creation of customer exits, Data Source Enhancements and Generic data source creation using Function Modules.
  • Involved in the process of standard business content installation and extension, Data Load Monitoring, Loading Activities, Debugging and Documentation Process.
  • Designed queries in BEx Query Designer and created Reports in the BEx Analyzer using filters, variables, calculated and restricted key figures, conditions and Exceptions.
  • Created report and workbook broadcast activities and scheduled them on periodic basis as per user requirement with regular monitoring activities.
  • Extensive working knowledge on WAD reports, portal applications to support the end users. Have good knowledge on the phases of ASAP methodology.
  • Involved in project RFP activities and discussions till they get finalized. Achieved projects by giving precise quotations and continued support to benefit company and customers
  • Supported further projects in addition to allocated projects in delivering them as expected. Successfully delivered many sub-projects by involving in them as shadow resource.
  • Having good communication skills, being a smooth team player with excellent interpersonal skills. Have Enthusiastic ability to master in new concepts and technologies.

TECHNICAL SKILLS:

ERP Applications: SAP BI, BW 3.5, ECC6 and HANA 1.0

SAP BI/BW Expertise: Modeling: Expertise in Data Modeling, Data staging and worked in business information warehouse Info cubes, ODS objects, Info object catalogs, characteristics, key figures, transfer rules, update rules, Info sources, Business content, Info packages, multi provider.

Extraction: Involved in extraction of data from flat files and View based extraction and generic extraction.

Reporting: Bex Analyzer, Bex Query, Work books, Info set Queries, Free characteristics, Restricted key figures, Calculated key figures, Variables, Structures, Filters, Conditions, Report to report interface.

Production support: Monitoring data loads, Process chains.

Transports: Release to test system, import the TRs & validation of objects.

EXPERIENCE:

Confidential, Dallas, Texas

SAP BI/BW Consultant, BW on HANA 1.0.

  • Strong analytical skills to solve and model complex business requirements (OLAP, OLTP).
  • Strong in OLAP and relational database management systems.
  • Created Attribute views & Calculation views in HANA studio.
  • Involved in optimizing ETL part and loading the BODS jobs.
  • Assist BO team creating the reports based on BEX.
  • Involved in the BODS jobs creation and extraction among multiples interfaces.
  • Involved in exporting views of BW objects to native HANA.
  • Creating, Importing, and Exporting SAP HANA Data Models.
  • Involved in optimizing the data store object & cubes for the faster data access.
  • Created Composite info providers.
  • Monitoring Process chains for Daily Loads and resolving Process Chains failure.
  • Working on tickets raised by the users for any new requirements or enhancements.
  • Enhancements for Reports, Cubes, DSOs, Data Source.
  • Followed charm process to move the changes across the landscape for BW.
  • Testing Objects for its functionality, Preparing test cases, Test Results.
  • Post upgrade testing across the landscape (Dev, QA, Test and Production environments).
  • Activation of inactive Transformations, DTPs, Data sources and Info Providers.
  • Recovery of data load issues. Handling with Transport requests.
  • Worked independently on development of Batch traceability Project.
  • Worked independently to develop a Sales report comparison of MTD and YTD values current year Vs. Previous year.

Confidential, Bridgeport, Connecticut.

SAP BW 7.3 Developer (Internship) .

  • Create Transformations, DTPs, InfoPackages, DSO, Cube.
  • Loading data manually when necessary.
  • Monitor Process Chains and Fix if any failures occurred.
  • Create BEX Queries and Broadcast to the User.

Confidential

BW Developer/BW HANA.

  • Loads monitoring and process chains monitoring.
  • Optimization of existing old data flows with Hana optimized objects such as Advanced DSO, Composite Provider, etc.
  • Statistics maintenance of daily loads as per the SLA, loads should complete before 6:00AM.
  • Activation & enhancement of data sources for SD.
  • Extracting Master & Transaction Data using Generic Data Sources from OLTP.
  • Worked on BW objects, created advanced DSO, Composite providers, etc.
  • Maintained InfoCube, Transformations and Creation of Info Package and scheduling the data into the DataTargets.
  • Involved in InfoCube maintenance i.e., Compression, Aggregates, Roll-up.
  • Splitting of cube in order to improve loading performance
  • Checking the filter in the DTP.
  • Testing the reports in RSRT.
  • Monitoring housekeeping in RSPC and deleting the PSA tables periodically. Correcting the failed requests based on the analysis of errors.

Confidential

SAP BI/BW Consultant
  • Process chains monitoring and improvements in Process chains performance.
  • Actively Involved in Rectification of Load Failure errors in Master and Transaction data Loads with appropriate communication to teams on action items.
  • Worked on BW objects, created advanced DSO, Composite providers, etc.
  • Creating and Broadcasting Bex reports to the users groups.
  • Running the processes in chains like deleting indexes, creation of indexes, aggregate roll up etc. manually in case of failures.
  • Involved in mapping of info source with the Data targets while extracting data.
  • Extensively worked in PSA, DSO, InfoObject, Cube and Multiproviders.
  • Assist the team members for any issues.
  • Worked on reporting issues and enhancements. Worked on transformation routines and created DTPs and other objects.
  • Worked extensively on BEx Query Designer to create queries on Info Cubes, and Multi Providers and published Web Reports.
  • Handling the tickets based on priority like New/Change requests.
  • Maintaining work History for all the tickets until it is closed down.
  • Development and testing across the Landscape. Interacting with users for testing and moving transports to the Production post user acceptance.
  • Updating the status of loads and the completion of processes to the client.
  • Working on performance tuning to reduce the load timings and make the data available for reporting to customers.
  • Generated various reports using variables, filters, restricted key figures, calculated key figures and free characteristics as per user requirement.
  • To communicate with the clients through Conf. call / Email in order to maintain a smooth flow of business processes.

Confidential

BW Consultant

  • Loads monitoring and process chains monitoring.
  • Statistics maintenance of daily loads as per the SLA, loads should complete before 6:00AM and SLA should be 90%.
  • Activation & enhancement of data sources for SD.
  • Extracting Master & Transaction Data using Generic Data Sources from OLTP.
  • Maintained InfoCube, Transformations and Creation of Info Package and scheduling the data into the Data Targets.
  • Involved in InfoCube maintenance i.e., Compression, Aggregates, Roll-up.
  • Splitting of cube in order to improve loading performance
  • Checking the filter in the DTP.
  • Testing the time of the report.
  • Testing the reports in RSRT.
  • Monitoring housekeeping in RSPC and deleting the PSA tables periodically. Correcting the failed requests based on the analysis of errors.

Confidential

Business Analyst - Revenue Cycle and Data Management

  • Working on receivable analysis & metrics reporting for various facilities
  • Working as a client liaison offering regular suggestions for process improvement to prevent lost revenue
  • Manage workflow of first day and aged billing for multiple departments to maximize collections
  • Conduct presentations to physicians on issues of compliance, coding, receivable status & financials
  • Managing reimbursement functions and revenue cycle.
  • Working on implementing technology that improves accurate billing process.
  • Assist in preparing plans and strategies for process improvements and department roadblocks.
  • Assist in preparing departments Finance/Budgets.
  • Perform employee reviews and prepare suggested paths. Identify appropriate trainings and coursework to help the employee add or improve skills.

Hire Now