Rohan J Email & Phone Number

Plano, Texas, United States

• Collaborate with business users and stakeholders to understand data requirements and visualization needs.• Analyse complex healthcare data sets, including Claims, providers, members, and billing data.• Worked with different types of Data sources and performed extensive Data Analysis to identify latest business trends, patterns, and anomalies.• Perform data cleansing, transformation, and manipulation using Power Query and other ETL (Extract, Transform, Load) techniques.• Conduct end-to-end analysis of the data ingestion pipeline, encompassing CloudWatch Jobs, Lambda functions within the underlying Step Functions, Glue Jobs, DynamoDB configuration as well as JSON and control files.• Additionally, create the necessary SQL queries to establish metadata lineage for performing Root cause analysis.• Involved in Monitoring the performance of Power BI reporting solutions and identifying potential bottlenecks or issues and responsible for troubleshooting and resolving any technical problems related to data connections, refresh schedules, or visualization components.• Involved in Documenting data sources, data lineage data mapping, test cases, transformations, data models, and report specifications to ensure clarity and maintainability of the solution.• Provided training and support to end-users and stakeholders on how to use Power BI dashboards and reports effectively for data-driven decision-making.• Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, and Bullets using Power BI.• Created KPIs, Partitions, Perspectives, and Calculated Measures, using DAX queries.• Worked with Deployment pipeline, Row level security, Parameterization, and Workspace management.• Created Page Level Filters, Report Level Filters, and Visual Level Filters in Power BI according to the requirements.• Generated context and data source filters while handling a large volume of data.

India

• Responsible for creating reporting dashboards, and performing data mining and analysis to understand customer purchase behavior.• Created real-time dashboards in Tableau to visualize and monitor key metrics processing using both external and internal data.• Collaborated with the marketing team to analyze marketing campaign data and perform analysis involving segmentation, and cohort analysis.• Designed MySQL table schemas and implemented stored procedures to extract and store customer purchase and session data.• Queried data from MySQL database and validated and detected inconsistent data using Python packages Pandas and Numpy.• Actively involved in designing A/B tests, defining metrics to validate new user interface features, calculating sample size, and checking statistical assumptions for tests.• Performed statistical analysis such as hypothesis testing, regression analysis, confidence interval and P-value calculation using R to find insights to increase click through rate and sales and build web applications for ad-hoc interactive dashboard.• Performed Exploratory Data Analysis to identify trends using Tableau and Python.• Wrote scripts to store data into Hadoop HDFS from various sources including AWS S3, AWS RDS and Web API and NoSQL Database MongoDB.• Deployed Big Data tool Spark and Hive to analyse large datasets up to 2TB stored in Hadoop HSDF, including performing filtering and aggregation using Spark SQL based on Spark Data Frame.• Developed Python scripts to do data preprocessing for predictive models including missing value.

India

• Worked with different team's clients, analytics, data sources, QA, and visualization.• Worked in an agile process having expertise in the life cycle of a project from start to end.• Created data warehouse and data marts from scratch based on data structures and reporting.needs.• Worked on writing ad hoc SQL scripts which are required for reporting purposes. • Worked on creating basic dashboards in Tableau connected to Azure SQL database for client reporting.• Worked on user management for Power BI. Sharing the dashboard access for power bi online.• Worked on Power BI dashboards and ad hoc DAX queries for Power BI.• Extensive back-end support for many various reports on Tableau and Power BI.• Created store procedures, functions, triggers, indexes, and views based on data processing and data.cleansing.• Created various SSIS packages for data movements and transformations. Worked on Python code to load data from Google buckets to big query tables, used data flow for ELT (Extract Load Transform) in Big Query.• Experienced in Developing PL/SQL - Procedures, Functions, SQL Scripts, and Database Triggers to populate the data by applying business logic.• Extensive knowledge in developing PL/SQL codes using Oracle 11g.• Create and review SSAS tabular cubes for consumption as a data source for reports, Dashboards, and Pivot tables.• Worked on creating multiple databases from scratch.• Worked on Azure SQL data warehouse and database development. Experienced user of PL/SQL for development of server-end program units as well as reusable codes using Procedures, and functions and worked on ad hoc change tickets.

Bachelor Of Technology - Btech, Computer Science

Master Of Science - Ms, Data Analytics