Usman Pathan

Usman Patan Usman Khan Patan Jazea Appartements Lbn Hibathullah, 2948 Prince Sultan Bin Salman Bin Abdulaziz Street, Riyad-, Saudi Arabia Email:-Mobile: - Professional Summary ● Having 11 years of experience in SQL Server & ETL(SSIS) Programming Development & maintenance of Power BI application on SQL Server 2016/12/08 . ● Experience in Data Engineering of Capital Market asset classes such as Equity, Bonds(Fixed Income) and Cash Equivalents and Money markets. ● Experience in Integrating Bloomberg Prices, FX/FWD rates and Corporate actions Using SSIS and SQLserver ● Experience in PBOR BNY Eagle Datamanagement and PMA feed integration from Backoffice and Bloomberg for performance reporting using SSIS and SQLserver ● Experience in creating the ODS for Back office application (FIS Invest one)for BI and data reporting using SSIS and SQLserver ● Experience in Integrating Swift MT 940 messages to our front office and also for reconciliation between our ABOR GL using SSIS and SQLserver ● Experience in Integrating Private Market data feed from vendors like Hamilton Lane and Burgiss for International market that contains valuations and Cash flows for TWR and IRR caliculations using SSIS and SQLserver ● Experience in creating Performance measurement and Attribution(PMA) Dashboard using BI and SSIS and SQLserver ● Experience in various data feed conversions for Front office (CRD) ,Back office (FIS investone), BNY (Eagle) ,GL and SIMCORP applications using SSIS and SQLserver ● Experience in data Migration from FIS to SIMCORP that contains the full history of transactions and holdings, Prices and FX rates using SSIS and SQLserver and Oracle ● Experience in Integrating FIS investone GL entries into ERP GL entries for Treasury Instruments like Time Deposites , Bonds and Money Markets and Loans Using SSIS ,SQLserver and Oracle ● Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities. ● Having Experience in executing XP_CMDSHELL and DTExec command Utility to execute SSIS Packages. ● Exceptional Knowledge of Configuring and Monitoring the SQL server agent jobs ● Experience in Connecting to Multiple sources like Share point List, Share point Excel and CSV, Excel, SQL server,MySQL,FISspectra,HTTP web and Bloomberg tool and OracleERP Using SSIS & Power BI ● Experience in using the T-SQL Performance Tuning Techniques Such as Extended Events, Query Store, DMV’s and System Stored procedures to debug the SQL Issues. ● Experience in Creating SQL Maintenance Plans for Index Rebuild and index reorganize based on the Fragmentation ratio to avoid the T-SQL performance issues. ● Experience in creating the Traces and analyzing the execution process using SQL profiler. ● Experience in implementing business logic using DDL, DML, Views, and Functions, Stored procedures, CTE’s, Cursors and Sub queries. ● Experience in creating the Power BI reports like Tabular, Matrix, Drill Through and Pie chart and Donut and Clustered Column bar Reports using Power BI and SSRS ● Strong Experience in creating Power BI KPI reports using Gauge, Data bar KPI , Techo Meter and Dial Gauge Charts by Using the KPI formula’s ● Experience in deploying the Power BI reports on Premises Report Server ● Experience in applying the RLS access to the Power bi users on report server ● Involved in Netezza to Vertica database Warehouse Migration. ● Experience in creating Cubes and Measures Using MDX in SSAS from the data ware house ● Good understanding of Dimensions and Facts to create a Data ware house ● Strong Experience in creating the Bookmarks and Slicers and enabling the Visual level and Page level filters in Power BI. ● Experience in deploying the Power BI reports on Premises Report Server Professional Experience ● Worked as a Senior Member Technical at Broad ridge Financial Solutions, Hyderabad (India) from November 2013 Nov to 2017 Jan ● Worked as a SQL Database Developer at ZETA Global (ZETA Interactive), Hyderabad (India) from 2017 Feb to 2018 Sept. ● Worked as a Senior SQL Server Developer at ELM information security, Riyadh (Saudi Arabia) from 2018 Sept to 2020 Mar ● Working as Assistant Vice President at Public investment Fund , Riyadh (Saudi Arabia) as a FTE From 2020 April to Till Now Technical Profile ● Programming Languages : SQL, T-SQL ● Data bases : SQLServer 2016/12, MySQL and Oracle ● Data ware house : Netezza and Vertica ● MSBI Tools : SSIS , SSRS & SSAS ● Business Intelligence Tool : Power BI ● Version Control Tool : Bit bucket and Git -Visual studio ● Data base Tools : IBM Aginity workbench & DB visualizer ● Oracle database tools : SQL developer ● Performance Monitoring Tools : Query Store ,Extended Events and Profiler Academic Profile ● Completed Masters of Computer Applications(MCA) from Muffakham Jah College of Engineering & Technology (Hyderabad) in 2013 Experience Summary Organization – Public Investment Fund (Riyadh, KSA) Team : Shared Services Division Database : SQLServer2016 ETL Tools : SSIS Business Intelligence tool : Power BI Roles : Lead Consultant Duration : - to Till now Project 1: MENA Security Investment Dashboard Project Description: Designed the MENA dashboard that contains the PMA feed from our front office exports and backoffice details that shows the Trading analytics,Holding summary ,Performance reports And Contribution and Attribution reports across multiple levels(Manager,Group,Region ,Sector level) . RLS has been applied to restrict specific users to access specific portfolios and visuals , so that data is not being exposed to unauthorised users. A star schema has been designed that contains Dim and Fact tables in a Database using SSIS which integrate multiple sources (front office ,Back office and Bloomberg) that runs on daily basis to populate the database and Dashboard that is accessing by Division heads, COO and CFO and Governor Project 2: Bloomberg to Backoffice Integration Project Description: Integrating Security details , Prices, FX Rates, FWD FX rates and Corporate actions from Bloomberg to Backoffice on daily basis using SSIS along with email notifications Project 3: ( Backoffice/Custody Integration Platform) Project Description: Integrating the Trade information from Local / External and JPM International Fundmanagers data through SFTP and load into our Back office on daily basis and also enable the feed from custody holdings to recon between custody and our back office application Fund Managers : SNB, Blackrock, SSGA and Inhouse Managers Project 4: ( Front Office and Backoffice Integration) Project Description: Integrating the Datafeed from Backoffice that contains the BOD Positions, Cashforecast and Security and Fund details to our front office trading system and Enabling the Front office intra day trades and any new securities back to our backoffice applications and also enable the Performance PMA feed from backoffice to front office for PMA(Performance Management and Attribution) that contains the PMA positions and PMA transactions and also Integrating S&P benchmark feed into front office for PMA. Role and Responsibilities: ● Creating the SSIS packages using Visual studio for development, Testing, UAT and Production ● Creating the Data model for each entity that is being used in SQLserverp ● Deploying the ETL SSIS packages using Integration service catalog ● writing Dynamic SQL queries in stored procedures ● using T-SQL queries that includes Joins, Sub Queries, Derived Tables, Functions & CTE ● Configuring and scheduling the SQLserver agent jobs for automation ● Creating Dimensions and Facts that is being used in Power bi Dashboards. ● Creating Power BI visuals like Drill through , Donut , Bar and Pie and Clustered and waterfall models Organization – ELM information security (Riyadh, KSA) Project Team : Royal Court Data Integration Platform : Social Security Program Database : SQLServer2016 MSBI Tools : SSIS & SSRS Business Intelligence tool : Power BI Roles : Senior SQLserver developer Duration : 2018 September to 2020 June Project: Social Security Government Program Project Description: Royal Court Data Integration Platform is the project that integrate the data between Multiple Ministry’s data agencies and NIC to support the data needs of Royal court NLO. This platform act as data interface agreement for the reference of all stockholders including and attributes which is mandatory information for implementing the integration interface. The Integration Platform loads the entire ministry's data (Full and Incremental) to NIC based on the synch frequency defined by the Ministry. Project Clients: National Information Centre(NIC), Ministry of Education, Ministry of Commerce and Investment, Ministry of Civil Services , Ministry of Interior. Role and Responsibilities: ● ● Involved in the requirement data gathering of the Agency data set’s and data sources Involved in designing and development of Objects such as Tables, Views, Stored procedures & functions. Involved in preparing the Client source schema set up for Multiple agencies for testing Created Composite Primary Keys on Tables for data integrity ● Involved in preparing the Dynamic SQL queries in stored procedures ● Involved in SQLServer XML query operations ● Created the maintenance plan for T-SQL Index fragmentation issues. ● Involved in tuning the T-SQL queries based on the Execution plans. ● Involved in debugging and Analyzing the process using SQL profiler. ● Involved in SSIS package support operations and Running SQLServer agent jobs ● Involved in SSIS data flows that connect to Oracle OLE DB sources. ● Created the reports like Table, Matrix, Drill Down and Pie chart and Stacked and Clustered Column bar Reports using Power BI Prepared documentation for end user training. ● ● ● Organization - Zeta Global (Zeta Interactive) (Hyderabad, India) Project Team : Cross Channel Digital Marketing : Data and Analytics Database : SQLServer2008R2, Netezza & Vertica MSBI Tools : SSIS, SSRS & SSAS Roles : Database developer and Analyst Duration : 2017 Feb to 2018 Sept Project: Digital Marketing Project Description: Zeta Hub is a cross platform tool, which used to send the campaigns to customers. There different of rule sets to categorize the audience. Client place the files in the ftp, we process the files send the files with customized data to hub. There are many businesses rules include email, address standardization, and apply scrubbing rules to maintain the consistency data. Clients: Ikea, LHW, RSH, Regis, C2C, Petco, FirstGroup and OOR Role and Responsibilities: ● Involved in designing and development of Objects such as Tables, Views, Stored procedures & functions. Developed Stored Procedures, Views for performing automation tasks ● Created Indexes like Clustered / Non- clustered Indexes to speed up the data ● retrieval. ● Created packages in SSIS Designer using Control Flow, Data Flow Transformations to implement Business Rules. ● Using Control Flow elements for each Loop and Sequence Container, Execute SQL Task, File System Task. ● Creating, Scheduling and Monitoring the SSIS packages for Daily load in SQL Server Job Agent. ● ● ● Create objects in Netezza and view and transforms. Create file definitions and Transforms to load the data from ETL to Netezza. Experience in working on various warehouse databases like Netezza and Vertica. ● Writing Dynamic Stored Procedures for Monthly reports generation Organization – Broad ridge Financial India Pvt Ltd. (Hyderabad, India) Project Team : MC Order Management System Technology : MS SQLServer2008R2 Third Party tools : Edge and Post Edge Archival system Duration : 2013 Nov to 2017 Jan : Marketing Communications Project: Marcom Project Description: Broad Ridge Marcom pre-sale is an investor communication service for mutual fund and retirement services. Our project aims at providing all the required pre- sale information to the investors about a fund before invests in it. We have portals designed for every client where Client can upload the information of mutual fund plan and we generate a dynamic PDF to that plan. Now clients can place orders to those mutual fund plans and Marcom System generates the participant order PDF's and deliver the hardcopy/softcopy of the PDF to the investor directly. Clients: Wells Fargo, JPMorgan, Bank of America & Goldman Sach’s Role and Responsibilities: ● ● Involved in development of SQL Scripts, Views, Stored Procedures and functions Trouble shoot queries using Joins, Sub Queries, Derived Tables, Functions and CTE. ● Debugging Stored Procedures, Views and Functions for Production issues ● Created Composite Primary Keys on Tables for data integrity ● Monitored daily Processes for different Data Loads and resolved Issues. ● ● ● ● Writing Stored Procedures for Monthly report generation. Monitoring the SQL Server agent Job’s on daily basis. Having ability to find RCA & fix Defects Enhancements and fixes. Achievements Profile: ● Gold Medalist at Master of Computer Application ● Won Star Performer awards on different financial year ● Awarded the title of “Best Team Captain” in Zonal Cricket Team Declaration: The above-submitted information is true and accurate to the best of my knowledge. Place: Riyadh (KSA) Date: (P. Usman Khan)