PROFESSIONAL SUMMARY:

• Senior Oracle Certified Associate developer with more than 16 years of IT experience in system analysis, design, coding, implementation, customization, testing, and performance tuning and production support of business applications in Client/Server, web environments.
• ETL experience using Oracle tools.
• PL/SQL Developer with extensive years of experience in IT, with very strong skills in developing information systems using Oracle Tools at all project stages.
• Extensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements Gathering, Analysis/Design, Development, Testing and Production.
• Extensive experience with Oracle on writing SQL queries and PL/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers, Cursors, and Database Objects.
• Proficient in Databases Conversions, Environment Setups, Security Backup, Restore, Indexes, Portal, Oracle Application Server 9iAS, and SQL Loader.
• ETL Experience using SQL Loader, OEDQ. Knowledge in Informatica.
• Excellent experience in Tuning, Performance and Optimization of queries, partitioning.
• Excellent experience Troubleshooting, Debugging.
• Excellent experience in data modeling and normalization in relational databases.
• Extensive experience working on Waterfall and Agile development environments.
• Extensive experience in high volume of data processing and fast paced database environments.
• Knowledge and experience in applying standard processes and documentation, under CMMI 5.
• Experience working on a wide variety of public and private sectors, including insurance, financial, roadside assistance, education, telecommunication, retail, gas/oil, publications, and government.
• Knowledge and practice in Foreign Exchange (FX) Market - FOREX.

TECHNICAL SKILLS:

Databases: Microsoft Access, Oracle RDBMS 8i/9i/10g/11g/12c, Oracle Forms 4.5/6i/9i/10g, Web forms, Oracle Reports /6i/9i/10g, SQL*Plus, TOAD

Languages: SQL, PL/SQL, Java, HTML, Visual Basic.

OS: Windows (9x/NT/200x Server/XP/Vista), UNIX Solaris.

Scripting: UNIX shell scripting (bash).

Job scheduler: Helpsystems Robot SCHEDULE (IBM), JDOracle Enterprise Manager, SQL*Loader, TOAD, Oracle Designer 6.0/9.

Application Servers: Oracle Application Server OAS 10g, Oracle Enterprise Data Quality (OEDQ) / ETL, Crystal Reports.

Methodologies: CMMI (level 5), UML

Testing: HP ALM, Mantis.

Version Control Software: Concurrent Version System (CVS), Rational Team Concert (IBM-RTC), Plastic, GIT. IT Service Management (ITSM) using ServiceNow.

Informatica: Waterfall, Scrum, Agile.

PROFESSIONAL EXPERIENCE:

Confidential, Webster, MA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Coordination with offshore team on testing plan.
• Client communication and delivery management.
• Creation/modification of Oracle objects to adapt new rating variables for Auto products.
• Solved escalated complex issues in production. Modification of packages and objects, creation of patches to fix inconsistent data.
• Collaborated to offshore team on problem resolution, by transferring knowledge on Confidential TronWeb system.

Environment: Oracle PL/SQL Developer, Oracle 11g R2, Agile, large databases, Java, ServiceNow, RTC, Helpsystems Robot SCHEDULE, Oracle PL/SQL Developer, Oracle 11g R2, Agile, large databases, Java, Plastic.

Confidential, Webster, MA

Sr. Oracle PL/SQL Developer / Technical Lead

Responsibilities:

• Senior Oracle Developer utilizing PL/SQL Developer to create and modify existing stored procedures, and tables, debug poorly conceived complex queries.
• Responsible for writing software to implement requirements for enhancements and bug fixes of in-house custom applications.
• Provided software development support by building, testing and deploying Oracle 11g SQL and PL/SQL queries, packages, procedures, functions and triggers.
• Requirements clarification with Confidential module leads.
• ETL using PL/SQL, Oracle SQL Loader, OEDQ (Oracle Enterprise Data Quality) and Java to extract data from external databases and XML files.
• Management of build requests for packages and data patches sent to production database.
• Version Control Management with Rational Team Concert (IBM-RTC).
• Support to Business Analysts in testing.
• Scheduling of jobs with Helpsystems Robot SCHEDULE.

Environment: Oracle PL/SQL Developer, Oracle 11g R2, XML, Web Services, Agile, large databases, Unix Shell, Java, Jasper, ServiceNow, RTC, Helpsystems Robot SCHEDULE.

Confidential, Webster, MA

Architect - Tech Lead - Sr. Oracle PL/SQL Developer

Responsibilities:

• Management of offshore development team in Colombia (6 people). Designation of tasks, periodic evaluation, revision of timelines and quality of deliverables.
• Responsible for analysis, data modeling, design, implementation and Production Support.
• Designed the logical and physical database structure.
• Extensive development in advanced PL/SQL including xml, dynamic SQL, collections and object oriented code.
• ETL using PL/SQL and Java to extract data from external databases and XML files.
• Developed PL/SQL scripts that migrated data from a client-developed system into tables in a custom environment.

Environment: Oracle PL/SQL Developer, Oracle 11g R2, XML, Eclipse, Agile, SCRUM, large databases, Unix Shell, Java, RTC, CVS, Helpsystems Robot SCHEDULE.

Confidential, Webster, MA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL objects for handling business rules (Technical Controls).
• Use of Oracle objects.
• ETL using PL/SQL and Java to extract data from external databases and XML files.
• Creation of Procedures, Functions, Packages, Database Triggers and Cursors.
• Technical lead in offshore team.
• Worked on Performance tuning on packages and SQL sentences.
• ETL using PL/SQL and Java to extract data from external databases and XML files.
• Ticket reception from Confidential contact and assignment to resources in Colombia, deadlines management

Environment: Oracle PL/SQL Developer, Oracle 11g R2, Eclipse, Web Services, Agile, SCRUM, large databases, Jasper, RTC, CVS.

Confidential , Webster, MA

Sr. Oracle PL/SQL Developer /Technical Leader

Responsibilities:

• Technical lead in offshore team. Responsible for tickets administration and assignment.
• Interacted with Business Users to understand the requirements, defects and enhancements.
• Designed, coded, tested and implemented programs, stored procedures and data base triggers, functions and materialized views.
• Developed and Implemented On-Line and Batch programs by using Oracle PL/SQL.
• ETL using PL/SQL and Java to extract data from external databases and XML files.
• Develop/Maintain/Support various Software applications that are written in oracle PL/SQL.
• Maintenance and enhancements for B2B, Cover-all, and TW applications.

Environment: Oracle PL/SQL Developer, Oracle 11g R2, PL/SQL, Eclipse, Web Services, large databases, Unix Shell, ServiceNow, CVS, Helpsystems Robot SCHEDULE.

Confidential, Miami, FL

Business Analyst

Responsibilities:

• Selected from Colombia TW team to travel to Confidential USA to contribute in Massachusetts Personal Auto project.
• Requirements gathering phase.
• Interviews with users of legacy system to know data flow and to provide knowledge about TW new system.
• Support to Confidential Business Analysts regarding TronWeb features in issuance, claims, and treasury and third parties modules.

Environment: Oracle PL/SQL Developer, Oracle 11g R2, PL/SQL, large databases.

Confidential, Bogotá, Colombia

Senior Oracle PL/SQL Developer

Responsibilities:

• Added new functionality for claims by adding new business rules using oracle PLSQL Packages, Procedures and Functions.
• Developed various Unix Shell Scripts to automate the processes. These include receiving the files from agents, decrypting, loading into a table using Oracle SQL Loader and send out email to DEV team if there were any issues.
• Worked on Performance tuning on many custom processes and reports. One of the processes was sending out the repair files to agents.
• Modifications in core database, on stored procedures, triggers and views.
• Creation of patches and delivery of fixed code to production database.

Environment: Oracle PL/SQL Developer, Eclipse, Web Services.

Confidential, Bogotá, Colombia

Senior PL/SQL Developer

Responsibilities:

• PL/SQL Development in maintenance of Oracle Packages for Internet/TV application for Telefonica (Spain).
• Developed custom Reports and Forms as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed data entry forms, complex and template forms in Forms 6i. Creation of Pop-up Menus and maintaining Master Detail forms.
• Creation of triggers, functions and stored procedures.

Environment: Oracle 11g, PL/SQL. PL/SQL Developer, Oracle Forms 10g, Oracle Reports 10g, Oracle Enterprise Manager (OEM).

Confidential, Bogotá, Colombia

Sr. Oracle PL/SQL Developer

Responsibilities:

• Development and implementation of Phase 1 of a Treasury Management System called MASTER for Banco de la República.
• Development of forms starting from scratch, using Oracle Developer Wizard, or manualy adding canvases (content, stacked, tab).
• Modified and created Oracle Forms and Reports.
• Database design and modeling using Oracle Designer.
• Database normalization.
• Transactional packages in Oracle Database to handle EFT transactions and Anti - Money laundering.
• Creation of flat files for ACH transactions, foreign money exchange.
• Creation of financial reports.

Environment: Oracle 9i, PL/SQL, Toad, Oracle Forms 6/9i, Oracle Reports 6/9i, Crystal Reports, Oracle PL/SQL Developer, Oracle Designer, CMMI 5

Confidential, Bogotá, Colombia

Sr. Oracle PL/SQL Developer

Responsibilities:

• Oracle tools used for maintenance / creation of business databases including all phases of SDLC.
• Costs calculations for retail sales using Oracle packages.
• Created Oracle Forms to supporte sales processes.
• Enhancements for a Call-Center information system for roadside assistance using Oracle Forms and Reports.

Environment: Oracle 9i, PL/SQL, Toad, Oracle Forms 6/9i, Oracle Reports 6/9i, Crystal Reports, Oracle PL/SQL Developer, Oracle Designer, CMMI 5

Confidential, Bogotá, Colombia

Sr. Oracle PL/SQL Developer

Responsibilities:

• Production support. Modification of Oracle packages according to production issues in product database.
• Creation of stored procedures (packages, functions and procedures).
• Data patching and research of root causes.

Environment: Oracle 9i, PL/SQL, Toad.

Confidential, Bogotá, Colombia

Sr. Oracle PL/SQL Developer

Responsibilities:

• Performed modification and development work on a large Oracle Forms 6i based management system that was custom built.
• Tuned and improved the responsiveness of many of the above Oracle Forms by either rewriting code or properly using indexes.
• Created Oracle reports (6i).
• Development from scratch of Oracle Forms (Content, Tab, Stacked canvas) and Reports for Vehicular (transportation) and Home Gas information system.
• Analysis and Design for new system using Oracle Designer, and then creating basic Forms with wizards, and complex designs manually.

Environment: Oracle 8i, PL/SQL, Toad, Oracle Forms, Oracle Reports, Crystal Reports.