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.

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.

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).

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.

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.

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.

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.

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.

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