We provide IT Staff Augmentation Services!

Senior Oracle Plsql Developer Resume

4.00/5 (Submit Your Rating)

Chicago, IL

PROFESSIONAL SUMMARY:

  • 14+ years of IT experience as “Oracle PL/SQL Developer” in Oracle 11g / 10g, “Oracle Forms / Reports Developer” in Oracle Forms / Reports 10g / 6i, “Oracle Apex Developer” in Apex 4.0 / 5.0, “Business Intelligence Developer” using OBIEE 11g / 10g, Business Intelligence Publisher 11g for “Enterprise ERP applications”, “Warehouse Management Applications”, “Supply Chain Management applications”, and “Web Applications”, “Business Intelligence solutions” and “Data warehousing applications”
  • 4+ years of IT experience as Systems analyst and ERP Consultant for “Supply Chain management applications”, “Warehouse management applications”, and “Manufacturing / production management applications”
  • Strong skills in Oracle server side programming which includes writing simple and complex SQLs, PL/SQL, Functions, Procedures, Packages, creation of Oracle Objects - Tables, Views, Materialized views, Triggers, Partition tables, External tables, Indexes, Synonyms, User Defined Data Types, Nested Tables, Collections, Pipelined functions, XML DB functions, and advanced PL/SQL concepts like SYS REFCURSOR, Bulk collect, FORALL, WITH clause, Merge statements, Autonomous transactions, Error Handling, Dynamic SQL, Records, DBMS SCHEDULER, DBMS JOB, UTL FILE
  • Experience working in large DB and high volume transaction processing and applications; 4TB+
  • Experience in designing entity-relationship diagrams and developing of logical and physical data model for Oracle Database applications
  • Extensive experience with Oracle Forms 11g/10g, 9i, 6i. Have developed numerous applicatiofns and maintained systems using more than 100 Forms
  • Extensively worked with Oracle Reports 11g/10g/9i, 6i and created numerous reports of varying complexity
  • Extensively worked in creating Oracle discoverer 11g business areas to support adhoc reporting using Oracle Business Intelligence Discoverer desktop 11g, and Oracle Discoverer Administration reporting tools
  • Experience developing reports using Oracle Business Intelligence Publisher 11g
  • Experience developing API’s and interfaces using SOA (Service Oriented Architecture) and have developed business event ABCS services (both provider API and requestor API services) using XML messages between Oracle and SQL server based applications
  • Extensive experience building and supporting Warehouse management applications, especially following sub systems “Appointment Schedule management”, “Wave management”, “Pick and Putaway jobs management”, “Replenishment Jobs”, “Loading and unloading tasks”, “Bulk Moves”, “Pick faces replenishment”, “Robotic tools integrations such as ASRS or Layer pickers”, “Job assignment and task interleaving management”, “Lean logistics and one network integration”, “WMS forklift RF and mobile applications for performing various tasks”
  • Experience in reading and analyzing execution plans using explain plans, autotrace, and TKPROF tools
  • Experience monitoring oracle applications for performance and Query Optimization
  • Experience using indexes for performance tuning of SQL
  • Experience using global temporary tables and SQL query optimizer Hints for SQL performance tuning
  • Experienced in PL/SQL Performance Tuning using Bulk Collections and other optimization techniques
  • Experience in designing and development of Logical and physical data models for Data Warehousing applications
  • Experience developing Business Intelligence solutions for enterprise applications using Oracle Business Intelligence (OBIEE 10g/ 11g)
  • Experience working as Data Analyst - expert in analyzing Sales Data, Shipment data, Financial Data, and Inventory Data for “Manufacturing”, “Retail”, and “Supply Chain Solution Industries”
  • Experience analyzing data using complex SQL joins, Oracle Analytic and Grouping functions for data analysis
  • Experience capturing ETL requirements, designing “Data transformation’s / mapping” and building of Data Cleansing and data migration solutions using SQLLoader, Oracle Data Pump, data transformation scripts and ETL tools
  • Experience performing Oracle Data Base Administration (DBA) activities such as creating DB Instances, creating schema objects and implementing rules for data integrity, creation and management of tablespaces, creating Grants, Backup, Recovery, performance monitoring, Export and Loading of Oracle DB using Data pump utility and SQL Loader
  • Experience using Shell Scripts in SSH Client Environment
  • Experience architecting "meta data structures" to handle data transfer, create and deploy business rules using such meta data structures and build interfaces for external communication or third party integrations such as EDI, API e.tc
  • Expertise building Data Integration APIs to communicate data between various data sources like SQL Server, Oracle, Flat Files, and XML files
  • Achieved success in developing and implementing Electronic Data Interchange (EDI) of Supply Chain / Logistics data between Vendors and partners for a Supply Chain Management company using Oracle PL/SQL, and Evision Software
  • Hands on experience developing KPI (Key performance indicator) Enterprise dashboards using Oracle Business Intelligence Enterprise Edition (OBIEE) tool, BI publisher
  • Knowledge of Salesforce Cloud Application administration and Development
  • Expertise in UI design for Hand Held Terminal applications and design of Integration with database applications using XML interfaces using Oracle Database and Dot Net technology
  • Good working experience in ORACLE XML DB. Extensively used Oracle XML DB to generate XML files and also parse the XML Files and validate the XML Files using XML Schema Definition (XSD)
  • Experience performing administration, production support and maintenance related activities for Oracle Applications R12 application in “Order to Cash”, “Finance” and “Inventory” Modules
  • Experience performing production support activities for Oracle Database, and data warehousing applications
  • Excellent Project Management skills (PMP Certified Project Manager) and experience spearheading numerous projects with tram size ranging from 3 to 15 and have demonstrated good productivity
  • Ability to perform Business Process study, Discovery and planning, software solution mapping and transforming it into system technical requirements
  • Experience designing and developing multi-tenant PL/SQL web applications and “Business Intelligence Dashboards” for Enterprise applications using Oracle Application Express (APEX 4.1)
  • Valuable Experience with data modelling and building “Logical / Physical Data model” for Data warehouse / data marts (Star, Snowflake) using Oracle SQL Developer Data Modeler, Erwin and Toad Data Modeler
  • Valuable experience with database development tools such as Oracle SQL Developer, PL-SQL Developer and Toad
  • Good understanding of partitioning, indexes, Bitmap indexes, triggers, materialized views
  • Profound functional and domain knowledge of enterprise resource planning Enterprise Resource Planning (ERP) functions - “Asset Management, Finance, Accounts Receivables and Payables, Manufacturing, Sales, Procurement, Inventory Management, Human Resources, Third Party Logistics, Warehouse Management, Quality Management, and RMA”, Customer Relationship Management”, and “Supply Chain Management”
  • Excellent Experience working as Systems Analyst - Involved in designing, building and implementing of enterprise solutions for the following industries - “Supply Chain and Logistics”, “Manufacturing”, “Retail”, “Financial”
  • Extensive experience in Code Review and strongly impose Code Review Culture in projects

