Power Bi Data Warehousing
Resume:
Anuradha Pradhan
*************@*****.***
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