DWIGHT PAGAN-LUGO
***********@*****.***
Herndon, VA 20171
www.linkedin.com/in/dpaganlugo
WORK EXPERIENCE
February 2024 – Nov 2024
Data Scientist
Deloitte Washington, Dc
• Leading the development of cloud-based and web applications utilizing Python, HTML, and CSS..
• Utilizing AWS services, including EC2, Lambda, S3, and SageMaker, to optimize data processing and reduce operational costs, while integrating Amazon OpenSearch Service to enhance search and analytics capabilities.
• Enhancing collaboration and project transparency by creating SOPs, comprehensive documentation, and managing GitLab repositories for version control.
• Applied machine learning techniques, including Linear regression, Decision Trees, and Natural Language Processing
(NLP) models to perform data analysis and supervised learning on structured and unstructured data, driving key insights and actionable recommendations.
• Conducting exploratory data analysis (EDA) using Python, performing data cleaning and preprocessing through Jupyter Notebooks to ensure data accuracy and uncover actionable insights.
• Applying advanced algorithms such as K-Nearest Neighbors
(KNN) and neural networks to develop efficient document parsing and search functionalities, enabling large-scale text analysis and query capabilities.
• Utilized NLP modules such as Scikit-learn, spaCy,s NLTK, Pillow
(Image), and Pytesseract (OCR) to build applications for sentiment analysis and extracting derogatory information from large text corpora, contributing to improved decision- making processes.
• Developed an advanced document parsing application utilizing machine learning algorithms, including KNN and neural networks, to efficiently process large document collections and accurately search for key terms.
Data Engineer BI Developer July 2023 – Feb 2024
TEKsystems Arlington, VA
U.S. Office of the Undersecretary of Defense for Intelligence & Security
• Led the integration of Databricks within ADVANA, enhancing big data utilization and increasing data processing speed by 45% for the U.S. Office of the Undersecretary of Defense for Intelligence
& Security.
• Designed and implemented dynamic dashboards and ad-hoc visualizations using Python, SQL, and Qlik Sense, improving data insights and decision-making capabilities.
• Developed and maintained Qlik applications to ensure data integrity and accurate representation, while debugging and optimizing Python and SQL scripts connected to clean data sources.
• Designed and executed comprehensive ETL processes, facilitating seamless integration of data from multiple sources through extraction, transformation, and loading workflows. Senior Data Analyst March 2022 – July 2023
Insight Global Tampa, FL
U.S. Department of Defense, SOCOM J2 Intelligence Data Science Team (IDST)
PROFILE SUMMARY
Dynamic Data Analytics Executive with over
7 years of extensive experience delivering
high-impact consulting services to federal
agencies. Demonstrated expertise in data
science, machine learning, and cloud
technologies, with a robust track record of
architecting innovative, data-driven
solutions that enhance operational efficiency
and drive strategic decision-making.
Proficient in translating complex data sets
into actionable insights, enabling
organizations to optimize performance and
achieve key objectives. Committed to
leveraging cutting-edge technology and
analytical methodologies to address complex
challenges and foster sustainable business
growth. A strategic leader passionate about
driving transformative change through data
innovation and cross-functional
collaboration.
EDUCATION
• Masters in science: Data Science and
Analytics, Expected in June 2026
Georgia Institute of Technology
• B.A. Economics, Business Administration,
• Universidad De Puerto Rico, Recinto De
Mayaguez, UPRM
• Post-Graduate Certificate: Data Science
& Business Analytics University of Texas,
Mccombs School of Business (Open,
Tableau Austin Source Tools, SQL,
Python, Business Statistics. Data
ACTIVITIES AND HONORS
• Nominee to Booz Allen Hamilton
Excellence Award for contributions to
project and performance (2022).
• 2013 Past Member of Accounting
Students Association. Won the
Community Services Award January
2015 – May 2016
• Member of Economics Students
Association January 2015 – May 2016
CERTIFICATIONS
• Tableau Desktop Specialist
SKILLS
• DOD analytic databases
• Tableau Desktop
• Tableau Prep, Tableau Server
• Red-hat Linux
• SQL (Oracle SQL developer)
• Python
• Jupyter noteboks
• Numpy
• Cloud technologies (Google Cloud,
AWS, Azure)
• Extraction, Transformation and load
(ETL)
• Pandas
• Scikit-Learn
• Supervised and Unsupervised learning
• Seaborn. R Studio
• Jira
• Confluence
• Data visualization
• business intelligence tools
• Machine Learning algorithms
• Microsoft Word
• Excel Power Query
• PowerPoint
• Active Listening
• Time Management
• Deep learning/Artificial Intelligence
·LANGUAGES
• Spanish
• English
• Defense Language Proficiency Test
(DLPT5) Scores: 3.0
• Developed and maintained ad hoc reports for various offices and divisions within the U.S. Department of Defense, SOCOM J2 Intelligence Data Science Team (IDST), providing critical insights to stakeholders.
• Managed and optimized Jira software projects, business workflows, dashboards, and user access, ensuring seamless project coordination and data sharing across the organization.
• Created and customized Confluence pages and Jira snapshots to enhance project documentation and accessibility, maintaining data integrity within the organization’s shared drives.
• Extracted, transformed, and cleaned data from Oracle databases using SQL, while performing exploratory data analysis (EDA) to identify trends and support decision-making.
• Designed, developed, and debugged R Shiny applications to visualize data and streamline analytical processes, improving overall efficiency.
• Enhanced reporting accuracy and data quality by maintaining and updating KPI reports and dashboards in MS Excel, Tableau, and Python, consolidating data into master files for stakeholders. Data Analyst Associate Mar 2022 – Sep 2022
KPMG LLP (Remote/Hybrid)
• Maintained comprehensive KPI reports to track organizational performance, utilizing MS Excel and Tableau Desktop for data analysis, dashboard updates, and KPI reporting quality checks.
• Streamlined data consolidation by receiving, cleaning, and verifying data from stakeholders, creating master files, and developing computed fields and dashboards in Tableau for dissemination.
• Performed dataset clean-up, data quality assurance, and formatting checks, ensuring accuracy and consistency in reporting processes.
• Managed and organized data files on the shared drive, supporting data integrity and providing quality reviews for various project efforts.
Data Scientist Senior Consultant Apr 2021 – Mar 2022 Booz Allen Hamilton, BAH Tysons Corner, VA
• Developed intuitive, interactive Tableau dashboards by extracting and transforming data from Oracle using Tableau Prep and SQL, improving process efficiency and decision-making for stakeholders, and publishing to Tableau Server.
• Enhanced data visualizations by leveraging Python and SQL for data transformation, clean-up, and quality checks, driving more accurate insights and stakeholder engagement.
• Created and implemented an ad hoc reporting system that extracted, filtered, and analyzed data from Oracle databases, exporting results as CSV files for comprehensive analysis using Python.
• Significantly improved user engagement by analyzing workforce demographic data and survey results, reflected in the Inclusion & Engagement dashboard, and optimized dashboard usability through demos and feedback sessions.
• Led exploratory data analysis (EDA) and ensured data integrity, contributing to key decision-making and process optimization initiatives.
• Cmpioned the creation of Tableau dashboards and transformed COGNOS data for strategic acquisition planning and source selection, supporting cost analysis and proposal evaluations. Data Analytics Senior Consultant Sep 2019 – Mar 2021 Guidehouse LLP
• Designed and maintained interactive Tableau dashboards for tracking organizational contracts and acquisitions KPIs by extracting, transforming, and cleaning data from COGNOS, and ensuring seamless integration with Tableau Server.
• Led the creation and administration of Tableau sites and dashboards, overseeing software updates, patches, and user access management to ensure data reliability and up-to-date reporting across departments.
• Collaborated with stakeholders to gather feedback, enhance dashboard usability, and tailor custom reports for specific organizational needs, improving operational insights and decision-making processes.
• Supported acquisition planning and source selection efforts by developing critical documentation (SOWs, selection plans, market surveys) and conducting compliance reviews for contractual and program integrity. Data Analyst Senior Consultant Jun 2019 – Oct 2019 MBC Consulting
• Provided strategic workforce insights by analyzing demographic data, employee surveys, and performance ratings, enabling informed decision-making for Naval Intelligence Activity’s Chief Human Capital Office.
• Identified trends and gaps in HR data sets, performing data sanitation and quality checks to ensure data integrity, and recommending solutions for data inconsistencies to clients.
• Designed Excel-based dashboards for workforce planning, supporting recruitment and retention initiatives, and providing forecasts aligned with organizational goals.
• Represented the organization in Intelligence Community-wide meetings, sharing insights and facilitating discussions on workforce trends and policy compliance.
Intelligence Operations Data Analyst Dec 2018 – Jun 2019 General Dynamics
• Conducted complex data searches and link analysis across multiple proprietary databases, producing actionable intelligence reports under tight deadlines for critical operations.
• Assisted in managing and retrieving vital information for both internal and external customers, ensuring timely and accurate delivery within a production-driven environment.
• Analyzed, indexed, and curated intelligence data based on established criteria, enhancing the accessibility and relevance of information for future use.
• Collaborated with intelligence assets and validated field intelligence reports, providing tailored feedback to refine collection efforts.
Contracting Officer Sep 2017 – Oct 2018
U.S. National Security Agency
• Managed and executed contracts for intelligence products and services, from vendor evaluation to contract negotiation and award, ensuring compliance with federal acquisition regulations (FAR, DFARS).
• Provided executive briefings to senior management on contract reviews, procurement strategies, and program success, influencing high-level decision-making.
• Conducted detailed cost analysis and procurement evaluations, ensuring alignment with budgetary and legal requirements, and optimizing value for the agency.
• Administered contract modifications, ensured delivery schedules were met, and coordinated payment processes, ensuring seamless contract execution and compliance. Sales & Operations Data Analyst Mar 2017 – Sep 2017 C7 Global LLC
• Created and maintained Tableau dashboards for monitoring sales, operational performance, and budget vs. actual analysis, enabling data-driven decision-making and process optimization.
• Performed comprehensive market data analysis to support sales and business development efforts, identifying market opportunities and assisting in goal-setting to expand market share.
• Analyzed operational costs and objectives, identifying areas for cost reduction and efficiency improvements in transportation and distribution processes.
• Acted as a liaison between sales and business development teams, aligning data insights with operational strategies to drive business growth and enhance reporting accuracy.