CORE COMPETENCIES:

  • Professional experience in interacting with business users to understand Business requirements and create system Requirements documents
  • Experience Managing Scope, Quality, Risk and creation of Project Plans, Preparation of Time schedule and Cost Estimates
  • Excellent communication, organizational, and presentation skills and a good team player
  • Profound knowledge of software development life cycle (SDLC) models and methodologies which includes both Waterfall and Agile development cycle, and its implementation and maintenance
  • Ability to prioritize and work on multiple tasks simultaneously
  • Ability to quickly learn new systems and business processes with strong analytical skills
  • Ability to demonstrate support for innovation and for organizational changes needed to improve the organization’s effectiveness
  • Ability to delegate responsibility and to work with others and coach them to develop their capabilities
  • Exceptional experience in resolving production support process / methods, troubleshooting and proposing solutions using a change management process in Production Environment
  • Expertise in creation and update of Technical and Functional Documents - Business Process Document, Software Requirements and Solution, High level Design, Low Level Design, Impact Analysis, ER Diagrams, and Gap Analysis, Data mapping, Data Integration and Audit Report documents
  • Exceptional expertise in performing Unit Testing, Functional Testing, Integration Testing and performance testing

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i/8.x; MS Access

ERP Products: Oracle Applications R12, ORION Enterprise Resource Planning Product Suite; ORION Third Party Logistics and Warehouse; ORION Cart

