We provide IT Staff Augmentation Services!

Sql Developer Resume

4.00/5 (Submit Your Rating)

SUMMARY:

  • I have over twenty years of experience in multiple areas of business operations including but not limited to business and systems analysis, systems development, financial analysis, process analysis, data warehousing, SOX, SOD, ERP implementation / support / operational management, SDLC including systems planning, design and implementation, and has managed large projects encompassing multi - disciplined staff and project goals.
  • I have worked extensively within a variety of industries (70% public 30% private sector) assisting clients with implementing management systems and related business processes.
  • My work has directly supported and bend conducted for a variety of operational personnel including FP&A, Finance, IT (support and development), PMO, Planning, Tax, Manufacturing, Revenue, and Budgeting.
  • I have worked primarily in a multi-tasked capacity applying management, analysis, and tactical/strategic skills to all sizes of teams and projects on multi - year engagements, as well as short term strategic projects.
  • I am fully capable of delivering strategic or direct specific expertise and skills to a variety of responsibilities and tasks.
  • Leveraging the use of several systems development methodologies, development of teams, conduct of a project, financial analysis, risk management, project management, business analysis and engineering, definition, requirements analysis, business process design, technical design, development, implementation, and post implementation support. Primary areas of focus have included Core Financials (including eBTax, Accounts Receivable, GL, AP, Purchasing, Assets, etc.), Order to Cash (OTC), Revenue Recognition, Procure to Pay (P2P), and Supply Chain Management (SCM).
  • I am a hands-on person whom is well able to work in a concurrent fashion detail technical, functional, and management tasks and roles. He remains current in his skill set relative to Oracle Technologies (60% functional, 40% technical), and in standard MS Office tools.

KEY SKILLS:

  • ERP & E-Commerce - developed, implemented, and managed implementation of MIS solutions
  • Software Development Management
  • Administrative Policy Development & Management
  • Web Development
  • Strategic Business and Operations Business Plan Departmental Operations
  • Development and Implementation
  • Staff oversight / Team Management (technical & functional)
  • Project meeting / presentation
  • Project planning & control (MS Projects)
  • Project implementation
  • Client training & education
  • Activity Based Costing
  • Budgeting
  • Standard Costing
  • Basic Accounting
  • Applied Statistical Analysis
  • Indirect cost development & analysis
  • Strategic Plan development and implementation

CORE SKILLS:

  • Oracle Applications ERP Implementation (Cloud/Fusion & EBS)
  • Conference Room Piloting
  • Production Systems Management & Issue resolution
  • Help Desk Operations
  • Strategic Planning
  • Business Process Reengineering (BPR)
  • Business Operations including OTC, P2P, SCM
  • Systems Development (SDLC)
  • Data Warehousing
  • IV&V, PMO, Project Oversight
  • SOX, HIPAA
  • Disaster Recovery
  • SOX, SOD, Testing, Training, Implementation, Support
  • RICE
  • Oracle Financials Release 12 to 9.5 (eBTax, AGIS, Receivables, GL, FA, AP, PO, iProcurement, Internet Expense, Sub - Ledger Accounting (SLA), FSG, ADI, Trade Management, Accounting, FAH - Financial Accounting Hub, Revenue Recognition)
  • Oracle Projects Modules (PA, PB, PM)
  • Oracle Manufacturing (Order Management, Inventory, QA, Trade Management)
  • Oracle HRMS
  • Oracle Tools - Discoverer, TOAD, SQL/PLSQL, Formscape, XML Publisher, Microsoft Office, MS Project
  • Order to Cash (OTC), Procure to Pay (P2P)

TECHNICAL SKILLS:

  • Oracle Release 9, 10, & 12 Applications in character, client server, & Web configurations
  • Oracle Multi-Org Configurations
  • Oracle Applied Implementation Methodology (AIM)
  • Oracle Purchasing
  • Oracle General Ledger
  • Oracle Accounts Payable
  • Oracle Cash Management
  • Internet Expenses
  • Oracle Assets
  • Oracle Discoverer (Release 2 - 4)
  • Oracle Browser
  • Oracle Self Service Web Applications (including Web Employees, Web Requisitions, Web Suppliers)
  • Oracle Inventory
  • Oracle Financial Analyzer
  • Oracle Express Analyzer
  • Oracle Project Accounting
  • Oracle System Administration
  • Oracle Office & Interoffice
  • Oracle Developer 2000
  • Oracle Designer 2000
  • Oracle Project Billing
  • Oracle Project Costing
  • Oracle Project Management
  • Oracle AME
  • Oracle User Management
  • Oracle Sub Ledger Accounting
  • Oracle Financial Accounting Hub (FAH)
  • Remedy
  • MS Excel
  • MS Word
  • MS PowerPoint
  • MS Project (98 & 2000)
  • Primavera TeamPlay
  • Lotus 1-2-3
  • Visio
  • Relational Report Writer
  • Netscape Internet Software
  • MS Explorer
  • On-Net
  • Smart Term
  • DOS Utilities, Windows Utilities
  • Lotus CC Mail
  • DOS
  • UNIX
  • Windows 95, 98, & NT
  • SQL/SQL Plus
  • X-Base (Clipper, Fox, D-Base, Access)
  • Pascal
  • Java, HTML
  • Helpdesk and Technical support
  • Software Development Life Cycle (SLDC) Methodology
  • Inventory Control - MRP, Khan Ban, JIT

PROFESSIONAL EXPERIENCE:

Confidential

Applications& Tools Used:Oracle Financials (GL, AGIS, AP, AR, PO, FA, Coupa, Concur, Blackline, Cash Management) iSetup, System Administration, Diagnostics, Excel4Apps HCM, FIN (GL Wand), User ManagementMS Office, Forms DataLoader, MS Project, SQL Developer, TOAD

SQL Developer

Responsibilities:

  • Implementation with Oracle R12.2.x +
  • ERP Systems Management, issue resolution, and enhancement.
  • Core fundamental analysis of prior project work and analysis to provide independent perspective on developed solutions to date.
  • Facilitated full functional and technical configuration of Oracle General Ledger, Organization constructs) along with full documentation.
  • Developed core functional and business processes and configurations using GL Wand and Allocations functionality related to multi-staged and multiple mass allocations
  • Developed integrations and approaches with COUPA and Concur Software.
  • Created Full GL Business Process Design documentation and deliverables.
  • Development of full process for new Entity incorporation into existing configuration and solution.
  • JAD Session work under a JAR approach
  • As-Is, To-Be, Solution Design, Transition Planning, documentation, development, planning and execution.
  • Lead on CRP (conference room pilot), SIT, and UAT testing including full testing scenario and script documentation and presentation materials.
  • Provided technical support to developed solutions for the entire life cycle of the project.
  • Developed co-operating Primary, statutory and adjustment ledgers to support the business
  • Developed and maintained AME/Workflow rules for iProcurement, requisition approval, po approval and ap invoices approval.
  • Business requirements, Gap Analysis, Solution Design, Risk Management, Testing, and other PMO/Project management documentation and standards
  • Development of full SOD (Separation of Duty), and SOX (Sarbanes Oxley) compliant security and protocols and solutions for system access
  • Standard AIM documentation - MD50, CV70, BR100 and other relevant standard documents of the tool.
  • Development of Migration and Conversion Strategies and associated documentation.

Confidential

Applications& Tools Used: Oracle Financials (GL, AGIS, AP, AR, PO, FA, Cash Management) iSetup, System Administration, Diagnostics/Analyzers, Coupa, Concur, Excel4Apps HCM, FIN (GL Wand), User ManagementMS Office, Forms DataLoader, MS Project, SQL Developer, TOAD

SQL Developer

Responsibilities:

  • Implementation with Oracle R12.2.6
  • Development of Core COA Structures and design
  • Core fundamental analysis of prior project work and analysis to provide independent perspective on developed solutions to date.
  • Facilitated full functional and technical configuration of Oracle General Ledger, Organization constructs) along with full documentation.
  • Developed core functional and business processes and configurations using GL Wand and Allocations functionality related to multi-staged and multiple mass allocations
  • Developed integrations and approaches with COUPA and Concur Software.
  • Developed functional specifications for Customer facing documents
  • Created Full GL Business Process Design documentation and deliverables.
  • Development of full Business Requirements and Solution Design
  • JAD Session work under a JAR approach
  • As-Is, To-Be, Solution Design, Transition Planning, documentation, development, planning and execution.
  • Lead on CRP (conference room pilot), SIT, and UAT testing including full testing scenario and script documentation and presentation materials.
  • Provided technical support to developed solutions for the entire life cycle of the project.
  • Created and validated COA and AFF Structures and designs.
  • Developed co-operating Accrual and Cash based ledgers and solutions to support the business
  • Business requirements, Gap Analysis, Solution Design, Risk Management, Testing, and other PMO/Project management documentation and standards
  • Development of full SOD (Separation of Duty), and SOX (Sarbanes Oxley) compliant security and protocols and solutions for system access
  • Documentation development and standards for IT and Business Processes including: Closing Processes, User Security, Financial Processes, Conversion, Migration, System Configuration, Change Management Control
  • Delivered a variety of documentation on standard processes for IT operations in support of the Application Suite.
  • Developed extensions, tweaks, and custom reports for business needs.
  • Issue resolution from both the front side, back side evaluation and with support of Oracle Support.
  • Standard AIM documentation - MD50, CV70, BR100 and other relevant standard documents of the tool.
  • Development of Migration and Conversion Strategies and associated documentation.

Confidential

Applications& Tools Used:Oracle Financials (GL, AP, AR, PO, FA,) iSetup, System Administration, Diagnostics, Excel4Apps (GL Wand), User ManagementMS Office, Forms DataLoader, MS Project, SQL Developer, TOAD

SQL Developer

Responsibilities:

  • Implementation with Oracle R12.2.6Development of full Business Requirements and Solution Design
  • JAD Session work under a JAR approach
  • As-Is, To-Be, Solution Design, Transition Planning, documentation, development, planning and execution
  • Core fundamental analysis of prior project work and analysis to provide independent perspective on developed solutions to date.
  • Facilitated full functional and technical configuration of Oracle General Ledger, Organization constructs) along with full documentation.
  • Developed core functional and business processes and configurations using GL Wand and Allocations functionality related to multi-staged and multiple mass allocations
  • Full implementation of Financial reports, and Allocations using the GL Wand Tool.
  • Developed core Month end Close documentation for Sub Ledger Modules and enhanced General Ledger Month End and Year End Close.
  • Created Full GL Business Process Design documentation and deliverables.
  • Lead on CPR (conference room pilot), SIT, and UAT testing including full testing scenario and script documentation and presentation materials.
  • Provided technical support to developed solutions for the entire life cycle of the project.
  • Created and validated COA and AFF Structures and designs.
  • Developed co-operating Accrual and Cash based ledgers and solutions to support the business
  • Direct support to Finance, FP&A, Budgeting, IT, Audit, and Executive teams
  • Developed Helpdesk procedures, approach, operations, and documentation including SOD and SOX
  • Business requirements, Gap Analysis, Solution Design, Risk Management, Testing, and other PMO/Project management documentation and standards
  • Development of full SOD (Separation of Duty), and SOX (Sarbanes Oxley) compliant security and protocols and solutions for system access
  • Documentation development and standards for IT and Business Processes including: Closing Processes, User Security, Financial Processes, Conversion, Migration, System Configuration, Change Management Control
  • Delivered a variety of documentation on standard processes for IT operations in support of the Application Suite.
  • Developed extensions, tweaks, and custom reports for business needs.
  • Issue resolution from both the front side, back side evaluation and with support of Oracle Support.
  • Excel4Apps / GL Wand Configuration, Installation, Training and Report development
  • Standard AIM documentation - MD50, CV70, BR100 and other relevant standard documents of the tool.
  • Development of Migration and Conversion Strategies and associated documentation.

Confidential

Applications& Tools Used: OnBase ReqConnect, OnBase Approvals Management, SQL Server

SQL Developer

Responsibilities:

  • Conducted, published and delivered initial project assessment, approach, and viability analysis report
  • Interviewed, assembled, and managed project team
  • Development of full Business Requirements and Solution Design
  • JAD Session work under a JAR approach
  • As-Is, To-Be, Solution Design, Transition Planning, documentation, development, planning and execution
  • Performed typical PM Functions including weekly T&E Management, Project reporting, Project plan management,
  • Developed and maintained full Project Plan with updates and periodic reporting
  • Developed full approach to project delivery
  • Researched, selected, provided full reporting on selected systems and tools to use for project (software)
  • Negotiated with Software Vendor for software and support
  • Performed and developed full project requirements, gap analysis, solution design, build approach and transition planning
  • Reviewed and developed approach to integration with existing and future systems anticipated.
  • Performed work in a full Secure Environment (subject to High Clearance Standards) tied and in congruence with Government (DOD) standards.

Confidential

Applications& Tools Used: Oracle Financials (GL, AGIS, AP, AR, PO, FA, EBTax) iSetup, System Administration, Diagnostics, HCM, FIN,Excel4Apps (GL Wand), User Management, Work Flow, OEM and AME.

SQL Developer

Responsibilities:

  • Development of IT oracle specific and business process mechanics for basic accounting processes
  • Direct support to Finance, FP&A, Budgeting, IT, Audit, and Executive teams
  • Developed Helpdesk procedures, approach, operations, and documentation including SOD and SOX
  • Business requirements, Gap Analysis, Solution Design, Risk Management, Testing, and other PMO/Project management documentation and standards
  • Development of full Business Requirements and Solution Design
  • JAD Session work under a JAR approach
  • As-Is, To-Be, Solution Design, Transition Planning, documentation, development, planning and execution
  • Systems Integrations analysis and configuration
  • Development of full SOD (Separation of Duty), and SOX (Sarbanes Oxley) compliant security and protocols and solutions for system access
  • Documentation development and standards for IT and Business Processes including: Closing Processes, User Security, Financial Processes, Conversion, Migration, System Configuration, Change Management Control
  • Establishment of helpdesk, systems, policies, processes, and procedures.
  • Establishment of change management process and procedures
  • Performed significant data cleanup in support of financial operations relative to Intercompany and Intra company accounting.
  • Performed significant Asset book and ledger realignment in support of corporate and tax reporting.
  • Upgrade Management of JRE & JDK
  • Implementation of OEM
  • Delivered a variety of documentation on standard processes for IT operations in support of the Application Suite.
  • Developed fundamental relational approach to support of operations by IT for operations and finance with the goal of becoming a “Service” organization rather than an approval organization to empower users of the tools and system.
  • Developed extensions, tweaks, and custom reports for business needs.
  • Issue resolution from both the front side, back side evaluation and with support of Oracle Support.
  • AME, Workflow configuration
  • Excel4Apps / GL Wand Configuration, Installation, Training and Report development
  • Standard AIM documentation - MD50, CV70, BR100 and other relevant standard documents of the tool.
  • Development of Migration and Conversion Strategies and associated documentation.
  • Module configuration of EBTax and associated components.
  • General Consulting and process improvement on Oracle Systems.

Confidential

Applications& Tools Used: Oracle Financials (GL, AGIS, AP, AR, PO, FA, EBTax) System Administration, Diagnostics, Excel4Apps (GL Wand), User Management, Work Flow, OEM and AME.

SQL Developer

Responsibilities:

  • Evaluation of Initial Solution design documentation relative to EBTax implementation.
  • Development of Solutions under existing solution approaches to business tax reporting needs as well as business transaction needs.
  • Participated in development of helpdesk operational support components not just for implantation but ongoing support. This included deployment of methodology and approach for extension of configuration and operational approach to taxes for AP and AR Operations and affiliated documentation to support it all and adjustments to all helpdesk support operations and personnel training.
  • Issue resolution from both the front side, back side evaluation and with support of Oracle Support.
  • Direct support to Finance, (payables, revenue, receivables), IT, and Tax teams
  • Development of Migration and Conversion Strategies and associated documentation.
  • GAP analysis and solution design.
  • Development of full Business Requirements and Solution Design
  • JAD Session work under a JAR approach
  • As-Is, To-Be, Solution Design, Transition Planning, documentation, development, planning and execution
  • Module configuration of EBTax and associated components including Vertax & Sabrix.
  • Development of adjusted business processes to handle current business needs in the revised R12 environment.
  • General Consulting and process improvement on Oracle Systems
  • Post go-live production support.
  • Documentation development and standards for IT and Business Processes including: Closing Processes, User Security, Financial Processes, Conversion, Migration, System Configuration, Change Management Control
  • Establishment of helpdesk, systems, policies, processes, and procedures.
  • Establishment of change management process and procedures
  • Performed significant data cleanup in support of financial operations relative to Intercompany and Intra company accounting.
  • Delivered a variety of documentation on standard processes for IT operations in support of the Application Suite.
  • Developed fundamental relational approach to support of operations by IT for operations and finance with the goal of becoming a “Service” organization rather than an approval organization to empower users of the tools and system.
  • Developed extensions, tweaks, and custom reports for business needs.
  • Issue resolution from both the front side, back side evaluation and with support of Oracle Support.
  • Standard AIM documentation - MD50, CV70, BR100 and other relevant standard documents of the tool.

Confidential

