SUMMARY

• Solutions focused IT professional seeking remote opportunities where I can leverage over 19 years of experience in data warehousing, dimensional data modeling, front end reporting tools, process automation, leadership skills and full - stack end to end project completion.Computer Languages, Familiarities and Tool Proficiencies
• Business Objects Designer 5.0 - 14.1, Infoview XI, Central Management Console XI, Central Configuration Manager XI, Business Objects Reporter, Business Objects Supervisor, Business Objects Broadcast Agent, Crystal Reports XI, Erwin, Kimball Group Data Warehouse Architecture, Confidential 8i,9i,10g,11g, DB2, SQL Server, Postgres, Pentaho BI, Schema Workbench, Penatho Analyzer, Pentaho DI, MS-Access, TOAD, SQL Navigator, SQL, PL/SQL, SQL Plus, UNIX, UNIX vi Editor, UNIX shell scripting, Crontab scheduling, Control M scheduling, AutoSys Scheduler, SDLC, Track Record and Request Tracker defect tracking, PVCS code management, StarTeam code management, Claims Connect, Diamond 950, Sharepoint, JIRA, Sysaid, Tableau, Periscope Data, SSRS, AWS

PROFESSIONAL EXPERIENCE

Senior BI Developer

Responsibilities:

• Led conversion of all ETL jobs, databases and reporting tools from MS SQL server to Confidential .
• Architected and redesigned legacy stored procedures and functions from MS SQL server to Confidential syntax.
• Designed and implemented replacement for legacy data warehouse indexing scheme.
• Redesigned multiple Pentaho ETL jobs to increase performance and scalability.
• Designed and created multiple complex customer specific data feeds with AES128 encryption for delivery to AWS S3 secure bucket.
• Worked fully remote with associates located throughout United States and internationally.

Confidential

Solutions Architect

Responsibilities:

• Subject Matter Expert (SME) during migration of legacy reporting tool (Pentaho) to Tableau and SSRS.
• Designed and automated creation of multiple data sets using ETL processes to support executive level Tableau Dashboards.
• Refactored and recreated multiple legacy Pentaho reports to Tableau and SSRS.
• Led design and implementation of new billing and reconciliation processes to support/overcome functionality gaps in legacy business application by using data warehouse and reporting tools.
• Worked closely with implementations team to provide automated data interchange processes and reporting for new clients.
• Architected backend data solution to support complex forecasting dashboards.

Confidential

Enterprise Data Architect

Responsibilities:

• Played critical role in managing IT and data related activities during multiple mergers and acquisitions. Worked closely with IT counterparts from acquired business units to create integrated high performing IT department.
• Architected and implemented solution for migration of legacy application data and data warehouse onto new platform and structure.
• Designed, created and automated multiple ETL processes to gather inpatient claim data (UB form data, itemized bills, revenue codes, patient information, facility information and RX data) from multiple data sources into warehouse environment in preparation for rules engine processing (InRule Application).
• Prepared queries, inserts and update statements for rules engine web service.
• Created ETL process using Pentaho Data Integrator to process and load complex free form claims data from internal triage form to warehouse staging environment.
• Proposed and implemented several process improvement solutions to current reporting environment.
• Provided confidential financial and operational due diligence data and information to support acquisition of Confidential by Equian.
• Evaluated options for enterprise class reporting solution, presented findings and made recommendation for new enterprise reporting tool set.
• Created analytic dashboard using Tableau for major external customer including, but not limited to gathering and organizing of data from multiple sources, end user and external security.
• Tasked with designing, creating and implementing enterprise class business intelligence solution. Including data warehouse architecture, ETL tools and processes, data governance and reporting.

Confidential

System Architect Consultant

Responsibilities:

• Designed, created and scheduled multiple reports and extracts for the Hawaii regional Claims Connect implementation to support testing, quality and performance.
• Mentored new hires on departmental reporting best practices and methodologies.
• Proposed physical and logical architecture improvements to reporting environment.
• Created multiple reports and extracts to support troubleshooting of application problems and configuration issues.
• Designed QA processes for Provider Contract Audits, Fee Schedule Audits, Price Rule Audits and Provider Vendor demographics.
• Recipient of multiple customer service/employee s.
• Engaged business stakeholders to design and create a reporting based solution to identify errors generated from the application accumulations process.
• Worked closely with external contractor to transition reports, data mart scripts and processes to internal KP claims department.
• Acted as configuration dept. liaison/consultant for ICD-10 Wrapper project for impacts to current and future reporting and database needs.
• Designed, created and implemented multiple automation processes for Fee Schedules, Ambulatory Surgery Center (ASC) contracts, LVAR provider matching and Contract Change Audits.

