Designed the technical specifications document for Teradata ETL processing of data into master data ware house and strategized the integration test plan and implementation.Developed the Logical and physical data model and designed the data flow from source systems to Teradata tables and then to the Target system.Translated Business Requirements into working Logical and Physical Data Models.
Created Business Requirement documents (BRD’s), such as SRS & FRS and integrated the requirements and underlying platform functionality. Ensured that Business Requirements can be translated into Data Requirements. Attended and participated in information and Requirements Gathering sessions. The project was to design, develop and maintain a data warehouse to present an integrated, consistent view of enterprise-wide data with a Decision Support System feature to compare and analyze product prices, quantities, and Customer profiles without compromising any customer information. As data modeler role was to design and implement the data warehouse to support 360-degree view of the customer and to build a point of integration for historical and current data from all major customer touch points. Enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.Įducation: Bachelor of Business AdministrationĬlient: Confidential- Bensenville, IL March2012–Feb 2013Ĭonfidential has more than 6 million customers and $5 billion annual revenue and they provide services to customers in 25 states. Proficient in using MS Office including MS Visio and MS Project. Possess a strong analytical, verbal, inter-personal skill that helps in communicating with developers, team members. Experienced in optimizing performance in relational and dimensional database environments by making proper use of Indexes and Partitioning techniques. Assisted quality assurance team in preparing test scripts and test cases. Experienced in preparing Business Process Re-engineering Models. 
Gathered and documented Functional and Technical Design documents.Performed various operations like Data Cleansing, Data Scrubbing, Data Profiling and maintained data governance.Created the enhanced logical model in 3NF using ER/Studio and the many to many relationships between the entities are resolved using associate tables.Experienced in optimizing performance in relational and dimensional database environments by making proper use of Indexes and Partitioning techniques.Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, usingindustry leadingData Modeling tools like ERWIN and EMBARCADERO ER Studio.Experience in conducting JAD sessions, interacted with various business users and acted as a liaison between the business and development teams.Possess strong Conceptual and Logical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications.
ERWIN DATA MODELER RESUME SOFTWARE
Expert knowledge in SDLC( Software Development Life Cycle) and good experience in the field of business analysis, reviewing, analyzing, and evaluating business systems and user needs, business modeling, document processing.
Extensive experience in Database Design, Normalization, Selective De-normalization, Forward/ Reverse Engineering of Applications, Conceptual, Logical and Physical data modeling using Erwin, E/R Studio and Sybase Power Designer. Gathering and translating business requirements into technical designs and development of the physical aspects of a specified design. Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like Erwin, EMBARCADERO ERStudio. Extensive experience in designing the Data models for OLTP & OLAP database system. About Eight years of extensive experience in the complete Software Development Life Cycle (SDLC) covering Requirements Management, Data Analysis, Data Modeling, System Analysis, Architecture and Design, Development, Testing and Deployment of business application.
0 kommentar(er)
