SUMMARY:

• Over 15 years of experience in the Information Technology field working as a system administrator, database administrator, data modeler and data architect
• More than 9 years of experience with extensive knowledge in Data Modeling for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Multiple years of experience working with industry standard analysis techniques to uncover client requirements and identifying the roles and deliverables in the Organization by creating Use Case Models, Data Flow Models along with Activity Diagrams, Sequence Diagrams and State Diagrams using Microsoft Visio.
• Experienced in the Design, Development and Implementation of the enterprise - wide architecture for structured and unstructured data, providing architecture and consulting services to Business Intelligence initiatives and data driven business applications.
• Experienced in ER Diagrams and Logical/Physical Design in Dimensional Modeling using Star schema and Snowflake schema methodologies of Data Warehouse and Data Marts.
• Experienced in Transactional, Operational and Dimensional Data Modeling in multiple database environment which includes Hadoop semantic layer, Hive, Teradata, Oracle, Cassandra, MS SQL Server.
• About 8 years of experience in leading data management initiatives (Data Profiling, Improvement, Accuracy, Completeness, Integrity, Security, Stewardship, and Governance).
• Excellent knowledge in Erwin Data Modeler, SQL and ETL tools like SSIS, Talend and Informatica. Hadoop, Hive, Cassandra.
• Multiple years of experience in database technologies, including Oracle 9i/10g/11g/12c, DB2 9.5, 9.7 & 10.1, Hadoop, MS SQL Server 2008/2008R2/2012/2014, Teradata 14, 15, XML Schemas, MS Access, Microsoft Visio, Visual Basics, Windows DOS and UNIX shell scripting.

EXPERIENCE:

Confidential: Philadelphia, PA

Senior Data Architect

Responsibilities:

• Work on Agile methodology and delivered successfully on time all sprint deliverables.
• Designed and modeled multiple data model for the current expected credit loss (CECL) system addresses the weakness to the current incurred loss methodology.
• Creates documents and maintains the models, Source to target documents, data Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Data Dictionary for multiple systems and environments.
• Designed and modeled the Fulton Data Marketplace Data Warehouse which comprises multiple data marts.
• Reverse engineered many legacy systems to understand and document the process as well as redesign the systems for better performance and with current technology and environment.
• Work on a broad range of projects and provide technical oversight for other members of the projects.
• Define the corporate data architecture and related standards that includes but not limited to data integration architecture, data warehouse and business intelligence architecture, data modeling tools and standards.
• Work with the data governance team to define, design and manage data and master data programs.
• Work with the data quality team to define and maintain matching rules, data cleansing rules and standard control rules for error free data loading.
• Provide regular advice, direction and support to Data Analysts with hands on demonstrations of proper techniques and disciplines across all functions.
• Performed dependency and gap analysis for data structure changes on other downstream applications and impact of new data elements on existing downstream processes.

Environment: erwin 9.8, SQL Server 2016, Oracle 11g, Python, erwinDG, SAS, SSIS, TFS

Confidential: Wilmington, DE

Data Solutions Architect

Responsibilities:

• Worked in Agile methodology and facilitated sessions with data warehousing partners including business, BA (Business Analyst), BI (Business Intelligence), SOR SMEs (System of Record Subject Matter Experts) and ETL (Extract, Load, and Transform) developers to assess business requirements and deliver design prototypes.
• Worked with the Data Governance team to ensure that all projects meet both the company and the financial services standards.
• Preformed data management initiatives that included data profiling, improvement, data lineage, completeness, integrity, security, stewardship, and governance on both the operational and analytical systems.
• Designed complete architecture for multiple data requirement that meet multiple business needs.
• Designed and modelled a centralized Product Catalogue ODS system on both Cassandra and Hive platforms for near real time analytics used by the Data Ecosystem.
• Created complex logical and physical data model with data mapping for Hadoop semantic layer, Teradata, Cassandra, Hive and Oracle database systems
• Created complete source to target data mapping document with transformation rules as well as generated SQL DDL scripts for Teradata, Hive, Cassandra and Oracle database systems
• Enforces compliance of data standards to minimize data redundancies and enhance information quality throughout the organization.
• Delivered logical and physical data model for both Dimensional & Relational concepts like Star-Schema modelling and Snowflake Schema modelling using Erwin.
• Created and maintained User Defined Properties (UDP), Naming Standards, Class words and Domain structure for proper integrated data dictionary & metadata management in all Erwin data model design.
• Created and maintain the conceptual, logical and physical data models that define the information required for management and business intelligence purposes using Erwin Data Modeler.
• Redesigned and remodeled the Credit Cards Mobile Payment Platform (MPP) from IBM Banking Data Warehouse (BDW) model to Big Data environment designed for distributed and scalable file system such as HDFS (Hadoop Distributed File System). Also designed and modeled a Hive platform for the data consumption.

Environment: Erwin 9.7, Teradata 15.10, Oracle 11g, Hadoop, Hive, Cassandra, Ab-Initio, SVN

Confidential: Philadelphia, PA

Data Architect /Sr. Data Modeler

Responsibilities:

• Conducted JAD sessions to gather information from Business Analysts, SQL Developers, end users and stakeholders to understand and determine the requirements of a project and the various systems.
• Worked with the ETL Developers to developed and supported ETL data standards as well as data architecture policies, domains and procedures.
• Preformed data management initiatives that included data profiling, improvement, accuracy, completeness, integrity, security, stewardship, and governance on the operational systems that I worked on.
• Monitored and enforced compliance of data standards to minimize data redundancies and enhance information quality throughout the organization.
• Created and documented the models, data Workflow Diagrams, Sequence Diagrams, Activity Diagrams, Data Dictionary and field mappings for the CABS Billing ODS and Dimensional Data Warehouse.
• Proficient in using Erwin Reverse engineering, Forward engineering and Complete Compare functions to create, updated and resolve issues with existing data models.
• Created and implemented Erwin Naming Standards and Domain in the design and creation of logical and physical data models in accordance with the company’s standards.
• Worked with others Data Modeler, DBAs and Developers using Microsoft Team Foundation Server to ensure the proper consideration and successful completion of all aspect of the project.
• Created and maintained the conceptual, logical and physical data models that define the information required for management and business intelligence purposes using Erwin Data Modeler.
• Worked with the DBAs and SQL Developers to deploy and maintain the developed physical data models.
• Created and owned data models, solution designs and data architecture documentation for complex information systems also managed all changes to the data models.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from the source and SQL Server database systems.

Environment: ERwin 9.64, MS SQL Server 2012, 2014, Teradata 15.10, ServiceNow, Sales Force, MS Visio, Microsoft Visual Studio 2012, 2013, Microsoft Team Foundation Server, SSIS

Confidential: Parsippany, NJ

Enterprise Data Architect

Responsibilities:

• Led JAD sessions with the Business Analysts, Developers, Management and stakeholders to gather and understand the requirements of various systems and ensure that the enterprise data standards were followed and enforced.
• Maintained and enhanced the metadata infrastructure, the data dictionary and business metadata as well as facilitated the publishing of the information to the business and technical communities.
• Worked with the business to create the appropriate business rules for data usage and integration.
• Established enterprise standard for master data management.
• Created and documented the models, data Workflow Diagrams, Sequence Diagrams, Activity Diagrams and field mappings of all existing system.
• Provided IT technical expertise on systems, technical infrastructure, tools, data modeling, external interfaces for various platforms, and other areas like software, middleware, and/or hardware projects (e.g., applications, networks, communications, and client server technologies).
• Used the Pragmatic Works Doc Xpress, Modeling tools, XML Schemas and SQL Server Data Tools to extract, create and document the models, E-R Diagrams, Workflow and Data mapping of all existing SSIS packages.
• Worked with project and application teams to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs.
• Generated and documented data lineage that included ETL from the operational source to the target systems using tools like Pragmatic Works BI Xpress.
• Designed and Created Master Data Management (MDM) system using Microsoft Master Data Services (MDS) to maintain data integrity and data quality.
• Identified all data issues by analyzing and isolating the issues using Talend Open Studio and worked with the business analysts and the developers to resolve the issue and ensure data quality.
• 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.
• Conducted and Participated in the development and assurance of compliance with architecture principles and standards for the various systems and components based on design patterns.
• 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, XML Schemas, MS Dynamic NAV, MS CRM, ServiceNow, Sales Force, MS Visio, SSIS, BI Xpress, Oracle 11g, Talend Open Studio

Confidential: Hackensack, NJ

Data Modeler

Responsibilities:

• Communicated with technical leads, IT groups, and clients to help them understand the project's technical implications, dependencies, and potential conflicts.
• 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 and the evaluation of the impacts of any change requests on own/shared technologies.
• Used data vault modeling method that was adaptable to the needs of the project.
• Created and maintained Logical Data Model (LDM) for the project, whichincluded documentation of all entities, attributes, data relationships, referential integrity, domains, business rules, glossary terms, etc.
• Created business requirement documents and integrated the requirements as well as the underlying platform functionality into logical data models.
• Created and maintained the source to target mapping including the transformations using the IBM FastTrack.
• Maintained data model and synchronized it with the changes to the database.
• Worked with the Business Analysts to ensure a complete and proper documentation of the projects.
• Worked with the Developers to ensure the proper understanding of the existing complex data model of the hospital and ensured complete application of all business rules.
• 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, IBM InfoSphere FastTrack, Netezza 7, Teradata 14, MS Visio, Oracle 11g, ER/Studio Data Architect 9.6, Informatica

Confidential: Cherry Hill NJ

Lead Data Analyst / 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.
• Created process flows and data flow diagrams 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.
• Created logical and physical data models that define the information required for management and business intelligence purposes using Erwin Data Modeler.
• Managed the meta-data for the Subject Area models for both Operational & Data Warehouse/Data Mart applications.
• Oversaw the company’s data and gave recommendations on how to ensure Data Governance and improve Data Integrity starting from the Source system - ETL - Target system.
• Developed, improved and supported enterprise data standards, data architecture policies and procedures.
• Monitored and enforced compliance of data standards to minimize data redundancies and enhance information quality throughout the organization.
• Designed Star Schema Data Models for Enterprise Data Warehouse using Power Designer.
• Managed the informatics technologies, ETL, BI, management, database management systems, data cleansing, data profiling and data quality tools such as Talend Open Studio.
• Ensured Data Integrity, availability and compliance of the systems using Talend Open Studio
• Created Mapping documents for Staging, ODS & Data Mart Layers.
• Created and maintained Logical & Physical Data Models including 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.
• Worked closely with both the functional and the technical teams on the creation of data models that was integrate with existing data structures on multiple Oracle databases.
• 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 6, 7, MS Visio, Toad, Oracle 10g/11g, PL/SQL, SQL*Plus, Toad, Data Stage, DB2 9.5 & DB2 9.7, SQL Server 2008, Informatica, Toad, Talend Open Studio

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.
• Created and maintained logical data and physical data models for OLTP systems as well as the documentation of the data mappings for the project.
• Reverse engineered and created physical data models from existing databases using ER Studio and used the models to improve and enhance performance of the 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.
• Managed performance and tuning of SQL queries and fixed the slow running queries using utilities like Explain, Trace, and Tkprof.
• 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.
• Generated SQL scripts and implemented the relevant databases with related properties from keys, constraints, indexes & sequences.

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