We provide IT Staff Augmentation Services!

Data Modeler Architect Resume

Atlanta, GA

SUMMARY

  • 11+ years of professional experience as a BIData Architect, Data Architect, Data Modelling, Data Analysis and design of OLTP and OLAP systems;
  • Implementation of the intended business architecture, and created an inventory of the data needed to implement the architecture;
  • Experience in meeting with business stakeholders and other technical team members to gather and analyse application requirements;
  • Experience in owning & managing all changes to the models, solution designs and architecture documentation.
  • Experience in determining database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems;
  • Involved in discussions with clients/users to determine the Dimensions, Hierarchies and Levels, Basic Measures, Key Metrics for Relational, Multidimensional Data Modelfor the system and understanding report requirements
  • Experience in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using Erwin;
  • Well versed on implementing data governance and Dodd Frank rules. Worked together with data stewards on governance;
  • Extensive experience in Relational Data Modelling, Dimensional Data Modelling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering ERWIN diagrams, analyzing data sources and creating interface documents;
  • Based on the business findings created Star Schema and Snow - flake Schema using advanced dimensional modeling concepts of Conformed Dimensions and Facts, Large Dimensions, Degenerated dimension, Fact less fact table, Aggregate fact tables in Multidimensional model.
  • Experienced in BDW tool,Developed conceptual models to walkthrough the business
  • Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprisedatastores within a metadata repository. Proficient in Master data management;
  • Proficient in data mart design and creation of cubes using dimensional data modelling - identifying Facts and Dimensions, Star Schema and Snowflake Schema;
  • Well versed in Normalization / De normalization techniques for optimum performance in relational and dimensional database environments;
  • Experience working with Agile and Waterfall data modelling methodologies, Ralph Kimball and Bill Inmon approaches;
  • Proficient in Informatica Power Center, Data stage IBM info sphere & SSIS, having experience in creation of jobs and executing them;
  • Experience in Data profiling, Data transformation and Data mapping from source to target database schemas and also data cleansing;
  • Experience in designing, developing & creating tables/views for database.
  • Good understanding oforacle Data DictionaryandNormalization Techniques.
  • Experience in SQL and good noledge in SQL programming and developed Stored Procedures and Triggers;
  • Experience in PL SQL and good noledge in PL SQL programming and developed Stored Procedures and Triggers;
  • Experience in NOSQL DB and tools like Apache Hbase to handle massive data tables containing billions of rows, millions of columns;
  • Experience in Mark Logic Enterprise NoSQL Database for large-scale systems in production;
  • Experience in Data loading using SQL Scripts and SQL Server Integration Services packages (SSIS 2005/2008);
  • Experience in SSRS for maintaining reporting requirements and their respective dashboards.
  • Well versed in understanding and explaining the reporting requirements to the development team for building dashboards to meet business.
  • Experience in directing the team to develop reports for business end users using Report Builder with updating Statistics.
  • Experience in directing the team to develop various operational Drill-through and Drill-down reports using SSRS.
  • Experience with DBA tasks involving database creation, performance tuning, and creation of indexes, creating and modifying table spaces for optimization purposes;
  • Experience in using Database Tools TOAD for Data Analyst, SQL Server Management Studio;
  • Experience in Data profiling between various OLTP systems & Canonical models;
  • Efficient in analyzing and documenting Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) along with Use Case Modelling and UML;
  • Facilitated and participated in Joint Application Development (JAD) sessions for requirements gathering and analysis;
  • Excellent noledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data;
  • Excellent analytical, interpersonal and communication skills with clear understanding of business process flow;
  • Created user or project documentation for all the above.
  • Effective team leader as explaining and halping them team in understanding the requirement and assigning work to the team.
  • Effective team worker and can carry out individual tasks to meet the deadlines effectively;

TECHNICAL SKILLS

Data Modelling Tools: Erwin 9.x/8.x, ER/Studio 7.1.1/7.5, SAP Power Designer, Infosphere Data Architect

Databases: Oracle 11g/10g, IBM DB2 UDB 8.0/7.0, MS SQL Server 2012/2008/2005, Teradata 13/14, Hadoop, Mark Logic, No SQL, Hbase

ETL Tools: IBM Data stage info sphere, SSIS, Informatica Power Centre

Reporting Tools: Cognos 8, Crystal Reports XI, SSRS,Spot fire Business Objects XI

