Bajrang Lal Panigrahi

• Heading team of 11 Highly skilled software engineers, promoting innovation, teamwork, and continuous learning
• Oversaw multiple projects, ensuring timely delivery, budget adherence, and quality standards
• Applied Agile methodologies to enhance project delivery efficiency and team productivity
• Collaborated with stakeholders to comprehend requirements and convert them into technical specifications
• Leading improvement of Cloud Infrastructure and Developer Productivity tools, tracked key DORA metrics
• Set up complete range of developer tools, cut down time from code commit to deployment by 30%
• Created custom automation scripts to simplify repetitive tasks, enhancing developer focus on coding
• Collaborated with development teams to find and solve issues, enhancing overall developer satisfaction.
• Building Nexgen Platform and CI/CD service at TriNet moving both HCM SaaS and Professional Employer Organization (PEO) models under one Denali Customer Platform (DCP) for SMB's.
• Conceptualized 12 Foundational Enablers for DCP applications and created Business and Technical tenants for our new platform.
• Spearheaded and successfully launched the inaugural DCP Production service, the Benefits Plan Library, in Q2 2023, catering to both PEO & HCM customers.
• Identified 107 Foundation and Core Services and delivered key functionality for our top 7 customer-facing features.
• Build DCP Platform for TriNet Pay, setting standard for future developments, managing over 600,000 lines of code, over 200 APIs, and about 40 background tasks (Q1 2024).
• Pioneered transition of existing platforms and architectural elements from monolithic HRIS to DCP Payroll application while ensuring seamless integration with existing HR platform.
• Building one single pane view for all CI/CD and developer productivity Metrics including Compliance and Governance coverage for both HCM SaaS and PEO to reduce time to ship and MTTR.

• Established and led Global Platform Engineering Team, responsible for Cloud Infrastructure, Databases, Security, Dev-Productivity, and Data Infra Analytics within HCM business infrastructure engineering
• Managed global team of highly skilled DevOps, DBA, and SRE Engineers, fostering collaborative and innovative work environment
• Partnered with Security Engineering to develop and implement effective teams and processes for Cloud SecOps, Vulnerability Analysis, and DevSecOps Engineering, enhancing security services framework.

Key Achievements:
* Pioneered Cloud infrastructure initiative, including Databases, Developer productivity tools (CI/CD), Cloud Security, and UI Engineering.
* Built and scaled engineering team from scratch, while continuing to manage other portfolios and DevOps responsibilities.
* Optimized database failover processes, reducing downtime from 45 minutes to under 5 minutes, significantly enhancing system reliability.
* Streamlined scalability procedures, cutting down time required from hours/days to under 5 minutes, thereby accelerating project delivery.
* Improved Speed to Market, decreasing build times from 90 minutes to under 5 minutes, contributing to faster product iterations.
* Achieved a 42% reduction in Cloud expenses, saving over $1 million in three years through strategic cost management and vendor negotiations.
* Managed an Opex budget of $4.5 million, overseeing all vendor product relations and ensuring optimal resource allocation.

• Spearheading enhancement of Cloud Infrastructure and Developer Productivity tools, while tracking pivotal DORA metrics for continuous improvement
• Independently drove end-to-end large-scale platform & database projects, demonstrating leadership and project management skills
• Hired & mentored newly hired employees, imparting knowledge, and guidance on INFRA automation and in-house developer tools like Gondor and Sauron
• Focused on infrastructure enhancement, contributing to career growth and aspirations
• Implemented policy-driven backup strategy that resulted in 40-45% reduction in DB infrastructure costs and improved data maintenance reliability
• Enforced SOC-2 guidelines and procedures for DB security and auditing, ensuring organizational compliance with SOC-2 audits
• Streamlined data aggregation process, enhancing data reliability and performance
• Implemented SQL-aware proxy layer, minimizing switchover periods and enabling more controlled graceful switchover
• Set up orchestrator for auto-failover and fast switchover in case of DB server or AZ failures
• Optimized Postgres DB and set up monitoring interface, improving visibility, and reducing build times in CI/CD platform
• Implemented MySQL multi-source replication as Infrastructure as Code (IaC), configuring alerts and monitoring to ensure more than 95% uptime for downstream CS - SPOOF
• Proposed a solution for initial load of queries and slower performance using ZFS CoW file system in a tech talk at Percona Live 2019
• Initiated level-3 region failover DR strategy for DB, setting up network wirings on Ohio Region transferred using CMK encrypted EBS volumes
• Improved infrastructure reliability using terraform and ansible for infrastructure as code
• Migrated Query Logger (Instrumentation and App error tracing) to GCP Big Query and build flame graph implementation saving costs around ~$25K per month from Redshift

• Pioneering member of Zenefits India Platform Engineering and Database Initiative
• Database Management: Extensive experience with large-scale data handling and complex database problem-solving
• High Availability Design: Skilled in designing fault-tolerant database infrastructures and replication topologies
• Technical Communication: Exceptional ability to articulate technical requirements and communicate ideas effectively
• Analytical Thinking: Strong analytical and decision-making skills with a focus on troubleshooting and task commitment.

Key Accomplishments:
* Cost Optimization: Developed a Standard Policy based Snapshot Mechanism, reducing snapshot costs from $28k/month to $16k/month, with projections to drop below $10k/month.
* Performance Enhancement: Implemented a multi-threaded tool for MySQL data dumps and restores, achieving a 70% improvement in dump times and a 55% increase in restoration efficiency.
* Infrastructure Improvement: Formulated a high-level plan for Database Backup and High Availability Architecture, transitioning from HA-Proxy to ProxySQL for better SQL-aware operations.
* Innovation in Data Management: Spearheaded Incremental Sanitization for Spoof DB creation, utilizing MySQL Multi-Source Replication to address scalability needs.