Application Building Tools: Oracle Developer 2000 (Forms/Reports 6i); Oracle Forms 11g/10g; Oracle Application Express (APEX 4.0, 5.1)

ETL and Data warehousing: Erwin, Oracle SQL Loader, Oracle Data pump, Oracle Data Integrator (ODI)

Business Intelligence: Oracle Business Intelligence (OBIEE)

Reporting Tools: Oracle Business Intelligence Publisher (BIP), Oracle Reports 11g/10g/9i/6.i/2.5; Oracle Business Intelligence Discoverer

Functional Knowledge: Enterprise Resource Planning (ERP) Modules - Supply Chain Management, Finance, Manufacturing, Sales, Procurement, Inventory and Assets Management, Warehousing, Third Party Logistics

Programming: SQL; PL/SQL; HTML; Shell Scripts; XML, C Programming

Portal: Oracle 11g/10gAS Portal

Other Tools: Erwin Data modeller, SQL*Plus, PL/SQL Developer, Toad, Toad Data Modeler, SQL Developer Data Modeler, SQL Developer, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Senior Oracle PLSQL Developer

Responsibilities:

  • Develop, administer Trade submissions and maintain Global Repository Services for USA, Europe, Canada, Australia and Singapore
  • Develop and maintain services with respect to maintaining Centralized reference data repository for all Legal Entities such as Reporting & non - reporting Party, Clearance Entity, and Broker Entities
  • Develop Inter Trade Repository reconciliation algorithms to reconcile Trade repository between different Trade Repositories such as CME vs DTCC
  • Develop Regulatory Reporting for various Trade Repository Regulators using complex SQL queries, sub queries, and Inline Views e.tc on Oracle Database
  • Design, Develop, Unit Test and maintain complex Oracle partitioning & Indexing Scheme, Data Models, PLSQL procedures, packages, and triggers for Data Extraction, Transformation and Loading
  • Maintain Integrity, Security and Optimum Performance by performing Oracle performance tuning activities which includes query optimization, partitioning, indexing, explain plans, Tkprof utility, hint usage e.tc
  • Develop Data Warehouse and ETL (Extract Transform and Load) designs for various Trade Repository Data Marts
  • Development ETL using Informatica mapping designer, and Informatica workflow builder
  • Troubleshoot and support Production GRS (Global Repository Services) Application
  • Develop UC4 jobs, UC4 Work Flows and UC4 Schedules to schedule various ETL, Database maintenance, and Regulatory Reporting Jobs

Environment: Oracle database Exadata, Oracle 12c, Linux, Shell Scripting, Oracle SQL Developer, Toad Data Modeler, Toad, UC4, and Java

Confidential, Cleveland, OH

Senior Oracle PLSQL Developer

Responsibilities:

  • Develop Triggers to capture change data
  • Develop PLSQL packages to extract and transform “change data” to make data available for “Polling” to all POS stores
  • Invoke “Polling” messaging services to poll “change data” to all the POS stores
  • Develop interfaces and programs using PLSQL to invoke web services
  • Develop shell scripts and PLSQL packages to schedule batch runs for ETL jobs
  • Develop Shell scripts and PLSQL packages to schedule payroll processing, report generations and perform benefit adjustments
  • Develop Test scripts using Oracle SQL Developer
  • Develop batch runs to email deliver various cost center and P&L reports to users
  • Develop PLSQL packages and shell scripts to Automate “Reorder” of deposit slips to POS stores
  • Develop interfaces between java UI and Oracle database to read, extract and load XML data passed into database and vice versa
  • Used SQL Loader functions and control files to mainframe data(legacy application) from Flat files
  • Develop Partitions; Use explain plan and perform SQL Query Optimization and tuning
  • Monitor and scheduling jobs through the UC4 tool

