MicroStrategy 9.3.x platform design, deployment, and development
Business Objects XI platform design, deployment, and development
Dashboard, Scorecard and other Visual Analytics Design & Delivery
Data Modeling, Engineering, Quality Control
Predictive Analytics Development
Software as a Service (SaaS BI) Development
Data Analysis, Architecture, Warehousing & Modeling
Training and Mentoring End - users on multiple BI Platform(s)
Evaluating front-end applications for feasibility of integration wifin the BI Domain
Acquisitions and Mergers - Data Warehouse & BI Integration
Integration and testing of complex SQL, T-SQL, VBA and MDX coding
Application and Database Quality Assurance, Stress-Testing & Risk Management
Business Intelligence Solution Architecture
Consulting project management for data warehouse, third party vendors, and BI platforms
Loss Reserving, Pricing Analysis and Portfolio Optimization Strategies (Actuarial)
Loss Control & Claims Management
Catastrophe Management Modeling (RMS)
Reinsurance exposure, pricing and performance
Underwriting knowledge & rating algorithm design experience across 28 different P&C product lines
Design and delivery of EPM and ERM reporting infrastructures.
General Ledger configuration, financial statement design, delivery and automation
Proven ability to identify and reduce operational inefficiencies
Application Design & Deployment (custom and third-party), including rating tools
Business Objects Dashboard Designer (formerly Xcelsius)
Business Objects XI v 3.x
SQL Server 2000, 2005, 2008
SQL Server Analysis Services (SSAS)
T - SQL
Microsoft Excel (VBA)
Team Lead & Senior MicroStrategy Consultant
Led a MicroStrategy SaaS (software as a service) Six Sigma best practice deployment for 300+ records/documents/image clients of Canon.
Served as a team lead for managing resources in an off-shore/on-shore model BI deployment for over 30 MAX advanced clients and 300 MAX basic clients.
Managed our BI deployment team in coordinating wif a 3rd party network vendor, overseeing hardware and infrastructure reconfiguration, performance and maintenance.
Proposed, obtained and led our BI deployment team in utilizing administrative support service from the MicroStrategy global delivery center, based out of Warsaw, Poland.
Engaged wif multiple data warehousing, modeling and architecture teams in configuration & design of data warehouse structures utilized by the MicroStrategy platform.
Founder & Senior MicroStrategy Consultant
MicroStrategy support, consulting and development for clients.
Software-as-a-Service (SaaS), Proof of Concept (POC), and web based Showcase Studio Design.
MicroStrategy project rescue.
Business Intelligence best practice consulting.
Senior MicroStrategy Consultant
Developed a proof of concept MicroStrategy showcase for client’s BI evaluation & due diligence purposes.
Coordinated wif ETL team and SSAS developers to build relational schema in MicroStrategy.
Senior MicroStrategy Consultant
Worked as a senior level BI consultant on a clinical operations project, managing a team of BI developers, quality specialists, and administrators.
Used multiple techniques to improve query performance, including VLDB properties, nested table expressions and intelligent cubes.
Trained core users and developers on many of the modules contained wifin the MicroStrategy 9.2.x platform, including MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Admin, and MicroStrategy Architect.
Developed complex report sets & dashboards in MicroStrategy which were utilized by over 300 employers & their members for health & wellness activity, wellness consultation and general population health profiles.
Took on a key role in developing logical and physical data models for the project, interacting extensively wif data engineering & data governance groups.
Worked directly wif business unit leaders to formulate and design solution architectures supporting the ongoing analytics build.
Senior BI Consultant
Worked as a senior level BI consultant on numerous projects, including neonatology analytics, whole system measures, report overhauls, and database consolidations. CHCA performs Software-as-a-Service business intelligence for 43 childrens hospitals around the United States.
Developed proof-of-concept (POC) analytics, built in SAP Business Objects Dashboard Designer (SAP 4.0), as well as release XI v3.1 SP3.
Assisted database engineering group wif pivotal schema builds, as well as ROLAP designed data integrity checks.
Worked as a senior level BI consultant on numerous projects, including large P&C insurance clients, wealth management & private equity clients, as well as oil & natural gas transportation entities.
Led a seven-figure business intelligence project for a private equity/wealth management for a Fortune 100 client. Project architecture integrated API data from Capital IQ, Sales Force.com, and internal financial data. Worked extensively wif business unit leaders to gather project requirements, consolidate existing reporting extracts and demonstrate various functionality of the MicroStrategy platform.
Built dynamic reporting extracts including dashboards, documents and web-based applications which allowed MicroStrategy’s Fortune 100 client to replace the functionality of a reporting system which had been in place for seven years in a three month period. This project exercise was attempted unsuccessfully by four previous BI vendors utilized by the client.
Developed physical data models and data warehouse extracts using SQL Server 2008, Power Designer and Oracle SQL. Worked wif database engineering to accomplish account management conformity across multiple CRM source systems
Passed all courses in MicroStrategy’s 7-week “bootcamp” on the first try. Earned highest score on 20-hour project exam, and the aggregate high score for the 14-member group.
Currently certified on MicroStrategy Administration (MCPA), MicroStrategy Developer (MCD) and MicroStrategy Engine Specialists (MCES)
Trained in summer 2011 on advanced visual analytics, iPhone/iPad mobile application development, transaction (writeback) mobile services, and data mining techniques for MicroStrategy version 9.2.1.
Business Intelligence Director
Oversaw enterprise performance, risk management and business intelligence initiatives for a startup property casualty insurer. Rockhill currently writes property casualty business in 48 states across 8 companies and 11 product lines, including 6 MGUs. 2010 written premiums were in excess of $190 million.
Developed a comprehensive set of executive level Xcelsius dashboards wif parameter driven drill-through functionality to the Web Intelligence layer reporting in the Business Objects Infoview repository.
Developed numerous data marts to support and build Business Objects universes. Utilized Erwin, DTS/SSIS and other ETL tools to support data management processes. Built DTS/SSIS packages to execute ETL processes, report delivery, and data quality management functions.
Integrated BOE universe collection using multiple third party vendor tools. Worked wif data engineering consulting groups & vendor support teams to replicate data models wifin our data marts and respective universes.
Built accounting & financial reporting and analytics domain for Rockhill Holding Group based off of EAS SunGard (General Ledger) software. Automated, scheduled, and triggered over 50 reporting extracts for delivery on both a cyclical and event driven basis.
Developed multi-dimensional loss/count/statistics triangle application using Business Objects Web Intelligence and Crystal Xcelsius for our actuarial department. The application utilized loss development factor algorithms and ultimate loss/IBNR/claim count estimates using scenario driven visual analytics (Xcelsius).
Automated and scheduled over 75 reporting exhibits denoting key performance indicators for our product metrics portfolio, including targets and variance thresholds wif embedded alerting. Metric sets were used for strategic planning, internal review and board meetings.
Oversaw migration of BOE XI v2 production environment into a BOE XI v3.1 test environment. Utilized Import Wizard functionality and cross checks for QA.
Enabled executive users to utilize parameter driven reporting and analytical mediums to navigate, drill and forecast data elements from 12 different BOE universes.
Worked wif a BI consulting team and outsourced network/data center to implement, administrate and maintain networking & hardware for BOE’s web and application servers.
Administrated and maintained BOE’s central management server security for 20 named users.
Saved company over 1,000 man hours of report development time wifin the first 18 months of our Business Objects XIv2 implementation by eliminating operational reporting inefficiencies.
Developed daily production report set distributed to executive team, product line leads and underwriters. Report data was sourced from five separate claims TPAs, and twelve separate policy enterprise data stores.
Assisted our catastrophe management department in building a customized software tool which allowed underwriters to gauge the marginal risk added to our portfolio on a by account basis.
Developed various risk pricing solutions for our actuarial and underwriting departments across 11 different product lines.
Hosted numerous workshops & training sessions to support end-user skill development wifin the BOE domain. Administered BOE/SAP on-line training and virtual classrooms for our end-user base.
Technical Lead, Analytics & Delivery
Served as a technical lead wifin the strategic information services department.
Planned and delivered dynamic analytical intelligence solutions to major company profit centers using the Business Objects XIv2 products suite.
Managed an 11 department user liaison group responsible for the selection and implementation of the company’s business intelligence platform.
Developed Business Objects XIv2 deployment strategies wif top executives from the underwriting, actuarial and senior management departments.
Directed an information inventory initiative, collecting quantitative and dimensional components of over 400 operational reporting packages in eight separate departments. The results of this initiative were summarized in an interactive metadata matrix, used by the strategic information service’s engineering team to fit the specifications of the underlying data model.
Senior Information Specialist
Led a project development team responsible for instituting an underwriting scorecard package; a product-exclusive analytical application comprised of rate level indications, profit reports, and key marketing performance metrics geared towards maximizing underwriting profits.
Constructed a dynamic analysis tool for the catastrophe management and reinsurance procurement departments enabling hypothetical reconstructions of net losses under various reinsurance structures.
Designed and implemented web-based rate quoting applications for personal umbrella and home business products, allowing customers and producers in all 50 states to price coverage selections online.
Designed and administrated numerous relational databases supporting OLAP-sourced applications wifin the SQL Server 2000 / Analysis Services environment.
Automated numerous annual statement, internal, statutory, and ISO data submission reporting processes.
Streamlined actuarial services reporting processes including loss reserving, pricing and booking of IBNR. This was accomplished through the implementation of various OLAP-sourced VBA applications, and improved the actuarial department’s reporting efficiency by 85% in a one-year period.
Collaborated wif internal audit team to comply wif Sarbanes-Oxley (SOX) regulations and controls.