Ted Stillwell Email & Phone Number

* Full data warehousing analysis, architecture, and implementation including: Data Modeling (Kimball methodology), Business Analysis, Relational Database Development, Multidimensional Database Development – OLAP, ETL (Extract, Transform and Load) Procedures, Data Validation and Cleansing, Master Data Services, Report Development, Dashboard Development.* Data warehousing business analysis and implementation strategy.* Served as lead technical architect for several BI/DW engagements.

Phoenix, Az, Us

• Development of Power BI, Report Builder dashboards and reports using SQL, DAX with Analysis Services and Snowflake.• Semantic model development, dimensional modelling recommendations for HR functional implementation.

Zug, Ch

• Trained in clinical research trial process including multi-government regulations, processes and procedures. • Data warehousing analysis, architecture, and data modeling (Kimball methodology), business analysis and relational database development.• ETL/ELT stored procedure analysis and development.• Facilitated data model for Power BI dashboards.

New York, Ny, Us

• Met or exceeded performance metrics while providing support for Infor Birst reporting and dashboarding tool.• Backend support to troubleshoot issues with data ingestion, performance and and connectivity configuration.• Frontend support to troubleshoot issues with performance, dashboard, reporting, variables and modeling issues.• Responsible for identifying software deficiencies and working with internal teams to resolve them.• Provided customer guidance on software features and capabilities.• Worked on special projects as required such as team SharePoint team collaboration site.

Santa Clara, California, Us

• Provided sales engineering support (architectural, data governance) for analytics solutions and data migrations.• Implemented Microsoft Azure Analysis Services solution (Tabular model) for a consumer products manufacturer.• Created Snowfake DB data model and Talend ETL procedures in support of COVID-19 survey project.• Implemented SnowAlert solution - Snowflake DB’s Security Event and Information Management (SEIM) to track critical and non-critical events.• Provided ETL analysis for a beverage distributor.

New York, New York, Us

• Created ELT and ETL procedures using Matillion and Snowflake DB to extract and load data from application repositories and event data.• Designed and developed email data mart from Responsys including ETL procedures, dimensional design and Birst dashboards.• Provided production support for ETL procedures and database operations for 4TB data lake implementation.• Refactored registry operations sales and referral feeds to take advantage of data warehouse infrastructure.

Austin, Tx, Us

• Developed custom and complex reports using SSRS.• Provided production support for existing SSRS reports to fix bugs or deliver enhancements.• Developed and modified complex SQL stored procedures.• Collaborate and help develop improved processes, requirements and data solutions with both business owners, stakeholders and other development teams.• Worked with development operations to develop automated reporting deployment.• Served as interim development lead for reporting team.

• Designed and provided cost estimates for data warehouse infrastructure.• Directed technical team for migration of marketing data warehouse from MySQL to SQL Server.• Designed and created required data tier elements and implemented ETL architecture to populate them using Microsoft SQL Server Integration Services (SSIS).• Designed and populated data tier for migration of Tableau reports to Microsoft Power BI.

Austin, Tx, Us

* Responsible for technical design and implementation of Tokyo Electron's data warehouse initiatives.* Designed and led development for financial data warehouse using Microsoft SQL Server 2016 platform including Master Data Services MDS, Data Quality Services DQS, Reporting Services SSRS and Integration Services SSIS.* Implemented ETL framework including scheduling, control, recoverability and metadata management.* Evaluate new technologies and advise on how they may be incorporated.* Provide technical training on business intelligence BI technologies.* Provide production support for ETL, relational and multidimensional data sources.

Austin, Tx, Us

• Created oil and gas data warehouse using Kimball methodology.• Designed and implemented ETL framework including logging, recoverability, metadata and auditability.• Designed and built document ingestion ETL process including MIcrosoft Data Quality Services solution to clean and de-duplicate data.

Irvine, California, Us

• Served as the Microsoft Business Intelligence architect.• Created and implemented architectures for data warehousing solutions including data source analysis, ETL, dimensional modeling, multidimensional modeling and reporting.• Supervised Microsoft BI development and provided training to the development team.• Provided pre-sales support and project estimating.• Implemented solutions in non-profit and industrial manufacturing industries.

Austin, Texas, Us

• Evaluated existing data warehouse infrastructure and provided architectural recommendations.• Provided technology selection advice between MicroStrategy and Microsoft BI stack.• Performed data modeling and created technical design documentation for financial data warehouse.• Performed data analysis, profiling for ETL implementation.• Conducted business analysis to collect requirements for financial data warehouse.

* Provided data warehouse production support and backup database administrator support.* ETL Architecture and development for systems implementation.* ETL maintenance and development using SSIS and SQL.* Data analysis and research support.

Austin, Tx, Us

