We provide IT Staff Augmentation Services!

Data Quality Analyst Resume

St Charles, MO

SUMMARY

  • Motivated IT consultant having around 7+ years’ experience with advanced Analysis, Design and technical knowledge, in the field of Data Warehousing, ETL, Data Analysis and modeling, along with quick adaptability to new technologies.
  • Expertise in Analysis, Design, Development, Implementation, Modeling, Testing, and support for Data warehousing & OLAP applications.
  • Expert in Business Intelligence solutions in Data warehousing / Decision Support Systems using ETL tools Informatica, OLAP, OLTP and Data Warehouse Reports using Business Objects, Crystal Reports.
  • Collaborated Cross work stream sessions to give idea on conversion changes from ODS and Data warehouse side.
  • Expertise in E - R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
  • Expertise in Data Profiling, Data Quality, and Data Governance.
  • Experienced in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data warehouse using Informatica.
  • Experience in coding using SQL, procedures/functions, triggers and exceptions.
  • Expertise in RALPH KIMBALL star schema methodology.
  • Expertise in conceptual modeling, logical modeling and physical modeling
  • Expertise in deploying OLAP tools, Views, Materialized Views, and partitioning techniques for highly responsive Decision Support Systems
  • Expert in Designing Dimensional Modeling (Star Schemas, Snow flake schema) and Operational Data store (OLTP) Data Warehouse design.
  • Designed Mapping documents ETL architecture documents and specifications.
  • Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment.
  • Designed logical & physical data models with Erwin Tool, Telelogic tool and Visio
  • Involved in weekly Bug tracking meetings, Status meetings with the Business analysts to resolve the bugs in the application.
  • Good expertise in gathering requirements, business definition requirements and functional requirements gathering.
  • Expertise in processes research, analysis and documentation.
  • Executed Autosys, UNIX commands and created scripts.
  • Familiarity with Enterprise Architecture Structures Zachman.
  • Having excellent problem solving skills and critical thinking skills.
  • Efficient in all phases of the software development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning, Unit Testing, System Testing, User Acceptance Testing.
  • A dedicated team player with excellent communication, organizational and interpersonal skills.

TECHNICAL SKILLS

Languages: C, C++, JDK1.2, Java Script, TSL, Perl, PL/SQL, COBOL, HTML, and XML

ETL: Informatica Power Center 8.6.1/8.1/7.1.4/7.1.1/6.0, PowerMart6.2/5.1, MS SQL Server, and SSIS/DTS

DSS: MS SQL Server Reporting Services, Business Objects XIR 2/6.5.1/5.1.8/4.1, SSAS,Web Intelligence, and Crystal Reports

Operating Systems: MS Windows 2003/2000/NT, Sun Solaris, and Unix

Databases: MS SQL Server 2008/2005/2000/7.0, Oracle 10g/9i/8i/7.x, DB2, and Teradata Data Warehousing

Methodologies: Star Schema Design, Snowflake Schema Design, Data Modeling, and BestPractices in Data Warehousing Design and Implementation

Design Tools: Rational Rose, Erwin7.2/4.0/3.0, IBM Telelogic 11, MS Visio, RUP, and RAD, ER studio

Testing Tools: Win Runner 7.5/7.0/6.0/5.0, Load Runner 7.6/7.5/7.0/6.0, Quick Test

PROFESSIONAL EXPERIENCE

Confidential, St.Charles, MO

Data Quality Analyst

Responsibilities:

  • .Validated the issues found through QA of new file and worked with architects to create a resolution.
  • Provided the support to development teams as they work towards data solutions for existing services.
  • Analyzed data in test and production environments to validate the fixed issues.
  • Reviewed the historical integrity of data in production database for client and analyzed the flow of data between different systems.
  • Assisted in client data initiatives for creating new environments for data.
  • Researched, coordinated, and executed the transfer of new data feeds or data corrections to ensure that continuity and level of service are maintained.
  • Communicated the value of services through a high level of understanding of services and the available data and configuration options.
  • Documented the issues and solutions identified in the business and data warehouse.
  • Worked on solution approaches for fixing data issues in long term.
  • Worked on source to target field mapping.
  • Worked with different types of Sources like XML files, DB Tables, Flat Files, and Destinations like DB Tables.
  • Worked with QA teams to resolve the issues in production and development.
  • Researched and identified data quality issues reported by the end users (customer relationship management).

Environment: SQL 2008/2012/2014, MS Office 2010, Excel, Access, Data Quality Services, MS visio

Confidential, St. Louis, MO

Database Analyst/Data Modeler

