SUMMARY:

• Lead PL/SQL Developer with more than 18 years of extensive experience in Oracle PL/SQL, ETL, Data analysis, OAF and Systems Management. Hands - on with UNIX / LINUX shell scripts, Database Administrations, Troubleshooting, Tracing, and Debugging. Proficient with Financial, Retail, Health, Oil & Gas, Telecommunication & 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, cursors, ref cursors, Bulk collect, FORALL. Triggers
• Good knowledge of XML, REST API, JavaScript, Spring, JSP, JDBC, CSS, HTML, Excel Programing, Microsoft R, SSIS, SSRS SQL reporting and Business Intelligence
• Strong experience in upgrade / migration of Oracle Data Base ERP, JDA, OLAP, ODS, EDW environments, Create Technical design documents and migration documents based on business functional requirements .
• Strong experience on SQL Scripting, automation of SQL reports.
• Extensive experience in creating and maintaining databases which includes configuration, query optimization, normalization 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, Oracle EBS Supply Chain modules
• 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, Ad-hoc Reports
• Experience on Oracle Data Integrator ODI with Business Intelligence tools such as Business Objects, BIRT, ETL OWB Builder, ETL Informatica Power center
• Hands-on with development and in-house maintenance front-back end applications using Oracle Forms 10G, Oracle Reports 6i, Oracle SQL, Oracle PL/SQL scripts for several clients
• Proficiently handled PL/SQL Collections and Records, Partition methods for oracle tables and indexes
• Hands on experience with Telecommunication XO Migration Project, DRY Runs, MF internal and external Gather for Government/ Internal Auditing
• 18+ years EBS Systems/Applications Management / Analysis / Solutions
• Oracle E-Business Suite R12c/11g/10g/9i/8i/ Forms/Reports / OAF
• Debugging / Troubleshooting / Diagnosis / Fixes / Migrations / Automation
• PL/SQL/Linux Unix shell Scripts/TOAD/SQL Developer/ETL Informatica/Oracle Forms & Reports /Data Modelling /Performance Tuning /Query Optimization

PROFESSIONAL EXPERIENCE:

Confidential, NC

Lead PL/SQL Developer

Responsibilities:

• Participate key role on XO Migration Integration Project
• 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 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 FORALL updates, Nested Tables, Cursors, Ref cursors, views, materialized views, Triggers
• 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, Java developers and DBA's to implement database scripts to meet the project goals.
• Writing UNIX shell scripts to automate the PL/SQL Packages for ODS, EDW environments, Automation of Migration deployment scripts, Scheduling of batch scripts.
• Implement modern engineering, DevOps and CI/CD programs, best practices using Jenkins, GIT and Stash repositories.
• Knowledge in Telecom Network elements.
• 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.
• Strong experience on SQL Scripting
• Automated Consolidated Profile Migration Reports, Fallout Reports
• Assist in integrations and deliverable creations, by utilizing 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, FileZilla, JIRA, Confluence, Stash, GIT repository, Microsoft XL, Word, PowerPoint, Visio

Oracle PL/SQL Developer

Confidential, Durham, NC

Responsibilities:

• 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 (NCFAST)
• Analyzed and identified reporting requirements for NC FAST Operations and Maintenance activities
• Used PL/SQL advanced concepts such as collections, Bulk Collect and FORALL updates, Nested Tables, Cursors, Ref cursors, views, materialized views, Triggers
• Involved in peer review code for team members
• Experience on Oracle Data Integrator ODI with Business Intelligence tools such as Business Objects, BIRT, CDW, snowflake schema
• Strong experience on SQL Scripting
• 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
• Participating Agile / Scrum Meetings

Environment: Oracle 11g OWB ETL TOOL, JIRA, Report Datamart, CDW (Central Data Warehouse), Staging database, Production database, RAC Oracle 12c, SQL DEVELOPER 4.1.3, SVN, NCFAST Application, Curam Reports, Microsoft XL, Word, PowerPoint, Visio

Oracle EBS Systems Consultant PL/SQL Developer

Confidential, Woodlands, TX

Responsibilities:

• 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
• PL/SQL advanced concepts such as collections, Bulk Collect and FORALL updates, Nested Tables, Cursors, Ref cursors, views, materialized views, Triggers
• Involved in data modelling, system analysis, and data flow from SAP to EMAPSS interface, and EMAPSS to SAP, Worked on Oracle EBS Supply Chain modules
• Experience in snowflake cloud databases, ODS, EDW schema.
• 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

Environment: E-Business suite Oracle 11.0.3, RAC Oracle 12c, JIRA, SQL DEVELOPER 4.1.3, Putty, WS FTP, Asset Management Tool (TFS), Visual Studio 2013, Unix / Linux Putty servers, ITPA TOAD, JDA Application, Microsoft XL, Word, PowerPoint, Visio

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
• Worked on Oracle EBS Supply Chain modules (OPM/INV/WMS/VCP)
• Used Oracle materialized views for faster query performance
• PL/SQL advanced concepts such as collections, Bulk Collect and FORALL updates, Nested Tables, Cursors, Ref cursors, views, Triggers
• Experience on Oracle Data Integrator ODI with Business Intelligence tools such as Business Objects
• Developed and maintained back-end applications using PL/SQL packages, functions, procedures and triggers, shell scripts
• Created Views, Functions, Procedures and Packages in PL/SQL for ODI process
• Used of DBMS packages to implement batch scheduling using Control M, 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, Informatica Power center, Java, Java script, .ASP, JIRA, HTML, Reports 6i, TOAD, Microsoft XL, Word, PowerPoint, Visio

