We provide IT Staff Augmentation Services!

Sr. Data Analyst/ Sr. Data Modeler Resume

Greenville, SC

SUMMARY

  • Over 9 years of IT experience in Data & Business Analysis with a focus on Business Intelligence, Data Modeling, ETL Development, Process management and implementation of full - lifecycle
  • Expertise using of ERWIN, Embarcadero ER/Studio & Power designer for developing Conceptual, Logical & Physical models
  • Experience in Database Programming SQL & PLSQL, Oracle 12c/11g/10g/9i, XML, DB2 Teradata, Database Tuning and Query Optimization
  • Experience in writing UNIX shell scripts to automate batch processes
  • Proficient in SQL query tuning to improve performance
  • Experience of Business Intelligence tools like Tableau & Qlikview for visualization of data
  • Understanding of WBS, Sequence Diagram, Data Flow diagrams and requirement gathering
  • Extensively worked on ERWIN tool with features like Reverse Engineering, Forward Engineering, Subject area, Domain, Naming Standards Documentation etc.
  • Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and extensive experience in project management methodologies, Microsoft SQL server database management, OBIEE.
  • Efficient in Extraction, Transformation and Loading(ETL) data from spread sheets, database tables using Microsoft Data Transformation Service(DTS)
  • Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD) Type I and Type II
  • Experience in Data Modeling with expertise in creating Star-Schema, Snow-Flake Schema, FACT and Dimensions Tables, Physical and Logical Data Modeling using ERWIN Tool
  • Extensive experience in enterprise Data flow analysis, data modeling and analytics (SSRS, SSAS, SSIS, ETL, MDM, Entity Data Models and data warehousing) incorporating transaction oriented business/service level data processes and metadata collection techniques to enhance informatics strategies.
  • Proficient in data mart designing and identifying facts & dimensions
  • Good understanding of Ralph Kimball and Bill Inmon’s modeling techniques
  • Good knowledge about all phases of Software Development Life Cycle(SDLC) which includes Requirement gathering and analysis, Design, Implementation, Testing, Deployment & Maintenance
  • In depth knowledge of Waterfall, Agile & XP development life cycles
  • Expertise in Normalization to 3NF/ Demoralization techniques for optimum performance in relational and dimensional database environments
  • Using Data Mapping, designed system test plans. Data Mapping is used in specifying of what data will be extracted from an internal warehouse, transformed and sent to external data
  • Strong expertise in Data Warehousing, Operations Data Store (ODS) concepts, data marts and OLAP technologies
  • Well versed with data analysis using MS Excel & SAS
  • Extensive experience in the development, implementation and integration of strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills
  • Proficient in DataWarehousing techniques like Change DataCapture (CDC), Customer Data Integration (CDI) and Master DataManagement (MDM).
  • Excellent analytical, inter-personal and communication skills with clear understanding of business process flows

TECHNICAL SKILLS

Functional: Business Requirements Analysis, Process mapping

Data Modeling: Logical Model, Conceptual Model, Physical Modeling, Star-Schema Modeling, Snowflake Schema, FACT& Dimension, OLAP,MDM

Dashboards Reporting Tools: Qlikview

ETL Tools: SSIS, Pentaho, Informatica, Power Center 6.0/7.1/8.1.1 , Power Mart 6.0.

Requirements Management Tools: Version One, Confluence, Rational RequisitePro, DOORS, Quality Center, ALM

Data Modeling Tools: TOAD 9.7, 10.5, ERWIN Studio, ER/ Studio, Rational Rose, MS-Visio

Change Management Tools: Rational ClearQuest, Rational Clear Case, RSA

Languages: SQL, PL SQL, Unix shell scripting

Reporting tools: Micro strategy, Cognos, Business Objects, Crystal Reports, OBIEE, SSRS

Databases: Oracle 11g,10g/ 8i/ 9i, MS SQL Server 7.0/ 2000, 2008, MS Access, Teradata

Additional skills: Microsoft SharePoint, Business Objects, Crystal reports, MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, Greenville, SC

Sr. Data Analyst/ Sr. Data Modeler

