SUMMARY OF EXPERIENCE
**+ years of total experience in the IT Industry.
AINS 21 and AINS 22 Certified.
Experience working on Automobile/Manufacturing and Insurance domains.
Strong business analytical and leadership skills to document scope, change management, functional Designs, Low and high Level Design documents.
Handled multiple projects and used different tools to track projects progress.
Created new change controls based on the estimation.
Used different techniques to define the process Flow Chart, Business Process Modeling Notations, Activity Diagram.
Experience in verifying the results in QA and updating Traceability documents.
Well-Conversant in systems design, Data gathering, Rule Harvesting, development, integration and deployment for Mainframe area.
Have experience working with Java and Mainframe integration projects.
Experience in writing functional requirements and technical requirements.
Worked closely with DBAs on Stored Procedures, table Indexes in relation to processing improvements.
Have vast experience in Onsite-Offshore model.
Created Engineering Approval Work Flows based on inputs received from Users in the Web applications.
Experience working in Scrum Agile model and Water fall model.
Worked on Parts Ordering and Approval System, Car Ordering System, Sales channel and Fleet related projects.
Worked on new product "AHH” of introducing and packaging it as a better product to US market
Worked on the Agent Life Insurance system which is worked as a channel to credit proper brokerage to agents for leading Insurance Company.
Was involved in the Rule Harvesting activities like requirement gathering from client, third party and creating VSAM files with rules.
Worked in terabytes of data analysis for BIDW area using ABinitio ETL tool.
Achieved many Syntel awards & client appreciations showcasing outstanding performance.
TECHNICAL SKILLS
Operating Systems
Windows, MVS
Languages
COBOL,JCL,VSAM, DB2, CICS, SQL Stored Procedures
Web technologies
HTML, Javascript
Database
DB2, Datacom
Other Tools
Doc1, Documerge, Fileaid, Data Studio, HP Quality Center, MS Visio, Word, Excel, Prism
Domain
P & C Insurance, Health Insurance, Automobile, Manufacturing
Source Control
Web Source Safe, SCLM, Endeavour, ToolBox
CERTIFICATIONS/TRAININGS
INS21 & INS22 Domain Insurance Certification
Agile Level-1 Certification
PROFESSIONAL EXPERIENCE
Company Name: Syntelinc January 2016 – In Progress
Project Name
DTNA PVE Portal
Client
Daimler Trucks North America
Technology
Word, Excel, Java, Stored Procedures & Visio.
Duration
12 months
Role
Business System Analyst
Team Size
12
Responsibilities:
Attending initial meeting with stakeholders and Project Managers on identifying and documentation on the scope.
Using Questionnaire and setting up meeting to understand different issues faced by the teams and what can be achieved.
Understanding of system by checking the portal and its working.
Analyzes the feasibility and develop requirements. Ensures system design fits the needs of the users.
Setting up meeting with Business and Stake Holders on finalizing the requirements.
Going through the existing Java code to confirm with business.
Having query sessions with Business and getting inputs from other stakeholders.
Created different work flow diagrams such as Approvals and Process, in Visio based on the analysis and feedback from all stakeholders.
Created Use Cases and Business Requirement Documents (BRD) based on the sessions.
Participated in Project Planning and Risk Management activities.
Creation and Organization on data mapping for different systems.
Requirement Walkthroughs and Signoffs.
Updating Change Management document and estimating the changes.
Preparing Test Strategy and coming up with plans on different testing methods.
Preparing QA Test Plan based on the requirements and Use Cases.
Traceability document from Requirement gathering to the Test Plan.
Worked closely with DBAs on Stored Procedures and table Indexes.
Review and closing any issues coming out of Quality testing.
Support UAT for any issues or clarifications.
Project Description:
DTNA PVE Portal –Web portal for Engineering Work flow on Parts Ordering and Vehicle or Parts testing
Company Name: Syntelinc May 2015 – January 2016
Project Name
MBUSA VSD MSR Support
Client
Mercedes Benz USA
Technology
Cobol, DB2, Stored Procedures, Word and Excel.
Duration
9 months
Role
Business System Analyst
Team Size
10
Responsibilities:
Setting up meeting with Business and Stake Holders on finalizing the requirements.
Putting up queries to the Users to understand the scope of the requirement.
Actively includes getting requirement from business and going through the coded information in mainframe.
Having query sessions with Business and getting inputs from other stakeholders.
Created Technical document and other supporting documents.
Created system documents in Visio based on the requirement changes.
Coding, unit testing and implementation of modules/products.
Working with Java (Front End) team for any implementation of Stored Procedures or Cobol Programs.
Worked closely with DBAs on Stored Procedures and table Indexes.
Review and solving any issues coming out of Quality testing.
Supported QA Team and Front end Team for any issues or clarifications.
Project Description:
Vehicle Sales and Distribution System – Vehicle Ordering and Distribution of Vehicles
Company Name: Syntelinc February 2014 – April 2015
Project Name
Prop CoHo
Client
Allstate Insurance
Technology
Excel, Word, Cobol, DB2, HP Quality Center, Prism
Duration
15 months
Role
Business System Analyst
Team Size
30
Responsibilities:
Actively includes analysis of the requirements and procuring from client.
Held meeting with business partners to get proper input.
Handled multiple projects other than working as a Business Analyst
Created Project Plans, Publishing plan and allocation of projects
Weekly meeting with the client on Project status,
Allocated and assigned projects to multiple resources.
Create requirement documents and held meetings with the client.
Created Use Case Diagrams and Flow diagrams to get better understanding for the QA team.
Automated the mainframe data to be placed in the excel sheet.
Created Technical document and other supporting documents.
Review of Coded, unit tested components.
Supported Technical Team and QA Team for any issues or clarifications.
Actively involved in analyze includes verification of code in mainframes and the conditional table.
Delegation & allocation of work to the offshore resources.
Raise Issue/Risks.
Project Description:
Forms Management System – Development Project of converting of existing Documerge system to Exstream competent.
Company Name: Syntelinc June’ 2013 – To February’ 2014
Project Name
GHC Discover Phase
Client
Group Health Cooperative
Technology
Cobol, JCL, Datacom, Ideal, CICS, VSAM, Visio, Word, Excel
Duration
9 months
Role
Business System Analyst
Team Size
25
Responsibilities:
Actively involved in Estimation and Pre-analysis of the projects.
Created requirement documents and held meetings with the client.
Actively involved in analyze, preparation of System Diagrams, Technical design and problem solving activities in Mainframe.
Designing, coding and unit testing of code.
Review of the documents created while analyzing, designing, coding & testing.
Delegation & allocation of work to the Offshore resources.
Participating in Project meetings.
Raise Issue/Risks.
Project Description:
Claims System – ICD10 Compliant Project, Introducing Healthcare Products.
Company Name: Syntelinc January 2011 – To June 2013
Project Name
Customer Communication
Client
Allstate Insurance
Technology
Exstream, Unix, Cobol, JCL, DB2, CICS, VSAM, XML, Word, Excel, Prism, Visio
Duration
29 months
Role
Project Manager & System Analyst
Team Size
17
Responsibilities:
Actively involved in Estimation and Pre-analysis of the projects.
Create Project Plan, Project publishing, Risk Management and Mitigation Plans.
Created requirement documents, functional design, technical design documents & other supporting documents.
Conducted meetings with the stakeholders of the project.
Actively involved in analyze, preparation of System Diagrams, design and problem solving activities.
Review of the documents created while analyzing, designing, coding & testing.
Delegation & allocation of work to the team resources.
Participating in Project meetings.
Participate in deliverables.
Performs all responsibilities and resource commitments consistent with the project work plan
Raise Issue/Risks.
Project Description:
Forms Management System: Introduction of new products like AHH. Enhancement & Maintenance Project.
Company Name: Syntelinc February 2010 – To December 2010
Project Name
Enhanced Billing Communication
Client
Allstate Insurance
Technology
Exstream, Unix, Cobol, JCL, DB2, CICS, Documerge, VSAM, Doc1, Endeavor, Word, Excel, Visio
Duration
11 months
Role
Business System Analyst
Team Size
6
Responsibilities:
Started from the Initial Phase of procuring the project, by actively involved in estimation, designing, coding & testing, through implementation of the project.
Worked as a SME in the project.
Created System Diagrams, Designs for the project
Actively involved in the coding and testing, in relation to gap analysis and problem solving.
Allocating work to the team resources.
Participating in Project meetings.
Project Tracking and involved in quality deliverables.
Project Description:
Billing System: Enhancement to Mainframe code to connect with Exstream.
Company Name: Syntelinc August 2009 – To January 2010
Project Name
ADT Ralie Application
Client
Allstate Insurance
Technology
Cobol, JCL, DB2, Coolgen
Duration
6 months
Role
Programmer Analyst
Team Size
6
Responsibilities:
Participated in Design, Coding, and Testing in the project.
Delegation & allocation of work to the team resources.
Monitoring the job cycles & review was also considered.
Project Tracking and involved in quality deliverables.
Project Description:
Agent System: Rules Engine to provide commission & Brokerage for different areas.
Company Name: Syntelinc September 2005 – To July 2009
Project Name
Customer Information Document
Client
Allstate Insurance
Technology
Cobol, JCL, DB2, VSAM, Endeavor, Startool
Duration
4 years
Role
Programmer Trainee, Programmer Analyst
Team Size
8
Responsibilities:
Participated in Design, Coding, and Testing in the projects.
Review of work done in Design, Coding, and Testing in the projects.
Delegation & allocation of work to the team resources.
Monitoring the job cycles & review was also considered.
Project Tracking and involved in quality deliverables.
Project Description:
Forms Management System: Enhancement & Maintenance Project.
EDUCATION
Degree
Specialization
Month/Year Of Passing
College Name
University Name
Percentage / Grade
MCA
Computer Science
April 2004
Sri Ramakrishna Engg College
Bharathiar University
71.32%
BCom
Business of Commerce - Taxation
March 2000
N. G. Acharya and D. K. Marathe College of Commerce & Science, Chembur
Mumbai University
60.85%
I hereby declare that the information that I have furnished is authentic, and true to the best of my knowledge.
Melvin Vareed Tharail