We provide IT Staff Augmentation Services!

Senior Bi Developer Resume

5.00/5 (Submit Your Rating)

Somerville, MA

SUMMARY

  • Around 6+ Years of extensive experience in developing BI applications using Power BI, Tableau, QlikView and Microsoft Business Intelligence suite.
  • Extensive experience in Database Design, Development & Support of MS SQL Server 2017/2012/2008/2005 in Production and Development.
  • Expertise in developing complex Tableau dashboards and working on end - to-end solutions from development till deployment with proper security practices.
  • Hands-on with various Tableau versions which include Pre-TSM, TSM versions covering Tableau Server 10.1, 2019.1 and Tableau Desktop 2018.1,2019.1.
  • Proficient in design and development of various dashboards, reports utilizingTableauVisualizations like Butterfly Charts, Pyramid Charts, Waffle Charts, Waterfall Charts, Sankey Diagram, Donut Charts, Pareto Charts, Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Box Plots, Geographic Visualizations, dashboardactions.
  • Proficient in making DAX queries in Power BI desktop.
  • Experienced in working with Star Schema, Snowflake Schema, Bus schema modeling to develop ROLAP/MOLAP Cubes using SQL Server 2008/2016 Analysis Services
  • Proficient in working with T-SQL statements to extract data from data tables and verify the output data of the reports. Good at Creating tables, Sub queries, CTE’s, Correlated Sub queries, Joins, Views, Indexes, SQL Functions, Set Operators and other Functionalities.
  • Expertise in designing and creating various analytical reports like Performance Dashboards,Score cardsand Metrics to help users to identify critical KPIs and facilitate strategic planning.
  • Proficient in performance tuning and Server management of tableau server environment (clustering, Load balancing).
  • Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
  • Strong knowledge on Power BI eco-system including Power BI service, Gateways.
  • Experience in mapping business processes against complex data models and writing DAX, MDX to query SSAS cube.
  • Hands-on working experience with analyzing query plans, using extended Stored Procedures
  • Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, SPROC, Views, Cursors and Triggers
  • Created, Maintained & scheduled various reports in Power BI which includes geo spatial reporting on Power Map and data modeling on Power Pivot and ETL data cleansing using Power Query.
  • Published Power BI reports from Power BI desktop to Power BI service.
  • Experience in building Excel reports with data manipulation techniques, drill through data functionalities using macros and data analysis using pivot tables.
  • Exposure on various reporting platforms such as looker, Qlik sense & ThoughtSpot.
  • Experienced in troubleshooting and validation of data after developing reports to cover any delta’s or formula errors or any other possible human errors.
  • Collect and analyze data for validity and accuracy in preparation of assigned reports and performs root-cause analysis on data related system problems and recommends or executes corrective action
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative, and the ability to think outside the box.
  • Experienced in managing the scrum process with the coordination of scrum team in Agile methodology.

TECHNICAL SKILLS

Operating Systems: MS DOS, Windows Server 2008/2017.

Reporting Tools: SQL Server Reporting Services (SSRS), QlikView, Crystal Reports, Excel Reporting, Tableau, SSAS, Power BI

Databases: MS SQL Server 2008/2008R2/2012/2014, Oracle 11g,12c, MS Access 2000/2003/2007

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Power Query.

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, SQL Agents, SQL Alerts, SQL Jobs, Bulk Insert and BCP, Visual studio code

Languages: Transact SQL (T-SQL), Python, PL/SQL, VB Script

DB Modeling Tools: MS Visio, Erwin, Lucidchart

Deployment Tools: TFS, Git bash, bit bucket, Octo, Bamboo.

PROFESSIONAL EXPERIENCE

Confidential, Somerville, MA

Senior BI developer

