Home

Veda Anand - Power BI Developer

[email protected]

Location: Bentonville, Arkansas, USA

Relocation: Yes

Visa: H4EAD

Resume file: Hema Damaraju - Power BI Developer_1763390838776.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Hema Damaraju Phone: (640) 999 0010 E-mail: [email protected] LinkedIn: https://www.linkedin.com/in/hema-mushkam-882a83121/ Summary: Over all 12+ years of experience as a Power BI Developer setup, scale and stabilizing the Data Analytics teams according to requirements across Finance and Human Resources Domains. Build visualization platforms and be able to generate quick decision-making insights. Hands on experience of using Tableau/Power BI, SAS, SPSS, and SQL for building analytical solutions to generate insights. Experience in creating visualizations and dashboards in Power BI and publishing them. Creating the Power Bi reports using Performance Optimization techniques to better the performance of the reports and reduce the dataset size. Using the Power Automate to trigger the reports. Experience in creating Paginated Reports using Stored Procedures Experience in creating Reports using Advanced Excel and Sharing with Clients. Worked in creating different types of reports and data models in Power BI. Hands on experience of using Looker Studio, Looker ML, Tableau/Power BI, SAS, Python including data manipulation libraires like Pandas, NumPy, Dask, and Polars, Matplotlib, Seaborn etc., SPSS, and SQL for building analytical solutions to generate insights. Hands on experience in GCP, GCS bucket, G-cloud function, cloud dataflow, BQ command line utilities, Data proc, Big Query, Data Bricks, ETL data pipelines using Data proc / Databricks on GCP. Strong Knowledge of Power BI to import data from various sources such as SQL Server, Google Big Query, SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc. Experienced in working with database technologies like My SQL and PostgreSQL, Google Big Query, SSIS, snowflake, Databricks. Experience on Developing various Power BI reports using Visuals and Visual Properties including Tree Map, Pie Chart, Funnel, Scatter Bar Chart and Column Charts. Strong Knowledge in dimensional Star Schema and Snowflakes Schema. Hands on experience in Performance Tuning, Query Optimization. Strong Knowledge of Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc. Experienced in working with database technologies like My SQL and PostgreSQL, Azure data factory (ADF), SSIS, data warehouse like snowflake, Big Query, Databricks. Extracting the data from different data sources with the help of cross database joins. Hands on experience on Tableau versions like 8.3,9,10 and 2018, 2020.4., Extensively used Calculations, LOD s, Table Calculations, Date functions. Very good experience in creating calculated Columns and Measures with DAX in Power BI and Excel to bring up the dynamic functionalities to the visuals and filters in the report. Highly experienced in using DAX for all the aggregations, time-intelligence and logical functions. Translated business needs into data analysis, business intelligence Data sources and reporting solutions for various clients. Developed stunning Visualizations for Dashboards using the data sources. Blended data from multiple databases into one report by selecting primary keys from each data validation. Prepared Dashboards using calculations, Parameters in Tableau and created calculated fields, groups, sets and hierarchies etc. Created Views in Oracle SQL to use as data sources in Tableau for designing Tableau Reports and Dashboards. Developed Tableau workbooks from multiple data sources using Data Blending. Generated Tableau Dashboards by using the Extract filters, Data sources filters, Context filters, Parameters and Calculated fields on Tableau reports. Experience in Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc., Created complex Stored Procedures, user define functions etc. Experience in data migration from Excel, flat data file to SQL Server. Expert in writing T-SQL Commands, and in writing Common Table Expressions. Strong problem solving and Analytical skills with high aptitude to adopt new tools and technologies with ease and seamlessly integrate skill set into the project implementation lifecycle. Experience with Big Data Sources including Azure SQL Database over Microsoft Azure Cloud. Collaborated with Technical teams to build the design and architecture documents and artifacts. Technical Skills: Analytical Tools: Power BI, Tableau, SSRS, BASE SAS and SPSS. Office Suite: MS-Excel, Access, Power Point. Database Tools: Microsoft SQL Server, PostgreSQL, Teradata, Azure, Teradata, DB2, SQL Server, Oracle 12c/10g/9i and MS Access. Education: Master s in Applied - Statistics from Osmania University Hyderabad, Telangana, India - 2007 Bachelors in Statistics, Mathematics and Computer Science from Osmania University Hyderabad, Telangana, India - 2004 Professional Experience: FRG RISK | Charlotte, NC Sep 2023 Present Power BI Developer Responsibilities: Recreated connections to web services or APIs using Power BI connectors. Used data transformation tools like Power Query to clean and prepare data for visualization. created charts, graphs, and charts in Power BI that match the functionality and aesthetics of the original reports. Applied formatting and styling to maintain consistency and implement interactive elements like drill-downs or filters in Power BI. Created Rich visualized Pie & Line Charts, Tree Map, Tabular and Matrix Reports Using Power BI. Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production. Developed stunning Visualizations for Dashboards using the data sources. Blended data from multiple databases into one report by selecting primary keys from each data validation. Prepared Dashboards using calculations, Parameters in Tableau and created calculated fields, groups, sets and hierarchies etc. Implement DAX Measures and Calculations for various Accounting Aggregations. Implement DAX Quick Measures for categorizing the data based on given parameters. Used Power BI Gateways to keep the dashboards and reports up to date. Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services. Created Snowflake objects like databases, schemas, tables, stages, sequences, views, Procedures and FILE_FORMAT using SnowSQL and snowflake UI Analyzing the raw data provided by the corporate and processing the data into meaningful and easy to Understand by using various functions in Advanced Excel and visualizing the data in the form of graphs. Preparing the detailed information using Pivot tables, Graphs. Loading data from files that have been staged in either external (Amazon S3) stage then Copy Data into the Target Table and Query the DW Data. Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided. Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations. Worked on Amazon S3 components. Renown Analytics IT Solutions | India Aug 2017 Jan 2023 Power BI Developer Responsibilities: Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports. Created Dax Queries to generate computed columns in Power BI. Generated computed tables in Power BI by using DAX. Created Azure Blob Storage for Import/Export data to/from .CSV File. Used Power BI, Power Pivot to develop data analysis prototype, and used Power View. and Power Map to visualize reports. Published Power BI Reports in the required originations and Made Power BI Dashboards. available in Web clients and mobile apps. Experience on with Column (Field) Grouping, Hierarchies Creations and Usage, experience on with Drill Ups, Drilldowns, Expand Fields to next level and Expand All Levels. Experience on Edit Interactions and Bookmarks including Buttons and Actions, explore data in a variety of ways and across multiple visualizations using Power BI. Experience on various Power BI Modeling Techniques using Power Query [M Language] and have good experience in DAX query Language. Implement DAX Measures and Calculations for various Accounting Aggregations. Implement DAX Quick Measures for categorizing the data based on given parameters. Used Power BI Gateways to keep the dashboards and reports up to date. Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services. Published reports and dashboards using Power BI. Experience on Sharing Reports, Dashboards, Organizational Content Packs and App Workspace. Creating and working with IMPORT and UPLOAD options for Dataset Creations, creating new reports from Datasets using Power BI Cloud. Working with Edit Interactions. Generating new insights and performance metrics including Dashboards Customizations. Recreated connections to web services or APIs using Power BI connectors. Used data transformation tools like Power Query to clean and prepare data for visualization. created charts, graphs, and charts in Power BI that match the functionality and aesthetics of the original reports. Applied formatting and styling to maintain consistency and implement interactive elements like drill-downs or filters in Power BI. Created Bullet Chart, Tree-Map, Reports, connection to Big Query, Single-Value Visualization, Bar & Column Chart, Line Chart, Pie Chart, Scatter Plots, Donut Multiples, Geo-Maps etc. Worked on Blending data from multiple tables. Created custom fields in Looker, filters, Boards, Look View-Mode, adding filters to Dashboard, Dimensions & Measures, Joins in Looker etc. IL &FS Technologies company | India Aug 2016 Aug 2017 Power BI Developer Responsibilities: Worked in a Project where migrated tableau reports to power bi, configured connections to databases like SQL Server, MySQL, or Oracle, and provided necessary credentials. Recreate custom calculations or expressions using Power BI s DAX language to ensure the same logic and results as in Tableau. Compared key reports between Tableau and Power BI for accuracy and consistency. Involved users in User Acceptance Testing (UAT) for feedback and adjustments. Performed performance testing, especially for large datasets or complex visualizations, and optimize queries and report design for optimal performance. Offered training sessions to facilitate the transition from Tableau to Power BI, set up appropriate access controls, monitor usage post-deployment, and gather user feedback. improved the reports based on user experiences to enhance their usability and effectiveness. Experience on Edit Interactions and Bookmarks including Buttons and Actions, explore data in a variety of ways and across multiple visualizations using Power BI. Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions. Created Rich visualized Pie & Line Charts, Tree Map, Tabular and Matrix Reports Using Power BI. Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production. Developed stunning Visualizations for Dashboards using the data sources. Blended data from multiple databases into one report by selecting primary keys from each data validation. Prepared Dashboards using calculations, Parameters in Tableau and created calculated fields, groups, sets and hierarchies etc. Created Views in Oracle SQL to use as data sources in Tableau for designing Tableau Reports and Dashboards. Scheduled data refresh on Tableau server for weekly and monthly Increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately. Distributed Tableau reports using techniques like packaged Workbooks, PDF etc. Used Oracle as data sources for designing Tableau Reports and Dashboards. Created views in Tableau Desktop that were published to internet team for review and further data analysis and customization using Filters and actions. Created Heat Map showing Current service Subscribers by Color that were broken into regions allowing business User to understand where we have most Users vs least users. The Hackett Group | India June 2008 Aug 2016 Senior Analyst / Power BI Developer Responsibilities: Facilitating the initial planning, and execution & delivery of process benchmarks in end-to-end processes of Sourcing and recruiting, Payroll and Administration, and Other Human resource Process. Accountable for assisting and supporting senior research directors in setting research hypotheses, carrying out research process that includes analysis and report production, eventually leading to research based advisory services to select clientele Identifying opportunities for improving operational efficiencies and identifying the potential business opportunities with the clients through exceptional reporting Developed, monitored and deployed SSIS packages. worked in transferring the data using SQL Server Integration Services packages Extensively used SSIS Import/Export Wizard for performing the ETL operations. Developed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes. Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers. Involved in the Database design (Logical Data Modeling and Physical Data Modeling) of the system. Implemented Snow - Flakes Schema and Star Schema Develop dynamic visualizations making use of the best visuals with all the possible latest features and dynamic functionalities. Create measures and KPIs with DAX in Power BI and incorporate the dynamic functionality in filters, slicers and visuals on the report. Have been working to create a Power BI App through a template app workspace and then finally have it deployed on the customer s tenant. Have worked in the designing the flow of a Logic App with various events & actions in it, so that Logic App gets triggered when the Power BI dataset refreshes and gets the data. Identify the key performance metrics which contribute in terms of Efficiency and Effectiveness by using correlation technique. Identify the World Class and Non-World Class companies by calculating efficiency and effectiveness scores of each company participated in the analysis. Identify and cluster the basic characteristics, lifestyle, attitude, and mindsets of persons who are willing to take housing loans using segmentation and cluster analysis. In this project we have identified the clusters using Hierarchical cluster and Non-Hierarchical cluster methods by grouping the observations. Customer demographic and transactional data collection, Data Preparation/ Data cleansing along with Feature selection. Ensure best practices in data visualization, data governance, and security while maintaining compliance with data privacy standards in Power BI reports. Data extraction from various sources, Prepare the data (identify the missing values, imputing values like mean for interval variable, mode for categorical variable). Apply the Data mining models like Multiple Regression and share the insights with stakeholders. Hypothesis setup and Exploration of Data for insight generation, Preparing the presentation and documentation of the project report for actionable. Utilized DAX in Power BI for custom measures and calculations, offering deeper insights and effective query and stored procedure writing. Developed custom Tableau and Power BI reports integrating data from multiple sources, including SQL databases and cloud platforms to present a unified view of business performance. This project mainly focuses on Identify and quantifies the factors responsible for losses in multivariate fashion for Auto insurance company. The database contains loss amount and policy related information. In this process we built Multiple Regression Model to identify and quantify the losses for Auto insurance company. Automated report generation by integrating Power BI with SQL Server, SQL Database, and Data Lake Storage Gen2, enabling accurate, up-to-date reporting. Keywords: machine learning user interface business intelligence sthree database information technology microsoft mississippi Colorado Illinois North Carolina