SUMMARY:

• 7 years of IT Experience with over 6 years of expertise as a Oracle PL SQL Developer in development, testing, and deployment of Enterprise Level Applications
• Adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing with user acceptance testing (UAT), production support, and code completion.
• Hands - on experience with Oracle 9i, 10g environments, SQL Developer, TOAD; SQL*Plus, SQL*Loader, PL/SQL, stored procedures, triggers.
• Proven background developing C, C++ using OCI, Java-based applications, Java Scripts, Applets with JDBC in Unix(Solaris), AIX and Windows Environments; Korn Shell scripting, Perl, awk, sed scripts etc.,
• Keen focus on performance tuning, testing, and quality assurance.
• Collaborate well with project management, business analysts, and department management teams.
• Excellent communication, organizational, and interpersonal skills.

TECHNICAL SKILLS:

Programming Tools: Oracle 9i, 10g new features, C, C++, Java, Java Script, HTML, Visual Basic, Workflow Builder, Application Object Library, Perl, Shell scripting, cron jobs, Autosys, SharePoint, CVS, Informatica Power center 8.5.

Database Applications: Oracle 9i, 10g; iSQL, SQL*Loader, SQL*Plus, PL/SQL new enhancements, Stored Procedures, Triggers, new and improved data types from 10g, R2 DML Error Logging.

Operating Systems: Oracle 8/9i/10g, UNIX, AIX, Linux, Microsoft Windows NT/2003/XP

WORK EXPERIENCE:

Confidential,Charlotte, NC

Senior PL SQL Developer

Responsibilities:

• Research data from multiple Systems Of Records and Design and develop Oracle 10g packages, stored procedures, configuration files, tables, views, external tables and functions; implement best practices to maintain optimal performance.
• With data conversion, Develop various Oracle 10g Applications using 10g's new enhancements to PL/SQL, ISO/ANSI iSQL, SQL, new and improved data types, R2 DML Error Logging, Java and XML, Java using JDBC, C/C++ using OCI.
• Develop Perl, C shell, awk, sed scripts on Unix(Solaris).
• Develop and Deploy objects of Production quality with Change Requests; Develop JILL scripts and Schedule jobs to run on Autosys.
• Develop and manage moderate to complex PL/SQL applications including - performance tuning with indexing, analyzing and SQL trace with TKPROF reports; native compilation; Highly Complex Procedures, Triggers, Materialized Views; Bulk Collects, Bulk loads etc.,
• Develop Informatica Power center 8.5 - Data mappings, Sessions, Work flows, Reusable worklets - Debug session logs.
• Train and manage developers, advising other groups in organization on Oracle development, data warehouse development, and ETL development best practices.
• SharePoint; Conduct code walkthroughs and review peer code and documentation
• Created systems for capturing, reporting, and correcting error data.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Provide on-call support to production system to resolve any issues of file arrivals, bug fixes, human errors.
• Coordinate with business; Gather requirements and design data warehouse and data mart entities.

Confidential, San Leandro, CA

Senior Oracle PL SQL Developer

Responsibilities:

• Senior PL/SQL developer to develop applications for the Confidential 's Dataware House.
• Research data from various sources and Design and develop Oracle 10g packages, stored procedures, configuration files, tables, views, external tables and functions; implement best practices to maintain optimal performance.
• With data coming in from upstream applications, Develop various Oracle 10g Applications using 10g's new enhancements to PL/SQL, new and improved data types, R2 DML Error Logging.
• Develop Perl, C shell, awk, sed scripts on Unix(Solaris) to process and cleanse incoming data.
• Develop applications to partition high volumes of data with range, list, hash, composite partitioning including global, local indexing.
• Performance tuning applications with explain plan, spot bottle necks, remedy with dbms stats package, indexing, analyzing tables and indexes.
• Develop JILL scripts and Schedule jobs to run on Autosys.
• Develop and manage moderate to complex PL/SQL applications including - performance tuning with indexing, analyzing and SQL trace with TKPROF reports; native compilation; Highly Complex Procedures, Triggers, Materialized Views; Bulk Collects, Bulk loads etc.,
• Train and manage developers, advising other groups in organization on Oracle development, data warehouse development, and ETL development best practices.
• SharePoint; Conduct code walkthroughs and review peer code and documentation
• Created systems for capturing, reporting, and correcting error data.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Provide on-call support to production system to resolve any issues of file arrivals, bug fixes, human errors.
• Coordinate with business; Gather requirements and design data warehouse and data mart entities.

