SUMMARY

• 7 years of total IT experience in the Analysis, Design, Development, Testing, Implementation and Support of Database Systems in UNIX and Windows environments.
• Strong working experience in designing and developing of Extract transfer and Load (ETL) processes on Teradata.
• Hands on experience using Teradata utilities (Teradata SQL Assistance, BTEQ, FastLoad, MultiLoad, FastExport, TPUMP, PMON, Teradata Admin and Viewpoint) and Unix Shell scripting.
• Strong working experience on Data Warehousing applications, directly responsible for the Transformation, Extraction and Loading data of multiple formats into Data Warehouse.
• Proficient in Database Performance Monitoring, SQL Query Tuning.
• Familiar with working on MVS systems utilizing JCL.
• UC4 and Unix Shell Scripts.
• Coded well - tuned SQL and UNIX Shell scripts for high volume data warehouse instances.
• Well versed with Data Warehousing concepts, design techniques and dimensional modeling.
• Good Knowledge of Data Modelling, Data Extraction, Data Integration and Data Mining for DSS as a Data Warehouse developer using ETL (Data Stage) and OLAP Tools.
• Experience in Database Programming, SQL, PL (Stored Procedures, and Triggers) in Teradata.
• Proficient in using DataStage Director to schedule jobs.
• Excellent ability with competitive spirit in finding various approaches for problem solving and highly skillful, creative and innovative in developing efficient logic/code.
• Team player with ability to adapt to various environments with excellent communication, interpersonal skills and a strong commitment towards Customer Satisfaction.
• Worked on data analysis and data validations and preparing Unit Test Cases.
• Performed unit testing and integration testing for the developed data load process.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

Operating Systems: Windows 8.1/7/XP/NT/2000, Unix, Linux.

Databases: Teradata 14.10/13.10/12, SQL Server 2008 R2, Oracle 9i, 10g

Teradata Tools: Teradata Tools (TPump, FastLoad, MultiLoad, FastExport, Teradata Admin, View Point, PMON, Teradata SQL Assistance), Microsoft VSS/TFS, Autosys, SOLMAN, Microsoft BI SQL Server 2008, SQL *Plus, PL/SQL, Forms 6i and Reports 6i, PL/SQL Web Toolkit (PL/SQL Cartridges), SQL Assistant, Visio, Excel, MS Word.

Reporting Tools: Micro strategy, Business Objects, SSIS/SSAS/SSRS

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

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Sr. Teradata Developer

Responsibilities:

• Involved in business requirements, technical requirements, high-level design, and detailed design process.
• Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD.
• Worked on loading data from Enterprise Data Warehouse and Supporting Subject areas using DataStage.
• Perform tuning and optimization of database configuration and application SQL.
• Writing shell scripts to run the automated programs in timely manner and materialization scripts to save time for big queries.
• Installation of Teradata drivers for the Teradata utilities on Windows.
• Refreshed the environments by using fast export and fast load utilities.
• Performed unit and system test for the modified code and loaded shadow data marts for testing prior to production implementation.
• Involved in centralized data management for important entities; single portal for multiple users across multiple organizations, enables consistent data flow throughout the enterprise, data validation and error checks to ensure input data is clean.
• Developed Data Stage jobs using Parallel Transformer stage, Basic Transformer stage, Aggregator stage, OCI stage, Datasets, Sort stage, Sequential file, funnel, Join and Lookup Stages.
• Developed Parallel Routines and Custom Built-Operators to meet the business logic which was otherwise not possible with available active/passive stages.
• Created Data Stage Sequencers using Job Activity, User Variables Activity, Execute Command Activity, Notification Activity, Sequencer activity and Nested Condition activity which house Data Stage jobs.
• Acted as the lead developer for all the ETL jobs, reading data from the vendors and affiliates, and finally loading dimension, fact and other aggregate tables.
• Worked with the users and testing teams to implement the business logic as expected.
• Written several Teradata BTEQ scripts to implement the business logic.
• Job scheduling using UC4.

Environment: Teradata 14.10, UNIX, UNIX Shell Scripting, Suse Linux, DataStage, BTEQ, MLOAD, Fast Load, FEXP, UC4

Teradata Developer

Responsibilities:

