Lead Pl/sql Developer Resume
NC
SUMMARY:
- LEAD PL/SQL Developer with more than 18 years of extensive experience in Oracle PL/SQL, OAF and Systems Management.
- Hands - on with UNIX / LINUX shell scripts, Database Administrations, Troubleshooting, Tracing, and Debugging.
- Proficient with Financial & Manufacturing Modules, Tools, and Techniques.
- Proficient in using and handling Oracle Application Frameworks (OAF) & EMAPSS Application Systems.
- Experience in Advanced PL/SQL Scripts, Performance Tuning, Stored Procedures, Functions, Packages, Triggers and complex SQL to develop robust, reliable and high-performance solutions.
- Proficiency with development in Oracle Forms, Oracle Reports, Entity Relation Data Base Design, Data Modeling, Creation of Tables, Creating Primary& Foreign Keys, Views, Materialized Views.
- Strong experience in upgrade / migration of Oracle Data Base ERP, JDA, OLAP environments.
- Extensive experience in creating and maintaining databases which includes configuration, query optimization and de-normalization
- Hands-on with deployment and migration of supply chain data EMAPSS from v7.7 Oracle 11 to Oracle 12c cloud environment for several global regions
- Experience in data conversion and migration to new EMAPSS Oracle 12C version2016
- Experience in Migration of Oracle Forms, from 6i to 8i, 9i,10g,12c, Migration of Oracle Reports from 6i to 9i, Reports 10g, Reports 11g/ BI Publisher Desktop,12c Reports BI Publisher
- Hands-on with development and in-house maintenance front-back end applications using Oracle Forms 10G, Oracle Reports 6i, Oracle SQL, Oracle PL/SQL queries for several clients
- Proficiently handled PL/SQL Collections and Records, Partition methods for oracle tables and indexes
- Hands on experience with Telecommunication Confidential Project, DRY Runs, MF internal and external Gather for Government/ Internal Auditing
SKILL:
- EBS Systems/Applications Management / Analysis / Solutions
- Oracle E Business Suite R12c/11g/10g/9i/8i/ Forms/Reports / OAF
- Debugging / Troubleshooting / Diagnosis / Tuning / Migration
- PL/SQ/ Unix / Linux Scripting / TOAD /SQL Developer/ Oracle Forms & Reports
PROFESSIONAL EXPERIENCE:
LEAD PL/SQL DEVELOPER
Confidential, NC
Responsibilities:
- Analyze, Database design, development, test and implement detailed software applications modules and systems by AGILE methodology according to specific client requirements using Oracle tool like SQL Developer/ TOAD, and writing advanced PL/SQL scripts and UNIX / LINUX shell Scripts.
- Query Performance Tuning.
- Data conversion and Data Migration for IPSM / XO Integration Projects.
- PL/SQL advanced concepts such as collections, Bulk Collect and Bulk updates.
- Experience in building complex software systems.
- Understand the underlying data sources (databases) and interpret requirements provided by the business to analyze operational issues and develop appropriate diagnostic and / or tracking data via dashboards, any necessary supporting data structures and extract transformation load required to populate the data structure.
- Working with Business Analysts, System Analysts, Database teams and software teams to support the Confidential IPSM applications.
- Writing UNIX shell scripts to automate the PL/SQL Packages. Automation of recurring reports.
- Implement modern engineering, DevOps and CI/CD programs, best practices using Jenkins, GIT and Stash repositories.
- Knowledge in Telecom Network elements.
- Working with Agile methodology.
- Collaborate with Java developers and DBA's to implement database scripts to meet the project goals.
- Actively participate in IPSM dry runs database migration and integration project.
- Actively participate in IPSM Internal/External gather for the Confidential Auditing.
- Actively participate in IPSM QA meetings for their automation scripts / jobs.
- Bug fixing during dry runs.
- Assist in integrations and deliverable creations, by utilizing her technical capabilities in delivery estimation, vendor coordination/ management and technical expertise in PL/SQL scripts, and Performance Tuning and code/bug fixes.
- Participate in requirement gathering and the project kickoff meetings to share expertise.
- Providing direction on best practices in designing and developing high performance middle tier.
- Responsible for analysis of current programs including performance, diagnosis and troubleshooting of programs, and designing solutions to problematic programming.
- Document code changes consistently during bug fixing process by listing a description of the program, special instructions, and any changes made to the database tables on procedural, modular level using SQL Developer.
- Responsible for creating PL/SQL packages, and automation of statistical reports.
- Engage in daily status SCRUM meetings and provide transparency, educate subordinates and support agile methodology advocated by the project.
- Develop services to enhance functionality of customer portal by abiding coding and quality standards imposed by Confidential .
- Conduct thorough testing in Development Integration, Systems Integration, and Business Acceptance testing environments.
- Performing code reviews and ensuring secure coding practices are followed.
- Responsible for setting up continuous integration and continuous delivery pipelines.
Environment: Oracle 12c, Production, XVE, NVE database, SQL DEVELOPER 4.0, Putty, stash/ GIT repository, FileZilla.
Oracle PL/SQL Developer
Confidential, Durham, NC
Responsibilities:
- Worked on Financial module, Oracle Application Framework (OAF)
- Worked on Jira tickets on Oracle Warehouse Builder (OWB) ETL failures in Datamart, CDW, Staging, apply code fixes, data fixes, performance tuning, deploy in testing and production
- Assisted with the design and implementation of NC Families Accessing Services through Technology ( Confidential )
- Analyzed and identified reporting requirements for Confidential Operations and Maintenance activities
- Involved in peer review code for team members
- Automated daily, monthly, quarterly, yearly recurring reports
- Worked on BMC Remedy Tickets, resolving defects in system, assisting case owners
- Involved in designing, coding, testing, debugging, and documenting reporting solutions, while enhancing existing reports to ensure that solutions continue to meet business needs
- Managed underlying data sources (databases) and interpret requirements provided by the business to analyze operational issues and develop appropriate diagnostic and/or tracking data via reports and dashboards
- Involved in gathering and documenting requirements for new reports and changes to existing reports, extraction or collection of data for performing queries and writing reports
- Developed and analyzed operational performance metrics and reports to ensure the quality and integrity of extracts though the use of validation and audit strategies
- Responsible for status reporting to the Confidential project manager and for adhering to DHHS policies and procedures
- Participating Agile / Scrum Meetings
Environment: Oracle 11g OWB ETL TOOL, Report Datamart, CDW (Central Data Warehouse), Staging database, Production database, RAC Oracle 12c, SQL DEVELOPER 4.1.3, SVN, Confidential Application, Curam Reports
Oracle EBS Systems Consultant PL/SQL Developer
Confidential, Woodlands, TX
Responsibilities:
- Worked with Oracle Application Framework (OAF)
- Deployed migration of supply data from v7.7 Oracle 11 to Oracle 12c cloud environment for 3 regions, specifically for America, Europe, and Asia Pacific regions
- Involved in data conversion and migration to new EMAPSS Oracle 12C version 2016
- Performed upgrade EMAPSS application system version from 7.7 Release 11.2.0.1.0 Production to version 2016 Oracle Database RAC 12c Enterprise Edition Release 12.1.0.2.0 Production
- Developed migration PL/SQL scripts and Shell Scripts, tested in Development tier environment, deployment in Acceptance servers and New Production servers
- Applied enhancement of performance tuning and optimization techniques for PL/SQL scripts in version 12c, to run the query faster without any time delays/ Blocks
- Involved in data modelling, system analysis, and data flow from SAP Stripes to EMAPSS interface, and EMAPSS to SAP
- Responsible for EMAPSS data is coming from SAP stripes, task is to measure forecasted units of oil consumption and distributions to its customers and calculate the new accurate algorithm for measurement units and sending back to SAP ERP to get forecast quantities
- Scheduled nightly batches are running on UC4, task is to upgrade all applications for v2016, Monitor the scheduled tasks, apply daily fix for them
- Used of DBMS packages to implement batch scheduling on UC4
- Participating Agile / Scrum Meetings with on shore/ off shore teams
- Upgrade/re-implemented all components of current EMAPSS environment for each geographic zone instance (America AA, Asia Pacific AP, Europe EU) and Integration Hub
- Implemented new, web-enabled user interface. Convert current User views to flexible editor pages and workbenches
- Redeveloped EMAPSS side of data interfaces to ERP systems, using integration solution
- Optimized EMAPSS night batch processes and monthly Demand Forecast processing
- Responsible for business process change management, as needed
- Implemented a release management strategy for EMAPSS
- Determined optimal number of EMAPSS instances, currently three zone instances + Integration Hub
- Responsible for data architecture review and recommendations
- Decommissioned existing infrastructure
- Responsible for demand classification module as a high priority discretionary item, to improve demand forecast accuracy
Environment: E-Business suite Oracle 11.0.3, RAC Oracle 12c, SQL DEVELOPER 4.1.3, Putty, WS FTP, Asset Management Tool (TFS), Visual Studio 2013, Unix / Linux Putty servers, ITPA TOAD, JDA Application
Senior Oracle Application Developer
Confidential, Houston, TX
Responsibilities:
- Developed and maintained in-house front-back end applications using Oracle Forms 10G, Oracle Reports 6i, Oracle SQL, Oracle PL/SQL queries for Great Lake Gas Transmission and Northern Border & Bison Pipeline for NAESB 3.0/FERC 809 Projects
- Created web-deployed forms and reports for clients using Oracle Portal, ASP.NET, HTML and Java script embedded in PL/SQL, PL/SQL code calling Java APIs, Oracle Reports generated by Oracle Reports 6i and SQL*Plus
- Used Oracle materialized views for faster query performance
- Developed and maintained back-end applications using PL/SQL packages, functions, procedures and triggers, shell script
- Used of DBMS packages to implement scheduling, Dynamic SQL and Extensive Usage of Ref Cursors
- Proficient in Core Java, web service (RESTful API’s/SOAP), XML, HTML web page application programs
- Participated in agile / scrum meetings
Environment: E-Business suite Oracle 10g, Developer Suite 10g, Oracle Forms 10g, PL/SQL Developer, Java, Java script, .ASP, HTML, Reports 6i, TOAD
Senior Oracle Application/PL/SQL Developer
Confidential, San Jose, CA
Responsibilities:
- Developed and maintained applications using Oracle Forms, Oracle Reports, Toad, Oracle SQL, PL/SQL packages, functions, procedures and triggers, shell script
- Created web-deployed forms and reports for clients using Oracle Portal, ASP.NET, HTML and Java script embedded in PL/SQL, PL/SQL code calling Java APIs, Oracle Reports generated by Oracle Reports 9i and SQL*Plus
- Used PL/SQL Collections and Records, Partition methods for oracle tables and indexes
- Wrote shell scripts that emailed SQL reports to clients
- Populated Data to Database using Data Loader, ETL Tools
- Involved in production support for the entire decision support team, which involved working on ticket queues and on-call support for most of existing production systems
- Developed SQL Loader scripts for bulk data loads as part of daily data extraction
- Performed data migration using data loader, ETL tools, Informatica
- Involved with UML, Use cases, Asset Management Tool (TFS)
- Responsible for Core Java, web service (RESTful API’s/SOAP), XML, HTML web page application programs
- Participated in agile / scrum meetings
- Defined security system role profiles, responsibilities to business groups, providing accessibility levels to the users
- Participated in a 24x7 on-call production support rotation
Environment: Oracle 9i, putty telnet, Oracle Forms 9i, Reports 9i, TOAD, PL/SQL Developer, Java, Java script, HTML
Senior Oracle Application /PL/SQL Developer
Confidential, Mountain View, CA
Responsibilities:
- Involved in production support for the entire decision support team, which involved working on ticket queues and on-call support for most of existing production systems
- Defined security system role profiles, responsibilities to business groups, providing accessibility levels to the users
- Responsible for creating and modifying the PL/SQL procedures, functions, triggers according to the business requirement - new tickets (enhancements)
- Populated Data to Database using Data Loader, ETL Tools
- Used of DBMS packages to implement scheduling, Dynamic SQL and Extensive Usage of Ref Cursors
- Developed SQL Loader scripts for bulk data loads as part of daily data extraction
- Responsible for creating indexes to increase performance and complex SQL queries for joining multiple tables
- Tuned and Optimized the SQL statements to improve the performance of the application using Explain Plan and SQL trace utilities
- Involved in Agile environment, with constantly shifting priorities and business needs. Provided best practices in database related issues to application team
- Responsible for developing Reports as part as new enhancement
- Performed data migration using data loader, ETL tools, Informatica
- Experienced with UML, Use cases, Asset Management Tool (TFS)
- Involved in writing Design Requirement and BRD
- Involved in writing Test documentation and performing unit, integration tests for the same modules in the existing application
Environment: E-Business suite Oracle 11.0.3, Oracle 10g, Developer Suite 10g, PL/SQL Developer, TOAD, SQL*Plus, Oracle Report Developer 10g, Oracle Application Server, Java, JSP
Oracle Application Database Administrator
Confidential, Bothell, WA
Responsibilities:
- Enterprise Archive Solutions is a tool to store historical data in compressed form and thereby reclaim storage, used for continued application use to improve the performance of the application.
- The Tool used is the IBM Optim Web Tool.
- This capability can be used for Performance Archive purpose.
- Archive old rarely used data (30 days old, 180 days old data) based on the retention policy period specified by the data owner in the web tool then delete the archived data from selected database tables from the production schema... Data from the historical archive files are stored in to the EAS cloud environment.
- The archived data is restored to target schema for their future use. Purging data from the Production after restore is completed.
- This will help the production to run efficiently and will save the storage space and thus will improve the performance.
- Worked on Oracle Application Framework (OAF)
- Worked in 24x7 production environment and provided on-call and day-to-day support.
- Implement Enterprise Data Management using IBM Info Sphere Optim tool for Data Archive (Performance Archive) and Data Purge.
- Database population using SQL*Loader.
- Data population using IBM WebSphere Data Stage.
- Experience performing data migration using data loader, ETL tools, Informatica.
- Experience with UML, Use cases, Asset Management Tool (TFS).
- Created the lookup tables used to mask the actual table or file with Optim.
- Designed workflows to do the Extract, Transformation and Load of data.
- Create OPTIM Environments, Directories and DB Aliases for Oracle.
- Configure Optim Archive / TDM environment in both windows and UNIX environment.
- Performance tuning and benchmarking SQL Queries.
- Convert flat files and csv files into relational model to use with Optim.
- Create and test Optim extract, archive, convert, insert jobs.
- Responsible for scheduling Optim extract and load jobs.
- Installed and maintain Optim, Optim connect and Discovery Center in production and QA environments.
- Create Optim access definitions, archive requests, columns mappings, table mappings and apply transformation functions.
- Implemented Test Data Management and Data sub setting services for Oracle Database.
- Manage RAC Oracle 12c environment for Day to Day Database administration, Performance Tuning.
- Refreshed development and test databases with production data.
- Expertise in Oracle Enterprise Manager (OEM), TOAD
- Managed application support, maintenance, created logical and physical data layout, table re-organization, installing patches, upgrades, monitoring and tuning of databases.
- Create and maintain materialized views.
- Worked in Oracle E-Business suite R12c, E-Business suite Oracle 11.0.3, PL/SQL, SQL, TOAD, UNIX, Linux, Sun Solaris, Windows servers.
- Experience to define security role profiles, responsibilities to business groups, providing accessibility levels to the users.
- Experience in ORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN.
- Analyzed database performance and tuned database, resulted in improved performance of system.
- Creating and maintaining logins, synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security features.
- Implemented backup and recovery procedures; established disaster recovery and high availability plans.
- Knowledge in automating UNIX jobs using UC4 automation tool.
Environment: Production Linux servers, Stage Linux Servers, Windows Servers, RDBMS - ERP Oracle 12c, Teradata, Enterprise Archive Systems, Optim Tool, Flat files, Oracle 10g/ E-Business suite Oracle 11.0.3, Oracle SQL, PL/SQL, TOADLEAD Oracle Application Analyst / Forms & Reports Developer / PL/SQL Developer