AHMER HASAN

• Managed Multiple large scale Data Integration and Reporting implementations for Banking and Financial Data Warehouses & Data Lakes.
• Followed Agile Methodology to achieve successful completion of project developments.
• Lead multiple Developments of Data Warehouse Systems and contributing in complex Developments.
• Successfully managed ETL Development and Design using SSIS which includes Master Package execution, Logging, Record Count Reconciliation, parametrization, variables, Data Work Flow Exceptions, etc.
• Development in SQL scripting ( Stored Procedures, T-SQL, Dynamic Queries/Pivots, Views, Ranking, Functions, Loops, etc.
• Successfully Optimized Database Tables ( Column Store Index , Global and Partitioned Indexes , Partitioning , Data Compression ) and Queries ( Analysis of Execution plans and query optimization accordingly ).
• Successfully Developed and Managed teams for Banking ad-hoc, standardized and Regulatory Reports using SSRS.
• Mentoring juniors, helping them enhance their skills and contribute more effectively to projects.
• Prioritized projects and project tasks depending upon key milestones and deadline dates.
• Resolved complex technical issues, restoring system functionality and minimizing downtime.
• Built strong relationships with clients through consistent communication and proactive problem-solving efforts.
• Increased client satisfaction by providing tailored consulting services and effective problem-solving strategies.
• Developed innovative strategies to address complex business challenges, resulting in increased profitability for clients.
• Identified key areas in need of improvement and implemented plans to rectify issues.
• Managed multiple projects simultaneously while prioritizing deadlines effectively under pressure through meticulous organization skills and time management.
• Managed cross-functional teams to ensure project deliverables were met on time, within budget, and to client's satisfaction.
• Multiple Technical trainings to relevant departments of multiple Clients.
• Multiple on-site and off-site projects delivered.

• Successful Implementations of Business Intelligence / Data Lake product (World's Best Core Banking Systems).
• Managed multiple projects simultaneously while prioritizing deadlines effectively under pressure through meticulous organization skills and time management.
• Successfully delivered technical Demos to new Clients.
• Major Participation in Business Requirement sessions with Clients.
• Interaction with different business stream owners to Understand and Build Mappings for different Reports.
• Managed Development of Banking ad-hoc, standardized and Regulatory
  Reports using SSRS and SSDT.
• SQL Development using Stored Procedures, T-SQL, views and Tables.
• Implemented Distributed Query Development and performance optimization for
  handling large volumes of data.
• Successful Reconciliation of Data with Client and Internal Business Teams.
• Managed Debugging and Code Fixtures of SQL scripts.
• Successful Analyzation and Optimization of Temenos ETL.
• Managing ad-hoc activities like Production fixtures or ETL failures on
  production.
• Persuaded Clients to achieve win-win situations for most use-cases.
• Achieving successful sign-offs from Clients.
• Provided post-live support and multiple trainings.
• Ensuring timely and quality delivery.

• Implemented Machine Learning Algorithms (Logistic Regression, K-Means by Elbow Method, Decision Tree), data analytics and data visualizations using Python Programming for AML Division, Global Compliance.
• Successful Alert Generation Threshold Optimization Exercises for International locations(HBL-UAE) which includes

Automated Statistical Analysis Process of selecting eligible values for each Alert generation scenario’s parameters.

Development of SQL scripts for data extraction and processing.

• Analysis on UAT batches outcome.
• Process Automations : Currency Transaction Report and Money Service Business.

• Developed Desktop Applications by using different data structures in Python Programming Language.
• Managed Web Scrapping in Python.
• Resolved bugs and errors in SQL scripts.
• Implemented best practices in code quality and ensuring maintainability.