I’m currently working for Northrock LLC ( US based Firm). I’m responsible for daily activity of Risk Score Card for funds and completion of new projects or task .

Roles & Responsibilities:• Responsible for end-to-end development for HR (Human Resource) Power BI reports, Dashboards & Dataset (DW)• Creating or updating Power BI Reports by gathering requirements from U.K. based Client (Zellis)• Engage stakeholder throughout the build phase and prioritize the report with inputs from stakeholders to maximize ROI• Managed Report Scheduling, Data Sensitivity, Workspace.• Expert in writing Measure, Calculated Column, Query optimization & RLS(Row-Level-Security) implementation

Roles & Responsibilities:• Responsible for end-to-end development for SBI Mutual fund• Creating or updating SSIS Packages, MS SQL Queries, procedure, dynamicquery, DW Database, SSAS Tabular, Power BI Reports• Data ingestion through creating / modified SSIS packages for daily runs byusing checkpoints, if it failed triggered an email to developer team andrectified by using log and reverse engineering.• ETL ingestion divided into 3 parts: Source to stagging tables, stagging table toDW (Fact & Dim Tables), DW to SSAS services (incremental refresh or defaultrefresh)• create / modified ssis catalog, Jobs Scheduling, optimizing ssis packages• Wrote complex SQL queries/ procedure by using recursive cte, inner queries,joins and optimized it• create / modified ssas tables, datasource, relationship between tables,refresh, dynamic partition creation and processing it• I also manage Report Scheduling, Data Sensitivity, Workspace.• I’m expert in writing Measure, Calculated Column, Query optimization & RLS(Row-Level-Security) implementation• IC Dashboard, RM & Brokerage reports were shown at Annual Meeting andwon awards.

Roles & Responsibilities:• Responsible for end-to-end development for Lakshmi Vilash Bank• Creating or updating Pentaho, SSIS Packages, MS SQL Queries, procedure,dynamic query, DW Database, SSAS Tabular, Power BI Reports• Data ingestion through creating / modified Pentaho, SSIS packages for dailyruns by using checkpoints, if it failed triggered an email to developer teamand rectified by using log and reverse engineering.• ETL ingestion divided into 3 parts: Source to stagging tables, stagging table toDW (Fact & Dim Tables), DW to SSAS services (incremental refresh or defaultrefresh)• create / modified ssis catalog, Jobs Scheduling, optimizing ssis packages• create / modified pentaho etl, Jobs Scheduling through cron tab, optimizingpentaho packages• Wrote complex SQL queries/ procedure by using recursive cte, inner queries,joins and optimized it• create / modified ssas tables, datasource, relationship between tables,refresh, dynamic partition creation and processing it• I also manage Report Scheduling, Data Sensitivity, Workspace.• I’m expert in writing Measure, Calculated Column, Query optimization

Roles & Responsibilities:• Responsible for end-to-end development for Invezta (sister company)• Creating or updating SSIS Packages, MS SQL Queries, procedure• Data ingestion through creating / modified SSIS packages for daily runs byusing checkpoints, if it failed triggered an email to developer team andrectified by using log and reverse engineering.• ETL ingestion divided into 2 parts: Source to stagging tables, stagging table toDW (Fact & Dim Tables• create / modified ssis catalog, Jobs Scheduling, optimizing ssis packages• Wrote complex SQL queries/ procedure and joins• Automated entire operation transactional feed and work closely for roboadvisory sql series.T