We provide IT Staff Augmentation Services!

Data Analyst Resume

Chicago, IL

SUMMARY

  • Over 8+ years of IT experience in the field of Business & Data analysis, ETL Development, ETL Testing and Data Modeling.
  • Strong experience in Business and Data Analysis, Data Profiling, Data Mining, Data Migration, Data Integration, Data architecture and Metadata Management Services and Configuration Management.
  • Lead & delivered Master Data Governance, Data Quality (DQ), D&B enrichment and cleansing solution for large French based global life - sciences company.
  • Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams with all related entities and relationship with each entity based on the rules provided by the business manager using ERWIN.
  • Worked extensively in forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Published Data model to acrobat PDF files, extensively created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-ordinated with DBAs to apply the data model changes.
  • Extensive Experience on Creating Visualization Dashboards using Tableau and Alteryx.
  • Very large database optimization and performance tuning to address data latency requirements utilizing performance analysis, execution plans, Bitmap Indexing, Partitioning, Materialized Views, Parallel Queries, Merge and Pipelines.
  • Enterprise wide applications security and compliance, corporate standards and best practices.
  • Collaboration software (SharePoint), technical specifications and system documentation.
  • Good Knowledge of ETL Processes such source, mapping, transformation, staging areas and created various ETL documents such as ETL Mapping documents, Data Mapping documents, ETL test scripts etc.
  • Excellent knowledge of Software Development Life Cycle (SDLC), Adhered to standards/guidelines through out the development life cycle and maintenance of the models.
  • Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities.
  • Extensive Experience working with business users/SMEs as well as senior management.
  • Strong understanding of the principles of Datawarehousing using Fact Tables, Dimension Tables, star and snowflake schema modeling.
  • Strong experience with Database performance tuning and optimization, query optimization, index tuning, caching and buffer tuning.
  • Extensive experience in backend programming including Database table design, Stored procedures, Triggers, Indexes, Performance tuning in DB2/Netezza/Teradata and Oracle .
  • Good knowledge in analysis and reporting using various Business Intelligence tools such as Cognos and Business Objects.
  • Excellent verbal, presentation and written communication skills. Able to communicate with technical, non-technical and senior management audiences. Have played a significant role in requirements planning, client interaction and documenting.
  • Excellent problem solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS

Data modeling: Erwin,(8.2,8.1,7.3.5) Power designer,Embarcadero

Databases/Tools: Teradata,12.0Netezza,Oracle 15g/11g MS SQL Server 2014, MySQL, Sybase 11.5/11.2, MS Access, Cobol Copybook, Mainframe Files, DB2 UDB, XML, SQL Navigator, Toad

ETL Tools: Alteryx,Informatica PowerCenter 8x, 7x/6.1, 5.1, DataStage, Ab initio

BI Tools: Tableau, SAP BW,Business Objects, Cognos,OBIEE,Crystal Reports 2008

Architectures: OLAP, OLTP, OOP, SOA, Client-Server

Databases: Teradata, SQL SERVER, Oracle, Mongo DB

Operating Systems: UNIX, Linux 7.0+, Macintosh 9+, Windows 95/98/2000/XP

Programming Languages: C, C++, JAVA, XML, HTML, SQL, JavaScript, Perl, PHP, Shell Scripting, websrevices.

Software Engineering Tool: Rational Rose, Requisite Pro

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Data Analyst

Responsibilities:

  • Worked Extensively on Various Projects implementing Database changes in the respective Data Models and implementing Reverse Engineering of Database Structure to enhance the models and also comparing the models to incorporate changes
  • Migrated 40 Cognos v11 Dashboards to Tableau 2019
  • Created complex KPI Dashboard using Tableau and Alteryx
  • Extensively used Erwin and Normalization Techniques to design Logical/Physical Data Models, relational database design.
  • Worked in Data Analysis, data profiling and data governance identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
  • Developed Data Mapping, Data Governance, and Transformation and cleansing rules for the Master Data Management Architecture involving OLTP, ODS.
  • Developed Data Mapping, Data Governance, and Transformation and cleansing rules for the Master Data Management Architecture.
  • Qliksense dashboard to present current data quality and effectiveness with data cleansing.
  • Participated in Requirement Gathering, Business Analysis, User meetings, discussing requirements for new table design in existing Data base and discussing about new columns for existing tables in Database..
  • Worked on the Data Warehouse team analyzing data files that had to be compiled from disparate non-production sources and readied them for production. Tasks included: comparing data to requirements documentation, creation of data layouts, data dictionary, and the pipe delimited and fixed width files. In addition, was team lead for managing the completion and loading of these files for the Data Management group
  • Conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities.
  • Well-versed in understanding existing logical data models and constructing physical data models from same
  • Extracted Data from SAP BWInfocubesand DSO Source using Open hub and also did data validations Using RSA1
  • Created 20 workflows using Alteryx
  • Experience in handling, configuration and administration of databases like MySQL and NoSQL databases like MongoDB and Cassandra.
  • Ability to recognize and resolve discripancies between executed DDL and the physical data model using complete compare
  • Ability to document activities and communicate with Data Architects as to status of Physical Data Modelling activities.
  • Ability to synchronize updates to physical data models with updates from the data architecture logical data models.
  • Ability to follow IBC configuration management standards (e.g. check-in and check-out procedures for models as defined by IBC standards).
  • Coordinating with DBA in implementing the Database changes and also updating Data Models with changes implemented in development, QA and Production

