Manimegalai Kumar

working as a software developer

Over 10+ years of experience as an Oracle PL/SQL Developer in the IT industry, with a strong background in software analysis, design, development, testing, and implementation. Proven expertise across the Retail and Banking domains.

• Experienced in both Waterfall and Agile software development methodologies.
• Proficient in utilizing Cursors and Bulk data processing techniques, including Bulk Collect and "FOR ALL" with records in Oracle PL/SQL.
• Specialized in creating database objects such as Packages, Procedures, Functions, Triggers, Tables, Views, and Synonyms using SQL and PL/SQL across Oracle versions 10g, 11g, 12c, and 19c, with expertise in data transformation.
• Well-versed in data loading into Oracle Tables using SQL *Loader and the UTL_FILE package.
•  Strong understanding of key Oracle performance optimization features, including Query Optimizer, Execution Plans, and Indexes.
• Expert knowledge in dimensional modeling, Star Schema modeling, Snowflake modeling, fact and dimension table design, physical and logical Data modeling using Erwin 3.5, Toad Data Modeler.
• Extensive knowledge of various table constraints in Oracle.
• Proficient in developing and optimizing PL/SQL procedures, functions, triggers, and packages to streamline business logic execution.
• Experience in performance tuning and query optimization using hints, partitioning, bulk processing techniques, and indexing strategies.
• Expertise in ETL processes involving large datasets, including XML parsing and loading into Oracle using Oracle XML Packages.
• Proficient in using tools like SQL*Plus, SQL Developer, and TOAD.
• Strong data modeling, database design, data migration, and business intelligence expertise.
• Solid understanding of core banking applications and their functionalities.
• Experience in enforcing database security through role-based access control, profiles, and privilege assignments.
• Hands-on experience in migration and conversion from Flat Files, MS Access, SQL Server, Ab Initio, and Sybase to Oracle using SQL*Loader.
• Developed and maintained complex stored procedures and functions to support application logic and data workflows.
• Created shell scripts for database connectivity and automated SQL package execution in UNIX environments.
• Involved in reviewing functional requirements, performing gap analysis, and creating technical documents and test case documentation.
• Managed lower environments, conducting daily health checks, data refresh activities, and issue resolution.
• Ownership of governance processes through BCR, MCR, and task record creation for lower environment management.
• Modified and updated customer billing cycle details via backend operations using OBRM tools.
• Experience with code deployment processes in production servers using Oracle TOAD 11g.
• Updating and modifying the database through SQL queries in the backend using Oracle TOAD 11g, with involvement in code deployment to production servers during release cycles.
• Working with Siebel application to resolve the customer queries.
• Delivered programming and analytical support for existing Oracle Forms and Reports applications, contributing to implementation, enhancements, and client-driven change requests.
• Utilized Oracle Business Intelligence (OBI) to generate reports tailored to user requirements, leveraging strong analytical and problem-solving abilities alongside excellent interpersonal and communication skills.

Bechelor degree in information Technology