ROHIT JHA
Technical Analyst Lead
Summary
Detail-focused Data Analyst with 8+ years of Experience having knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Data Engineer experienced in working across the different stages of the data pipeline, including acquisition, integration, and real-time data marts. Adept in working quickly and efficiently in close collaboration with analytic, engineering and other stakeholders. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.
Overview
9
9
years of professional experience
3
3
years of post-secondary education
2
2
Certifications
2
2
Languages
Work History
Technical Lead Analyst
Sony India Software Center
09.2022 - Current
- I was promoted within one year after my good performance.
·Work on certain measures, vulnerabilities, patch management, and security operations across Global Sony Groups.
Conduct detailed vulnerability research and analysis of the findings to eliminate false positives and provide proof of concepts to convey the business impact to Sony stockholders.
Work on ensuring that vulnerabilities are mitigated or remediated within the timeframes specified in the SONY Global Vulnerability Management Standard.
Work on the architecture to manage the data from the API to the Snowflake process from start to finish and integrate multiple sources of data, like JSON and XML, from the AWS S3 bucket to the Snowflake table.
Ensure that documentation, data, assessment information, and vulnerability management program information are kept up-to-date.
Build procedures, tasks, and dynamic tables and create views in Snowflake to run SQL complex queries on a daily basis to perform ETL processes like data cleaning, blending,blending and converting JSON/XML data to the required format.
Write certain vulnerability policy timeframe logics in Snowflake Sql, which helps us analyze and identify whether devices are remediated within the timeframe.
Build monthly and weekly views and reports in PowerBI, which are shared across the Sony stakeholders.
Expedited the design process of interactive dashboards and systemized reports with Power BI, reducing production time by 30%.
Implemented advanced DAX queries in Power BI desktop, providing detailed insights and enabling 20% better performance.
Utilizing Python to carry out data mining and handle massive data sets. Employing Python to handle the calculation and fill in the data in Excel.
Using Python scripts to automate certain operations that are started manually. I am in charge of using SQL database queries to mine data from it for a number of important presentations.
Risk Analyst
Skill-mine Technology Consulting Private Limited
04.2019 - 09.2019
- Streamlined risk reporting procedures for improved communication with stakeholders and senior management.
- Creating reports for vulnerability management based on security analysis of the various Sony Group of Companies participants.
- Extensive data transformation, analysis, and cleaning in Snowflake. Generating intricate SQL scripts for business reporting and analysis in the Snowflake cloud data warehouse. A lateral view of the VARIANT, OBJECT, and ARRAY columns was created using the FLATTEN table function.
- Producing and designing Reports in Tableau for the different reports on risk and vulnerability management for the different Sony companies.
- Using Python to manage large Excel files. Designing and putting into action solutions for the Sony Risk by working alone or in a team.
- Convincingly show reports and analytics that you've created. Utilizing Python to carry out data mining and handle massive data sets.
- Employing Python to handle the calculation and fill the data in Excel. Using Python scripts to automate certain operations that are started manually.
- In charge of using SQL database queries to mine data from it for a number of important presentations.
Associate Technology Consultant
Aequm India Pvt Ltd
01.2016 - 04.2019
- Created a platform for analytical dashboards for several participants
- Created analyses for internal usage on a quarterly, monthly, and annual basis
- Aided in the creation of technical architecture, specifications, and statistical models
- In order to build and deploy analytical solutions that meet the needs of the company, coordination was done with end users
- Developed dynamic graphs (such as pie charts, bar charts, scatter plots, etc.) Techniques for integrating R programming strategies with data sources and delivery systems have been developed
- In accordance with the needs of the company scripts that have been prepared to guarantee effective data access, manipulation, and reported capabilities using R programming languages
- Developed sophisticated DASHDB(IBM BLUEMIX) scripts for modeling and data visualization
- Helped the technical team members create automated data extraction and analysis techniques
- Supervised and maintained the PHP backend development for dynamic, database-driven websites
- Created a Sync Server to synchronize data for the POS system and made the necessary adjustments
- According to the project requirements, PHP MySQL solutions were designed and executed
- Worked together on database structural development with team members.
Education
B.Tech/B.E. -
Rajiv Gandhi Proudyogiki Vishwavidyalaya (RGPV), Bhopal
BHOPAL 01.2010 - 01.2013
Skills
Snowflake
My Sql
Python
Power Bi
Technical Analysis
Business Analysis
Data Analysis
Data Visualization
Leadership
Data quality assurance processes
Problem Solving
Project Management
Advance Excel
R Programming
Certification
Certificate in Data Science, BI & Analytic, 10/2018
Timeline
Technical Lead Analyst
Sony India Software Center
09.2022 - Current
Risk Analyst
Skill-mine Technology Consulting Private Limited
04.2019 - 09.2019
Associate Technology Consultant
Aequm India Pvt Ltd
01.2016 - 04.2019
B.Tech/B.E. -
Rajiv Gandhi Proudyogiki Vishwavidyalaya (RGPV), Bhopal
01.2010 - 01.2013