beBee background
Professionals
>
Engineering / Architecture
>
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

See professionals near Bethlehem, Ohio

Other users who are called Pavithra

Jobs near Bethlehem, Ohio

  • Insight Global

    Project Engineer

    Found in: Appcast Linkedin GBL C2 - 2 days ago

    Insight Global Canonsburg, United States

    Required Skills and Experience * · 4-year engineering degree or equivalent technical training · 5 years' experience/knowledge of construction required. · Advanced knowledge of construction project execution, industry standards, and practices; plus, an in-depth understanding of th ...

  • KELLER - North America

    Site Engineer

    Found in: Lensa US 4 C2 - 5 days ago

    KELLER - North America Mingo Junction, United States

    Company Logo: · Overview: · RECON has successfully completed over 6,000 environmental remediation, geotechnical and mine reclamation projects across North America since 1989. Our team of dedicated employees, financial strength, and large fleet of equipment empower RECON to deli ...

  • Tapestry

    Temporary Sales Associate

    Found in: beBee S2 US - 6 days ago

    Tapestry Smithfield, United States

    Coach is a global fashion house founded in New York in 1941. Inspired by the vision of Creative Director Stuart Vevers and the inclusive and courageous spirit of our hometown, we make beautiful things, crafted to last—for you to be yourself in. · Coach is part of the Tapestry por ...