Post Job Free

Resume

Sign in

Sql Server Software Engineer

Location:
Karachi, Sindh, Pakistan
Posted:
June 04, 2014

Contact this candidate

Resume:

Mirza Aijaz Baig

R-***, Gul Houses, Gulistan-e-Jauhar, Block-7, Karachi, Pakistan

+92-300-*******

acefcr@r.postjobfree.com

Dear Sir/Madam,

I would like to take the opportunity to introduce myself for a Software

Engineering Professional position. Please regard this letter as my formal

application. I consider that my experience and interests match with your

most of the requirements and want to apply for the same position.

I have more than 10 years experience in Microsoft Technologies. I have

proven expertise in ASP.NET, C#, VB.NET, ADO.NET (Framework 4.0, 3.5, 2.0),

SQL Server 2008/2005/2000, Crystal Reports 10, JQuery, WCF, Web Services,

LINQ, Entity Framework, Oracle Database 10g, Ajax, JavaScript, SharePoint

2010, SharePoint Designer 2010, EntitySpaces, MVC, XML, DHTML. I have the

ability to work in a fast-paced, team-oriented environment with minimal

supervision.

I have vast experience of Software Development and excellent Techno-

Functional skills, contributed in many Enterprise Applications including

GL, AP, AR, Payroll, Inventory and many others.

I am confident that my education coupled with my extensive experience can

be an asset to your organization. I have made numerous contributions to my

present & past organizations; I can work on any kind of application. You

will definitely come to know about them after reviewing my resume.

Thank you for considering me for the job and for taking time to read my

letter.

Sincerely,

Aijaz Baig

H. No. 212, Gul Mobile: +92-300-*******

Houses, E-mail : acefcr@r.postjobfree.com

Gulistan-e-Jauhar, LinkedIn :

Block-7, Karachi. http://pk.linkedin.com/in/aijaz

zbaig

Mirza Aijaz Baig

Professional Summary

Highly efficient in transforming Business Knowledge into Technical

solutions/deliverables and elaborate them to developers as well

Experience in Client-Server and Three-Tier application design and implementation

Strong interpersonal and leadership skills. Energetic, Enthusiastic, A Good team

player & A Quick learner

Database Tuning and Query Optimization (SQL Server), Strong RDBMS & Data

Warehousing concepts

MCTS - Web Development using MS .Net Framework 4.0

MCTS - SharePoint 2010 (Application Development)

Developed a DSS application as data source of a Data Warehouse

Ability to interact with client and absorb domain knowledge, good understanding

and concepts of business processes

Good R&D, Troubleshooting and Problem solving skills

Strong experience in System Analysis, Design and Development. Worked on various

business applications

Test environment - done SharePoint Development and R&D.

Knowledge of object oriented design and programming experience. Expertise in all

SDLC phases

Expertise in ASP.NET, C#, SQL 2008/2005, Entity Framework, jQeury, Crystal Report,

WCF, Web Services, XML, SharePoint 2010, VB6 (Branding, Lists, Visual WebParts,

BCS connectivity with ERP), Framework 4.0/3.5/2.0, Oracle 10g, Oracle Developer

10g

SQL Server 2000 to SQL Server 2008 successful migrations

Industries: Information Technology

Functional Business Analysis, System Analysis and Design, Interpersonal Skills,

Areas: R&D and Problem Solving Skills, Team Leadership, Team Work, Verbal

and Presentation Skills, Feasibility / Requirements Analysis,

Testing.

Methodologies Requirement Specification Document, Proposal Writing, Functional

: Specification Document, System Development Life Cycle, Software

Testing, Testing (Unit, System, UAT), Client Server Framework,

Business Process Modeling, Database Design, Infrastructure Solution

Design.

Professional Experience

(Banking Domain)

PIBAS (Pioneers International Banking Application System) Nov 2013 -

Present

Sr. Analyst Programmer

PIBAS is the pioneer banking solution provider in Pakistan, focused on developing

end-user solutions for financial institutions. The banking solutions of PIBAS

include core banking for both conventional and Islamic banking, loans and

microfinance, treasury, trade finance, leasing, reconciliation, etc.

Tools &

Technology VS 2010, jQuery, WCF, EntitySpaces, Oracle 11g, Oracle Streams,

Windows Service

Role Lead Developer

Project

Summary PIBAS Pvt. Ltd.

Real-time Database Replication Monitoring

This utility provides a user interface to reflect System

Accessibility, Database Connectivity and Tables Replication status on

a Dashboard from DR site.

A windows service is also a part of this utility which monitors the

replication status and reports via SMS and Email if founds any

problem. Replication Health Report is also a main feature of this

utility.

Assignments R&D, Development

Project Team 1

Size

Duration 1 Month

Professional Experience

(at Lakson Group of Companies)

PRINTEK Pvt. Ltd. (EXPRESS NEWS) Apr 2010 - Oct

2013

Sr. Software Engineer

Express Media Group is the second largest media group in Pakistan. It is consist

of three channels and four newspapers. It has a large number of customers and

