نبذة عني
Analytical and results-driven Senior BI and Data Analyst with considerable experience in optimizing enterprise master data, building data pipelines, designing end-to-end data migrations, and mentoring teams of 5+. Over m…
Analytical and results-driven Senior BI and Data Analyst with considerable experience in optimizing enterprise master data, building data pipelines, designing end-to-end data migrations, and mentoring teams of 5+. Over my 25 years of career, I had the opportunity to work with some of the best ERP solutions such as Oracle|JDEdwards EnterpriseOne and SAP S/4HANA. I am highly skilled in Database handling with extensive experience in data migration, integration, modeling, transformation, BI Analytics and the entire ETL Process. I am an SAP Certified Data Analyst - SAP Analytics Cloud (C_SAC_2601) with strong expertise in SAP Datasphere and SAP Analytics Cloud. Experience on working with popular Relational Databases for Back-End programming and configuring them using PL/SQL for creating tables, stored procedures, table triggers, views, etc.
الخبرة
Senior BI and Data Analyst
<p>Lead a team of 3 Data Analysts and a BI developer.</p><p> Provide management with current and predictive analysis on periodic and ad hoc basis.</p><p> Develop and maintain MS Power BI dashboards with expertise in data modelling, data warehousing and DAX.</p><p> Deliver periodic analytical reports daily, weekly, monthly and annual.</p><p> Perform reconciliation and trend analysis.</p><p> Execute ETL/ELT processes to collect, clean, validate, and analyze data from multiple sources for data migration and on-prem data warehousing.</p><p> Optimize query performance to reduce processing and retrieval time of data.</p><p> Write and maintain PL/SQL queries to retrieve, store and manage data from various tables.</p><p> Create tables, views, triggers, and stored procedures in Oracle, MS SQL Server, IBM DB2 and MySQL databases.</p><p> Support data onboarding, workflow improvements, management KPI tracking, and operational efficiency initiatives.</p>
Senior IT SAP Analyst
<p>Liaised extensively with employees for their requirements and worked on solutions to fulfill requests.</p><p> Defined and optimized data extraction and retrieval, ETL logic, and transformation layers for performance and data quality during data migration and data warehousing for company BI dashboards.</p><p> Designed and implemented SAP Datasphere artifacts including spaces, views, local tables, analytical models, data/replication flows, and transformation flows.</p><p> Connected to SAP data sources such as S/4HANA, SuccessFactors and ARIBA for extracting data for SAC dashboards.</p><p> Managed the integration of Oracle Primavera P6 with SAP S/4 HANA Project System.</p><p> Used Commondo to send and receive Project WBSE details, work order information and scheduling data between Primavera and SAP.</p><p> Used data sources to interact with web-based visualization tools for reporting and analysis.</p><p> Translated complex datasets into actionable items for management KPIs.</p><p> Supported SAP business users in Project System for budget controls, budget versus actual cost reporting, and troubleshooting purchase requisitions, service entry sheets, PO history, GRN, and SAP|Ariba orders.</p><p> Provided basic support for HCM including Employee Master in HCM and SuccessFactors for employee engagement.</p><p> Managed time and attendance using ATOSS for workforce time tracking.</p><p> Worked closely with business analysts, developers, testers and end users to ensure system compatibility and user satisfaction.</p><p> Provided training and user manuals after completion of projects.</p>
Senior Technical Consultant
<p>Developed applications and reports for clients on JDE B7333, 8.0, 8.10, 8.11, 8.12 and 9.10 versions.</p><p> Participated in 8 full implementations of JDE ERP projects at various clients.</p><p> Provided technical support to existing clients by developing applications and reports using JDE tools.</p><p> Performed Visual Basic development for requirements that could not be fulfilled by JDE Development Tools.</p><p> Participated in analysis, design and value addition activities in the ERP system and related process improvements, JDE integrations and system upgrades.</p><p> Performed data migration activities transferring data from legacy systems using standard ETL tools.</p><p> Created custom development to ensure clean data was stored in JDE.</p><p> Developed JDE applications, reports, workflows, table conversions, Financial Report Writer, BI Publisher and NERs.</p><p> Created and updated documents for support activities with respect to business processes.</p><p> Developed custom C# and Visual Basic .NET desktop applications for interfaces between JDE and legacy systems.</p><p> Validated design and other details with stakeholders to ensure deliverables satisfied client requirements.</p>
Software Consultant
<p>Worked as a Software Developer for the full tenure.</p><p> Developed POS applications, Inventory Management Systems, Payroll processing software and other end-user applications using Visual Basic 6.0.</p><p> Used MySQL, MS SQL, Sybase and MS Access as back-end databases.</p><p> Created websites using Dreamweaver, Net Objects Fusion and HTML editors.</p>
Junior Programmer (VB6)
<p>Worked as a Junior programmer for the IT Department.</p><p> Programmed in Visual Basic 6.0, Visual FoxPro 6.0, and FoxPro 2.5.</p><p> Developed small applications to satisfy user requirements and assist in daily tasks.</p><p> Involved in the Y2K project.</p>