Senior Data Analyst/ Etl Developer Resume
Houston, TX
SUMMARY:
- Senior Data Modeler/Analyst with 10 + years of experience in data analysis and modeling, with excellent understanding of Data Warehouse and Data Mart designing.
- Experience in understanding various business process, gathering business requirements, implementing business processes, identifying risks, doing impact analysis and UML modeling
- Experience in carrying out the entire Software Development Life Cycle (SDLC).
- Experience in working with business users/SMEs (Subject Matter Experts) as well as senior management.
- Strong Data modeling experience using ER diagram, Dimensional data modeling, Conceptual/Logical/Physical Modeling using 3NormalForm (3NF), Star Schema modeling, Snowflake modeling using tools like Erwin, ER - Studio, SAP Power Designer.
- Conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
- Created DDL scripts for implementing Data Modeling changes. Created ERWIN crystal reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, coordinated with DBAs' to apply the data model changes.
- Extensively used ERWIN for REVERSE Engineering, FORWARD Engineering, SUBJECT AREA, DOMAIN, Naming Standards Document etc.
- Developed Data dictionary and maintained Metadata for each model.
- Good understanding of Teradata SQL Assistant, Teradata Administrator and data load/ export utilities like BTEQ, Fast Load, Multi Load, Fast Export.
- Experienced in data access optimization, writing complex SQL queries and PL/SQL blocks like stored procedures, Functions, Triggers, Cursors and ETL packages.
- Experience working on creating models for Teradata master data management.
- Worked and extracted data from various database sources like Oracle, SQL Server, DB2, and Teradata.
- Loaded huge volumes of data into empty Teradata tables in the datamart for the initial load, using Teradata Fast Load utility. f the SQL Queries, Functions, Procedures, Packages and Database Objects by creating Normal, Unique.
- Extensive experience with OLTP / OLAP System and E-R modeling, developing Database Schemas like STAR schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
- Solid experience in Data Modeling using designed tool Erwin , Oracle SQL Developer , SQL Server Management studio, My SQL , SQL Plus and Toad .
- Expertise in writing SQL Queries , Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
- Deployed and scheduled Reports using various Business Intelligence reporting tools to generate all daily, weekly, monthly and quarterly Reports including status.
- Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
- Conducted GAP analysis and User Acceptance Testing (UAT).
- Skilled in System Analysis, E-R /Dimensional Data Modeling, Database Design and implementing RDBMS specific features.
- Participated in performance management and tuning for stored procedures, tables and database servers.
- Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables , Constraints (Primary key, Foreign Key, Unique , Default), Indexes .
- Strong analytical, logical, Communication and problem-solving skills and ability to quickly adapt to new technologies by self-learning.
TECHNICAL SKILLS:
Data Modeling Tools: ERwin 7.1/7.3/8.2/9.0/9.6, ER Studio & Power Designer.
OLAP Tools: Microsoft Analysis Services, Business Objects, Oracle Business Intelligence.
ETL Tools: Microsoft SSIS, Kettle ETL, Import/Export Wizard, Data Stage and Quality Stage
Programming Languages: SQL, PL/SQL, HTML, XML, Basic Java and JavaScript
Database Tools: Microsoft SQL Server 2005/2008/2012/2014/2016, DB2, Oracle 11i/10g/9i and MS Access, Teradata.
Operating Systems: Microsoft Windows 7/NT/2000/XP/Vista and UNIX
Reporting Tools: SSRS, Excel Reporting, Tableau, Power BI, QlikView and Infosphere tools
Work Flow Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Access.
PROFESSIONAL EXPERIENCE:
Senior Data Analyst / ETL Developer
Confidential, Houston, TX
Responsibilities:
- Involved in understanding of Law IT management business processes and coordinated with business analysts to get specific user requirements.
- Good experience in translating Business Requirements specifications into technical requirements for development.
- Extensively used DataStage Tools like Infosphere DataStage Designer, Infosphere DataStage Director for developing jobs and to view log files for execution errors.
- Imported Metadata from Oracle database. Imported metadata definitions into the repository. Exported and imported DataStage components.
- Created ETL IBM DataStage parallel jobs to extract information needed to populate into source data.
- Conducted unit testing’s using various test cases.
- Implemented end user requirements by creating stage variables and coding the business rule logic for transformations and rejections with a Business Rule stage.
- Extensive usage SQL developer for executing queries.
- Defined Simple and complex Data Quality rules based on the Business requirements specified by Analysts.
- Extensively Worked on Information Analyzer, Quality Stage
- Involved in interacting with Reporting developers and helped them in providing requirements and logics.
- Experience with Information Analyzer column analysis, Primary key & foreign key analysis, Publish Analysis result, define data rules definitions & Rule set to raise exceptions, understand and resolve IA logs.
Environment: Infosphere Tools, PL/SQL, SQL, ERWIN r7.3, MS-Word. Tableau, Oracle, SQL Server, Python
Senior Data Analyst / Data Modeler
Confidential, Madison, WI
Responsibilities:
- Analyzed the business requirements of the project by studying the Business Requirement Specification document.
- Created a logical design and physical design in Erwin
- Created ftp connections, database connections for the sources and targets.
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Maintained security and data integrity of the database.
- Developed, deployed, and monitored SSIS Packages.
- Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
- Designed the Logical Model into Dimensional Model using Star Schema and Snowflake Schema.
- Designed Physical database in the form of Star Schema for Data Mart Design.
- Developed Tableau visualizations and dashboards using Tableau Desktop.
- Generated DDL Scripts from Physical Data Model using technique of Forward Engineering in Erwin.
- Identified objects and its relationship from existing database, which can be used as a reference for data mart, then transformed those objects into physical model using Reverse Engineering in Erwin.
- Involved in database development by creating Oracle PL/SQL Functions, Procedures and Collections.
- Worked extensively with XML schema generation.
- Created DFD (Data Functional Design) artifacts that incorporated the process flow Visio, S-T Mapping document and all the specifications for proper ETL implementation.
- Used Python programming to develop a working and efficient network with the company.
- Participated in Performance Tuning using Explain Plan and Tkprof.
- Extensively used Erwin for developing data model using star schema methodologies.
- Created Unix Shell Scripts for automating the execution process.
- Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
Environment: PL/SQL, SQL, ERWIN r7.3, INFORMATICA, VISIO, Oracle, MS-Word. Tableau, Oracle, SQL Server, Python, Teradata SQL Assistant 12.0, ERWIN data modeler, ODS, TOAD, CA Erwin 7.0
ConfidentialSenior Data Analyst
Responsibilities:
- 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.
- Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
- Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
- Used ERwin for reverse engineering to connect to existing database and Operational Data Store to create graphical representation in the form of Entity Relationships and elicit more information.
- Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values and business rules in accordance with the Corporate Data Dictionary etc.
- Worked with ETL to develop source to target data mapping with transformation rules, physical naming standards, data types, domain definitions and corporate Meta data definitions.
- Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
- Modified the existing SSIS packages to meet the changes for the business requirements.
- Used SSIS transformations such as Lookup, Derived column, Data Conversion, Aggregate, Conditional split, SQL task, Script task and Send Mai task etc.
- Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
- Performed data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like MS Access, Excel and SQL.
- Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
- Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
- Fine tuning of stored procedures to improve the performance.
- Performed Performance tuning on SQL queries, triggers and stored procedures.
- Worked with end users to gain an understanding of information and core data concepts behind their business.
- Assisted in defining business requirements for the IT team and created functional specifications documents along with mapping documents to assist the developers in their coding.
- Involved in the critical Design review of the finalized database model.
- Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
- Integrated the work tasks with relevant teams for smooth transition from testing to implementation.
Environment: ERwin 9.0, SSIS 2012, SSRS 2008, MS SQL Server, Teradata 14.0, Oracle11g, MS Excel 2010.
SQL Data Analyst / Modeler
Confidential, Oakdale, MN
Responsibilities:
- Involved in requirement gathering and data analysis and Interacted with Business users to understand the reporting requirements, analyzing BI needs for user community.
- Involved in logical and physical designs and transforming logical models into physical implementations.
- Normalized the data up to 3rd Normal form.
- Created Entity/Relationship Diagrams, grouped and created the tables, validated the data, identified PKs for lookup tables.
- Worked on Business As usual (BAU) Operating Model defined and agreed in the Blueprinting phase.
- Involved in modeling (Star Schema methodologies) in building and designing the logical data model into Dimensional Models.
- Documented the source to target mappings for both data integration as well as web services.
- Experience working with MDM team with various business operations involved in the organization.
- Worked on different data models for Claims, Members and Providers for different claim types, for different Health Partner Incentive programs.
- Utilized ERwin’s forward/reverse engineering tools and target database schema conversion process.
- Designed the data marts in dimensional data modeling using star and snowflake schemas.
- Redefined attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
- Identify the Primary Key, Foreign Key relationships across the entities and across subject areas.
- Developed ETL routines using SSIS packages, to plan an effective package development process, and design the control flow within the packages.
- Took active role in the design, architecture and development of user interface objects in Qlikview applications. Connected to various data sources like SQL Server, Oracle and flat files.
- Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources.
- Created and maintained logical, dimensional data models for different Claim types.
- Designed data flows that extract, transform, and load data by optimizing SSIS performance
- Involved in loading the data from Source Tables to Operational Data Source tables using Transformation and Cleansing Logic.
- Worked on all data management activities on the project data sources, data migration.
- Worked on creating DDL, DML scripts for the data models.
- Worked on stored procedures for processing business logic in the database.
- Performance query tuning to improve the performance along with index maintenance.
- Worked on the reporting requirements for the data warehouse.
- Created support documentation and worked closely with production support and testing team.
Environment: ERwin 9.5/8.2, Oracle 11g, Crystal Reports, Toad, Windows OS, DB2, Teradata, SSRS, SQL, Qlikview 11.6, Informatica 11.
Data Analyst/ Data Modeler
Confidential, Chicago, IL
Responsibilities:
- As a Data Modeler/Data Analyst I was responsible for all data related aspects of a project.
- Translate business and data requirements into Logical data models in support of Enterprise Data Models, OLTP, Operational Data Structures and Analytical systems.
- Been part of on call production support, to work with Business, Customer Service teams, to handle with any data issues, data analysis, data verification, change requests, and Adhoc/Production report requests.
- Developed a Conceptual model using Erwin based on requirements analysis.
- Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
- Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1.
- Created/maintained stored procedures, SSIS packages, Agent job settings to ensure they are applied with new business rules, including loading additional files, and applying new validation logics, by adding/changing Stored Procedures, and SSIS packages.
- Created/modified the ETL processes to achieve the daily/monthly loading requirements.
- Used SSIS control flow such as using Execute SQL Task, File System Task, Script Task, For each Loop container, and Execute Package Task to create/modified daily/monthly ETL processes.
- Used SSIS data flow such as using Derived column, Data Conversion, Conditional Split, Lookup, and Row Count, Slowly Changing Dimension for daily/monthly ETL processes.
- Developed the required data warehouse model using Star schema for the generalized model.
- Used forward engineering approach for designing and creating databases for OLAP model.
- Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
- Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
- Worked on all data management activities on the project data sources, data migration.
- Worked on creating DDL, DML scripts for the data models.
- Worked on stored procedures for processing business logic in the database.
- Used SSRS to generate formatted production reports, including drill through, drill down, parameterized reports, and sub-reports, with Stored Procedures and Expressions. And also, be familiar with dynamic report, snapshots, and subscription.
- Wrote T- SQL queries, MDX queries for data retrieval.
- Took part in the normalization and de-normalization of database.
- Implemented the AGILE Method of Development.
Environment: ERwin 7.1, Oracle 11g, MS SQL SERVER 2008/2012, SSIS, SSRS, DB2.