SUMMARY:

• More than 17 years of Professional Experience as Sr. Programmer Analyst / Oracle Application Developer / DBA / PL/SQL Developer Roles.
• Worked on all phases of software development lifecycle(SDLC)asa Sr.Oracle Programmer Analyst /Sr. Oracle Developer and proficient inRequirement Study, Analysis,DatabaseDesign, Development, Integration,Implementation, Maintenance, Performance Tuning, and System IntegrationTesting.
• Extensive experience in PL/SQLScripts, Stored Procedures, Functions, Packages, Triggers and complex SQLto develop robust, reliable and high - performance solutions.
• Proficiency with development inOracleForms,OracleReports, Entity Relation Data Base Design,Data Modeling,Creation of Tables, Creating Primary& Foreign Keys, Views, Materialized Views.
• Extensive experience increating and maintaining databases which includes configuration,query optimization and de-normalization
• Working with clients to identify system issues and make improvements for functionalitychanges, Actively Participated in Change Management Requirements.
• Worked with webtechnology,java, html5, style sheets, andruby onrails,Sinatraframe works.
• Worked inOracle E-Business suite R12,Oracle 11g, 10g, PL/SQL, SQL,TOAD, UNIX, Linux, Sun Solaris,Windows servers.
• Workedas Apps DBA inEnterprisePerformanceArchival Solutions using IBM OPTIM tool to archive periodical data and restore to cloud environment for future queries and purging from the productionthearchiveddata’sto improve the performance of the applications.
• Strong understanding of Oracle locking and transaction mechanisms in multi-session environments.
• Good understanding of SQL performance tuning techniques including query plan understanding and management, SQL tracing, DB stats, indexing techniques, using AWR reports.
• Experience with managing and resolving problems onproduction system.
• Experience with Database access methods and simple SQL constructs.
• Experience with ORM tools (Hibernate, JPA)
• Experience in Core Java, web service(RESTful API’s /SOAP), XML, HTML web page application programs
• Experience to define security system role profiles, responsibilities to business groups, providing accessibility levels to the users.
• Hands on experience to work withagile/ scrumprocess.
• Worked on various reporting service tool likeMicro-strategy, cypress, crystal reports,BusinessIntelligence,XML Publisher Reports.
• Self-starter, highly motivated, technically sound,good team player, problem solver and quick learner. Ability to perform at a high level, meet deadlines.
• Ability to communicate effectively and clearly between teams and resolve issues quickly.
• Oracle SQL Developer
• Strong Skills in SQL Queries.
• Expertise in Oracle tools like TOAD, to create stored procedures.
• Experience in QueryPerformanceTuning
• Writing Ad-hoc Reports to provide statistical informationto the business.
• Oracle PL/SQL Developer
• Strong Skills in PL/SQL Programming to maintain Entity Data Integrity and Referential Data Integrity by authoring Database Triggers, Stored Procedures and Functions.
• Expertise in Oracle tools like SQL*Loader,ETL,Export and Import.
• Strong working knowledge in all oracle objects like DB Links, Synonyms and Materialized Views
• Extensive experience in using Cursors, Ref-cursors, V arrays, nested tables and Dynamic SQL.
• Involved in creating and maintaining users, roles and granting and revoking privileges.
• Working efficiently with SQL and PLSQL tuning using explain-plans, indexes, hints and reusability.
• Oracle Forms / Reports Developer
• Strong Skills inForms, Reports, BI Publisher Reports (DW)for ERP.
• Creation of Data Base, Data Analysis, Normalization, Table Design, Entity Relationship Modeling, maintain Entity Data Integrity and -Referential Data Integrity by authoring Database Triggers, Stored Procedures and Functions, Development, UA Testing, Implementation, Maintenance and Support for Large volume of metadata.
• Expertise in Oracle tools like SQL*Loader,ETL informatica Exportand Import, TOAD, Forms 10g, Reports 10g.
• Strong working knowledge in all oracle objects like DB Links, Synonyms and Materialized Views
• Involved in creating and maintaining users, roles and granting and revoking privileges.
• Skills in making any kind of analytical, statistical, matrixreports.
• DBA skills to support the systemin creating tables,roles, views, materialized views,indexes, primary&foreignkeys.

