Home

Divya Devarapally - Power BI Resume

[email protected]

Location: Dalton, Ohio, USA

Relocation: YES

Visa: GC

Divya [email protected] 5134434943 Power BI Developer Profile Summary Overall 8+ years of experience in the IT industry, including big data environment, Azure cloud platform, and reporting tools like Power BI and SSRS Having good exposure to visuals like Table, Bar, Card, Funnel, Line, Gauge, Doughnut, Waterfall, Slicers, and Matrix visualizations. Worked on DAX expressions like filters, Aggregate, Mathematical, Time Intelligence Functions, etc. Created New Calculated Columns and Measures using DAX expressions like filters, Aggregate, Mathematical, Time Intelligence Functions, etc. Implemented datasets in Power BI based on a mapping sheet by following star schema modeling. Flexible in working with selection and bookmark panes for hiding and displaying visuals according to the required selections. Worked on Schedule refresh in Power BI Service based on timings provided for all types of sources datasets. Implemented Role Based Security as part of Power Bi security for users who will utilize the reports. Experience in Using multiple join statements to retrieve data from multiple tables. Created different logic for implementing transformation of data using split columns, conditional columns, and append and merge queries in the Power Query editor. Created various reports and dashboards in Power BI with different types of sources like ADLS Gen2, SharePoint path, Postgres SQL, SQL server, salesforce objects, Power BI shared datasets, and SSAS cubes. Good experience in handling EXCEL for doing data analysis and comparison. Having good exposure to visuals like Table, Bar, Card, Funnel, Line, Gauge, Doughnut, Waterfall, Slicers, and Matrix visualizations. Implemented several reports with the help of wireframe documents provided by the business. Good exposure to SQL server and oracle in creating several complex queries, views, and stored procedures. Hands-on experience in handling ETL data pipelines in Azure data factory for migrating data from several resources to destinations. Good knowledge in handling Azure resources like Azure data factory, Synapse, ADLS Gen2, and Azure SQL server. Active team player with excellent interpersonal skills, a keen learner with self-commitment& innovation. Superior communication skills, strong decision-making, and organizational skills along with outstanding analytical and problem-solving skills to undertake challenging jobs. Having good experience in Power Query, Power Pivot, and Power View for creating effective reports and dashboards in Excel and Power BI Desktop. Involved in connecting, importing, shaping, and transforming data for business intelligence (BI) tools like Excel, and Power BI Desktop from different kinds of data sources. Designing dashboard templates as per the requirement & dashboards content, which includes Power BI Desktop visualizations like stacked column charts, tabular reports, bar charts, waterfall charts, Bubble charts, Geospatial visualizations, donut charts, line, bar, histograms, scatter, water, Bullet, Heat maps, tree maps, etc. Education Details: JNTUH University: BTech Computer Science, 2010-2014 Organizational Experience Client: Cbre, Dallas, TX Dec 2021 to Present Power BI Developer Tools & Environment: Azure data factory, oracle, ADLS Gen2, Synapse, and Power BI desktop. Created pipeline, dataset, and linked services for extracting data from Oracle to ADLS Gen2 storage in the form of parquet files. Implemented ETL logic in doing transformation with the help of data flows in Azure data factory. Worked on creating case management reports by using azure data lake gen2 as a data source. Created data model as different entities are to be related for all reports. Connecting Power BI desktop with sources using the live connection of Power BI Shared dataset connection. Used Table, treemap, Bar, Card, Doughnut, and Slicer visualizations. Used filter pane to display visuals according to the conditions. Created a New Calculated Column and Measured using DAX Expression. Implemented Star schema model in Power BI desktop by taking all required files from ADLS Gen2 as the source and the relationship between tables with the help of a mapping sheet provided by the data architect. Published reports in Power Bi Service. Done schedule refresh for the reports. Transform data by using merge queries/ append queries in the Edit Queries section on Power Bi Desktop. Designed and developed data models and cubes using Tabular in Power BI, enabling efficient data analysis and report generation. Creating bookmarks for the report to view in the current scenario. Gateway connections implementation in Power BI Service for allowing data refresh in on-premises. Implemented DAX expressions for MTD and YTD based on slicer selection. Using bookmark and selection pane for hiding and displaying visuals based on selection. Added sync slicers for filtering data with the help of one slicer to multiple pages. Imported summary table visual from the market and modified code view of that vision to get ACTUAL and BUDGET details into a single format. Configuration of RLS (Row Level Security) for specified users with the help of specific user selection in the Power BI service. Worked on different DAX functions like EOMONTH, DATEDIFF, CALCULATE, COUNT, SUM, FILTER, ALL, etc., Implemented Data sets using data modeling by connecting all the tables to satisfy all required conditions. Worked on all types of filters like Page level, Visual level, report level, and drill-through filters. Used all the functionalities of visuals in Power BI like drill up, drill down, conditional formatting, and tooltips. Good Experience with Power BI concepts like Data visualizations, Data Modelling Creating reports, creating Workspaces, and DAX Functions. Good Experience with power BI Desktop including getting data, identifying the relationships, create calculated columns & measures using DAX. Worked on the Power BI reports & dashboards by using SQL Server, azure data lake Gen2, and some other sources as data sources. Worked on DAX expressions like filters, Aggregate, Mathematical, Time Intelligence Functions, etc. Comfortable in working with filters/calculated columns/measures/relationships and transformations in the power query editor. Documented all the technical work for future references and customizations. Good knowledge in analyzing data with the help of EXCEL by using functions like VLOOKUP, CONCAT, etc. Implemented autogenerated scripts in EXCEL with the help of functions in EXCEL. Displaying images in all visuals using web URLs from source tables. Implementation of sorting techniques in the visual display of reports. Configuration of Power BI service account after publishing reports Client: Silicon Valley Bank, CA Jan 2020 to Nov 2021 Power BI Developer Tools & Environment: SQL Server, Salesforce objects, and Power BI Desktop. Created various reports and dashboards in Power BI with different types of sources like ADLS Gen2, SharePoint path, Postgres SQL, SQL server, salesforce objects, Power BI shared datasets, and SSAS cubes. Having good exposure to visuals like Table, Bar, Card, Funnel, Line, Gauge, Doughnut, Waterfall, Slicers, and Matrix visualizations. Created New Calculated Columns and Measures using DAX expressions like filters, Aggregate, Mathematical, Time Intelligence Functions, etc. Implemented datasets in Power BI based on a mapping sheet by following star schema modeling. Flexible in working with selection and bookmark panes for hiding and displaying visuals according to the required selections. Worked on Schedule refresh in Power BI Service based on timings provided for all types of source datasets. Implemented Role Based Security as part of Power Bi security for users who will utilize the reports. Experience in Using multiple join statements to retrieve data from multiple tables. Created different logic for implementing transformation of data using split columns, conditional columns, and append and merge queries in the Power Query editor. Transform data by using merge queries/ append queries in the Edit Queries section on Power Bi Desktop. Creating bookmarks for reports to view in the current scenario. Helped the testing team for generating test scripts which are very complex and involved in creating the test scenarios/cases. Implemented DAX expression to enable the slicer to filter data with the help of measure value by creating a table that contains measure values. Implemented incremental refresh by using start date and end date values as parameters for storing data to start incremental refresh after full load. Implemented dynamic RLS configuration to restrict the data for the provided users by using the RLS configuration table in the data model. Created complex query using multiple joins in SQL Server which will be taken as a source in Power BI. Testing the reports by taking different scenarios and filters. Validating data from source to visual output by writing queries in SQL. . Client: Travelport Englewood, CO Nov 2017 to Dec 2019 BI Developer Tools & Environment: Tableau, SQL Server, and Power BI Desktop. Evaluated business requirements and prepared detailed specifications that follow project guidelines required to develop written programs. Understanding logic and patterns in Tableau reports for migrating reports from Tableau to Power BI. Created reports in Power BI by creating single datasets for all the reports and publishing them in Power BI Service. Developed matrix visual with all types of changes and additional features like conditional formatting. Transformed data with the help of Edit queries in Power BI Desktop by copying and duplicating tables. Merged and appended tables in Edit query for joining and appending data from one table to another. Maintained clear relationships in Power BI Desktop by using a single direction and assigning desired connections between tables based on their key relations. Connected data from SQL server to Power BI Desktop in both import and direct query mode of connections. Added several DAX functions like USERELATIONSHIP and TREATS which will help in controlling relationships of data virtually in Power BI Desktop. Importing images into table visual from web URL of images with the help of changes in categories of data view. Created several conditional columns in the Edit query of the Power BI desktop to satisfy the conditions of the end-user. Comparing expressions in Tableau with DAX expressions in Power BI Desktop to implement logic that will replicate. Created several dimension tables in the Power BI desktop to implement logic with the help of DAX expressions. Understanding business requirements and implementing visuals in reports Migrating reports from the tableau to Power BI by transforming complete data and logic into Power BI. Restricting data to users by implementing RLS configuration and also testing the same. Handled different visuals and their interactions by using the edit interactions functionality in Power BI Desktop. Involved in presentations and business requirements calls for getting more understanding towards details of report development. Client: Maisa Solutions Private Limited Hyderabad, India July 2016 to Sep 2017 Data Analyst Tools & Environment: SSIS, SSRS, and SSMS. Evaluated business requirements and prepared detailed specifications that follow project guidelines required to develop written programs. Modified existing procedures and UDF as per new requirements. Contributed to JRD sessions to gather requirements and define functional requirements. Utilized Python for recurring reports automation and visualized them on the BI platform. Identified, formulated, and documented detailed business rules and use cases based on requirements analysis. Maintained referential, domain, and entity integrity across database tables utilizing constraints in SQL. Implemented Agile for frequent changes to client requirements and following parallel development and testing. Used data analysis to validate business rules and identify low-quality missing data in the data warehouse. Performed data analysis to find anomalies and ensure data integrity before consolidating data. Worked collaboratively within and across development and project teams in a fast-paced work environment, utilizing Agile BI design. Generated periodic reports based on the statistical analysis of the data from various time frames and divisions utilizing SSRS. Created ETL package for data conversion using various transformations tasks. Created Views and stored procedures using analytical functions in SQL for migrating and transforming data in SSIS packages. Created summary and detail reports utilizing drill down and drill through functionalities in SSRS. Utilized different transformations, tasks, and containers for various activities during the ETL process. Client: Dhruvsoft Services Private Limited, Hyderabad, India Aug 2014 to Jun 2016 Data Analyst Tools & Environment: Oracle, SQL Developer, and Report 6i. Involved in Agile methodologies, daily Scrum meetings, and Sprint planning. Created database objects like tables, views, Materialized views, procedures, and packages using Oracle tools like PL/SQL, and SQL * plus. Involved in database development by creating Functions, Procedures, Triggers, and Packages using TOAD for accessing, inserting, modifying, and deleting data in the database. Used Ref cursors and Collections for accessing complex data resulting from the joining of a large number of tables. Worked on the creation of Sequences for the automatic generation of students registering. Created indexes on tables for optimizing stored procedure queries. Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application. Worked extensively on exception handling for handling errors using system-defined exceptions and user-defined exceptions. Developed a few Reports like parameterized reports, crosstab reports, and sub-reports according to the client s requirement using Reports 6i. Documented all the technical work for future references and customizations. Worked with the testing teams to fix bugs and ensured smooth and error-free code. Preparation of docs like Functional Specification document and Deployment Instruction documents Fixed defects during the QA phase, support QA testing, troubleshoot defects and identify the source of defects. Keywords: quality analyst business intelligence information technology procedural language California Colorado Texas