Jile La Obstacle

8+ years of experience in systems Analysis, design and development of complex software systems for various domains. * Good exposure of Software Development Life Cycle methods (waterfall etc. ). * Extensive experience in Design, Development, and Enhancement and Maintaining applications in Oracle 9i/10g/11g using SQL, PL/SQL in Windows 9x/NT/2000/XP and UNIX environments. * In-depth Knowledge of Oracle Architecture, Data Dictionary and DBMS Packages. * Performed a major role in database migration. * Expertise in creating database Triggers, Stored Procedures, Packages, functions, Indexes. Strong knowledge in Oracle cursor management and exception handling. * Worked on DML, DDL, and TCLoperations. * Extensive experience in Database query tuning, Performance tuning (Explain Plan and TKPROF utility) of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems. * Extensively used PL/SQL features like collections, nested table, Varray and Bulk collect for high performance of stored procedures. * Good working experience with the usage of Collections, Bulk Insert, Global temp table, Nested tables, External tables, advanced queuing, Materialized Views, Inline Views, Analytical functions and REF cursors. Strong Knowledge on Object oriented Programming. * Experience in developing the webpage using JSP, extensive experience on Java, Java script, Hibernate. * Experience in using Oracle in-built packages like UTL_FILE, DBMS_SQL etc. * Experience in designed and deployment of UNIX Shell Scripts.

* Expert knowledge in using data modeling tools like ER-WIN and ER diagrams with Model mart exposure. * Extensive Knowledge in Normalization Techniques for designing database Relational technology on N-Tier and created database reports to monitor the project. Experience in debugging the performance issues and bugs within packages, forms, and reports using dbms_output. * Excellent Knowledge of Business Intelligence and Data Warehousing Concepts and used tools like Data stage. * Managing co-ordination of the partners and working groups engaged in project work. Technical Skills: Languages| PL/SQL, SQL, Shell Programming, C, C++. | Databases| Oracle11g, 10g, 9i, SQL Server 2008/2005/200| GUI / Tools/Utilities| SQL* Loader, TOAD 8. 0/7. 1, PL/SQL Developer, Data Pump (Import/Export), SQL* PLUS, ERWIN 3. 5/4. , SQL Navigator MS VISIO, VI Editor, Oracle Wrap, FTP, SFTP, Explain Plan, TKPROF, Microsoft Excel, Microsoft PowerPoint, Forms 10g/9i/6i. Reports 10g/9i/6i. | Operating Systems| Unix/Linux RHEL 5,Sun Solaris 2. x/7/8, HP-UX 10/11i, Windows XP/ NT 4. 0/ 2000. | Scripting| Unix Shell Scripting| Reporting Tools | Crystal Reports 2008/XI, Business Objects XIr3. 1,XIr2,XI| Professional Experience: Johnson & Johnson, New Brunswick, NJ March 2012-Till Date Role: Oracle Developer Responsibilities: Involved in the transition phase to understand the business and the technologies used to maintain the data base of the client. * Worked in finding manageable strategies to handle massive amounts of data (millions of records per day) in a production environment. The company and the nature of the environment impose strict use of best software designing principles and quality assurance practices. * Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling. * Worked on building user interfaces to the database employing Java. Debugged the performance issues by using Oracle Hints, Explain plans and Table partitioning.

* Developed and Modified the PL/SQL Packages, Procedures, Functions and Database Triggers using the oracle advanced techniques Bulk Processing. * Requirement Analysis, Impact Analysis, Coding & Unit Testing of Production Requests and Change Requests of database. * Developed a Java program for automatic batch loading. * Developed re-usable components in Oracle and UNIX. * Worked with Heterogeneous Source Systems like oracle, Sql server, Teradata, Flat files. Extracted data stored in a multi-level hierarchy using Oracle Stored Procedures * Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database. * Used concepts like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions,Insert All, Global Temporary tables * Developed Client-Server applications using front-end tools like Oracle Developer 2000 – Forms 10g,Oracle Reports 10g, SQL*Loader, Data Pump and SQL*Navigator. * Creation, execution and reviewing of Regression and unit test plan for new requirements. Created Autosys jobs on UNIX shell scripting Background. * Encapsulated error handling and use of autonomous transaction for logging. Used UTL_FILE for exporting data and UTL_MAIL to generate E-mails. * Writing scripts for Data Staging, Loading and cleanup process. * Involved in Unit Testing Stored Procedures and Functions. * Automated various tasks which required manually intervention. Environment: Oracle 11g/10g, SQL*Loader, forms 10g, reports 10g, SVN, TOAD 10. 1 Java, Oracle Designer, Clear case, Clear quest , UTL_FILE, Sun Solaris/Windows XP/Linux ,UNIX Shell Scripting, Crystal Reports 2008, PERL.

