We provide IT Staff Augmentation Services!

Data Architect/ Sr. Data Modeler Resume

3.00 Rating

Parsippany, NJ

SUMMARY

  • Goal - oriented IT professional with strong background in Data Analysis & Modeling.
  • Excellent knowledge of waterfall and spiral methodology of software development life cycle (SDLC).
  • Strong Knowledge of Data Warehouse Architecture and Star Schema, Snow flake Schema, FACT and Dimensional Tables.
  • Participated in JAD sessions and requirements gathering & identification of business subject areas.
  • Created, documented and maintained logical and physical database models in compliance with enterprise standards.
  • Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model.
  • Used the Ralph Kimball Methodology for Data Warehouse and Data Mart designs.
  • Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
  • Managed the meta-data for the Subject Area models for both Operational & Data Warehouse/Data Mart applications.
  • Have worked with ETL tools to migrate data from variousOLTPdatabases to the data mart.
  • Excellent knowledge inSQLand codingPL/SQLPackages, Procedures.
  • Managed performance and tuning of SQL queries and fixed the slow running queries using utilities like Explain, Trace, and Tkprof.
  • Proficient in creating Views, Materialized views & Partitions for the Oracle warehouse.
  • Experience in technologies, including Oracle 9i/10g/11g, MS SQL Server 2008/2008R2, MS Access, Microsoft Visio, Visual Basics, Windows DOS andUNIXshell scripting.
  • Experience as a System Administrator in the financial environment working on VMWare, Appworx and IBM Mainframe.
  • Experienceon hardware and software issues in Windows 9x/2000/NT/XP/Server2003/Vista/7/Server2008/8, Mac OS 10.4/10.5/10.6/10.7/10.8 and Linux Ubuntu 10.10/11.04/11: 10/12.04/12.10.
  • Strong analytical ability with the capability to determine the root cause of problems and provide solutions to the issues.
  • Ability to juggle multiple, competing, frequently changing time-sensitive deadlines and priorities.
  • I have excellent communications skills and work well with end users and management.
  • Strong project management skills: Plan, organize, monitor, and control projects, ensuring efficient utilization of resources, to achieve project objectives and deadlines.

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

Data Architect/ Sr. Data Modeler

Responsibilities:

  • Contacted JAD sessions, gathered information from Business Analysts, SQL Developers, end users and stakeholders to determine the requirements or various systems.
  • Created and documented the models, data Workflow Diagrams, Sequence Diagrams, Activity Diagrams and field mappings of all existing system.
  • Used the Pragmatic Doc Xpress, Modeling tools and SQL Server Data Tools to extract, create and document the models, E-R Diagrams, Workflow and Data mapping of all existing SSIS packages.
  • Optimized the integrations of the different systems by creating the proper modeling of all the systems.
  • Designed and Created Master Data Management (MDM) system using Microsoft Master Data Services (MDS) to maintain data integrity and data profiling.
  • Created and maintained Logical Data Model (LDM) for the project whichincluded documentation of all entities, attributes, data relationships, referential integrity, domains, codes, business rules, glossary terms, etc.
  • Reverse engineered the existing systems to create and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports using Erwin v9 and Toad V5 data modeling tools
  • Documented the integrations between the different onsite and cloud based systems using tools like BI Documenter and SQL Server tools.
  • Used ETL tools to extract, transform and load data into data warehouses from various sources like relational databases, application systems.
  • Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Environment: Erwin 9.6, Toad, MS SQL Server 2012, 2014, MS Dynamic NAV, MS CRM, ServiceNow, Sales Force, MS Visio, BI Xpress, Oracle 11g, IBM Data Stage

Confidential, Hackensack NJ

Data Modeler

Responsibilities:

  • Participated in JAD sessions, gathered information from Business Analysts, end users and other stakeholders to determine the requirements.
  • Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modelling.
  • Involved in translating business requirements into data requirements.
  • Used data vault modeling method which was adaptable to the needs of this project.
  • Created and maintained Logical Data Model (LDM) for the project whichincluded documentation of all entities, attributes, data relationships, referential integrity, domains, codes, business rules, glossary terms, etc.
  • Created business requirement documents and integrated the requirements and underlying platform functionality.
  • Maintained data model and synchronized it with the changes to the database.
  • Involved in the modeling and development of Reporting Data Warehousing System.
  • Used ETL tools to extract, transform and load data into data warehouses from various sources like relational databases, application systems.
  • Developedstored procedures and triggers, packages, functions and exceptions using PL/SQL
  • Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Environment: IBM Data Architect 9,Netezza 7, Cognos 10, MS Visio, Oracle 11g, IBM Data Stage, Toad

Confidential, New Jersey

Data Modeler

