Summary
Overview
Work History
Education
Skills
Timeline
Generic

Bhargav

Contact

Summary

  • Experienced professional with over 6 years of expertise in developing and optimizing data-driven solutions.
  • Experienced in exhibiting expertise to create precise Power BI dashboards and reports for intranet applications on IIS.
  • Proficient in Python, gaining experience in parsing XML and JSON, and loading data into databases.
  • Experienced in designing and implementing efficient ETL operations with SSIS across diverse data sources.
  • Authorized T-SQL queries and stored procedures aligned with business logic in accounting and health insurance systems.
  • Demonstrated strong problem-solving skills in cloud-based environments, gaining valuable experience working independently and with cross-functional teams.
  • Experienced in implementing scripts for automating SFTP processes,PGP encryption and decryption and Azure.
  • Gained experience in developing comprehensive documentation covering system architecture and configurations in an agile framework.
  • Proficient in utilizing debugging skills to troubleshoot and resolve issues, ensuring seamless data processes and script functionality.
  • Experienced in designing and implementing robust database solutions in Azure SQL Data Warehouse.
  • Experienced in implementing export functionalities to CSV and XLSX formats, improving data accessibility.
  • Experienced in creating and maintaining interactive Power BI reports and dashboards, providing insightful visualizations.
  • Proficient in implementing Microsoft BI and Azure BI solutions, including Azure Data Factory, Power BI, Azure Analysis Services, SSIS, and SSRS, gaining valuable experience in the process.
  • Experienced in developing complex calculated measurements using DAX in Power BI, showcasing a high level of expertise.
  • Collaborated with IT teams to seamlessly integrate DNS and firewall configurations, optimizing overall system architecture and gaining valuable experience.
  • Experienced professional with expertise in the health insurance industry, specializing in SSRS report development. Proficient in crafting reports that include billing, accounting, and other metrics for comprehensive financial insights.
  • Experienced in query optimization to enhance the performance of stored procedures and reports.
  • Gained experience in independently creating and validating data sets for analysis, ensuring relevance and accuracy for Power BI visualizations.
  • Proficient in utilizing PowerShell to manage and automate network stack configurations, ensuring consistent and secure network functionality.
  • Proficiently monitored, developed, and troubleshooted errors in batch jobs, demonstrating a high level of expertise and gaining valuable experience.
  • Experienced in creating and maintaining Power BI gateways, scheduling Power BI dataset refresh.
  • Proficient in developing multiple complex Power BI reports using SQL Queries/Excel as data sources, manipulating relationships between tables in Power BI model.
  • Proficient in ensuring security and compliance standards for VM deployments, implementing encryption, and access controls, gaining valuable experience in the process.
  • Gained experience in analysis, requirement gathering, function/technical specifications, development, deployment, and testing.
  • Experienced in developing and fine-tuning SQL scripts for optimal performance and scheduling.
  • Experienced in executing single-valued data conversion from flat files into a normalized database structure.
  • Proficient in conducting performance tuning for long-running T-SQL scripts and stored procedures.
  • Experienced in creating SSIS Packages using control flow and Data flow items according to business requirements.
  • Collaborated with IT teams to seamlessly integrate DNS and firewall configurations into the overall system architecture and infrastructure, gaining valuable experience.
  • Experienced in developing reports using complex formulas and querying the database to generate different types of ad-hoc reports using SSRS.
  • Proficient in optimizing ETL operations in SSIS for efficient data processing in various formats.
  • Proficiently employed PowerShell for automation, including report generation, data manipulation, and tasks related to processes.
  • Experienced in automating the creation of Jira tickets for any issues related to data processing, allowing for quick identification, resolution, and documentation within the Jira platform.
  • Experience in integrating real-time data into SSRS reports using C# and Java, I proficiently leverage dynamic data sources and seamless external connectivity for delivering timely and accurate insights to meet dynamic business needs.

Overview

6
6
years of professional experience

Work History

Data Analyst

