Summary
Overview
Work History
Education
Skills
Awards
Timeline
AccountManager
Siva Sevala

Siva Sevala

Technical Lead
Hyderabad

Summary

  • Experienced software professional with 8+ years of experience in ETL using SSIS, Data Modeling using SSAS and Azure Analysis Services, Data Analytics and Data Warehouse using SQL, Dashboards and Reports using Power BI and SSRS.
  • Experienced in handling different teams and delegation of work to meet the timelines.
  • I enjoy playing Cricket, Chess and Cards in free time.

Overview

8
8
years of professional experience
4
4
years of post-secondary education

Work History

Technical Lead

Birlasoft
Hyderabad
02.2021 - Current
  • Acted as a team leader in group projects, delegating tasks and providing feedback.
  • Analyzed enterprise data holdings to reduce redundancy of data within existing systems.
  • Reviewed project requests describing the user needs to estimate time and cost required to accomplish projects.
  • Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
  • Designed Azure Analysis Services data models for complex analysis needs using defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using DAX, Perspectives and Roles.
  • Automated model processing step using Azure Data Factory which increased the performance by 60%.
  • Developed Multiple Power BI dashboards on top of Azure Analysis Service Model.
  • Expertise in DAX Queries to build Power BI calculated measures and Calculated columns.
  • Published Power BI reports to Power BI web service and Implemented Security for users.
  • Directly interact with end users to get the ad hoc requirements and report modifications

Kagool Data

Sr. Consultant
Hyderabad
04.2020 - 01.2021
  • Migrated existing Multi-Dimensional model to Azure AS Model.
  • Built Measures, KPIs, Calculated columns in tabular model using DAX queries.
  • Created partitions and automated processing approach which helped to maintain low cost.
  • Worked on performance tuning of model which helped cost reduced by 40%.
  • Handled data securities and implemented Row Level Security in Azure AS Model.
  • Build Power BI Dashboards with functionalities Bookmarks, Navigation, Web URLs and many key features.

Technovert Solutions

Sr. Software Engineer
Hyderabad
10.2014 - 03.2020
  • Analyzed existing SQL queries to identify opportunities for improvements.
  • Designed and implemented TSQL queries for reporting and complex solution development.
  • Designed and developed customized extract, transform and load (ETL) applications per client specifications using SSIS.
  • Developed SSIS packages for data migration between different sources such as flat file, excel, oracle, Sybase, SQL Server 2005/2008 R2/2012/2016/2019 by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union.
  • Used Row Transformations, Block and Unblock Transformations for Performance Tuning in SSIS packages and Logging, Error handling using Event Handlers pre and post for SSIS Packages. .
  • Experience in working with Data Cleansing technique in ETL procedures.
  • Resolved complex business issues, proposing long-term solutions to avoid repeat problems.
  • Designed Data Model with multiple Fact Tables and Dimensions depending on the business requirements.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Identified and worked with Parameters for parameterized reports in SSRS.
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Responsible for scheduling the subscription reports with the subscription report wizard.

Education

B. Tech - Computer Science & Engineering

BVCITS
Amalapuram
09.2006 - 04.2010

Skills

    Azure Analysis Services

undefined

Awards

  • Star Performer by Birlasoft in Aug-2022
  • Customers Delight by Birlasoft in Feb - 2022
  • Rising Star by Technovert Solutions in Apr - 2017

Timeline

Technical Lead

Birlasoft
02.2021 - Current

Kagool Data

Sr. Consultant
04.2020 - 01.2021

Technovert Solutions

Sr. Software Engineer
10.2014 - 03.2020

B. Tech - Computer Science & Engineering

BVCITS
09.2006 - 04.2010

Similar Profiles

CREATE PROFILE
Siva SevalaTechnical Lead