Crop Picture
NOTE: Do not upload any image that violates our Picture Policy. Doing so will result in the removal of the concerned image without prior notification.
Summary
Masters degree as M.C.S & Bachelor as B.S with professional hands on experience as data Analyst, Project Management, ETL, Business Intelligence tools(Power BI), Data Mining, Data insights, SQL, troubleshooting and supporting information systems experience for more than 15 years. Proven track record as a successful individual. A team oriented professional with extensive experience in Financial Sector plus information Technology as Data Analyst. Highly committed to the role assigned to me and to produce results. SPECIALTIES * Data Science / Data Analytics / Business Intelligence / Dynamic Live Dashboards * Software Development / ETL / SQL / Python / Database Management System* Process Automation / MIS Reports* Banking Operations / Regulatory Compliance* System Administration / System Troubleshooting / Data Backup /Networking * System Analysis / IT Training / Data Center Operations* IBM Enterprise Content Management - Documents Archiving SIGNIFICANT ACHIEVEMENT * Awarded - Internal Audit's Value Champion - HBL* Successfully launched Live Continuous Monitoring and Branch Audit Dynamic Dashboards for HBL-IA * Provided robust delivery of Internal Audit Data Analytics solutions for various stakeholders (Management Audit, AML/CFT, BRR, Remittances, Branch/Branchless Banking, HR, Management Audit, Regional Audits) as per yearly plan Designed, developed and implemented in-house Employee Profile Management Software for HBL -Country Credit Administration.* Deployed IBM Content Manager (Documents Archiving) all HBL Regions PAN Pakistan successfully.
Page 1 of 4
* IT Training to more than 35 staff members of Credit Administration Division for IBM Content Manager.* Automated the process of Credit Proposals routed to RISK Head /President of the Bank.* Evaluated, selected and optimized ECIB (Consumer / Corporate Loan Information) Automation processes for Regulatory Compliance and timely Reporting.* Key Player in preparation, Consolidation of Budget (CAPEX-OPEX)- HBL Risk Management Group.* Automated the process of various MIS extractions and forwarding mechanism to HBL Regions PAN Pakistan.* Developed in-house Database validations to strengthen loanportfolio.* Acquired / maintaining dedicated file Sever for HBL Credit Administration HOK.
Projects
Experience
Unit Head Data Analytics and Insights
· Lead the development of AI solutions that will enable whole universe of Internal audit department to deliver its Data Analytics demands from different IA-Functions such as Continuous Monitoring / AML-CFT, Branchless Banking, Remittances, Management Audit, Islamic Audit, Investigation Unit, Planning Packs for Branch Auditing, International Audit Teams and Debit/Credit card Analytics.
· Developed and implemented Continuous Monitoring/Brach Audits/ Regional Audit virtually dynamic dashboard for Internal Audit aligned with regulatory and stakeholders’ requirements
· Prepared ERD (Entity Relationship Diagram) for the data requirements associated Analytical needs
· Designed methods for extraction of Data with relevant IT and Data Custodians for structured / unstructured Data
· Preparation of Data Models, appropriate relationship among related tables, queries
· Design and execute complex data analytics queries to obtain desired results using advanced analytics tools.
· Designed and implemented visualization with actual data reference based on requirements submitted by the Data & Visualization Architect.
· Develop algorithms for rule-based analytics and machine learning for AI based solutions
· Execute data mining to enhance self-extraction capability from Equation
· Deliver exception reports based on testing objectives and implemented solutions to enable automation
· Translate layman requirements to data-oriented requirements for BRD
· Perform data abstraction, cleansing, validation, modeling, interpretation and Reporting
· Train Backup staff as succession planning and business continuity. pre-requisite will be awareness of RDBMS (Relational Database Management System) including data analytics, queries, reporting,
· Provide recommendations on report design, especially around data visualization best practices, and creation
· Manage multiple projects from conception to completion, by anticipating challenges and ensuring deadline
· Maintain database and analytics servers, Data Quality Management
· Analyze output to ensure efficient and error free data is supplied to stakeholders
· Implemented KRI / Planning pack for Branch Audit Annual Audit Program
· Power Query M-Query / DAX Studio, SQL and DB, Core Banking Data Engineering
Senior Analyst (ECIB & Data Management)
• Interpreting data, analyze results using statistical techniques and provide ongoing reports
• Developing and implementing databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
• Identify, analyze, and interpret trends or patterns in complex data sets
• Locate and define new process improvement opportunities
• Support Departmental Head to Manage Huge Corporate/ Consumer Loan/Master Data as per Regulatory reporting formats
• Process Optimization.
• Data Cleansing & Data Accuracy
• Scorecards, Presentations
• In Depth Analysis of Electronic-Credit Information Bureau (eCIB)
• Pre-Post Reconciliations of various MIS for regulatory compliance
• Training Regional/ Head Office
• Backup/Availability of Data
• Maintains client confidence and protects operations by keeping information confidential.
Manager IT/Data Analyst
• Manipulating / Cleansing & Processing raw data using Excel, Access and SQL Server 2008 R2.
• Application development, VB.NET, VB 6, Database Server SQL Server, MS-Access
• Collecting, collating and carrying out complex data analysis in support of management requests, also involved in reporting statistical findings to work colleagues, senior managers and departmental heads.
• Responsible for loading, extracting and validations of various reports and databases includes Central liability statement, Collateral data, overdue data, Non-Performing Loans, Deposits/Lending and (ECIB)
• Creating and monitoring the automated loading processes.
• Preparing and circulating various MIS reports for all HBL-Regions pan Pakistan (Weekly/Monthly)
• Ensuring critical weekly, monthly, quarterly, annual and regulatory reports are prepared according to agreed procedures.
• Data auditing, creating data reports & monitoring all data for accuracy.
• Advance working command on MS-Excel & VBA Macros.
• Actively involved in Budgeting process of HBL Risk Management (OPEX/CAPEX).
• Advising on the suitability of methodologies and suggesting improvements.
• Various in-house reports and databases i.e. ECIB, Past-Due-Obligation, Portfolio management, Large Groups Exposure.