Applications& Tools Used: Sabrix, Vertax, Oracle Financials (GL, AGIS, AP, AR, PO, FA, EBTax), vertax, sabrix,System Administration, Diagnostics, Excel4Apps (GL Wand), User Management, Work Flow, OEM and AME.

SQL Developer

Responsibilities:

  • Evaluation of Initial Solution design documentation relative to EBTax implementation.
  • Support of Project Costing/Billing implementation
  • Development of Migration and Conversion Strategies and associated documentation.
  • Direct support to Finance, IT, and Tax teams
  • GAP analysis and solution design.
  • Development of full Business Requirements and Solution Design
  • JAD Session work under a JAR approach
  • As-Is, To-Be, Solution Design, Transition Planning, documentation, development, planning and execution
  • Module configuration of EBTax and associated components including installation and implementation of Vertex Solutions and rates
  • Development of adjusted business processes to handle current business needs in the revised R12 environment.
  • General Consulting and process improvement on Oracle Systems
  • Development of IT oracle specific and business process mechanics for basic accounting processes
  • Performed systems Integrations analysis and configuration
  • Documentation development and standards for IT and Business Processes including: Closing Processes, User Security, Financial Processes, Conversion, Migration, System Configuration, Change Management Control
  • Performed significant data cleanup in support of financial operations relative to Intercompany and Intra company accounting.
  • Delivered a variety of documentation on standard processes for IT operations in support of the Application Suite.
  • Developed extensions, tweaks, and custom reports for business needs.
  • Standard AIM documentation - MD50, CV70, BR100 and other relevant standard documents of the tool.
  • Development of Migration and Conversion Strategies and associated documentation.

Confidential

Applications& Tools Used: Oracle Rele ase 12

SQL Developer

Responsibilities:

  • Create detailed and high level deliverable providing full coverage and documentation of existing business processes, specific requirements, process requirements, existing gaps/issues, development of anticipates future direction.
  • Direct support to Finance, FP&A, Budgeting, IT, and Executive teams
  • Design, publishing, and creation of formal RFP (Request for Proposal
  • Development of Base materials to be used in the RFP
  • Development of full Business Requirements and Solution Design
  • JAD Session work under a JAR approach
  • As-Is, To-Be, Solution Design, Transition Planning, documentation, development, planning and execution
  • Creation of Evaluation Criteria of responses for RFP
  • Lead and execution of seminars by potential vendors of their product and solutions
  • General Consulting and process improvement on Oracle Systems

Confidential

Applications Tools Used: Oracle Rel 12 (AP, AR, GL, Payments, CE, FA, EBTax), Vertax/Sabrix, P2P, ADI, FSG, Multi-Org - MOAC, Structures, isetup, SubLedger Accounting,

SQL Developer

Responsibilities:

  • Upgrade of Applications from R11 to R12
  • Evaluation and modification of configurations in support of upgrade. Specific focus areas included eBTax, Accounts Receivable, Fixed Assets, General Ledger (including SLA, AGIS)
  • Support of COA and Accounting Flexfield Structure Changes
  • Direct support to Finance, IT, PMO, and Executive teams
  • Evaluation, Migration and testing of CEMLI objects.
  • Development of Business processes
  • Solution Design
  • Development of full Business Requirements and Solution Design
  • JAD Session work under a JAR approach
  • As-Is, To-Be, Solution Design, Transition Planning, documentation, development, planning and execution
  • Issue resolution
  • Planning, testing, transition planning, development activities.

Confidential

Applications Tools Used: Oracle Rel 12 (AP, AR, GL, P2P, eBTax Payments, iProcurement, iSupplier, Internet Expenses), Vertax and Sabrix ADI, FSG, Multi-Org - MOAC, Structures, isetup, SubLedger Accounting,

SQL Developer

Responsibilities:

  • SME support for PTP areas. Primary focus on payables, Oracle Internet Expenses, iSupplier, iProcurement
  • Support, management, testing, and development of custom RICE objects in the PTP area.
  • Focus upon linkage and configuration of eBTax in conjunction with Accounts Payable, Purchasing and Receivables.
  • Development of Business processes
  • Solution Design
  • Development of full Business Requirements and Solution Design
  • JAD Session work under a JAR approach
  • As-Is, To-Be, Solution Design, Transition Planning, documentation, development, planning and execution
  • Direct support to Finance, FP&A, Budgeting, IT, Audit, PMO, and Executive teams
  • Issue resolution
  • Planning, testing, transition planning, development activities.
  • Data Validation from custom migration programs.

We'd love your feedback!