• Involved as Tech Lead & developer in requirements gathering, design and development of the user stories by following the agile methodology.
• Manage a team, with day to day activities of involving active development, mentor team, also support and enhancements of the system.
• Extensively used DataStage as ETL to load data from files into staging area and then to Data warehouse by applied business transformations in another layer.
• Co-ordinate with DBAs, Warehouse operation Managers and Business user communities.
• Interacted with the Client technical team to analyze the business process and gathered the requirements.
• Involved bug fixesand optimization of ETL processing.
• Involved in solving user issues
• Involved in the code reviews prepared by the teams.
• Prepared production support documents and provided training to the support teams.
• Involved with migration team to fix the deployment issues in the Production environment.

Environment: Teradata 13.10, Teradata Utilities, DataStage, Autosys, UNIX, Linux, MS Windows XP/7

Confidential, Pleasanton, CA

Teradata Developer

Responsibilities:

• Gathered, documented, and analyzed user requirements for the operational data marts.
• Did majority of the ETL design, including Process specifications, Source to Target mappings, selection of the appropriate Teradata Extract/Load tools.
• Co-coordinated improvements and enhancements to the data marts, by acting as a bridge between the users and the development teams.
• Writing shell scripts to run the programs in timely manner.
• Updating all the historical mainframe data at EDW side according to business requirements.
• Deployment of new code and observation of night batch cycles.
• Responding/clarifying to customers/business if they had any issues.
• New job settings at OPLAIS side.
• Enabling new jobs and disabling mainframe jobs at EDW end.
• Structural changes in EDW tables or in process to eliminate mainframe.
• Worked in ACF (Agent Control File) and ECC (Expanded commission control) eliminations.
• Performance tuned ETL Batch jobs, Reporting and Ad-hoc SQL.
• Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD.
• Exported numerous files, created through extensive transformation of the data, to different vendors.
• Provided on call support for the entire Enterprise Data Warehouse processes. Solved numerous issues arising from batch processing in minimal time.

Environment: Teradata 12, MAINFRAMES MVS, TSO/ISPF/JCL, CA-7, BTEQ/BTEQWin, FastLoad, Visual Explain, Teradata Manager, SQL Assistant, Oracle,PL/SQL, Windows XP

Confidential, Chicago, IL

Associate Technical Consultant

Responsibilities:

• (PL/SQL) Stored Procedures, Self Service Applications, and Developing PL/SQL Web Applications using PL/SQL Web Toolkit (PL/SQL Cartridges) in Oracle Applications 11i.
• Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process
• Implemented quick fix and suggested a Permanent fix to the other Teams as per the Business need.
• Implemented Data fix on database as per the User Request for the Business.
• Involved in peer to peer reviews.
• Involved in System Maintenance /Database upgrade/ patch Upgrades - Planning, Scheduling, Co-ordination, Communications, Implementation, and Testing.
• Used TOAD for database designing and business process flow.
• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
• Extensive testing was done on the programs for achieving accuracy, timely processing of data.
• UsedODBCto connect to the target Oracle database.
• Used Java Script functions to data validation of the fields in the forms at the front end which are not allowed at the Oracle database and format validation fields like email id, Zip code etc.

Environment: /Tools: Oracle Application 11i (11.5.9), Oracle 9i, PL/SQL, PL/SQL Web Toolkit (PL/SQL Cartridges), and Java Script, PL/SQL Self Service Application and AOL. Sun Solaris, MS Windows

Confidential

Software Programmer

Responsibilities:

• Analyze and design Database and Designing GUI’s.
• Developing plans for Database connectivity.
• Pre sales activities and requirement analysis.
• Feasibility study for implementing software solutions using oracle databases and tools.
• Planning and implementing user security processes.
• Planning, scheduling and automating Backups and Archiving.
• Supported for managing Database security using Roles and privileges.
• Used SQL*Loader utility to load data into oracle apps database.
• Involved in release activities (Release notes, Package preparation) to the client at maintenance phase.
• Coordination with the onsite team for the clarifications and discussions.
• Analyzing and testing the functionality of all the key modules.
• Involved in finding the bugs and preparing analysis documents for PMT’s.
• Conducting trainings / KTs to new comers.
• Involved in Regression and Performance Testing.
• Developed tools to automate some work by using PL/SQL and UNIX.
• Involved in maintaining historical data in Teradata.
• Job responsibilities include creating database objects like tables, indexes, views etc. using SQL Plus, import and export of database.

Environment: Oracle/ SQL Server, Developer 2000 (Forms 4.5 & Reports 2.5), VB, Crystal Reports, SCO UNIX, Windows.