Home

sanjana ch - BI Developer

[email protected]

Location: Cumming, Georgia, USA

Relocation: yes

Visa: F1

Sanjana C BI Developer [email protected] (943) 221-7224 Professional Summary Results-driven BI Developer with 5+ years of experience designing, developing, and delivering end-to-end BI solutions across Power BI, GCP, Snowflake, Oracle, and Azure platforms. Expertise in Power BI architecture, data modeling, T-SQL, DAX optimization, and enterprise reporting. Proven success in handling large-volume data, database security, performance tuning, and mentoring BI teams. Strong experience with GCP BigQuery integration, data pipelines, metadata governance, and stakeholder collaboration. Adept at delivering scalable BI models and secure data warehouse solutions aligned with business goals and compliance standards. Technical Skills Category Skills BI & Reporting Tools Power BI (Desktop, Service, Dataflows, Report Builder), Looker, SSRS, Tableau Languages SQL, T-SQL, DAX, Python, Power Query, Shell scripting ETL & Data Integration SSIS, ADF, Informatica, Dataflows, Star/Snowflake Schema, OLAP Modeling Databases BigQuery, Snowflake, SQL Server, Oracle, Azure SQL Automation & Integration Power Automate, Azure DevOps, Git, CI/CD Pipelines Cloud Tools Google Cloud Platform (BigQuery, Cloud Storage, Cloud Composer), Azure Synapse, Azure Data Factory ERP & Platforms Familiar with NetSuite, Shopify, Celigo, Google Sheets Security & Governance Database Security, RLS, OLS, Row/Column-Level Security, GDPR, Metadata Management Other Tools Excel (Advanced), Jira, Confluence, Azure DevOps, Power Platform Professional Experience Client: Americold Logistics Atlanta, GA Role: BI Developer. Feb 2023 Present Responsibilities: Designed and deployed enterprise Power BI architecture integrating data from GCP BigQuery, Snowflake, Oracle, and Azure SQL. Developed Power BI Dataflows and semantic models to support self-service analytics. Built and optimized multi-billion row datasets using incremental refresh and hybrid tables. Implemented T-SQL stored procedures and views for enterprise reporting. Automated dataset refresh monitoring using PowerShell and Azure Monitor. Managed metadata governance processes, data integrity checks, and auditing. Maintained and secured database access using row-level and role-based controls. Built CI/CD pipelines in Azure DevOps for report promotion and deployment. Mentored junior developers and led Power BI Center of Excellence initiatives. Supported governance alignment by working with data stewards and architects. Integrated Synapse and ADF pipelines for batch ingestion and transformation. Provided on-call support for data integrity and pipeline failures. Conducted root cause analysis and resolved data quality issues. Created and monitored audit controls to ensure accuracy and compliance. Collaborated with Data Architects on source-to-target mapping and lineage documentation. Tuned complex SQL queries and optimized batch processes through parallel execution. Defined and implemented naming conventions, folder structures, and metadata standards. Participated in design reviews and architecture assessments for new BI solutions. Client: Target Minnesota, MN Role: BI Analyst/Developer Oct 2021 Jan 2023 Responsibilities: Migrated 50+ legacy SSRS reports to Power BI dashboards. Created optimized star/snowflake models across BigQuery, Oracle, and Snowflake. Developed complex DAX for KPI modeling and interactive filtering. Enforced Power BI security with RLS and OLS for multi-tenant access. Used Power Automate and DevOps to orchestrate dataset refresh pipelines. Diagnosed data quality issues, implemented cleansing, and validation logic. Delivered ad hoc reports and scheduled dashboards to business units. Supported Tableau dashboard development and extract refreshes. Delivered stakeholder-aligned visuals using trend, forecast, and heat maps. Collaborated with business stakeholders to translate requirements into visual insights. Designed and implemented version-controlled Power BI assets. Maintained refresh schedules, tested deployment artifacts, and resolved report issues. Contributed to team standards for DAX calculations and visualization patterns. Client: Altran Technologies Hyderabad, India Role: Junior Data Analyst Nov 2019 July 2021 Responsibilities: Built HR dashboards using Power BI and Oracle HRMS data. Scheduled and managed ETL workflows with SSIS and SQL Server Agent. Maintained workspace-level security and user access policies. Designed star schema data models and enhanced visualization performance. Developed parameterized reports and supported multi-departmental analytics. Assisted in QA testing and validated ETL logic across HR datasets. Education Master of Science - Information Systems Trine University, Angola, IN December 2022 Keywords: cprogramm continuous integration continuous deployment quality analyst business intelligence active directory Georgia Minnesota