Software Engineer Project

Muhammad Usman Farooqi

[pic] Address [pic] Mailing [pic] Contact #

Address

H#229, Block C1,

Nespak Colony, *********@*******.*** 0092-345-***-****

College Road

Township Lahore,

Pakistan

PROFILE Lead Data Warehouse Design Architecture and Business

Intelligence implementation for multiple dektop / web

based BI Platform Projects.

Developed Business Process Management Solutions for

multiple Fortune 500 companies.

Good analytical & design skills, focused approach,

process oriented, hardworking and professional attitude

towards work.

A team player who has the ability to work

independently, lead others, and also to perform well in

the team

Involved in all phases of the software life-cycle,

including requirements definition, design, validation

for testing, implementation and support

Have good communication and interpersonal skills

PROFESSIONAL TRG Tech (August 2010 - Present)

EXPERIENCE ( www.trgworld.com )

Software Engineer

Software Engineer: Data Warehousing and Business

Intelligence Development

August 2010 - Present

Responsibilities:

Currently working as Data warehousing / Business

Intelligence Developer at TRG Tech. My responsibilities

here includes writing SSIS packages for ETL, Designing

and development of SSAS Cubes and making various

reports using SSRS/Report Builder

Tools and Technologies:

SSIS 2008, SSAS 2008, SSRS 2008, Report Builder, MDX

Studio

Books Consulted:

Microsoft Data Warehouse Toolkit By Ralph Kimball

Microsoft SQL Server 2008 MDX (Step by Step)

Techlogix Pvt. Ltd. (Dec 2008 - July 2010)

( www.techlogix.com )

Software Engineer

Software Engineer: BI Platform Development (IHI Portal)

December 2008- July 2010

IHI Portal is web based portal. It was initially built

using "Ruby On Rails", and later was shifted to

"Microstrategy". It includes more than 50 different

types of reports. Some of these reports consist of

"User Engagement Report", "Products Stats Report",

"Content By Time Report" and "Content By Website

Report".

These reports reflect the analytics of end application

users with different perspectives. Filtering, refining,

export to pdf/excel or email, drill down and roll up in

time and geographical location dimension are some major

features present in these reports.

Responsibilities:

As a BI Developer, I define and create facts, metrics,

attributes, hierarchies, filters, prompts,

consolidations, custom groups and drill maps. Define

and create complex reports and various dashboards.

Tools & Technologies:

Microstrategy, Ruby on Rails, HTML, CSS, JavaScript,

AJAX, MySQL, Erwin

Books Consulted:

"Business Intelligence for Enterprise" By Mike Biere

"Business Intelligence Roadmap" By Larissa T. Moss &

Shaku Atre

"Web Analytics, An hour a day" By Avinash Kaushik

Software Engineer: Data Warehouse and ETL Development

December 2008- July 2010

Data Warehouse and ETL framework was developed for web

analytics of Buying Guides and Show Case Applications.

ETL framework was developed and enhanced in C# for

version 1.0 and 2.0 of the applications. Later on new

ETLs were developed using Pentaho Data Integration

tool.

Responsibilities:

Being an ETL developer and owner of this application, I

design the whole dimensional model using star schema,

hence defining fact and dimension tables from user

requirements. Then write the code for transformation

from transactional databases to the warehouse database.

The ETL process was incremental and easily

configurable.

Tools & Technologies:

C# 2008, Pentaho Data Integration, MySQL, Erwin

Books Consulted:

"The Data warehouse ETL Toolkit" By Ralph Kimball

"Building the data warehouse" By William Inmon

Powersoft19 Pvt. Ltd(June 2008-Nov 2008)

( www.powersoft19.com )

Software Engineer

Software Engineer/Research Assisstant: Train Control

System (Absco)

June 2008 - November 2008

This is a massive project for Leading Locomotive

Automation Company in USA while in Powersoft19. This

Project features complete autonomous guided system

(auto pilot) for remotely controlled Locomotives. With

this system the train will be input all the grade and

curvature of the railway track ahead, along with the

maximum and minimum speed limits. By strictly following

the driving rules and best fuel consumption and best

speed plan, this system provides with the driving

controls in advance. Then on the run time this system

changes the driving controls by taking actual inputs

from the train, until the train reaches its

destination.

Responsibilities:

