Nikhil Dsouza

562-***-**** adc9na@r.postjobfree.com

PROFESSIONAL SYNOPSIS

Highly analytical and detail-oriented Business Intelligence Analyst with strong dashboard design experience and data visualization best practices. Expertise in creating custom automated dashboards and reports for internal and external clients to determine and analyze key performance indicators. TECHNICAL SKILLS

• Microsoft SQL Server • Tableau, Power BI • Microsoft Office Suite

• Zoho CRM, Agile, SDLC • Visio, Jira, Lucidchart • Gap analysis

• Business process mapping • Workflow analysis • SSRS, SSAS, SSIS

• Oracle SQL, PL/SQL • PHP, Python • HTML, CSS

EXPERIENCE

Business Intelligence Analyst

United Healthcare

November 2016-Present

Tableau (BI) Experience: 4 years (Work Sample: Tableau Dashboard)

• Designed and developed interactive dashboards for companywide weekly business performance reviews

• Expert in geographical heat mapping to identify gaps in network and suggest corrective actions

• Automating reports for external stakeholders via Tableau Server and providing visualizations for external RFP’s

• Generated reports triggering KPI alerts to end users via email notifications

• Tableau integration with Relational Databases and Microsoft Office applications for companywide reporting

• Fine-tuned SQL queries to maximize performance and provide flexibility in dashboard creation

• Developed financial reports to identify trends, variance, forecast and dimensional drill downs

• Created parameters, action filters, table calculations and calculated sets to improve efficiency for custom reporting

• Tableau server maintenance along with user permissions & roles, subscriptions, performance monitoring, scalability and data access using refreshed extracts and live connections Microsoft SQL Experience: 4 years

• Experience writing complex SQL queries and views to conduct analysis and validate report accuracy

• Created SSIS packages to extract, manipulate and clean data from different sources and load them into SQL tables and spreadsheets for automated reporting

• Created user defined functions, triggers, unions, join functions and stored procedures to manage back end validations when transferring data to production

• Performed sophisticated ad-hoc and ongoing custom analysis against medical data to support business stakeholders

• Wrote and automated tools and scripts to increase departmental efficiency and automate repeatable tasks

• Used execution plan to view index performance and improve processing time for live Tableau and Excel reports

• Experience importing, exporting and manipulating large data sets for critical reporting Microsoft Office Suite and CRM Experience: 4 years

• Power Query in Excel to extract data, analyze and perform analysis for ad hoc reporting

• Advanced Excel including pivot table functions, vlookup, index match and complex formulas

• Integrated Access with SQL tables to move data to and from front end user forms

• Developed and streamlined reporting processes for non-technical users using Zoho CRM EDUCATION

Master of Management Information Systems August 2016 Utah State University, Jon M. Huntsman School of Business, Logan, Utah 3.82 GPA Bachelor of Engineering – Information Science & Engineering May 2014 Visvesvaraya Technological University, India

Willing to Relocate