Power BI Developer Resume Washington DC - Hire IT People (2024)

SUMMARY

• Highly motivated Power BI Developer with around 9 years of IT Experience having multiple skillsets and extensive working experience in Business Intelligence and Data warehousing technologies with expertise in SQL Server Development, MSBI Stack (TSQL, SSIS, SSAS, SSRS), Azure, Power BI, Tableau for building, deploying and managing applications and services through a global network of Microsoft - managed datacenters.
• Assisted Business users in developing, maintaining and supporting operational reports, dashboards and scorecard solutions for clients; with various visualization data insights.
• Experience in Power BI Desktop, Report Service, Gateway Connectors, Data Models, Relationships, Publishing / Updates to Apps Workspaces, Data On-Demand Refreshes, Scheduling, Testing and Deployment.
• Involved in developing, maintaining and supporting operational reports, dashboards and scorecards solutions using MS Power BI.
• Experience in Frame Work Manager, Data Models, Relationships, Table / View Creations, Publishing / Updates to Apps Workspaces, On-Demand Data Refreshes, Scheduling, Testing and Deployment.
• High-level MS Power BI admin knowledge, custom visuals and cloud computing environments.

TECHNICAL SKILLS

• Methods/Tools
• Project & program management
• Business Intelligence
• Disaster Recovery and Crisis Management System Integration
• Practices Microsoft Power BI
• User Acceptance and System Integration
• Tableau
• Testing Solution Architect
• Hyperion Financial
• Financial Management
• Reporting TM1 and Planning Analytics
• BI Reporting and Financial Reporting
• SAP and General Ledger data integration Agile & Waterfall Methodologies
• Change management and Incident Management
• Oracle
• Teradata SQL & Server
• Azure SQL
• MongoDB
• Business process mapping

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Power BI Developer

Responsibilities:

• Created complex dashboard using Power Bi using calculations and drill down and drill up in worksheets and customization using filters and actions.
• Manage development and production issues impacting our clients and operations.
• Optimization of DAX and queries to improve the performance of the reports.
• Connecting data through live and import more from MYSQL Database to power bi. Experience with Data Modelling/Power Query, Power Apps, Power Automate, Desktop designer/Report designer.
• Knowledge of SQL query, SQL server reporting services (SSRS) and SQL integration services (SSIS).
• Experience in leading offshore team and working in Agile/Scrum methodologies and environment.
• Designed, developed, and tested various Power BI visualization for the dashboard and ad-hoc reporting solutions. Conducted meetings with business stakeholders, clients and director-level members for requirement gatherings and presented various solutions using best practices.
• Implementing RLS (Row Level Security) for all the reports using geographical granularity.
• Monitor and improve data and BI processes to meet firm SLAs and increase efficiency.

Confidential, Parsippany NJ

Power BI Developer

Responsibilities:

• Design, develop and deploy SSAS tabular models and maintain Row-Level security
• Design, develop and publish Power BI reports connecting to data sources like ADLS blob storage, tabular models, and SQL DB via Import or Direct query mode
• Optimization of DAX and queries to improve the performance of the reports
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Improvising the report in Power BI and detailing it to the client on the performance of the dashboard.
• Involved in working closely with other software developers and senior-level technology leaders, to understand the stakeholder’s requirements and translate them into wireframes for review and build the solution using Power BI.
• Designed, developed and tested various Power BI visualization for the dashboard and ad-hoc reporting solutions. Conducted meetings with business stakeholders, clients and director-level members for requirement gatherings and presented various solutions using best practices.

Confidential, Chicago IL

Tableau/Power BI Developer

Responsibilities:

• Designed, developed and tested various Power BI visualization for the dashboard and ad-hoc reporting solutions
• CreatedTableaudashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• As aTableauSME, responsible for the design, development and production support of interactive data visualizations used across the company.
• Involved in Migrating BI reports from Microsoft forms to Power BI using SharePoint and MS Excel as Data source
• Improvising the report in Power BI and detailing it to the client on the performance of the dashboard.
• Possess a high level of proficiency in Data Analysis Expressions (DAX) with demonstrated capabilities in this area.
• Monitor and improve data and BI processes to meet firm SLAs and increase efficiency.
• Integrated custom visuals based on business requirements using Power BI desktop.
• Significant knowledge on tracking the performance issues with Power BI reports and presented various solutions using best practices.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Provide analysis of the project, including business case, ROI and post-project review.
• Implementing RLS (Row Level Security) for all the reports using geographical granularity.
• Involved in project planning and deadlines.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Confidential, Boston MA

