Revathi Munusamy
Mississauga,Canada
Summary
Highly driven and qualified professional with 12 years of programming experience in IT Software development and Team Management with that 9 years of experience in Oracle PL/SQL and 3 years in T SQL in the Mutual Fund domain. Capable of playing multiple roles within an organization/project with strong business knowledge.
Overview
13
13
years of professional experience
Work History
Technology Lead PL/SQL
Synechron
10.2023 - Current
- Led the analysis and interpretation of complex business requirements through stakeholder collaboration, ensuring seamless translation into technical specifications.
- Designed and developed advanced PL/SQL solutions including complex queries, stored procedures, functions, and views to support critical business applications and data workflows.
- Spearheaded performance tuning initiatives using tools like EXPLAIN PLAN, and implemented indexing strategies to enhance database performance and scalability.
- Directed the automation of batch jobs using Autosys JIL commands, optimizing job scheduling and reducing manual intervention.
- Oversaw and participate in unit, system, and integration testing, ensuring code quality, performance, and alignment with business requirements.
- Collaborated with clients during User Acceptance Testing (UAT) to validate functionality and incorporate feedback into final deliverables.
- Provided leadership in post-production support, proactively monitoring systems, resolving issues, and ensuring data integrity across environments.
Development Lead PL/SQL
Sterling Software Private Limited
05.2022 - 09.2022
- Led client meetings to gather requirements, address queries, and provide technical guidance, ensuring clear communication and efficient issue resolution.
- Played a key role in debugging stored procedures, functions, and performing performance tuning in Oracle PL/SQL to enhance efficiency and resolve critical issues.
- Conducted data analysis to identify and evaluate the impact of requirement changes on database objects, collaborating with developers to ensure seamless integration into the project.
- Managed and ensured timely updates to essential project documentation, including understanding documents, test cases, code reviews, and change summaries, to ensure quality and compliance with project standards.
- Oversaw peer testing of tasks before delivery, ensuring thorough validation and adherence to business requirements.
- Led data migration efforts using the ETL process, ensuring smooth transfer and transformation of data across systems while maintaining data integrity.
- Designed and developed database models using star and snowflake schemas for data warehousing and analytical reporting solutions.
Senior Software Developer
Sterling Software Private Limited
10.2017 - 04.2022
- Involved in all phases of SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
- Used Stored Procedures to dynamically retrieve data based on user selection.
- Involved in performance fine tuning by creating indexes and gather statistics and query optimization.
- Played a key resource in the team and awarded as star of the quarter for continuous performance.
- Used GIT for version control, ensuring efficient code management, collaboration, and smooth integration across multiple developers and environments.
- Used Views, Materialized Views and created WITH Clause while forming a query.
Software Developer
Sterling Software Private Limited
12.2015 - 09.2017
- Involved in table creation, indexes and constraints based on the business requirements, ensuring data integrity and performance.
- Developed database objects like Stored Procedures, Functions, Packages and Triggers.
- Worked extensively on Cursor, External Tables, Bind variables and Collections.
- Expertise in Dynamic SQL, Collections and Exception handling. Used Bulk Collections for better performance and easy retrieval.
- Necessary Documents (Test cases, Code Review, Change summary) need to be created while completion of the task.
Software Developer
Precept Management Consultants
01.2013 - 11.2015
- Involved in Live ERP Web application Project as well as windows project.
- Created Web Forms and handled client validation using Java Script.
- Worked in .NET, Crystal Reports and T-SQL.
Education
B.Tech - Information Technology
Dhanalakshmi College of Engineering
Chennai, India05.2011
Skills
- PL/SQL, T-SQL, SQL, C#, VBNET, WPF, HTML, CSS, Java Script, Unix, Jil
- PLSQL Developer, Oracle 11g/12c, Sql Server 2012, Crystal Reports, Informatica, Visual studio 2010/2017, Stimulsoft
- Git, Jira
- Effective multitasking
- Strong Planning and Time Management skills
- Excellent Debugging Skills
Languages
English
Timeline
Technology Lead PL/SQL
Synechron
10.2023 - Current
Development Lead PL/SQL
Sterling Software Private Limited
05.2022 - 09.2022
Senior Software Developer
Sterling Software Private Limited
10.2017 - 04.2022
Software Developer
Sterling Software Private Limited
12.2015 - 09.2017
Software Developer
Precept Management Consultants
01.2013 - 11.2015
B.Tech - Information Technology
Dhanalakshmi College of Engineering