Shuvee Neupane

Power BI / Tableau Developer

Cell # 650-***-****

E-mail: adbnl3@r.postjobfree.com

PROFESSIONAL SUMMARY:

Around 7 years of strong experience in all phases of the life cycle of Requirement gathering, Analysis, Design, Development, Testing, debugging of various Data Warehousing Applications using Power BI, Tableau, ETL Informatica and SSIS

5 years of experience in designing and development of visualization reports using Power BI and Tableau using various relational database including Azure SQL DB.

2+ Experience as report developer using Power BI visualization tool in conjunction with ETL SSIS; designed, developed and published multiple interactive Power BI visualization report/dashboard in Azure environment.

3 years of strong experience in Tableau, designed and developed multiple visualization report and dashboards.

Experience in working with customers to determine their needs, gather, analyze and document requirements, communicate with customers throughout the development cycle, manage customer expectations, resolve issues and provide project status

Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets and Data marts and Data warehouse.

Extensive Experience in integration of various data sources like ORACLE 11g/10g, SQL server 2012/2014 and PostgreSQL 9.3

Superior SQL skills and ability to write and interpret complex SQL statements and also mentor developers on SQL optimization and performance tuning

Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query/ T-SQL /MS excel.

Hands on experience in utilizing Power BI DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.

Heavily used DAX table functions, including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.

Strong experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI and Tableau

Hands-on designing and deploying rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized dashboards using Tableau.

Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Treemaps, etc. using Power BI and Tableau.

Generated context filters and data source filters while handling a large volume of data using Power BI and Tableau.

Involved in creating Filters, quick filters, table calculations, calculated measures and parameters in Power BI.

Coordinate with ETL on MSBI (SSIS) to extract, transform and load data into the target database.

Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.

Knowledge of Hadoop Ecosystem, Hive, and HDFS

Exposure of end to end SDLC and Agile methodology

Extensive experience of providing IT services in Healthcare, Financial, and Banking industries.

Have good problem solving, time management skills, communication skills, self-motivated, ability to work independently or cooperatively in a team and eager to learn.

EDUCATION:

Masters from University of The Cumberlands, Current, Kentucky, USA

Master from National Institute of Technology, 2012, Trichy, India.

TECHNICAL SKILLS:

ETL Tools

Informatica Power Center 9.6.1, MS SSIS

BI Tools

Power BI Desktop (2.5/2.6/2.7), Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop 8.0/9.2 Tableau Server, SQL Server Analysis Services (SSAS).

Data Modeling

ERwin 9.5.2.

Databases

Teradata 15, Oracle /11g/10g, SQL Server 2014/2016, PostgreSQL 9.3

Languages

JSON, PL/SQL C++, C, UNIX Shell Scripting, SQL

Others

MS Word, MS Access, T-SQL, TOAD, SQL Developer, Microsoft Office, Teradata SQL Assistant, Rally, JIRA, Control–M

PROFESSIONAL EXPERIENCE:

Client: Best Buy Co, Inc

Location: Richfield, MN

Duration: Nov 2019 – Till Date

Role: Power BI Developer

Project: Enterprise Customer Care

Best Buy is a popular provider which sells consumer electronics and a variety of related merchandise, including software, video games, music, mobile phones, digital cameras, car stereos and video cameras, in addition to home appliances (washing machines, dryers, and refrigerators), in a non-commissioned sales environment.

Best Buy’s Enterprise Customer Care (ECC) project provides industry-leading, responsive service to accommodate a wide variety of customer requests.

Responsibilities:

Coordinated with business users at various levels and call meetings during the different phases of projects to deliver successfully.

Read data from multi-dimensional cubes through Power BI Reporting Server for creating Dashboards/ Reports.

Migrated reports build in SSRS to Power BI.

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.

Created various views using Power BI (Tree maps, Scatter plot).

Improved performance by identifying the bottlenecks in Source table, recommended for creating index.

