Ramakrishna Reddy Kovvuri

Engineered payroll datasets using Snowflake SQL and data build tool (dbt), transforming 1M+ biweekly payroll recordsfrom 6 HRIS and tax systemsinto governed modelssupporting 10 recurring compliance and finance reports. ● Developed 10 executive dashboardsin Power BI with DAX and PowerQuery, tracking gross pay, multi-state tax withholdings, garnishments, and W2 reconciliation metrics, reducing manual reporting time from 2 hours to 45 minutes per payroll cycle. ● Administered 6 scheduled ETL pipelines in Azure Data Factory, processing daily compensation transactions and reducing data availability from next day reporting to under 3 hours for payroll operations teams. ● Reconciled payroll tax data using Python and Pandas, validating quarterly payroll records against federal and state tax filing reports while resolving 20+ monthly data quality tickets within established SLA timelines. ● Generated workforce cost variance analyses through Advanced Excel and Power Pivot, producing 18+ monthly ad-hoc financial reports supporting compensation forecasting across client portfolios averaging $50M in annual payroll volume. ● Strengthened data governance within Microsoft Purview and enterprise payroll reporting systems, documenting key payroll data elements, mentoring junior analysts, and aligning analytics outputs with federal and compliance requirements.

Applied Python (Pandas, NumPy) to perform sales trend analysis, backlog aging calculations, and data validation across multi-region transaction datasets, improving reporting accuracy and supporting revenue forecast reviews. ● Architected sales and supply chain data models using Amazon Redshift and SQL, integrating 1M+ transaction recordsfrom 7 regional systems into reporting tables supporting weekly revenue and inventory analysis for 20+ business users. ● Created 15+ operational analytics dashboards in Tableau, analyzing order to ship cycle time, regional sales trends, and backlog aging to identify fulfillment bottlenecks and support weekly supply chain planning decisions. ● Configured batch ETL workflows in AWS Glue, ingesting and standardizing daily order and shipment data from operational systems, applying validation checks to support daily refresh cycles for operations and finance reporting. ● Conducted sales pipeline analysis using Microsoft Excel (Pivot Tables and advanced formulas), evaluating order conversion trends and backlog aging to support enterprise sales planning and periodic forecast reviews. ● Improved query performance in Azure Synapse Analytics, refactoring 20+ complex SQL queries and restructuring joins to reduce dashboard load time under 2 minutes, improving report responsiveness for supply chain analytics users. ● Standardized data preparation workflows using Alteryx Designer, consolidating cleansing rules across 8 source systems and reducing manual validation workload by 10+ hours per month for finance teams. ● Documented reporting requirementsin Azure DevOps and Jira, capturing 40+ analytics requests and coordinating with sales, finance, and IT teams to support structured KPI delivery timelines.