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.