Operating Systems: Microsoft Windows Vista/XP/2000/NT, Sun Solaris, Unix, Linux, AIX, MSDOS.

Programming Languages: COBOL,SQL,SAS

Defect Tracking Tools: HP ALM, Service Now.

Project Execution Methodoligies: Ralph Kimball and Bill Inmon data warehousing methodology, Rational Unified Process (RUP), Agile, Rapid Application Development (RAD), Joint Application Development (JAD)

PROFESSIONAL EXPERIENCE

Data Modeler Architect

Confidential, Atlanta, GA

Responsibilities:

  • Understanding the specification and analyzed data according to the client requirement
  • Conducting requirement gathering sessions with Edward EDW Report Owners/SMEs to understand the current process flow of report generation and identifying the Risk Data elements.
  • Coordinate with various developers, project managers and analyst to prepare designs for application and document all process to ensure effective evaluation of all applications.
  • Develop the logical model & physical model for the identified elements.
  • Involved with implementing Kimball methodology to design data marts.
  • Mapping data to the authoritative source field and table name as part of the data migration analysis activity
  • Design & develop OLTP models and OLAP model for the reporting requirements using Erwin& Power designer.
  • Working together with Data stewards to follow the data governance principals.
  • Generate the DDL’s out of the developed physical model and execute the DDL’s on the defined database.
  • Capturing data elements - definitions and characteristics for information requirements
  • Extracted key data from SOR systems and built dimensional data models for data warehouse, data marts, and balanced scorecards for key managers.
  • Experience in using InformaticaPower Center tool for data integration and processing the data from staging tables to the relational database
  • Experience in explaining the tuning requirement changes for SQL/PL SQL packages and provide stored procedures to the design & development team.
  • Experienced with metadata before loading the models into Hadoop.
  • Experience in Tableau for maintaining reporting requirements and their respective dashboards.
  • Experience in data cleansing on the target database.
  • Prepared Testing Strategies document and documentation of Test Plans and Test Cases.
  • Did troubleshoot after implementation for production problems and created projected/ user documents
  • Effective team leader as explaining and halping them team in understanding the requirement and assigning work to the team.

Environment:SAP Power Designer, Erwin 9.x/8.x, Teradata SQL Assistant, SQL Server 2012, MS SQL Server, Teradata, Oracle 11g, SQL Developer, Hadoop, Tableau, Apache Hbase, ER/Studio.

Data Architect/ Data Modeler

Confidential, Wilmington, DE

Responsibilities:

  • Understanding the specification and analyzed data according to the client requirement
  • Conducting requirement gathering sessions with Wealth Management Report Owners/SMEs to understand the current process flow of report generation and identifying the Risk Data elements.
  • Coordinate with various developers, project managers and analyst to prepare designs for application and document all process to ensure effective evaluation of all applications.
  • Understand the current process and develop the conceptual model.
  • Understand & created the data flows and data architecture for the requirement.
  • Data Lineage of Wealth management risk data elements to its source system and capturing all the calculation/derivation logic involved in underlying Teradata /SQL & PL-SQL codes.
  • Develop the logical model & physical model for the identified elements.
  • Prepared Conceptual Model Use Cases for representing the various dimensions and measures involved in recreation of Chase Wealth Management reports.
  • Involved with implementing Kimball methodology to design data marts.
  • Mapping the Risk Data elements to the Authoritative Data Source and documenting the Schema, Database, Table details for data modelling purpose.
  • Mapping data to the authoritative source field and table name as part of the data migration analysis activity
  • Designed & developed OLAP model for the reporting requirements using Erwin.
  • Working together with Data stewards to follow the data governance principals
  • Generate the DDL’s out of the developed physical model and execute the DDL’s on the defined database.
  • For FINRA, developed conceptual, logical & physical models to support and generate the reports often.
  • Participated in DRB Sessions with the reviewer by presenting the designed data models and explained how we followed the standards while designing the models.
  • Experienced with metadata before loading the models into Hadoop.
  • Capturing data elements - definitions and characteristics for information requirements
  • Extracted key data from SOR systems and built dimensional data models for data warehouse, data marts, and balanced scorecards for key managers.
  • Interact with the customer and the SME(s) to identify the relationship between the data element and the business rule to document the data
  • Used Hadoop to analyse outcome data for generating recommendations, performing predictive analytics, and detecting fraudulent activities.
  • Experience in analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers.
  • Experience in explaining the tuning requirement changes for SQL/PL SQL packages and provide stored procedures to the design & development team.
  • Extensively useddynamic performance views,data dictionary, as well asEnterprise Managerto monitor thedatabaseand performtuningactivities.
  • Experienced in explaining complex Ad-hoc reports, Dashboard Reports, KPI’s, Business views containing charts showing sales, products, in-service customers, disconnects, revenue by regions, market areas & divisional managers using ERwin, Business Objects, Visual Studio, SSRS, Dashboards, Reports and SQL.
  • Participated and managed Scorecards to report on key metrics to Senior Management and other key stakeholders.
  • Experience in management of Commerce solutions & wealth management products performance data KPI monitoring process.
  • Experience in data cleansing on the target database.
  • Directed offshore team to create dashboards based on the business requirement using SSRS and halped offshore team in noledge about the requirement.
  • Prepared Testing Strategies document and documentation of Test Plans and Test Cases.
  • Did troubleshoot after implementation for production problems and created projected/ user documents
  • Effective team leader as explaining and halping them team in understanding the requirement and assigning work to the team.

