Joseph Till

Background

About Joseph Till

Goals To obtain an interesting position utilizing my SQL skills in, preferably, an industry I'm new to so I can experience different ecosystems and gather new experiences. There is no limit in this regard. Please note that any inquiries pertaining to work primarily seated in SQL or data migration will be ignored. This is the primary purpose of moving to a new line of work. ≡ Projects º Extensively re-written Perl (PL) programs in a cleaner, more visible fashion. º Completed projects in an AGILE method. º Used JIRA frequently to create and track tasks. º Created Denodo report utilizing several database objects. ≡ Datawarehouse / Report Creation Software º Informatica PowerCenter 9.1.0 (all PowerCenter clients) º Oracle SQL Developer (mostly SQL, some PL/SQL) º PuTTY (DDL management) º UltraEdit º Denodo º Ignite º WinSCP º Microsoft Suite ≡ Schedule Optimization Tasks º Create partitions and sub partitions for tables. º Examine explain plans for queries to ensure the optimizer is handling indices and joins in the manner we want. º Create unique/non-unique indices based on join criteria. º Convert heavy-running parts of queries into Informatica components. ≡ Informatica Tasks º Create lookups to simulate outer joins. º String together transforms to emulate query behavior and utilize Informatica's power (expressions, filters, routers, lookups, sorts, aggregate). º Create mappings with multiple targets and split targets into partitions in the Workflow Manager based on table's data. º Examine logs to adjust sessions properties like commit interval, amount of space to cache for transforms and temp space, session configurations. ≡ Data Migration Related Software º SAP Data Services º Microsoft SQL Server º Toad for SQL Server ≡ Software Experienced Through Education / Recreation º Programming: C, Java, Scheme, Qbasic, Vbasic º SPSS (statistics) º DreamWeaver (HTML/XHTML/CSS) º Photoshop / GIMP / Paint editing skills ≡ Hobbies º Video Game Play / Observation (Lots of Fond Memories With Friends; Twitch) º Insect Observation º Baking