Post Job Free
Sign in

Power Bi Data Warehousing

Location:
Sunnyvale, CA
Posted:
June 06, 2025

Contact this candidate

Resume:

Anuradha Pradhan

+1-669-***-****

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

Professional Summary

I have 8+ years of experience in IT, specializing in Tableau Desktop, Tableau Server, Power BI Data warehousing, ETL, SQL, PLSQL,Snowflake, Python.

Hands on Experience in development of Reports and Dashboards in Tableau,Power BI

Strong background in Database development and Data warehousing and ETL process and reporting.

Experience with SQL Server, Snowflake,PostgreSQL,MySQL.

Certified on Snow Pro Core.

Excellent experience with DW Concepts such as star schema, Fact and dimensional tables. Experience includes designing, implementation and integrating various Data warehouse and Data Marts.

Good understanding in database and data warehousing concepts (OLTP & OLAP).

Proficient in writing and optimizing stored procedures and functions to implement complex business logic. Skilled in designing and managing indexes to enhance query performance and database efficiency. Experienced in developing triggers for automated data integrity and audit processes.

Expertise in SQL server Job scheduling to execute Integration Services packages and send report to the client.

Hands-on experience with Snowflake databases, schemas, views, and table structures to design and manage efficient data storage and retrieval.

Strong understanding of Snowflake cloud data platform architecture, including its multi-cluster shared data approach, scalability, and performance optimization features.

Extensively working with snowflake to rewrite the existing code from other databases.

Extensive knowledge on loading JSON and CSV files data into Snowflake.

Worked on ETL tools like Talend, Informatica.

Experience in creating filters – Quick filters, Data Source filters, Cascading filters, and Context filters.

Experienced in enhancing dashboard interactivity by creating dynamic parameters, implementing custom sorting and grouping, and applying professional formatting standards in Tableau and Power BI to improve usability, readability, and end-user engagement.

Experienced in designing and generating diverse reports, including detailed Cross-Tab (pivot) reports, to deliver actionable insights and support data-driven decision-making..

Developed customized and interactive dashboards by integrating multiple data sources to deliver comprehensive and actionable business insights.

Extensive experience on Data Blending, Relationships, Joins, Cross database join in Tableau.

Implementing Individual Axis, Axis Blending, and Dual axis in Tableau.

Proficient in creating Groups, Sets, and Data Bins to segment and categorize data effectively for enhanced analysis and reporting.

Experienced in developing Tableau workbooks using both live connections and extracts, including incremental and full refresh strategies, to ensure efficient and up-to-date data visualization.

Generated context filters and data source filters, Extract filters while handling the huge volume of data.

Restricted data for users using Data security through User filter option and USERNAME function.

Skilled in Tableau Desktop for data visualization through various charts such as Horizontal bars, stacked bars, side by side bars, Bar in bar, Pie chart, text tables, highlight tables, Histograms, Heat Maps and Tree maps, Donut chart etc.

Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.

End-to-end experience in designing and deploying data visualizations using Tableau.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and parameterized using Tableau.

Extensive knowledge in various reporting objects like Hierarchies, Filters, calculated fields, Sets, Groups, Actions, Table Calculations, Parameters and LODs etc., in Tableau

Created interactive combination charts in Tableau using dual axes and custom calculations to compare key performance indicators, enhancing dashboard clarity and business insights.

Designed data models, wrote advanced DAX calculations, and used Power Query for data transformation in Power BI to deliver scalable, interactive business dashboards.

Proficient in writing advanced SQL queries using complex joins, subqueries, and CTEs to extract and manipulate large datasets for business intelligence and reporting.

Proficient in Python for data analysis, automation, and ETL scripting, with experience using libraries such as pandas, numpy, and requests to manipulate data, connect APIs, and streamline reporting workflows.

Collaborated with cross-functional team members in a fast-paced Agile environment to deliver bi-weekly software releases.

Leveraged GitHub Copilot to accelerate Python scripting and SQL development, improving code

efficiency and consistency across ETL pipelines.

Used ChatGPT to enhance documentation, debug logic, and explore alternative solutions for complex BI

problems, resulting in faster turnaround on deliverables.

Good communication, interpersonal & professional skills

Ability to rapidly learn new concepts together with excellent interpersonal skills.

Excellent skills in understanding business needs and converting them into technical solutions.

Capability to learn new technologies quickly for project developments.

Extensively Interacted with Clients directly, Quick learner, always eager to learn, Interacted with clients directly

Education Details

Master’s in computer application from Regional College of Management (B.P.U.T), Odisha 2013- 2016

Certifications

SNOWPRO CORE Certified