Technical Expertise:
* In-depth knowledge of database systems with significant expertise in AWS.
Proven ability to troubleshoot issues beyond the immediate area of expertise.

Client & Customer Focus:
* Recognized for being readily available and responsive to work demands.
Peer Endorsements:
* Commended for exceptional coding skills in database and proactive adoption of innovative technologies.
* Keen to engage in data analytics use cases, complex data modeling, and the design of in-house Data-Lake/Big-Data projects.
* Renowned for strong decision-making capacity and excellent priority management in dynamic environments.
* Eager to learn modern technologies and adapt to business-driven changes.

• Among first 30 employees who started swiggy platform services and DevOps journey. Initial member of Platform Engineering and first Database persona.
• Introduced Cloud Database Team: Championed inaugural integration of database engineering at Swiggy, leading to significant enhancements in advanced schema design, query performance, and introduced robust Point-In-Time Recovery (PITR) and archiving features.
• Developed Data Protection Platform: Built an in-house platform for dynamically protecting sensitive information at rest in application databases.
• Revamped SRE Team: Revitalized Site Reliability Engineering (SRE) team, positioning them as Level 1 team for DevOps/DBA team
• Established Security Team: Involved in Hiring and setting up security team from scratch, introducing automated practices for Vulnerability Assessment and Penetration Testing (VAPT), static and dynamic code analysis, and public ports and endpoints management.
• Implemented Web Application Firewall (WAF): Conducted Proof of Concept (POC) of various WAF solutions and introduced Imperva Incapsula WAF to all public endpoints of Swiggy.
• Deployed Docker Platforms: Implemented Mesos and Kubernetes-based docker platforms with capability of promotion-based deployments with multiple runways and environments.
• Optimized AWS Infrastructure Costs: Streamlined resources and implemented auto-scaling systems, reducing AWS infrastructure costs by ~50%. Also introduced governance of cost per pod through budgets and cost dashboards.
• Built DDoS Protection Platform: Developed an in-house DDoS protection platform based on open-source technologies.
• Collaborated with Architecture Team: Worked closely with architecture team for various design optimizations and introduced new layers like Kong-based traffic gateway.
• Partnered with Data Team: Collaborated with Data team to set up in-house data platforms and data science systems. (Analytics Infra Tools - Presto, Apache Hive and CDC Frameworks using Hevo)

• Lead a team of 6 backend engineers responsible for the automation of B2B (JD-Omni) and E-Com (JD-ShopFront & QuickQuotes) Product Modules for the business.
• Build search engine for distributed index topologies, through effective mapping static and dynamic data sets, used logstash to process and parse incoming logs
• Led development of Shop Online Vertical, price comparison tool for products from various online and offline partners. Created API integration framework with embedded business logic to facilitate dynamic pricing and ensure JD Guarantee (JDG) for customer product pricing.
• Impacted revenue growth and new PDG customers onboarded with Optimization on JD Tree Categories and many newly introduced Search Plus Verticals.
• Improved Search Performance optimizing sphinx storage and indexing layer.

• Served as Lead Sphinx Programmer to integrate entire search data to real time Indexes using Sphinx Distributed and RT Index
• Build and Configured nodes for Database level Encryption at Rest using InnoDB TDE (Transparent Data Encryption) through OKV
• Created Security Algorithm / routines for data push and retrieval at database layer to ensure PCI DSS compliance
• Implementation of MySQL Replication, configuring Multi-Master, Master-Slave Set-based replication, Circular Replication, effectively configured as part of HA solution
• Read scalability by adding set-based topologies and automation in place
• Implemented and configured Max-Scale as part of query split and Load sharing and query caching needs
• Led Sphinx to Elastic Search conversion, entire search base services were re-exhibited and segregated into different search unit nodes for scalability and incremental data push was introduced which boosted search indexing time from 6-8 Hours to 10 - 15 minutes and improved go to market metrics
• Identified and suggested innovative technologies and tools for enhancing product value and Increase Team productivity
• Involved in Community and delivering ideas and thoughts in various DB Workshop, collaborating with MySQL Development Team in Bangalore and others based large MySQL Users
• Recognition for excellence in establishing PCI compliance and DSS standards for payment and transactions at database layer
• Hired and trained new engineers to scale team in Bangalore and Mumbai.

• Developed and managed database schemas and objects, adapting them to meet evolving business requirements.
• Streaming data from scratch to production modules, performing various validation checks to ensure data integrity and consistency
• Creation of Database Procedures, Functions & Triggers for Data Manipulation and Events Handling at Runtime
• Performed installations, new database design, configuration, backup, recovery, security, upgrade, and schema changes, tuning and data integrity
• Administration and management of entire development, QA and production environment
• Using MyISAM storage engine and its FULL-TEXT index support, enhance search for distributed data source
• Automated Pipeline and Data Import Scripting via PHP modules and Shell scripting using MySQL backend
• Imported & migrated more than 2 million records data set from MySQL to MondoDB using mongify
• Optimized and streamlined process, use of multiple worker threads and benchmarked system to move to NoSQL interface for Products (E-Com) vertical.

• Creating corporate portals, websites, and large scale-web applications, providing design direction through rendering images and effective written and verbal communication
• Design and coding on user forms in PHP for websites that requires user registration
• Well versed with Microsoft Access, MS SQL Server & Oracle 9i/10g
• Optimization of graphics for corporate client's sites and adaptation of visual designs into dynamic websites and websites templates.
• Developed customized software solutions for diverse clients, resulting in increased satisfaction and repeat business.