employees. A Number of software solutions are developed to support the business,

including General Ledger, Receivables, Payables, Billing, Payroll, Sales &

Marketing, Media Management System, Advertisements Monitoring System, Market

analysis applications, Circulation, SharePoint.

Tools &

Technology SharePoint Server 2010, Windows Server 2008 R2, SQL Server 2008 R2,

Visual Studio 2010, SharePoint 2010 Designer, WCF

Role Team Lead

Project

Summary Express Media Group

SharePoint 2010 implementation

The core objective of SharePoint 2010 implementation is to provide a

collaborative environment in organization to more than 2000+

employees. Moreover, With the help of SharePoint 2010 employees will

just need to sign-in with domain account and see their Leave Balance,

Apply a leave, Check PF Balance, Apply for a loan, TA/DA submission,

Expense forms submission, Check reimbursement status.

On an average for all above activities Payroll department receives

more than 100 calls a day. SharePoint will automate these processes

as a result unnecessary workload will be reduced.

Assignments R&D, Requirement Analysis, Development

Project Team 3

Size

Duration Ongoing

PRINTEK Pvt. Ltd. (EXPRESS NEWS)

Sr. Software Engineer

Tools & ASP.NET 2.0, SSIS packages, SQL Server 2008, Visual Studio 2005, SQL

Technology Server Jobs, SQL Mail, Crystal Delivery (Pdf generator utility),

Crystal Reports 10

Role Sr. Developer cum Team Leader

Project

Summary Express Media Group

Advertisement Monitoring System (DSS)

This system is designed to monitor advertisement business on

competitor channels. Third party data is imported in the system via

SSIS package to transform the data into required form. After import

New Clients and New Programs are listed for the treatment. Duplicate

clients are marked by the user as mapped with actual one and they are

also recorded in the knowledge base.

System produces reports like Market Share, Most Aired Ads, Missing

clients on our channel, Top 10 channels by Revenue / by Airtime, Top

10 Clients, Channel positions, Program / Client wise revenue and a

variety of reports.

Approx. 55,000 ads are entered in the system, and finally moved to a

Data Warehouse for in-depth Trend Analysis based on different

dimensions and historical data. Tthis application is working with

more than 80 Million records.

Assignments Development, R&D, Performance tuning, Database Migration, Implement

change requests

Team Size 4

Duration 3 months

PRINTEK Pvt. Ltd. (EXPRESS NEWS)

Sr. Software Engineer

Tools & jQuery, ASP.NET 2.0, SQL Server 2008, Visual Studio 2005, SQL Server

Technology Jobs, SQL Mail, Crystal Delivery (Pdf generator utility), Crystal

Reports 10

Role Team Lead / Analyst Developer

Project

Summary Express Media Group

Media Management System (RO, Transmission, A/R, Billing, GL)

This application provides integration between these processes:

Commercials Release Orders (RO), Time band rates and revenue, Dropped

commercials handling, Billing for Aired Commercials, Invoice

Settlement, Adjustments, Deal based commercials, Ads Queue sheet, RO

Tracking, Capping (maximum commercials in one hour).

Assignments Development and Support, Performance tuning, Database Migration.

Team Size 4

Duration 5 months

LAKSON BUSINESS SOLUTIONS Oct-2008 To

Mar-2010

Sr. Software Engineer

Tools & C#, ASP.NET 2.0, SQL Server 2008, Visual Studio 2005, Crystal Reports

Technology 10

Role Sr. Developer

Project

Summary Pfizer Laboratories Pakistan

Material Management System (Purchase cycle of Material & Services)

Administration

Administrator, Requester, Approver

Material Issuance Request

Request from an Individual to Dept. / Main Store

Request from Dept. store to Main Store

Store

Store Categories (Main stores, Department stores)

Material transfer among stores

Material Return

Item Batch Numbers with expiry details

Purchase Request

Individual to Purchase Department

Department Store to Purchase Department

Main Store to Purchase Department

Budget allocation

Purchase Request Limits for Requester:

Number of Requests per Month

Number of Items per request

Amount per Request

Monthly Request Amount limit

Approval Process

Approval Limits for Approver:

Number of Request Approval per month

Amount per Purchase Request

Monthly Request Amount limit

Approver can approve Request or Forward to superior authority or any

other Approver for approval

Approver's remarks are preserved and not editable)

Purchase

Material type (Local, Imported)

Purchase Request Consolidation

Tender

RFQ (Request for Quotation)

Comparative Statement (QCF)

Final Purchase Requisition (vendor specific)

Purchase Order

Receiving

Receiving of material from vendor can be done at different locations.

A Purchase Order can have only one receiving location.

Receiving officer will receive items and verify the Items with

Purchase Order.

Receiving Receipt will be generated by the Receipt Officer to deliver

Material to the requester.

Requester will verify the materials on Receiving Receipt.

Requester can accept all or partial items on Receiving Receipt.

Requester can reject all or partial items on Receiving Receipt.

If Items rejected Receiving Officer will return Rejected Item to

Supplier with Gate Pass

Assignments Design, Development, Issue fixing, UAT, Change request

