Over 5 years of experience in Power BI development and SQL Development. Proficient in Power Query Editor, DAX functions, Power BI Desktop and Power BI service. Expert in creating paginated reports. Expertise in Client server application development using Oracle 11g/10g,12c,19c SQL LOADER, SQL navigator, Service now. Effectively made use of Table functions,Analytical functions, Materialized views. Experienced in SQL performance tuning using Cost based Optimization. Also used Informatica and SSIS. Learned basic cloud computing.
Project 1: GE Vernova
* Data modelling from different objects and gathering final transformed reports as per requirement.
* Deploying the dashboards to UAT from the Development environment.
* Analyze and interpret complex datasets relating to customers business and prepare reports for internal and external audiences using business analytics reporting tools.
* Creating dashboards by using transformed final reports as table format and Charts.
* Developed different styles of chart like Bar,Donut,Line,Area.
* Create data dashboards,graphs and visualisations to showcase business performance and also provide sector and competitor benchmarking.
Project 1: BAU Housing
* Created calculated columns and calculates measures
* Created Visuals and Reports in Power BI Desktop and publish into Power BI Service
* Created Reports using custom visuals and Dashboards in Power BI
* Generated reports using DAX time intelligence functions and other DAX functions
* Done Scheduling using Gateway
Project 1: AIG Insurance
* Involved in creating Hierarchies and giving the relationship between attributes to decrease
processing time
* Involved in creating calculated columns and measures
Created custom visuals and reports in Power BI Desktop and Dash boards normally and also
using DAX functions as per the requirements
* Created data dashboards,graphs and visualisations to showcase business performance and also provide sector and competitor benchmarking
Project 1: Macqarie Groups
* Developed PLSQL Procedures and Functions. Did Patching works according to the Change
requests. Handled Incident tickets, Problem tickets and change requests. Did job monitoring.
Job scheduling.
Project 2: PLSA Banking
* Developed advance PL/SQL packages, procedures, triggers, functions, Indexes and collections
to implement business logic using SQL navigator. Generated server side PL/SQL scripts for
data manipulation and validation and materialized views for remote instances. Involved in
table partitioning, compressing and indexes for improved performance and efficiency.
Performed modifications on existing form as per change request and maintained it.