Data Analyst Business

Terrence J. Estu, Jr.

**** **** ****** **** # ****, Woodbridge, Virginia 22195

703-***-**** adym1r@r.postjobfree.com https://www.linkedin.com/in/terrenceestujr

Data Analyst with experience across diverse environments. Skilled at working in fast-paced environments demanding strong organizational, leadership, and multitasking skills required to meet strict deliverable deadlines. Effective interpersonal skills and committed to providing superior customer service.

HIGHLIGHTS OF QUALIFICATIONS

Data Analysis

Certified Business Systems Analyst, InQuestra Learning Completed: 5/2011

Analyzed data for numerous United States Postal Service (USPS) PostalOne! recurring and ad hoc reporting requests based on complex SQL queries in an Oracle 12c database environment. Supported the monthly production of over 10,000 reports for Aetna’s Disease Management program. Front end data Oracle 11g database analysis minimized production reruns and proved that Aetna’s Disease Management program financially saved plan sponsors money.

Team Environments

Effective teamwork resulted in over $ 50,000 savings for ActiveHealth Management while volunteering to take on additional projects during staff shortages, “successful” performance evaluations, and the recipient of the Q4 2009 Sapphire Award for service excellence.

Applied Analytical and Evaluative Techniques

The implementation of the more efficient Excel based Infoscheduler tool reduced the amount of time required to setup and schedule Crystal report instances for Aetna’s Disease Management program from about two hours to one hour per batch. Additionally, the development of complex Excel macros greatly improved production processes and eliminated extraneous QA work.

Computer Skills: Structured Query Language (SQL), Aqua Data Studio, SQL Developer, Informatica, Crystal Reports, Apache Subversion (SVN), Jira, Confluence, Remedy, ServiceNow, Oracle Business Intelligence Enterprise Edition (OBIEE), Birst, Tableau, Power BI, Adobe Acrobat Pro DC, Logi Composer, Microsoft Word/Excel/Access/Visio/PowerPoint/Outlook

PROFESSIONAL EXPERIENCE

Oran, Inc., Woodbridge, VA

Data Analyst, 02/2023 to present

Perform analysis, identify meaningful insight, and translate business needs into solutions as a member of an Agile/Scrum team.

Elicit requirements and analyze data using Structured Query Language (SQL), Excel, and Logi Composer.

Build analytics products including reports and dashboards.

Present analysis results to internal and external stakeholders.

GC Associates USA, LLC, Arlington, VA

Data Analyst, 10/2022 to 02/2023

Performed analytics and studies support to the Defense Health Agency Disability Evaluation System (DHA DES) Program.

Analyzed data using Structured Query Language (SQL), Excel, and Power BI.

Performed analysis for process improvement.

Presented analysis results to internal and external stakeholders.

Seventh Sense Consulting, LLC, Woodbridge, VA

Business Intelligence Analyst, 06/2022 to 09/2022

Performed analysis and translated business needs into solutions to support the United States Army as a member of an Agile/Scrum team.

Developed assessment criteria and conducted assessments of United States Army applications.

Collaborated with stakeholders to standardize United States Army applications.

Analyzed United States Army data with Power BI to identify trends and patterns.

R3 Government Solutions, LLC, Washington, DC

Senior Consultant, 12/2021 to 05/2022

Performed analysis and optimized processes to support the United States Department of Homeland Security (DHS) as a member of an Agile/Scrum team.

Analyzed United States Department of Homeland Security (DHS) data using Structured Query Language (SQL), Excel, and Tableau.

Improved processes in order to create Tableau dashboards.

Created reports with Excel and Oracle Business Intelligence Enterprise Edition (OBIEE) using complex equations.

General Dynamics Information Technology, Arlington, VA

Senior IT Quality Analyst, 11/2021 to 12/2021

Designed and implemented testing plans for IT products to support the United States Department of Homeland Security (DHS) as a member of an Agile/Scrum team.

Regularly analyzed United States Department of Homeland Security (DHS) data using Structured Query Language (SQL).

