Sap Bw/hana Developer Resume
Minneapolis, MN
PROFESSIONAL SUMMARY:
- Information technology professional with more than 10 years of diverse and extensive experience focusing on systems analysis and design, training, documentation and systems migration. Strong Knowledge and expertise in SAP HANA, SAP BW 3.5, SAP BI/BW 7.x
- 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 utilizing Transformations like Query, Merge, Pivot, Change Data Capture Type 1 and 2, Table Comparison, History Preservation
- Understanding of SAP In - Memory Computing Architecture, Column store, Row store tables in SAP HANA studio.
- Underwent complete life cycle Implementation of BW 7.x which includes Data- Modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring,
- LO-Cockpit, Info Objects, Info-Cubes, DSO’s, ADSO’s, Calculation Views, Analytical Views, Attribute Views, InfoPackages, Transformations and DTPs, and BEx Query
- Extensively worked on SAP R/3 LO-Extractions, Generic Extractions
- Comprehensive knowledge using SAP ASAP methodologies in Business Information Warehouse.
- Knowledge on Business Objects Web Intelligence (WEBI) and Dashboard reports.
TECHNICAL SKILLS:
Business Intelligence/Data Warehouse: SAP BW7.0/7.3, SAP ECC 6.0, SAP HANA 1.0 SP08/09/10, SAP Data Services
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
PROFESSIONAL WORK HISTORY:
Confidential, Minneapolis, MN
SAP BW/HANA Developer
Responsibilities:
- Worked Extensively on Data Warehouse Workbench and customized info objects, info cubes,
- ADSOs, Data Sources, DTPs, Transformations and Composite Providers in BWMT (BW Modeling Tool).
- Set up periodic Data loads from ECC and CRM to BW
- Installing and creating Business Content objects like Info Objects, ADSOs, Attribute Views, Analytical views, Calculation Views and Data Sources.
- Data Source Enhancement according to customer requirement.
- Designed and developed queries to generate reports in IDT and BOBJ Webi.
- Extensively 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 BI system.
- Worked with SAP R/3 Logistics data in loading Sales and Distribution and Material Management data into BI.
- Installed HANA Optimized BC for MM Data Sources 2LIS 03 BX, 2LIS 03 BF, and 2LIS 03 UM
Confidential, Group Minneapolis, MN
SAP BO Developer
Responsibilities:
- Participated in project planning sessions with Business owners, Project Managers, Business
- Analysts and Data Architects to analyze business requirements and outline the proposed solution.
- Created universes, classes, objects, 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, Slice and Dice, Alerts.
- Implemented the Object-Level Security and Row-level security in Universe.
- Designed and developed reports utilizing IDT, Webi, SAP Lumira Discovery and Lumira Desinger.
Confidential, Minneapolis, MN
SAP HANA Consultant
Responsibilities:
- Interacted with the business owners, end users, technical team to understand requirements and translate them into technical requirements.
- Performed data modeling in SAP HANA studio and developed Analytical views for the transactional data, Attribute views for the master data, and Calculation views for reporting.
- Utilized SAP Business Objects Data services to provision data from different data sources.
- Created different transforms using Query, Table Comparison, Key Generation, Merge, Pivot transforms and functions.
- Performed Data provisioning using SAP Landscape Transformation, SAP Data Services, and Flat File methodologies.
- Integrated BOBJ with SAP HANA to create universes and reports.
Confidential, Minneapolis, MN
SAP BW Consultant
Responsibilities:
- 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.
- Creation of Generic Data Sources from table, view.
Confidential, Minneapolis, MN
SAP BI/HANA Consultant
Responsibilities:
- Interacted with business owners, end users, technical team to understand requirements and translate them into technical requirements.
- Performed data modeling in SAP HANA studio and developed Analytical views for the transactional data, Attribute views for the master data, and the Calculation views
- Utilized SAP Business Objects Data services to provision data from different data sources.
- Created different transforms using Query, Table Comparison, Key Generation, Merge, and functions.
- SAP HANA Data provisioning using SAP Landscape Transformation and SAP.
- Created Query level Filters and Report level Filters.
- Created Universes, classes, objects by retrieving data from Relational data bases and defining the necessary connections using Information Design Tool.
- Extensively created Calculations, Variables, Breaks, Sections, Ranking, Sorting, and Drill down using Business Objects Webi reports.
Confidential, Minneapolis, MN
SAP BW Analyst
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 and transactional data from ECC system to SAP BW.
- Designed data models utilizing Info Objects, Info cubes, DSO objects, MultiProviders.
- Monitored data loads using Process Chains.
- Created and managing dataflow using DTP, transformations and info packages.
- Created reports using Bex Query Designer with functionalities like filters, Free Characteristics, Restricted Key Figures, calculated key figures.
Confidential, Minneapolis, MN
Data Analyst
Responsibilities:
- Performed functional testing and user acceptance testing of enhancements to CACS, the consumer collection account management system.
- Created comparative reports on actual and expected results on consumer client accounts.
- Performed consumer product analysis and reporting.
- Managed delinquent credit card accounts by working closely with clients to gather income, investment, and debt information and develop customized payment plans.