Environment: Erwin 9.x/8.x, Teradata SQL Assistant, SQL Server 2012, MS SQL Server, Teradata, Oracle 11g, SQL Developer, Hadoop, Mark Logic, Apache Hbase, ER/Studio.

BI Data Architect/ Data Modeler

Confidential, Columbus, GA

Responsibilities:

  • Gathered business requirements; interacted with DSO and business analysts to finalize requirements.
  • Developed data flows & architecture models for the requirement and halped the business by creating business process flow & workflow models.
  • Evaluate all architecture for SQL applications and prepare layouts for all logical models and maintain database objects for various application components
  • Experienced in BDW tool,Developed conceptual models to walkthrough the business
  • Translated existing databases into models to understand objects and relations using reverse engineering function using Erwin.
  • Performed walkthroughs for Conceptual Data Model, Logical Data Model and Physical Data Model for validating designs for the enterprise data warehouse.
  • Identified Multiple Dimensions and Fact tables. Used advance data modeling concepts of Degenerated dimension, sub-dimension, Fact less fact table, Aggregate fact tables in Multidimensional modelusing Erwin.
  • Designed & developed OLAP model for the reporting requirements using Erwin.
  • Developed the DDL’s from the physical Erwin Data model and executed in sandbox for errors.
  • Involved with implementing Kimball methodology to design data marts.
  • Implemented primary key foreign key constraints using RI (Referential Integrity).
  • Used normalization/de-normalization techniques to achieve optimum performance of the database.
  • Identified SCD and categorized them under Type1, Type-2 and Type-3.
  • Created models with Star schema over EDW and Mart database.
  • Updated the Models with the metadata and the governed elements as part of governance
  • Experienced in explaining Banking Data Warehouseprocess, Worked with development team in halping them to understand the BDW logic and methods
  • Involved with data analysis using Teradata SQL Assist from data source.
  • Design the documents which included data flow model in VISIO, data mapping documents, design document which will assist the developer, transformations rule document which is mainly used to feed the project into the EMR (Enterprise Metadata Repository). Uploaded design data to the Enterprise Metadata Repository.
  • Experience in using IBM info sphere data stage tool for data integration
  • Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
  • Assist with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
  • Developed SQL/ PL -SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects. Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Analyze the existing packages and tune the SQL/ PL SQL to ensure efficiency and to provide support to all application developers.
  • Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.
  • Consolidate transactions from third party and created a dashboard as a one stop reporting for business
  • Conducted Design walkthroughs which better halped the developers to understand the design. Generated the DDL and assisted in designing the overall ETL strategy.
  • Maintained security and data integrity of the database.
  • Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
  • Directed a team with the integration effort for development and deployment of dashboards by creating dimensional models, merging BI platforms from enterprise data warehouse systems that allowed KPI's and scorecard metrics for executive decision support systems.
  • Created Dashboards based on the business requirement using SSRS and halped development team in noledge about the requirement.
  • Used Cognos reporting for analysis as per requirement. Data for the reports are sourced from Mart DB
  • Experience in data cleansing on the target database.
  • Did troubleshoot after implementation for production problems and created projected/ user documents
  • Effective team leader as explaining and halping them team in understanding the requirement and assigning work to the team.