Team Size 5

Duration 8 months

LAKSON BUSINESS SOLUTIONS

Sr. Software Engineer

Tools & C#, ASP.NET 2.0, SQL Server 2000, Visual Studio 2005, Crystal Reports

Technology 9

Role Analyst, Developer

Project

Summary Engro Vopak

Preventive Maintenance Management System

This application was designed to ensure the preventive maintenance of

the equipments in the chemical terminal. There are three types of

equipments:

Electrical

Mechanical

Electronics

There are a number of maintenance frequencies i.e. Weekly, Bi-weekly,

Monthly, 2 Months, 3 Months, 6 Months, Yearly.

The system records maintenance plan and alters the relevant

departments as per the schedule. After the activity plan is updated

and moved to the next date.

Different reports of delayed/unattended/attended plans.

Assignments Analysis, Development, UAT, Go Live, Change request.

Team Size 2

Duration 3 months

LAKSON BUSINESS SOLUTIONS Jul-2006 To

Sep-2008

Software Engineer

Tools & Oracle database 10g, Forms 10g, Reports 10g, Oracle Application

Technology Server

Role Analyst Developer

Project

Summary Fixed Asset Management System

The organization was in need of a system which can has Fixed Asset's

up to date status regarding their Current Location, Depreciation

details, Current Book Value etc. There are two types of assets:

Autonomous assets (AC/Electrical Instruments/Server Machines/Racks)

Component assets (Detachable parts, Motherboard, RAM, HDD,

Electronics component, Valuable accessories)

The system is designed to avoid extra ordinary manual work in

managing assets and have a track record of asset's movement

throughout its lifecycle, also avoid manual accounting of assets in

terms of their book value after depreciation.

This software is specially designed for Fixed Assets Management only.

Oracle technology is used throughout because the organization already

has oracle based infrastructure and this application would be

integrated with already running ERP solution in future.

Without such system it was very difficult to have a track record of

assets which are moving throughout the organization frequently. For

example, computer components which are located on different locations

with different assets in different time periods.

This system provides the solution to this problem. It has the

flexibility to move components assets and trace them very easily

where they are currently located.

Assignments R&D (Data transformation, Mail generation), Analysis, Development,

Deployment and Testing.

Team Size 3

Duration 5 months

LAKSON BUSINESS SOLUTIONS

Software Engineer

Tools & ASP.NET, C#, SQL Server 2000, JavaScript.

Technology

Role Developer

Project

Summary Civil Aviation Authority Pakistan

CMS-based website

Flight Schedule, Publication of Tenders / Notices /Aviation policies

/ Licensing policies, Airports Information.

Assignments

Analysis, Development, Deployment and Testing.

Team Size 3

Project 3 months

Duration

Duration 4 months

NISAR TEXTILE CORPORATION Sep-2002 To

May-2004

Tools & Vb6, ASP 3.0, SQL Server 2000

Technologies

Role Developer

Project

Summary Enterprise Applications Development

Development of business application GL / HR / Payroll / Sales /

Inventory.

Assignments Development, Deployments and Training

Team Size 3

Project 1 Year

Duration

Academic Qualifications

Degree Discipline University City/Country Year

Professional Certifications / Licenses

Certificate / Course Month Year

Microsoft SharePoint 2010, Application Development Feb 2011

Web Development using MS .Net Framework 4.0 Mar 2011

Technical Skills

Operating Windows Server 2008 R2, Windows 7, Windows Server 2003, Windows

Systems: Vista, Windows XP, Windows Server 2000, Red hat Linux 9.0

Databases / DB SQL Server 2008 R2, SQL Server 2005, SQL Server 2000, Oracle 10g

Tools: (SQL, PL SQL, TOAD)

Application Visual Studio 2010, 2008, 2005, 2003, MVC 4.0, Crystal Reports,

Development SSIS, SSRS, SharePoint 2010

Tools:

Infrastructure C#.Net 4.0, 3.5, 2.0 & 1.1

Solutions/Techno VB.Net

logies SharePoint Server 2010

ASP.NET

ADO.NET/LINQ/Entity Framework

MVC 4

AJAX

XML

JQuery

Windows Communication Foundation (WCF)

SharePoint 2010

Windows Forms

SQL, T-SQL, PL/SQL

Stored Procedures, Triggers, SQL Server Jobs

Web Services

DHTML & JavaScript

Languages; C# / VB.NET 4.0,3.5, 2.0, MVC, Ajax, XML, LINQ, JavaScript, HTML,

Scripting/Markup CSS, SQL, JQuery

:

Network / Server Active Directory knowledge, AD accounts handling

Technologies:

Frameworks / Visio 2010

Object Models:

Case Tools: MS Project 2007/2003, Visio 2007/2010

PERSONAL INFO

Father's Name: Mirza Hameed Baig (Late)

Marital Status: Married

DOB: Mar-79

Nationality: Pakistani

Religion: Islam

Reference (s)

Name Organization Contact Number(s) Relationship

References will be furnished upon request.

[pic]



Contact this candidate