Power BI Architect

Responsibilities:

• Involved in Power BI infrastructure setup, explaining to the client about a handful of versions of Power BI to choose from, depending on budget, needs, and how they want to deploy it
• Coordinated Client with Microsoft for better understanding of Power BI versions ranging from light use to comprehensive features, free to premium, so users can select the one that best meets their requirements.
• Designed and documented the entire Architecture of Power bi.
• Expertise in writing complex DAX functions inPower BI and Power Pivot.
• AutomatedPowerQuery refresh usingpowershell script. Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, and Measures query’s in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kinds of reports such as Yearly, Quarterly, Monthly, and Daily. Worked on all types of transformations that are available in Power bi query editor
• Created stored procedures and SQL queries to pull data intothe powerpivot model.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Confidential, New Jersey

Power BI Developer

Responsibilities:

• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Manage development and production issues impacting our clients and operations.
• Build BI reports, dashboards, drill-downs, filters, graphs, etc. on the Microsoft Power BI platform.
• Monitor and improve data and BI processes to meet firm SLAs and increase efficiency.
• Integrated custom visuals based on business requirements using Power BI desktop.
• Converting operational excel reports into Power BI Reports.
• Possess a high level of proficiency in Data Analysis Expressions (DAX) with demonstrated capabilities in this area.
• Managed project insights through Azure DevOps to track the list of assignments and provide daily updates on progress.
• Experience on Azure Boards to work at various stages of a process using cards to represent work items and columns to represent each stage of the process.
• Involved in working closely with other software developers and senior-level technology leaders, to understand the stakeholder’s requirements and translate them into wireframes for review and build the solution using Power BI.
• Involved in new ways of working through VFQ (Value, Flow and Quality) which brings together the best thinking, practices and principles behind current methodologies.
• Maintain in-depth knowledge of IT industry best practices, technologies, architectures and emerging technologies.
• Able to thrive in an environment that requires flexibility and multi-tasking.

Confidential, New Jersey

Power BI Developer

Responsibilities:

• Designing, developing and maintaining business intelligencesolutions. Crafting and executing queries upon request for data. Presenting information through reports and visualization.
• As a Power BI coach trained business users and clients on creating reports using Power BI desktop, providing advanced learning materials and WebEx sessions.
• Imported data from SQL Server DB, and Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generate computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Designed, developed and tested various Power BI visualization for the dashboard and ad-hoc reporting solutions. Conducted meetings with business stakeholders, clients and director-level members for requirement gatherings and presented various solutions using best practices.
• Closely associated with consumption team to assist in evaluating and selecting the best technologies and tools to support BI mission.
• Significant knowledge on tracking the performance issues with Power BI reports and presented various solutions using best practices.
• Maintain in-depth knowledge of IT industry best practices, technologies, architectures and emerging technologies.
• Able to thrive in an environment that requires flexibility and multi-tasking.

Confidential, TX

Power BI Developer

Responsibilities:

• Guide the design and development of data management and business intelligence projects to drive strategic decisions through data-driven actionable metrics and insights.
• Designing, developing and maintaining business intelligencesolutions. Crafting and executing queries upon request for data. Presenting information through reports and visualization.
• Knowledge of and proven expertise with cloud implementations in AWS, Azure
• Provide subject matter expertise in data modeling and architecture design. Assist in evaluating and selecting the best technologies and tools to support the BI mission.
• Imported data from SQL Server DB, and Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generate computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Manage development and production issues impacting our clients and operations.
• Build BI reports, dashboards, drill-downs, filters, graphs, etc. on the Microsoft Power BI platform.
• Monitor and improve data and BI processes to meet firm SLAs and increase efficiency.
• Leverage technology capabilities and standards while working with technology system owners to identify appropriate data sources, and define and build required data transformation logic.
• Significant experience solutioning, architecting, designing, implementing, migrating, and operating in an enterprise cloud environment
• Perform detailed data analysis to derive insights and deliver operational mechanisms such as dashboards or ad-hoc reports.
• Maintain in-depth knowledge of IT industry best practices, technologies, architectures and emerging technologies.
• Provide architectural consulting to programs, projects and product initiatives.
• Review new and existing solution delivery for compliance with IT standards, and policies and Ensure that project documentation captures significant architectural decisions.
• Identify architectural risks and propose alternatives and solutions.
• Provide analysis of the project, including business case, ROI and post-project review.
• Drive innovation, best practices and achievement of strategic objectives.

