Resume
Enterprise Architect Windsor, CT
SUMMARY
- Enterprise Architecture, Solution Architecture, Project Management, Road Map Planning, Business Capability Matrix, Presenting to Program Management Office and Architectural Review Board, Leading Technical teams, Managing Release Trains using SAFE Agile methodologies, Leading JAD Sessions, Running Daily Scrums, Release Management, Continuous Integration, AWS, S3 Storage, NodeJS, Azure Cloud, Web, Mobile, Analytics, Big Data. Machine Learning, GuideWire, Accord, Jenkins, Azure.
TECHNICAL SKILLS
API/Web/Mobile/Big Data: Microservices, MVVM, API Management, RIA, RWD, HTML5, Canvas, JavaScript, MVC4, KineticJS, Multi - Tenancy, KnockoutJS, Prototype, JSON, XML, ASPX, PHP, JSP, AJAX, Web Sockets & Workers, DOM, Smart-Callbacks, Service Intelligence, .Net, Java, SaaS, SFDC, Android SDK, Custom Plugins, SOAP, REST, Cloud, Google Voice&Maps, JQuery, Display & Elastic Services, Cloudera, Hortonworks, MongoDB.
Analytics/BI/MDM: SAS 9.4,SQL Server MDM, Sparks, Splunk, Flume, Tealeaf, Hive,D3JS, KineticJS, ThreeJS, Google Charts, Tableau, Sparks, Scala, Python,BI Interactive In-Memory Dashboards, Cube Space, Calculation Context, Tuples, CrossJoin, RTM, Hierarchies, Data Science, Statistics, Smart Callbacks, Incrementals, Omniture Administrator, Omniture Web Services API, offline data integration, Site Catalyst, A/B Testing, Props, Evars, Events, Conversions, Fallout, ROI, KPI, SLA, Small-Data, Advanced Analytics, in-stream change data capture, nosql, Test Plans, Test scripts, Regressions, data quality, web/mobile usage, built-in security heuristics, Coremetrics, Server Side to SaaS Data Capture, Log & Analytics Dependency Injection, SSH Data Capture, Aggregation Service, SAS BI, REST OData, Binary Data Streaming MTOM.
PROFESSIONAL EXPERIENCE
Enterprise Architect
Confidential, Windsor CT
Responsibilities:
- Responsible for setting up a Secure Network based on US/GC status by providing network diagrams, security reference architecture as well as VM Host and Guest infrastructure to support 80 person development team to support our partners in Java, .Net, Jenkins, JIRASQL Server, Oracle, SharePoint, Network Services as well as Program Services for Client Mangers to view real time dashboards to
- Project timelines, deliverables, alerts, burn rates, code coverage, and defect ratios.
- Designed high level overview of a Data Ingestion and Data Processing Scalability which mapped Non Functional Requirement Categories and Taxonomy to plan for VLDB (10 Petabytes over 5 years) for 5000 daily commercial flights with 12 second processing time using a Kafka, Sparks Hadoop system. Provided detailed non-functional scenarios and requirements including by approaching the architecture from a utility perspective which gives simple examples of what is needed and required for ease of understanding as well as the ability to link abstract concepts to concrete examples using scenarios that will create information that is measurable through architecture analysis
- Created PoC for 3D scatter plot to shim up web player api in Tibco Spitfire reports using Azure Cloud and NodeJS on Ubuntu server which exposed a data rest api for Plotly JS for visualization of frequency values in a 3D values of materials in confidentials,.
- Created a Road map and proof of concept for global api management for fleet care and preventative maintenance using Tibco Integration Cloud as well as confidential using REST API without code where it was all based-on configuration and integration interfaces.
- Migrated 8 development teams move from manual deployment to CI environment using Jenkins, SVN and ERA code analysis and leader board management systems for real time metrics of violation density and code coverage after code commits.
- Responsible for Road Map development and Governance Framework for IT and Operations. Provide guidance and strategy for application, data, mobile, platform architectures including leveraging API management to minimize system and code divergence.
- Designed Aircraft ingestion and alerting system for Commercial Airline engines. Designed machine learning systems for document classification using Bayesian and Neural Network patterns.
- Redesigned B2B engine maintenance content management and portal system for self service Leading Enterprise alignment of technology and business capabilities of 10 concurrent projects using Enterprise Unified Process methodology.
Enterprise Data/SOA/Integration/MDM Architect
Confidential, Hartford, CT
Responsibilities:
- Designed, Created and Implemented a HTML5 Data Steward Client using Model-View-View-Model (MVVM) pattern leveraging 2-way data binding to support operations in disconnect mode to analyze and submit OLTP Merge and Split Transactions based on Customer, Policy and Location SOAP and REST Services using a MDS JavaScript API and leveraging HTML5 number controls with built in input validation as well as native xhr-ajax interfaces to dedicated worker objects for asynchronous parallel threads. Also, Implemented MSMQ server and client to align SAP DQ cleansing, split and merge transactions. Applications functions in UI API interface leveraging Microservices endpoints supported by NodeJS.
- Designed Data Lake process for file intake to leverage Hortonworks Data Flow, Metadata, SSH and HDFS.
- Configured SAS 9.4 Stored Process and Workspace servers to logical partition data science teams and SAS data management using GDG and replication with SQL Server 2014.
- Led Project team using AGILE Methodologies using weekly sprints, weekly demo, weekly backlog grooming and retrospective and tracking bugs and issues.
- Designed, Created and Implemented a Canonical Data Model aligned with ACCORD standards to minimize integration and messaging scope of work for ease of development for the Enterprise. Supported and led SSIS Development, SAP DQ team using, DQ jobs, SQL and DB Engine optimization including using Entity Framework to build physical data model.
- Led, Designed and Configured 12 Windows Servers to support Enterprise Services and Integration with 3 environments. Web Proxy tier, REST tier, SOAP tier, MSMQ/Windows Services tier, SAS tier, SQL Server tier using C#, SAS, Web Hooks, HTML5, JQuery, JavaScript, Dependency Injection, WCF, SOAP, XML, JSON, OData, Entity Framework 6, Windows Services, Task Operations, MQMQ, in Memory Data Table, Bulk Loading and Process Monitoring via Management Windows Services.
- Presented and Designed a TPO/PMO a video animation as well as screen recording of a MDS Data Seward UI using Blender3D, Windows Movie Maker to highlight the importance of data intake, data cleansing and MDM with use case analysis with narration for a business presentation to facilitate question and answers for Data & Analytics.
- Led, Designed, Implemented and Deployed Location Risk Modeling Rate Service using WCF, Entity Framework 6, Odata, SAS Web Services and SQL Server 2012 to support an excel based web consumption rate calculator for existing and new treaty customers for HSB Products. Collaborated with Data Science and Actuarial Services to expose the functionality in future state by leveraging a Risk Message Model for B2B operations and value added capabilities.
- Led, Designed, Implemented and Deployed a Web Service enabled MDM platform for Customer, Policy, Location, Address and Contact Entities to support Pricing and Underwriting. Existing Treaty and new Treaty Profile input service via SAS SOAP Stored Process Server.
- Led, Designed, Implemented and Deployed a Web Service enabled Sensor Intake System for Church Mutual Sensor data for real time analysis of boilers, ambient temperature and vibration sensors for Engineering and Inspection Team to diagnosis and prevent future losses and claim with a maintenance alerting system.
- Led, created and started the Data Analytics Program using best practices in Pattern Oriented Analysis and Design in leveraging Service Oriented Architecture in a Gateway SOA Platform. Designed a Master Data SQLServer Model and MDM Solution to work within the SOA design using the .NET MDM API.
- Created, Designed, Implemented and Coded a UI Injected Display Service with Windows Authentication, HTML5, SOA n-tier Analytics Platform in C#, SAS, OData Provider, Web Reverse Proxy, WCF REST, WCF SOAP, ADO In-Memory Filter of 1.2 million records with 500ms response times using Windows TCP Services, Lost Cost JavaScript Data API for Underwriters and Statisticians collaborate on risk model development and real time deployment.
- Designer of a real-time Data Warehouse Architecture that leverages services and operational data sources to emulate an operational data fabric to support Risk Analysis, Modeling and Master Data Management.
- Responsible for design and implementation of a canonical data model and message schema for an Enterprise Service Bus for an SOA enabled data fabric of in-memory stores and services.
- Digital architecture design and support of Transformation program to move operations into next generation of heuristics and machine learning using ESB and client services in a reverse proxy pattern.
- SAP Data Services, Data Steward, Meta Data Management, Canonical Data Modeling, Data Quality, Data Profiling, Dependency Injection, and Fine Grain Data Interception for Data Security Redaction, REST to SOAP Gateway patterns, SAS BI and .Net Integration using Proxy design patterns for real time modeling for non-Analytic Users.
- SQL Server MDM, In-Memory, Indexed Views, SMO API Data Management Services, Dynamic DDL, DML, Open Data Framework (OData) WCF Data Services for ESB Integration Services.
- HSB Client Data API, SQL Server and Hadoop Integration for Data Lake data routing within a Data Capture and Intake Framework for ILM. Logging and Traceability within an Enterprise Service Bus Warm Data Framework.
Solution Architect
Confidential, Hartford, CT
Responsibilities:
- Lead, create and start a Governance Board to monitor and oversee an Enterprise and Finance model to manage capabilities in SOA and Big Data such as MapR, Hortonworks and Marklogic. Lead Architect to create an Enterprise Billing platform using an Integration Gateway with Layer 7 API Management and elastic services for dynamic runtime application and port allocation systems to enhance security within internal and external trading partners using Mulesoft ESB and IBM Integration Service Bus v9.0.
- Leader in using POAD (Pattern Oriented Analysis and Design) in creating our own or leveraging Reactive Libraries containing observer, subscriber, and mapper as factory methods for data transformation interfaces to accommodate different financial interfaces in a Gateway SOA as our Operating Model.
- Project management, estimation, work breakdown and cost analysis using sequence diagrams to segment work by vertical systems and interaction points as well as object life cycle vector analysis.
- Author of Finance Client API for an Enterprise Consumer Generic Interfaces for an Oracle Billing Platform via a Finance SOA Gateway.
eBusiness (Web/Mobile/BigData) Architect
Confidential, Hartford, CT
Responsibilities:
- Lead efforts within the Enterprise Architectural Committee to present Architectural Definition Document and Architectural Roadmap for Confidential .com to re-architect and support routing, filter, security interceptors, caching, including rewrite of url, header and response body to support reverse proxy pattern for enhanced business capabilities as well as Transition Architecture to move to a digital gateway for all devices.
- Architect and designer of Renewal Digital Campaign System integrated with 3rd party SaaS consuming internal aggregated data store for a digital system of record for all assets including content management system with a custom filter context router for referential integrity.
- Member of the Big Data Governance Board to evaluate Enterprise Capabilities to support data initiatives and leverage latest technologies including Hadoop, Pig, Oozie, Hue, Sparks, Flume, No-SQL, Nutch, Fuse, Cassandra, MongoDB and Hitachi Content Systems.
- Web Architect for Confidential .com to support content management, custom markup, responsive design, personalization by implementing a distributed and horizontal scaling architecture to support an n-tier framework.
- Heuristics, Service Intelligence, Service Relay, and Small-Data Design patterns for enhanced security and highly interactive push systems.
- Live Site, Team Site, Interwoven, content management, solution architecture for .Net and dynamic content, multivariate and A/B Testing.
- Designed Custom Crawler for SEO and Web Analytics Tag management with daily analytics for SEO and Tagless pages storing in No-SQL, Hadoop, Pig, Oozie and Fuse environment.
- Tealeaf installation and configuration on Mobile Bundle One with customization of AngularJS and Web proxy including network tap capture of http filtering for mobile bill pay and replay.
- Architecture, Planning, Server Procurement, Vendor Evaluation, Product Evaluation, ROI, Technology Road Map, Big Data Strategy, Social Data Integration, Real Time Market/Social Influence Alerts, Coremetric, Hadoop, Map Reduce, HDFS, Hive, Pig, NoSQL, 600 TB 30 Data Node Apache No-SQL Hadoop Cloudera Cluster, SSH, No-SQL, Piping and Cloudera Hadoop OBDC, including Pig, Oozie, Fuse and Hue.
Consultant, SQL/BI/MDM Architect
Confidential, Farmington, CT
Responsibilities:
- MDM, DWH, BI Solutions for ConnecticutCare Data Management Group.
- Design, build and maintain end to end DWH, BI. Mobile Web solutions using Json NoSQL design pattern to remove sql injection and other security threats. Architect and Designer of MDM Service Framework for robust data meta repositories, meta data crawler, data profiling and data stewardship. Author of a Business Intelligence Javascript Framework for HTML5 Analytics, Dashboard and Reporting system with machine learning. Author of small data framework for near real time web and mobile analytics.
Senior Manager, Web Architect
Confidential, Glastonbury, CT
Responsibilities:
- Providing Solutions and APIs in Business Intelligence, Enterprise Data Warehouse, Master Data Management, Data Delivery, Service Oriented Architecture, Mobile Dashboards, Web Applications, Web Analytics, Social Media, Big Data, Software Architecture, QA Testing, QA Test Plans, QA Scripts, and QA Repositories including Emerging Technologies. Lead team of architects defining and creating Web, BI and Data architecture including source to target artifacts. Solution Architect for Customer Reporting and Analytics Project for Unum in Portland Maine.
- Designed Web BI Dashboard integrated with Cognos Services for in-memory acceleration using façade and Proxy design patterns. Author of JS framework with built-in web analytics methods with properties that allow for confidential and Custom Repositories within a rich client to capture micro and macro events including pointer listeners for interactive and responsive web context help and machine learning. Informatica Mapping, Workflow, Data Profiling, Meta Data Manager, BOM, LDM, PDM Designs. Providing Web Design, Architecture and Analytics, integrated with Cognos BI Mashup and SDK in a Multi-Tenant/SaaS environment. Advanced Web Analytics for user experience reporting and analysis. Providing solution design of a Custom web framework extending custom widgets and robust callback methods including powerful web analytics capabilities including HTML5, Kinetics and ThreeJS. Framework architect for a RCG UXJS API with 30 plus classes using JSON, Websockets, Web Workers and AJAX for maximum flexibility and lightweight data exchange using HTTP, UDP, TCP as well as Google voice and Google maps for heat/clustering map reporting and analytics.
- Lead JAD sessions with key stakeholders for requirements gathering as well as produced Solution Design Document, Sequence and Class Diagrams as well as Enterprise Reference Architecture for external facing web systems integrated with existing systems. Provided current state verses future state road map for web and mobile technologies. Provided assessment of current state architecture and design of their web systems and aligned solutions to Enterprise Architecture. Mentored and lead team of architects and developers in best practices and approaches for end to end delivery.
Enterprise Solution Architect
Confidential, White Plains, NY
Responsibilities:
- Provides IT knowledge and architecture for data, web, mobile, applications for enterprise solutions. Created new Solutions development processes as well as new custom software solutions that enable collaboration, data mining, artifact generation, project management, data quality and enterprise search and reports of meta data repositories. Created Enterprise Solutions for data management, Business Intelligence, Web and Android development within a Services Oriented Architecture. Informatica Mapping, Workflow and Data Profiling.
- Developed new web analytics repository that integrated offline data with online data to give a composite view of multi-channel intersection of business and customer services where sql based reporting and machine based reporting can be utilized effectively with minimal manual processes. Migrated DTS and batch processes to Informatica. Reversed engineered SSIS packages to Informatica workflows for health intervention program. Created EDW QA scripts and tools for testing and development. Created Sequence, Class, Session, Business Diagrams.
- Implemented schema based enterprise data management architecture to extend meta data repositories and application data services and discovery services for enterprise service bus. Implemented Enterprise wide custom Analytic, Proxy and Web Services for applications, web, and android for near real time Enterprise Dashboards integrated with Google Charts and Maps.
- Author of new Enterprise Service Intelligence Framework that uses Analytic and Meta Data repositories to create a next generation smart system that provisions self-diagnosis and alerting capabilities throughout the Enterprise. Author of a Meta Data, Normalization configuration files using an auto loader ETL process for Landing, Staging to Operational Data Store using Sql Bulk copy method that improved efficiency over 500% from current processes using VB.net and Windows Services.
BI/Web Analytics Architect
Confidential, Gold River, CA
Responsibilities:
- Provides business solutions for enterprise architecture, integration, and data, BI, Analytics and Decision Support. Also, Responsible for Web Analytics, Omniture Data Architecture, Design of Web, Application and Middle confidential systems for Enterprise web applications. Member, Provider, Broker and Employer portal design including claims, eligibility, authorizations, utilization and medical management. Application level Database design, target to source data mapping from legacy systems including mapping web services via enterprise service bus and b2b solutions and APIs. BI and ETL installation and architectural implementation & design including data and reporting services integrated with web performance tracking and click stream.
- Provides Mobile BI Dashboard solutions using high attribute xml for specialized soap messaging capabilities for peer to peer sharing and consuming Enterprise BI web Services.
- Master Data using Data Integration, Data Profiling and Data Governance of Enterprise Projects including designing data structures to adhere to domain models to synchronizes domain types, regular expression patterns, dependent data elements, redundancy, nulls, cardinality including full schema, catalog and table analysis to support enterprise data services and shared databases.
- SQL Server Management Studio, Report Server and Service Broker, Snapshots, Database Mail, and Visual Studio 2008, Analysis Services, Integration Services, Report Model for BI Analytics support for internal business stakeholders including sales and marketing to determine target markets and market penetration by demographics. Created server side .net components including an object model to support analytics and reporting to be reused by development.
- Design and maintain logical, physical data models to support SDLC including working with local and offshore teams. Enterprise Domain Models, use case, waterfall and agile, scrum methodologies in a J2EE, struts, hibernate, spring, abatis framework including data & web services to delegated medical groups.
- Designed and created Flex3 Flash application for rate region polygons and mash maps for sales and marketing correlated with operational data for interactive dashboards integrated with Google Maps for runtime markups and geographic panning and zoom including medical group radius mapping for quick physician lookups and alignment of capitatation requirements.
- Created and designed omniture enterprise architecture that includes custom omniture proxy http java servers as a load distributed round robin asynchronous manager for enterprise analytics with flexible and dynamic report suite and prop/evar/events including web and application servers in near real-time operational merged web saas environment. Framework is extensible to include enterprise wide analytics of all internal systems correlated with operational data exposed for cross system analysis including .Net Enterprise Analytics management tool to manage web services, proxy services, listeners and rpc managers to maintain cohesion to produce near real-time interactive dashboards and reports for decision support.
- Robust QA tools are available for managers and analysts to create scenarios and store into a repository for instant reports which bypasses the need for logging into site catalyst and manually create traceability reports. The repository gives instant access to project managers and give detail updates and email notifications of web analytic measurement bugs and inconsistencies at the enterprise level which includes Screen Recording, Sound Capturing for voice notations, Screenshots, Excel reports tagged with QA Analyst ID and Scenario ID meta tags for easy traceability and cross referencing to minimize duplication.
- The solution provides correlation and covariance matrix capabilities for business intelligence and decision support solutions supported by rank correlation, binominal models to identify ROI, Business Case which reduces the need for large transfers of data and identifies metrics at the point of distributed data contacts among disparate data streams for quick up to date targeted measurements for executive management.
Solutions Architect
Confidential, San Francisco, CA
Responsibilities:
- Responsible for Data integration strategy and management layer for DB2, Oracle, SQL Server and mainframe processes. Design and implement business intelligence solutions for current financial and brokerage systems. Implement DB2 Information Integrator using data federation to transparently access diverse business data from a variety of sources and platforms and Planview PMMigrate current infrastructure to a next generation solution architecture that couples middle layer with database operations in an open framework for future extensibility and create an abstraction to manage current systems.
- Support, Maintain and Upgrade a trading compensation system for Private Banking brokers and financial consultants at a retail and brokerage level.
Data Warehouse Architect
Confidential, New York, NY
Responsibilities:
- Responsible for design and implementation of the next generation of business intelligence solutions including advanced data warehouse design based on object oriented schema based on a domain life cycle architecture. Implemented and deployed windows 2003 servers. Installed and configured, Test Director, SAP, SAS, IIS, FTP, SMTP, Qlikview, Business Objects, Oracle Discoverer 10g, and Crystal Reports 11. Created a robust and interoperable service oriented architecture and various enterprise api’s using Visual Studio .Net. Including Data Modeling with confidenti and Data Profiling.
- Designed an enterprise schema of schemas to emulate the object-oriented architecture to loosely couple objects and databases for maximum flexibility.
- Designed and implemented SAS Web Proxy server to work with stored process and workspace servers to extend sas services via web services. Saved Confidential IT approximately 200k in SAS Mainframe licensing fees on their OS390 IBM systems. Responsible to mentor and supervise 2 technical direct reports. System enhancement and design for National Provider Identifier. Support Hyperion, Integration Services building ETL processes, OLAP cubes, dynamic DDL and Oracle Warehouse Builder.
- Migrated an entire OS390 SAS reporting system to 2-terabyte windows 2003 server in 4 months using Oracle and DB2 Connect and eliminated cumbersome ftp and sql loader process and directed streamed data from DB2 to Oracle using SAS and Perl. Reduced entire ETL process from 3 days to 3 hours using multi-threading data streaming from DB2 to Oracle using dynamic DDL generation.
- Designed a next generation data warehouse architecture that emulates object relational design without high overhead of integration and broker services using an interoperable framework. Using this framework, I have designed Business Models, ETL- Web Services and System Architecture for Enterprise Data Warehouse and Business Intelligence Reporting Systems of Clinical Information Management.
Solutions Architect
Confidential, Norwood, NY
Responsibilities:
- President and owner of Confidential . Responsible for implementation of Enterprise Solutions for technology and health care companies.
- Consultant, NY Dept. of Mental Health, Albany, NY: Responsible for design and architecture of web services for data information delivery of clinical health data to health care facilities to help in treatment and care of new and continuing patients. Developed Oracle portal and Graphing applications using web services.
- Consultant, CIGNA Healthcare, Hartford, CT: Responsible for design, architecture and management of new framework to unify data and applications through existing infrastructure using .net, including database design, class patterns, process management and document construction using .net 2005, .net 2003, VSTO, MS Office 2003, Crystal Reports 10, SAS 9.13, MVS/TSO, DB2, SQL Server and SAS Business Intelligence.
- Consultant, Bristol-Meyers Squib, Princeton, NJ: Responsible to transition Fleet Management System from Information Management to Accenture offshore team. Design, enhancement of current infrastructure using SAP, SAS/Unix, VB5, Crystal 7.5, AS/400 for interim support and architectural system design and development.
Consultant
Confidential, Alameda, CA
Responsibilities:
- Responsible for EDI process and development. Implement 837 HIPPA compliant claims submission format for confidential. Create custom components in Visual Basic, Crystal Reports and ECGateway. Developed applications in VB.Net, C#, VB6, custom business objects for shared libraries and MTS. Created web applications for claims examiners for adjudication using .Net, DOM, DHTML, JavaScript, Visio, Framework Design, UML Diagrams, Visual SourceSafe, B2B Integration with trading partners. SQL Server, Stored Procedures for web based reporting. Created web applications using ADO.NET, DOM, DHTML, and Vb.Net custom DLL’s. Developed File Maid, .NET win systray app to cleanup large directories.
Data Consultant, Software Engineer
Confidential, Oakland, CA
Responsibilities:
- Responsible for development of architecture, design specifications, implementation and testing of a reporting engine client integrating NPS and Crystal Reports 10. Create custom components for server and client including integrating Crystal Enterprise 10 and J2EE in compliance with an open source distributed object model. Providing architectural, interface design and coding leadership with 4 other developers in compliance with KP standards and within a business user customized Pricing object model framework for underwriting, sales/marketing and senior management. Developed complex loosely linked subreports. On MVS/TSO, authored SAS JCL beans. Using VB.net created custom components using an xml, soap and SDL, SDLC, UML. Created a web based document construction application using SQL Server, Oracle, DB2, UDB, and Teradata where DSN dynamically changes at runtime. Enterprise Data Modeling with Erwin.
Systems Analyst:
Confidential, San Francisco, CA
Responsibilities:
- Developed client application to integrate claims system, capitated providers for reporting in the Actuarial Department. Supported data extraction from a Unix/Oracle box for client business logic layer.
Project Manager, Systems Analyst
Confidential, San Francisco, CA
Responsibilities:
- Developed XML applications, ASP applications, Visual Basic applications, Unix scripts, JavaScript, VB scripts, FTP processes, server side scripts, Web applications. Responsible to manage projects and design web and database applications applied to marketing strategy. Worked in Database Marketing in marketing campaigns and market research. Providing leadership up to 5 developers. Using DOM, Xpath and Visual Basic- developed multi-platform XML conversion process for Brokers, Strategic Marketing and Asset Management.
Senior Contractor
Confidential, San Francisco, CA
Responsibilities:
- Developer/Analyst. Responsible to design and create SAS-Visual basic applications, Access Databases and integrate Unix and Windows NT platforms using SQL, PL/SQL and TSQL for Oracle and SQL Server.
Healthcare Analyst:
Confidential, San Francisco, CA
Responsibilities:
- Programmer/Analyst using Visual Basic, SAS, SQL, and VMS/VAX to build Financial, Patient and Disease Management databases to report the administration of IDX data including the Healtheon Project - RACER Enterprise System that is designed to use the internet.
Regional Analyst
Confidential, Walnut Creek, CA
Responsibilities:
- Mainframe and applications programming using JCL, SAS, Eztrieve, Rumba scripts to extract and build databases, applications using SQL and Visual Basic for patient and disease management for end users to properly manage costs and utilization trends including membership analysis. Responsible for custom eligibility, claim utilization, provider demographics and multidimensional models for various departments for the Western Region.
Medical Economic Analyst:
Confidential, Concord, CA
Responsibilities:
- Statistics, programming, research methodology, aggregate claims data and utilization trends. Extensive ability to program using Quiz, QTP, Focus, SAS, Reflection Basic on a Digital UNIX Oracle platform. Working knowledge of medical utilization analysis, regressions, probability distribution functions, descriptive statistics, PMPM analysis, claims modeling and QA of data. Responsible for ad hoc and medical management reports to support medical negotiations and physician report requests including HEDIS and NCQA measures.
Medical Claims Examiner
Confidential, Concord, CA
Responsibilities:
- Claims Adjudication of Medical, Dental and Vision for PPO, HMO, Indemnity and self-funded plans. Responsible for adjusting claims, customer service, data entry, adjusting accumulators with knowledge in CPT, ICD9 codes. Processed UB92 and HCFA 1500 for various fortune 500 companies with knowledge in Medical terminology in inpatient, outpatient and dental claims.