add photo
Sangeetha
sangeeta.bolla@gmail.com
551-222-1188
Hackensack, NJ 07602
MSBI Developer / Power BI Developer
14 years experience W2
0
Recommendations
Average rating
221
Profile views
Summary

  • Over 8+ Years of experience as MSBI Developer and Power BI Developer in Production, Development and Staging Environments with hands-on experience in Heterogeneous files processing like Flat Files, Excel and CSV files in SSIS and developing Dimensions, Measures, Cubes using SSAS.
  • Expertise in SSIS Customization by extending MS Business Intelligence Framework and writing stored procedures and views for SSIS, SSRS in SQL Server.
  • Expertise in developing, monitoring, implementing ETL process in SSIS using various tasks and transformations.
  • Expertise in creating and updating tables in MS SQL Server using T-SQL.
  • Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables) using Analysis Services.
  • Expertise in writing complex SQL Queries using Joins, CTE'S, Functions, and Sub Queries in T-SQL.
  • Experience in creating visualizations and dashboards in Power BI and publish them.
  • Worked in creating different types of reports and data models in Power BI.
  • Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
  • Expertise in Debugging, Error Handling and Production support for SSIS.
  • Extensive knowledge in Administering, Managing and Troubleshooting Reporting services.
  • Knowledge in Azure SQL, Azure Data Lake, Azure data warehouse, Azure data factory.
  • Extensive practical knowledge in importing data for use in reporting, graphs, and flowcharts.
  • Experience in developing complex calculations for Power BI Reporting and Tabular model using DAX.
  • Participated actively in all phases of SDLC including Requirement Gathering, requirement analysis, Designing Data Models, Development, Testing, go live and Post Go Live Support.
  • Excellent problem-solving, multitasking, business analytical and critical thinking with the ability to work on fast based environment. reporting tools, software, and other applications, including SQL Database, Tableau and Data warehouse.
  • Developed SSAS Tabular model and deployed it into Azure Analysis Services to provide scalable data source for Power BI Reporting.
  • Designed reports using SQL Server Reporting Services (SSRS) based on OLAP cubes improving communications, relations, sales, quality, and morale.
  • Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
  • Performed SSRS Drill-down, Drill-through and Pivot Reports, providing a paid subscription to customer. SSRS Subscription model for each report so that, an ASP.Net application subscribes in runtime enabling others to have the data in a usable form to make decisions or plan better. Environment: MS SQL Server 2014, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL, Microsoft Office 2010, and TFS.

Experience
Education
Jawaharlal Nehru Technological University 2008
Skills
ETL
2022
10
SQL
2022
10
SQL Server
2022
10
SSIS
2022
10
SSRS
2022
10
T-SQL
2022
10
Data Warehousing
2022
8
MS Azure
2022
8
Tableau
2022
8
Triggers
2022
8
Stored Procedure
2022
7
BI Developer
2022
5
Data Lakes
2022
5
Data Modeling
2022
5
MS Power BI
2022
5
MS TFS
2022
5
Oracle
2022
5
Snowflake
2022
5
ASP.NET
2017
3
SSAS
2017
3
SSAS CUbe
2017
3
Business Intelligence
2014
2
Database Backups
2014
2
SQL Developer
2014
2
WebServices
2014
2