Business Intelligence Engineer III @ Contract working with the Amazon.com Student division: Provide support of ETL jobs, incoming tickets, including extensive troubleshooting tasks, with responsibilities covering multiple product lines Provide analytical support and collecting data from different data sources Operational ownership of generating and maintaining key business metrics From November 2015 to Present (2 months) Freelance Artist/DJ @ Expert knowledge of pro-audio equipment, including: MIDI/Surface controllers Direct Driven Turntables CDJs (Pioneer 900 and 2000) Audio Mixers From February 2002 to Present (13 years 11 months) Data Analyst, Customer Data Analysis @ Design and create simple to complex SQL queries Data conversion (manipulating/transforming) of data based on business rules/guidelines Create database objects such as stored procedures, joins, views, and creating/updating tables Debug and review stored procedures and recommend changes Import and export of data, bulk insert of data, Excel file data, and Flat file sources and load into various tables for analysis and processing Process ad hoc data import and data export requests Generate reports, chart and graphs using Excel and SQL Server reporting services (SSRS) Support multiple marketing programs by gathering and analyzing data, generating reports and communicating findings Involved with Code Review processes for an error-free coding environment From July 2013 to November 2015 (2 years 5 months) DJ @ 2013 Season House DJ for RAW Artist: Seattle (Volunteer) From January 2013 to November 2013 (11 months) Greater Seattle AreaData Analyst, Data Services @ Monitored data transmission and proper operation of sensors on meteorological (met) towers used for preliminary wind energy studies around the world Validated met tower data for, and prepared periodic summary reports for use by clients and other groups in the company Created, implemented, and maintained current SharePoint website for my team Troubleshot any erroneous data found in large datasets Fulfilled client data requests as needed Used MS Access to link SQL databases and created, maintained, and developed queries Provided timely communications to clients and team members regarding problems with equipment and for routine reporting Interacted professionally with clients through email, phone and in person Shared and continuously developed knowledge and best practices Created and updated technical manuals for new and existing company procedures for in-house Data Quality Filtering and Processing From February 2012 to July 2013 (1 year 6 months) Greater Seattle AreaData Analyst, Wind Resource @ Analyzed incoming data from meteorological towers and report on findings per relevant standards and company practices Manipulated and impored various forms of data types into bankable data Created Excel charts of weekly wind speed data for wind farm projects Participated in User Acceptance Testing Researched and troubleshoot data issues using spreadsheets and databases Provisionined telemetry modems for meteorological towers Helped manage the structure and layout of the collaboration SharePoint Intranet page for Acciona Acted as an active SharePoint administrator for the wind assessment group Created custom sub sites within SharePoint using web parts and KPIs From May 2008 to February 2012 (3 years 10 months) Greater Chicago AreaData Analyst III – Contractor @ Wrote tailored programs to perform manipulation in FoxPro and understand different commands used when programming Performed queries with FoxPro & Access to get different matching variances Built application forms and add variant functions within the forms in FoxPro Data analysis of employment and wages via multiple reports generated through governmental software Researched and troubleshot data issues using spreadsheet, Access databases and FoxPro databases as reference tools Acted as a scribe and tester during JAD sessions Assisted with training of new employees Troubleshooter for various software and analysis issues Created technical training documents in Word for new employees Assisted in conflict resolution with difficult and/or sensitive survey respondents Formatted and imported data files into Bureau of Labor Statistics approved software applications and databases Followed Bureau of Labor Statistics approved procedures for data analysis, editing and coding Maintained BLS standards for exported data quality From August 2005 to May 2008 (2 years 10 months) Greater Chicago Area

Full Stack Web Development, Computer Software Engineering @ Free Code Camp From 2015 to 2017 Bachelor’s Degree, Information Technology, Software Engineering, 3.24 GPA @ University of Phoenix From 2009 to 2015 AAS; Honors Graduate, Computer Networking Systems @ ITT Tech From 2005 to 2007 Pete Gil is skilled in: Data Analysis, Databases, Wind Resource Assessment, Data Manipulation, Renewable Energy, Wind, Program Management, Microsoft SQL Server, SharePoint, Analysis, SQL Server Management Studio, SQL, Project Management, Client Liaison, Business Intelligence Tools