Scott Smith

Scott Smith Email and Phone Number

Sr. Database Architect and Engineer @ Finity Communications
Portland, OR, US
Scott Smith's Location
Portland, Oregon Metropolitan Area, United States, United States
Scott Smith's Contact Details

Scott Smith personal email

n/a
About Scott Smith

• I am an I.T. Professional with 20+ years experience with a broad scope of knowledge from business perspectives to hands on development, SDLC, methodologies and industry best practices. I have deep roots with Business Intelligence, Database Architecture, Reporting and Data Movement methods (ETL). I have taken on many different roles in many different industries and have a well rounded knowledge of business systems and industry standards. I have been contracting for the past 17 years and was a Full time employee for 10 years in the healthcare industry.Specialties: I have years of experience in full life cycle data movement projects and individual assignments with roles ranging from analyst and requirements gathering, ETL developer, project manager, programmer, DBA, reports developer and environment administrator to end user training.

Scott Smith's Current Company Details
Finity Communications

Finity Communications

View
Sr. Database Architect and Engineer
Portland, OR, US
Website:
finity.com
Employees:
65
Scott Smith Work Experience Details
  • Finity Communications
    Sr. Database Architect And Engineer
    Finity Communications
    Portland, Or, Us
    View
  • Finity Communications
    Sr. Database Architect/Engineer
    Finity Communications Jan 2020 - Present
    Portland, Oregon, Us
    Database Architecture, Healthcare/Wellness, Snowflake, AWS, Aurora, RDS
    View
  • Nike
    Senior Data Architect
    Nike Jan 2019 - Dec 2019
    Beaverton, Or, Us
    ITAM and Data Architecture
    View
  • Epiq
    Sr. Data Analyst
    Epiq Jan 2018 - Dec 2018
    New York, New York, Us
    SSRS Development and MaintenanceSSIS Package DevelopmentProcess and Schema EnhancementsStored Procedure DevelopmentSQL Performance Tuning
    View
  • The Standard
    Senior Data Engineer
    The Standard Apr 2017 - Mar 2018
    Portland, Oregon, Us
    View
  • Providence Health & Services
    Software Development Engineer
    Providence Health & Services Dec 2016 - Mar 2017
    Renton, Wa, Us
    SSIS package development, SQL Server Stored procedures and T-SQL, Compliance Extracts and data deliverance using Agile/Kanban/TFS.
    View
  • Zoom+Care
    Etl Developer/Business Intelligence
    Zoom+Care Dec 2015 - Nov 2016
    Tigard, Oregon, Us
    Pentaho ETL Development, Data Movement and Data Architecture• Pentaho 6.1, PDI, CE (Data Integration Tools)• Cron – Enterprise scheduling.• Documentation (Metadata, Business cases, Technical specifications, Operations manuals).• Unix Bash script development• Unix shell scripting, plsql, tsql• Conceptual, Logical and Physical data modeling using ErWin 11x.Environment: Pentaho, Cron, ErWin, Postgres 9.5, MySql, SQL Server (2003, 2005, 2008,2010)
    View
  • Bonneville Power Administration
    Informatica Etl Developer/Database Engineer
    Bonneville Power Administration Jan 2010 - Oct 2015
    Portland, Or, Us
    Informatica Development, Data Movement and Data Architecture• Informatica 9.5 development, deployment and support for BPA applications• UC4 – Enterprise scheduling.• Documentation (Metadata, Business cases, Technical specifications, Operations manuals).• Provided Misc. support for other production applications including 24x7 On Call support.• Created multiple stored procedures/views used by Informatica and users, to support seamless implementation and usability.• Conceptual, Logical and Physical data modeling using ErWin 11x.Environment: Informatica (8x, 9x), UC4 Scheduler, ErWin, Oracle 11g, SQL Server (2003, 2005, 2008,2010)
    View
  • The Ods Companies
    Database Engineer
    The Ods Companies Jan 2009 - Dec 2009
    Portland, Oregon, Us
    Database Engineer• ODS Database Engineer and Data Architect.• Principal engineer for all subject areas for data warehouse project.• Creation and maintenance of star schemas and supporting structures using Power Designer.• DDL maintenance, execution and optimization with correct version control techniques (CVS).• Support performance enhancements with indices and correct coding in SSIS.• SSIS mentoring for FTE Staff, Knowledge transfer.Environment: Power designer v.10 - 15, SQL Server 2008, Sybase 11, Aqua Studio, Business Objects, SSIS, Tidal
    View
  • Intel
    Database Engineer Ssrs Report Writer
    Intel May 2008 - Dec 2008
    Santa Clara, California, Us
    Database engineer for the reporting environment for the Digital Health Group at Intel. Responsible for data extracts, reporting and management of the customer data requirements. SQL 2005 Stored procedures, TSQL, DBArtisan, SSRS, Analysis Server, MQC, SFTP and other propriatary tools being utilized. Responsible for custom ETL scripts in the data movement process using SSIS and other custom scripts.
    View
  • Oregon Department Of Education
    Senior Project Manager
    Oregon Department Of Education Dec 2007 - May 2008
    Salem, Or, Us
    Responsible for all technical related project management activities.
    View
  • Intel
    Database Engineer
    Intel Jun 2007 - Nov 2007
    Santa Clara, California, Us
    Reverse engineering and schema enhancements using DBArtisan against a SQL 2005 database.•Create custom stored procedures for reporting against OLTP databases.•Data mapping and object pairing via XML messaging between two systems.•Created object level security and enforcement per government HIPAA Requirements using a combination of encryption and database strategies.
    View
  • The Regence Group
    Data Modeler
    The Regence Group Oct 2006 - Jun 2007
    Portland, Oregon, Us
    • Requirements gathering, Design and implement multiple new data models to support CPSS data modeling effort (Full Life Cycle).• Reverse engineering and cataloging of existing data models.• Provide corporate support for existing and new model diagrams and data dictionaries.• Maintain metadata and supporting repositories.• Routine Model Mart maintenance.• DDL Generation and performance tuning using indexes, partitioning and enhanced physical model structures
    View
  • Bonneville Power Administration
    Etl Developer
    Bonneville Power Administration Oct 2005 - Sep 2006
    Portland, Or, Us
    • Converted 130 ETL Jobs from Ascential Data Stage to Informatica 7.1.3• Successfully moved all jobs into production stream using Control-M Software• Documented and published all related documentation for the production move.• Provided Misc. support for other production applications• Created multiple stored procedures, used by Informatica, to enhance the performance of the Oracle 10g database and the Informatica server• Performed Informatica algorithms to adjust memory and cache sizes for jobs running in production.Environment: Ascetical Data Stage, Informatica, Control-M, ErWin, Oracle 10g, SQL Server 2005
    View
  • Panther Systems, Inc.
    Data Architecture, Cognos Impromptu Report Conversion
    Panther Systems, Inc. Apr 2005 - Sep 2005
    Vancouver, Washington, Us
    Provided expertise into database tuning, data architecture, Cognos Impromptu, Business Objects and Crystal Reports 11. • Provided technical guidance in DB tuning (SQL Server 2000)• Analyzed and documented existing Cognos Impromptu reports/Business Objects reports for conversion to Crystal 10.• Create release notes procedures and business area requirements.• Mentor existing DBA’s on proper data architecture techniques and implementation from transactional systems data.• Successfully converted 160 reports for .net web portal deployment with optimal performance gains and deployment flexibility to web enabled clients. Managed I.T. Staff of 17 FTE’sEnvironment: Windows 2000 server, windows XP Client, SQL Server 2000, Crystal Reports 10.x and 9.x, Cognos Impromptu version v7.2, Business Objects v6.5, ErWin 4.2, DBArtisan, MS Office 2003, MS Access and other Microsoft tools where required, SQL Server
    View
  • Stockamp & Associates
    Olap Development, Reporting Services, Data Architecture
    Stockamp & Associates Jan 2005 - Apr 2005
    Us
    Consulted and implemented a reporting package to support quick and accurate reporting for Stockamp’s client base of over 60 major health care providers. • Consulted and provided key changes for Stockamp’s DSS reporting data marts• Created Microsoft Analysis Server cubes to support client reporting needs• Mentored existing FTE’s in coding custom MDX for Microsoft Reporting Services reports embedded in .NET projects for deployment.• Analysis of existing Microsoft Reporting Services reports and Business Objects reports for replication to newly created MS Analysis Services Cubes and .net deployment• Oversaw I.T.Staff of 15 FTE’sEnvironment: ErWin, Windows 2000/2003 server, windows XP Client, SQL Server 2003, Crystal Reports 10.x, Business Objects v6.5, DBArtisan, MS Office 2003, Microsoft .net with MS Reporting Services Add-In and MS Analysis Services, SQL Server
    View
  • Daimlerchrysler
    Cognos Developer/Data Architect
    Daimlerchrysler Apr 2003 - Dec 2004
    Auburn Hills, Mi, Us
    Implemented corporate Cognos architecture, oversaw and created best practices for corporate enterprise wide installation. Responsible for Cognos development for corporate reporting for the TREAD act reporting/government compliance. Responsible for Cognos management and BI implementation•Created data mart architecture to support analysis and XML extracts•Scripted XML extracts from data marts using Informatica•Created Microsoft Analysis Server cubes to be used in conjunction with Cognos products and other tools.•Authored and designed data marts and Cognos power cubes to support the Freightliner NHTSA “TREAD Early Warning Government Compliance” mandate.•Developed Cognos Impromptu catalogs and reports to support detailed reporting for the aforementioned.•Deployed and customized Cognos upfront reports.•Administrator for the Freightliner Cognos/Business Objects environment.•Deployed Cognos ReportNet company wide and coordinated LDAP/Site minder Integration
    View
  • Freightliner Northwest
    Freightliner
    Freightliner Northwest 2002 - 2004
    Pacific, Washington, Us
    Business Intelligence Development, Cognos Reportnet Implementation, Data Architecture and Informatica ETL Development.
    View
  • The Oregon Clinic
    Database/Reporting Consultant
    The Oregon Clinic Mar 2003 - Apr 2003
    Portland, Oregon, Us
    Consulting with The Oregon Clinic L.L.P. to enhance current financial reporting capabilities. Enhancing current month end reporting process and examining optional transactional systems to support business needs.• Completed review of existing transactional systems and reporting processes.• Provided interim solutions for month end financial reporting using a VB/Access platform vs. manual extraction and compilation.• Recommended long term solution and software vendor(s) Environment: Windows 2000 server, UNIX MS Access, Pix, SQL Server
    View
  • Perry Ellis International
    Business Objects Developer/Consultant
    Perry Ellis International Nov 2002 - Feb 2003
    Doral, Fl, Us
    Responsible for Business Objects universe and report development. Performed Modifications to existing universe structure and reports. Created Ad-Hoc data extracts where conventional Business Objects report would not suffice. • Completed Business Objects catalog development.• Completed Business Objects report development and deployment.• Compiled business area requirements for new report functionality.Environment: Windows 2000 server, Business Objects 6.0, MS Products, SQL Server 7.x
    View
  • Nike
    Data Warehousing Consultant/Project Manger
    Nike Oct 2001 - Oct 2002
    Beaverton, Or, Us
    Provided technical consultation for design optimization and leadership of Nike’s Latin America’s data warehouse and Cognos Impromptu/Powerplay environment in an Oracle 8/AIX platform. Database optimization, schema enhancements and Cognos catalog development and deployment. Completed decision point entry data analysis for implementation into existing data schema. Developed PowerPlay cubes for EIS reporting needs.• Database reverse engineering.• Database enhancements and performance enhancements.• Cognos catalog, cube and report development and deployment.• Project management over Latin America’s region, 10 direct multinational reports.
    View
  • Cnf
    Data Warehousing Consultant / Data Architect
    Cnf Jan 2001 - Sep 2001
    Us
    Provided technical consultation for design and implementation of corporate data warehouse and technical/data architecure in an Oracle 8i/AIX environment, needs assessment and business area requirements in the supply chain management industry.• Database architecture using Erwin/Visual Analyst.• Created and managed outbound vehicle movement database schema for General Motors using Erwin 4.0.• Created Order management schema for GM project.• EDI Data mapping.• Business Area Requirements.• End user reporting and exposure needs.• Supply chain management environment.• Schema volumetric analysis.• Schema design enhancements to existing data models.Environment: ErWin, Oracle 8i/AIX, SQL Server
    View
  • Wellpoint
    Actuarial Systems Developer
    Wellpoint May 1998 - Sep 2000
    Indianapolis, Indiana, Us
    Acted as an Actuarial Systems Developer/Data Architect for the Corporate Actuarial Data Warehouse team. Served as the liaison between Actuarial Systems and the Corporate Actuaries gathering user requirements and aiding the technical team in the design process in multiple phases of development. Responsible for the extraction and compilation of the business area requirements for the corporate actuarial business intelligence needs and subsequently developing the data cubes for distribution to the appropriate Actuaries and Executive Staff.• Stored procedure and program development using Sybase ASE.• Corporate data architecture transactional systems and data marts.• Cognos administration and development. Powerplay and Impromptu catalog development.• MS Access application development including distributed VBA Apps.• Metadata creation/storage and maintenance.• Performance tuning and data training.• Environment: ErWin, Sybase, VB, MS Access, Metadata, SQL Server
    View
  • Health Net
    Senior Systems Analyst
    Health Net Jan 1990 - Mar 1998
    Woodland Hills, California, Us
    Served as part of an I.S. team that developed and implemented the Foundation Health Systems data warehouse/data mart for the membership reporting process.• Participated in the user requirements, design, testing and implementation of a 200+ user data warehouse and data mart.• Oversaw technical staff of 20+ core team members and coordinated JAD sessions.• Served as the Business Objects Administrator and Designer.• Brio and Cognos report development.• Maintained data model in ErWin• Performed user tool and data training pre and post implementationEnvironment: Brio, Cognos, Business Objects Administrator and Designer, JAD, ErWin, SQL Server
    View

