Nsikan U

Datawarehouse Designer - 3 Years of Experience - Near 94531


Datawarehouse Designer


Antioch, CA

Education Level:

Some College Units Completed

Will Relocate:



Summary: * 5+ years of experience in IT industry functional and technical experience in customization and implementation of SAP BI/BW. * Professional Experienceas a SAP BI/BO consultant, which includes expertise in SAP Net weaver XI (3.0, 7.0,7.3 and 7.4). * Worked extensively on Business Objects XI 3.1and 4.0 versions, generated different types of reports by using the queries designed in BEx - query designer. * Implemented Five full life cycle implementations for different modules in SAP BI/BW which involves Development, Testing, Documentation, Requirement analysis, End user documentation, Data extraction, Data modeling, Data loading, Reporting and Production Support. Involved in building reports using SAP BO 4.0 and integrating BO with BI and HANA. * Extracted data from Finance module (FI - AR, FI-AP, FI-GL and FI-SL). * Experience in Performance Tuning using Aggregates, Rollup, MultiProviders, Indexing, Partition, and Compression. * Hands on experience in designing and maintenance of InfoProviders and MultiProviders and familiar with creating and customizing of PSA, InfoSources, TransferStructures, Update Rules and StartRoutines. * Expertise in the front end business warehouse components like BEX analyzer, Query designer, Universe, Web Application Designer, Web Reports, WEBI, XCelsius (Dash Boards). * based Planning infrastructure that supports input-enabled Queries on sales infocube. * Resolved performance issues by writing stored procedures and command objects in crystal reports and performed unit testing, system integration testing, and user acceptance testing at various levels. * Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges. * Developed data flows and work flows using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation. * Extracted the data from ECC 6.0 and loaded into BW 7.0 using Data Services XI 3.2 SP1 as an ETL tool for Data Quality. * Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based). * Good Knowledge and Experienced in User Management and security in HANA. * Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing. * Experienced in loading data from tables in HANA Database to BW data marts. * Good experience in SAP BW related ABAP. * Experience in Migration from SAP BW3.x to SAP BI 7.0&SAP BW 7.3. * Experience in Migrating from Business objects 3.1 to 4.0 * Extensively worked with HP QC Tool. * Proactive team player with excellent interactive and interpersonal skills to communicate with team members, developers, clients and end users at all levels. * Efficiently managed teams of various sizes and worked with the team to achieve company and client's goals.