We provide IT Staff Augmentation Services!

Sr. Data Modeler/data Analyst Resume

4.00/5 (Submit Your Rating)

Omaha, NB

SUMMARY

  • 9+ years of IT industry experience in Data analysis, Data modeling for OLTP, OLAP and BigData projects
  • Experience in Dimensional Data Modeling, Star/Snowflake schema, FACT& Dimension tables.
  • Understanding in development of Conceptual, Logical and Physical Models for Online Transaction Processing and Online Analytical Processing (OLTP&OLAP).
  • Skillful in Data Analysis using SQL on Oracle, MSSQLServer, DB2&Teradata.
  • Excellent experience in trouble shooting SQLqueries, ETL jobs
  • Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
  • Designed and developedDataMarts by following Star Schema and Snowflake Schema Methodology, using industry leadingDataModeling tools like Erwin.
  • Performed data analysis anddata profiling and Expert in writing SQL queries and optimizing the queries in Oracle,SQL Server 2008/2012, Netezza and Teradata
  • Strong and Excellentexperience in Data Analysis,Data Migration, Data Validation, Data Cleansing, Data Verification, identifying data mismatch, Data Import, and Data Export through the use of tools such as Informatica and IBM Infosphere Data Architect.
  • Excellent experience on Teradata SQL queries, Teradata Indexes, Utilities such as Mload, Tpump, Fast load and FastExport.
  • Experience in Data masking using Informatica data masking transformation and Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
  • Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments.
  • Experienced working with Excel Pivot and VBA macros for various business scenarios.
  • Experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
  • Solid hands on experience with administration of datamodel repository, documentation in meta data portals in such as Erwin, ER Studio and Power Designer tools.
  • Expertise in all aspects of data management methods and practices including Data Modeling, creation of Logical and Physical Data Models (LDMs/PDMs), Design of Data warehouse schemas, Forward engineering and reverse engineering, Data migration/conversion with ETL tools and data warehousing.
  • Strong experience with data mining and management with huge data sources (Oracle/Teradata, Hadoop, NoSQL, Netezza)
  • Solid experience in working and creating 3rd Normal Forms (ODS) and Dimensional models (OLAP)
  • Have good exposure on working in offshore/onsite model with ability to understand and/or create functional requirements working with client and also have Good experience in requirement analysis and generating test artifacts from requirements docs.
  • 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 project.

TECHNICAL SKILLS

Data Modeling Tools: Erwin R8/R9, IBM Infosphere Data Architect, ER Studio

Database Tools: Microsoft SQL Server12.0/16, Teradata 15.0, Oracle 12c/11g, NetezzaBI Tools: Tableau 8.2, Tableau server 8.2, SAP Business Objects, Crystal Reports Packages Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server

Version Tool: VSS, SVN, CVS, TFS

Tools: & Software: TOAD, MS Office, BTEQ, Teradata SQL Assistant

Operating System: Windows, Unix, Sun Solaris

ETL/Datawarehouse Tools: Informatica 9.6/9.1/8.6.1/8.1 , Talend, Pentaho

Project Execution Methodologies: Ralph Kimball and BillInmondatawarehousing methodology, Rational Unified Process (RUP), Rapid Application Development (RAD), Joint Application Development (JAD)

Quality Assurance Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, Quality Center, Rational Functional Tester.

RDBMS: Microsoft SQL Server14.0, Teradata 15.0, Oracle 12c/9i, and MS Access

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NB

Sr. Data Modeler/Data Analyst

Responsibilities:

  • Owned and managed all changes to the data models. Created data models and documentation for complex information systems.
  • Inherited enterprise data requirements and definitions from the Enterprise Information Models for use in projects and data-related initiatives.
  • Implementation of full lifecycle inDatawarehouses and BusinessDatamarts with Star Schemas, Snowflake Schemas, SCD &DimensionalModeling.
  • Worked with reversed engineer Data Model from Database instance and Scripts.
  • Responsible for Dimensional Data Modeling and Modeling Diagrams using ERWIN.
  • Worked with Solution Architects to provide a consensus-based enterprise solution that is scalable, adaptable and in synchronization with ever changing business needs.
  • Ensured that new solutions comply with company technology standards and support the strategic requirements of the business.
  • Worked in AGILE software development methodology.
  • Worked on AWS Red shift and RDS for implementing models and data on RDS and Redshift
  • Able to guide / partner with VP / Directors for architecting solutions for the Big Data Organization
  • Data modeling, Design, implement, and deploy high-performance, custom applications at scale on Hadoop/Spark.
  • Maintain and work with our data pipeline that transfers and processes several terabytes of data using Spark, Scala, Python, Apache Kafka, Pig/Hive& Impala
  • Applied data analysis, data mining and data engineering to present data clearly.
  • Ensured high-quality data and understand how data is generated out experimental design and how these experiments can produce actionable, trustworthy conclusions.
  • Full life cycle of Data Lake, Data Warehouse with Big data technologies like Spark, Hadoop, Cassandra
  • Worked with project team representatives to ensure that logical and physical datamodels were developed in line with corporate standards and guidelines.

Environment: Teradata 13.10, Microsoft SQL Server 2012, Agile, SQL Manager, Erwin 8.0, Informatica, Teradata SQL Assistant, ER Studio 9.1.0, Linux.

Confidential, NYC, NY

Sr. Data Modeler/Data Analyst

