Hari B

Experience

• 

  DXC Technology

  Jul 2014 - Jan 2016

  SQL Developer

  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. Show less

• 

  Pravtek Solutions Pvt limited

  Jan 2016 - Jan 2018

  SQL Developer/BI developer

  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. Show less

• 

  T-Mobile

  Feb 2018 - Nov 2020

  Business Intelligence Analyst

  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. Show less

• 

  Wanclouds Inc.

  Nov 2020 - Jan 2022

  BI Analyst

  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. Show less

• 

  AXEL Informatica srl

  Feb 2022 - now

  Designed, developed, and maintained ETL processes using T-SQL and SSIS for data extraction and loading into the data warehouse.Created efficient Stored Procedures, Functions, Indexes, Tables, and Views, establishing T-SQL scripting standards.Implemented Tableau BI Dashboard reporting solution and administered an enterprise-wide Tableau application.Integrated Python scripts for data preprocessing in Power BI, enhancing data quality.Built Pipelines in Azure Data Factory and utilized Azure Databricks for unstructured data transformation.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.Conducted performance tuning activities for Power BI reports and Analysis Services models.Implemented version control for Power BI reports, SSIS packages, and SSAS models.Contributed to the development of Snowflake data warehousing solutions, collaborating with cross-functional teams.Worked on creating and maintaining DAX calculations and queries for advanced analytics.Designed and implemented data models for business analytics, optimizing query performance.Created dynamic and user-interactive reports using parameters and expressions in SSRS to filter and customize data presentations based on user input.Streamlined reporting processes by building SSRS reports, enhancing data accessibility.Integrated SSRS with various data sources, including SQL databases, OLAP cubes, and web services. Show less

  • Power Bi Developer

    Feb 2022 - now

  • Data / BI Analyst

    Feb 2022 - now