Scott Smith Email & Phone Number

Portland, OR, US

Portland, Oregon, US

Database Architecture, Healthcare/Wellness, Snowflake, AWS, Aurora, RDS

Beaverton, OR, US

ITAM and Data Architecture

New York, New York, US

SSRS Development and MaintenanceSSIS Package DevelopmentProcess and Schema EnhancementsStored Procedure DevelopmentSQL Performance Tuning

Portland, Oregon, US

Renton, WA, US

SSIS package development, SQL Server Stored procedures and T-SQL, Compliance Extracts and data deliverance using Agile/Kanban/TFS.

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

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.

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.

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.

Salem, OR, US

Responsible for all technical related project management activities.

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.

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

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

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.

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.

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.
• 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.

Pacific, Washington, US

Business Intelligence Development, Cognos Reportnet Implementation, Data Architecture and Informatica ETL Development.

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

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.
• 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

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.
• 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.

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.
• 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.

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.
• 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.

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