Power Bi Data Quality

HIMANA DHYAPULAI

*********@*****.*** 857-***-**** www.linkedin.com/in/himana-d-399138127

TECHNICAL EXPERIENCE

•Databases: AWS (DDB, RDS and S3), Snowflake, MSSQL, Oracle, DB2, SAP HANA, MySQL, PostgreSQL, SQL, MongoDB, Vertica

•Languages: Python, Trino SQL, Presto SQL, T-SQL, PL/SQL, Shell Script

•Tools and Technology: Alteryx, power bi, Tableau, Qlik Sense, SSIS, Informatica, Toad, JIRA, GitHub, Confluence

ACHIEVEMENTS:

•Qlik Sense – Visualizations and Data modeling (Healthcare /Energy & Trading Domain/ Retail)

•Tableau – Advanced level certifications

•Power BI - Associate and advanced level certification, DAX certification

•SSIS & Alteryx – ETL development

WORK EXPERIENCE

Fox Factory, Scotts Valley, USA

Senior Business intelligence Quality Analyst May 2023 – Present

•Automated real time health checks on data observability platform leveraging AWS stack to display data quality trends in critical attributes from 500 + tables that enabled proactive identification of outliers and reduced downstream impact by 99%.

•Gathered data from Azure cloud, SAP, Excel, and other data sources. Transformed the data and produced reports using the Power BI platform. Optimized dashboards with a focus on usability and performance.

•Developed and implemented reporting, analytics, and Data visualization solutions with Power BI.

•Architected and single handedly deployed Data Quality infrastructure from ground up after performing through research of relevant DQ tools in market for organization's 1TB product data which led to 99.99% data accuracy.

•Developed ETL logic to source product data from cloud, cleansed and transformed it to make it fit for data scientists to build ML models and reports for sending intelligent recommendations to end users.

•Designed and implemented ETL workflow in AWS Glue studio which proactively validated accuracy of critical DB master data preventing 75% DQ errors in downstream tables and reports.

•Led effort to implement changes in Agile framework for 60+ SQL scripts across various data functions and successfully deployed to Production DAGs by administering version control through GitHub and Bitbucket

•Performed metadata migration governing global product usage data from legacy catalog to data observability tool using SQL and APIs, and mentored team of 50 on the new tool for smooth transition.

•Working knowledge of Power BI (Power Pivot, Power View, Power BI Online, Power BI Desktop, Power BI Publisher) and DAX.

•Design and Implement reporting solutions using Reporting Services, Power BI, or other data visualization tools.

•Gathered business requirements, communicating directly with the users, progress and keeping track of the reports.

•Creating data sets for the reports using SQL server and oracle and manipulating the data as per requisition

•Effectively communication business processes with the users and executives from beginning to end of the project.

•Carrying out research projects to progress to exceed expectations of the end clients.

Kaiser Permanente

Lead Data Quality Analyst Nov 2021 – May 2023

•Led a team of 5 to consistently achieve 99% success in targeting correct set of audience through company’s critical email marketing campaigns by endorsing end to end analysis and testing of customer activity data to ensure dataset is fit for purpose.

•Managed and delivered on cross team project that involved profiling data from multiple sources - web, call center & surveys using Alteryx, transformation of values as per business logic and developed dataset for holiday marketing campaign with 99.9% accuracy.

•Made over 800 insertions and 150 deletions to 4 central Firmware repositories in less than 3 months.

•Participated in more than 4 projects per year from initial research and conceptual design through testing and implementation phases.

•Developed internal tools for text mining (sentimental profiling), and web crawler for collecting data by SQL.

•Involved in creating database objects like tables, views, procedures, triggers, functions using Oracle SQL to provide definition, structure and to maintain data efficiently.

•Carried out multiple data manipulation and migration jobs using python and ETL tools like DB2, Qlik sense and Alteryx/ SSIS.

Venus Fashion Inc., Florida USA

Qlik sense and Tableau developer Feb 2020 – Nov 2021

•Lead creating complex table, matrix, sub reports and chart reports using SSIS.

•Transform data from SQL tables to these data models using Qlik sense’s proprietary scripting language.

•Used Microsoft SharePoint to create and design pages for SSIS, Informatica Power Centre and Power BI reports for specific requirements given by clients.

•Monitor ETL process and debug the technical issue to make sure the dashboard is delivered accurately and efficiently.

Florida Blue BCBS, Florida, USA

Senior Business intelligence developer Oct 2019 – Feb 2020

• SQL Data profiling for report building and gap profiling

•Alteryx development for Data cleaning and data prepping.

•Performing and documenting data profiling, data validation using SQL, and data mapping/design.

•Developing, maintaining, and managing advanced reporting, analytics, dashboards and other BI solutions.

•Utilizing tools like Alteryx and Power BI to develop and migrate dashboards from.

•Prepared scripts to ensure proper data access, manipulation and reporting functions with R programming languages.

•Formulated procedures for integration of R programming plans with data sources and delivery systems.

•Provided technical assistance for development and execution of test plans and cases as per client requirements.

•Data mapping using Power BI for last minute presentations purposes.

•Communicating requirements to Users and allotting them within the project.

•Rebuilding and developing ETL processes from SQL to Talend for productive environment.

•Reviewing and improving existing systems and collaborating with teams to integrate new systems.

•Conducting unit tests and developing database queries to big query the effects and troubleshoot any issues.

•Creating tools to store data within the organization.

USF Health, Tampa, USA

Data analyst Oct 2017 – Oct 2019

•Design, build and maintain all components of data warehouse which includes numerous numbers if ETL processes, stored procedures, reporting environments, dashboards, scorecards, ad hoc requests on regular basis- monthly, quarterly and daily utilizing SQL as a language to communicate.

•Develop huge number of ETL processes for error handling, data manipulation, data preparation using SSIS, Qlik Sense, Power BI and Talend using SQL server management console/ database.

•Rebuilding and developing ETL processes from SSIS to Informatica Power Centre for productive environment.

•Utilizing business objects in designing and building the reporting environment

•Developing executive summary, departmental and provider independent dashboards using SAP business objects and later migrating it into Qlik Sense

•Hands-on professional with thorough knowledge of ETL, Data modeling scripting and Python

•Translating business requirements into Qlik based solutions and Tableau solutions into Informatica Power Centre solutions.

•Reviewing and re-developing Power BI dashboards for executive decision – making.

•Understanding of healthcare procedures and management, knowledge of enterprise Data warehouse (EDW) and data management systems

•KPI metric development: Carried out modifications of various KPI metrics depending upon the requirements and definitions requested.

•Handled various Healthcare research and reporting projects utilizing required tools.

Rudolph Technologies, MA, USA Jan 2017 – Sep 2017

•Carried a research program on comparing different (ETL tools) Data loaders – Talend, Apache Nifi

•Integrated datasets from Oracle and Vertica into Vertica database with Energy & Trading Domain data.

•Generated Task scheduling reports and to collect, organize, big query, and disseminate significant amounts of information.

•Created dashboards, reports, visualizations, and analytics using Qlik Sense followed by ETL to integrate different data subsets from 4 different databases SQL server, MySQL, Postgres, and Oracle

•Carried Data visualization and profiling on Data sources provided using Qlik Sense and accessed reports generated through Qlik sense cloud.

•Automated the manual data loading procedure using Apache Nifi / Talend

•Produced reports and created dashboards using Tableau, Qlik sense and Ad hoc on Energy & Trading Domain dataset.

•Developed Dimensional data modelling, familiar with snow, star, dimensions and facts, Qlik sense profiling.

•Developed meaning insights using Tableau, Qlik view and Power BI

•Created ETL scripts under Vertica and Oracle database platform, cleared dataset anomalies using SSIS and SSAS

•Carried Data integration tasks on Qlik Sense management console.

Data Scape, Dublin, IR Jan 2014– Dec 2015

•Performing data profiling, data collection systems and other strategies that optimize statistical efficiency and quality.

•Acquiring data from primary or secondary data sources and maintaining databases where I got to perform analytical research on three different teams and their productivity.

•Using Business analyst tools like JIRA and Microsoft program manager sheets to keep track of the performance of the teams in order to calculate productivity.

•The final stage involved developing Dashboards using Power BI based off the profiling performed on the teams and updating the Data within the private cloud and later on hybrid cloud using Company’s credentials.

Cloud gauge, Dublin, IR Jan 2013– Nov 2013

•Carried a research program comparing different ETL tools for further development on hybrid cloud data.

•Integrated different installation packages on one operating system to observe the processing time.

•Developed visualizations and analytics using Tableau and power pivot to figure out the memory limits of private cloud.

EDUCATION

Northeastern University, Boston, MA Dec 2017

Master of Science - Information Systems

Coursework: Data Design and DBMS, Data Warehousing and BI, Big Data Management, Advances in Data Sciences, Java, Web Design

National College of Ireland, Dublin, IR Dec 2012

Post Graduation – Cloud computing.

Coursework: Cloud Infrastructure, Cloud Security, Cloud Architecture, Research and Development, Virtualization, Data Storage

Aurora’s Scientific Technological and Research Academy, India Nov 2012

Bachelors of technology – Information technology

Contact this candidate