beBee background
Professionals
>
Bethlehem
Pavithra Dhanajayam

Pavithra Dhanajayam

SQL Developer

Engineering / Architecture

Bethlehem, Ohio

Social

1 Followers

About 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).

Experience

• 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).

Education

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

Professionals in the same Engineering / Architecture sector as Pavithra Dhanajayam

Professionals from different sectors near Bethlehem, Ohio

Other users who are called Pavithra

Jobs near Bethlehem, Ohio

  • developer l4

    1 month ago

    Wipro Houston

    Provide L4-level production support, troubleshooting, and RCA for .NET/SQL applications. · Handle incident, problem, and change/Release management activities. · Develop minor enhancements and improvements using .NET Core and SQL Server. · O · ...

  • Advanced Embedded Software Engineer- Test Systems Developer

    1 month ago

    GeoLogics Corporation Canonsburg, PA

    We are seeking a skilled Software Engineer - Test Systems Developer to join our cross-functional team responsible for sustaining and creating software for embedded applications. · ...

  • Lead Java Developer

    3 weeks ago

    Jobs via Dice Toronto

    We are seeking a Lead Java Developer with 6 years of experience in Spring Boot, Java REST API development, and Kafka-based event-driven architectures. · Handson expertise in Spring Boot Java REST API development and Kafkabased eventdriven architectures. · Strong understanding of ...