![ca erwin data modeler training ca erwin data modeler training](https://www.techshout.com/images/ca-logo.jpg)
Perform Data validation, Data integrity before delivering data to operations, Business, Financial analyst.Involved in developing SQL queries for extracting data from test and production databases to perform data analysis and data quality checks.Involved in creating Functional Specifications Document (FSD), Data Mapping and Data Conversion/transformation documents.Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.Extensively used most of the Control and Data Flow tasks, created XML configuration files to enable portability of packages.
![ca erwin data modeler training ca erwin data modeler training](https://image.slidesharecdn.com/endusercaerwindatamodelerpresentation-091124083901-phpapp01/95/ca-erwin-data-modeler-end-user-presentation-1-728.jpg)
![ca erwin data modeler training ca erwin data modeler training](https://www.bisptrainings.com/images/video-img-3.jpg)
Implemented performance tuning T-SQL queries, Stored Procedures and SSIS Packages, Peer reviewed T-SQL code/SSIS packages.Designed, modified database objects such as tables, views, indexes, Stored Procedures, defaults, user defined data types and functions.
![ca erwin data modeler training ca erwin data modeler training](https://i.ytimg.com/vi/PidGeD4q0TE/hq720.jpg)
Designed Informatica ETL Mappings documents, created ETL staging area framework, created data mapping documents, data flow diagram, ETL test scripts etc.Used ER Studio for Creating/Updating Data Models.Created Logical and Physical Data Models with Source to Target Mapping Document.Worked on Coordinating with 4 Different Team to Document and Spec out the requirement.Wrote installer DDL script, Stored-Procedures for ETL Data Loads, enable/disable table constraints, table-truncation, resetting sequences.Development of Excel sizing model to determine Oracle segment sizing’s prior to the loading of new data.Development of PL/SQL queries and procedures to validate model functionality and requirements.Development of DDL to establish Oracle databases on Oracle 11g R2 platform using Oracle-Partition feature.Involved in business process modeling using UML through Rational Rose.Communicated with users and business analysts to gather requirements.Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Dataflow Diagrams, and Conceptual Data Models in MS Visio.Involved in the enhancement efforts in implementing the business rules for Marketing Profile, Network Evolution, Wire centers call routing application.Involved with Business Analysts team in requirements gathering and in preparing functional specifications and changing them into technical specifications.Analyzed data requirements & provided conceptual and technical modeling assistance to developers.Use a variety of information gathering techniques to gather complex business data requirements from internal business clients and development teams.Used Erwin for data modeling Perform Data Analysis & Profiling Activities to identify volumes, data quality issues to Solution Designers &ETL Architects.Performed Data Analysis and data profiling using complex SQL on various sources systems.Creating a data warehouse will enable the users to gather valuable data in a single source which is user ready for analytical reporting across the many different systems.