Experience

Star Insurance Company

• United States
• Insurance
• 1 - 100 Employee

• Business Intelligence Engineer

  • Sep 2020 - Present

  • Developed Tables, Views, and Stored Procedures using SQL Server Management Studio. • Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling. • Extensive use of Stored procedures, writing new stored procedures and modifying existing ones and tune them such that they perform well. • Expertise in understanding legacy report logic and transforming it into Power BI for reporting and analysis. • Gathered data for validation and populate them into tables using stored procedures. • Create Stored Procedures, Triggers, Views, joins and Functions for the Application. • Created data refresh strategies for Azure SQL Server and other sources, reducing data latency by 60% and improving data accuracy. • Expertise in writing complex DAX functions in Power BI and Power Pivot. • Experience in Querying a Tabular Model in Excel, Power View and used various DAX Functions. Loading • Data inside Tabular, Monitoring Security, Automating Deployment to Production Server. • Created calculated columns and measures using DAX queries in Power BI based on report requirements. • Expertise in creating advanced calculated columns and measures with DAX using Power BI. • Used Power BI Custom visuals like KPI, designer, spline chart to make the visuals look and understand better. • Performed data cleaning and data shaping in Query Editor and Analyzed data in data model using Power BI. • Experienced in designing and implementing workflows using Power Flows to streamline report automation. • Proficient in leveraging iframes to enhance the functionality and interactivity of reports and dashboards by embedding external content from different web applications or pages. • Used Power BI Custom visuals like KPI, designer, spline chart to make the visuals look and understand better. • Created DAX and VB scripts for Excel reporting and calculated members. • Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat Show less



Visa

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Sr. SQL Developer/Power BI Developer

  • Feb 2019 - Aug 2020

  • Extensive experience in data Extraction, Transformation and Loading (ETL) using SQL Server 2015 Integration Services, for moving data from source to target system. • Utilized Execute SQL Task and Control Tasks to import Source/Target tables from respective databases in SQL Server 2015 Integration Services. • Designed and documented the entire Architecture of Power BI POC • Develop technical and training manuals for Power BI setup and services. • Expertise in writing complex DAX functions in Power BI and Power Pivot. • Implemented data export automation process, reducing human errors and saving 2 hrs/week of manual effort. • Created SSRS reports and SSIS packages for exporting and importing data from SQL Server to Access, Text, and Excel files. Configured SQL mail agent for sending automated mails. • Skilled in leveraging Power Flows to automate data extraction, transformation, and loading for report generation. • Skilled in analyzing and converting complex legacy report logic into interactive Power BI reports. • Implemented automated data refresh mechanisms for Azure SQL Server and other data sources, resulting in a 50% reduction in manual effort and improved data availability. • Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database in the most efficient manner and created stored Procedures for the business logic using T-SQL. • Developed database triggers and stored procedures using T-SQL cursors and tables. • Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for cleaning and massing. • Utilized Power BI Gateway to keep the dashboards and reports up to date. • Configuring Power BI Gateway for SSAS live connection. • Developed paginated reports for different sources of genome taxonomy that provide accessible information for accurate decision making. • Create, debug, and execute T-SQL scripts and stored procedures Show less



UnitedHealth Group

• Hospitals and Health Care
• 700 & Above Employee

• SQL Developer/ MSBI Developer

  • Jun 2017 - Jan 2019

  • Proficient in data Extraction, Transformation and Loading (ETL) using SQL Server 2012 Integration Services. • Involved in complete Software Development Life Cycle (SDLC) process, analyzing business requirements and functional workflows. • Proficient in working with diverse data sources and transforming legacy reports into modern and visually appealing Power BI reports. • Proficient in designing and developing interactive Power BI pagination reports and dashboards. • Created complex Stored Procedures, Views, and Functions for loading data from Staging to Data Warehouse. • Imported Source/Target tables from respective databases using Execute SQL Task and Control Tasks in SQL Server 2012 Integration Services. • Proficient in utilizing Power Flows to automate report generation and distribution tasks. • Extensively utilized Derived Column, Data Conversion, Conditional Split, and Aggregate. • Scheduled daily ETL packages using SQL Server 2012 Management Studio. • Developed SQL Server Integration Service (SSIS) packages for transferring data between enterprise databases and third-party data sources. • Skilled in embedding external content such as reports, dashboards, and visualizations within reports using iframes for a unified view. • Extensive Testing on the Performance of the Stored Procedures. • Partitioned measure groups to enhance cube performance. • Designed reports in SSRS using data from the Data Warehouse database. • Developed SSIS packages for Data Importing, Cleansing and Parsing. • Followed Report Specification document and designed reports that meet client requirements. Show less



HSBC

• United Kingdom
• Financial Services
• 700 & Above Employee

• SQL Developer/T-SQL Developer

  • Jun 2013 - Apr 2016

  • Created SSIS packages to migrate data from different data sources to data warehouse. • Extensively 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. • Developed stored procedures and triggers to facilitate consistent data entry into the database. • Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources. • Experienced in using iframes to create a seamless user experience by integrating multiple data sources and tools within reports and dashboards. • Experienced in implementing pagination techniques to enhance performance and user experience in Power BI reports and dashboards. • Involved in enhancing and deploying the SSIS Packages from development server to production server. • Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012. • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012. • Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard • Involved in writing T-SQL programming for implanting stored procedures and functions for tasks. • Best coding programmer in writing complex T-SQL queries for Joins, views, Stored Procedures & parameters, Triggers, User functions, Tables. • Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts. Show less