SUMMARY:

• Consulting with Monsanto, made major Genomic switch to GMO (genetically modified), resilient seeds using detailed discovery tools as Bio Perl and BLAST (database Query) and Oracle Cloud 12c VM Developer, SQL Pattern Matching with 12 on massive datasets. Key player in financials (0ver $1 million), grain sales mechanisms, auctions, credit options, Reporting and CME (Chicago Mercantile Exchange) and SEC/SOX Confidential compliance.
• Utilized intense Database, Medical Data Capture and Statistical and Financials Issues using warehousing vehicles to stabilize contract critical platforms for current and strategic direction allowing many additional contract wins over competitors.
• Earned sole Administrator/Developer of Oracle Database of Medicare - Medicaid Claims Processing after system failure. Identified data issues, fixed problems and had Medicare data delivered to Washington D.C. just within SLA contract requirements - incurring no penalties on $100 Million Account.
• After diligent reorganization efforts, managed 4000 acre Agriscience- Business to stability using financial audits and Excel Add-ons to clarify what-if issues and comparing financial data and sales with financial consultants such as Edward D. Jones
• Determined break points in Health Care Claims - Medicare and Medicaid-ICD 9 and Pharmaceutical (LIMS), Controlled Confidential Pharmaceuticals Data Sets and Pre-Clinical to Clinical Study conclusions to successful FDA Drug Submission.
• At HP Enterprise Systems successfully restored cornerstone Blue Cross Blue Shield of Mass Medicare-Medicaid data warehouse by program modifications during significant crisis effecting Account Contract worth $100 Million over 10 years Contract. This accomplishment earned me sole developer for major Medicare - Medicaid database/warehouse including statistical models (regression, multivariate) on medical procedures.
• Also at HMO Blue - BCBS (Blue Cross Blue Shield) of MA was Key Database Person in opening new Medical Center- Pharmacy breaking new ground and money maker for Insurer.
• Used and developed database software with database software to show GMO (genetically modified) products eliminated many pesticides. Used BioPerl software to identify sequences where gene was modified to enhance growth-yield and financials. Used NCBI tools, to understand related genomic Issues.
• Stopped unnecessary programmatic changes to 401k Retirement database at The Hartford, eliminating unnecessary programming to speed up running time for business side. Clear Audit of Employer and employee contributions using business program rules.

CORE COMPETENCIES:

Business Competencies: Persistent, project and problem solver, quality conscious and multi - disciplined in several business and technical areas. A point person, "End Game" in my Agribusiness, Financials, Agriscience, Health-Medical, Pharmaceutical Science including Major Drug Submissions for FDA submissions for drugs for Confidential Pharmaceuticals. Merged knowledge in Biotech to both Agriscience and Pharmaceuticals.

Technical Competencies: Intense use of massive databases for AWS HPC Oracle Cloud Developer 12c, BIEE, SQL-Server (Clinical), Statistics, Identified data trends to business to company levels using HPC visual tools. Intense user of NCBI Population Genomics (National Center for Biological Information) of genomic data annotation and sequencing alignment in nucleotide and protein sequence - DNA (tRNA or rRNA) - to understand molecular combinations that work in target therapies. Doing this jumpstarted the the Drug Discovery and Agriscience process to successful actionable work.

SOFTWARE TOOLS:

• Oracle Databases, 12C Cloud Pattern Matching/Perl, MDM, Master Data Management PL/SQL, Bioinformatics, BLAST, Genomic Sequencing-NCBI (National Center for Biological Information). TOAD for Oracle- data management.

• Cloud Based SAS Studio, Oracle 12c, DW- Star, Cognos, R
• Data Design-Normalization, Metadata, RDMS Database, Oracle, SQL, SQL Management Studio, T-SQL Query Performance, Crystal Decisions, Normalization, Data Structures, Triggers, Stored Procedures, Constraints, Indexing, Query Performance, ETL, 'Packages'.
• JAVA, .NET-Visual Studio, C#, Bio Perl, .JS, XML
• Open Source- API’s, JSON
• HIPPA, GCP, CFR Regulations, SOX.
• Project Management Tools: SDLC, UML, ER Diagrams, Use Case, TOAD
• Agile Scrum Management tools in Agriscience.
• Database Management and Architecture
• Use of Oracle 11g in many business enterprise markets, including Oracle Clinical
• Setup of new systems for Bioinformatics, Molecular Biology, and Biologics, BLAST (DNA Query Tool)

CAREER PROGESSION:

Business Agri-science Management

Confidential

Responsibilities:

• Managed 4000 Acre Agricultural Business ( Confidential ) and modernized with Confidential .
• Used BI, SAS Enterpris12.X, Java and Oracle (SQL Server - SSRS) for identifying yield and financial trends in Dashboards, Multivariate (MVA) for modeling and statistical issues.
• Assisted Monsanto in St. Louis on Cloud Computing Data Issues, various switchovers to genetically modified seeds-hybrid seed issues on multi-million dollar Agribusiness; Realigned complex financials using Excel/SAS showing accurate financial snapshots, Income Statements, A/P, A/R, Capital and Cash Flow; projecting oil yields on leases.

Confidential

Database and Statistical Analyst

Responsibilities:

• Extensive review and audit of 401(k) and 529 College Savings Plans to determine if employee and employer were meeting contribution obligations.
• Aligned 401(k) with less risk funds and worked with Confidential brokers to bring about a stable growth vs. high risk and fee approach. 401(k) evaluated to $185 million with steady growth.

Confidential, MA

Project manager

Responsibilities:

• Engineered data warehouse for statewide Medicare A & B reimbursement, crossover claims, and fee-for-service, meeting SLA contracts, avoiding financial penalties, sustaining medical, technical, and referential integrity (HIPPA, GCP).

Confidential, Groton, CT

Responsibilities:

• Program customization, from paper to Web (Java, HTML) for compounds and their therapies for research implementation for future Clinical Trials saving time and millions of dollars.
• Used statistical models to analyze biological data. ‘End Game’, time critical programming on successful drug submission to FDA by Confidential .