Harees Ahmed

+971-*********

PECHS Block *, Shara-e-Faisal

+92-322*******

Karachi, Pakistan

adgkpy@r.postjobfree.com

Summary

Proven enterprise consultant with 10+years of experience in developing scalable solutions in Finance, Oil/Gas and Postal Service industry, with expertise in Modern Data Warehouse and Big Data Analytics, Data Integration over cloud and on premises environment. Proficient in n-tier application architecture design, development and maintenance, capable of delivering and implementing advance technology solutions for medium and large enterprises. Excellent interpersonal skills along with effective coordination inter-team. Seeking the next big career challenge and an opportunity to apply professional expertise with keep learning attitude.

Professional Experience

Assurety Consulting – Sr. Team Lead BigData Integration / BI Analytics

May 2020 – Present

Senior Team Lead responsible for managing a medium size team of architects, data engineer and contractors. Responsible for enabling BigData Analytics solutions to modernize USPS Mails IV-MTR (Informed Visibility Mail Tracking Reporting), enterprise access management (EAMS), and customer identity and access management (CIAM) systems to enable stronger security and improve the user experience. Develop technology solutions to address key business needs including modern data warehouse (SSAS, SSIS, ADF and ADL), data pipelines, business intelligence (MSTR/PowerBI) and predictive analytics.

Chevron Corp, Kazakhstan – Sr. Technical Architect/Team Lead

(Contract via Qordata Pvt Ltd)

Feb 2018 – May 2020