Senior Business Intelligence Consultant for Catapult System's San Antonio, TX practice. Activities include:Full data warehousing analysis, design, and implementation:* Data Modeling* Business Analysis* Relational Database Development* Multidimensional Database Development - OLAP* ETL (Extract, Transform, Load) Procedures* Data Validation and Cleansing* Report Development * Dashboard DevelopmentPrior industry experience includes government, telecommunications, insurance, utilities, oil & gas, consumer products.Technologies Include:Microsoft SQL Server 2005 & 2008Microsoft SQL Server Integration ServicesMicrosoft SQL Server Reporting ServicesMicrosoft SQL Server Analysis ServicesMicrosoft Office Performance Point ServerMicrosoft Office Excel ServicesMicrosoft SharePointProgramming Skills:TSQL, MDX, CSS, XML, HTML, VBScript

Austin, Tx, Us

* Assisted buyers and sellers for residential real estate transactions.

Completed business intelligence engagements in the government and insurance agencies using the Microsoft Business Intelligence stack. Activities included:* Data Modeling* Business Analysis* ETL (Extract, Transform, Load) Procedures* Strategic Dashboarding and Report Creation

New York, Ny, Us

• Conducted enterprise data warehouse analysis and modeling, using Kimball methodology, at a Fortune 500 semiconductor company.• Worked toward documenting data flows, creating source to target mappings and consolidating data into dimensional models.• Designed and implemented SQL Server 2008 data warehouse components including schemas, tables, views, stored procedures, and functions.• Provided implementation strategies for Microsoft Business Intelligence tools including SQL Server Reporting Services reports, PerformancePoint dashboards and ProClarity analytical tools.

Seattle, Washington, Us

• Business Intelligence developer and consultant specializing in Microsoft technologies for global IT consultancy (jointly owned by Accenture and Microsoft).• Assisted enterprise level customers in designing and implementing Business Intelligence strategies that fit their unique requirements and provide a complete, integrated view of their overall organizational health.• Designed, developed and tested BI solutions using the most current Microsoft technologies including the development of data warehousing schema (relational and multidimensional), extract/transform/load (ETL) procedures and BI end products such as dashboards, scorecards, key performance indicators (KPIs) and managerial reporting, financial reporting and operational reporting.

• Implemented a prototype Business Intelligence solution for a national construction firm.• Performed ETL procedures to consolidate data sources into a SQL Server 2005 database. SQL Server Integration Services was used to define data imports, build scheduling packages, define integration flow, log data error exceptions and orphaned data, implement maintenance plans and send notification emails. • Created OLAP cubes, dimensions and business critical KPIs using SQL Server Analysis Services for analytical performance. Created MDX queries according to business requirements. • Developed detail and summary reports including line and pie charts, trend analysis and sub-reports according to business requirements using SQL Server Reporting Services. • Implemented business intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership. • Created score cards with executive summary dashboards using MS Office Performance Point Server 2007 Dashboard Designer that display performance monitoring measures with data from a SQL Server 2005 OLAP data source and deployed them to SharePoint sites.• Created score cards with advanced dashboards using MS Office Performance Point Server 2007 Dashboard Designer offering executive summary measures with data extracts from a SQL Server 2005 OLAP data sources and deployed them to SharePoint sites.

Atlanta, Georgia, Us

• Acted as consumer voice for Austin Division of Fortune 500 home builder.• Owned the Operational Strategic Planning Process and led senior management to customer driven opportunities. • Identified market opportunities using target consumer groups, submarket preferences, and supply/demand data.• Assisted land acquisition functions by providing targeted consumer group supply and demand metrics and product pace/price forecasts for feasibility process.• Assisted sales & marketing with product selection, product development, and competitive pricing analysis.• Conducted market research activities including market analysis, site validation studies, buyer/shopper/rejecter studies, livability studies, and customer focus groups.• Received "Difference Maker of the Quarter" Award for Q2 2006.

Los Angeles, Ca, Us

• Used Microsoft Reporting Services and Microsoft SQL Server 2000 tools to streamline and standardize sales reporting process resulting in cost savings, improved accuracy, and increased availability of information.• Created enterprise wide Key Performance Indicator (KPI) reporting with drill through and parameter features which allowed end-users to make more effective business decisions.• Developed business requirements for and participated in project management of enterprise-wide business intelligence (managerial reporting and scorecard analysis) system including user acceptance testing and post deployment training.• Provided detailed performance analytics to division, regional, and corporate executives for $5.8B Fortune 200 Company.

Basking Ridge, Nj, Us

• Utilized financial insight and technical skills to provide timely financial analysis for co-location product ($500M annual revenue) including variance, trend, forecast, journal entries, and ad hoc requests.• Designed and developed MS Access OLAP cube and MS Excel analysis tools that streamlined reporting processes and increased productivity – received performance award.• Developed financial models and provided upper level management with insight for decision making. • Provided financial and analytical support to the GTENS East Region Wholesale Markets Account Management team, including support of incurred expenses, the Sales Incentive Compensation Plan, revenue reporting support, and various added requests.

Master'S, Business Administration

Master'S Certification, Business Intelligence

Bachelor Of Arts, Biblical Studies

Bachelor Of Arts - Ba