SUMMARY

• 9+ years of IT experience as developer using TERADATA (V2R5, V2R6, V12, V13, V14), ETL processes and supply chain concepts involving in all SDLC phases like Business Requirements Analysis, Application Design, Data Modeling, Development, Testing and Documentation.
• Expertise in Project Management for SDLC methodologies including Waterfall and Agile.
• Administering large Teradata database system in development, staging and production.
• Strong knowledge of Teradata RDBMS Architecture (AMP, PE, BYNET and Data distribution by Index’s/Hash concepts).
• Expert in Dimensional Data Modeling, using Data Modeling, Star - Join Snowflake Schema Modeling, FACT & Dimensions Tables, Logical & Physical Data Modeling usingERWIN
• Expertise in Design, development, testing of Extract, Transform and Load (ETL) processes necessary to load and validate data warehouse using UNIX shell scripting
• Strong domain knowledge in Teradata DCM (Demand Chain Management).
• Experience in developing Teradata databases, manipulating data and making change to dimensions in databases using Teradata Utilities
• Created Tables with Referential Integrity for implementing business rules and queries were developed using SQL.
• Experienced in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
• Expertise in Migration of objects from Oracle databases to Teradata
• Extensive knowledge and experience inCOBOL, JCL, SQL, DB2, VSAM, FILE-AID, TSO/ISPF, CA7 (Scheduler), SPUFI and FTP.
• Creation and maintenance of mainframe execution JCL (jobs)to support system replacement project in User acceptance (UAT) and Production environments.
• Perform Grant, Revoke table accesses to Database Analysts, Business Analyst, Operational Analysts and Project Manager
• Extracting data from existing data sources, Developing and executing Business reports for Performance Monitoring
• Provided performance tuning and physical and logical database design support in projects for Teradata and DB2 systems.
• Experience in preparing Business reports using Teradata SQL and BTEQ
• Developed SQL, Stored Procedures, Views, Indexes and Constraints, Query Optimizer.
• Strong hands on experience using Teradata utilities like SQL, BTEQ, Fast Load, MultiLoad, FastExport, Tpump.
• Performing Adhoc reports using Teradata, BTEQ, and UNIX.
• Developed scripts using UNIX shell scripting to format data in Teradata RDBMS.
• Experience in working on Performance and Optimization of the SQL Queries.
• Hands on experience and proven practices of resolving performance issues at various (Applications, Database) Levels.
• Hands On experience creating, converting oracle scripts (Sql, Plsql) to Teradata scripts.
• Team player with ability to adapt to various environments with excellent communication and interpersonal skills.
• Attending project meetings and work with teams, Project managers, team members associates, business analysts, statisticians, and internal customers/ end users, working with multiple tasks. Strong written and oral communication skills.

TECHNICAL SKILLS

Operating Systems: Windows 7, OS390, Linux, Unix

Languages: BTEQ, SQL, Unix/Linux Shell Script, COBOL, JCL

Database: Teradata, Oracle, DB2, SQL Server

Special Software/ Tools: Sub Version (SVN), Putty, SQL Assistant, View Point, TSAM, FastLoad, MultiLoad, FastExport, Tpump, Teradata Statistics Wizard and Priority SchedulerBeyond Compare, Teradata Admin, IBM Tivoli Workload Scheduler, HP Quality manager, ISPF, Endevor, CA7, File-Aid, File-Manager, Platinum, Fault-Analyzer, Spufi, QMF, Online and Batch Debugger, SDSF, Bundle, Arzos, Queue Tool, SQL Server Reporting Services.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Teradata Consultant

Responsibilities:

• Involved in Data analysis and Data model designs.
• Prepared metadata documents for all source tables
• Prepared data mapping & transformation documents
• Involved in ETL design phase and prepared high level designs documents
• Developed low level design documents & jobs specs for staging and core layer jobs
• Involved in giving Quick resolutions and design changes when there was a requirements changes
• Prepared Unit test and system test cases and involved in testing phase.
• Involved in tracking and reviewing the defects in all phases of the project using HP Quality center
• CreatedUML DiagramsincludingUse Cases Diagrams,Activity Diagrams/State Chart Diagrams,Sequence Diagrams, Collaboration DiagramsandDeployment Diagrams, Data Flow Diagrams (DFDs) and Entity Relation(ER) Diagrams using MS Visio
• Writing complexSQL Queries, Stored Procedures, Triggers, Views User Defined Functionsto implement the business logic
• Used teradata utilities like for Teradata ETL processing huge volumes of data throughput Fast Load, Fast Export, MultiLoadandTpump
• Wrote numerousBTEQ scriptsto run complex queries on theTeradata database.Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Worked on Teradata SQL, BTEQ, MLoad, FastLoad, and FastExport for Ad-hoc queries, and build Unix shell script to perform ETL interfaces BTEQ, FastLoad or FastExport
• Worked on data moving the tables from Oracle/SQL server to Teradata.
• Used differentkinds ofSQLJoinsto join more than 10 tables.
• ImplementedConstraintson tables for maintainingData Integrity.
• Optimized queriesby looking atExecution Planfor better tuning of the database.
• Involved inNormalizationandDe-Normalizationof existing tables for faster query retrieval.
• Involved in analysis process of low level designs and provided design documents
• Performing high/detailed level estimation and planning work parcels for GMIS Application.
• Involved in tracking and reviewing the defects in all phases of the project using Clear Quest
• Prepared Unit test and system cases and involved in testing phase.
• Developed data mapping document and development of Group Ordering extracts - Order Lines
• Packaging of the developed component to be deployed in production environment using Change man package (Enhancements) Fixing production bugs.
• Temporary and permanent fix within Application Service Level Agreement (ASLA)
• Involved in implementation and batch monitoring

Environment: Teradata14, Teradata 14.10, SQL server, TSAM, SQL Assistant 13.0, Business Objects, BTEQ, FastLoad, FastExport, Multiload, Tpump, MS Visio, View Point, Data Mover.

Confidential, Cleveland, OH

Teradata Sr. Developer

Responsibilities:

• Used ETL for efficient mapping and transformation techniques and processed the data from various source to Teradata Confidential tables
• Analyzed user requirements and developed, tested, and tuned various scripts, procedures, and database triggers to validate data.
• Migrated Oracle and DB2 database objects to Teradata
• SQL scripts were developed for accessing data from the Teradata tables.
• Worked Extensively in Teradata DCM (Demand Chain Management).
• Developed Bteq scripts to load data to Teradata and developed UNIX scripts to access Teradata.
• Tuned the SQL queries for optimum performance.
• Extracted data from various production databases using Teradata to meet data needs.
• Data loaded into Teradata from flat files using data stage dynamic sequence job with schema file concept.
• Wrote Case Expressions, Data Manipulation Command by using Teradata (BTEQ).
• Created numerous Volatile, Global, Set, MultiSet tables.
• Used Inner, Outer Join, UNION, INTERSECT, CUBE, RANK and OLAP functions CSUM, MSUM, MAVG, MDIFF.
• Used Basic Teradata Query utility for reporting Purpose.
• Developed Basic Teradata Query (BTEQ) for Interactive & batch queries.
• Used for loading, Mload for modifying database objects.
• Assisted in the analysis, design, coding and development of building a new schema (staging tables, views, SQL files).
• Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using SQL, Ms Excel.
• Worked closely with different Marketing Groups in designing and analyzing the data.
• Performed two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.
• Built the Operational data store by using BTEQ, Teradata, Oracle, DB2, SQL, and UNIX.
• Scheduled jobs for batch processing using Maestro Scheduler.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
• Refreshed data from production into lower life cycles using Data Mover.

Environnent: Teradata12, Teradata13, SQL Assistant 12.0, CAS, Oracle. IBM DB2, Business Objects, BTEQ, FastLoad, FastExport, Multiload, Korn Shells, MS Visio, View Point, Data Mover

Confidential, Atlanta, GA

Teradata DBA /Teradata Consultant

Responsibilities:

• Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
• Developed the DW ETL scripts using BTEQ, Stored Procedures, Macros in Teradata
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Created numerous scripts with Teradata utilities BTEQ, MLOAD and FLOAD
• Developed mappings to load data from Source systems like Oracle to Data Warehouse
• Highly experienced in Performance Tuning and Optimization for increasing the efficiency of the scripts.
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Developed reports using the Teradata advanced techniques like rank, row number
• Communicated with business users and analysts on business requirements. Gathered and documented technical and business Meta data about the data.
• Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata
• Experienced in using OLAP functions like sum, count, csum and etc.
• Proficient in working on Set, Multiset, Derived, Volatile Temporary tables.
• Proficient working in loading data into staging tables via views.
• Designed and developed weekly, monthly reports related to the marketing and financial departments using Teradata SQL.
• Experience in Power Point Presentation (Financial Data, Charts).
• Expertise in generating graphs using MS Excel Pivot tables.
• Extracted data from existing data source, Developing and executing departmental reports for performance and response purposes by using oracle SQL, MS Excel.
• Extracted data from existing data source and performed ad-hoc queries.

Environment: Teradata12, Teradata13, SQL Assistant 12.0, CAS, Oracle, IBM DB2, Business Objects, BTEQ, FastLoad, FastExport, Multiload, Korn Shells, MS Visio, View Point, Data Mover.

Confidential, Minneapolis, MN

Production Support Executive

Responsibilities:

• Provide 24 x 7 production support for the Confidential Financial applications.
• Support Confidential Financial applications which are used credit settlement with the third party banks.
• Maintenance and Bug Fixes/Break fixes.
• Handling Performance tuning issues.
• Analyzing the problems identified either during the Unit Testing, System Testing or Integration Testing and applying the fixes.
• Responsible for handling the business queries and other tasks mentioned in the financial applications.
• The estimation, planning and scheduling of each of these fixes.
• Designing the application based on the finalized requirements from the business user and came up with the high level design document.
• Performed the unit testing, integration testing and system testing for the application.
• Coordinate with the QA team for the QA testing of the applications and defect fixes.
• Involved in the technical design and development of the application.
• Experience in leading a Team technically and assigning the tasks to the team and updating the development and the testing status to the Lead on day by day basis.
• Coordinating, Planning & Executing the System Development Life Cycle.
• Ensure compliance to Timesheets.
• Preparing unit test plan.
• Unit Testing.
• Participate in Teleconferences.

Environment: COBOL, JCL, UNIX, SQL, IBM DB2, TSO/ISPF, File-Aid, Endevor, MVS, QMF, Platinum, CA-7File Manager for DB2, IBM Debugger, Bundle, Fault Analyzer, JMRlog

Confidential

COBOL Developer

Responsibilities:

• Involved in Requirement Analysis, Coding, Technical support, and Testing and Quality assurance.
• Prepare the Analysis and understanding documents.
• Resource and project planning for optimum usage of resources and seamless delivery for meeting the project deadlines.
• CodedCOBOL and COBOL DB2programs and tested them thoroughly.
• Creatingbind strategiesandrunning bindjobs.
• UsedCA7 (Mainframe Production Control Scheduling)to schedule jobs.
• Monitor and ABEND resolution of MVSCA-7batch processing.
• Used Endeavor to create, stage, and deploy COBOL packages in to production site.
• Assurance of fast and error free delivery of requirements within limited amount of time.
• Monitoring the Error events and resolving them.
• Create and modify JCL jobs in production.
• Analyzing the issue mentioned in Ticket and applying appropriate solution.
• Carried out the Change Release (Regression Testing) test schedule where planned changes going to production were routed.
• Provide technical assistance to the team for solving abends.
• Creating Change Request (CRs) as and when required.
• Tracking the work in progress and attending status meetings.
• Performing detailed turnover of all activities performed.
• GivingKT(Knowledge Transition) to newer team members.
• Ensure that the project documentation is maintained as per the Project Life Cycle and all documents are version controlled and maintained.
• Used QMF for executing Query.

Environment: COBOL, JCL, SQL, IBM DB2, Endevor, QMF, Platinum, CA-7, File-Aid, File Manager for DB2, IBM Debugger, Bundle, Fault Analyzer