SUMMARY:

• Above 9+ years of experience in Data Architect and Data Analysis/Data modeling, Data Development, Implementation and Maintenance of databases and software applications.
• Architect and design conceptual, logical and physical models and build data marts using hybrid Inmon and Kimball DW methodologies
• Experience in designing star schema, Snowflake schema for Data Warehouse, ODS architecture.
• Solid knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snow - Flake Modeling for FACT and Dimensions Tables) using Analysis Confidential .
• Specialization in Data Modelling, Data warehouse design, Building conceptual Architect, Data Integration and Business Intelligence Solution.
• Developing full life cycle software including defining requirements, prototyping, designing, data mapping, coding, testing and maintain/upgrade software, Developing Database Architecture using design standards and tools including Erwin, IBM Info Sphere, and Data Architect.
• Architected solution and designed data structures for the business to gain an insight into customer's survey and technician's performance scores and customer satisfaction.
• Good experienced in Dimensional and Relational Data Modeling using Star and Snowflake Schemas, OLTP/OLAP system, Fact and Dimension tables, Conceptual, Logical and Physical data modeling using Erwin.
• Experienced in SQL queries and optimizing the queries in Oracle, SQL Server, DB2, and Netezza& Teradata.
• Extensive experience with various data processing platforms and languages including Apache Spark(Scala), Apache Drill, Python, Oracle PL/SQL, and PostgreSQL PL/pgSQL.
• Experience in data analysis using Hive, Pig Latin, and Impala.
• Good knowledge in Normalization and De-Normalization techniques for optimum performance in relational and dimensional database environments and have performed normalization up to 3NF.
• Good knowledge in designing the Conceptual, Logical and Physical data modeling using Erwin and Data modeling.
• Experience in Database Creation and maintenance of physical data models with Oracle, Teradata, Netezza, DB2 and SQL Server databases.
• Experience in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems (ODS, ADS and Data Marts).
• Experience in data extraction from flat files, Excel files, OLE database source to data warehouse, packages were created using MS SQL Server Integration Confidential (SSIS).
• Good knowledge of Data Marts, Operational Data Store (ODS), Dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables) using Analysis Confidential .
• Excellent experience in writing and executing unit, system, integration and UAT scripts in a data warehouse projects.
• Experience with Client-Server application development using Oracle PL/SQL, SQL PLUS, SQL Developer, TOAD, and SQL LOADER.
• Very good experience in Normalization (1NF, 2NF, 3NF and BCNF) De-normalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Expertise in SQL Server Analysis Confidential (SSAS) and SQL Server Reporting
• Confidential (SSRS).
• An excellent team player & technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the.

PROFESSIONAL EXPERIENCE:

Confidential,Fairbanks,AK

Sr.ETL QA Tester

Responsibilities:

• Provide data architecture support to enterprise data management efforts, such as the development of the enterprise data model and master and reference data, as well as support to projects, such as the development of physical data models, data warehouses and data marts.
• Lead Architectural Design in Big Data, Hadoop projects and provide for a designer that is an idea-driven.
• As a Architect implement MDM hub to provide clean, consistent data for a SOA implementation.
• Involved in developing Database Design Document including Data Model Conceptual, Logical and Physical Models using Erwin 9.6.
• Managing infrastructure and security architecture with other architects.
• Involved in integration of various relational and non-relational sources such as Oracle, XML and Flat Files.
• Data Modeler in a centralized group doing logical and physical data models in ERWIN. Also, wrote database interface specifications and documented in Data Manager data dictionary.
• Involved in OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports using multi-dimensional models such as Star Schemas and Snowflake Schema.
• Used Star Schema and Snowflake Schema methodologies in building and designing the Logical Data Model into Dimensional Models.
• Involved in Data loading using PL\SQL Scripts and SQL Server Integration Confidential packages
• Performed the Data Mapping, Data design (Data Modeling) to integrate the data across the multiple databases in to EDW.
• Responsible for technical data governance, enterprise wide data modeling and database design.
• Developed Logical data model using Erwin and created physical data models using forward engineering.
• Worked closely with the ETL Developers to explain the complex Data Transformation using Logic.
• Performed dimensional Modeling on OLAP system using Ralph Kimball methodologies.
• Excellent in creating various artifacts for projects which include specification documents, Data mapping and data analysis documents.
• Involved in several facets of MDM implementations including Data Profiling, Metadata acquisition and data migration.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using Star and Snowflake Schemas.
• Defined best practices for data modeling and extraction and ensure architectural alignment of the designs and development.

Environment: Erwin9.6, Hadoop, ODS, Oracle 12c, Confidential -SQL, SQL, ETL,, MDM, PL/SQL, OLAP, OLTP.

Confidential,Anchorage,AK

Sr. Data Architect/Data Modeler

Responsibilities:

