N Jaswanth - Sr BI Consultant at Optum

Disclaimer: This information was obtained from publicly available sources online and is believed to be accurate at the time of publication. Valimates collects this information with proprietary technology and cannot guarantee the accuracy or completeness of the data. The purpose of the data is to inform the reader about the expertise of the individual and should not be used for any other purpose. Valimates does not have any affiliation with the individual.

N Jaswanth Sr BI Consultant at Optum

Claim Profile Update Profile Delete Profile

N. Jaswanth is an impressive Sr BI Consultant with over 11 years of experience in Business Intelligence and Data Analysis. They have a strong expertise in Report Design, Dashboard development using Tableau, and SAS Reporting. They also have knowledge in other Business Intelligence/Business Analytics software like SAP BO, MS BI (SSAS, SSRS), and Data warehouse Concepts.

N. Jaswanth is highly skilled in Power BI and has experience in designing Interactive Reports using Power Query, Power Pivot, and Power View. They have a track record of gathering Business Requirements, Analysis, Design, Development, Testing, Implementations, and Documentation in Data Warehouse/Data Marts and Business Intelligence projects. Additionally, they have extensive experience in Designing, Administration, Analysis, and Management in the Business Intelligence Data warehousing domain.

Moreover, N. Jaswanth has a strong background in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS). They are highly proficient in ETL-Extraction Transformation Loading, Data warehousing, Operational Data Store concepts, data marts, and OLAP-Online Analytical Processing technologies.

Overall, N. Jaswanth's expertise and experience in Business Intelligence and Data Analysis make them a valuable asset with a strong track record of success in the field.

More about this expert

Full name: N Jaswanth
Location: United States
Title: Sr BI Consultant
Company: Optum
Industry: Wellness and Fitness Services
LinkedIn profile: https://www.linkedin.com/in/n-jaswanth/
LinkedIn Connections: 1123
Summary: 11+ years of Experience in Business Intelligence and Data Analysis including experience as Tableau developer. Expertise in Report Design, Dashboard development using Tableau, and SAS Reporting. Knowledge on Business Intelligence/Business Analytics software like SAP BO, MS BI (SSAS, SSRS) and Data warehouse Concepts. Power BI experience in designing Interactive Reports using Power Query, Power Pivot, Power View. Experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence. Proficient in Designing, Administration, Analysis, Management in the Business Intelligence Data warehousing, Client Server Technologies, Web-based Applications and Databases Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs. Experience in publishing Power BI Desktop reports created in Report view to the Power BI service. Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries. MS-Business Intelligence experience using SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS). Expert in ETL-Extraction Transformation Loading, Data warehousing, Operational Data Store concepts, data marts and OLAP-Online Analytical Processing technologies. Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools. Building reports by connecting against Single Table, Multiple Tables and Custom SQL. Highly proficient in the use of SQL and PL/SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
Skills: User Acceptance Testing SQL DB2

Education

KL University: Bachelor's degree
Field of study: Computer Science
Wichita State University: Master's degree
Field of study: Computer Science

Positions

Optum: Sr BI Consultant
Sep 2023 - Present

• Gathering requirements for Reports and Dashboards and planning data tables structures for Database to automate and provide procedures for self-reporting out of Tableau / SSRS / Power BI.
• Analyzing various database applications and analyzing for the business teams suggest effective migrations strategies to a single database for faster reporting.
• Used various sources to pull data into Power BI such as SQL Server, oracle. Involved in installation of Power BI Report Server. Developed reports to visually explore data and create an interactive report Excel and Power BI.
• Using a query editor in Power BI performed certain operations like fetching data from different files.
• Created groups, content packs.
• Created the KPI to show the difference between actual and forecast data. Working with import and direct query, creating custom tables in the Power BI.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as
per business requirements.
• Involved in Report generation using SSRS and Excel services, Power Pivot and deployed them on
SharePoint Server.
• Automated manual report running process to achieve self-reporting out of tableau.
• Created Advanced Drill down on Provider and Member claims, Enrollment, Medicaid, Wellness and Audit related items analysis Dashboards using Tableau.
• Worked on Informatica Designer, Workflow Manager and Workflow Monitor for loading BI tables.
• Validate data transformations and perform End-to-End data validation for BI layer Tables.
• Develop and execute plan for data profiling, Unit Testing, Performance testing, SIT, UAT for BI Tables and Tableau OPA (Optum Performance Analytics) reports.
• Gathered ETL test cases from QA team and automated in tableau.
Bayer HealthCare Diabetes Care Pittsburgh, Pennsylvania, United States · Remote: Power BI Lead Consultant/Data Consultant
Aug 2020 - Sep 2023