Senior Oracle Application/PL/SQL Developer

Confidential, San Jose, CA

Responsibilities:

• Developed and maintained applications using Toad, Oracle SQL, PL/SQL packages, functions, procedures and triggers, shell scripts
• 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
• PL/SQL advanced concepts such as collections, Bulk Collect and FORALL updates, Nested Tables, Cursors, Ref cursors, views, materialized views, Triggers
• Wrote shell scripts that emailed SQL reports to clients
• Populated Data to Database using Data Loader, Informatica Power center
• 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
• Involved with UML, Use cases, Asset Management Tool (TFS)
• Created Views, Functions, Procedures and Packages in PL/SQL for ODI process
• Responsible for Core Java, web service (RESTful API’s/SOAP), XML, HTML web page application programs
• Participated in agile / scrum meetings

Environment: Oracle 9i, putty telnet, JIRA, Oracle Forms 9i, Reports 9i, TOAD, PL/SQL Developer, Informatica Power center, Java, Java script, HTML, Microsoft XL, Word, PowerPoint, Visio

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
• Worked on Supply Chain modules (OPM/INV/WMS/VCP)
• 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, Informatica Power center
• PL/SQL advanced concepts such as collections, Bulk Collect and FORALL updates, Nested Tables, Cursors, Ref cursors, views, materialized views, Triggers
• Used of DBMS packages to implement batch scheduling using Control M, Dynamic SQL and Extensive Usage of Ref Cursors
• 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, Strong experience in SQL Scripting, XML Publisher, Oracle Forms, Oracle Reports, PL/SQL
• Responsible for developing Reports as part as new enhancement
• Experienced with UML, Use cases, Asset Management Tool (TFS)

Environment: E-Business suite Oracle 11.0.3, Oracle 10g, Developer Suite 10g, PL/SQL Developer, Informatica Power center,TOAD, SQL*Plus, JIRA, Oracle Report Developer 10g, Oracle Application Server, Java, JSP, Microsoft XL, Word, PowerPoint, Visio

Oracle Application Database Administrator

Confidential, Bothell, WA

Responsibilities:

• Archiving historical 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 in compressed form and thereby reclaim storage, used for continued application use to improve the performance of the application using IBM Optim Web Tool
• Worked on Oracle Application Framework (OAF)
• Worked in 24x7 production environment and provided on-call and day-to-day support.
• Data population using IBM WebSphere Data Stage.
• Experience in performing data migration using data loader, ETL tools like 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.
• 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.
• Expertise in Oracle Enterprise Manager (OEM), TOAD
• 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.
• 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, JIRA, Oracle SQL, PL/SQL, TOAD, Microsoft XL, Word, PowerPoint, VisioMinistry of Health, Sabha Hospital, Kuwait

Lead Oracle Application Analyst / Forms & Reports Developer / PL/SQL Developer

Confidential

Responsibilities:

• Developed pl/sql scripts, and centralized the data warehouse schema by merging 65 primary care centers for dental and vaccination project centers, register follow-up, schedule appointments and track administration of immunization of children, Adults and Hajj Pilgrims.
• Comprehensive reports administrative, statistical and medical in nature are generated.
• Requirements gathering, Analyzing, Designing and developing the application.
• Played a major role in DB Design and creation of objects both Confidential the clinic database and central database. Writing UNIX Shell Scripts.
• Experience performing data migration using data loader, ETL tool Informatica.
• PL/SQL advanced concepts such as collections, Bulk Collect and FORALL updates, Nested Tables, Cursors, Ref cursors, views, materialized views, Triggers
• Experience with UML, Use cases, Asset Management Tool (TFS)
• Worked in Oracle Forms, Oracle Reports, PL/SQL developer (TOAD),
• Strong experience in SQL Scripting, XML Publisher, Oracle Forms, Oracle Reports, PL/SQL
• Extensive use of Oracle materialized views for faster query performance.
• Pl/SQL scripting to synchronize the data between the clinic database and central database.
• Managed a team of 4 to develop and rollout this application to all the centers.
• Scheduled a Train-the-Trainers Program to train Doctors, Nurses, Health Inspectors
• Worked in data migration from Oracle 10g to Oracle E-Business suite R12c, PL/SQL, SQL, TOAD, UNIX, Linux, Sun Solaris, Windows servers
• Experience to define security system role profiles, responsibilities to business groups, providing accessibility levels to the users.

Environment: RAC Oracle 12c, E-Business suite Oracle R12, Oracle 10g, Developer Suite 10g, Oracle8i, SQL, PL/SQL, SQL* Plus, SQL * Loader, Forms 10g/6i, Reports 10g/6i, TOAD, DBA, Unix, Linux, Microsoft XL, Word, PowerPoint, Visio