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