Responsibilities:

  • Interacting with End user community, external vendors to understand the business requirements and in identifying data sources
  • Understanding the existing Autosys jobs and scripts which relate to Business Logic and converting the same to make it work in EDW environment.
  • Understanding the complex logic business transformation and implement into ETL development and design.
  • Regular interaction with client to review the design.
  • Analyzing the design pattern of various staging tables and Dimension and Fact tables.
  • Created and maintained Metadata, including table, column definitions
  • Perform performance tuning in the load level to improve the performance.
  • Perform object deployments on versioned repositories from QA to Production.
  • Involved in Indexing and Partitioning of Database
  • Interacted with QA team in their testing of Data warehouse
  • Extensively used SQL for performance tuning
  • Created and executed SQL queries (using SQL and MS Access) and scripts to validate data movement
  • Worked closely with DBA's as a part of various database change requests
  • Involved in documentation of Data Mapping and ETL specifications for Data warehouse.
  • Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided using SSRS.
  • Created various SSRS reports such as Multi-valued reports, Parameterized, Linked reports, Drill down reports, Tabular Matrix reports and Chart diagrams.
  • Enabled speedy reviews and first mover advantages by using Oozie to automate data loading into the Hadoop Distributed File System and PIG to pre-process the data.
  • Working on a Map RHadoop platform to implementBigdatasolutions using Hive, Map reduce
  • Experienced in full life cycle MDM development including data analysis, database design, data mapping and data load in batch.
  • Conducted design reviews and validated data models and was involved in MDM (Master Data Management).
  • Worked extensively with understanding, developing, cleansing, maintaining and entering metadata for various new as well as existing models

Environment: Oracle 11g, SQL, SSRS, XML, UNIX Shell Scripting, SQL Developer, Autosys, Erwin 9.5, Hadoop, MDM

Confidential, New York, NY

Data Analyst/Sr. Data Modeler

Responsibilities:

  • Identified entities and attributes and developed conceptual, logical and physical models using ERWIN
  • Worked on cleansing and organizing various tables in a presentable manner to help with better understanding of already existing models
  • Produced Pdfs for various models (logical and physical) to ensure communication with different teams (DA, ETL, IA, and Development)
  • Worked with the Reporting Analyst and Reporting Development Team to understand Reporting requirements
  • Produced customized data definition reports for smooth coordination between various teams associated in a project
  • Created documentation for custom reports using report designer in ERWIN
  • Designed the Data Marts using Ralph Kimball's approach
  • Checked for all the modelling standards including naming standards, entity relationships on model and for comments in the model
  • Generated customized report solutions for metadata reports
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SSRS.
  • Created various SSRS reports such as Multi-valued reports, Parameterized, Linked reports, Drill down reports, Tabular Matrix reports and Chart diagrams.
  • Conducted design reviews and validated data models
  • Analyzing query results in Excel, creating pivot table/chart reports etc. and sharing them with MDM team members.
  • Designed different type of STAR schemas using ERWIN with various Dimensions like time, services, customers and FACT tables
  • Reverse Engineered the existing database and based on Functional Design Specification (FDS) updated and optimized the existing star schemas to satisfy the reporting requirements
  • Created Source to Target mappings and Transformations. Mapped data between Source and Targets.
  • Coordinated with DBA's and generated SQL code from the data models and generated DDL scripts using forward engineering in ERWIN

Environment: ERWIN 9.5, Oracle 11g, DB2, MS SQL Server 2008, SQL, XML, MS Excel, SSRS, TOAD, Crystal reports 9, SAS

Confidential, Minneapolis, MN

Sr. Data Modeler/Data Analyst

