* Approx. 10 years of experience in Business Intelligence, Business Analytics and Data Analytics
within finance, sales and marketing, healthcare, and Manufacturing industries.
* Expertise in working with various versions of Tableau including the latest 2022.1,2021.2.3.4, 2019.1 , 2018, 10.5, 10.4 and the previous versions 10.x, 9.x, 8.x.
* Skilled in Power BI Desktop, Power BI Service (Power BI Online), Power BI Mobile, DAX (Data Analysis Expressions), Power BI Embedded, Power BI Report Server, Power BI Administration in delivering BI report to users across the organization.
* Proficient in using Cognos Business Intelligence Suite, including Cognos Analytics, Cognos Framework Manager, and Cognos Report Studio to design, develop, and deliver interactive and visually appealing reports and dashboards.
* Expertise in working with multiple Business intelligence tools like Tableau, Power BI, Looker.* Studied and analyzed applications and brainstormed with the business team for gathering
effective requirements for the system.
* Followed SCRUM (Agile) methodology and developed dashboards with value-added products.
* Involved in creating views, stored procedures, and custom SQL queries to import data from SQL server to Tableau.
* Created Advanced Analytics using SQL Server, Oracle, Snowflake, Alteryx integration with
Tableau.
* Created embedded, interactive, and hyper link Dashboards like Prescribing provider profile,
Payments by Procedure codes in Tableau / Power BI.
* Created Dashboards to allow the users to dynamically interact with the data to the lowest
level of granularity.
* Created claim detail and Claim header reports with over 3 billion records with in 15 Secs SLA
* Provided Tableau desktop workshop training for end users.
* Used Oracle, SQL server as data sources for designing Tableau Reports and Dashboards. Provide
customer support to Tableau users and Wrote Custom SQL to support business requirements.
* Created crosstabs for displaying underlying data based on various graphs and charts for future
data analysis.
* Worked in the application UI to present to the end-users with Tableau dashboards and
visualizations on multiple platforms.
* Migration of Redshifts, Salesforce data to SQL or Create Tableau Data flows using Tableau Data
Prep to facilitate dashboards data sources internally.
* Created an Advanced workflow in Alteryx using Multiple Data sources to reconciliations, Clean
and Modify Data.
* Analyzing reports run out of Teradata, MS access, Cognos and other legacy platforms like EDW,
Radar and plan their transition to SQL database and assess current database capability and
initiate changes to database architecture to accommodate self-service.
* Provide support to Cognos BI reports migration to Tableau and Power BI. Conducted engaging training sessions for end-users, promoting BI tool adoption and empowering teams to leverage Cognos BI to its fullest potential.
* Identified performance bottlenecks in Cognos reports and applied optimization techniques to
improve report execution times.
* Proficient in gathering and translating business requirements into actionable Cognos BI solutions, ensuring alignment with strategic objectives and end-user needs.
* Implemented data security measures in Cognos BI to control user access and ensure data confidentiality.
* Created Data Connections, Published on Tableau Server for usage with Operational or monitoring Dashboards.
* Created Advanced Analytics using SQL Server, Oracle, Snowflake, Alteryx integration with Tableau.
* Analyzing data issues within reports by designing and building DAX queries sourced from OLAP (online analytical processing) cubes in Power bi query editor, applying data mining algorithms on source database to have minimum data processing on Power BI azure server side.
* Designed and developed MOLAP and ROLAP cubes with SSAS. Created a report model on SSAS cubes. Experienced in Connecting SSAS with either SSRS or Excel tables.
* Expertise in writing custom SAS macros to streamline data analysis processes, reducing project turnaround time.
* Conducted hypothesis testing and regression analysis in SAS, providing critical insights into the effectiveness of marketing campaigns.
* Assisted in data management tasks, including data cleaning and manipulation, using SAS DATA step and PROC SQL.
* Designed and executed complex analysis models in SAS to assess patient outcomes in a healthcare wellness project, providing critical insights for healthcare providers / executives.
* Implemented several DAX functions for various fact calculations for efficient data visualization