Leonard Kalimasi

Advanced Metrics Development for Advanced Data Analysis and Institutional Research Purposes

WBR

· OTCCR Expected Completions

· Median DTC Per CU

· Longest Quartile DTC Per CU

MBR

· Revised the Standard POTC

· etc

Advanced-Data Visualization Dashboard Development for Data Analysis and Advanced Research Purposes

· OTCCR Expected Completions

· Median DTC Per CU

· Longest Quartile DTC Per CU

· DTC Course Comparison

· Finance Taxonomy Reference

Objects Revision for Finance Level 3 Grouping.

• I revised more than 36 WBR and MBR objects (DBV, TVZ, DBT) to add Finance Level 3 Groupings in less than 1 month.

I actively participated in the planning, defining, and developing scripts for loading the FY25 targets.

I developed SQL scripts to add academic and operational clusters for new programs.

I developed 'Affiliation by Actives" scripts to load rankings for new affiliation codes

I participated in Loading Forecast Data from Adaptive For Finance Planning Purposes

I conducted rigorous testing and validation of datasets to ensure the accuracy and completeness of data.

I collaborated with cross-functional teams such as the finance department to gather requirements and translate business needs into technical specifications for data solutions.

· Etc

• Participate in initial product designing per clients' requirements
• Participate in projects planning using SCRUM methodology
• Initial Data Analysis for specific existing and new platform feature
• Perform Advanced dashboards Creation for detail data analysis Purposes
• Writing Advanced Store procedures and Advanced SQL functions to prep data for ad hoc reporting purposes
• Create analytical reports and ensure data quality as per specifications and clients requirements
• Perform final data analysis
• Perform final risk assessment
• Participate in monthly code deployment to all platform's environments.

• Responsible for data acquisition and reliability
• Implemented Advanced EXCEL for advanced data manipulation and data cleaning (Conditional formatting, pivot tables, etc)
• Implemented Advanced EXCEL for regression analysis, forecasting and prediction
• Optimized data collection procedures by 75% in less than 2 months
• Optimized SQL queries using Materialized Views, indexes and table partitioning techniques.

• Hands-on BI report development (IBM/Cognos BI) with report lists, all required filters
• Create BI reports with drill-through functionality, drill up and down functionality
• Create reports with required/optional parameters (including auto-submit)
• Worked on SQL query optimization tasks(such as Materialized view, Indexes, and table partitioning ) on OLAP and OLTP systems
• Worked with database control structures such as Case Statements, Simple/ For' loops statements etc, and wrote SQL for data mining, testing and reporting purposes
• Took team ownership of Agile process and was coordinator of all BI team meetings and projects using scrum methodology on JIRA.