BI Developer, Tableau, Power BI,Reporting

Santosh Kumar

Email- *****************@*****.***

Contact- 832-***-****

LinkedIn- https://www.linkedin.com/in/santosh-kumar-185a99296/

SUMMARY:

Over 10+ years of Experience in Power BI, Tableau and Data Analyst roles with strong BI Developer within the IT industries in Analytics, Visualization, Data modeling, Reporting.

Strong IT experience as a MS SQL Server 2005/2008 and BI tools SSIS, and SSRS.

Extensive experience working with Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader.

Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices.

Experience in Tableau report developing, testing and deploying reporting solutions using Tableau Server.

Hands on experience in development using Power BI and Experience in Power BI Desktop and experience on understanding DAX Functions in Power BI.

Proficient in DAX (Data Analysis Expressions) for creating calculated columns, measures, and advanced analytical calculations in Power BI.

Defined and documented detailed ETL, Informatica specifications for Data Warehouse interface, extracts, staging areas, atomic areas, and mart database environments

Expertise in Automated back-end retrieval, Data Manipulation, Curing, quality control and Anomaly Detection using functional programming in Python & R.

Experience analyzing diverse healthcare data sets, including clinical records, medical claims, and patient outcomes, to inform strategic decision-making

Experience in handling large amounts of data for Data Cleansing, creating and editing SQL queries for data analysis.

Good SQL reporting skills with the ability to create SQL views and write SQL queries.

Explore data in a Variety of ways and across multiple visualizations using Power BI.

Expertise in building visualization using Power BI, Power View, Power Query.

Used python to extract financial data from various sources and integrated them into one single data set.

Extensive experience in developing and implementing Microsoft SQL Server Integration Services (SSIS), Reporting Services

Extensive experience in data warehouse design, ETL development, and SQL query optimization.

Developed Calculated Columns and Measures using DAX in Power BI to satisfy the business requirements.

Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.

Experienced in Creating DAX Expressions create Date to yearly columns and implement partitions in Tabular Models.

Strong understanding of DAX evaluation contexts (row, filter, context transition) to build efficient data models.

Created hierarchical, cumulative, and percentage-based calculations in Power BI dashboards for better business insights.

Hands-on-experience with Pandas, SciPy and NumPy packages in Python for data analytics.

Large data sets manipulation, data cleaning, quality control, and data management

Data Mining models development using Decision Trees, Random Forest in Python and MARS (Multivariate adaptive regression spline) in Python & Alteryx.

Having excellent communication skills, analytical skills, and an understanding of business requirements in various domains.

Actively participated in team building and led many operations for maintaining a healthy work environment.

EDUCATION:

Bachelors in Commerce specialization in Finance from OSMANIA UNIVERSITY, India 2012

Masters of Science. In Business Analytics, LEWIS UNIVERSITY, ROMEOVILLE, IL 2014

TECHNICAL SKILLS:

BI/Reporting Tools:

Tableau,, Power BI, Tableau desktop, Tableau Online, Alteryx, Tableau Server

Operating System

Windows, Linux, Unix

SDLC Methodologies

Waterfall, Agile, Scrum, Team Management

Data Visualization / Analytical Tools

PowerBI, Tableau, Advanced Excel, Microsoft Office Suite (Word, PowerPoint, Excel, Edge etc.), SharePoint, JIRA

Databases

Big Query, MS SQL Server, PostgreSQL

ETL and Other Tools

Microsoft SQL Server Integration Services (SSIS), Informatica, Alteryx Salesforce CRM, GIS Tools, Crystal Reports

Cloud Technologies

AWS, Azure, Snowflake

API Integration

REST APIs, SOAP APIs, OAuth, JSON

PROFESSIONAL EXPERIENCE:

STATE OF FL- FDOT (REMOTE) SEPT 2023 - PRESENT

Senior BI Consultant

Role- Responsible

Developed and maintained interactive dashboards and reports in Power BI, providing key insights for MDOT's project management and operational efficiency.

Integrated and transformed complex datasets from multiple sources, including SQL Server, Excel, and SharePoint, to support data-driven decision-making across MDOT.

Developed and deployed complex Power BI reports and dashboards, integrating data from various Azure-based data sources, including Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics

Optimized Power BI reports by implementing DAX measures, calculated columns, and relationships, reducing report load.

Implemented a self-service BI strategy using Power BI and Azure, enabling MDOT departments to independently create and manage their own reports while maintaining centralized data governance.

Collaborated with stakeholders across various MDOT departments to gather requirements and translate them into effective Power BI visualizations and dashboards.

Created custom Power BI visuals to meet unique MDOT needs, enhancing the usability and impact of reports.

Designed and implemented data models in Power BI, improving data integrity and ensuring accurate reporting across multiple projects.

Integrated Power BI with Azure AD for single sign-on (SSO) authentication, improving user access management and security.

Conducted data validation and quality assurance on Power BI reports, ensuring accuracy and consistency of critical transportation data.

Automated data refresh processes in Power BI using Azure Automation and PowerShell, ensuring up-to-date information is available to decision-makers.

Optimized data models by normalizing tables and reducing redundancy, improving the performance and scalability of Power BI reports.

Monitored and managed Power BI Service workspaces, ensuring the security and availability of MD DOT's reporting environment.

Collaborated with data engineering teams to design and implement data models in Azure Synapse Analytics, enabling advanced analytics and reporting capabilities in Power BI.

Implemented advanced analytics using Power BI, including trend analysis and forecasting, to support MD DOT's strategic planning efforts.

Developed interactive dashboards for real-time monitoring of transportation project statuses, enabling proactive decision-making.

CVS Health AZ (REMOTE) MAY 2022 - APR 2023

Senior BI Consultant

Role- Responsible

Played an active role during the requirements gathering, analyzing and designing of the system.

Independently collected daily data on COVID-19 cases and deaths in Iowa and Kansas from public websites with Beautiful Soup library in Python

Collaboratively created webpages for Covid-19 website by mapping data and developing one wireframe, two user-journey maps and two dashboards’ prototypes

Performed storytelling in Tableau after pre-processing Covid-19 datasets to aid the web design team

Worked with Data architect and business users to understand business processes, document project requirements and translate them into functional specifications for BI reports and applications.

Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the application.

Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.

Worked of monitoring, logging and cost management tools that integrate with AWS.

Used AWS Glue for creating several ETL jobs and loading data sets into tables and connecting to Tableau.

Worked on AWS migration from on-prem Tableau server with setup of EC2, EMR, S3 and EBS.

Connected to the AWS Redshift and Snowflake directly from Tableau to access cloud data warehouse and quickly perform visual analysis

Developed different kind of Tableau reports such a Sub Reports, Charts, Matrix reports, Linked reports.

Highly responsible for development and management of SSRS projects like creating drill through reports through Linked reports.

Created individual SSIS packages to load dimensions, fact tables then created ETL Master package to load data in Data mart

Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, Cache, for each loop, multi cast, Derived column, Data conversions.

Created scripts and Scheduled SQL jobs to facilitate data processing, monitoring and alerting.

Designed and developed Dashboards based on the Client requirement in timely manner.

Created extensive joins for data blending from several different data sources.

Translated business logic and rules from the existing system (SQL) to Alteryx.

Created Alteryx macros in Alteryx designer for reporting and data manipulation.

Analyzed data using SQL, R, Python, Apache Spark and present analytical reports to management and technical teams.

Worked with various datasets and analyzed data using python/R and used different regression models for datasets.

Developed responsive and accessible applications, ensuring compatibility across different devices and user groups.

CAPITALONE BANK VA (REMOTE) NOV 2021- APR 2022

Senior Power BI Developer/Data Analyst

Role- Responsible for designing and development of POWER BI reports and dashboards and the relational data sources from the warehouse.

Worked with various datasets and analyzed data using python/R and used different regression models for datasets.

Design Tableau visual analytics and development of various dashboards, reports utilizing advanced Tableau Visualizations like Waterfall Charts, Funnel Charts, Pareto Charts, Dual Axis, Blended Axes, Scatter Plots, Box Plot, Bullet Chart, Gantt Chart, Heat Map, KPI Charts using Oracle, SQL Server, Excel as Data source.

Implemented multiple charts together in a single Tableau Report together to add more valuable information at single glance includes Pie charts, donut charts, bar graphs, trend lines along with Future forecasting.

Gathering the Business requirements from Business Analyst and product owner and creating the requirements file.

Created, altered tables and schemas in Redshift database as per the business requirements.

Worked on data load into the Redshift tables at regular intervals from S3 data buckets using SQL scripts. Loaded csv files to the S3 buckets.

