Summary
Overview
Work History
Education
Skills
Timeline
Generic

Nirosha A

Chittor

Summary

Accomplished Senior Software Engineer with expertise in Power BI and SQL, previously at Sapphire System Pvt Ltd. Demonstrated leadership and problem-solving skills, successfully migrating 90% of on-premises data to the cloud. Proficient in creating impactful dashboards and optimizing ETL processes, enhancing data-driven decision-making for clients.

Overview

13
13
years of professional experience

Work History

Senior Software Engineer

Sapphire System Pvt Ltd
Hyderabad
02.2024 - Current
  • Developed Client/Server applications using a range of Microsoft Technologies, including Power BI, SQL Server, Data Warehousing, MSBI, PowerBI.
  • Generating SQL queries from given structure and syntax, creating stored procedures, resolving complex database queries, designing ETL process, creating dashboards using Power BI visualizations, publishing reports in Power BI Services, creating content packs, implementing Row Level Security (RLS), enabling filters for reports, creating Azure secrets and Key vaults, creating triggers, data movement from Rest API, Azure SQL to storage accounts, CICD, and creating business calculations using DAX expressions.
  • Performance Tuning for SQL Queries and Scripts.
  • Migration of data from different storage accounts and On-premises data to cloud.
  • Creation of PowerBi dashboards for KPI for Mercedes Benz and Performance tuning for PowerBi constant review from Business team for modification and changes in the dashboards.
  • Executing SSIS Packages and usage of Event handlers for Debugging.
  • Solving customer related issues which we will be received in mails regarding data which we have produced.
  • Development of ETL process in DEV,UAT environment after verification from Business team publishing the data into Production Environment.
  • Creation of End to Powerbi Reports and experience on migration of SSRS reports to Powerbi.
  • Migration of On premises data into clouds using ADF pipelines and monitoring the ADF jobs.

Senior Consultant

Capgemini
Bangalore
10.2023 - 01.2024
  • Developed DAX measures in Tabular model cubes for building powerbi reports.
  • Experience in Powerbi Embedded service. Premium accounts.
  • Completing monthly activities and performing the unit testing and sharing the data with testing team once approved presenting the same in Sprints.
  • Performance Tuning for SQL Queries and Scripts.
  • Migration of data from different storage accounts and On-premises data to cloud.
  • Creation of PowerBi dashboards for KPI for Mercedes Benz and Performance tuning for PowerBi constant review from Business team for modification and changes in the dashboards.
  • Executing SSIS Packages and usage of Event handlers for Debugging.
  • Solving customer related issues which we will be received in mails regarding data which we have produced.
  • Development of ETL process in DEV,UAT environment after verification from Business team publishing the data into Production Environment.
  • End to end experience with SQL ETL Operation and PowerBi Dashboard creation.

Senior Software Developer

Inventech Info solution Pvt Ltd
Bangalore
05.2022 - 06.2023
  • Developed Client/Server applications using a range of Microsoft Technologies, including Power BI, SQL Server, Data Warehousing, MSBI.
  • Generating SQL queries from given structure and syntax, creating stored procedures, resolving complex database queries, designing ETL process, creating dashboards using Power BI visualizations, publishing reports in Power BI Services, creating content packs, implementing Row Level Security (RLS), enabling filters for reports, creating Azure secrets and Key vaults, creating triggers, data movement from Rest API, Azure SQL to storage accounts, CICD, and creating business calculations using DAX expressions.
  • Performance Tuning for SQL Queries and Scripts.
  • Migration of data from different storage accounts and On-premises data to cloud.
  • Creation of PowerBi dashboards for KPI for Mercedes Benz and Performance tuning for PowerBi constant review from Business team for modification and changes in the dashboards.
  • Executing SSIS Packages and usage of Event handlers for Debugging.
  • Solving customer related issues which we will be received in mails regarding data which we have produced.
  • Development of ETL process in DEV,UAT environment after verification from Business team publishing the data into Production Environment.
  • End to end experience with SQL ETL Operation and PowerBi Dashboard creation.

Operation Executive

Innov Source
Bangalore
05.2021 - 05.2022
  • Worked on issues reported by the Client.
  • Generated SQL queries, created stored procedures, resolved complex database queries, designed ETL process, created dashboards using Power BI visualizations, published reports in Power BI Services, created content packs, implemented Row Level Security (RLS), enabled filters for reports, imported data from developed excel into Power BI Desktop, created Azure secrets and Key vaults, created triggers, data movement from Rest API, Azure SQL to storage accounts, CICD, and created business calculations using DAX expressions.

Senior Operation Executive

Agies
Karnataka
07.2019 - 04.2021
  • Designed ETL process for extraction and transformation of data from the source Database and loading on to the target database, implemented complex business rules using multiple transformations, handled errors efficiently, worked in support role as well for meeting the request, in-depth knowledge and hands on experience on MySQL database with good logic creation, good exposure of Joins, functions, indexes, SQL/PSQL, generating, debugging, and executing stored procedure, writing and resolving complex database queries, Azure data factory migration of data from on-premises to cloud creation of different types of Triggers, creation of Azure secrets and Key vaults, data movement from Rest API, Azure SQL to storage accounts, knowledge about CICD, knowledge about different activities like For each, Lookup, copy data activities, Data flows, etc.

Process Associate

HP
Karnataka
10.2012 - 10.2014
  • Scheduled SSIS packages to run as jobs periodically according to the requirement using SQL Server Agent, configured SSIS packages to move the same between different Environments and for optimal performance, created cubes using data from data marts/warehouses for deep analysis; designed error tolerant SSIS packages; logged execution details, worked directly with users and business partners to gather reporting requirements and provide solutions, worked on customer/client support role solving the client issues, created purchase order on Behalf of HP customer through HP internal portal or manually, if any missing information directly contact with customers to collect the information, if Customer representative officers will create an tickets related to purchase orders we have to resolve the issue, pull the tasks from internal portal and assign with the team and make sure to clear the tickets to finish.

Education

MBA -

KSSEM
Bangalore
07.2012

Skills

  • Leadership
  • Problem solving
  • Decision making
  • Team work
  • Adaptability
  • Time management
  • PowerBI Serivice Level
  • SQL
  • ADF
  • SSIS
  • SSRS
  • SSAS
  • DAX
  • Powerbi Desktop

Timeline

Senior Software Engineer

Sapphire System Pvt Ltd
02.2024 - Current

Senior Consultant

Capgemini
10.2023 - 01.2024

Senior Software Developer

Inventech Info solution Pvt Ltd
05.2022 - 06.2023

Operation Executive

Innov Source
05.2021 - 05.2022

Senior Operation Executive

Agies
07.2019 - 04.2021

Process Associate

HP
10.2012 - 10.2014

MBA -

KSSEM

Similar Profiles

CREATE PROFILE
Nirosha A