Rohan J Email and Phone Number
• I have 5 Years of industrial working experience focused on big data analysis, data mining, statistical inference, machine learning, data visualization, and ETL data pipelines.• Solid working experience with SQL including MySQL and MS SQL Server. • Strongly skilled in writing stored procedures, triggers, and complex queries containing multiple joins, subqueries, and window functions to create reports and perform analysis.• Worked on creating dashboards in Tableau for reporting and data visualization, and guided business decision-making for multiple stakeholders.• Worked on developing Python script for the whole data science project life cycle including data acquisition, data cleaning, data exploration, and data modeling. • Hand-on experience performing statistical analysis, causal inference, and statistical modeling in R and Python.• Experience working with NoSQL databases and big data tools including Hadoop, Hive, and Spark• Built ETL pipelines to extract, transform, and load into analytical databases, schedule, and automated pipelines using Apache Airflow.• Solid experience working with cloud platforms such as AWS and Google Cloud.• Experience working with Shell Scripting in operating systems such as Linux and version-control tools such as Git.• Strong experience in SQL database design & development, architecture, and data modeling (conceptual, logical, and physical) using SQL server enterprise manager.• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas,snowflakes, ETL processes, dimensional modeling, and reporting tools (SSIS, SSRS, SSAS, Power BI, and Tableau).• In-depth understanding of database management systems, online analytical processing (OLAP), and ETL framework.• Strong background in developing reports from complex financial data mart and cubes using SharePoint, MDX queries, power BI, Amazon Redshift, and Tableau.• Proficient in business scope definition, cost/benefit analysis, and conceptual design analysis.• Proficient in data analysis at levels of inspecting, cleansing, transforming, and modeling data for decision-making and business forecasting.• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins, and query writing.• Efficient in upgrading and migrating from SQL Server 2012/2014 to SQL Server 2016.
-
Data AnalystUsaa Jun 2023 - PresentPlano, 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. -
Data AnalystZen3 Infosolutions Jun 2020 - Feb 2022India• 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. -
Power Bi DeveloperMicropyramid Inc Jan 2018 - May 2020India• 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.
Rohan J Education Details
-
Malla Reddy Institute Of Engineering And TechnologyComputer Science
Frequently Asked Questions about Rohan J
What company does Rohan J work for?
Rohan J works for Usaa
What is Rohan J's role at the current company?
Rohan J's current role is Experienced Power BI Developer | Data Analyst.
What schools did Rohan J attend?
Rohan J attended Malla Reddy Institute Of Engineering And Technology, George Mason University - College Of Engineering And Computing.
Who are Rohan J's colleagues?
Rohan J's colleagues are Joseph Flores, Scott K., Ryan King, Linda Hood, Kimberly Nash, Christopher Milton, John Crewdson.
Not the Rohan J you were looking for?
-
2gmail.com, verizon.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial