I like learning, technology, and interacting with people. I work in the data warehousing/BI space (ETL and reporting). Recently been interacting with Hadoop via Pig and Hive. Do a good bit of work in Teradata, and a smidgen in MicroStrategy, Ab Initio, and Oracle. Learning some Python, mostly for fun. Specialties: Teradata Oracle T-SQL PostgreSQL SQL Server SSIS Aster Data

Data Science and Engineering Analyst @ ETL, reporting and analysis. Hadoop (Pig, Hive), Teradata, MicroStrategy, Ab Initio, Oracle, Python. From September 2011 to Present (4 years 4 months) Sr. DW Developer @ Tools used: Informatica 8.6, Oracle 9i, Netezza, Bourne Shell, ER/Studio Data Architect Interact with a variety of end-users to gather and understand requirements, and ensure high-quality deliverables are available on time Design and create reporting tables to be used with MicroStrategy Create and maintain ETL processes using Informatica and Oracle Modify and maintain processes to export/import data into Netezza using Bourne shell scripts, Informatica, and NZLoad Unit test and document new developments Provide overnight ETL support as needed Document current ETL and new processes, as created or modified Member of interview panel for new data warehouse members From May 2010 to March 2012 (1 year 11 months) DW Engineer 4/Team Lead @ Tools used: SSIS, SQL Server 2005/2008, Aster Data, Windows batch files, Team Foundation Server Interacted with a variety of data warehouse end-users to gather and understand requirements, and ensure high-quality deliverables are available on time Designed and created reporting tables and data marts to be used with MicroStrategy. This included working with BI team to understand reporting requirements, and with DW architect to design and develop robust ETL processes Developed multiple data marts, including one which is used to measure and increase user engagement Improved existing ETL/ELT, helped develop best practices for DW processes Built and maintained reports for International team using SQL Server and Aster Data Ad hoc reporting for International team using SQL Server and Aster Data Created royalty reporting files for MySpace Japan for music and video. Results were used for paying royalties to JASRAC, the Japanese Recording Artist Association Created reporting for A/B testing of new toolbar. The results were used to guide deployment of the updated toolbar Worked on distinct user definition for data warehouse with members of several other teams, including the VP of data and the Director of data mining Created various user activity marts. Report tables were used by power users through MicroStrategy Team SharePoint administrator. SharePoint is used for documentation and sharing code, including some code reviews by the data warehouse team Created page view ETL and reporting. This was one of the first metrics delivered by the data warehouse, and showed value from new data warehouse platform, which gave the company the ability to track metrics that were not available before Created SSRS reports for Apps team, including execs. Reports were used to track adoption of apps by users, and most popular apps Member of interview panel for new data warehouse members. Interviewed candidates and gave recommendations to management From March 2008 to May 2010 (2 years 3 months) Business Intelligence Analyst @ Tools used: SQL Server 2005, SSIS, SSAS, Cognos, Virtual SourceSafe Maintained, administered, and adjusted all ETL processes (SSIS) for BI server, which hosts over 300 reports used company-wide New report creation (SQL Server 2005 Reporting Services) and dashboard administration Provided on-call support for overnight ETL processes Provided DBA support as needed, including Cognos and Virtual SourceSafe From September 2007 to February 2008 (6 months) Database Analyst III @ Tools used: SQL Server 2000, DTS Technical lead. Spearheaded effort to automate scheduled reporting, clearing up hundreds of man-hours to work on high profile projects and ad hoc requests. The automated reporting project allowed the team to remain efficient without an increase in headcount. Over one thousand automated reports are sent out monthly through the automated reporting process. Improved external facing ROI reports by streamlining code and adding quality control measures using a combination of SQL Server tables and VB.NET programs. The efficiencies and quality assurance measures put in place reduced quarterly project run time for my team from two months to three days. Created and automated transaction summary tables that greatly reduced report run times. Average run times dropped from three minutes to under ten seconds. Created code used by marketing team to identify and focus on reactivating clients, and to increase client entanglement. These programs were highly successful in bringing in additional revenue to the company which would have otherwise been lost. Updated and streamlined code used to market to existing and potential clients through direct mail and electronic direct mail pieces. The code is used to find appropriate targets, as well as suppressing touches in line with client wishes. The original code was multi step process that took over an hour to run. Run time was reduced to approximately eight minutes. Lead effort to centralize re-usable code, ensuring greater code accuracy and consistency. This allows new team-members to become productive quickly, while allowing code changes and improvements to be implemented across reports easily and automatically. Technical advisor in high level meetings for company-wide initiatives. Created reports for external clients and internal clients ranging from the Executive team to Sales Managers. From 2005 to 2007 (2 years) Sr. Report Director @ Responsible for directing long-term and one-off data studies for Fortune 500 companies. Promoted three times, from Assistant Project Director, to Project Director, to Senior Project Director. Successfully and skillfully managed multiple accounts at once. Spearheaded innovations which improved accuracy and speed of checking process, saving hundreds of man-hours across multiple studies. Set expectations, negotiated time line for deliverables, and ensured quality of product delivered to both internal and external clients. From 2000 to 2004 (4 years)

BS, Psychology @ Arizona State University From 1998 to 1999 Adrian Senftleben is skilled in: Data Warehousing, Microsoft SQL Server, T-SQL, ETL, Business Intelligence, SSIS