Responsibilities:

  • Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
  • Built 10+ domain multidimensional OLAP cubes on SQL Server Analysis Services.
  • Maintained 1TB monolith domain OLAP cube and separated into small domain cubes.
  • Experienced in Microsoft BI reporting tools such as SSRS, Power BI and Tableau
  • Worked on all activities related to the development, implementation, and support of ETL processes.
  • Created T-SQL Stored Procedures, User Defined Functions, Indexes, Views, Constraints, Triggers and wrote complex queries using Joins, Aggregate Functions, Sub-queries, Derived tables and CTEs.
  • Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS.
  • Worked on transitioning database and report packages from Development and Test Environments to Production
  • Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Tableau Prep to extract the data from MS excel and import into Tableau Desktop.
  • Implemented row level security for the tableau dashboards and used various advanced table calculations.
  • Modifies existing ongoing report templates and dashboards built in the Tableau reporting platform.
  • Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
  • Used live connection oracle database schemas to provide near real-time data.
  • Utilized Tableau server to publish and share the reports with the business users and provided production support to Tableau users
  • Involved in administration tasks such as Setting permissions, managing ownerships, providing access to the users, and adding them to the specific group.
  • Administered tableau server to implement RBAC (Role based access control) project and AD group level security is implemented.

Confidential, Boston, MA

MS SQL Server, BI Developer

Responsibilities:

  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Prepared dashboards using calculated fields for different logics for trends, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Developed Parameter based reports, Drill-down reports, Charts and Tabular reports using Tableau and enabled ad-hoc reporting.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations.
  • Created UI screens for running SSIS Packages and showing log tables in web application using C#.Net and ASP.Net.
  • Created completely automated ETL Packages which will unzip the flat file, load into staging database, then into ODS (Operational Data Store) and then into normalized Database.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
  • Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
  • Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
  • Experienced in writing efficient query, Performance optimization, and Query plans.
  • Extensively used SPROC, VIEWS and efficient way of using Indexes.
  • Experienced in writing Dynamic SQL.

Confidential

BI Developer

Responsibilities:

  • Involved in gathering the user requirements.
  • Developed reports using Microsoft Power BI (Desktop, Service, Mobile)
  • Developed SSIS Packages for integrating data using OLE DB connection from heterogeneous sources.
  • Used multiple transformations provided by SSIS such as Data Conversion, Derived Column, Lookup,
  • Conditional Split, Bulk Insert, Merge and union all, etc.
  • Performed error handling in SSIS using Event Handling and logging.
  • Developed calculated columns and measures using DAX in Power BI
  • Improved the performance of SSIS packages by using fast load options, converting the data type at source if applicable, parallel processing, using non-blocking, semi blocking components over blocking components, dropping and rebuilding the indexes during the SSIS package run.
  • Worked on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule
  • SSIS Packages.
  • Extracted data from On-Premises and SaaS (Software as a Service) into Power BI desktop.
  • Created data visualizations using various visual objects and Published reports and dashboards to the Power
  • BI service through the Office 365 integration.
  • Implemented row level security by restricting the users for the data access.
  • Created Content packs that package up a dashboard, report, and dataset to send to specified team.
  • Incorporated Power Pivot/View to create analytical reports/dashboards from tabular and multidimensional models.
  • Developed dashboards with Power BI which display key KPIs for business analysis and decision making.
  • Developed SQL queries for data migration and Reporting Services. (SSRS)

Confidential

Database Developer

Responsibilities:

  • Analyzed business requirements and built conceptual, logical, and physical data models that describe all the data and relationships between the data.
  • Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables.
  • Worked with SQL Transmitter and DBArtisan.
  • Created stored procedures for implementing the business logic.
  • Responsible for Performance Tuning / Optimization
  • Worked with complex T-SQL queries
  • Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
  • Proposed triggers on events to insert, update and captured the data
  • Defined constraints, rules, and defaults to ensure data integrity and relational integrity.
  • Developed data modeling to visualize database structure
  • Participated in different Testing and Debugging for the system.
  • Documented all processes involved in maintaining the database for future reference

We'd love your feedback!