SQL with Jake R.

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) • HRIS 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.