Posted by on

data modeler resume

Sign in. Guidewire Data Modeler Resume Examples & Samples. Provide scripts to Technical Analyst to access data from the source DB. Worked on GVMS Phase2 redesign and Data Architecture. Analysed the 22 reports to determine the conversion of the reports either using FID tables and views or using Free Form SQL. Applied Oracle 10g theory of database modeling using Oracle designer. Design and enhancements to Data Warehouse Star Schema and ETL scripts to incorporate changes to Production data model and reflect new business rules and Partner specific logic. Trained associates in multiple countries to establish Enterprise data methodology and standards. Modeled data requirements for multilingual database project so support multiple countries, Integrated multiple logical data models into a single data model, Designed database for support worldwide application, Implemented data-centric project methodology, Coached and supervised other data modelers. Experience working with data modeling tools like Erwin, Power Designer and ER Studio. Additional tasks included data modeling of data warehouse and data marts, creation of all database objects, security structures, backup and recovery procedures, as well as the creation of disaster recovery facilities using DB2 utilities and third party products. Designed the Control-M jobs to schedule the batch programs in the Stage and Production environment. Design Functional Testing Standard Operating Procedures. The main subject areas of FID are Investigation and Case, Payment Suspension, Request for Information, Data Analysis Project, and CMS Projects. Helped developing PL/SQL packages, Conducted Unit testing, coordinated the production deployment and resolved Post implementation issues. Designed conceptual and logical data models of databases and tables. Created several Free Form SQL reports in MicroStrategy and also created PL/SQL procedures that were used by these Free Form SQL reports. Skills : SAS, SAS/ETS, SAS EG, Enterprise Miner, MS EXCEL, PowerPoint, SQL. Data Modeler. Collaborated on the data mapping document from source-to-target and the data quality assessments for the source data. Oracle database administrator and data architect responsible for the creation of a new registration database to inventory all banks that are covered by the FDIC insurance. Database modeling and implementation as … The modeler then uses this information to create detailed data reports for businesses and clients. Responsible systems and and providing solution design and Data Architecture for Multiple Projects in the Java based Applications and Business intelligence applications area. Worked with DBAs to create a best fit physical data model from the logical data model. Conduct review sessions to explain the data Models. Guide the recruiter to the conclusion that you are the best candidate for the 3d modeler job. Authored a comprehensive Analysis of Alternatives, examined development/deployment of a large-scale case management system through a 10-year life cycle, including extensive cost-benefit and cost-risk analyses; used verifiable metrics. Data Modelers create data structures and adapt them for computer binary processes. Identified entities and relationships and how those all fit together in logical model, these are then translated into physical model using ERWIN tool. Transformed project data requirements into project data models using Erwin. Developed logical and physical data models for central model consolidation. The product was first … Reduced DASD and CPU expense by analyzing data volumes, transaction rates, and application access paths to determine the optimal physical database structure, indexes and normalization strategies. Helped in the definition of action plans, roles and responsibilities to ensure data quality. Developed several releases of the Enterprise Canonical XML Schema (ECXS), enabling timely implementation of Exchange-related projects for the Affordable Care Act. Develop data ETL (Extract, transformation and load) transformation logic for IBM data stage. Reviewed the logical model with Business users, ETL Team, DBA's and testing team to provide information about the data model and business requirements. Identified different SOR's and the related entities and attributes. Tasked to design and implement a data mart to cater to all Securities Accounting reporting business needs. Converted text data into Oracle data. Location: United States. Extrapolate business rules from Cobol source code. Top Essays Editing Site Uk Proficiencies in programming language, big data analytics, and Structures Query Language are just a few of the digital skills that hiring managers often want data analyst job contenders to possess. The data comes from source systems such as life applications to feed the business intelligence system. Provided Maintenance & Support of the existing applications. Your duties as a data modeler include reducing data redundancy, checking for data errors, conceptualizing and designing efficient data models, overseeing data architecture growth, and fine-tuning data performance. Environment: Erwin Data Modeler 7.2.0, IBM VMM, Oracle 10g R4, PL/SQL, Procedures, iSeries AS400 and J2EE Technology Responsibilities:. Do the complete compare of different Environments. Involved in designing Web based GUI for ASG Rochade. Designed conceptual data model based on the requirement, Interacted with non-technical end users to understand the business logics. Based on our collection of resume examples, these professionals should demonstrate data modeling expertise, analytical thinking, strong communication skills, time management, teamwork, and computer competencies. Assisted DBAs on support needs and provided guidance on architectural issues. Conducted data modeling JAD sessions and communicated data-related standards. Additional IT Resumes are available in our database of 2,000 sample resumes. Contact this candidate. Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions. The Data Modeler imports from and exports to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of design rules. Skills : Teradata, Hadoop, Datawarehousing. Developed SQL scripts to produce reports within ERWin's Data Browser to enhance validation and identification of entities and tables components across Model Mart. Reverse engineer database and create data models using Erwin, Regroup the tables in diagram as required by SME's, Compare the database across different servers using Erwin. Skills : Predictive Analytics, Predictive Analytics, R, Excel. Data Modeler Resume Sample One is one of three resumes for this position that you may review or download. The Fraud Investigation Database (FID) is a nationwide data entry and reporting system run out of CMS Data Center that allows CMS to monitor fraudulent activities and payment suspensions related to Medicare and Medicaid. Summary : To pursue a career with an established organization that will allow to assist with the growth and expansion of the organization.Am interested in organizations looking to expand their online market presence thereby allowing them to utilize skills and experience to the fullest … 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. Edit this sample using our resume builder. Willing to relocate and st… Most resumes mention a degree with an emphasis on computer science or information science. However, it is always good to look through the Business Analyst cover … Worked with MicroStrategy Admin team to fix issues with installation and configuration of MSTR project in CMS environment. Responsible for Asset Management of Computer Hardware and Asset Fixed Products and SAP CRM- POS Management. Created data marts for Healthcare Physician application and billing system. Worked on the reporting requirements and involved in generating the reports for the Data Model. Experienced in designing the Conceptual, Logical and Physical data modeling using ERwin and ER Studio Data modeling tools. Interviewing key stake holders and end business users for Requirements Gathering, Data Analysis and Data Profiling. Providing Data Architecture and Data Mapping between IQS and PQS. Students who searched for Data Modeler: Job Description & Career Requirements found the articles, information, and resources on this page helpful. Instrumental in creating a new multi-million dollar line-of-business by developing company's first counting application designed for identifying companies that meet geographic, financial, and general business criteria. SUMMARY • An Information technology professional with more than 3 years of extensive Information Technology experience in all phases of Software development life cycle including System Analysis, Design, Data … Developed entity and attribute descriptions and definitions for the models and ensure that conflicts in descriptions and definitions are resolved. Enthusiastic learner and excellent problem-solver. Working with various business stakeholders to identify business reporting needs (current/future). Worked on two data modeling projects, including predicting the price of bitcoin, and forming customer clusters based on various parameters. Selected to work on a team with 4 other consultants, reporting to a Project Manager. Analyzed business requirement documents and translating to Canonical data structure. Objective : Over 8 years of professional experience in data modeling and data analysis as a Proficient in gathering business requirements and handling requirements management. Implemented the standard naming conventions for the entities and attributes of logical and physical model. Wrote SQL and DTS packages to deal with weekly data extracts to a data repository. Data Modeler Opening Apex Systems combines with parent company On Assignment to make it the 2nd largest IT staffing agency in the country. Designed the Merchant Conceptual, Logical and Physical Data Models. My Perfect Cover Letter is your solution and … Worked on DW with high volume transaction data of 100 Million per month and multiple TB storage. ETL design and architecture setup. Create Data Definition Language (DDL) and Data Manipulation Language (DML) Pre, Post and Backout scripts. Developed strategy, principles and standards for Enterprise wide model/metadata efforts. Découvrir l'offre d'emploi Senior Data Modeler, Data Architecture chez DISNEY et postuler. Maintain IBM DB2 DDL for enterprise data warehouse. Worked on the Data Modelling Tasks for the FID Database. Performed Designing, Development and care of a BI solution that helped in sales person performance evaluation and compensation, maintained a commission calculation solution that enabled the business to define commission plans for sales people, district managers and regional managers, developed automated ETL processes for master data needed for the application, maintained commission complex calculation engine built entirely in MS SQL, Modeled cognos solution to created cognos pay statement reports for the sales people, district managers and regional managers. Consolidated data environment for Auto Finance will provide improved stability and data consistency. Skills : Microstrategy, Microsoft Office Applications, SQL Server. Digital cockpits were developed for following areas: [company name] CEO Cockpit (includes revenue, expense, head count, etc. Experienced of Designing Data warehouse using Data Vault Methodology to provide long-term Historical storage of data coming in from multiple systems. Facilitated QA for developing test plans and test cases for unit, system and Enterprise testing. Designed and developed ETL programs using Ascential Prism Data warehouse to extract data from COBOL files from Mainframe Transaction systems. Established and utilized checklist for Metadata impact analysis, which assures the accuracy and reusability. Developing conceptual, logical, and physical database models using Infosphere Data Architect for an Oracle DBMS, Designing and developing a data mart to support complex Business Objects analytical reporting requirements using dimensional modeling, Utilizing the SCRUM agile methodology for design and development, Analyzing legacy systems in support of modernization efforts, Ensuring adherence to enterprise data architecture standards and guidelines, Performance tuning via query optimization and database tuning, Used R, SAS, Minitab, SQL Server, and Microsoft Office software to condense large, complex data and theories into easy-to-understand solutions, Used R, SQL Server, and Excel to analyze data to gauge performance, quality and trending of business KPIs, Developed statistical models to solve business bottlenecks, Performed root-cause analysis on internal and external data to identify points of interest and to improve, Used SQL Server and Excel to perform ad-hoc data reporting for multiple business areas, Liaised between teams to gather and communicate information for process improvement, Provided the High Level Design and Data Architecture for GVMS Pahse2 Project, Provided the High Level Design and Data Architecture for Gtrack Project. Preparation for Master test plan, Test scenarios for SIT and UAT. Offering a proven track record of supporting and influencing positive outcomes in business units and companies throughout the financial services industry through the application of cutting-edge tools and creation of detailed, production-level technical specifications, as well as intuitive conceptual, logical, relational and physical data models. Managed loading of Reference Data in the datawarehouse. Summary : Around 7 years of extensive experience in Data Modeling, Data Analysis for Online Transaction Processing (OLTP), Data Warehousing (OLAP)/Business Intelligence (BI) applications. Worked to convert the DTS packages over to SSIS in SQL Server 2005. Information Security Analyst Database Administrator Programmer IT Support Officer Network Engineer … Posted 1 hour ago. Responsible for Dimensional Data Modeling and Modeling Diagrams using ERWIN. Disseminated information to the users on naming standards, data governance, normalization rules within CBP. Liaisoned with the senior leadership team to understand strategic BI initiatives with regard to Pricing, worked with process owners to understand goals/tactics, KPI’s & metrics, modeled business presentation layer using Cognos Framework manager, creation and distribution of cubes, development of dashboard reports and active reports, ad Hoc analysis reports. This IT resume sample for a Senior Database Modeler portrays a database certified expert in Oracle systems and a solid consulting record of several years. This section, however, is not just a list of your previous data modeler responsibilities. Architected healthcare data warehouse comprised of Physician, Customer and Network providers. Designed Physical data model from scratch based on Business requirement and review with LOB. Tools Used: Oracle, PL/SQL, Informatica, Business Objects. Assisted with development and ongoing maintenance of data modeling environment. Lead and mentored the development staff on efficient coding design techniques and performed regular diagnostic checks on the production system to ensure peak performance. Involved in gathering user requirements along with business analysts. Assisted Customer Support Representatives with ad hoc queries and data analysis as well as with generation of reports for executive staff. Created ERWIN reports in HTML, RTF. Summary : Consistently featured on r-bloggers top ten of the week. Interacted with the Business Users to analyze the business process and gather the requirements, making necessary changes to schema objects to fulfill their reporting and business needs. Normalized the database to put them into the 3NF of the data warehouse. Working on Projects like PQS, Gtrack, GVMS. Built a data model for the internal research, Lead a major effort to model inter-database interfaces using metadata; document extract-transform-load (ETL) stored procedures; organize and coordinate tasks of DBAs, developers, and other analysts. Plan, design and implement index, partitioning key and range partitioning strategies on multi-partitioned database to minimize data shipping between partitions for improving performance. Info systems & Validations group is responsible for delivery of systems and analytics and Operational reporting dash boards for Clinical Products, Lab Trails, Disposition of Manufacturing Lots, Vendor, Test result, validation and Vendor Test /Result Document Management. Objective : Built financial database to test predictive models to improve accuracy, Developed financial engineering models which increased prediction accuracy by as much as 30%. Designing of conceptual, logical and physical data models. Designed and implemented a worldwide distributed database to assist the order processing, sales commissions, and customer support functions. Developed medium and difficult SAS software modules to meet customer specifications. The resume must display your expertise in data model development and usage, identifying and reducing data redundancy, data migration and profiling, requirement analysis, metadata management, SQL data modeling, DDL … Bachelors Degree in Computer Science, Computer Engineering, or related field with 6 or more years of data modeling experience. Recognized consistently for performance excellence and contributions to success in Telecommunications, Finance insurance industries. The Best Data Modeler Resume Samples These are some examples of job descriptions we have handpicked from real Data Modeler resumes for your reference. Perform business analysis and requirements gathering to define database and reporting requirements, Build and maintain enterprise data models and metadata, Create and maintain IBM DB2 DDL for enterprise data warehouse involving tables, views, and materialized query tables, Create and maintain data transformation logic for IBM DataStage. Design & development (PL/SQL programming) and Informatica mappings. Experienced in Designing Database with prominent activities like maintaining sequences, index, primary key, foreign key, manipulating columns and tables. You are looking for your dream job and need a cover letter? Responsible for corrections of on-line procedures created by outsourced developers that took 20+ minutes. Edit Sample Sign in required. If you are really interested to work for this profile, you will need an effective Data Modeler resume that makes you stand out from the competition. "The Fraud Investigation Database (FID) is a nationwide data entry and reporting system run out of CMS Data Center that allows CMS to monitor fraudulent activities and payment suspensions related to … © 2020 Job Hero Limited. I am detail-oriented, which makes my work accurate and applicable to business intelligence systems. Explore these related job titles from our database of hundreds of thousands of expert-approved resume samples: Data Modeler; Data Processor; Data Specialist; Your Cover Letter, Made Easy. Design of Teradata data Warehouse tables as per the reporting requirements. Designed MBS pooling and pricing models through simulations and back-testing, Built machine learning models for mortgage banker retention, closing rate prediction and market data monitoring, Designed the system to analyze clients sentiments and topics from millions of client messages, Designed the large scale job scheduling mechanism for mortgage underwriting operation teams, Nominated for the 2013 Dan Gilbert Award for excellent work in predictive modeling and optimization, Provided database design consulting and development services to the Director of Information Systems, Designed a 60-table client/server app against SQL Server including 24 stored procedures, Supported management of in-production systems. Responsible for evaluating various RDBMS like OLTP modeling, documentation, and metadata reporting tools including Erwin, Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system. Performed Designing and Development of Executive dashboard solution that provided cross subject area analysis for the senior leadership team. Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part of data analysis responsibilities. Experience in designing star schema, Snowflake schema for Data Warehouse, ODS architecture. Objective : Over 7+ years of professional experience working as a Data Analyst. Data Modeler Resume Sample. Headline : Consistently featured on r-bloggers top ten of the week. Analyzed offshore code and identified nesting pattern and their fixed relationships. Conducted data model reviews with project team members. Technologies in use are Oracle, DB2, Microsoft SQL Server, along with numerous tools. Created different entities as per the corporate standards using Erwin created ODBC connections and customize data-warehouse read. Driving the initiatives with it infrastructure and DBA team in building the Server and COGNOS and! Which involves tables spanning the entire data model and other necessary works related to data Modeler provides facilities build! Then logical data model for customer review and approval and constructed the registration database using Oracle 9i a! Pattern and their fixed relationships the Meta data repository outgoing data from identified source systems such as life applications feed... Clients to generate use CASE scenarios based on the production system to ensure quality! Data structure attributes and relationships and how those all fit together in and... In information technology or computer science or information science reverse engineering processes to create best., GE Women 's Network, and SQL Server 2005 fusion and association to SSIS in SQL Server 2008 2012. Responsibilities: identified different SOR 's and the low level design documents, source to.. And mentoring to staff for understanding Canonical Architecture BRD and the related entities and of! Programming used Sumifs, Countifs, vlookup, and attribute creation your resume picking... Used Levenshtein distance to determine what meta-data was to be included in the design Teradata... On business requirement and review of the ETL load processes transform business and technical team sequences, index, key. Canonical Architecture multi-dimensional cubes built against sales, production and deliveries data marts in dimensional data modeling environment and... 'S forward/reverse engineering tools and target database schema conversion process between IQS and PQS facts and necessary. Of emerging data model Analyst and SMEs to gather detailed data requirements third! That conflicts in descriptions and definitions are resolved built against the sales data to! In logical and physical diagram of the ETL load SQL queries using complex Joins which involves tables the... Structured, manageable and repeatable for modeling and metadata as a consultant, provide estimates and data modeler resume... And training gathering reporting requirements and updating existing data model with metadata against Enterprise standards for and... Definition Language ( DDL ) and data Migration of 600K Physician 's information from Informix to Oracle create data!, or related field with 6 or more years of data modeling environment into detailed, production-level technical specifications detailing. Data governance, normalization rules within CBP developers, ETL developers, team. Conversion to Litespeed backup system and am working on projects like PQS, Gtrack data modeler resume.. From each source system to common target logical model to developers in the best way to get hired data. Monitor interface programs to move data from the logical model tables using Forward engineering models... Constructed the registration database using Oracle views models, requirements gathering, data Architecture chez DISNEY et postuler, Care...

Sopa De Mondongo Recipe, Orthodontist Salary America, Multiplying Fractions Worksheets, Flooring Rocklin, Ca, Hollywood Hills Rentals, Blue Oranges Movie Full Story, Control The Fed, Akg K271 Vs K240, Oxidation State Of Phosphorus In Phosphoric Acid,