Developed Data Analysis for Erwin Logical and Physical model design, Oracle (PL SQL packages, triggers) development, UAT for Oracle objects (Tables, MVs, Views).Designed Conceptual Model as an architectural migration target for new LRT ODS model and redesigned the key structures of the Data Warehouse (tables, MVs, Indexes).With architects, assisted in development of current and target LRT data architectures.Actively involved in colleting, analyzing, reviewing and documenting business requirements from the client (EPA) and created tickets if more reviews are required.Data updates was to be visible within 24 hours such that business users and public can access the most accurate information/data to make timely and informed decisions. The Environmental Protection Agency project objective is to re-engineer the existing Facility Registry Systems (FRS) so as to have Locational Reference Tables (LRT)- Data Warehouse that has real time data. INDUS is an IT solutions company to Federal Civilian, Homeland Security, Defense and Intelligence organizations based in Vienna, VA. UCM: SOURCE FORGE, MKS INTEGRITY, CLEARCASE, LANGUAGES: PL/SQL, SQL, JAVA,HTML, BOURNE SHELL, K SHELLĭATABASE TOOLS: ERWIN 10, MS VISIO, TOAD, SQL NAVIGATOR,īI TOOLS: CRYSTAL REPORTS XI/10i, BO XI R2/6.1X, COGNOS 7/8. RDBMS: ORACLE 10G/9I, MySQL, DB2, HPX, MS ACCESS Developed approaches and frameworks for the enhancement of data quality and integrity.Involved in Performance tuning, database monitoring and Capacity Planning, SQL Tuning using optimization ( Analyze, Explain Plan, TKPROF), snapshots, data archiving, Hints, table Partitioning and Indexes.In-depth knowledge of PL/SQL with the experience in constructing the triggers, tables, collections, functions, collections, user defined datatype, procedures etc.Experienced in ETL, data transformation, conversion and interface.
#Oracle database modeling tools software#
In-depth knowledgeof Software Development Lifecycle (SDLC) and AGILE software development methodologies adhering to best practices and industry standards.Experience in developing DDL scripts to create and alter Oracle Objects and upgrades.Expertise in development, care, and maintenance of logical and physical ERWin data models, along with corresponding metadata.Dimensional Modeling (Data Marts, Facts and Dimensions) in both Star Schema and Snowflake Dimensional modeling using Erwin.
#Oracle database modeling tools professional#
0 kommentar(er)