• Developed Power BI and migrated the existing standard scheduled reports created in Facets Rubi to Power BI Desktop; built the models within Power BI developed enhanced existing reports.
• Data cleaning and integration with other data sources within Power BI and developed Dashboard, Utilized DAX (Data Analysis Expressions) to recreate the access / Excel VBA logics and formulas.
• Developed Calculated Columns, Tables measures rewriting mostly from Excel reports & Developed KPIs. Also, worked on and created time calculations.
• Utilized existing SSAS cubes and created live connections and deployed the Dashboards to Power BI app server.
• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Created Database Objects – Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2005/2008
Aspen Dental Chicago, Illinois, United States · Remote: Power BI Developer/ Data Analyst
Sep 2018 - Aug 2020

• Performed Data wrangling and cleaning methods such melting, pivot and merging data sets, removing lurking variables by using Python for making data easy to split in training, testing and validation data sets.
• Developed reports through SQL, ETL-SSIS, SSAS and excel after acquiring, cleaning, and analyzing data from multiple sources.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of reports using Pivot/Unpivot in T-SQL.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created Crosstab, Drill-down, Drill-through and Sub drill down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly, and quarterly Reports including status.
• Used Microsoft Power BI for creating dashboards, exporting, and importing reports and for streaming dataset.
• Created Custom workflows, custom screens, and custom fields on Jira.
Target Minneapolis, Minnesota, United States: Power BI Developer
Jun 2016 - Aug 2018

• Developed Power BI Reports; migrated the existing standard scheduled reports created in Facets Rubi to Power BI Desktop. Initial phase of this project Data was accessed from Facets Reports DW using the on-premises import mode; build the models within Power BI developed enhanced existing reports.
• Data cleaning and integration with other data sources within Power BI and developed Dashboard, Utilized DAX (Data Analysis Expressions) to recreate the access / Excel VBA logics and formulas. Developed Calculated Columns, Tables measures rewriting mostly from Excel reports & Developed KPIs. Also, worked on and created time calculations.
• Worked on sensitive data and had PHI/PII information, implemented row level security & also had to work with Power BI server administrator and configuring the Power BI gateway for on premise data refresh and schedule data refresh in Power BI.
• Utilized existing SSAS cubes and created live connections and deployed the Dashboards to Power BI app server.
• Build and scheduled SSRS reports and pinned these reports to Power BI Dashboards.
JPMorgan Chase & Co. New York, United States: Tableau Developer / Data Analyst
Feb 2014 - May 2016

• Developed dashboard design and layout as it pertains to business flow, performance, and functionality.
• Coordinated with DBA in creating and managing tables, indexes, triggers, database links and privileges.
• Gathered data and documented it for further reference and designed Database using Erwin data modeler.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Scheduled data refresh on Tableau Server on daily, weekly and monthly basis to ensure that the views and dashboards were showing up updated data.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Using advanced date calculations, aggregate calculations, user-calculations, table-calculations, logical-calculations, string-calculations, type-conversion and number calculations.
• Using the date month, logic statements and using several Calculation Types like Type Conversions and Date Calculations, Quick Table Calculations.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.
• Created Tabular Matrix reports, Charts, and graphs as per customer requirements Using SSRS.
• Made complex charts like Spider chart and funnel chart to better visualize the data.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.