Anthony Lourdusamy

About Anthony Lourdusamy

PROFESSIONAL SUMMARY• Accomplished Senior Oracle PL/SQL Developer with extensive expertise across the SDLC.• Skilled in designing and architecting robust database applications, specializing in complex SQL queries, advanced PL/SQL development, and performance optimization.• Proficient in leveraging database techniques such as partitioning, indexing, parallel DML, and tools including Explain Plan, TKPROF, ADDM, and AWR for enhanced performance.• Adept in relational and dimensional database design, complemented by strong capabilities in Unix Shell, Perl, and Python scripting.• Experienced in data migration, replication, Oracle RAC, Exadata, and application database administration.• Proficient in client-server, web, middleware, and data warehousing technologies, with a focus on high-volume OLTP systems, data warehousing, and batch processing.• Expert in ETL processes using PL/SQL and Business Objects Data Integrator, alongside hands-on experience with AWS cloud services (EC2, S3, RDS, Lambda).• Familiarity with Containerization and Orchestration tools like Docker and Kubernetes.• Experienced in developing complex queries, aggregations, and Node.js REST APIs for NoSQL databases (MongoDB).• Skilled in developing and maintaining comprehensive design documentation, standards, and best practices• Demonstrates exceptional analytical, problem-solving, and design skills, with a proven track record in Agile and Waterfall methodologies.• Effective mentor and self-driven professional committed to delivering high-quality solutions.• Domain expertise spans Finance, Capital Markets, Asset Management, Telecom, Manufacturing, Retail, and Pharmaceuticals.

Experience

1. Lead Oracle Pl Sql Developer

   Verizon

   May 2023 — Present · Alpharetta, GA, US

   Reseller Solution Suite (RSS) supports provisioning and billing of lines onto Verizon network for resellers, M2M, and lessee business segments. RSS loads and rates usage data from upstream Usage Broker system. Month-end process and six bill cycles are run on rated usage data to generate invoice and send to resellers, lessees and downstream systems.Responsibilities:• Interact with business to understand business requirements.• Capture new requirements and translate them into specifications.• Design technical solutions for the requirements.• Develop PL/SQL packages, Perl scripts and ESP jobs for daily and monthly process.• Monitor, identify and fix application performance issues using Oracle tools.• Provide expert advice and mentor team members.Environment: Oracle19c, PL/SQL, AWR, ADDM, TKPROF, Explain Plan, SQL Plan Baseline, ESP, JIRA, GIT, Perl, Linux, Agile

Education

• Bharathidasan University

  Post Graduate Diploma, Computer Science

• Bharathidasan University

  Master of Science - MS, Physics