Confidential, Lansing, MI

Sr. Power BI Developer /Sr. Tableau Developer

Responsibilities:

• Designed, developed and tested various Power BI/Tableau visualization for the dashboard and ad-hoc reporting solutions.
• Conducted meetings with business stakeholders, clients and director-level members for requirement gatherings and presented various solutions using best practices.
• Managing timely and accurate delivery of information to various cross-functional teams.
• Created Power BI Visualizations and Dashboard as per the requirements.
• Configured Power BI Dashboard and reports.
• Created many calculated columns and measures using DAX in Power BI based on report requirements.
• Willingness to learn new technologies. Enjoy working on the technical side as well as leading project efforts.
• Created incremental refreshes for data sources on Tableau Server.
• Created report schedules, data connections, projects, and groups in Tableau Server.
• Implemented action filters, and parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Mentored and trained less tenured Business Analysts for their development.
• Use tools such as SQL and Insync for investigation of issues and work closely with our Actuarial and Underwriting Customers.
• Managed projects ranging from large to small.
• Created, maintained and queried relational database (MS Access). Understand and use SQL regularly for problem analysis.
• Created solution-driven dashboards by developing different chart types including Crosstab's, Heat/Geo/TreeMaps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Created Adhoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used Excel, flat files, and CSV files to create Tableau Adhoc reports.
• Design interactive dashboards in Tableau Desktop and published them to Tableau Server.
• Strong presentation skills
• Attention to detail and quality.
• Ability to work independently and deliver around tight timelines.
• Coordinate with multiple technology teams on product releases and related administrative tasks.
• Able to thrive in an environment that requires flexibility and multi-tasking.

Confidential, NC

Sr. Tableau/Power bi Developer

Responsibilities:

• CreatedTableaudashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Created interactive data visualizations inTableau, using relational and aggregate data sources.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Integrated custom visuals based on business requirements using Power BI desktop.
• Converting all operational excel reports into Power BI Reports.
• As aTableauSME, responsible for the design, development and production support of interactive data visualizations used across the company.
• Deep experience in architecting cloud solutions for enterprise
• Experience in deploying solutions in Azure and AWS platforms
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Provide Support toBusinessusers inBusinessObjectsReporting.
• Identify areas of opportunity to improve the ROI of marketing activities by analyzing customer behavior.
• Worked on all types of transformations that are available in Power bi qu=ery editor.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Implemented metrics, filters, reports, and dashboards and also created advanced chart types, using calculations to manipulate the data and enable user-driven parameters for visualizations and drilled down the level of detail using sets.
• Developed interactive views with action/highlight filters to track-manage-correct system entry errors which provided strategic insights to Finance leaders, that helped decrease the faulty inputs into their project’s software.
• Implemented workbooks to display Year to Date, Month to Date, and Quarter Date analysis for Operational expenses for IT leaders based on Accounts, and generated bullet graphs.
• Implement complex formulas, calculations & Level of detail (LOD) within Tableau to meet the needs of complex business logic.
• Created advanced connections, join new tables, and create & manage Extract and Monitor Queries using SQL Assistant.
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Designed and developed ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Mapplets, connected and unconnected stored procedures/functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Confidential

Tableau/SQL Developer

Responsibilities:

• Built Strategic, Analytical and operational dashboards usingTableau.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop by connecting live/dynamic and static datasets.Developed Inventory reconciliation, Sales KPI summary update reports, and Days Inventory on hand report for different channels, firms and products rolling up by month-end.
• Created SQL views to pull data from SQL Server and developed reports using advanced calculations, filters and parameters.
• Training business users for all things Tableau and data analysis.
• Creating New Schedule and checking the tasks daily on theTableauServer.
• Maintaining server activities, user activity, and customized views onTableauServer analysis
• Interacted with the Business Users and Supervisors to gather business requirements.
• Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents.
• Created Business Process Models from the requirement specifications.
• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2014, and MS Access databases.
• Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance.
• Extracted data from XML and flat files using SSIS.
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing.
• Designed, programmed, deployed and tested the requested Reports.