Environment: IBM Infosphere data stage, Erwin 9.x/8.x, ER/Studio, Teradata SQL Assistant, SQL Server 2012, SSRS, Oracle 11g, Cognos

Data Architect/Data Modeler

Confidential, Columbus, OH

Responsibilities:

  • Responsible to design models to support reports followed by Dodd-Frank rules.
  • Understood the risk management requirements and developed conceptual model to walkthrough the business.
  • Developed data flows & architecture models for the requirement and halped the business by creating business process flow & workflow models.
  • Created logical & physical model for the Risk management reports and responsible for data mapping, metadata maintenance and governance.
  • Identified Multiple Dimensions and Fact tables. Used advance data modeling concepts of Degenerated dimension, sub-dimension, Fact less fact table, Aggregate fact tables in Multidimensional modelusing Erwin.
  • Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses usingKimball and Inmon Data Warehouse methodologies.
  • Implemented SQL Scripts to modify the data to resolve assigned defects.
  • Involved in conducting walkthroughs with business and development teams to validate end-to-end data mapping across various systems.
  • Designed the conceptual data model and worked with the Business analysts and technical teams to design and update the logical data model in various iterations. Involved in the entire System study, Analysis and Design.
  • Created Entity relationships diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.
  • Developed the data warehouse model (star schema) for the proposed central model. Also worked on normalizing star-schema to snow flake schema to fulfil requirement.
  • Exhaustively collected business and technical metadata and maintained naming standards
  • Updated the Models with the metadata and the governed elements as part of governance
  • Experience in using InformaticaPower Center tool for data integration
  • Worked on data cleansing techniques to make sure no duplicates are present in the data.
  • Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
  • Worked with the ETL team to document the SSIS packages for data extraction to Warehouse environment for reporting purposes.
  • Developed source to target mapping documents to support ETL design.
  • Created tables, views, sequences, indexes, triggers, table spaces, constraints and generated SQL/ PL SQL scripts for physical implementation.
  • Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers.
  • Monitored & recommended changes for SQL/ PL SQL packages and provide inputs to the design & development team.
  • Determined data rules and conducted Logical and Physical design reviews with business analysts, developers and DBAs.
  • Used NoSQL Database in Mark logic enterprise for handling large-scale systems in production and to read and report unstructured data
  • Used NoSQL to manage user & customer profile data.
  • Used Hadoop to analyze outcome data for generating recommendations, performing predictive analytics, and detecting fraudulent activities.
  • Designed Informatica mappings, enabling the extract, transform and loading of the data into target tables.
  • Designed the data sourcing, data staging and ETL process. Mapped the data between the source and targets.
  • Responsible for data validation and writing validation scripts once the data is loaded from source to target.
  • Developed data mapping documents between Legacy, Production, and User Interface Systems.
  • Experience in SSRS for maintaining reporting requirements and their respective dashboards.
  • Experienced in explaining complex Ad-hoc reports, Dashboard Reports, KPI’s, Business views containing charts showing sales, products, in-service customers, disconnects, revenue by regions, market areas & divisional managers using ERwin, Business Objects, Visual Studio, SSRS, Dashboards, Reports and SQL.
  • Participated and managed Scorecards to report on key metrics to Senior Management and other key stakeholders.
  • Experience in management of Risk data KPI monitoring process.
  • Extensively useddynamic performance views,data dictionary, as well asEnterprise Managerto monitor thedatabaseand performtuningactivities.
  • Directed to Create Dashboards based on the business requirement using SSRS and halped development team in noledge about the requirement.
  • Did troubleshoot after implementation for production problems and created projected/ user documents
  • Effective team leader as explaining and halping them team in understanding the requirement and assigning work to the team.

Environment: Erwin 8.x, /SQL, SQL Server, SSIS,SSRS, Teradata SQL Assistant 6.1, Oracle 10g, SAS, Business Objects, Informatica Power Centre, Crystal Reports 10/11 Mark Logic, Hadoop, Apache Hbase.

Data Architect/ Data Modeler

Confidential, Columbus, OH