AHIP (America's Health Insurance Plans)

Technical Skills

Analytics Skills: Data analysis, Data visualization, Data mining, Data Analytics, Business Intelligence, Business Analytics

Data Visualization: Tableau, Tableau Server, Power BI (Desktop edition & web edition),ThoughtSpot

Databases & Query Languages: Snowflake, SQL Server, PostgreSQL, Oracle, SQL, PLSQL, Data cube, OLAP, MOLAP, SSIS, SSRS, MS Access, No SQL,ANSI SQL, MySQL, BigQuery

ETL,Transformation,Orchestration tool & Data Integration: Talend, Informatica, Tableau Prep Builder

Programming, Libraries & Scripting: Python(Pandas, NumPy, Matplotlib, Seaborn, Plotly), SQL, PL/SQL, DAX, HTML

Cloud Platforms: AWS, GCP

Data Warehousing & Data Lakes: Snowflake, Google BigQuery, AWS S3

Design & Presentation: Figma, Keynote, Power Point

Version Control & Collaboration: Git, GitHub, Bitbucket, JIRA, Confluence, SharePoint site

Data Analytics & ML: Excel,Google Sheets

AI Tools: GitHub Copilot, ChatGPT (for code generation, debugging, documentation assistance, and productivity enhancement),Gemini(generation, content creation, and productivity enhancement)

Professional Experience

Company – Carelon Global Solutions Dec2019–

Project Name: HOS Reporting

Client: Elevance Health

Role – Senior Software Engineer

Responsibilities:

Project deals with Medicare, Medicaid and Commercial data (Providers clinical data)

Involved in designing Ingestion framework for data loads from S3 into snowflake using a metadata driven architecture.

Develop stored procedures that would enable automated data loads into snowflake.

Create and deploy permanent and temporary tables, materialised and non-materialised views, schemas and stored procedures.

Create secure and non-secure schemas and views based on usage by business teams and developers.

Worked with different RDBMS databases such SQL Server, Oracle and flat files to bring data into snowflake.

Bulk loading of files from S3 bucket to Snowflake.

Worked on Snow pipe, streams and tasks for continuous data loading to Snowflake tables.

Worked on ETL tools such as Talend to transform data before loading to Snowflake.

Loading the JSON files and flattening it out as per the requirement.

Designed high-fidelity UI mockups and interactive prototypes using Figma, Keynote and Pages.

Created Scatter Plots, Stacked Bars using reference, Bullet chart, Gauge chart and Heat Maps according to deliverable specifications.

Developed interactive dashboards and visualizations using Tableau, Power BI to support data-driven decision-making.

Created Tableau calculations and applied complex calculations to large data sets

Scheduled Extract refresh for weekly and monthly reports.

Worked on permissions, Ownerships and User filters.

Streamlined patient data preparation, including cleansing, standardization, and enrichment to support reporting on patient outcomes, appointment trends, and utilization metrics.

Enabled self-service analytics for clinical and operations teams by delivering curated, governed datasets ready for visualization in Tableau/Power BI.

Automated 80% of repetitive data cleaning and reporting tasks by integrating Python scripts developed with GitHub Copilot, accelerating weekly report delivery by 2x.

Created a scalable ETL pipeline with help from GitHub Copilot, increasing data reliability for dashboard refreshes.

Developed and scheduled Airflow DAGs to automate ETL pipelines that ingested claims, eligibility, and care quality data into Snowflake for real-time reporting.

Tools: JIRA, Tableau Desktop & Server, Snowflake, Tableau Prep Builder, Excel, Power BI, Talend, Agile methodologies (Scrum, Kanban), Figma, Keynote, Pages, AWS S3, Anaconda, Jupyter Notebook, VS Code, GIT, GitHub Copilot

Project 2:

Project Name: EDA Agile Metrics

Client: Elevance Health Feb2021– Mar2025

Role – Senior Software Engineer

Responsibilities:

Project deals with displaying all the Agile team information such as Team Size, Sprint Story counts, Defects, feature cycle time, Backlog health etc.

Creating Dashboard /Reports to analyse the monthly summary using Tableau.

Connecting with Scrum masters and managers on monthly basis to discuss the improvement of metrics

Attending meetings to identify risks and maintain project targets.

Monitoring and troubleshooting data source systems for data flaws and errors and upstream data issues.

Interpreted data and translated ad hoc requirements and requests to deliver relevant and impactful results.

Developed SQL queries for data analysis and enhancing reporting capabilities for stakeholders.

Tools: Tableau, Share point site, JIRA, SQL Server, Excel, Agile methodologies (Scrum, Kanban), confluence

Project 3:

Project Name: Demand Management

Client: Anthem Inc Feb2021 - Dec2023

Role – Senior Software Engineer

Responsibilities:

The Project deals with displaying all the details about the demand of application along with demand trend by device cost & count, YOY%, MOM%, Current vs previous demand forecasting comparison, total demand % and forecasting.

Expertise in identifying and analysing the business need of the end users and building the project plan to

translate the functional requirements into the technical task that guide the execution of the project.

Bulk Loading from the external stage (AWS), Internal Stage to Snowflake cloud using the COPY command.

Loading data into snowflake tables from internal stage using Snow SQL.

Stage file to snowflake internal staging area and external AWS S3 buckets. Used COPY, LIST, PUT and GET commands for validating the internal stage files. Used Import and Export from the

internal stage (snowflake) from the external stage (AWS S3).

Used SNOW PIPE for continuous data ingestion from the S3 bucket.

Create ETL Specification document that outlines the entire process flow and the execution process.

Designed, build and managed ELT data pipeline using Informatica.

Utilize Tableau, Power BI to develop various dashboards and reports/Sheets.

Used various visualizations such as table, scatterplot, pie charts, columnar, bar in bar chart, gauge reports.

Created Actions, parameters, calculations, LODs, Background Images, Maps, Trend lines, Table calculations, Row level Security.

Hands on in building groups, hierarchies, sets to create detail level summary report and dashboard using KPIs

Provided production support to Tableau users and wrote custom SQL to support business requirements.

Utilized Tableau server to publish and share the reports with the Business users.

Also involved in administration tasks such as setting permissions, managing ownership and provided access to the users and adding them in to the specific group.

Distributed Tableau reports using techniques like packaged workbook, PDF to different user Community.

Tools: Tableau, Power BI, Snowflake, SQL Server, ETL, Excel, AWS S3

Project 4:

Project Name: Pathfinder

Client: Anthem Inc. Dec2019- Feb2021

Role -Software Engineer

Responsibilities:

Project deals with Medicare and Medicaid data.

Involved in data extraction, data cleansing, data mapping, data consolidation, data loading and data

reconciliation.

Developed and maintained ETL processes to consolidate data from other business units and

departments (Excel, CSV and Text).

Implementing Slowly Changing Dimensions (SCD) to maintaining historical data in required dimension tables.

Creation and scheduling of ETL Packages using SQL Server Management Studio.

Involved in design of database and created Data marts extensively using Star Schema.

Worked extensively on SQL and involved in creation of tables, views using SQL Server.

Developed stored procedures in SQL Server and used ETL for loading dimensions and facts.

Involved in documentation of end-to-end process starting from development till migrating of objects to

production.

Extract and analyse data using Power Query, Pivot tables, MS Excel, Power BI.

Used DAX to create complex measure and calculated columns.

Setting up Power BI environment, creating app workspaces, publishing app and setting up Power BI gateway.

Created Page level filters, Report level filters, visual level filters in Power BI according to the requirement.

Created dashboard and App workspace for the originations to get the updated Power BI Reports and added the refresh time for each tile in the dashboard.

Converted existing Power BI reports to Tableau dashboards.

Developed Tableau data visualization using cross tabs, donut chart, Heat maps, scatter plots, Geographic Map, Pie charts, Bar charts, Line charts.

Worked extensively with advanced analysis Actions, Calculations, Parameters, dual axis, Tooltip, LODs.

Utilized Tableau server to publish, share, schedule and Extract refresh reports.

Tools: Tableau Desktop & Server, Power BI, SQL Server, Informatica, Excel, JIRA, Agile methodologies (Scrum, Kanban), Anaconda, Jupyter Notebook, VS Code, GitHub

Company - Sapient, Bangalore, India Aug 2016–Nov2019

Project 1:

Project Name: CRMS Managed Services

Client: Royal Bank of Scotland

Role - Associate Software Engineer

Responsibilities:

Compliance management Reporting system (CMRS) Reg report is a Sapient proprietary solution, Conceptualised and developed by Sapient to allow market participants to seamlessly integrate with third party trade capturing systems.

This system allows CMRS Reg report sends required information to trade repositories in the accepted formats after data processing and transformation

I was a Part of the managed services team for RBS with a primary role in creating and sharing BI Reports with the client using Power BI and Tableau.

Worked on full life cycle development SDLC involving in all stages of development.

Created and maintained database in development, testing, and production environments using SQL Server.

Created database objects such as schemas, Tables, Indexes, views, User defined functions, Stored procedure.

Extensively used Joins, Sub Queries, Table variables, Global and Local Temp tables.

Designed, performed unit testing and implemented stored procedure and triggers for processing huge volume of data.

Created and managed Clustered Indexes and Non-Clustered Indexes and optimized queries using execution plan.

Worked on Index tuning as required for performance improvement of the applications SQL tuning.

Created Dashboard /Reports to analyse the weekly/Daily summary using Power BI and Tableau.

Implemented advanced DAX queries in Power BI desktop, providing detailed insights and enabling 20% better performance.

Migrated Power BI reports to Tableau using Tableau Desktop.

Tools: Power BI, Tableau, SQL Server, CMRS tool,JIRA,ServiceNow



Contact this candidate