Metra
01.2021 - Current
  • Developed precise Power BI dashboards and reports for intranet applications on IIS, aligned with user requirements.
  • Write Python scripts to parse XML and JSON documents and load data into a database.
  • Developed SSIS packages for efficient ETL operations compatible with diverse data sources.
  • Authorized T-SQL queries and stored procedures, aligning with business logic in accounting and health insurance systems.
  • Developed multiple SQL queries for Data Warehouse/Data Visualization DB and executed scripts for tables and stored procedures.
  • Demonstrated strong problem-solving skills, particularly in cloud-based environments, working independently and across cross-functional teams.
  • Exhibited expertise in accounting systems and secure data handling.
  • Implemented scripts for automating SFTP processes and PGP encryption/decryption.
  • Proficient in Jira for issue tracking and integrating Python scripts for streamlined processes.
  • Developed comprehensive documentation in an agile framework, covering system architecture and configurations.
  • Utilized debugging skills to troubleshoot and resolve issues, ensuring the seamless functioning of data processes and scripts.
  • Design and implement database solutions in Azure SQL Data Warehouse.
  • Implemented export functionalities to CSV and XLSX formats, improving data accessibility.
  • Created and maintained interactive Power BI reports and dashboards, providing insightful visualizations for data analysis.
  • Experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, Azure Analysis Services, SQL Server Integration Services, and SQL Server Reporting Services.
  • Developed complex calculated measurements using Data Analysis Expression Language DAX.
  • Collaborated with IT teams to seamlessly integrate DNS and firewall configurations, optimizing the overall system architecture.
  • Created SSIS packages that pick files from a shared folder, transform the data as per the requirement, and generate output files that are used for 3rd party integration.
  • Develop ETL packages with different data sources (SQL Server, Flat Files, Excel source files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Create and maintain packages using Microsoft SQL Server Integration Service (SSIS).
  • Involved with Query Optimization to increase the performance of the Stored Procedure/Report.
  • Independently created data sets for analysis, ensuring relevance and accuracy for Power BI visualizations.
  • Implemented PowerShell scripts for logging and monitoring stored procedure execution, enhancing visibility and troubleshooting capabilities.
  • Utilized PowerShell to manage and automate network stack configurations, ensuring consistent and secure network functionality.
  • Implemented ETL and data movement solutions using Azure Data Factory, SSIS create and run SSIS Package ADF V2 Azure-SSIS.
  • Develop, monitor, and troubleshoot errors occurring in Batch Jobs.
  • Expert knowledge in creating and maintaining Power BI enterprise data gateway and involvement in other Power BI admin activities like publishing Power BI reports, scheduling data refreshes, converting datasets into incremental data refreshes, etc.
  • Created and maintained Power BI gateways from various On Perm servers and data sources, to schedule Power BI dataset refresh.
  • Develop multiple complex Power BI reports using SQL Queries/Excel as the data source and manipulate relationships between tables in Power BI model as required.
  • Optimized VM performance, including resource allocation, for efficient data processing and application responsiveness.
  • Ensured security and compliance standards for VM deployments, implementing encryption and access controls.
  • Produced monthly reports using advanced Excel spreadsheet functions.

SSRS/SSIS Developer

Excell Media Pvt Ltd
01.2018 - 12.2020
  • Involved in analysis, requirement gathering, function/technical specifications, development, deployment, and testing.
  • Created database objects such as schemas, logins, tables, clustered and non-clustered indexes, views, functions, and stored procedures.
  • Developed SQL scripts for tuning and scheduling, including optimization of SSRS reports.
  • Performed single-valued data conversion from a flat file into a normalized database structure, aligning with SSRS reporting requirements.
  • Designed, developed, and deployed reports in MS SQL Server using SSRS, including single-value and multi-value parameterized reports.
  • Performance tuning for long-running T-SQL scripts, stored procedures, and SSRS reports.
  • Managed CSV and XLSX formats using Python scripts for efficient data processing, export, and accessibility.
  • Executed regular audits of data processes and storage, identifying areas for improvement, including SSRS report performance, and implementing necessary adjustments.
  • Applied PGP data encryption to secure sensitive information during transfer and storage, including data presented in SSRS reports.
  • Created SSIS Packages using Control flow and Data flow items according to business, ensuring alignment with SSRS reporting needs.
  • Experience in scheduling the SSIS Packages through SQL server jobs, coordinating with SSRS report delivery schedules.
  • Collaborated with IT teams to seamlessly integrate DNS and firewall configurations into the overall system architecture and infrastructure, supporting SSRS reporting requirements.
  • Developed reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS, aligning with overall reporting needs.
  • Used conditional split or derived columns in SSIS for flexible transformations, supporting diverse SSRS reporting requirements.
  • Optimized ETL operations in SSIS for efficient data processing in various formats, ensuring data readiness for SSRS reporting.
  • Independently created data sets for analysis, ensuring relevance and accuracy for SSRS reporting.
  • Employed PowerShell for automation, including report generation, data manipulation, and tasks related to processes, enhancing overall efficiency, including SSRS report automation.
  • Utilized PowerShell for DNS automation tasks and integrated cloud-based services for automated workflows, supporting overall system architecture, and SSRS reporting needs.
  • Integrated billing-related data transformations within SSIS packages for accurate financial processing, aligning with financial reporting needs in SSRS.
  • Enhanced reporting capabilities, incorporating specific billing metrics tailored for comprehensive financial insights within SSRS reports, leveraging experience in the health insurance industry.
  • Automated the creation of Jira tickets for any issues related to data processing, allowing for quick identification, resolution, and documentation within the Jira platform, including SSRS-related issues.
  • Leveraged the capabilities of C# and Java to integrate real-time data into SSRS reports. This involved the incorporation of dynamic data sources, enabling the reports to pull and present information in real-time, ensuring that the data was always up-to-the-minute.

Education

Bachelor of Science - Computer Science And Engineering

Gitam University
Hyderabad

Skills

  • Languages: Python, Java, C#, SQL, Powershell, JavaScript, T-SQL
  • Databases: SQL Server 2019, Oracle, MySQL, Microsoft SQL Server, OLAP, OLTP
  • Packages: MS Visual Studio, MS Project, and Photoshop
  • ETL and Reporting Services: SSIS, SSRS, SSAS, Excel 2010/2013, Power BI
  • Operating System: Windows 7, 8, 10, UNIX, Linux, Mac OS

Timeline

Data Analyst

Metra
01.2021 - Current

SSRS/SSIS Developer

Excell Media Pvt Ltd
01.2018 - 12.2020

Bachelor of Science - Computer Science And Engineering

Gitam University

Similar Profiles

CREATE PROFILE
Bhargav