I had the task to assist two Researchers at

Powersoft19. We analyzed different control system

implemented in the field already, got patents about

train control system. Then made comparison of them all

which outputs in the form of comparison matrix of all

research papers. Then on the basis of our requirements

and discussion with our on shore research team, we

agreed on new features which will be incorporated in

our train control system.

Tools & Technologies:

Matlab 7

Owner: Rail Simulator

June-2008- September 2008

This was an implementation for the research project

"TRAIN CONTROL SYSTEM (ABSCO)". While in Powersoft19.

The purpose of this simulator was

Apply the whole dynamics of the Train

Using the dynamics, implement and compare result for

different control system techniques

Display simulation run to the user

Responsibilities:

I worked on it from scratch. I had the task to

implement the whole dynamics of the train along with

the HCI (Human Computer Interaction)

Tools & Technologies:

C#.Net 2008

SKILL SET Languages:

C#

Ruby on Rails

Action Script 3.0

SQL

C++

C

MDX

Development Tools:

MicroStrategy(9.0 & 9.0.1) Web, Desktop, Architect,

Intelligent Server, Intelligent Cubes, Object Manager,

Integrity Manager, Enterprise Manager

SQL Server Integration Services (SSIS) 2008

SQL Server Analysis Services (SSAS) 2008

SQL Reporting Services (SSRS) 2008

SSRS Report Builder

Pentaho (ETL Tool)

Erwin

Powershell

Visual Studio 2005/Visual studio 2008

Visual Studio 6.0

Aptana

Net Beans

Eclipse

Flex Builder

Matlab

Tools, I am Familiar With:

Oracle Business Intelligence (OBIEE)

Informatica (ETL Tool)

MDX Studio

Microstrategy SDK

OS Exposure:

Windows

Ubunto

Linux(Red Hat)

Scripting/Markup Languages:

JavaScript

HTML / CSS

XML / XSD

Databases:

Oracle 10 g

SQL Server 2005 / 2008

MySql

MS Access

EDUCATION University Of Engineering And Technology,

Lahore. www.uet.edu.pk

BS(Honors), Major in Computer Science and engineering,

June 2008

Percentage: 74%

AWARDS/PUBLICATION 2 years part time (6 hours a day) job experience as

S junior software engineer during studies at powersoft19

(www.powersoft19.com), from June 2006 to June 2008.

Certified Ethical Hacker (CEH) ver. 6.0 by EC Council

in June 2009.

Got 2nd position in IEEE Speed Programming Competition

held at FAST-NU, October, 2007.

Got 1st Position in All Pakistan Software Competition

Organized by TECH-ELITE, NED University Karachi on 3rd

May 2008, with the Project Title VEELOX.

Got 1st Position in All Pakistan Software Competition

Organized by VISIO SPARK, Comsats Wah Cant on 7th April

2008, with the Project Title VEELOX.

Got 1st Position in PINAKALL All Pakistan Business Idea

Competition Organized by Kalsoft, Karachi in August

2008, with the Project Title VEELOX.

Got 3rd Position in International Software Competition

Organized by SOFTEC, FAST Lahore on 30th 31st August

2008, with the Project Title VEELOX.

Got 3rd Position in All Asia Software Competition

Organized by NASCON, FAST Islamabad on 5th 6th April

2008, with the Project Title VEELOX.

Got 3rd Position in All Pakistan Software Competition

Organized by COMPEC, EME (NUST) Rawalpindi on 25th 26th

April 2008, with the Project Title VEELOX.

Represented the Computer Department and got 2nd

position in ALL Pakistan Electronics & Software

Competition organized by Electronics Club (UET, Lahore)

in December 2005. Project Title "Voice Controlled Comp

Car with Geographical Direction Indication".

Got 2nd position in Intra UET Robot Competition held in

September, 2007, with "FLAMINGO (The Fire Fighting

Robot)".

CO-CURRICULAR Got second position in debating competition in the

ACTIVITIES: school era.

Two Times winner of Bait Bazi Competition at school

level in all Punjab Bait Bazi Competition.

Quaid-e-Azam Scout

Red Crescent Certified.

Head of House in School through 9th and 10th.

Represented my school once in inter school Calligraphy

competition organized by "Punjab Text Book Board"

REFERENCE References can be provided on request.

Contact this candidate