Used custom visuals like Power KPI Matrix, Sunburst and KPI Matrix to create custom reports in Power BI.

Conducted user testing and prepared documents for future use.

Environment: Microsoft Power BI Report Server (May 2019), JIRA

Client: Wells Fargo

Location: Minneapolis, MN

Duration: Oct 2017 – znov 2019

Role: Informatica ETL Developer/Data Analyst

Project: Enterprise Customer engagement

Description: Wells Fargo & Company, a diversified financial services company, provides retail, commercial, and corporate banking services to individuals, businesses, and institutions. It operates through three segments: Community Banking, Wholesale Banking, and Wealth and Investment Management.

Use powerful analytics to better serve and engage with customers, build loyalty, and drive revenue. Power BI report and dashboard helping banks effectively utilize customer relationship management (CRM) solutions to acquire new customers, retain existing ones, and maximize customer lifetime value. Customer are accessing powerful analytics to comb through large amounts of data and extract actionable insights about how to increase the profitability of their customers; also enables users to maintain a holistic view of individual customers’ profiles and activities.

Responsibilities:

Actively involved in the Analysis phase of the business requirement and reports/dashboards design.

Coordinated with business users at various levels and call meetings during the different phases of projects to deliver successfully.

Interacted with Business Analyst, Data Modeler and team Members within the organization to understand business processes, implement the logic.

Involved in ETL processes and develop source-to-target data mappings

Coordinated with ETL team on data transformations using SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Analyze source system data to assess data quality. Work with technical and business representatives to determine strategies for handling data anomalies that are identified.

Read data from multiple sources like CSV/SQL Server 2016/AZURE SQL DB through Power BI for creating Dashboards/ Reports.

Generated context filters and data source filters while handling large volume of data.

Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data.

Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.

Have used Z-order to overlap the reports on each other using Power BI.

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.

Created various views using Power BI (Tree maps, Scatter plot).

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.

Created multiple data model and used as a common data source for the reporting purpose.

Used Power BI Gateways to keep the dashboards and reports up to date.

Have refreshed/republish reports and data set manually.

Improved performance by identifying the bottlenecks in Source table, recommended for creating index.

Performed data validation, data profiling, data auditing and data cleansing activities to ensure high quality report deliveries·

In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.

Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.

Performed Data profiling and analysis using complex SQL, data sitting into target tables.

Performed detailed data investigation and analysis of known data quality issues in related databases through SQL

Created effective Test Cases and performed Unit and Integration Testing to ensure the successful UAT.

Prepared user training documented for smooth transaction to support team.

Environment: Microsoft Power BI 2.7x, SSIS, SQL Server 2016, Power BI Service, Power BI Gateway, Power BI Report Server, SQL Server 2014, MySQL, AZURE SQL DB, Advance Excel, SQL, T-SQL, SSIS

Client: Cummins Inc.

Location: Minneapolis, MN

Duration: June 2015 to Sept 2017

Role: Tableau Developer

Project: Sales and Marketing Analysis

Project description: Cummins Inc. designs, manufactures, distributes, and services diesel and natural gas engines, and powertrain-related component products worldwide.

The object of integrated data mart is to enable improved SALES AND MARKETING ANALYSIS report and dashboard to speed up delivery time for quotes and orders by monitoring actual lead times, enforcing business rules, adding triggers to facilitate accuracy, and pursuing up-sell/cross-sell opportunities.

Responsibilities:

Participated in the Design Team and user requirement gathering meetings.

Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the business needs.

Discussed with team to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.

Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.

Participated in building and visualizing dashboards using Tableau Desktop 9.0

Co-ordinated with ETL Informatica team to create and manipulate source and target data mappings, ETL mapping transformations.

Used Tableau to generate Tableau combination dashboards and wrote SQL Queries for testing the tableau report/dashboard.