Analyzed large data sets to find any pattern in the data by extracting the data, cleaning the outliers using pandas and publishing them into tables and graphs.

Worked on different data formats such as json, XML and performed analysis on Python.

Stored and retrieved data from Redshift, Snowflake using databricks.

Developed and performed data quality checks using the SQL scripts. Created functions, triggers to notify the errors in the data quality checks.

Data manipulation and data aggregation from different sources using SQL workbench and Tableau desktop.

Experience in analyzing huge dataset in AWS Redshift as well as on Snowflake.

Developed complex metrics required for daily business reports in Redshift SQL.

Worked on data verification and validation to evaluate the data generated monthly and quarterly as per internal loss team directions.

Involved in reviewing business requirements and analyzing data sources from Excel/Redshift, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Developed Tableau report layouts as per requirements and implementing final development using R shiny and R studio.

KEMPER INSURANCE St. Louis MO (REMOTE) May 2020 - OCT 2021

BI Developer-Reporting Analyst

Kemper Insurance exemplifies how leveraging BI tools and data reporting can drive operational excellence, enhance customer satisfaction and support strategic decision-making within Life insurance and Auto insurance industry.

Develop a BI dashboard to consolidate and analyze data from various sources within Kemper Insurance. The dashboard aims to provide actionable insights for improving operational efficiency, optimizing claims processing, and enhancing customer satisfaction.

Integrate data from internal systems such as policy management, claims processing, customer relationship management (CRM), and financial transactions. Created productive documents which will be used by rest of the team to have better understanding of the related system, Salesforce.com CRM.

Integrated Salesforce with third party applications using REST

Provided the migration strategy from SAP CRM to Salesforce Cloud CRM platform

Include external data sources like weather patterns (for claims related to weather events) and demographic data (for customer segmentation).

Visualize key metrics related to claims processing times, including average processing time per claim, time taken for approval/rejection, and bottlenecks in the process.

Implement drill-down capabilities to identify specific claims categories (e.g., auto, property) or regions with longer processing times. Analyze customer data to segment policyholders based on demographics, policy types, claims history, and customer behavior.

Generate automated reports and scheduled updates for stakeholders, providing real-time insights into operational performance and customer satisfaction.

Preparing dashboards and analyzing trends to aid in targeting and the development of new business opportunities.

Analyzing huge data from multiple sources to formulate and develop insights to a day-to-day basis.

Gathering data, analyzes trends, proactively identifying variances to forecast and automate existing dashboards.

Ensuring that manually updated dashboards are published on a daily, weekly and monthly basis for use by the sales and marketing organization.

Organized dashboards in PowerBI to analyze the revenue, and expense over various attributes of employee, project, time and location dimensions.

Building, and publishing customized interactive reports and dashboards, report scheduling using PowerBI server.

Developed dashboards for Real-time view of issues impacting results and drill down details to help identify the root cause.

Design, development, and deployment of PowerBI reports on PowerBI Online

Designed, developed and tested various PowerBI visualization for the dashboard and ad-hoc reporting solutions.

Involved in writing QA test cases for the PowerBI dashboards.

Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks, and Incremental Refresh for the weekly and monthly dashboard reports on PowerBI Server.

Analyzed the data using statistical features in PowerBI to develop Trend Analysis reports.

Monitored ETL Daily Jobs and reported to Source teams if any issues emerged with the upstream data.

Debugged the issues by analysing reports and ETL logic and providing RCA for the issue.

Streamlining quality reporting processes for sales adherence.

Designed and Developed ETL workflows for datasets in Snowflake.

Federal Reserve Bank of Cleveland OH July 2018 – Mar 2020

Sr. BI Data Analyst

Role and Responsibility

Leveraged Power BI to develop interactive dashboards and reports, providing actionable insights into key performance indicators (KPIs) for various departments within Federal Reserve Bank.

Collaborated with stakeholders to understand their reporting needs and translate requirements into Power BI solutions, enhancing data-driven decision-making processes.

Designed and implemented data models in Power BI, integrating data from multiple sources including SQL databases, Excel files, and cloud-based applications.

Conducted user training sessions to educate stakeholders on how to leverage Power Apps for data entry, editing, and collaboration within the Power BI environment.

Integrated Power BI reports into Power Apps interfaces, allowing users to visualize and analyze data directly within their workflow for enhanced decision-making.

