Shahzad Sundrani

• Scope review sessions with business key holders. • Coordinated between different integrated matrix teams (Project management, Web Development, Business operations) for Data Integration and warehouse projects. • Create and modify data model into existing data warehouse. • Monitor data loads and take appropriate action in case of failure. • Communicating and coordinating with client.

• Leading a team for end to end process flow including dimension data modeling, data extraction, data loading and dashboards • Implementation of Data Lake Project on Cloudera. • Data Integration with misys (core banking) system. • Data analysis using Hive query language and Impala. • Played multiple roles while leading the projects. Acted as a BA, technical & functional key personal and tester.

• Collaborate with AI (artificial intelligence) team and provide update to all ETL activities within schedule and provide support to all large data volumes and assist in data processing. • Analyze and interpret complex data and provide resolutions to data issues. • Coordinate with business analyst to validate requirements. • Validate data flows and prepare ETL processes according to business requirements. • Perform root cause analysis and resolve production issues.

• Responsible for implementation of SAS AML for Branchless Banking system • Responsible for implementation and maintenance of SAS Anti Money Laundering (Transaction monitoring) system of core banking • Troubleshooting of Alert Generation Process. • Responsible for Ad hoc data reporting using Oracle and SQL Server • Automation of data reporting via SSRS • AML Scenario Customization with reference to business needs.

• Data Mapping and Data Cleansing • Coordination with clients. • Anti Money Laundering Scenario Customization • Execution and troubleshooting of Alert Generation Process • Create data pipelines.

• Data gathering to upload for whole Microfinance banking industry. • Provide data driven analysis of business processes for improving the efficiency, accuracy & effectiveness of data reported. • Communicate with management & business users on matters related to Bureau Services • Provide monthly or on demand reports to management over the data reporting status , issues and its resolution. • Involved in NADRA verification process of overall Microfinance industry.