SUMMARY

• Over 8+Years of IT experience in Teradata RDBMS and Data warehousing environment focusing mainly on analysis, Requirements collection, design, development, documentation and production support of all stages of full life cycle projects.
• Attending project meetings and work with teams, Project managers, team members / associates, business analysts and internal customers/endusers working with multiple tasks.
• Experienced in load and unload tools like FastLoad, MultiLoad and Fast Export.
• Thorough grasp of Teradata RDBMS Architecture and data warehouse concepts.
• Expertise in report formatting, batch processing, data loading (mload, fload and tpump) and unloading (fastexport) using BTEQ.
• Strong working experience in planning and carrying out of Teradata system Loading Processes, Data Warehousing, Large - Scale Database Management.
• Good experience working with very large databases and Performance tuning.
• Developed and Proficient skills in writing ShellScripts.
• Performing Data validation, Data integrity, Data Quality checking before delivering data to operations, Business, Financial analyst.
• Experience in Study, Design, Analysis, Development and Implementation of Data Warehousing Concepts.
• Motivated to take independent responsibility as well as to contribute to be a productive team member. Strong Team building and mentoring skills and excellent Team leadership capability.
• Strong Logical and Analytical Reasoning Skills, Excellent Management skills, Excellent Communication with good Listening and Intrapersonal Skills.

TECHNICAL SKILLS

Teradata Tools Utilities: SQL Assistant, File-Aid, NDM, CA7, Abend-Aid, Peregrine, Teradata Manager, PMON, Statistics Wizard, Teradata Administrator, Teradata Index Wizard, Erwin

ETL, Reporting & Data: Informatica 7.x, Erwin

Databases: TERADATA V2R5, V2R6, V2R12, V2R13.1

Operating system: Windows 2000, Windows XP, MS-DOS, Z/OS, MVS,UNIX

Utilities: Multi Load, Fast Load, TPump, BTeq

Languages: C, C++, Java

Software: VS COBOL II, JCL, EZTrieve, VSAM, SQL

Others: MS Office, PL/SQL, Korn Shell,VBA,MACROS

PROFESSIONAL EXPERIENCE

Confidential, IL

Sr TD Consultant

Responsibilities:

• Involved in Data Extraction,Transformation and Loading from sources systems thru BTEQ
• Performed Data analysis and prepared the demographics for objects/entity for physical database
• Coordinating tasks and issues with team on daily basis.
• Responsible for capacity planning and performance tuning.
• Prepared MLOAD scripts for loading Confidential tables based on requirements.
• Responsible for tuning the long running SQL’s and complex joins for better performance
• Extensively worked with DBA’s to apply multi value compression for large tables in production.
• Worked extensively with the Teradata SQL assistant to interface with the Teradata
• Built UNIX shell scripts for processing/cleaning incoming text files,archive processed files after certain period of time
• Built tables using UPI,NUPI,USI and NUSI based on demographics of data
• Analyzing the specifications and identifying the source data that needs to be moved to Warehouse
• Performed unit testing and generated various test cases.
• Scheduled bteq scripts data loads through Control-M scheduling tool.
• Query optimization(explain plan,collect statistics,primary and secondary indexes).
• Partitioned the tables which are not partitioned to reduce CPU and I/O usage.
• Used PMON (Performance Monitor Tool) to monitor the performance of the jobs and to find out the active sessions and users logged into the system
• Worked on exporting data to flat files using TERADATA Fast Export.

Environment: Teradata 13.10, Teradata SQL Assistant, MLOAD, FASTLOAD, BTEQ, FAST EXPORT, Control - M, UNIX, MACROS,Windows 7

Confidential, GA

TD Consultant

Responsibilities:

• Responsible for coordinating with Business Analysts in the requirement Gathering process
• Created and maintained high level design documents,functional documents and technical design documents.
• Involved in various stages of Software development life cycle.
• Worked with Teradata SQL Assistant and Used Teradata Fast Load to load the data into the empty tables in the Staging area
• Verify and modify the transformation rules for source to Confidential mapping.
• Created tables, views in Teradata, according to the requirements.
• Performed data load from multiple data source(flatfile,DB2,Teradata) to Teradata using
• BTEQ,Fastload,Multiload.
• Used FastExport utility to extract large volumes of data Confidential high speed from Teradata RDBMS.
• Used Teradata Multiload Utility in order to load the Base tables and extensively worked with Error Tables associated with it.
• Created BTEQ scripts with data transformations for loading the base tables.
• Created unit test plans to unit test the code prior to the handover process to QA.
• Responsible for seeding different environments and data setup as a part of testing.
• Performed data analysis on a set of tables belonging to another application which was meant for some reporting purposes.
• Collected Statistic periodically on tables to improve the system performance.
• Used the feature Explain Plan to find out the bottlenecks in a given Query, thus improving the performance of the job
• Responsible for onshore/offshore coordination.
• Worked with a project development and test team providing support during the project cycle, helping develop optimum solutions for data warehouse deliverables
• Involved in performance tuning of Teradata SQL for optimum performance.
• Provided 24/7 on call Production support on rotation also ran & monitor jobs in Prod.

Environment: Teradata 13.10, Teradata SQL Assistant, MLOAD, FASTLOAD, BTEQ, FAST EXPORT,Mainframes,MACROS,Windows 7

Confidential, NC

TD Consultant

Responsibilities:

