Roderick Lee Email & Phone Number

Westminster, CA, US

• Freelance Business Intelligence and Database Development Consultant, currently as a Database Reporting Analyst for internal project status and revenue analysis at Systems Source (see below)
• Microsoft Certified Technology Specialist SQLServer 2008 Business Intelligence Development and Maintenance
• Even greater experience in the SAP Business Objects suite (10+ years) and the Oracle platform (20+ years)

Newport Beach, California, US

• Reporting Consultant for industry leading contract office furniture and interiors company. Developed, tested, and administered internal reports in SSRS running on a SQLServer transactional database. Designed, built.
• Wrote and tested T-SQL stored procedures for populating these reports. Co-designed new inventory and product catalog data models; wrote ad hoc SSIS tasks and SQL queries to populate these databases in addition to.
• Wrote and tested code fixes, feature enhancements, and cosmetic changes for front-end perl CGI interface running on top of same transactional system, in an auxiliary role to reduce workload on our primary developer..

• Business Intelligence Consultant for direct auto loan division of a Fortune 500 bank. Wrote, designed, and optimized ETL process combining SSIS packages and T-SQL procedures to transfer Oracle direct auto loan.

• ETL Consultant for healthcare IT services solutions provider. Wrote and tested SSIS packages to load new healthcare customer, claims, and laboratory data into the existing data warehouse. Analyzed incoming flatfile.

Marina Del Rey, California, US

• Data Analyst and Developer for financial and business services IT consultant group specializing in public employee retirement systems. Wrote and tested data migration and data reconciliation stored procedures in.
• Wrote DTS packages for importing source legacy and other third-party non-RDBMS data, exporting transformed data to flatfile, or transferring error result sets from the vendor database back to the conversion database.

Irvine, CA, US

• Oracle Consultant for Fortune 500 corporate reseller running an operational data store on an Oracle 10g RAC cluster. Wrote and tested Oracle PL/SQL packages that serve as the entry-point for external applications to.

Los Angeles, California, US

• Oracle Consultant for newspaper circulation system running on top of Oracle 9i. Wrote and tested control and scheduling scripts in Oracle PL/SQL, Unix (csh and ksh), and perl. Analyzed data synchronization errors that.

New York, NY, US

• 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 (BIDW) and a.
• Lead developer for multi-platform (SQLServer, Informix, and Oracle) ETL process using Business Objects Data Integrator. Built physical data model for BIDW in SQLServer and Oracle. Wrote and tested DI workflows to.
• Tracked defect and issues from Initial build and feature enhancements; coordinated comprehensive and regression testing between QA and development

Oakland, California, US

• Business Objects Consultant for healthcare industry professional public liability reporting system running on top of Oracle 8i and 9i. Built and tested healthcare loss prevention reports using Business Objects.

Menlo Park, CA, US

• Consultant Database Analyst for streaming advertising reporting data warehouse running Oracle 8i and Informix. Scoped, designed, and tested ETL algorithms which were prototyped in PL/SQL; provided expert technical.
• Wrote Web reporting user interface using Perl CGI scripts querying reporting tables in Informix; scoped and built additional control and support tables in Informix

• Lead Oracle PL/SQL Developer, Designer, and Analyst for radio Website traffic reporting data warehouse running Oracle 8i. Designed and built physical data model for the data warehouse using ERWin. Scoped, designed, and.
• Oracle PL/SQL Developer for Web publishing tools package using Oracle 8i and running on Oracle Application Server. From inception, wrote and tested PL/SQL stored procedures and packages for a Web interface used to.
• Wrote and tested back-end SQL procedures that were crucial for data access functionality tasks required by the front-end Java servlets

Culver City, CA, US

• Data Design Consultant for entertainment industry OLAP reporting data mart based in Oracle 7.3. Built, designed, and tested executive level OLAP reports using Business Objects; met with users over report requirements.
• Designed, created, and administered multiple OLAP reporting universes in Business Objects Designer based on different reporting business functions; defined class relationships, created custom reporting objects, and.
• Scoped, designed, and loaded OLAP reporting data mart in Oracle 7.3, source and target data both in Oracle; met with users to develop initial data requirements. Designed core data model for the data mart. Wrote load.

Fort Mill, SC, US

• Project Leader for in-house Finance Data Warehouse project. Designed and built financial and accounting tables to add to existing Oracle warehouse with reporting capabilities in Business Objects. Wrote extract scripts.

Armonk, New York, NY, US

• Technologist for fledgling Professional Services group (which would go on worldwide to account for 40% of all IBM revenue) building and supporting financial data warehouses for RS6000 based systems running DB2/PE 1.2..
• Trained IBM personnel in proprietary CPM-developed solution package that includes data analysis, cleansing, transformation, householding, data mining, and campaign management modules
• Helped design logical and physical data models for banking, insurance, and retail warehouses, using ERWin 3.0

• Analyst for pioneering CRM firm (before industry coined "CRM") writing SQL database query scripts for the purpose of prepping variables for an in-house neural network scoring package on multiple SQL platforms including.
• Served as chief on-site representative for six months at customer site during full software install/database build. Built proprietary banking data warehouse from flatfile data, cleansed and transformed data, provided.
• Wrote 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

Bs, Mathematics

Ma, Applied Mathematics

Microsoft Business Intelligence Master'S Program