SUMMARY

• Experienced IT professional with domain expertise in HealthCare, Insurance and Transportation.
• Good experience in various phases of development lifecycle such as user Requirements analysis, design, coding, documentation and implementation.
• Extensive knowledge and experience in Legacy Mainframe Programming Language such as COBOL,JCL,DB2,EASYTRIEVE and tools such as CHANGEMAN,ENDEVOR,SPUFI,IBM UTILITIES, WinSCP, PuTTY.
• Working Knowledge of Production Support and System analysis activities.
• Experience with source control tools and system tools like File - aid, sort, CA-7, SPUFI, IBM Debugger EXPEDITOR
• Experience in Developing and executing test plans and works closely with QA and UAT teams.
• Experience in Data warehousing project life cycle.
• Good Experience in Migration of Legacy code to BI Environment.
• Experience in developing the best practices and quality assurance standards for ETL solutions.
• Experience in developing ETL mappings using Informatica ETL Tool.
• Hands on experience in dealing with databases like DB2, Oracle, and IMS.
• Good knowledge in writing basic UNIX scripts.
• Good experience in writing complex SQL queries.
• Experience in working in an onsite/offshore model.
• Proficient experience with MS Office Word, Excel and Outlook.

TECHNICAL SKILLS

Databases: DB2, Oracle, IMS

Languages & Tools: COBOL, CICS, JCL, Easytrieve, UNIX Scripting, Toad, SQL, SPUFI, File Manager

Operating Systems: Windows XP, Windows 7

ETL Tool: Informatica Power Center 9.1, 9.5

Change Control Tools: Changeman, Endevor

PROFESSIONAL EXPERIENCE

Confidential, Illinois

Application Maintenance Analyst

Environment: COBOL, JCL, DB2, ENDEVOR, SPUFI

Responsibilities:

• Responsible for monitoring mainframe Batch cycle and take any pro-active steps.
• Identify and implement Root cause analysis to improve the Batch job performance
• Fix the Production Job abends within the Specified SLA and without impacting the downstream job flow.
• Test the components in lower regions for any change made as per the business requirement and migrate to Production as per the release calendar.
• Perform Impact analysis before making any changes to the Components.
• Provide the estimates and get the approvals from the business to implement the Root cause issues.
• Involve in Team meetings which will help me to understand the tasks that are currently going on in both offshore and onshore
• Involve in Peer review(s) and suggest any modifications as required.
• Prepare and send weekly ABEND reports to the Business.

Confidential

Associate Professional Software Developer

Environment: COBOL, JCL, DB2, ENDEVOR, TOAD, SPUFI, EASYTRIEVE, Oracle, Informatica 9.5

Responsibilities:

• Creating the Design documents as per requirement and reported to the business.
• Analysis and understanding the requirements and functional specifications.
• Involved in Unit Testing and preparing the Unit Test Cases as per the requirements.
• Responsible for preparing production and test JCL's for batch programs.
• Developed DB2 Stored Proc's which will be used by front end applications as a part of migration project.
• Impact Analysis for requirement changes, finding affected list of programs and homogeneous implementation
• Scheduling and monitoring the Batch programs in Production Environment and document the process for internal team use.
• Attend the team meetings for the status and action plans need to be taken on any on-going issues, if any with onshore team.
• Involved in preparation of Pre-delivery & Post-delivery follow up documents in order to have smooth migration of Mainframe Components such as JCL's, stored proc’s, COBOL programs to production environment.
• Perform Peer review and log any issues and track till it is closed.
• Developed various DB2-COBOL, pure COBOL Batch programs with corresponding JCL's and Proc's.
• Involved in impact analysis on various Mainframe components before starting the enhancements and take appropriate action before proceeding further.
• Enhancements to the existing system which involves analysis of programs, coding, testing the jobs and migrating final elements to Production environment.
• Provide weekly status reports to the Team Lead.
• Developed standard and reusable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Prepared design documents consisting of data flow from Source to Target for all the mappings that are developed using Informatica.
• Created DDL and DML scripts that have structure of new tables and modifications of existing tables.
• Worked on Power Center client tools like Source Analyzer, Mapping Designer, Mapplet Designer and Transformation Developer
• Extensively used transformations like Unconnected Lookup, Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Maintained good quality on deliveries, even in complex tasks. Moved the code to Functional Testing without any defects and helped the testing team to understand the functionality.

Confidential

Software Engineer

Environment: DB2, COBOL, JCL, CICS, IMS, JCL, CHANGEMAN, SPUFI, INFORMATICA 9.1

Responsibilities:

• Involved in Production support activities. Ensured the Batch cycle gets completed in time. Also, fixed the issues within the Service Level Agreements (SLA's), contact the scheduling team to restart problematic jobs, contact onsite oncall person in case of critical job failures, closing incident tickets with description of fix.
• Responsible for correct versioning of code by creating and moving the packages using Changeman.
• Responsible for testing to ensure that the existing functionality is unaffected by new change.
• Extensively used IBM Debugger tool Expeditor in production support to find out the bad records and fix the issue.
• Escalation of issues through TCIS (Incident tracking tool).
• Follow coding standards and development of programs and jobs using JCL, DB2, and COBOL.
• Preparing of test cases, test plan before each delivery of component.
• Developed DB2-COBOL, IMS-COBOL, DB2-IMS-COBOL batch programs along with corresponding JCL's and PROC's.
• Perform Impact analysis.
• Involved in Root Cause Analysis and developed solutions for frequent repetitive errors in Production Environment.
• Actively participated in Team meetings and get to know the upcoming enhancements.
• Involved in various Enhancements as per the requirement.
• Designed ETL mappings using Informatica ETL tool.
• Preparation of STTM's which tells about the business logic.

Confidential

Java/J2EE Developer

Responsibilities:

• Liaised with client gathering requirements for change requests and converted to functional and technical specifications.
• Worked on auditing Commission/Decommission process events using Java, JavaScript, Viryanet API, SQL and PL/SQL
• Developed code to retrieve signal strength of Motoral MC65 device using TAPI API. TAPI value is converted to Decibels and bars using PL/SQL stored procedures and trigger
• Implemented change requests for portal and mobile pages involving changes during job creation, job completion using JSP, Servlets, Viryanet API, PL/SQL.
• Used JUnit 4.X, Mockito for unit testing and integration tests using Selenium Web driver.
• Given support to factory testing and UAT testing.

Environment: Agile TDD, Java 1.6, Viryanet MCP platform, JSP, JavaScript, DOM, XML, XPath, Oracle, PL/SQL, Apache Axis, Web Sphere Application Server 6.0, Motorola MC65 device, SVN, JIRA.

Confidential

Java developer

Responsibilities:

• Extensively worked on Struts Framework.
• Created user interfaces using JSP.
• Developed the Web Interface using Servlets, Java Server Pages, HTML and CSS.
• Developed the DAO objects using JDBC.
• Business Services using the Servlets and Java.
• Developed and modified Servlets to accept and process request from the clients.
• Used JDBC to connect the J2EEserver with the relational database.
• User input validations done using JavaScript and developed use cases using UML.
• Extreme programming methodologies for replacing the existing code and testing in J2EE environment.
• Developed java classes for business layer.
• Developed ANT script for building the application.
• Developed database objects like tables, views, stored procedures, indexes.
• Involved in testing phase and also production support of the project.

Environment: Java, J2EE, JSP, Struts, HTML,DHTML, Custom Tags, ANT, Java Script, XML, JDBC, Oracle (PL/SQL), DAO, Linux, Web Logic, JUnit, Eclipse.