Senior Etl Developer Resume
Raleigh, NC
SKILL:
Teradata Certified Master, Large Enterprise Teradata Data Warehouses, SQL, Ab Initio developmentOracle DBA, Analytics Dashboards Reporting, Business Intelligence, RDBMS, Data Modeling, Erwin, PowerDesigner, Control - M, CA-7, UNIX Korn Shell, Putty, WinSCP, JAVA, Visio, Excel, IBM Mainframe, COBOL, DB2, MVS/ESA, TSO ISPF, IMS, ERP, Datacom, CICS, Assembler, ROSCOE, Agilex, Project Management, RPG, PMON, Data Marts, Microstrategy, BMC Remedy Change Management, Service Now, SaaS. Finance, Accounting, Banking, Retail, Sales, Merchandise, Credit Card, HR, Federal Government, Payroll
EXPERIENCE:
Confidential, Raleigh, NC
SENIOR ETL DEVELOPER
Responsibilities:
- Security clearance. Data warehouse ETL developer.
- I designed and enhanced EDW enterprise data warehouse systems supporting business intelligence.
- I have done ETL development (Extract,Transform,Load) using AB Initio, Teradata, SQL, UNIX Korn Shell, data modeling etc.
- Performance tune queries on Teradata platform and optimize business intelligence queries.
- I coordinated with Microstrategy developers, source systems, and users.
- I am an ETL and SQL expert.
- As a Oracle DBA I handled database deployments and activities.
- Administrator on ITIL platforms, Change Management systems including BMC Remedy and ServiceNow, SaaS.
- Developed Dashboards for Analytics importing data from spreadsheets.
- Developed Control M jobs and wrote technical specifications on ETL batch processes.
- Skills include AB Initio, Teradata Data Warehouse, ETL, SQL, Data Modeling, Oracle DBA, Unix Korn Shell, SAS, analytics.
Confidential, Duluth, GA
SENIOR ETL DEVELOPER
Responsibilities:
- Designed and developed processes on the Teradata EDW (Enterprise Data Warehouse) for ETL (Extract, Transform, and Load) operations.
- Optimized business intelligence through SQL queries, indexes, tables, and macros.
- Incorporated data information from different departments into the data warehouse.
- Wrote technical specifications on ETL systems. Performed data modeling tasks using Erwin.
- Troubleshooted issues with data and reports.
- Worked with data modelers, DBA, business analysts, Microstrategy developers, product/project managers, customers, etc.
- Experience includes Teradata, ETL, SQL scripting, Data Modeling, PowerDesigner, Erwin, Visio, DB2, COBOL, MVS/ESA, TSO ISPF, CICS, Datacom, Eztrieve, NT environment. in JAVA, ORACLE, etc.
Confidential, Marietta, GA
SENIOR PROGRAMMER ANALYST
Responsibilities:
- Developed COBOL applications for HR, Payroll, and Marketing systems.
- Experience includes MVS/ESA, JCL, COBOL II, TSO ISPF, VSAM, IBM utilities, batch programming.
Confidential, Columbus, GA
PROGRAMMER ANALYST
Responsibilities:
- Developed applications in Assembler language for Credit Card processing of VISA, MasterCard, Diner Club, bank cards.
- Batch/online programming, MVS/ESA, COBOL, CICS, Assembler, JCL, CA-7 scheduling, REXX, TSO ISPF, VSAM, IDCAMS, SYNCSORT, Fileaid, Multitrak, AVRS, Endevor.
Confidential, Maitland, FL
BUSINESS ANALYST
Responsibilities:
- Spearheaded design and development of new database system on Dbase.