Ethel Ajanga

Provide support to General Services Administration by interacting with business users to understand their data needs and generate visual reports that meet their requirements.
● Oversee the end-to-end development lifecycle of BI projects, from requirements gathering to deployment.
● Utilized my strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, joins, data blending to generate reports.
● Perform data analysis to identify trends, patterns, and opportunities for improvement within the Federal Government context.
● Addressed the challenges to data integration, profiling the data for peculiar anomalies in the data source, and subsequently reworked the integration efforts.
● Prepare and conduct presentations or training sessions on non-technical and technical topics to the user community.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
Help administer & configure Tableau instances for accuracy and best practices.
Automate key areas of business processes to improve efficiency within HR and Accounting departments.
Also involved in administration tasks such as setting permissions, managing ownerships, and providing access to approved users.
Optimize Indexes, Views, Stored Procedures and Functions using Oracle.

Provide support to General Services Administration by interacting with business users to understand their data needs and generate visual reports that meet their requirements.
Oversee the end-to-end development lifecycle of BI projects, from requirements gathering to deployment.
Utilized my strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, joins, data blending to generate reports.
Perform data analysis to identify trends, patterns, and opportunities for improvement within the Federal Government context.
Addressed the challenges to data integration, profiling the data for peculiar anomalies in the data source, and subsequently reworked the integration efforts.
Prepare and conduct presentations or training sessions on non-technical and technical topics to the user community.

Participate in all aspects of the software development lifecycle which includes estimating, technical design, implementation, documentation, testing, deployment, and support of applications developed for a variety of clients.
Develop and maintain reports, report schedules, dashboards, publishing, and user administration.
Research data issues associated with reports and data accuracy.
Use Jira to manage user stories, complete tasks, begin dashboard development and access blockers and testing.
Experience working with Tableau Server, Tableau Prep, and Tableau Online.
Help business partners and stakeholders understand best practices for needed insights: KPIs and visualizations, dashboard design, and approaches to effectively answer their questions and help them run their business unit/functional area.
Modify SQL Queries to improve performance and develop reference documents or reports for the finalized project for the end client (AAIS).

Play a key role in the architecture, delivery and governance of reporting and data delivery.
Created Tableau Dashboard designing with effective data visualization of large data volumes analyzing student performance using various data sources (SQL server, oracle, spreadsheets, etc).
Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.
Extensively used snowflake to manage HR Dashboards.
Generated talent management dashboards using tableau and identified KPI’S that allowed companies to retain talent, avoid turnover rates and subsequently cut cost.

Provide support for the district’s enterprise applications, database environments, and data integration processes by analyzing problems and solutions.
Model data warehouse to best meet the needs of various departments.
Maintain and QA existing reports on our Tableau Server as well as existing integrations.
Built complex calculations to monitor student progress throughout the year by generating monthly quarterly and end of year reports.
Recommended, scheduled, and performed software improvements and upgrades.
Experience in publishing reports, data source and dashboards, scheduling, refresh, creating projects, groups, and users.