● Responsible for extracting the data from OLTP and OLAP using SSIS, Worked with various tasks and transformations in Control flow and Data flow items.● Data Modeling and Analysis: Designed data models and relationships in Power BI to ensure efficient data retrieval and analysis. ● Successfully led the deployment of Power BI Premium in a large-scale organization, resulting in enhanced data accessibility and improved reporting capabilities for over 500 users.● Implemented Power BI Premium, resulting in a 50% reduction in report load times, allowing users to access critical data faster and make more informed decisions.● Effectively managed user access and permissions for Power BI, ensuring data security and compliance with company policies and industry regulations.● Created visually appealing and insightful Power BI reports and dashboards using Alteryx for data integration and transformation.● Leveraged Alteryx to efficiently extract, clean, and transform data from various sources, ensuring data accuracy and consistency.● Designed and implemented complex data models in Power BI, including relationships, calculated columns, and DAX measures to support business requirements.● Optimized Power BI reports for improved performance, reduced load times, and enhanced user experience by using Alteryx for data preprocessing.● Developed interactive and user-friendly data visualizations, making complex data sets accessible and actionable for end-users.● Utilized version control tools and best practices to maintain and track changes in Power BI reports and Alteryx workflows.● Ensured data governance standards and data quality by implementing data lineage and data lineage tracking within Alteryx and Power BI.● Created DAX formulas to calculate and summarize data for visualizations.● Report and Dashboard Development: Created interactive and visually appealing reports and dashboards in Power BI that provide actionable insights to stakeholders.

● Developing the best practices and drive the code to across development, test and Pre-Prod and Production environments. ● Creating the Daily jobs for data dumps for various teams. ● Responsible for Data Analytics migration from Tableau to PowerBI.● Designed and developed the migration of Data Analytics to Power BI.● Optimized a complex financial dashboard, reducing report loading time from 15 seconds to less than 3 seconds, resulting in improved user satisfaction.● Conducted user training sessions and provided ongoing support to empower employees at all levels to leverage Power BI effectively.● Conducted weekly Power BI workshops, resulting in a 25% increase in user-generated reports and improved data-driven decision-making across departments.● Developed and enforced governance policies and procedures to ensure data consistency, security, and compliance.● Established a data retention policy that reduced storage costs by 20% while maintaining compliance with data retention regulations.● Collaborated with IT teams to integrate Power BI with various data sources, ensuring data accuracy and consistency in reports.● Integrated Power BI with Salesforce CRM, providing sales teams with real-time data on customer interactions, resulting in a 10% increase in customer satisfaction scores.● Conducted routine system health checks, troubleshooting issues promptly, and applying updates to ensure system reliability.● Implemented proactive monitoring, detecting and resolving data source connection issues before they impacted report availability, minimizing downtime.● Produced executive-level reports and dashboards, presenting key performance indicators and trends to senior management for strategic decision-making● Created an executive dashboard that provided real-time insights into market trends, leading to a 15% increase in strategic investments● Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards

● Responsible for gathering/refining requirements from the customer for developing reports in Power BI.● Built Data Analytics or visualization using Power BI (Power View integrated with Share Point).● Worked with DAX/MDX queries in building expressions for various business calculations.● Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.● Involved in Developing Power BI visualizations and dashboards using Power BI Desktop.● Created Grouping, sorting columns and writing expressions according to the business requirements.● Transferred the data using SSIS packages.● Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.● Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.● Created SSIS packages to Export data from text file to SQL Server Database.● Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.● Generated Reports using Global Variables, Expressions and Functions for the reports.● Identified and worked with Parameters for parameterized reports in SSRS.● Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.● Generating Ad-Hoc reports on a timely basis and also to fulfill immediate requirements.

● Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.● Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.● Utilized Power BI Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.● Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.● Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.● Designed dash boards for actionable, non-actionable complaints from Multidimensional database.● Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.● Created report snapshots to improve the performance of SSRS.● Used different type of Filters available in SSRS for creating reports.● Developed reports like Parameterized, Drill Down, Drill Through, Tabular, Cascading reports by using SSRS.● Modified reports as per new requirements.● Deployed SSRS reports into Report server and managed data-driven subscriptions, snapshot and rendering.● Troubleshoot T-SQL, SSIS and SSRS errors and performance issues and address them as required.● Wrote complex SQL queries involving multiple tables from different databases using Joins, Stored Procedures, Temporary tables, functions.● Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance. ● Created and designed several SSIS packages by using Control Flow and Data Flow level elements.● Highly worked on Control Flow and data flow elements like For Loop Container, for- each Loop Container, Sequence Container, Data Flow task, Execute SQL task, Script task, File System task, Send Mail task etc.