SUMMARY:

• Over twelve years of experience with a focus in analysis, design, development, implementation, modeling, testing, closing data gaps, reconciling and support for data warehousing applications.
• Teradata Certified Master V2R5 (all 6 levels of s).
• Two years of experience in capacity planning for data migration projects.
• Six years of experience working as a Teradata Development DBA and support DBA for production.
• Four years of experience in writing SQL scripts/analytical queries as per the business specifications.
• Five years of experience working as a Teradata Data Architect. This involved building data models with 3NF to the Star implementations.
• Experienced writing recursive SQLs (a new feature introduced in Teradata V2R6).
• One year of experience in design, development and deployment of the churn prediction model using Teradata Warehouse Miner 4.1 as data mining tool.
• Over nine years of experience in performance tuning of databases, analytical scripts and business objects queries.
• Experienced in tuning database performances using column compression and PPI implementation.
• Experienced in designing, creating and tuning physical database objects (tables, views, secondary indices) to support normalized and dimensional models.
• Experienced in validating the business requirements (interacting with business analysts from the client) and transitioning to the database schemas (physical data models) from the Logical data model.
• Experienced working on large Teradata Systems.
• Extensively worked on Teradata Utilities like MultiLoad, FastLoad, FastExport, BTEQ, TPUMP, TPT and tools like Teradata Administrator, Teradata SQL Assistant, Teradata Manager and Teradata Performance Monitor, Viewpoint.

TECHNICAL SKILLS:

Development: Visual Basic 6.0, C++, Java

Operating Systems: All Microsoft Platforms, UNIX

Dimensional Modeling: ERWIN 4.x/3.x/7,x

Databases: Teradata V2R5/V2R6/V12/V13, SQL Server 7, Microsoft Access

OLAP Tools: Business Objects 6.1b, Web Intelligence 2.7/2.6, Actuate Reporting, Microstrategy 9

Data Mining Tool: Teradata Warehouse Miner 4.1.0

ETL Tools: Informatica PowerCenter 7.1, Datastage 8.1, Sunopsis 4.0, BTEQ, Fastload, Fastexport, Multiload, TPT

PROFESSIONAL EXPERIENCE:

Sr. Teradata Consultant

Confidential, Framingham, MA

Responsibilities:

• Creating pseudo code based on the mapping document and passing that out to offshore team for development and testing of scripts/migrated data.
• Review of the code developed/ tested by the offshore team.
• Identifying deployed production processes for performance tuning/ re - designing.
• Involved in discussion with Teradata for hardware upgrade as we are adding more nodes.
• Involved in implementing PPIs and MVC. Doing the analysis based on table size.
• Re-designing the backup process as currently few of the backups run for as long as 13 hours.
• Involved in doing the Dev refresh once every month wherein we move the Prod data back to Test environment for real time testing of the code developed.
• Works on Adhoc requests for data movement from Prod to Test using Fastload/Multiload/TPT.
• Working on data anomalies identified by the Business between EODS (DB2) system and MrkDM (Teradata).

Environment: Teradata V14.0, BTEQ, TPT, UNIX AIX 6.1, Teradata SQL Assistant 14.01, Teradata Administrator /Viewpoint 15.10, Tidal Scheduler, Informatica Powercenter 9.5.1, DB2 10.5, Toad for DB2 4.7

Teradata DBA

Confidential, Quincy, MA

Responsibilities:

• Created the roles and profiles.
• Installed the macros in Dev, Test, Prod
• Completed the monthly release to install the macros (DDLs) in Prod
• Performed the backup activities using netvault.
• Moved the data from Prod to Test using TPT
• Granted access to users as needed
• Performance tuning of long running scripts

Environment: Teradata V13, BTEQ, FASTLOAD, UNIX, Teradata SQL Assistant, Teradata

Teradata Lead

Confidential, Virginia Beach, VA

Responsibilities:

• Assisted the team with any issues related to Teradata.
• Taught them the best practices to be followed in Teradata.
• Performance tuning of the analytical scripts.
• Created the physical data models by identifying the table structure/indexes/compression etc.
• Close interaction with the business in understanding the new requirements and incorporating the same via LDM/PDM changes.
• Utilized the Teradata V13 capabilities of temporal data in different tables in the integration layer.
• Write and tuned the stored procedures for loading the data from staging to target.

Environment: Teradata V13, BTEQ, FASTLOAD, UNIX, Teradata SQL Assistant, Teradata Administrator/Viewpoint.

Semantic Lead

Confidential, Englewood Cliffs, NJ

Responsibilities:

• Created the logical data models for different entities identified and defined the relationships between them.
• Created the Physical Data model by identifying the table structure/indexes/compression etc.
• Close interaction with the business in understanding the new requirements and incorporating the same via LDM/PDM changes.
• Responsible for managing the resources that are developing the business views that will enable reporting and analysis.
• Wrote complex SQL’s required for views to deliver intense BI transformations/calculations.
• Performance tuning of long running batch scripts.
• Recommended the indexes/stats collection for long running Microstrategy queries.

Environment: Teradata V13, BTEQ, FASTLOAD, UNIX, Teradata SQL Assistant, Teradata Administrator/PMON, ERWIN 7.3, Microstrategy 9.

Teradata Technical Lead

Confidential, Orlando, FL

Responsibilities:

• Developed the technical design documents by going through the solution design document/data mappings/reporting needs.
• Created Python scripts which would utilize the existing ETL framework and would invoke Fastloads/BTEQs to load the data from the flat files to the tables in D3 Teradata production database.
• Created of above mentioned FastLoads/BTEQs.
• Involved in capacity planning exercise for DVA projects for providing the sizing estimates to the DBAs.
• Involved in modifying the logical/physical data models.
• Involved in creating triage, production support and deployment documents.
• Involved in code-review sessions with the production support team/DBAs.
• Involved in analysis of reporting needs from CMR and creation of materialized views for complex reports which had 10-15 table joins.
• Involved in the creation of DDLs/pass through views/ stats collection scripts.

Environment: Teradata V12, BTEQ, FASTLOAD, Wingware IDE 3.2 (python 2.7), UNIX, Teradata SQL Assistant, Teradata Administrator/PMON.

Teradata Technical Lead/DBA (Dev)

Confidential, Enon, OH

Responsibilities:

• Developed MLOAD scripts for loading the data from flat files to the staging tables for the new shipper item feeds.
• Modified the logical and physical data models for the new feeds.
• Developed BTEQ scripts to load the data from the staging tables to the base tables.
• Incidents/Maintenance/Enhancements (7X24).
• Performance tuning of long running scripts. Stats/ index recommendations.
• Performed developer DBA tasks like creating users/roles/profiles and space allocation tasks.
• Worked on Teradata Manager to monitor and manage resource utilization.
• Capacity planning for new applications.
• Production system monitoring and providing support for any batch failures.

Environment: Teradata V12 on UNIX MP-RAS, Informatica 7.1, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, UNIX Shell Scripting, Teradata Manager/PMON.

Teradata Technical Lead/ SME

Confidential, Columbus, OH

Responsibilities:

• Application systems availability.
• Incident/maintenance (7X24).
• Production system monitoring and provided support for any batch failures.
• Minor enhancements and maintenance.
• Performance monitored the production systems which has have different applications running on top of it. It also requires tuning of the various jobs which are kicked off by these applications.

Environment: Teradata V12 on UNIX MP-RAS, Datastage 8.1, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, UNIX Shell Scripting, DB2, Oracle 9i

Application DBA

Confidential, Plano, TX

Responsibilities:

• Involved in performance tuning of skewed running queries.
• Involved in physical database design from logical data model (3 NF) in consultation with data modelers and business analysts.
• Involved in analysis and implementation of MLPPIs (new extension in Teradata 12) and Join Indexes.
• Involved in identifying columns for compression.
• Involved in analyzing managing the workload on the system.

Sr. Teradata Developer

Confidential, Plano, TX

Responsibilities:

