SUMMARY

• 7 years of software experience in Evaluation, Analysis, Design, Development, Testing, Deployment and Production support on Teradata, Informatica, Mainframe, Linux, Vertica Platforms
• Played a lead role in all phases of a migration project - From Teradata-Mainframe platform to Linux-Vertica platform
• Technically proficient, Customer dedicated, remarkable experienced in Mainframe development & Maintenance projects built with COBOL, IBM Tools, Teradata tool and utilities V13, Linux
• Exposure to ETL tasks involving datastage
• Ability to work both independently and in a team environment.
• Have a good appetite to learn new tools/concepts at work. Motivated to deliver exceptional customer service proven to result in successful business outcomes.
• Experienced as Senior software Developer & Technical Analyst for projects involving Teradata, Informatica, Unix, Mainframe etc. Have hands on experience in Onsite-Offshore model projects.
• Excellent experience in Data Analysis & Design.
• Good in understanding the business requirements and developing Analysis documents, Technical Design & Specification documents for the Developer requirements
• Proficient in development using Teradata Utilities, Informatica PowerCenter, COBOL, DB2 utilities, Unix scripting etc.
• Strong Experience in tools like SQL assistant, SQL Workbench, Autosys, Clearcase, Toad, Endevor, Changeman, File-Aid, File manager, QMF/SPUFI, Work Load Manager.

TECHNICAL SKILLS

Database Platforms: Teradata, Informatica, DB2, Unix

OS: IBM, OS/390, z/OS, Windows, Unix/Linux

Languages & S/W: SQL, JCL, COBOL, Unix Script

Tools: SQL-ASSISTANT, SQL Workbench, Queryman, Toad, Teradata tools and utilities V13(BTEQ, MLOAD, FLOAD, TPUMP, FastExport), TSO, ISPF, FILE-AID, File Manager, DFSORT, SAR, SPUFI, QMF, IBM mainframe utilities and tools, NDM, FTP/SFTP, RPCs

Scheduling Tools: CA-7, Autosys, Work Load Manager

Documentation Tools: MS-Office, MS Visio, SharePoint, Discovery

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Teradata DBA

Responsibilities:

• Mapping of data from source to staging to target database TERA DATA and ETL processes for complete project lifecycle and involved analysis, High level Design, Low level Design documentation
• Responsible for creating, Tables, Views, Indexes (Primary, Secondary, Partitioned etc.), Triggers, and Macros in different phases and different segments of the project and involved in Performance tuning.
• Designed and developed various Mappings, Mapplets to implement the business logic using different Transformations.
• Proficient in data modeling using MDM and BW extended star schema models
• Extensively built Info Objects, Info Sources, Info Packages, ODS, Info Cubes
• Performed extensive CO-PA, LO Cockpit and generic data extractions, Configured and implemented BW reporting using BEx analyzer/browser.
• Knowledge of BW security and authorizations
• Archiving of data and used Fast export/ Fast load process to migrate data from one system to another depending on the space and business requirements.
• Analyze and Develop Landing/Staging tables based on Business Requirements/Layout.
• Working with Database, User and space management, controlling access rights across Development, Test environments.
• Monitor Teradata application(s) performance using PMON and Teradata Manager.
• Make recommendations for implementing Teradata best practices in place.
• Worked with NCR personnel to register problems, hardware upgrades and to problem resolution.
• Developed and Scheduled workflows, worklets using Workflow Manager and monitored using Workflow Monitor.
• Developed UNIX Shell Scripts to automate the process of running jobs and batches, Involved in Reviews, Validation and Data Integrity checking.
• Troubleshoot problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting.
• Created, tested and implemented Unix Shell scripts for various automated process.
• Responsible for Fixing Errors in Mloads, Fastexports, Bteqs, Fastloads, Config files and Shell scripts for others in the team and providing Technical Support whenever required.
• Provide Production Support for TERADATA and ETL jobs for daily, Monthly and Weekly schedule.

Environment: NCR Windows 2000 Servers 5400 and 5500, HP Unix 11.11, IBM PC/Windows XP Professional, TERADATA V2R5/V2R6, TTU 8.1 (TERADATA Utility Foundation), Teradata ODBC 3.5 ERWIN 4.0, Sun Solaris 9SVM, Oracle Client X.X.

Confidential, Warren, NJ

Teradata DBA

Responsibilities:

