SAP BW Developer
Resume:
Mala
adlctb@r.postjobfree.com
Dallas-Fort Worth TX
SAP TECHNOLOGY PROFESSIONAL
Certified Information technology professional with diverse and extensive experience focusing on systems analysis and design, training, documentation and systems migration.
Experienced in SAP HANA implementation, SAP BW 7.4 BWMT (BW Modeling Tool) which is combination of HANA Studio and BW, SAP HANA data modeling using Attribute View, Analytic View and Calculation Views.
Replicated data in real-time (SLT Replication) from SAP source systems and non-SAP source systems to an SAP HANA environment using the option Full Load, Replicate, Stop Replication, Suspend, Resume.
Knowledge in SAP HANA 1.0 and 2.0.
Understanding of SAP In-Memory Computing Architecture, Column store, Row store tables in SAP HANA studio, Privileges and roles.
Strong Knowledge in SAP HANA and SAP BW.
Underwent complete life cycle Implementation of BW which includes Data-Modeling, Data Extraction, Generic Extraction, Data Loading, report creation.
Knowledge of Info Objects, Info-Cubes, DSO’s, ADSO’s, Calculation Views, ODS views, CDS views, Analytical Views, Attribute Views, Info Packages, Transformations and DTPs, and BEx Query
Performed worked SAP R/3 LO-Extractions, Generic Extractions.
Comprehensive knowledge using SAP methodologies in Business Information Warehouse.
Understanding Business Objects Web Intelligence (WEBI).
Working Knowledge of SDLC, including testing (Unit, Integration, UAT, FUT)
Strong Leadership skills, Communication, Verbal, Written, Reading, Analytical, Multi-tasking, Attention to Detail and Problem solving skills.
Ability to work independently and in a team environment as well in a fast paced environment.
My StrengthsFinder’s attributes: Focus, Futuristic, Significance, Relator and Learner
EXPERIENCE
MTS – Minneapolis MN Mar 2016 – To Date
SAP BW/HANA Developer
Worked with Business Owners in the Management, Analyzing, Refining, Estimating Efforts and understanding functional requirements and translating them in technical requirements.
Worked on BWMT 7.4 (BW Modeling Tool) Data Warehouse Workbench and customized info objects, ADSOs, Data Sources, Info Packages to move data from Data Sources to staging area PSA, DTPs to transfer data from PSA to Info Provider like ADSO or Info Cube.
Created Transformations to map data fields from PSA, or source Info Provider to End Target and also manipulate data to meet business rules using ABAP.
Utilized Composite Providers in to combine one or more Info Providers for final exposure of the data to reporting tools like Bex, IDT, Webi, Bex Query.
Exposed Bex Queries to webi by enabling ‘Allow External Access to this Query’ option in Bex and using BICS connection.
Installed and created Business Content objects like Info Objects, ADSOs, and Data Sources, Data Source enhancement and created Hybrid modeling with Native HANA views.
Created Info Packages, DTP, Transformations with ABAP for complex Transformations, Info Objects, Info Cubes and ADSOs.
Data Source Enhancement according to meet customer requirement.
Worked on LO Extractions and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from ECC to BW system, Process Chain Monitoring.
Employed Data Sources worked on 2LIS_03_BX, 2LIS_03_BF, 2LIS_03_UM for Material Inventory Management, 2LIS_05_Q0NOTIF, 2LIS_05_Q0ITEM, 2LIS_05_Q0CAUSE for Quality Management 0CRM_SRV_PROCESS_I, 0CRM_COMPLAINTS_I, 0CRM_SRV_CONFIRM_I for Service Orders in relation to Quality Management, 2LIS_11_VADHR, 2LIS_11_ITEM, 2LIS_11_VASCL for Sales Orders.
Created Dimension Calculated views for master data depending on requirements
Created Calculation View or Calculation view with Data Category Cube for complex reporting to combine one or more Analytical views.
Calculated columns and variables for added information not available in the source system.
Hierarchies for hierarchical reporting, Stored Procedures and variables.
Designed Universes in IDT and created reports on these Universes in Webi for On-Time Delivery, Inventory management, Sales Orders, Quality Reports.
Provided end users with Production Support with webi and Bex navigation and issues with reports.
UNITED HEALTH - GROUP Minneapolis MN Aug 2015 – Mar 2016
Systems Analyst
Participated in project planning sessions with Business owners, Project Managers, Business Analysts and Data Architects to analyze business requirements and outline the proposed solution.
Managed and Designed the Universes using Information Design Tool (IDT) and exposed the final data to the Users utilizing Webi.
Liaison between End users, Report Developers and the Data Modeling Team.
Created universes, based on SAP HANA data models like Calculation Views and Analytical Views and defining the necessary connections.
Created BO reports using functionalities like Calculations, Variables, Breaks, Sections, Ranking, Sorting, Drill down.
Implemented the Object-Level Security and Row-level security in Universe.
Designed and developed reports utilizing IDT, Webi.
Assisted with Production Support.
MEDTRONIC INC. – Minneapolis MN Oct 2013 – Oct 2014
SAP HANA Consultant
Worked extensively on Administrator Workbench (AWB), BEx Analyzer
Involved in creating and maintaining Info Cubes, Data Store Objects, PSA, Info Objects, Info Areas, MultiProviders, and Info Packages.
Data Extracting from the Source system using LO Cockpit and Generic Extractions for 2LIS_11_VAITM, 2LIS_11_VADHR.
Involved in Info Cube maintenance utilizing Compression, Roll-up for Aggregates.
Created new reports and maintained existing reports in in Bex Query Designer, with addition of Restricted Key and Calculated Key Figures, Formulas, Conditions and Exceptions.
SIMPBIZ Software Solutions, Minneapolis, MN Feb 2013 – Jul 2013
SAP BW Consultant
Worked with Business Owners in the Management, Analyzing, Refining, Estimating Efforts and understanding functional requirements and translating them in technical requirements.
•Involved in creating and maintaining Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, Multi providers, Info Sources, Data Sources, and Info Packages.
•Worked on Multi providers, Info cubes, DSOs, transformations, DTPs in order to meet the end user reporting requirements.
•Installing Business Content Info Cubes and DSOs and used BC Data sources.
•Involved in deploying the mapping document, detecting the Field-to-Info Object mapping.
•Created Generic Data Sources from table, view for customized data extraction.
MEDTRONIC. Minneapolis, MN Jun 2011 – Dec 2012
SAP Analyst
Participated in the planning, integration, data migration, and testing of the new GCH system based on SAP CRM.
Gathered requirements and developed a clear understanding of existing business functions and processes.
Performed data mapping, data cleansing, and testing during data conversion activities for the systems transition from Legacy systems EARS and EPCR Oracle based systems to Global Complaint Handling (GCH).
Performed GCH user acceptance testing (UAT), performance, and unit testing.
Lead and facilitated weekly project team meetings to review progress and address any issues of concern.
Worked with local business and offshore units to coordinate project activities and meet deadlines.
Worked with stakeholders and IT peers to identify business process improvements through process and system analysis.
Technical skills Summary
Business Intelligence/Data Warehouse: SAP BW7.0/7.3/7.4,SAP ECC 6.0, SAP HANA 1.0. SP08/09/10, HANA 2.0, SAP Data Services 4.0/4.2
Reporting Tools: BEx Query Designer, BEx Analyzer, SAP Business Objects Suite
RDBMS/Databases: Oracle, SQL Server 2000/2005, Sybase, DB2, MS Access
Operating Systems : Windows 95/98/2000/2007/8/10/Linux
Languages: SQL
Testing Tools: HP Quality Center, Quick Test Professional (QTP)
Microsoft Office Suite, Visio
EDUCATION
Bachelor of Science in Business Management (BSBM)
Cardinal Stritch University, Milwaukee, WI
CERTIFICATIONS
SAP Certified Application Associate- Business Intelligence with SAP NetWeaver 7.0
SAP America
SAP Certified Application Associate - SAP HANA 1.0
SAP America
Associate Certificate in Project Management
Auburn University, Auburn, AL
Contact this candidate