codesdanax.blogg.se - Toad data modeler resume

Toad data modeler resume software#
Toad data modeler resume code#

Toad data modeler resume code#

Involved in implementing the DDL scripts in the Development, Testing Environment and moving code to production environments.

Carried out Reverse Engineering of the source database, attached naming standards, data domains and Complete comparing the two models to identify the differences.

Involved in reviewing the model with Peer review team.

Involved in reviewing the model with the project team and product owner, LDDM Lead Division Data Modeler and getting approval from LDDM.

Designed the ILDM Implementation Logical Data Model and ELDM Enterprise Logical Data Model packet for the projects and Enterprise respectively.

Designed the LDM and PDM models using Erwin 8.5 data modeling tools for Order Provisioning System, Data warehouse project Star Schema.

Involved in JAD sessions with the Business Analyst, Subject matter expert, Product Owners and Application Team in gathering Business Requirements.

Rapid SQL 7.x,Toad, Putty, SSH, Ultra edit, FileZilla FTP client.

Erwin 7.x, Erwin 8.x, Power designer, UML, ER studio, Visio, Toad Data Modeler, Oracle Designer, Embarcadero.

Excellent problem solving and communication skills.

Experience in performance optimization at Database level for SQL and PL-SQL scripts.

Experience in Relational, XML, DTD, XML Schemas in Oracle 11g/10g/9i/8i, SQL Server 2000-2005, SQL Server-2008, DB2, Sybase and Teradata databases.

Experience in creating Normal, Unique and Bitmap Indexes to improve the performance of the SQL Queries, Functions, Procedures, Packages and Database.

Optimal in performing Database Tuning in reducing the Cost and Cardinality of the SQL Queries by using various Hints and Optimizers on looking at the Explain Plan and using TKprof and AWR.

Strong RDBMS concepts and well experience in creating database Tables, Views, Sequences, triggers etc by taking the Performance and Reusability into consideration.

Experience in both Inmon and Kimball methodology for a data warehouse environment.

Proficient in designing Star Schema, Snow Flake Schema, OLAP and OLTP Data Modeling using Erwin modeling tool.

Experience with Business Process Modeling, Process Flow Modeling, Data Flow Modeling.

Experience in working with industry standard analysis techniques to uncover client requirements and identifying the roles and deliverable in the Organization by creating Use Case Models, Data Flow Models, Work flow Analysis, Functional decomposition Analysis, Object Modeling along with Activity Diagrams, Sequence Diagrams, Report Flow and State Diagrams using Rational Rose and Microsoft Visio.

Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering, Publishing ERWIN diagrams, analyzing data sources, and proficient in Relational Database Management Systems RDBMS.

Experience in Data warehousing DW, Master Data Management MDM, Dimension data modeling in different environments like Healthcare, Food services, Telecoms, Airlines and Banking.

5 Years of Experience in Designing the Data models and developing the Database Schemas using Erwin.

Toad data modeler resume software#

Expert knowledge in SDLC Software Development Life Cycle.Over 8 years of experience in Software development and consulting industry involving and support project in Client Server, Data warehouse, Data modeling and Web application environments.