Birundhavan Murugesan

• Investigated system issues and implemented resolutions to reduce downtime.
• Evaluated and adopted new technologies to address changing industry needs.
• Designed support structure needed to confirm scalable application rollouts.
• Defined parameters for API and data acquisitions.
• Expertise in SQL, stored procedures, functions, packages using cursors,GTT, Pl/Sql Tables.
• Good experience in over loading the Procedures and Functions.
• Expertise in creating and managing Tables, Triggers, Views,Synonyms and Sequence.
• Strong experience in Performance tuning .
• Expertise in creating and managing keyspace, tables, primarykey and partition clustering columns in Cassandra.
• Experienced in data load by feed processing in all layers of data warehouse.
• Experienced in UNIX script.

• Determined areas for improvement and implemented processes to alleviate problems.
• Analyzed problematic areas to provide recommendations and solutions.
• Closely monitored and updated company systems for efficiency, output and other factors to improve overall productivity.
• Developed custom solutions based upon clients' strict requirements.
• Create procedure, functions, trigers , ananymous block for validation, query analysis, Query optimisaztion
• Create packages, Table arrays,Ref cursors
• Create shelscript to run sql scripts in linux.
• Creat dump file csv format by using UTL file
• Data isnertion using SQL loader.

• Led software development initiative as subject matter expert and primary point-of-contact for project management staff.
• Worked with project managers, developers, quality assurance and customers to resolve technical issues.
• Checked client code for bugs and weaknesses using approved troubleshooting methods.
• Trained and mentored junior developers and engineers, teaching skills in Database and working to improve overall team performance.
• Genesis Retail Data migration using Hadoop(HDFS),Hive,Spark and Memsql
• Expedition of subscription in UAT and PRODUCTION environment
• High materiality feed calculation and doing Regression Testing.
• Mismatch analysis using UNIX script.
• Use HP ALM for defect Management and Test Execution Management.
• Participate the daily status call with Onsite team for Task closure.
• Create ananymous block for validation, query analysis, Query optimisaztion
• Data isnertion using SQL loader.

• Led software development initiative as subject matter expert and primary point-of-contact for project management staff.
• Worked with project managers, developers, quality assurance and customers to resolve technical issues.
• Checked client code for bugs and weaknesses using approved troubleshooting methods.
• Trained and mentored junior developers and engineers, teaching skills in SQL/PLSQL and working to improve overall team performance.
• Based on Agile Methodologies analysis of the specification from customer and modifying the program to satisfy customer needs.
• Created stored procedures,Functions,and Packages using Cursors,Refcursors,Pl/Sql tables in oracle 11g RDBMS
• SQL performance tuning .
• Created key space, tables, primary key , Partition key clusteringcolumnsin Cassandra
• Testing and debugging.
• Entering login hours in jira for each sprints as per estimated points

• Tested programs and databases to identify issues and make necessary modifications.
• Designed, developed, and implemented software applications for website based on analyzed requirements and understanding of industry technical standards.
• Collaborated on stages of systems development lifecycle from requirement gathering to production releases.
• Revised, modularized and updated old code bases to modern development standards, reducing operating costs, and improving functionality.

 Business Requirement analysis and Functional requirement analysis.
 Technical Document preparation.
 Created database triggers for inventory management.
 Designing and Writing SQL queries stored procedures, Functions and Packages.