Confidential

Data Analyst

Responsibilities:

• Designed and created multiple Business Objects universes to support the reporting and management of the Colorado Xcelys project.
• Designed and created HIP, XLSKP, and Confidential Extract Universes, modified or added additional functionality to the Claims Base, Xcelys Benefits, Xcelys Provider and OPA universes.
• Developed and automated multiple reports and extracts to support daily business activities of the Claims and Configuration departments, including by not limited to HIP Inventory Reports, HIP Dashboard, Xcelys Inventory reports.
• Devised reporting contingency plan in order maintain reporting functionality during system outages and upgrades.
• Worked closely with outside vendors to provide non-PHI data extracts as requested by management.
• Trained and mentored teammates and analysts in best practice reporting techniques for Business Objects.

Confidential

Senior Data Modeler

Responsibilities:

• Managed Business Objects software upgrade from BO6.5 to XIR2 3.1.
• Upgraded all reports, users, universes, security groups and repository onto new server, operating system and repository using Confidential 10g for repository database for approximately 80 users.
• Trained and mentored Decision Support analysts in best practice reporting techniques for Business Objects.
• Developed approximately 15 new subject matter specific Business Objects Universes, to support a variety of business needs ranging from testing, reporting, analysis and or extracting.
• Led design and development of project that merged existing pharmacy data with data from new pharmacy vendor to support seamless reporting across both data sets.
• Designed and created secure BO reporting environment for external customer/partner containing multiple universes, reports and extracts.
• Integrated Business Objects XIR3 3.1 with MS Sharepoint 2005 to more effectively leverage dashboard reporting.
• Designed and created multiple HEDIS measures using a combination of SQL and Business Objects universe design to increase efficiency and decrease costs associated with using external vendors for required HEDIS reporting.
• Designed and created datamart, The datamart replaced a manual process requiring approximately 40hrs per month and two FTEs.
• Worked closely with Decision Support department to increase efficiency and automate multiple manual processes.
• Integrated Business Objects log on with Windows Active Directory authentication.
• Created multiple dashboard style reports using a combination of Xcelsius, Business Objects, Live Office and QAWS (Query as a web service).
• Customer Service Champion winner 2008.

Confidential, Denver, CO

Team Application Systems Engineer IV

Responsibilities:

• Bankruptcy Project: Designed and created process to automatically retrieve, process and load to data warehouse external vendor bankruptcy files using a combination of UNIX shell scripting, Perl, FDX secure transmission software, AutoSys scheduling and DataStage ETL toolset.
• AFS Ad Hoc Project: Led design phase of project to provide Loan Services department with AFS data in an easily queryable format. Including creation of Functional System Design document (FSD), Meta Data tables, Process changes to adhere to a standard software development lifecycle and ensured collaboration between business users, quality assurance team and ETL developers.
• Bank Security Act: Worked closely with subject matter experts and production Database Administrators to provide data sets for Bank Security Act (BSA).
• Segment Count Compare: Designed and created DataStage ETL jobs used to compare header files with actual staging tables to assure file segment counts matched.
• Process Improvement: Identified process bottlenecks, successfully proposed changes to management and began implementation of changes to fall more in line with standard software development lifecycle.

Confidential, Denver, CO

Senior Data Modeler

Responsibilities:

• Designed and developed Claims Data mart to accurately and easily report on daily claims metrics via a star schema design using Kimball methodology.
• Developed incremental load processes for Claims Data mart including type 2 slowly changing dimensions and historical recreation capabilities.
• Created Business Objects Universe for Claims Data mart.
• Implemented Software Development Lifecycle process for reporting environment.
• Upgraded Business Objects from 6.1b to 6.5.1 SP1
• Tuned queries from existing reports to increase performance.
• Created Business Objects Universe for RT (Request Tracker) database to allow management reporting for work/project requests.
• Created Business Objects Universe for Core provider application.
• Worked closely with CFO to design and develop SQL procedures to determine retro disenrollment and related impact to paid pharmacy and medical claims.
• Created database model for eligibility redesign project.

Confidential, Denver, CO

Software Developer

Responsibilities:

• Technical Reporting Lead, Transition Team
• Software Developer / Senior Software Developer
• Technical Lead Enterprise Reporting
• Associate Software Developer, object-oriented developer for Sage application.