SUMMARY

• Over 8 years of IT experience in Data Analysis, Design, Development, Testing, Configuration Management of Teradata/Mainframe Projects.
• Excellent Experience in Requirement gathering, Application Design, Data Modeling, Development, Testing and Documentation.
• Extensive experience in the Implementation of Data Warehousing using Extraction, Transformation and Loading (ETL) and Reporting.
• Six plus (6+) years of experience using Teradata SQL Assistant, Teradata Administrator and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, ARCMain, PMON, Visual Explain and Exposure to T pump on UNIX/Mainframes environments.
• Extensive experience on various versions of Teradata (V2R6/V2R5/V2R4/V2R3/V2R2) and handled 20TB+ data.
• Extensive Experience in performance tuning of the Database, SQL and ETL code and writing efficient and complex queries on huge volumes of data.
• Experience in designing error and exception handling procedures to identify, record and report errors.
• Expertise in database programming in writing Stored Procedures, Functions, Triggers, Views in Teradata.
• Extensively worked in monitoring Teradata jobs using CA7 in mainframes environment, profound knowledge in UNIX environment and specializing in Autosys jobs.
• Worked on designing the ETLs to move the transactional data to the warehouses nightly and in real time.
• Familiar in Creating Secondary indexes and Join Indexes in Teradata.
• Expertise in developing Test Cases based on Functional specifications and Technical Specifications.
• Extensive experience in System Testing, GUI Testing, Functional Testing, Regression Testing, Database Testing and Performance Testing.
• Involved in unit testing for validating the data is mapped correctly which provides a qualititative check of over all data flow up and deposited correctly in target tables.
• Active contribution with Off - shore team for 24 hours development process and production support.
• Complete knowledge of full life cycle design (SDLC) and development for building Data Warehouse.
• Worked closely with Teradata Development, Testing, Pre-Production and Production teams to align project deliverables within due dates and reporting issues.
• Excellent organizational and analytical abilities teamed with effective oral and communication skills.

TECHNICAL SKILLS

Operating Systems: Windows 7/Vista/XP/NT/2000, UNIX, Linux.

Mainframes: COBOL, CICS, JCL, MVS, DB2, File Aid, File Manager, Abend Aid

Database: Teradata V12/V2R6.2/V2R6.1/V2R5.1/V2R5.0, Oracle 9i/8i/7, SQLserver2000/2005, MS Access

DB Utilities/Tools: BTEQ, Fast Load, Multi Load, Fast Export, T Pump, SQL *Loader, Teradata Manager, Teradata Query Manager, Teradata Administrator and Teradata SQL Assistance.

Languages: SQL, PL/SQL, C, C++, Java.

Scripting languages: PERL, UNIX shell Scripting.

PROFESSIONAL EXPERIENCE

Confidential, Dearborn, MI

Teradata Developer

Responsibilities:

• Extensive experience in writing and executing BTEQ scripts for validation and testing of the sessions, data integrity between source and target database and for report generation.
• Involved in loading data into Teradata database from legacy systems and flat files using complex MLOAD scripts and FASTLOAD scripts.
• Build tables, views with UPI, NUPI, USI and NUSI.
• Perform query inserts, updates and deletes by request from development team.
• Created proper Primary Index (PI) taking into consideration both “planned access” and “even distribution” of data across all the available AMPS.
• Worked with DBAs in assigning the space and privileges for the departmental needs.
• Designed and Developed template scripts, which are used by the developers to improve the maintainability.
• Resolve major Performance Issues in production, and prepared performance tuning guidelines to meet SLA and coding standards for Teradata Load utilities.
• Maintained, Tracked and provided quick and effective solutions for Severity 1 production issues.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked on Tuning, and troubleshooting Teradata system at various levels.
• Wrote hundreds of DDL scripts to create tables, views and indexes in the company Data Warehouse.
• Involved in data profiling on data source and collected stats.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Involved in Historical data migration to new reporting environment.
• Worked on collecting performance metrics on deployment components and getting them approved by the architect to move the code to production.
• Wrote numerous BTEQ scripts to run complex queries on the Teradata database.

Environment: Teradata V12 & V2R5.1 (BTEQ, SQL Assistant, FastLoad, MultiLoad), MVS/Mainframes, DB2, Linux, File Aid, File Manager, Abend Aid.

Confidential, Charlotte, NC

Teradata Developer/ Production Support

Responsibilities:

• Worked as 24/7 on call Production Support for ADIM (Associate Data and Information Management) team for ETL Process design and development in Teradata for Mainframes Environment.
• Help Monitor, acknowledge and solve the abending jobs on Teradata Production Mainframes Environment.
• Creating Prod Ex’s on IBM Maximo for job overrides holds, demand in, post requirements, No Executable etc.
• Extensive experience in writing and executing BTEQ, FASTLOAD, MULTILOAD, and FASTEXPORT scripts for validation and testing of the jobs on SIT, UAT and Production Environments.
• Involved in monitoring the jobs which load data into Teradata database from the data sets using complex Bteq, Fast Export, Multi Load scripts.
• Writing and modifying different JCLs in Mainframes.
• Worked on SSN updates to correct the wrong SSN values which we get from source system (Fidelity).
• Build tables, views with UPI, NUPI, USI and NUSI.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked on Performance Tuning and troubleshooting Teradata system at various levels.
• Performed research queries for the customer to solve the Data missing issues to backtrack and find out where the data is missing while data flow from upstream to down stream.
• Perform query inserts, updates and deletes by request from development team.
• Reporting Special characters, Duplicates to source and correct them in the next feed.
• Worked on creating change man packages and CAB‘s for monthly deployment components.
• Worked on creating overrides and editing data sets to fix the jobs which are abending for bad data issues.
• Worked on monitoring application related data sets and make sure they arrive on time by contacting the source and making sure that we meet the SLA.
• Worked on monitoring the archives in the weekend and cancelling the jobs which are blocking the critical archives.
• Worked on backtracking and solving SEV1 issues where critical data is missing from the reports by attending the analysis and validation meetings with the source and development team.

Environment: Teradata V12 & V2R6.2 (BTEQ, SQL Assistant, Fast Load, MultiLoad), MVS/Mainframes, Teradata SQL, Ca7 scheduling, IBM Maximo, Linux, File Aid, File Manager, Abend Aid.

Confidential

Teradata Developer

Responsibilities:

• Involved in writing the SQL for development process following the FRD(Functional Requirement Document)
• Extensively used BTEQ for analysis purpose.
• Involved in creation and updating of tables using Fastload and Multiload Utilities.
• Used FastExport for creating the flat files from TD tables.
• Involved in modifying and Tuning of already existing code.
• Creating and maintaining the Views and Macros.
• Involved in Developing of physical data model and populating it for data mart.
• Involved in Testing and validation of data before the code moves to QA.
• Testing the code in the staging area before it moves to Production.
• Extensively involved in performance tuning.
• Writing and modifying different JCLs in Mainframes.
• Involved in documenting each phase of the SDLC for the future references.

Environment: Teradata, SQL, Mainframes, UNIX, Windows, MS Excel.