Sr. Data Modeler/data Analyst Resume
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
