Power Bi Data Visualization
Resume:
ARCHANA DINDIGALA
*********@*****.*** 289-***-****
PROFESSIONAL SUMMARY
6+ years of extensive experience in Business Intelligence, Data Analysis and Data Visualization, specializing in Power BI, Tableau, and SQL Server for analytics, design, implementation, administration, and support.
Skilled in creating diverse visualizations, dashboards, charts, and reports using Power BI and Tableau.
Proficient in enhancing Power BI dashboards with embedded JavaScript for improved aesthetics and functionality.
Proficient in Python, R, Looker, and big data platforms like Apache Hadoop, complementing BI tool expertise.
Extensive experience with Tableau Desktop and Server for data visualization and analysis.
Demonstrated proficiency in Data Warehousing methodologies, including star and snowflake schemas, ETL processes, dimensional modeling, and reporting tools.
Developed analytical applications using Power BI and Tableau, integrating various Azure Data Services sources. Proven expertise in Data Engineering with Azure.
Expert with ETL processes, data analysis, migration, preparation, validation, quality assurance, reporting, and documentation.
Proficient in writing DAX functions for Power BI reports and dashboards, covering filter, time-intelligence, logical, and mathematical/statistical functions.
Experienced in all aspects of ETL pipeline development and operational system metrics reporting using Microsoft BI tools.
Skilled in SQL query writing, stored procedure development, and trigger creation using PostgreSQL and SQL Server.
Well-versed in Microsoft BI stack, including SSIS, SSRS, and SSAS, with hands-on experience in OLAP, data warehousing, and data mining.
Experience with Azure technologies such as Data Factory, Synapse, Databricks, Data Lake, and Power Platform.
Implemented Azure Data Factory for data ingestion from diverse source systems, including relational and unstructured data.
Created ADF pipelines using Linked Services, Datasets, and Pipeline components for ETL processes across various Azure data services
Utilized Python for data cleaning and analysis of large, complex datasets, facilitating data visualization for executive presentations and tool development
Developed parameterized, dashboard, linked, and sub-reports segmented by various time frames (Year, Quarter, Month, Week)
WORK EXPERIENCE
Sr. Power BI Developer/Data Analyst Emburse - Toronto, ON 11/2021 - Current
Emburse is a company that provides expense management and accounts payable automation solutions for businesses
Responsibilities:
Designed a Power BI Data Model with multiple Fact Tables and Dimensions depending on the business requirements
Developed Power BI dashboards using Tabular and Multi-Dimensional models with advanced analytical capabilities for critical internal KPIs
Implemented complex DAX measures and calculated columns utilizing comprehensive DAX function libraries including Date/Time, Time-intelligence, Filter, Logical, and Statistical functions
Created custom visualizations like Gantt, Skyline, Timeline, and Gauge charts to enhance data representation and insights
Executed data mapping and source code development in SQL Server for comprehensive data visualization strategies
Extensively worked with Azure technologies including Databricks, Data Factory, and Azure Monitor for robust big data analytics and performance optimization
Performed advanced data integration by connecting multiple data sources (Oracle, SQL, Excel) and implementing sophisticated ETL processes
Optimized database performance through strategic T-SQL query modifications, execution plan analysis, efficient indexing, and join optimization techniques
Developed and maintained SQL database objects including tables, stored procedures, and complex database interactions
Conducted comprehensive data profiling and preparation using advanced tools like Talend, Azure Machine Learning Studio, and Python programming
Implemented end-to-end data pipeline management with seamless integration between Power BI, Azure services, and various database platforms
Used advanced features of T-SQL to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL
Technical Snapshot: MS Office, Power BI, Power Query, Python, Shell Scripting, Power Pivot, SQL Server, Snowflake, MS SQL Server, ADF, Data Bricks, Azure Cloud, Azure SQL Database, Azure Data Lake, Azure Blob, T-SQL, C#, SQL
Data Analyst Cardinal Health – Vaughan, ON 09/2018 - 10/2021
Cardinal Health is a global, integrated healthcare services and products company. operates across various segments of the healthcare industry, including the distribution of pharmaceuticals and medical products and supply chain management.
Responsibilities:
Analyzed data trends, patterns, and outliers to uncover insights, collaborating closely with business analysts and stakeholders to meet data requirements and provide analytical support
Implemented efficient data blending techniques and minimized query execution times to boost dashboard performance
Implemented complex DAX functions, measures, and calculated columns in Power BI for advanced data analysis
Automated Power Query refresh using PowerShell scripts and Windows Task Scheduler
Integrated various data sources into Power BI, including SQL Server, SAP BW, Oracle, and SQL Azure
Developed Excel Power View, Power Query, and PowerPivot dashboards for comprehensive data analysis
Designing and developing interactive dashboards and visualizations using Tableau Desktop
Created custom SQL queries within Tableau for direct data extraction from databases and data warehouses, particularly for large datasets and complex data models
Optimized Tableau dashboards and reports for enhanced performance by improving query execution, refining data extracts, and ensuring responsive user experiences
Designed visually compelling data visualizations using Tableau to effectively communicate complex concepts to customers and leadership
Created stored procedures and SQL queries to populate Power Pivot models, transforming complex business logic into efficient database designs
Developed SSIS packages for data import from diverse sources (Access, Excel, XML, OLE DB, Flat Files) and implemented various SSIS tasks (Execute SQL, Bulk Insert, Data Flow, FTP, Send Mail)
Designed SSAS solutions with multiple dimensions, perspectives, hierarchies, measure groups, and KPIs for analyzing business unit performance
Designed confidential proprietary analytical tools using Excel
Technical Snapshot: Power BI, SQL Server, SSMS, SSIS, SSRS, SSAS, T-SQL, Tableau, Power BI, MS Excel, C#,Jira, SQL Profiler, Informatica, Talend, Apache, Looker, ML, Python, R
SKILLS
Programming Languages: SQL, Python, R, M, JavaScript
Storage: Azure Data Factory, Azure SQL
Frameworks & Libraries; Pandas, Flask, AWS, Snowflake, NumPy, Hibernate, Data stage, HDFS, Matplotlib
Cloud Technologies; PCF, EC2, EBS, S3, Docker, ECS, EBS, EKS, S3, Azure, Glacier, Google Cloud, Lambda,
Analytics: Power BI, Tableau, MS SQL Server, Machine Learning, Big Data Analytics, Business Intelligence, Statistical Analysis, Pivot Tables, Power Query, Macros, VBA, DAX, M Query, A/B testing, ETL, NLP, Regression, Clustering, Decision Trees.
Databases; Oracle, MySQL, Postgres SQL, Mongo DB, DB2, SQL Server, Swagger, MYSQL, MongoDB.
EDUCATION
JNTU
Masters in Business Administration
Contact this candidate