Responsibilities:

  • Worked with business users to gather requirements and create data flow, process flows and functional specification documents
  • Designed & Created Test Cases based on the Business requirements
  • Involved in extensive Data validation using SQL queries and back-end testing
  • Involved in data analysis and creating data mapping documents to capture source to target transformation rules
  • Used ERWIN and MS VISIO to create 3NF and dimensional data models and published to the business users and ETL / BI teams
  • Creating or modifying the T-SQL queries as per the business requirements
  • Worked on creating role playing dimensions, Factless Fact, snowflake and star schemas
  • Managed full SDLC processes involving requirements management, workflow analysis, source data analysis,datamapping, metadata management,dataquality, testing strategy and maintenance of the model
  • Wrote complex SQL queries for validating thedataagainst different kinds of reports generated by Business Objects
  • 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
  • Involved in the validation of the OLAP Unit testing and System Testing of the OLAP Report Functionality and data displayed in the reports

Environment: Erwin 9.5, Power Center 8.1/9.1, Power Connect/ Power exchange, Oracle 11g, DB2 MS SQL Server 2008, SQL, XML, Windows NT 4.0, MDM, Unix Shell Scripting

Confidential, Chicago, IL

Data Analyst/Data Modeler

Responsibilities:

  • Gathered Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis
  • Analyzed the business requirements by dividing them into subject areas and understood thedataflow within the organization
  • Created aDataMapping document after each assignment and wrote the transformation rules for each field as applicable
  • Created DDL scripts for implementingDataModeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement
  • PublishedDatamodel in model mart, created naming convention files, co-coordinated with DBAs to apply thedatamodel changes
  • Used Model Mart of ERWIN r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement
  • Used ERWIN r9 for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
  • Helped the BI, ETL Developers, Project Manager and end users in understanding theDataModel, dataflow and the expected output for each model created
  • Gained Comprehensive knowledge and experience in process improvement, normalization/de-normalization,dataextraction,datacleansing,datamanipulation
  • Created various SSRS reports such as Multi-valued reports, Parameterized, Linked reports, Drill down reports, Tabular Matrix reports and Chart diagrams.
  • Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprisedatastores within a metadata repository
  • Extensively used ERWIN r9 as the main tool for data modeling along with MS VISIO
  • Applieddatanaming standards, created thedatadictionary and documenteddatamodel translation decisions and also maintained DW metadata
  • Experienced in full life cycle MDM development including data analysis, database design, data mapping and data load in batch and Analyzing query results.
  • Used Star Schema and Snow flake schema methodologies in building and designing the logicaldata model in the dimensional Models
  • Assisted developers, ETL, BI team and end users to understand thedatamodel

Environment: Microsoft SQL Server, Oracle 11g,Erwin R9, Visio, SSRS, Informatica, Business Objects, Teradata SQL Assistant, ER Studio, Linux

Confidential, Northbrook,IL

Data Analyst/Data Modeler

Responsibilities:

  • Developed business flow diagrams, Activity/State diagrams and Sequence diagrams using MS VISIO
  • Performed Data Analysis and Data validation by writing complex SQL queries using T-SQL
  • Created Business Requirements and converted them into detailed Use Cases, Report Specifications and Non Functional Requirements
  • Created and maintained Data Dictionary and pursued to reach consensus
  • Provided primary liaison between business/operations/vendors and development
  • Created data models and data flow diagrams for the to-be process using ERWIN r9
  • Researched upstream data sources and ensured its owners attested all source data sources
  • Created report specifications containing mapping to source data sources
  • Worked with the developers on resolving the reported bugs and various technical issues
  • Involved in preparing a simple and detailed User manual for the application, for an intended novice user

Environment: SQL Server 2005/2008, Oracle 9i, MS Access, ERWIN r9, SQL Loader.

Confidential

Data Analyst

Responsibilities:

  • Suggested various changes in the physical model to support the business requirements
  • Developed server jobs to load thedatafrom flat files, text files, tag text files and MSSQL
  • Created and scheduled the job sequences by checking job dependencies
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries
  • Wrote PL/SQL stored procedures, functions and packages and triggers to implement business rules into the application
  • Performed unit testing to check the validity of thedataat each stage
  • Implemented best practices in the development environment (code standards, code migration)
  • Created and ran Workflows and Worklets using Workflow Manager to load thedatainto the target database
  • Performance tuning of SQL Queries, Sources, Targets and sessions

Environment: Oracle 9i, MS SQL Server, PL/SQL, Toad.

Hire Now