Pavithra Dhanajayam

• 3+ years of experience in Database development interacting with business users; created business design documents end technical design documents for the applications.
• Experience working in all phases of SDLC from analysis, estimate, design, coding, unit testing, system testing end user acceptance testing.
• Experience working in an Agile end Waterfall development environment for Insurance projects.
• Extensively involved in making detailed program specifications, developing test cases, documenting test results, and interfacing with QA/ Test teams and other IT teams for deployment into production.
• Created and used Functions, Indexes, cursor, Table Partitioning, Collections, REFCURSOR, Views, materialized views, indexes, Packages, Exception handling, Dynamic SQL and Triggers, and Stored Procedures in PL/SQL.
• Extensive knowledge of ETL including with Informatic Power Center (9.1) in developing and administering ETL mappings with Designer (Source Analyzer, Target Designer, Transformation Developer, Mapping designer, Maple Designer), Repository Manager, Workflow Manager & Workflow Monitor.
• Experience in DBA activity, SQL performance tuning using explain plan, query Optimizer and Cost-Based Optimization (CBO).

• 3+ years of experience in Database development interacting with business users; created business design documents end technical design documents for the applications.
• Experience working in all phases of SDLC from analysis, estimate, design, coding, unit testing, system testing end user acceptance testing.
• Experience working in an Agile end Waterfall development environment for Insurance projects.
• Extensively involved in making detailed program specifications, developing test cases, documenting test results, and interfacing with QA/ Test teams and other IT teams for deployment into production.
• Created and used Functions, Indexes, cursor, Table Partitioning, Collections, REFCURSOR, Views, materialized views, indexes, Packages, Exception handling, Dynamic SQL and Triggers, and Stored Procedures in PL/SQL.
• Extensive knowledge of ETL including with Informatic Power Center (9.1) in developing and administering ETL mappings with Designer (Source Analyzer, Target Designer, Transformation Developer, Mapping designer, Maple Designer), Repository Manager, Workflow Manager & Workflow Monitor.
• Experience in DBA activity, SQL performance tuning using explain plan, query Optimizer and Cost-Based Optimization (CBO).

I am done my mater's from Cleveland State University, Cleveland, OH in Computer and Information Science.