Rod S. Lewis Email & Phone Number

Charlotte, Nc, Us

Originally hired as a Senior Spotfire Consultant and Lead Administrator in Production Support, promoted to current role within eight months retaining original responsibilities. ♦ Play key role in the review, assessment, and go-forward adoption and standardization of BI solutions; helped transform BI into a managed service offering consumption across corporate treasury & investments business units♦ Lead Administrator of Spotfire and MicroStrategy applications; manage a team of offshore MicroStrategy administrative resources and directed efforts of onshore administrative associates and consultants♦ Provide user support: issue tracking, troubleshooting, escalation and workarounds; SDLC management; user training♦ Assure regulatory compliance, including incident/change management, application availability and access control♦ BI report development (Spotfire, MicroStrategy, Tableau), including parametrized custom SQL, data integration, custom formulas/functions, filtering, drilldown visualization, automated data refresh, and delivery♦ Develop, maintain, and communicate project schedules and milestones to user community and upper management♦ Create and administer customized websites, including webpage content with customized CSS, service request/incident management systems, access control, and bank compliance♦ ETL/Database Design – Developed numerous ETL (SSIS) and database tables (MS SQL Server) used to track BI application activity for management and regulatory team oversight KEY ACCOMPLISHMENTS:♦ Spearheaded effort to migrate reporting functionality and fully decommission Spotfire application♦ Oversaw a couple of months-long BI platform upgrade projects. Conducted extensive testing while managing end-user communication/testing/buy-in/sign-off and remediating discovered issues; engaged external technology teams for service setup (network, SA, middleware, dba, server monitoring, etc.)

Santa Clara, Ca, Us

♦ Solely responsible for all data systems supporting analysis, QC/QA, and reporting customer experimental results, with an average weekly inflow of thousands of compounds from multiple customers♦ Maintained average turnaround time of less than a week; improved value through customized data analysis and reporting; and contributed to data delivery in less time than industry average♦ Developed various data-input/statistical-analysis and report-generating templates (MS Excel/VBA/XLfit, Spotfire), databases (MS SQL Server), and custom-coded ETL and data integration processes (VB.net); initiatives enabled data transfer between multiple systems and facilitated flexible data processing flow to meet customer analysis and reporting needs in a timely manner♦ Provided frontline support for all IT infrastructure, including maintaining/troubleshooting servers (web hosts, email, database), network (switches, routers, cabling), phone system, data center (UPS/generator, cooling, tape backups), and software contract maintenance; coordinated and supervised escalation of issues with outsourced IT and DBA support providers♦ Communicated with external customers (scientists and IT staff) to gather requirements for tailored data analysis, data reporting, and data transfer solutions♦ Administered company-wide LIMS (ActivityBase) and compound library database (ISIS)♦ Developed several semi-automated (one-click) processes (MS Excel/VBA/ADO) that enabled scientific staff to monitor/statistically analyze the quality of ongoing experiments; processes enabled scientists to quickly repeat and adjust experimental parameters and improved company response to tight deadlines♦ Developed and continuously refined project cost model and calculator to estimate FTE expenditure and experiment consumable expenses based on the type and size of the proposed lab procedure; calculator became indispensable for company's rapid production of accurate cost quotes for customers’ proposed business

Us

Originally hired in 2002 as Senior Analyst and Amphora’s primary LIMS developer and administrator. Promoted to senior role in Jan 2005 with additional responsibility for development of automated processes of scientific instrument data capture and analysis, as well as development of semi-automated data report generation.♦ Administered company-wide LIMS (ActivityBase), resolved user-reported errors, and performed all end-user training♦ Successfully implemented four ActivityBase and Oracle version upgrades, including organizing application upgrade activities with system administrators, all upgrade QC/QA activities, and end user training ♦ Worked with scientific staff to develop tools used to read data from scientific instrumentation; analyzed statistics and compiled results for use in company-wide database; ensured group adherence to QC standards♦ Created 100+ ActivityBase/MS Excel/XLFIT templates for non-linear regression calculations to enable precise quantification, statistical analysis, and display of experimental data for corporate scientific groups♦ Designed, developed, and maintained applications to query information to automatically produce data reports of various formats (heat-maps, dose-response curve presentation, etc.) (MS Excel/VBA, Spotfire)♦ Administered compound structure databases (ActivityBase) with average weekly inflow of 900 compounds; maintained compound structure, compound library, and vendor information; and designed and maintained compound ID alias system♦ Designed, developed, and maintained custom applications (VB6, VB.net, ActivityBase SDK) that monitored numerous robotic pipetting stations, to automatically register 1,100 production compound plates per week within 15 minutes of creation and significantly increase automation ♦ Created a database, custom ETL processes (VB/ADO.net), and web-based user interface (MS IIS/ADO.net) used to automatically track inventory levels and freezer locations of stored plates and compounds

Switzerland 🇨🇭 , Ch

Promoted from Research Associate to Programmer/Analyst in Oct 1999 because of significant scientific and computer programming experience and connections to the Roche scientific community. In that role, worked on a team tasked with a large project that transferred numerous disparate, locally run data systems into a centralized/uniform data system—consisting of ActivityBase for results calculation and data QC/QA and an in-house developed site-wide data repository and result display system. Upon promotion to Systems Analyst/Programmer in Jan 2002, role expanded to include development of computer programming and data analysis templates.♦ Acted as primary liaison for technology team to scientific community to ensure accurate transfer of laboratory data collection and analysis from locally run systems (within each laboratory) to centralized LIMS (ActivityBase); updated management on adoption progress; provided end-user training♦ Sat on a global board tasked with ensuring that each of Roche’s campuses throughout the world complied to uniform definitions of result type definitions (Data Dictionary) and standard rules of data quality♦ Created numerous ActivityBase/MS Excel/XLFIT (for non-linear regression calculations) templates which enabled precise quantification, statistical analysis and display of experimental data♦ Responsible for overseeing the flow of information between chemical inventory systems and biological data systems by developing Oracle PL/SQL Packages and Procedures♦ Developed proprietary Visual Basic/SQL utilities used to pre-process raw data, generate summarized reports and maintain a large database to ensure high quality and integrity of biological data♦ Supervised contract employees and managed the training of new employees

Switzerland 🇨🇭 , Ch

As a Research Associate III (01/97-09/99):♦ Programmed in MS VBA/Excel and SAS languages and provided end-user feedback of Oracle Forms for clients to assist in design, development, build, and implementation of proprietary statistical applications; applications enabled analysis, mining, and management of large biological database ♦ Programmed in Sunplus and employed the Hamilton Robotic Microlab AT Pipette Station to significantly increase productivity and throughput with concomitant reduction in assay cost ♦ Trained and supervised interns and temporary employees♦ Developed, validated, and presented various animal models of human disease states (schizophrenia, tactile allodynia) As a Research Associate II (07/94 to 12/96):♦ Utilized SAS programming and modified existing DOS-based SAS programs to statistically analyze biological data ♦ Developed and validated several in vivo behavioral models of chronic pain, cognition, and ethanol drinking As a Research Associate I (01/93 to 06/94): ♦ Employed Microsoft Excel Macro language to write tools to manipulate, filter, and transform large data sets ♦ Developed expertise in various behavioral pharmacology models

Seattle, Wa, Us

Applied operant conditioning techniques and developed BASIC programs to behaviorally shape laboratory rats.