Daniel Donovan Email & Phone Number

Seattle, Wa, Us

Washington, Dc, Us

Key Responsibilities:• Designed and implemented user-friendly web interfaces for research tools, enhancing accessibility and usability for team members using Flask.• Designed and implemented database systems from the ground up using PostgreSQL, incorporating best practices for data modeling and schema design.• Orchestrated the deployment of an AWS RDS PostgreSQL database, configuring instance specifications, storage, and network settings.• Optimized database structures for improved performance, resulting in faster query execution and enhanced overall system efficiency.• Engineered and executed serverless ETL pipelines on AWS, leveraging services such as AWS Lambda, Step Functions, Batch,and S3 to streamline data processing workflows.• Optimized serverless ETL pipelines for performance and cost-effectiveness, continuously monitoring and fine-tuning resource allocation.• Implemented error handling and logging mechanisms in ETL processes to ensure the traceability and auditability of data processing activities.• Automated the creation of Docker images as part of the CI/CD pipeline, ensuring consistency and reproducibility in the deployment process.• Integrated GitHub Actions with Amazon ECR to seamlessly push and store Docker images within the AWS-managed container registry.• Prepared and organized data for bulk loading into PostgreSQL, ensuring compatibility with the target database schema and structure.• Configured AWS Glue as the ETL (Extract, Transform, Load) service for data processing and loading tasks.•Utilized SQLAlchemy framework and Alembic as the database migration tool to manage schema changes.• Integrated database migrations with version control systems, tracking changes to the database schema and automating upgrades with GitHub actions.

Reno, Nevada, Us

Key Responsibilities:• Orchestrated end-to-end genomics workflows, including data pre-processing, alignment, variant calling, and post-analysis steps using Nextflow's scripting language.• Implemented a robust version control strategy for Nextflow workflows, utilizing Git and GitHub, to track changes and collaborate effectively with team members.• Established CI/CD pipelines using GitHub Actions to automate the testing and deployment of Nextflow workflows, ensuring reliability and reproducibility.• Designed and created Docker images tailored for genomics processing applications, ensuring reproducibility and consistency across different computing environments.• Employed best practices in Dockerfile creation to optimize image size, minimize dependencies, and enhance the efficiency of genomics workflows.• Designed and implemented end-to-end workflows within Nextflow for processing amplicon sequences, including data pre-processing, denoising, and variant calling.• Engineered serverless applications for seamless and efficient downloading of genomics studies from the European Genome-phenome Archive (ECI).• Integrated AWS services such as EC2, EBS, and GPU instances to create a comprehensive computing environment on ECS suitable for large-scale genomic data analysis.• Utilized Terraform to define, provision, and manage the infrastructure as code, ensuring consistency, repeatability, and scalability in the deployment process.• Utilized the Seqera Platform to orchestrate and manage the execution of Nextflow workflows, providing a centralized environment for workflow monitoring and control.

Washington, Dc, Us

Key Responsibilies:• Collaborated with technology teams to understand the business meaning of data, provided analysis and requirements ensuring that data design is fully understood.• Managed the developing, supporting, and maintaining the ETL processes using Python.• Enhanced and ensured the maintenance of knowledge of data available from upstream sources and data within various platforms.• Designed custom web scrapper for accessing FPDS.gov ATOM backend web feed.• Oversaw the development and maintenance of PostgreSQL database on Amazon Web services RDS instance.• Created web scrapping tool for SAM.gov that accesses their public API.• Developed internal web-based analytics platform using Flask web framework and hosted on Heroku.• Defined mappings for Elasticsearch indices, specifying data types and settings to optimize search functionality.• Implemented data ingestion processes to index data into Elasticsearch, utilizing various methods such as bulk indexing, API ingestion, or integration with other data sources.• Design and implement RESTful API endpoints for faceted search using Elasticsearch, providing a seamless and efficient user experience.

Charlotte, Nc, Us

• Closely monitor and supervise daily operations ensuring quality of produced work.• Enter User stories into Jira and participate in software planning sessions.• Develop dashboard solutions to existing clients using python and MS Azure stack.• Conduct statistical analyses to leverage the results to drive brand decision making and survey development. Key Achievements• Spearhead the implementation of account strategy by proactively working with clients to identify their business objectives, priorities and directions, critical success factors. • Develop a Fair Value Options Pricing model to facilitate stock options grants to Senior Executives.• Design and build a Cash Flow model that projects the expected cash flows of a home loan portfolio, accounting for loan prepayments and defaults.• Develop a project that used identity potential conflicts of interest around the SEC Auditor Independence Rules, an entity recognition matching solution for matching existing clients with internal and external data sources.

Greensboro, North Carolina, Us

Duties• Developed databases and reports to support pricing adequacy, incorporating data on market trends, risk characteristics, and product performance.• Analyzed data using SAS and Python to identify insights related to new products, features, and market segments.• Developed predictive models using SAS and NumPy to forecast the runoff of the company's in-force business.• Utilized historical data and statistical techniques to identify patterns and trends influencing runoff behavior.• Designed and implemented database structures to efficiently store and retrieve data for analysis purposes.• Generated reports and dashboards to visualize key performance metrics and trends, aiding decision-making processes.• Collaborated with cross-functional teams to understand business requirements and translate them into actionable data solutions.• Conducted thorough data validation and quality checks to ensure accuracy and reliability of reports and analysesSkills:• Proficient in SAS, Pandas, and NumPy for statistical analysis, modeling, and data manipulation.• Strong understanding of predictive modeling techniques and their application in strategic planning and budgeting.• Experienced in working with large datasets and extracting meaningful insights to drive business decisions.• Created interactive dashboards using Jupyter notebooks and Qlikview

Walnut Creek, Ca, Us

• Designed and developed databases to efficiently store and manage company data, ensuring optimal performance and data integrity.• Wrote PL/SQL stored procedures and functions to automate data processing tasks and enforce business rules within the database.• Utilized SQL queries to prepare custom data sets tailored for statistical modeling in R, extracting relevant data from various database tables and sources.• Conducted performance tuning and optimization of SQL queries and stored procedures to improve database efficiency and responsiveness.• Actively participated in database design discussions and code reviews to ensure best practices and maintainability of database solutions.• Designed and built custom ad hoc reporting solutions using Crystal Reports to meet specific business requirements and stakeholder needs.• Developed Python-based ETL (Extract, Transform, Load) pipelines to automate data extraction, transformation, and loading processes.

Bachelor Of Science - Bs, Mathematics

B.S., Computer Science