-- ============================================= -- TIRUMALARAO NAIDU WEBSITE - SEED DATA -- Run this SQL AFTER manual_schema.sql -- ============================================= -- --------------------------------------------- -- 1. CREATE ADMIN USER -- Password: Admin@123 (bcrypt hashed) -- --------------------------------------------- INSERT INTO `users` (`name`, `email`, `password`, `role`, `created_at`, `updated_at`) VALUES ('Tirumalarao Naidu', 'admin@tirumalarao.com', '$2y$12$LQv3c1yqBWVHxkd0LHAkCOYz6TtxMQJqhN8/X4a/5Pp0nZVlj.wKO', 'admin', NOW(), NOW()); -- --------------------------------------------- -- 2. SETTINGS - General -- --------------------------------------------- INSERT INTO `settings` (`key`, `value`, `type`, `group`, `created_at`, `updated_at`) VALUES ('site_name', 'Tirumalarao Naidu', 'string', 'general', NOW(), NOW()), ('site_description', 'Technology Executive | Data Engineering Leader', 'string', 'general', NOW(), NOW()), ('contact_email', 'tirumalarao.naidu@gmail.com', 'string', 'general', NOW(), NOW()); -- --------------------------------------------- -- 3. SETTINGS - Social Media -- --------------------------------------------- INSERT INTO `settings` (`key`, `value`, `type`, `group`, `created_at`, `updated_at`) VALUES ('social_linkedin', 'https://www.linkedin.com/in/tirumalaraonaidu', 'string', 'social', NOW(), NOW()), ('social_facebook', 'https://www.facebook.com/tirumalraonaidu', 'string', 'social', NOW(), NOW()), ('social_twitter', 'https://x.com/tirumalraonaidu', 'string', 'social', NOW(), NOW()), ('social_instagram', 'https://www.instagram.com/tirumalraonaidu', 'string', 'social', NOW(), NOW()); -- --------------------------------------------- -- 4. SETTINGS - Resume Data -- --------------------------------------------- INSERT INTO `settings` (`key`, `value`, `type`, `group`, `created_at`, `updated_at`) VALUES ('resume_name', 'Tirumalarao Naidu', 'string', 'resume', NOW(), NOW()), ('resume_title', 'Technology Executive | Data Engineering Leader', 'string', 'resume', NOW(), NOW()), ('resume_email', 'tirumalarao.naidu@gmail.com', 'string', 'resume', NOW(), NOW()), ('resume_phone', '+1 4706014799', 'string', 'resume', NOW(), NOW()), ('resume_summary', 'Internationally recognized technology executive and data engineering leader with over 19 years of distinguished experience across the U.S., South Africa, and India. Led innovative, high-impact initiatives that have shaped multimodal transit, financial technology, cloud infrastructure, and enterprise-level digital transformation. Currently serving as the Manager of Customer Technology Data at MARTA, spearheading regionally critical data systems that enhance equitable access to public transportation for millions.', 'text', 'resume', NOW(), NOW()), ('resume_experience', '[{\"company\":\"Metro Atlanta Rapid Transit Authority (MARTA)\",\"role\":\"Manager of Customer Technology Data\",\"dates\":\"April 2024 – Present\",\"location\":\"USA\"},{\"company\":\"Entellects Corporation (Client: Global Atlantic Financial Group)\",\"role\":\"Technical Project Manager\",\"dates\":\"June 2023 – Mar 2024\",\"location\":\"USA\"},{\"company\":\"Marquis Finance Pty Ltd\",\"role\":\"Application Development Manager\",\"dates\":\"Jan 2022 – May 2023\",\"location\":\"South Africa\"},{\"company\":\"FedEx Express\",\"role\":\"Senior Architect\",\"dates\":\"Jan 2015 – Feb 2019\",\"location\":\"South Africa\"}]', 'json', 'resume', NOW(), NOW()), ('resume_education', '[{\"degree\":\"Master of Business Administration\",\"institution\":\"Henley Business School\",\"year\":\"2020\"},{\"degree\":\"Bachelor of Engineering in Electronics and Communications\",\"institution\":\"Anna University\",\"year\":\"2005\"}]', 'json', 'resume', NOW(), NOW()), ('resume_skills', '{\"Languages\":\"Java, Spring Boot, Python, JavaScript, React, Node.js, PHP, C#.NET\",\"Databases\":\"Oracle, SQL Server, PostgreSQL, MongoDB, MySQL, Cosmos DB\",\"Cloud\":\"AWS, Microsoft Azure, Google Cloud Platform\",\"DevOps\":\"Docker, Kubernetes, Jenkins, Terraform, Ansible\"}', 'json', 'resume', NOW(), NOW()), ('resume_certifications', '[\"Microsoft Certified: Azure AI Fundamentals\",\"Oracle Certified Java Programmer\",\"Leading Scaled Safe Agile (4.5)\",\"Six Sigma Green Belt Certificate\"]', 'json', 'resume', NOW(), NOW()); -- --------------------------------------------- -- 5. ABOUT PAGE -- --------------------------------------------- INSERT INTO `pages` (`title`, `slug`, `content`, `meta_title`, `meta_description`, `is_published`, `order`, `created_at`, `updated_at`) VALUES ('About', 'about', '

About Tirumalarao Naidu

\n

I am an internationally recognized technology executive and data engineering leader with over 19 years of distinguished experience across the U.S., South Africa, and India.

\n\n

Current Role

\n

Currently serving as the Manager of Customer Technology Data at MARTA (Metropolitan Atlanta Rapid Transit Authority), I spearhead regionally critical data systems that enhance equitable access to public transportation for millions.

\n\n

Expertise

\n\n\n

Education

\n\n\n

Memberships

\n', 'About Tirumalarao Naidu - Technology Executive', 'Learn about Tirumalarao Naidu, a technology executive and data engineering leader with 19+ years of experience.', 1, 1, NOW(), NOW()); -- --------------------------------------------- -- 6. BLOG CATEGORIES -- --------------------------------------------- INSERT INTO `blog_categories` (`name`, `slug`, `description`, `created_at`, `updated_at`) VALUES ('Data Engineering', 'data-engineering', 'Articles about data pipelines, ETL, and data architecture', NOW(), NOW()), ('Cloud Computing', 'cloud-computing', 'AWS, Azure, GCP, and cloud infrastructure topics', NOW(), NOW()), ('Public Transit Technology', 'public-transit-technology', 'Technology in public transportation systems', NOW(), NOW()), ('AI & Machine Learning', 'ai-machine-learning', 'Artificial intelligence and ML applications', NOW(), NOW()), ('Enterprise Architecture', 'enterprise-architecture', 'Enterprise-level system design and architecture', NOW(), NOW()), ('Leadership', 'leadership', 'Technology leadership and management insights', NOW(), NOW()); -- --------------------------------------------- -- 7. BLOG TAGS -- --------------------------------------------- INSERT INTO `blog_tags` (`name`, `slug`, `created_at`, `updated_at`) VALUES ('GTFS', 'gtfs', NOW(), NOW()), ('Real-time Data', 'real-time-data', NOW(), NOW()), ('Microservices', 'microservices', NOW(), NOW()), ('Docker', 'docker', NOW(), NOW()), ('Kubernetes', 'kubernetes', NOW(), NOW()), ('AWS', 'aws', NOW(), NOW()), ('Azure', 'azure', NOW(), NOW()), ('Python', 'python', NOW(), NOW()), ('Java', 'java', NOW(), NOW()), ('API Design', 'api-design', NOW(), NOW()), ('Data Pipelines', 'data-pipelines', NOW(), NOW()), ('DevOps', 'devops', NOW(), NOW()), ('Agile', 'agile', NOW(), NOW()), ('Transit', 'transit', NOW(), NOW()), ('Digital Transformation', 'digital-transformation', NOW(), NOW()); -- --------------------------------------------- -- 8. SAMPLE BLOG POSTS -- --------------------------------------------- INSERT INTO `blog_posts` (`title`, `slug`, `excerpt`, `content`, `category_id`, `author_id`, `is_published`, `is_featured`, `published_at`, `views`, `created_at`, `updated_at`) VALUES ('Building Resilient Real-Time Transit Data Systems', 'building-resilient-real-time-transit-data-systems', 'Exploring the architecture and best practices for building highly available real-time transit data systems using GTFS-RT.', '

In the world of public transportation, real-time data is not just a convenience—it''s a necessity. As the Manager of Customer Technology Data at MARTA, I''ve learned firsthand the critical importance of building resilient systems that can handle the demands of millions of daily riders.

\n\n

The Challenge of Real-Time Transit Data

\n

Modern transit systems generate enormous amounts of data every second. Vehicle positions, arrival predictions, service alerts—all of this information needs to be processed, validated, and distributed in real-time.

\n\n

Key Architecture Principles

\n\n\n

Implementation with Azure

\n

Our implementation leverages Azure''s cloud services to ensure stability and performance. The key components include Azure Kubernetes Service for container orchestration and Azure Event Hubs for real-time data streaming.

\n\n

Lessons Learned

\n

Building these systems has taught me valuable lessons about balancing technical excellence with practical constraints. The most important takeaway is that simplicity often trumps complexity when it comes to reliable systems.

', 3, 1, 1, 1, NOW(), 0, NOW(), NOW()), ('Data Engineering Best Practices in Enterprise Environments', 'data-engineering-best-practices-enterprise', 'A comprehensive guide to implementing data engineering solutions that scale across large organizations.', '

Data engineering has evolved significantly over the past decade. What was once a niche specialty has become a critical function in virtually every technology organization.

\n\n

Foundation of Modern Data Engineering

\n

The foundation of any successful data engineering initiative is a clear understanding of business requirements and data governance principles.

\n\n

Key Technologies

\n\n\n

Building Data Pipelines

\n

Effective data pipelines are the backbone of data engineering. They must be reliable, maintainable, and observable.

\n\n

Conclusion

\n

Success in data engineering requires a combination of technical expertise, business acumen, and a commitment to continuous improvement.

', 1, 1, 1, 1, DATE_SUB(NOW(), INTERVAL 5 DAY), 0, NOW(), NOW()), ('Cloud Migration Strategies: Lessons from the Field', 'cloud-migration-strategies-lessons', 'Practical insights from leading multiple cloud migration projects across different industries.', '

Cloud migration is one of the most impactful decisions an organization can make. Done right, it can transform operations. Done poorly, it can be a costly mistake.

\n\n

Assessment Phase

\n

Every successful migration begins with a thorough assessment of existing infrastructure, applications, and data.

\n\n

Migration Approaches

\n\n\n

Common Pitfalls

\n

Understanding common pitfalls helps avoid costly mistakes. These include underestimating complexity, inadequate planning, and neglecting security considerations.

', 2, 1, 1, 0, DATE_SUB(NOW(), INTERVAL 10 DAY), 0, NOW(), NOW()); -- --------------------------------------------- -- 9. BLOG POST TAGS (Relationships) -- --------------------------------------------- INSERT INTO `blog_post_tag` (`blog_post_id`, `blog_tag_id`) VALUES (1, 1), (1, 2), (1, 7), (1, 14), (2, 8), (2, 11), (2, 12), (2, 15), (3, 6), (3, 7), (3, 5), (3, 15); -- --------------------------------------------- -- 10. RESEARCH PUBLICATIONS -- --------------------------------------------- INSERT INTO `research_publications` (`title`, `slug`, `abstract`, `type`, `published_date`, `journal_name`, `is_published`, `created_at`, `updated_at`) VALUES ('Improving IT Service Management: A Case Study of the Help Desk Process', 'improving-it-service-management', 'This research paper analyzes IT service management practices and proposes improvements for help desk processes in enterprise environments.', 'paper', '2017-08-19', 'Managing Process and Systems', 1, NOW(), NOW()), ('Strategic Growth Options for Express Services in South Africa: A B2B/B2C Market Expansion Approach', 'strategic-growth-options-express-services', 'Analysis of strategic growth options for express delivery services targeting both business and consumer markets.', 'paper', '2018-06-09', 'Strategy', 1, NOW(), NOW()), ('Strategic Integration and Change Management in Global Logistics', 'strategic-integration-change-management', 'Insights from the FedEx–TNT merger examining strategic integration and change management practices.', 'paper', '2019-04-18', 'Leadership Challenge', 1, NOW(), NOW()), ('Logistics Last Mile Parcel Delivery Service Innovation', 'logistics-last-mile-delivery-innovation', 'Research thesis examining innovation in last-mile delivery services to meet evolving customer demands, focusing on on-location delivery solutions.', 'thesis', '2019-11-22', 'Henley Business School', 1, NOW(), NOW()); -- ============================================= -- SETUP COMPLETE! -- -- Admin Login: -- URL: https://www.tirumalaraonaidu.com/admin -- Email: admin@tirumalarao.com -- Password: Admin@123 -- -- IMPORTANT: Change the password after first login! -- =============================================