SUMMARY

• Over 11+ years of experience in Software Design, Development, testing, Implementation and production support using Teradata and Mainframe Technologies.
• Extensive experience in the area of Banking - Customer Relationship and Application Systems -- Analyzing Business Requirements, Design, Coding and Testing and production support for Confidential and Financial Business in Confidential and wireless Telecommunication business areas in Confidential .
• Worked on major Confidential Merger & Acquisition - Northwest, US Trust, GWIM, LaSalle, Countrywide and Merrill lynch conversions in Customer Information Systems
• Experience working in all the stages of SDLC - requirements gathering, analysis, design, architecture, development, integration, implementation, administration, enhancement, testing, production support, user interaction and Project management activities.
• Worked and part of implementation of migrating the Customer Relationship and Application(C&RA and CDM) data from Teradata platform to MAP - Map Analytic Platform (Vertica (real time data) - Hadoop(Archive and Historical data)) . ETL process are used to get the data from Source systems to Landing Zone. From there to load database
• Worked and part of the WCC and MDM upgrades in Confidential - Customer Information Systems
• Experience in working with agile methodology.
• Experience in Database Performance Tuning and Query optimization.
• Worked on automation and re-engineering ideas by reducing CPU usage, which helps in Cost Savings for the Customer.
• Experience in writing SQL, DB2 and Stored Procedure queries.
• Ability to work in a Team/Manage and Positive orientation to expand present knowledge base, active team player with positive and forward looking attitude.
• Good debugging skills and interpersonal skills with Strong analytical skills and ability to code test and debug.
• Ability to learn new technologies as project demands
• Good in communication and written skills.
• Always been successful in completing the projects on time while meeting strict timelines and requirements. This has enabled me in establishing strategic relationships with key clients and prospects.

TECHNICAL SKILLS

TECHNOLOGIES: COBOL,CICS, JCL, Eztrieve, Salesforce UNIX Shell Scripting and SAS

Operating System: OS/390, Z/OS, WINDOWS 95/98/NT/XP, UNIX

DATABASE: Teradata, DB2, SQL, Hadoop

Tools: / Utilities Teradata - Mload, Tpump, Fastload, BTEQ Utilities,WCC, TSO/ISPF, QMF, SQL, VSAM, FILE AID, File-Manager, QMF, CHANGEMAN, IEBCOPY, EZTRIEVE, SPUFI, ENDEAVOR, CA7, NDM, FTP, SPUFI, DFSORT, ICETOOL, XPEDITER, ABENDAID, SAR, REXX

PROFESSIONAL EXPERIENCE

Confidential, NC

Senior Developer

Responsibilities:

• Identify the foundational data similar in both applications
• Identify the redundant functions between C&RA and CDM applications
• Build the VAPS ( Value added processes) in the Target stage, Which is CRH - Customer Relationship hub
• Build robust disaster recovery platform in the Target stage.
• Real time Analytics can be done in the Vertica platform and Archive/History data will be stored in to Hadoop platform
• Design - Documentation of system design and detailed design documents to introduce new functionality.
• Coordination
• Coordinating with other to team members to meet the SLAs.
• Identified the pain points in the current process in the existing flow and suggested the strategic approach towards optimization.
• Build the connection with the Source Systems directly and get the input data directly to strategic landing zone to reduce the dependency.
• Involved in production implementation and post production work.
• Create a robust foundational layer with the customer and account foundational data first, so that value added process can be built on top of it.

Environment: Teradata, TSO/ISPF, COBOL, JCL, CA7.

Confidential, Charlotte, NC

Senior Developer

Responsibilities:

• Requirement Analysis - Understanding the functionality and doing analysis to implement.
• Design - Documentation of system design and detailed design documents to introduce new functionality.
• Proposed and Designed Daily delta and SLA's to the downstream applications and reporting process.
• Coordinating with other to team members to meet the SLAs.
• Identified the pain points in the current process in the existing flow and suggested the optimization.
• Coordinated, executed and certified the entire SDLC phase of the entire project.
• Involved in production implementation and post production work.

Environment: Teradata, TSO/ISPF, COBOL, JCL, CA7

Confidential, Charlotte, NC

Senior Developer

Responsibilities:

• Represent Confidential CRA in the Transition workgroup and technical meetings
• Involved in interaction with other applications during the integration testing
• Prepared the document of the application with job flow charts
• Coordination with co-workers, technical support, and business users
• Tracking and Monitoring the Test issues, identifying scope constraints if any and coordinating with the work group for the change controls, if required
• Preparation of Unit, System and integration test cases
• Involved in execution of Unit and Integration test plans
• Involved in Production implementation and production support activities.

Environment: Teradata, TSO/ISPF, SDSF, COBOL,JCL, SQL, Z/OS, MS Office, CA7.

Confidential, Charlotte, NC

Senior Developer

Responsibilities:

• Involved in interaction with other applications during the integration testing
• Prepared the document of the application with job flow charts
• Coordination with co-workers, technical support, and business users
• Tracking and Monitoring the Test issues, identifying scope constraints if any and coordinating with the work group for the change controls, if required
• Preparation of Unit, System and integration test cases
• Involved in execution of Unit and Integration test plans
• Involved in Table creations in Teradata database
• Involved in Created the Test and production JCL’s
• Involved in Job schedule in CA7
• Involved the production implementation and post production support.

Environment: Teradata, TSO/ISPF, SDSF, COBOL,JCL, SQL, Z/OS, MS Office, CA7.

Confidential, Charlotte, NC

Application Developer

Responsibilities:

• Program Conversion from Cobol to UNIX sysyem
• Coded 25 shell scripting programs.
• Prepared the Job Scheduler on Tivoli Job Scheduling Console
• Responsible to manage Unit testing and Integration testing
• Responsible in Onsite Offshore project co-ordination.
• Responsible for Release co-ordination and management
• Involved in production implementation and production support activities.

Environment: TSO/ISPF, SDSF, COBOL, JCL, Teradata UNIX and Tivoli Job Scheduling Console

Confidential, Irving, TX

Application Developer

Responsibilities:

• Quality center is used for the Specifying the testing requirements, Planning tests, Running tests, Defect tracking, Logging Defects, Tracing changes and Analyzing the Testing process.
• Critical jobs statistics tool, ACS tracker tool, GDG Tool, DD Name Vs File name and developed back end JCL’s and COBOL programs.
• All the back end modules involve Database interaction like creating the table, Inserting the data and retrieving the data
• Key point of contact to end users and developers
• Responsible to manage UAT (OPC Scheduler activities like Monitoring batch schedules, fixing the abends, escalations, adding new jobs, handling holds), Regression and Parallel testing on rumba system
• Acted as a Defect preventive prime
• Developed and implemented the Compare Process, regression SCRUB process
• Involved in the preparation of regression design document, analysis of miss compares and responsible to circulate the same to developers to fix the issues
• Performance tuning
• Used Strobe tool to identify the time consuming statements in JCL/COBOL/DB2 and provided the solutions to save the CPU time

Environment: TSO/ISPF, SDSF, COBOL, JCL, DB2, EasyTrieve, Remedy, CICS, SQL, SPUFI, VSAM, Z/OS, MS Office, File-Aid, REXX

Confidential, Seattle,WA

Application Developer

Responsibilities:

• Involved in interaction with other applications
• Involved in Table creation
• Responsible in Design, programming and Testing.
• Responsible in Production support activities.

Environment: MF COBOL, IBM COBOL, VSAM, DB2, SQL, File Aid, Endeavor