Mamatha R Email and Phone Number

• Over 8+ years of professional experience in IT industry as Oracle SQL/PLSQL/ data modeling and Analysis, Design and Modeling.• Strong knowledge on oracle architecture and data base design.• Strong Data modeling experience using ER diagram, Dimensional data modeling, Logical/Physical Design, Star Schema modeling, Snow-flake modeling using tools like Erwin, ERStudio.• Good knowledge of Data modeling using ETL tools, LAP tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams• Excellent skills in designing and development of applications using Oracle, SQL,PL/SQL Good knowledge on Oracle tools like SQL * PLUS, PL/SQL, SQL and used TOAD in many development projects.• Experienced in all phases of Software Development Life Cycle (SDLC).• Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms.• Expertise in developing advanced PL/SQL code through various stored procedures, functions, cursors, triggers, packages and materialized views.• Experience in Bulk Data loading using Oracle utilities namely SQL* Loader and External Tables.• Expertise in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized Views and Troubleshooting Oracle database issues.• Working Knowledge on Unix and Windows.• Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader and UTL_File Utilities.• Developing reports using Informatica ETL tool.• Created Database constraints like Primary key and foreign key using RDBMS concepts.• In depth knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL,T-SQL using database tools like Toad, SQL Navigator.• Worked on Version Control Software.• Experienced in using Business intelligence tool OBIEE.• Expertise in Mathematical and Modeling and Numerical Analysis.• Excellent planning, analytical, written communication and Interpersonal skills.