• Involved in Create / Modify / Drop Teradata objects like Tables, Views, Join Indexes, Triggers, Macros, Procedures, Databases, Users, Profiles and Roles.
• Involved in the complete re-design of the process flow, starting with design considerations, technical specification and source to target mapping.
• Actively involved in designing the primary indexes, secondary indexes with the application team for tables.
• Manage Teradata Database using Teradata Administrator, Teradata SQL Assistant and BTEQ. Performance Tuning, Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
• Performed application level DBA activities creating tables, indexes, monitored and tuned Teradata BETQ scripts using Teradata Visual Explain utility
• Execute Diagnostic Help stats for session for queries to find missing stats on tables.
• Collect Statistics on UPIs, NUPIs, USIs, NUSIs, non-indexed join columns, small tables for better performance of the queries. .
• Developed stored procedure to collect stats on Databases, Tables, Columns and Indexes by referencing from cross- reference table.
• The stored procedure also collects stats based on 10% change in database size.
• Execute change requests for DDL & DML statements from the users.
• Write, test and implement Teradata FastLoad, MultiLoad, FastExport and BTEQ scripts, DML and DDL.
• Perform data load to staging empty table using Teradata FastLoad from single input file or multiple input files, copy data from staging table to target table.
• Perform data load to existing tables using Teradata MultiLoad.
• Monitor and Abort Sessions for blocked, high CPU consuming, highly skewed and long running queries.
• Monitor Teradata Database using Teradata Manager, Performance Monitor and Teradata Viewpoint.

Environment: Teradata V2R12, SQL, BTEQ/BTEQWin, TPT, FastLoad, Mload, FastExport, and Teradata SQL assistant 7.0/6.1, Informatica Power Center 8.5/7.1, Erwin4.0, Oracle 9i/10g, Windows XP/2000.

Confidential, Tampa, FL

Teradata DBA

Responsibilities:

• Involved in Data Extraction, Transformation and Loading from source systems.
• Performed Data analysis and prepared the Physical database based on the requirements.
• Performed Data validations.
• Responsible for populating warehouse-staging tables.
• Responsible for capacity planning and performance tuning.
• Prepared Performance Matrices.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Developed BTEQ scripts for Teradata.
• Automated Workflows and BTEQ scripts
• Responsible for tuning the performances of Informatica mappings and Teradata BTEQ scripts.
• Worked with DBAs to tune the performance of the applications and Backups.
• Worked on exporting data to flat files using Teradata FEXPORT.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes)
• Build tables, views, UPI, NUPI, USI and NUSI.
• Worked exclusively with Teradata SQL assistant to interface with teradata
• Written several Teradata BTEQ scripts to implement the business logic.
• Used Repository Server Administration Console to create and backup Repositories.
• Writing UNIX Shell Scripts for processing/cleansing incoming text files.
• Performed Unit testing, Integration testing and generated various Test Cases.
• Coordinating tasks and issues with Project Manager and Client on daily basis.

Environment: Teradata 13.10, Teradata SQL, Erwin 4.0, Windows

Confidential, Oakland, CA

ETL/Teradata Developer

Responsibilities:

• Involved in Data Extraction, Transformation and Loading from source systems.
• Performed Data analysis and prepared the Physical data base based on the requirements.
• Performed Data validations.
• Responsible for populating warehouse-staging tables.
• Responsible for capacity planning and performance tuning.
• Prepared Performance Matrices.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Developed BTEQ scripts for Teradata.
• Automated Workflows and BTEQ scripts
• Provided a rich OLAP layer to the business analytics to determine complex ad-hoc and detailed reporting of the business profitability at various levels.
• Responsible for tuning the performances of Informatica mappings and Teradata BTEQ scripts.
• Worked with DBAs to tune the performance of the applications and Backups.
• Worked on exporting data to flat files using Teradata FEXPORT.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes)
• Build tables, views, UPI, NUPI, USI and NUSI.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Written various Macros and automated Batch Processes
• Used Repository Server Administration Console to create and backup Repositories.
• Created Informatica mappings to populate data into fact tables and dimension tables.
• Writing UNIX Shell Scripts for processing/cleansing incoming text files.
• Used CVS as a versioning tool.
• Extensively used Reusable components, custom components and macros in Ab-Initio
• Performed Unit testing, Integration testing and generated various Test Cases

Environment: Teradata V12/V2R6, Teradata SQL, MVS, Oracle PL/SQL, ETL, ODS

Confidential

Jr.SQL Developer

Responsibilities:

• Organized requirements into business and system requirements
• Interpreted business requirements and created functional specifications and providing basic business functional support to application developers.
• Analyzed Requirements and captured functional as well as Nonfunctional requirements and Coordinate functional and stress testing.
• Designed interfaces for existing vendor software and coordinated with them to resolve technical issues.
• Created Process flow, Data flow and Sequence diagrams in order to document business goals and to clarify the functionality of the system to the development team.
• Wrote simple SQL queries to test and validate the field mappings
• Prepared Test Cases for the Business Requirements and executed through various environmental setups as per requirement.
• Used rational clear case to manage the different versions of the source.
• Prepared and Maintained design, test case documents in Rational Clear Case and Updating Rose Models.
• Actively engaged in Data Analysis
• Expertise in identifying, developing and managing business and functional requirements Specifications
• Gathered information requirement analysis, system design, development and application systems, database design, Object Oriented design and Programming skills.
• Performed Unit Testing, System Testing and Production support
• Designed and developed forms for the user interface using MS Visio.
• Designed and developed matrix reports for the analysis of the data.

Environment: UML, MS Visio, Rational Rose, Rational Requisite Pro, Clear Case, Clear Quest