Venkatesh G

• Having 5.8 years of experience in SQL Server development, T-SQL, MSBI, SSIS, SSRS, SSAS, Data warehouse Designing, Data Analysis etc.
• Having good understanding of Banking, Finance and Trading domain
• Experience in Query Optimization and performance tuning of T-SQL queries, stored Procedure and functions
• Experience in Application support and Database development and Technical Code Review
• Highly analytical candidate with extensive and progressive experience in design, develop, support and management of application system.
• Extensive knowledge on Reporting using complex SQL queries, stored procedures, functions, packages, triggers, Indexing
• Join, Views, and transactions in T-SQL
• Have Strong US General Insurance, USA Define Benefit, Law and Finance Domain knowledge
• Implement enhancement/bug fixing/unit testing within pre-set deadlines with high quality
• Experience in Data analysis, Data Cleansing, development, Implementation, Reporting and documentation projects
• Providing post deployment support for upgrades/changes/enhancements done on UAT & Production Environments.
• Designed and developed the Power BI Reports & Dashboards using SQL Server, SSAS Tabular and Excel Sources.
• Created rich visualized Power BI reports (Used Pie charts, Line charts and Tree Maps, Bar & Column charts, Tabular, Matrix, Cards, Slicers, Gauge, KPI's and Custom Visualizations.
• Comfortable in working with Filters/Calculated Columns/Measures/Relationships and Transformations of Edit Query section.
• Published Power BI pbix files from Power bi desktop to Power bi service.
• Shared the reports by creating a Content Pack in app.powerbi.com.
• Worked on On-Premises Gateway to refresh the data sources.
• Created new calculated columns and calculated measures using DAX Expressions.
• Getting the data from On-Premises data source bases to perform visualizations using Power Bi Desktop.
• Created rich visualized power bi reports and dashboards using KPI.
• Created charts like Pies, Lines, Tree Map, Area, Scatter, Table Heat Maps, Combo, Tabular, Matrix, Funnel, Single Card
• Multi row card, Gauge and Slicer etc.
• Imported Custom Visuals from Microsoft Power Bi gallery as per client request.
• Implemented Row Level Security (RLS) as part of security.
• Published the reports into Power BI Service & shared the dashboards to the users.
• Worked on On-Premises Gateway to refresh the data sources in Power Bi Service.
• Created Content packs that package up a dashboard, report and dataset.
• Performed required calculations using DAX Expressions as per business needs (Table, String, Date and Logical functions).
• Experience in optimizing various database objects and T-SQL queries using appropriate joins and indexes.
• Monitor, Optimize and Tune Complex T SQL scripts and Stored Procedures based on the execution plans

1. Saxo Bank:

SSIS, SSAS, SSRS, Power Pivot, Azure DevOps, Power BI, ADF.

ETL, and Power BI Developer, 05/01/23, 02/29/24.

Saxo Bank A/S is a fully licensed and regulated European bank specializing in online trading and investment across global financial markets, Saxo Bank enables private investors and institutional clients to trade FX, CFDs, ETFs, stocks, futures, options, and other derivatives via multi-award-winning online trading platforms, in addition, Saxo Bank offers professional portfolio and fund management.

Roles & Responsibilities:

Creating all types of SSRS reports (drill down, drill through, parameterized, snapshot, cache), creating dashboards using SSAS cubes and Power BI standalone models for business users to access the model and analyze the data, created pivot tables using Power Pivot, geographical models using Power Maps, and visualizations using Power View and Power Chart, created automated flows, scheduled flows, created instant flows, and desktop flows for RPA, created canvas apps and model-driven apps, integrated with Microsoft Teams, and embedded a canvas app in Teams, implemented healthy ALM using solutions, and administered Power Apps, used Power Automate to integrate with Teams, SharePoint, used flows with Data verse, and triggered flows with Data verse events, created many dashboard reports, user parameters, slicers, and other visualizations, scheduled the dashboards to refresh in Power BI Desktop, used visualizations like column chart, stacked chart, pie chart, slicers, donut charts, row cards, multi-row card, and line chart, shared the reports with business users with the help of content packs, scheduled email-driven SSRS reports on a weekly and monthly basis, developed dashboard reports using Power View and Power Pivot, created pipelines using Azure DevOps, used Azure Synapse for ETL orchestration and analytics, involved in Azure DevOps authenticate access with personal access tokens, configured Azure Boards, and created your backlog, created Azure DevOps repos and cloned an existing Git repository.

2. Enterprise Data Lake Hub:

SSIS, SSAS, SSRS, Power Pivot, Azure DevOps, Power BI, ADF

Data Engineer, 01/01/21, 05/31/23. 

Roles & Responsibilities:

Version 1 recently migrated all data from SAP applications and designed Azure Data Lake, and now they want to design self-service BI in Microsoft Power Platform and SSRS analytical reports The main objective of this project is to create pipelines to load data from SAP applications to Data Lake and create executive dashboards using Power BI and develop analytical reports using SSRS, creating all types of SSRS reports (drill down, drill through, parameterized, snapshot, cache), creating dashboards using SSAS cubes and Power BI standalone models for business users to access the model and analyze the data, created pivot using Power Pivot, geographical models using Power Maps and visualizations using Power View and Power Chart, created ADF pipelines to move data from on-premises to Azure Data Lake, created automated flows, scheduled flows, created instant flows and desktop flows for RPA, created canvas apps and model-driven apps, integrated with Microsoft Teams and embedded a canvas app in Teams, implemented healthy ALM using solutions and administered Power Apps, used Power Automate to integrate with Teams, SharePoint, used flows with Data verse and triggered flows with Data verse events, created many dashboard reports, user parameters, slicers, and other visualizations, scheduled the dashboards to refresh in Power BI Desktop, used visualizations like column chart, stacked chart, pie chart, slicers, donut charts, row cards, multi-row card, line chart, shared the reports with business users with the help of content packs, and scheduled email-driven SSRS reports on a weekly and monthly basis, developed dashboard reports using Power View and Power Pivot.

3. Drug File Pricing Response:

SSIS, SSRS, SSAS, Power BI Desktop, ADF, SQL Server 2014

ETL, data modeling, Power BI developer, 07/01/18, 12/31/20

Roles & Responsibilities:

Objective is to maintain the historical data generated from the nationwide network chain and to calculate the revenue generated from the different chains of stores Through its nationwide networks, the company delivers a number of leading health benefit solutions through a broad portfolio of integrated health care plans and related services, along with a wide range of specialty products such as life and disability insurance benefits, pharmacy benefit management, analysis, design, development, and duty watch support for SQL production databases to meet client requirements, understanding requirements and developing changes to standard productized SSIS packages, OLAP cubes, and reports, understanding the behavior of the data from various applications and inserting or managing them accordingly in the data warehouse for further analysis and reporting purposes, understanding the data warehouse and extracting data for the reports to meet the requirement, designing the cubes according to the requirement and fetching data using MDX queries for different reports, developing reports or optimizing existing reports according to the requirement, creating SSIS packages to load the data from Excel sources to our data warehouse using transformations and mappings in data flow tasks, scheduling the ETL package monthly using SQL Server 2012 Management Studio, creating dashboards using SSAS cubes and Power BI standalone models for business users to access the model and analyze the data, creating pivot tables using Power Pivot, geographical models using Power Maps, and visualizations using Power View and Power Chart, creating many dashboard reports, user parameters, slicers, and other visualizations, scheduling the dashboards to refresh in Power BI Desktop, and scheduling email-driven SSRS reports on a weekly and monthly basis.