Confidential, Little Rock, AR

Senior Oracle PL SQL Developer

Responsibilities:

• Develop applications for Chase credit card services data warehouse
• Design and develop Oracle 10g packages, stored procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Develop various Oracle 10g Applications using 10g's new enhancements to PL/SQL, ISO/ANSI iSQL, SQL, new and improved data types, R2 DML Error Logging, Java and XML, Java using JDBC, C/C++ using OCI. Develop Perl, Korn shell, awk, sed scripts in Unix(Solaris). Schedule jobs to run on Unix using Crontab.
• Develop and manage PL/SQL applications including - performance tuning with indexing, analyzing and SQL trace with TKPROF reports; native compilation; Highly Complex Procedures, Triggers, Materialized Views; Bulk Collects, Bulk loads etc.,
• Develop applications in Pro*C with Oracle including -- performance tuning; Oracle PreProcessor; manage bulk loads, bulk fetches with arrays; memory management, dynamic memory allocation, pointers to memory etc.; create HTML formatted reports with Pro*C programs for end users.
• Train and manage developers, advising other groups in organization on Oracle development, data warehouse development, and ETL development best practices.
• Conduct code walkthroughs and review peer code and documentation.
• Created system for capturing, reporting, and correcting error data.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Provide on-call support to production system to resolve any issues.
• Gather requirements and design of data warehouse and data mart entities.

Confidential, Little Rock, AR

Oracle PL SQL 9i Developer

Responsibilities:

• Developed Oracle 9i applications with full life cycle development including implementation, change management for Confidential credit card services.
• Design and develop applications using SQL Navigator in Oracle 9i environment; develop and implement PL/SQL packages, stored procedures, Triggers.
• Develop UNIX Solaris Korn shell scripts, Perl, awk, sed scripts and processes to extract data from various sources such as Oracle 9i.
• Scheduled various jobs to run periodically using Crontab in Unix environment.
• Used CVS for code management with version controlling.
• Implemented complex transformations by creating custom transformations in addition to using built-in ones.
• Oversaw unit and system tests and assisted users with acceptance testing.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Played role in design of scalable, reusable, and low maintenance ETL templates.

Confidential, South Lake, TX

Oracle Application Developer

Responsibilities:

• Developed E-Business Suite programs for databases supporting supply chain management, order management, inventory, warehouse management system, purchasing, and iProcurement.
• Designed and implemented error checking and correction protocols and programs.
• Built Internet access and GUI interfaces to Relational Database Management Systems (RDBMS).
• Coded, tested, debugged, documented, and maintained programs.
• Created detailed project outlines, application design specifications, and test plans.

Confidential, Little Rock, AR

Oracle Applications Developer

Responsibilities:

• Developed medium to complex sql queries in Oracle 8, and Oracle 9i for marketing campaign applications
• Developed Korn shell scripts to run batch processes with sql scripts
• Performance tuned the sql queries using explain plan, sql trace and tkprof utilities.
• Supported complete water fall methodolgy software life cycle development for data extraction, data cleansing, data transformation and data loading into databases.
• Developed sql, PL/SQL scripts to support data marts for reporting environments
• Participated in business and functinal spec walk throughs. Developed tech specs for the business requirements. Chose direct path when data was very large.
• Used sqlloader to load flat file data into Oracle tables in different ways such as direct and convetional paths.
• Partitioned tables with historical data and created indexes for performance improvements
• Identified bottle necks of slow performing queries such as nested loops, full table scans, high memory usage with sorts and merges, high read writes.
• Improved the sql query performance by creating appropriate indexes, gathering table statistics make available to the Oracle Optimizer.
• Created views and triggers for certain database operations.
• Developed unit test cases, and participated in system and user acceptance testing.