Power Bi Data Analyst

Venkat Vajja

Email: ************@*****.***

Phone: +1 (732) 704 - 6262

LinkedIn: linkedin.com/in/venkat-v-3b2435248

Professional Summary:

Overall, I have around 9 years of experience as a results-driven BI/Data Analyst with extensive experience in transforming raw data into actionable insights across diverse industries. Proficient in leveraging advanced BI tools and platforms, including Power BI, Tableau, and Snowflake, to design and develop interactive dashboards, reports, and multi-dimensional data models. Expertise in optimizing data processes using SQL(MSSQL/PLSQL/SNOWSQL).

●Skilled in designing and mapping data models, developing interactive dashboards, and generating comprehensive reports using Power BI and Tableau.

●Having IT industry experience using DW technologies Snowflake, MSBI and Data modelling.

●Gained hands-on experience with Snowflake (cloud data platform) and Azure (cloud computing platform) to manage and analyze large-scale data environments, leveraging Power BI for reporting and data visualization.

●Proficient in implementing automated workflows, optimizing SQL queries, and leveraging indexing techniques for efficient data handling.

●Having Strong data analysis skills including data mapping from source to target database schemas, data cleansing, processing, writing data extract scripts for data conversion and researching complex data problems.

●Expertise in Power BI, Tableau and SSRS including support, troubleshooting, report design and monitoring of system usage using Tableau suite (Desktop/Server/Public/Reader/Mobile) and Power BI.

●Proven track record in designing and analyzing data visualization dashboards using Tableau to facilitate business decision-making.

●Proficient in Python Libraries like (Pandas, NumPy, Matplotlib, Seaborn), SQL, and R for data analysis and visualization.

●Proficient in Informatica PowerCenter (versions 8.x–10.x), Power Exchange, and Informatica Cloud Data Integration (IICS) for building scalable ETL pipelines.

●Experienced in integrating data from diverse sources including relational databases (Oracle, SQL Server, DB2), flat files, XML, JSON, and web services.

●Experienced in conducting User Acceptance Testing (UAT), performing data validation with Splunk, and developing new SQL scripts to enhance data processes.

●Experience with statistical programming languages such as R and Python.

●Utilized advanced data profiling techniques to analyze structured and unstructured data, ensuring accurate data mappings and high-quality data outputs.

●Proficient in utilizing Snowflake for interactive data visualizations and complex reporting, including writing SNOWSQL scripts.

●Designed and executed queries across both relational and non-relational databases, including experience in Snowflake, to extract critical insights that influenced strategic business decisions.

●Developed and maintained Source-Target Mapping Sheets (STTM) by effectively analyzing and interpreting source-target data relationships and ensuring smooth data migrations.

●Automated the process of refreshing Power BI datasets using Power Automate flows, ensuring up-to-date reports without manual intervention.

●Demonstrated ability to collaborate with business units for accurate report delivery and to perform detailed analysis using DAX queries in Power BI.

●Skilled in defining and designing new systems to meet evolving business intelligence needs and managing the development of data warehouses.

●Expertise in writing complex Queries like Procedures, Functions, implementing Joins in MS SQL Server, Pandas, NumPy, Snowflake and HDFS database-Impala.

●Driven the automation of data extraction from systems to derive Key Performance Indicators (KPIs), driving optimization of quality, cost, delivery speed, and problem resolution strategies.

●Capable of developing and implementing KPIs with clear objectives and monitoring their performance to maintain interactive dashboards and reports.

●Skilled in leveraging various BI tools and platforms, including Snowflake for scalable data management and reporting.

●Create Data Quality Scripts using SQL and Hive to validate successful data load and quality of the data. Create various types of data visualizations using Python and Tableau.

●Experienced in implementing actions in Tableau/Power BI for enhanced report interactivity, including URL, filter, and menu actions.

●Skilled in applying advanced data analysis techniques for in-depth data insights, including filters, actions, and security measures.

●Demonstrated ability to gather client requirements, provide demos, and implement report-level and row-level security in Power BI.

●Proven experience in handling large volumes of data securely and efficiently using cloud infrastructure and various BI tools.

●Expertise in implementing Row level security over data and in writing DAX-Power BI, Calculations-Tableau.

●Competent in designing and optimizing database solutions, including data warehouses, OLAP metadata catalogs, and data pipelines, to support business analytics.

Technical Skills:

Programming Languages: Python, R, SQL (T-SQL, PL/SQL), DAX.

Big Data & Cloud Technologies: Snowflake, Impala, Azure.

Business Intelligence &

Data Visualization: Power BI, Tableau, SQL Server Reporting Services (SSRS).

Databases & Data Warehousing: SQL Server, Oracle, PostgreSQL, Snowflake, Data modeling (Star schema, Data Vault).

ETL & Data Integration: SSIS (SQL Server Integration Services), Informatica

Data Analysis & Statistical Tools: Excel, Alteryx.

Version Control & Collaboration: Git, Jira, Confluence.

Other Tools & Technologies: Splunk.

Methodologies & Concepts: ETL (Extract, Transform, Load), Data Mining, Data Profiling, KPI (Key Performance Indicator) Development, Data Security (Report-level and Row-level), OLAP (Online Analytical Processing), Agile Development.

Professional Experience:

Client: AT&T, Bedminster, NJ. May 2023 – Present

Role: BI/Data Analyst

Responsibilities:

●Analyzed business requirements to develop and optimize business intelligence solutions. Designed and mapped data models to transform raw data into actionable insights.

●Developed interactive and visually compelling dashboards and reports using Power BI. Identified key performance indicators (KPIs) and set measurable objectives for performance monitoring.

●Conducted comprehensive analysis of historical and current data to drive data-driven decision-making. Translated business requirements into detailed technical documentation.

●Utilized Python libraries (Pandas, NumPy) to clean and analyze large datasets, uncovering insights that informed business strategies.

●Optimized existing process in MS Excel using Python (Pandas, NumPy) and Tableau to deliver end- to- end business intelligence solutions across HR Operations, HR business partners and talent acquisition.

●Developed a real-time sales dashboard with Python and enabling sales teams to monitor performance and adjust strategies promptly.

●Conducted data profiling, data definition, data mining, and data analysis to derive insights and support decision-making processes.

●Built multi-dimensional data models for robust analytical capabilities. Created extensive documentation for algorithms, parameters, and models to support data analysis processes.

●Extracted and pulled data from databases and BI platforms to support reporting and analytical tasks.

●Generated reports and performed data analysis using Excel, SQL, and Oracle, ensuring accurate and insightful information.

●Utilizing historical sales and demand data to improve demand forecasting and align supply with market needs.

●Monitoring real-time data from various sources like ERP and WMS to support agile decision-making in Supply Chain operations.

●Creating dashboards and reports that communicate key Supply Chain KPIs to stakeholders for better strategic planning.

●Analyzed complex business requirements and transformed them into actionable data requirements, including reports, visualizations, and data lifecycle management solutions, supporting informed decision-making.

●Designed and analyzed data visualization dashboards using Power BI to facilitate business decision-making.

●Conducted User Acceptance Testing (UAT) and built reports from BI systems to validate functionality and performance.

●Data automation initiatives by pulling measurements from diverse systems to derive KPIs, driving improvements in quality, cost, speed of delivery, and problem resolution through best practice optimization.

●Used Power Automate to streamline the data pipeline between different systems and Power BI, improving efficiency and reducing manual effort.

●Perform Data Cleaning, features scaling, features engineering using pandas and NumPy packages in Python.

●Utilized Splunk for data validation, identifying and correcting information discrepancies and coding errors.

●Rewrote existing scripts and developed new SQL scripts from scratch to automate data processes and enhance efficiency.

●Leveraged Tableau to visualize data quality and integrity, providing actionable insights through interactive dashboards and reports.

●Wrote SQL queries to retrieve and analyze data for Sales and Marketing Trending Reports, providing critical business insights.

●Developed interactive dashboards and visualizations, providing actionable insights into key performance metrics and business trends.

●Performed detailed analysis on tested and deployed Power BI scripts to ensure accuracy and performance. Executed complex DAX queries and functions to enhance data analysis in Power BI.

●Defined and designed new systems to meet evolving business intelligence needs. Managed the development and optimization of data warehouses.

