Modernization Projects – Conversion of legacy systems to Azure Data Lake and Palantir Foundry. Also retooled to include Python, Microsoft VS Code, Windows Terminal, WSL and current versions of SSMS and MS Visual Studio. Legacy System Support – Administration of SQL Server instances, SSRS, SSIS, Power BI and MDS in multiple versions,Administrative Duties – Works help desk tickets involving access and permissions to Power BI apps and Corporate Web Sites. Performs manual month end… Show more Modernization Projects – Conversion of legacy systems to Azure Data Lake and Palantir Foundry. Also retooled to include Python, Microsoft VS Code, Windows Terminal, WSL and current versions of SSMS and MS Visual Studio. Legacy System Support – Administration of SQL Server instances, SSRS, SSIS, Power BI and MDS in multiple versions,Administrative Duties – Works help desk tickets involving access and permissions to Power BI apps and Corporate Web Sites. Performs manual month end processes in support of financial reporting. Monitors exception reporting and error messaging. (SQL Server, Azure, T-SQL, Spark, SSRS, SSIS, MS Management Studio, Oracle, Oracle Developer, PL/SQL, MS Visual Studio Code, XML, MS Access, Python, VBA, PowerShell, C# script tasks) Show less

Covid Python Refactoring – Converted unmanaged combination of Python, Dos batch files, Windows Scheduler and PowerShell scripts into object-oriented Python application. Added logging, error handling, and converted multiple copies of functions into a single re-used class structure. Added database structure to monitor data imports, deduplicate, match with Maven database, and maintain delta history. Retooling – Consolidated code bases to Visual Studio Code from eclipse, programmer’s… Show more Covid Python Refactoring – Converted unmanaged combination of Python, Dos batch files, Windows Scheduler and PowerShell scripts into object-oriented Python application. Added logging, error handling, and converted multiple copies of functions into a single re-used class structure. Added database structure to monitor data imports, deduplicate, match with Maven database, and maintain delta history. Retooling – Consolidated code bases to Visual Studio Code from eclipse, programmer’s workbench etc. Used for python, java, xml/xsd, SQL.Legacy System Maintenance – Developed queries converting Maven back-end Question-Answer representation into formats conducive to specific analytical requirements. Assisted in identifying configuration points and areas where hard coded values could be modified or enhanced. Developed xsl to convert xml to htlm5.Shadow/Backup – Qualtrics, Maven (Syndromic Surveillance), Rhapsody, ArcGIS(SQl Server, T-SQL, MS Management Studio, MS Visual Studio Code, Python, Java, XML, Tomcat, MS Access, VBA, SVN, JIRA) Show less

Data Preservation – Converted unmanaged T-Sql code into SSIS package that implemented transformation of vital records data from raw input to cleansed data to data linked to conformed dimensions and finally to updated representation of production facts and dimensions. Data representation of slowly changing dimensions allowed user to trace and review provenance of data through entire process. Metadata designed and implemented to represent business and data transformation rules to include… Show more Data Preservation – Converted unmanaged T-Sql code into SSIS package that implemented transformation of vital records data from raw input to cleansed data to data linked to conformed dimensions and finally to updated representation of production facts and dimensions. Data representation of slowly changing dimensions allowed user to trace and review provenance of data through entire process. Metadata designed and implemented to represent business and data transformation rules to include cleansing, geographical validations, as well as weighted matching logic to production database facts and dimensions. Stop gap MS Access database augmented to allow for viewing and approval pending completion of web interface. Landing, cleansing, matching, and merging implemented as single turn key application.Vital Records Data Warehouse – Initiated conversion of un normalized birth records into preliminary facts and dimensions. This was designed and implemented as an SSIS package that split single table with large number of columns into a single fact table and multiple logically defined dimensions.(SQl Server, T-SQL, MS Management Studio, SSIS, MS Visual Studio, C#, MS Access, VBA) Show less

Ad Hoc Analysis Environment – ETL process transfers data daily from central data repository to server dedicated to ad hoc analysis. Allowed for tuning customized to requirements of ad hoc analysis. Type two slowly changing dimensions universally applied using auxiliary columns applied to destination table definitions. Driven by meta data representations of tables, primary key definitions and foreign key relationships between tables interacting with data dictionaries of source and… Show more Ad Hoc Analysis Environment – ETL process transfers data daily from central data repository to server dedicated to ad hoc analysis. Allowed for tuning customized to requirements of ad hoc analysis. Type two slowly changing dimensions universally applied using auxiliary columns applied to destination table definitions. Driven by meta data representations of tables, primary key definitions and foreign key relationships between tables interacting with data dictionaries of source and destination data bases. Allows for addition of tables without programmatic changes. Includes a logging system which allows for the detection and correction of execution failures at the table level as well are automated resubmission of failed steps. QA process highlights differences between the adhoc analysis environment and the clinical data repository. Cerner Millenium, vocabularies/ontologies to include CPT, ICD-10, NDC, LOINC,…Study Snapshot- A snapshot of the Ad Hoc analysis environment is extracted for a given study at a point in time. Comma separated value (csv) extracts are generated in a human readable, more de normalized format (vs. integer references). CSV extracts optionally exported into a user friendly MS Access format with relationships between tables enforced, and data dictionary definitions applied. Phase 2-Augmented the ad hoc analysis environment to initiate and allow for ongoing database tuning, and enabled future in-situ processing of studies. (Would limit the need for maintaining separate copies of data per study through references to ad hoc analysis environment). Allowed for flagging and tagging approach for detection of repeating sets as well as for detection of patterns of usage of medical vocabularies and ontologies (SNOMED, ICD10 diagnosis and procedures, CPT …).(Oracle 11g, SQL Developer, PL/SQL, scripts and packages, MS Access, VBA (Excel and Access) Show less

Design, implement and populate relational and multi-dimensional data sources representing financial, patient demographic, health indicators, quality of care, and resource utilization measures. Trending, predictive analysis and fraud detection strategies to be implemented in support of cost containment initiatives. Identify existing and trending technologies to support objectives. Emphasis on reducing labor while increasing transparency of methodology. Implementation of medical data quality… Show more Design, implement and populate relational and multi-dimensional data sources representing financial, patient demographic, health indicators, quality of care, and resource utilization measures. Trending, predictive analysis and fraud detection strategies to be implemented in support of cost containment initiatives. Identify existing and trending technologies to support objectives. Emphasis on reducing labor while increasing transparency of methodology. Implementation of medical data quality metrics to be stream lined through use of meta data, rules, conformed dimensions and repeatable work flows presented in a user friendly way. Show less

Generalist role. Primarily upgrading and expanding analytics and informatics. Also includes support of financial and manufacturing operations. Includes eclectic mix of older and current technologies. Deployed financial reporting system focusing on Accounts Receivable. Developed underlying sql-server database, reporting services reports, subscriptions, user based security. Developed intranet site to facilitate and automate data import to customer centric profit calculation… Show more Generalist role. Primarily upgrading and expanding analytics and informatics. Also includes support of financial and manufacturing operations. Includes eclectic mix of older and current technologies. Deployed financial reporting system focusing on Accounts Receivable. Developed underlying sql-server database, reporting services reports, subscriptions, user based security. Developed intranet site to facilitate and automate data import to customer centric profit calculation system.Developed Integration services ETL package to support migration to new shop floor maintenance system. Show less

Used SSIS to transition data from multiple legacy platforms to SAP input formats. Vendor and Customer data converted to include excel output for domain expert review of slowly changing dimensions. C# script tasks, and excel macros augmented base SSIS functionality.Converted Crystal reports to SSRS reports. Included mapping from legacy/production database schemas to Next generation/to be data model.

Designed and implemented data model to support sql server dental data warehouse. Included anatomical(mouth only) , clinical, physician, patient, and insurance subject areas. Supported class 2 slowly changing dimensions. SSIS used to convert multiple nonstandard data sources to single dental data warehouse structure impemented in Sql-Server. Encoded and applied proprietary rule base to flag potential coding errors.Advised subcontractors in conversion of legacy data to… Show more Designed and implemented data model to support sql server dental data warehouse. Included anatomical(mouth only) , clinical, physician, patient, and insurance subject areas. Supported class 2 slowly changing dimensions. SSIS used to convert multiple nonstandard data sources to single dental data warehouse structure impemented in Sql-Server. Encoded and applied proprietary rule base to flag potential coding errors.Advised subcontractors in conversion of legacy data to Oracle OBIEE model.Ad hoc analysis of client data sources executed to aid in establishing efficacy of treatment. Show less

Advised management as to alternatives to combine many data sources into a single data warehouse structure.Provided support to SSRS report developers.

Developed data marts and cubes summarizing existing data warehouse. Subject areas included patients, physicians, clinical (CPT, ICD...), insurance/financial, employers, and quality assurance (PQRI xml submission). Implemented C# web based dash boards for same.