Description
PROFESSIONAL SUMMARY: * Over 8 years of experience in Oracle database development. * Experience with SDLC process using waterfall and agile methodologies. * Experience in analyzing source systems, understanding business requirements and documenting technical specifications. * Expertise in developing PL SQL stored procedures, functions, packages and usage of collections. * Experience in usage of Explain_plan, Tkprof to look for database bottlenecks and improve performance. * Performance improvements in Procedures using bulk collect and for all clauses. * Experience in aggregation using rollup, hierarchies using connect by prior clauses. * Excellent understanding of latest concepts such as partitioning, swap partitions, Index organized tables. * Extensive usage of ETL tools like Informatica Power Center, IBM Datastage, Oracle data intergrator (ODI), SQL*Loader. * Expertise in Oracle Forms and Reports, also with migration of applications from older versions. * Experience in developing Entity Relationship diagrams/Dimensional Diagrams as per business requirements using ERWIN. * Expertise in Oracle Application Express (APEX). * Experience in building and maintaining of materialized views and usage with full and incremental refresh. * Experience in agile software development methodologies using Scrum. * Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance. * Expertise in loading data from legacy systems using SQL*Loader. * Experience in front end development using oracle forms/reports6i/9i/10g. * Experience in developing forms based on views, tables and procedures in tabular and form layouts. * Experience in developing both web layout and paper lay out reports in various styles based on the user requirements. * Extensively worked with third party database tools like TOAD & PL/SQL Developer. * Good in creating users and maintaining their roles and responsibilities. * Experience in writing Technical design documents and developing unit test documents. * Experience with coding in Core Java, JSP & Servlets and HTML. * Good interpersonal skills and ability to work independently and to work with teams.
Accomplishments
Highlights:
Keywords
