Senthil Thavamani

Experience

• 

  Western Data Systems

  Jan 1996 - Jan 1997

  Programmer / Analyst

  I worked with Compass Contract - a complete integrated MRP-II system specifically designed for the aerospace industry. The system was re-engineered from MF-COBOL under Unix to Oracle 7.3 on HP-UX 10.01. Involved in conversion and redesigning of COBOL system. • Developed complicated forms which require dynamic SQL to enforce business rules for Attachment Module. • Developed functions procedures and packages in PL/SQL (2.3) for Work Order Module.• Used PL/SQL tables to implement the multidimensional arrays of COBOL. • Used DBMS-PIPE to trap and handle errors / exceptions. Object oriented PL/SQL package design. Show less

• 

  Resort Computer Corporation (RCC)

  Jan 1997 - Jan 1997

  Programmer / Analyst

  I developed forms for RCC - Premier (the Club Module) which consisted of Clubs, Reservations, Contracts, etc. modules. Involved in unit test of forms, triggers and procedures.• Worked with multiple complicated forms, such as Maintain Members and Membership Processing.• Designed and developed packages and triggers in PL/SQL (2.3) for processing assessments, allotments and transfers.

• 

  Mastech Digital

  Jan 1997 - Dec 2002

  Software Consultant

  Designed, developed, tested, implemented and maintained various modules to track pilot and mechanic qualifications, work orders, labor time, inventory. Descriptions of modules as listed below:• Pilot Qualifications, Mechanic Qualification and Pilot Times modules in complete SDLC.• Automated Maintenance System (AMS), including work order and labor collection modules (SDLC). • Interfaced all above systems with HR Payroll and GOLD systems and loaded data from mainframe to new ORACLE database. • Inventory Accounting (GOLD) System. • Designed and developed various Inventory Reports from GOLD/Inventory database.• Played a significant role in design and development of Pilot Scheduling, and helped with training, customer support, and DBA activities.• Maintained Oracle EBS – HRMS and developed Forms and Reports for HRMS. Show less

• 

  PHI Inc

  Dec 2002 - Feb 2018

  As a database and Unix administrator, maintained all Unix AIX servers and all production and test databases. • Maintained all Oracle and SQL Server databases.• Managed all Unix and Linux servers and Dell Storage System.• Altered memory variables, optimized Storages, and tuned all production databases for better performance. • Recovered data using RMAN, PL/SQL developer tools and cloned databases with Dell-Compellent replays/storage replications.• Maintained Change Requests, provided statistics of servers, databases and users to auditors for SOX complient.• Used customized ETL tools to load periodical Vendor Price.• Refreshed Test and Development databases very often.• Tuned complex queries and processes.• Maintained Service Level Agreements (SLA).• Handled Change Requests applicable to all Oracle Databases and Unix Servers and implemented. Show less Designed, developed, tested, implemented and maintained projects as follows: • Administered aviation application Ramco with a technical team serving abroad.• Maintained Accounting / payroll system Lawson and enabled interfaces with many other systems.• Derived logics and prepared specifications for User-Requirements explained to Developers.• Frequently tuned and applied patches to Ramco and Lawson applications, Oracle Databases, Unix Servers and other needed tools.• Electronic Flight Bag (EFB) package, including a “Weight and Balances” module to assist pilots in arranging passengers and luggage to ensure a balanced helicopter. (This replaced handheld calculators.) • Served on Ramco Implementation Team and guided development and creation of reports. • Migrated data from old system “GOLD” to new system “Ramco”.• Integrated all major systems and also with other sub-systems.• Maintained projects and handled their issues using Atalassian JIRA. Show less

  • Database and Unix Administrator

    Mar 2013 - Feb 2018

  • Senior System Analyst

    Dec 2002 - Mar 2013
• 

  ATAC

  Mar 2018 - Feb 2019

  Technical Consultant

  During Aviation ERP implementation, installed Aviation ERP software in Test, Migration and Production servers. • Installed and maintained all (Production, Migration and Test) databases.• Installed the whole ERP software in 3 tier environment Web, Application and Database servers.• Tuned codes, optimized Storages, and tuned all test and production databases for better performance. • Involved in Interfacing this ERP software with Finance Package with Oracle database.• Scheduled and maintained all needed jobs for this ERP Application.• Took care of Backup Schedules and maintained all backups.• Collected and prepared data and loaded using ETL & MDCF tools.• Traced and debugged stored procedures of transactions using Profiler.• As part of this implementation, defined business parameters to suite current client.• Maintained Issue Tracking System (Atlassian JIRA) for this implementation. Show less

• 

  McIlhenny Company

  Feb 2019 - Mar 2019

  DBA Trainer

  Trained an entry level database admin and Unix admin to administer Oracle Databases and to handle all DBA activities.• Taught them about User Objects, Database Objects.• Recovered test database using RMAN• Compared objects of two different versions to inform developers about new object changes.• Setup roles for admins and developers.• Analyzed AWR reports; Tuned complex queries.

• 

  Erickson Incorporated

  Apr 2019 - Apr 2020

  Technical Consultant

  During Aviation ERP implementation, installed Aviation ERP software in Test and Migration servers. • Installed the whole ERP software in 3 tier architecture - environment Web, Application and Database servers.• Collected and prepared data and loaded using ETL & MDCF tools.• Took care of data upload in a specific sequence.• To interface with multiple systems, had series of discussions and prepared Integration Documents (ICD).• Scheduled and maintained all needed jobs for this ERP Application.• Took care of Backup Schedules and maintained all backups.• Refreshed Test databases with Data migration databases.• Traced and debugged stored procedures of transactions using Profiler.• As part of this implementation, defined business parameters to suite current client.• Maintained Issue Tracking System (Atlassian JIRA) for this implementation. Show less

• 

  CGI Federal Inc

  Apr 2020 - now

  Cloud DBA

  Maintained PROD, TEST and Standby databases and prepared technical guide for Azure SQL database. • Monitored all PROD, TEST and Standby Oracle databases.• Provided Storage recommendations and implemented them in Production and Test database servers.• Refreshed Test and UAT databases from Production.• Applied Oracle Patches in Azure servers.• Enabled and disabled Standby Database in Disaster Recovery server.• Obtained various Security Approvals from clients.• Prepared documentation on Azure SQL database pricing model.• Prepared Azure SQL database architecture and O&M guide. Show less

• 

  PHI Aviation

  Oct 2020 - now

  Technical Consultant

  Currently assisting with an upgrade of an Aviation software - Ramco.• Uploaded periodical vendor price using PL SQL scripts.• Extracted data from Oracle database to upload the upgraded system.• Maintained all Production and Test databases in AIX Unix servers.• Monitored Unix based applications and Unix servers.• Analyzed storage requirements of all production and test servers.• Replicated Production databases to Test servers.• Developed SSRS Reports• Maintaining Workflow for various functional areas.• Generating Audit reports from Aviation and HR-Payroll databases.• Coordinating Ramco Offshore team for deploying patches.• Administrating Ramco Users accounts and Roles. Show less