BIRUNDHAVAN MURUGESAN

Role: Tech Lead
Dates of Employment: [Start Date] - [End Date]

• Procedure and Function Creation: Led the development of procedures, functions, triggers, and anonymous blocks for data validation, query analysis, and query optimization, ensuring high-quality and efficient database operations.
• Package and Cursor Management: Designed and implemented packages, table arrays, and reference cursors to streamline data processes and enhance application performance.
• Shell Script Development: Developed shell scripts to automate the execution of SQL scripts in a Linux environment, improving operational efficiency and reducing manual intervention.
• Data Insertion with SQL Loader: Managed data insertion processes using SQL Loader, ensuring accurate and efficient data migration and loading.
• Production Support: Provided robust production support, including ad-hoc query handling, manual script preparation based on customer needs, and ensuring overall system stability.
• Change Request Management: Created and deployed change requests (CRs), ensuring smooth and seamless implementation of database updates and modifications.
• Tablespace and Partition Maintenance: Conducted tablespace reclamation and partition maintenance to optimize storage utilization and enhance database performance.
• Scheduler Job and Report Generation: Maintained scheduler jobs and generated critical reports to support business operations and decision-making processes.
• Agile Methodologies: Adhered to Agile methodologies, managing project tasks and ensuring timely delivery of high-quality solutions.
• Task Management in Jira: Created and managed tasks in Jira, facilitating effective project tracking, collaboration, and transparency.
• Performance Tuning: Performed extensive performance tuning to improve database efficiency, reduce query response times, and enhance overall system performance.
• Yearly Maintenance: Executed yearly maintenance tasks, including password updates, to ensure database security, compliance, and optimal functionality.

• Procedure and Function Creation: Developed procedures, functions, triggers, and anonymous blocks for data validation, query analysis, and query optimization, ensuring efficient and reliable database operations.
• Package and Cursor Management: Created packages, table arrays, and reference cursors to streamline data processing and improve application performance.
• Shell Script Development: Developed shell scripts to automate the execution of SQL scripts in a Linux environment, enhancing operational efficiency and reducing manual workload.
• Data Export using UTL File: Created dump files in CSV format using UTL file, facilitating easy data export and sharing.
• Data Insertion with SQL Loader: Managed data insertion processes using SQL Loader, ensuring accurate and efficient data migration and loading.

• Expedition of Subscription: Oversaw the expedition of subscription processes in UAT and PRODUCTION environments to ensure timely and accurate data updates.
• High Materiality Feed Calculation: Performed high materiality feed calculations and conducted thorough regression testing to ensure data accuracy and system stability.
• Mismatch Analysis: Utilized UNIX scripts for mismatch analysis, identifying and resolving data discrepancies efficiently.
• Defect and Test Management: Used HP ALM for defect management and test execution management, ensuring comprehensive tracking and resolution of issues.
• Daily Status Calls: Participated in daily status calls with the onsite team to discuss task closure and project progress.
• Procedure and Function Creation: Developed anonymous blocks for validation, query analysis, and query optimization to enhance database performance and reliability.
• Data Insertion with SQL Loader: Managed data insertion processes using SQL Loader, ensuring accurate and efficient data loading.

• Agile Methodologies: Conducted analysis of specifications from customers and modified programs to meet their needs, ensuring alignment with Agile methodologies.
• Stored Procedures and Functions: Created stored procedures, functions, and packages using cursors, ref cursors, and PL/SQL tables in Oracle 11g RDBMS, enhancing database functionality and performance.
• SQL Performance Tuning: Performed SQL performance tuning to optimize query execution and improve system efficiency.
• Cassandra Database Management: Created keyspaces, tables, primary keys, partition keys, and clustering columns in Cassandra, ensuring efficient data storage and retrieval.
• Testing and Debugging: Conducted thorough testing and debugging to ensure the accuracy and reliability of database applications.
• Jira Management: Entered login hours in Jira for each sprint according to estimated points, ensuring accurate tracking and reporting of project progress.