Responsibilities:

  • Involved in requirement gathering meetings, brainstorming sessions and detailed design meets.
  • Involved in requirement analysis and understanding of business analysis and creating a design workflow. Designed ER diagrams.
  • Created conceptual, logical and physical models for OLTP, Data Warehouse Data Vault and Data MartStar/Snowflake schema implementations
  • Determine the data quality by doing data profiling and perform data cleansing on database
  • Developed data flows & architecture models for the requirement and halped the business by creating business process flow & workflow models.
  • Responsible for understanding the existing model and documenting the suspected design which is affecting the performance.
  • Designed & developed OLAP model for the reporting requirements using Erwin.
  • Identified the grain, key dimensions, facts and designed star and snowflake schema.
  • Experience in using IBM info sphere data stage tool for data integration
  • Updated the Models with the metadata and the governed elements as part of governance
  • Analyzed the data, which is using the maximum number of resources and made changes in the back-end code using SQL stored procedures and triggers.
  • Experience in management of Risk data KPI monitoring process.
  • Tuned SQL queries and indexed database tables wherever necessary and also partitioned databases.
  • Used SQL & PL/SQL triggers and Stored Procedures.
  • Involved in developing the business naming standards, consistent data definitions, data aliases and documenting the business rules of the enterprise
  • Involved in System Integration Testing and User Acceptance Testing.
  • Provide expertise and recommendations for physical database design, architecture, testing, performance tuning and implementation.
  • Directed the team to develop reports for business end users using Report Builder with updating Statistics.
  • Worked with report developers for building OLAP Cubes for ad hoc reporting.
  • Performed unit testing and tuned for better performance.
  • Involved in the critical design review of the finalized database model.
  • Designed XML schemas using Unified Modelling Language (UML) - translating business concepts into XML vocabularies.
  • Involved in scheduling backups of databases and logs and restoring them when necessary.
  • Interacted with the end users and found out the performance of the database and also involved in developing test cases.
  • Used Cognos reports for the data analysis on Business demand
  • Effective team leader as explaining and halping them team in understanding the requirement and assigning work to the team.

Environment: Erwin 8.x, ER/Studio, SQL, XML, SQL Server 2008 IBM DB2 Mainframe, IBM Data stage, Oracle 10g, Cognos, Report Builder.

Data Architect/Data Modeler

Confidential, Detroit, MI

Responsibilities:

  • Involved in requirement gathering along with the business analysts group.
  • Gathered all the Sales Analysis report prototypes from the business analysts belonging to different Business units
  • Requirements gathering by conducting meetings and brainstorming sessions with SMEs and senior management.
  • Developed data flows & architecture models for the requirement and halped the business by creating business process flow & workflow models.
  • Gathered various requirement matrices from the business analysts.
  • Participated in Joint Application Development(JAD) sessions
  • Designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, ConformedFacts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
  • Created conceptual, logical and physical models for OLTP, Data Warehouse Data Vault and Data MartStar/Snowflake schema implementations
  • Participated & designed OLTP model for the SOR requirements using Erwin.
  • Performed Data profiling & data quality assessment for the given SOR data.
  • Designed for the various reporting requirements
  • Designed a logical & physical data model using database tool Erwin r7.0
  • Used ER Studio to create logical and physical data models for enterprise wide OLAP system.
  • Developed monthly summary and downstream data marts from enterprise wide databases in accordance with reporting requirements with dimensions like time, customers, services and accounts.
  • Developed Star and Snowflake schemas based dimensional model to develop the data warehouse
  • Modelled the Multi dimensions and facts using Erwin for centralized data warehouse
  • Experience in using IBM info sphere data stage tool for data integration
  • Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
  • Developed source to target mapping documents to support ETL design
  • Worked with the ETL team to document the SSIS packages for data extraction to Warehouse environment for reporting purposes.
  • Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions
  • Actively participated in data mapping activities for the data warehouse.
  • Created summary tables using de-normalization technique to improve complex Join operations
  • Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis pertaining to Loan products
  • Participated in the tasks of data migration from legacy to new database system
  • Developed and maintained data dictionary to create metadata reports for technical and business purpose.
  • Worked on Metadata exchange among various proprietary systems using XML.
  • Updated the Models with the metadata and the governed elements as part of governance
  • Conducted Design reviews with the business analysts, content developers and DBAs
  • Designed and implemented a physical data model to handle marketing strategies and to satisfy reporting needs dynamically.
  • Organized User Acceptance Testing (UAT), conducted presentations and provided support for Business users to get familiarized with Loan products application.
  • Extensively useddynamic performance views,data dictionary, as well asEnterprise Managerto monitor thedatabaseand performtuningactivities.
  • Analyzed SQL/ PL SQL packages and recommended the changes to the design & development team to tune the SQL packages for better time response.
  • Experienced in explaining complex Ad-hoc reports, Dashboard Reports, KPI’s, Business views containing charts showing sales, products, in-service customers, disconnects, revenue by regions, market areas & divisional managers using ERwin, SSRS, Dashboards, Reports and SQL.
  • Participated and managed Scorecards to report on key metrics to Senior Management and other key stakeholders.
  • Experience in management of sales data KPI monitoring process.
  • Directed the team to Create Dashboards based on the business requirement using SSRS and halped development team in noledge about the requirement.
  • Participated in dashboards development and explained the concepts and requirements to the development team for the reporting requirements.
  • Participated and managed Scorecards to report on key metrics to Senior Management and other key stakeholders.
  • Handled performance requirements for databases in OLTP and OLAP models.
  • Directed the team to develop reports for business end users using Report Builder with updating Sales Statistics.
  • Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase
  • Did troubleshoot after implementation for production problems.
  • Created project/user documentation for the requirement.
  • Effective team leader as explaining and halping them team in understanding the requirement and assigning work to the team.

