APOORVA GAJJALA
Hyderabad
Summary
Experienced IT professional with 6+ years of expertise in cloud platforms, SQL, and Python. Seeking a challenging position to leverage skills and contribute to organizational success.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Assistant Manager
Deloitte Support Services India Pvt. Ltd.
Hyderabad
2022.05 - Current
- Perform security reviews by initiating meetings with various system owners, providing guidance on evidence needed for security controls and documenting findings of the assessment
- Perform remediation by evaluating policies, procedures, security scan results and system settings; tracking & aggregating results and reporting to the leadership
- Engage in daily scrum meetings as a subject matter expert (SME), work on features and user stories using Azure DevOps (ADO) Dashboard
- Collaborate with the Compliance Monitoring team for continuous compliance monitoring processes
- Provide guidance on cloud security and compliance procedures according to regulatory requirements, firm policy, data classification, client commitments, etc.
- Monitor cloud infrastructure security solutions and drive remediation/ mitigation of identified risks
- Automate the agent validation process one after the other for the agents such as BigFix, Qualys, CrowdStrike, and Splunk in all the CSPs
- Create PowerBI dashboards to analyze and track the metrics to showcase the leadership using multiple sources
- Collaborate with different member firms’ Chief Information Security Officers to expand the security controls to their regions
- Perform quality checks for the work done by team members
- Collaborate with ServiceNow team to build request forms for the services offered by the team
- Extract dormant asset reports and remediated 75% of dormant assets in AWS, Azure and GCP cloud service providers
- Worked with the Outlook Exchange team and automated the process for Rogue account management which resulted in the remediation of 82% of rogue accounts created for all CSPs in the organization
- Perform security agent testing on AWS, Azure and GCP servers in routable and non-routable environments and assist users to troubleshoot issues with security patches. Installation of security agents like CrowdStrike, BigFix, Splunk, and Qualys on the virtual machines
- Installation of security agents like CrowdStrike, BigFix, Splunk, and Qualys on the virtual machines
- Prepare metrics for services like dormant assets, Rogue account management, Agent remediation and Validation.
- Created ServiceNow RITMs to work on the remediation of machines.
Systems Engineer
Tata Consultancy Services
Bangalore
2019.04 - 2022.04
- Launched AWS EC2 instances for application, reporting and databases in dev, stage and production environments
- Taking Remote Desktop Connections to the servers to manage the services and install applications on the servers
- Performed enhancements in the Infor Enterprise Asset Management (EAM) application
- Personalized the application according to the customer’s requirements
- Developed business rules with Flex SQLs for required functionalities
- Deployed calibration and maintenance modules of the Infor EAM application for 10 sites
- Designed customized reports for monthly calibration and maintenance using the IBM Cognos tool
- Involved in the upgrade of the Infor EAM application from v11.1 to v11.7 on AWS
- Created scripts and performed User Acceptance Testing of the scripts for new functionalities using HP Application Lifecycle Management (ALM)
- Conducted functionality training sessions on maintenance and calibration modules to clients during site deployments
- Retrieved the data from the database using SQL Developer and manipulated it to specific needs and requirements
- Built and retrieved XML files from the Import utility web services
- Engaged in integration with other applications like eDHR, eAndOn
- ITIL role in ServiceNow for raising RITMs, Incidents and change controls to implement new enhancements
- Documented and maintained configuration specs, user acceptance and trace matrix documents for GxP environment and tracked the status of work done by the team using smart-sheets
- Acted as team lead for a team of 4 and conducted internal audits and mock Business Continuity Plan (BCP) drills
- Engaged in Scrum meetings and ad-hoc meetings to discuss the backlogs and ongoing requirements.
Integration Project Manager
eClincalWorks Pvt. Ltd.
Bangalore
2017.10 - 2019.04
- Facilitated meetings with clients and vendors to gather and document business requirements and explore the most feasible solution
- Acted as a liaison between the clients and technical team for any new development requests; created design & functional specification documents, coordinated meetings, documented the minutes and tracked the status of various projects using excel
- Created project plans & scope documents to communicate requirements and built interfaces for clients as per scope
- Tested, debugged and modified HL7 messages; assessed & configured the message format with the help of the technical team
- Generated Scenario based round-trip testing in the test environment
- Resolved issues, handled escalations and verified the results in reports from SAAS Server
- Collaborated with different vendors and middleware like Labcorp, Pathgroup, PDL, Avero diagnostics, Xeron clinical labs, Ellkay, etc
- Knowledge on connectivity like Hub & Spoke, Point to point (TCP/IP, SFTP)
- Provided interface training on Lab and Radiology to providers and clinical staff
- Implemented 200+ interfaces of Lab and Rad to the clients as per their requirement
- Regularly followed up with clients and vendors on the challenges and status of the projects along with providing hyper-care support for the first 15 days of interface go-live.
Education
Masters in Power Systems (M. Tech) -
Sri Venkateswara University
Tirupati, India2018-03
Under Graduate in Electrical and Electronics Engineering (B. Tech) -
G. Pulla Reddy College of Engineering
Kurnool, India2015-04
Skills
- AWS (EC2, S3, IAM, Load Balancer, Auto-Scaling)
- Azure
- ServiceNow
- Python
- Safe5
- PL/SQL
- SQL Developer
- SQL
- Basics of XML and JSON
- Microsoft Office (Word, Excel, OneNote, Outlook, PowerPoint)
- Smartsheet
- GitHub Actions
- GCP
- Terraform
- Power BI
Certification
- AWS Solutions Architect Associate (SAA- C03)
- Azure Cloud Administrator (AZ-104)
- Azure Fundamentals (AZ-900)
- SAFe5 for Teams Practitioner
Accomplishments
On-Spot Award
Tata Consultancy Services
For extending my services in internal and external audits for other projects for the client along with project deliverables
Spot Award
Deloitte
For being consistent and punctual in remediating the Rogue accounts in Azure and AWS
Applause Award
Deloitte
For taking Key role in building ServiceNow Case management form for Endpoint Integration service.
Spot Award
Deloitte
For extending the agent testing to GCP and creating SOP
Timeline
Assistant Manager
Deloitte Support Services India Pvt. Ltd.
2022.05 - Current
Systems Engineer
Tata Consultancy Services
2019.04 - 2022.04
Integration Project Manager
eClincalWorks Pvt. Ltd.
2017.10 - 2019.04
Masters in Power Systems (M. Tech) -
Sri Venkateswara University
Under Graduate in Electrical and Electronics Engineering (B. Tech) -
G. Pulla Reddy College of Engineering
- AWS Solutions Architect Associate (SAA- C03)
- Azure Cloud Administrator (AZ-104)
- Azure Fundamentals (AZ-900)
- SAFe5 for Teams Practitioner
Similar Profiles
Durgesh Kumar Singh Durgesh Kumar Singh null
Analyst at Deloitte Support Services India Pvt Ltd.Analyst at Deloitte Support Services India Pvt Ltd.
Rajesh MoluguRajesh Molugu
Deputy Manager Procure to Pay at Deloitte Support Services India pvt ltdDeputy Manager Procure to Pay at Deloitte Support Services India pvt ltd
Reena HarryReena Harry
Assistant Manager, Lab Delivery Excellence (LDX) at Deloitte Support Services India Pvt LtdAssistant Manager, Lab Delivery Excellence (LDX) at Deloitte Support Services India Pvt Ltd