Senior Consultant
Resume:
Rajkumar
Alagiri
South Windsor, CT, USA
**********.****@*****.***
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