PowerBi, Sql, Azure, Snowflake, Cognos

RAMA GADDE

+1-404-***-**** ****.*********@*****.***

Power BI Developer Snowflake & Azure Data Analytics

PROFESSIONAL SUMMARY

•Business intelligence developer with 10+ years delivering reporting and analytics on Power BI, Snowflake, and the Microsoft Azure stack across insurance, healthcare, energy, and IT services.

•Deep hands-on work with Snowflake, including SnowSQL, Snowpipe, COPY INTO bulk loads, and internal and external stages feeding governed reporting layers.

•Built and tuned ELT pipelines moving data in and out of the Snowflake Data Warehouse using a blend of Python and SnowSQL.

•Strong command of Azure Data Factory for orchestrating ingestion, transformation, and scheduled data movement into ADLS and Snowflake.

•Experienced with Azure Databricks and PySpark for cleansing and reshaping large structured and unstructured datasets.

•Modeled analytical layers on Azure Synapse Analytics and curated Azure SQL Database sources for downstream Power BI consumption.

•Designs star schema and snowflake schema semantic models tuned for fast, reliable DAX analytics.

•Authored advanced DAX — calculated measures, calculated columns, variables, and Time Intelligence — following performance best practices.

•Strong Power Query (M) skills for shaping, merging, pivoting, and cleansing data before it reaches the model.

•Creates interactive Power BI dashboards using slicers, drill-through, bookmarks, tooltips, and custom visuals tailored to each audience.

•Produces pixel-perfect paginated reports with Power BI Report Builder and legacy SSRS for print-ready operational reporting.

•Manages the full Power BI Service lifecycle — workspaces, apps, dataflows, gateways, and scheduled refresh.

•Implements Row-Level Security (RLS) and dynamic security patterns to keep sensitive data scoped to the right users.

•Configures Snowflake RBAC — roles, grants, and resource monitors — to balance access, cost, and governance.

•Sets up Snowflake secure views, data sharing, Time Travel, and zero-copy cloning for secure, repeatable analytics.

•Automates recurring data tasks with Python scripts and integrates systems through REST APIs and JSON payloads.

•Streamlines approval and notification workflows with Power Automate and builds lightweight front ends in Power Apps.

•Migrated legacy Cognos, MicroStrategy, and QlikView content to Power BI during platform consolidation efforts.

•Builds and maintains SSIS packages and complex T-SQL — stored procedures, functions, triggers, and views — across SQL Server environments.

•Tunes slow-running queries and reports through indexing, query refactoring, and Snowflake warehouse right-sizing.

•Practices data profiling, data validation, and reconciliation to keep reporting accurate and trustworthy.

•Delivers under Agile/Scrum and full SDLC, contributing to sprint planning, reviews, and retrospectives.

•Supports deployments through CI/CD pipelines and source control with Git, promoting reports across Dev, Test, and Prod.

•Leads onshore and offshore developers, runs code reviews, and mentors teammates on Power BI and Snowflake best practices.

•Comfortable presenting complex technical solutions to senior stakeholders and training end users to adopt self-service BI.

TECHNICAL SKILLS

Languages: SQL, T-SQL, Python, JavaScript, UNIX/Shell scripting, DAX, M (Power Query)

BI & Reporting: Power BI (Desktop, Service, Report Builder, Mobile), Power BI Dataflows, SSRS, Tableau, QlikView, QlikSense, Cognos

Snowflake: SnowSQL, Snowpipe, COPY INTO, internal/external stages, file formats, VARIANT/FLATTEN, secure views, streams & tasks, data sharing, Time Travel, RBAC, ELT, performance tuning

Azure Cloud: Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure Data Lake Storage (ADLS Gen2), Azure SQL Database, Azure Blob Storage, Azure Active Directory, Azure Virtual Machines

ETL & Integration: SSIS, DBT, Power Query, REST APIs, JSON, Power Automate

Databases: Snowflake, Azure SQL Database, SQL Server (2008-2019), Oracle 11g/12c, PostgreSQL, Teradata, MySQL

Data Modeling: Star Schema, Snowflake Schema, Tabular Model, DAX Measures/KPIs, Row-Level Security (RLS)

Analytics Services: SSAS, SSIS, SSRS

Practices & Tools: Agile/Scrum, SDLC, Jira, SharePoint, Power Apps, CI/CD pipelines, Git

PROFESSIONAL EXPERIENCE

Humana – Louisville, KY Aug 2024 – Present

Power BI / Snowflake Developer

•Designed Snowflake dimensional models with conformed dimensions and fact tables organized into RAW, STAGING, and CURATED schemas, right-sizing virtual warehouses (X-Small to Medium) to control credit usage.

•Built incremental ELT in Snowflake using Streams on staging tables and scheduled Tasks to MERGE change-data into curated fact and dimension tables.

•Loaded JSON and Parquet files from ADLS Gen2 into Snowflake through external stages and COPY INTO, parsing semi-structured payloads with the VARIANT type and FLATTEN.

•Built Azure Data Factory pipelines using Copy, Lookup, and ForEach activities with parameterized linked services and tumbling-window triggers to land source extracts in ADLS Gen2.

•Developed PySpark transformations in Azure Databricks notebooks, writing curated Delta tables consumed by Snowflake and Power BI.

•Wrote DAX measures with CALCULATE, FILTER, SAMEPERIODLASTYEAR, and DATEADD for YoY, MoM, and YTD trend and variance reporting.

•Shrank model size and refresh time through star-schema design, integer surrogate keys, disabling auto date/time, and VertiPaq-friendly column typing.

•Configured incremental refresh policies and composite models with aggregation tables to keep large datasets responsive in Power BI.

•Built paginated reports in Power BI Report Builder using table/matrix layouts, grouping, and page breaks for printable claims and remittance statements.

•Implemented Row-Level Security with DAX filter roles mapped to Azure Active Directory security groups for member- and region-level isolation.

•Migrated legacy Cognos and MicroStrategy reports to Power BI, re-creating logic in DAX and validating output against the source reports.

•Established governance via certified datasets, naming conventions, shared dataflows, and a documented promotion path across Dev, Test, and Prod workspaces.

•Set up CI/CD for Power BI using deployment pipelines and Git-integrated workspaces for version control and controlled releases.

•Automated approval routing and refresh-failure alerts with Power Automate, notifying owners through Teams and email.

•Wrote Python scripts (pandas, snowflake-connector) to stage external files, validate row counts, and trigger Snowflake loads on schedule.

•Pulled data from REST APIs, parsed JSON responses, and landed structured tables in Snowflake for reporting.

•Surfaced AI/ML risk-score outputs in Power BI by joining prediction tables into the model and visualizing with KPI and decomposition-tree visuals.

•Tuned slow Snowflake queries using Query Profile, clustering keys on large tables, and result caching to cut warehouse runtime.

•Ran requirement workshops with business leaders, documented report specs, and translated them into a prioritized delivery roadmap.

Environment: Power BI Desktop, Power BI Service, Power BI Report Builder, Snowflake, Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure Blob Storage, DBT, Python, PySpark, T-SQL, SSMS, Power Apps, SharePoint, Jira, CI/CD pipelines

AXA XL – Manhattan, NY Jan 2020 – Jun 2024

Senior Power BI Developer

•Partnered with the Director of Analytics and underwriting and actuarial SMEs to capture KPIs and turn them into Power BI report specs and mockups.

•Built reusable Power BI dataflows in Power Query (M) sourced from Azure Databricks and the Azure portal to centralize policy, claim, and broker entities.

•Created curated tables in Snowflake and ADLS, then connected Power BI through the Snowflake connector in both Import and DirectQuery modes based on volume.

•Modeled a star schema over Azure SQL Database with premium and loss fact tables and policy, date, and region dimensions.

•Wrote DAX using VAR-based measures, TOTALYTD, SAMEPERIODLASTYEAR, and ALLEXCEPT to control filter context for loss-ratio reporting.

•Built interactive visuals — Dual KPI, table heat maps, decomposition tree, slicers, gauges, and filled maps — with drill-through pages and report/visual-level filters.

•Developed Python (pandas) scripts to automate extract-transform steps feeding the warehouse, cutting manual prep by roughly 20%.

•Used PySpark in Azure Databricks to cleanse, dedupe, and join large policy and claims datasets before loading Snowflake staging.

•Created Snowflake tables, views, and secure views, plus file formats and stages for CSV and JSON ingestion via COPY INTO.

•Built pixel-perfect paginated reports in Power BI Report Builder for regulatory and bordereaux reporting with parameter-driven filtering.

•Designed mobile-optimized layouts in Power BI Mobile view so field underwriters could read KPIs on tablets.

•Implemented Row-Level Security with role mapping and validated each role using “View as” to enforce business-unit boundaries.

•Packaged reports into Power BI Apps and published to audience-specific workspaces with managed permissions.

•Modeled hierarchies (product > line > peril; geography) and used bookmarks and tooltips to support self-service exploration.

•Maintained QlikSense dashboards and administered QlikView/QlikSense reloads, scheduling QVD extracts and monitoring task chains.

•Integrated Tableau with Python (TabPy) to surface forecasting and predictive outputs inside existing dashboards.

•Configured scheduled refresh and on-premises data gateway connections for Azure SQL and Snowflake sources.

•Reconciled Power BI measures against source SQL queries and prior reports to validate figures before sign-off.

•Participated in design reviews, recommending data-model normalization and DAX refactors to improve refresh performance.

•Documented technical specs, data lineage, and measure definitions, then unit-tested and released the final reports.

