Hari Subramony

** ************ ***, ***#****, Syracuse, NY -13202

Mobile: 315-***-****

E-Mail:acoygt@r.postjobfree.com

Career Summary

. 7 years' experience in AS/400, SQL, XML, HTML application development,

enhancements, and support.

. 1 year experience in AS/400 server migration and upgrade.

. 3 year experience as Business Systems Analyst performing Requirement

gathering, Testing...

. Proven professional career progression as Business Analyst, Project

Leader and Technical Coordinator.

EDUCATION AND Professional Certifications

. B.E. Computer Science and Engineering (May-2006), Anna University,

Chennai, India.

. Achieved Oracle Certified Associate (OCA) from Oracle.

. Certified Fellow Life Management Institute (FLMI) from LOMA.

. Certified Associate in Customer Service (ACS) from LOMA.

KEY COMPETENCIES AND SKILLS

IBM AS/400 XML and HTML

RPG/RPGLE/SQLRPGLE Requirement Gathering

CLP/CLLE Data Warehouse Concepts

AS400 Reporting Tools VISIO, EXCEL & MS Office 2010

iSeries Access for ORACLE SQL/PL-SQL

Windows/Navigator

Change management - ALDON. Internal Auditing and PWC Controls

HIGHLIGHTS

. In-depth knowledge of Software Development Life Cycle (SDLC)

methodologies like Waterfall and Agile.

. Expertise in gathering, analyzing and documenting business

requirements and Functional Requirement Specifications.

. Extensive knowledge in preparing Process Flow Diagram & other UML

Diagrams using MS Visio.

. Creative and innovative thinker, with excellent analytical ability and

planning to provide problem resolution.

. Strong knowledge in AS/400 server upgrade and migration,

. Experience in AS/400 Security setup, Internal Auditing and PWC

Controls.

. Excellent knowledge in performing data analysis and extracting data

using SQL.

. Involved in converting the requirements into effective business

design.

PROFESSIONAL PROJECT EXPERIENCE

Tata Consultancy Services

Client: AXA Equitable Life Insurance Company, Syracuse, NY

Business Systems Analyst - PCI Compliance Project

Mar 2014 - Present

Solutions Environment: Requirements Gathering, AS/400, SQL, XML, MS Visio,

MS Excel, MS Word.

This project will bring AXA US into compliance with Payment Card Industry

standards which will seek to identify any updates that need to be made to

improve client credit card security. The project will focus on three

specific work streams that handle credit card transactions currently for

AXA-US. This project will identify the optimum solutions for securing and

protecting new client payment card data. Additionally, the PCI compliance

project will review existing policy data and clean up any existing data

currently on file to reduce the risk of data exposure. The final objective

of this project will be to update any procedures related to work stream and

process changes made through this project. My other responsibilities

included:

. Requirement Gathering and Analysis to identify the work streams that

handle credit card transactions.

. Conducted the project meetings successfully by coordinating all users,

technical staff.

. Discuss with Payment Gate way vendors and associated banks to

implement tokenization.

. Prepare the current state process flow and Target state process flow

using MS Visio.

. Prepare detailed BRD including High-Level Business and Functional

Requirements and Challenges.

. Clarified issues with developers during efforts to validate designs

and functional specifications

. Actively Participated in internal presentations and status reporting.

. Prepare Test plan, Test cases and perform testing of the implemented

changes.

Client: AXA Equitable Life Insurance Company, Syracuse, NY

Systems Analyst Apr

2013 - Mar 2014

Solutions Environment: Sysyem i Navigator, AS400, RPGLE, CLP, FTP, ALDON,

MPLUS, SPOOLMAIL, DBU, POWERTECH, MS Visio, MS Excel

My major role as a Systems Analyst and data migration lead at AXA included

upgrading the AS/400 servers from the IBM unsupported V5R1 version to

latest V7R1 servers. This included the migration of 3 application related

severs. The migration involved, POC, the application setup, migration

itself, vendor package installation, job scheduling, defect fixing, profile

security setup, testing, UAT support and cutover for 3 Production, 3

Integration, 2 Development and creation of 3 DR servers. My other

responsibilities included:

. Perform Requirement gathering and analysis of the existing system to

identify the daily routines, jobs scheduled, Business Activities, List of

vendor software's, Back-up process, printers, folders, interfacing

systems and prepare timelines for each activity completion.

. Serving as a liaison between the Customer and offshore migration team.

