Resume

Sign in

Sql Server Management

Location:
United States
Posted:
August 27, 2012
Email:
bbjzg7@r.postjobfree.com
Contact Info:
***********@*******.***


MUHAMMAD IRFAN HALEEM

Flat# **, Block# * Railways officers colony walton road Lahore Cantt, Pakistan.

Mobile: +92 300 *** **** Email: bbjzg7@r.postjobfree.com

Objective

Providing quality solutions to complex business applications within scope, budget and tight schedules. Extensive experience in Business Intelligence, MicroStrategy, SAP Business Objects, Data warehouse design, cubes design and implementations, database design, maintenance and optimizations, programming, IT support and technical communication. Flexible as regards moving from project to project and in assimilating new technologies. Proven team leadership skills. Now looking to continue making a significant contribution within design and development on a good position.

Current Job Title

I am currently associated with Teradata Global Consultancy as a Business Intelligence Consultant and currently working on:

Enterprise Telco Reporting System using MicroStrategy, SAP Business Objects, SAP Xcelsius, SAP Crystal Reports, Teradata 13.0, SQL Server 2008 R2, SSIS, SSRS, SSAS

A huge report system for Telecom industry. Covers all kind of General and analytic report.

Enterprise Banking Reporting System using MicroStrategy, SAP Business Objects, SAP Xcelsius, Teradata 13.0, SSIS, SSRS

A huge report system for banking industry. Covers all kind of General and analytic report.

Previous Job Title

I was associated with Systems Limited Lahore as a Business Intelligence Expert & DBA and was working on:

Enterprise Data Management (EDM) using MicroStrategy, SQL Server 2008 R2, SSIS, SSRS, SSAS, Oracle 10g

Enterprise Reporting System using SAP Business Objects, SQL Server 2008 R2, SSIS, SSRS, SSAS, Oracle 10 g

Previous Job Title

I was associated with AutoSoft Dynamics (Pvt.) Ltd. Lahore as a Senior Software Engineer and currently working on:

Auto BI Reporting Portal using C#, VB.Net, SSIS, SSRS, Visual Studio 2008, SQL Server 2008, MS Visio

Management Information System using C#, VB.Net, Power Builder and SQL Server 2005 & 2008 BI (Business Intelligence) components and Databases.

Banking Solution (Core and Credit) using Power Builder and SQL Server 2005.

Fixed Assets Management System using C#, VB.Net, Power Builder and SQL Server 2008

Professional Summary

5+ Years of strong System Design, Database Design, Database Administration, Programming, support and implementation experience.

Excellent working experience in SSIS, SSRS, Advanced SQL Queries, Query Optimizations, ETL Writing and database maintenance.

Oracle Developement

Strong knowledge of SQL Server 2008, 2005, 2000, Microsoft Access Databases environment.

Excellent working experience in C#.Net, VB.Net, ADO.NET, Power Builder 10.0 & 12.0 and Sybase EAServer.

Education

Professional Qualification:

University of Punjab, Lahore Pakistan

Bachelor of Computer Science (Honors) 2003-2007

Academic Qualification:

Board of Intermediate and Secondary Education Lahore Pakistan

F.Sc. (Pre-Engineering) 2001-2002

Board of Intermediate and Secondary Education Lahore Pakistan

Metric (Science Subjects) 2000

Technical Skills

Experience with:

Databases:

Data Warehouse, Data Marts, Cubes, MDX, etc

SQL Server 2008, SQL Server 2005, SQL Server 2000

SQL Server 2005/2008 Business Intelligence (BI) components (SSIS, SSRS, SSAS), Report Builder

MS Access 2003

Development Tools:

Visual Studio 2005, Visual Studio 2008

Power Builder 10.0, 12.0

Sybase Power Designer

Analysis and Design Tool:

Rational Rose 2000, MS Project, MS Visio

Languages:

C#.Net, VB.NET, ADO.NET, ASP.NET

Power Script in Power Builder 10.0, 12.0

Windows Programming using Visual C++ 6.0

Application Server:

Sybase EAServer

Project Source Control Tool:

Microsoft Visual SourceSafe

Trainings and Courses

SAP Business Objects

Microstrategy

Power Pivot

Oracle 10g

Microsoft SharePoint Portal Server

Enterprise Data Hub

Client Server, Distributed and N-Tier Architecture

Professional Experience

Job Title: Senior Software Engineer Jul-2007 – to date

AutoSoft Dynamics (Pvt.) Ltd.

Lahore, Punjab, Pakistan.

http://www.autosoftdynamics.com

Project title: Auto BI Reporting Portal

Description: Improving organizations by providing web based enterprise level reporting that meets the business needs in better, faster and simplest way. It is also aim to provide the performance management efforts effectively across the business and process. The Auto BI Reporting Portal Project is to be designed and developed in order to provide web based enterprise level reporting. The system will provide all Financial, Core Banking, Foreign Trade, Treasury, Credit and Leasing reports throughout their life cycles through a user-friendly interface.

Auto BI Reporting Portal Project is very flexible and generic system. It also enable user to define and design a report as required and provide reports in multiple formats.

Tools and Technologies: SQL Server 2008, SSIS, SSRS, C#.Net, VB.Net, Visual Studio 2008, MS Visio

Project title: Management Information System (AutoMIS - II)

Description: AutoMIS is a Distributed Management Information System with comprehensive reporting powers. This tool is used to generate on the basis of user defined requirements, all MIS, central bank & other statutory reporting in addition to customized reports for both internal and external purposes

AutoMIS is a comprehensive reporting tool which forms the backbone for all of complementing systems reporting. The system facilitates its users with such a great degree of flexibility that they need not depend upon a development team to define individual reports, and can do this with complete ease using the 100 % parameterized customizable report setup.

