Usman Pathan

ETL Development & Data Integration:

Integration of Bloomberg prices, FX/FWD rates, and corporate actions.

Development of data migration solutions (e.g., FIS to SIMCORP) involving historical data for transactions and holdings.

Expertise in integrating multiple data feeds, including SWIFT messages, private market data, and performance measurement feeds.

Proficient in automating workflows using SQL Server Agent Jobs and DTExec Utility.

Business Intelligence (Power BI & SSRS):

Extensive experience creating advanced Power BI reports (e.g., KPIs, tabular, matrix, and clustered charts).

Development of MENA Security Investment Dashboards and implementing RLS access controls for data security.

Skilled in data modeling, creating star schemas, and optimizing dashboards for performance.

Database Performance Optimization:

Proficient in T-SQL tuning techniques, including query optimization, index maintenance, and execution plan analysis.

Experience with tools like SQL Profiler, Extended Events, and Query Store to debug and resolve performance bottlenecks.

Project Leadership:

Successfully led large-scale projects, including Backoffice/Custody integration, front-to-back-office system integration, and warehouse migrations (e.g., Netezza to Vertica).

Collaborated with cross-functional teams, delivering tailored solutions for investment dashboards and financial reporting.

Technical Expertise:

• Databases: SQL Server (2016/12/08), MySQL, Oracle, Vertica, Netezza.

ETL/BI Tools: SSIS,Power BI.

Programming: SQL, T-SQL, MDX.

Version Control: Bitbucket, Git, Visual Studio.

Achievements:

Gold Medalist in Master of Computer Applications.

Awarded Star Performer across financial years for exceptional contributions.

Recognized as the Best Team Captain in Zonal Cricket tournaments.