●Developed and maintained ETL processes using Informatica PowerCenter to extract data from multiple sources, transform it according to business rules, and load it into a centralized data warehouse.

●Implemented technical and strategic improvements to enhance existing business intelligence systems. Developed custom charts based on specific business requirements.

●Wrote complex SNOWSQL scripts in the Snowflake cloud data warehouse for enhanced business analysis and reporting. Utilized SNOWSQL to query and optimize data results.

●Led migrating MS Strategy reports to Power BI, ensuring a seamless transition and improved reporting.

●Implemented KPIs with clear objectives and continuously monitored their performance. Created and maintained interactive dashboards and reports in Power BI.

Client: Bank of America, Charlotte, NC. Feb 2022 – Apr 2023

Role: BI/Data Analyst

Responsibilities:

●Performed advanced data analysis using Python and SQL to uncover insights from customer interaction data, identifying key drivers of customer satisfaction and areas for service improvement.

●Conducted troubleshooting analysis and resolved critical issues to ensure smooth project execution.

●Designed and trained a machine learning based gradient boost and general additive model with H2O framework in Python to forecast the number of reservations that can be cancelled to facilitate better planning of the supply chain.

●Migrated MS Strategy reports to Power BI, enhancing data accessibility and visualization.

●Streamlined ETL operations by migrating and cutting manual effort by 50% and improving the efficiency of data transformation processes.

●Responsible for Data Cleaning, features scaling, features engineering by using NumPy and Pandas in Python.

●Implemented version control using Git, ensuring efficient collaboration on data projects, and maintaining a robust, documented codebase for ongoing analysis.

●Created interactive dashboards and visual reports using Power BI to support data-driven decision-making.

●Developed and implemented Key Performance Indicators (KPIs) with clear objectives, ensuring consistent monitoring and assessment.

●Used Power Automate to call the Power BI REST API for programmatic report generation, management, and embedding.

●Worked on Advanced SQL skills, fluent in R and/or Python, advanced Microsoft Office skills, particularly Excel and analytical platforms.

●Collaborated with stakeholders to translate business requirements into technical specifications, establishing timelines for task completion.

●Utilized DAX queries and functions in Power BI to create complex data models and calculations.

●Designed and documented data structures for effective data visualization, including algorithms, parameters, models, and relationship explanations.

●Utilize Pandas and NumPy for exploratory data analysis (EDA), statistical analysis, and visualization.

●Applied advanced data analysis techniques, including filters, actions, KPIs, report tuning, data security, and user management, to slice and dice data for in-depth insights.

●Gathered client requirements and provided demos to users, showcasing Power BI capabilities and ensuring alignment with business needs.

●Implemented report-level and row-level security in Power BI to maintain data confidentiality and access control.

●Led team efforts by distributing tasks, resolving technical challenges, and ensuring the team's alignment with project objectives.

●Perform efficient data processing using NumPy arrays and Panda’s data structures.

●Created comprehensive Confluence pages to document project workflows and technical components for reference and knowledge sharing.

Client: IMS, Bengaluru, India. Apr 2019 – Dec 2020

Role: Data Analyst/BI Developer

Responsibilities:

●Participated in gathering and analyzing business requirements to design and develop database solutions, leveraging expertise in architecture, analysis, design, development, deployment, testing, and documentation.

●Developed Snowflake-level procedures and views tailored for data visualization requirements.

●Analyzed and understood report specification documents to design and develop reports using SQL Server Reporting Services (SSRS).

●Updated Python scripts to match training data with our database stored in AWS Cloud Search, so that we would be able to assign each document a response label for further classification.

●Optimize code performance using vectorized operations in NumPy and Pandas.

●Migrated SSRS and Cognos reports to Power BI, improving data visualization capabilities. Conducted unit testing and troubleshooting to ensure the accuracy and functionality of reports.

●Acquired and blended data from diverse sources, including SQL Server, Oracle, and SAP systems, for regular ad-hoc querying and analysis.

●Designed and optimized Snowflake data warehouses, creating efficient schemas, tables, views, and stored procedures to support analytics and reporting needs.

●Scheduled and distributed Power BI reports via email to designated recipients at regular intervals using Power Automate

●Developed and published dynamic and complex financial and sales reports in Power BI, utilizing DAX for creating complex measures and calculated columns.

