SUMMARY:

• 9+ years of experience in analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverable within committed deadlines. Diverse industry
• 7+ years of Teradata 13/V12/V2R6/V2R5/V2R4.1/V2R3, Teradata SQL Assistant (Queryman). Experience on data load/unload utilities like BTEQ (Import/Export), FastLoad, MultiLoad, T - Pump, Fast Export. Worked on Teradata administrative utilities like Teradata Manager, Teradata Administrator, Teradata Visual Explain and Teradata Index wizard. OLAP, OLTP, ETL, BI, Sync Sort for NCR 4300/5200. Proficient in Teradata V2R5 database design (Logical and Physical), Query Optimization, SQL Performance Tuning, PLSQL and dynamic SQL.
• Teradata SQL, Teradata Basics, Teradata Physical Implementation and Teradata Application development .
• Knowledge on PMON
• 4 years of Dimensional Data modeling experience on Data modeling, Erwin 4.5/4.0/3.5.5/3.5.2 , Dimensional Modeling, Datamarts, OLAP, FACT & Dimensions tables.
• 8 years of experience using Oracle 11g/10g/9i/8i/8.0/7.0, DB 2 8.0/7.0/6.0 , MS SQL Server 2005/2000/7.0/6.0 , Teradata V2R5/V2R4/V2R3, DB2 for OS/390, 12.x/11.x, MS Access 7.0/2000, SQR 3.0, Erwin 3.5/3.x, SQL, XML, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000 and SQL Server 12.0/11.x, MS SQL Server 2000/8.0/7.0/6.5 , MS Access 97/2000.

TECHNICAL SKILLS:

Teradata: Teradata 14,13,V2R5/V2R4.1/V2R3, Data Load/Unload utilities like BTEQ, FastLoad, MultiLoad, Tpump, Fast Export and Teradata administrative utilities like Archive/Restore, Table Rebuild, Check Table, Configuration, Reconfiguration, Filer, DIP., ), OLAP, OLTP, ETL, BI, Sync sort for UNIX/Mainframes, NCR 4300/5200.

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2 , Oracle Designer, synopsis, Visio and Sybase Power Designer.

Databases: Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.2/7.0, MS SQL Server 2005/ 2000/7.0/6.0 , Teradata V2R12/V2R5/V2R4/V2R3, EDI, SAP R/3, Sybase 12.x/11.x, MS Access

Programming GUI: SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, Synopsis, Visual Basic

Environment: HP-UX 10.20/9.0, IBM Mainframes AIX 4.2/4.3, MS DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Ultra, Sun-Spark, Sun Classic, SCO Unix, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos

PROFESSIONAL EXPERIENCE:

Confidential, FL

Teradata/ETL Developer

Responsibilities:

• Communication with business users and analysts on business requirements.
• Worked in complete Software Development Lifecycle Experience (SDLC) from Requirement gathering to Development, Testing, Deployment and Documentation.
• Fulfilled ad-hoc requests coming from superiors.
• Working on SQL’s to get required data.
• Helping the Reporting team by providing the Teradata SQL queries.
• Created Mapping tables for Data load and Complex Report views for Business Objects Universes and Dashboard reports.
• Involvement in implementation of BTEQ and Bulk load jobs.
• Worked on PMON, Manager.
• Created BTEQ scripts to extract data from warehouse for downstream applications.
• Exporting Data using BTEQ and Fast Export.
• Execute the SQL’s on UNIX environment.
• Performance tuning the long running queries.
• Developed processes on Teradata using RDBMS utilities such as Fast Load, Fast Export, BTEQ Teradata).
• Worked with DBAs to tune the performance of the applications and Backups.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Tuning and optimization of Teradata Queries.
• Worked on UDF for masking data.
• Code review’s in production issues.
• Monitoring load job’s and issues.

Environment: Teradata V14.10, Teradata SQL ASST, Utility: Teradata Loading Utilities (Bteq, Multiload, Fast load, Fast Export), UNIX hp.

Confidential, VA

Teradata Developer

Responsibilities:

• Work on SQLs to get required data.
• Help the reporting team by providing the Teradata SQL queries.
• Involve in implementation of BTEQ and Bulk load jobs.
• Create BTEQ scripts to extract data from warehouse for downstream applications.
• Export data using BTEQ and Fast Export.
• Execute the SQLs on UNIX environment.
• Develop processes on Teradata using RDBMS utilities such as Fast Load, Fast Export and BTEQ Teradata).
• Troubleshoot the failure Jobs.
• Develop MLoad scripts to load data from Load Ready Files to Teradata Warehouse.
• Solved various defects in set of wrapper scripts which executed the Teradata BTEQ, MLoad and Fload utilities.
• Wrote Teradata SQL queries according to process needs.
• Used Visual Explain for query optimization.

Environment: Teradata V2R13, Teradata QueryMan, Oracle 8i, Utility: Teradata Loading Utilities (BTEQ, Multiload, Fast Load and Fast Export)

Confidential, Phoenix, AZ

Teradata/ETL Developer

Responsibilities:

• Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD.
• Hands on experience in using code repository CVS, for code check in and checkout process.
• Involved in business requirements, technical requirements, high-level design, and detailed design process.
• Performed unit and system test for the modified code and loaded shadow data marts for testing prior to production implementation
• Worked on Store Procedures SQL tuning and improved the Performance of the Queries.
• Involved in maintaining clean, accurate and consistent ( Confidential CAS - Credit Card Authorization System) data to share across systems enterprise wide using Teradata MDM (Master Data Management) methodology.
• 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.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Generate power point reports using VBA macros and Teradata macros.
• Performance tuning and optimization of database configuration and application SQL.
• Tested the stored procedures and custom tools for Teradata version upgrade from 14 to 14.10.

Environment: Teradata 14, NCR’s Unix Servers 50, Oracle, MVS, SAS 9.1, DB2, VBA Macros, Ab Initio, BTEQ, MLOAD, FLOAD, Affinium, ERWIN.

Confidential, Pittsburgh, PA

Teradata/ETL Developer

Responsibilities:

• Understood the business needs and implemented the same into a functional database design.
• Worked closely with Project Managers, Business Analysts, BI Architect, source system owners, Data Management/Data Quality team to ensure timely and accurate delivery of business requirements.
• Coding using BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQL’s on UNIX environment.
• Working with vendors to provide required data.
• Create BTEQ scripts to extract data from warehouse for downstream applications.
• Participated in Meetings of Designing Source Matrix Preparation for the System for both Dealers vendors and subsequent strategy changes in those systems.
• Export data using BTEQ and Fast Export.
• Used Teradata SQL Assistant extensively to work with Teradata Database.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Develop processes on Teradata using RDBMS utilities such as FastLoad, FastExport and BTEQ Teradata).
• Versed with proactively addressing DBMS performance issues such as partition optimization, indexes, and statistics collection.
• Troubleshoot the failure Jobs.
• Developed SHELL scripts and PERL programs for getting the data from all systems to load into Data Warehousing system. The data was standardized to store various Business Units in tables.
• Performance Tuning of sources, Targets and SQL queries in transformations.
• Used Visual Explain for query optimization.
• Developed unit test plans and involved in system testing.

Environment: Teradata 14, Teradata QueryMan, Utility: Teradata Loading Utilities (BTEQ, MultiLoad, FastLoad and Fast Export), UNIX.