Soumya Sebastian

Power BI Developer

• Job Details:Experience with creating new Power BI reports and modification of existing reports as per the user stories created by Microsoft FTE. Created tables, views, and stored procedures for the database which processed data for Power BI reports. Do daily ROB (Rhythm of Business) testing for reports and Azure resources. Created Logic Apps for mailers for end users of different roles and notifications for the internal team. Created and modified Azure Data Factory which process the data from the source for database and Power BI reports. Created test plans and did manual testing of Power BI reports and database. Analyzed and created POC on Selenium automation testing for Power BI and web application. Analyzed and resolved Microsoft Defender created security issues in Azure resources. Analyzed and resolved Sonar Cube code smells in DB objects. Created technical specification documentation for Power BI reports, Azure Data Factory pipelines and Logic Apps.

Production Support Team Member

• Job Details:Experienced as L3 .NET application support for Microsoft Azure IaaS and PaaS applications. Experienced with application migration from physical to Azure. Managed virtual machines. Incident management, queue management and change management using ServiceNow. Monitor and maintain the server storage of applications log, prioritize, resolve the incidents within the agreed SLAs resolving recurring incidents permanently and taken preventive measures monitoring the application and server availability. Coordinated and carried out change deployments. Expertise in impact analysis on infrastructure changes. Drive P1S1 (Priority 1, Severity 1) issue resolution. Supported Microsoft patch deployment and post-deployment validations of servers and applications. Created KB articles (knowledge base). Created document of understanding (DOU) for the .NET applications. Experienced in root cause analysis.

Data Analyst & Database Administrator

• Job Details:Expertise in Power BI report creation and maintenance. Experienced as a database administrator for both on-prem and Azure databases. Expertise in SQL coding for ETL activities. Good hands-on in Azure Data Factory, Azure SQL and various IaaS and PaaS resources. Expertise in implementing ETL activities using SSIS packages and managing SSIS jobs. Experienced in implementing DevOps practices. Experienced in CI/CD deployment for database. Expertise in SQL job deployment, scheduling and troubleshooting. Developed and tested proof of concepts (POCs) to explore new technical solutions. Interacting with clients for requirement gathering, problem resolution, testing, and issue clarifications. Experienced in project planning and estimation for development activities. Expertise in root cause analysis.