Description
Professional Summary - * Oracle Advanced Certified Professional with around 10 years' experience of programming as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). - Strong experience in the Analysis, design, development, testing and Implementation of database solutions and translating business requirements into design. - Expertise in data analysis to extract, interpret and analyze the application data - Worked as Senior Consultant for key client of Capgemini, leading team for development of Business flows, complex reports and system performance tuning. - Worked as Senior Developer, Team leader and Individual Contributor for noted clients of Tata Consultancy Services (TCS), in development of Business flows, provided Technical guidance, done Quality analysis. - Extensive working knowledge on various versions of Oracle Database with proficiency in SQL and PL/SQL - Expertise in handling Query Optimization, Performance Tuning, Trouble shooting, transaction management mechanism, and referential integrity, Packages, Stored Procedures, Triggers and Export/Import Utilities. - Hands-on wide experience in Translating business requirements into database objects viz - Tables, Indexes, Constraints, Triggers, Stored Procedures, and Views. - Competent in PL/SQL coding with enhanced debugging and error handling using advanced programming techniques like dynamic SQL, Analytical Functions, hierarchical queries, Bulk, etc., - Proficiency in Advanced PL/SQL like Dynamic SQL, UTL packages for File handling, Ref cursors, Table Partitions - Strong experience in Extraction, Transformation and Loading (ETL) data from various sources using SQL Loader and Informatica - Professionally trained in Informatica and implemented pilot projects to develop mappings that perform Extraction, Transformation and load of source data - Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting and TWS scheduler - Strong knowledge and adherence to Change and Release Management. - Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing. - Excellent interpersonal and communication skills and professional in working with direct clients. - Excellent technical documentation skills