David Luster Email & Phone Number

Minneapolis, Minnesota, United States

State of Minnesota system upgrade for IBM DataStage Create and execute detailed Project plans and Task schedulesLead, facilitate, and document user sessions to determine business and technical requirementsPrepare Fit - Gap report to identify any potential Risks Calculate cost estimation and tracking of hours to planDaily scrum meeting, timeline monitoring and resolution of project issuesProvide daily, weekly and monthly Sponsor project status reports throughout the life… Show more State of Minnesota system upgrade for IBM DataStage Create and execute detailed Project plans and Task schedulesLead, facilitate, and document user sessions to determine business and technical requirementsPrepare Fit - Gap report to identify any potential Risks Calculate cost estimation and tracking of hours to planDaily scrum meeting, timeline monitoring and resolution of project issuesProvide daily, weekly and monthly Sponsor project status reports throughout the life of the project Show less

Los Angeles, Ca

Development and administration of MicroStrategy and Tableau infrastructureDevelops advanced data Visualizations on MicroStrategy and Tableau for enterprise reportingDefine and manage MicroStrategy metadata and Tableau Data Sources, Dimensions and MeasuresUpgrade of MicroStrategy reporting systems from v.11.3 to v.11.6

Los Angeles, California, United States

Exelixis Inc. CA Develops Visualizations on Tableau for tracking Study activities of Clinical Trials for New Drug CandidatesProcesses Clinical Research Organization(s) data files and File management on the AWS platform Develops Tableau objects (Attributes, Measures & Custom SQL) and maintains B.I. architecture Administration of Tableau Web Server, end user access and security integration with LDAPProject Manager: RJR Reynolds Winston-Salem, NC AGILE project… Show more Exelixis Inc. CA Develops Visualizations on Tableau for tracking Study activities of Clinical Trials for New Drug CandidatesProcesses Clinical Research Organization(s) data files and File management on the AWS platform Develops Tableau objects (Attributes, Measures & Custom SQL) and maintains B.I. architecture Administration of Tableau Web Server, end user access and security integration with LDAPProject Manager: RJR Reynolds Winston-Salem, NC AGILE project management of B.I. operations involving multiple software platformsDevelops advanced data Visualizations on Tableau 2020 and MicroStrategy 19.x Creates data sources on Teradata, Oracle, DB2, MS SQL platforms with complex transformation logicProject Manager: Warner Bros. Burbank, CA Development and administration of MicroStrategy infrastructure on AWS ver.11.XXDevelops advanced data Visualizations on Tableau and MicroStrategy for enterprise reportingMigration of reporting systems from multiple B.I. toolsDefine Tableau Data Sources, Dimensions and Measure granularity levels for advanced VisualizationsAdminister Tableau and MicroStrategy User access rights, security for Data Sources and user access to Report Show less

Burbank, Ca

Develop and maintain infrastructure for Informatica versions 9.6 & 10.2Participate in Informatica 10.X upgrade and Datacenter migrationsDevelop Enterprise level Visual Analytics on Tableau 10.X

Los Angeles, Ca

Project Management of B.I. Developer resourcesInteract with I.T. Senior Management to plan long term B.I. initiativesDevelop and maintain infrastructure for MicroStrategy version 10.11Planning and provisioning extractions from new data sources

Woodland Hills

Develops Tableau Dashboards for enterprise reportingPerforms administration, user provisioning and job scheduling for Tableau ServerWorks with end users to evaluate needs and define reporting requirements Gathers requirements from business users and prepares associated documents; such as Business Requirements Document (BRD), Technical Design Document (TDD) and QA Test CasesEstimates Rough Order of Magnitude for the level of effort/cost of new application functionality

Westlake Village, Ca

MicroStrategy Consultant – Jul. 2016 to Oct. 2016 Develop and maintain infrastructure for MicroStrategy versions 9.4.1 Participate in MicroStrategy 10.X upgrade and Datacenter migration Develop Enterprise level Visual Analytics on MicroStrategy 10.X

Beverly Hills

Project Management of Informatica and MicroStrategy Developers resourcesIdentify Key initiatives for improving B.I. operationsInteract with I.T. Senior Management to plan long term B.I. StrategiesWork with Department Heads to define and implement reporting solutionsDevelop and manage Project Plans for B.I. operationsDevelop and maintain architecture for MicroStrategy 9.4.1