Routinely tested performance of IT products and services to ensure that they met established quality standards.

Presented quantitative and qualitative test result findings to internal and external data stakeholders.

Modis GS, Arlington, VA

Senior Data Analyst, 04/2021 to 10/2021

Performed data analysis to support the United States Department of Homeland Security (DHS) as a member of an Agile/Scrum team.

Regularly analyzed United States Department of Homeland Security (DHS) data using Structured Query Language (SQL).

Routinely validated extract, transform, and load (ETL) processes along with Birst reporting requirements using complex equations.

Documented and presented validation summaries to internal and external data stakeholders.

AVER, LLC, Washington, DC

Sr. Data Analyst, 12/2020 to 04/2021

Performed data analysis to support the United States Department of Veterans Affairs (VA).

Combined large data sets into visually appealing reports, charts, and graphs.

Created reports with Access, Excel, and Oracle Business Intelligence Enterprise Edition (OBIEE) using complex equations.

Evaluated existing metrics and developed new performance metrics in order to monitor performance across the enterprise.

Constructed complex database queries across multiple databases in order to develop effective analytical solutions.

Salient CRGT, Inc., Alexandria, VA

Business Analyst 4 (EDW/BI Business Analyst), 10/2019 to 12/2020

Performed business analysis and data analysis to support the National Science Foundation (NSF) as a member of an Agile/Scrum team.

Created standards for National Science Foundation (NSF) AWS cloud architecture.

Tested data between National Science Foundation (NSF) legacy source systems and AWS cloud architecture.

Analyzed National Science Foundation (NSF) data using Structured Query Language (SQL).

Integral Consulting Services, Inc., Arlington, VA

Data Analyst, 10/2018 to 10/2019

Performed data analysis to support the United States Department of Homeland Security (DHS) as a member of an Agile/Scrum team.

Analyzed United States Department of Homeland Security (DHS) data to support the data migration from IDENT to HART.

Routinely implemented data quality rules as part of the data quality assessment (DQA) process.

Documented and presented data quality assessment (DQA) findings and recommendations to internal and external data stakeholders.

Huntington Ingalls Industries - Mission Driven Innovative Solutions Inc., Fairfax, VA

Data Analyst, 05/2014 to 09/2018

Autonomously performed data analysis for United States Postal Service (USPS) PostalOne! recurring and ad hoc reporting requests to support the PostalOne! program. Additionally, provided analysis for process improvement.

Regularly analyzed United States Postal Service (USPS) PostalOne! data using Structured Query Language (SQL).

Automated recurring United States Postal Service (USPS) PostalOne! reporting requests with the interactive shell Fluidshell.

Solved critical ad hoc United States Postal Service (USPS) PostalOne! business questions with complex SQL queries.

ActiveHealth Management, Chantilly, VA

Business Analyst, 04/2013 to 05/2014

Autonomously performed analysis and translated business needs into business requirements and functional specifications documentation. Additionally, independently conducted interviews and research to design creative IT solutions for business problems to maximize both efficiency and profitability.

Independently conducted interviews, fact-finding, and research in order to accurately bill clients for program participation.

Created functional specification documentation for the Global Transition Report that increased member transition efficiency.

Completed project activities on time and within budget.

ActiveHealth Management, Chantilly, VA

Associate Business Analyst, 08/2011 to 04/2013

Under the guidance of experienced Business Analysts performed analysis to assist with translating business needs into business requirements and functional specifications documentation. Additionally, under the guidance of experienced Business Analysts conducted interviews, fact-finding, and research to design creative, progressive IT solutions for business problems to maximize both efficiency and profitability.

With guidance conducted interviews, fact-finding, and research in order to accurately bill clients for program participation.

Created functional specification documentation for the potential large claims report that increased production efficiency.

Regularly documented, tracked, and resolved issues related to incentive data quality.

EDUCATION

Bachelor of Science in Mathematics, University of Georgia, Athens, GA 12/2002

Delta Epsilon Iota Academic Honor Society, Golden Key Int’l Honor Society, National Society of Collegiate Scholars

Contact this candidate