Roderick is currently unavailable
Roderick Lee
Verified Expert in Engineering
Database Developer
Westminster, CA, United States
Toptal member since October 31, 2017
Bio
Roderick is an information management expert specializing in business intelligence and data development. He is fully versed in all aspects of the data warehouse lifecycle, including data design, ETL, reporting, installation, implementation, and administration. Roderick seeks a pivotal role to leverage his substantial experience and skills and add value, stability, and success to a growing organization.
Portfolio
Systems Source
Business Intelligence (BI), SQL Server Reporting Services (SSRS), Perl...
Wells Fargo
SharePoint, SQL Server Reporting Services (SSRS), Data Warehousing, ETL...
CTG HealthCare Solutions
Data Warehousing, ETL, Business Intelligence (BI), Transact-SQL (T-SQL)...
Experience
- Data Warehousing - 20 years
- Business Intelligence (BI) - 20 years
- ETL - 20 years
- Data Warehouse Design - 20 years
- Perl - 20 years
- Database Development - 20 years
- Data Modeling - 12 years
- Microsoft BI Stack - 10 years
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...
...software package I helped develop is a CMS for internet radio—handling the front-end HTML generation and all transactions—using Oracle PL/SQL.
Work Experience
Database Reporting Analyst
2018 - PRESENT
Systems Source
- Consulted on database reporting (SSRS and Power BI) for an industry-leading contract office furniture and interior company.
- Developed, tested, and administered 250+ project status, revenue, and market analysis reports and dashboard visualizations in SSRS and Power BI, significantly improving user efficiency.
- Wrote and tested around 100 T-SQL stored procedures, functions, and views for populating these reports.
- Co-designed new inventory and product catalog data models, unlocking additional value for future reports. Created ad hoc SSIS tasks and SQL queries to populate these databases, sourcing from Flatfile, Excel, file system, or native SQL.
- Wrote and tested code fixes, feature enhancements, and cosmetic changes for a front-end Perl CGI interface running on top of the same transactional system in an auxiliary role—to reduce the workload on our primary developer.
- Served as a liaison between the marketing team and IT/DBA.
Technologies: Business Intelligence (BI), SQL Server Reporting Services (SSRS), Perl, SQL Server Integration Services (SSIS), ETL, Database Development, OLTP, Transact-SQL (T-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, CSV File Processing, Data Transformation, Data Visualization, Query Optimization, Entity-relationship Diagrams, Entity-relationships Model (ERM), Microsoft Excel, JSON
Business Intelligence Data Architect
2016 - 2017
Wells Fargo
- Consulted on business intelligence for a direct auto loan division of a Fortune 500 bank. The scope covered ETL and reporting in the Microsoft Business Intelligence suite.
- Wrote, designed, and optimized ETL processes combining SSIS packages and T-SQL procedures to transfer Oracle direct auto loan application source data to a new SQL Server reporting data mart.
- Tested and optimized Transact-SQL procedures, called by SSIS, to transform source-replicated data to the corresponding target data warehouse formats.
- Designed and built administrative dashboard reports using SSRS, SharePoint Server, and Power View.
- Analyzed raw SQL queries from MicroStrategy reports for adding new data elements that would eliminate the need for raw SQL.
Technologies: SharePoint, SQL Server Reporting Services (SSRS), Data Warehousing, ETL, Database Development, OLTP, Business Intelligence (BI), Transact-SQL (T-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, CSV File Processing, Data Transformation, Data Visualization, Query Optimization, Microsoft Excel
ETL Developer
2014 - 2016
CTG HealthCare Solutions
- Acted as an ETL (SSIS) consultant for a healthcare IT services solutions provider as a member of a team of ETL developers.
- Wrote and tested SSIS packages to load new healthcare customer, claims, and laboratory data into the existing data warehouse.
- Administered multiple SSIS configuration settings for the separate development, QA, and production environments for all the team members' packages (not just mine).
- Analyzed incoming flat file source data for data mapping, defect management, or unit testing.
- Coordinated the user requirements with a business analyst.
Technologies: Data Warehousing, ETL, Business Intelligence (BI), Transact-SQL (T-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, CSV File Processing, Data Transformation, Data Pipelines, Query Optimization, Microsoft Excel
Senior Technical Analyst
2010 - 2014
Linea Solutions
- Worked as a data analyst and developer for a financial and business services IT consultant group that specialized in public employee retirement systems.
- Wrote and tested the data migration and data reconciliation stored procedures in SQL Server (T-SQL) or Oracle (PL/SQL) to transform the legacy pension data to the new vendor data model, both for conversion and data cleanup.
- Wrote SSIS and DTS packages for an assortment of tasks: importing source legacy and other third-party non-RDBMS data, exporting transformed data to flat files, or transferring error result sets for source/target data validation.
- Wrote, in Oracle systems, SQL*Loader command scripts for similar load operations outlined in the previous item (output routines were in PL/SQL).
- Created and managed the MS Access databases for QA and data-mapping.
Technologies: SQL Loader, SQL Server Integration Services (SSIS), ETL, Database Development, Oracle PL/SQL, OLTP, Transact-SQL (T-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, Microsoft Data Transformation Services (now SSIS), Database Migration, Data Engineering, Data Extraction, CSV File Processing, Data Transformation, Query Optimization, Entity-relationship Diagrams, Entity-relationships Model (ERM), Microsoft Excel
Oracle Developer and Analyst
2006 - 2009
Ingram Micro
- Acted as an Oracle consultant for a Fortune 500 corporate reseller.
- 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.
- Worked as the technical lead for integration testing between the DBA and application development teams.
- Wrote and tested triggers and stored procedures to populate ODS tables from mirror tables of the transactional IMS legacy system.
- Wrote Perl script to parse JDB error logs as part of a data-quality initiative.
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, CSV File Processing, Data Transformation, Query Optimization, Entity-relationship Diagrams, Entity-relationships Model (ERM), Microsoft Excel, JSON
Product Systems Analyst
2003 - 2005
Thomson Elite
- Worked as a systems analyst for a technology company behind Elite Enterprise, the leading HR and practice software for legal practices around the world, serving as BusinessObjects SME.
- Led the development of Elite Business Intelligence, an award-winning OEM co-branded version of the entire BusinessObjects enterprise suite (with pre-built reports) and a new data warehouse (Elite BIDW), creating an entirely new revenue stream.
- Led the development of a multi-platform (Informix, SQLServer, and Oracle) ETL process using BusinessObjects Data Integrator (now Data Services). Wrote and tested the BODI workflows to load Elite Enterprise flagship source data into BIDW utilizing CDC.
- Ported existing Elite Enterprise reports to BusinessObjects Web Intelligence and added these new documents to the Elite BI product offering.
- Built a physical data model for Elite BIDW in Universe Designer, both in SQL Server and Oracle.
- Oversaw beta testing and quality control for initial development and new feature testing. Tracked comprehensive and regression testing between QA and development environments.
- Coordinated customer support for Elite Business Intelligence. Trained front-line and field support, was the primary contact for escalated development support, and provided onsite support for customer beta sites.
- Conducted, assisted, and supervised multiple customer installations and migrated the customer base from BusinessObjects 5.1.x to Enterprise 6.5.
Technologies: Oracle, IBM Informix, Business Objectives, Data Warehouse Design, Data Warehousing, ETL, Database Development, Oracle PL/SQL, OLTP, Oracle 11g, Business Intelligence (BI), Transact-SQL (T-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, CSV File Processing, Data Transformation, Data Visualization, Data Pipelines, Query Optimization, Entity-relationship Diagrams, Entity-relationships Model (ERM), Microsoft Excel
BusinessObjects Reports Developer
2002 - 2003
Kaiser Permanente
- Worked as a BusinessObjects consultant for a healthcare industry professional public liability reporting system.
- Built and tested healthcare loss prevention reports using BusinessObjects 5.0. Worked as a BusinessObjects consultant for a healthcare industry professional public liability reporting system.
- Designed and created a universe for a new reporting data mart in BusinessObjects Designer.
- Wrote SQL transformation load scripts for auxiliary reporting tables in Oracle 8i and 9i.
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, CSV File Processing, Data Transformation, Query Optimization, Entity-relationship Diagrams, Entity-relationships Model (ERM), Microsoft Excel
Oracle Database Analyst | Perl Developer
2001 - 2002
Hiwire
- Consulted as a database analyst for streaming advertising reporting data warehouse.
- Scoped, designed, and tested ETL algorithms in Oracle 8i PL/SQL, then served as technical support for Java developers who ported these algorithms to the Java Database Connectivity.
- Built and administered multiple test Oracle instances for development and testing environments.
- Wrote a web reporting user interface using Perl CGI scripts, querying reporting tables in Informix.
- Scaled and built additional control and support tables in 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, CSV File Processing, Data Transformation, Data Pipelines, Query Optimization
Senior Oracle Data Warehouse Analyst, Developer, Administrator
2000 - 2001
Enigma Digital | Clear Channel Interactive
- Worked as the lead Oracle PL/SQL developer, designer, and analyst for an internet radio website traffic-reporting data warehouse.
- Built a new clickstream data warehouse from scratch across an entire data warehouse lifecycle (DWLC). Designed and built a physical data model using Er Win and scoped, designed, and tested daily ETL routines in Oracle 8i PL/SQL.
- Administered live data warehouse and associated ETL.
- Wrote and tested PL/SQL packages and stored procedures for a web interface used to publish, manage, and administer around 300 integrated media websites. Developed the back end on the Oracle Application Server.
- Wrote and tested back-end SQL procedures that were crucial for data access functionality tasks required by the front-end Java servlets.
- Supported the front-end interface by writing minor JavaScript functions and simple HTML. Conducted spot administrative tasks and user support.
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, CSV File Processing, Data Transformation, Query Optimization, Entity-relationship Diagrams, Entity-relationships Model (ERM)
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.
- Created batch OLAP reporting procedures in Business Objects Document Agent.
- 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.
- Scoped, designed, and created OLAP reporting data mart in Oracle 7.3, with load scripts, user functions, and data integrity checks in 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, CSV File Processing, Data Transformation, Query Optimization, Entity-relationship Diagrams, Entity-relationships Model (ERM), Microsoft Excel
CRM System Services Analyst
1996 - 1997
IBM
- Acted as a CRM and data warehouse analyst and as a member of one of IBM's first Professional Services teams—supporting new data warehouse customers on multiple database platforms.
- Built and supported financial data warehouses for RS6000-based systems running DB2/PE 1.2.
- Wrote data population scripts in DB2 SQL and supplementary data transformation scripts in Perl.
- Developed OLAP reports in the Business Objects front end.
- Trained IBM personnel in a proprietary CPM-developed solution package that includes data analysis, cleansing, transformation, data mining, and campaign management modules.
- Helped design logical and physical data models for banking, insurance, healthcare, and retail warehouses using ERWin 3.0. The banking prototype is apparently the core of the existing IBM BDW model, which is still in use.
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, CSV File Processing, Data Transformation, Query Optimization, Entity-relationship Diagrams, Entity-relationships Model (ERM)
Research Analyst
1994 - 1996
CPM Corporation
- Analyzed research for a customer marketing firm—examining neural networks, genetic algorithms, and other potential technologies to implement in the company's data quality, data mining, and campaign management software.
- Acted as the chief onsite representative for six months at the customer site during full software install/database build.
- Built proprietary banking data warehouse from flat file data, cleansed and transformed data, provided analyst support for customer scoring package.
- Wrote SQL database query scripts for the purpose of prepping variables for an in-house neural network scoring package on multiple SQL platforms including Oracle, Teradata, Access, and DB2.
- Developed the preliminary version of a profitability analysis scoring package in Visual Basic of which the underlying SQL algorithm remained at the core of the first production-grade version.
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, CSV File Processing, Data Transformation, Query Optimization
Education
1991 - 1993
Master of Arts in Applied Mathematics
University of California, San Diego - La Jolla, CA, USA
1987 - 1991
Bachelor of Science in Mathematics
Harvey Mudd College - Claremont, CA, USA
Certifications
FEBRUARY 2010 - PRESENT
Microsoft Cert Tech Specialist MS SQL Server 2008, Business Intelligence Development and Maintenance
Microsoft
Skills
Tools
Toad, LaTeX, Microsoft Excel, Microsoft Access, Oracle Designer, Erwin, Visual Studio, Microsoft Power BI, Power View, Apache Tomcat
Languages
TeX, Transact-SQL (T-SQL), SQL, Stored Procedure, Perl, C Shell, KSH, JavaScript, C++, Visual Basic, MDX
Paradigms
ETL, Database Development, Business Intelligence (BI), Entity-relationship Diagrams, 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, Data Pipelines, JSON
Other
Data Warehouse Design, Data Warehousing, Data Modeling, Data Migration, Data Analysis, Data Engineering, Data Extraction, CSV File Processing, Data Transformation, Entity-relationships Model (ERM), Scripting, Data Mining, Web Intelligence, SAP BusinessObjects (BO), SAP BusinessObjects Data Service (BODS), Data Architecture, Microsoft Data Transformation Services (now SSIS), Web Applications, Query Optimization, Business Objectives, CGI, MicroStrategy, Internet Information Services (IIS), Data Visualization
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring