SQL: Advanced expertise in writing, optimizing, and troubleshooting queries. Strong grasp of joins, subqueries, CTEs, window functions, performance tuning, and execution plan analysis.
Sigma Computing: Proficient in creating interactive dashboards, applying row-level/user-level security, and training end users on best practices.
ETL (Extract, Transform, Load): Skilled in developing data pipelines for cleansing, transforming, and loading large datasets from multiple sources.
Microsoft SharePoint: Utilized for cross-functional collaboration, project tracking, document management, and team coordination.
Microsoft Excel (VBA): Strong command over Excel functions and macros for task automation, reconciliation, and reporting.
Design, develop, and maintain dashboards and reports using Sigma Computing and Power BI.
Write, optimize, and troubleshoot complex SQL queries, including performance tuning and execution plan analysis.
Collaborate with stakeholders to understand data/reporting needs and deliver actionable insights using cloud data warehouses.
Apply row-level and user-level security for data governance and access control.
Build and manage ETL workflows for data extraction, cleansing, transformation, and loading.
Partner with data engineering teams to validate data accuracy and align models with business logic.
Train and support users on Sigma tools, best practices, and data literacy initiatives.
Assist with financial reporting, including month-end close, general ledger reconciliations, and treasury-related activities.
Perform statistical analysis including weighted averages, central tendency (mean, median, mode), and measures of dispersion (standard deviation, variance).
Engage in process improvement initiatives to enhance reporting accuracy, system controls, and operational efficiency.
Manage cross-functional projects independently and collaborate with teams including Accounts Payable (AP), Accounts Receivable (AR), Oracle ERP, and Application Support.
