Michael Mullen Email & Phone Number

Monterey, California

My responsibilities include design and modification of existing database tables and procedures, assisting in the design of an analysis cube, and general reporting for SQL Server databases.

Redwood City

In charge of all management reporting from LIMS system, providing Finance dept. with actionable information for invoicing, creation and daily maintenance of data marts.Key Accomplishments:• Designed integration of Laboratory Information management system, Salesforce, and Financial servicing inputs to operational data stores and an integrated data warehouse.• Designed methods to report on process times and test results from the laboratory database.• Integrated financial billing information from service bureaus with direct billing requirements for internal invoicing.• Designed and implemented hierarchical dimensions and multi-dimensional database using Kendall methodology.

San Jose

Database Analyst for Cisco Services Finance and Cisco Services Partner Programs: Responsible for reporting channel sales details to Finance department: monthly dashboards and scorecards, interactive pivot tables by subject matter, tracking promotional programs fulfillment statistics.Key Accomplishments:• Designed database reporting all 2-tier channel bookings for Cisco Services finance.--- Designed and implemented data staging in SSIS.--- Designed and implemented the cube hierarchies, attributes, and measures.--- Implemented several calculations in MDX to enhance intelligence.• Designed and implemented data mart detailing all requirements for worldwide promotional program.--- Integrated data from 3 source engines, a total of 15 feeds.--- Implemented cube hierarchies and attributes for drill-down capabilities.--- Created logical scripting to apply business rules and flag program eligibility.

San Jose, Ca.

Database analyst, architect, and administrator for Revenue Recognition: converted desktop application to client-server database, refined data cleansing routines, designed prototype web-based front end.Key Accomplishments:• Created routines to find and eliminate embedded data in queries.• Designed SQL database for Revenue Recognition project.• Migrated base records to new SQL Server database.• Designed prototype front end in ASP.Net 2.0 with C#

San Francisco Bay Area

Responsible for business analysis of international sales forecasting inputs and database implementation of sales forecasting application Key Accomplishments:• Conducted business analysis to formalize parameters of a department level sales forecasting application. This included workshops to document forecasting application business rules.• Diagrammed data flow for forecasting application.• Created input forms for data extract from Essbase cubes.• Used Visio to create ERP diagrams for application database• Designed SQL Server database to replace existing Access / Excel forecasting application.

Part of a team responsible for data model and quality for world-wide services application validating units in field against eligible contractsKey Accomplishments:• Quality assurance work against a suite of Access databases. Verified interface elements, tuned query clauses for efficiency, constructed logic tables for applying business rules.• Created stored procedures in Oracle 8i to extract data and aggregations for analysis.• Created form-driven application for verification of equipment instances noted in Excel spreadsheets against Oracle data mart.• Created Visual Basic routines for specific data formatting and parsing• Automated reporting for custom spreadsheets and data streams

San Francisco

Data analyst for Portfolio Management Analysis team, wholesale products division. Documented and re-modeled legacy data feeds, created new data tables to hold data. Created system for reporting exceptions to conversion. Provided quality assurance for checking vendor conversion.Key Accomplishments:• Assisted in data quality control during a major vendor conversion. Modeled data allowing sufficient granularity to resolve inconsistencies in data conversion• Redesigned overdraft and returned items reporting process to normalize data mart tables, allowing the consolidation of 3 separate report processes.• Refined and documented legacy systems programs for Oracle 9i, adapting SQL programs to changing business requirements and creating business process documentation.

San Francisco Bay Area

Created application to ensure that no Yahoo! would recieve more than 2 emails from Yahoo! directly. Also proportioned total customers between Yahoo! program advertisements.

Responsible for modeling and creating the database web service for member billing application. Conducted business process analysis of billing and account services.Key Accomplishments:• Modeled data structure for XML service to provide billing information to ASP. • Implemented web service utilizing Visual RPG, Visual Basic.Net, and ASP.Net.• Implemented new procedures to assist in annual billing. • Analyzed existing DB2 database tables and procedures. Created new view tables to link with front end services for reporting and analysis.

• As database architect, normalized existing back office database to account for increased business needs. • Tuned the database for interactive reporting outputs.• Expanded the model to include Fixed Income and Derivatives products for Back Office reporting. • As database analyst, revised DB2 database naming standards and adapted to native format I/O to improve performance within constraints of the Banc’s computing architecture and AS400 platform. • Using Erwin data modeling tool, created metadata, mapping, and supplemental data structures for application development. • Extracted internal documentation from DB2 and Erwin metadata for use as application manual.• Created database script (DDL) for database maintenance.

Responsible for programming allowing customer participation in IPO sales and the transaction system to implement the sales. Design and implementation of data model allowing the trading of foreign stocks. Account establishment for all accounts acquired under OptionsLink merger, and transaction system for establishing new clients for OptionsLink division.Key Accomplishments:• During acquisition / merger of OptionsLink, determined enterprise data model to be used by system across 4 data platforms. • Created batch transaction automation with rollback to establish user accounts on the following databases and operating systems: RMS on Dec DB2 on IBM  Oracle on Unix Oracle on NT SQL Server on NT• Created program to filter candidates for initial public offerings, to allocate the shares allowed under ‘bidding’ conditions, and place the orders at the time of the IPO.• Determined the information necessary to integrate Canadian Stocks into the trading system, and modified the trading database entities to adapt to international trading in general.• Analyzed existing process flow to create program to duplicate Order tickets on demand. Resulted in 60% savings in manpower and materials.

Political Science, Forensics

Activities and Societies: Debate team

Education record

Activities and Societies: debate team, intercollegiate forensics and competitive speaking