• Gathering requirements from the various systems business users.
• Reviewed and translated BRD/BSD in to technical specifications design (TSD)
• Coordinated with SME for technical clarifications
• Working closely with Business users to come with High Level Design, Detailed Design documents.
• Created tables, views in Teradata, according to the business requirements.
• Developed Fast Load scripts to import data from the flat file to Staging area.
• Developed Multiload & BTEQ scripts to Load the data from Staging area to Data Warehouse.
• Created unit test cases with different scenarios
• Closely coordinated with configuration management team for migrating code basesto various Confidential environments SIT/UAT/RT/PROD on different release tracks.
• Involved in Sizing of the Database.
• Generated reports using Teradata BTEQ.
• Developed SQL, Ad Hoc queries to fulfill business analyst requirements.
• Performed tuning of Queries for optimum performance.
• Designed & developed various Ad hoc reports for the CDW Project
• Provide 24x7 on call production support on a rotation basis
• Monitoring, identifying and resolving systems problems that interfere with the smooth operation of the Data warehouse.
• Handling of CR’s (Change Requests) and enhancements for existing application and followed change management process.

Environment: Teradata 13.10, Teradata SQL Assistant, MLOAD, FASTLOAD, BTEQ, TPUMP, Erwin, Unix Scripting,Peregrine,VBA,MACROS,Windows XP

Confidential, IL

Sr. Consultant

Responsibilities:

• Responsible for Requirements Collection, Analysis, Design, Coding and testing
• Responsible for the Data Mapping Analysis, Mapping rules and design
• Responsible for Creation & Analysis of Functional/Technical Specification Documents
• Created some test cases as a part of System Testing.
• Generated reports /scripts using Teradata BTEQ
• Creation & Analysis of Functional/Technical Specification Documents
• Responsible for documentation using the CMM methodologies.
• Responsible for project planning and management.
• Developed scripts using Teradata utilities like MLOAD, FLOAD, fastexport, Tpump
• Responsible for off-shore coordination and customer interaction
• Preparation of test data for regression testing.
• Validating the Confidential data with the source data.
• Initiate project weekly status meetings.
• Develop best practices, development guidelines/standard, and governance process to help to maintain a healthy and stable production environment
• Delivering weekly and monthly status reports and monitoring project flow and planning.
• Implementation and production support for the enhancements to these systems.
• Responsible for Implementation & Post Implementation support
• Provide 24x7 on call production support on a rotation basis

Environment: Teradata 13.10, Teradata SQL Assistant, MLOAD, FASTLOAD, BTEQ, TPUMP, UNIX Scripting, Erwin, VBA, Macros, Windows XP

Confidential, NC

Sr.DW developer

Responsibilities:

• Responsible for coordinating with the Business system Analysts in the requirement gathering process and creating technical specific document.
• Gathering requirements from the various systems business users.
• Perform Gap Analysis between existing ETL process and Standard Business Content, created Gap Analysis documents for each business area identified.
• Responsible for Design, Data Mapping Analysis and Mapping rules
• Responsible for project management and planning.
• Worked on loading of data from several flat files sources to Staging using MLOAD, FLOAD.
• Created Bteq scripts with data transformations for loading the base tables.
• Generated reports using Teradata BTEQ.
• FastExport utility to extract large volume of data and send files to downstream applications
• Developed TPump scripts to load low volume data into Teradata RDBMS Confidential near real-time.
• Created BTEQ scripts to load data from Teradata Staging area to Teradata
• Performed tuning of Queries for optimum performance.
• Performance tuning for Teradata SQL statements using Teradata EXPLAIN
• Collected statistics periodically on tables to improve system performance.
• Instrumental in Team discussions, Mentoring and Knowledge Transfer.
• Responsible for Implementation & Post Implementation support
• Documentation of scripts, specifications and other processes.

Environment: Teradata V2R12, Teradata SQL Assistant, MLOAD, FASTLOAD, BTEQ, TPUMP, Erwin, Unix Shell Scripting,MacrosVBA,Windows XP

Confidential, MN

Sr.DW 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.
• 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
• Worked with DBA’s for transition from Development to Testing and Testing to Production.
• Worked with the users and testing teams to implement the business logic as expected.
• Designed & developed various Ad hoc reports for the CDW Project
• Written several Teradata BTEQ scripts to implement the business logic
• Developed scripts to load high volume data into empty tables using FastLoad utility.
• Perform tuning and optimization of database configuration and application SQL
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Ran and monitor batch jobs in production area.
• Writing shell scripts for automating common tasks

Environment: OS390, Z/OS, VS COBOLII, TERADATA V2R5, EZTrieve, JCL, File-Aid, SQL Assistant, Changeman, CA7, MLOAD, FASTLOAD, BTEQ, TPUMP.

Confidential

Oracle Developer

Responsibilities:

• Analysis of the existing system, for detailed information needed for developing and designing the system. Developed user interface for the application.
• Developed Pro*C programs for loading data with updates.
• Database design, rebuilds, troubleshooting, and performance tuning.
• Developed database procedures, functions and triggers using PL/SQL.
• Developed C programs and UNIX shell scripts for controlling job flow.
• Extensively developed C programs and UNIX Shells for the purpose.
• User Training and post-implementation monitoring of the system.
• Wrote Stored Procedures for data integrity.
• Involved in the process of high-level design for the workflow module. Designed database for the workflow module.
• User and System Documentation are developed for the production area.
• Effectively interface with and respond to users.
• Allocating system storage and planning future storage requirements for the database.
• Analysis and resolution of end user and system reported problems.
• Developed database monitoring and tuning strategies.
• Developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports. Monitor database and system backups

Environment: Oracle, SQL*Plus8.0.5, UNIX, Shell Scripts, C, PL/SQL, SQL Server 2000.