Description
Professional Summary: * Eleven years of extensive professional IT programming experience as an Oracle PL/SQL Developer, Data Analysis, Design, Coding, Reporting, Database modeling, ETL Data Modeling, Maintenance, Testing, Documentation and Implementation of Business Applications. * Experience on REST services, Message Queues. * Experience in core Java. * Experience in the creation and maintenance of scripts (SQL Plus/KSH) used in database change management, MySQL to Oracle migrations, and schema setup. * Expert in creating Business reports, parameterized reports and in designing report layout using oracle reports. * Experienced on installing oracle, creating database, creating directory, users, roles, grants, table spaces, partitioning in oracle. Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) and other DB objects. * Experienced in transforming complex business requirements from customer into development plan by using objects like Stored Procedures, Functions, Packages and Triggers to support Agile development. Good experience in using PLSQL Collections. * Gather, analyze, summarize database information and prepare recommendations towards SOX initiative within organization. * Experience in performance tuning for Oracle RDBMS using Explain Plan and HINTS. Performance tuning knowledge in SQL and PLSQL by using explain plan and row source operations to identify bottlenecks in queries and remediate them. Experience in using HPROF for PLSQL code performance. * Experience in leading a team 4, while still performing database development duties. * Ability to work independently and drive tasks to completion.