• Involved in writing complex BTEQs to load the data from staging to target,
• Involved in writing error handling scripts to fix the data at source.
• Involved in performance tuning of Business views.
• Involved in interaction with businesses to gather requirements and develop reports for them.
• Involved in maintenance of different subject areas like ITEM and CUSTOMER.

Environment: Teradata V2R6.1/Teradata Database 12.0 on UNIX MP-RAS, Informatica 7.1, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, UNIX Shell Scripting.

Teradata Technical Consultant

Confidential

Responsibilities:

• Reviewing ETL scripts developed using Teradata utilities BTEQs FEXP, FASTLOAD, MLoad Codes.
• Participated in customer interaction, code reviews and follow-up.
• Involved in resolving any data issues cropped up during postproduction
• Involved in preparing the impact analysis document while migrating the data from Oracle to Teradata.
• Involved in checking the quality of data extracted from the Arbor and Mediation systems and subsequently reporting the source system owners of dirty data if any.
• Involved in the Unit/System testing the ETL scripts.

Environment: Teradata V2R5 on UNIX MP-RAS, Oracle 9i, BTEQ, FASTLOAD, Multiload, FASTEXPORT, UNIX Shell Scripting

Teradata Technical Consultant

Confidential

Responsibilities:

• Involved in writing SQL scripts/analytical queries so as to prepare the data to be used as a source for building the ADS.
• Involved in design, development and deployment of the prepaid churn prediction model for Bharti using Teradata Warehouse Miner 4.1.
• Involved in presenting the model variables, lift chart, good predictors of churn.
• Involved in scoring the base customers basis the and the test set developed.
• Involved in conducting performance tuning exercises of the three major databases, which further involved tracking the access logs to determine the user access behavior patterns and accordingly build/modify indexes.

Environment: Teradata V2R5, Teradata warehouse Miner 4.1, BTEQ.

Teradata Consultant/Prod support DBA

Confidential

Responsibilities:

• Involved in production support as DBA and was responsible for monitoring the performance of the system.
• Involved in creating users/databases, assigning space, taking weekly back up.
• Involved in compression activity which led to overall 34percentage of space gain.
• Involved in database tuning.
• Day-to-day interaction with the client to resolve data issues.
• Involved in closing the data gaps between the detailed and the summarized data.
• Developed scripts to extract, transform and load the data from various data sources using BTEQ, Fastload, and Multiload utilities of Teradata as per pre ascertained approved requirements.
• Involved in versioning of the logical and physical data models for the new changes.
• Developed test cases and performed the unit and integration testing of above mentioned scripts.
• Created analytical scripts as per the client’s specifications.

Environment: Teradata V2R5, Datastage, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, Shell Scripting

Systems Executive/Prod support DBA

Confidential, Dallas, TX

Responsibilities:

• Involved in production support as DBA working from offshore
• Developed UNIX Shell Scripts.
• Teradata Utilities Scripts (BTEQ, FastExport, MLOAD, Tpump, FastLoad).
• Migration of codes from to production after validation of the extract generated.
• Beta testing of parameter files and generated extract before delivering the same to the customer

Environment: Teradata V2R4, Teradata Utilities (BTEQ, FastExport, MLOAD, Tpump, FastLoad), ShellScripts

Systems Executive/Prod support DBA

Confidential, Dallas, TX

Responsibilities:

• Involved in production support as DBA working from offshore.
• Business objects universe design and development.
• Development of universe based business objects reports.
• Unit testing of reports.
• Integrated system test support.

Environment: Business Objects 6.1b, Designer, WebIntelligence and Teradata V2R4

Systems Executive/Prod support DBA

Confidential, Dallas, TX

Responsibilities:

• Production system monitoring and support DBA.
• Business objects universe design and development.
• Development of Universe based WebI Reports
• Unit testing of reports.
• Integrated system test support.
• Implementation support.

Environment: Business Objects 6.1b, Designer, WebI and Teradata V2R4

Programmer

Confidential

Responsibilities:

• Overall design, development and implementation of module.

Environment: Visual Basic 6.0, Microsoft Access 2000