Data Analyst - BI & SQL Specialist - Power BI Expert

Arpita Kadre

Mechanicsburg, PA 832-***-****

LinkedIn URL https://www.linkedin.com/in/arpita-k-aa553336/

*************@*****.***

DATA ANALYST BUSINESS INTELLIGENCE ANALYST SQL POWER BI

Designing Data Solutions That Improve Business Insights and Decision-Making

Detail-oriented Data Analyst with strong experience in SQL, Power BI, ETL pipelines, and enterprise data systems across healthcare, SaaS, and government domains. Skilled in transforming complex datasets into actionable insights through reporting, automation, and dashboard development. Experienced in working with cross-functional teams to translate business requirements into scalable data solutions. Known for improving data accuracy, optimizing reporting workflows, and supporting data-driven decision-making.

CORE COMPETENCIES

ETL Development and Automation SQL Server Development Data Warehousing and Modeling Cloud Platforms (Azure) Systems Integration BI Reporting and Dashboards Client-Facing Communication Technical Troubleshooting Agile/Scrum Collaboration Performance Tuning and Optimization

TECHNICAL SKILLS

Databases: SQL Server (2012-2019), Oracle, MySQL, PostgreSQL, ETL Tools: SSIS, Informatica, Oracle Warehouse Builder (OWB), Oracle Data Integrator (ODI), Reporting & BI: SSRS, Crystal Reports, Power BI, Tableau, Languages: T-SQL, PL and SQL, C#, .NET, Python, HTML and CSS, JavaScript, Tools and Technologies: Azure, SharePoint, SAP Business Objects, Other: Data Modeling, Performance Tuning, SSAS, Agile and Scrum

PROFESSIONAL EXPERIENCE

FRONTLINE EDUCATION, Mechanicsburg, PA 07/2023 - 11/2025

Data Analyst SQL, Reporting & SaaS Data Operations

Administrated integrations with 90+ third party systems for school district operations, worked with large complex databases, maintained data accuracy, resolved Absence Management and ERP issues, delivered client training, and created detailed process documentation that streamlined workflows and improved team efficiency.

●Analyzed client data requirements and implemented automated ETL workflows across 3 enterprise systems, reducing manual entry errors by 40% and accelerating reporting turnaround by 2 days.

●Cleared high volume of backlog tickets during a critical operational phase, helping stabilize system performance and restore service levels.

●Achieved 95% resolution rate on Absence Management issues by collaborating directly with clients, improving user satisfaction, and reducing repeat support requests.

NEW SEASON, Mechanicsburg PA 05/2023 - 08/2023

Data Analyst BI & ETL Developer

Orchestrated healthcare data operations by automating weekly SSIS based ETL processes, developed Tableau dashboards, creating Python scripts for CSV to SQL and cloud integrations, optimizing SSIS pipelines that replaced legacy SQL workflows, and maintained automated ingestion processes for in house ERM systems.

●Developed automated Tableau reporting pipelines by creating Python scripts for CSV to SQL ingestion and cloud integrations, improving data freshness and accelerating operational and executive reporting cycles.

●Constructed and deployed SSIS packages integrating complex transformations and scripting tasks, streamlining data processing, and enabling faster, more accurate business reporting.

●Rebuilt legacy SQL processes into automated SSIS based ETL pipelines, improving performance and maintainability while increasing data reliability and eliminating weekly manual intervention.

WTW, (Kelly Services), Mechanicsburg, PA 05/2022 - 03/2023

Data Analyst ETL & BI Reporting

Implemented enterprise data workflows by automating ETL workflows, optimizing database structures, developing SSIS export packages, building SQL and Python based pipelines, creating AD connected Python scripts and PowerShell automations, and delivering Power Apps, Dataverse, SSAS, and Power BI solutions for analytics and reporting.

●Improved overall data processing efficiency by 40% through targeted ETL workflow enhancements, reducing cycle times and accelerating downstream reporting.

●Engineered hybrid ETL pipelines using SQL Server and Python by streamlining multi source data extraction, transformation, validation, and loading across enterprise systems.

COMMONWEALTH of PENNSYLVANIA, Office of Administration, (ATG Tech), Harrisburg PA 2/2019 - 11/2019

Data Analyst SQL & BI Reporting

Improved end to end data reliability, partnered with cross functional teams, identified root cause issues, implemented standardized data quality checks, and streamlined validation workflows across multiple enterprise systems.

●Assembled high performance SQL objects (stored procedures, functions, views, triggers) and optimized PostgreSQL schemas, improving query efficiency and supporting scalable ETL and reporting workloads.

●Delivered enterprise reporting solutions by developing SSRS reports and Power BI dashboards, while validating ETL processes through comprehensive test cases and managing code deployments using Azure DevOps Repos and data factory pipelines.

COMMONWEALTH of PENNSYLVANIA, Department of Correction, (Unica), Mechanicsburg PA 3/2018 - 12/2018

BI Developer Data Warehouse & Reporting Analyst

Optimized enterprise data systems, oversaw end to end data workflows, coordinated cross functional reporting needs, and focused on consistent delivery of business intelligence solutions. Partnered with technical and functional teams, aligned data processes with organizational requirements, maintained reporting standards, and increased overall data accessibility for decisionmakers.

●Shaped and maintained enterprise data warehouse solutions by integrating and transforming data from Oracle, flat files, and relational databases, ensuring accurate and reliable datasets for operational and strategic reporting.

●Developed Power BI dashboards and SSRS drill down and matrix reports while documenting ETL specifications and collaborating with analysts, refining requirements, improving reporting clarity, and decision making across organization.

PA MUNICIPAL RETIREMENT SYSTEM, (Unica), Harrisburg PA 3/2016 - 2/2018

Data Analyst BI Systems & SQL Reporting

Led enterprise data operations which managed database driven workflows, coordinated reporting needs, and contributed for system enhancements across multiple internal platforms. Collaborated with technical teams, maintained stable data environments, improved internal tools, and ensured smooth delivery of reporting and operational solutions for business users.

●Defined COLA database components and developing ETL processes for pension administration, including secure data scrambling for system upgrades and migrations, ensuring compliance, and data integrity.

●Produced complex SSIS packages and maintained SQL Server environments as junior DBA, automating batch processes and large dataset reporting generation by improving operational efficiency.

●Optimized Crystal Reports and Access databases with VBA, macros, and custom interfaces, while creating intranet pages using Bootstrap and CSS by enhancing internal reporting and user experience.

UNICA, Mechanicsburg, PA 09/2015 - 3/2016

SQL Developer Intern

Managed full stack internal application operations which coordinated data workflows, aligned reporting needs with business requirements, and contributed with development of secure user focused web solutions. Collaborated with cross functional teams, maintained stable application environments, ensured consistent data availability, and enhanced organization’s reporting and analytics infrastructure.

●Performed database modeling and developed stored procedures, functions, and SQL scripts by supporting internal web applications, while optimizing SQL queries, including pagination and indexing while improving application performance.

EDUCATION

Master, Master of Computer Applications (MCA), Computer Science, Allahabad Agricultural Institute, Deemed University, India

Diploma, Diploma in Computer Applications (DCA), Computer Science, Government Girls Polytechnic, India

Bachelor, Bachelor of Commerce (BCom), Commerce, Guru Harikishan college, India

AWARD and RECOGNITION

Earned “Rookie of the Quarter Award” by Frontline Education

COMMUNITY INVOLVEMENT

Personal Community Contributions, 2019–2022

Delivered community training sessions on SQL, SSIS, Power BI, data warehousing, and software testing concepts.

Contact this candidate