• Ord NC

Mark Lock

Work History

Work History

Systems Developer-Corporate

Corporate Data Warehouse
Systems Developer--Condition/Transform/Load Team Participated in the initial design and development for a data warehousing project. The warehouse was run on IBM SP/2 with 88 Dual Processor RISC 6000 nodes. Data was extracted from over 20 legacy applications and over 100 COBOL copybooks. Developed code to condition, transform and load extracted legacy data into the data warehouse. Develop and maintain physical data model of database. Tools used-Ab initio, Informix XPS, SQL, AIX, Korn Shell, Erwin, Office Applications.

Senior Systems Developer

Corporate Data Warehouse
Senior Systems Developer- Technical expert assisting in developing and implementing processes to handle the First Union/Wachovia merger process in the data warehouse environment. Technical Lead assigned to develop a common cleansing process to be utilized by all data feeds into the environment Designed and developed the process to convert legacy application data from loading monthly to loading daily and implemented a process to load multiple legacy application data feeds simultaneously. Technical lead assigned to design and code the first load ready extract from the data warehouse and send to a data mart on a daily basis. Technical lead assigned to take datafrom an Oracle based system consisting of over 100 tables and load into the data warehouse. Tools used-Ab Initio, Informix XPS, SQL, AIX, Korn Shell, Perl, Erwin, Autosys, Trillium, Visio, Oracle, Office Applications, Harvest, Keon.

Senior Etl Designer/architect

2014 - Present
Wells Fargo Bank
Charlotte, NC Senior ETL Designer/Architect-Mortgage Warhouse Team Build new AbInitio graphs to move data from the production warehouse to UAT Build AbInitio graphs to make data extract files for internal customers. Conduct code walkthroughs and review peer code and documentation. Tools used-Teradata, AbInitio, UNIX, Korn Shell, Harvest, Microsoft Office Applications

Senior Etl Designer/architect

2006 - 2014
Time Warner Cable
Charlotte, NC Senior ETL Designer/Architect-Enterprise Data Management Team Designed numerous new data marts and rebuilt existing data marts to implement a Netezza ELT approach. Architected and designed a solution for sourcing external data sources into the warehouse environment. Led offshore developers thru the development process. Rebuilt existing data warehouse sourcing ICOMS and ACP billing systems. Built a data layer that became a unified source for downstream data marts and reports. Conduct code walkthroughs and review peer code and documentation. Tools used-Netezza, Oracle, Informatica, AIX, Korn Shell, Perl, Tidal, WinCVS, SubVersion, Data Mirror, Microsoft Office Applications.

Application Architect

1994 - 2006
Wachovia/First Union National Bank
Charlotte, NC Application Architect/Abinitio EME Administrator-Enterprise ETL Team

Computer Programming Technician

1989 - 1994
International Business Machines
Charlotte, NC Computer Programming Technician Write and maintain programs for COPICS manufacturing system with a focus on enhancing and building the shipping portion of the software. Manage system data security with RACF. Manage COPICS security and perform regular audits. Order and install personal computers with DOS and OS/2 operating systems. Tools used-COBOL, CICS, DB2, QMF, RPG III, AS/SET and C.

Education

Education

Central Piedmont Community College