- Islamabad, PK
- £12 /hr
- Available now
Youth Vision (In Progress)
Developing the drug user data base software for Nepal, this maintains the “Drugs user” records. It manages registration of new drug user,more...Youth Vision (In Progress)
Developing the drug user data base software for Nepal, this maintains the “Drugs user” records. It manages registration of new drug user, searching, updating & inserting the specific user information. Maintain records of the different type of services given to them (OST, Rehabilitation, BCC, Referral, Syringe Exchange, Social, Medical, HIS, Care & Support) and record there queries too. Reporting & analysis of the data. Designing the Data base as well.
C#, SQL Server
Develop the data base software for Nai Zindagi Trust, which maintains the “Injecting Drugs user” information & related Data. The software is in working condition in four centers (Faisalabad, Sailkot, Lahore and Sargodha). Main purposes are registration of new drug user, searching, updating & inserting the specific user information. Maintain records of the different type of services given to them and record there queries too. Reporting & analysis of the data.
Handling data base & data quality and management issue as well (Profiling, cleansing, analysis, extraction etc)
ETL & BI
The data is of four provincial campuses of university, containing two types of tables i.e. Registration tables & Student tables. The tasks performed on data were; Data loading using Multi Load, Data profiling on dirty data, Answers to business questions on dirty data, Data cleansing, De-Normalization, Designing Star Schema, Data profiling on clean data, and Answering Business questions from clean data. Teradata V2R6 was used for this project.
ETL Analysis of PTCL Data BI & Duplicate Identification
.Net Framework 2.0, Visual C# 2005, MS Access, MS SQL Server
Performed ETL (Extract, Transform, Cleanse and Load) on PTCL records, cleansed data and identified duplicates using BSN (Basic Sorted Neighborhood)
• Defined business rules and coded them into scripts and queries.
• Performed ETCL and developed answering tool for BI (Business Intelligence) and visual analysis
• Created business rules and Tokenized attributes according to the business rules to create key
• Services include OLAP analysis through cube drill & roll ups etc
• Sorted data on the basis of keys to create cluster index and merged the duplicate records
• Performed house holding & individualization on sorted data
Implement Indexing Techniques & Query Builder
.Net Framework 3.0, Visual C# 2008, MS Access, MS SQL Server
Implement Indexing Techniques on PTCL Islamabad records (250000) and comparison of techniques (Bit-Map, Hash, Cluster), run different types of SQL queries on it and do different analysis on it
• Analysis of Memory usage, Time taken, Space utilization on different chunks of data
• SQL queries are Exact Match, Range type, Statical type, In type, Where Clause.
Soft Tel Answering Machine (FYP)
Net Framework 3.0, Visual C# 2005, MS SQL Server, TAPI, SAPI
It is basically a Soft Phone. It is an application that enables desktop computer to function as a telephone
Area Covered: all
Company Name: Nai Zindagi Trust
Work Experience Summary: Software Engineer Jan. 2009 _ Present
Nai Zindagi Organization (Internship Jan.-April) Islamabad
• Develop different software in C# (2005-8) and SQL(2000-5), related to on going and up coming projects at NZRS (Nai Zindagi Registration System)
• Handling and trouble shooting of Software & software related problems
• Statistical analysis and extraction of Data on different software’s (SPSS), Data Profiling
• Handling and maintaining Data quality management issues
• Testing Of software and data
• Give training & handling issues of the clients
Computer Teacher Feb. 2007 • August 2007
Roots School System Rawalpindi
• Deliver lecture to student on basic information and knowledge of computer.
• Prepared MS power point presentation on different topics and present them on weekly Basis
• Technical writing
Internee June 2005 • August 2005
Election Commission of Pakistan Islamabad
• Prepared project plans, documentation and requirement specifications of projects
• Web based vehicle Management system
• Analysis report on Mobile Service Provider in Pakistan and related GPRS Application Development.
Teacher Assistance for C/ C++ Sep 2004 • May 2005
International Islamic University Islamabad
• Deliver Lecture
• Taking and checking assignments
• Taking labs
Education Summary: MS (Computer Science) 2007 • 2009
FAST • National University of Computer & Emerging Sciences.
BS (Computer Science) 2003 • 2007
International Islamic University, Islamabad.
Soft ware Engineer