TECHNICAL SKILLS

• Business Objects Dashboard Designer (formerly Xcelsius)
• Business Objects XI v 3.x
• Neteeza
• SQL Server 2000, 2005, 2008
• SQL Server Analysis Services (SSAS)
• T - SQL
• MDX
• Oracle
• DB2
• RMS eSurety
• AS400
• AIM
• EAS SunGard
• Microsoft Excel (VBA)

PROFESSIONAL EXPERIENCE

Confidential, Overland Park, KS

Responsibilities:

• Led a Confidential 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 with 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 Confidential global delivery center, based out of Warsaw, Poland.
• Engaged with multiple data warehousing, modeling and architecture teams in configuration & design of data warehouse structures utilized by the Confidential platform.

Confidential, Overland Park, KS

Responsibilities:

• Confidential support, consulting and development for clients.
• Software-as-a-Service (SaaS), Proof of Concept (POC), and web based Showcase Studio Design.
• Confidential project rescue.
• Business Intelligence best practice consulting.

Confidential, Evansville, Indiana

Responsibilities:

• Developed a proof of concept Confidential showcase for client’s BI evaluation & due diligence purposes.
• Coordinated with ETL team and SSAS developers to build relational schema in Confidential .

Confidential - Kansas City, Missouri

Responsibilities:

• 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 within the Confidential 9.2.x platform, including Confidential Desktop, Confidential Web, Confidential Admin, and Confidential Architect.
• Developed complex report sets & dashboards in Confidential 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 with data engineering & data governance groups.
• Worked directly with business unit leaders to formulate and design solution architectures supporting the ongoing analytics build.

Confidential, Overland Park, Kansas

Senior BI Consultant

Responsibilities:

• 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 with pivotal schema builds, as well as ROLAP designed data integrity checks.

Confidential, Overland Park, Kansas

Senior Consultant

Responsibilities:

• 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 with business unit leaders to gather project requirements, consolidate existing reporting extracts and demonstrate various functionality of the Confidential platform.
• Built dynamic reporting extracts including dashboards, documents and web-based applications which allowed Confidential ’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 with database engineering to accomplish account management conformity across multiple CRM source systems
• Passed all courses in Confidential ’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 Confidential Administration (MCPA), Confidential Developer (MCD) and Confidential 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 Confidential version 9.2.1.

Confidential, Kansas City, Missouri

Business Intelligence Director

Responsibilities:

• 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 with 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 with data engineering consulting groups & vendor support teams to replicate data models within 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 with 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 with 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 within 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 within the BOE domain. Administered BOE/SAP on-line training and virtual classrooms for our end-user base.

Confidential, Peoria, IL

Technical Lead, Analytics & Delivery

Responsibilities:

• Served as a technical lead within 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 with 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.

Confidential, Peoria, IL

Senior Information Specialist

Responsibilities:

• 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 within 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 with internal audit team to comply with Sarbanes-Oxley (SOX) regulations and controls.