EXPERIENCE SUMMARY:

• Seeking a challenging and growth - oriented position as a Software consultant in developing business applications, Mainframes and to be a part of a team that dynamically works towards the growth of organization
• More than 14years of Information Technology Industry experience as a consultant in legacy system and experience in the areas of ETL design and Development.
• Highly proficient in Mainframe application development and Data Warehousing.
• Extensive experience in SDLC system Analysis, Requirements gathering, Design, Development, Estimating, Data Conversion, Testing / Debugging, Technical as well Production support, Offshore/Onshore coordination.
• Worked on ETL tools like SSIS, DataStage Designer, DataStage Director and DataStageAdministrator .
• Strong understanding of the principles of Data Warehousing using fact tables, dimension tables and star/snowflake schema modelling.
• Worked extensively with Dimensional modelling, Data migration, Data cleansing, ETL Processes for data warehouses.
• Strong skills in COBOL, JCL, DB2, CICS, VSAM, SPUFI, SQL, TSO / ISPF, Expediter, File-Aid, NDM, Change men, MVS and OS/390.
• Thorough working knowledge in SDLC (Software development life cycle).
• Comprehensive usage of DB2utilities like Stored Procedures, REORG, RUNSTATS, LOAD, UNLOAD, COPY, and SQL Tuning.
• Domain exposure in Banking, Financial, Credit Card, and Telecom applications.
• Possess excellent interpersonal and team building, leadership and negotiation skills. Strong organization, planning, problem solving and decision-making skills.
• Good experience bug tracking systems, configuration management and version control tools.
• Aligned myself successfully with the CMM standards and the streamlined processes the client is following. Able to follow the Client/Project specific standards.
• Ability to write test plans, test cases, test procedures and test scripts from requirements.
• Create reports using Microsoft reporting tool SSRS.
• Extensive experience working in the Microsoft stacks of BI solutions - SSRS, SSIS with MS SQL
• 2012/2008R 2/2008/2005/2000.
• Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management,
• Report delivery and Report security.
• Experience in SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions,

TECHNICAL SKILLS:

Hardware: Intel Based PC Family, Main Frame

Operating Systems: Windows NT,2000& XP, IBM MVS,OS/390, ZOS

Languages: COBOL, JCL, SQL, IBM InfoSphere Datastage 8.5, IBM InfoSphere 9.1, Java

Databases: DB2, Oracle 10g/8i/9i, Azure SQL Server

OLTP: CICS

Special Software: FILE: AID, XPEDITER, TSO/ISPF, VSAMSORT/MERGE Utilities,FTP,NDM,CA-7 Scheduler, ABEND-AID, FILE-AID, FILE-AID for DB2, BMCDB2, DB2MONITOR, File Manager, IBM DEBUG Tool, AutoSYS

Version Control: CHANGEMAN, ENDEVOR

Database related products: SPUFI, QMF, MS: SQL, Toad Data Point

SQL Server Tools: SQL Server Management Studio (SSMS), SQL Server Reporting Service (SSRS), SQL Server Integration Services (SSIS)

WORK EXPERIENCE:

Confidential

Consultant - Programmer Analyst

Responsibilities:

• Involved in gap analysis and setting up high level documentation standards.
• Code Analysis and Translation document preparation.
• System Flow diagram preparation using visio
• Data analysis, verbalization and SME document preparation
• Coordinate with the business analysts
• Test case preparation for the target system
• Class diagrams preparation for target system
• Interface analysis, design and documentation
• Database query support for IIB
• Defect tracking resolution and closure.
• Provide reports to Business.

Environment: /Software: COBOL, DB2, CICS, IBM Dispatch, Data Stage, Quality Center, FILEAID, BMC, FILE AID DB2, SYNC SORT, Agile methodology using TFS, Toad, SSMS, SSRS, SSIS, Azure

Confidential

Consultant - Programmer Analyst

Responsibilities:

• Requirements gathering, Analysis, Design, Coding, and unit testing.
• Reviewing the requirement, Preparing, and updating the Technical Design documents.
• Analyze existing system functionalities and prepare design document for future state.
• Coordination among different subsystems/team for execution of SIT, UAT, QA and final implementation of project.
• Prepare Request message format from IPP and Response Message Format send to IPP.
• Code Analysis and Translation document preparation.
• System Flow diagram preparation using Visio.
• Coordinate with the business analysts.
• Test case preparation for the target system.
• Defect tracking resolution and closure.

Environment: /Software: JCL, COBOL, DB2, CICS, CA VIEW, ASG-ZEKE Scheduler, FILEAID, BMC, FILE AID DB2, SYNC SORT, MQSeries, XPEDITOR and DB2 Stored Procedure

Consultant - Programmer Analyst

Confidential

Responsibilities:

• Involved in gap analysis and setting up high level documentation standards.
• Code Analysis and Translation document preparation.
• System Flow diagram preparation using visio
• Data analysis, verbalization and SME document preparation
• Coordinate with the business analysts
• Test case preparation for the target system
• Class diagrams preparation for target system
• Interface analysis, design and documentation
• Database query support for IIB rule development in the ODM rule engine and testing
• Defect tracking resolution and closure.

Environment: /Software: COBOL, DB2, CICS, IBM Dispatch, Data Stage, Quality Center, FILEAID, BMC, FILE AID DB2, SYNC SORT, Agile methodology using RTC, Toad.

Confidential

Sr Analyst

Responsibilities:

• Define and Maintain attributes of EMV Chip card.
• Provide new maintenance of promotional offering templates.
• Allow all Marketing Campaign applications to attach number of promotional offers.
• Allow maintenance of distinct pricing schedules.
• Provide ability to risk base credit card marketing campaigns.
• Define number of permissible offers Confidential issuer level.
• Provide data services to other technology areas.
• Permit use of Risk Based Pricing for Credit Card
• Allow assignment of penalty and curing to new account marketing.
• Allow the definition of minimum finance charge and its applicability to new accounts.

Environment: /Software: COBOLI, DB2, ENDEVOR, XPEDITOR, File-Aid, File-Aid for DB2, JCL, CICS, SPUFI, QMF, TSO/ISPF, BMCDB2, File Manager, IBM Debug, DB2 Stored Procedures, Java

Confidential

Responsibilities:

• Analysis and Understanding of the Functional Spec - Work closely with the Business Area and empathize the Functional requirements.
• DB2: Worked on Stored procedures, BMC monitoring of Table data.
• Extensively worked on LOAD/UNLOAD utilities, RUNSTATS, REPAIR, Performance Tuning and Monitoring.
• Supported to CIT, SIT, UAT, Pre-Prod, Disaster Recovery (DR) cycles and Production Implementation.
• Code construction and/or changes to the existing programs.
• Performing unit and system test.
• Technical Spec Development and High Level Design/Low Level Design document preparation.
• UTR& Data Mapping documents building.
• Analyzing the code changes required as per client functionality updates.
• Analyzing test results, identifying issues and suggesting resolution.
• Involved in Data creation by modifying data in PS files using FILE-AID.
• Participated in Functional Spec preparation as per client needs.
• Participated actively in system maintenance including bug fixes and enhancements.
• Involved greatly in code reviews, test reviews.
• Defect tracking and supporting for cycle execution.
• Preparing and review DTS (Detailed Task Schedule) Plan for installation, involved in module installation.

Environment: /Software: VS-COBOL II, DB2, ENDEVOR, XPEDITOR, File-Aid, File-Aid for DB2, JCL, CICS, SPUFI, QMF, TSO/ISPF, BMC-DB2, DB2 Stored Procedures, RMA, Java.

Senior Programmer Analyst

Confidential

Responsibilities:

• Analysis and Understanding of the Functional Spec - Work closely with the Business Area and empathize the Functional requirements.
• SQL tuning and BMC monitoring of DB2 tables.
• Extensively worked on DB2 Batch and Unload utilities, RUNSTATS.
• Code construction and/or changes to the existing programs.
• Performing unit test.
• Data Mapping documents building.
• Analyzing the code changes required as per client functionality updates
• Developed or enhanced the coding part in Interchange Module
• Analyzing test results, identifying issues and suggesting resolution.
• Involved in Data creation by modifying data in PS files using FILE-AID.
• Involved greatly in code reviews, test reviews.

Environment: /Software: VS-COBOL II, DB2, ENDEVOR, XPEDITOR, INSYNC, File-Aid, File-Aid for DB2, JCL, SPUFI, QMF, TSO/ISPF, BMCDB2, DB2Monitor, BATCH programming, MS-SQL.

Confidential

Senior Programmer Analyst

Responsibilities:

• Analysis and Understanding of the Functional Spec - Work closely with the Business Area and empathize the Functional requirements.
• DB2: Worked on Stored procedures, BMC monitoring of Table data.
• Extensively worked on Load utilities, RUNSTATS, REPAIR, Performance Tuning and Monitoring.
• Supported to CIT, SIT, UAT, Pre-Prod, Disaster Recovery (DR) cycles and Production implementation.
• Code construction and/or changes to the existing programs.
• Performing unit and system test.
• Technical Spec Development.
• UTP & Data Mapping documents building.
• Analyzing the code changes required as per client functionality updates
• Developed or enhanced the coding part in Interchange Module
• Analyzing test results, identifying issues and suggesting resolution.
• Involved in Data creation by modifying data in PS files using FILE-AID.
• Participated actively in system maintenance including bug fixes and enhancements.
• Involved greatly in code reviews, test reviews.
• Defect tracking and supporting for cycle execution.
• Preparing and review DTS (Detailed Task Schedule) Plan for installation, involved in module installation.

Environment: /Software: VS-COBOL II, DB2, ENDEVOR, XPEDITOR, File-Aid, File-Aid for DB2, JCL, CICS, SPUFI, QMF, TSO/ISPF, BMCDB2, DB2 Stored Procedures.

Confidential

Associate Consultant

Responsibilities:

• Analysis to the programs to be modified according to the business requirements.
• Analysis of Functional Specification document.
• Study of the requirements and getting clarifications for the change requests and Enhancements.
• Involved in Impact Analysis.
• Involved in preparing the test cases and Technical System design documents.
• Involved in Coding and Testing
• Unit testing and production support
• Competency Development activities, Knowledge management.

Environment: COBOL, DB2, JCL, CICS, VSAM, SPUFI, EXPEDITER, FILE-AID, CHANGE MAN

Software Engineer

Confidential

Responsibilities:

• On receiving the EAP (Evista Artemis Project No) and CR (Change Request). Communication with the customer and receive the detailed description of the EAP and CR either in document form or oral.
• Preparing LLD and DD.
• Impact analysis.
• Preparing CTP (construction test plan) & UTP (unit test plan).
• Code the impacted COBOL programs, CICS Programs, copybooks, JCLs, Procs, Control cards.
• Create the packages and move it to production.
• Unit Testing.
• Regression testing.
• Software configuration management activities.
• HLAD TOOL maintains.
• Conducting Technical Design & Test summary Walkthroughs.

Environment: COBOL, IDMS, CICS, JCL, DB2, VSAM, SPUFI, ISPF, ABEND-AID, SDSF, EXPEDITER, FILE-AID, CHANGE MAN