Jagadeesh Bondu

ETL AND POWER BI DEVELOPER

• I am responsible to handle end to end reporting of the Learning portal. Responsible for dynamic flow of data from source DB to reporting DB, to be used for report creation.
• Worked on the Business Analytics, Reporting, ETL. Performed ADF transformations, and refactoring of Power BI reports.
• Implemented row‑level security via ADF and Power BI to support multiple tenancy of the report.
• Understood the existing ADF dataflows and replaced them with ”copy data” activity to reduce ADF runtime and cost optimization.
• Restructured the ADF pipeline to make the report show near real time data.
• Created automated workflows with the help of triggers.
• Refactored the Power BI report to Direct Query Mode.
• Implemented Power BI Embedded to be used by the Application.

POWER BI DEVELOPER

• Gathering the requirements from business users and analyzing those requirements and providing estimates.
• Imported data from SQL Server DB, Excel to Power BI to generate reports .
• Created highly interactive reports and Dashboards by understanding the business requirements.
• Created DAX Queries to generate computed columns in Power BI. Generated computed tables in Power BI by using DAX.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Used Power BI Gateway to keep the dashboards and reports up to date.

BI DEVELOPER

• Understand requirements from clients and design solution approach.
• Imported data from SQL Server DB, Excel to Power BI to generate reports
• Worked on Data modeling, calculated fields like Periodic Calculations and Aggregate.
• Worked on all types of transformations that are available in Power query editor.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Experience in Publish of Power BI reports to Power BI server.

ETL and SSRS Report Developer.

• Deployed SSIS packages to different environments using package configurations of type environment variable and SQL Server table.
• Designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Written T-SQL scripts, dynamic SQL, complex stored procedures, functions.
• Created SSIS packages to pull data from SQL Server and exported to flat files, CSV files and Excel Spreadsheets.
• Involved in maintenance and administration of SSIS by creating Jobs, alerts and schedule SSIS packages.
• Created SSIS packages to unzip files and move them to folders dynamically based on the file names.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Involved in performance tuning and optimization of stored procedures and queries.
• Created Drill Down and Drill Through Reports in SSRS.