●Designed and built dashboards in Power BI to facilitate analysis of business KPIs for stakeholders.

●Created Dataflows to reuse transformation logic across datasets, reducing duplicate data refreshes.

●Developed dynamic charts in Power BI, including horizontal, stacked, dual bar, pie, and side-by-side charts according to business needs.

●Performed Data collection, Data Cleaning, features scaling, features engineering, validation, Visualize, interpret, report findings, and develop strategic uses of data by python libraries like NumPy, Pandas, SciPy, Scikit-Learn.

●Implemented actions, including URL, filter, and menu actions, to enhance report interactivity.

●Document data workflows, transformations, and analysis steps using Pandas and NumPy functionalities.

●Performed window-level calculations to support complex data analysis in Power BI.

●Utilized T-SQL to extract data from data warehouses (DWH) for reporting and analysis purposes. Worked extensively with stored procedures, functions, joins, and SQL queries to optimize performance.

●Applied data-level security measures to protect sensitive information and maintain data integrity.

Client: Capgemini, Bengaluru, India. Nov 2017 – Apr 2019

Role: BI Developer

Responsibilities:

●Developed global dashboards using Tableau and SSRS to deliver insights across various business areas.

●Executed matching logic using SQL, MDS Fuzzy Matching, SSIS Fuzzy Matching, Alteryx Fuzzy, and custom Python scripts to create a "Golden" client record.

●Managed multiple core data sources (CRM, traditional servers, file systems) using DBT and SSIS ETL for data integration and transformation.

●Processed large data groups to support specific business groups, forming data pipelines for loading data from on-premises to the development system.

●Developed and implemented packages to extract, transform, and load (ETL) data as per business requirements, optimizing the data flow into the DWH.

●Collaborate with data scientists, analysts, and other stakeholders to understand requirements and deliver insights using Pandas and NumPy capabilities.

●Participated in Joint Application Development (JAD) sessions with business users to gather, analyze, and document business requirements from a technical perspective.

●Authored functional specifications, translating business requirements into technical specifications, and created and maintained database design documents detailing logical entities and physical tables.

●Reviewed logical models with business users, Pandas and NumPy, ETL teams, DBAs, and testing teams to align data models with business requirements.

●Designed conceptual and logical data models for databases and tables, identifying entities and their relationships within the logical model.

●Created databases for OLAP metadata catalog tables using forward engineering models, such as Star schema, and implemented a proof of concept (POC) in the data vault.

●Supported various users by responding to ad hoc data analytics requests to test business hypotheses and provide data-driven insights.

Client: KPI Partners, Hyderabad, India. May 2016 – Nov 2017

Role: BI Developer

Responsibilities:

●Analyzed and interpreted report specification documents to design and develop reports using SQL Server Reporting Services (SSRS).

●Conducted unit testing and troubleshooting to ensure the accuracy and quality of reports.

●Migrated SSRS reports to Tableau to enhance data visualization capabilities.

●Designed and built dashboards in Tableau to analyze key business performance indicators (KPIs) for stakeholders.

●Created KPI maps to support analysis activities across various business units.

●Applied data blending techniques in Tableau dashboards to combine data from multiple sources.

●Developed parameter-driven charts in Tableau for dynamic data visualization.

●Created various chart types in Tableau, including horizontal, stacked, dual bar, pie, and side-by-side charts, to meet business requirements.

●Designed custom visualizations, such as butterfly charts, dynamic waterfall charts, and dual-axis reports, to provide unique insights.

●Managed datasets, groups, and data bins to organize data effectively within Tableau. Developed drill-down and drill-through reports to enable detailed data analysis.

●Established and managed data hierarchies to facilitate complex data exploration in Tableau. Implemented actions (URL, filter, menu) to enhance interactivity and usability in Tableau reports.

●Performed window-level calculations in Tableau to support advanced analytical functions. Utilized T-SQL to extract and manipulate data from data warehouses (DWH) for reporting purposes.

●Developed and optimized stored procedures, functions, and joins to improve SQL query performance.

Education:

●Master of Science in Management Information Systems from Auburn University, Montgomery, AL.

●Bachelor of Technology in Computer Science from JNTU, Kakinada, India.

Contact this candidate