We provide IT Staff Augmentation Services!

Bi Developer Resume

Dayton, OhiO

SUMMARY

  • Over seven years of Experience in developing Business Intelligence applications, Data analytics using Microsoft BI tools and data visualization tools such as Tableau and Microsoft Power BI.
  • Extensive experience in implementing BI and DW solutions in domains like Health Care, Insurance, Logistics, and Banking.
  • Created query functions by understanding relationship between the business functions and its datasets to analyze the data and to find the powerful insights.
  • Deep understanding of Power BI tool capabilities and appropriate use cases to extract the right value from the data.
  • Can efficiently use Power BI and Tableau for reporting, modelling and transforming the data based on the requirements.
  • Expertise in creating dashboards, reports, stories with visualization tools with forecasting and optimization of data and by proficiently writing sql queries, user defined functions, views, indexes and stored procedures.
  • Meticulous in analyzing complex data using data visualization tools like SSRS, Tableau, Microsoft Power Bi to find the insights to improve decision making.
  • Generated various types of reports like Tabular, Matrix and Charts using SSRS and created maps, animations, LOD dashboards using tableau.
  • Created templates in SSRS and embedded KPI’s in web portal.
  • Strong experience in Business and Data Analysis, Data Profiling, Data Cleansing, Data Migration, Data Integration and Metadata Management Services.
  • Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided bySSIS.
  • Can trouble shoot technical issues during the ETL process, isolate the root cause and take appropriate action to amend the problem.
  • In depth use of Data warehouse concepts, OLTP, OLAP, ETL, Star Schema, Snowflake, data modelling and SQL.
  • Strong experience in SQL server integration services to integrate data from multiple heterogeneous data sources and to accelerate internal business processes.
  • Experience in tableau report server development and deploying reports in tableau server and reporting services configuration.
  • Experience inPerformance TuningandQuery Optimization.
  • Exceptional analytical, qualitative, problem solving and critical thinking skills.
  • Knowledge and aware of HIPAA privacy rules, ICD and CPT codes in healthcare domain.
  • Implemented solutions using agile methodology by taking active part in sprint planning, Daily Scrum Stand Up, and Sprint Retrospective.
  • Cultivated strong technical and soft skills to establish respect for the real - time data and importance of probability.

TECHNICAL SKILLS

  • T-SQL
  • SQL Server 2008/2012/2014/2016
  • Tableau 8.1/9.0/10.2
  • Power BI 2.53
  • VS 2008/2012/2014/2015
  • SSIS
  • SSRS
  • SSAS
  • MDX
  • DAX
  • R Programming
  • Oracle
  • Teradata
  • MS Excel
  • MS Access
  • Tidal
  • Team City
  • Octopus.

PROFESSIONAL EXPERIENCE

Confidential, Dayton, Ohio

BI Developer

Responsibilities:

  • Interacted with the business users and business analyst to understand the requirements and develop reports by following all the reporting standards.
  • Created and modified existing stored procedures to extract the data and to develop reports.
  • Developed SSIS packages to load all lines of business data into a single table and use that data to populate dashboard.
  • Modified existing Power BI dashboards based on the business user’s requirements.
  • Worked on research stories to create STM for converting existing reports from Teradata to sql server.
  • Developed SSRS reports in tubular, matrix and validated the reports. Trouble shoot the errors to break fix the report issues.
  • Actively involved in Agile methodology by participated in story grooming sprint planning, Daily Scrum Stand Up, and Sprint Retrospective, JAD sessions, Peer review.
  • Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
  • Deployed the SSIS Packages and SSRS reports into all the environments using team city and octopus.

Environment: SQL Server, Teradata, Visual studio, MS Office Tools, Tidal, Team City, Octopus, Agile Methodology.

Confidential, Eden Prairie, MN

BI Developer

Responsibilities:

  • Interacted with Business users, Business Analysts to understand business requirements and transform them into technical specifications.
  • Involved in the data migration from Teradata server to MSSQL Server of other reporting Systems.
  • Created stored procedures, user defined functions, views, tables and T-SQL scripts for complex business logic
  • Cleaned the data source using SSIS and MS SQL Server using conditional splits and Stored procedures.
  • Used audit batch process to track number of rows inserted or updated on the tables.
  • Grouped bunch of activities into one using sequence container and to organize things better.
  • Generated a metadata for reporting using complex joins, Custom SQL, split and data blending.
  • Designed, developed and managed metadata schema in regular intervals.
  • Created a visualization dashboard which includes table calculations, calculated fields, filters, parameters, toggling, trend lines, clusters to meet the business requirements.
  • Leveraged the power of visualization by making them interactive by creating groups and controlling them with parameters.
  • Deployed reports onto the reporting server configuration.
  • Deployed the workbooks and live data sources to Tableau Server under row-level security environment.
  • Modulated reports performance by recording and analyzing performance workbook on timeline and execution query, tuned andoptimized analysis, calculated fields, layout and data source
  • Troubleshoot errors and find the insights to solve the business problems.

