Faraz Khan
ad3ws7@r.postjobfree.com
Process and Solution-Oriented Data Analyst Over 10 Years’ Experience
Empowers data-driven decision-making via data reporting, analysis, and optimisation
Analytically minded Data Analyst who combines advanced data modelling acumen with expertise in Extract, Transform, Load (ETL) mapping. Proven success synthesising large quantities of data while deriving actionable insights across heavily regulated financial services arenas. Dynamic, ambitious, relishes challenges and is quick and willing to learn and apply complex processes and procedures. Recognised for experience in project management; defined and delivered robust operational processes in line with structured methodologies (PRINCE2 Foundation certified). Utilised strong communication skills to articulate complex data to non-technical stakeholders in an accessible format. Facilitated process / workflow enhancements via data quality improvements in accordance with Key Performance Indicators (KPIs). Strong technical skills; receptive to new and emerging data analysis technologies and testing methodologies.
//Core Competencies
Financial Data Assimilation Data Mining / Data reconciliation / Warehousing/ Visualisation Trend Analysis Statistical Modelling Business Requirements Document (BRD) Management Stakeholder Engagement Insight Gathering
Performance Management Root Cause Analysis (RCA) Treating Customers Fairly (TCF) Principles Relationship-Building
Complaint Management / Resolution Quality Assurance (QA) Business Intelligence (BI) Artificial Intelligence (AI) Analytics BI Reporting ETL solutions Data Validation
//Professional Experience and Achievements
Barclays 2013-Present
Data Analyst (promoted from Customer Relationship Manager in January 2015)
Promoted from initial role tactfully resolving PPI mis-selling complaints to strengthen customer retention and bank reputation to current role managing how many QA Data analysts delivering insightful data used to advance communications strategy through simple, impactful and compelling visuals, reports and presentations. Subject Matter Expert (SME) on business / bank / external market / bureau data to support Risk teams in developing and optimising strategies:
Liaise with business owners to drive data and analytics technologies for commercial use to mitigate inefficiencies.
Identify, analyse and interpret dataset trends or patterns while overseeing data audits to address concerns.
Manage end-to-end process and workflow mappingusing data capture and modelling technologies and methodologies.
Translate business user requirements into technical designs to support BI reporting and analytics.
Develop and optimise SSIS packages while utilising data transformations for deployment across various environments using both package and project deployment models.
Harness gravitas to secure buy-on to recommendations rooted in insights, test results and risk and performance analysis.
//Professional Experience and Achievements continued
Key achievements
Improved operational efficiency and effective through robust and delivery-oriented product ownership of data and analytics initiatives.
Optimised customer retention having synthesised trends in customer response, acquisition and product migration while investigating root cause factors for complaints and product de-activations.
Managed cutting-edge data analytics products focused on business process and operations improvements.
Led sustainability efforts while driving accountability via data solution documentation, culminating in improved awareness of data and analytics business-wide.
Reduced staff attrition via coaching and mentoring of how many people while championing talent development.
Innovated predictive/analytical tools and statistical data modelling for complex operations and processes.
Citibank 2007-2010
IT Operations Specialist
Consulted with client to delineate their requirements while undertaking primary and secondary market research and performing statistical data analysis using SPSS (including factor and cluster analysis).
Key achievements
Aided strategic decision-making having collated and led complex data analysis.
Harnessed communication skills when presenting complex data findings to diverse audiences and stakeholders.
DevelopedSAS ETL MI daily, weekly and monthly reporting capabilities.
Delivered analysis, data quality exceptions and full life cycle reporting in Excel via creation and maintenance of complex T-SQL stored procedures, views and functions.
Enhanced cross-database reporting using SSRS having created new data warehouse using SQL Server 2005 SSIS Data Flow and T-SQL stored procedures to extract data from a variety of MIS software databases.
Improved data quality by developing new (or re-engineering existing) processes/workflows for data entry.
//Education and Qualifications
University of Northampton (UK) 2010-2011
MSc IT Service Management (ITIL V3)
BSc Computer Science
//Professional Development
PRINCE2 Project Management (Foundation)
//IT Skills
HTML and CSS (Programming) ITSM, JIRA, control-M (Incident Tracking and Scheduling)
Microsoft Office - advanced Excel (VBA / V-lookup, Pivot Table, H-lookup, Macros) Microsoft Project / SQL Server / Visio
Multi-Dimensional Modelling Power BI and Power Pivot (Data Modelling) Python and Spyder Statistical Computer Languages SAS (Analytics, Artificial Intelligence and Data Management) Software Development Lifecycle (SDLC)
SQL Server (SSIS, SSRS) Tableau and Qlikview (Data Warehousing) Teradata (Data Intelligence and Analytics)
T-SQL (including Stored Procedures, Relational Database Models and Performance Tuning)