Playa Del Rey, Ca

Develop and maintain architecture for MicroStrategy infrastructure versions 9.4 & 10.X on Linux and WindowsEnterprise reporting from OLTP, OLAP systems and Dashboard designSQL / VIEW optimization and Index Tuning on Teradata Viewpoint and OracleDevelop expert level Visual Analytics on MicroStrategy 10.X and Tableau 9.XDevelop and maintain data models using Embarcadero from disparate data sources such as DoubleClick, Google Analytics, Amazon WS, Flat Files, etc.Data… Show more Develop and maintain architecture for MicroStrategy infrastructure versions 9.4 & 10.X on Linux and WindowsEnterprise reporting from OLTP, OLAP systems and Dashboard designSQL / VIEW optimization and Index Tuning on Teradata Viewpoint and OracleDevelop expert level Visual Analytics on MicroStrategy 10.X and Tableau 9.XDevelop and maintain data models using Embarcadero from disparate data sources such as DoubleClick, Google Analytics, Amazon WS, Flat Files, etc.Data Normalization on Web visitor traffic based on Device ID’s, E-Mail address, Cookies, etc.Web traffic optimization using Session analytics’, partner closed-loop feedback and unstructured dataSupport multiple data interfaces and “Publisher” flat file uploads from Google, Facebook, Y2, etc. Click Stream Analytics on visitor conversion, revenue-per-open/click/visitor for Online AdsVendor liaison and technical case management Show less

Develop, maintain, upgrade and support architecture for MicroStrategy 9.0 Report and Dashboard design; also Narrowcast administrationStar schema design and maintenance of D.W. data integrityProject management for B.I. operationsVendor liaison and technical case management

Managed D.W. operations.Performed upgrades of Informatica (5.3 -> 7.1) and MicroStrategy (7.2 -> 8.1)Star schema design and maintenance on DB2 7.1Develop and maintain architecture for Microstrategy 8Develop and maintain ETL architecture for Informatica 7

Star schema design and maintenance on MS SQL 2000Develop and maintain architecture for MicroStrategy 7.5.3Develop ETL mappings on Informatica 7.1 and Sagent 4.3Enterprise reporting from OLTP, OLAP systems Clickstream analysis and development of 'A\B Testing' methodologiesPL/SQL Query optimization, data analytics and performance tuning

Administration of Oracle 9i and MS SQL 2000 databases in a multi platform environmentETL of 3rd Party data sources, such as Alltel, Metavante, and CountrywideDeveloped stored procedures to interface with Java / ASP client applicationsCapacity planning, developed ERD's, schema's, and stored procedures Developed OLAP systems for reporting mortgage activity Migrated MS Access applications into a Client Server environment

Database management with MSSQL 7 involving the migration to a N-Tier financial system using Windows 2000 Advanced Server Terminal Services from a single server environmentMaintained data replication in a multi-platform environment on Oracle 6i and MS SQL 7Developed and maintained MSSQL 7 based accounting systemsASP development with MS Visual Inter Dev and Macromedia Ultra Dev

Prepared maintenance and modification requests for DB2, MSSQL 7 and FoxPro databases for Financial Reporting and Budgeting divisionProject management for various accounting departments to coordinate interfaces of financial systems in a multi-platform environmentModified financial systems for FASB 53 reporting requirements Evaluated various MSSQL and Oracle based financial system products for ERP Developed Crystal Reports and Hyperion 6 budgeting systems for accounting departments

Maintained ACCPAC General Ledger through close and financial statementsDeveloped Dbase III database systems for property management systems

Maintained Platinum General Ledger through close and financial statementsDeveloped MS Access based database system to report sales, perform churn analysis and prepare commission statements for long-distance and cable servicesCoordinated Lotus Notes based report distribution system

Maintained General Ledger and supporting processes through month-end close Developed automated data entry system using Visual Basic modules and text file uploads to replace a manual data entry process that required several FTE'sPerformed data back-up and Systems testing

Maintained General Ledger and supporting processes through month-end closePrepared financial statements and consolidated reporting for several corporate entitiesDeveloped spreadsheet based analysis tools, depreciation and amortization schedules to supplement paper based reports

M.S. I.S., Information Systems

Activities and Societies: MCE

Master Of Science, Information Systems

Bachelor Of Science, Accounting