ADRIANA SOLIS
Dallas-Fort Worth
Summary
Detail-oriented professional with a strong ability to adapt in fast-paced environments. Delivers high-quality results under pressure while fostering effective communication and teamwork. Committed to aligning efforts with company goals and enhancing service delivery. Engaged in continuous learning and development to drive personal and organizational success.
Overview
5
5
years of professional experience
Work History
Data Engineer
Attain Finance
09.2024 - Current
- Designing and optimizing data pipelines to efficiently process large volumes of structured and unstructured data
- Automating data loading and transformation through Airflow DAGs
- Developed complex risk, compliance, and credit reports utilizing advanced SQL queries and stored procedures on Snowflake
- Migrating on-premises big data infrastructure to cloud platforms for improved scalability and cost- efficiency
- Utilizing the cloud-based platform AWS for deploying scalable big-data solutions
- Automating manual processes through scripting with Python to improve efficiency in handling big data tasks
- Facilitated cross-departmental collaboration to successfully execute high-level data migrations and reporting
- Working with AI to help the efficiency of data-based needs by building the first interactive chatbot for the company
Data Analyst/Engineer
Attain Finance
02.2023 - 09.2024
- Constructed complex business intelligence and loan tracking reports with Snowflake, SQL, Streamlit, and Airflow. Maintained data integrity of these reports by building/maintaining data loading and data validation DAGs.
- Migrated and validated big data loading and transformation stored procedures from Microsoft SQL Server to Snowflake, enhancing data processing capabilities.
- Developed a SQL-focused loan history report adhering to the Canadian IRS data format requirements.
- Created compliance reports and data visuals using Sigma to meet regulatory requirements.
- Managed user stories and tasks in Azure DevOps for each sprint during daily standup to ensure project alignment.
SBA Lending Intern
First Bank of the Lake
01.2021 - 02.2023
- Reviewed and authorized approval of many PPP loan applications for a loan or for loan forgiveness application to the SBA.
- Partnered with industry members to update document manager, ensuring compliance with SBA and Bank regulations.
- Trained interns on loan review procedures, lending practices, and company policies to foster a knowledgeable team.
- Addressed loan applicants' concerns and questions regarding the application process to enhance their experience.
Technical Leader
Allegheny College Department of Computer Science
Meadville
08.2021 - 01.2023
- Conducted code reviews and debugging analysis while leading bi-weekly standups for software engineering students, fostering a collaborative learning environment.
- Collaborated with professors and technical leaders on course assignments and protocols to ensure effective support for students' learning needs.
- Provided technical assistance to students on assignments using Discord channels, Jupyter Notebook, and GitHub, enhancing their understanding and project outcomes.
Data Engineering Intern
HCL Technologies, Inc.
Frisco
05.2022 - 08.2022
- Leveraged Azure Data Factory, Databricks, and Azure Machine Learning to deliver a final project that analyzed customer loan history data to predict potential customer churn.
- Completed weekly training on SQL, Unix procedures, Python, Microsoft Azure Data Lake, Microsoft Azure Data Factory, Microsoft Power BI, and other data engineering concepts, enhancing technical knowledge.
- Participated in biweekly development meetings to review workload progress and finalize project deliverables, ensuring alignment with project goals.
Education
Bachelor of Science - Computer Science / Economics
Allegheny College
Meadville, PASkills
- Data engineering
- Data pipeline development
- Data modeling
- Data architecture design
- ETL pipeline development
- Data warehousing design
- Data integration
- Cloud architecture design
- Cloud infrastructure implementation
- Azure Data Factory
- Azure Data Lake
- Snowflake
- Apache Airflow
- Airflow
- Databricks
- Data visualization techniques
- Power BI
- Data analytics
- Data analysis
- Data mining
- Statistical analysis
- Machine learning
- Scikit-learn
- Pandas
- NumPy
- SQL databases
- Query optimization
- Query management
- SQLite
- Microsoft SQL Server
- SQL Server Management Studio
- ETL processes
- Continuous integration
- Continuous Delivery (CD) implementation
- Git
- GitHub
- GitHub Actions
- Source code management
- Integrated Development Environment
- Integrated Development Environment Code
- Software coding
- Scripting
- Shell Scripting
- Java
- JavaScript
- C/C
- Linux
- XML
- User Interface (UI)
- Cloud databases
- Cloud storage solutions
- Big data
- Performance dashboard reports
- Dashboard development
- Markdown
- Waterfall
- Agile
- Scrum
- Technical project management
- Project leader experience
- Tech lead experience
- System requirements definition
- System troubleshooting
- Automated testing
- Refactoring
- Business Requirements
- Communication
- Data presentation formats
- Datadog
- Sigma
- Data engineering principles
- Software Development
- Databases
- Streamlit
- Markdown
- SSIS
- Big data
- Scripting
- Automated testing
- Data mining
- Cloud storage solutions
- Data presentation formats
- AWS
- ETL
- Container orchestration
- Agile
- ETL processes
Timeline
Data Engineer
Attain Finance
09.2024 - Current
Data Analyst/Engineer
Attain Finance
02.2023 - 09.2024
Data Engineering Intern
HCL Technologies, Inc.
05.2022 - 08.2022
Technical Leader
Allegheny College Department of Computer Science
08.2021 - 01.2023
SBA Lending Intern
First Bank of the Lake
01.2021 - 02.2023
Bachelor of Science - Computer Science / Economics
Allegheny College