نبذة عني
Senior Data Analyst with experience in data analysis, business analysis, data integration, and reporting across banking and financial services environments. Skilled in SQL, Python, Hive, Oracle, TOAD, ERWIN, Microstrateg…
Senior Data Analyst with experience in data analysis, business analysis, data integration, and reporting across banking and financial services environments. Skilled in SQL, Python, Hive, Oracle, TOAD, ERWIN, Microstrategy, Excel, Power BI, Business Objects, SharePoint, Confluence, MS Office, JIRA, and Visio, with a background in requirements gathering, Agile/Scrum, and data modeling.
الخبرة
Senior Data Analyst
Working at Barclays as data analyst and assisted strategic Implementation of a migration project for Market Risk - Equities business by doing the legacy systems assessments, reverse engineered 50+ regional feeds, performed data profiling using discovery and analytical techniques, identified and prepared data dictionary for risk data elements and mapped them into the strategic data model for Data Services System.
Senior Data / Business Analyst
Assisted strategic Implementation of OneRisk migration project for Market Risk - Equities business by doing the legacy systems assessments
Reverse engineered 50+ regional feeds
Performed data profiling using discovery and analytical techniques
Identified and prepared data dictionary for risk data elements
Mapped risk data elements into the strategic data model for Data Services System
Conducted working sessions to gather data requirements from 10+ Risk Mangers from across the regions
Documented inventory of 70+ legacy risk reports/templates/logic's in Confluence
Benefited decommission of 25+ reports with improved business processes and by introducing generic reporting templates
Designed and built Timelines dashboard using key events occurred in the data flows
Visualized and identified white-spaces in 4 of systems processes as well as business users performance in data sign-off processes
Performed extensive data analysis using Toad / SQLs and cutting-edge cube modeling techniques
Presented the transformed risk data into 25+ bespoke reports belong to key desks in Equities
Designed reports distribution to Risk Managers automatically
Reduced 45 man-days per month
Big Data Analyst
Collaborated with 8+ lead product owners and system leads
Identified data sources and interfaces for data acquisitions requirements for Finance and Treasury LoB’s under Group functions
Collected, analyzed and cleaned the structured and unstructured data belong to Finance and Treasury LoB’s
Documented the life-cycle of source-to-target mappings and logical modeling using Erwin
Prepared use cases and architecture diagrams for end to end business process flow
Provided 20+ walk-through sessions to IT team
Ensured the requirements translated into technical solutions
Restructured 15+ OLAP cubes design to improve performance by compressing data
Improved loading techniques
Reduced system maintenance cost by 35%
Senior Data Analyst
Researched and conducted data analysis to source 800+ attributes from 6 different upstream transactional systems into the managed reporting platform in Oracle/Exadata
Transformed complex datasets into meaningful insights using Python / SQL queries
Influenced strategic decision-making in cross functional data sourcing
Ensured data accuracy and compliant with regulations
Refined hierarchy datasets for account, function, company and product
Designed auto clean-ups
Enhanced data quality improvements for 10+ business processes and internal reporting
Managed 2-man team
Defined interface specification for 25+ data feeds
Performed map and gap data analysis in accordance to strategic data modelling
Designed source feeds orchestration
Improved timeliness and efficiency by 18%
Partnered with RAS and 8-man Agile team
Successfully developed 15+ Analytical reports in Microstrategy
Met both IFRS9 and Local GAAP regulatory standards