Environment: Visual studio 2014/2015, MS SQL Server 2014, MS Office Tools, Control M.

Confidential, Bloomington, IL

ETL Developer

Responsibilities:

  • Understand business initiatives including technical and none technical requirements.
  • Development, support and monitorof SSIS packages using Visual Studio.
  • Created SQL queries, Store Procedures, Functions, Views, Triggers and other DB objects in different phases as per required.
  • Extracted data from multiple sources like DB2, Oracle, Access, MySQL etc.
  • Scrubbing and monitoring data to make sure that it meets legal requirements.
  • Developed SSRS reports in tubular or matrixand deploy them onto the server.
  • Generated interactive reports by using cascading parameters, drill down and book marks.
  • Involved in development of Dashboards like line graphs, bar graphs, area charts in Power BI using filters, drill down and drill through features.
  • Transformed the data with the help of DAX, Power pivot and power query for the analysis using Power BI.
  • Involved in assisting and assigning works to interns related to Power BI.
  • Translated complex concepts in ways that can be understood by none technical audiences.
  • Conduct code review to ensure delivery of high quality standards.
  • Optimized the reports performance by understanding the end user’s interaction with the reports.
  • Used TFS during development process to collaborate within the team members.
  • Used agile methodology for SDLC and actively participated in sprint planning.

Environment: SQL Server 2012, Visual Studio 2012, Power BI, Team Foundation Server, Oracle, MS Access, MS Excel

Confidential, Charlotte, NC

BI Developer

Responsibilities:

  • Understood the objectives that make a project scope and helped in improving overall efficiency of the business functions.
  • Performed data cleansing, data staging and transfer, and integrating and consolidating data from many usually disparate information systems and technologies.
  • Created metadata for reporting services using joins, Custom SQL, split and data blending.
  • Effectively involved in the maintenance of Data Server, metadata management, creating shared Data sources and publishing them to Server.
  • Created multi-dimensional models using SSAS.
  • Implemented a process of continuous review to reaffirm, adjust or replace metrics and see to it that the metrics measured are always optimal for achieving the missions for which they are aligned.
  • Reviewed Business requirements and prepared the data and the reports as per the requirements.
  • Developed various types of charts using SSRS to provide better visualization and to extract the knowledge from the data.
  • Created Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports using SSRS.
  • Deployed and configured SSRS reports in SQL Reporting Services Server.
  • Guided end users to interact with reports to find insights.

Environment: Visual studio 2010, MSSQL Server 2008, MS Excel

Confidential, IL

BI Developer

Responsibilities:

  • Effectively Involved in gathering the requirements of the project and analyzing them. And interacted with the client to analyze requirements in-depth.
  • Extracted data from various sources and performed data joins and data blending.
  • Developed crystal reports based on the business requirement.
  • Created different type of charts Like tabular, matrix, list, bar, pie charts.
  • Created worksheets and dashboards using custom queries and multiple tables.
  • Developed interactive reports using Cascading parameters, Embedded reports and bookmarks.
  • Created templates in SSRS, placed into the directory and modified the templates as per requirement.
  • Validated the data for each report and reviewed the reports before deploying.
  • Executed and tested required queries and reports before publishing.
  • Deployed reports on to the server.
  • Designed OLAP cube(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems to meet reporting requirements.

Environment: Visual studio 2010,2012, MS Office Suite, SQL Server 2008, MS Excel

Confidential

SQL Developer

Responsibilities:

  • Understand the business requirement document and supported team in designing database model.
  • Created queries to store the application’s data into the database tables.
  • Involved in developing conceptual and logical data base model to visualize database structure.
  • Created database triggers for automation with the help of stored procedures for logging and storing information on table access, imposing security authorizations and preventing invalid transactions.
  • Created indexes to improve database performance.
  • Reviewed the query performance and to optimize the code.

Environment: SQL Server 2008, Share Point, MS Excel 2008

Hire Now