Environment: Oracle database Exadata, SQL, PL/SQL, Linux, Shell Scripting, Crystal reports, Oracle SQL Developer Data Modeler, Oracle applications R12 ERP, Java and web server

Confidential, Green Bay, WI

Senior Oracle PLSQL Developer

Responsibilities:

  • Develop Test scripts, SQL, PL/SQL programs, Packages, Stored procedures, Functions and Triggers to enhance WMS mobile applications
  • Document system requirements and create design documents for OBIEE dashboards for “Online Appointments” scheduled through Lean logistics - “On Time performed Appointments”, “Appointments performance analysis”, “Packaged RM Cost analysis”, etc
  • Used External tables, and SQL Loader functions load data from Flat files
  • Use Informatica Designer to create and manipulate source and target definitions, and mappings to load initial set of WMS appointment data into Lean Logistics System
  • Building Business intelligence Analysis and dashboards
  • Create BIP Publisher data model and reports (BIP) for warehouse management system
  • Build / enhance WMS labels such as 3PL, unit, and LPN labels using Loftware label solutions and C programs
  • Develop Enhancement of signature pad application to print BOL copies using C Programming
  • Building Business intelligence Publisher reports
  • Building Data models using Erwin, and SQL Developer Data modeler
  • Building API’s and oracle interfaces to create and update appointment schedules through transaction messaging for various WMS jobs in WMS applications using oracle SOA integration framework suite
  • Develop Integration API’s with Lean logistics appointment scheduling application
  • Providing DBA support; Use explain, Generate Tkprof; use explain and perform SQL Query Optimization and Performance tuning
  • Customer and product Support of Oracle applications R12 Inventory management system
  • Customer and user support of warehouse management application
  • Monitor and scheduling jobs through the UC4 tool

Environment: Oracle database 12c, SQL, PL/SQL, Forms 11g, Oracle Reports 11g, Oracle SOA, PL-SQL Developer, Oracle SQL Developer Data Modeler, Oracle Business Intelligence Publisher and OBIEE, Informatica, Loftware label solutions, Oracle applications R12 ERP, Oracel APEX 5.0, Linux, Shell Scripting

Confidential ., Arlington, VA

Senior Oracle PLSQL Developer

