SUMMARY:

• Extensive experience in information technology, specializing in Software Development Life Cycle (SDLC), Agile, Object - Oriented Design (ODD) and Analysis (OOA) with extensive experience in the full life cycle of the software design process including requirements gathering and definition, prototyping, proof of concept, design, development, implementation, technical writing, writing testing and deployment scripts.
• Extensive knowledge of database design, logical and physical data modeling, data analysis, and data conversion/data migration. Optimization, normalization and tuning of databases, data abstraction, SQL Server SSIS. SSRS and SSMS, Oracle XML DB usage, Oracle BI modules knowledge: Oracle Service Fulfillment, Order Management Fulfillment functionality, Applications
• Financial Module and various modules from Supply Chain Management, data warehouse and data mining tool usage, debugging, monitoring and addressing database capacity issues, performance and access issues, and database development through a wide variety of tools.
• Advanced knowledge of Oracle products from Oracle 6 to Oracle 12c with emphasis on the database design, development, testing and production deployments building complex and efficient SQL queries, PL/SQL scripts, SQL tuning, triggers, stored procedures and packages and use of SQL Loader. SQLServer, familiarity with SSIS and various data warehouse tools and concepts. Oracle Discoverer Administrator and Developer for 7 years with emphasis on customer interface and development of custom folders, for our in-house clients.
• Experience installing WebLogic Server 12.2.1.2.0 dat included Java 8 JDK version 1.8.0 131 and the Fusion Middleware Infrastructure as well as Oracle Forms and Reports 12c for Linux and Windows 10.
• Advanced expertise in SDLC, Object-Oriented Analysis/Design, Agile, Waterfall and Oracle Development methodologies, skilled at progressing from problem statement to well-documented designs and various control and test documents and experience with CMMI, AS9100, and ISO9001.
• Excellent oral and written communication skills, extensive knowledge of Microsoft Suite including: Microsoft suite of tools: Access, Word, Excel, Outlook Express, PowerPoint and Visio. Reporting tools experience: Oracle Reports, Oracle Discoverer, SSRS, Hyperion and Crystal Reports; excellent organization skills and ability to perform detail-oriented work. Strong problem solving skills, adaptable, proactive and willing to take ownership of the project
• Demonstrated knowledge and understanding of various database administration functions dat included complex data modeling, data analysis, optimization and tuning of databases, data abstraction, debugging existing and new SQL, writing automation and data extraction scripts, familiarity with ETL (Extraction, Transformation and Load) processes for data migration.
• Demonstrated ability to keep management informed of status changes and progress and to produce high quality technical documentation. Actively coordinate with peers, management, and internal customers.
• Solid technical leadership skills with demonstrated proficiency in leading and mentoring junior analysts and developers, and to communicate clearly and appropriately to all levels of the management.
• Developed and maintain personal and professional E-Commerce websites via the local Unix hosting system. Utilizing development tools provided by the client and various E-Commerce development tools such as OsCommerce, PHP Admin tools, Visual Basic, CSS, some HTML, and SQL Server and MySQL database development and maintenance in a Linux environment with Apache as the web daemon.

TECHNICAL SKILLS:

Methodologies and Concepts: Agile, Waterfall, OOA/OOD, SDLC, CMMI, Unit and Module Level Testing

Databases: Oracle (6i, 7, 8, 9i, 10g, 11g, 11i, 12c), MS SQL Server 2008 R2, MySQL, dBase, DB2 and Sybase

Database tools: Oracle Designer, Oracle Discoverer (Administration and Design), Oracle Forms and Reports (6i, 7, 8, 9i, 10g, 11g, 12c), SQL Loader, TOAD for Oracle and SQL Server, Visual FoxPro, SQL Developer, SQL Navigator, Aqua Data Studio for Oracle, Erwin

Software: Configuration Control utilizing PVCS, Harvest, and Oracle CM control tool, R & R Studio, IBM Rational tools: ClearQuest. ClearCase, RTC, Team Foundation Server (TFS) and Visual Studio. Strong proficiency with Microsoft suite of tools: (Access, Word, Visio, Excel, Outlook Express, SharePoint and PowerPoint)

Language knowledge: Ada, Basic, C, C++, ProC, COBOL, FORTRAN, RPG, SQL, PL/SQL, MySQL, Transact-SQL, HTML, CSS, some Java and Unix/JCL/Perl shell scripting and command line interface.

Remote File Access: HTTP, SMTP, telnet, NFS, FTP, SFTP

SFTP/FTP tools: WinSCP, Putty, Filezilla

Platforms/Operating Systems: Microsoft Windows (95, 98, 2000, NT, XP, 7, 8), Unix, VMS, Linux, Red Hat, SUN OS, DEC VAX, NFS

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Developer

Responsibilities:

• Responsible for installing WebLogic Server 12.2.1.2.0 dat included Java 8 JDK version 1.8.0 131 and the Fusion Middleware Infrastructure as well as Oracle Forms and Reports 12c for Linux and Windows
• Lead Oracle Developer converting all Oracle objects from 6i to 12c dat include 500+ reports and 350+ forms, menus, pll’s and olb’s.

