Publication
An HDFS Tutorial for Data Analysts Stuck with Relational Databases
https://www.toptal.com/developers/database/hdfs-tutorial-data-migration-from-postgresql
Dallas is currently unavailable
Dallas H. Snider
Verified Expert in Engineering
Data Mining Developer
Pace, FL, United States
Toptal member since September 15, 2016
Bio
Dallas has 22 years of database application development experience. He has worked with SQL servers and Oracle and he is comfortable with both Windows and Linux. He also has experience with data analytics on OLAP platforms and data mining. Furthermore, Dallas has extensive experience with ETL tools such as SSIS and IBM's DataStage. He also writes articles for the MSSQLTips.com website.
Portfolio
University of West Florida
Visual Studio, Oracle, Hadoop, Linux, Windows, SQL Server BI
Northrop Grumman Information Systems
Visual Studio, Oracle, Windows, SQL Server BI
Acxiom Corporation
Visual Studio, C++, Datastage, Oracle, Linux
Experience
- Linux - 15 years
- Data Mining - 11 years
- MATLAB - 10 years
- ETL Implementation & Design - 10 years
- SQL Server Reporting Services (SSRS) - 8 years
- SQL Server Integration Services (SSIS) - 8 years
- SQL Server Analysis Services (SSAS) - 8 years
- Datastage - 6 years
Preferred Environment
Oracle, SQL Server BI, Linux, Windows
The most amazing...
...project involved integrating and analyzing millions of rows of data collected by biosensors worn by high performance jet pilots.
Work Experience
Assistant Professor of Computer Science
2012 - PRESENT
University of West Florida
- Taught Java Programming, C++ Programming, Visual Basic, Data Mining, Data Warehousing, Database Administration, Database Security, and Software Engineering Process.
- Worked as the Principal Investigator on the Security and Software Engineering Research Center (S2ERC) research project, “Data Mining for Network Performance Assessment, Phase 2”, sponsored by Northrop Grumman Aerospace Systems, Jan. 2015–Dec. 2015, awarded $26,985.
- Worked as the Co-Investigator on the Santa Rosa County School District project, “Instructional Evaluation Application”, Jun. 2014–Aug. 2016, awarded $314,306.
- Acted as the Principal Investigator on the Security and Software Engineering Research Center (S2ERC) research project, “Data Mining for Network Performance Assessment”, sponsored by Northrop Grumman Aerospace Systems, Jan. 2014–Dec. 2014, awarded $26,985.
- Worked as the Principal Investigator on the Security and Software Engineering Research Center (S2ERC) research project, “A Knowledge Engineering, Team-Based Approach to Introducing Security Assurance Cases”, sponsored by Northrop Grumman Aerospace Systems, Jan.–Dec. 2013, awarded $22,050.
Technologies: Visual Studio, Oracle, Hadoop, Linux, Windows, SQL Server BI
Software Development Analyst Level 4
2008 - 2012
Northrop Grumman Information Systems
- Developed and architected, as the lead architect, the creation and implementation of a data warehouse for the Arkansas Department of Human Services containing highly sensitive and confidential data following the Kimball dimensional design methodology.
- Developed ETL packages in SQL Server Integration Services to extract source system data from Oracle, SQL Server, and SharePoint and then transform and load the data into fact and dimension tables.
- Created dimensions and cubes in SQL Server Analysis Services for business intelligence applications.
- Designed and developed reports in SQL Server Reporting Services using SQL and MDX that followed guidelines set forth by the United States Department of Health and Human Services for reporting compliance and compiling statistics.
- Collaborated with DBA, testing, and logistics teams to deliver quality products.
Technologies: Visual Studio, Oracle, Windows, SQL Server BI
Software Developer Level 4
1996 - 2008
Acxiom Corporation
- Provided Netezza/DataStage ETL consulting and software development for TransUnion, General Motors, State Farm, New York Life, and Nationwide Insurance client account teams.
- Worked as the lead developer for customer fulfillment processes in a large-scale, distributed database in DataStage on AIX for JP Morgan Chase.
- Provided on-call support, fulfillment processing consulting and programming for client account teams such as Time-Life, Sprint, AT&T Wireless, and Primedia.
- Developed a process on a UNIX server to reduce a 12-hour mainframe process to 25 minutes.
- Collaborated with DBA’s and system administrators to performance-tune hardware for optimum parallel processing, database, and DataStage flows.
Technologies: Visual Studio, C++, Datastage, Oracle, Linux
Experience
MSSQLTips.com | Author
I write articles for MSSQLTips.com that provide solutions to problems that I have encountered. The articles are also written to be supplemental material for my students in my data mining, database administration. and data warehousing classes.
The link provided has a list of all of my articles.
The link provided has a list of all of my articles.
Using Concept Maps to Introduce Software Security Assurance Cases | Research Paper
I co-authored this paper on using concept maps to introduce software security assurance cases to new employees.
Creating Reports with SQL Server 2012 Reporting Services | Video Book
This video book will show you how to develop practical reports with an SQL server that utilize tables and matrices, along with bold objects such as pie charts and gauges that quickly gain the attention of the viewer and deliver your message.
With this course, you can acquire the essential skills you need to make an impression on your customers, your audience, or your boss.
With this course, you can acquire the essential skills you need to make an impression on your customers, your audience, or your boss.
Education
2005 - 2011
Ph.D. in Integrated Computing
University of Arkansas at Little Rock - Little Rock, AR, USA
1992 - 1994
M.S. in Instrumental Sciences
University of Arkansas at Little Rock - Little Rock, AR, USA
1988 - 1992
B.A. in Physics
Hendrix College - Conway, AR, USA
Skills
Tools
Camtasia, Weka, Microsoft Visual Studio, MATLAB, SQL Server BI, Visual Studio
Languages
SQL, Bash, C, R, C++, Java
Paradigms
ETL Implementation & Design, ETL
Storage
SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Microsoft SQL Server, SQL Server Management Studio (SSMS), Datastage, Apache Hive
Platforms
Windows, Oracle, Linux, SharePoint
Frameworks
Hadoop
Other
Machine Learning, Data Mining, IBM Watson Analytics
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring