SUMMARY

• 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.
• Over 16 years of IT experience in system analysis, design, coding, implementation, customization, testing and production support of business applications in Client/Server environment.
• Analysis and Design with Oracle Designer, and Development using Oracle Forms, Oracle Reports, and PL/SQL.
• Extensive noledge 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 8i/9i/10/11g/12c on writing SQL queries and PL/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers, Cursors, and Database Objects.
• Proficient in Databases Conversions, Application Tuning, Environment Setups, Security Backup, Restore, Indexes, ETL, Portal, Oracle Application Server 9iAS, SQL Loader, TOAD and FTP.
• Excellent experience in Development, QA, Test and Production environment.
• Excellent experience in Tuning, Performance and Optimization of queries.
• Excellent experience modeling relational databases.
• Extensive experience working on Waterfall and Agile development environments.
• Extensive experience in high volume of data processing and fast paced database environments.
• Good understanding of Oracle data dictionary.
• Experience working in large scale information systems.
• Development on OLTP Plattforms.
• 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 (forensic and national voting polls).
• Excellent Interpersonal and Communication skills, coupled with strong technical and problem solving capabilities.
• Work well in close cooperation with project managers and other team members
• Work well independently or as a part of a team.
• Knowledge and practice in Foreign Exchange (Fx) Market - FOREX.
• Extensive experience in all phases of SDLC (Software Development Life Cycle). Oracle RDBMS 8i/9i/10g/11g/12c, advanced skills in Oracle Developer Tools such as SQL and PL/SQL, Oracle Forms 4/6i/9i, Oracle Reports 6i/9i. ETL process using PL/SQL.
• Crystal Reports.
• Production support environments using ServiceNow.
• SCM (Source Code Management) experience with different tools: CVS (Concurrent Version System), RTC (Rational Team Concert), Plastic.

TECHNICAL SKILLS

Databases: Microsoft Access, Oracle RDBMS 8i/9i/10g/11g/12c.

Development Platforms: 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), Perl.

Job scheduler: Helpsystems Robot SCHEDULE (IBM), Query performance (SQL Tuning), Database Design and Modeling, DBA tasks, Backups, Export, Import

Methodologies: CMMI (level 5).

Testing: HP ALM, Mantis.

Other technologies: HTML5

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

PROFESSIONAL EXPERIENCE

Confidential, Webster, MA

Test Lead

Responsibilities:

• Testing activities using Oracle tools and TronWeb.
• Coordination with offshore team.
• Client communication and delivery management.

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

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Senior Oracle Developer utilizing PL/SQL Developer for Oracle and provided PL/SQL and SQL support to create and modify existing stored procedures, and tables, debug poorly conceived complex queries.
• Solved escalated complex issues in production. Modification of packages and objects, creation of patches to fix inconsistent data.
• Worked on Performance tuning on packages and SQL sentences.
• Collaborated to offshore team on problem resolution, by transferring noledge on MAPFRE TronWeb system.

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

Confidential, Webster, MA

Sr. Oracle PL/SQL Developer / Technical Lead

Responsibilities:

• Senior Oracle Developer utilizing PL/SQL Developer for Oracle and provided PL/SQL and SQL support 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 and commercial off the shelf software packages.
• Provided software development support by building, testing and deploying Oracle 11g SQL and PL/SQL queries, packages, procedures, functions and triggers.
• Requirements clarification with MAPFRE module leads and directions to offshore team in Colombia about fixing/enhancing needs.
• Delivering of fixed packages and data patches to production database.
• Software configuration in Production.
• Version Control Management with Rational Team Concert (IBM-RTC).
• Worked on Performance tuning on packages and SQL sentences.
• Support to Business Analysts in testing.
• Scheduling of jobs with Helpsystems Robot SCHEDULE.
• Responsible to meet the timeline of the development activities and to negotiate with offshore team over design elements and deadlines.
• Management of assignments in offshore team (12 people).
• Management of tickets according priorities and impact. Productivity was raised to fix fifty issues by month.

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