Implemented Extract filters, Calculation Filters, Context filters, Data source filters to exclude certain values or a range of values as well as batter performance.

Created story using sequence of worksheets to convey information using Tableau.

In Tableau dashboards used different bars and charts like stack bars, bar graphs, scattered plots, Gantt charts.

Blended data from multiple sources like SQL Server 2014, PostgreSQL, oracle 10g, Teradata into one report by selecting primary keys from each database for data validation.

Have done advance analysis, through field calculation, table calculation as well as also involved in forecast analysis.

Used different functions like number, string, date, Type conversions, aggregate functions.

Created performance recording to improve Tableau’s performance.

Effectively used data blending feature in tableau desktop 9.0.

Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

Worked closely with the business analyst’s and Production Support to resolve any JIRA issue related to production reports.

Co-ordinated offshore team on daily basis to leverage faster development.

Environment Tableau 9.1(Tableau Desktop, Tableau Server, Tableau online), MS Office Suite, Informatica PowerCenter 9.0.1, SQL, Oracle 11g, PostgreSQL 9.3, TOAD, Control M, Shell Scripting

Client: Cigna Corporation

Location: Denver, CO

Duration: Jan 2015- June 2015

Role: Tableau Developer

Project: Fraud and Abuse Analysis

Project Description: Cigna Corporation, a health service organization, provides insurance and related products and services in the United States and internationally. FRAUD AND ABUSE ANALYSIS is a data discovery application for healthcare payers to identify high-cost and non-compliant providers, and to identify hospital readmission costs resulting from non-adherence to medication. Claims costs are continuing to rise and healthcare payers need to proactively reduce costs by managing clinical outcomes for members.

Tableau reports and Dashboard capabilities helped healthcare payers identify providers who are charging above normal rates or excessively billing expensive procedures. This dashboard application contains both procedure and payments information for a specific hospital and compares submitted charges against paid charges for each procedure. Using interactive filters, payers are able to isolate the problem areas and identify providers who need to be evaluated in more detail.

Responsibilities:

Worked with Business users to analyze the data specifications and developed relationship between source data and worked with data modeler to build tables from different source data.

Developed custom SQL queries to minimize the data to improve the performance in Tableau.

Experience in designing and development of Tableau visualization solutions and Created Business Requirement documents and plans for creating dashboards.

Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.

Defined best practices for Tableau report development and effectively used data blending feature in tableau.

Worked with different types visualizations like Combination charts, Map visualizations, Matrixes and tables, Scatter charts Waterfall and funnel charts, Gauges and single-number cards, Z-order, Visual hierarchies and drill-down in the tableau reports.

Used Power Pivot to create powerful data model and created power view for dynamic reports.

Utilized advanced features of Tableau software like link data from different data sources together on one dashboard to filter data in multiple views.

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.

Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.

Environment: Tableau Desktop 8.2, Tableau Server, MS Office Suite, Oracle 10g, T-SQL, Unix, TSQL,

Informatica PowerCenter 9.1, ORACLE 11g, UNIX Shell Programming

Client: Asian Institute of Technology

Location: Thailand

Duration: Jan 2014- November 2014

Role: Research Associate/Data Analyst

Project: Energy Access

Project Description: AIT is an international organization for higher education in Thailand. It specializes in engineering advanced technologies, sustainable development and management and planning.

The project was funded by UNEP where energy access had to be analysed for urban Myanmar. The collected data was cleansed using informatica and analysed using tableau. The dashboards so designed was used to recommend policies to UNEP.

Responsibilities:

Responsible for requirement gathering from business and prepared the requirement specification document and mapping document.

Designed and developed Tableau reports to ensure all the business requirements are met and provide enhanced Solution that meets client needs.

Performance optimization of dashboards with huge volume of data.

Extracting data from different sources connecting them and used the same to create dashboard.

Created data blending in case of merging two different datasets.

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and extracts.

Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes.

Contact this candidate