TECHNICAL SKILLS:

Technology and Tools: Oracle Developer (Forms and Reports) Oracle SQL and PL/SQL ETL, SQL Loader Oracle Database 8i Oracle Database 9i Oracle Database 10g Oracle Database 11g Oracle Database12C Unix Ruby on Rails HTML,CSS, JavaScript, MVC, JQuery, Active Record, RSpec,Heroku, Bit Bucket,MySQL,SQLite3,Git, SVN, Stash

PROFESSIONAL EXPERIENCE:

Confidential, Texas

JDA ANALYST II / PL/SQLDeveloper

Technology:Oracle database and Oracle Developer tools

Responsibilities:

• Upgrade/re-implementation of all components of current EMAPSS environment for each geographic zone instance (America AA, Asia Pacific AP, Europe EU) and Integration Hub
• S&C - address current security issues by using improved capabilities of new JDA software and ORACLE
• Implement new, Web-enabled user interface. Convert current User views to Flexible Editor Pages and Workbenches
• Redevelopment of EMAPSS side of data interfaces to ERP systems, using integration solution
• Optimize EMAPSS night batch processes and monthly Demand Forecast processing
• Business process change management, as needed
• Implement a release management strategy for EMAPSS
• Determine optimal number of EMAPSS instances, currently three zone instances + Integration Hub
• Data architecture review and recommendations
• Data conversion and migration to New EMAPSS Oracle 12C version 2016
• Decommissioning of existing infrastructure
• Addition of Demand Classification module as a high priority discretionary item, to improve Demand Forecast Accuracy.
• The New Demand 360 Module
• Demand Classification Optimization (Dmd320)
• History Cleansing (Dmd320)
• Inclusion of Inter Zone Affiliate Demand in Total Forecast (PRO700/Dmd330)
• Next generation Sales History / Open Orders Upload (new IFI500)
• Integration of DFU Maintenance and Supply Side Supersession (Dmd330)
• Switch to using standard MAPE when calculating DFA (Dmd310)
• Use SKUEXTERNALFCST for inventory builds (Dmd340)
• Improved Demand workbench
• Create Stored Measures to be used in Demand360 and Demand Workbench (Dmd340)
• Create Calculated measures to be used in Demand360 Demand workbench
• Inclusion of standard Cost, Standard Price, and Standard Margin Data (IFI600)
• Daily Batch Performance Improvements (Dmd330)
• Ability to see Quantities in Standard UOM in Demand Workbench / Demand360 (Dmd340)
• Establishment of Global Bulk Rebrand Process (Utilizing Supersession)
• Establishment of Global PTO/FTO/BTO Process
• All Scripts with full logging to UDT INTEGRATION MESSAGES
• DFU Maintenance
• The Demand Planning Monthly Cycle (Except Demand360)
• History Aggregation / Reconciliation
• Forecast Aggregation / Reconciliation
• Exception Reporting
• Standard MI Entry / Upload
• DFA Reporting
• Basic DFU Hierarchy post new sales history interface
• Weekly forecasting

Environment: Oracle 11g, 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.

Confidential, Houston, TX

Sr.Oracle ApplicationDeveloper/ PL/SQLDeveloper

Responsibilities:

• Developed and maintained in-house front-backend applications using Oracle Forms 10G, Oracle Reports 6i, Oracle SQL, Oracle PL/SQLqueriesfor GreatLakeGasTransmission and Northern Border & Bison PipelineforNAESB 3.0/FERC 809Projects.
• Developed and maintained back-end applications using PL/SQL packages, functions, procedures and triggers, shell script.
• Created web-deployedforms andreports for clients using Oracle Portal, ASP.NET, HTML and Javascript embedded in PL/SQL,PL/SQL code calling Java APIs,OracleReports generated by Oracle Reports6i and SQL*Plus.
• Use of DBMS packages to implement scheduling, Dynamic SQL and Extensive Usage of Ref Cursors.
• Extensive use of Oracle materialized views for faster query performance.
• Experience in Core Java, web service(RESTful API’s/SOAP), XML, HTML web page application programs
• Participated in agile / scrum meetings

Environment: Oracle10g, Oracle Forms10g, PL/SQL Developer, Java, Javascript, .ASP, HTML, Reports6i,TOAD.

Confidential, CA

Sr.OracleApplicationDeveloper / PL/SQLDeveloper

Responsibilities:

• Developed and maintainedapplications using Oracle Forms, Oracle Reports, Toad, OracleSQL,PL/SQL packages, functions, procedures and triggers, shell script.
• Created web-deployedforms andreports for clients using Oracle Portal, ASP.NET, HTML and Javascript embedded in PL/SQL, PL/SQL code calling Java APIs,Oracle Reports generated by Oracle Reports9i and SQL*Plus.
• Wrote shell scripts that emailed SQL reports to clients.
• Populate 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.
• Use of PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• Developed SQL Loader scripts for bulk data loads as part of daily data extraction
• Experience performing data migration using data loader,ETL tools,Informatica.
• Experience with UML, Use cases, Asset Management Tool (TFS)
• Experience in Core Java, web service(RESTfulAPI’s/SOAP), XML, HTML web page application programs
• Participated in agile / scrum meetings.
• Experience to define 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 Forms9i, Reports9i,TOAD,PL/SQLDeveloper, Java, Javascript, HTML

Confidential, Mountain View, CA

Sr.Oracle ApplicationDeveloper/ PL/SQLDeveloper

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.
• Experience to define 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).
• Populate Data to Database using Data Loader, ETL Tools.
• Use 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.
• Agile environment, with constantly shifting priorities and business needs.Provided best practices in database related issues to application team.
• Responsible in developing Reports as part as new enhancement.
• Experience performing data migration using data loader, ETL tools,Informatica.
• Experience 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 theexisting application.

Environment: Oracle 10g, PL/SQL Developer, TOAD, SQL*Plus, Oracle Report Developer 10g, Oracle Application Server, Java, JSP.

Confidential, BOTHELL WA

Oracle Application Database Administrator

Responsibilities:

• Worked in 24x7 production environmentand provided on-call and day-to-day support.
• Implement Enterprise Data Management using IBM Info SphereOptimtool for Data Archive (Performance Archive) and Data Purge.
• Database population using SQL*Loader.
• Data population using IBMWebSphereData 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 withOptim
• Designed workflows to do the Extract, Transformation and Load of data.
• Create OPTIM Environments, Directories and DB Aliases for Oracle.
• ConfigureOptimArchive / TDM environmentin both windows and UNIX environment
• Performance tuning and benchmarking SQL Queries
• Convert flat files andcsvfiles into relational model to use withOptim
• Create and testOptimextract, archive, convert, insert jobs
• Responsible for schedulingOptimextract and load jobs
• Installed and maintainOptim,Optimconnect and Discovery Centerin production and QA environments.
• CreateOptimaccess definitions, archive requests, columns mappings,table mappingsand applytransformation functions.
• ImplementedTest Data Management and Data sub setting servicesfor OracleDatabase.
• Manage RACenvironment for Day to Day Database administrator, Performance Tuning.
• Refreshed developmentand 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 inOracle E-Business suite R12,Oracle 11g, 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.
• ExperienceinORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN andwithout 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 automatingUNIXjobs using UC4 automation tool.

Environment: Production Linux servers, Stage Linux Servers, Windows Servers, RDBMS- ERP ORACLE 12c,Teradata,Enterprise ArchiveSystems,OptimTool, Flat files, Oracle 10g/ 11g,Oracle SQL,PL/SQL, TOAD

