Sangeerthana Shanmugasundaram
E-mail: **************@*****.***
Phone: +91-897-***-****
Profile Summary
A proficient software engineer with 3.5 years of technical expertise in developing and maintaining business/mission critical applications in the Banking and Insurance domains.
Fields of expertise include Data Analysis, Relational Database and Mainframe development
Security, Compliance and GDPR implementation to comply with regulations of the Financial sector.
Operations and management of multiple business critical mainframe environments. Technical Experience
Expertise Business, Technical and Data Analysis
Database DB2, MySQL
Programming Languages COBOL, JCL, PL1, REXX, CLIST, EGL, VB scripting Tools TSO/ISPF, Endevor, IBM utilities, IMS utilities, File-aid, VSAM, SPUFI, IBM Websphere MQ, IBM Infosphere Optim, ESP Workstation, FTP, sFTP protocol, SoapUI, DB Visualizer, Microsoft Visio, BMC remedy, JIRA, Rational tools – RDZ, RBD, RTC, QMF, Query Analyser, . Web Service WSDL
Professional Trainings Mainframe – Batch & CICS
Process and
Methodology
Agile software development, Scrum master
Work Experience
Danske IT and Support Services
Duration Oct’17 till present
Projects General Data Protection Regulation (GDPR) Project Description To architect and implement GDPR to preserve data privacy of customers, provide customer data insight and to comply with EU’s directive Role Developer, Scrum master
Responsibilities
Business, Technical and Data Analysis
Architect and design solutions for various use-cases
Developed the entire application, performed unit, integrationand system testing using agile methodology.
Facilitate sprint processes and collaborate with the team, product owner and as Scrum Master.
Setup IBM WebSphere MQ for z/OS and developed the application to publishor subscribe messages to the MQ.
Apply data retention and erasure policies to manage data of expired/unused customers
Data lifecycle management, governance, archiving and consolidation using IBM Infosphere Optim.
Cognizant Technology Solutions
Client Liberty Mutual Insurance
Duration Oct’14 – Oct’17
Projects Billing System, Policy Writing System
Project Description The Application handles all the Billing and Payment functionalities for multiple product lines of Liberty Mutual Insurance. Role Developer & Technical support analyst
Responsibilities
Development
Working with key stake holders from clients to gather requirements, architect and deliver the solution
Unit, System, Integration and Performance testing of the solutions implemented
Majority of the development was done using COBOL & DB2, PL1 Mainframe Deployment
Maintained and supported 13 mainframe environments.
Deployment of the environments to facilitate monthly release testing.
Code deployment and data setup across all 13 regions. o This includes JCLs, Loadlibs, Bind, Files, WSDL, CICS online programs, online load refresh (new copy), pipeline refresh.
Well versed in generating the provider WSDLs/requester copybook using batch utility and refreshing the CICS pipelines.
Used TSO/ISPF utilities to create and Maintain PDS, PS, etc. and to monitor Spools and migrate files between different LPARs.
Database Management
Involved in data copy across all the non-production environments - Data copy involves copying the data from production to lower environments using various IBM utilities such as Optim utility, DSNUTILB, IKJEFT01. Post data copy masked the sensitive data such as bank info and customer details.
Well versed in DB2 Plan, Packages, Collid, DB2 relationships, referential integrity, SYSIBM system tables (SYSPACKAGE, SYSTABLES, SYSCOLUMNS, SYSPACKLIST, SYSPLAN, etc.)
Experienced in handling COBOL DB2 Bind issues.
Experienced in Database Recovery, Log mark and image copy process.
Worked with DB2 commands to play around the database and tablespaces, Repair the status of tables.
Batch Execution
Managed daily Batch execution in both production and Non-Production Environments.
Monitored using ESP Workstation and BMC Remedy, analysis of abend and resolving them with focus on SLA
Root Cause Analysis to identify the cause of issues in the Production/Test environments and provided work arounds/bug fixes.
Co-ordination of Testing
Supported batch/online business testing across 13 non-production regions
(QA/Dev/Integration/Performance/UAT), as part of monthly release business testing.
Actively coordinated with DBAs, CICS tech support team, business testers and across multiple application owners during any kind of issues and maintained the application availability for business testing.
Worked with business users on their special requirements for testing - analyzing and recommending an approach to experiment complex requirements. Value-Adds Proposed and Implemented
Identified standard tasks with recurring patterns and automated them using Rexx/Cobol/JCL reducing manual labor and people process issues.
Developed Macros using VB Scripts for non-technical Business users to automate mainframe related tasks.
Involved in Continual Service and Process Improvement - reducing the production bugs, improving code quality and shape future releases of the software. Academic Qualifications
B.E Computer Science from Park College of Engineering and Technology, Coimbatore (2010
– 2014).
Class 12 from Adwaith G.N.S Matric Higher Secondary School in 2010 with 93%.
Class 10 from Adwaith G.N.S Matric Higher Secondary School in 2008 with 91%. Personal Details
Date of Birth : 07 Apr 1993
Marital Status : Single
Languages Known : English and Tamil
Nationality : Indian
I hereby declare that above furnished details are true and precise to my knowledge. Sangeerthana