- Teaches students:
- Ages 5+
- Teaching since:
My experience was born from necessity and includes:
• Data mapping
• Data normalization
• Data reconciliation
• Database documentation (ERD and Data Dictionary)
• Database architecting
• Database development (Oracle and SQL Server)
• "Old school" ETL development
• Code converting from and to SQR, PL/SQL, T-SQL, all flavors of SQL, and VB(-A, -S, -.Net)
• Solution architecting
• Troubleshooting existing databases, their data, and related process.
• Troubleshooting the noted languages above as well as C#
• Teaching ANSI SQL, Oracle SQL, SQL Server SQL and MS Access
The industries that I gained this experience from were:
• Finance (lease and purchase)
• Legal (compliance with law)
I've worked in environments as small as a single database to as large as a single environment that contained 12 servers with thousands of schema and over a 1100+ clients; each client having their own HR, Payroll, Benefit and Leave of Absence data source. These clients also had anywhere between 5,000 and 200,000 employees.
In short, I understand and have experience with small tasks like building an automated process with MS Access to medium tasks of migrating and/or integrating newly acquired companies' HRIS to large tasks like querying, and if necessary transforming, billions of records with terabytes of data in a timely and efficient manner.
I had the pleasure of working with Jake Riley when I was brought on board at the same company he was working for at the time. Part of my background had been in Business Intelligence so I had an understanding of relational databases but I had never written SQL code. As part of my duties documenting Access databases, Jake saw in me a potential I myself didn't realize - that being the ability to write SQL. Over time, Jake guided me through basic SQL syntax and helped me build my SQL repertoire into more complex and powerful queries - with my doubting my abilities along the way. Over the years, I've come to appreciate even more how lucky I was to work with a professional who not only has exceptional depth in the world of SQL but also has the ability to communicate that knowledge to beginners, intermediate and advanced users alike. And by the way, I am now not only a hardcore SQL junkie but it's the focus of my current position. - Chris Wilson, Master Data Analyst+ Read More