? 2+ years of experience in IT industry with working experience in Development of Oracle PL/SQL. ? Experience in writing PL/SQL procedures, Functions, Packages and Triggers. ? Experience in writing Cursors, Collections and Handle the Exceptions. ? Experience in writing design documents based on Functional Requirements. ? Experience on Development of Unified Data Migration Framework. ? Knowledge on SQL Performance Tuning. ? Good Experience on Oracle 10g, UNIX and SQL * Loader. ? Experience on Informatica 8.6.0. ? Good communication, presentation and interpersonal skills. ? Ability to adapt quickly to new technologies and environments. ? Ability to handle multiple projects and a good team player.
? Working as Technical Associate for Techmahindra Ltd, Bangalore from Nov'2009 to till date. ? Worked as Software Engineer for Spes InfoTech Ltd, Bangalore from April'2009 to Oct'2009.
? M.C.A from S.K.University with 74% marks in the year 2009. ? B.Sc from S.K.University with 74% marks in the year 2005. ? 12th from Sri SaiRam Jr.College with 85% marks in the year 2002. ? 10th from Z.P.High School with 73%marks in the year 2000.
? Languages Oracle PL\SQL, SQL ? RDBMS Oracle 10g/9i ? Tools PLSQL Developer, Toad ? ETL Informatica 8.6.0 ? Operating Systems Windows XP, UNIX.
Project Name IPID-UK rPACS Period Nov' 2009- till Environment Oracle 10g, PLSQL Developer, ETL, Windows XP Role Developer
IPID is Physical Inventory Database it is used to store all network elements and PACS is a Planning Assignment Configuration System. It is an Oracle based System used to maintain the Quality of data instead of IPID. Migrate the Black Box, Fully Model and Broadband data from IPID to UK_rPACS. It follows the levels of Hierarchy like Equipments, Slots/Cards, Ports and Connections.
? Design the UDMF process for Extracting, Transform and Load data into rPACS. ? Writing of Procedures, Functions and Packages to meet business logics. ? Involved in load Flat File data using SQL * Loader. ? Developed various Procedures for applying Transformation rules. ? Involved in Fallout Management Process. ? Developed Packages for Data Reconciliation and Rectification. ? Writing the test cases for unit testing. ? Involved in design the UDMF Document.