PROFESSIONAL SUMMARY:

• SAP BI/HANA Developer with over 7+ years of experience in Design and Development involved in 3 full lifecycle SAP BW/BI solutions using the ASAP methodology process which includes Requirements gathering, Gap Analysis, Data Extraction, Data Loading (Full/Delta Up - Load), ETL, Scheduling, Monitoring, Reporting and InfoCube Performance Tuning using Aggregates & Roll-Up, Compression of an InfoCube and Indexes generation.
• Modeling & Customizations - Extensive experience in data modeling using BW extended star schema and entity relationship model. Involved actively in enterprise data warehousing (EDW) strategies. Worked on activating standard Business Content, extending the delivered structures and enhancing data sources according to business requirement.
• BEx Reporting - Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, and Web application designer.
• Business Objects - Excellent experience in designing Business Objects universes, Xcelsius/Dashboard, Complex Web Intelligence Reports and Crystal reports.
• SAP HANA Certified with extensive knowledge of Modeling in SAP HANA studio, Data Provisioning, and User Management. Created Attribute, Analytic, and Calculation Views.
• SAP HANA SQL SCRIPTS - Strong experience on Creating SQL, Stored Procedures with SQL Script and with Calculation Engine (CE) functions and Debugging SQL Script
• Worked on BW 7.3 platform, designing technical specification documents using the new info providers like SPO, Hybrid provider, Analytical Index, Transient provider & BWA.
• Highly motivated, adaptive to new technologies and possess excellent Interpersonal technical and analytical skills.

TECHNICAL SKILLS:

ERP: SAP R/3, ECC 6.0. 4.7.

Data Warehousing: SAP BI 7.3, 7.0 & 3.x, SAP HANA 1.0, SAP BO, SAP BODS, IP.

SAP Modules: FI, CO, HR, SD, MM & SCM.

Reporting Tools: BEx, Query Designer, BEx Analyzer, Business Objects XI 3.x, 4 .0.

Operating System: RHL, Windows NT/XP.

Databases: DB2, Oracle, & SQL.

PROFESSIONAL EXPERIENCE:

Confidential, Calgary

SAP HANA Consultant

Responsibilities:

• Highly motivated, adaptive to new technologies and possess excellent Interpersonal technical and analytical skills.
• Involved in collaborating with Client managers, DBA’s, reporting team, Business users and other stakeholders to understand SAP HANA and the existing landscape.
• Created a high-level and detailed HANA implantation and migration plan and develop a training plan.
• Imported Selective Metadata for SAP BODS 4.1 imported Metadata in the ETL process prior to on boarding data into SAP HANA, created schemas and data provisioned using SAP LT Replication Server SLT.
• Developed Business Object Data Services BODS 4.1 jobs to pull external data from Flat files and Oracle into HANA database.
• Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the Calculation views as final model in HANA studio.
• Worked with various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table Comparison in Platform and DI Transforms and extracted data according to the business rules and Technical specifications.
• Created master data objects as Attribute views, joined multiple master data table depending on the requirement, selected key figures and attributes to give context to the master data.
• Involved in creation of Analytical views to support, multi-dimensional reporting by joining Fact table data foundation to modeled dimensions attribute views, selected attributes and measures.
• Created Calculation views using database tables, attribute views and analytic views, to address complex business requirements created SQL Script based Calculation views.
• Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE studio.
• Created Database for Supply chain and Inventory executive dashboards using Design Studio.
• SAP HANA Security activities like User Management, Assigning Roles to users and Managing Analytical Privileges.
• Accessed HANA data as Pivot tables in Microsoft Excel through via MDX provider.
• Integrated HANA views with Reporting like SAP Lumira, MS Excel, IDT and Crystal reports.

Confidential, Houston, Texas

SAP BW/BI Analyst

Environment: SAP ECC 6.0, SAP NW BW 7.3, SAP BOBJ, SAP HANA 1.0, Big Data- Hadoop

Responsibilities:

• Implemented 3 full lifecycle including Gap Analysis, Blue-Printing, Reporting and integration to BO reporting tools like WEBI, Dashboards, and Analysis for Office/Analysis edition for OLAP.
• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information Design tool)
• Created a custom complex Procurement Procure to Pay (P2P) and epayables report key metrics like Vendor evaluation, Invoice paid late, Average PO Processing time, Spend Captured in MM, System created PO, Invoice Processing time and Rate Validation to increase process efficiency and maintain compliance.
• Defined technical structures to facilitate SAP BI metrics project for Procure to Pay (P2P) reporting and dashboard to meet customers analysis requirements.
• Developed and conducted manual and automated tests in HP Quality Center; coordinated user acceptance testing-created the test scripts in excel, consulted with the users and captured results; worked within project scope and met milestones; conducted functional testing in production client for go-live.
• Handled tickets related to production system issues.

Confidential, Aberdeen

SAP BW/BI Developer

Environment: SAP ECC 6.0, SAP BI 7.0- Xcelsius, Crystal Reports & WEBI, FI, and BEx Suite.

Responsibilities:

• Designed and Developed write optimized DSO's for EDW layers and standard DSO for the consolidation layers and created a direct update DSO's by activating Business content for Accounts Payable (AP), Account Receivable (AR).
• Extracted data from the finance modules like AR, AP and GL and enhanced the standard data sources 0FI AP 04, 0FI AR 04 to meet the client requirement and enhanced the business content data sources by appending structures, User Exits and customized delta.
• Created Transformation mappings, DTPs, Info packages for all above DSOs and performance enhancement features such as Cube Indexing, maintaining Aggregates, Rollups and Cube compression.
• Worked on Accounts payable and accounts receivable cubes and enhanced the performance (Modeling, Data load) from other systems and did currency conversions for Country specific.
• Created process chains for periodic upload of master data, transactional data, and text data and scheduled and monitored the data loads with delta update and full update mechanisms.
• Created Transformation Routines, Start Routines, and End Routines as per the requirement and for the lookups from one DSO to other data targets. Testing and Debugging of routines.
• Involved in Query performance analysis and tuning through data model, query definition, Aggregates, OLAP Cache, and Database Statistics.
• Created BEx queries for reporting on InfoCube, ODS, and Multiproviders.
• Published the reports on the web using Web Application Designer using the wizard as well as drag and drop web items like ad-hoc, table, and filter for creating customized web templates according to the user requirements.

Confidential

SAP BW/ BI Developer

Environment: SAP BW (3.5), SAP Netweaver 2004s (BI 7.0), SAP R/3 ECC 6.0, BEx Analyzer, WAD, FI/CO, Enterprise Portals.

Responsibilities:

• Involved in 3 full life cycles of the project in Technical design. Carried out the requirement analysis with users.
• Implemented SAP BI 7.0 for SD, PP, MM modules.
• Involved in analyzing and designing the data from ECC to BI and responsible for deployment.
• Responsible for design, development and extraction of data from ECC source system into BI from SD, PP and MM using LO Cockpit extraction methods.
• Extracted data from data sources like 2LIS 02 ITM, 2LIS 02 SCL, 2LIS 02 HDR and populated into the Infocubes 0PUR C07, 0PUR C08, and 0PUR C09 to evaluate service levels.
• Performed LO-Cockpit on Header and Line item data from the Sales and Distribution(SD) modules (Sales Order "2LIS 11 VAHDR/VAITM", Shipping/Delivery "2LIS 12 VCHDR/VCITM") and (Billing "2LIS 13 VDHDR/VDITM").
• Maintained Hierarchy of Cost Center Accounting and Profit Center Accounting and loaded these files to BPC for Planning, Budgeting, Forecasting and Consolidation.
• Developed and maintained the objects necessary for loading Master and Transactional data staging to PSA, DSO and Info Cubes.
• Created reports like confirmed quantity, item purchase orders and purchase order values.
• Published reports on the web using Web Application Designer using the wizard and web items like ad-hoc, table and filter for creating customized web templates according to the user requirements.
• Extensively created Variables, Conditions, Exceptions, Exception Aggregation, Customer Exit Variables and Structures for developing complex BOBJ reports.
• Created Dashboards in Xcelsius reports on purchasing data and periodic plant stock and published on Infoview and provided access to the end users.