Roderick is available for hire
Hire RoderickRoderick Lee
Verified Expert in Engineering
Database Developer
Location
Westminster, CA, United States
Toptal Member Since
June 18, 2020
Roderick是一位专门从事商业智能和数据开发的信息管理专家. 他精通数据仓库生命周期的各个方面, including data design, ETL, reporting, installation, implementation, and administration. 罗德里克寻求一个关键的角色，以利用他丰富的经验和技能，并增加价值, stability, and success to a growing organization.
Portfolio
Systems Source
商业智能(BI)， SQL Server报表服务(SSRS)， Perl...
Wells Fargo
SharePoint, SQL Server报表服务(SSRS)，数据仓库，ETL...
CTG HealthCare Solutions
数据仓库、ETL、商业智能(BI)、T-SQL (Transact-SQL)...
Experience
Availability
Full-time
Preferred Environment
ETL, Oracle PL/SQL, Business Intelligence (BI), PL/SQL, Oracle, Data Migration, Data Analysis, SAP BusinessObjects (BO), SAP BusinessObjects Data Service (BODS)
The most amazing...
...我帮助开发的软件包是一个用于互联网广播的CMS -处理前端HTML生成和所有事务-使用Oracle PL/SQL.
Work Experience
Database Reporting Analyst
2018 - PRESENT
Systems Source
- 为一家行业领先的合同办公家具和室内设计公司提供数据库报告(SSRS和Power BI)咨询.
- Developed, tested, 并管理运行在SQL Server事务数据库上的SSRS内部报告. 编写并测试用于填充这些报表的Transact-SQL存储过程.
- Designed, built, and tested project status, revenue, 在SSRS和Power BI中提供市场分析报告和图形演示.
- 共同设计新的库存和产品目录数据模型. 创建特别的SSIS任务和SQL查询来填充主事务系统中的数据库和选择表, sourcing from a flat file, Excel, the file system, or native SQL.
- Wrote and tested code fixes, feature enhancements, 并对以辅助角色运行在同一事务系统之上的前端Perl CGI接口进行修饰性更改，以减少主要开发人员的工作量.
Technologies: 商业智能(BI)， SQL Server报表服务(SSRS)， Perl, SQL Server Integration Services (SSIS), ETL, Database Development, OLTP, T-SQL (Transact-SQL), SQL Server 2014, SharePoint, Microsoft Power BI, JavaScript, Visual Basic, Data Migration, Data Analysis, Data Modeling, Microsoft BI Stack, Scripting, Internet Information Services (IIS), CGI, Business Objectives, SQL, Stored Procedure, Data Architecture, Microsoft SQL Server, Visual Studio, Database Migration, Data Engineering, Web Applications, Data Extraction
Business Intelligence Data Architect
2016 - 2017
Wells Fargo
- 为一家财富500强银行的直接汽车贷款部门提供商业智能咨询. 范围涵盖了Microsoft Business Intelligence套件中的ETL和报告.
- Wrote, designed, 优化了一个SSIS包，将Oracle直接汽车贷款申请源数据传输到一个新的SQL Server报表数据集市.
- Tested and optimized Transact-SQL procedures, called by SSIS, 将源复制数据转换为相应的目标数据仓库格式.
- 使用SSRS, SharePoint Server和Power View设计和构建管理仪表板报告.
- 分析MicroStrategy报告中的原始SQL查询，以添加新的数据元素，从而消除对原始SQL的需求.
Technologies: SharePoint, SQL Server报表服务(SSRS)，数据仓库，ETL, Database Development, OLTP, Business Intelligence (BI), T-SQL (Transact-SQL), SQL Server Integration Services (SSIS), Data Migration, Data Analysis, Microsoft BI Stack, OLAP, SQL, Stored Procedure, Data Architecture, Microsoft SQL Server, Visual Studio, Database Migration, Data Engineering, Data Extraction
ETL Developer
2014 - 2016
CTG HealthCare Solutions
- 作为ETL开发人员团队的成员，担任医疗保健IT服务解决方案提供商的ETL (SSIS)顾问.
- 编写和测试SSIS包以加载新的医疗保健客户, claims, 并将实验室数据导入现有的数据仓库.
- 为单独的开发管理多个SSIS配置设置, QA, 以及所有团队成员包的生产环境(不仅仅是我的).
- 对传入的平面文件源数据进行数据分析，进行数据映射, defect management, or unit testing.
- 与业务分析师协调用户需求.
Technologies: 数据仓库、ETL、商业智能(BI)、T-SQL (Transact-SQL), SQL Server Integration Services (SSIS), SQL Server 2014, Data Migration, Data Analysis, Microsoft BI Stack, OLAP, SQL, Stored Procedure, Microsoft SQL Server, Visual Studio, Database Migration, Data Engineering, Data Extraction
Senior Technical Analyst
2010 - 2014
Linea Solutions
- 曾在一家专门从事公共雇员退休系统的金融和商业服务IT咨询集团担任数据分析师和开发人员.
- 在SQL Server (T-SQL)或Oracle (PL/SQL)中编写和测试数据迁移和数据协调存储过程，以将遗留养老金数据转换为新的供应商数据模型, both for conversion and data cleanup.
- 为各种任务编写SSIS和DTS包:导入源遗留数据和其他第三方非rdbms数据, exporting transformed data to flat files, 或者为源/目标数据验证传输错误结果集.
- Wrote, in Oracle systems, SQL*Loader命令脚本，用于类似于上一项中概述的加载操作(输出例程是PL/SQL).
- 为QA和数据映射创建和管理MS Access数据库.
Technologies: SQL Loader, SQL Server Integration Services (SSIS), ETL, Database Development, Oracle PL/SQL, OLTP, T-SQL (Transact-SQL), Toad, Unix, Microsoft Access, SQL Server 2014, SQL Server Analysis Services (SSAS), PL/SQL, Data Migration, Data Analysis, Scripting, C Shell, KSH, Oracle, SQL, Stored Procedure, Data Architecture, Microsoft SQL Server, 微软数据转换服务(现为SSIS), Database Migration, Data Engineering, Data Extraction
Oracle Developer and Analyst
2006 - 2009
Ingram Micro
- 曾担任一家财富500强企业经销商的甲骨文顾问.
- Wrote and tested Oracle 10g RAC packages for external applications (usually Java) to access operational data store data; these included multiple entry points called directly by the Java front-end as well as back-end object and transactional layers.
- 担任DBA和应用程序开发团队之间集成测试的技术主管.
- 编写并测试触发器和存储过程，以从事务性IMS遗留系统的镜像表填充ODS表.
- 编写Perl脚本解析jdbc错误日志，作为数据质量计划的一部分.
Technologies: Perl, ETL, Database Development, Oracle PL/SQL, OLTP, Oracle 11g, Toad, Unix, Oracle SQL Developer, PL/SQL, Data Migration, Data Analysis, Scripting, C Shell, Oracle Designer, KSH, Oracle, SQL, Stored Procedure, Database Migration, Data Engineering, Data Extraction
Product Systems Analyst
2003 - 2005
Thomson Elite
- 在精英商业情报公司做系统分析员, 一个屡获殊荣的OEM联合品牌版本的整个业务对象套件，其中包含Elite商业智能数据仓库和预打包的业务对象文档.
- 领导使用Business Objects Data Integrator开发ETL流程.
- 编写并测试数据集成商工作流，以将源数据从Elite Enterprise生产数据库传输到业务智能数据仓库表.
- 将现有的精英企业报告移植到BusinessObjects Web Intelligence.
- 监督beta测试和质量控制，管理缺陷和问题.
- 协调产品的客户支持:培训一线和现场支持, 作为升级开发支持的主要联系人, 并为客户测试站点提供现场支持.
- Conducted, assisted, 监督多个客户安装，并从业务对象5迁移客户群.1.x to Enterprise 6.5.
- Worked on the initial development and new feature testing; coordinated and tracked comprehensive and regression testing between QA and development.
Technologies: Oracle, IBM Informix, Business Objectives, Data Warehouse Design, Data Warehousing, ETL, Database Development, Oracle PL/SQL, OLTP, Oracle 11g, Business Intelligence (BI), T-SQL (Transact-SQL), Web Intelligence, Unix, Microsoft Access, SQL Server 2014, SQL Server Analysis Services (SSAS), Apache Tomcat, SQL Loader, PL/SQL, Data Migration, Data Analysis, Data Modeling, Scripting, SAP BusinessObjects (BO), SAP BusinessObjects Data Service (BODS), OLAP, C Shell, Oracle Designer, KSH, Internet Information Services (IIS), SQL, Stored Procedure, Data Architecture, Microsoft SQL Server, Database Migration, Data Engineering, Web Applications, Data Extraction
Business Objects Reports Developer
2002 - 2003
Kaiser Permanente
- 担任医疗保健行业专业公共责任报告系统的Business Objects顾问.
- 使用业务对象构建和测试医疗保健损失预防报告.
- 在业务对象设计器中设计并创建了一个报告域.
- 在Oracle 8i和9i中编写辅助报表的SQL转换加载脚本.
Technologies: Business Objectives, Data Warehouse Design, Data Warehousing, ETL, Oracle PL/SQL, OLTP, Oracle 11g, Business Intelligence (BI), Web Intelligence, SQL Loader, PL/SQL, Data Migration, Data Analysis, Scripting, SAP BusinessObjects (BO), Oracle, SQL, Database Migration, Data Engineering, Data Extraction
Oracle Database Analyst | Perl Developer
2001 - 2002
Hiwire
- 作为流媒体广告报告数据仓库的数据库分析师.
- Scoped, designed, 并在Oracle 8i PL/SQL中测试了ETL算法, 然后为将这些算法移植到Java数据库连接的Java开发人员提供技术支持.
- 为开发和测试环境构建和管理多个测试Oracle实例.
- 使用Perl CGI脚本编写一个web报表用户界面，在Informix中查询报表.
- 在Informix中扩展和构建额外的控制和支持表.
Technologies: Perl, IBM Informix, Oracle, Data Warehouse Design, Data Warehousing, ETL, Database Development, Oracle PL/SQL, OLTP, Oracle 11g, Business Intelligence (BI), Unix, SQL Loader, PL/SQL, Data Migration, Data Analysis, Scripting, OLAP, CGI, SQL, Stored Procedure, Data Architecture, Database Migration, Data Engineering, Web Applications, Data Extraction
高级Oracle数据仓库分析师、开发人员和管理员
2000 - 2001
Enigma Digital | Clear Channel Interactive
- Acted as the lead Oracle PL/SQL developer, designer, 还是一家广播网站流量报告数据仓库的分析师.
- Worked on the full data warehouse life cycle: designed and built a physical data model using ERWin; scoped, designed, and tested daily ETL routines in Oracle 8i PL/SQL; managed ETL reports in Excel, and administered the final live process.
- 编写并测试用于发布的web界面的PL/SQL包和存储过程, manage, and administer integrated media websites; also developed back-end on the Oracle Application Server.
- Supported front-end interface by writing minor JavaScript functions and simple HTML; also conducted spot administrative tasks and user support.
- 编写和测试后端SQL过程，这是前端Java servlet调用数据访问所必需的.
Technologies: JavaScript, Perl, Erwin, Data Warehouse Design, Data Warehousing, ETL, Database Development, Oracle PL/SQL, OLTP, Oracle 11g, Business Intelligence (BI), Toad, Unix, Oracle SQL Developer, SQL Loader, PL/SQL, Data Migration, Data Analysis, Data Modeling, Scripting, OLAP, C Shell, Oracle Designer, KSH, Oracle, SQL, Stored Procedure, Data Architecture, Linux, Database Migration, Data Engineering, Web Applications, Data Extraction
Data Design Analyst
1998 - 2000
Sony Pictures Entertainment
- Worked as a data design consultant for an entertainment industry OLAP reporting data mart using Business Objects on top of Oracle; worked within the full data warehouse lifecycle.
- Built, designed, and tested executive-level OLAP reports using Business Objects; starting with requirements gathering and proceeding through to the final deployment.
- 在业务对象文档代理中创建批量OLAP报告过程.
- Designed a core data mart model and designed, created, and administered multiple OLAP reporting universes in Business Objects Designer; including custom reporting objects and universe synchronization.
- 在Oracle 7中定义、设计和创建OLAP报告数据集市.3、在PL/SQL中加载脚本、用户函数和数据完整性检查.
Technologies: Oracle, Business Objectives, Data Warehouse Design, Data Warehousing, ETL, Oracle PL/SQL, OLTP, Oracle 11g, Business Intelligence (BI), Web Intelligence, Unix, SQL Loader, PL/SQL, Data Migration, Data Analysis, Data Modeling, Scripting, SAP BusinessObjects (BO), OLAP, SQL, Data Architecture, Database Migration, Data Engineering, Data Extraction
CRM System Services Analyst
1996 - 1997
IBM
- 担任CRM和数据仓库分析师，并担任IBM首批专业服务团队之一的成员，支持多个数据库平台上的新数据仓库客户.
- 为运行DB2/PE 1的基于rs6000的系统构建并支持财务数据仓库.2.
- 用DB2 SQL编写数据填充脚本，用Perl编写补充数据转换脚本.
- 在业务对象前端开发OLAP报告.
- 培训IBM人员使用专有的cpm开发的解决方案包，其中包括数据分析, cleansing, transformation, data mining, and campaign management modules.
- 帮助设计银行业务的逻辑和物理数据模型, insurance, healthcare, and retail warehouses using ERWin 3.0. 银行原型显然是目前仍在使用的现有IBM BDW模型的核心.
Technologies: Perl, Erwin, IBM Db2, Teradata, Business Objectives, Data Warehouse Design, Data Warehousing, ETL, OLTP, Business Intelligence (BI), Unix, Data Migration, Data Analysis, Data Modeling, Scripting, OLAP, C Shell, KSH, SQL, Stored Procedure, Data Architecture, Database Migration, Data Engineering, Data Extraction
Research Analyst
1994 - 1996
CPM Corporation
- 某客户营销公司的分析研究——检验神经网络, genetic algorithms, 以及其他潜在的技术来实现公司的数据质量, data mining, and campaign management software.
- 在整个软件安装/数据库构建期间，在客户现场担任首席现场代表6个月.
- 从平面文件数据构建专有银行数据仓库, cleansed and transformed data, 为客户计分包提供分析支持.
- 为包括Oracle在内的多个SQL平台上的内部神经网络评分包准备变量，编写SQL数据库查询脚本, Teradata, Access, and DB2.
- 在Visual Basic中开发了盈利能力分析评分包的初步版本，其中底层SQL算法仍然是第一个生产级版本的核心.
Technologies: Microsoft Access, Visual Basic, C++, Perl, IBM Db2, Teradata, Oracle, ETL, Oracle PL/SQL, OLTP, Unix, SQL Loader, PL/SQL, Data Migration, Data Analysis, Data Modeling, Scripting, C Shell, KSH, Business Objectives, SQL, Linux, MySQL, Database Migration, Data Engineering, Data Extraction
Skills
Languages
TeX, T-SQL (Transact-SQL), SQL, Stored Procedure, Perl, C Shell, KSH, JavaScript, C++, Visual Basic, MDX
Tools
Toad, LaTeX, Microsoft Access, Oracle Designer, Erwin, Visual Studio, Microsoft Power BI, Power View, Apache Tomcat
Paradigms
ETL，数据库开发，商业智能(BI)， OLAP
Platforms
Oracle, Microsoft BI Stack, Unix, Linux, SharePoint
Storage
PL/SQL, SQL Server 2014, Oracle PL/SQL, OLTP, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Oracle 11g, Microsoft SQL Server, Database Migration, SQL Loader, Oracle SQL Developer, MariaDB, MySQL, IBM Informix, SQL Server Analysis Services (SSAS), IBM Db2, Teradata
Other
Data Warehouse Design, Data Warehousing, Data Modeling, Data Migration, Data Analysis, Data Engineering, Data Extraction, Scripting, Data Mining, Web Intelligence, SAP BusinessObjects (BO), SAP BusinessObjects Data Service (BODS), Data Architecture, 微软数据转换服务(现为SSIS), Web Applications, Business Objectives, CGI, MicroStrategy, Internet Information Services (IIS)
Education
1991 - 1993
Master of Arts in Applied Mathematics
加州大学，圣地亚哥-拉霍亚，加州，美国
1987 - 1991
Bachelor of Science in Mathematics
Harvey Mudd College - Claremont, CA, USA
Certifications
JUNE 2010 - PRESENT
MCTS 70-448: Microsoft SQL Server 2008，商业智能开发和维护
Microsoft