SUMMARY:

• Database systems expert, with 20+ years of experience spanning companies of diversified sizes and industries:
• Ability to perform multiple roles as necessary throughout the entire SDLC of a data warehouse or BI project:
• Database architect and developer - Architects databases and solutions without any unnecessary complexity, that are efficient to develop (and can be completed in aggressive timelines), and that are easy to understand, maintain, and expand. Creates systems that run fast and are easy for production-support teams to monitor and support. Has created data models and ER diagrams for numerous data warehouse, business intelligence, star, snowflake, and normalized relational database systems.
• 7 years of experience architecting databases specifically for optimal use by MicroStrategy.
• ETL solutions architect and developer - 19 years of experience with SSIS (including its predecessor DTS).
• VLDB databases - architected, loaded, and optimized multi-terabyte databases from scratch.
• Requirements gathering and communication - Top-level communication skills to interface with clients and experts across multiple departments, and to understand and detail complex business requirements and project scope, and to translate the business requirements into optimal database solutions.
• Ability to handle quantitative complexity - Able to understand and program sophisticated mathematical and statistical computations and complex algorithms.
• Team lead and project manager - Has created detailed technical project plans and led projects with diverse teams across multiple time-zones of up to over 30 people.
• Technical expertise:
• Primary expertise: MS SQL Server, SSRS, SSIS, Data Warehousing, Business Intelligence, Data Modeling, Database Design, Database Architecture, Database Administration, Database Development, Performance Optimization, Multi-Terabyte Databases, VLDB, Partitioning, Erwin, PowerDesigner, ER Diagramming, Requirements Gathering, Project Lead, Team Lead, Project Management, ETL, Star, Snowflake, Normalization
• Secondary expertise: Oracle, MySQL, Sybase, DB2, Access, Excel, SSAS, Unix, Cognos, MicroStrategy

WORK EXPERIENCE:

Confidential, Corona, CA

Business Intelligence Database Consultant (SQL Server)

Tools: Used: MS SQL Server 2012, MS SQL Server 2014, MS SQL Server 2016, MS SQL Server 2017, MicroStrategy, SSIS

Responsibilities:

• Solutions architect, data architect, database developer, ETL developer, and team lead for the corporate data warehouse of Purchase and Sales data.
• The data warehouse and business intelligence reports are used extensively by managers in all of the company’s subsidiary business-units, as well as by corporate management.
• Successfully led the re-architecture of complex nightly ETL process to populate the corporate data warehouse with purchase, receipt, inventory, and supplier data from 22 separate ERP systems.
• Using the purchase and receipts data, created additional algorithmically complex processes to report on “On Time Delivery” and “Baseline Savings” metrics.
• Successfully created a new Sales & Margin module with data model and ETL process to populate the corporate data warehouse with sales, bookings, shipment, and invoice data from 16 separate ERP systems.
• Using the sales and shipments data, created additional system to create sales forecasts for several business-units of Confidential, using extremely complex and sophisticated mathematical calculations and algorithms.
• The calculated forecast-values are used to report to Wall Street.
• Performed multiple roles on each of the above projects, including the following:
• Project manager - Coordinating and leading the project effort, consisting of 27 team members across multiple countries and time-zones (USA - several cities, Canada, France, Germany, England, Italy, India, Brazil, and China). Also created project plan and project roster. The solution was delivered on-time and on-budget.
• Database architect - After meeting with clients to receive detailed business requirements, created star-schema database designs and ER-diagrams, with optimized and simplified data design, making further development and production support relatively easy and efficient.
• SSIS solutions architect and developer - Established standard extract-file formats and data-transmission methods. Created SSIS packages to listen for new-and-ready data-loads, and to load the data into the Sales & Margin data warehouse. Also created SSIS package to streamline the QA and error-tracking process.
• SQL Server developer - Developed stored procedures to load the extracted ERP data into the Sales & Margin data warehouse tables. Developed stored procedures for error-trapping and for streamlining the QA process.
• MicroStrategy co-architect - Working in conjunction with the MicroStrategy developer, created spreadsheet architecting the MicroStrategy solution (attributes, metrics, calculations, prompts, filters, and hierarchies), and mapping each MicroStrategy object to its source database field(s).

Confidential

Business Intelligence Database Consultant (SQL Server and MySQL)

Tools: Used: MS SQL Server 2012, MS SQL Server 2008 R2, MySQL, Unix, PowerDesigner, Erwin, MicroStrategy, SSIS, SSRS

Responsibilities:

• Freelance consultant working remotely for multiple clients (USA and European based), providing database services encompassing the full SDLC. Services provided include database team management, business intelligence, architecture, development, administration, ETL, file-encryption, and performance tuning. Database sizes ranged from small to multi-terabyte. Client industries included sales-and-marketing, education, and food-and-beverage.
• Lead SQL Server database architect and ETL developer of multi-terabyte Point of Sales (POS) system, for USA-based Guest Metrics LLC’s core product, consisting of a MicroStrategy reporting-layer running off of a SQL Server data warehouse, housing data received from POS systems of various clients in the food-and-beverage industry, such as Marriott, Dave-and-Busters, and Daphne’s Greek Cafes.

Confidential

Business Intelligence Database Architect (DB2)

Tools: Used: DB2, Cognos, Erwin

Responsibilities:

• Team lead for the requirements gathering, architecture, ETL, and development of data mart, used to analyze revenue and employee utilization for the Cognos Center of Competency department of IBM.

Confidential, Glendora, CA

Business Intelligence Database Consultant (SQL Server)

Tools: Used: MS SQL Server 2005, Reporting Services, Excel, SSIS, SSRS, SSAS, Access, PowerDesigner

Responsibilities:

• Led the database and reporting architecture, ETL, and development for the company’s SAP Business Intelligence department.
• The developed reports were well-received by both management and the end-users.

Confidential, Pasadena, CA

Business Intelligence Database Consultant (SQL Server)

Tools: Used: MS SQL Server 2005, Reporting Services, Excel, SSIS, SSRS, Access

Responsibilities:

• Led the re-design of the Confidential application for the Decision Support Team of Confidential (formerly Physician Associates), including developing a set of new diagnosis-analysis reports, allowing medical physicians to consider potentially-missed ICD9 diagnoses that would increase the Confidential scores of their Medicare patients.
• These efforts resulted in an increase in Medicare revenue stream by over $3,000,000 beyond company projections, and a 15% increase in projected Confidential scores for 2008.