Amna W. Email & Phone Number

Tysons, Va, Us

- Implemented ETL workflows to handle real-time and scheduled data ingestion, transformation, and loading, ensuring seamless integration with various data sources and destinations- minimizing manual efforts- Engineered scalable data pipelines using PySpark’s DataFrame API and SQL capabilities to perform complex transformations and aggregations on large datasets- Auto-scaled and optimized clusters to enhance pipeline performance and reliability by configuring auto-scaling policies and selecting appropriate instance types based on workload requirements. Leveraged Databricks' cluster pools and spot instances to efficiently manage resources and reduce costs- Optimized data performance through StreamSets configuration and leveraging Snowflake’s parallel processing capabilities, resulting in faster data processing time and improved system efficiency- Developed ETL processes using Apache Spark on Databricks to ingest data from various sources into data lakes and warehouses and load into AWS S3 buckets for further analysis- Facilitated sprint meetings and progress reviews for a team of 4 engineers using JIRA, overseeing task creation and assignment, addressing roadblocks, and ensuring alignment with project objectives. Managed timelines and made necessary adjustments to keep the project on track, while fostering team collaboration and communication- Coordinated with stakeholders to gather requirements, develop project plans, and track progress, ensuring alignment with business goals- Engaged with end-users to gather feedback on data solutions and incorporated user insights into the design of ETL processes and dashboards, resulting in improved user satisfaction and adoption

Mclean, Va, Us

- Conducted API versioning and lifecycle management on Apigee, allowing smooth transitions to existing integrations- Designed, implemented, and maintained data pipelines on Databricks for efficient ETL processes- Performed data quality assessments through identifying and resolving abnormalities using data profiling and validation- Applied statistical techniques to evaluate data to ensure accuracy and reliability of research outcomes-Developed Excel table shells with appropriate data validation rules to enforce data integrity and improve user experience/ readability while also ensuring consistency in formatting across various projects

Washington, District Of Columbia, Us

- Developed a current state assessment of the data management, data governance, and analytics capabilities through stakeholder interviews and document review- Translated technical concepts for 60+ systems into clear, concise language for a diverse audience of end-users, systems included: Databricks, Rockies, PowerBI, Palantir, etc- Modernized business processes and ETL structure which resulted in a decrease of processing time by a minimum of 45%- Uncovered data insight through gap and trend analysis which refined requirements and optimized data performances- Established a Data Science Centers of Excellence for 14,000+ employees to promote collaboration, networking, education, and assist with technical/ data science use cases- Evaluated documentation and provided methods for improvement to ensure all content was written in a user-friendly manner to address the target non-technical audience. This increased end-user satisfaction by 30%- Conducted gap analysis and user research through stakeholder interview and document review for 3 different clients to improve data-driven decision making- Mapped relationships between different systems; mainframe to system, system to system, and system to ETL- Automated the extraction of data tables using Python from over 5000 Cobol copybook files

Mclean, Va, Us

- Analyzed and presented multi-source data sets using advanced SQL querying, visualization, and analytic tools. This provided further insight on gaps and trends while optimizing performance by over 40%- Developed and executed end-user acceptance criteria and automated regression testing- increasing query performance- Updated existing data streamlining processes, resulting in a 30% redundancy reduction- Worked with clients through all stages of the development lifecycle to identify and implement changes- Created and analyzed data visualization and dashboard in ArcGIS and Tableau to support analyst and business users- Modeled ETL pipeline to best maintain and streamline client data- Created, translated, and integrated open-source GIS data layers-allowed insight to where resources needed to be allocated- Facilitated senior leaders to develop rapid prototype solutions and recommendations to improve incident management- Conducted data significance and regression analyses of relationships between variables which helped to identify gaps

Washington, Dc, Us

- Worked with contractors and employees to create a smart label software which will assist in the transfer of information between contractors and the government- saving time and money - Contributed to data record management and package preparations for contractor review - Performed company outreach to update information on products for online disinfectant lists - Created Access database to assist in records management of branch - Collaborated with the ombudsman to analyze data under the Antimicrobial Testing Program - Assisted with the development of the Product Science Branch SharePoint webpage design.

Albuquerque, Nm, Us

- Initiated project to assist Washington Metropolitan Area Transit Authority with predictive analytics- Applied data mining, mathematical modeling and machine learning techniques to help client operate more efficiently and cost-effectively - Performed document review to determine relevant information- Visualized large data-sets in Tableau to detect patterns and correlations. This allowed data to be presented in an interactive format when briefing customers- Assisted with database and web application development in the SharePoint environment

Reston, Va, Us

- Oversaw 20 schools at the state and regional level; promoting business and leadership - Led several local, regional and state conferences- preparing students for life after high school

Master'S Degree, Data Analytics Engineering

Undergraduate, Computer Science And Software Engineering

International Baccalaureate Student