Fedex, Memphis, TNJan 2011- Mar 2012 Role: Oracle Developer Responsibilities: * Analyzed the existing code and optimized, enhanced the existing procedures and SQL statements for the better performance. * Involved in the design phase of the development. Responsible for the physical as well as logical design of physical configuration on the storage media. * Importing data from flat files and Excel sheets to Oracle using SQL* Loader * Development of PLSQL scripts. * Global Technical Architecture Design for Enterprise Data Warehouse. * Designing the forms for various modules. Created weekly, monthly and quarterly reports. * Generating graphs from the processed data using Excel and power point for presentation. * Involved in monthly production support and process the batch jobs and troubleshoot the problems. * Created dynamic SQL queries using Execute Immediate statements. * Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools/utilities like Explain plan, DBMS_Profiler, Auto*Trace, SQL Trace, TKPROF etc. * Extensively used hints to direct the optimizer to choose an optimum query execution plan. Expertise in debugging the code and creating the exceptions to handle bad data and send them to error log files. * Used various control structures like Case, Decode, IF-Then-Else, For Loop, While Loops while developing procedures, used SQL Joins. * Loaded the data using the SQL loader, Imports & UTL files based on file formats. * Extensively worked using autonomous transaction and triggers to keep the track of DML operations. * Processed data using both implicit cursor and explicit cursor. * Used Records and Collections extensively in Packages in order to improve the package performance. Extensively Worked with Table Partitioning and used various partitioning strategies like Range Partitioning, Hash Partitioning, List Partitioning, Range-Hash Partitioning, Range-List Partitioning etc. * Performed Unit Testing on the developed code to ensure it is bug free. Environment: Oracle 10g, HP-Unix, Oracle Enterprise Manager, UTL_FILE ,VSS, SQL*Loader, SQL*Plus, Toad Data Modeler, Java, Clear case, Clear quest ,Windows XP, UNIX Shell Scripting. Credit Suisse, Raleigh, NC Dec 2008 – Dec 2010 Role: Oracle Developer

Responsibilities: * Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data * Worked on SQL*Loader to load data from flat files obtained from various facilities every day * Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements * Wrote Unix Shell Scripts to process the files on daily basis like renaming the file ,extracting date from the file ,unzipping the ile and remove the junk characters from the file before loading them into the base tables * Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances * Developed PL/SQL triggers and master tables for automatic creation of primary keys * Created PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart * Created indexes on the tables for faster retrieval of the data to enhance database performance * Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan. Data loads are been performed by using the SQL loader, Imports & UTL files based on file formats. Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between sql and pl/sql engines

* Partitioned the fact tables and materialized views to enhance the performance * Created records, tables, collections (nested tables and varrays) for improving Query performance by reducing context switching * Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application Environment:Oracle 10g, HP-Unix, Oracle Enterprise Manager,UTL_FILE, VSS, SQL*Loader, SQL*Plus, Toad Data Modeler,Clear case, Clear quest ,Forms/ Reports 10g GE Advance Materials, Waterford, New York April 2007 – Nov 2008 Role: Oracle Developer Responsibilities: Involved in the Analysis, Design, Coding and Testing of the application * Developed and Modified the PL/SQL Packages, Procedures, Functions and Database Triggers using the oracle advanced techniques Bulk Processing Developed ER Diagrams, Data flow diagrams based on the requirement * Developed SQL scripts to create database objects liketables, views and sequences * Used SQL*Loader to load bulk data from various flat files and legacy systems * Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for better performance. * Developed SQL and PL/ SQL scripts for transfer of data between databases * Developed complex SQL queries for reports * Developed complex triggers in reports before/after for validation of ser input * Performed unit testing and supported integration testing and end user testing * Extensively worked on production issues with effective defect management

* Involved in logical and physical database design, Identified Fact Tables, Transaction Tables * Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency * Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS_PROFILERetc * Extensively worked with table partitioning and table space creation etc * Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance * Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformation Environment:Oracle 9i, ERWIN 3. 5, UTL_FILE, Toad 7. 5, Forms 9i/6i, Reports 9i/6i, ASP. NET 4. 0, XML, HP-AIX Comcast Corp. , Philadelphia, PAFeb 2005 – Mar2007 Role: Oracle Developer Responsibilities: Understanding the customer requirements, analysis, design, development and implementation into the system, Gather and define business requirements, improve business processes. * Designed and developed PL/SQL functions, stored procedures, cursors, packages, triggers. * Involved in performance fine-tuning of the queries, report using PL/SQL and TOAD. * Involved in Database Design & Data Modeling (ERWIN).

* Designed and developed GUI front-end using OracleForms 6ifor user interaction with the database. * Involved in writing complex queries to generate reports as per client request as a part of production support. * Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL. Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc. * Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader. * Provide functional requirements to describe system process, as well non-functional requirements to describe performance, scalability, security and usability requirements. * Optimized different SQL queries to insure faster response time. * Developed screen layouts, report layouts using Forms and Reports and participated in implementation. Environment:Oracle 9i, HP-Unix, Oracle Enterprise Manager, VSS, SQL*Loader, SQL*Plus, Toad,Data Modeler