Tableau • Meet with users (including executive leadership) to understand their business needs and gather requirements to develop feature rich dashboards• Administrator for 40+ developers (on other teams) and designed an environment on Tableau Server for users to publish dashboards• Create numerous stretch opportunities for others to improve their skills weeklySQL/SSMS - Used heavily for research and dashboard/data source validation.• Custom SQL used to create most Tableau data sources and source data for ETLPython - Main tool for data science projects, data file processing and custom Alteryx tasks.• Develop scripts to process data files in conjunction with Alteryx which involved consolidating files, shaping the data and removing out of scope data• Used for data science projects to process data files to be fed through machine learning algorithms for analysisAlteryx - Used for ETL and data collection automation. • Import data from vendors and websites using API, FTP and selenium methods• Augment Tableau development for unique cases such as union of tables from different databases and leverage PublishToTableau to automate the entire processConcepts used: SCD type 0/1/2/3, API/FTP/Selenium, PublishToTableau, union/join, aggregation

Sole developer for a front-end customer facing application that sees an average of 10,000 report uses a month using multiple databases and data warehouses totaling over 10 million rows. Wrote scripts and custom code to automate delivery of customized reports to save the bank hundreds of hours per month.Supported multiple reporting projects with gathering requirements, data modeling, reporting, testing, product enhancements and production support.Applications used: SAP BusinessObjects, OBIEE, SQL, Hyperion IR, JavaScript, Perl, Python, XML, TOAD and more.

Lead I&T for the GPS OCX Contract, unclassified development effort. Responsibilities include: build, deploy, test and debug code in a Linux environment. Provided test results that were used for EN (Engineering Notice) proposal responses. Developed custom software and scripts to carry out mission critical tasks as well as maintain existing code.

Compiled design packages that encompass the whole scope of the customer’s lighting control system using LC & D equipment.Drafted diagrams and tech sheets using AutoCAD to be used by contractors and architectsEvaluated Energy Management Systems: Day Light Harvesting, Occupant sensitivity, Time SchedulingTrained and demonstrated to installers and end users on a daily basis to provide excellent customer service