We provide IT Staff Augmentation Services!

Sr. Data Analyst/data Modeler Resume

Research Triangle Park, NC

SUMMARY:

  • Over 8+ years of working experience as a Data Modeler and Data Analyst with high proficiency in data modeling, data analysis, requirement gathering, design and support of various applications in OLTP and Data Warehouses.
  • Extensive experience of Software Development Life Cycle (SDLC) methodologies like Waterfall, Agile and RUP.
  • Solid Excellent experience in creating cloud - based solutions and architecture using Amazon Web services, Amazon RDS, and Microsoft Azure.
  • Experience in designing Conceptual, Logical and Physical data models using Erwin, Sybase Power Designer and ER Studio data modeling tools.
  • Strong Experience in Entity Relationships & Dimensional Data Modeling to deliver Normalized ER& Star/Snowflake schemas.
  • Expert in writing SQL queries and optimizing the queries in Oracle, Teradata and SQL Servers.
  • Experience in designing SQL queries using joins, sub queries, functions, indexes, views materialized views, set operators, group by, OLAP functions.
  • Experience in Data Extraction/Transformation/Loading (ETL), Data Conversion and Data Migration using Microsoft SQL Server Integration Services (SSIS) and Informatica.
  • Experience in using Business intelligence tools like Tableau and Power BI for visualizing and analyzing of data.
  • Extensive experience working with business users/SMEs as well as senior management.
  • Extensive experience working with XML, Schema Designing and XML data.
  • Hands on experience in SQL queries and optimizing the queries in Oracle, SQL Server, DB2, and Netezza.
  • Strong experience working with conceptual, logical and physical data modeling considering Metadata standards.
  • Having good knowledge in Normalization and De-Normalization techniques for optimum performance in relational and dimensional database environments.
  • Design data marts using Ralph Kimball and Bill-Inmon dimensional data modeling techniques.
  • Proficient in writing DDL, DML commands using SQL developer and Toad.
  • Experience in design and develop Reporting Data Models to support OLAP Business Intelligence reporting system.
  • Having good working experience in Data Vault which is used in maintain Historical Data in the Enterprise Data Warehouse.
  • Excellent knowledge on creating reports on SAP Business Objects, Web reports for multiple data providers.
  • Experience in SQL and PL/SQL including all database objects: Stored procedures, stored functions.
  • Excellency in MS Excel with proficiency in Vlookups, Pivot Tables and understanding of VBA Macros.
  • Excellent experience in writing and executing unit, system, integration and UAT scripts.
  • Experience with DBA tasks involving database creation, performance tuning, creation of indexes, creating and modifying table spaces for optimization purposes.
  • Perform extensive Data profiling and analysis for detecting and correcting inaccurate data from the databases and to track data quality.
  • Extensively experience on Excel Pivot tables to run and analyze the result data set and perform UNIX scripting.

PROFESSIONAL EXPERIENCE:

Confidential - Research Triangle Park, NC

Sr. Data Analyst/Data Modeler

Responsibilities:

  • Massively involved in Sr. Data Modeler/Analyst role to review business requirement and compose source to target data mapping documents.
  • Participated in design discussions and assured functional specifications are delivered in all phases of SDLC in an Agile Environment.
  • Researched and developed hosting solutions using MS Azure for service solution.
  • Worked on Performance Tuning of the database which includes indexes, optimizing SQL Statements.
  • Coordinated with the Business Analyst and prepared Logical and Physical Data-models as per the requirements involving multiple subject areas, domains and naming standards.
  • Experienced on building Data Warehouse in Azure platform using Azure data bricks and data factory.
  • Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
  • Developed data Mart for the base data in Star Schema, Snow-Flake Schema involved in developing the data warehouse for the database.
  • Worked on ETL and Report testing using different Data warehousing tools like SSIS, Databricks, Cognos, Data Mart.
  • Designed both 3NF data models for ODS, OLTP systems and dimensional data models
  • Prepared complex T-SQL queries, views and stored procedures to load data into staging area.
  • Created and maintained data model standards, including master data management (MDM).
  • Worked in importing and cleansing of data from various sources like Teradata, flat files, SQL Server with high volume data.
  • Explored NoSQL options for current back using Azure Cosmos DB (SQL API).
  • Created PL/SQL procedures in order to aid business functionalities like bidding and allocation of inventory to the shippers.
  • Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin.
  • Worked with project management, business teams and departments to assess and refine requirements to design BI solutions using MS Azure.
  • Defined facts, dimensions and designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.
  • Developed and maintained data dictionary to create metadata reports for technical and business purpose.
  • Used Azure reporting services to upload and download reports
  • Prepared process flow/activity diagram for existing system using MS Visio the design based on business requirements.
  • Created DDL scripts using Erwin and source to target mappings to bring the data from source to the warehouse.
  • Generated parameterized queries for generating tabular reports using global variables, expressions, functions, and stored procedures using SSRS.
  • Created Project Plan documents, Software Requirement Documents, Environment Configuration and UML diagrams.
  • Worked on Data load using Azure Data factory using external table approach.
  • Developed the stored Procedures, SQL Joins, SQL queries for data retrieval, accessed for analysis and exported the data into CSV, Excel files.
  • Created data flow, process documents and ad-hoc reports to derive requirements for existing system enhancements.

