Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Languages
Timeline
Generic

Thanigaivel Selvaraj

Troy,MI

Summary

Highly adaptable professional with 15 years of experience in mainframe ZOS DB administration across multiple industries including automotive, banking, finance, and insurance. Proven expertise in problem-solving, prioritization, and leadership. Seeking challenging assignments in an environment that promotes personal and professional growth. Excited about contributing effectively to the goals of a reputable organization, particularly in the role of Database Administrator. Possessing a strong background in RDBMS concepts, logical and physical database design, and capacity planning, I have successfully managed database migration, performance monitoring, security, troubleshooting, backup, and data recovery. Proficient in using ER-Studio and Power Designer as well as BMC, IBM, and CA tools for database maintenance. Skilled in database design, creation, tuning, stored procedure development, SQL query development and tuning, and application tuning through monitoring and third-party tools. Additionally, I have extensive knowledge of configuring and maintaining large data sharing IMS and DB2 systems. With a solid understanding of SDLC in both waterfall and agile methodologies, I am well-versed in using various third-party tools from IBM, BMC, CA, and NEON. Furthermore, I possess strong analytical skills with a fast learning curve and the ability to work on multiple projects simultaneously while ensuring adherence to SLAs.

Transitioning from fast-paced consulting environment, with focus on leveraging technical expertise and strategic problem-solving skills. Developed proficiency in managing client relationships and delivering tailored technological solutions. Seeking new opportunities to apply analytical capabilities and project management skills in different field.

Overview

18
18
years of professional experience
1
1
Certification

Work History

LEAD DATABASE ADMIN, TECHNICAL CONSULTANT

HTC Global Services INC
11.2012 - Current
    • Company Overview: Client: State Farm Insurance, Central Illinois
    • I am working as an Application support DBA for the Billing and payments and as a System support DBA for the performance monitoring and improvement at Data warehouse team
    • Major teams and their Projects supported at Billing and Payments:
    • Credit card: On-platform web services and screens to process card payments from all on-line payments sources through tokenization vendor and Card network vendor to authorize or decline card payments
    • Merchant Card Processing: We support the tokenization and authorization of Debit and credit card payments for all insurance lines
    • Common Payment Processing: Payment processing services is a collection of services that takes acquisition and renewal premium payment transaction, prepares it for the settlement and stores it in a master data store
    • Internal cash: Host screens and jobs to process premium payment for all payment sources, update ledger and policy master records of payment receipt
    • State Farm Billing solutions: This project receives acquisition and servicing transactions from Business lines and personal lines policy administration systems and Sends them to SF Billing solution
    • Statefarm Account's Billing Management: This projects manages the automated payments process for a customer's SF billing account
    • Billing and Payments User Interface: Screens, web services and on-platform Databases for the manual entry of renewal payments to the Mejesco Billing product and storage of all payment transactions
    • System Support DBA at Data warehouse team: The data warehouse team is responsible for the availability of the whole data warehouse, including, the data marts, reports, researches, acquires and supports data visualization and reporting tools
    • Client: State Farm Insurance, Central Illinois
    • Managed multiple projects simultaneously while prioritizing deadlines effectively under pressure through meticulous organization skills and time management.
    • Enhanced system performance by identifying and resolving technical issues through troubleshooting and root cause analysis.
    • Facilitated knowledge transfer among team members by leading training sessions on new tools, techniques, or industry best practices relevant to the role of Technical Consultant.

IT SPECIALIST – DATABASE ANALYST III

FIS Global Business Solutions India Private Limited
12.2010 - 07.2012
  • Company Overview: FIS' risk management and reporting solutions can help you minimize liquidity risk for better management of the balance sheet
  • Monitoring, analyzing, detecting and preventing financial crimes are regulatory requirements, with expectations that a robust system be in place based on the institution's risk profile
  • Involved in a POC that compares the CA, BMC and IBM utilities execution stats and performance to achieve the database maintenance
  • Performance tuning for business-critical PPO application for DB2 DYNAMIC SQL using CA INSIGHT
  • Restructured the process for LOAD jobs for the very large DB2 databases
  • FIS' risk management and reporting solutions can help you minimize liquidity risk for better management of the balance sheet

SENIOR DATABASE ANALYST

Inautix Technologies India Private Limited
02.2007 - 12.2010
  • Company Overview: Pershing Brokerage is an International provider of financial services and investment resources
  • Production Database Space Estimation Report: This Space estimation report is generated for production database objects for both Partitioned and Non-Partitioned Tablespaces and Indexspaces
  • Recurring REORG objects for past 8 weeks Report: The report is used to find objects been reorged more than once in the past 8 weeks
  • Pershing Brokerage is an International provider of financial services and investment resources
  • Maintained up-to-date documentation on database structures, procedures, and user guides for efficient knowledge sharing among team members.
  • Optimized query performance through proper indexing strategies resulting in faster response times from applications.
  • Conducted thorough analysis of existing databases, identifying areas for improvement and recommending necessary changes.

Education

Bachelor in Engineering - ECE

Anna University
Chennai India

Skills

  • COBOL
  • JCL
  • JAVA
  • Zos
  • Windows
  • TSO
  • ISPF
  • RACF
  • SDSF
  • DB2 for Zos
  • DB2 for LUW
  • MongoDB
  • IBM DB2 Admin tools
  • IMS Connect
  • IBM Data Studio
  • IBM Log analysis tool
  • IBM DB2 SQL Analyzer
  • IBM Query Monitor
  • IBM Data Visualization manager
  • BMC Catalog manager
  • BMC Change manager
  • DASD manager
  • Log master
  • Change Accum
  • Recovery Manager
  • Apptune
  • Mainview CA RC/update
  • CA log analyzer
  • CA detector
  • CA insight
  • QMF
  • Omegamon
  • IBM Utilities for DB2
  • IBM Utilities for IMS
  • BMC Utilities for DB2
  • BMC Utilities for IMS
  • XML
  • Java Virtual Machines
  • Database systems
  • Agile
  • Waterfall
  • REXX
  • CICS
  • EAZYTRIVE
  • Technical consulting
  • Technical guidance
  • Project management
  • IT infrastructure planning
  • Proficient in IBM, BMC and CA utilities

Accomplishments

  • Optimized existing procedures to improve performance by 87%.
  • Created a consolidated database to improve efficiency by 39%.
  • Obtained $[Number] in annual savings by designing [Process].
  • Tested databases to identify and resolve [Issue].
  • Automated processes to reduce workflow by [Number] hours.
  • Collaborated with team of [Number] in the development of [Project name].

Certification

  • IBM CERTIFIED DB2 DBA FOR DB2 V9 AND V10
  • IBM DB2 FOR Zos V12.1 DATABASE ADMINISTRATOR

Languages

English
Full Professional
Tamil
Native or Bilingual

Timeline

LEAD DATABASE ADMIN, TECHNICAL CONSULTANT

HTC Global Services INC
11.2012 - Current

IT SPECIALIST – DATABASE ANALYST III

FIS Global Business Solutions India Private Limited
12.2010 - 07.2012

SENIOR DATABASE ANALYST

Inautix Technologies India Private Limited
02.2007 - 12.2010

Bachelor in Engineering - ECE

Anna University

Similar Profiles

CREATE PROFILE
Thanigaivel Selvaraj