- Business Process
Here's the means by which Business Process is utilized in Data Modeler occupations:
- Engaged with recording client prerequisites, business interaction and interpretation of business measure into specialized reports.
- Planned Order provisioning business measures, target applications design and target information model.
- Made Data Architect plans/records for business preparing prerequisites.
- Broke down and reviewed Requirements and Business Processes.
- ETL
Here's the manner by which ETL is utilized in Data Modeler occupations:
- Broke down ETL preparing to distinguish hazard factors and made fundamental proposals to guarantee information trustworthiness in the information stockroom.
- Attempted to guarantee execution meets the recorded determinations for ETL measures including information interpretation/planning and change.
- Interpreted all business security announcing and investigation prerequisites and models into working ETL measure.
- Made ETL cycles to concentrate and load fundamental request execution data from different corporate information bases.
- Information Analysis
Here's the means by which Data Analysis is utilized in Data Modeler occupations:
- Reclassified numerous credits and connections in the figured out model and purged undesirable table/segments as a feature of information investigation obligation.
- Assessed Entities and connections in the designed model and purged undesirable tables/segments as a component of information examination duties.
- Directed legitimate information investigation and information displaying joint application plan (JAD) meetings, recorded information related guidelines.
- Performed information examination to help planning and change of information from inheritance frameworks to actual information models.
- Design
Here's the means by which Architecture is utilized in Data Modeler occupations:
- Performed code surveys with in-house and contracted improvement groups to guarantee legitimate combination design is executed and principles are followed.
- Taken an interest in significant task exercises including Architecture, Design conversation, Requirement social occasion, Analysis and survey measure.
- Given documentation and preparing to this security design and its utilization to application backing and business client local area.
- Created, coordinated, and oversaw ongoing information on geological guide engineering dependent on country explicit security arrangements.
- Systems
Here's the manner by which Procedures is utilized in Data Modeler occupations:
- Produced Logical Data Models for old data sets utilizing Reverse designing and archived to carry out Forward Engineering systems.
- Smoothed out information organization systems through creating itemized information property contractions direct and overseeing information models in Erwin ModelMart.
- Planned and carried out methods for planning interface information between heritage frameworks and another AllTel execution.
- Recommended enhancements to existing tagging methodology and concession arrangement utilizing measure planning and cost investigation.
- Actual Data Models
Here's the way Physical Data Models is utilized in Data Modeler occupations:
- Performed Reverse Engineering of the current application utilizing Erwin, and created Logical and Physical information models for Central Model union.
- Built up the legitimate information models and actual information models that limit existing condition/potential status information essentials and information streams utilizing Erwin.
- Made coherent and actual information models for the Marketing Department to follow standard mail sales of credit-screened car advance possibilities.
- Change the Logical and Physical Data Model to add extra usefulness of Deferred Payment course of action for NV Energy Customers.
- Information Warehouse
Here's the means by which Data Warehouse is utilized in Data Modeler occupations:
- Taken an interest with key administration assets in the essential investigation and arranging prerequisites for Data Warehouse/Data Mart detailing and information mining arrangements.
- Planned and created framework for producing information stockroom quality test contents driven by meta-information removed from ER/Studio models.
- Engaged with Data Warehouse Support - StarSchema and Dimensional demonstrating to help plan DataMart and information stockroom.
- Created and facilitated upgrades and upkeep of information stockroom and information shop sensible models.
- Scene
Here's the way Tableau is utilized in Data Modeler occupations:
- Created and conveyed dynamic announcing visuals utilizing Tableau.
- Utilized different detailing objects like Hierarchies, channels, determined fields, Sets, Groups, Parameters and so forth, in Tableau.
- Worked with MS Excel utilizing PivotTables, Formula, and Conditional Statements and Tableau for producing a few reports.
- Produced Dashboards with Quick channels, Parameters and sets to deal with sees all the more proficiently utilizing Tableau.
- Metadata
Here's the means by which Metadata is utilized in Data Modeler occupations:
- Created Private Bank's Metadata Strategy that use shared corporate assets including utilization of Computer Associates Advantage Metadata Repository.
- Made SQL questions to remove Report and source/target metadata from Business Objects and Oracle Data Integrator inner archive information bases.
- Planned and created coordinated metadata storehouse utilizing existing parts of metadata in existing programming instrument speculations
- Associated with creating metadata storehouse, information word reference documentation utilizing interface outlines and stream diagrams.
- SQL
Here's the way SQL is utilized in Data Modeler occupations:
- Made custom information vault application and data set utilizing SQL Server.
- Helped application engineers with execution tuning of use inquiries and SQL
- Performed different SQL Server information organization capacities.
- Made different Oracle tables, sees, records, successions, capacities, information base triggers and bundles utilizing SQL*Plus and Toad.
- BI
Here's the means by which BI is utilized in Data Modeler occupations:
- Adjusted consistent and actual social and dimensional models for deals examination BI revealing.
- Collaborated with BI designers for business necessities social occasion to create the report components.
- Broke down the information models of the source frameworks (OLTP) to create Data Models for OLAP frameworks for BI revealing.
- Planned information loads from R/3 to BI and streamline the heap execution by information determinations, information parcel size change.
- Information Requirements
Here's the manner by which Data Requirements is utilized in Data Modeler occupations:
- Recognized and coordinated proposed reference information necessities inside the systems of the U.S. Transportation Command information standard.
- Encouraged information necessities and business prerequisites dependent on the task by communicating with money managers.
- Dissected the information prerequisites of the undertaking by considering the Business Requirement Specification record.
- Guaranteed all the business prerequisites are converted into information necessities.
- Information Quality
Here's the way Data Quality is utilized in Data Modeler occupations:
- Proposed a way to deal with the union of strategy holder and maker data and to information quality improvement.
- Kept up the honesty of information additionally checked information quality.
- Utilized Information Analyzer for profiling and information quality checking.
- Articulate with Data Conversion, Data Quality, Data Profiling, Performance Tuning and System Testing and carrying out RDBMS highlights.
- Java
Here's the means by which Java is utilized in Data Modeler occupations:
- Created interface pages in Java content by encouraging the client to pass boundaries into the report.
- Aided Java Developers AND Testers in understanding the Data Model.
- Planned and appropriated reports utilizing Report Caster JAVA API.
- Guided JAVA advancement staff in utilizing DB2.
- Information Governance
Here's the manner by which Data Governance is utilized in Data Modeler occupations:
- Worked autonomously and get ready information methodology, Data administration documentation and introduction for Chief Data Office.
- Created and kept up big business information word reference by communicating with information steward, information administration group.
- Associated with gatherings with Data Governance group to guarantee legitimate exercise of power and command over the administration of information resources.
- Scattered data to the clients on naming guidelines, information administration, standardization runs inside CBP.