Environment: Erwin r7.0, SQL Server 2000/2005, SSIS, Mainframes, IBM Info sphere Data stage, UML, SQL Loader, Oracle, Report Builder .

Data Modeller

Confidential

Responsibilities:

  • Involved in gathering user requirements along with business analysts.
  • Worked directly with users to establish Business Requirements, defined and documented core business process information, business rules, business entities and other relevant information.
  • Part of team conducting logical data analysis and data modelling JAD sessions, communicated data-related standards.
  • Transformed project data requirements into project data models.
  • Performed Data profiling & data quality assessment from the SOR files.
  • Responsible as a member of development team to provide business data requirements analysis services, producing logical and Physical data models using ERwin r7.0.
  • Developed dimensional model for the SOR requirements using Erwin.
  • Experience in using InformaticaPower Center tool for data integration and processing the data from staging tables to the relational database
  • Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.
  • Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering.
  • Created entity process association matrices, functional decomposition diagrams and data flow diagrams from business requirements documents.
  • Involved in designing built Data marts by using Star Schema and Snowflake schema.
  • Closely worked with ETL process development team.
  • Experienced in designing the Data warehouse.
  • Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
  • Participated and managed Scorecards to report on key metrics to Senior Management and other key stakeholders.
  • Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
  • Directed the team to develop reports for business end users using Report Builder.
  • Experience in evaluating all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects for various application components.
  • Generated the first cut physical design.
  • Developed data mapping documents between Legacy, Production, and User Interface Systems.

Environment: Erwin r7.0, ER/Studio 7.x & 8.x, SQL Server 2000/2005, Mainframes, Informatica Power Centre, Oracle 8i, UML, SQL Loader, Report Builder.

Data Modeller/Analyst

Confidential

Responsibilities:

  • Involved in gathering user requirements along with business analysts.
  • Worked directly with users to establish Business Requirements, defined and documented core business process information, business rules, business entities and other relevant information.
  • Part of team conducting logical data analysis and data modelling JAD sessions, communicated data-related standards.
  • Transformed project data requirements into project data models.
  • Performed Data profiling & data quality assessment from the SOR files.
  • Responsible as a member of development team to provide business data requirements analysis services, producing logical and Physical data models using ERwin r7.0.
  • Experience in using Informatica tool for data integration
  • Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.
  • Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering.
  • Created entity process association matrices, functional decomposition diagrams and data flow diagrams from business requirements documents.
  • Involved in designing built Data marts by using Star Schema and Snowflake schema.
  • Closely worked with ETL process development team.
  • Experienced in designing the Data warehouse.
  • Good understanding of Ralph Kimball (Dimensional) & Bill Inmon (Relational) model Methodologies.
  • Participated and managed Scorecards to report on key metrics to Senior Management and other key stakeholders.
  • Created SQL/ PL -SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects. Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
  • Particiated in evaluating all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects for various application components.
  • Generated the first cut physical design.
  • Developed data mapping documents between Legacy, Production, and User Interface Systems.

Environment: Erwin r7.0, ER/Studio 7.x & 8.x, MS SQL Server 2000/2005, Mainframes, Informatica Power Centre, Oracle 8i, UML, SQL Loader.

Hire Now