Responsibilities:

  • Actively involved in the Design and development of the Star schema data model.
  • Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
  • Involved in understanding Logical and Physical Data model using Erwin Tool.
  • Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
  • Designed the database in Teradata and worked with Data Architect to implement it in the data model
  • Involved with metadata & Data Dictionary Management, Data Profiling and Data Mapping.
  • Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
  • Inherited enterprise data requirements and definitions from the Enterprise Information Models for use in projects and data-related initiatives.
  • Worked as Enterprise Data Modeler to harvest new insights discovered in project and program work that can inform and strengthen the Enterprise Information Models.
  • Lead data model walk-throughs to insure clear understanding across all stakeholders and addresses issues that surface.
  • Worked with Solution Architects to provide a consensus-based enterprise solution that is scalable, adaptable and in synchronization with ever changing business needs.
  • Ensured that new solutions comply with company technology standards and support the strategic requirements of the business.
  • Worked in AGILE software development methodology.
  • Proficient in importing/exporting large amounts ofdatafrom files to Teradata and vice versa.
  • Worked with project team representatives to ensure that logical and physical datamodels were developed in line with corporate standards and guidelines.

Environment: Teradata 13.10, Microsoft SQL Server 2012, Agile, SQL Manager, Erwin 8.0, Informatica, Teradata SQL Assistant, ER Studio 9.1.0, Linux.

Confidential, Providence, RI

Sr. Data Modeler/Data Analyst

Responsibilities:

  • PerformedDataAnalysis andDataProfiling and worked ondatatransformations anddataquality rules.
  • Designed both 3NFdatamodels for ODS, OLTP systems and dimensionaldatamodels using star and snow flake Schemas
  • Created, documented and maintained logical & physical database models.
  • Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN.
  • Developed Logical Model from the conceptual model.
  • Worked with DBA's to create a best-fit Physical Data Model from the logical data model.
  • Created Schema objects like Indexes, Views, and Sequences, triggers, grants, roles, Snapshots.
  • Extensively worked on documentation of Data Model, Mapping, Transformations and Scheduling jobs.
  • Used forward engineering to generate DDL from the Physical Data Model and handed it to the DBA.
  • Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.
  • Designed STAR schema for the detailed data marts and plan data marts consisting of confirmed dimensions.
  • Defined data management policies including enterprise naming and definition standards, specification of business rules, data quality analysis, standardized calculations and summarization definitions, and retention criteria.
  • Performed logical data modeling, physical data modeling (including reverse engineering) using the Erwin Data Modeling tool.
  • Did data modeling and involved with design and development of conceptual, logical and physical data models using AllFusion Data Modeler (Erwin)
  • Performed logical data model design including normalization/de-normalization referential integrity, data domains; primary and foreign key assignments and data element definitions as applied to both relational and dimensional modeling.
  • Created data masking mappings to mask the sensitive data between production and test environment.
  • Participate in development of core application and data warehouse data models.Worked with application developers to map process models to data models.
  • Perform logical and physical OLAP / OLTP schema design.
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle.
  • Worked on SQL queries in a dimensional data warehouse as well as a relational data warehouse.
  • Involved in extensive data validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.
  • Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.

Environment: - MS SQL Server 2012, Oracle 12c/11g, MS office, TibcoSpotfire, Clear Quest, Clear Case, Teradata R14

Confidential, Minneapolis, MN

Sr. Data Analyst

Responsibilities:

  • Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
  • Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
  • Wrote ad-hocSQLqueries and worked with SQL andTeradata databases
  • Wrote complex SQL queries for validating thedataagainst different kinds of reports generated by Business Objects.
  • Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business user.
  • Reverse Engineered DB2 databases and then forward engineered them to Teradata using ERStudio.
  • Analyzed the business requirements by dividing them into subject areas and understood the data flow within the organization.
  • Created a list of domains inErwinand worked on building up the data dictionary for the company
  • Providing ad-hoc analyses to support investment decisions
  • Extensively worked with querying, modeling and visualizing data using tools like MicroStrategy, SQL
  • Worked with digital advertising landscape and KPIs for web/mobile traffic, digital display, video, SEO, SEM and search advertising
  • Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable
  • Create and maintain Metadata, including table, column definitions
  • Assisted the ETL Developers and Testers during the development and testing phases
  • Conducted User Acceptance Testing (UAT)

Environment: Oracle 10g, Microsoft SQL Server 2012, SQL Developer, SQL Manager,Erwinr9, SQL Developer Data modeler, Visio, Informatica, Crystal Reports

Confidential

Data Analyst

Responsibilities:

  • Extensively used SQL for Data Analysis and to understand and documenting the data behavior within and between two companies.
  • Designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
  • Worked with Excel, utilizing macros and formulas for various Data Analysis activities
  • Handled data from many sources using Excel and SQL queries
  • Managed internal and external reporting requests while helping automate processes using data from multiple sources to an internal data warehouse
  • Assisted in data review of service failure investigations, providing this information to the Quality Manager for processing.
  • Compiled and tracked KPIs related to customer acquisition, revenue retention, prescription growth, and labor statistics
  • Recommended opportunities for reuse of data models in new environments
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Improved performance on SQL queries used Explain plan / hints /indexes for tuning created DDL scripts for database. Created PL/SQL Procedures and Triggers.
  • Performed data mining on data using very complex SQL queries and discovered pattern.
  • Used SQL for Querying the database in UNIX environment.

Environment: Oracle 8i, SQL, PL/SQL Developer 5.1,Sun Solaris8.0,Erwin4.0, ER- Studio6.0/6.5, Toad 7.6, Informatica 7.0, IBM OS 390(V6.0), DB2 V7.1.

We'd love your feedback!