SUMMARY

• Project/Technology Lead experience 7+ years of conducting and leading user s group discussions of problem analysis and implementing innovative solutions for business needs and objectives.
• SDLC/ Confidential 22+ years experience; analysis/defines/develops System Scope, gathering user requirements, conducting research, and fact - finding by preparing detail program specifications and diagrams to assist in problem analysis.
• Provided system designs and submitted recommendations of proposed solutions. Prepared an innovative prototype and code final product based on revised requirements. Prepared and completed documentation of the System Development Life Cycle. Conduct and prepare test cases for string, unit, regression, user, and system testing phases. Developed, planned implementation plans and performed continued maintenance and support of the system.
• 22+ years (20+ total SQL scripting) have written basic and complex PL/SQL functions, triggers, stored procedures, and packages in an Oracle Database Environment and ability to optimize SQL queries. Experience with UNIX Korn shell scripting. Utilized various database analysis tools; such as SQL Programmer, ISQL, and TOAD.
• Utilized Visio to create data models, ERDs, and flowcharts for program flows and relational databases.
• Training/Certification with ERWIN database analyst tool, ETL tools Ab Initio and Data Integrator and Report tool, such as Business Objects, and Microsoft Visual C# 2008, Oracle SQL, PL/SQL, ASP, advanced SQL at w3schools.com.

TECHNICAL SKILLS

Clubs: Current lifetime member of DPMA, APICS, and ABG (former vice president)OS MS/DOS Win 3/95/98/2000/NT/XP/Vista/7, 8, 8.1, 10, UNIX (SOLARIS/AIX), MVS

Languages: PL/SQL, COBOL, JCL, CICS, IMS, C/C++, and QBasic

Applications: Turbo C, Micro Focus Workbench, QuickBasic

Web: HTML, ASP 3.0, FrontPage 2000-2003, Microsoft Visual C#

GUI/IDE: Confidential 3-12.6 and 2017, Visual Basic 3-4/6, Delphi 2

Analyze: SQL/Plus, SQL Programmer 12.0/15.0, Erwin, SQL-Front, SQL Workbench, RazorSQL dBase’s: Sybase10-11/12.5, SQL Anywhere, dBase IV, EAServer, Access, Oracle 7.3-11G, ASE & ASA 12 & 15, SQLite, MySQL, AS/400

Version Ctrl: PVCS, Intersolv, Harvest/HarPB, Visual SourceSafe 6.0a, Native PB Source Control

Email: Groupwise, Outlook, AOL, Yahoo, and MSN

DB Misc: Ab Initio, Data Integrator, DataStage, Business Objects, Toad, SQL Programmer, Erwin

PROFESSIONAL EXPERIENCE

Power builder Consultant

Confidential

Responsibilities:

• Developed various SQL scripts to add new columns to the new COR2 project.
• Written SQL scripts for triggers and procedures on SQL Server database.
• Analyzed various database issues after adding columns to tables that are part of an automatic fill of audit tables.
• Add columns to various datawindow screens throughout the applications written in Confidential .
• Production support/Development of daily issues reported by BA testers and users.
• Implemented new functionality to the existing systems, such as; Profile Tracking Form Display, Manifest Rail multiple truck tracking, Waste Import of shipping received by what Transporter Company, Fingerprint Treatment/LandFill, Add Dragon Received/Ship as Rail/Threshold etc.
• Modified existing reports; Daily Load Composite Reports, Lab Worksheet Composite Reports, Flash Reports, TX Inbound Received Composites Reports Based on technically documents applied calculated formula for display waste received from lbs. to gallons to tons.
• Participated in peer code review of checked in code changes.
• Modified various windows; Profile Tracking, Profit Centers, Inbound Receipt, Fingerprint, Pricing, Report Center, Waste Statistics, Work Order, Retail Orders, Batching Processing, Audit, Shipment Approvals.

Environment: Confidential 11.5/12.5 and 2019, Windows 10 OS, Microsoft Office 2016, SQL Server 2008/2016, SQL Server Management Studio (SSMS), Pulse Secure VPN v9.0.4 (1701).

Power builder Consultant

Confidential, Chicago, IL

Responsibilities:

• Developed SQL scripts to decreased numerical fields that will accommodate higher currency values.
• Modified various datawindow objects editmask properties that will handle currency increase with limits.
• Enhanced Confidential code to manipulate and display large currency field amounts in various windows.
• Conducted Unit, Integration testing, and created User Testing documents.
• Edit Unix file formats to accommodate large fields for various tables.
• Lead all Testing phases and enhancements for implementation.
• On-Going Production Support of Confidential Client/Server Application the ‘Marketing Management System.’

Environment: Confidential 9.0.1 Build 6533, Windows 7 Professional OS, Microsoft Office 2013, Oracle 10g 10.2.0.2.0 (64bit), PL/SQL 10.2.2.0.2.0 , SQL Programmer 2006.17.0.5 , UNIX AIX, CRT 4.1, SVN, Notepad++ v7.5.3 (64bit), Cisco AnyConnect VPN v4.403034, Novel Client 2 SP3 for Windows 7, FileZilla 6.1 3.6.02 64 bit.

Production Support Engineer

Confidential

Responsibilities:

• Daily task of rebuilding setup Test versions of PENTA applications and install on test Machines for QA testing.
• Daily Production Support JIRA tickets such as data fixes, applications proper operations, to code bug fixes, to confirm what the application will do in each situation.
• Team corporative brainstorm of issues that has in high impact to all PENTA versions.
• Team Code Review participation.
• Enhanced code to retrieve based on Group Authorization of a given Construction Job, Organizational Unit, Site Work Orders.
• Fixed behavior of application forms and grid versions of the same window so that entering required fields work the same.
• Modified Oracle packages regarding PENTA interfaces of XML data exported into the application, where system options settings did not make it into the application as requested by the web app.
• Modified various ways a LONG type Oracle fields will be handled in Packages and Confidential code to prevent errors when saving or displaying data BLOB data.

Environment: Confidential 8.04 Build 10923, Oracle 12c, PL/SQL, HipChat v 4.30.3.1665 , Benthic Software (PL Edit 32 v5.7 Build 292, Golden6, Golden View), Remote Desktop Manager (v13.0.6.0), Linux, Tera Term v4.90, and Microsoft Visual SourceSafe 32bit (v8.0.50727.42).