SUMMARY:

• Overall 16 years of software development experience, 10+ years of experience as an Oracle PL/SQL Developer in Analysis.
• Excellent skills in designing and development of applications using Oracle 11g /10g/9i/8i SQL, PL/SQL
• Good knowledge on Oracle tools like SQL* PLUS, PL/SQL, SQL and used TOAD in many development projects.
• Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms .
• Experience with database objects like Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, parameterized cursors, Views, Materialized Views, PL/SQL collections and Database Link.
• Expertise in developing advanced PL/SQL code through various stored procedures, functions, cursors, triggers, packages and materialized views.
• Experience in Bulk Data loading using Oracle utilities namely SQL Loader and External Tables.
• Expertise in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, SQL Trace, Explain Plan, Bulk Collect feature, Materialized Views and Troubleshooting Oracle database issues.
• Worked on Crystal Reports.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re - Write and Transportable table spaces.
• Experienced in DB Design, PL/SQ Development.
• Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader and UTL File Utilities .
• Proven track record of database design and modeling.
• Good knowledge of Data Modeling using ETL tools, Entity-Relationship Diagrams .
• Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.
• Team Player with ability to maintain team spirit and resolve conflicts within the team with ease and calmness. Ability to drive team with ideas and thoughts and keeping everyone engaged.
• Added ability to manage work under pressure in addition to solving problems correctly.
• Experience in managing Oracle SQLldr tool for loads of high volumes of information.
• Expertise in analysis, design, develop, implementation of database processes to handle high volumes of information.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables. Worked extensively on Ref Cursor, External Tables and Collections.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/8i, Access 2007/2010, and SQL SERVER

Operating Systems: Windows 7, Windows XP/2003/2000/NT/98/95, UNIX, LINUX, (ubuntu, debian)

Languages: VBscript, JavaScript, SQL, SQL ANSI, PL/SQL, UNIX, Linux, HTML, CSS, Visual Basic, Visual Basic .Net, ASP classic, SQL transaction

ETL Tool: SQL Loader

Frontend tools/Utilities: TOAD, Oracle SQL Developer, Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential

Leader Senior Oracle PL/SQL Developer

Responsibilities:

• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Created, debugged, and modified stored procedures, triggers, tables, views, user-defined functions etc.
• Involved in Preparing Detailed technical documents
• Involved in Code Review and preparing unit test cases
• Involved in Writing Backend Procedures, Function & Packages in PL/SQL
• Trouble shooting and provide 24x7 supports for Production environment.
• Maintained the data integrity and security using integrity constraints and database triggers
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Involved in the analysis of the existing database.
• Defining and reviewing the coding standards, besides reviewing the code.
• Preparation of Checklists, identification of Test Cases, preparing Test Plans.
• Integrating and deploying in production
• Designing database using Erwin
• Generated web pages directly from an Oracle9i database by using PL/SQL Web Toolkit.
• Data modeling, database design and creation of database using data modeling tools (Creation of Data Flow diagrams and Entity Relation Diagrams using Erwin.
• Extensively involved in database design and creation.
• Expertise in Unix environment and shell scripting. Excellent knowledge in Batch Jobs using UNIX CRONTAB, Autosys, UNIX Shell Script (csh, bash, ksh).
• Modifying triggers, functions, procedures to accommodate ongoing changes in business logics, Scripts to automate manual tasks using oracle built-in packages.
• Extensively used SQL* Loader, Export tables, External Tables and Oracle utilities for data loading process.
• Created and manipulated PL/SQL tables (i.e. Index-by Tables and Nested tables) and Varrys.
• Handling PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, Granting and Revoking Schema Object Privileges and Roles, Responding to System Events through Triggers.
• Created sub programs with Dynamic SQL at both client and Server side (DBMS SQL, Native Dynamic SQL at Server Side and EXECUTE SQL at Client side).
• Separating of tables and indexes on different locations. Reducing Disk I/O Contention etc.
• Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS etc. Oracle query tuning and optimization.
• Initiating the project with identifying the requirements, estimating and designing. Ensuring and implementing a good development plan. Work distribution and tracking is one of the prime responsibilities.
• Database design, E-R diagrams, Logical, Physical layout design using Erwin.
• Co-ordination between development, testing and production teams and attending bridge calls and technical. Discussions regarding future developments and releases.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• 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, functions and packages for moving the data from staging area to data mart.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.

Environment: Oracle11g, PL/SQL, SQL*PLUS, SQL* Loader, Oracle Jobs, Toad, Unix, Shells, Linux

Confidential, Boston, Massachusetts

Leader Senior Oracle PL/SQL Developer

Responsibilities:

• Supporting existing PL/SQL back-end functionality, creation of ad-hoc reports and alarms, optimization of existing reports and PL/SQL solutions, interaction with customers.
• Designed data model and created necessary objects in Oracle database, developed and debugged PL/SQL package, created queries for alerting system, monitored performance of solution, tuned it up.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Writing packages, complex stored procedures, functions, views, and data base triggers using SQL and PL/SQL in Oracle.
• Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shell Scripts 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 file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• 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, functions and packages for moving the data from staging area to data mart.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.

Environment: Oracle11g, PL/SQL, SQL*PLUS, SQL* Loader, Oracle Jobs, Toad, Unix, shells, Linux

Confidential

Leader Oracle PL/SQL 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 shell Scripts 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 file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• 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, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Create new reports with Excel, visual basic for application and connection to oracle database.

Environment: Oracle10g, PL/SQL, SQL*PLUS, SQL* Loader, Oracle Jobs, Toad, Unix, shells, Visual basic.

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Supporting existing PL/SQL back-end functionality, creation of ad-hoc reports and alarms, optimization of existing reports and PL/SQL solutions, interaction with customers.
• Performing as software engineer in test on C#, .Net, Java, PL/SQL and SQL solutions, including test case preparation, back-end functionality testing, bug reporting and investigation drilling down onto the database code generated by application, development of customized SQL and PL/SQL solutions, optimization of used standard techniques, all these include interaction with developers to provide full description, key reason of the bug, necessary proofs and possible fixes.
• Deployed rollout of the new version of the application, including configuration of harmonization layer to provide multi-vendor and multi-technology functionality, customized the tool using PL/SQL and Perl scripts, participated in training and documentation writing.
• Led two subprojects with two teammates in each: SQL queries analysis, harmonization and development of the policy of reports migration to the new release of the tool and from Oracle specific queries to Teradata specific SQLs.
• Provided application training for newcomers using standard training materials, trained customers to introduce functionality of the deployed version of the tool as well as training to introduce options and features of new version.
• Worked on projects independently and as a member of a team was involved in the different phases of software development process including requirements analysis, planning, modeling, implementation, testing and deployment.
• Worked with partitioned tables in very large database.
• Writing packages, complex stored procedures, functions, views, and data base triggers using SQL and PL/SQL in Oracle.
• Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
• Schedule Oracle jobs for update, validate data and create vendor reports for analysis.
• Use Oracle Collections, Bulking techniques, Partition utilization to increase performance.
• Interact with the clients, collect requirement, and develop technical specification.
• Development of Store Procedures, Triggers, Views, materialized views, DBLinks, maintenance of millions of data records.
• Suspend the Rating & Roaming (Correction of Stories). Administration, maintenance and process blanketing Online Bach and driving Shells, (PL / SQL), Unix, Oracle Stores Procedures, Package and PL/SQL anonymous, resolution of inconsistencies Care regarding product plans and postpaid lines.
• Very Good experience with UNIX Cron Jobs, Batch Processing with highly complex data model
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
• Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.

Environment: Cobol, DB2, Oracle10g, PL/SQL, SQL*PLUS, SQL* Loader, Oracle Jobs, Toad, Unix, shells, Visual basic.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Bearing in my responsibility 10 people project leaders and programmers. As leader of my area verify that the objectives set by the directors of the company are met, and to reach those goals laid out in a timely manner.
• Administration, management and implementation of systems for different areas such as General direction, coordination, management, supervisory and sales force nationwide afore, driving net ASP platforms (web pages), Crystal Reports (Report), OLAP CUBES, SQL Server, Visual Basic. Net.
• Supporting existing PL/SQL back-end functionality, creation of ad-hoc reports and alarms, optimization of existing reports and PL/SQL solutions, interaction with customers.
• Performing as software engineer in test on C#, .Net, Java, PL/SQL and SQL solutions, including test case preparation, back-end functionality testing, bug reporting and investigation drilling down onto the database code generated by application, development of customized SQL and PL/SQL solutions, optimization of used standard techniques, all these include interaction with developers to provide full description, key reason of the bug, necessary proofs and possible fixes. designed data model and created necessary objects in Oracle database, developed and debugged PL/SQL package, created queries for alerting system, monitored performance of solution, tuned it up.
• Vital Signs Project. Based on information processing of volumetric clients allowed us to make a consolidated report at the national and sub-levels to see the financial and statistical behavior of the afore against the others. Well as future projections of high or low that might arise.
• Scope and Achievements: Helped managers in the various decision-making for their area
• Project Boards dynamic. Based on the organizational structure allowed comparisons for each of the areas of sales force of top ten of the best areas nationwide and online.
• Project control unit. This system allowed scanning formats remittances from clients (new capacity) and that the administration of the information was contained in a database. Allowing the validation of information was as small as possible. curps robot. As a complement to project control unit design a robot that generate new customers curps graduated through Redican external systems and printing up to 20% of document requisition promoter.
• System arrivals. This system allowed a better accounting of the money of customers just graduated and those who were transferred to other afores, validating in VSM (times minimum wage) and outgoing national.

Environment: oracle PL/SQL, windows XP/200x, SQL Server 2000, SQL transaction, Crystal Reports, Visual basic 6.0, VB.Net, ASP.Net.

Confidential

Software Developer

Responsibilities:

• Design & Developed projects in ASP and SQL Server as well as intranet systems implemented with ASP.Net and SQL Server 7.0, client-server projects Visual Basic 6.0, developing reports in Crystal Reports.
• Development of SAC system. This system helps to automate all the activities for newspaper subscriptions giving a smooth and centralized management of information.
• Database Administration SQL Server 7 and 2000.
• Design and development of intranet system for catalog management, process scheduler, migration information and automatic backups
• Design a little site web intranet for manage catalogs from web with asp and internet information service

Environment: Windows 2000 server. Windows XP, SQL server 7/2000, SQL Transaction, Crystal Reports, Asp Classic, IIS (internet information Services), visual basic 6.0, VBScript

Confidential

Software Developer

Responsibilities:

• Developed Platform Vantive (old platform based in VB 4.0) of PeopleSoft
• Analysis, design, develop in database Informix projects Visual Basic 6.0 and Informix
• Reports with Crystal Reports. projects ASP (Intranet / Internet) and Informix,
• UNIX processes function in bullfights processes for BD informix,
• Administration BD SQL Server
• Informix developer stores procedures and background process

Environment: Windows XP, Windows 2000 server. Unix, Informix 4GL, ASP classic, Vantive, visual basic, VBScript, Shell.

Confidential

Responsibilities:

• Attended daily scrum meetings with the team for daily updates on the projects
• Communicated with different client, team members, project managers, and co-workers
• Worked with Business Analysts and customers to understand and validate end-user requirements in accordance with business need.
• Develop PL/SQL packages, Procedures, Functions, Triggers by Using TOAD.
• Developed advanced Web Reports by using PL/SQL, SQL, HTML, JavaScript, and CSS.
• Managed multiple assignments, set priorities and meet deadlines.
• Performed key role in cross-functional teams through development, testing, and product launch.

Environment: Windows NT 4.O. Windows XP. Unix, Oracle (10g, 11i), Dynamic SQL, PL/SQL 8.0, SQL*PLUS, TOAD, HTML, JavaScript, LAMP, VB 6.0. And MKS.

Confidential

Analyst/Developer

Responsibilities:

• Creating level information systems (client - server)
• Visual Basic, ASP interact with database SQL Server 7.0, 2000
• Management Client Access (AS/400), SAP, Erwin. developing Intranet Web sites to meet the needs of users (Elektra Stores, The one, Salinas y Rocha, Unefón)
• ASP, VBScript, HTML.
• Activities DBA SQL server 7.0 (Database Administrator), Data migration, maintenance, cleaning, correcting and table creation, DTS, stores, triggers, cursors.

Environment: Windows 98/95/XP, SQL SERVER, 7.0/2000, SQL TRANSACTION, SQL ANSI, AS/400, Windows NT workstation, Windows 2000 advancer server.