Christopher Aragao
Rumford,RI
Summary
Accomplished SQL Developer and Analytics Administrator with affinity for quantitative and qualitative research of complex issues. Successful innovator with years of experience in data quality, governance, visualization, and automation. Collaborative by default and works hard to be inclusive of all perspectives. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
23
23
years of professional experience
1
1
Certification
Work History
IT Specialist (Data Management)
U.S. Department of Veterans Affairs
02.2024 - Current
- Developed interactive reports and dashboards using advanced DAX features
- Designed Power BI apps, connecting them to live data sets for real-time analysis
- Collaborated with diverse users and stakeholders to provide actionable insights
- Created and deployed applications using Power Apps to enhance business productivity
- Proficient in model-driven and canvas apps, API integration, and front-end languages
- Designed and implemented automated workflows to streamline operations
- Leveraged Power Automate to connect various services and automate tasks
Program Analyst (Data Analytics)
U.S. EPA Office Of Inspector General
04.2022 - 02.2024
- Collaborated with cross-functional teams to identify opportunities for process improvement.
- Collected, reviewed, maintained, and financial datasets and dashboards for auditors and evaluators that included financial data coming from the EPA General Ledger and USASpending.gov.
- Served as analyst for numerous financial projects that ranged from investigating grant allocations to scripting algorithms to automatically parse and summarize ledger activity for financial statement auditors.
- Utilized AutoML in PowerBI Service to automatically tag actionable news articles received on a daily basis to provide investigators with timely leads on future financial fraud investigations, which was demonstrated to the CIGIE Text Analytics Subworking Group.
- Developed payroll budgeting reports for all offices in the OIG, which provided better visibility over Core and IIJA spending with projections taking into account seasonality trends.
- Proficient in developing Power Platform applications to efficiently track workload, leading to increased productivity and streamlined processes.
- Assists in development and management in SQL Server and Oracle systems to include ETL development, data modeling, and workload automation with PowerShell and Python.
- Skilled in utilizing various programming methods, including Power Query (M), DAX, SQL, Visual Basic for Applications, PowerFx, PowerShell, and Python, to provide innovative solutions and achieve objectives.
- Produced detailed Recommendations Report that integrated two Oracle systems, resulting in improved data analysis and decision-making.
- Collaborated with team members to create Secondary Sources database, which automatically captures and stores multiple data sources, enabling comprehensive audit research.
- Demonstrated expertise in engineering reports from diverse data sources, such as SQL Server, Oracle, SAP, and more, leading to enhanced data analysis and reporting capabilities.
- Dedicated lifelong learner that recently attended SQL Saturday Boston and joined the NESQL Community, which regularly has trainings at Microsoft in Burlington, MA.
- Conducted regular team trainings to improve use and adoption of Power BI and supported monthly user group for broader EPA OIG community.
Lead Program Analyst (Process Automation Analyst)
Department Of Veterans Affairs (OIG)
03.2021 - 04.2022
- Expertise in content management, data organization, permissions management, analytics, and workflow optimization using SharePoint, Power Platform, and T-SQL, leading to improved productivity and streamlined processes.
- Personally developed a Visual Basic application that simplified hotline referral processing and generated actionable metadata for reporting and advanced analytics, leading to increased efficiency and enhanced data analysis capabilities.
- Optimized hotline data processing by redesigning forms to simplify intake and metadata tagging efforts, which contributed to a NLP-based model that classified hotline data.
- Proficient in modeling, mapping, and visualizing call center data for trending and insights using Power BI, leading to creation of the Hotlines Daily Report that provides critical insights for decision-making.
- Developed Power BI dashboards for Office of Audits and Evaluations, utilizing internal audit project data, including TeamMate, to provide comprehensive data analysis and reporting capabilities.
- Created workload management tool that incorporated SharePoint and audit project tracking data, leading to better visibility of workload in Power BI and increased productivity.
- Attended Intro to Government Auditing at the USDA Graduate School, which was a 40-hour training on Government Audit Standards.
- Personally developed internal Learning Management System (LMS) using Power Platform (SharePoint, Power Automate, Power BI, Power Apps) that manages Individual Development Plans (IDPs), training proposals, training requests, training purchase management, and role-specific reporting for 370+ employees, leading to increased efficiency and streamlined training processes.
- Developed Alteryx workflows to clean and process operational data and integrate LMS with VA Talent Management System (TMS), resulting in improved data accuracy and enhanced reporting capabilities.
Supervisory Veterans Service Representative
U.S. Department Of Veterans Affairs
05.2008 - 03.2021
- Single-handedly developed Official Military Activities Report (OMAR) version 2.0, which was migrated to a Power BI application (with 10+ reports) and analyzed ~5 million rows of data to expedite mental health and Agent Orange claims, as well as visualize war campaigns from Vietnam War to Iraq and Afghanistan, leading to enhanced data analysis and streamlined processes.
- Produced Strategic Analysis of Operation (SAO) Reports, which were a detailed analysis of operations that would recommend actions to improve work procedures.
- Developed several data visualizations in Tableau and Power BI, including the Visual Workload Management Plan, Performance-Based Telework Calculator, and Leave Projection Workbook, to provide insights on VSC operations, resulting in enhanced data analysis capabilities and streamlined operations.
- Successfully managed a remote workforce of 148 employees during the COVID-19 pandemic as Acting Assistant Service Center Manager (AVSCM), implementing strategies and internal controls using Teams, SharePoint, Power Automate, Power BI, and Power Apps, leading to increased productivity and efficient remote operations.
- Regularly provided presentations on innovation projects to outside groups and conferences, such as Chisholm, Chisholm and Kilpatrick; Assistant Director Development Program; and Tableau Government Summit.
- Developed a SharePoint solution and Tableau workbook to track overtime expenditures for two divisions (over 250 employees), leading to improved financial management and streamlined operations.
- Interacted regularly with external stakeholders, such as Operation Stand Down RI and Chisholm, Chisholm and Kilpatrick, to resolve high-profile and sensitive inquiries, demonstrating effective communication and problem-solving skills.
- Supervised a team of 18 employees, including assisting with hiring and onboarding, demonstrating leadership and effective management skills.
- Past positions: Decision Review Officer, Authorization Quality Review Specialist, Rating Veterans Service Representative, Veterans Service Representative
Clerk
U.S. Department Of Education
09.2007 - 05.2008
Sergeant
United States Marine Corps
06.2001 - 06.2005
- Deployed in support of Operation Iraqi Freedom I & II
Education
Lean Six Sigma Green Belt -
Purdue University
West Lafayette, IN2018
M.P.A. - Public Administration
Northeastern University
Boston, MA2010
Bachelor of Arts - Philosophy
University of Massachusetts Boston
Boston, MA2007
Skills
- Python, T-SQL, Visual Basic, DAX
- Information Design and Management
- Tableau, Power BI, and Alteryx Development
- Solution Engineering
- Effective Communication Skills
- Project Management
- Quality of Service
- Problem Analysis and Evaluation
- Advanced O365 Software Proficiency - SharePoint, Power Apps, Power Automate, Power Query, Teams
Certification
- Power BI Data Analyst Associate, Microsoft - March 2022 - March 2025
- Power Platform App Maker Associate, Microsoft - November 2022 - November 2024
Awards
- Inspector General Bronze Award - FY 2022
- Assistant Inspector General for Audits and Evaluations Innovation Award - FY 2021
- Assistant Inspector General for Audits and Evaluations Project Award - FY 2021
- Samuel Heyman Service to America Medal - 2019 Finalist
References
- Daniel Porter, Acting Director, Data Analytics Director, EPA OIG, porter.daniel@epa.gov
- Jason Taliaferro, Deputy Director, VA OIG (52H), jason.taliaferro@va.gov
Portfolio
- EPA OIG Infrastructure and Jobs Act (IIJA) Dashboard (Power BI): Provided mentoring to lead developer on use of Power BI, which resulted in improvements on design and flow of information. Link to Report: https://tinyurl.com/yc7w54fu
- Iraq SigActs Dashboard (Power BI): In my free time I developed a dashboard to analyze significant activities during the Iraq War. While not financial in nature, I believe it shows my ability to communicate insights using advanced analytics. Link to Report: https://tinyurl.com/5n7523mk
- Impact of Library Services on RICAS Scores (Tableau and Alteryx): For a class, I developed this dashboard that brought together multiple sources of data to look at the impact of library funding in a geographic radius on Rhode Island Comprehensive Assessment System (RICAS) literacy scores. Link: https://tinyurl.com/2scvwun8
- Power Query Check Color Blindness function (Power BI): In my free time, I researched how to simulate color blindness and wrote a custom function to simulate what a color blind person may see based on the color palette used. Link to video: https://www.youtube.com/watch?v=BMqss4aGW2E
- Extract Colors from a Picture Using Python (Power BI and Python): I researched how to use Python to extract colors from an image and was able to return a palette for using in a dashboard. Link to video: https://www.youtube.com/watch?v=ZhyBF86F_S4
Timeline
IT Specialist (Data Management)
U.S. Department of Veterans Affairs
02.2024 - Current
Program Analyst (Data Analytics)
U.S. EPA Office Of Inspector General
04.2022 - 02.2024
Lead Program Analyst (Process Automation Analyst)
Department Of Veterans Affairs (OIG)
03.2021 - 04.2022
Supervisory Veterans Service Representative
U.S. Department Of Veterans Affairs
05.2008 - 03.2021
Clerk
U.S. Department Of Education
09.2007 - 05.2008
Sergeant
United States Marine Corps
06.2001 - 06.2005
Lean Six Sigma Green Belt -
Purdue University
M.P.A. - Public Administration
Northeastern University
Bachelor of Arts - Philosophy
University of Massachusetts Boston
- Power BI Data Analyst Associate, Microsoft - March 2022 - March 2025
- Power Platform App Maker Associate, Microsoft - November 2022 - November 2024
Similar Profiles
Jean-Paul S. KelloggJean-Paul S. Kellogg
Senior Training Analyst at U.S. Department of Veterans AffairsSenior Training Analyst at U.S. Department of Veterans Affairs
Erika M. Fuentes FigueroaErika M. Fuentes Figueroa
Legal Administrative Specialist at U.S. Department of Veterans Affairs (VBA)Legal Administrative Specialist at U.S. Department of Veterans Affairs (VBA)
Lisa NicholsLisa Nichols
Medical Support Assistant at U.S. Department of Veterans AffairsMedical Support Assistant at U.S. Department of Veterans Affairs