SUMMARY:

• Independent self starter. Communicates well with and between technical and business people.
• 18+ years of full lifecycle development experience. From requirements gathering to development, delivery and maintenance.
• Proven ability to master new business areas, methodologies, technologies, languages and environments.
• Complex subject areas supported, including Healthcare, Manufacturing, Sales/Marketing, Decision Support, Quality Assurance...
• Technical Skills ranging from object oriented coding to database development to dimensional modeling, and web development
• Documentation produced to variety of standards customized to local conditions. (Military Specifications, IEEE, NIST)
• Masters and Bachelors Degrees in computer science.

PROFESSIONAL EXPERIENCE:

Business Intelligence Architect

Confidential, Nashua, NH

Responsibilities:

• Data Warehouse Development - Designed and implemented data warehouse and ETL process to import clinical, provider, and financial data relating to dental Confidential t visits and related insurance claims. Six different insurance carriers imported to single data warehouse with shared conformed dimensions and fact tables. Intensive rule based cleansing and conforming procedures implemented to identify duplicates and unusable data elements. Ad hoc reporting and data analysis performed to customer specifications.
• (Sql Server 2005/2008, Visual Studio 2008, MS Integration Services, MS Analysis Services, C#, XML)

Senior Developer

Confidential, RavensWood, IL

Responsibilities:

• Data Warehouse Development - Developed Integration Services package that converts OLTP data base into multi-sourced data warehouse. Implemented as periodic snapshot with class I and class II slowly changing dimensions. Applied data model refactoring to extract and combine repeated and imbedded dimensions from base tables. Configurable via meta data describing tables as measure and/or dimension and describing column usage as to measure, dimension, delta and key.
• Scheduling Data Modeling - Modeled enhancements to existing data model to enable assignment of orders to known or forecasted capacity. Included hierarchical structures to represent demographics, geographical breakdowns, and target structure.
• (Sql Server 2008, Visual Studio 2008, MS Integration Services, MS Analysis Services, C#, XML, SVN)

Business Intelligence architect

Confidential, IL

Responsibilities:

• Architecture - Developed reporting strategy to consolidate numerous disparate databases into one central version of the truth. Included periodic snapshots, quality checks, data cleansing and slowly changing dimensions.. Subject areas included invoicing, shipments, service, and electronic communication with medical devices.
• (Sql Server 2008, Visual Studio 2008, MS Integration Services, MS Reporting Services, MS Analysis Services, C#, MS Team Server)

Software Engineer - Data Warehousing and Reporting Specialist

Confidential, Chicago, IL

Responsibilities:

• Reporting - Developed reports detailing payment history, case loads, and work queue status for external clients. Distributed via e-mail subscription and on demand via web page, and Sharepoint.
• Data Warehouse Development - Developed Integration Services package to combine and summarize multiple legacy data sources into one central view. Modeled data warehouse, developed datamart dimensional model.

Business Intelligence Analyst

Confidential, Chicago, IL

Responsibilities:

• Designed and implemented data mart representing claim data. Dimensions included physician, medical facility, employer, clinical diagnosis, and time. Periodic snapshot fact tables and class 2 slowly changing dimensions implemented. Hierarchies designed and implemented for medical services, Confidential t demographics, payers, facility rosters, Confidential t rosters. Time dimensions for fiscal and calendar years applied to service, billing, and collections. Designed and implemented ETL logic to populate data mart from data warehouse.
• Designed and implemented web dashboards representing demographic trends and Insurance carrier distributions.
• Developed Excel charts driven from data tables representing financial transactions relating to claim collections, fee schedules, Confidential t tracking. Extracted data and created charts depicting Confidential t movements between payers, utilization distribution
• XML Submissions - Create XML output from PQRI system for government submission.

Senior Business Technical Analyst

Confidential, Chicago, IL

Responsibilities:

• BlueBrowser - Identified benefits of visual interactive user experience in support of analytical and research activities. Conducted interviews with actuaries and underwriters to develop initial view( Confidential ) of operational data. Incorporated undocumented requirements from legacy reporting systems. Designed charts and graphs representing time series of, claims and income. Demographic breakdown of populations, product structure, and customer timelines all represented. Designed and implemented visual interactive user interface to present data graphically. Included navigation, aggregation, searching, and filtering. Rapid prototyping methodology utilized. Object Model implemented through creation of multiple name spaces and several dozen classes. Presentation layers generated through extension and combination of windows control classes to produce intuitive visual representation.
• Actuarial DataMart - Produced database design document, project timelines, and operational concept document. Designed, implemented and owned database schema that consolidates data from many disparate and isolated data sources. Data mart integrates employer, demographic, financial and product structure data. Database tuned for rapid extraction and presentation. Enables business intelligence initiatives. Facilitates reporting across disparate functional areas and organizational levels.
• ETL - Developed process and logic to transfer data from mainframe flat files, sql-server, and teradata sources. Process completely automated with in-process quality checks and data logging. Delta functionality tracks changes in source data over time. Table sizes reduced through use of generalized set theory to detect and represent repetitive patterns in data. Includes detection and creation of new data entities from source data and data cleansing.
• Legacy Mainframe - Filled gap to support legacy systems unimproved for 15 years or more on IBM mainframe and Unix environments. Improved documentation of legacy systems, automated repetitive tasks.
• Mainframe Modernization - Identified benefits and championed department used of Unix Systems Services and JAVA on IBM mainframe. Nine month process of negotiation and information transfer with central IT to obtain UNIX accounts on mainframe. Enabled retirement of unsupported mainframe languages and the balancing of data processing between mainframe and PC resources. Extensive internet research on IBM recommended best practices. Facilitated future conversion to LAN oriented processing.

Senior Developer/Project Manager

Confidential, Gurnee, IL

Responsibilities:

• Object Model - Utilized simple inheritance to eliminate duplicate code. Ensured ongoing data quality. Improved revenue calculation algorithm to better model real world
• Report Manager - Identified opportunity for improved performance, maintainability, and extensibility. Re-Engineered financial reporting system. Included database enhancements, and user interface development. Improved execution time from several hours to less than ten minutes. Improved scope, accuracy, and consistency of reports. Reduced requirements through one common interface and report criteria selection method. Simplified code base, reduced redundancy, reduced lines of code by factor of three. Combined three separate reporting tools into one, combined separate divisional financial reports into single consolidated report. Reduced report development time by factor of two, maintenance effort by factor of five.
• Proposal/Budget Creation Tool - Initialized proposal document from project budget.

Programmer Analyst

Confidential, Elk Grove Village, IL

Responsibilities:

• Centralized data from satellite locations into corporate decision support database. Developed reporting systems in support of Sales and Finance (Treasury) organizations. Enhanced supply chain management tool through increased report formats, and automated spreadsheet generation. Developed prototype website for taking customer orders. Included automated page generation from database, embedded ocx for presentation of graphics.

Quality Assurance Systems Manager

Confidential, Franklin Park, IL

Responsibilities:

• Quality Decision Support System - Designed, implemented and supported decision support software and databases for Vice President of Quality Assurance. System functionality encompasses incoming inspection, supplier rating, production yield, and final product audit and field failure analysis. Data from multiple sources and formats collected, integrated, sanitized, and organized. On line access to data presented to decision makers and staff on demand. Several dozen data entry screens, data browsers, system maintenance screens, operational reports, and reports presenting departmental performance metrics implemented. Roughly forty users ranging from mechanical engineers to assembly line workers.
• ETL - Extracted data from AS400, Oracle sources for in corporation into centralized repository.