We provide IT Staff Augmentation Services!

Sr. Data Modeler/data Analyst Resume

2.00/5 (Submit Your Rating)

San Jose, CA

SUMMARY

  • Above 8+ years of experience in Data Analyst and Data Modeling, Data Development, Implementation and Maintenance of databases and software applications.
  • Good understanding of Software Development Life cycle (SDLC) including planning, analysis, design, development, testing, implementation.
  • Good Knowledge and working experience on AWS tools like Amazon S3, and Amazon Red Shift.
  • Extensive experience in using ER modeling tools such as Erwin and ER/Studio, Power Designer.
  • Experience in conducting Joint Application Development (JAD) sessions with SMEs, Stakeholders and other project team members for requirements gathering and analysis.
  • Excellent proficiency in Agile/Scrum and waterfall methodologies.
  • Good experience in working with different reporting tool environments like SQL Server Reporting Services (SSRS), and Business Objects.
  • Good Knowledge on SQL queries and creating database objects like stored procedures, triggers, packages and functions using SQL and PL/SQL for implementing teh business techniques.
  • Experience in generating DDL (Data Definition Language) Scripts and creating Indexing strategies.
  • Proficient in Normalization/De - normalization techniques in relational/dimensional database environments and have done normalizations up to 3NF.
  • Strong experience in Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration management.
  • Experience in data analysis to track data quality and for detecting/correcting inaccurate data from teh databases.
  • Excellent knowledge on creating reports on SAP Business Objects, for multiple data providers.
  • Conduct data analysis, mapping transformation, data modeling and data-warehouse concepts.
  • Capture, validate and publish metadata in accordance with enterprise data governance policies and MDM taxonomies.
  • Excellent experience in writing and executing unit, system, integration and UAT scripts in a data warehouse projects.
  • Experience in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
  • Good experience in Technical consulting and end-to-end delivery with data modeling, data governance.
  • Efficient in all phases of teh development lifecycle, coherent with Data Cleansing, Data Conversion, Data Profiling, Data Mapping, Performance Tuning and System Testing.
  • Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
  • Good understanding of Ralph Kimball (Dimensional) & Bill Inman (Relational) model Methodologies.
  • Experience with Teradata utilities such as Fast Export, MLOAD for handling various tasks.
  • Having good working experience in Data Vault which is used in maintain Historical Data in teh Enterprise Data Warehouse.
  • Experience with DBA tasks involving database creation, performance tuning, creation of indexes, creating and modifying table spaces for optimization purposes.
  • Strong experience in using MS Excel and MS Access to dump teh data and analyze based on business needs.
  • Supporting ad-hoc business requests and Developed Stored Procedures and Triggers.
  • Experience in designing error and exception handling procedures to identify, record and report errors.

TECHNICAL SKILLS

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

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

Reporting Tools: SSRS, Power BI, Tableau, SSAS, MS-Excel 2016, 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 10/9/8, 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

PROFESSIONAL EXPERIENCE

Confidential - San Jose, CA

Sr. Data Modeler/Data Analyst

