Data Quality Assurance

Hassan Zaman

**** ******* **, *********, ** *****, 214-***-****

**********@*****.***

PROFESSIONAL SUMMARY

. 3+ years experience in the field of Information Technology, with

extensive experience in analysis, design, development, Production

Support, data conversion, Data Warehouse/Data Mart design, testing and

documentation.

. Free hands in writing and debugging PL/SQL packages, stored procedures,

functions and database triggers using dynamic SQL and PL/SQL for Oracle

9i/10g.

. Worked on setting the SQL Isolation level for the database to maintain

the data consistency.

. Worked with Oracle Stored Procedures, Table Partitions and experienced in

loading data into Data Warehouse/Data Marts using PL/SQL Developer Tool,

Export/Import utilities.

. Very good experience to write complex SQL queries

. Extensive experience to write PL/SQL Procedures, Functions, Packages and

Triggers

. Highly experienced in converting data from legacy systems and data

warehouse environments to Oracle Database using SQL, PL/SQL, sql*loader

and Unix Scripts.

. Received the data files from third party vendors(USPS) to validate the

customer addresses using SSH

. Experience in design and development of custom reports and backend

development.

. Proficient in creating SQL*Loader scripts to load data from legacy

systems into temporary staging tables and Oracle Interface Tables (OIT).

. Good understanding of the Oracle database, related utilities and tools.

. Excellent analytical and problem solving skills to handle time-sensitive

assignments.

. Ability to work through complex business environment, understand and

interpret data in a manner that business units and customers are able to

understand and use.

. Highly motivated, Enthusiastic Team Player and self learner with ability

to develop proficiency and adapt to new technologies and methods in a

short period of time.

EDUCATION

Bachelor of Science in Electrical Engineering, West Virginia University -

December 1999

PROFESSIONAL EXPERIENCE

National Data Services Inc, Dallas, Texas

May'10 to Aug'10

Data Specialist

. Created data-base files by using different format of data from clients in

Visual FoxPro environment.

. Used Mail Manager 2010 to create customers monthly statements for

different clients and their direct mail campaign

Brierley & Partners, Dallas, Texas

Jul'07 to De'09

Data Analyst

. Wrote enhanced database interfaces using PL/SQL Procedures, Functions and

Packages

. Loaded data into multiple tables and generate SQL scripts to install,

create and drop database objects including tables, views, primary keys,

indexes, constraints, packages, sequences, grants and synonyms

. Wrote Developed UNIX shell scripts for automated data loading using the

controls file with SQL Loader.

. e Database triggers to maintain the audit columns in the table

. Created and used Materialized views for summary data analysis and other

user Reports

. Query performance monitoring, tuning and training. Structures and

delivers data in a usable format for end-user query tools.

. Troubleshoot issues, including creation/follow-up of Oracle service

requests (SRS).

. Conducted quality reviews of code developed by other development staff.

. Designed, developed and maintained staging areas from source systems.

. Provided detailed data analysis of source data and development of the

dimensional data model

. Translated data models into physical table structures. Defined,

implemented and administered aggregation, partitioning, and indexing

strategies. Responsibled for the end-to-end design of the production

process to extract, transform and load the data in preparation for the

data warehouse.

. Designed, developed and administered data and summary table refresh

strategies. Developed and administered recurring outbound data feeds

(delimited data types).

. Wrote extract process for the day to day user transactions

. Wrote Unix Shell Scripts and Scheduled jobs to Automate the process

. Used VI Editor to edit and created new programs

. Involved in different testing phases of the application

Environment: Oracle 10g, PL/SQL, SQL, PL/SQL Developer, Unix Shell, Oracle

Reports10g,

MS-Access, MS-Excel, Windows XP

Gamestop, Grapevine, TX

Apr'05 to Jun'07

Hardware Technologist

. Responsible for planning, developing, implementing all the test

procedures to refurb gaming-hardware units for the technician.

. Responsible for maintaining production and accuracy standards of pre-set

hardware refurbishing goal by completing diagnostic processes.

. Ensure that all resale hardware units are completely refurbished and

sufficiently ready for resale by following all quality assurance

standards and guidelines.

. Responsible for counting and recording relevant information related to

hardware refurbishing per pre-established guidelines.

MCI Worldcom, West Orange, New Jersey

Feb'00 to Apr'04

Field Engineer (Light Wave Test)

Tested, configured, and maintained SONET Optical carriers includes

. Nortel OC-192, OC-48, OC-12, Optera LH, Optera DX, and Optera Metro

. Ciena CoreStream DWDM, Optical line amplifiers, and CoreDirector core

optical switch.

. Siemens Transxpress Infinity Modular Optical Amplifier

. Alcatel 1648, 1603 SONET.

. Pirelli optical amplifiers, post amps, line amps.

. Experienced in testing transmission and optics specifications for DWDM,

wrote test plans and used SONET/Optics test equipment.

. Performing both end-to-end and site testing on long distance optical

networks.

. Worked on Multi-Optical Repeaters(MOR) and regenerators.

. Verified performance and reliability of new turn-up and existing optical

networks of 1+1, 1:n and Ring.

Contact this candidate