• Interaction with Business Analyst, SMEs and other Data Architects to understanding Business needs and functionality for various project solutions
• Involved in documentation of Data Modeler/Data Analyst and ETL specifications for Data warehouse using Erwin.
• Independently coded new programs and design Tables to load and test the program effectively for the given POC's using Big Data/Hadoop.
• Involved in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
• Developed, managed and validated existing data models including logical and physical models of the data warehouse and source systems utilizing a 3NF model.
• Developed data designs that fully supported the current business needs and which were flexible enough for future requirements.
• Full life cycle of Data Lake, Data Warehouse with Big data technologies like Spark, Hadoop.
• Extensively used MS Visio for representing existing and proposed data flow Diagrams.
• Translating high level business requirements into solution, infrastructure architectures, involved enterprise architects to align strategic view.
• Managed, designed, and created the Star Schema and Snowflake Schema for a financial data mart using Erwin and DB2 using Ralph Kimball dimensional modeling techniques.
• Involved in Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Performed data modeling to differentiate between OLTP and Data Warehouse data models.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle, and DB2 database.
• Performed the Data Modeling effort for the gaps identified while data mapping.

Environment: Erwin 9.x, Hadoop, Spark, ETL,, PL/SQL, MDM, Erwin, OLTP, Oracle 12c/11g, DB2, SQL server, BTEQ,, MS Access, Excel.

Confidential,Anchorage,AK

Sr. Data Modeler/Data Architect

Responsibilities:

• Worked extensively in Teradata data modeling for both logical and physical data models.
• Used Erwin and Normalization and De-normalization Techniques to design Logical and Physical Data Models, relational database design.
• Involved in relational and dimensional Data Modeling for creating Logical and Physical design of the database and ER diagrams using data modeling like Erwin.
• Developed various Qlikview Data Models by extracting and using the data from various sources files, Excel, and Big data, Flat Files.
• Involved in OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports using multi-dimensional models such as Star Schemas and SnowFlake Schema
• Involved in Teradata utilities (BTEQ, Fast Load, Fast Export, Multiload, and Tpump) in both Windows and Mainframe platforms.
• Created a Logical Design and Physical Design in Erwin and used Erwin for developing Data Model using Star Schema methodologies.
• Applied Hot-bug fixes and also version patches for Teradata and Informatica power center.
• Involved in designing the data warehouse using Ralph Kimball's and Bill Inmon techniques.
• Worked in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Lead data architect and designer of next generation high-speed data ingestion / cleanse / transform pipeline spanning thousands of columns of data.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from Teradata database.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snow flake Schemas.
• Extensively worked with Developers and ETL team in enhancing the models and co-ordinate the same with DBA in implementing those changes into Applications or Databases.
• Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Ability to document activities and communicate with Data Architects as to status of Physical Data Modeling activities.
• Conducted Learning sessions for business users, analysts, QA team to provide insight into data model and providing documentations.

Environment: Erwin, Teradata 13, Data Modeler, SSIS, Confidential -SQL, SQL Server, PL/SQL, Informatica Power Center.

Confidential,Anchorage,AK

Sr. Data Modeler/Data Analyst

Responsibilities:

• Involved in OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports using multi-dimensional models such as Star Schemas and Snow Flake Schema.
• Created Physical Data Analyst from the Logical Data Analyst using Compare and Merge Utility in ER Studio and worked with the naming standards utility.
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL*Loader and Handled Exceptions.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures and Collections.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Developed Logical and Physical data models that capture current state/future state data elements and data flows using ER Studio / Star Schema and Snowflake Schema.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Involved in administrative tasks, including creation of database objects such as database, tables, and views, using SQL, DDL, and DML requests.
• Worked on Data Analysis, Data profiling, and Data Modeling, data governance identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.
• Loaded multi format data from various sources like flat-file, Excel, MS Access and performing file system operation.
• Used Confidential -SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Worked on designing Logical and Physical Data Models for different database applications using the ER Studio.

Environment: ER Studio, Oracle10g, Netezza, Data Modeler, Confidential -SQL, SQL Server, PL/SQL, ETL, etc.

Confidential,Soldotna,AK

Sr. Data Modeler/Data Analyst

Responsibilities:

• Gathered Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Used SQL for Data Analysis and to understand and documenting the data behavior within and between two companies Erwin.
• Worked on Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Created the conceptual model for the data warehouse using Erwin data modeling tool.
• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Involved in Data Analysis, Data Profiling, Data Migration, Data Integration and validation of data across all the integration points.
• Generated and DDL (Data Definition Language) scripts using ERWIN 7 and assisted DBA in Physical Implementation of data Models.
• Designed both 3NF Data models for DB2 systems and dimensional Data models using Star and Snowflake Schemas.
• Identified Facts and Dimensions from the business requirements and developed the logical and physical models using ERWIN
• Created scheduled batch jobs using PL/SQL for downloading data into temporary tables to generate the data required for some of the reports.
• Wrote and executed SQL queries to verify that data has been moved from transactional system to DSS, Data warehouse, data mart reporting system in accordance with requirements.
• Created a list of domains in Erwin and worked on building up the data dictionary for the company.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs. Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Performed ETL SQL optimization designed OLTP system environment and maintained documentation of Metadata.
• Wrote PL/SQL statement, stored procedures and Triggers in DB2, Confidential -SQL for extracting as well as writing data.
• Worked with BTEQ to submit SQL statements, import and export data, and generate reports.
• Worked with the team of business analysts, developers and end users for generating audit reports and troubleshoot the related queries and fix the connectivity issues.

Environment: ERWIN 7, Data Analyst, SQL, PL/SQL, Teradata, Confidential -SQL, SQL Server, DB2, PL/SQL, OLTP.