Confidential

Senior Oracle Developer

Responsibilities:

• Responsible for writing software to implement requirements for enhancements and bug fixes of in-house custom applications and commercial off the shelf software packages. Worked as part of a software team to handle integration, debugging, testing and troubleshooting of Westgate software releases based on trouble ticket resolution or change order management.
• Provided software development support by building, testing and deploying Oracle 11g SQL and PL/SQL queries, packages, procedures, functions, triggers, forms and reports. Modified and updated existing ProC code, VMS and JCL scripts and batch file processing, remote file processing through FTP, telnet and File Copy processing to and from remote NFS servers via WinSCP and Putty.

Confidential, Orlando, FL

Senior Oracle Developer

Responsibilities:

• Captured, compile, review, define, validate and document business processes, software requirements and database solutions and implementations. Work with client PLLs to analyze database changes and make suggestions to improve efficiencies, access time and possible tuning solutions.
• Providing software development support by building, testing and deploying Oracle 10g SQL and PL/SQL queries, packages, procedures, functions and triggers. Utilizing C programming, PERL scripts, Java, VMS and JCL scripts and batch file processing, SFTP and TC/IP file transfer protocol.

Confidential

Principle Business Analyst

Responsibilities:

• Created comprehensive documentation on technical processes in addition to the creation of business and functional requirements documents (BRD/FRD) for applications and reporting.
• Analyze and determine business problems/opportunities for multiple concurrent projects. Performed extensive Data Analysis utilizing Visual Studio for both Oracle and SQLServer backends,
• Author detailed business requirements documents, functional specifications, use cases, test cases, process flow, data flow, state, and UML models to communicate business needs to developers and non technical management.
• Prepare documents for business stakeholders showing the business idea under consideration are in conjunction with the company’s business strategies.
• Manage personnel, define project scope, determine personnel needs and cost, present project proposals to management committee, track the full lifecycle of the project, and manage external development teams located nationally and internationally and various cross functional business groups.

Confidential, Winter Park, FL

Business Systems Analyst

Responsibilities:

• Collaborated with various internal business units and external users, to investigate and analyze location and management requests for additions or changes to the system.
• Gathered, compiled, reviewed, defined, validated and documented business processes and software requirements. Assisted the software developers through the designing, coding, testing, and deployment phases by providing Oracle 10g SQL queries and step by step processing for the development effort.

Confidential, Orlando, FL

Senior Oracle Consultant

Responsibilities:

• On-site at client providing problem definition, develop, create and improve the database structure, debug and update existing forms, testing of enhanced PL/SQL and SQL code, create scripts for ETL and Hyperion developers, create functional technical specs, end-user documentation, server load balancing and implementation and post-implementation phases of two large software projects utilizing Oracle 11g based off of trouble ticket resolution and change order management.

Confidential, Alexandria, VA

Database Architect/Senior SQL Analyst

Responsibilities:

• Provided technical analysis, technical writing and authoring of ProPath/PMAS technical documents.
• Supported the VA VBMS-R application as the Oracle Database Administrator, Technical Lead for the Agile project team, responsible for the day to day operations on lower level database environments (Dev, Test, QA, UAT) and interfaced with the VA DBA’s on pre-production and production software and database releases. Provided extensive PL/SQL and SQL expertise to 50+ developers and testers.
• Previously responsible for VA BMS/BH project as the Oracle PL/SQL/SQL developer and information/database architect which also included SQL Server database support with Transact-SQL development, built Visual FoxPro applications and utilized experience and skills to write multiple technical documents and database architecture diagrams.

Confidential

Senior Systems Designer Staff/ Oracle Application & Database Developer

Responsibilities:

• Led the development of the Calibration Exchange Pool (CEP) program, an Oracle 9i developed web based forms, reports and Discoverer program for logistical tracking of submarine upgrades, at SWFLANT and SWFPAC
• Provided leadership in requirements gathering, system concept and design, deployment, and for all aspects of user and customer interface, tutoring and junior software engineers in various software development and verification activities, how to plan, analyze, design, test and document software and contribute to system integration.
• Responsible for exporting data, created new SQL queries and tuning existing queries, find/debug SQL or PL/SQL code issues, and perform various testing within the database
• Extensive knowledge of Oracle Discoverer (Administration and Design), Oracle Forms and Reports (6i, 7, 8, 9i, 10g), PL/SQL, SQL Loader, TOAD for Oracle, ClearQuest for requirement and error tracking, Agile Team Lead for the system development life cycle, Configuration Control utilizing Serena, data extraction/data migration with FTP processing to perform data cleansing and data validation from external DB2 and Sybase databases to the main Oracle database and knowledge of Oracle XML DB Repository usage.
• Lead developer in researching possible Oracle BI modules to replace existing PL/SQL and Oracle forms functionality. Reviewed the Server Fulfillment, Order Management’s fulfillment functionality, the Supply Chain Management’s Value Chain Management and Orchestration and Fulfillment modules with emphasis on the Order Management process, and the Applications Financial Module’s Fixed Assets.