VINUTHA NARAYANA REDDY
Macgregor,Australia
Summary
Around 4 years of IT experience in Power BI, Azure, and SQL Server Business Intelligence solution development and design, including the production of reports and dashboard.
Overview
4
4
years of professional experience
Work History
Data Analyst
Virtusa
02.2022 - Current
- Our project goal is to gather data from various sources, dump it into a data warehouse whenever the necessary conditions are met, then create dashboards in PowerBI Desktop and share them with the Azure cloud using Data Management Gateway
- Responsibilities: Worked on operational, analytical dashboards and data visualization reports using Power BI
- Deployed web embedded Power BI dashboards refreshed using gateways by using workspace and data source
- Used Microsoft Power BI Power Query to extract data from external sources and modify data to by calculated columns as required in Excel
- Enhanced Power BI, Power Pivot to develop data analysis prototype, and Power View and Power Map to visualize reports
- Worked on Tableau and Power BI to create visualization reports from both relational and multidimensional data as source
- Designed SSIS Packages in SQL Server to handle data migration (ETL Processes) from transaction System to Dimensional Model
- Performed Power BI Desktop Data modeling, which cleans, transforms, and mash up Data from multiple sources
- Used SSRS reports are used for creating Dashboards, drilldown reports, Scorecards
- Created various Excel reports using drop downs and v-lookups connected to the SQL server
- Worked with DAX queries to modify data and add new columns and measures
- Work with various transformations in the Power BI query editor
- Designed and built several dashboards involving KPIs and trend charts comparing cumulative vs actual values to depict the client’s overall business needs
- Provide analytics and decision support to stakeholders across the organization
- Partner closely with internal stakeholders to dive deep into the data to provide actionable insight
- Enhanced Data Warehouse Architecture and Design - Star Schema or Snowflake Schema, FACT and Dimensional Tables, Physical/Logical Data Modeling and data flow diagrams
- Worked on Azure cloud in spinning of new resources under resource group
- Worked on Azure Data factory to load the data from on premise to Azure Data Lake
- Secured the Power BI reports using Row Level Security (RLS) and DAX filters Used SQL, Python, and PySpark, worked Data bricks notebooks were generated, and automated notebooks were made using tasks
- Used a variety of tools for development and documentation, such as Confluence for all project- related documents, JIRA for daily development chores, and QC for defect management
- Worked on Agile process with backlogs and story points who participate in daily scrum meetings Environment: Power BI, Power Pivot, Power View, Power Map, Tableau, SQL Server, SSIS, SSRS, ETL, Excel, KPI, DAX., Power Query, Star, Snowflake, Data Warehouse, Data Modeling, Azure Data Factory, Row Level Security, Python, Snow SQL, Jira, Agile, Scrum.
Data Analyst
Thought Works
06.2020 - 02.2022
- In this project it is the capacity to comprehend customer behavior and the variables that influence it
- Use predictive analytics to examine how your most profitable clients connect with one another
- Use focused strategies to improve customer response, retention, and profitable growth
- Responsibilities: In-depth knowledge of Software Development Life cycle, having a thorough understanding of various phases
- Collaborated closely with clients to perform thorough Data Analysis, data validation, error handling mechanisms, and data clean-up within vast datasets
- Worked on Power BI Visualizations and Dashboards as per the requirements
- Worked in the creation of dashboards and visualizations for Power BI using Power BI Desktop
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
- Developed on Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations
- Created Power BI dashboards, visualizations, and connections to SharePoint and SSRS to give insightful data that can be used to take action
- Developed interactive dashboards and storyboards in Tableau to explore credit portfolios data and report insight to the manager
- Extensively worked on OLAP cubes using SSAS and Created and Managed OLAP Cubes using SSAS
- Utilized multi-dimensional models like Star Schemas and SnowFlake Schemas for generating Cubes in the design and development of Data Warehouses, Data Marts, and Business Intelligence
- Used ETL tool SSIS to extract data from both external and internal sources including csv, json, excel and load data into the database
- Used Scripted advanced SQL queries in PostgreSQL for Redshift and MySQL leveraging Common Table Expressions, sub-queries, correlated subqueries, window functions and complex join logic to apply business rules
- Worked on various reports using reporting tools like Tableau and MS excel to forecast the growth of various KPI
- Restricted access to users by creating security roles to access reports in Power BI using row level security
- Utilized monitoring and deployment tools to efficiently manage Power BI Service CI/CD and data flow operations
- Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data
- Create SSIS Packages to migrate data from / to Azure Cloud (Azure SQL Database), Azure Blob Storage
- Used Jira, epics, user stories, and tasks were created for each requirement in accordance with the sprint planning
- Environment: Power BI, OLAP, SSAS, Star, Snowflake, SQL, ETL, SSIS, KPI, Row Level Security, PostgreSQL, My SQL, Tableau, Excel, CI/CD, T SQL, Azure, Jira, Data modeling, Linux, Unix.
Skills
- Reporting Tools: Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop, SQL Server Analysis Services (SSAS), SQL Server Reporting Service (SSRS), SQL Server Reporting Services, Crystal Reports, Tableau, Excel
- Cloud Technologies: Microsoft Azure, Azure Data Factory
- Database Technologies/Tools: SQL Server, SQL, T-SQL, Data Transformation Services (DTS), OLTP, SSIS, OLAP, PostgresSQL
- Data Warehouse /Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2017/2019, SSAS, Business Intelligence
- RDBMS/DBMS: MS SQL Server 2019/2017/2016/2014/2012/2008R2/2008, MySQL, Oracle MS Access
- Programming Languages: PL/SQL, Python, Power Shell Scripts
- Hadoop: MapReduce, YARN, Hive, HBase, Flume, Sqoop, PySpark, Spark SQL
- Methodologies: Agile, Scrum, Waterfall
- Testing Tools: Jira
- Operating Systems: Linux, Windows
- Hands-on experience on the Software Development Life Cycle in all its aspects (SDLC)
- Strong Experience in SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development with Power BI
- Gained experience in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation
- Experience in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop
- Experience with DAX queries and functions, Data modeling in Power BI with multiple system connections
- Extensive experience in designing, developing, and delivering business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS)
- Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps)
- Experience in Dimensional Modeling and Data Visualization using Microsoft Power BI, Power Pivot and Database design using RDBMS
- Experience in deploying Power BI to import data from several sources, such as Microsoft Excel, SQL Server analysis Services (Tabular Model), SQL Server 2012/2014/2018/2019, Azure SQL Database, and additional sources
- Hands on in Designing, maintaining, and building Cubes, Dimensions, and Data source views, data mining Models, Deployment and Processing using SSAS
- Experience of a range of data processing languages and systems, including Oracle PL/SQL, SQL Server T- SQL
- Designed and built dashboards for use in monitoring performance metrics while maintaining existing dashboards for accuracy and efficiency and incorporating changes using Tableau
- Proficient in Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools
- Experience with setting up Azure Data Factory to facilitate data transformation and movement Partnered with Azure Data Lake Store to gather data for various processes in one location, regardless of size, kind, or ingestion pace
- Strong development skills with Azure Data Factory, Azure SQL Data warehouse, Azure SQL Database, Azure Storage Explorer
- Experience in data warehouses and OLTP/OLAP environments Extensive experience in data mining and OLAP cubes in SQL Server Analysis Services
- Collaborated with stakeholders to gather requirements, analyze business needs, and design the data analytics and reporting solution architecture
- Implemented Row-Level security(RLS) and Data Governance in Power BI Desktop and Service
- Gained knowledge with the Distributed File System (HDFS), Map Reduce, Pig, Hive, Sqoop, Flume, and Spark, as well as the Hadoop framework, should be gained directly from the source
- Gained knowledge of PySpark for using Spark libraries with Python scripts for data analysis
- Experience with both Waterfall and Agile model working techniques Possess experience with the GIT Version Control System and Agile Defect Tracking Tools, such as JIRA
- Practical knowledge of the Linux, UNIX, and Windows operating systems
Personal Information
Title: Data Analyst
Timeline
Data Analyst
Virtusa
02.2022 - Current
Data Analyst
Thought Works
06.2020 - 02.2022