SKILL

• Oracle Policy Automation OPA
• Oracle Policy Modeling OPM
• XML, XSL and .NET Web Services
• Visual Studio 2005/2008 and 6.0
• SQL RDBMS: Oracle 8.i and 9i, PL-SQL
• UML Analysis, Database, and System Design
• SQL Server 97/2000/2005 Transact SQL
• OOP and OOD Software Development
• Full Life Cycle DBMS Application Development
• Data migration, conversion, and ETL scripting
• Excellent Verbal and Written Technical Communication and Customer Service Skills

Confidential

• OPA Rules Architect for Vermont Health Connect health care exchange.
• Enhanced and tested OPA 10.4 rulebase integrated business rule engine of the Health Care Exchange.
• Performed architectural and functional discovery and analysis on existing sparsely docmented systems.
• Examined 2015 Vermont and Federal policy changes and updated rules for eligibility and state/federal subsidies.
• Interfaced with a variety of stakeholders and policy personnel.

Confidential

• Professional services consultant: Oracle Policy Automation solutions, analysis, architecture, and training.
• Lead OPA developer US Treasury ACA project: OPA Batch Processor integrated OPA data-validation system. Authored rulebase for validation of monthly HIX data transmittals to US Treasury design documentation, and mentored junior staff on this project.
• Led team of 3 for authoring a complete set of self-paced OPA training materials for OPA 10.4 and Web Determinations/Velocity template customizations.
• BA and rules developer on Cover Oregon health insurance marketplace comprehensive healthcare and social services rulebase platform. Liaison with SME's and policy officials for elicitation of policy and construction of rules and attributes.

Confidential

• Team lead: team tasked with development of pricing and forecasting modules for pharmaceutical manufacturing financial application.
• Developed rules policy strategy and rulebase working from business requirements and SMEs.
• Modeled complex rulebase in Oracle Policy Modeling OPM with screens. This project is for input and validation of user data against company, state, and federal regulations pertaining to manufacture of pharmaceutical products and controlled substances.
• Architected custom integration components connecting the OPA data collection/validation modules to down-stream data processing system.
• Architected and led construction of overall system components in Oracle PL-SQl and VB.NET, and OPA 9.x and 10.x

Confidential

• Rules Developer/Senior Business Analyst Performed extensive customer facing activity, including business analysis, process re-design, and RAD sessions for design of asset allocation and tracking system of PC, laptop, and peripheral equipment for the 16,000 member Capitol One employee workforce.
• Developed rulebase with screens for user facing components of this effort to determine employee equipment allocation per Capitol One asset allocation policy using the determination to output the associated equipment order.
• Authored rules and entity model per the system design. Tested and implemented against down-stream data processing system.
• Constructed remainder of this asset allocation and tracking system in SQL Server and C .NET.

Confidential

• Delivered and implemented software systems: enterprise Windows application problem resolution software
• Extensive customer facing activity: Project initiation and management, customer requirements collection and analysis. Project management and monitoring per Service Level Agreements.
• Re-design of customer personnel workflow processes for new system s .
• Creation of software implementation and integration technical design documents.
• Formal classroom training and one-on-one mentoring.
• Consulted on problem resolution of enterprise ASP.NET, C , VB.NET, T-SQL and PL-SQL applications.
• Performed at customer location in fast-paced environments, frequently working on multiple projects simultaneously.

Confidential

• Business/Systems Analyst and Transact-SQL coder Cleansing, merging and migrating legacy database systems to new database.
• Data analysis and Creation of extensive system documentation, specifications and data dictionary.
• Data analysis, scrubbing and migration using T-SQL and SQL Server of diverse legacy systems for migration to common database.
• High visibility customer facing activity gathering business rules and requirements.
• Translation of business requirements into technical design documents.

Confidential

• Analyst, Transact-SQL, and Crystal Reports developer performing project duties:
• Analysis and conceptualization of customer requirements K-12 public school standardized testing .
• Data import and export using DTS, Stored procedure creation and enhancement and Crystal Reports development for deliverables.
• Expediting and managing project processes to meet aggressive deadlines.

Confidential

• Analyst and Software Developer enhancing web-based Home Equity reporting application.
• Coded ASP.NET, C , CSS, SQL Server 2000, and third party ASP.NET Server Controls Dundas Chart and Gauge controls .
• Coordinated with Business and Systems Analysts to gather requirements and furnish specifications for data warehouse extraction.

Confidential

• o Located classroom and laboratory facilities available through county government. Proposed multiple Microsoft .Net MCSD Certification courses to the local technical community and promoted these by speaking at professional organizations and relevant industry gatherings and conferences. Facilitated the official offering of this course work and promoted it to full capacity enrollment.
• o Researched technical topics relevant to emerging trends in local Information Technology shops and secured the collaboration of a qualified trainer expert in these topics.
• Training Facilitator: Conceived, initiated, organized, promoted and facilitated high quality, low cost Microsoft .Net technical training for the technical community of the North Carolina Triangle.
• Analyst and Software Developer: re-architecting and re-writing of VB.NET application to Object Oriented standards for scalability and extensibility. Coding application using VB/ADO.NET, XML, and SQL.

Confidential

• Second tier support, analysis, code fixing, and enhancements ASP.NET, C , SQL Server Reporting Services Visual Studio 2005 , T-SQL.
• Systems Analyst and Developer contracting to NTelos Inc. supporting Wireline telephone provisioning web application written in SQL Server 2000 and ASP.NET.

Confidential

• Authored design documents in Visio and coded solution in T-SQL and DTS packages.
• Analysis, design, and development of SQL Server 2000 based EMR data processes extract-transform transmission per Ohio Medicaid standard .
• Software developer and Analyst for a leading Medicaid provider: Amerigroup Inc.
• Software Developer and Analyst: Conceived, designed, and developed application for Smart Phone mobile devices in C and ADO.NET. Utilized .NET Compact Framework coding to OOP standards

Confidential

• Business Process Analyst and software Developer integrating of ViewStar paperless document management system with existing client server accounting application.
• Interface with user community writing of design and specifications.
• Code enhancements into account payable system in Powerbuilder 8.0 and Oracle PL-SQL 8.i packages.
• Coded system integration ASP.NET, and VB.NET using web services and HTTP interface.