SUMMARY:

• Over 10+ years of IT experience in software analysis, design, development and implementation of various Mainframe & Data warehouse using Informatica applications.
• Strong expertise in Mainframe technologies like COBOL, JCL, DB2, VSAM, IMS/DB, CICS, Changeman, Endeavor, File - AID, Xpeditor, QMF and SPUFI.
• Experience in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 9.x/8.x/7.x/6.x ETL tool.
• Expertise in planning, building and managing Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts.
• 5+ Years of experience as Project lead and Experience in leading the team at onsite and offshore.
• Experienced in using ETL tools like Informatica (Power Center) Designer, Repository Manager, Administration console and Workflow Manager.
• Interacting with client for gathering, analyzing the requirements and preparing analyze work objects and ensuring High Level and Low-Level Design are captured and it meets the client’s architectural design. Had a good rapport with Client during the elicitation phase.
• Strong in preparing Functional and Technical specifications, design documents accordingly
• Provide a walkthrough of DSD document with Business team and get concurrence for the solution approach.
• Manage the requirement till the rollout facilitating business and technology teams.
• Good functional exposure in Banking & Financials and Insurance applications.
• Very good communication and interpersonal skills, with demonstrated team dynamics and initiative
• Able to handle different projects concurrently
• Good analytical skills and a quick learner

TECHNICAL EXPERTISE:

IBM Mainframes: COBOL, JCL, DB2, CICS,VSAM,IMS DB

Mainframe Tools: Changeman, Endeavor, Xpeditor, File-AID, File-manager, BMC tool, CA tools

Job Scheduling tools: CA7,Autosys,OPTIWISE,ESP

RDBMS: Oracle 11g,DB2

ETL Tools: Informatica Power Center 9.X/8.6.

Programming: SQL, C++, XML, HTML, Cobol

WORK EXPERIENCE:

Confidential, Dodgeville, WI

Sr. COBOL Developer

Responsibilities:

• Understand and document the current system and work flow at Confidential ’ end.
• Support and maintain Order Management system Mainframe application.
• Support Confidential ’end Incident and problem management process.
• Provide maintenance and change release for in scope applications.
• Participate in solution design process for long term fix.
• Execute impact analysis before modifying any existing application/code.
• Design and develop small to medium projects based on the requirements
• Provide estimated timelines and meet deadlines in a fast paced environment
• Recommend process improvements to the development cycle
• Pay attention to detail and work as a team player
• Interact with the project team which includes project managers, development manager and QA
• Attend the meeting/s and provide status update on a timely manner.

Environment: Mainframes - COBOL, J CL DB2,CICS, VSAM,EZT+, OPSWise, SerivceNow & JIRA.

Confidential, Madison, WI

Tech Lead

Responsibilities:

• Developed new batch programs for extracting and transform using COBOL, DB2 and VSAM.
• Created new JCL’s to provide the Mainframe extract files to Ware house system.
• Made changes to existing Cobol & CICS programs to in corporate the changes required for
• The new system.
• Provided support in migration of Mainframe applications to Dataware house applications.
• Provided 24X7 on call production support for Mainframe applications.
• Ran data extracts from VSAM or flat files using utilities like File-Aid, DFSORT, Ice tool etc. for clients.
• Responsible for reviewing functional specifications and preparing technical design framework for ETL.
• Interacting with the clients on a regular basis to discuss day-to-day issues and matters
• Provide technical second-level product support.
• Provide support for Informatica workflows/mappings which are running in production environment.
• Enhanced the existing batch and online programs according to the clients new requirements
• Involved in the development of Informatica mappings and preparation of design documents,
• Technical specification documents and unit testing documents.

Environment: COBOL, JCL, DB2, VSAM, CICS, Endevor, File-AID, Xpeditor, CA7, Autosys & Informatica.

Confidential, Des Moines, IA

Tech Lead

Responsibilities:

