Extensively used External Tables for data conversion in staging area before loading the data into the respective dimensional tables and fact tables.Wrote PL/SQL overloading stored procedures, functions, packages and package constructors to enforce business rules.Created Data Mart with complete Star Schema for OLAP Reporting.Created different schemas and maintained schema objects.Database Design Relational models using ERwin.Performed user interviews and participated in JAD sessions.Involved in developing Logical and Physical Data Models.Responsible for designing different Data warehouse schemas like Star and Snowflake using ERwin.As a team member interact with Business Analysts, Data architect and client representatives for requirements gathering, research and solving client specific data issues.Worked on SQL*Loader and External Tables for Export/Import of data.Įnvironment: Oracle 9i, Oracle 10gR2, DB2 UDB 9.5, SQL, PL/SQL, CVS, ERwin, Windows XP, UNIX.Involved in optimization of SQL statements using Explain plan.Prepared Function Requirement Documents and documented the process events and best practices.Worked on task orders and request for proposals for these projects.Worked in both Forward Engineering concept and reverse Engineering Concepts of data modeling.Designed star schema as per the requirement with multiple facts and dimensions using ERwin.Involved in creating new data models both in OLTP as well as OLAP environment.Gathered requirements, project scope management, worked on project estimates, resourcing, status updates, project plan updates, and team coordination.Carried out extensive data validation with client’s data specialist validating complex SQL queries.Įnvironment: Teradata, SQL, CVS, MS Visio, ERwin, Windows XP.Prepare Functional Requirement Documents.Preparation of Checklists, identification of Test Cases, preparing Test Plans.Work on task orders and request for proposals for these projects.Work in both Forward Engineering concept and reverse Engineering Concepts of data modeling.
Involved in programming, debugging, and unit and system integration testing of modules.Knowledge in MS Office Suite such as Visio, Word, Excel, Access and PowerPoint.Highly involved in all phases of Software Development Life Cycle (SDLC) from Analysis, Design, Development, Test, Implementation, Documentation and Support.Working knowledge of Performance Tuning and Query Optimization using Explain Plan.Extensive experience in working for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify Logical entities.Possess strong Documentation skill and knowledge sharing among team, conducted data modeling.Experience in Data Migration processing including data loading from flat files to the database tables using SQL*Loader.Experience in the development of PL/SQL Stored Procedures, Functions, Triggers and Packages to implement business logic.Created database objects such as Tables, Views, Synonyms, Indexes, Sequences and DatabaseLinks as well as Custom Packages tailored to business requirements.Used several tools like SQL Assistant, SQL*Plus, SQL*Loader, SQL Developer.Adept in Teradata, Oracle, Oracle Tools and Utilities SQL and PL/SQL.Experience in Data Extraction, Transformation and Loading (ETL) processes.Dimensional Data Modeling using Erwin and participated in designing the Logical and Physical Data Model.Strong understanding of the principles of DW using Fact Tables, Dimension Tables, Star and Snowflake SchemaModeling.5+ years of IT experience in Design, Development and Maintenance of various software applications in client - server environment using Oracle Technologies& Data Warehousing on Windows Platforms.
0 kommentar(er)
