Data Architect Resume Plano, TX - Hire IT People

SUMMARY

Data Modeler experienced in guiding the analysis, design, development, implementation, and support of relational database (OLTP), data warehousing systems (OLAP), and NoSQL Data schemas.
Extensive background in Data Governance, Master Data Management, Conceptual, Logical, and Physical design of data models that support all types of data stores (DB2, PostgreSQL, Riak, MySQL, NoSQL, MongoDB, Hive).
Experience in the querying of two Hadoop eco - systems to gather Email and IM messages for the purposes of Human Resources, Auditing and Legal Department operations.
Designed and implemented a Peer Review Process to ensure accurate and correct queries used for the gathering of Hadoop eco-system searches, process led to 100% search accuracy.

TECHNICAL SKILLS

Databases: MS Access, DB2, PostgreSQL

Database Tools: PostgreSQL Admin, IBM Data Studio

Languages: SQL

Business Intelligence Tools: Business Objects, Crystal Reports

Data Modeling: Erwin 6.x, ER-Studio Data Architect, Visual Paradigm, SAP Power-Designer, Relational Data Modeling, Dimensional Data Modeling, Fact and Dimension Table, Conceptual Data Models, Logical Data Models, Physical Data Models, UML Class Diagrams

Other Tools: Master Data Management, Data Governance, SDLC (Waterfall, Agile), MS Office (Word, Excel, PowerPoint, Outlook), MS Office 365, MS Visio, Use Case, Business Process Modeling

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Data Architect

Responsibilities:

Serve as a Data Architect designing a Data Warehouse to store Student Loan related information.
Designing a new Data Warehouse for the Pennsylvania Higher Education Assistance Association (PHEAA) that will be located on an AWS hosted system.
Transformed and transitioned SAP Power-Designer Data Models into ER-Studio Data models.
Assisted team members in learning how to use the ER-Studio Data Architect v18 tool.
Logical Data Modeling, Physical Data Modeling, Source to Target Mapping, Data Dictionary, Requirements gathering and solicitation.

Environment: AWS Redshift, SAP Power-Designer, ER-Studio

Confidential, Dallas, TX

Data Modeler

Responsibilities:

Serve as a Data Modeler Consultant (Robert Half Technology).
Designing a new database system for Confidential to utilize to manage the business operations.
UML Class Diagrams, Logical Data Modeling, Physical Data Modeling, and JSON Modeling for a PostgreSQL structure to be deployed on AWS technology.

Environment: PostgreSQL, Visual Paradigm, AWS

Confidential, Richardson, TX

IT Analyst - Solutions

Responsibilities:

Served as a Search Analyst with the eDiscovery search team that assists with the discovery of information (Email/IM) requested by the Business Partner, which includes Human Resources, Legal Department, and Internal Auditors. (SQL Query of two Big Data Hadoop eco-system)
Documented a training plan for search analysts to utilize a vendor provided search system to gather and deliver Email for the business partner use. (Data Management)
Developed a Peer Review Process used to ensure the accuracy of each SQL query developed for the searches conducted on two Hadoop (Big Data) eco-systems. The deployed Peer Review Process achieved search team accuracy of 100% from an 85% average. (Data Management)
Worked with ER-Studio to enhance Life Insurance Asset Management data models. (Data Governance)

Environment: Hadoop, SharePoint, ER-Studio Data Architect, Solr Search

We provide IT Staff Augmentation Services!

Data Architect Resume

Plano, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship