Home

Sai mandalaneni - Bi Consultant

[email protected]

Location: Dallas, Texas, USA

Relocation: yes

Visa: H1b

Resume file: Sai BI Conusltant-1 (1)_1751389884795.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Sai M Sr. POWER BI Developer https://www.linkedin.com/in/sai-kumar-mandalaneni-219422232// Email: [email protected] Phone: 567-274-6383 Summary: Approx 10 years of experience in Business Intelligence, Business Analytics, and Data Analytics using, Tableau, Power BI, and SSRS. Expertise in developing Power BI reports and dashboards from multiple data sources using live and import query. Worked extensively in MDX programming, DAX expressions, M programming analysis, and business forecasts. Extensively created various Power BI reports utilizing the desktop and published reports to Power BI service and scheduled refreshes. Created various visualizations in the reports using Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Also, using different transformations inside the Power Query. Experienced on working with HIPAA translation based projects and on claim processing systems (claims and encounters). Extensively used user roles and groups and provided row-level security included in Reports. Created advanced drill-down reports using Slicers and timelines, linking reports to Bookmarks and parameters by including report-level filters, and page-level filters in Power BI. Extensively worked on Optimizing Power BI reports to meet the agreed SLA. Experienced in Power BI working with different Enterprise Data sources like SAP HANA, SSAS Cubes, Hadoop HDFS, SQL Servers, AWS Redshift, DB2, and the Extracts (auto/incremental) using RDBMS systems. Designed and deployed rich Graphic visualizations with drill-down and Drop-down menu options and parameterized using Power BI. High Skilled in writing Parameterized Queries for generating tabular reports formatting report layout, Sub reports using global variances, Expressions, and Functions, Sorting the data defining data source and subtotals for the reports using SSRS 20162014/2012/R2/2008. Crafted real-time monitoring dashboards using Power BI amalgamating live data feeds from various origins. Achieved a 30% reduction in critical system issue response time, facilitating swift anomaly detection and resolution through interactive visualizations. Installing and configuring the Personal and On-Premises Power BI gateway in Azure, connecting to data sources, and adding the different users. Key role in the Design and Development of dashboards and automated manual reports. Migrated Business objects report/Cognos to Tableau and sunset of Data Warehouse. Worked on the Power BI and Tableau APIs for the functionality enhancement to Host reports into Third-party UI applications. Custom SSRS 2012 reports as well as Tableau reports for large customers and senior executive leadership. Experience with Linux systems, scripting Experience, and building data pipelines. Migrated Database from SQL databases (Oracle and SQL Server) to NoSQL databases (Cassandra/MongoDB). Hands-on experience with AWS. Experienced in working with Spring MVC-based applications using Rest-based web services to handle JSON data. Performed data cleansing enrichment and mapping tasks. Created various sets of scripts and orchestration using Autosys. Having Experience in managing Cassandra, MongoDB, and Oracle Databases Developed workbooks with ETL jobs on a daily basis to automate. Experience in working with unstructured data developing workflows in Alteryx Designer with documentation and implementation of the processed data. Experience in writing TSQL (DDL, DML, AND DCL), developing/creating new database objects such as tables, views, indexes, complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs). Technical Proficiency: BI/Visualization Tools: Power BI (Desktop, Services, Report Server) Tableau 2021.2.3, 2019.1, 2018, 10.5, 10.4, Qlik Sense, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS). Programming: SQL, PL/SQL, Hive, Hadoop Ecosystem, HTML, Python, Java Utilities: MS Project, MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, MS SharePoint. Databases: Teradata 14.10/14/13, Oracle-11g/10g/9i, OAC, MS Redshift, MS SQL Server-2005, 2008, DB2, MS Access, GCP, Snowflake. Platforms: Windows 2012 R2/7/8/2003/NT, MS Server 2008 R2, Mac OS, DOS, UNIX, Web Sphere, Apache/Tomcat. Project Experience: Client: Maryland Health Benefit Exchange, Baltimore, MD Sep 22 - Present Role: Business Intelligence Lead Maintained different levels of Data Security in Power BI while granting access to data and assigning row-level security (RLS) when needed. Developed and maintained multiple Power BI dashboards in Power BI mobile and Power BI web. Created paginated reports using Power BI Report Builder for both on-premises and cloud data sources. Migrated Reports and Dashboards from Cognos Analytics to Power BI. Utilized Power BI (Power View) to create various analytical dashboards that depict critical KPIs such as legal case matters, billing hours, and case proceedings along with slicers and dicers enabling end-users to make filters. Extensively worked on POWER QUERY Editor and Data modeling in Power BI Installed and configured Enterprise gateway and Personal gateway in Power BI service. Implemented version control for Power BI files using tools like Git, ensuring a systematic approach to changes and updates. Demonstrated proficiency in integrating OAC/Power BI dataflows and applying ETL (Extract, Transform, Load) techniques at scale, ensuring seamless data integration across various sources. Functional Lead role in defining the dashboard requirements and providing the best practices/approaches to perform ETL and publish data to the reports/dashboard. Designed and implemented data mapping strategies to align Cognos data models with Power BI architecture. Configured incremental data refresh in Power BI for large datasets, reducing load times and enhancing data accuracy for time-sensitive business reporting. Optimized tabular cube processing times and query performance within SSAS/AAS by implementing partitioning, aggregations, and calculated columns to support high demand reporting environments Created organized, customized analysis and visualization projects and dashboards to present executive leadership. Acted as a subject matter expert for OAC and Power BI platforms, staying updated with the latest features and advancements to recommend best practices and optimize analytics workflows. Building data models out of Teradata and importing them to Tableau for customer's ready-to-use reports and dashboards for leadership. Developed and optimized complex SSAS/AAS tabular models, enabling efficient data processing and analytics for large-scale business intelligence applications Successfully implemented Power BI reports by integrating data from diverse sources, including on-premises data servers, cloud services, and various file formats. Optimized dashboards for efficiency, managing data extracts, and improving load times. Employed Power Query to transform raw data into analyzable formats, including advanced cleaning, merging, and reshaping to ensure quality and consistency across all Power BI reports. Proficient in integrating Tableau visualizations seamlessly into Angular applications, leveraging APIs and embedding techniques for a cohesive user experience. Enhanced user interface and experience by integrating Tableau dashboards into Angular applications, focusing on design consistency, responsiveness, and user-friendly interactions. Created crosstabs for displaying underlying data based on various graphs and charts for future data analysis. Created and Documented Standard Operating Procedures (SOP) for enterprise monitoring. Support ad-hoc requests; perform deep-dive analysis to identify areas of concern and debugging of data inaccuracies. Project Experience: Client: Optum Health, Chicago, IL May 20 - Aug 22 Role: Business Intelligence Lead Generated ad-hoc reports in Excel Power Pivot and shared them using POWER BI to the decision makers for strategic planning. As a Part of Power BI Administration, configured Usage metrics, users, Audit logs, Power BI Apps settings, Power BI premium and Premium Capacity settings. Provided governance and technical expertise for the use and operation of clinical dashboards. Designed and implemented robust ETL processes to consolidate and integrate diverse data sources into a unified data model. Implemented relationships, calculated columns, and measures to create a cohesive and efficient data structure. Designed and implemented ETL pipelines in Azure Data Factory to streamline data ingestion from multiple sources, enabling real-time data updates and synchronization with Azure Synapse Analytics. Integrated Power BI reports and dashboards with other Microsoft products like SharePoint, Teams, and Excel for seamless collaboration. Experienced in EMR both in an outpatient and inpatient setting. Utilized Azure services to optimize data storage, processing, and retrieval for enhanced Power BI performance. Created and processed numerous masking rules to protect sensitive PHI, PII data. Collaborated with cross-functional teams to gather requirements, design data models, and develop data pipelines using Oracle Analytics Cloud (OAC) and Power BI dataflows, resulting in tailored solutions that meet client needs. Utilized Google Cloud Platform (GCP) products such as Cloud Data Studio and Cloud SQL in conjunction with Google Looker Studio to enhance data visualization capabilities and optimize performance in government health insurance analytics environments. Providing technical and analytical support Ad-hoc reporting in responding to specialized report requests requiring higher-level data analysis and data management services. Good Understanding of SOAP, webservices XML and JSON. Integrated Azure Data Lake as a centralized repository for structured and unstructured data, enabling seamless data retrieval and analysis in Power BI for cross-departmental insights. Used query editor in Power BI for Data cleaning, Data manipulating Dataset using transformations like merge, append, group by, pivot, and unpivot. Designed and developed ETL jobs to extract data from Salesforce replica and load it in DataMart in Redshift. Experience with Azure transformation projects and Azure architecture decision-making Architect and implementing ETL and data movement solutions using Azure Data Factory (ADF). Configured and maintained Report Manager and Report Server for SSRS Created Batch scripts which will load Tables into Teradata scheduled them using Control M and created batch scripts for adding users into Tableau. Used Role level security in Power BI report and assigned RLS\ Object level security for executive groups. Implemented Power BI gateway from different source to matching analysis criteria and further modeling for Power Pivot and Power View. Extensively used Performance analyzer and optimized Power BI reports and made changes accordingly. Experienced in setup workflow using Power Automate to Provide auto approval and status update features based on predefined criteria. Design and develop data warehouse projects and data marts, model and create Power BI projects. Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes. Experienced in creating tableau backup batch script in windows scheduler. Installed and upgraded Tableau server cluster environment in the 2021.2 version. Created action filters, parameters, advanced table calculations and sets for preparing dashboards and worksheets in Tableau using Teradata as a Data Source. Project Experience: Client: Cars.com, Chicago, IL Aug 18 - May 20 Role: Sr. Tableau Developer Responsible for BI development/Implementation, data architecture, data warehousing, and reporting techniques Write complex SQL queries with multiple joins to automate/manipulate these extracts in Tableau. Created Tableau scorecards, dashboards using scatter plots, geographical maps bar Charts Advanced KPI Charts Performance tuning on Tableau server and Tableau dashboards using utility tools like Palette, Tab Jolt and Log shark for Performance monitoring and running load tests for Tableau server Health. Involved in creating data blending in case of merging different sources, used Alteryx for Data blending for Tableau. Created Alteryx macros in Alteryx designer for reporting and data manipulation. Strong expertise in ETL process design. Demonstrated expertise in handling complex data scenarios and ensuring seamless integration for comprehensive reporting. Executed data migration in coordination with management and technical services personnel. Worked on DAX functions to build visualizations, and developed power bi paginated reports using Power BI report builder. Create rich Power BI visualizations, DAX queries and work with Power Query, M code language for data integration and transformation as per the business requirement. Created Workspace and Apps in Power BI service and gave access to end users to Apps. Configure Power BI Report Server for SSRS, deployed and scheduled reports in Report Manager. Create paginated reports using Power BI Report Builder for on-premises and cloud data sources. Applied domain expertise in risk and control management processes to assess and mitigate compliance risks within Google Looker Studio, ensuring the integrity and reliability of analytical solutions and reports. Adroit in accessing and using PowerApps, Power Automate (MS Flow), and Power Bl. Experience building Power Automate (Flows), supporting multiple users on Power BI & Power Apps. Created Row-level security (RLS) and integrated with Power BI service. Maintained different levels of Data Security in Power BI while granting access to data and assigning Row Level Security (RLS) when needed. Project Experience: Client: Ohio Department of Health, Columbus, OH Feb 15 - Aug 18 Role: Power BI Consultant Delivered Bl reporting solutions in Power BI Reporting Services (SSRS), Tableau and MicroStrategy, Design and develop data warehouse projects and data marts, model and create Power BI projects, logical data marts, and table structures; and define attributes, dimensions, hierarchies, and metrics. Developed complex SQL queries using stored procedures, common table expressions (CTES), temporary tables to support Power BI and SSRS reports. Created reports from HIPAA database from audit reports and number of times accessed patient data. Collaborated with IT teams to design and deploy scalable ETL processes for data ingestion and transformation, enabling seamless integration of disparate data sources into OAC/Power BI dataflows. Validating Designing of outbound CCDs using the HL7 version 3.0 from clinical EMR system. Build advanced analytics in Power BI using Oracle, SQL Server and Teradata in Live and Import connections. Developed custom reports and deployed them on server using Power BI. Monitored, debugged, and tuned Power BI services to enhance performance, reliability, and user experience, including the troubleshooting of complex issues in reports, cubes, and semantic models. Implemented automated monitoring and alerting systems for Power BI service health, enabling proactive detection and resolution of performance or data refresh issues. Created Dashboards and visualizations from HIPAA auditing data by doing analysis with threshold values. Migrated existing self-service reports and ad-hoc reports for Tableau\ SSRS to Power BI. Created and deployed cubes in star and snowflake schema. Performed and worked with dimensions, measures, MDX queries. Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts. Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting on SQL Server 2008 using SSAS, SSIS, SSRS. Experience in Reporting Services, Power BI (Dashboard Reports), Crystal Reports, SSRS using MS SQL Server and in supporting services MDX technology of the analysis services. Project Experience: Client:AgFirst, Columbia, SC Aug 14 Feb 15 Role:Tableau Developer Deep experience with the design and development of Tableau visualization solutions. Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop. Used groups, combine fields, calculated fields and aggregated fields and spotlighting to compare and analyze data in different perspectives. Worked on creating interactive, real-time dashboards using drilling downs and customizations. Published Workbooks and Dashboards to the Tableau server. Importing tables using Warehouse catalog and Creating Logical Tables Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports. EDUCATION: Master s in computer science, Valparaiso University, 2014. B. Tech in Computer Science, JNTUK, 2012. Keywords: user interface business intelligence active directory information technology microsoft procedural language Illinois Maryland Ohio South Carolina