Confidential

Sr.Oracle ApplicationAnalyst / PL/SQLDeveloper

Responsibilities:

• Requirements gathering, Analyzing, Designing and developing the application.
• Played a major role in DB Design and creation of objects both at the clinic database and central database.
• WritingUNIXShell Scripts.
• Experience performing data migration using data loader, ETL tools,Informatica.
• Experience with UML, Use cases, Asset Management Tool (TFS)
• Extensive use of Oracle materialized views for faster query performance.
• Pl/SQLscripting 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
• Successfully rolled out the application with all the necessary objects/scripts, as indicated in point.3, in place.
• Worked inOracle E-Business suite R12,10g, 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, EBS Suite R12,Oracle 10g, Oracle8i, SQL, PL/SQL, SQL* Plus, SQL * Loader, Forms 10g/6i, Reports 10g/6i, TOAD, DBA, Unix, Linux.

Confidential

Sr.Oracle Application/ PL/SQLDeveloper

Responsibilities:

• Requirements gathering, Analyzing, Designing and developing the application.
• Played a major role in DB Design and creation of objects both at the Kuwait schema as well as Jordan, Oman, Lebanon database.
• Developed Forms& Reports by Developer Tools, BI Publisher Reports, Micro strategy Reports, Ad-hoc Excel / PDFReports.
• Created database objects like tables, views, procedures, packages using Oracle tools like TOAD, SQL Loader, SQL, and PL/SQL.
• Developed complex queries, functions,procedures and triggers using Pl/Sql scripts, Unix Shell Scripts, Scheduling of Batch Jobs.
• Created various SQL and PL/SQL scripts for verification of the required functionalities used in forms, reports.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Experience performing data migration using data loader, ETL tools,Informatica.
• Experience with UML, Use cases, Asset Management Tool (TFS)
• Experience in Core Java, web service(RESTfulAPI’s/SOAP), XML, HTML web page application programs
• Involved in the preparation of user Requirements and functional specification of the systems.
• Run Batch files for loading database tables from flat files using SQL loader.
• Created indexes on tables and Optimizing Stored Procedure queries.
• Involved in customization of Oracle Forms 4.5/6i/8i/9i/10g/11g, Oracle Reports versions 2.5/6i,8i/9i/10g/11g.
• Customization of Business Intelligence Reports to RMS, SIM, POS dashboards.
• Involved in preparing test plans, unit testing, System integration testing,implementation andmaintenance,Writing UNIXShell Scripts.
• Migration of Oracle Forms 6i to Forms 8i/9i/10g/11g, Reports 6i to Reports 8i/9i/10g/11g.
• Migration of SCMADS Data from 8i to 9i, 9i to10g, 10g to 11g, 11g to ERP 12c.
• Worked inOracle E-Business suite R12,Oracle 11g, 10g, PL/SQL, SQL, TOAD, UNIX, Linux, Sun Solaris, Windows servers.
• Experience to define security system role profiles, responsibilities to business groups, providingtable dataaccessibility levels to the users.

Environment: Oracle EBS Suite,SCMADS Supply Schain Merchandise and Distribution System Application Package,RDBMS,RETEK Retail Merchandise RMS, Point of Sale POS, SIM Store Inventory Management System, Relational Data Warehouse RDW, Flat files, Oracle 6i/Oracle8i/Oracle9i/Oracle10g/Oracle 11g/ Oracle 12c E-Business suite R12,TOAD, Oracle SQL, PL/SQL DEVELOPER, Oracle Forms 4.5, Forms 6i, Forms 8i, Forms 9i, Forms 10g, Forms 11g, Oracle Reports 2.5, Reports 6i, Reports9i, Reports 10g, Reports 11g/ BI Publisher Desktop, Micro strategy Desktop, Unix, Linux Putty Servers.