Hitanshu Joshi

Implemented automated data processing using Cronjobs and SQL stored procedures, achieving a high job success rate and reducing manual efforts by 20%, enhancing business agility and decision-making capabilities.
Created interactive dashboards in Tableau, visualizing complex datasets and enabling stakeholders to make data-driven decisions, resulting in a 20% increase in operational efficiency and a 15% reduction in reporting errors.
Analyzed large datasets using Python pandas to identify customer retention trends, and created actionable Tableau dashboards for real-time insights, facilitating clearer decision-making for senior leadership.
Improved project outcomes by actively participating in project planning sessions, resulting in a 20% increase in efficiency through enhanced analysis of business requirements and the proposal of more effective solutions.

• Implemented automated data processing using Cronjobs and SQL stored procedures, achieving a high job success
rate and reducing manual efforts by 20%, enhancing business agility and decision-making capabilities..
• Created interactive dashboards in Tableau, visualizing complex datasets and enabling stakeholders to make
data-driven decisions, resulting in a 20% increase in operational efficiency and a 15% reduction in reporting
errors.
• Analyzed large datasets using Python pandas to identify customer retention trends, and created actionable
Tableau dashboards for real-time insights, facilitating clearer decision-making for senior leadership.
• Improved project outcomes by actively participating in project planning sessions, resulting in a 20% increase in
efficiency through enhanced analysis of business requirements and the proposal of more effective solutions.

Developed Python automation to optimize processes within Google’s FedRAMP team, enhancing team efficiency and reducing 3 weekly manual work hours.
Optimized team efficiency by 10% by creating dynamic product dashboards using Google Cloud Platform, Python, SQL, and dashboarding tools like Tableau & Power BI.
Automated ticket creation with Appscript and email alerts for vulnerability thresholds, using ETL patterns, frameworks, and query techniques, leading to streamlined data accuracy and faster decision-making for the client.
Employed advanced data analysis methods to scrutinize extensive customer feedback’s large datasets, resulting in a notable 10% boost in product usability, thereby enriching user experience and bolstering customer retention metrics.
Empowered senior management with data-driven insights by developing 7+ insightful reports and dashboards using Tableau, resulting in improved strategic decision-making in Product and Operations teams.
Contributed to 15% increase in project efficiency by participating in project planning sessions, leading to better analysis of business requirements and more effective proposed solutions.
Enhanced project management plan by using Confluence, Jira and One note for business process, and process flow, resulting in amplified project coordination and streamlined operations, leading to client satisfaction.
Accelerated client’s security measures by assisting in conducting comprehensive security control audits, resulting in lifting data integrity and increased protection against potential security threats.

Utilized statistical analysis to polish the organization’s integrity during onboarding and offboarding processes, leading to a 20% reduction in data errors and Strengthening decision-making for the IT team.
Automated the integration of data from GIT, AWS, SLACK, Outlook, and NIST using Python and Pandas, reducing data processing time by 30% and improving data accuracy, leading to more informed business decisions.
Implemented Python Pandas automation for efficient handling of dormant and bot accounts, resulting in a 3% cost saving and reduction in access to dormant accounts.

Streamlined software integrity assessment using API and Python automation, leading to a 20% improvement in response time and ensuring comprehensive data analysis for 50 products, 1500+ product versions, and 1000+ vulnerable components, enhancing overall product security.
Established an efficient on-premises data warehouse for scan result analysis, using Python to develop and implement ETL processes, leading to a 20% increase in data-driven response time.
Collaborated closely with cross-functional teams to address vulnerabilities identified in Black Duck scans, promptly generating JIRA tickets for efficient resolution and mitigation.
Ensured timely action to minimize security risks and uphold data integrity.
Improved decision-making by providing stakeholders with visually compelling representations of scan results through dynamic Tableau dashboards on MySQL database.

Learned OWASP top 10 security attacks in first few months and performed those attacks on clients’ projects to find vulnerabilities.
Researched and analyzed known hacker methodologies, system exploits and vulnerabilities to support Red Team Assessment activities.
Performed application security and penetration testing manually and with tools like burp suite.
Created written detailing assessment findings and recommendations, worked on Network testing.