Roderick Lee Email & Phone Number

Westminster, Ca, Us

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, and tested project status, revenue, and market analysis reports and graphical presentations in SSRS and Power BI. Documentation of all work• 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 select tables in the main transactional system, sourcing from flatfile, Excel, file system, or native SQL. Documentation of all work.• 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. Documentation of all work.

• 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 application source data to a new SQLServer reporting data mart. Designed and built administrative dashboard reports using SSRS, SharePoint Server, and Power View. Documentation of all work.

• 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 source data for data mapping, defect management, or unit testing. Coordinated user requirements with business analyst. Documentation of all work

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 SQLServer (T-SQL) or Oracle (PL/SQL) to transform legacy pension data to the new vendor data model, both for conversion and data clean-up. Documentation of all work• 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 for source/target data comparisons; similarly for Oracle systems but using SQL*Loader. Managed MS Access databases for QA test results or source data mapping. Documentation of all work

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 access ODS data; technical lead for integration testing between 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. Documentation of all work.

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 arose between external partner data sources and the primary database. Wrote PL/SQL package for name and address parsing and record consolidation. Documentation of all work.

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 standard set of Business Objects documents. Coordinated customer support and trained front-line and field support; acted as primary contact for escalated development support and on-site support for customer beta sites. Conducted, assisted or supervised multiple customer installations; migrated customer base from Business Objects 5.1.x to Enterprise 6.5• 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 transfer source data from Elite Enterprise production database into BIDW tables. Full DWLC. Oversaw beta testing and quality control. Documentation of all work• 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; designed and created reporting universe in Business Objects Designer. Wrote SQL transformation load scripts for auxiliary reporting tables. Documentation of all work.

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 support for Java developers who ported these algorithms to JDBC. Built and administered multiple test Oracle instances for development and testing environments. Documentation of all work• 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 tested daily ETL routines in PL/SQL; also administered the live ETL process. Managed ETL reports in Excel. Documentation of all work• 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 publish, manage, and administer integrated media Websites; also included writing minor Javascript functions, simple HTML editing, and spot administrative tasks and user support. Documentation of all work• 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 and performance and modified initial versions to final user specifications. Verified reporting data integrity by comparing results to original mainframe functionality. Full DWLC. Created batch OLAP reporting procedures in Business Objects Document Agent. Documentation of all work• 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 managed universe synchronization• 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 scripts, including stored procedures and user functions in PL/SQL; performance tuning of scripts. Wrote data integrity check scripts

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 in source system Progress 4GL. Documentation of all work

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. Wrote data population scripts in DB2 SQL and supplementary data transformation scripts in Perl. Developed OLAP reports in Business Objects. Documentation of all work• 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 Oracle, Teradata, Access, and DB2. Documentation of all work.• 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 analyst support for customer scoring package• 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