Data Analyst Resume

SUMMARY:

Master Certified Teradata Professional Consultant, ETL Developer and Mainframe Developer with over 13 years of IT Experience in Design, Development, Implementation, Maintenance and Tuning of Data Warehouse/Database and Business Intelligence applications for a wide range of industries using Teradata, Mainframe Technologies and UNIX.
Technical design developer with 10+ years of software life - cycle experience with Multi Terabyte Data Warehouse and Client Server applications. (Teradata V2R6/V2R5/V2R4/V2R3, Teradata SQL Assistant, BTEQ-DOS, BTEQWIN, BTEQ, FastLoad, MultiLoad, TPump, FExport).
Experience in development and design on ETL methodologies for supporting data transformations and processing, in a corporate wide ETL solution.
SQL Performance Tuning and Creation of Indexes for faster Database access and better Query performance in Terabyte level database.
Strong working experience in planning and carrying out of Teradata system extraction, Loading Process and Data warehousing, Large-scale Database Management and Reengineering.
Proficient in Teradata Database design(Logical and Physical), Application support, Performance Tuning, Optimization, Data Administration and setting up Test and Development Environments.
Experienced in Creating Teradata scripts using BTEQ, FLoad, MLoad, FastExport, TPump and Teradata SQL Stored Procedures.

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential

Responsibilities:

Involved in Data Migration between Mainframe DB2, VSAM files, Teradata and Oracle.
Highly experienced in Developing Mainframe Programs using COBOL, DB2, and VSAM.
Experience in creating several JCL jobs and scheduling them using Control-M.
Participated in a Decision Support Project team to develop views necessary for structured and ad-hoc reporting.
Fast learner, technically strong, committed and well accepted & appreciated employee by peers and supervisors. Friendly, supportive and is able to work independently and in a team and also established the rapport with peers and supervisors at all levels in and outside the department(s) in earlier organization(s).

TECHNICAL SKILLS:

Operating Systems: NCR UNIX 4400/5100/5250, IBM MVS OS/390, Z O/S

Data Warehousing: Informatica ETL, SQL*Loader.

Databases: Teradata V12, Oracle 9.x, DB2, VSAM.

Teradata Utilities: BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT,TPUMP, SQL Assistant.

Reporting Tools: Business Objects XI, IBM Cognos 7.

Languages: COBOL II, SQL, JCL, PL/SQL.

Mainframe Tools: Xpediter, File-Aid for DB2, SPUFI, QMF, Abend-Aid, TSO/ISPF.

Business Areas: Software system applied to Financial Credit & Banking, Retail marketing, Telecom and Health Insurance.