I am responsible with coordinating Chevron Corp BI & Cloud Infrastructure development team, and main responsibility includes ownership of building scalable BI and DWH architecture which serve as Azure SaaS solution for multiple modules of human safety project related to Motor Vehicle Tracking system (Integration & Reporting of real-time Geospatial data) to avoid accidents and improve road conditions. Our Azure SaaS solution’s core has been built on Databricks, Event Hub, Kafka, Azure Redis, Azure Stream Analytics & Azure Data Lake. For BI reporting solution we have used Power Platform (PowerBI/PowerApps/Power Automate. Some of the reports also integrated with existing web applications via PowerBI Embedded using Rest API. For ETL Integration of heterogeneous servicing system, we used SSIS, SSAS, and Azure Data Factory.

Primatics Financial (Pvt) Ltd, Pakistan – Senior BI & ETL Analyst (PSE)

Jan 2015 – Feb 2018

Mainly responsible for leading DWH/ETL and BI team for development and analysis of Loan Accounting & Valuation for financial forecasting. Supporting complete loan portfolio accounting which include Fee Amortization under FAS 91, Real Estate Owned (REO) asset accounting. Developing analytical platform to generate future financial forecasting of the exist portfolio which will help our client to mitigate their risk and take strategic decisions. We use MSTR 9.4.1 and 10.2 for building BI solution and we have extensively used MSTR architect, Object Manager, Command Manager, Integrity Manager, Narrowcast Server, Enterprise Manager, MSTR Java SDK, Intelligent Cubes, Reports, Dynamic Dashboards, Drills/Templates, Hierarchies, Transformations, Drill Maps, Consolidation, Custom Groups etc.

As MSTR administrator I have migrated our entire BI solution MSTR 9.4.1 to 10.2, and also develop SSO with Ldap and active directory. I have also worked on MSTR web SDK tool and develop multiple APIs for auto deployment process, one of these features was allowing the Power User to create metrics through the UI. I have had experienced of Microstrategy customization by using Microstrategy Java SDK for implementing the complex business requirement, which can’t be implemented via the MSTR developer tool.

I had also responsible for building DWH/ETL solution using Informatica tool 9.5.x and 10.x tool. Apart from core development I had been actively reviewing code of my fellow team members, thereby ensuring high quality code without compromising on deadlines. I have actively and effectively coordinating with clients for supporting production issues and provides training to the existing and new features of reporting solution of Primatics Pvt Ltd.

Techlogix (Pvt) Ltd, Pakistan – Senior BI & ETL Consultant

Jan 2014 – Jan 2015

ERM (Basel-II Standardize Approach)

I was working as senior ETL consultant/architect and BI Analyst. I was mainly responsible for Formation and development of Date Warehouse architecture for Basel-ll implementation with OFSAA (AML & ERM FSDM), and also deliver end user reporting solution to meet the reporting requirement (using OBI Tool). Assists Data Warehouse team in constructing ETL solution to meet Basel-II requirements and highlight the major data discrepancies available in heterogeneous source systems.

Barwa Bank, Doha Qatar – IT Consultant/ETL Analyst (Contract)

Apr 2013 – Dec 2013

ERM Market Risk (VaR) Implementation

The project includes implementation of Basel-ll and Market Risk (Enterprise Risk Management modules) for developing an approach to identify, analyze, respond to, and monitor risks and opportunities, within the internal and external environment. It includes analysis of Bank’s source data and transforms it in a way that will helpful for management committee to identify events relevant with Bank’s potential risk and opportunities and provide extensive OFSAA (AML & ERM FSDM) regulatory reporting with OBI integration. Mainly responsible for designing ERM Data warehouse ETL and BI architecture (using ODI & OBI tool) and provide support for BI & ETL development team.

Techlogix (Pvt) Ltd, Pakistan – DWH ETL & OBI Developer

Jun 2012 – Apr 2013

FCCM (AML&KYC) Implementation

I was working as Data warehouse ETL team lead and BI Regulatory Reporting consultant, mainly responsible for analysis of Bank’s source systems and mapping required for FCCM data files for AML scenarios & KYC compliance module for risk reporting System. 7(Seven) AML scenarios had been implemented at the bank to monitor suspicious transactions. Mainly responsible to deploy “Oracle Financial Services Anti-Money Laundering (AML)” and “Oracle Financial Services Know your Customer (KYC)” to develop Financial Crime and Compliance Management (FCCM) system in Barwa Bank at Doha, Qatar.

Qatar Exchange Premium Developer

This project includes the development of Qatar Stock Exchange online solution for Qatar’s Stock Exchange (www.qe.com.qa). Core responsibility to develop the Exchange Premium System for Qatar’s Stock Exchange, Work includes development of front-end and backend layer for the subscription and payment system as required for Qatar Stock Exchange Market watch-list using TIBCO Business Work as back-end and XHTML and TIBCO Designer as front-end technology.

Professional Skills

Concepts: OOA, OOD, TDD, UML, Patterns, Networking

Software: Informatica 9.x/10.x, SSIS, ODI-11g, PowerBI, MSTR 9.x/10.4/10.9/10.11, Tableau 10.3, SSRS, Hadoop, Hive, NoSQL(mongoDB), Spark, Tibco Business Work, Weblogic, Apache, Oracle 11g, SQL-Server, MySQL, DBArtisan, Ervin Data Model.

Language: Scala, Java, Python, C++, C#, XML, SQL,PHP5, JavaScript, HTML-5, CSS-3,JQuery, Bootstrap, TypeScript, AngularJS, NodeJS, XML/XSLT/XSD, JSON, ASP.NET (MVC 3+ and Razor views).

Frameworks: Azure, AWS Redshift, J2EE, Servlets, JSP, Spring, Hibernate, JDBC, RMI, JUnit

Systems: Linux, Windows, Backtrack

Miscellaneous:

Financial Services, DWH/ETL Development, Big Data Analytics, OFSAA-FSDM (AML, KYC & ERM), OLTP/OLAP Modeling, BI Integration, Agile Scrum methodology, W3/Web2.0, OOP, RUP, SOA, Test-Driven, Data profiling and Data Cleansing, Development (TDD), UML, Use Cases, OOA, OOD, UML, Patterns, Networking.

Certifications & Awards

AZ-200 & AZ-201: Microsoft Certified Azure Data Engineer Associate

MCSA 70-778: Microsoft Certified Analyzing and Visualizing Data with Power BI

Tableau: Tableau Specialist (Desktop)

ICS: Informatica Certified (PCDI 9.x) Developer Specialist

ICS: Informatica Certified (PCDI 9.x) Administrator Specialist

MCP: Microsoft Certified Professional

MSV: Server Virtualization with Windows Server Hyper-V and System Center Specialist

MWP: HTML5 with JavaScript and CSS3 Specialist

CCNA: Cisco Certified Network Associate (Special training Session Sponsored by Cisco)

Oracle 12c Beta Certification: Oracle Database Performance and Tuning Essentials 2015

Education

National University of Science & Technology, Islamabad (www.nust.edu.pk)

Bachelor in Information Technology (CGPA: 3.7 ICT R&D Scholarship)

Contact this candidate