| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Data Analysis,Business Analysis,ProjectManagement,Python,SQL,Pow Lawrenceville, NJ Power Bi Sql Server Princeton, NJ Microsoft Excel, Microsoft Word, Microsoft PowerPoint, SQL, Pyth Springfield, NJ Data Analyst Power Bi Newark, NJ Business Intelligence Sql Server Manhattan, NY Power Bi Data Analysis Levittown, PA Power Bi Data Analysis Jersey City, NJ |
|
Click here or scroll down to respond to this candidateCandidate's Name
Power BI DeveloperEMAIL AVAILABLE PHONE NUMBER AVAILABLEPROFESSIONAL SUMMARY8 years of experience working in Microsoft BI tools and designing and developing Power BI reports and dashboards from multiple data sources using data blending.Expertise in Microsoft Business Intelligence Tools (SSIS/SSRS/SSAS) and T-SQL with SQL Server 2005/2008R2/2012/2014/2016/2019/2022.Ability to design, develop and maintain Power BI reports and dashboards providing actionable insights to users.Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server.Communication experience with stakeholders, subject matter experts (SMEs), and end users in order to understand, analyze, communicate, and validate requirements.Having extensive experience in calculating measures and dimension members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.Extensive experience in developing, designing and supporting interactive Tableau dashboards is an advantage.Hands on experience in developing Power BI Reports and Dashboards using data blending from multiple sources.Strong understanding of T-SQL (DDL, DML and DCL), the creation of new databases objects such as tables, views, indexes, stored procedures, functions (UDF), cursors, triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery, and the SQL Server Agent profiler for SQL Server 2000/2005/2008 R2/2012/2014/2016/2019/2022.In-depth knowledge of RDBMS, including E/R Diagrams, Normalization, Constraints, Joins, Keys, and Import/Export of Data.Thorough understanding of Stored Procedures and Triggers along with experience debugging them.Expertise in Extraction, Transformation, and Loading (ETL) utilizing SSIS to extract data from various sources.Good understanding of how to tune the performance of SSIS packages by using Row Transformations, Block Transformations, and Unblock Transformations.Strong understanding of and experience working with different types of dirty data that originate from different sources.Extensive experience working with logging and error handling in SSIS packages using Event Handlers.Excellent ability to work with Data Cleansing techniques in ETL procedures as part of the ETL process.Strong experience building and deploying multi-valued parameterized reports using Power BI and Tableau.Proficient understanding of SQL Server Analysis Services (SSAS) and OLAP Cubes, as well as Dimensions, Measures, Hierarchies, Attributes, Calculations using MDX, Perspectives and Roles.Excellent hands-on knowledge of creating groups, metrics, and KPIs, and having hands-on experience with them.Extensive experience building Tabular Model Cubes from scratch in databases with different measures and dimensions.Extensive experience with performance tuning, data processing, and cube deployment.Good Ability to communicate clearly and effectively through writing and verbal communication. TECHNICAL SKILLSPower BI Tools Power BI Desktop, Power BI Gateway, Power Query, DAX, Power BI App, SSIS, SSRS, SSASRDBMS/DBMS MS SQL Server 2022/2019//2016/2014/2012/2008R2/2008/2005/2000, MySQL, Oracle 11g/10g/9i/8i, and MS Access 2003/2000/97Database Technologies/Tools SQL Server Enterprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio Databases Azure SQL Database, Azure data warehouse, Azure Data azure data factory, Azure Data Synch, MS SQL Server 2008 R2, 2012, 2014,2016,2019,2022, MySQL and Oracle 12c. Azure Cloud Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure SQL Data Warehouse, Azure Service Bus, Azure Analysis Service (AAS), Azure Blob Storage. Cache using Pipeline and SSIS, Data Migration Service (DMS), Azure SQL Data. Reporting Tools Power BI, SQL Server Reporting Services, Crystal Reports, Excel. Operating Systems Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 11/8/7 Programming Languages T-SQL, PL/SQL, HTML, C#.Net, VB.Net, C++, Java, Java script, CSS, Python, Windows ScriptsDesign Technologies/Tools Erwin, MS Visio, Rational Rose Data Warehouse / BusinessIntelligence ToolsSQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2022/2019/2016/2014/2013/2010/2008, SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell PROFESSIONAL EXPERIENCECustom Ink Fairfax, VA Jul 2023 Till DatePower BI DeveloperGathered requirements from the customer for developing reports in Power BI.Designed and customized simple visualization tools, including combinations, slicers, maps visualizations, matrices, scatter charts, waterfall and funnel charts, gauges, and single number cardsAccessed Power BI Dashboards from the Web and published Power BI Reports in the required originations.Utilized Power BI extensively for data analysis and visualization.Created the Dashboard Reports using Power BI and DAX.Utilized Power BI visualizations to create effective reports, including bar charts, clustered column charts, waterfall charts, gauges, pie charts, and tree maps.Utilized Power BI, Power Pivot and SSRS to develop the reports.Improved drill through and hyperlink functionality has been implemented within Power BI reports.Managed numerous Power BI dashboards, reports, and content packs.Worked with Power BI dashboards using tabular and multidimensional models.Designed and modeled data sets with Power BI desktop based on customer requests and dashboard requirements.Extracted data from external sources, modified it to certain formats in Excel, and created SSIS packages for importing excel sheets from PC to database using Microsoft Power BI Power Query.Utilized Python scripts and identified, designed, and implemented processes related to predictive / analytical modeling, data mining, and complex data sets.Created visually appealing dashboards using Tableau based on Power BI.Activated the On premise data gateway and scheduled Power BI daily data refreshes.Utilized DAX queries to create Calculated Columns and Measures in Power BI and Excel based on the client's requirements.Utilized T-SQL to write and modify various stored procedures within the application.Created calculations and measures in the Tabular Mode and Multidimensional Cubes using DAX (Data Analysis Expressions) and MDX functions.Developed a Tabular Model cube from scratch data and fetched data into SSRS and Power BI with MDX and DAX queries.Developed PowerPivot models and reports and published them to SharePoint and SQL Server SSAS instances. Created Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of the database.Developed custom Azure Data Factory pipelines, such as the Copy activity and the Custom Azure Data Factory Pipeline Activities: Primary responsibility for data migration using SQL, SQL Azure, Azure Storage, SSIS, PowerShell, and Kimball Methodology.Created ETL Frames for extracting, transforming, auditing and loading data in Azure SQL Data Warehouses.Deployed a database backup to the production server and performed database backups.Developed extensive experiences in designing and implementing ETL processed data from external sources such as Azure Blob Storage, Azure Data Lake Gen2 and ORC/Parquet/Text Files into an Azure SQL Data Warehouse (Azure Synapse).Created ETL packages using SSIS to validate, extract, transform, and load data into data warehouses and data marts.Implemented .NET and C# custom code in Script task to create SSIS packages.Tested the reports and packages developed against unit tests.Utilized SSRS to deploy and schedule Report subscriptions to generate all daily, weekly, monthly, and quarterly reports. Environment: Power BI, Power BI (Pro), Power BI Service, MS SQL Server 2022, Management Studio (SSMS), ETL, Integration Services (SSIS), AzureLamm Insurance Raleigh, NC Sep 2021 Jun 2023Power BI DeveloperInvolved in gathering user requirements and design meetings during the user requirements gathering phase.Engaged in close collaboration with Business Analysts, Data Modelers, and other team members within the organization to understand business processes.Utilized a variety of data services, such as CDS, FLOW, EXCEL FORMS, in order to develop the application in power app.Handled large volumes of data while generating context filters and data source filters at the same time.Worked with DAX functions including Aggregation, Counting, Logical, Information, Text and Date functions.Utilized DAX table functions such as FILTER, ALL, VALUES, DISTINCT, and RELATEDTABLE.Utilized Z-order to overlap the reports on each other using Power BI.Developed a data analysis prototype using Power BI, Power Pivot, and Power View, and visualized reports using Power Map.Designed and customized simple visualization tools, including combinations, slicers, maps visualizations, matrices, scatter charts, waterfall and funnel charts, gauges, and single number cards.Accessed Power BI Dashboards from the Web and published Power BI Reports in the required originations.Developed Dashboards & Scorecards (KPI) for the Finance Department using Power BI.Created a dashboard report using Excel Power Query and Power Pivot to include Monthly Resource Allocations.Supported supply chain analysts in automating reporting through Power BI tools like Power BI reporting, Dashboards & Scoreboards (KPIs) and MySQL, AWS & Data Warehouse.Assembled several data models and used them as a basis for generating reports.Updated dashboards and reports using Power BI Gateways.Developed Power BI reports based on year-to-date years (YTD), month-to-date months (MTD), and same period last year.Worked with ETL team on transformation logic in the ELT (Azure) and migration of SSIS packages to Azure Data Factory (V2).Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ELT processing in close collaboration with ETL.Worked closely with the ETL team on calling the procedures in the pipeline of Azure Data Factory.Worked on ETL processes, developed source-to-destination data mappings, integrated workflows, and developed load processes as part of the ETL process.Assessed data quality using SQL queries on source system data.Implemented ETL processes and developed source-to-target data mappings, integration workflows, and loading processes. Build enterprise-class data warehousing solutions and implement them.Extracted, cleaned, transformed, and loaded data into data warehouses using extract, transform, load (ETL) (SSIS).Added row-level security so that end users can view data depending on their role.Utilized trend lines and reference lines to analyze reporting requirements and develop various dashboards.Calculated columns, calculated views, and calculated measures.Used the power platform for intranet and extranet users. Environment: Microsoft Power BI, Python, SSIS, SQL Server 2019, ORACLE 11g, SQL Developer, SQL Azure, Azure storage, and Azure Data Factory, PowerShell, Domain knowledge in Retail, Finance and Banking Mainstreet Bank Fairfax, VA Jun 2020 Aug 2021Power BI DeveloperDeveloped, implemented and reported Business Intelligence solutions using SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) in MS SQL Server 2016.Worked on Database Administration things like Backup, Recovery, Replication, and SQL Profiler and know DDL and DML in T-SQL.Created Cascading, Drill Down/Drill through reports, Conditional, Table and Matrix reports, Charts, and Ad-hoc reports, utilizing Relational Data Warehouses and OLAP Cubes.Developed drill down reports with drop-down menus, sorted records, defined subtotals in SSRS.Used Power BI extensively for data visualization and analysis.Implemented DAX reports in Power BI for Dashboard Reports.Developed effective reports using Power BI visualizations such as Bar charts, Clustered Column Charts, Waterfall Charts, Gauges, Pie Charts, Tree Maps, etc.Incorporated Power BI, Power Pivot, and SSRS into the reports.Implemented Drill through & Hyperlinks in Power BI report.Managed numerous Power BI dashboards, reports, and content packs.Responsible drill-throughs & hyperlinks in PowerBI reports and Multidimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.Extracted data from external sources, modified it to certain formats in Excel, and created SSIS packages for importing excel sheets from PC to database using Microsoft Power BI Power Query.Developed, designed and implemented methods and processes related to predictive / analytical modeling, data mining and complex data sets using Python scripts.Assisted in the development of Power BI dashboards and prepared them using Tableau for more attractive presentation.Integrated Power BI with the On premise data gateway and scheduled daily data refreshes.Developed calculated columns and measures in PowerBI and Excel based on the requirements through the use of DAX queries for PowerBI and Excel.Created and modified numerous T-SQL stored procedures that are used in the application in order to perform various functions.Worked with DAX (Data Analysis Expressions) and MDX functions for creating calculations and measures in the Tabular Mode & multi-dimensional Cubes by using DAX (Data Analysis Expressions) & MDX functions.Created a Tabular Model cube from scratch, and utilized MDX and DAX queries to fetch data to SSRS and Power BI.Developed MDX queries to retrieve data from a tabular model.Implemented PowerPivot models and reports, published reports to SharePoint, and deployed models to SQL Server SSAS. Developed parameterized PowerPivot Workbooks and SSRS reports using data from the tabular and cube models to demonstrate the database's functionality.Developed and implemented the Copy activity and Custom Azure Data Factory Pipeline activitiesWorked with databases using SQL, SQL Azure, Azure storage, SSIS, PowerShell, and Azure Data Factory.Designed and built an ETL Frame enabling the extraction, transformation, auditing and loading of data into an Azure SQL data warehouse.Deployed a database backup to the production server and performed database backups.Created ETL packages using SSIS to validate, extract, transform, and load data into data warehouses and data marts.Implemented .NET and C# custom code in Script task to create SSIS packages.Tested the reports and packages developed against unit tests.Utilized SSRS to deploy and schedule Report subscriptions to generate all daily, weekly, monthly, and quarterly reports. Environment: MS SQL Server 2016/2014, Python, Management Studio (SSMS), ETL, Azure, Integration Services (SSIS) 2012, Power BI, Power BI (Pro), Power BI Service.Sagarsoft India Limited Hyderabad, India May 2017 Feb 2019 SQL / Power BI developerDesigned and developed the POCS according to business users.Managed the development, test, pre-production, and production environments and developed best practices.Involved in the creation of the Daily jobs for data dumps to be processed by various teams.Managed the migration of Data analytics from Tableau to Power BI from the perspective of Data analytics.Developed and designed a migration plan from Data Analytics to Power BI based on the requirements.Created dashboards, scorecards, and KPIs in PowerBI.Developed on-premises data gateways to implement scheduled data refreshes based on business requirements.Imported data, executed Direct Query, and implemented Live Connection.Maintained the content of the app as well as created and maintained it.Managed the PowerBI Content packages and created and maintained them.Created the Web links or Embedded Code to be published to web pages, websites, or portals in order to publish them.Implemented the Row-Level Security (RLS) system and designed it.Improved data loading speed by implementing best practices.Implemented the Data Marts as per the business requirements.Adapted the existing Excel reports to Power BI and migrated them to Power BI.Designed and developed the test scenarios for data analytics.Designed and developed the MySQL scripts that are used for data dumps.Engaged in deploying SSIS packages, SSRS reports and SSAS cubes through the use of command line tools, including the use of SSRS properties.Engaged in Star Schema Modeling, Snow-Flake Modeling, FACT & Dimension Tables, Physical and Logical Data Modeling. Environment: MS SQL Server 2016/2014/2008, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2014/2013/2012, C#, Python, SQL Server Profiler, Azure Cloud, Azure SQL Database, Azure Data Lake, Azure Blob, Power BI Desktop, Power BI Service, Power Query, Power Pivot, Power Designer, Tabular Models, SQL Server Management Studio, Team Foundation Server (TFS), Business Intelligence Development Studio (BIDS), Business Objects, JasperSoft Studio. Optimized Solutions Hyderabad, India Jan 2015 Apr 2017 SQL DeveloperIntegrated and analyzed data from multiple heterogeneous and homogeneous sources (CSV, Excel, DB2, SQL 2000, and SQL 2005).Configured the package to be portable and created event handlers to handle package errors.Utilized For-Each Loop Container, Sequence Container, Expressions, SQL Task, Variables, Send Mail Task, Package Execution Task to achieve business goals.Designed SSIS packages to extract, transform, and load data using different transformations, including Lookups, Derived Columns, Condition Splits, Aggregates, Pivots, Slowly Changing Dimensions, and Merge Joins and Unions.Used T-SQL to create and modify various Stored Procedures in the application.Executed Analysis Services Processing Task in SSIS for processing cubes in packages with the star schema and snowflake schema in SSAS.Managed packages using SSMS using the SQL Server Agent daily, weekly, and monthly.Implemented SSAS cubes for aggregate reportingImplemented MDX calculations and supported DAX expressions that were used in pivot table reports.Utilized SSRS to create Project Expense Statements for all Data Marts and other Financial Reports.Prepared expense reports for the company on a yearly and quarterly basis.Deployed the report using SSRS and used subscriptions (Data Driven and Email) to publish the report.Optimized SQL queries for better performance using SQL Profiler.Provided active support for change requests made by business users. Environment: SQL Server 2000/2005, Enterprise Edition, SQL, Python, Enterprise manager, SSRS 2005, SSIS 2005, Spotlight, MS SharePoint, MS Access 2000 & Windows 2003/2000 platform, VB.NET, ASP.NET. |
