Summary
Overview
Work History
Education
Skills
Projects
Languages
Timeline
Generic

Sruthi Manam

Hyderabad

Summary

Overall 5+Years of IT industry experience and having around 3+Years of experience on working in Power BI, SQL Server Integration Services, SQL Server Reporting Services and SQL Server. And experience in gathering data from various sources and transforming it into insightful reports and dashboards.

Overview

7
7
years of professional experience

Work History

Senior Engineer

LTIMindtree
02.2024 - 06.2024

Power BI Developer

Tech Mahindra Pvt Ltd
11.2021 - 06.2022

Software Engineer

Optum Global Solutions
03.2020 - 07.2021
  • Analyzing the client requirements
  • Written the data base stored procedures and views in SQL
  • Design of the SSRS reports as per the requirements
  • Worked on Change Requests to change the functionality of the system
  • Worked on automation of files, which was processed manually in the system
  • Created jobs and scheduled them as part of the files processing on monthly basis
  • Worked on Sprint changes by which Client benefits were boosted
  • Created Unit Test case scenarios and Business scenarios for my modules
  • Direct involvement with client communication to understand the business
  • Creating dashboards in Power BI and maintain the RLS security for the users
  • Creating Hierarchies and relations ships in power Bi reports
  • Publishing the reports into power BI service and maintain the scheduling processes
  • Performed unit testing for the jobs developed to ensure that it meets the requirements

Software Engineer

Artech Global Solutions
05.2019 - 11.2019

Associate Engineer

W3Softech
05.2017 - 05.2019

Education

B. Tech - CSE

Acharya Nagarjuna University
01.2016

Skills

  • MS SQL Server 2014
  • MS SQL Server 2016
  • SSRS
  • Power BI Desktop
  • Power BI service
  • SSIS
  • SQL
  • T-SQL
  • DAX
  • Windows Family

Projects

Capture RX, Software Developer, SQL, SSRS, POWER BI, This project regards to US Health Care federal program initiated in America as part of public interest. This is a Program run for people who are not able to bear medical cost. Under this program Clinics or Hospitals provide service to people and get insured payment from federal government, which is organized by state government., Analyzing the client requirements., Written the data base stored procedures and views in SQL., Design of the SSRS reports as per the requirements., Worked on Change Requests to change the functionality of the system., Worked on automation of files, which was processed manually in the system., Created jobs and scheduled them as part of the files processing on monthly basis., Worked on Sprint changes by which Client benefits were boosted., Created Unit Test case scenarios and Business scenarios for my modules., Direct involvement with client communication to understand the business., Creating dashboards in Power BI and maintain the RLS security for the users., Creating Hierarchies and relations ships in power Bi reports., Publishing the reports into power BI service and maintain the scheduling processes., Performed unit testing for the jobs developed to ensure that it meets the requirements. Spicejet Datamart, BI Developer, Power BI Desktop, Service, The Project is basically to convert old Reports that were in Excel into Power BI for making it more interactive and user friendly., Gathering Requirements from the client., Developed various dashboards using different charts like Bar charts, Combination charts, Area charts and heat maps and Custom Visuals., Created new columns and new measures using DAX., Created Drill Down Reports, Drill Through Report by Region., Connected data from excel datasets., Designing, developing and implementing Business Intelligence reports., Connect to different Data sources from Power BI., Publishing reports in Power BI services. MQA Product Materials, Test Engineer, UnitedHealth Care Medicare & Retirement is part of the family of companies that make UnitedHealth Group one of the leaders across most major segments of the US health care system. Materials Automation is to automate required and non – required materials for Medicare members using CMS models as input based on products types like ANOC, EOC, SB and BenHi. Any materials that use the same benefits, the data required to automate is available, if material type meets cost effective criteria and documents that are not highly customized can be programmed for automation.

Languages

Telugu
Advanced (C1)
English
Upper intermediate (B2)

Timeline

Senior Engineer

LTIMindtree
02.2024 - 06.2024

Power BI Developer

Tech Mahindra Pvt Ltd
11.2021 - 06.2022

Software Engineer

Optum Global Solutions
03.2020 - 07.2021

Software Engineer

Artech Global Solutions
05.2019 - 11.2019

Associate Engineer

W3Softech
05.2017 - 05.2019

B. Tech - CSE

Acharya Nagarjuna University
Sruthi Manam