SUMMARY

• Senior Technology Lead with around 10 years of experience in executing development, maintenance and production support projects in Mainframes environment
• Having 5 years of experience as Teradata Developer with strong expertise in TERADATA SQL and TERADATA utilities BTEQ, MLOAD, FastLoad, and TPUMP
• Experienced in leading teams
• Proficient in analyzing, designing, developing and deploying the systems
• Vast experience in working on various kinds of projects like Development, Maintenance, Production support, Migration, and Testing
• Strong understanding of Data warehousing and Business Intelligence concepts
• Good communication, interpersonal and managerial skills. Team player with positive attitude

TECHNICAL SKILLS

Database: DB2, TERADATA,IDMS, VSAM, DATACOM, IMS, ORACLE

Teradata Utilities: BTEQ, MLOAD, Fastload, TPUMP

Languages: COBOL, JCL

Front - End Applications: ADS/O, CICS

Operating Systems: MVS, OS/390, Z/OS

Query Language: SQL, PL/SQL

Change Control Tools: ENDEVOR, PANVALET, ELIPSE, REMEDY

Scheduling Tools: CA7, Control-M

Query Management Tools: SPUFI, SQL ASSISTANT, QMF, TOAD

Presentation and Documentation: Word, Excel, PowerPoint, Visio

PROFESSIONAL EXPERIENCE

Confidential, Bentonville, AR

Sr. Teradata Developer

Responsibilities:

• Preparing Technical Design Documents (High Level Design) and Program Specification Documents (Detailed Design)
• Design and code the nightly flows of History Corrections and HRDW to load data from Lawson DB2 tables to Teradata tables using utilities BTEQ, MLOAD and FastLoad
• Design and code the hourly flows of History Corrections to load data from Lawson DB2 tables to Teradata tables using utilities BTEQ, TPump and FastLoad
• Design and code the flow down logic (flow the corrections to the next effective dated records) for History Corrections using Teradata SQL and BTEQ
• Coding and scheduling JCLs to run the Teradata scripts and utilities
• Preparing Test Strategy, Test Plan and Test case documents and. Conducting smoke testing, functional testing, regression testing, interface testing and performance testing
• Facilitate System Integration Testing and User Acceptance Testing
• Participate in install activities like creating change request, preparing checklists, staging and production move
• Lead a team of 4 developers

Environment: TERADATA, Multi Load, FastLoad, BTEQ, TPUMP, SQL Assistant, JCL, Remedy, HPQC, CA7, Elipse, Z/OS

Confidential, Bentonville, AR

Sr. Teradata Developer

Responsibilities:

• Preparing Technical Design Documents (High Level Design) and Program Specification Documents (Detailed Design)
• Design and code the nightly flows of CPFR application to load data from JDA Oracle tables to Teradata tables using utilities BTEQ, MLOAD and FastLoad
• Design and code the hourly flows of Perishables application to load data from JDA Oracle tables to Teradata tables using utilities BTEQ, TPump and FastLoad
• Design and code the extracts from Teradata tables using Teradata SQL and BTEQ, to be sent to the Sales Reporting Dash Board for use by the Business users
• Coding and scheduling JCLs to run the Teradata scripts and utilities
• Preparing Test Strategy, Test Plan and Test case documents and. Conducting smoke testing, functional testing, regression testing, interface testing and performance testing
• Facilitate System Integration Testing and User Acceptance Testing
• Participate in install activities like creating change request, preparing checklists, staging and production move
• Lead a team of 4 developers

Environment: TERADATA, Multi Load, FastLoad, BTEQ, TPUMP, SQL Assistant, JCL, Data stage, Remedy, HPQC, CA7, Elipse, Z/OS

Confidential, Bentonville, AR

Teradata Developer

Responsibilities:

