Home

Vijaya Sai Raghavendra - PowerBI Developer

[email protected]

Location: Plains, Texas, USA

Relocation:

Visa:

Vijay Mobile No: +1 980-331-9263 Mail ID: [email protected] Objective: Having total 10 years of IT experience, Highly skilled and motivated Data Visualization Lead/Architect. Seeking a challenging position to architect, lead and optimize data visualization initiatives. Leveraging expertise in developing dashboards and reports, driving data-driven insights, and collaborating with cross-functional teams to enhance business actions and decision-making processes. Professional Summary: A result-driven, detail-oriented professional, skilled in architecting, developing and implementing data-driven strategies, leading teams, and managing projects for Manufacturing, Banking, Financial & Healthcare industry. Proficient in Data warehousing, Data Analysis, Power BI, Power Automate, SSRS, Synapse, ETL and Tableau, with expertise in SQL, DAX, M, Python and R. Experience with PowerApps, Power BI Data Flow, Common Data Service, Power BI Embedded and Rest APIs. Expert level experience of experience with Microsoft BI stack (SQL Server, SSAS, SSRS, Power BI), specifically developing Azure Analysis Services Tabular model in Power BI using DAX. Extensive experience in Power BI/Tableau architecture, including designing and implementing robust solutions for data integration, modeling, and visualization. Strong knowledge of self-service data preparation techniques, including building Dataflows, establishing direct database connections, and leveraging Power Query for data transformation. Skilled in Power BI modeling and SQL querying, with the ability to design efficient data models and write complex calculations using DAX/ M query. Proven track record in building and supporting enterprise-level reports and visuals, ensuring data accuracy, performance, and user interactivity. Proficient in workspace creation and user access management, enabling effective collaboration and content sharing, implementing row level security (RLS), Performance optimization within Power BI. Created executive reports with and distribute among end user using Power BI service and scheduled gateway refresh. Experience in building Power BI Data Models/cubes with multiple fact table and over 100M records Worked on Incremental Refresh, Power Query, Time-Intelligence functions to building forecast versus actual reports Strong understanding of the principles of Data Warehouse using Fact/Dimension Tables Star and Snowflake model Strong Knowledge on Power BI to import data from multiple sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc. Experienced in writing SQL queries, with expertise in Relational Database Management Systems stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers, and cursors Extensive experience using data cleansing and reporting techniques using R, Python, SQL, Power BI, Cognos, Advanced Excel - pivot tables, VLOOKUP, SUMIF and charts Conducted training sessions for end-users on how to use reports and dashboards effectively. Provided technical guidance and mentoring to junior developers. Technical Skills: Programing Languages: Python, R, SQL, DAX, M Analytics Tools: Power BI, Tableau, Cognos, Power Apps, SAS, Azure Synapse Analytics, SSRS Database Management: SQL Server, SAP Hana, Oracle, MySQL, PostgreSQL, Snowflake Data Modeling Tools: Power Pivot, Power Query, Azure Data Factory, SSIS Cloud Platforms: Azure, AWS Data Analysis/ETL Tools: Informatica, ADF, Alteryx, Excel, SSRS, SSIS CRM: Salesforce, Siebel, SugarCRM Web Technologies: HTML, CSS, JavaScript, PHP Project Mgmt./ Agile Tools: JIRA, Pivotal Tracker, Git, Jenkins SDLC: Agile, Scrum, Waterfall OS: Windows, Linux/Unix Work Experience ________________________________________________________________________________________ PepsiCo Dallas, Texas Feb 2023 to Present Project: Centre of Excellence Team Role: Power BI Lead ___________________________________________________________________________________ Role and Responsibilities: Led Power Platform implementation projects, designing end-to-end solutions for data integration, modeling, and visualization. Worked with stakeholders (data scientists and business partners) to gather and analyze business requirements, design data models, to develop wireframes for Power BI reports/dashboards and implemented actionable insights based on data-driven analysis. Managed multiple projects simultaneously and ensured timely delivery of high-quality reports and visualizations. Developed and maintained end-to-end Power BI solutions for supply chain operations, enabling data-driven decision-making. Worked on Power Bi Paginated Reports by using Report Builder. Developed scorecards using SSRS for both the Tales as well failure to load reports that can aid to create the metrics. Developed paginated report to match the invoice formats. Hands-on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data Created paginated report using power Bi Report Builder for on-premises and cloud data Created interactive reports to visualize key supply chain metrics, such as inventory levels, demand forecasting, and order fulfillment. Integrated data from multiple sources, including ERP (SAP) systems, CRM (Salesforce) platforms, and external data feeds, to create a comprehensive view of supply chain performance. Supported end-to-end Power BI activities, covering architecture, data import, data modeling, transformation (Power Query), DAX calculations, and building complex visualizations. Proficient in creating canvas apps, model-driven apps, and portal apps using Power Apps. Strong understanding of Microsoft Power Automate and Power BI for building end-to-end automation and analytics solutions. Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ OLTP/Analysis Server (SSAS) in Tabular Model. Implemented advanced features such as drill-through actions, sync slicers, bookmarks, parameterized reports, RLS and dynamic report layouts for enhanced user experience. Used Rest API/Azure Blob Storage/ AWS connector to build data pipeline using Synapse and feeding the data from JSON, Parquet, CSV files to Azure SQL tables and creating views in database to feed Power BI report for data visualization. Designed Azure Logic App/ Power Automate workflows to automate business process flows between different applications. Developed and maintained connections to various data sources, including file systems, SQL databases, Snowflake, Oracle, Azure SQL server and SharePoint, ensuring data accuracy and reliability. Built paginated reports using Power BI Report Builder and SSRS/SSIS to enhance data-driven decision-making. Conducted data analysis and provided actionable insights to support financial decision-making. Conducted training sessions for end-users and mentored junior team members on Power BI feature and functionality. Company: IBM Jul 2021 to Nov 2022 Client: BP (British Petroleum) Role: Power BI Lead ______________________________________________________________________________________ Role and Responsibilities: Led a team working time-limited analytics product development (migrating Tableau to Power BI reports). Developed Paginated reports using Azure SQL database and automated distribution of the reports using Power Automate. Built and supported applications in Power Apps and integrated them with Power BI for seamless data visualization and analysis. Developed paginated report to match the invoice formats. Integrated Custom Visuals using Python to account for unique business requirements using Power BI desktop Built data model in Power BI having star schema and used Power Query to extract data from external sources and cleaned, transformed, modified the data using DAX to ingest it into Power BI for reporting. Develop and maintain compliance dashboards and documented all data sources and mapped them to Power BI data models. Created paginated report using power Bi Report Builder for on-premises and cloud data source. Worked closely with the Data Engineering team to understand data pipelines feeding into Power BI models, monitored data refreshes, and promptly addressed any failures to ensure smooth and consistent data updates. Defined reporting groups, established user permissions, and implemented Row-Level-Security (RLS) in Power BI reports as necessary, ensuring data confidentiality and controlled access for different user groups. Developed SSIS packages to extract, transform, and load data from diverse data sources into the target data warehouse. Developed and maintained SQL Server Reporting Services (SSRS) reports and dashboards to meet business reporting needs. Utilized Report Builder to design interactive and visually appealing reports with drill-down and drill-through capabilities. Developed complex calculated measures, columns using Data Analysis Expression (DAX) language. Developed complex SQL queries using stored procedure, common Table Expression (CTE) to support BI reports Used Power BI Embedded for embedding report to internal SharePoint application using Power BI REST API Company: Accenture Jun2020- Jul 2021 Client: AIG, America. Role: Sr. Power BI Developer. ________________________________________________________________________________________ Role and Responsibilities: Developed and implemented Power BI solutions for Patient Care Advocate Dashboard, Account & Digital adoption Dashboard, leveraging data from various sources, including claims, enrollment, and eligibility systems Designed and optimized data models using Alteryx to ensure accurate and efficient data retrieval for reporting and analysis Created interactive dashboards and reports that provided actionable insights on key performance indicators (KPIs), utilization trends, and financial metrics Collaborated with cross-functional teams to gather business requirements, translate them into technical specifications, and deliver high-quality solutions within defined timelines Conducted data profiling and analysis to identify data quality issues, resolve anomalies, and improve overall data integrity Implemented row-level security and user access controls to ensure data confidentiality and compliance with regulatory guidelines Provided training and support to end-users, enabling them to effectively navigate and utilize the Power BI platform Company: Accenture Dec2018- Jun2020 Client: Geo Links, USA Role: Power BI Developer ___________________________________________________________________________________ Role and Responsibilities: Provided day-to-day support to business users in developing new reports using Power BI for Finance, Marketing, and Sales teams. Successfully completed multiple projects, including the Amex - Travel & Expense Dashboard, ServiceNow IT Security Metrics and ticketing Dashboard, and BI reports migration project from Hyperion, OBIEE, SWR systems. Achieved an 18% reduction in spending by ensuring compliance with T&E policies, resulting in a 15% boost in revenue savings. Created MDX, DAX, Cubes, and Tabular models using Azure Analysis Services (SSAS), SSMS, and SSDT. Ingested data from multiple sources into Power BI, primarily using star schema for data modeling. Implemented both live and import modes to bring data into Power BI for report creation, utilizing Power BI gateway for scheduled data refreshes and establishing Row Level Security (RLS). Created user-friendly and dynamic dashboards and reports with KPIs, bookmarks, slicers, drill-down, and drill-up functionalities. Extracted data from CRM systems to the staging area and loaded data to the target database using Informatica Power Center for ETL processes. Worked with Informatica Power Center tools, including Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer, and Transformation Designer for ETL. Demonstrated an iterative approach, starting from v0.5 solutions, incorporating real-world feedback, and driving continuous improvement to achieve v1.0+ solutions. Monitored and optimized dashboards/reports, troubleshooted issues and outages, and scheduled upgrades. Utilized Jira to create agile user stories, log bugs, track and escalate issues. Company: TESS Jun2015 - Dec2018 Client: Heineken Breweries Designation: Data Quality Associate ______________________________________________________________________________________ Role and Responsibilities: Supported Data Systems team in building reports dashboards and visualizations Also wrote SQL Scripts, and reporting Bugs in Jira to evaluate and test processes Performed data mining, remapping / validating data with SQL. Utilized Agile Scrum methodology, Jira, Microsoft Office 365 and Zendesk to perform required job functions Developed testing suites and rigorously tested newly implemented processes in SQL Server 2014 Collected and loaded data from Schoolzilla, Naviance and other third-party vendors into Salesforce database Created different chart objects like Bar Chart, Line Chart, Text Tables, Tree Maps and Scatter Plot to analyze data using Tableau. Worked with LOD calculation in Tableau for creating variables like Previous Month, Previous Quarter, etc. Querying and manipulating multidimensional cube data through MDX Scripting in SSAS. Performed GAP analysis to compare the existing system with the proposed system and document new requirements. Involved in Designing, Developing and Testing of ETL (Extract, Transformation and Load) strategy to populate data from various source systems feeds using SSIS Supported refinement of annual data collection to ensure the process is as low burden as possible to users by continually refining collection processes Company: TESS Jun2013- Jul2015 Client: GAP Role: Test Engineer ________________________________________________________________________________________ Roles and Responsibilities Requirement understanding. Raising question to get clarity on requirements in time. Test Cases Development and review. Gather data and report progress through standardized Automation reports Execute Test cases Keywords: business intelligence database rlang information technology microsoft Idaho