Teradata Dw Consultant Resume
OBJECTIVE
- To secure a challenging position in an organization engaged in building innovative and customer - centric business solutions. I aim to be a part of a growing organization where there is value for work and ample opportunities. I aim to excel in all assignments designated to me and enhance my technical and personal skills through experience and continued learning.
SUMMARY
- Having over 15 years of strong experience in designing, development, maintenance and support areas of Software applications in Banking, Insurance, Healthcare, Retail and Logistics Industry.
- Having 8 years of strong Teradata ETL design, development and support experience.
- SAS Institute Certified Base SAS Programmer with 3 Years of experience in Analysis, Design, Development and Maintenance of SAS ETL processes.
- Well experienced with all key phases like Analysis, Design, Development and Support of a Software Project Development Lifecycle.
- The ability to multi-task and function efficiently in a high-volume, fast-paced environment.
- Strong understanding of the principles of Data Warehousing Concepts, ER Database models (Relational, Snowflake and Star schema) and SCD (Slowly changing dimensions) and Data Marts.
- Have strong knowledge of Teradata Database Architecture, Internal Data processing, Hashing Algorithm in inserting and retrieving Data, Primary and Secondary Indexes etc.,
- Designed complex Teradata Databases involving Logical and Physical Data modelling, establishing the Entity relationships, Database Design and creating Dataflow charts.
- Well experienced with defining different database components like Tables, Views, Indexes, Stored Procedures, Triggers, Macros etc.,
- Developed Teradata Applications by creating Stored Procedures, Macros and BETQ scripts that perform complex data processing.
- Designed and developed complex SQL queries to extract or load data into Teradata database using BTEQ, MLOAD, FASTEXPORT and FASTLOAD.
- Good experience in Fixing data issues and Performance tuning using Teradata Explain.
- Well experienced with designing and developing Teradata Parallel Transporter Operators for loading and extracting huge volumes of data.
- Extensive experience in SAS Data Analysis, SAS Reporting and Maintenance.
- Extensive experience on SAS SQL with DB2 and Teradata for applying transformations and cleansing data.
- Designed complex mainframe batch applications along with jobs, file formats, database tables and execution plans.
- Strong application development experience using COBOL, JCL, SAS, EzTrieve, DB2 and Teradata.
- Involved in Teradata Database Upgrade Testing and Disaster Recovery testing.
- Have Strong Experience in using Teradata SQL Assistant.
- Performed end to end testing by defining test scope, test approach, test scenarios and test cases and performing unit, system and UAT testing and preparing test result documents.
- Strong experience in preparing system/data flow diagrams and implementation plan.
- Knowledge of designing and developing ETL parallel jobs in IBM Datastage Designer 9.1.
TECHNICAL SKILLS
Operating SystemsWindows, MVS, z/OS, UNIX:
Languages: COBOL, JCL, CICS, Easytrieve, SAS, Shell Scripting
Tools: TSO/ISPF, SPUFI, DCLGEN, Micro Focus Mainframe Express, File Aid, ISAM Edit and Teradata SQL Assistant, IBM Datastage 9.1.
Databases: Teradata 13/14/15, DB2, VSAM, ISAM, IMS DB, Oracle, PL/SQL
Version Management: Panvalet, Changeman.
Debugging: Expeditor, IBM Debug, Animator.
PROFESSIONAL EXPERIENCE
Confidential
Teradata DW Consultant
Responsibilities:
- Responsible for meeting Business Users and gathering Business Requirements.
- Responsible for conducting impact analysis to understand the flow of the system and documenting the impacted areas to change.
- Responsible for developing high level design document as per requirements.
- Responsible for designing Database Model and Data Flow diagrams.
- Responsible for defining Teradata Tables, Views, Indexes and other database components.
- Conduct design review meetings with Business Users, Technical Architects and DBAs.
- Responsible for developing Low Level Design document as per requirements.
- Conduct review meeting for Low Level Design document team members.
- Developing ETLs using Cobol, JCL, Unix and Teradata utilities like MLOAD, FXPORT, FLOAD, BTEQ and TPT.
- Developing Stored Procedures for data processing on the database.
- Developing test scripts based on business needs and conduction unit testing by automating/manual setting of the test scripts and verifying the test results in the database.
- Responsible for supporting system and integration testing.
- Responsible for preparing implementation plan and implementing the projects.
- Responsible for post production support.
Environment: z/OS, LINUX, IBM Datastage 9.1 Teradata SQL Assistant
Confidential
Mainframe Consultant
Responsibilities:
- Responsible for meeting Business Users and gathering Business Requirements.
- Responsible for conducting impact analysis to understand the flow of the system and documenting the impacted areas to change.
- Responsible for developing high level design document as per requirements.
- Responsible for designing Database Model and Data Flow diagrams.
- Responsible for defining Teradata Tables, Views, Indexes and other database components.
- Conduct design review meetings with Business Users, Technical Architects and DBAs.
- Responsible for developing Low Level Design document as per requirements.
- Developing ETLs using Teradata utilities like MLOAD, FXPORT, FLOAD, BTEQ and TPT.
- Developing JCL cataloged procedures to execute programs, SYNCSORT utility, DB2 load and unload utilities, JCL utilities etc., using symbolic parameters and conditional codes.
- Developing Copybooks and Parmlib members for using in the programs and JCLs respectively.
- Developing test scripts based on business needs and conduction unit testing by automating/manual setting of the test scripts and verifying the test results in the database.
- Responsible for supporting system and integration testing.
- Responsible for preparing implementation plan and implementing the projects.
- Responsible for post production support.
Environment: TSO/ISPF, z/OS, Linux, Teradata SQL Assistant.
Confidential
Systems Analyst
Responsibilities:
- Responsible for meeting Business Users and gathering Business Requirements.
- Responsible for conducting impact analysis to understand the flow of the system and documenting the impacted areas to change.
- Responsible for developing high level design document as per requirements.
- Conduct review meeting for high level design document with Business Users and Technical Architects.
- Responsible for developing Low Level Design document as per requirements.
- Conduct review meeting for Low Level Design document with team members and DBAs.
- Developing application programs in COBOL that reads Sequential or VSAM files in sequential order or randomly and read DB2 database tables for information using CURSORS or SELECT statements or update DB2 Database tables performing, INSERT/UPDATE/DELETE statements while checking for any exceptions and handling them in the program.
- Developing Mainframe ETLs using Cobol, JCL and Teradata utilities like MLOAD, FXPORT, FLOAD, BTEQ, TPUMP and TPT.
- Developing JCL cataloged procedures to execute programs, SYNCSORT utility, DB2/Teradata load and unload utilities, JCL utilities etc., using symbolic parameters and conditional codes.
- Developing Copybooks and Parmlib members for using in the programs and JCLs respectively.
- Design Teradata tables, views, Indexes etc.,
- Design tables and develop SQLs in DB2 and Teradata to extract and load data to Databases.
- Develop Job/ETLs using Teradata utilities like BTEQ, MLOAD, FASTLOAD, FASTXPORT to load or unload data, update history tables etc., against Teradata database.
- Developing test scripts based on business needs and conduction unit testing by automating/manual setting of the test scripts and verifying the test results in the database.
- Responsible for supporting system and integration testing.
- Responsible for preparing implementation plan and implementing the projects.
- Responsible for post production support.
Environment: TSO/ISPF, z/OS, UNIX, Panvalet, IBM DEBUGSQL Assistant, PL/Sql Developer, TOAD
Confidential
Analyst Programmer
Responsibilities:
- Responsible for developing Low Level Design document as per requirements.
- Conduct review meeting for Low Level Design document team members.
- Responsible for database table design and data flow diagram development.
- Developing application programs in COBOL that reads Sequential or VSAM files in sequential order or randomly and read DB2 database tables for information using CURSORS or SELECT statements or update DB2 Database tables performing, INSERT/UPDATE/DELETE statements while checking for any exceptions and handling them in the program.
- Developing JCL cataloged procedures to execute programs, SYNCSORT utility, DB2/Teradata load and unload utilities, JCL utilities etc., using symbolic parameters and conditional codes.
- Developing Copybooks and Parmlib members for using in the programs and JCLs respectively.
- Responsible for preparing the Unit and system test plans, test scenarios and test cases.
- Conducting unit and system testing and documenting the test results.
- Responsible for supporting the integration testing.
- Responsible for preparing implementation plan and implementing the projects.
- Responsible for post production support.
Environment: TSO/ISPF, z/OS, Endevor, Xpeditor.
Confidential
Analyst Programmer
Responsibilities:
- Responsible for designing the program specifications as per the requirements.
- Developing application programs in COBOL that reads Sequential or VSAM files in sequential order or randomly and read DB2 database tables for information using CURSORS or SELECT statements or update DB2 Database tables performing, INSERT/UPDATE/DELETE statements while checking for any exceptions and handling them in the program.
- Developing JCL cataloged procedures to execute programs, SYNCSORT utility, DB2/Teradata load and unload utilities, JCL utilities etc., using symbolic parameters and conditional codes.
- Developing Copybooks and Parmlib members for using in the programs and JCLs respectively.
- Responsible for preparing the unit test cases and documenting the test results.
- Responsible for supporting the integration testing.
- Responsible for supporting system testing.
Environment: TSO/ISPF, z/OS, Endeavor, Xpeditor.
Confidential
Team Leader
Responsibilities:
- Analysis of the existing systems to know their functionalities.
- Responsible for delivery of High-level design of the project.
- As the team leader making the team to work in analysis, designing, Specification preparation and UTP preparation.
- Responsible for the delivery of the project related documents at different phases and the development of the project.
- Responsible for supporting system testing.
- Responsible for management documents.
Environment: TSO/ISPF, OS/390, File Aid and Change man.
Confidential
Team Leader
Responsibilities:
- Analysis of the existing systems to know their functionalities.
- Responsible for delivery of Low-level design of the project.
- Implemented Classic Event Publisher to capture customer transaction and events.
- As the team leader making the team to work in analysis, designing, Specification preparation and UTP preparation.
- Responsible for the delivery of the project related documents at different phases and the development of the project.
- Worked as a guide for SQA sampling and Defect Prevention Champion.
Environment: TSO/ISPF, OS/390, XPEDITOR, FileAid, Changeman.
Confidential
Team Leader
Responsibilities:
- Analysis of the existing systems to know their functionalities.
- Responsible for delivery of High-level design of the project.
- As the team leader making the team to work in analysis, designing, Specification preparation and UTP preparation.
- Responsible for the delivery of the project related documents at different phases and the development of the project.
Environment: TSO/ISPF, OS/390, XPEDITOR, FileAid and Changeman.