Rajkumar

Alagiri

South Windsor, CT, USA

+1-508-***-****

adsj6g@r.postjobfree.com

https://www.linkedin.com/in/rajkumar-alagiri-ba55485b

Senior application Developer, specialized in Mainframe and ETL developments. Experienced with all stages of the development cycle for dynamic development and migration projects. Well-versed in numerous programming languages including IBM mainframe languages, Informatica. Strong background in project management and customer relations.

Skills

Language

COBOL, JCL, CICS, IMS/DC, EZYTRIEVE

ETL

Informatica Power center 9.x, 10.x and SSIS

Database

DB2, IMS/DB, VSAM

Operating System

OS/390

Tool

QMF, PANVALET, File-aid, Expeditor, ISPF, Endeavor, VIDD, TRXM, Change-man, VISIO, Excel Macro, Microsoft Visual Studio 2012

Other

REXX, Cobol Stored procedure, NETRON/CAP, Vantage, SSIS (ETL), Power Center, PWA (Project web application for PPM)

Project Management

Microsoft Project Server 2010, Project Web Application (PWA)

Domain

Automotive, Insurance

Reporting Tool

Clear-Quest, TRACK, Remedy (Admin and development)

Profile Summary

Overall 16+ Years of IT experience in Insurance, Financial Service and manufacturing domains. This includes SIX + years at client location in USA.

Extensive experience in working IBM Mainframe Technology (COBOL/JCL/CICS/VSAM/DB2).

Experience in ETL development using Informatica power center 10.x. In addition having knowledge in SSIS.

Experience in complete development life cycle from requirements gathering to post implementation support and maintenance of Mainframe and ETL projects.

Experience in handling administrative activities in 'Project Portfolio Application (PPM) includes Microsoft Project Server 2010, Project Web App.

Experience in working as Admin of Remedy on Demand cloud based application and SRD development.

Specialized in documentation, Organizing, Tracking Projects/Defects and Mainframe Automation using REXX, etc.

Proficient in requirement study, System Analysis, Design, Construction, preparation of High level and Low level documentation, drafting Unit test and System test case.

Experience in supporting critical production support applications and provided 24*7 support.

Excellent Communication, Presentation and Interpersonal skills.

Having different working exposure by working as Development Lead, Tech Lead, OSC Business System Analyst and Application SME’s.

Experience

MAY/2010 – TILL DATE

Associate Consultant / TATA Consultancy Services, USA

AUG/2005 TO APRIL/2010

Programmer Analyst / Syntel Limited, Chennai

Education

2001 - 2003

M.S (IT&M) / A.J. College, Sivakasi, Tamilnadu, India

1997 - 2000

B.sc (Tex) / Rajapalayam Raju’s College, Tamilnadu, India

Overall Roles & Responsibilities

Customer coordination to prioritize and gathering requirements.

Participate customer strategic initiative project discussion.

Preparation of Low level and high level requirement specification documents.

Project release meeting coordination and engage required stake holders.

Handling Project management and provide required document for management review.

Production Batch Support and ABEND resolution in ETL and Mainframe jobs to make sure the application is meeting daily SLA’s.

Coordination for weekly, monthly, quarterly and yearly activities.

Perform RCA meeting and documenting the same for production failures.

Development mainframe programs by using IBM Mainframe technologies.

Development in ETL process by using Informatica Power center 10.x, SQL, Zena.

Handling D2D administrative tasks from PPM and remedy application.

Coordinate with various team to troubleshoot the failures (this involves multiple teams/vendor).

Engaged in improvement activities like PI or CI.

Expertize in handling Agile and waterfall projects.

Handling internal and external SOX and KPMG audit.

Collaborate with business users and product vendor to gather required data.

Documenting all technical and system specification documents for all ETL applications.

Offshore and Onsite coordination and make sure onshore and offshore handovers are happening in smooth manner.

Providing necessary training to junior associates.

PPM Application support using Project Server 2010 Support and Microsoft Project 2010.

Outlook form maintenance.

Key Strength

Leadership/ Team work Skills.

Decision making skills.

Innovative Thinking.

Project Management.

Business Development.

Multi technology skills.

Quick Learner.

Work History

[1] PERIOD(S): JULY/2015 THRU TILL NOW ROLE: PROJECT LEAD, ONSITE SME

CUSTOMER: SELECTIVE INSURANCE COMPANY OF AMERICA, USA

Customer is high rated and ranked P&C Insurance group in the United States. They provide value added products and services to businesses, public entities and individual through independent agents in majority of the states in US. In this acted as SME of following projects.

Personal lines underwriting system

Billing Integration, AGT5

Legacy Application (General Ledger and Profit Sharing)

PPM

Remedy

ETL Developments

Project Type: Development / Maintenance / Application Support (L1/L2 & L3)

Environment: COBOL, JCL, DB2, VSAM and Easytrieve, Informatica Power Center 10.x

[2] PERIOD(S): DEC/2012 THRU JUNE/2015 ROLE: PROJECT LEAD, ONSITE SME

CUSTOMER: STATE FARM INSURANCE AND TRANSAMERICA INSURANCE, USA

Customer is one of the American holding company for various life insurance companies and investment firms operating primarily in the United States offering life and supplemental health insurance, investments, and retirement services.

Project Type: Development / Maintenance / Application Support

Environment: COBOL, JCL, DB2, VSAM and Easytrieve, CCL, TRAC, REQPRO

[3] PERIOD(S): MAY/2010 THRU DEC/2012 ROLE: PROJECT LEAD/OFFSHORE

CUSTOMER: AXA INSURANCE, USA

Customer is one of the top insurance companies and they have been using OMNI product of AXA IT technology to support the PARIS application which deals with Annuity Policy Admin System. In this have taken care of end-to-end application development in Annuity admin systems.

Project Type: Maintenance / Development / Prod-Support

Environment: COBOL, JCL, VSAM, DB2, Easytrieve and NETRON/CAP

[4] PERIOD(S): AUG/2005 THRU APR/2010 ROLE: PROGRAMMER ANALYST

CUSTOMER: CHRYSLER LLC, USA

Customer is one of the leading automaker in United States. My involvement was develop and maintain their inventory management and MRA projects.

Project Type: Development

Environment: COBOL, JCL, DB2, IMS/DB-DC, CICS and Stored Procedure

Contact this candidate