• Working closely with the client for gathering, analyzing the Requirements and preparing analyze Work objects.
• Modified COBOL and CICS programs with DB2 as a part of Agent Master File system changes.
• Fine-tuned existing CICS online screens (formats, validation edits, deletion and addition of new fields, Standardization etc.).
• Created new mainframe batch programs COBOL, DB2 for Agent bonus system.
• Assisted in the development of several applications that allowed new platforms to work in Conjunction with legacy systems.
• Enhanced the existing batch(DB2) and online programs(CICS) according to the clients New requirements.
• Preparing and executing test plan and test cases
• Performed coding, unit test, system test thoroughly
• Working with all teams for SIT and with Business users for UAT test phase
• Debugged the programs to fix the issues
• Reviewed and led team members and implemented the code changes

Environment: COBOL, JCL, DB2, VSAM, CICS, REXX, Changeman, File-AID, Xpeditor, ESP.

Confidential

Programmer Analyst

Responsibilities:

• Maintenance for both COBOL & CICS programs as per the requirements.
• Modification of existing JCL’s to suite the requirements of the testers.
• Maintenance for both COBOL & CICS programs and unit testing the changes.
• Create extracts from VSAM or flat files using DFSORT, File-Aid
• Providing the technical support for all test environments, which include DB2, CICS, IMS issue handling
• And resolution. Resolution of the errors like S0C1, SOC4, SB37, SE37 etc.
• Involved in 24X7 Production support from offsite.
• Run queries in DB2 to generate reports/extracts for the clients.
• Incident and Problem Management.
• Change Management (Order processing & ad-hoc requests)

Environment: COBOL, JCL, DB2, CICS, VSAM, Changeman, File-AID, Xpeditor, ESP

Confidential

Programmer Analyst

Responsibilities:

• Modification of existing JCL’s to suite the requirements of the testers.
• Changed some existing COBOL & CICS programs to add processing for the new accounts.
• Providing the technical support for all test environments, which include DB2, CICS, IMS issue handling and resolution.
• Created new jobs and modified existing jobs using JCL
• Assisted in the deployment of code to Production environment and provided support for the code thereafter.
• Implement the Service improvement plans/service transformation plans. Proactive problem management. Track and prepare/approve RCA’s for severity 1 SLA/KPI breaches.
• Performed other functions such as systems analysis and design, user coordination, and systems documentation and technical research.
• Investigation and diagnosis, Resolution and recovery and Incident closure.
• Created new reports as per requirements
• Performed code reviews
• Performed test data preparation and creation of test files
• Performed Assembly/Component, SIT, UAT testing
• Prepared and executed test plan and test cases

Environment: COBOL, JCL, DB2, VASM, CICS, MVS, Endevor, File-AID, Xpeditor, SPUFI, QMF

Confidential

Software Engineer

Responsibilities:

• Responsible for Technical analysis and design, coding and testing
• Maintenance for both COBOL & CICS programs including DB2 & IMS DB as part of various initiatives.
• Wrote adhoc queries in DB2 for business partners.
• Monitor and ABEND resolution of MVS CA-7/CA-11 batch processing.
• Enhanced the existing batch and online programs according to the client’s new requirements.
• Ensure that the project documentation is maintained as per the Project Life Cycle and all documents are version controlled and maintained.
• Enhanced the existing batch and online programs according to the client’s new requirements.
• Creating bind strategies and running bind jobs.
• Performed coding, unit test, system test thoroughly.
• Created test cases for the user acceptance test and co-ordinate with the users during UAT.
• Reviewed and led team members and implemented the code changes

Environment: COBOL, JCL, DB2, IMS/DB, CICS, MVS, Changeman, File-AID, Manage now, Xpeditor, SPUFI, QMF, MS-Windows XP, MS-Office, Microsoft Visio

Confidential

Software Engineer

Responsibilities:

• Analyzing the business requirements and transforming the requirements to Functional design specifications analyzed business requirements and identified solutions for the same.
• Development of both online and batch programs with database connectivity likeCICS-DB2 and COBOL-DB2.
• Querying data from database (SQL) for creating data for unit testing using QMF, SPUFI etc. and creating best unit test scenarios covering all aspects of the business requirements.
• Create and modify JCL jobs in production.
• Prepared and executed test plan and test cases.
• Extensive coding using COBOL, JCL and VSAMs.
• Performed coding, unit test, system test thoroughly.
• Created test cases for the user acceptance test and co-ordinate with the users during UAT.
• Debugged the programs to fix the issues.

Environment: COBOL, JCL, DB2, CICS, QMF, SPUFI, GTAM, Comparex