Lynn Lopez
Senior Data Analyst @Whataburger
Signup · Get unlimited contacts
WORK HISTORY
Senior Data Analyst @Whataburger
I perform normalized and dimensional data modeling. Modeling duties include creating data models for the data warehouse and internal application databases. Responsible for maintaining and updating the data model in ER Studio Data Architect. Perform administrative function for the Idera Team Server. • I work with other IT and business people to determine the data sources for the data warehouse. I also develop SQL to load data into the data warehouse. • I design processes and code SQL for loading data into applications, the operational data store, data warehouse, and data marts. Works closely with the ETL team so they can take that code and convert it to Datastage. • Wrote complex SQL and Stored Procedures in both Netezza and SQL Server as a part of the modeling process. • Encourage programmers to use appropriate data naming standards and to establish proper data domains with data quality checks and data entry enforcement. • Assist data users in establishing requirements for data reporting and applications. • During this assignment, I have developed the dimensional data model and SQL for a Talent Identification application that brings in data from multiple data sources. I have also worked closely with a development team to build the required SQL and DDL for a dot-Net performance assessment application. This project involved extensive work in Visual Studio 2017 and some SSIS development.
EDUCATION
The University of Texas at San Antonio
MBA, General Business Management
Texas State University
BBA, Computer Information Systems
SKILLS
ABOUT LYNN LOPEZ
Lynn Lopez has over 20 years’ experience working as a developer, modeler, and data…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.