Responsibilities:

  • Gathered Business requirements from Application teamsand Involved in JAD sessions with different application teams.
  • Performed Impact Analysis on existing database to see the existing data flow based on requirements.
  • Created VISIO diagrams in order to give idea for Business Users and for IT team about existing flow. Also created future state data flow diagrams.
  • Performed Data Profiling by using SQL and Informatica Data Explorer.
  • Created Conceptual design as per requirements before designing logical and physical models.
  • Designed logical & physical data models with Erwin Tool.
  • Designed normalized database.
  • Performed field analysis to create data mapping documents and provided those documents to development team.
  • Created Source System Analysis documents, and provided those documents to development team.
  • Created views for downstream users, also created extracts from both ODS and BDW in order to send files to downstream applications.
  • Worked extensively with the Dev and QA teams to plan and execute the releases.
  • Extensively worked with QA team to resolve the issues.
  • Worked in Agile methodology.
  • Designed and Implemented Dimensional Data Model to satisfy end users reporting needs.
  • Created Entities, attributes from requirements and established relationships between entities.
  • Worked with different types of Sources like XML files, DB Tables, Flat Files, and Destinations like DB Tables.

Environment: Erwin 7.2,Informatica Power Center 8.6.0, Informatica Data Explorer 8.6, Oracle 10g, DB2, MS Access, Toad for Oracle 9.7.2, Toad for DB2 4.0, Sun OS 5.9, IBM Unix, HP Quality Center 9.2, SecureCRT6.1, SecureFX6.1, XML, MS Office 2007, Windows 2003, ER Studio.

Confidential, Saint Paul, MN

Data Analyst

Responsibilities:

  • Gathered Business requirements from Application teamsand Interviewed Users to understand requirements.
  • 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, codes, business rules, glossary terms, etc.
  • Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
  • Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
  • Designed an approach to separate intercompany transactions and external transactions for all GL entries in the source system as per requirement.
  • Performed Data Profiling on General Ledger Source system.
  • Created Entities and established relationships between entities.
  • Created Technical Design documents to load both Transactional GL data and Master data in BW Staging model.

Environment: Power Designer 15.1, Informatica Power Center 8.1, SAP BW, PECAS, JD Edwards, Oracle 10g, MS Office 2007, Windows XP.

Confidential, Seattle, WA

Data modeler/data analyst

Responsibilities:

  • Interacting with business users to analyze the business process and requirements and transforming requirements into
  • Conceptual, Logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
  • Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
  • Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
  • Worked on Bank Data ware house and Mortgage Data ware house.
  • Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
  • Normalized the database to put them into the 3NF of the data warehouse.
  • Involved in dimensional modeling, identifying the Facts and Dimensions.
  • Maintain and enhance data model with changes and furnish with definitions, notes, reference values and check lists.
  • Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments.
  • Generate DDL scripts for database modification, Teradata Macros, Views and set tables.
  • An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.

Environment: Teradata, SQL Server 2000/ 2005, Erwin 7.5.2, Windows XP, XML, Excel, Access, Visio, ER Studio.

Confidential, Boston, MA

Data modeler/data analyst

Responsibilities:

  • Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business logic.
  • Created Physical Data Model (PDM) for the OLTP application using ER Studio.
  • Created Data Models using IDEF1X methodology.
  • Involved in data model reviews with internal data architect, business analysts, and business users with in depth explanation of the data model to make sure it is in line with business requirements.
  • Worked at conceptual and physical (using IE methodology) database level to implement and build corporate enterprise information strategies.
  • Worked on analyzing source systems and their connectivity
  • Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
  • Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application.

Environment: ER Studio, Informatica Power Center 7.1.2, Sybase, Windows, Toad, PL/SQL, Oracle 9i, SQL Server 2000, SQL*Loader, AIX 5.0, Windows 2000.

Confidential

SQL developer

Responsibilities:

  • Gathering business requirements from business users
  • Designed Logical and Physical models of Relational Database
  • Built strong relationships with key business and technology partners inside and outside the platform and infrastructure team
  • Partnered with finance, MIS teams, and accounting to ensure the consistency and accuracy of data and reporting
  • Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer
  • Created SQL tables with referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL
  • Wrote stored procedures and triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems
  • Involved in developing scripts for validating the data and maintenance of security and integrity of database
  • Created scheduled batch jobs using PL/SQL for downloading data into temporary tables to generate the data required for some of the reports
  • Worked with the team of business analysts, developers and end users for generating audit reports and troubleshoot the related queries and fix the connectivity issues

Environment: Erwin, SQL Server, Crystal Reports, MS Office, Windows 2003

Hire Now