Responsibilities:

  • As a Sr. Data Modeler/Analyst to generate Data Models using Erwin and subsequent deployment to Enterprise Data Warehouse.
  • Participated in design discussions and assured functional specifications are delivered in all phases of SDLC in an Agile Environment.
  • Developed Data mapping, Transformation and Cleansing rules for teh Data Management involving OLTP and OLAP.
  • Wrote DDL and DML statements for creating, altering tables and converting characters into numeric values.
  • Developed rule sets for data cleansing and actively participated in data cleansing and anomaly resolution of teh legacy application.
  • Researched and developed hosting solutions using MS Azure for service solution.
  • Involved in data analysis, data discrepancy reduction in teh source and target schemas.
  • Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs.
  • Created data masking mappings to mask teh sensitive data between production and test environment.
  • Worked on Data Mining and data validation to ensure teh accuracy of teh data between teh warehouse and source systems.
  • Worked on Master data Management (MDM) Hub and interacted with multiple stakeholders.
  • Worked with Business users during requirements gathering and prepared Conceptual, Logical and Physical Data Models.
  • Worked extensively on Tableau for data visualization producing interactive graphs.
  • Created various Physical Data Models based on discussions with DBAs and ETL developers.
  • Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for teh new programs.
  • Reverse Engineering teh existing data marts and identified teh Data Elements (in teh source systems), Dimensions, Facts and Measures required for reports.
  • Document data dictionaries and business requirements for key workflows and process points
  • Performed teh Data Accuracy, Data Analysis, Data Quality checks before and after loading teh data.
  • Used SAS procedures like means, frequency and other statistical calculations for Data validation.
  • Developed teh data warehouse model (Kimball's) with multiple data marts with conformed dimensions for teh proposed central model of teh Project.
  • Involved in writing queries and stored procedures using MySQL and SQL Server.
  • Designed teh data marts in dimensional data modeling using star schemas and snowflake schemas.
  • Maintained and implemented Data Models for Enterprise Data Warehouse using Erwin.
  • Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across teh organization.
  • Worked with project management, business teams and departments to assess and refine requirements to design BI solutions using MS Azure.
  • Involved in migration projects to migrate data from data warehouses on Oracle and migrated those to Teradata.
  • Performed Data Manipulation using MS Excel Pivot Sheets and produced various charts for creating teh mock reports.
  • Created data flow, process documents and ad-hoc reports to derive requirements for existing system enhancements.

Environment: Erwin 9.7, Teradata 15, Oracle 12c, ETL, SQL, PL/SQL, SAS, MDM, MySQL 8.0.13, T-SQL, SSIS, SSRS, OLAP, OLTP, SSAS, Azure, Tableau.

Confidential - Charlotte, NC

Data Modeler/Data Analyst

Responsibilities:

  • Worked as aDataModeler/Analyst responsible for Conceptual, Logical and Physical model for Supply Chain Project.
  • Developed full life cycle software including defining requirements, prototyping, designing, coding, testing and maintaining software.
  • Extensively used Agile methodology as teh Organization Standard to implement teh data Models.
  • Conducted Design reviews with teh business analysts and teh developers to create a proof of concept for teh reports.
  • Developed scripts dat automated DDL and DML statements used in creations of databases, tables, constraints, and updates.
  • Designed different type of STAR schemas for detailed data marts and plan data marts in teh OLAP environment.
  • Created SSIS package for daily email subscriptions to alert Tableau subscription failure using teh PostgreSQL database.
  • Analyzed teh data which is using teh maximum number of resources and made changes in teh back-end code using PL/SQL stored procedures and triggers
  • Connected to AWS Redshift through Tableau to extract live data for real time analysis.
  • Performed thorough data analysis for teh purpose of overhauling teh database using SQL Server.
  • Used Informatica & SAS to extract transform & load source data from transaction systems.
  • Created Logical & Physical Data Model on Relational (OLTP) on Star schema for Fact and Dimension tables using Erwin.
  • Created and maintained data model standards, including master data management (MDM)
  • Involved in extracting teh data from various sources like Oracle, SQL, and Teradata.
  • Designed teh data marts using teh Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.
  • Identified and documented data sources and transformation rules required to populate and maintain data Warehouse content.
  • Worked on Metadata exchange among various proprietary systems using XML.
  • Worked with medical claim data in teh Oracle database for data validation, trend and comparative analysis.
  • Developed Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse.
  • Written SQL scripts to test teh mappings and Developed Traceability Matrix of Business
  • Communicated with all business functions to maintain a comprehensive understanding of data quality requirements.
  • Performed detailed data analysis to analyze teh duration of claim processes and created teh cubes with Star Schemas using facts and dimensions through SQL Server Analysis Services (SSAS).
  • Worked on normalization techniques, normalized teh data into 3rd Normal Form (3NF).
  • Implemented Forward engineering to create tables, views and SQL scripts and mapping documents.
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle.
  • Performed GAP analysis to analyze teh difference between teh system capabilities and business requirements.
  • Generated parameterized queries for generating tabular reports using global variables, expressions, functions, and stored procedures using SSRS.
  • Monitored teh Data quality and integrity of data was maintained to ensure TEMPeffective functioning of department.

Environment: Erwin 9.7, Teradata r15, SQL, PL/SQL, Oracle 12c, SSIS, SSRS, OLAP, OLTP, SSAS, XML, MDM, Informatica, AWS, Tableau, 3NF, Ralph Kimball's

Confidential - Eden Prairie, MN

Sr. Data Modeler

Responsibilities:

  • Worked with Business Analyst during requirements gathering and business analysis to prepare high level Logical Data Models and Physical Data Models using E/R Studio.
  • Provided solutions for teh data migration on various platforms from hierarchical to relational databases to unstructured databases.
  • Created a Data Mapping document after each assignment and wrote teh transformation rules for each field as applicable.
  • Designed Star and Snowflake Data Models for Enterprise Data Warehouse using E/R Studio.
  • Identified teh Facts & Dimensions Tables and established teh Grain of Fact for Dimensional Models.
  • Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
  • Involved in teh study of teh business logic and understanding teh physical system and teh terms and condition for sales Data mart.
  • Gatheird and documented requirements of a Qlikview application from users.
  • Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data.
  • Developed teh data warehouse model (Kimball's) with multiple data marts with conformed dimensions for teh proposed central model of teh Project.
  • Working on teh OLAP for data warehouse and data mart developments using Ralph Kimball methodology as well as OLTP models,
  • Used SQL Loader, external tables and import/export toolbar to load data into Oracle.
  • Generated DDL statements for teh creation of new ER/studio objects like table, views, indexes, packages and stored procedures.
  • Created Project Plan documents, Software Requirement Documents, Environment Configuration and UML diagrams.
  • Performed Hypothesis testing using SAS to check if teh difference in teh population mean is significant.
  • Developed process methodology for teh Reverse Engineering phase of teh project.
  • Prepared complex T-SQL queries, views and stored procedures to load data into staging area.
  • Worked in importing and cleansing of data from various sources like Teradata, flat files, SQL Server with high volume data.
  • Involved in teh creation, maintenance of Data Warehouse and repositories containing Metadata.
  • Worked Normalization and De-normalization concepts and design methodologies like Ralph Kimball and Bill Inmon approaches.
  • Performed ad-hoc analyses, as needed, with teh ability to comprehend analysis as needed.

Environment: ER/Studio v15, Teradata v13, SQL, PL/SQL, Oracle 12c, Qlikview, OLAP, OLTP, T-SQL, SAS, UML, UAT.

Confidential - Bentonville, AR

Sr. Data Analyst/Data Modeler

Responsibilities:

  • Worked as a Sr. Data Analyst/Modeler to generate Data Models using SAP Power Designer and developed relational database system
  • Analyzed teh business requirements of teh project by studying teh Business Requirement Specification document.
  • Conducted JAD Sessions with teh SME, stakeholders and other management teams in teh finalization of teh User Requirement Documentation.
  • Involved in Data profiling and performed Data Analysis based on teh requirements, which helped in catching many Sourcing Issues upfront.
  • Developed long term data warehouse roadmap and architectures, designs and builds teh data warehouse framework per teh roadmap.
  • Worked in generating and documenting Metadata while designing OLAP systems environment.
  • Designed logical and physical data models using data provisioning and consumption techniques.
  • Involved in data mapping document from source to target and teh data quality assessments for teh source data.
  • Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across teh organization.
  • Designed both 3NF data models for OLTP systems and dimensional data models using star and snow flake Schemas.
  • Developed and maintained data dictionary to create metadata reports for technical and business purpose.
  • Created ER diagrams using Power Designer modeling tool for teh relational and dimensional data modeling.
  • Created SQL tables with referential integrity and developed queries using SQL, and PL/SQL.
  • Involved in Normalization / De-normalization, Normal Form and database design methodology.
  • Conducted user interviews, gathering requirements, analyzing teh requirements using Rational Rose, Requisite pro RUP.
  • Designed and Developed Oracle, and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
  • Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
  • Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.

Environment: SAP Power Designer 15, SQL, PL/SQL, Oracle 11g, OLAP, OLTP, T-SQL, SSIS, SSRS, SSAS

Confidential

Data Analyst

Responsibilities:

  • Worked with Business analysts to identify and understand requirements, tried analyzing user reviews and then discussed cleared my views on some Data analysis.
  • Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for application.
  • Worked with Data Analyst for requirements gathering, business analysis and project coordination.
  • Performed Verification, Validation, and Transformations on teh Input data (flat files) before loading into target database.
  • Translated business concepts into XML vocabularies by designing XML Schemas with UML
  • Created, modified, deployed, optimized, and maintained Business Objects Universes using Designer.
  • Worked with business analyst to design weekly reports using combination of Crystal Reports.
  • Performed Data Validations using SQL queries by extracting data and running queries in wamp server.
  • Applied various data mining techniques Linear Regression & Logistic Regression, classification, clustering.
  • Performed teh Data Accuracy, Data Analysis, Data Quality checks before and after loading teh data.
  • Developed all teh required stored procedures, user defined functions and triggers using T-SQL and SQL
  • Performed Data Analysis and Data validation by writing SQL queries using SQL assistant.
  • Worked in generating and documenting Metadata while designing OLTP and OLAP systems environment.
  • Wrote a complex SQL, PL/SQL, Procedures, Functions, and Packages to validate data and testing process.
  • Worked on Data Mining and data validation to ensure teh accuracy of teh data between teh warehouse and source systems.
  • Produced report using SQL Server Reporting Services (SSRS) and creating various types of reports.
  • Performed data analysis and data profiling using complex SQL on various sources systems and answered complex business questions by providing data to business users.
  • Generated Data dictionary reports for publishing on teh internal site and giving access to different users.
  • Developed SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development environment.
  • Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables.
  • Developed SQL queries, Ad Hoc for Extracting data from production databases to build data structures, reports.

Environment: SQL, XML, T-SQL, OLTP, OLAP, PL/SQL, MS Excel 2010, Tableau

We'd love your feedback!