Ankit Saxena

WORK HISTORY

EDUCATION

SKILLS

ABOUT ANKIT SAXENA

Professional with more than 12+ years of extensive experience in Oracle PL/SQL development.• Experience with Siebel EIM, PL/SQL and UNIX, Procedures, Functions, Triggers and Views, EIM Import, Export and Delete processes.• Used third party database tools like TOAD and SQL*PLUS for applications development and performance debugging.• Trained on Web logic middleware for Oracle Forms/Reports integration.• Writing Static & Dynamic (REF) Cursors, Dynamic SQL, Records, PL/SQL tables & Exception handlers, performance tuning, partitioning of data and indexing of partitioned tables, tuning application using tools like Explain Plan, and SQL*Trace for high efficiency.• Working with large tables containing an average of 10 million rows, creating different kinds of partitions for managing large tables.• Proficient in writing and tuning complex SQL statements, complex joins co-related sub-queries and SQL statements with Analytical functions (Rank, Lead, Lag etc). • Used Oracle seeded packages like DBMS_SCHEDULER, DBMS_OUTPUT, UTL_FILE and DBMS_STATS.• Experienced in working with DB Links and creating materialized views, User-defined and System defined exceptions to handle different types of Errors like NO_DATA_FOUND, TOO_MANY_ROWS etc.• Enforcing data Integrity using integrity constraints and database triggers as per data model.• Worked closely with technical teams/DBAs for issues related to code changes, data fixes, and testing. • Experience working with different file transfer clients like Smart FTP, Cute FTP and TIBCO.• Developing batch programs by using PL/SQL and shell scripts and in using SQL*Loader for loading data from flat files into Oracle tables. • Hands on experience with Control-M in UNIX environment for scheduling routine tasks.• Worked on creating mapping and PL/SQL Packages for loading data from different legacy systems.• Have worked on archiving data from Siebel applications using PL/SQL packages and procedures.