Environment: Power BI, Snowflake, Azure Databricks, Azure Data Lake Storage, Azure SQL Database, Python, SQL Server, Oracle, Tableau, QlikSense, NPrinting, SharePoint

Gas South – Atlanta, GA Jan 2016 – Nov 2019

Power BI Developer

•Built Power BI dashboards for billing, consumption, and customer-care metrics using slicers, line/pie charts, maps, scatter plots, histograms, heat maps, and tree maps.

•Imported custom visuals from AppSource and configured them in Power BI Desktop where native visuals fell short.

•Authored DAX calculated measures and KPIs with CALCULATE, SUMX, DIVIDE, and RELATED for decision-support dashboards.

•Wrote T-SQL stored procedures, scalar and table-valued functions, and views, tuning execution plans for efficient retrieval.

•Built parameterized, drill-down, drill-through, and sub-reports with matching report parameters.

•Designed dimension hierarchies and allocation logic to deliver the KPIs requested by finance and operations.

•Developed metadata-driven SSIS packages with Lookup, Derived Column, Conditional Split, and Slowly Changing Dimension transforms to load the data mart.

•Built SSAS cubes with measure groups and dimension hierarchies for ad-hoc analysis.

•Published reports to Power BI Service and scheduled dataset refreshes through the on-premises gateway.

•Created drag-and-drop, web-shared dashboards so business users could self-serve common views.

•Used trend lines, dual-axis charts, groups, and sets to build summary and exception reporting.

•Developed SSRS paginated reports with grouping, expressions, and matrix layouts for operational distribution.

•Implemented cascading parameters so selecting a region filtered the available service territories and accounts.

•Optimized refresh and query performance by adding nonclustered indexes, refactoring T-SQL, and lowering dataset cardinality.

•Blended data from Excel, flat files, and SQL Server using Power Query merge and append operations.

•Configured SSRS report subscriptions for scheduled email delivery to stakeholders.

•Encapsulated business logic in stored procedures to standardize calculations across multiple reports.

•Applied report-level and page-level filters to scope each page to its intended audience.

•Documented report specs and walked stakeholders through wireframes to confirm requirements before build.

•Built reports combining multiple data providers, global variables, and aggregate-aware queries for complex layouts.

Environment: Power BI Desktop, Power BI Service, MS SQL Server 2012, SSIS, SSAS, SSRS, Visual Studio 2010, MS Excel, Windows

Minacs Private Ltd – Bengaluru, India Apr 2014 – Oct 2015

BI Developer

•Analyzed onshore change requests and new requirements, estimating effort and breaking work into development tasks.

•Translated business requirements into technical specs and built the corresponding SSRS reports and Excel dashboards.

•Connected, imported, and transformed data from SQL Server and Excel for reporting and early Power BI Desktop visuals.

•Designed dashboard templates with stacked column, waterfall, donut, geospatial, histogram, and tree-map visuals to match stakeholder layouts.

•Modeled reporting structures using ODS, star and snowflake schemas, and data-lake concepts.

•Created SQL tables, views, stored procedures, and user-defined functions to support report queries.

•Automated recurring report generation with VBA macros in Excel to remove manual steps.

•Imported and parsed data from Excel and text files, cleansing it before load.

•Scheduled Cognos reports to run on daily, weekly, and monthly cadences per business need.

•Set up auto-scheduling and distribution to eliminate manual report runs and reduce delivery delays.

•Performed QA on dashboards and reports, validating totals against source before release.

•Investigated and resolved data-quality and processing issues flagged during validation.

•Fulfilled ad-hoc reporting requests and quick-turn data queries from onshore teams.

•Built functional scorecard presentations summarizing KPIs for monthly business reviews.

•Managed file-handling and transfer processes for report inputs and generated outputs.

•Updated databases and report objects to match evolving onshore requirements.

•Ran knowledge-transfer and onboarding sessions for new joiners on reporting standards.

•Coordinated daily with onshore teams over email and messaging to track status and blockers.

•Built operational reports using MS SQL Server, SSRS, and MS Office tooling.

•Planned and delegated technical tasks, validating each stage of the reporting workflow.

Environment: Power BI Desktop, Power BI Service, MS SQL Server 2008R2/2012/2014, SSIS, SSRS, SSMS, Visual Studio, MS Office, Windows Server 2008

EDUCATION

M.sc (IT) (Master of Science In Information Technology) from Nagarjuna University, AP, Passed with 67% and period 2009-2011

PGDIT (Post Graduate Diploma In Information Technology) from JNTU, Hyderabad, Passed with 81% and period 2007-2009

B.Sc (Bachelor of Science) from Nagarjuna University, Andhra Pradesh, Passed with 61% and period 2004-2007

XII (Intermediate) from Board of Andhra Pradesh, Passed with 67 % and period 2002-2004

Secondary School Certificate (X) from Board of Andhra Pradesh, Passed with 70 % in 2002

Contact this candidate