Home

Bhavani - Power BI developer

[email protected]

Location: Dallas, Texas, USA

Relocation:

Visa: H1B

Bhavani Sr BI/Tableau/Power BI Developer Email: [email protected] Phone: 732-813-0469 Professional Experience: A senior Business Intelligence Professional with 9years of extensive experience as a Tableau, Power BI developer and Data Analyst. Experienced in generating dashboards, Data Warehouse, ETL packages, Reports/Dashboard applications. A highly motivated person who is enthusiastic about learning new technologies in the field of data Analytics /Business Intelligence, adaptable and transformational with an ability to work independently, managing projects from concept to completion, utilizing scrum/agile methodologies in banking/financial, Educational, healthcare, and insurance industries. AWS Certified Solutions Architect - Associate certification PROFESSIONAL SUMMARY: Having 9 years of experience as an IT professional including 7+ years of experience in Business Intelligence technologies using Tableau, Power BI, Advanced excel, MySQL, SQL Server Management Studio, Oracle SQL developer, AWS(EC2), ServiceNow. Expertise in Tableau 2022.x/2020.x/2019.x/2018.x,10.x, Power BI, Business Objects 4.0, 4.1. Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects. Hands on experience on Power BI, Tableau Desktop versions 2022.x/2020.x/2019.x/2018.x,10.x Tableau Reader and Tableau Server. Produced attractive visuals/dashboards to convey the story inside the data. Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. Involved in creating many Ad-hoc reports. Involved in trouble shooting of performance issues which were associated with Power BI and Tableau reports. Worked on Jira, helping scrum master across the company to customize Jira for the requirements. Worked on Jira and source code version SVN control. Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users, and adding them to the specific group and scheduled instances for reports in Tableau Server. Worked in all phases of BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation, and end-user training. Worked with Hadoop database by connecting to impala as a data source and fetching tables. Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic. planning in the organization. Converting all operational excel reports into Power BI Reports. Experience in efficiently using standard Business Content, extending, and enhancing according to the report requirements. Created and maintained pages in confluence based on the requirements. Technical Skills Reporting Tools Tableau 2022.x/2020.x/2019.x/2018.x/10.5, Power BI, Crystal reports, Business Objects XI 4.x Databases: AWS(EC2), MySQL, MS SQL Server, Oracle, Teradata, Hive, Hadoop, Impala. DynamoDB, SharePoint, Advanced Excel ETL Tools Informatica, SSIS Front End Tools Microsoft Project, Microsoft Office, Visible Analyst, JIRA, GitLab, Confluence Programming Languages: SQL, PL/SQL, HTML, CSS, Java Script, Java/J2EE, Angular, React, Python Methodologies, Data Modeling-Logical/Physical/Dimensional, Star/Snowflake Schema, ETL, OLAP, Complete Software Development Lifecycle (Waterfall, Agile),Data Modeling Power Designer, MS Visio Work Experience: VISA, Austin - TX Sep 2022 - Present Role: Sr BI/Tableau Developer At Visas I m working for Employee Enablement Solutions team, it s here to support the success of our technology and business as a champions of user experience, The mission is to drive exceptional quality, effectiveness, and efficiency of services to its users and business functions and its vision is to enable visa colleagues to do their best work through human centric, value driven process. Responsibilities: Designed, developed, tested, and maintained Tableau functional reports based on user requirements. Developed various Tableau data visualization using cross tabs, Heat maps, Box and Whisker Charts and many more. Built and published customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server. Perform analysis for senior leadership and provide solutions for data related queries. Lead the development of new Power BI reports to provide real-time insights based on requirements. Implemented data blending to blend data from different data sources. Responsible for creating calculated fields and hierarchies using Tableau Desktop. Utilize business analytics to create performance analysis reports and compile data to drive process improvement opportunities. Proficiency in creating Ad-hoc Reports, Drill-Down, Drill-Through, Cascaded, Matrix, Sub-reports, Pie Chart Reports and Tabular Reports for different business domains depending on the specifications and requests. Created paginated reports using Power BI report builder for on-premises and cloud data sources. Developed paginated report to match the invoice formats Made Power BI reports more interactive and activate by using story telling features such as bookmarks, selection panes, and drill through filters and created many custom visualizations. Extract and organize datasets using Excel to create business models and compile data for the organization s risk index. Working directly with stakeholders for requirement gathering and developing various decision-making dashboards. Experienced with connecting multiple data sources in Power Bi to implement working reports. Design and develop of reporting data module for Credit Card Marketing Analytics. Developed Up-selling and Cross-selling reports using DAX functions. Used Confluence for storing and maintaining all the documents based on the requirements. Involved in creating internal and external tables in Azure Data warehouse. Developed Azure data factory pipelines to move the data from source systems. Creating Row level security with power bi and integration with power bi service portal. Responsible for creating SQL datasets for Power Bi and Ad-hoc reports. Developed Power Pivot reports in excel 2013 by publishing them to sharepoint2013 for providing ad-hoc reports as per client needs. Created joins and sub-queries for complex queries involving multiple tables. Proven experience in developing and managing data integration solutions using Microsoft BI technologies. Participated in daily scrum meetings with the team to discuss challenges and development of the project. Used jira for all the story and task related updates. Involved in testing and publishing reports to servers and higher ENV s and setting up refresh. Environnent : Power BI Desktop, Tableau 2022.x/2020.x/2019.x, MS SQL Server 2016/2017, SSRS, SSIS, SSAS, SQL Server Management Studio, Python, Oracle, Tableau Server 2022.x. ETS, New Jersy, NY Nov 2020 Sep 2022 Role: Data Analyst/ Power BI Developer ETS is the world s largest private educational testing and measurement organization; ETS builds assessments based on rigorous research and an uncompromising commitment to quality. Each year they develop, administer, and score more than 50 million tests in more than 180 countries at more than 9,000 locations. Responsibilities: Developed several parameterized dynamic dashboards, scorecards, with drill down and drill through capabilities. Designed rich dashboards with Power BI and referred user stories to create compelling dashboards to deliver actionable insights. While designing the Power BI reports and dashboards, the measures are created using DAX programming language. Writing all the calculations using DAX formulas. Experience in Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging. Migrated existing self-service reports and ad hoc reports to Power BI. Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Worked on Paginated reports by using report builder. Used SSRS to create, execute and deliver tabular matrix and chart reports. Used SSIS to create ETL packages .dtsx files to validate, extract, transform and load data to data warehouse databases. Created packages in SSIS and SSRS with error handling. Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using SSIS to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts. Designed rich dashboards with Power BI and referred user stories to create compelling dashboards to deliver actionable insights. Involved in developing complex Azure analysis services tabular databases. Involved in creating internal and external tables in Azure Datawarehouse. Developed Azure data factory pipelines to move the data from source systems. Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau. Defined best practices for Tableau report development. As a Tableau SME I was responsible for the design, development and production support of interactive data visualizations used across the company. Created URL Actions to navigate from one Dashboard visual to another Dashboard for a smooth eye-catching presentation along with using Tableau Data Extracts for better performance on rendering the visualizations. Environnent : Power BI, Tableau 2020.x/2019.x, MS SQL Server 2008 R2, SQL Server Management Studio, Oracle, Tableau Server 2020.x, SSIS. COX Communications, Atlanta, GA Aug 2019 Nov 2020 Role: BI Developer Cox Communications is an American privately-owned subsidiary of Cox Enterprises providing digital cable television, telecommunications, and Home Automation services in the United States. The scope of the project is to build reports in such a way all the United States-wide users will be get known about the status of the Network, Region, District and Store Levels. Various KPI s are created to get the up-to-date information of Products, Analysis of the Ticketing tools. Responsibilities: Understand the Requirements and Functionality of the application from specifications. Provide guidance to IT Infrastructure and Application teams on Architecture s Frameworks, Patterns, Best Practices, and Programming concepts. 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. 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. Scheduled Automatic refresh and scheduling refresh in Power BI service. Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server. Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau. Created different KPI using calculated key figures and parameters. Developed Tableau data visualization using Cross tabs, Heat maps, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart. Hands on experience with API gateway and DynamoDB Worked extensively with SNS and SQS to post queries to the tables. Creating Row level security with Power BI and integration with Power BI service portal. Developed donut charts and implemented complex features in charts like creating bar charts in tooltip. Worked on all types of transformations that are available in Power BI query editor. Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations. Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI s. Environment: Power BI, Tableau 2018.x/2019.x, MS SQL Server 2008 R2, SQL Server Management Studio, SSIS, MS Excel, Tableau Data Extract (HYPER), AWS. Chevron, San Ramon, CA Oct 2017- Aug 2019 Role: Tableau Developer Chevron Corporation is an American multinational energy corporation. One of the successor companies of Standard Oil, it is headquartered in San Ramon, California, and active in more than 180 countries. The scope of the project is to build reports and to track sales all over the United States. Developed main Dashboard s for Fuel Analytics and used to track Sales, Fuel Prices. Responsibilities: Created dashboards for analyzing POS data using Tableau 10.x. Consistently attended meetings with the client subject matter experts to acquire functional business requirements. Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting. Created Scatter Plots, Stacked Bars, bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications. Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets. Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports. Scheduled extract refresh for weekly and monthly reports. Worked on workbook Permissions, Ownerships and User filters. Environment: Tableau, SQL Server 2012, SSMS, SSIS, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler Client: OPT Integrated Solution, India May 2013 Aug 2015 Role: Data Analyst Execute and maintain reports for external clients and internal support. Support ad-hoc data analysis requests from business owners and support management team. Develop and maintain databases necessary for projects and development functions. Develop graphs, reports, and presentation for project results. Used Oracle SQL*Plus tool for running SQL scripts containing statements and queries. Designed and developed all the Tables and Views for the system in Oracle. Acting as Tableau SME for other Tableau users across the enterprise. Designed a dashboard that is easy for the clients to use and to analyze their growth and predict the requirements for the future. Perform basic statistical analysis create and present quality dashboards. Communicate analysis effectively to internal team and clients. Wrote triggers, menus, and stored procedures in PL/SQL Data loading and Extracting function using Oracle SQL Developer. Organized and reported training statistics to company-wide management. Coordinated with third party contractors to update and maintain CEPs and CSPs for the company website. Environment: Power BI, Tableau, Advanced Excel, SQL, C, C++, Java, Oracle Proc*C, SQL Scripts, PL/SQL packages and stored procedures, Cognos, Perl, Shell scripting, Oracle Forms and Reports. Education Details: Master s in information technology and management (2018) Bachelor of Engineering in Electrical &Electronics (JNTUH) (2013) Keywords: cprogramm cplusplus csharp business intelligence database active directory information technology microsoft procedural language California Georgia New York Texas