• Conducting Impact Analysis and preparing estimates using SMC methodology
• Preparing Technical Design Documents (High Level Design) and Program Specification Documents (Detailed Design)
• Making code changes to COBOL and CICS programs by converting IMS calls to DB2 calls and other necessary changes
• Writing Teradata SQL and Load scripts (TPUMP, MLoad, FastLoad, BTEQ) to load the extracts of DB2 tables into Data warehousing (Teradata) tables
• Regression Testing to make sure that the existing functionality is not impacted
• Performance Testing to make sure that the performance is not impacted
• Participating in install activities like Creating change request, preparing checklists, staging, production move

Environment: COBOL, JCL, DB2, TERADATA, TPUMP, MLoad, FastLoad, BTEQ, IMS, CICS, Elipse, QMF, QueryMan, CA7, Z/OS

Confidential, Glenview, IL

Teradata Developer

Responsibilities:

• Preparing Technical Design Documents (High Level Design) and Program Specification Documents (Detailed Design)
• Design and code the batch jobs and Teradata SQL scripts to unload and format data from DB2 Daily sales tables
• Design and code batch jobs and scripts to load data into Teradata tables using BTEQ, MLoad and TPump
• Scheduling JCLs to run the Teradata scripts and utilities
• Preparing Test Strategy, Test Plan and Test case documents
• Support Business Objects development team in design and generate the daily sales reports
• Facilitate User Acceptance Testing
• Participate in install activities like creating change request, preparing checklists, staging and production move

Environment: TERADATA, Multi Load, BTEQ, TPUMP, SQL Assistant, JCL, Business Objects, Remedy, HPQC, CA7, Elipse, Z/OS

Confidential, Glenview, IL

Mainframe Lead

Responsibilities:

• Provide 24x7 support for Sales Incentive system that comprise of CICS screens, Cobol-DB2 batch jobs, Crystal Reports
• Service minor enhancements, major enhancements and other maintenance requests from users on ad-hoc basis
• Participate in complete SDLC stages for the Quarterly and Annual payout requirements that change every 6 months
• Process the quarterly, semi-annual and annual payout process for all eligible employees
• Lead a team of 4 developers

Environment: COBOL, JCL, DB2, CICS, VSAM, Endevor, QMF, Control-M

Confidential, Brisbane, CA

QA tester

Responsibilities:

• Test data setup and environment setup/validation
• Test scenario creation and validation
• Test case creation and execution
• Coordinate with functional experts and RETEK support team
• Status Reporting

Environment: RETEK, SQL

Confidential, Omaha, NE

Sr. Mainframe Developer

Responsibilities:

• Provide 24x7 support for Railcar and Demurrage system that comprise of CICS screens, ADS/O screens, Cobol-DB2-IDMS batch jobs
• Service minor enhancements, major enhancements and other maintenance requests from users on ad-hoc basis
• Deliver Major Enhancements by conducting Requirements Analysis, Design, Coding, Unit Testing, and Implementation activities.

Environment: IDMS, ADSO, DB2, COBOL, JCL, OS/390

Confidential, Topeka, KS

Mainframe Developer

Responsibilities:

• Preparing high level and detailed level design documents for coding new COBOL and Datacom programs to extract data from Datacom tables into flat files to be loaded into DB2 tables
• Preparing test plan and test cases
• Coding and testing JCLs and Cobol-Datacom programs
• Coding and testing the JCLs to run load utilities to load data from flat files into DB2 tables
• Facilitate System Testing for the entire allocation system
• Implementation and Warranty support

Environment: COBOL, DATACOM, DB2, JCL, VSAM, CA7, OS/390

Confidential, Omaha, NE

Mainframe Developer

Responsibilities:

• Provide production support for Invoice and Order Management System that comprise of CICS screens, ADS/O screens, Cobol-DB2-IDMS batch jobs
• Service maintenance requests (minor enhancements) from users on ad-hoc basis
• Deliver Major Enhancements by conducting Requirements Analysis, Design, Coding, Unit Testing, and Implementation activities.

Environment: COBOL, JCL, IDMS, ADS/O, CICS, DB2, VSAM, OS/390