SUMMARY

• 18+ Years of Experience on Z/OS - IBM Mainframe DB2 Developer in Banking, Finance, Insurance (BSFI), Retail domain.
• Specific technical Knowledge in Mainframe technologies i.e. Z/OS, COBOL, JCL, DB2, VSAM, MVS, TSO/ISPF, CICS, and Easytrieve, SAS.
• Extensive hands-on experience on Systematics applications like GN, IMPACS, RM and ST.
• Extensively working on tools like SCM, CMS, Panvalet. ChangeMan, Endevor, INSYNC, Intertest, DB2 Connect, Jira, Wiki, BMC Remedy, Service Now, SPUFI, QMF, CA7,Toad-Oracle, Microsoft SQL Server, Main view, Abend-Aid, File-Aid, File Manager.
• Extensive knowledge & experience in Microsoft Technologies- Microsoft SQL Server, SSIS &SSRS
• Install/Customize DB2 QMF IMS software NEW releases - DB2 V9, V10, V11 & IMS V13 Omegamon DB2 upgrading QMF V10
• Coordinated physical changes to DB2 database objects are including; coding, testing, database and production migration and performance tuning, participated in the full life cycle implementation plan including designing, building, configuration, testing, and implementation. Participated in Confidential ’s SOA (Service Oriented Architecture).
• Implemented new applications such as, real-time processing of customer on-line transactions, ETL branch business process, was the new architecture for business process management based on SOA.
• Solid working experience in designing and implementing backup/recovery solutions, setting up and managing high availability and disaster recovery solutions and developing and managing reports using Microsoft SQL Server Reporting Services (SSRS).
• Working experience on Performance Tuning, creating and tuning Stored Procedures, Triggers, Functions, Constraints and Views.
• Strong business and technical vision with effective people skills. Innovative and creative problem solver, results oriented, and has high aptitude for learning new technologies.
• Installation and configuration of Microsoft SQL Server 2008/2008R 2/2012/2014/2016 during new projects, upgrade/migration and expansion.
• Experienced in application development from initial requirements gathering, systems design, specification, and documentation, deployment, and training
• Working Experience in T - SQL Programming, tuning SQL queries and creating different database objects.

PROFESSIONAL EXPERIENCE

Sr. Programmer Analyst

Confidential, San Antonio, TX

Responsibilities:

• Provides software development and support for the company's business solutions within a defined Software Development Lifecycle.
• Develop, test, implement and maintain application software working with established processes.
• Analyze the Functional Requirement Specifications FRS and Additional Design Specifications ADS with business Stake holder.
• Creating and providing the Legacy modernization solution architect plan
• Prepare and represent the Technical Design document in order to get approval from Customer.
• Develop/Reviewing the Integration design of the project.
• Analyze/Review the complete architecture of the application.
• Acting as a SME for the application.
• Involve in Project planning, Reports and representation at meetings.
• Monitoring and fixing the CICS transaction with OMEGAMON tool.
• Working on performance tuning on DB2 stored procedure and Mainframe jobs.
• Design New Components using COBOL and DB2 Database design Concepts.
• Perform/Review unit testing for batch and online programs using DB2 load/Unload utility
• Review the Test result for Stored Procedure using EzProc.
• Schedule and set up in conditions/Out conditions in job using Control M.
• Responsible for Project Planning and prioritizing the tasks.
• Providing the daily status updates in scrum meeting.

Associate Manager

Confidential, Dallas, TX

Responsibilities:

• Application development, maintenance activities involved in Mainframe Platform migration. Requirements Analysis, Design, Coding, Reviews, Unit testing. Deployments in various regions(UNIT, INTG, PROD). Support to Migration activities, Integration Testing. Support User Acceptance Testing, Production Implementation activities, Warranty support.
• Problem solving, root cause analysis, and issue resolution. Adhere to Software Development Life Cycle Standards (SDLCS) and applicable Data and Technology Services Policies and Standards.
• Update/change programs in CM(ChangeMan) package.
• Analyze COBOL/DB2/JCL programs and resolve technical issues. Multi-task and work on multiple projects concurrently.
• Involved in Design, Coding, Report generation and Unit Testing.
• Time to time Interaction with the SMEs( Subject Matter Experts) on work.
• Impact Analysis of Programs, Tables and Copybooks.
• Attending client calls and communicating the updates and sending the status to the client.
• Creating the Checklists and other Process documents and maintains the same.
• Coordinating with deployment team.
• Worked with other team leads and lead our team in all stages of deployment process.
• Partnered with different team members to resolve issues through constant communication.
• Preparing technical documentation such as system architecture, functional, design documents on conversion project and enhancements.
• Contacted customer representatives on a daily basis to resolve tickets and work on enhancements for existing applications.

Development Supervisor

Confidential, Detroit, MI

Responsibilities:

• Migrated Databasesfrom other databases like Oracle 10g & DB 2 to Microsoft SQL Server 2008.
• SQL development: write and troubleshoot SQL code and design (SPs, functions, tables, views, triggers, indexes, constraints).
• Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.
• Creating and managing database resources, providing administration of database security including the monitoring and maintenance of user access.
• Monitoring, migrating, backup, recovery and tuning of SQL Server databases in a multi-platform environment.
• Utilize and analyze SQL Server Profiler to tune SQL Server 2008r2 databases.
• Detect and troubleshoot SQL server related CPU / memory, I/O, disc space and other resource contention.
• Design and implement relational databases to support complex database systems and applications.
• Create documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices Data Analyst.

Sr. Software Engineer

Confidential

Responsibilities:

• Creating, maintaining, and supporting COBOL applications alongside a team of industry leading COBOL developers. Use DB2 to support applications RDBMS requirements. Production support.
• Communicate with clients & support end users. Perform cost benefit and feasibility analyses related to the modification of existing computer-based information system in COBOL/DB2.
• The maintenance and support of information system of COBOL/DB2 application programs, the implementation of new system in IBM Mainframe TSO/ISPF environment. Work on utility EZTRIEVE, IDCAM, ENDEVOR, EXPEDITOR.
• Assisted EDI programmer integrating data to user interface inhouse Alpha-Omega System in COBOL and compliant mapping. Matching transaction acknowledgements to the original documents.
• Tuned up and improved the performance of Alpha Omega System (MicroFocus COBOL). Resolved problems and developed new solutions for specific in house applications in COBOL/DB2.

Programmer/ Developer

Confidential

Responsibilities:

• Actively involved with the team of developers in knowledge transfer, functionality issues, database issues, best coding practices and standards.
• Analyzing, coding, testing, documenting and implementing tax application enhancements in IBM Mainframe and AS/400 environments.
• Development/maintenance of CICS/COBOL/DB2/SQL, CL, OS/JCL VSAM in IBM IMS/MVS. Production support, developing business rules. Design, modify, implement business applications.
• Extensive DB2 database implementation. Perform database maintenance. Requirement validation, analysis, design, programming, documentation, unit/integration testing and acceptance testing support, and production support.
• Strong analytical and coding skills on large and complex on-line and batch mainframe applications. Deep knowledge and experience in COBOL II applications with state and federal interfaces required.