Aravind Resume
Resume:
Aravind Viswanathan
*******.*****@*****.***
_____________________________________________________________________________________________________________________
SUMMARY
• 4 years of hands-on experience leading all stages of application development efforts, including requirements definition, design, coding, testing, and support in mainframe and client server platform.
• Worked for Life Insurance and healthcare clients and INGENIUM implementations.
• LOMA certified professional in Life insurance and Annuities. Have functional knowledge and experience working on life insurance and annuity products and processes.
• Extensively involved in developing application in INGENIUM and IBM Mainframes using Web sphere, COBOL,CICS, DB2, JCL, REX, Java and HTML.
• Have good exposure to CICS, IMS, tools Viz. QMF, SPUFI, DFSORT, CONNECT-ENTERPRISE, VSS, ABEND-AID, XPEDITOR, FILE-AID.
• Experience in preparation and review of Business Functional Specifications, Functional Design Specifications and Detailed Design Specifications.
• Participated in Requirement gathering, and preparation of Application flow diagrams, High Level and Low Level Designs throughout the Software Development Life Cycle using MS-Office & MS-VISIO.
• Expertise in providing customer support for development, testing and debugging.
• Expertise with interaction with Business Analysts, Managers, Developers, Testers and End Users.
• Handled Unit, Functional, System Integration, Regression testing and supported for UAT.
• Received appreciation from the client side for the extra effort taken during crunch times in the production problems.
• Have a proven track record of improving quality assurance through defect prevention planning and process re-engineering.
EDUCATION
Kelley School of Business, Indiana University, Bloomington, IN December 2008
Master of Science in Information Systems; GPA-3.65
• First place, Orientation case competition, “Web 2.0 in Financial Services”
• Second place, Allstate case competition, “Second life innovation concepts”
• Capstone project: explored and made recommendations on Intel Business Value Index for Batesville Casket Company
• Learned advanced web programming skills with HTML, ASP.NET, C# & MS Visual studio.
National Institute of Technology(NIT), Trichy, India May 2004
Bachelor of Technology, major in Electrical & Electronics Engineering, with honors
• Simulated power transmission algorithms using C & C++ as part of curriculum project work.
• Active member of IEEE, NIT Chapter
• President, Rotaract Club of NIT (social organization)
• Cultural Secretary, Festember (annual cultural festival)
TECHNICAL SKILLS
• Operating Systems : Windows, MVS,Z/OS,OS/390, Linux/Unix
• Languages : C,C++, C#, HTML, Cobol, CICS,JCL, Java, JavaScript, REX,ASP.NET
• Databases : DB2,MSSQL, MYSQL,IMS
• Tools : MS Visual Studio 2005, MS SQL Server 2005, MS Share point, MS
Project, MS Visio, Lotus Notes, Test Director, Star Team, Serena Version
Manager, SPUFI, TSO/ISPF, File aid, Change man, INGENIUM, IBM Web sphere
• Domain certifications : LOMA certified professional in Life Insurance, ITIL Foundation Certified,
Certified Information Systems Auditor (Passed exam on June 2008)
EXPERIENCE
Project #1: Air Ticket Web retail system and Carrier contract management
Client : Right Rez Travel Automation Solutions, Bloomington, IN
Date : May 2008 – Oct 2008
Position : Business Analyst
Technologies used : MS Visio, MS SharePoint, MS visual studio, MS Excel, MS Project, ASP.NET, .NET 3.5 framework, C #, MSSQL 2005.
Project Profile:
RightRez travel automation solutions, based in Bloomington Indiana provide travel automation solutions to cruise tour operators and agents. The business considered to be one of the most complex models and Right Rez is one of the very few companies that provide IT enabled solutions for this business. Air ticket web retail application and carrier contract management application were systems build on ASP.NET, C++ and C# and were used by tour operators and travel agents to maintain their systems. The application was connected to a MS SQL database and major product upgrade during August was creating new database table structure for creating additional reports.
Responsibilities:
• Created and made changes to Database tables and stored procedures using MS SQL Server 2005 according to the change requests.
• Analyzed and developed requirements for adding BI reporting capabilities to the air ticket retail application. Developed Use cases, comprehensive test plan and scripts for major product upgrade in August 2008.
• Re-engineered airline contract management application; reduced contract data input time by 15 minutes.
Cognizant Technology Solutions India Pvt Ltd June 2004 – June 2007
Designed and developed IT applications using mainframe technologies for MetLife Insurance, One of the major Life insurance providers in the US.
Project #2: Claims Reserves Calculation Application
Client : MetLife Insurance, NY
Date : June 2006 – June 2007
Position : Associate-Projects (Project Lead)
Technologies used: IBM OS/390,Java, COBOL, CICS, DB2,JCL, REX, INGENIUM,ChangeMAN, OPCE, BMC EDITOR, SPUFI, QMF, ABENDAID,EXPEDITOR(BATCH/ONLINE),Mercury Test Director, MS Visio, MS project
Project Profile:
The claims reserve management application was an enhancement to the existing application developed over 20 years using INGENIUM, Java, COBOL, DB2 and CICS. The project covered code changes over 200 programs and 120 batch jobs. The application enhancement was critical for accurate reserves calculation and SOX compliance, ensuring adequate internal controls in the system. The project also covered migrating legacy COBOL to Java platform for web enablement.
Responsibilities:
• Creating Service Request
• Providing High Level Estimates
• Creating Project Design Documents
• Client coordination for the project
• Code Walkthrough’s and Review’s
• Code migration from COBOL to JAVA.
• Providing implementation support (production support) for the impacted & implemented Systems.
• Enhancement of the system as per requirements
• Software Configuration Management.
• Acted as Offshore claims and production support SME. Was the single point of contact for all issues and defects to the client side.
• Responsible for prepare Low level design (LLD), task allocation, team lead activities, peer review, documentation, defect tracking using Mercury tools.
• Responsible for unit testing, parallel testing, integration testing and user acceptance testing
• Responsible for analysis and modification of existing COBOL-DB2, CICS/COBOL /DB2, COBOL modules, JCL/PROCS, VSAM files creations, Reports
• Assisted in ensuring proper deployment of the application through the various test environments and production; including coordination with other Developers in the use of common components in all test and production environments.
Project #2: Long Term Care (LTC) Claims Management Application
Client : MetLife Insurance, NY
Date : June 2005 – June 2006
Position : Associate-Projects (Project Lead)
Technologies used: IBM OS/390, Java, COBOL, CICS, DB2,JCL, REX, INGENIUM,ChangeMAN, OPCE, BMC EDITOR, SPUFI, QMF, ABENDAID,EXPEDITOR(BATCH/ONLINE),Mercury Test Director, MS Visio, MS project
Project Profile:
Claims management application was used to maintain the long term care claims lifecycle from claims entry to pay out. The application involved feeds to almost all critical applications of the client. The project also involved migration of legacy code to Java . Lead a team of 4 analysts
Responsibilities:
• Acted as Production support coordinator. Supervised the batch trial and reduced batch abends by 40% by doing root cause analysis and fixing the defects in programs.
• Created and maintained Change man packages as release co-coordinator. Responsible for scheduling batch jobs in the OPCE and ensuring successful run of all jobs in the batch trial.
• Lead a team of 4 analysts for a critical upgrade.
• Involved in User communication experience for requirement gathering, High Level design HLD, Use Acceptance Testing (UAT), and Production issues.
• Responsible for unit testing, parallel testing, integration testing and user acceptance testing
• Responsible for analysis and modification of existing JAVA,COBOL-DB2, CICS/COBOL /DB2, COBOL modules, JCL/PROCS, VSAM files creations, Reports
Project #3: BIOS (Benefit Information Operation System)
Client : MetLife Insurance, NY
Date : May 2005 – June 2005
Position : Programmer Analyst
Technologies used: IBM OS/390,Test Director, MS Visio, MS project , COBOL, CICS, DB2, REX, INGENIUM, File Aid, BMC Admin, Changeman, OPCE
Project Profile:
BIOS (Benefit Information Operation System) were used to by call center employees to pull up customer benefits information when required. The systems were build using CICS, COBOL, DB2 technologies and also involved had a daily nightly batch trial jobs.
Responsibilities:
• Requirements Analysis
• Preparing Design Documents
• Coding
• Testing
• Code Walkthrough’s and Review’s
• Analysis & providing solutions to the Change Requests
• Enhancement of the system as per requirements
• Designing new DB2 database structure
• Testing for Change requests and Project Requests.
Project #4: FMS (Financial Management System)
Client : MetLife Insurance, NY
Date : Jan 2005 – April 2005
Position : Programmer Analyst
Technologies used: IBM OS/390,Test Director, MS Visio, MS project , COBOL, CICS, DB2, REX, INGENIUM, File Aid, BMC Admin, Changeman, OPCE,ADSO,IMS
Project Profile:
The FMS (Finance Management System) was based on ADSO-IMS and the client wanted to migrate from ADSO-IMS to CICS-DB2 to avoid license renewal fees, thus saving the client 10 Million dollars. The project went on for 18 Months with over 200 person team working during the UAT stage. The project was divided into 5 portfolios (releases).
Responsibilities:
• Part of the code development team in a migration project from ADSO-IMS platform to CICS-DB2 platform.
• Designed front end screens using CICS and extensively used REX to develop tools and scripts.
• Designed test plan and test scripts for the various testing stages as defect coordinator
• Coding according to the specifications prepared
• Test plan preparations and testing
• Conduct reviews and other quality related procedures as per the CMM Level 5 standards
Project #5: Capacity Planning Application
Client : MetLife Insurance, NY
Date : June 2004 – Dec 2004
Position : Programmer Analyst
Technologies used: IBM OS/390,Test Director, MS Visio, MS project , COBOL, CICS, DB2, REX, INGENIUM, File Aid, BMC Admin, Changeman, OPCE,ADSO,IMS
Project Profile:
The capacity planning application was build on COBOL-CICS-DB2 on an OS 390 system and was used to maintain call centre call volumes and benefits payout information for the client. The system had a nightly batch trial containing 30 batch jobs.
Responsibilities:
• Involved in production support, bug fixing and job performance improvement activities.
• Acted as the Software Configuration Management (SCM) coordinator for the projects.
• Solved many Critical Production A-bends issues using DUMP MASTER/Trace Master/ Expeditor for batch programs and identifying long term and short term fixes with SLAs
• Data extraction from DB2 tables by using DSNTIAUL and load data into DB2 tables by using LOAD utilities
• Written many SQL query using inner/outer joins and cursor queries Cobol/DB2 modules with commit rollback concepts
• Worked on EXPLAIN for query performance issues. Handled ad hoc application support, code walkthroughs and bug fixes.
Contact this candidate