Hari Boddu Email & Phone Number

Rockville, Md

• Designed and maintained ETL processes using T-SQL and SSIS for data extraction, loading, and transformation.• Implemented Tableau BI Dashboard reporting solution for actionable insights into business performance.• Integrated Python scripts in Power BI to enhance data quality and efficiency.• Utilized Azure Data Factory and Azure Databricks for unstructured data transformation.• Optimized Looker Studio performance by fine-tuning SQL queries, caching strategies, and data modeling techniques, resulting in faster report rendering and improved user experience.• Conducted training sessions and provided documentation to educate users on how to leverage Looker Studio for self-service analytics, empowering teams to make data-driven decisions independently.• Experienced in leveraging C# to optimize performance and enhance the functionality of Power BI solutions for data visualization and analysis.• Proven track record of effectively utilizing C# to interact with databases, including Azure SQL Database, ensuring seamless data integration and management.• Experienced in implementing Agile development methodologies, utilizing C# to rapidly prototype and iterate on solutions in response to changing business needs.• Developed SQL queries, stored procedures, and triggers for data retrieval, manipulation, and reporting.• Conducted performance tuning activities for Power BI reports and AAS models to enhance query performance and reduce data retrieval times.• Implemented version control for Power BI reports and AAS models, ensuring traceability and rollback capabilities.• Integrated Power BI reports with SQL databases, Tableau dashboards, and SAP ERP systems.• Led the design and implementation of T-SQL and SSIS ETL pipelines for financial data.• Demonstrated proficiency in Power Query and M language for efficient data extraction in Power BI's dataflows.

San Jose, California, United States

Developed Tableau dashboards and visualizations, optimizing reports for better load times.Collaborated with IT to enhance data warehouse capabilities and maintain data quality.Assisted in developing Power BI dashboards for monitoring insurance KPIs.Developed SQL Server Stored Procedures, tuned SQL Queries using Indexes.Created custom Python visuals in Power BI using Plotly and D3.js for interactive charts.Integrated Python scripts for real-time data pipelines and automation in Power BI.Utilized Python for statistical analysis within Power BI, including hypothesis testing.Conducted data analysis and modeling using SAS for identifying trends and patterns.Wrote complex SQL queries, views, and stored procedures for data retrieval and manipulation in SSRS reports.Developed, designed, and deployed complex SQL Server Reporting Services (SSRS) reports. Created tabular, matrix, graphical, and free-form reports tailored to business needs.Extracted data from various sources, performed transformations, and loaded into Power BI.Connected Power BI to Microsoft Dynamics ERP systems for real-time reporting.Implemented complex DAX calculations for advanced data analysis in Power BI.Implemented security controls in OBIEE to protect sensitive business data.Integrated NetSuite financial data with Power BI for interactive dashboards.Conducted performance tuning in OBIEE for fast query response times.Designed efficient ETL processes using Tableau Prep Builder for data integration.Created interactive dashboards with advanced features in Tableau.Used Azure Databricks for data processing and business logic application.Conducted data profiling and cleansing in QlikView for data quality.Implemented QlikView extensions for enhanced user experience.Implemented dynamic hierarchies and time intelligence functions in AAS models.Leveraged advanced data modeling techniques in AAS for complex scenarios.

Kansas, United States

Implemented core business processes using T-SQL, Stored Procedures, and Functions.Developed complex T-SQL code, including Stored Procedures, Triggers, Functions, Indexes, Tables, and Views.Debugged T-SQL queries for performance tuning and ensured timely completion of ETL processes.Created and modified T-SQL stored procedures/triggers for data integrity validation.Developed SAS Business Intelligence reports and dashboards for critical business insights.Created pipelines using Azure Data Factory and Azure App Services for data retrieval.Designed ETL packages with SSIS, handling various data sources and transformations.Developed interactive Power BI reports and dashboards for Microsoft Dynamics ERP data.Modeled and transformed data from Microsoft Dynamics ERP for effective Power BI use.Integrated diverse data sources into Power BI, including Dynamics ERP, SQL databases, Excel, and external APIs.Integrated Power Apps with external systems using C# for seamless data exchange.Integrated Azure Analysis Services (AAS) with Power Platform components.Developed ETL processes for extracting and transforming data from Epic systems.Created custom reports and dashboards using Epic Reporting Workbench and other tools.Integrated Epic data with other healthcare sources for comprehensive insights.Utilized Tableau, Power BI, or QlikView to create user-friendly healthcare analytics dashboards.Implemented data governance practices to ensure healthcare data quality and security.Employed Python for in-depth analysis of healthcare datasets and trend identification.Developed predictive models in Python and integrated them into Power BI.Applied Python's NLP capabilities to extract information from clinical notes and text data.Integrated Python-based algorithms into Power BI for clinical decision support.Implemented data governance best practices in Python for healthcare data quality and security.

Hyderabad, Telangana, India

Involved in gathering the requirements and conducting meetings with clients. And documented the requirements and ITIL assessment & implementation of the projectCreated new database objects like Stored Procedures, Functions, Packages, Triggers, Indexes, and Views using T- SQL in the Development and Production environment for SQL Server.Created and Rebuilt the Clustered & non-Clustered indexes at regular intervals for better performance.Expertise in designing, developing, and implementing mappings/transformations based on source-to-target specifications, defining ETL (extract, transform, load) and ETL development standards and conventionsDesigned Data Mart using Star Schema. Reviewed the Current Data Mart and OLAP Cubes and Implemented Corrections and enhancements.Developed interactive Power BI dashboards and reports that provide real-time insights into HR metrics, enabling informed decision-making for HR leaders and executives.Collaborated with HR teams to understand project requirements and transform complex HR data into user-friendly visualizations.Automated data extraction and transformation processes, reducing manual effort and ensuring data accuracy in HR reports.Created and optimized SQL queries to extract and manipulate HR data from HRIS and other data sources.ETL document developed for best practices and Reporting systems.Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from different data sources.Used different data Transformations like Lookup, Derived columns, Conditional Split, and data conversion while creating the SSIS Packages.Created several types of reports such as tabular, matrix, drill down, and sub reports using SSRS and sent the information to different clients, vendors and managers.Created groups, roles, and users and assigned access privileges to users. Created various visualizations and reports in Power BI.

Hyderabad, Telangana, India

Interacted with Team and Analysis, Design and Develop database using ER Diagram, involved in Design,Development and testing of the system.Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes).Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications.Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.Created SSIS packages to automate the ETL process included meta data on record count, file size and run time.Wrote and edit SQL Queries for data base testing and report verification.Developed SQL Server reports (SSRS) on daily performance of databases using SQL Server Reporting Services.Worked on client requirement and wrote Complex SQL Queries to generate Reports.Used DDL and DML for writing triggers, stored procedures, and data manipulation.