Responsibilities:

  • Facilitated logical JAD sessions to discuss and gather business requirements for all assigned projects.
  • This process included scheduling meetings with the business and application groups, documenting agendas and minutes.
  • Participatedin data analysis and data dictionaryandmetadata management - Collaborating with business analysts, ETL developers, data quality analysts and database administrators.
  • Designed Order provisioning business processes, target applications architecture and target data model as well as developed relational and dimensional model
  • Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
  • Validated and maintained the enterprise-wide logicaldatamodel forDataStaging Area.
  • Worked at conceptual/logical/physical data model level using Erwin according to requirements.
  • Aided and verified DDL implementation by DBAs, corresponded andcommunicated data and system specifications to DBA, development teams, managers and users.
  • Managed the meta-data for the Subject Area models for both Operational & Data Warehouse/Data Mart applications.
  • Conducted data profiling, qualities control/auditing to ensure accurate and appropriate use ofdata.
  • Used Data Stageto extract data from relational databases, various file formats. Cleansed and transformed the data before loading it to target database.

Environment: ERWIN 7, 8,Oracle 10g, SAP Business ObjectsData Services3.X

Confidential, Bridgewater, NJ

Sr. Data Analyst/Modeler

Responsibilities:

  • Attended and participates in information and requirements gathering sessions.
  • Translated business requirements into working logical and physicaldata models for Staging, Operational Data Store and Data marts applications.
  • Performed gap analysis and dependency analysis for current & future systems.
  • Designed Star Schema Data Models for Enterprise Data Warehouse using Power Designer.
  • Created Mapping documents for Staging, ODS & Data Mart Layers.
  • Created and maintained Logical & Physical Data Models for the project. Included documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
  • Validated and updated the appropriate Models to process mappings, screen designs, use cases, business object model, and system object model as they evolved and changed.
  • Created Model reports including Data Dictionary, Business reports.
  • Generated sql scripts and implemented the relevant databases with related properties from keys, constraints, indexes& sequences.
  • Performance tuning

Environment: Power Designer 11, Oracle 11g, Informatica, Toad

Confidential, Philadelphia PA

Data Modeler

Responsibilities:

  • Reviewed functional requirements and use cases to determine the necessary data requirements.
  • Participated in creating realistic project plans with detailed tasks and ensuring their timely execution.
  • Reversed engineered current system data model and subdivided it into work streams for analysis and generated data source to target mapping documents.
  • Created process flows and data flowdiagrams of the current and future systems.
  • Performed dependency and gap analysis for data structure changes on other downstream applications and impact of new data elements on existing downstream processes.
  • Designed and produced logical and physical data models for the financial platform and other in-house applications running on Oracle databases.
  • DevelopedETLprocedures for moving data from source to target systems.
  • Worked closely with both functional and technical team on the creation of data models which can seamlessly integrate with existing data structures on multiple Oracle databases integrated by database links.
  • Generated Surrogate Key for the dimensions in the fact table for indexed and faster access of data.
  • Maintain database standards documents example Naming standards document, Data dictionary to ensure consistency.

Environment: ERWIN 4, 7, MS Visio, Toad, Oracle 10g/11g, PL/SQL, SQL*Plus, Toad, Data Stage

Confidential, Mercer County NJ

Database Administrator/Data Modeler

Responsibilities:

  • Managed database elements, including creation, alteration, copying and deleting of schema, databases, tables, views, indexes, stored procedures, triggers and declarative integrity constraints on both oracle and SQL server databases.
  • Sets up access privileges to databases and maintained user profiles for database access, including login and password and configured database parameters and prototypes designs against logical data models.
  • Performed backup and recovery on Oracle databases using RMAN, Export/Import and Flashback Technologies
  • Experience in Performance Tuning & Optimization of SQL statements including Indexing, Row Chaining,Row Migration and routine DBA activities on Oracle database instances.
  • Maintained database architectures and strategies to ensure performance, availability, integrity and security of client databases.
  • Designed and developed various applications using oracle products/tools for process automations software into database server using UNIX shell scripts, PL/SQL packages, procedures and database triggers based on client/server and multi-tier technologies.
  • Performed Microsoft SQL database design, SQL coding, stored procedures on SQL server 2008 and worked with DBA on backend database related activities like export and import.
  • Maintaining logical & Physical Data Models

Environment: SQL Server 2005/2008/2008 R2,Oracle 10g/11g, SQL, PL/SQL, UNIX

Confidential

System Administrator

Responsibilities:

  • Updated systems operating system and applications on both Windows and Linux OS and implement the policies for the use of the computer system and network.
  • Installed, troubleshoot and repair GPRS internet systems and GPRS internet related problems.
  • Performed daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups.
  • Analyzed system or application usage and plan for growth or increases in network capacity.
  • Managed communications and connection solutions, including local area networks, company intranet, and Internet applications and ensure the integrity of host computers, multiple databases and data transfer.
  • Maintained database architectures and strategies to ensure performance, availability, integrity and security of client databases. Also generated reports, queries and documentations on both Oracle and SQL Server databases.
  • Maintained network hardware and software and IT Appliances - includes pushing OS updates, firmware updates etc. Optimize Network Performance and Implement Best Practices.
  • Installed and configured hardware, software, peripherals, services, directories and storage of new servers and rebuild existing ones in accordance with standards and project requirements.

Environment: Oracle 9i/10g, SQL, Linux, Microsoft Server 2003, Windows XP, MS Access

We'd love your feedback!