Sr. Pl/sql Developer Resume
Chicago, IllinoiS
SUMMARY
- Over 6 years of development experience as an ODI Developer, Oracle Database Designer and Developer in Analysis, Design and Implementation of Business Applications using Oracle Relational Database Management System (RDBMS).
- Strong experience in translating business requirements into creation of Database Objects.
- Strong experience in writing Complex Database Objects like Stored Procedures, Functions, Cursors, Triggers and Database Administration.
- Strong experience in SDLC including Water fall and Agile Scrum environments in Data Migration projects in government sectors.
- Experience in Client Server application development using Oracle 11g/10g/9i, PL/SQL, SQL*PLUS, TOADAND SQL DEVELOPER.
- Excellent experience in Designing, Maintaining and tuning various RDBMS like T - SQL & MS SQL Server 2005/2008/2008 R2/2012 and MS Access databases.
- Experience in working all the stages of Data Migration.
- Worked extensively on Ref Cursor, External Tables and Global Temporary Tables.
- Experience in Dynamic SQL, Exception handling and Analytical Functions.
- Experience in database development and hands on experience working on various database activities like Tables, Views, indexes, sequences, materialized views, nested tables, types, Bulk Collect Functions, Procedures, Packages and Triggers.
- Excellent expertise in writing different types of SQL queries like Sub queries, Hierarchical and co related sub queries along with set operators.
- Extensive usage of Oracle collections and standard API’s like DBMS LOB, UTL FILE etc. for business logic in user defined API’s.
- Expertise in dealing with complex data models and object relational database mapping, while producing complex reports.
- Good Exposure to UNIX shell scripting.
- Expertise in developing outbound and inbound interfaces.
- Hands on experience in Data migration (ETL) across different databases via SQL scripts.
- Experience in project planning, scheduling, system design, white board sessions, impac analysis, code development, code review, system test plan, system testing, solution demonstration to stakeholders and post production support.
- Experience in requirement gathering, gap-analysis and solution design.
- Knowledge of Oracle Applications R12GL, Inventory, OM, AP, AR, PO modules.
- Possess strong communication and problem solving skills developed through a variety of projects over a period of time.
- Great team player and ability to work collaboratively and independently as required.
TECHNICAL SKILLS
Operating Systems: UNIX, Linux, Windows
Database: Oracle 9i/10g/11g, MS SQL Server and MS Access
Tools: SQL developer, TOAD, SQL * Loader, SQL*Plus, PL/SQL Developer, Oracle Forms and Reports 10g/9i/6i
ERP: Oracle Applications R12.
Languages: SQL, PL/SQL, JAVA, HTML, XML and shell scripting
Tracker Apps: BMC Remedy, BugZilla
Version control: PVCS
Office Tools: MS Office and Generic text editors
PROFESSIONAL EXPERIENCE
Confidential, CHICAGO, ILLINOIS
Sr. PL/SQL DEVELOPER
Responsibilities:
- Implemented UI screens using JSP, JDBC and interacting with PL/SQL interfaces.
- Parsing and processing of XML data, using DOM, XPath, and XQuery in oracle XMLDB.
- Implemented XML schemas to validate XML.
- Applied design patterns including Factory, Model-View-Controller and Singleton.
- Defined Views and materialized views for simplifying reporting queries and performance.
- Responsible for tracking requirements by interacting with business team.
- Enhancement of Logical and Physical models to in corporate new features.
- Involved in development, enhancement and maintenance of PL/SQL interfaces such as defining packages, developing procedures and functions.
- Created several programs written in Perl to extract data and create reports.
- Addressed errors in communication between the application and other websites.
- Responsible for development and maintenance of Reports.
- Made changes in the existing data model and system for new enhancements.
- Created rerun able shell scripts for meta data creation and maintenance.
- Supported nightly builds and deployments and also part of 24/7 support team.
- Responsibly followed build and release process.
- Prepared test data, test cases.
Environment: Oracle10G, SQL, PL/SQL, XMLDB, Oracle Forms and Reports 9i/10g,Shell Script, Java, J2EE, Erwin, Perl Scripting, Toad, Clear Case, Web logic 8x, HP-UX, Ant, and See Beyond.
Confidential, Birmingham, AL
Sr. PL/SQL DEVELOPER
Responsibilities:
- Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
- Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
- Loaded the data into database tables using SQL*loader from text and excel files.
- Developed data model, SQL Coding, SQL Query tuning process and Schemas.
- Used Tortoise SVN version control for changing the codes.
- Making changes to the existing apex applications in the production.
- Created SQL*plus reports as per client's various needs, and developed business objects.
- Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
- Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
- Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling.
- Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
- Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
- Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
- Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
- Worked on various levels of SDLC (Software Development Life Cycle) including system analysis, high level design, coding and testing.
- Developed UNIX Shell scripts to automate table creation, execute procedures.
- Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
- Used ORACLE SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).
Environment: Oracle 9i/10g, 11g, Reports 9i, SQL, PL/SQL, TOAD, SQL*Loader, UNIX, UNIX Shell script, MS Windows XP/2000, Oracle Development Suite.
Confidential, MILWAUKEE, WI
Sr. Oracle PL/SQL Developer
Responsibilities:
- SME for Accounting Databases and DataMarts.
- Applying Code releases.
- Defect Fixing and Automation of repeating defects.
- Involved in review of the database design.
- Involved in Bulk loading of data from non-Oracle data sources using SQL * Loader.
- Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
- Monthly Reports and Data Extracts.
- Monitoring and Optimizing Database.
- Communicating with the offshore team for project related activities.
- Provided input into project plans for database projects providing timelines and resources required. Involved in SQL tuning using SQL-TRACE, TK-PROOF and Explain plan utilities.
- Responsible writing UNIX shells scripts.
Environment: Oracle 9i, SQL, HTML, UML, SQL * Loader, PL/SQL, Crystal Reports, TOAD, XML and UNIX Shell Scripting.
Confidential - IRVING, TX
Oracle PL/SQL Developer
Responsibilities:
- Responsible for tracking requirements by interacting with business team
- Enhancement of Logical and Physical models to in corporate new features
- Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.
- Designed and developed the ETL process for learning data mart and made use of database objects efficiently towards the fulfillment of business requirements.
- Designed and developed the Developed Cognos reports for Learning Survey Reporting using complex PL/SQL procedures.
- Created List Reports, Dash Board Reports, Cross-tab Reports, and Charts using Tabular SQL, Tabular References and Tabular Sets to reduce the load on the Framework Manager model and improve the report performance.
- Enhancement of Logical and Physical models to in corporate new features
- Defined Views and materialized views for simplifying reporting queries and performance.
- Developed PL/SQLStoredprocedures, Triggers and Functions and embedded them in packages.
- Designed dynamic workflows for the factory planner using ABPP.
- Performed Query optimization and PL/SQL tuning to maximize performance
- Supported nightly builds and deployments and also part of 24/7 support team
- Responsibly followed build and release process
- Involved in Unit Testing, Integration testing, Performance testing and Regression testing.
Environment: Oracle 10G, SQL, PL/SQL, Oracle Forms and Reports 9i/10g, Shell Script, Erwin, Toad, Clear Case, Ant, and See Beyond.
Confidential, Columbus, OH.
Oracle PL/SQL Developer
Responsibilities:
- Involved in designing ER diagram usingERWIN and VISIO. To set the logical and physical relationships of database.
- DevelopedStored Procedures, Functions, Packages and SQL ScriptsusingPL/SQL.
- Developed data model,SQL Coding,SQL Query tuning processandSchemas.
- Migration of DBMS jobs tocontrol M.
- Scheduling jobs incontrol Mand handling them.
- UsedTORTOISE SVN versioncontrol for changing the codes.
- Making changes to the existingapexapplications in the production.
- CreatedSQL*plus reportsas per client's various needs, and developed business objects.
- DevelopedSQL Scripts, Packages and Proceduresfor Business rules check to implement business rules.
- Developed and designed dynamic configuration wrapper in Perl to generate flat fund reports.
- Providedbackend supportfor various Perl based applications.
- UsedBulk Collections, Indexes, and Materialized Viewsto improve the query executions.
- UsedRef cursorsandCollectionsfor accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling.
- Atomized routine jobs usingDBMS JOB.On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
- Involved in SDLC including designing, coding and testing.
- DevelopedSQLandPL/SQLscripts to transfer tables across the schemas and databases.
- Data loaded from legacy systems (ETL Operations) usingPL/SQL and SQL*Loader.
- Developed UNIX shell scripts in VI Editor with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
- Archived many applications in the existing system and retrieval of necessary data from them.
- Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
Environment: Oracle 10g/9i/11g, SQL, PL/SQL, SQL*Loader, UNIX Shell script, MS Access, TOAD, Oracle Forms 10g, Reports10g, Oracle Designer, UNIX, JAVA, Windows XP/2000.
Confidential
Software Programmer
Responsibilities:
- Gained experience in C & C++ programming on UNIX for JIST Applications and also developed PL/SQL Code for updating the payment terms.
- Design, Development and testing of Reports using SQL*plus.
- Worked closely with architects, designers and developers to translate data requirements into the physical schema definitions for Oracle.
- Creating SQL and PL/ SQL scripts, calling C external routines from within PL/ SQL for transfer of data between the databases.
- Developed Stored Procedures, Functions, Packages and Triggers using SQL, PL/ SQL and Run Batch files for loading database tables from flat files using SQL*loader.
- Developed UNIX Shell Scripts for automating the execution process.
- Involved in preparing documentation and user support documents.
- Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
Environment: PL/SQL, Oracle 9i, UNIX, Windows NT/2000, SQL Navigator, Windows NT/2000/XP.