SUMMARY:

• Around 12 years of experience in IT with specialization in analyzing System Functionality, Conceptualization, Design and Implementation of Teradata/Mainframe Technologies.
• Have Extensive experience in Requirements gathering from Business, Design, Development, testing, Support Integration testing, Preparing Implementation strategies for production readyness.
• Expertise in writing complex SQL queries for the data for reporting/Analytics purpose.
• Expertise in TERADTA Utilities like BTEQ,TPUMP, FASTLOAD, MLOAD, FASTEXPORT
• Excellent understanding of the fundamentals of Teradata/ETL and Mainframe.
• Excellent knowledge and hands on experience in software development life - cycle quality assurance processes and testing methodologies processes.
• Experienced in developing applications using VisionPLUS, AdvantaGEN and CoolGEN
• Experience in handling Data Integrations/Data Warehouse application with mulitple sources and various interfaces.
• Good experience in Migration and Upgrade projects
• Excellent knowledge in Application design, Database design, preparation of Solution design documents from BRI, conducting SRS review meetings with Business, Development and testing teams.
• Good knowledge on Retail Confidential, Credit Card Systems, Banking, Auto and Life Insurance Applications.
• Experience in Using tools like SQL Assistant, LIbrarian,Changeman INTERTEST, EXPEDITOR, FILE-AID, QMF, SPUFI,CA-7, Remedy, Quality center.
• Expertise in preparing in Test Plans and Test Cases.
• Experience in Analyzing Defects and interacting with development team & Business to resolve issues.
• Extensive experience with Teradata and DB2 systems with the ability to write complex database queries.
• Team leading experience, work allocation, review the deliverables, delivery of the tasks ahead of dead lines, Offshore and Onsite Coordination .

TECHNICAL SKILLS:

• Teradata
• Teradata SQL Assistant
• HADOOP
• Datastage
• UNIX
• COBOL
• JCL
• DB2
• VSAM
• Librarian
• Changeman and Gaurdian
• INTERTEST
• EXPEDITOR
• ENDEVOR
• FILE - AID
• QMF
• SPUFI
• TSO
• ISPF
• BMCDB2
• APPTUNE
• CICS
• CA-7
• Control-M
• VisionPLUS
• AdvantaGEN
• CoolGEN/CAGEN
• Remedy
• JIRA.

PROFESSIONAL EXPERIENCE:

Confidential, Bentonville,AR

Sr Application Developer and Teradata LEAD

Environment: UNIX, Teradata, COBOL, JCL, VSAM, DB2, HADOOP, Greeplum and Datastage

Roles & Responsibilities:

• Interacting with Business for clarification on requirements & information and driving requirement meetings with Business, Development and Testing team
• Detailed analysis and verification of preliminary system design and business requirements
• Developing system design documents
• Develop the Scripts/Reviews for the Teradata Utilities like BTEQ,MLOAD,TPUMP,FASTLOAD and FASTEXPORT
• Writing complex SQL queries joining multiple tables.
• Supporting all kinds of testing
• System enhancements, Preparation of Implementation strategy documents and Job Scheduling
• Provide Production support on Mainframe, HADOOP and Datastage abends / issues
• For New development / Support enhancement / Fixes - Gather requirements from client / customer and providing estimations & work with IBM team on meeting the estimated completion dates.
• Work with DBA, Datastage / Production Control / Control Room / Mainframe Operations / Unix Operations / Development Services teams on Teradata, Datastage, CA7 System Outage / Upgrade Preparation, Coordination, Back out plans, Monitoring, Fixing and Reporting
• Provide Business Value Add by developing Automation tools/scripts which saves $$$ and time.

Confidential, Bloomington, IL

Sr Application Developer, Lead

Environment: COBOL, JCL, VSAM, DB2,MQ Series, CICS and IMS-DB

Roles & Responsibilities:

• Overseeing activities related to project deliveries, Business Analyst communication and status update communications to top level management.
• Handling all phases of the project starting from Initiation to the Project Closure.
• Analyzing the requirements and involving effort estimations meeting with BAs.
• Creating high level design documents.
• Creating technical specifications.
• Analyze various project requirements and transferring the knowledge to offshore team.
• Developing COBOL/DB2 programs, Creating test and production JCLs.
• Conducting code walkthroughs on deliverables along with client and offshore team.
• Preparing status reports on weekly basis
• Worked with TRAC tool to track the defects and update the information regarding the defect.
• Involved on System testing for Auto batch cycle.

Confidential

Consultant

Environment: COBOL, JCL, VSAM and DB2

Roles & Responsibilities:

• Gathering the requirements by directly interacting with the Client and estimating the effort required for each task
• Participating in design discussions and making design decisions
• Creating high level design documents
• Clarifying the issues of the team member and helping them in the proper execution of the project
• Receiving and recording all customer feedback and ensuring timely corrective action
• Identifying and developing the reusable modules and templates, this will help in improving the productivity of the team
• Developing COBOL/VSAM programs and Creating test and production JCLs
• Independently analyze and resolve large, complex, high-risk, production problems, assessing alternatives as appropriate and implementing long-term solutions.
• Produce appropriate documentation and notifications for changes to production systems or fixes to production problems. Notifications include team members, production control and affected business units

Private Label systems (PLS) - Citi Cards USA

Confidential

Developer

Environment: COBOL, JCL, VSAM, CICS,DB2 and CA-Easytrieve

Roles & Responsibilities:

• Understanding the Functional and Technical design Document
• Estimation for project requirements
• Preparing the low level design documents
• Developed the source Code to satisfy the LLDD
• Preforming the Unit testing
• Preparing the Handover documents
• Conduct post-implementation reviews, generate problem reports, and provide appropriate feedback concerning production implementation efforts.

Confidential

Consultant

Environment: COBOL, JCL, VSAM, CICS and DB2.

Roles & Responsibilities:

• Leads a team of eight and act as single point contact between clients and team
• Preparation of Weekly & monthly metrics
• Analyzing the Requirements obtained from the Altec and Estimating the time required to in corporate the requirement in the system.
• Implementing the required changes in the System and Testing whether the incorporated changes satisfy the new requirements and do not hamper the existing functionality.
• Reviewing the code changes, preparing the Test Plan to describe the scenario for Testing Requirements and preparing the Test Results Documents for Verification of the code changes.
• Performing Process Related Activities to conform to CMM, PCMM and IQMS Standards and ensure the quality of the Deliverables from TCS

Confidential, Columbus, OH

Consultant

Roles & Responsibilities:

• Collect basic application inventory
• Validate Inventory to create the road map
• Carry out high level analysis
• Identify opportunities and Provide opportunities & recommendations to simplify, rationalize, and optimize the applications/application areas.
• Identify Interfaces
• Create Interface Solution Context Diagram
• Create System Context Diagram
• Create the Governance Process for new application

Confidential, Pasadena,CA

Application Developer

Environment: COBOL, JCL,DB2

Roles & Responsibilities:

• Analyzing the Requirements obtained from the client and Estimating the time required to in corporate the requirement in the system.
• Preparing the Initial Analysis Documents stating the code changes and the location of the Code Changes.
• Implementing the required changes in the System with COOL: Gen and Testing whether the incorporated changes satisfy the new requirements and do not hamper the existing functionality.
• Providing comprehensive version control, model management and configuration management using the tool Guardian
• Reviewing the code changes for foreign modules, in the team, as part of the internal processes followed.
• Specifying to Onsite, the objects that should be moved to the Integrated Testing region after Peer Review is done at Offshore and maintaining the version control for the changes with Change Man.

Confidential

Application Developer

Environment: COBOL, JCL, VSAM, CICS,DB2

Roles & Responsibilities:

• Preparing the converting programs using CCCA Tool
• Conducted Code Reviews & Unit Testing
• Preparing Prod &Test JCL’s
• Preparing TCF’s, Release Documents, Inventory Docs

Confidential

Application Developer

Environment: COBOL, JCL, VSAM, CICS,DB2

Roles & Responsibilities:

• Involved in Whole Development Cycle.
• Analyze the service requests.
• Fulfilling the request coding.
• Preparing test-cases
• Unit Testing