Scroll To View More
Roderick Lee

Roderick Lee

Westminster, CA, United States
Member since August 22, 2017
Rodrick is an information management expert who specializes in business intelligence and data development. He’s fully versed in all aspects of the data warehouse lifecycle: data design, ETL, reporting, installation, implementation, and administration. Rodrick is seeking a pivotal role to leverage his substantial experience and skills to add value, stability, and success to a growing organization.
Roderick is now available for hire
  • Database Development, 20 years
  • Perl, 20 years
  • ETL, 20 years
  • Business Intelligence (BI), 15 years
  • Data Warehouse, 15 years
  • Data Modeling, 12 years
  • SAP BusinessObjects (BO), 10 years
  • Microsoft BI Stack, 5 years
Westminster, CA, United States
Preferred Environment
For BI: Business Objects; General DB: Oracle
The most amazing... package I helped develop is a CMS for internet radio—both the front-end HTML generation and all transactions (all done with Oracle PL/SQL).
  • Business Intelligence Data Architect
    Wells Fargo Dealer Services
    2016 - 2017
    • Consulted on business intelligence for a direct auto loan division of a Fortune 500 bank; the scope covered ETL and reporting.
    • Wrote, designed, and optimized an SSIS package to transfer an Oracle direct auto loan application source data into a new SQL Server reporting data mart.
    • Wrote, tested, and optimized T-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 the purposes of adding new data elements that would eliminate the need for the raw SQL.
    Technologies: Microsoft BI (SSIS, SSRS), SQLServer 2014, SharePoint
  • ETL Developer
    CTG HealthCare Solutions
    2014 - 2016
    • Acted as an ETL 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 the production environments for all the team members' packages (not just mine).
    • Conducted a data analysis of incoming flat file source data for data mapping, defect management, or unit testing.
    • Coordinated the user requirements with a business analyst.
    Technologies: SSIS, SQL Server 2012
  • Senior Technical Analyst
    Linea Solutions
    2010 - 2014
    • Worked as a data analyst and developer for a financial and business services IT consultant group which 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 file or transferring error result sets from the vendor database back to the conversion database 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: SQLServer 2008 R2, DTS/SSIS, Oracle 11g, SQL*Load
  • Oracle Developer and Analyst
    Ingram Micro
    2006 - 2009
    • 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: Oracle 10g RAC, PL/SQL, Perl
  • Product Systems Analyst
    Thomson Elite
    2003 - 2005
    • Worked as a systems analyst for Elite Business Intelligence, an award-winning OEM co-branded version of the entire Business Objects Enterprise suite packaged with the Elite Business Intelligence Data Warehouse and prepackaged business objects documents; I worked in the full lifecycle development, QA, and support.
    • Led the development for the ETL process using Business Objects Data Integrator.
    • Wrote and tested the data integrator workflows to transfer source data from Elite Enterprise production database into business intelligence data warehouse tables.
    • Ported existing Elite Enterprise reports to BusinessObjects Web Intelligence.
    • Oversaw beta testing and quality control.
    • Coordinated the customer support of the product: trained the front-line and field support, acted as the primary contact for escalated development support, and provided onsite support for customer beta sites.
    • Conducted, assisted, and supervised multiple customer installations and migrated customer base from Business Objects 5.1.x to Enterprise 6.5.
    • Managed defects and issues.
    • Worked on the initial development and new feature testing; coordinated and tracked comprehensive and regression testing between QA and development.
    Technologies: Business Objects 6.5, Informix, SQLServer 2000, Oracle 8i
  • Business Objects Reports Developer
    Kaiser Permanente
    2002 - 2003
    • Acted as a Business Objects consultant for a healthcare industry professional public liability reporting system.
    • Built and tested healthcare loss prevention reports using Business Objects.
    • Designed and created a reporting universe in Business Objects Designer.
    • Wrote SQL transformation load scripts for auxiliary reporting tables in Oracle 8i and 9i.
    Technologies: Business Objects 5.1, Oracle 8i and 9i, PL/SQL
  • Oracle Database Administrator | Perl Developer
    2001 - 2002
    • Acted as a consultant DBA 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 JDBC.
    • 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.
    • Scoped and built additional control and support tables in Informix.
    Technologies: Oracle 8i, PL/SQL, Informix, Perl CGI
  • Senior Oracle Data Warehouse Analyst, Developer, and Administrator
    Enigma Digital | Clear Channel Interactive
    2000 - 2001
    • Acted as the lead Oracle PL/SQL developer, designer, and analyst for a radio website's traffic-reporting data warehouse.
    • 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.
    • Wrote and tested PL/SQL packages and stored procedures for a web interface used to publish, 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.
    • Wrote and tested back-end SQL procedures which were necessary for front-end Java servlets to call for data access.
    Technologies: Oracle 8i, PL/SQL, ERWin, Perl, JavaScript
  • Data Design Analyst
    Sony Pictures Entertainment
    1998 - 2000
    • Worked as a data design consultant for an entertainment industry OLAP reporting data mart; 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: Business Objects 4.1, Oracle 7.3
  • CRM System Services Analyst
    1996 - 1997
    • 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 Business Objects.
    • Trained IBM personnel in 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 current existing IBM BDW model, still in use.
    Technologies: Business Objects 4.0, Oracle 7, Teradata, IBM DB2/PE 1.2, ERWin, Perl
  • Research Analyst
    CPM Corporation
    1994 - 1996
    • 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: Oracle 6, NCR Teradata, DB2 1.0, Perl, C++, Visual Basic, Access
  • Languages
    T-SQL, TeX, Perl, KSH, C Shell, MDX
  • Tools
    Toad, ERwin, Oracle Designer, Microsoft Access, Power View, Apache Tomcat
  • Paradigms
    Database Development, ETL, OLAP
  • Platforms
    Microsoft BI Stack, Unix, SharePoint
  • Storage
    OLTP, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Oracle 11g, Oracle PL/SQL, MariaDB, IBM Informix, Oracle SQL Developer, SQL Server 2014, MySQL, SQL Server Analysis Services (SSAS), Teradata, IBM - DB2
  • Misc
    Business Intelligence (BI), Data Modeling, Data Warehouse, Data Migration, Data Analysis, Data Mining, Scripting, Web Intelligence, SAP Business Objects Data Service (BODS), SAP BusinessObjects (BO), Internet Information Services (IIS), MicroStrategy
  • Master of Arts in Applied Mathematics
    University of California, San Diego - La Jolla, CA, USA
    1991 - 1993
  • Bachelor of Science in Mathematics
    Harvey Mudd College - Claremont, CA, USA
    1987 - 1991
I really like this profile
Share it with others