Saves Time

AutoMIS saves time by automating reports for instant delivery

Reports are sent from host systems to end user in seconds

E-mail subscriber lists ensure report delivery by eliminating the potential for human error.

Saves Money

AutoMIS drastically reduces the company overall cost of reporting

Performance

Optimize processing time and provide reports in time

AutoMIS massage and process data much faster than distributed reporting engine does and remains stable over time, even as data volumes grow

Salient Features

Support both centralized and decentralized data collection

Parameter driven, user defined reporting templates

Support General Ledge and Customer base reporting at branch, region and bank level

Automatic Report Shipments to the end user, using a schedule based facility

Automatically Upload Data from Core Banking System

Menu Driven, User Friendly, Multi User Application developed in 4GL

Advanced Security Mechanism

Tools and Technologies: SSAS, SSRS, SQL Server 2005, C#.Net, VB.Net, Visual Studio 2005, MS Visio

Project title: Management Information System (AutoMIS - I)

Description: AutoMIS is a Management Information System designed for Banks and other Financial Institutions. This tool is used to generate management, central bank and other statutory reporting in addition to customized reports for both internal and external purposes.

Immediate comparisons at Branch/Head Office Levels

Incorporates consistency and standardization with internal and external reporting

Central Bank Reports

Weekly, Monthly, ABC FX

MIS Reports

MFS, Lead Schedule, Statutory A/C, Average TB

Size Wise Advances

Size Wise Deposits

Top N (by Customer/Group)

Other Reports

Exception Report, Adjustments, A/C without analysis

Analysis based reporting

Easily customizable reports for internal/external use

Automatic processing of reports

Tools and Technologies: PowerBuilder 10.0, Sybase EAServer, SQL Server 2000, MS Visio

Project title: Fixed Assets and Inventory Management System (AutoAssets)

Description: AutoAssets is a fixed assets and inventory management system designed to provide clients with a proper inventory and distribution of their assets throughout their life cycle. Salient features of the system include asset authorization procedure, asset adjustment mechanism and asset depreciation using multiple methods. Management reporting is enabled for quick and easy viewing of current asset portfolio at all stages in their lifecycle.

Incorporated Functionality Includes:

Asset acquisition and authorization

Asset maintenance

Asset adjustment and authorization

Asset depreciation

Depreciation methods

> Straight line

> Double decline

> Sum of year digits

Assets inquiry

Asset-transfer facility

Own to lease and vice versa facility

Multi-branching

Administration

Reporting

Tools and Technologies: PowerBuilder 10.0, SQL Server 2000, MS Visio

Job Title: Programmer Jul-2006 - Jul-2007

Metallical Inc.

Lahore, Punjab, Pakistan.

Project title: Human Resource Management System (HRMS)

Description: This Payroll and personnel system is developed to provide the organization with planning and efficient utilization of your human resources. Payroll, personnel, Appraisals, Power of attorney, benefits accounting and much more made this system essential tools to manage and utilize human resources efficiently.

Payroll encapsulates monthly payroll processing location wise

Personnel includes complete employee history, references and current employee salary status

Staff Career Planning using which you can plan and project your employees future

Appraisals, increments, promotions and any necessary information is maintained

Reimbursements such as medical, fuel etc., are maintained for each employee

Loans issued to employees and their proper deductions from salaries are recorded for salary processing and loan information

Benefit Funds for each employee are maintained

User defined salary types and linkage with employee entitlements

Appointed power of attorney information is entered and maintained here

All tax related statutory reporting

Tools and Technologies: C#.Net, VB.Net, ASP.Net, Visual Studio 2003, SQL Server 2000, MS Visio

Abroad Deployments

Deployed Auto BI Reporting Portal in a Investrust Bank Zambia.(Jan, 2011)

Deployed Fixed Assets Management System (AutoAssets) in a Investrust Bank Zambia. (Aug, 2010)

Deployed Management Information System (AutoMIS - II) in a Investrust Bank Zambia.

(July, 2008)

Deployed Fixed Assets and Inventory Management System (AutoAssets) in a Investrust Bank Zambia. (Dec, 2010)

Other Deployments

Deployed Auto BI Reporting Portal in Emirates Global Islamic Bank. (Dec, 2009)

Deployed Fixed Assets Management System (AutoAssets) in Emirates Global Islamic Bank. (Mar, 2009)

Deployed Management Information System (AutoMIS - II) in Emirates Global Islamic Bank. (May, 2008)

Deployed Management Information System (AutoMIS - I) in Prime Commercial Bank.

(Jan, 2007)

References

Tariq Munir Syed A. Naqvi

Temenos Consultant Sr. Software Engineer

IT-Quality Control Webroot Software Inc.

Al-Hilal Bank USA

Abu Dhabi Mobile: +1 626 *** ****

Direct: +971 2 499 4301 Email: bbjzg7@r.postjobfree.com

Mobile: +971 50 982 9257

Email: bbjzg7@r.postjobfree.com

Abraham Mwanza Farrukh Sarfraz

Sr. Finanace Officer Assistant Project Manager

Investrust Bank Plc. Autosoft Dynamics Pvt. Ltd.

Lusaka Zambia Lahore Pakistan

Mobile: +26 097 *** **** Mobile: +92 300 *** ****

Email: bbjzg7@r.postjobfree.com Email: bbjzg7@r.postjobfree.com

Umer Hussain Minhas Harry Mafuta

Managing Director Financial Controller

Kinetic IIS Investrust Bank Plc.

Lahore Pakistan Lusaka Zambia

Mobile: +92 345 *** **** Mobile: +26 097 *** ****

Email: bbjzg7@r.postjobfree.com Email: bbjzg7@r.postjobfree.com