Scott Smith Skills

Data Modeling Data Warehousing Business Intelligence Etl Databases Oracle Microsoft Sql Server Ssis Informatica Ssrs Sdlc Data Integration Software Development Life Cycle Data Analysis Enterprise Architecture Cognos Business Objects Visual Basic Analysis Services Unix Integration Software Development Erwin Hyperion Enterprise Data Architecture Relational Databases Sql Tuning Requirements Gathering Systems Analysis Sql Server Reporting Services Sql Server 2000 2008 Metadata Modeling Sybase Iq Sybase Adaptive Server Data Cubes Mdx Kimball Methodology Inmon Toad Db Artisan Xml Databases Business Analysis Performance Tuning Transact Sql Olap Crystal Reports Oracle Sql Developer Requirements Analysis .net Framework Pl/sql

Scott Smith Education Details

  • Moorpark College
    Moorpark College
    Computer Science

Frequently Asked Questions about Scott Smith

What company does Scott Smith work for?

Scott Smith works for Finity Communications

What is Scott Smith's role at the current company?

Scott Smith's current role is Sr. Database Architect and Engineer.

What is Scott Smith's email address?

Scott Smith's email address is sc****@****ast.net

What schools did Scott Smith attend?

Scott Smith attended Moorpark College.

What skills is Scott Smith known for?

Scott Smith has skills like Data Modeling, Data Warehousing, Business Intelligence, Etl, Databases, Oracle, Microsoft Sql Server, Ssis, Informatica, Ssrs, Sdlc, Data Integration.

Who are Scott Smith's colleagues?

Scott Smith's colleagues are Brendan Wray, Isai Morfin, Brianna Johnson, Jenny Maxwell Mba, Phr, Shrm-Cp, Keegan Hanes, Ligali Harruna, Miguel G Moseler.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.