Data analyst / Data modeler Resume

SUMMARY:

Over 20 years IT experience with 12+ years experience in data management and architecture. Strong experience in data modeling, data analysis, data mapping, SQL queries, and database design. Deep understanding of data warehouse environment including dimensional modeling, star and snow flake schemas, ETL and BI.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin, PowerDesigner, Visio, IBM Data Architect

Databases: Oracle 11, Oracle Exadata, SQL Server, Access, Teradata, DB2, Netezza

PROFESSIONAL EXPERIENCE:

Confidential

Data analyst / Data modeler

Responsibilities:

Map newly developed integration model to replace old existing system.
Develop mapping documents, data flow diagrams.

Technical Environment: SQL Server 2014, MS SQL Server Mgmt Studio 2014 v. 12.0.5511.0, Embarcadero ER/Studio v16.03

Confidential

Lead Data Modeler

Responsibilities:

Reverse engineer Aginity base data model.
Develop logical model to support business profitability.

Technical Environment: Netezza, Aginity Amp 2.0, Junos Virtual Environment, Google Open Office, IBM Data Architect 9.2.1

Confidential

Data Validation Analyst

Responsibilities:

Write SQL queries to validate new data coming into the data warehouse from JDE migration project.
Analyze complex data environments with multiple sources.
Develop functional and technical specs for enhancements related to JDE integration project.
Develop process improvement for system integration testing on the data warehouse.

Technical Environment: Oracle 11g, Toad 12.0, JDE 9.0

Confidential

Data Warehouse Analyst

Responsibilities:

Supported Digi - Key Business Intelligence teams by providing dimensional modeling solutions.
Gathered business data requirements from business partners.
Designed and developed reporting structures intended to give several departments the ability to analyze sales, product distribution center and vendor management.
Modeled star-schema environment as well as data integration layer and source databases.
Participated in data architectural strategies and process improvement.
Led the development and maintenance of Erwin data models for the data architecture team.
Created source to target mappings, performed data validation, and developed DDL scripts.
Provided Oracle SQL training to Digi-key employees.
Mentored new data warehouse staff.

Technical Environment: Oracle Exadata, ERwin, SQL Developer, PL/SQL, Informatica, TFS (Agile)

Confidential

Data Architect

Responsibilities:

Supported Best Buy Business Intelligence teams by providing dimensional modeling solutions.
Gathered business data requirements from business partners.
Modeled star-schema environment as well as data integration layer and source databases.
Provided dimensional and OLTP data modeling solutions.
Created source to target mapping, performed data validation and developed DDL scripts.
Coordinate with DBAs in creating and managing tables and indexes.
Develop adhoc queries for Data Warehouse users using Teradata SQL and Oracle SQL.
Participated and contributed to mentoring new data warehouse staff.

Technical Environment: Oracle, Teradata, PowerDesigner, Informatica, SQL Server 2005, Toad

Confidential

Senior Technical Developer

Responsibilities:

Design, build, test and deploy CCE Change Tools such as Role Mapping, Change Impact and Training databases using Microsoft Access and SQL Server 2005.
Develop queries as requested by end users using Microsoft Excel and SQL Server 2005.
Automated information dataloads using SSIS and T-SQL.
Request security and setup for new end users.
Research data issues using Oracle SQL.

Technical Environment: SQL Server 2005, Access, SSIS

Confidential

SQL Server 2005 Database Developer

Responsibilities:

Develop new SQL Server 2005 database to replace existing Lotus Notes database.

Confidential

Data Modeler

Responsibilities:

Develop logical and physical data model for OLTP database to meet business requirements.

Confidential

Data Modeler, ETL Developer, Unix Programmer

Responsibilities:

Responsible for investigating, understanding and documenting data contents of system.
Gathered business data requirements from business partners.
Created source to target mapping, performed data validation, and developed DDL scripts.
Develop logical and physical data model using dimensional methods (Kimball).
Develop extract, transform and load (ETL) processes to data mart using Datastage.
Converted Oracle Pro*C compiler and tested code for Oracle 10g upgrade.
Develop and execute test plans using Test Director.
Coordinate with DBA in creating, managing tables, indexes, privileges for Oracle 9i, 10g databases.
Create and update triggers for referential integrity using Oracle PL/SQL.
Develop load scripts using UNIX shell scripts.
Provided after hours support.

Environment: Oracle 10g, Erwin, DataStage, Toad, DB2

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship