We provide IT Staff Augmentation Services!

Senior It Consultant | Senior Oracle Developer Resume

SUMMARY:

Results - driven, customer-focused, and accomplished professional with more than 15 years of proven expertise in all aspects of IT project management, application development, database development and administration in oracle environment. Known for integrity, exemplary work ethic and strong commitment to provide innovative and strategic solutions aligned with diverse client needs and interests. Well-versed in Oracle Fusion Middleware and business intelligence/ETL. Adept at building, motivating and leading high-calibre teams of professionals. Recognized for outstanding leadership, communication, problem-solving and interpersonal skills in building long-term business relationships with professionals of all business levels.

AREAS OF EXPERTISE:

  • Data Modeling and Database Architecture
  • Project Management
  • Agile and Scrum Methodologies
  • Client Relations and Technical Support
  • Cross-functional Team Collaboration
  • Entity Relationship Modeling
  • Systems Analysis, Design, Development, Testing, Documentation and Deployment
  • Full Lifecycle Application Development
  • User Acceptance Testing and System Integration Testing
  • Exceptional expertise in performing as an Oracle Database Administrator, with knowledge of database design, data modeling, database maintenance, server installation and migration, client configuration, space management, backup and recovery, network administration, data access rules and security, capacity planning and performance tuning
  • Extensive experience in requirements gathering, system analysis, development, testing, documentation and deployment using Oracle, SQL*PLUS, PL/SQL, Oracle Developer Suite (WEB Forms 6i, 9i and 10g; Reports 6i, 9i and 10g) and Pro*C under UNIX and Windows Servers
  • Proven expertise in various system development methodologies and full lifecycle application development, quality control, prototyping, entity relationship modeling, data flow diagrams and functional hierarchy diagrams
  • Hands-on knowledge in developing SQL queries, PL/SQL packages, functions, triggers, stored procedures and cursors; as well as database objects such as views, tables, synonyms, sequences and indexes
  • Comprehensive background in using records and collections, nested tables, dynamic SQL, bulk bind, ref cursors and various advanced Oracle for PL/SQL programming features
  • Well-versed in SQL and PL/SQL tuning and query optimization tools, such as SQL Trace, Explain Plan and DBMS PROFILER; Oracle utilities such as SQL*Loader and Export/Import; and data pump utilities such as EXPDP/IMPDP
  • Solid familiarity with using packages such as DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL SMTP; PL/SQL Wrapper to protect the PL/SQL procedures or packages
  • Expertise in using Informatica and ETL methodologies, such as star schema, snow flake schema, dimension and fact table, to support data extraction, transformation, loading and processing
  • In-depth knowledge of Oracle Business Intelligence Enterprise Edition(OBIEE) Architecture and various OBIEE components such as analytic server, web server, RPO, webcats, security, Dashboards, Reports, iBots and scheduler:
  • Development of metadata repository with three layers - physical layers, presentation layer and business model and mapping
  • Creation of OBIEE analytics repository with aggregate navigation, dimension hierarchies, and level-based measures
  • Building of interactive dashboards with drill-down capabilities, as well as various charts with page level prompts and filters
  • Configuration, installation, and management through administration tools and BI Publisher Desktop and Client Edition
  • Utilization of Microsoft Word to develop Oracle BI Publisher Report templates
  • Strong knowledge of using Oracle ADF (Oracle ADF 11g Architecture and JDeveloper) and Oracle ADF Development (ADF BC, ADF Faces, view criteria's, task flows, web services, ADF security and deployment) to develop applications; Oracle SOA (BPEL, WSM and ESB, JNDI, Web Services - SOAP, Oracle Service Registry) technology to develop web services; and design, develop, and deploy web services using Oracle BPEL, Java and XML

TECHNICAL SKILLS:

Technologies: Oracle Developer Suite (FORMS 11g/10g, REPORTS 11g/10g, Designer10g) | J2EE | Web Service, JDBC | Oracle Business Intelligence | ETL - Informatica | Microsoft .NET Framework (3.5 and 4.0), Oracle SOA Suite (BPEL, Human Workflow, ESB, Adapters, WSM, SOAP, WSDL) | Oracle OSB, MVC Architecture | SharePoint | ORM(Devart) | Oracle Fusion Middleware11G, Oracle ADF (ADF, ADF Faces, ADF Task Flows and Business Components)

Application Servers: Apache Tomcat (5.x/6.x) | Oracle Web Logic 10.1.3 | Oracle 10iAS/9iAS (Apache,OC4J, Portal SSO)

Database: Oracle (11g/10g/9i/8i/8.0) | SQL Server (2008/2005)

Software: OBIEE 11g/10g | Oracle BI Publisher | Siebel 7.5 | JDeveloper 11g | SQL Developer | TOAD Discoverer | Oracle Developer Suite 11g/10g (FORMS 11g/10g,REPORTS 11g/10g) | VSS | TFS Oracle Designer | Oracle Developer 2000 (FORMS 4.5, REPORTS2.5) | SQL*PLUS | SQL*LOADER Oracle Enterprise Manager | Eclipse IDE | Crystal Reports | Informatica (6.1/9.1) Visual Studio (2008 and 2005)

Programming Languages: SQL | PL/SQL | Pro*C | C | C#| JAVA | COBOL | Clipper | HTML | CSS | JavaScript | ASP | XML Oracle ADF Faces | XSLT | XSL | AJAX | Korn Shell | C Shell | Bourne Shell | .NET (ASP.Net, C#.Net)

Data Modeling Tools: Power Designer | Oracle Designer | Oracle BI Administration | Informatica

PROFESSIONAL EXPERIENCE:

Confidential

Senior IT Consultant | Senior Oracle Developer

Tools: Oracle 10g, ASP.Net, C#.Net, Power Designer, Oracle BI Publisher, SQL Developer, SQL, PL/SQL, SQL Server

Responsibilities:

  • Developed and evaluated functional specification documents for consultant selection (CSAM), stakeholder, TAPs and Confidential
  • Utilized Power designer to create and manage physical data and E-R models
  • Created and provided support on database schemas, business rules, functional requirements, and code scripts using Oracle 10g, SQL, PL/SQL and Program Unit (functions, procedures, packages, database triggers, sequences, synonyms and grants)
  • Took charge of tuning performance of database objects, including tables and store procedures
  • Built and delivered support on ICAPS interface, as well as the RAP and CMS systems
  • Generated reports in Oracle BI Publisher using templates made in Microsoft Word
  • Due to integrated procurement modules in this system ease of work to various departments
  • Successfully deployed the project to production

Confidential

Senior Oracle Developer

Tools: Oracle 10g, ASP.Net, C#.Net, Power Designer, SQL, PL/SQL, SQL Developer, Oracle BI Publisher

Responsibilities:

  • Created and provided support on database schemas, business rules, functional requirements, and code scripts using Oracle 10g, SQL, PL/SQL, Program Unit
  • Designed, developed and maintained interface between OPRA and IMAGIS to manage personnel payroll and deductions
  • Constructed batch processes to synchronize data between IMAGIS and OPRA systems
  • Built and ran unit testing scripts prior to code deployment, and sent results to the rational quality manager (RQM) system
  • Utilized Oracle BI Publisher Desktop to develop reports through templates made in Microsoft Word; integrated reports with application and devote efforts to produce output in PDF, Excel and Confidential formats
  • Successfully implemented Parking project across GOA ministries
  • Effectively utilized stalls and gain revenue on empty stalls

Confidential

Senior Oracle Developer

Tools: Oracle 10g, Asp.Net, C#.Net, SQL, PL/SQL, Toad 9.2

Responsibilities:

  • Created physical data and E-R models using Power Designer
  • Utilized VSS version control system to manage component versions
  • Developed SQL scripts for database schema and relevant objects
  • Drafted system design, interface design and developer guide documents; managed them in SharePoint
  • Successfully deployed the project to production

Confidential

Senior Oracle Developer

Tools: Oracle 10g, Oracle Developer Suite 10g(Forms, Reports), Oracle Designer, Oracle 10iAs, SQL Server, C#, Toad 9.2, PL/SQL, SQL Scripts, SQL Developer

Responsibilities:

  • Assumed responsibility in designing, analyzing, developing, managing, supporting, testing and overseeing document, database and application systems
  • Leveraged technical expertise in developing and supporting database schemas, business rules, functional requirements, and code scripts
  • Developed a web service for the CMS interface to verify project, contract, change order and invoice data
  • Applied Oracle encryption and decryption to validate interface users, and utilized AES256 algorithm to invoke interface processes
  • Utilized C# to create applications to migrate data from project module to RAP
  • Built, compiled and managed patches to resolve system issues and provide system enhancements; collaborated with quality assurance units and end users to release patches across multiple platforms
  • Gained the Teamwork Award for the successful implementation of the Confidential project module

Confidential

Senior Oracle Developer

Tools: Oracle 10g, Asp.Net, C#.Net, SQL, PL/SQL, Toad 9.2

Responsibilities:

  • Built and supported implementation of business rules and functional guidelines
  • Served as primary technical resource to support the resolution of system issues and implementation of system enhancements on UAT
  • Initiated unit testing and submitted bugs for developers
  • Achieved the Premier’s Award for Excellence in recognition for the successful project implementation

Confidential

Senior IT Consultant | Senior Oracle Developer

Tools: Oracle 10g, Oracle Developer Suite 10g, Oracle 10iAS, SQL, PL/SQL, Toad 9.2

Responsibilities:

  • Designed, evaluated, supported, managed and tested document database and application automation for mail merge and automated batch processes in generating daily, weekly and monthly reports
  • Leveraged technical expertise in swiftly resolving bugs and errors in the SMART system
  • Performed unit testing and documentation, and provided support in project implementations
  • Deployed enhancement on existing system in production

Confidential

Senior IT Consultant | Senior Oracle Developer

Tools: Oracle 10g, Oracle Developer Suite 10g (Forms, Reports), Oracle 10iAs, SQL, PL/SQL, Toad 9.2

Responsibilities:

  • Performed system analysis and design to determine federal and provincial tax through a tax formula provided by the government
  • Created Oracle forms and reports, as well as relevant packages in accordance with project requirements
  • Developed SQL scripts for database schema and relevant object creation
  • Managed component versions using VSS version control system
  • Seamlessly deployed the tax module to production

Confidential

Senior IT Consultant | Senior Oracle Developer

Tools: Oracle 10g, Oracle Developer Suite 10g (Forms, Reports), Oracle 10iAs, PL/SQL, PL/SQL HTML Package

Responsibilities:

  • Constructed new batch programs and Oracle forms and reports in accordance with project guidelines
  • Utilized PL/SQL HTML Package to create new web page for the student registration site
  • Performed unit testing and documentation while providing ongoing implementation support
  • Successfully deployed enhancement on existing system in production

Confidential

Senior IT Consultant | Senior Oracle Developer

Tools: Oracle 8i/9i, SQL, PL/SQL, Asp.Net, C#.Net, Toad

Responsibilities:

  • Assumed responsibility in the development of database, as well as the database procedural logic for the meta-data driven financial reporting system
  • Functioned as main technical support for the application and database system, including troubleshooting, system enhancement, and problem resolution
  • Implemented improvements to the CFIS project after successful deployment to production

Confidential

Senior Oracle Developer | Senior Oracle Database Administrator

Tools: Oracle Database 8i/9i, SQL, PL/SQL, Toad, Oracle Developer Suite 9i (Forms, Reports), Oracle Designer, Oracle 9iAS, Developer 2000 (Forms 4.5, Reports 2.5), Solaris 2.6/2.5.1, Pro*C, UNIX, SQL Server 2000/2005

Responsibilities:

  • Built and oversaw the client-server based ERP system and the Amul Online ERP system to manage supply chain management operations while smoothening member union, suppliers and transporters, depot, wholesale dealers and retailers activities
  • Created and implemented new modules including conditional data interchange between Headquarters to Zone to Depot and back
  • Developed web-enabled Oracle forms and reports, along with PL/SQL procedures, functions, packages and triggers for various modules under the EIAS and Web-EIAS system
  • Calibrated SQL queries to optimize efficiency and performance
  • Supported other units, including the Business Analyst Team, Testing Team and business users, by providing online technical support, troubleshooting and problem resolution
  • Formulated and established installation guidelines for application and software patch, software upgrade, module design and implementation steps
  • Provided strategic leadership to the production, development, and testing of Oracle and Oracle applications server across various platforms
  • Utilized RMAN scripts for backup and recovery operations, and keenly observed the online database performance using TOAD
  • Isolated and resolved system errors during data loading
  • Evaluated database schemas for four production databases, and disseminated necessary scripts to all 54 depots and 6 zones
  • Initiated successful database defragmentation using export and import functions
  • Collaborated with various teams in the upgrade and migration of Oracle databases, including developing scripts to convert all database objects
  • Established guidelines for the Oracle software installation for both client and server side, Oracle 9iAS and ERP database configuration, database import and export, database backup and recovery and database health check-up
  • Played a major role as part of a team to receive the International CIO 100 Award For Resourcefulness in recognition for the successful implementation of an ERP system for supply chain management

Confidential

Senior Oracle Developer

Tools: Oracle 9i, Siebel 7.5, Informatica 6.1

Responsibilities:

  • Designed, analyzed, developed and implemented numerous DSS/MIS reports and integration with existing ERP systems
  • Gathered Siebel Analytics Reports and Dashboard requirements; determined facts, dimensions and hierarchies for dimension modeling
  • Developed a dashboard for strategic trust area as outlined during annual meetings
  • Generated daily, monthly and annual reports, including aggregate sales, town sales, scheme versus sales, plan versus sales, product age, product sales and product categories
  • Identified mapping from numerous physical databases to business layer in developing various subject areas in the presentation layer
  • Facilitated technical and user documentation training
  • Gained the TQM Awards for best team performance, business process, process improvement and end user satisfaction ratings

Confidential

Oracle 9i, Oracle Developer

Responsibilities:

  • Utilized expertise to develop a web-based system to provide updated information on vehicle movement
  • Improved vehicle movement monitoring in supply chain at member unions, transporters, head office, zonal office, depots and wholesale dealers

Hire Now