SUMMARY

• Accomplished software engineer with 11 plus years of experience in Information Technology with complete SDLC exposure and expertise in requirement analysis, application design, development, reviews and testing
• Proficient technical lead, having successfully managed teams in onshore and offshore
• Experience in Design and architecture review
• Hands on experience in COBOL, DB2, JCL and VSAM
• Experience in z/OS utilities and scripting languages like REXX.
• Solid knowledge in DB2 Structured Query Language (SQL).
• Proficient in creating, monitoring and performance tuning of COBOL - DB2 programs and jobs.
• Good experience with logical data models, schemas and physical database design and development.
• Vast experience in designing database objects like tables, views, stored procedures, indexes, cursors and queries and in managing user permissions and grants.
• Expert in extracting, transforming and loading data into various databases.
• Experience in RCA (Root Cause Analysis) for production issues and resolving data issues
• Excellent team player with good communication, problem solving and interpersonal skills.

TECHNICAL SKILLS

Programming Technologies: COBOL, JCL, CICS Web Services, REXX and Assembler, Z/OS DFSORT

Database Management System: DB2

Operating Systems: Z/OS, Windows

Tools: Used File Aid, TWS, TOM, Omegamon, DB2 File Aid, Smart Test, Intertest, FTP, NDM, SPUFI, QMF, Fault Analyzer, INFO/X, IBM OnDemand Report, IBM Rational Application Developer for system Z

Version Control: Change Man

Domain Knowledge: Banking and Financial services, Confidential ApplicationsTelecommunications

PROFESSIONAL EXPERIENCE

Confidential, New York

COBOL DB2 Technical Lead

Responsibilities:

• Onshore technical lead, responsible for functioning of the existing application
• Understanding of the requirements and analysis to come up with the most efficient solution to the problem
• Analyze new business requirements and create high level and low-level design documents for the proposed solutions
• Evaluate new and existing strategies along with operational metrics and recommend optimal solutions
• Identifying the number of components and type of components to be developed
• Working with QA in identifying test cases/scenarios and creating the test plan
• Development/Coding of the components and reviewing them for consistency with the requirements and coding standards
• Designed and coded components in an Agile environment utilizing a test-driven development approach
• Creating Test Plans in accordance with Testing Scope, Methodology, and Business requirements
• Day to Day Interaction with business stakeholders and clients
• Decommission job streams and migrated modules
• Coordinate with offshore development team(s) to identify priorities and update scope and delivery schedule.
• Perform optimization of DB2 Jobs and Stored Procedures by optimizing queries
• Working with infrastructure teams regarding mainframe system upgrades and executing test scenarios post implementation
• Addressing Batch Job abends, incidents and any interruption of system services to Business users
• Implementation Support and post-production support

Confidential, New York

Architect / COBOL-DB2 Developer

Responsibilities:

• Onshore technical lead, responsible for quality delivery of solutions.
• Participated in architecture discussion with clients and was involved in finalizing the application design.
• Analyzed the Existing system and Developed a Design for the new product
• Create prototypes as per the design and present to the client.
• Perform optimization of DB2 Jobs and Stored Procedures by optimizing queries.
• Requirements gathering and feasibility analysis along with System Analysis and Design of the existing system.
• Proposed new solutions to clients for improvement of system performance
• Involved in preparation of effort estimation for regular project tasks
• Defining responsibilities and reviewing deliverables
• Co-ordinated with all external teams - infrastructure team, DBAs, scheduling team, network team, to support daily tasks and operations
• Documentation of requirement solution
• Created and modified COBOL, DB2, CICS, JCL, VSAM, PROCs programs/jobs to align with User requirements
• Effort estimation for monthly releases and Change the Bank projects.
• Lead Developer on the major releases for the Wealth Management Joint venture. Developed over 60 batch DB2 programs and 25 CICS/DB2 programs
• Document existing legacy REXX and Assembler programs to convert to COBOL.
• Developed COBOL stored procedures and CICS Batch Programs to enable the UI screens from backend
• Preparation of Unit test Cases, review code and Unit test plan from both Onshore and Offshore team
• Perform Unit/System/Regression testing
• Lead Technical Developer and SME for CICS Web Services for the Confidential Area. Task includes creating WSDL from the scratch based on User Requirements and merging it with COBOL program.
• Trouble shooting of the entire application based on JIRA tickets
• Monitoring the software implementation to production environment
• Provide Post implementation support, enabling end to end support starting from Dev to Production support
• Contributed to the Value-Add proposals for Process Improvements
• Mentored team and brought them up to a higher level of proficiency with respect to system understanding and day to day operations
• Monitoring/Ensuring Client satisfaction through quality and timely deliverables

Confidential

COBOL-DB2 Developer

Responsibilities:

• Requirement Gathering and Analysis
• Preparing High Level Design document (HLD) and Low-Level Design document (LLD)
• Preparing Test Scripts for all the newly converted programs
• Worked extensively on COBOL and DB2 scripts
• Perform various testing i.e. Unit Testing, System Integration Testing and User Acceptance Testing
• Validating test data after each level of testing
• Receiving client sign off for deployment after client verification of test results
• Created numerous reports interfacing with OnDemand Application and E-Mail alerts to Users
• Onsite Offshore Coordination