hammad alam

Worked remotely for Jotana Tech as a BI developer. Developed different types of Sales, Operations, Customer Care, Marketing, CFO and HR dashboards using Power BI for Kohinoor Maple Leaf Group. The source used is a semantic layer which was developed on Oracle.

* As an ETL Developer, I’ve worked on different projects: * ETL Migration Project from T-SQL to SSIS (APNA Bank, Sindh Bank) * Name Screening Application for Anti Money Laundering AML Project (FINCA Bank, Al-Baraka Bank) * Fraud Transaction Detection System (FINCA Bank)

* Working as a database developer. I am part of a launch team which follows a Scrum Model, an * Agile Development Methodology. My major contributions are: * Upgrading the legacy system processes from T-SQL to SSIS. * Optimization of SQL objects including the usage of proper data types and coding * standards which significantly enhance the memory performance. * Attending sprint backlog meeting, sprint planning meeting, spring review meeting and * daily stand up meeting to ensure that all the client needs should be meet.

In NUST, I was the core developer for the project of Hostels Management System initiated at CEME, NUST. The most challenging part of this job was the implementation of CRUD operations in gridviews. There were different modules like role based authentication, authorization module, hostel accommodation manager, RFID card allocator, SMS generator and report generator. I also gained experience of working on Crystal Reports.

At Ibex Global (A TRG Company), I was assigned to an American client in financial industry. My responsibilities were to develop applications for agents and to develop reports. The applications were about promotional offers, the language that I used to develop these applications was VB.net. The main purpose of this application was to manage the data of each dialed call from the agent. And for that I’ve worked on SQL queries for creating different type of sale reports with the frequency of hourly, daily, weekly, bi-weekly, monthly and EOC reports. I’ve also used MicroSoft SSIS packages in BIDS (Business Intelligence Development Studio) environment for loading processes.