Data Engineer T-Mobile

Mohammad A. Hasan

***** ************ ***** *****, *******, VA 20148

Mobile: 703-***-**** Email: **********@*****.***

Database Analyst / Data Engineer / Campaign Execution

Summary of Experience:

Twenty proven years of experience in Database Design, Analysis, development, testing and implementation of business systems. Broad technical knowledge combined with outstanding leadership ability and creative problem-solving skills in both strategic and tactical areas allowing translating big picture ideas into executable projects. Expertise in Azure Databricks, Oracle, Teradata, SAS, UNIX, business analysis, data modeling and implementation of full software life-cycle development. Responsible for executing Campaigns to increase and retain T-Mobile customer base. Responsible for the design, development, and support of the Sales and Marketing group in data analysis, trending and reporting.

Technical Skills

Azure Databricks, Oracle Teradata SAS UNIX TOAD

PL/SQL Korn Shell COGNOS SYBASE DB2, Ab Initio HTML

CRYSTAL Report, Actuate Report/Web Tools

Education / Training:

B.S., Computer Science, University of Maryland, College Park, Maryland

Work Authorization: US Citizen

Professional Experiences:

T-Mobile, Reston, VA Mar 01 – Dec 23

MKTG DATABASE ANALYST/ Data Engineer

•Designed and implement effective database solutions (Axure blob storage) to store and retrieve data.

•Perform large-scale data conversions for integration into MYSQL.

•Responsible for creating a huge T-Mobile data warehouse with a size over 500 Tera bytes.

•Create and Maintain Teradata Databases (100 TB in size), Users, Tables and Views

using SQL Assistant (Quarryman), BTEQ, Fastload and FastExport.

•Builds and execute automated processes on the UNIX platform to extract, transform, and

load data to the CRM database.

•Some experience on Data Engineering field including Ingestion, Datalake, Datawarehouse, Reporting and Analytics.

•Responsible for conducting advanced campaign development, analysis, and

insight that enables the creation and execution of actions that drive increased

revenues and margins.

•Gathered requirements, designed, developed, tested and implemented Teradata and Unix

based software components to support the implementation of models into various support

databases for both Wireline and Wireless models.

•Develops, documents, and implements automated marketing processes within CRM with

emphasis on maximizing the efficiency and effectiveness of campaign operations and

•Migrate/Convert Data from Oracle to Teradata DW.

•Responsible for monitor and maintain monthly production Oracle database environment,

including runtime Optimization, capacity mgmt, planning, security, configuration and

scheduling.

•Working closely with users of the T-Mobile Datawarehouse (SDW) to identify users needs

to populate data into the SDW. Also checking to ensure that data populated into the SDW

reconciles with the source systems.

Freddie Mac, McLean, VA

Technical Analyst

•Responsible for monitoring, submission and production control of data warehousing jobs.

•Develop SQL and PL/SQL script for complex adhoc reports.

•Extract data from SYBASE tables using SAS procedures through SAS ACCESS and SAS

CONNECT

QWEST Communications

Application Developer

•Member of a data warehousing development team responsible for the following functions:

•Responsible for submission, monitoring and production control of data warehousing jobs.

•Provided input and specifications to other developers for PL/ SQL packages, Korn shell

scripts, control files for data extraction and loading into and ORACLE 7.3.x database.

MCI Telecommunications Corp.

Systems Analyst

•Designed, developed and maintained various MCI order entry systems, using JCL, CLIST,

SAS, SYNSORT, and ISPF DIALOG in a TSO MVS mainframe environment.

•Responsible for producing ad-hoc and monthly reports on East Coast Billing Audit Center,

West Coast Billing Audit Center and Revenue Services.

Claims Administration Corp.

System Technical Analyst

•Designed and developed SAS 6.08 version applications on Mainframe for Database design

and complex management reports.

•Designed, modified data tables, manipulated existing data and created multiple queries using

Microsoft Access 2.0. Analyzed geographic accessibility of health care network through Geo-

Network software.

References: Available on request.

Contact this candidate