| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Sr Power BI DeveloperEMAIL AVAILABLEPHONE NUMBER AVAILABLESummary:Over 13+ years of IT experience in Data Analysis, Design, Implementation, and support of Business Intelligence using Power BI, Tableau, and SQL Server along with Azure cloud.Involved in all SDLC phases, including requirements gathering, Design and Analysis, Development, and Customization of the application with Waterfall and Agile SCRUM methodologies.Spearheaded the modernization and migration of data platforms from On-Premises to the Cloud.Designed and developed efficient data pipelines within the Azure Data Ecosystem, ensuring scalability and high performance.Executed Extract, Transform, and Load (ETL) processes from diverse source systems into Azure Data Lake, Azure SQL, Azure Databricks, and Azure Synapse and Azure Data Factory.Developed Azure Data Factory Pipelines, T-SQL, Spark SQL, and Pyspark Notebooks for seamless data numpy integration.Architected Dedicated SQL Pool tables in Azure Synapse, implementing SQL Data Warehousing.Created logical and physical data models adhering to best practices and compliance with BI data models (Snowflake, Star Schema).Designed and maintained multi-dimensional (OLAP) data modeling models for Transactional and EDW systems.Developed complex T-SQL Stored Procedures, Tables, Views, Materialized Query tables, and Indexes.Extensive experience in SSIS development, deployment, and maintenance, deploying various SSIS components.Experience in writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests.Designed, developed, and implemented ETL processes using IICS Data Integration.Implemented Power BI architecture, design, and development, promoting self-serve Power BI reporting.Proficient in Power BI Desktop and Power BI Service, DAX, and Power Query for advanced reporting.Designed and developed SSAS Multi-dimensional Cubes using Star and Snowflake Models.Administered SSRS Report Manager and Server, developing various types of reports and dashboards.Designed and implemented Power BI security using Active Directory groups and role-based security.Experience in Tableau Desktop, Tableau Server, Tableau Public, and Tableau Reader.Designed and developed Tableau graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.Expert in Tableau, and Power BI Dashboard Development and publishing them to respective server.Implemented row-level security in various visualization tools.Managed incidents with ServiceNow, conducting post-incident reviews and preventive measures. Led change management efforts, reviewing change requests, and ensuring proper execution.Presented SLA metrics and BI performance reports to stakeholders and leadership.Education:Bachelors in Commerce and Computers in 2007CertificationMicrosoft Certified Data Analyst (Power-BI)Skill Set:Microsoft AzureAzure Databricks, Azure SQL Database, Azure Data Factory, Azure Blob Storage, Azure Data Lake, Azure Synapse AnalyticsDatabases and DatawarehouseSQL Server, Oracle DB, T SQL, MySQL, PL/SQL, Snowflake, SSAS, RedshiftMonitoring and ReportingTableau, Power BI, Cognos, SSRSBuild and Deployment ToolsGit, GitHub, Visual Studio, TFS, SharePoint, Excel, ServiceNowWeb Dev. TechnologiesHTML, XML, CSV, JSONETL ToolsInformatica, SSISWork Experience:Fifth Third Bank, US April 2023 Till DateSr Power BI DeveloperResponsibilities:Responsible for providing full Power BI service administration user management, workspace management, gateway administration, data source creation, monitoring, and troubleshooting.Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements.Imported data from amazon redshift ODBC driver to Power BI to generate reportsCreated Stored procedures scripts using CTEs, tables, and as per the business requirement and views to maintain the metrics.Developed scorecards using SSRS for both the Tales as well failure to load reports that can aid in creating the metrics.Hands-on experience in utilizing DAX functions which include Aggregation, Counting, Logical, information, Text, and date functions in source dataCreate and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards.Created KPI's, Partitions, Perspectives, and Calculated Measures, using DAX queries, Roles.Create and customize simple data visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cardsCreated different data visualizations using Lines, Pies, Histograms, Maps, Scatter, and Bullets using Power BI.Used Execute package utility in ADF to modify the existing SSIS packages to create an ADF pipeline and migrate it to Azure SynapseResponsible for creating the metrics tree and populating the Fact and Dimension tables that the helps to transform/load data.Designed SSIS packages to validate, extract, transform and load data into staging and Data WarehouseHave extracted loaded and transformed data to copy the data from source to destination using Azure data factory.Have scheduled and created various dependencies of activities in ADF.Developed schemas for business applications with providing full-life cycle architectural guidance and ensured quality technical deliverables.Was responsible to for releasing the scorecards to QA and production with zero errors.Designed and developed Power BI (Tabular) Models from Azure Data Lake and Published them to Power BI Service to promote Self-Serve Power BI Reporting.Created Stored procedures scripts using CTEs, tables, and as per the business requirement and views to maintain the metrics.We follow agile scrum development methodology as well as Azure Dev ops for enhanced performance in the project.Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Sources, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.Upgrading the current reports to the cloud using Power BI desktop by transforming the existing reports in trust.Strong experience in designing and developing visualization reports using Power BI and Tableau using various relational databases, including Azure SQL DB.Environment: Azure, Azure ADF, Power BI Desktop, DAX, Tableau, SharePoint, SQL Server, T-SQL, SSIS, Visual Studio, etc.Cloud4C, Hyderabad, India May 2022 Feb 23Sr Power BI DeveloperResponsibilities:Participated in the scope, design, and delivery of advanced, scalable BI and Analytics solutions in partnership with business stakeholders and senior data warehouse team members.Translated business requirements and end-user needs into architectural models to deliver high-quality BI solutions.Designed & Implemented BI solutions on Azure using Azure Data Platform services.Analyze, design, and build Modern data solutions using Azure PaaS service to support visualization of data.Used Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL, and Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.Enhance (or create - if new system) system logical data model to meet requirements, applying the Data Modeling Standards and the Logical Data Naming Conventions.Select the appropriate data types and sizes for the new fields added to the system data model.Designed and created Fact and Dimension tables based on business needs using best practices such as Kimball Methodology for Data warehouse/ Data Mart development.Collaborated on the Data Mapping document from source to target and the data quality assessments for the source data.Designed and Developed ETL (SSIS) Framework to perform full loads or incremental loads to Enterprise Data Warehouse (EDW).Developed complex T-SQL Stored Procedures, Tables, Views, Indexes, and Cursors, and performed Query tuning/optimization.Created SSAS Tabular Models off the data warehouse and built Pivot Table templates for the end users.Involved in creating complex measures including ranking, KPIs, and aggregation by DAX in Power BI Tabular Models according to business requirements.Involved in designing and implementing partitions in the Tabular Models.Designed dynamic row-level security for the entire global procurement team with different levels of users utilizing complex DAX functions within the SSAS tabular model.Performed Power BI Architecture, Configuration, Design, Development, Administration, Deployment, and Maintenance.Worked on implementing Modern Analytics toolkit using Amazon Redshift and Tableau Software which form a Data warehousing and analytics solution that allows users to analyze datasets.Extensively used M-Language in Power Query, created parameters to address dynamic environments and used DAX in Power Pivot to create Quick Measures, Custom Measures, and columns.Developed Power View using various Power BI Visuals such as Bar Chart, Area Chart, Table, Card, and Custom (Microsoft Store) Visuals such as Hierarchical Visuals, Sankey Chart, etc.Designed and Implemented Power BI security using Active Directory groups and role-based security.Utilized the ServiceNow platform to streamline service management processes, ensuring efficient handling of incidents, changes, and problem tickets.Configured SLAs within ServiceNow to monitor and enforce service-level agreements, ensuring timely resolution of issues and compliance with organizational standards.Environment: Power BI Desktop, Power BI Service, Azure Data Lake, Azure Data Factory, Azure Databricks, Azure Synapse, Azure SQL, SSIS, SSRS, Amazon Redshift.Wipro, Hyderabad, India May 2020 May 2022Power BI DeveloperResponsibilities:Led the development of efficient data quality processes and pipelines, improving data accuracy. Automated several hours of manual reporting tasks weekly.Leveraged Azure cloud services to securely store and process the data, ensuring data accuracy and accessibility.Extensive experience in reporting and analytics using Power BI, including skills in M Query, DAX, data modeling, and implementing Row Level Security.Proven ability to implement solutions involving multiple data sources, showcasing versatility and adaptability.Good in analytical thinking skills to convert raw data into meaningful and relevant reports and graphics.Integrated data from multiple HR systems using SQL, ensuring up-to-date information for HR dashboards.Skilled in connecting and transforming data from diverse sources, including databases and APIs, into Power BI for comprehensive analysis.Employed for data pre-processing and ETL tasks in HR analytics. Ensured data quality and accuracy through data cleaning, mapping, and advanced transformations.Created Semantic Layer (on top of Azure data lake /SSAS Cubes/SQL database) to support Power BI ad-hoc and planned reporting needs of users.Implemented Python scripts for agile data processing and refreshing.Developed interactive dashboards for employee engagement and sentiment analysis. Used Power BI libraries for feedback analysis.Designing data models that align with business requirements to optimize data for effective reporting within Power BI.Implementation of robust security measures and adherence to data governance best practices within Power BI solutions.Designed and implemented data workflows in Power BI Services, orchestrating ETL processes in the cloud environment.Utilized ADF pipelines for data movement and transformation between on-premises and cloud-based data sources.Designed custom Power BI visualizations for employee retention, turnover prediction, and talent acquisition.Collaborated on a predictive analytics model, improving forecasting accuracy by 20% and enabling better resource allocation and cost savings.Environment: Power BI Desktop, Power BI Server, Power Pivot, Power View, Power Map, DAX, ETL, SSIS, SSRS, Power Query, SQL, Oracle, MS Excel, Windows 10 ProfessionalCognizant, Hyderabad, India Oct 2017 to Apr 2020Sr BI DeveloperResponsibilities:Crafted interactive dashboards using data from the Customer Communication Management tool. Implemented age and category filters, applying display rules for individual paragraphs for a tailored user experience.Designed and implemented Packages for seamless data import/export between MS Excel, Flat files, and SQL Server, ensuring data integrity and efficiency.Applied a strong understanding of data modeling in data warehouse environments, employing star schema and snowflake schema principles.Proficiently performed data analysis, executed database queries, and utilized SQL query tools to extract valuable insights.Developed parameterized reports to allow users to filter data dynamically.Developed stored procedures, functions, indexes, and views to support data processing and cleansing activities.Created DAX and tabular models using SQL Analysis Services (SSAS) in Power BI, incorporating diverse visualizations (Stacked bar chart, Clustered bar chart, etc.) based on project requirements.Utilized Power BI for collaborative work with users and stakeholders on live data sources, enhancing real-time decision-making.Developed comprehensive user guides and documentation for PowerApps and Power Automate solutions, facilitating user adoption and self-service troubleshooting.Automated Power BI Refresh using Power BI Gateway application.Transformed data from many online data sources when importing into the Common Data Service through Power Query.Assisted team members in understanding and leveraging Power BI features, through hands-on guidance and support, enhancing team productivity and report accuracy.Facilitated communication between IT and business stakeholders to translate business requirements into actionable BI strategies, ensuring alignment with organizational goals.Coordinated with IT and data analytics teams to streamline data workflows, improving efficiency and data quality for Power BI reporting.Conducted workshops and trainings for Business Users & Power Users on Power BI.Good experience authenticating Power BI using Azure service account.Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.Took ownership of operational and business performance dashboards, interpreting results, identifying improvement opportunities, and making recommendations.Generated Power BI reports and automated the publishing process to workspaces, apps, ensuring the availability of the latest data.Ensured that the data sources used by the existing reports are compatible with the target BI platform.Migrated the data sources to the new platform, ensuring data integrity, security, and accessibility.Updated the report connections and data queries to point to the migrated data sources.Planned the rollout of the migrated reports in phases or batches to minimize disruptions and ensure a smooth transition.Implemented various DAX functions for efficient data visualization in Power BI, optimizing fact calculations.Conducted training sessions for business users on Power BI reports and dashboards, facilitating widespread understanding and usage.Performed user acceptance testing, ensuring system integrity before production release.Environment: SQL Server 2012, Visual Studio, SSIS, MS Office 365, Power BI Desktop, DAX, Jira, Confluence, SharePoint, MS Excel, MS Word, Agile (Scrum)Thomson Reuters, India Oct07 July14BI DeveloperResponsibilities:Worked closely with businesses and was involved in gathering user requirements.Responsible for writing and modifying stored procedures, functions, and packages for data conversions to create database objects dynamically.Created indexes, tables, and sequences as per the business requirement and views to maintain data privacy.Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressionsUsed different types of visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.Used SQL profiler to identify slow-running queries.Analyzed the requirements and framed the business logic for the ETL process.Extensively used SSIS Import/Export Wizard, for performing the ETL operations.Performed data migration from Excel, Sybase and Oracle to MS SQL Server using SSIS.Created packages to transfer data between OLTP and OLAP databases.Designed Cubes with star schema using SSAS. Created hierarchies and partitions for improving SSAS cube performance.Created various complex reports and manage them using SQL Server Reporting Services (SSRS)Designed rich dashboards with Power BI and referred user stories to create compelling dashboards to deliver actionable insights.Environment: Power BI, T-SQL, SQL Profiler, SSIS, SSRS. |