Environment: Tableau 2018.2/2019.2 , Alteryx, Teradata, SAP BW, Mongo DB,Netezza, Oracle 9i/10g/11g,Sql Server 2008/2012/2015 , DB2 LUW, DB2 ZOS, Unix AIX 5.2, Linux, ERWIN 7.3/8.28

Confidential, Wilmington, DE

Data modeler/Analyst

Responsibilities:

  • Extensively worked on various database impacts on CMS application once the impacted changes are known in project requirements review.
  • Extensively worked with Model maintainance project where all the Data models which are not toupto standards making them standardized
  • Writing implementation plans in order to implement the database changes into QA and Production environment
  • Coordinating with DBA in implementing the Database changes and also updating Data Models with changes implemented in development, QA and Production
  • Created Data dictionary using ERWIN modeler.
  • Involved in Low level Design for the scripts of the database sequences, constraints, triggers and stored procedures.
  • Knowledge of Merging several flat files into one XML file.
  • Extensively worked on creating, Altering and Deleting the Tables in different Development Environments and also Production.
  • Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas,data dictionary, publishing model to PDF and HTML format, generating various data modeling reports etc..
  • Extensively worked with logical models to change them into complete physical models from where we can implement these models into database.
  • Designed a Conceptual Data Model, Logical Data Model, and Physical Data Model using Erwin.
  • Extensively worked with developers on analizing the impacterd changes on respective applications based on which design approach is taken and also same chages are implemented in database with help of DBA.
  • Created physical models for the applications which don’t have any physical models from logical models.

Environment: Oracle 9i/10g/11g,Sql Server 2005, Toad 8.6 for Oracle, DB2, Unix AIX 5.2, Linux, ERWIN 7.3/,, Flat Files, Hyperion 8.3.

Confidential, Eden Prairie, MN

Data Analyst

Responsibilities:

  • Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
  • Worked on the Data Warehouse team analyzing data files that had to be compiled from disparate non-production sources and readied them for production. Tasks included: comparing data to requirements documentation, creation of data layouts, data dictionary, and the pipe delimited and fixed width files. In addition, was team lead for managing the completion and loading of these files for the Data Management group
  • Developed Loding Scripts for Terradata database using Fast Load Utility
  • Participated as member of a project team performing various lifecycle tasks for an intranet application with Oracle database for tracking public offering orders. Developed logical and physical database models and data dictionary documentation. Worked as liaison between users and developers refining and explaining user requirements.
  • Worked with Terradata utilities Fast Load to develop loading scripts to mock the Data
  • Assess data quality requirements in terms of data completeness, consistency, conformity, accuracy, referential integrity, duplication and evaluate vendors (Informatica Data Explorer/Data Quality, identify and measure data quality, design and implement data profiling and data quality improvement solution to analyze, match, cleanse, and consolidate data before loading into data warehouse.
  • Develop data quality reports/dashboards with Cognos Framework Manager and Report Studio.
  • Designed the relational data model for operational data store and staging areas, Designed Dimension & Fact tables for data marts.
  • Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, creating DDL scripts, data dictionary, publishing model to PDF and HTML format, generating various data modeling reports etc..
  • Designed a Conceptual Data Model, Logical Data Model, and Physical Data Model using Erwin.
  • Worked as a Data Warehouse and Database Developer. Core responsibility is to interview with customers and subject matter experts to gather the requirements for a proposed database analyze these requirements and source systems required to build the data warehouse using Data Warehouse Builder.
  • Data Architect in a centralized group doing logical and physical data models in ERWIN. Also, wrote database interface specifications and documented in Data Manager data dictionary.
  • Designed Informatica ETL Mappings documents, created ETL staging area framework, created data mapping documents, data flow diagram, ETL test scripts etc.
  • Extensively used Erwin and Normalization Techniques to design Logical/Physical Data Models, relational database design.
  • Experience with utilities Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE).
  • Conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities.
  • Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, creating DDL scripts, data dictionary, publishing model to PDF and HTML format, generating various data modeling reports etc..
  • Extensively involved in creating, maintaining, updating documents like requirement document, database design document, System design document, naming standard procedures, SOPs etc.
  • Analyzed and optimized the existing business processes using Conceptual Models and Data Flow Diagram. The process included performance enhancement requirements assessment and mapping of existing work flow and data flows.

Environment: Erwin,, DB2v7, XML/XSD, Qwest Center, MS SQL Server, Teradata, RedHat Linux Shell Scripts, PL/SQL, IBM Control Center,Informatica Power Center v 8.6.1, Cognos v8, Tunnelier, Test Track Pro, TOAD, PVCS, Microsoft Project Plan

Hire Now