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