Confidential

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.
• Manipulated tables in the database with the use of SQL, SQL * Plus, PL/SQL.
• 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 Databases and XML files (OLTP).
• Developed PL/SQL scripts dat migrated data from a client-developed system into tables in a custom environment.
• Version Control Management with Rational Team Concert (IBM-RTC).
• Modification of Jasper reports.

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

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed stored procedure APIs for the middle tier of the infrastructure .
• Defined sufficient error handling rules from the database layer into the application layer.
• Developed PL/SQL objects for handling business rules.
• Modified and created Oracle Forms and Reports dat utilized the migrated data.
• Use of Oracle objects.
• Developed Technical Controls using triggers and modifying existing stored procedures.
• Creation of Procedures, Functions, Packages, Database Triggers and Cursors.
• Worked on Performance tuning on packages and SQL sentences.
• Creation of new tools to allow creation of insurance quotes having existing policies as source.

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

Confidential

Sr. Oracle PL/SQL Developer /Technical Lead

Responsibilities:

• Performed modification and development work on a large Oracle Forms 6i based manufacturing work floor management system dat was custom built.
• Tuned and improved the responsiveness of many of the above Oracle Forms by either rewriting code or properly using indexes, thereby improving work floor turn-around time.
• Worked on Performance tuning on packages and SQL sentences.
• Created, managed, tuned, and tested the Oracle PL/SQL data migration scripts dat would port the schema of the above-mentioned application to a new database format.
• Technical lead in offshore team.
• Ticket reception from MAPFRE contact and assignment to resources in Colombia, deadlines management.
• Version Control Software: Concurrent Version System (CVS)

Environment: Oracle PL/SQL Developer, Oracle 11g R2, Oracle Forms, PL/SQL, Eclipse, Web Services, large databases, ServiceNow, CVS.

Confidential

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 materialize view for COTT, OMAC, SOLAR Systems by using Oracle PL/SQL, MS SQL Server, DB2
• Developed and Implemented On-Line and Batch programs by using Oracle SQL, SQL*Plus, PL/SQL
• Designed and developed various custom packages triggers and forms.
• Developed various database objects including Packages, Procedure, Functions, Views, Triggers, Sequences and Synonyms using SQL and PL/SQL as per the requirement.
• Maintenance and Support of Customer apply process which is used in executing Honda Service campaigns.
• Worked on Performance tuning on packages and SQL sentences.
• Automated various Forms/reports and processes through Appworx scheduler so dat manual intervention is not needed.
• Develop/Maintain/Support various Software applications dat are written in oracle PL/SQL, SQL and UNIX.
• Maintenance and enhancements for B2B, Cover-all and TW applications.

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

Confidential

Business Analyst

Responsibilities:

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

Environment: Oracle PL/SQL Developer, Oracle 11g R2, Oracle Forms, PL/SQL, XML, Eclipse, Web Services, Agile, large databases.

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed inbound processes to load the data into database tables using Oracle SQL Loader.
• Added new functionality for Merchandize return policy 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 vendors, decrypting it, 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 vendors.
• PL/SQL Developer in issuance, third party, treasury and claims modules.
• Modifications in core database, on stored procedures, triggers and views.
• Creation of patches and delivery of fixed code to production database.
• Creation of forms and reports using Oracle Forms and Oracle Reports.

Environment: Oracle PL/SQL Developer, Eclipse, Web Services, AS/400, Oracle Forms, Oracle Reports.

Confidential

Senior PL/SQL Developer

Responsibilities:

• PL/SQL Development in maintenance of Oracle Packages for Internet/TV application for Telefonica (Spain).
• Developed custom Forms and Reports 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 relation-ship.
• Creation of forms using Oracle Forms.
• Creation of triggers, functions and stored procedures.
• Execution of patches in production database.

Environment: Oracle 11g, PL/SQL. PL/SQL Developer, Oracle Forms 6/9i, Oracle Reports 6/9i, Oracle Enterprise Manager (OEM), ERWIN.