Jagadeesh Dora Email and Phone Number

 10+ years of progressive IT development experience in Oracle 10g, 11g, and 12c (SQL & PL/SQL). 3+ years of experience in Informatica, SQL* Loader and Postgresql development.  Investments, Banking, ERP, CMT, Life Sciences Domain and KRONOS Workforce Central expertise in Oracle SQL, PL/SQL, Oracle Forms & Reports. Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, Analytical functions, developing Forms and Reports. Experience with Informatica Designer Components such as Source Analyzer, Warehouse Designer, Transformation Developer, mapplet and Mapping Designer. ETL Design and ETL development using Informatica Power center 9.0. Expert level Data analysis, Data profiling and Data quality process design. Experience in Database design using Normalization and E/R Diagrams Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Profiler, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning. Experience in developing External Tables, Joins, Indexes and sequences. Responsible for code review, Unit and System Level testing. Manage source control including SVN. Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. Experience in writing Technical design documents and developing unit test documents. Experience coordinating, validating and undertaking unit and integration testing. Excellent communication skills & very good team building and leading abilities and ability to articulate technical problems & solutions in a mixed team environment. Mentor a growing onsite and offshore team in various phases of knowledge transition and day to day maintenance and production support activities.