Haseeb Arshad Email & Phone Number

Philadelphia, Pa, Us

Colmar, Pennsylvania, Us

Work as a Lead Data Warehouse Architect for HANA EDW (Enterprise Data Warehouse) using SAP Big Data Intelligence solutions with SAP HANA, SAP Data Services 4.2, SLT and SAP BI Platform 4.1 to design and develop enterprise data marts for various business areas.Defined, managed and evolved BI Solution architecture roadmap to ensure that the BI and Analytics solution can continuously improve value driven insights. Actively participate in project chartering, Budgeting and business requirement sessions as a means of assisting the Business Architect in crafting such artifacts. Presented Solution Architectures to business and IT stakeholders. Reviewed solution designs and participate in code reviews as part of delivery projects. Manage data movements across platforms to minimize cost. Architected, designed and developed End-to end Reporting solutions from ETL>Data Modeling>Reporting and Dash boarding. Performed extensive performance analysis on all levels of reporting. Extracted, Transformed and Loaded data from multiple data sources in Enterprise Data Ware house using SLT and SAP Business Objects Data Services. Remodeled data in SAP Hana from SAP BW and SQL server 2008 to make HANA as EDW.Modeled Data in SAP HANA using highly proficient data modeling techniques Created HANA CDS Views to leverage HANA DATA modeling capacity. Design and develop ETL processes and data structures for the Data Warehouse following best practice procedures using BODS and SLT Provide leadership to ETL tasks and support production Data Warehouse load issues as needed Architected and maintained Qlik Sense Reporting environment. Created next generation Apps in Qlik Sense to support Sales and Marketing team which helped company generate 3 Million Dollars profit in new business area in Fiscal year 2019. Successfully tuned long running Batch Jobs and HANA Models to significantly cut down run time by doing analysis on execution Plans at DB level.

Mumbai, Maharashtra, In

Leaded integration architecture for developing pre-packaged Integration developments working with product owners from establishing requirements thru to implementation of the process and establish design principles and architecture for implementations.Worked with product manager to define software requirements and assess feasibility of design within time and cost constraints.Support the total design effort and participate in multiple projects, solve complex problems, and provide mentoring and support to junior engineersMigrated reports from BO 3.1>4.0> 4.1Generated WebI reports using BEx Analyzer, Query Designer on top of BICS connection and OLAP universe.Created OLAP Analysis and Explorers Created Universes to provide common platform for Service level reporting.Deep understanding of BW 7.0, 7.3 and 7.4 on HANACreated .UNV and .UNX universe on top of OLAP and RDBMS data sources such as SAP BW, HANA and Oracle 11g. Also Created Multi source universe using IDT.Modified /Deployed BO Audit universe and created custom reports to fulfil Audit needs.Modeled data in SAP HANA using attribute, calculated and analytical views.Extracted data in SAP HANA through SLT and BODSUpgraded required universes from .UNV universes to .UNX universes.Changed data sources in all reports from .UNV universes to .UNX universes.Created detailed documentation of all technical steps and prepared end users training documentations, also provided training to users.Tracked the lineage of data flows between BW, Business Explorer (BEx) query and BOBJIntegrated SAP Businessobjects with Microsoft live office to create excel and Power Point reports.Created data models and App design using QlikViewExtracted data through multiple data sources in QlikView and generated QVDs as required.Provided solutions for product bugs with SAP BO suit by trouble shooting, OSS notes research, message posting and working with SAP Engineers.