SUMMARY:

• 8+ years of software experience in Evaluation, Data Modelling & Design, Development, Testing, Deployment and Production support using Teradata, Mainframe & Linux Technology
• Teradata - 12 Certified Professional with a good experience on leading Design, Development, Enhancement & Maintenance projects
• Played a lead role in all phases of a migration project - From Teradata-Mainframe platform to Linux-Vertica platform: Analysis, Data Modeling & Design, Environment setup, Co-ordinate the Build and Testing activities, Implementation activities, Production validation etc.
• IBM Infosphere Datastage 8.5 certified professional with exposure to ETL tasks involving datastage
• Technically proficient, Customer dedicated, IBM DB2 Certified Software professional with remarkable experience in Mainframe development & Maintenance projects built with COBOL, JCL, DB2 & IBM Tools
• Strong organizational & presentation skills with excellent analytical & problem solving proficiency
• Experienced as Senior Mainframe Developer/Analyst & Project Lead. Have hands on experience in Onsite-Offshore model projects.
• Databases: Very good experience on Teradata, DB2, Vertica SQLs, Cursors and Store procedures. Strong experience on IBM DB2 & Teradata utilities.
• Data Analysis: Excellent experience in Data Analysis. Good in understanding the business requirements and developing analysis documents & specifications for the business requirements
• Data Modeling & Design: Good experience in Conceptual & Logical Data Modelling, Creating data mapping documents, writing functional requirements & queries
• Development: Proficient and experience on developing and changing Teradata, COBOL, DB2 modules programming. Very good experience on developing and changing JCLs and Procs. Strong experience on developing and changing SQLs, Cursors, Stored procedures, Remote Procedure Calls, VSQLs, unix scripts
• Tools: Strong Experience in tools like Endevor, Changeman, File-Aid, File manager, QMF/SPUFI, Autosys, SQL Workbench, Toad
• QC/defect management tools: Good experience on QC/defect management using tools like IPMS defect tracker tool - tracking defects to successful closure and maintain documentation.
• Created Project Metrics Reporting documents, involved in scheduling and tracking Audit, handled Project Management Reviews.
• Identify and make recommendations to clients for application and capacity planning, reduction of processing costs through automation and operational improvements.
• Worked in Projects using Waterfall and Agile model.

TECHNICAL SKILLS:

OS: IBM, OS/390, z/OS, Windows, Unix/Linux

Languages & S/W: SQL, JCL, COBOL, CICS, Unix/Linux

Databases: Teradata, Vertica, DB2, VSAM

Tools: TSO, ISPF, FILE-AID, File Manager, DFSORT, SAR, SPUFI, QMF, CA-7, SQL-ASSISTANT, SQL Workbench, Toad, Teradata Utilities, IBM mainframe utilities and tools, Autosys, NDM, FTP/SFTP, RPCs

Documentation Tools: MS-Office, MS Visio, SharePoint, Discovery

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Project Lead

Responsibilities:

• Working as a Senior Analyst leading a team of 6 members in meeting the project goal
• Playing a remarkable role in all phases of a Consolidation & Migration of Mainframe-Teradata applications to Linux-Vertica platform
• System analysis of the legacy applications to understand and document the functionalities, data model, data flow etc.
• Part of data modeling team where about 4500 tables of legacy applications (C&RA and CDM) are consolidated to create an effective database model for new application eliminating the duplicity of data & redundant tables
• Prepare design documents & steps necessary for migrating platform, direct sourcing from System of Records, Environment needs, Data base object requirements etc.
• Drive the build and testing activities with offshore team
• Preparation of test plans & scripts for Unit testing & User Acceptance testing
• Coordinate with supporting teams like Infrastructure, DBAs, Architects, Lower environment team, Enterprise Data Management, Program Management, Production Support etc.
• Production deployment activities & post implementation support
• Driving design discussions, code walkthrough, test results validations, prod-parallel data comparison discussions and acquiring required sign-offs
• Prod parallel data validations and comparison with legacy application, implementing fixes and attain Certification for the new application

Environment: Teradata, Vertica, JCL, VSQL, DB2, SQL Assistant, SQL Workbench, Autosys, Toad, File-Aid, Linux, SPUFI, MVS, OS/390, Mainframe Service Oriented Architecture (SOA)

Confidential, Charlotte, NC

Production Support Lead

Responsibilities:

• Worked as a Senior Programmer/Developer leading a team of 4 members in meeting the project objectives and manage day-to-day activities.
• Enhancements to the existing functionalities to integrate with the applications and thereby providing more scope for the application
• Preventive & Adaptive maintenance to adapt and integrate with the new enhancements
• Analysis of client supplied documents, Prepare program flow & Business Change documents
• Preparation of test plans & scripts for Unit testing & User Acceptance testing, Co-ordinate for test environment setup
• Code & Test results review
• Co-ordinate with Users, Architects, Change control board members & Clients about the Changes, Results, Performance, Install procedure & dates
• Production Implementation, Deployment & Post Implementation support
• Business As Usual production monitoring
• Data Quality checks for critical processes to ensure correctness of data that is provided to the down streams
• Creating Daily, Weekly & Monthly reports like User Specific Reports, Status Reports, Governance Deck, Score card etc.
• Participated & coordinated Disaster Recovery Testing

Environment: Teradata, JCL, SQL Assistant, SQL Workbench, Changeman, File-Aid, SPUFI, MVS, OS/390, Mainframe Service Oriented Architecture (SOA), UNIX, Autosys, Infosphere Datastage Windows XP

Confidential, Hopewell, NJ

Programmer Analyst

Responsibilities:

• Module Lead for a team of 4 members and acted as a Backup-Lead
• Analyze the requirement specification document from the client
• Conducting Impact Analysis and Program Analysis for the client requests
• Coding the COBOL-DB2 programs, JCLs & PROCS
• Unit & Integration testing of programs
• Preparing & testing of new RPC's using Neon shadow direct calls
• Maintenance and Enhancement of the PMR system
• Onshore / Offshore co-ordination
• Reviews and Code Walkthrough of the developed components
• Tracking of Enhancements requests
• Project planning /tracking of request with an in-house tool

Environment: COBOL, JCL, VSAM, DB2, CICS, RPC, Endevor, File Aid, SPUFI, SORT,PLATINUM, ICETOOL, Neon Shadow runner

Confidential, Hopewell, NJ

Team Member

Responsibilities:

• Production Support
• Conducting Impact Analysis and Program Analysis for the client requests.
• Coding and Testing
• Maintenance and Enhancement
• Tracking of Enhancements requests

Environment: COBOL, JCL, VSAM, DB2, CICS, Intertest, Endevor, File Aid, SPUFI, SORT,QMF,PLATINUM