| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Power BI/BI Developer EMAIL AVAILABLE PHONE NUMBER AVAILABLEPROFESSIONAL SUMMARY7+ years of experience as a BI Developer, focusing on Microsoft SQL Server versions 2019/2016/2014/2012/R2.Strong understanding of SQL and RDBMS principles with a strong emphasis on Microsoft SQL Server.Experience modeling data using star and snowflake schemas, FACT tables, and dimension tables.In-depth understanding of both Waterfall and Agile project methodologies, enabling effective collaboration and project management.Proven ability to install and configure different SQL Server versions, including 2019, 2016, 2014, 2012, and 2008, ensuring seamless deployment.Extensive experience developing Power BI reports and interactive dashboards that deliver actionable insights to stakeholders using data visualization techniques.Comprehensive understanding of Microsoft SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS), facilitating efficient data integration, reporting, and analysis workflows.Expertise in optimizing database performance through advanced techniques, such as client/server connectivity, query optimization, DBCC commands, and performance tuning, ensuring maximum performance and responsiveness.Strong understanding of T-SQL for the development of complex stored procedures, triggers, tables, views, and user-defined functions.Expertise in analyzing query plans, managing indexes, handling deadlocks, and troubleshooting.Proven track record of developing, deploying, scheduling, troubleshooting, and monitoring packages for SQL Server Integration Services.Exceptional skills in complex stored procedures, views, data imports and exports, as well as system views.Thorough knowledge of import/export wizards, SSIS, BCP, bulk insert utilities, and the extraction and migration of data from Excel, Access, and Oracle.Proven experience analyzing SQL Server Query Execution Plans and optimizing complex Stored Procedures, Curses, and Triggers with the Profiler.Hands on experience with ETL workflows and data models to enhance Power BI report performance and reduce refresh times.Experience developing event handlers for logging and handling errors in SSIS Packages.Deep understanding of row transformations, partial blocks, and block transformations, which are necessary for optimizing data processing and transformation tasks within SQL Server environments.Specialist in designing and developing enterprise reports with SSRS (SQL Server Reporting Services) and Business Objects, as well as using ETL processes, SSAS (SQL Server Analysis Services) cubes, and a wide array of heterogeneous data sources, delivering comprehensive and insightful reporting solutions to organizations.Expertise in creating ad hoc reports and subscription reports using the Report Builder, allowing users to generate reports on-demand and automate report delivery processes.Expert in SSRS, Crystal Reports, and MS Excel, including drilling-down reports, parameterized reports, charts, dropdowns, and incorporating images to enhance data visualization and analysis.Excellent communication skills, excellent team player, and equally skilled when working independently to find the most effective solution for a given project.Good ability to approach and solve problems in an independent and effective manner.TECHNICAL SKILLSPower BI ToolsPower BI Desktop, Power BI Gateway, Power Query, DAX, Power BI App, SSIS, SSRS, SSASRDBMSMS SQL Server 2008/2008R 2/ 2012/2014/2016 /2017/2019, Oracle, MS Access.LanguagesT SQL, DAX, M CODE, SQL*Plus, PL/SQL, XMLSoftware PackagesMS - Excel, PowerPoint, Word, TOADApplication AdministrationOracle WebLogic ServerMethodologiesAgile, Waterfall, RADOperating SystemWindows Linux.PROFESSIONAL EXPERIENCEProvident Bank Jersey City, NJ Jun 2023 Till DatePower BI DeveloperAnalyzed and converted client requirements into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation, and implementation.Incorporated Power BI reports into other applications using embedded analytics, such as Power BI service (SaaS), or through API integrationDesigned and implemented robust ETL processes to extract data from multiple sources including databases, APIs, and flat files, ensuring efficient data integration into Power BI.Integrated Power BI reports from various data sources, including SQL databases, Excel files, and web servicesDeveloped visualizations and charts that communicate complex data effectivelyDiagnosed and fixed any problems encountered with Power BI reports and dashboardsIdentified and resolved performance bottlenecks in ETL processes and Power BI reports by optimizing queries, data refresh schedules, and data model design.Translate Tableau report and dashboard designs to Power BI, ensuring consistency in data presentation and user experience.Developed calculated columns and measures queries in PowerBI desktop to demonstrate good data analysis.Used Power BI and Power Pivot to write complex DAX functions.Implemented best practices for data modeling and visualization of Power BI reports and dashboardsUsed visualizations such as bar charts and line charts to create hierarchies in Power BI reports.Implemented complex business logic using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting, and Jobs in the database design.Utilized various advanced table calculations for tableau dashboards and applied row-level securityCreated, scheduled, and maintained reports in Report Manager and Report Server for SSRSSupported SSRS, Power BI, Tableau visualization tools reporting applications by designing and implementing data extracts.Implemented version control practices for ETL processes and Power BI reports using Git or similar tools, ensuring traceability and facilitating collaborative development.Engaged with the Office 365 admin team so that Power BI workspace groups are created with legit members.Developed interactive dashboards for Business Users, Program Managers, and End Users using Power BI.Implemented SSRS to create drill down reports, parameterized reports, linked reports, and sub reports, as well as generating Ad-hoc Reports.Assisted in the development of star schemas in accordance with the business requirements.Utilized the latest data prep features, fuzzy matching capabilities, and data profiling capabilities to identify data quality issues.Tech Stack: Power BI, Power BI Gateway, Power Query, MS SQL Server 2019, SSIS, SSRS, MS Excel, Tableau, Windows, Team Foundation.Ameriserv Bank Johnstown, PA Nov 2022 May 2023Power BI Developer ADMINDetermined patterns and trends affecting overall performance through the analysis of utilization data, which has enabled strategic decision-making and optimization of performance.Achieved efficient data management and manipulation by implementing Stored Procedures, Triggers, and User Defined Functions (UDFs).Implemented robust error handling mechanisms in ETL workflows to capture and handle data integration issues, ensuring data integrity and reliability in Power BI reports.Managed Power BI environment including user access, roles, and security to ensure data integrity and confidentiality.Implemented and maintained Power BI Gateway to enable secure data transfer between on-premises and cloud-based data sources.Implemented data cleansing techniques during ETL processes to handle missing or erroneous data, ensuring data accuracy and consistency in Power BI visualizations.Adhered to regulatory compliance standards by creating Views that controlled access and maintained data confidentiality.Improved the efficiency of data retrieval by creating indexes, improving query execution, and optimizing the execution of queries.Integrated ETL operations with SSIS, facilitating incremental and historical data loading and ensuring data integrity and consistency.Created SSIS packages for extracting data from OLTP (Online Transaction Processing) systems and integrating it with OLAP (Online Analytical Processing) systems, and scheduling jobs for seamless data insertion.Utilized Multidimensional Expressions (MDX) for dimensional measures, enabling multidimensional analysis and reporting.Monitored Power BI performance, conducted troubleshooting, and optimized dashboards and reports for maximum efficiency.Involved in the development and execution of complex data transformations using SSIS packages that enable data to be loaded from multiple sources into destination tables while ensuring data accuracy and consistency.Conducted regular data refreshes and updates to ensure that Power BI reports and datasets are current and accurate.Implemented SSIS packages that synchronized data between two systems in a manner that ensured data integrity and consistency across all platforms.Provided job management and scheduling services for a variety of tasks, ensuring timely completion of the tasks and efficient maintenance of the system.Implemented data governance policies and standards within Power BI to maintain data quality and compliance with organizational guidelines.Utilized SSIS ''Control Flow'' and ''Data Flow'' transformations in order to optimize the data processing workflow, including Execute SQL Tasks, FTP Tasks, Send Mail Tasks, Conditional Splits, and Fuzzy Lookups in order to optimize the data processing workflow.Enhanced performance and efficiency of data processing tasks by implementing advanced SSIS functionality, including complex joins, conditional splitting, and column conversions.Developed SSIS packages to facilitate the migration of dimensions that slowly change over time.Generated Power Pivot data models from the models in Power View using the Power Pivot data models.Imported data from SQL Server databases and Analysis Services databases using Power Pivot data models.Calculated columns and measures using DAX functions and formatted with the appropriate types.Established monitoring and logging mechanisms to track ETL job execution, performance metrics, and data lineage, enabling proactive troubleshooting and optimization.Developed a tabular data model using the Scalable Statistical Analysis System (SSAS) and deployed it to SharePoint.Developed Power View Reports, and scheduled them to be updated on SharePoint on a daily, weekly, and monthly basis.Leverage knowledge of Tableau to integrate or migrate data sources and reports between Tableau and Power BI environments.Developed reports using Power BI Desktop and Power BI Service by using Power BI Desktop and Power BI Service.Assigned permissions to report publishers to ensure secure and controlled access to the data inside the enterprise environment, we established Enterprise Gateways to facilitate access to data sources and assist report publishers.Contributed significantly to the design, development, and maintenance of SSAS (SQL Server Analysis Services) cubes, allowing for multidimensional analysis and reporting capabilities to improve business intelligence initiatives by supporting multidimensional analysis and reporting.Managed the development, planning, and implementation of SSIS (SQL Server Integration Services) packages for loading Facts and Dimensions into data warehouses and data marts, ensuring that the data loading process is efficient and accurate.Optimized query execution and data retrieval efficiency for very large databases by utilizing database partitioning strategies.Ensured timely communication and proactive monitoring of system processes by creating mail profiles to automate email notifications for job status updates.Achieved optimal data storage and retrieval performance by creating partitions, schemas, and file groups within the database environment.Developed a dashboard based on Power BI reports and shared it with business users.Incorporated both unit tests and integration tests into the development process.Tech Stack: Power BI, Tableau, SSIS, SSRS, TFS, MS SQL Server 2019, Query Analyzer, Windows, SSAS.Thomson Reuters Hyderabad, India Sep 2019 May 2022Power BI DeveloperAnalyzed the reporting environment thoroughly to figure out its structure, requirements, and functionalities to develop effective reporting solutions.Achieved alignment between technical solutions and business requirements by collaborating with business analysts on requirements gathering, database design, and workflow design.Utilized new database and schema changes to implement updated reporting requirements, which ensured that reporting solutions remained current and relevant in line with the industry.Implemented a centralized SSIS Master Package that allows executing multiple children while utilizing Control Flow and Data Flow to simplify data processing.Designed and developed interactive dashboards using Power BI, enabling stakeholders to visualize and analyze data efficiently.Ensured data integrity and consistency throughout the migration process by analyzing and resolving migration issues.Notified relevant user communities about execution results with event handlers and error handling mechanisms in SSIS packages. Managed proactive maintenance in the new environment using SQL Server Mailing Agent.Optimized functionality and performance of SSIS packages by utilizing variables, breakpoints, checkpoints, logging, package configuration, and event handlers.Improved database, SQL query, and stored procedure performance using SQL Profiler, Execution Plan, and Index Tuning Wizard to ensure efficient data retrieval and processing.Implemented complex SSAS Cubes to meet OLAP reporting needs, including multiple fact measure groups and hierarchy groups, to be used by multiple fact measures.Prepared MDX queries for Analysis Services and Reporting Services with the help of Microsoft Visual Studio.Utilized OLAP cubes and offline cubes to develop and test PivotTable/PivotChart reports.Improved cube performance by dividing the measure groups into multiple partitions and aggregating them for the different measure groups.Resolved SSAS cube connectivity and data issues as necessary.Assisted with the generation of reports and the analysis of the data for the business by connecting to SQL Server Analysis Services (SSAS) via a secure connection.Debugged and tested the use case scenarios, migrated the code as needed, and coordinated with the DBA Team as needed.Tech Stack: SQL Server 2016, SQL Server Integration Services (SSIS), Reporting Services (SSRS), TFS, Power BI, PowerShell, Pivot Tables, Windows.Cognizant Hyderabad, India May 2018 Sep 2019SQL Server BI DeveloperImplemented SQL Server Agent to schedule ETL Jobs so they run regularly into data marts.Developed transforms, control flow tasks, loop containers, and data flow tasks within SSIS to load data into staging tables and prepare it for processing.Implemented complex stored procedures, triggers, and functions to enhance the productivity of the claims processing system and improve the overall system performance.Automated Excel sheet retrieval from FTP servers into SSIS, streamlining data acquisition processes and ensuring timely availability of required data.Utilized SSIS packages to perform comprehensive data transformations and manipulation in order to meet specific business requirements, including Derived Columns, Conditional Splits, Lookups, Merges, Row Counts, and Data Conversions.Monitored and managed production software deployments.Utilized SQL Profiler and the Database Engine Tuning Advisor to tune SQL commands and troubleshoot technical issues.Created documentation for all types of reports and SSIS ETL packages that were required by clients.Analyzed and validated the new SSRS reports based on different filters.Implemented complex reports using Microsoft Reporting Services, including drill downs, drill throughs, and cross tabulations.Utilized SSRS Report Builder to create data-driven subscription reports using parameters, queries, and reports to develop data-driven subscription reports for end users.Migrated all code versions in TFS while maintaining all code versions.Tech Stack: MS SQL Server 2012, TFS, T-SQL, SSIS, SSRS, Excel, Visual Studio 2008/2010, Windows Server 2008Optimized Solutions Hyderabad, India Jun 2016 April 2018SQL Server BI DeveloperManaged the definition, design, and management of databases in accordance with business requirements.Implemented business requirements after identifying them and understanding their scope.Assembled Functional Requirements and mapped them to Technical Specifications to provide a map of the project.Created indexes, views, complex stored procedures, triggers, cursors, and user defined functions to implement business logic.Updated and cleaned up the old database tables and procedures.Utilized SSIS to convert flat files, Excel spreadsheets, and XML into SQL Server.Designed scorecards and reports using Dashboard Designer.Implemented an ER diagram using Erwin for the data modeling of the application.Worked with SQL Server Reporting Services SSIS to create, maintain, and schedule various reports, such as Ad-hoc Reports, Canned Reports, Master Reports, Parameterized Reports, and Drill Down Reports.Developed sales reports, customized reports, on-demand reports, ad-hoc reports, and analyzed multidimensional reports using SSRS.Constructed complex queries using joins and subqueries extensively.Utilized SQL Server Setup to install MS SQL Server and its management tools.Coordinated with the DBA in creating and managing tables, indexes, triggers, databases links, and privileges.Developed and reviewed primary objects, such as views and indexes, based on logical design models, user requirements, and physical constraints.Prepared a Self-Service Deployment and Execution document for SSISSupported users and troubleshooted stored procedures, triggers, and privilege issues.Utilized ETL procedures and schemas to optimize loads and queries.Tech Stack: Microsoft SQL Server Management Studio, SSIS, SSRS, SSAS, SQL Server, MS Word, MS Excel, Visual Studio, Windows. |
