We provide IT Staff Augmentation Services!

Teradata Developer Resume

SUMMARY:

  • Over 10 years compound experience in Information Technology groups with major global corporations in financial services and publishing sectors
  • Over 7+ years of experience on Teradata development and OLAP operation with Teradata database and 3 years of experience in Mainframe application programming and development
  • Proven track record in planning, building, and managing successful large - scale Data Warehouse and decision support systems. Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging
  • Extensive experience in designing and developing stored procedures, functions, constructing tables, views, indexes, triggers and user defined data types
  • Experience in optimizing indexes and looking at query plans for highest performance and usability
  • Experienced in various Teradata utilities like Fastload, Multiload, BTEQ, and Teradata SQL Assistant

TECHNICAL SKILLS:

Operating System: OS/390, Z/OS, Linux

Database& File system: TERADATA, DB2 UDB, VSAM, IMS/DB

Languages: C, C++, C#, COBOL, JCL, PL SQL

Other Tools: SQL Assistant, BTEQ, Fastload, FastExport, MultiLoad, T-Pump, Viewpoint, Teradata Administrator, IBM Rational Synergy, Endevor, File-Aid, NDM, Via-soft, Intertest and Changeman

PROFESSIONAL EXPERIENCE:

Confidential

Teradata Developer

Responsibilities:

  • Data alignment initiative addresses inconsistent reporting across field and client reporting channels. dis project will address various data, display, presentation and calculating inconsistencies by order of impact to financial advisors and clients. The main focus is to maintain single data source and integrate all other systems
  • Analyze various client reporting application to identify and prepare a solution to close the gaps
  • Designed and developed various Teradata stored procedures and macros to populate refined data based on the business logic specified by the requirements and send the data to on-line and statement reporting application
  • Developed FastExport scripts to generate different delimited files to external applications processing
  • Automated test scenarios using BTEQ scripts to validate source system data against the Data Mart
  • Performance tuning of Teradata SQL statements using Explain, analyzing the data distribution and index usage
  • Preparing various BI ad hoc reports for operation and business team for decision making

Environment: Teradata, SQL Assistant, Teradata utilities - BTEQ, Fastload, FastExport, MLoad, T-Pump, Viewpoint, Teradata Administrator, IBM Rational Synergy, Linux

Confidential

Teradata Developer

Responsibilities:

  • Migrated Morgan Stanley statement reporting to display securities purchases/sales and holdings information on a Trade Date Basis, departing from the current settlement date based display
  • Developed Teradata Mload and Fastload scripts to bring the data from various text file to staging tables
  • Worked on data enrichment, data standardization for quality check on data coming from various source system
  • Participated in physical and logical data modeling. Identifying the entity types, their attributes and the relationship between entities in the organizational business process
  • Implemented table concept to create cross between SB and MS accounts
  • Designed and developed various Teradata stored procedures to reformat the data and processed in Morgan Stanley system
  • Modified existing stored procedures logic to change transactions on display orders
  • Involved in performance tuning and optimization of long running jobs/quires using features like partitions and data/index cache to manage very large data volume
  • Developed/Modified BTEQ scripts to execute set of stored procedures
  • Modified existing UNXI shell scripts to schedule various jobs

Environment: Teradata, SQL Assistant, Teradata utilities - BTEQ, Mload, Fastload FastExport, Viewpoint, IBM Rational Synergy, Linux

Confidential

Teradata Developer

Responsibilities:

  • Statements renovation is a complete redesign of the legacy application in Morgan Stanley’s Global wealth management division. It generates monthly financial statements for their wealth management customers.
  • Responsible for application development, data Profiling, data quality, quality assurance, and project delivery
  • Developed Teradata Fastload scripts to bring the data from text file to staging tables
  • Designed and developed various Teradata stored procedures to extract real time account system data into open system architecture
  • Implemented complex logic using Teradata Stored Procedures to extract and populate tax lot information for each customer into open system architecture
  • Creating RQC (Real-time Quality control) to ensure data quality of client statements which reduced approximately 20% of data quality issues
  • Developed Bteq scripts to execute set of stored procedures
  • Created UNXI shell scripts to schedule various jobs

Environment: Teradata, SQL Assistant, Teradata utilities - BTEQ, Fastload, FastExport, Viewpoint, IBM Rational Synergy, Linux

Confidential

Teradata Developer

Responsibilities:

  • Tax Reporting system generates IRS (Internal Revenue Service’s) specified Tax forms for Merrill lynch clients and their subsidiaries
  • Design and developed sorted procedures to extract data from various system and load the data into target environment in a specific format
  • Designed and developed Teradata Fast export scripts to generate output files for the third party vendor requirement
  • Preparation of TS (Technical Specifications) based on the existing functionality and requirements. Created detailed technical design specification for enhancing the batch programs

Environment: COBOL, JCL, DB2, Teradata, UNIX

Confidential

Application Programmer

Responsibilities:

  • Design and develop various rules engine based the business requirements using SQL and COBOL programming to collect data from various financial applications
  • Designed and created various reports based business specified format from different financial applications
  • Developed an operational search engine for financial analysts and traders to get specific trade information for their ad hoc requirements
  • Involved in key development role on Ready Assets (RAT) and Cash Management Accounting (CMA) subsystem development

Environment: COBOL, JCL, VSAM, CICS, DB2, IMS/DB, SOLA, File Aid and Endevor

Confidential

Support Analyst

Responsibilities:

  • Managed software and configuration changes on Test and Production environments
  • Troubleshot and diagnosed systems problems; installed and configured varied applications
  • Resolved data quality issues by coordinating with clients and internal units
  • Analyzed causes of production problems and developed methods for improvement
  • Managed daily modifications to support customer's business and technical specifications

Environment: COBOL, JCL, VSAM, File Aid and Endevor

Hire Now