MUHAMMAD ABBAS
Mobile:92-3002297262 Email: mohdabbas110@yahoo.com
Objective:
To work with team spirit in an esteemed organization where my knowledge of Information Systems can be utilized in organizational and personal growth. A challenging position in the field of Information Systems that would provide an opportunity for learning and applying Software Engineering and Database Development skills based on the knowledge of current tools, trends and technologies. I am confident, self-motivated and hard working. I usually get pleased to meet new people and user groups to keep myself up to date. I am target oriented and willing to swim on horizon of Information Technology Management.
Summary:
A Senior Application Developer/Team Lead/DBA with over 5 years experience in full Life Cycle development including business analysis, architecture, design, development, deployment & Management using Microsoft technologies. Extensive experience in Design & Architecture of Data Models and Database for MS SQL Server(2000/2005). Experience in Database Mirroring, Replication, Log Shipping, Performance Tunning, Query Optimization, Back up and Restore . 3 years of experience in Business Intelligence using Pentaho, Cognos 7 and Cognos8. 3 years experience in designing and developing desktop applications on Microsoft platform using VB, VB.NET, SQL Server 2000/2005 and Crystal Reports. Have domain knowledge of various businesses like Banking, Stock Exchange, Mortgages, E-Learning and Insurance division. Developed various desktop and web enterprise applications using Cognos, VB, VB.NET, Crystal Reports, Teradata, Microsoft SQL Server and MS Access.
Technical Skills
B.I Tools: Cognos 7, Cognos 8, Pentaho Kettle, Yellowfin
Databases: Teradata, MS SQL Server 2000 & 2005 & 2008, MS Access, Oracle and DB2.
Languages: VB, VB.NET.
Development Tools: Visual Studio.NET, MS Visio, MS Project and MS Office.
Reporting Tools: Crystal Reports, JReports, Active Reports, SQL Server Reporting Services, Crystal Xcelsius
Live Cycle Tools: Adobe Live Cycle Designer 7.1 & 8.1
Version and Source Control: Visual Source Safe, SVN
Education & Credentials
SZABIST- Karachi, Pakistan
M.S in Computer Science, completed in 2006 with 3.66 CGPA.
BAHRIA UNIVERSITY- Karachi, Pakistan
B.S.E in Computer Science, completed in 2004 with 3.28 CGPA.
Adamjee Science College- Karachi, Pakistan
Intermediate – Pre Engineering , completed in 2000 with B Grade.
Al Murtaza School- Karachi, Pakistan
Matriculation - Science, completed in 1998 with A1 Grade.
Awards
Certificate of Achievement – Outstanding Performance from RBS
Exceptional Team Award from Systems Limited.(Worked as Component Lead in this project)
Outstanding Team Award from Systems Limited.(Worked as Team Lead in this project)
Certifications
Microsoft Certified Technology Specialist : SQL Server 2005
Professional Experience
From: December 2009-Till Date Data Warehouse Engineer at 360Training
Description:
Responsibilities include Designing and Development of Data warehouse and to keep intact with all of the systems running in company. Be involved in full life cycle development and implementation of enterprise data warehouse, BI reporting and analytical services.
• Designed and Developed Data Warehouse to be capable of containing all Revenue Related Data. Tools: SQL Server 2005/2008
• Developed ETL to migrate data from all the Systems that are currently being used in company which include Virtual University , Learner MS , Learner Course MS , My Classroom Management. Tools: Pentaho Kettle , SQL Server 2005/2008
• Improvement of the Database Designs and Optimization of queries that are not performing effectively. Tools: SQL Server 2005/2008
• Working with Network Operations team to resolve Performance and Other Database related issues. Helping out other teams in Query Optimization and Database Development.
• Migration of Store Front(IBM) Data to Data Warehouse . Tools: Pentaho Kettle , SQL Server 2005, DB2
• Migration of Quick books Data to Data Warehouse . Tools: Pentaho Kettle , SQL Server 2005, QODBC
From: June 2008-December 2009 Assistant Manager(BI Team Lead/DWH Admin) – BIU at RBS
Description:
Responsibilities include Managing a Data Warehouse, understanding new requirements, analyze the problems, suggest the solutions, implement the changes, develop BI analytics such as (Reports, Cubes and Dashboard), and perform the verification with associate department. Major Technologies includes Cognos 8(Report Studio , Framework Manager , Analysis Studio), Cognos 7(Powerplay Administrator , Powerplay Cube) and Teradata.
• Developed Cubes for Operations, AD&E, Liabilities and Asset Marketing by which user can perform various analytics like Cross Sell, CM Retention and Segmentation. Tools: Cognos 7, Teradata
• Designed strategic reporting for Consumer Risk Management some of which includes IS-Was analysis, Vintage Analysis, Utilization Analysis, Collection & Collection Performance Reports, and Product Caps Report. Tools: Cognos 8, Teradata
• DWH Administration Tools: Teradata
• Providing demand analytics and reports for different departments like Operations, Finance, AD&E, Business Quality, Branch Banking, Wealth Management Unit, Secured Assets and Unsecured Assets. Tools: Teradata, Excel
• Designed and Developed Reports & Dashboards for Business Heads/Branch Banking Users which include Weekly Dashboard , Monthly Dashboard , Comparison of Current Picture with SPLM , Branch Performance Report , Turnover Report, Account Deepening Report.
Tools: Teradata, Cognos 8
From: Feb 2007-May 2008 Senior Software Engineer(Cognos/SQL Server TL) at Systems Limited
Description:
Responsibilities include Managing Team, understanding new requirements, analyze the problems, making project plan, initiate development and implement the changes, updating stakeholders, taking care of each and every step from analysis till deployment.
• Worked as DBA/Team Lead for Reporting Module/Forms of Victors Application designed for Lenders First Choice (Title Insurance Application). Tools: Cognos 8.2 (BI Tool) / SQL SERVER 2005 (Back end)/Adobe Live Cycle 7.1,8.1(LiveCycle Tool)
• Worked as Team Lead for Reporting Module of Registrar/Transfer Authority system designed for Central Depository Company. Reports were designed for Corporate Actions, Administration, General, Transfer and SBP sections. Tools: JReports (Reporting Tool) / Oracle 10g (Back end).
• Developed the Reporting module of Visi Loan Review designed for Bank of America and Freddie Mac. Reports for all type of loans were developed.
Tools: Crystal Report (Reporting Tool) / SQL SERVER (Back end) / ASP.NET (Front end)
From: July 2006-Feb 2007 Software Engineer at Wavetec Pvt. Ltd.
Description:
• Developed Stock Game for Dubai Financial Market. This project is a game and all the operations and functionality are same as of Real Stock Market. SG is designed for the competition which is arranged by DFM for the students of different schools every year. Important feature of this project is that it was designed in such a way that it’s not restricted to one market and one student can play in more than one market at a time with the same portfolio affected. Tools: ASP (Front end) / SQL SERVER (Back end).
• Designed and Developed eqConfiguration System. This project is basically a configuration system for Electronic Queue Management System It was designed various clients in UAE. This project has two other parts, which are Desktop Ticket Dispensing Unit, which talk with router and get the ticket number and then print that ticket, other part was LCD TDU Screen that is a picture based screen, it also have the same functions as Desktop TDU, but from pictures. Tools: VB 6.0 (Front end) / SQL SERVER (Back end) / ROUTER (Linux Based)
• Designed and Developed Attendance Management System for HR Department. Basically this project was having two parts, one was related to Attendance itself and other was a small portion of HR, so that other salary calculation and other matter of HR could also be resolved using this system. This project also consists of some reports and other process to implement other management policy. Tools: VB.NET (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting)
From: March 2005-July 2006 Assistant MIS at Crescent Leasing Corporation Limited
Description:
• Designed and Developed Lease Management System. This project consisted module for Leasing, Depreciation, Assets and CIB. Tools: VB 6.0 (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting).
• Developed CresTreasury. This project consist modules for Treasury and Money Marketing. Tools: VB 6.0 (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting)
• Developed Attendance Management System. This project was having two parts, first the interface with the IGAURD Machine which recorded the Attendance and secondly the reports and other process to implement other management policy. Tools: VB 6.0 (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting) / IGAURD (Server)
• Designed and Developed ChequeInfo System, which main aim was to do the cheque management and other issues related to cheques. Tools: VB 6.0 (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting)