Responsibilities:

  • Develop SQL, PL/SQL programs, Packages, Stored procedures, Functions and Triggers to automate the interface processes for daily/incremental ETL
  • Use Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations and re-usable transformations
  • Use ETL tool (Informatica Power Center) to migrate data from legacy system (NEW Vern) to Oracle
  • Building Data models using Erwin, SQL Developer Data modeler and Coordinate data model structure with Business Intelligence development team
  • Design and Develop Finance Funding Module, Loan module, and Budgeting module using Oracle Forms 10g/11g and Oracle Reports10g/11g, Oracle 11g Database
  • Creating scripts to generate the data for reports developed in Oracle reports as per user requirements.
  • Created database triggers for Audit Trails and data analysis
  • Creating scripts to generate the data for reports developed in Oracle reports as per user requirements.
  • Developed Data analysis scripts to analyze Legacy System Data and cleanse as per data requirements for upload
  • Design and develop Integration schedules to export and receive data into flat csv files from Oracle to partner’s and USAID
  • Monitor and scheduling jobs through the UC4 tool
  • Perform DBA activities such as Creating jobs and schedules them to run on the specific times, Setting up email notifications for failure and other events using DBMS SCHEDULER
  • Perform other basic DBA activities such as refreshing database, review tablespace usage and monitor performance and clearing dead locks or blocking sessions
  • Developing technical solutions / Business cases for Supply Chain Management ERP software, CRM software solution and Business Intelligence reporting requirements. The robust solution spans across the following modules - CRM portal, Finance, Accounts payables, Order Management, Procurement, Inventory Management, MIS Reports, Data warehouse for Business Intelligence tool / Order portal / MIS reporting)
  • Design and Develop Logical and Physical Data models using Oracle SQL Developer Data Modeler
  • Develop and enhance Complex forms / reports using Oracle Forms 10g / Oracle Reports 10g for the Supply Chain Application such as Purchase Order, Sales Order, Invoice, Delivery Note, EDI interfaces, Finance project and funds accounting transactions.
  • Designed and developed multiple Oracle reports using Oracle Business Intelligence Discoverer Administrator and Oracle Business intelligence desktop tool
  • Extensively worked in Complex Matrix reports and created multiple reports involving Matrix functions using Oracle Business Intelligence Discoverer
  • Created Data Mapping documents, Look-up table and Hand shaking techniques to exchange data with third party EDI vendors using EDI’s such as 211, 940, 214, 944 e.tc
  • Developed EDI packages using PL/SQL and Evision software to receive / send supply chain data using EDI exchanges as per ANSI X12 standard and AS2 transmissions
  • Create Shell Scripts in SSH Client Environment for running server side SQL/PLSQL scripts for ETL and EDI exchanges
  • Understanding and Discovering Business Requirements through discussions with Business power users
  • Creation of High Level and Low Level Design Documents, and Program Specification documents
  • Creation of Functional Requirements Specifications (FRS/FRD) document
  • Preparation and review of Business Requirement Document (BRD)
  • Monitoring scope and scope changes using a change management process
  • Developed and Implemented Business models, Work Flow Models
  • Created process flow diagrams for Funding, supply chain solutions and customer order management using VISIO
  • Design, Develop / customize various functions of the ERP suite to deliver customer specific solution for Supply Chain, Customer Order Management and Finance
  • Design data security classification document and implement / configure business rules to achieve data security within various systems
  • Design and Develop data warehouse for “Order Tracking and My-Commodities” website using Oracle tools
  • Provided Business cases, and data integration related system requirements to Website MIS team to develop “ Online customer Order Entry system using Perfect Forms solution” and “Online Order tracking and My-commodity website” system
  • Design and Develop Oracle Scheduler to run certain EDI job’s and send E-mail Notification’s to Business users and MIS team about errors
  • Involved in unit testing, Integration testing, UAT Testing and Go-live preparation and helped creation of standard operating procedure, user manual and Training documents
  • Prepared Test Strategy Document, detailed Test Plans and Test Cases which specify testing overview and testing approach depending on the Business and Technical requirements
  • Involved in Production maintenance of the ERP application
  • Responsible for preparing the migration and deployments scripts for UAT as well as PRODUCTION environments
  • Generating the AWR Report and Identifying the top SQL’s In the Database.
  • Performance tuning and trouble shooting in the production environment using Bugzilla system and Heat support systems

Environment: Oracle database 12c, SQL, PL/SQL, Oracle Forms 11g, Oracle Reports 11g, EDI, Oracle SQL Developer Data Modeler, Oracle Business Intelligence Discoverer, SSH Client, VmSphere, Toad, Win 2008 and Unix, Business Intelligence; Shell Scripting; Informatica Power Center

Confidential

Senior Oracle PLSQL Developer

Responsibilities:

  • Develop SQL, PL/SQL programs, Packages, Stored procedures, Functions and Triggers to automate the interface processes for daily/incremental ETL
  • Prepare Software requirements Solution Document
  • High Level Design of Data Access Layer - Table Design, Temporary table design and usage, data partition, indexes
  • Define warehousing methods and data mining techniques
  • Design and Develop Logical and Physical Data models using Oracle SQL Developer Data Modeler
  • Use Data migration and ETL tools (Oracle Data Integrator) to migrate data
  • Analyze data to identify and report useful data patterns
  • Design and develop Framework Components for APEX and OBIEE
  • Develop APEX pages for Warehouse management application
  • Project Management
  • Design and enable security and scalability into the system
  • Develop Key Libraries using PLSQL, HTML and APEX
  • Define and Prototype Usability
  • Code Licensing schema using PLSQL
  • Define quality check lists and integration test cases
  • Design and enable security and scalability into the system
  • Query Optimization and Performance tuning
  • Develop Dashboards using OBIEE for Asset Management, Finance MIS and Supply Chain KPI’s

Environment: Oracle 11g, OBIEE, Oracle Application Express, BI publisher, CSS, SQL/PLSQL, HTML, JAVA scripting, Unix

Confidential

Senior Oracle PLSQL and XML Developer

Responsibilities:

  • Architect and development of “3PL (Third Party Logistics) logistics Management application”
  • Prepare Software Requirements Solution Document
  • High Level and low level design
  • Define Standalone interfaces and third party integration services using PLSQL packages
  • Prepare prototype and receive acceptance from Product Management group
  • Project Management
  • Design and Develop Logical and Physical Data models
  • Develop Complex forms/ reports using DEVELOPER 2000 (Forms 11g, Reports 11g) for the Application
  • Creating schema objects and implementing rules for data integrity
  • Develop XML interfaces using PLSQL to communicate with Hand held terminals
  • Develop Key processing triggers and procedures using PLSQL
  • Define quality check lists and integration test cases
  • Developing enhancements to C programs to print barcoded labels (Pick, Shipping, product, Job card labels for Loading/unloading, and position labels) as per configuration

Environment: Oracle 10g, Oracle Forms 10g, SQL/PLSQL, Dot Net for Hand Held Terminal programs, Unix

Confidential

Oracle PLSQL and XML Developer

Responsibilities:

  • Design and Develop “Warehouse inventory application”
  • Prepare Software requirements Solution Document
  • High Level and low level design
  • Design and Develop Rule Engine
  • Design and Develop Logical and Physical Data models
  • Develop Complex forms/ reports using DEVELOPER 2000 (Forms 11g, Reports 11g) for the Application
  • Creating schema objects and implementing rules for data integrity
  • Define Standalone interfaces and third party integration services for stock upload or service request uploads through web using PLSQL packages
  • Prepare prototype and receive acceptance from Product Management group
  • Project Management
  • Develop XML interfaces using PLSQL to communicate with Hand held terminals
  • Developing enhancements to C programs to print barcoded labels (Pick, Shipping, product, Job card labels for Loading/unloading, and position labels) as per configuration
  • Develop Key processing triggers and procedures using PLSQL

Environment: Oracle DB 10g, Oracle Forms 10g, SQL/PLSQL, Pro*C, Dot Net for Hand Held Terminal programs Oracle

Confidential

Oracle PLSQL, and XML Developer

Responsibilities:

  • High Level and low level design
  • Define Prototype and Usability
  • Code procedures to exchange data between HHT and Oracle
  • Develop XML interfaces using PLSQL to communicate with Hand held terminals
  • Develop Key processing triggers and procedures to create transactions using PLSQL

Environment: Oracle DB 10g, SQL/PLSQL, Dot Net for Hand Held Terminal programs.

Confidential

Oracle PLSQL, XML Developer

Responsibilities:

  • Develop Standalone interfaces and third party integration services using PLSQL packages
  • Project Management
  • Develop XML interfaces using PLSQL to communicate with BAPI (SAP)
  • High level Design of data transfer / storage, error handling, design "meta data structures" to handle data transfer, business rules and interfaces for external communication
  • Writing SQL, PL/SQL programs, Packages, Stored procedures, Functions and Triggers to read / write into XML data from / to ERP warehouse management application
  • Design API for the product to communicate with other systems using interfaces. Enable third party systems to call such API to seamless integrate with our product

Environment: Oracle SQL/PLSQL, BAPI Programming and XML Interface

Confidential

Oracle PLSQL, Dot net Developer

Responsibilities:

  • High level and Low level design
  • Define prototype
  • Writing SQL, PL/SQL programs, Packages, Stored procedures, Functions and Triggers to automate to transfer questionnaire data in XML format to Oracle
  • Decode transferred data into DML commands based on master mapping definitions. The DML’s are executed sequentially as per the defined rule by the rule engine

Environment: Oracle SQL/PLSQL, Dot Net

Confidential

Oracle PLSQL, Forms and Reports Developer

Responsibilities:

  • Creating materialized views to generate the data for reports developed in Oracle reports as per user requirements
  • Developed Data analysis scripts to analyze Legacy System Data and cleanse as per data requirements for upload
  • Designed and developed multiple reports using Oracle Reports builder and Oracle Discoverer Reports
  • Query Optimization and Performance tuning
  • Design Framework Components for customization
  • Code PL/SQL Triggers and Procedures
  • Generate AWR Reports, SQL Tuning and Optimization
  • Develop Forms and Reports using Oracle Developer 2000

Environment: Oracle SQL/PLSQL, Oracle Developer 2000, Oracle Forms 10g

Confidential

Oracle PLSQL, Forms, and Reports Developer / Systems Analyst

Responsibilities:

  • Study and Understand customer business and requirements
  • Demonstrate business intelligence capabilities of the product and request additional KPA or report printing related requirements
  • Understand system integration services required to transfer data from legacy system and plan the data migration process
  • Project Management
  • Business Process Study and Prepare business solution mapping document
  • Prepare Gap document and define process flows
  • Propose alternate solution or customization for gaps and prepare functional specification document for the customization
  • Configure product based on the proposed mapping document
  • Prepare customer solution acceptance criteria document
  • Test customized solution
  • Provide training to end users and achieve acceptance sign off for the product
  • Prepare Live environment - Install and configure Oracle database schema, Basic level Oracle database performance tuning, Install ERP application, upload opening balance data from excel or legacy system and test performance
  • Provide GO Live support

Environment: Oracle Database 10g / 11g, Oracle SQL/PLSQL, Oracle Developer 2000, Oracle Forms 10g, Oracle Application server 10g, SQL* Plus, SQL Loader, SQL Developer, Toad, Oracle Application Express, Oracle Business Intelligence Enterprise Edition, Oracle Discoverer Tool, BIRT Reporting tool, BIRT Analytics / Cube Designer, Integrator Tool, Business Configuration Tool, Administrator and Configuration Tool

Confidential

Systems Analyst and Senior Oracle Support Consultant

Responsibilities:

  • Customer Interaction and telephonic / onsite support
  • Debug Issues and PLSQL code reviews
  • Communicate with back office about product bugs and possible solution
  • Responsible for preparing the migration and deployments scripts for UAT as well as PRODUCTION environments

Environment: Configuration, SQL Developer, Toad, Oracle SQL/PLSQL, Oracle Developer 2000, Oracle Forms 10g

Confidential

Oracle PLSQL, Forms and Reports Developer

Responsibilities:

  • Code Oracle PLSQL Programs and Forms using Oracle Developer 2000
  • Integration Testing

Environment: Forms 6i, Reports 6i, Oracle 8i, Windows 2000, PLSQL, Oracle Designer 2000, MS VISIO 2000

Confidential

Oracle Forms and Reports Developer

Responsibilities:

  • Code PLSQL Programs and Forms using Oracle Developer 2000
  • Integration Testing
  • Deployment Support

Environment: Forms 6i, Reports 6i, Oracle 8i, Windows 2000, PLSQL, Oracle Designer 2000, MS VISIO 2000

Confidential

Oracle Forms and Reports Developer

Responsibilities:

  • Code PLSQL Programs and Forms using Oracle Developer 2000

Environment: Forms 6i, Reports 6i, Oracle 8i, Windows 2000, PLSQL, Oracle Designer 2000, MS VISIO 2000

We'd love your feedback!