Project Details
EMployee account provisioning
By leveraging various APIs and popular platforms like Workday, Slack, Google, and Jira, I automated the provisioning of employee profiles. I designed an integration system that seamlessly connected these platforms, enabling a streamlined process for onboarding and managing employee access across multiple systems. I utilized the Bamboo HR API to extract employee data, including job titles and department information. This data was then used to create corresponding profiles on other platforms. Through the Slack API, I automated the creation of Slack accounts for new employees. Using the Google API, I automated the creation of email accounts and assigned them to google groups based on their roles, departments, countries and supervisor. Automating the provisioning of employee profiles played a crucial role in assisting the IAM (Identity and Access Management) team assign permissions and access levels across company resources, thereby enhancing the overall access management process. Overall, this automation significantly reduced manual effort, improved efficiency, and ensured consistent role-based access control across multiple platforms.
account Backup
I spearheaded the automation of backing up and deleting inactive employee Google accounts, effectively addressing the company’s issue of paying for unused accounts. On an Amazon Elastic Compute Cloud (EC2) I developed a system that monitored employee account activity within the Google Workspace environment. When an account was identified as inactive for a specific duration, the system automatically initiated the backup process to securely archive associated data and documents. Following the backup, the system proceeded to delete the account, ensuring the removal of all data and access privileges. This automation not only saved the company unnecessary expenses, it also improved data security and compliance by eliminating dormant accounts. My efforts significantly optimized resource allocation and mitigated potential security risks associated with inactive employee accounts.
Employee account provisioning
When the acquisition of Auth0 by Okta took place, I played a pivotal role in redesigning the automation process to ensure a seamless integration with the new Okta resources while preserving compatibility with existing Auth0 profiles. Understanding the importance of a smooth transition for both employees and systems, I thoroughly analyzed the differences between the two platforms and identified areas of alignment. Leveraging my expertise in automation and system integration, I redesigned and reconfigured the automation pipelines to leverage Workday’s APIs for extracting employee data. Rigorous testing and validation processes were implemented to ensure the accuracy and integrity of the migrated data. Through these efforts, the organization was able to smoothly transition to the Okta resources while maintaining the functionality and access controls established in Auth0, minimizing disruption and ensuring a seamless user experience for all stakeholders involved.
acquisition reporting
I developed and implemented an automated solution to track and record employee record changes during the stock option conversion process. The solution utilized the Bamboo HR API to capture and record various types of changes, including new hires, terminations, and modifications to employee records that impacted stock options.
The system generated scheduled daily, weekly, and monthly reports, providing HR and management with real-time visibility into employee record changes. Additionally, I created a user-friendly Slack application that allowed on-demand report generation and facilitated communication between the automated tracking system and the stock plan administration team.
I conducted training sessions for the HR staff and stock plan administration team on how to effectively use the Slack application. Ongoing support and assistance were provided throughout the implementation and post-implementation phases.
The benefits of this project included significant time and resource savings, improved accuracy and compliance, real-time visibility into employee data changes, and enhanced data management with a secure audit trail.
Overall, the project’s successful implementation contributed to a more efficient, accurate, and compliant HR operation within the organization.
account alerts
I automated the creation of Jira tickets to address issues such as inactive employee accounts or active accounts of terminated employees within the Google Workspace environment. Whenever an inactive employee account or an active account of a terminated employee was detected, the system triggered the creation of a Jira ticket. These Jira tickets served as notifications to the IT team, alerting them about the account status and the necessary actions to be taken. This automation not only ensured that IT was promptly informed about such accounts but also streamlined the workflow for handling these situations. The Jira tickets provided a centralized and trackable mechanism for IT to manage and resolve the identified issues, ensuring that inactive or terminated accounts were properly addressed and access was revoked or managed according to the organization’s security policies.
EXTERRO INTEGRATION
I took the lead in integrating Exterro with Okta’s Slack and Box platforms, facilitating a seamless integration for data management during legal processes. By working closely with Exterro’s SMEs, I gained in-depth knowledge of the platform’s capabilities and requirements. Leveraging this understanding, I identified and established the necessary integrations on Slack and Box. Together with Exterro, we tested a sample data collection and ensured a comprehensive and efficient integration. This integration enabled the automatic collection, processing, and preservation of relevant data, empowering legal teams to effectively manage legal holds. These efforts significantly contributed to a more streamlined and robust approach to data management during legal proceedings.