Environment: MS Azure, Agile, 3NF, T-SQL, MDM, Teradata r15, SQL, PL/SQL, Erwin 9.7, MS Visio 2019

Confidential - Chicago, IL

Data Modeler/Data Analyst

Responsibilities:

  • As a Data Modeler / Data Analyst I was responsible for all data related aspects of a project.
  • Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
  • Extensively used agile methodology as the Organization Standard to implement the data Models.
  • Worked on Amazon Redshift and AWS and architecting a solution to load data creates data models and run BI on it.
  • Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
  • Conducted data modeling JAD sessions and communicated data-related standards.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
  • Worked at conceptual/logical/physical data model level using Erwin according to requirements.
  • Extensively used SSIS import/export wizard for performing the ETL operations.
  • Translated business and data requirements into Logical data models in support of Enterprise Data Models, OLTP, Operational Data Structures and Analytical systems.
  • Involved in designing the context flow diagrams, structure chart and ER-diagrams.
  • Performed extensive data analysis and data validation on Teradata.
  • Developed and implemented data cleansing, data security, data profiling and data monitoring processes.
  • Worked on Oracle PL/SQL and Shell Scripts, Packages, Scheduling, Data Import/Export, Data Conversions and Data Cleansing
  • Performed forward engineering to create a physical SAS model with DDL, based on the requirements from logical data model.
  • Developed and configured on Informatica MDM hub supports the Master Data Management (MDM).
  • Work fluently in different styles of data modeling as needed, including Data Vault, Dimensional (Snowflake Schema), OLTP, hierarchical.
  • Created scripts to generate new tables, views for enhancement in application using TOAD and SQL developer.
  • Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Implemented referential integrity using primary key and foreign key relationships.
  • Applied conditional formatting in SSRS to highlight key areas in the report data.
  • Developed the required data warehouse model using Star schema for the generalized model.

Environment: Erwin 9.7, Agile, Amazon Redshift, AWS, SQL, ER-diagrams, Teradata r15, PL/SQL, MDM, Tableau, Informatica

Confidential - Bellevue, WA

Data Modeler

Responsibilities:

  • Worked as a Data Modeler I was responsible for all data related aspects of a project.
  • Used SQL tools like Teradata SQL Assistant and TOAD to run SQL queries and validate the data in warehouse.
  • Defined facts, dimensions and designed the datamarts using the Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.
  • Wrote PL/SQL statement, stored procedures and Triggers in DB2 for extracting as well as writing data.
  • Developed Data mapping, Data Governance, Transformation and Cleansing rules for the Data Management involving and OLAP.
  • Designed logical and physical data models, Reverse engineering, Complete compare for Oracle and SQL server objects using Erwin.
  • Developed scripts that automated DDL and DML statements used in creations of databases, tables, constraints, and updates.
  • Normalized the database based on the new model developed to put them into the 3NF of the data warehouse.
  • Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
  • Produced Source to target data mapping by developing the mapping spreadsheets.
  • Involved in designing and developing SQL server objects such as Tables, Views, Indexes (Clustered and Non-Clustered), Stored Procedures and Functions in Transact-SQL.
  • Designed logical and physical data models, Reverse engineering, Complete compare for Oracle and SQL server objects using Erwin.
  • Worked on the reporting requirements and involved in generating the reports for the Data Model using crystal reports
  • Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
  • Used Informatica & SAS to extract transform & load source data from transaction systems.
  • Developed and maintained an Enterprise Data Model (EDM) to serve as both the strategic and tactical planning vehicles to manage the enterprise data warehouse.
  • Developed Data Migration and Cleansing rules for the Integration (OLTP, ODS, DW)
  • Designed the data warehouse modeler for all the source systems using MS Visio.

