Bi Developer Resume Examples and Templates

Senior BI Developer, Business Intelligence

• Executed 15 analytics projects within a portfolio of inbound and outbound marketing initiatives for real estate clients. These projects encompassed integrated campaign management, database and email marketing, persona-based nurture programs, and account-based marketing.
• Led the development of analysis reports, resulting in improved operational efficiencies across credit cards, mortgages, personal loans, and branches. This initiative addressed stagnant inter-communication, leading to an efficiency ratio improvement of approximately 11%.
• Played a key role in constructing business dashboards for conducting trend analysis on retail metrics, with a specific focus on enhancing sales revenue, customer retention, and salesperson productivity.

BI Developer

• Gathered business requirements.
• Established multiple pipelines in the ADF portal.
• Generated diverse client reports using SSRS.
• Enhanced query performance by optimizing queries using SQL Server Tuning Advisor.
• Designed a new database for a project and crafted Drill Down reports, Sub reports, Tabular reports using Business Intelligence Development Studio.
• Loaded data from Flat files, DB tables, and Views into the Datawarehouse as per requirements.
• Developed and oversaw numerous applications within the Framework launcher.

Power BI developer

• Utilized various Power BI query editor transformations.
• Created and maintained multiple Power BI reports for analyzing productivity performance and sales.
• Designed reporting data modules for Monthly, Quarterly, and Yearly Development Reports.
• Developed complex DAX measures to derive different metrics.
• Implemented Row-level security and integrated with Power BI service portal.
• Scheduled automatic report refreshes in Power BI service.
• Installed and configured Enterprise gateway and Personal gateway in Power BI service.
• Managed Power BI reports based on global manufacturing data.
• Resolved bugs, conducted root cause analysis, and provided optimized solutions.
• Worked on a project in the Insurance domain, focusing on call performance and sales analysis.
• Created various reports including Customer service, Collection, Claims, Sales, and Delinquency reports.
• Participated in all phases of SDLC, from Requirement & Impact analysis to deployment verification.
• Implemented Row-level security and integrated with the Power BI service portal.
• Utilized bookmarks, selection pane, buttons, and Drill-through reporting.
• Scheduled automatic report refreshes in Power BI service.

MSBI,POWER BI Developer

• Responsible for SQL development, SSIS, and Power BI development, including the creation of Business Requirement Documents (BRD) and Proof of Concepts (POC).
• Proficient in using recursive CTEs, CTEs, temp tables, and effective DDL/DML Triggers to ensure data manipulation efficiency and consistency, supporting existing applications.
• Expertise in crafting T-SQL Queries, Dynamic queries, sub-queries, and complex joins for generating Stored Procedures, Triggers, User-defined Functions, Views, and Cursors.
• Skilled in error and event handling, including precedence Constraints, BreakPoints, Checkpoints, and Logging.
• Experienced in analyzing, designing, developing, installing, configuring, and deploying MS SQL Server suite of products with a focus on Business Intelligence, including SQL Server Reporting Services 2005/2008, SQL Server Analysis Services 2005/2008, and SQL Server Integration Services.
• Created SSIS Packages for ETL processes from various data sources such as Excel, Flat File Source, and OLDB.
• Utilized SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Proficient in importing/exporting data between different sources like Oracle, Access, Excel, etc., using SSIS/DTS utility.
• Expert in generating parameterized queries, drill-through reports, and formatted SQL server Reports in SSRS 2005/2008/2008 R2, using data from ETL Loads, SSAS Cubes, and various heterogeneous data sources.
• Imported data from SQL Server DB and Azure SQL DB to Power BI to create reports.
• Created DAX Queries to generate computed columns in Power BI.
• Published Power BI Reports and made Power BI Dashboards available in web clients and mobile apps.

BI Developer

• Constructing Data Warehouses and Data Marts.
• Developing Data Pipelines.
• Creating and maintaining Business Reports.
• Analyzing Business Requirements.
• Conducting Research and Delivering Presentations for Teams.

Power BI Developer

• Collaborating with Microsoft clients to offer guidance and develop Power BI Reports for Microsoft customers.
• Crafting Dashboards tailored to customer requirements and resolving issues related to Dashboards, gateways, and Dataflows.
• Automating report and dashboard generation using Power BI.
• Managing Workspace access levels (Admin, Member, Contributor, Viewer) based on user responsibilities and hierarchy.
• Crafting optimized SQL queries for seamless integration with other applications.
• Ensuring data quality and supervising database security.
• Developing views, functions, and stored procedures.

BI Developer

• Conducted initial induction and training in PL/SQL, Power BI, and SQL Server Integration Services.
• Executed ETL processes utilizing TIBCO Data Virtualization, a middleware tool that organizes services and data layers.
• Managed data for the new Web Client Portal.
• Extracted data from various sources, initially SAP ECC and Pivotal, and currently Oracle databases.
• Customized data in accordance with interface specifications.
• Optimized data performance through PL/SQL queries.
• Published information as a RESTful webservice for the Web Portal development team.
• Migrated data from Oracle to SAP4.
• Employed SCRUM methodology.

BI Developer

• Designed and developed interactive dashboards and analytics reports to aid store managers in decision-making.
• Created various interactive dashboards and analytics reports, encompassing price trend analysis, product placement analysis, and more.
• Developed Report Design Templates (RDT) and logical models for large-scale projects.
• Implemented VLDB properties and conducted performance tuning for extensive data projects.
• Managed entire projects, including requirements gathering, analysis, design documentation, and BI report development.

__BI developer __

• Directed the BI technical strategy within the company.
• Created visualizations and dashboards in Tableau for tracking KPIs, including product engagement, product installation, email campaign performance, business metrics (OKR), and retention metrics.
• Worked with various data sources running on MS SQL Server, such as User Accounts, Installations, and Transactions.
• Collaborated with cross-functional team members to ensure data collection and transmission for calculating product metrics.
• Designed and implemented Data Warehouse (DWH) infrastructure and data marts for reporting.
• Leveraged big data sources like web and application clickstreams and email automation logs using the column-oriented DBMS, Clickhouse.
• Led the development of a cross-device identification (XDID) algorithm.
• Developed critical Tableau reports for business, including OKR, Email Marketing, and Installations.
• Proposed and implemented a big data solution based on a column-oriented DBMS to address performance issues with SSAS cubes.
• Implemented the XDID algorithm to link user activities across various data sources.

Azure BI Developer

• Proficient in Team and Delivery Management, facilitating the seamless migration of BI Solutions to the Cloud Platform as part of a digital transformation journey.
• Skilled in Strategic Planning and Problem-Solving, with a focus on Data Analytics for Market Strategy and Shared Services.
• Experienced in Capacity and Demand Planning, supporting the operations of a large Telecom Enterprise within the Enterprise IT Organization.

Senior BI Developer

• Designed comprehensive database architecture, encompassing ETL, SSIS, SSAS, cube design, and Power BI reporting with automation.
• Managed product replenishment and vendor negotiations to secure optimal deals.
• Conducted market research and analyzed competition.
• Initiated and oversaw new business projects from conception to execution.
• Provided supervision for technical staff members located overseas.