Anand Pavan

Background

About Anand Pavan

Professional Summary: 18 Years of Experience in IT as an Oracle Developer (Oracle 19c, 12c, 11g, PL/SQL). Expertise in PL/SQL: Packages, stored procedures, triggers, functions, and cursors. Database Knowledge: In-depth understanding of Oracle database, SQL queries, database performance tuning, and data modeling. Financial Services Domain: Extensive experience in PL/SQL programming within the financial services sector. Optimization Skills: Proficient in cost-based optimization, index tuning, analyzing execution plans, TKPROF, and AWR reports. Database Design: Hands-on experience in database design, implementation, performance tuning, debugging, optimization, monitoring, and capacity planning. DWH and ETL Knowledge: Familiar with data warehousing, ETL processes, RDBMS concepts, dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables, and slowly changing dimensions (Types I, II, Stakeholder Collaboration: Ability to work with stakeholders to understand detailed requirements and design complete user experiences. Soft Skills: Excellent communication and interpersonal skills, self-motivated, quick learner, team player, strong analytical and leadership qualities, and excellent work ethics.