Environment: SQL, Teradata r13, TOAD 9.6, Ralph Kimball, PL/SQL, Erwin 9.6, MS Visio 2016

Confidential - Omaha, NE

Data Analyst/Data Modeler

Responsibilities:

  • Worked as a Data Analyst/Data Modeler to generate Data Models using SAP Power Designer and developed relational database system.
  • Gathered all the Sales analysis reports prototypes from the business analysts belonging to different Business units.
  • Used forward engineering approach for designing and creating databases for OLAP model.
  • Designed a STAR schema for the detailed data marts and Plan data marts involving shared dimensions (Conformed).
  • Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.
  • Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
  • Involved in Data profiling and performed Data Analysis based on the requirements, which helped in catching many Sourcing Issues upfront.
  • Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
  • Applied conditional formatting in SSRS to highlight key areas in the report data.
  • Performed GAP analysis of current state to desired state and document requirements to control the gaps identified.
  • Created SQL tables with referential integrity, constraints and developed queries using SQL and PL/SQL.
  • Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database
  • Collected, analyze and interpret complex data for reporting and/or performance trend analysis
  • Worked on the Snow-flaking the Dimensions to remove redundancy.
  • Implemented one-many, many-many Entity relationships in the data modeling of Data warehouse.
  • Modification of all databases via indexing of tables, MS SQL Server design parameters and stored procedures SQL code optimization.
  • Involved in extracting, cleansing, transforming, integrating and loading data into different Data Marts using Data Stage Designer.
  • Extracted data from Oracle, SQL Server and other databases using Informatica to load it into a single data warehouse repository.
  • Designed and generated various dashboards, reports using various Tableau Visualizations.
  • Developed Scripts that automated DDL and DML statements used in creations of Databases, Tables, Constraints, and updates.
  • Identified the Facts & Dimensions Tables and established the Grain of Fact for Dimensional Models.
  • Wrote and executed unit, system, and integration and UAT scripts in a data warehouse project.

Environment: SAP Power Designer 15.0, PL/SQL, T-SQL, DDL, DML, MS SQL Server 2014

Confidential

Data Analyst

Responsibilities:

  • Worked extensively in data analysis by querying in SQL and generating various PL/SQL objects.
  • Performed in team responsible for the analysis of business requirements and design implementation of the business solution.
  • Analyzed database requirements from the users in terms of loading dimensions and fact tables using SSIS Packages.
  • Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
  • Used SAS Import/Export Wizard plus SAS programming techniques to extract data from excel.
  • Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
  • Extensively used Data Analysis for OLTP and OLAP systems.
  • Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
  • Written complex T- SQL, SQL queries using joins, sub queries and correlated sub queries
  • Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
  • Created multiple automated reports and dashboards sourced from data warehouse using Tableau.
  • Designed and developed PL/SQL stored procedures to increase the performance of system
  • Perform source data analysis, data discovery, data profiling and data mapping.
  • Extensively worked on Performance Tuning and understanding Joins and Data distribution.
  • Developed SSRS Reports like Drill through Reports, Drilldown Reports, linked reports and parameterized reports
  • Identified, analyzed, and documented defects, errors, and inconsistencies in the application using MS Excel
  • Developed UNIX Shell scripts to automate various periodically repetitive database processes.
  • Designed and developed Ad-hoc reports as per business analyst, operation analyst, and project manager data requests.

Environment: SQL, PL/SQL, SAS, SSIS, T- SQL, SSRS, MS Excel 2012

TECHNICAL SKILLS:

Data Modeling Tools: Erwin Data Modeler 9.7/9.6, Erwin Model Manager, ER Studio v17, and Power Designer.

Programming Languages: SQL, PL/SQL, HTML5, XML and VBA.

Reporting Tools: SSRS, Power BI, Tableau, SSAS, MS-Excel, SAS BI Platform.

Cloud Platforms: AWS, EC2, EC3, Redshift & MS Azure

OLAP Tools: Tableau 7, SAP BO, SSAS, Business Objects, and Crystal Reports 9

Databases: Oracle 12c/11g, Teradata R15/R14, MS SQL Server 2016/2014, DB2.

Operating System: Windows, Unix, Sun Solaris

ETL/Data warehouse Tools: Informatica 9.6/9.1, SAP Business Objects XIR3.1/XIR2, Talend, and Pentaho.

Methodologies: RAD, JAD, RUP, UML, System Development Life Cycle (SDLC), Agile, Waterfall Model

Hire Now