. Responsible for gathering business requirements and preparing FSDs,

communicate with development, QA.

. Conduct recurring meeting between project stake holders to understand

progress and timelines.

. Prepare Weekly Status Report and Presentations on project progress for

high level management.

. Coordinate with each vendor to get an estimate and upgraded software

packages to be installed in the new servers.

. Install the PTF's for the vendor packages in all the V7R1 LPAR's and test

the software's.

. Prepare workflow system for the business to streamline endorsement

procedure for administrative processes

. Create new OUTQ's and writers to configure to new interfacing systems.

. Coordinate with Business to create the Test Cases, perform UAT testing

and sign off.

. Clarified issues with developers during efforts to validate designs and

functional specifications

. Create plan to perform system maintenance and perform cutover and

Business checkout.

. Work with Internal Audit to set up Audit Controls and perform Audit in

new servers.

Client: AXA Equitable Life Insurance Company, Syracuse, NY

SME and Technical Onsite Coordinator

Apr 2010 - Mar 2013

Solutions Environment: System iNavigator, AS400, RPGLE, CLP, ControlM, MS

Excel

United States Financial Life(USFL) and MONY International Life of

America(MLICA) are AS/400 policy admin systems using the vendor software

LSP & GLP. The scope of the applications is to manage the policy base for

USFL. Execute contractual provisions for all customers with MONY

International financial protection, universal life, variable universal life

and variable annuities. This includes financial transactions, Title

(ownership/beneficiary) changes, billing and collection of premiums and

payouts. My other responsibilities included:

. Provided Subject Matter Expertize for USFL and MLICA. Responsible for

managing the project related all the work.

. Prepare business requirement specifications.

. Act as a liaison between AXA business team, Servicers and IT technical

development and support team for any technical and Business queries.

. Work closely with Accounting Team, Commissions Team and Customer Service

Business areas to provide suggestions for technical and Business queries.

. Business Analysis & requirement gathering for new enhancements and

developments and regulatory projects like NYS308, REG70,COI Remediation

and all system and application enhancement projects.

. Automation and Performance Tuning of batch processing for reducing manual

work and system improvements.

. This involved creation of SUBFILES, Display Files, Printer Files and

automation Batch programs in AS/400.

. Worked closely with Internal Audit and PWC to perform and review system

security and define control documents and performed semi-annual SOX

Recertification.

. Performed Backup and restoration process and maintenance of DR Server.

. Perform Set-up and Change Management using ALDON.

. Meeting between Developers & Quality Analyst, coordinated with Business

Users & Clients for UAT Stage till production movement.

. Responsible for checking the daily achievements. Generating reports and

sending to the clients as well as seniors.

Tata Consultancy Services, Chennai India Client: Aaron Brother's

Software Developer

Sept 2008 - Mar 2010

Solutions Environment: AS/400, RPGLE, CL/400, SQL/400, MS Word, MS Visio,

TURNOVER

Aaron Brothers desires to phase out their paper-based gift certificates and

sees Electronic Gift Cards as a way to increase the sales and usability of

this form of payment. This modification will allow Aaron Brothers to allow

in-store processing of Electronic Gift/ Merchandise Cards. My duties

included -

. Requirement gathering and impact analysis activities.

. Prepare the High Level Design Document [HLD] and Application Design

Document [AID]

. Preparing technical specification and created a visual representation of

the project design.

. Developed Gift Card processing menus and screens. This involved creation

of MENU, SUBFILES, Printer Files and automation of online report programs

in AS/400.

. Prepared detailed design document and manual for Gift Card menu options.

. Finally use TURNOVER for code promotion.

. Provide post implementation support.

Tata Consultancy Services, Chennai India Client: TATA-AIG Life Insurance

Software Developer

April 2007- Aug 2008

Solutions Environment: AS/400, Oracle SQL, MS Access, MS EXCEL, XML

My primary role in this position included providing production support and

maintenance of applications namely OLAS (Ordinary Life Administration

System). I had been the only contact for my application all over India. My

other responsibilities were:

. Analysis and documentation of the existing application which involved

preparation of application summary technical and business documents, root

cause analysis documents for recurring issues and overview presentations.

. Performing automations of recurring scheduled and exception reports. More

than 100 Oracle based reports are automated.

. Investigating application functionality to determine requirements.

PESONAL DETAILS

VISA STATUS: H1-B

REFERENCES: Available upon request

[pic][pic]

Contact this candidate