Conducted thorough data analysis using Power BI to identify trends, patterns, and anomalies, facilitating proactive decision-making and risk management strategies.

Automated repetitive reporting tasks by creating scheduled data refreshes and developing Power BI templates, increasing operational efficiency and reducing manual effort.

Designed and implemented Power Apps forms to capture and input data seamlessly into Power BI datasets, improving data accuracy and completeness.

Provided training and support to end-users on Power BI functionalities, ensuring widespread adoption and maximizing the utility of reporting tools across the organization.

Implemented advanced analytics features in Power BI, such as predictive modeling and clustering, to uncover hidden insights and drive strategic initiatives.

Leveraged Power Apps connectors to integrate external data sources with Power BI, enabling comprehensive data analysis and reporting.

Worked closely with IT teams to optimize data infrastructure and ensure seamless integration between Power BI and other business systems.

Collaborated with business stakeholders to gather requirements and design Power Apps solutions tailored to specific data analysis and reporting needs in Power BI.

Acted as a subject matter expert on Power BI best practices and industry trends, staying abreast of new features and functionalities to continuously improve reporting capabilities.

Civic Financial NY AUG 2015 – APRIL 2018

Data Analyst

Role- Was involved in a combination of skills in data analysis, statistical modeling, programming (e.g., using Python, R, or SQL), and domain knowledge in finance and economics.

Work closely with development teams to ensure that technical solutions meet business needs and are delivered on time and within budget.

Developing models to assess financial risks associated with investments or portfolios.

Evaluating the financial health of companies by analyzing income statements, balance sheets, and cash flow statements. Key metrics might include profitability ratios, liquidity ratios, and leverage ratios.

Applying data analytics to detect anomalies or suspicious patterns in financial transactions that may indicate fraud or compliance issues.

Providing clear and final report after analysing in Civic financial documentation for finance teams to implement.

Creating financial dashboards in Tableau can be highly effective for visualizing and analyzing key financial metrics.

Visualize cash inflows and outflows using waterfall charts or stacked bar charts using Tableau.

Organized calls with Clients and Stakeholders and gathered all the Business Requirements and converted them to technical requirements using Excel, Microsoft Word, Visio and Tableau.

Organized various Knowledge Transfer Sessions to new employees on customer handling and client retention.

Performed data integrity checks, data cleaning, exploratory analysis and feature engineering using R and python.

Used R, Python and tableau to develop a variety of models and algorithms for analytic purposes.

Used Python and R to manipulate the data according to the requirement.

Used python to extract financial data from various sources and integrated them into one single data set.

Help write and optimize in-application SQL statements.

Ensure performance, security, and availability of databases.

Design and develop OLAP cubes for multi-dimensional data.

Created Packages for loading mappings into Tables

CATERPILLAR CHICAGO IL May 2014 – July 2015

BI ANALYST (DWH and Supply-chain)

As a leading global aerospace company, CAT develops, manufactures and services commercial airplanes, defense products and space systems for customers in more than 150 countries. Responsible for design and implementation of advanced Business Intelligence solutions, including information models, dashboards, metrics, and reports.

Develop data solutions end-to-end, from gathering requirements from business stakeholders to partnering with Data team and other analysts to implement

Define, instrument, and maintain new and existing business KPIs from scratch, leveraging SQL queries and beyond

Prepares data for analysis, e.g., cleansing, conditioning, transforming, modelling, identifying new feature variables and handling multi-variate data

Monitors production and deployment, prepares decision support visualizations and reports, algorithms, models, dashboards using Tableau and MicroStrategy tools.

Involved in ETL applications, data feeding, cleansing, archiving and re-modelling.

Created, Configured, and Fine-tuned ETL workflows designed in MS SQL Server Integration Services (SSIS).

Involved in ETL applications, data feeding, cleansing, archiving, and re-modelling.

Connected to the AWS Redshift and Snowflake directly from Tableau to access cloud data warehouse and quickly perform visual analysis

Worked on CAT Data Warehouse processes and Data Modelling concepts with star and snowflake data models

Execute the analytics roadmap for audit, which includes improving audit department efficiency, leveraging tools like Tableau, R, and Python.

Performed root cause analysis to improve efficiency and shared the insights with the team.

Supported web analytics packages and data warehouse operations.

Contact this candidate