SUMMARY

• Project/Technology Lead experience 6 years of conducting and leading user's group discussions of problem analysis and implementing innovative solutions for business needs and objectives.
• SDLC/PowerBuilder 18 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 submits recommendations of proposed solutions. Preparing 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 system.
• 11 years 18 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.
• Take initiative, responsibility for accuracy timeliness, and reliability of data.
• Motivated to learn and excel at new technologies as needed.
• Associated with Greater Phoenix Urban League

TECHNICAL SKILLS List below is a combination of professional experience, training, course studies, and self knowledge.

OS

MS/DOS, Win 3/95/98/2000/NT/XP, 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, Microsoft Visual C

GUI/IDE

PowerBuilder 3-12.5.1, Visual Basic 3-4/6, Delphi 2

Analyze

SQL/Plus, SQL Programmer 12.0/15.0, Erwin Data Modeling, SQL-Front 5.1.4.16 and SQL Workbench 5.2, RazorSQL 4.5.15 for Windows dBase's

Sybase10-11/12.5, SQL Anywhere, Watcom, dBase IV, EAServerAccess 2.0, Oracle 7.3-10G, ASE ASA 12 15, SQLite, MySQL, AS/400

Version Ctrl

PVCS, Intersolv, Harvest/HarPB, Visual SourceSafe 6.0a

Email

Groupwise, Outlook, AOL, Yahoo, and MSN

DB Misc.

Ab Initio, Data Integrator, DataStage, Business Objects

EXPERIENCE

PowerBuilder Contractor Confidential

• Analyzed, modified source code for Client's LTCG application and Microsoft SQL Server scripts.
• Print Queued RMI Process directory path changes to fit Northwestern Mutual Info structure. Modified non-visual object code to bypass large documents to print if Adobe PDFWriter printer device does not exist. Analyzed and adopted 3rd party tools ieStream Imaging software and Adobe Acrobat XI Pro to Underwriting module of LTCG application.
• LTCG Logon Window modified applications .ini file to fir Northwestern Info structure and Server/Database naming conventions. Edit PowerBuilder window object to dynamically insert database names into a new dropdownlistbox.
• Enrollment Processing Module create Outlook local profile. Add runas.exe /netonly /user command to LTCG application modules shortcuts Target option in properties. Written scripts for .bat and VB that automates creating shortcuts for LTCG application modules.
• End User Provision IDs replacement created script to update Univita IDs to Northwestern Mutual Network ID against varies tables, including adding new IT users for support purposes.
• Global P.O. Box Default Address changes - modified varies windows and stored procedure changes for Northwestern Mutual downtown address.
• International Address changes - modified varies windows and stored procedure changes for Northwestern Mutual downtown address. Create new scripts to update tables that contain international addresses to new values.

Environment: PowerBuilder 12.5 Build 2511, Microsoft Office 2013, Embarcadero Rapid SQL 8.5.0, TrackView, MS SQL Server DB 10.0, Sybase, Snapit 10, Adobe Acrobat IX Pro/ieStream Imagine for windows version 2.8 PB 3rd party tools .

PowerBuilder Contractor Confidential

PowerBuilder consultant analyzing, developing, designing, and maintaining Client's high profile critical windows based GUI applications. Interaction with internal customers while providing technical expertise to variety of users groups. Active participation in team development projects such efforts include expanding existing source or adding new functionality based on state laws that effect government regulated personal and vehicle loans that pertain to different states. Involved in Team testing and Peer Reviews of application design and development. Performed 24 hours production support.

Branch plus System

• Modified GL 5095 description and flag column in table prevents users from writing a check or cash transactions against it.
• Provide customer request of adding Total amounts to Dealer Statistics Summary report for all numeric and dollar amount fields.
• Remove redundant bankrupt columns Payment Tab page.
• Remove chart of account GL 5210 from users ability to use, but can be displayed in reports for historical purposes. Modified database table indicator to N, this allow for history display but will not allow user to place transaction payouts to this General Ledger Account.
• Modified Private Policy report zip code, was re-zoned by local post office.
• Add extra page to Life and A H Insurance Policy called American National Insurance Waiver. This change applied to print documents and Loan Process documents.
• Re-Design SQL logic currently system programmed to automatically print the IRS form 8300 if cash payments during a calendar year exceed 10000. Please create a ticket to change it from a calendar year to a rolling 12 months from the 1st cash payment. Example. If a customer pays a cash payment on 2/1/2014 and pays additional cash payments that exceed 10000 before 2/1/2015, the IRS form 8300 form should print automatically. Once the 10k cash maximum has been met and the form is printed, that 12 month rolling period stops. A new 12 month rolling period will start once the next cash payment is made.
• Relocated Insurance forms to another FORMS folder location in tree branch structure in application. Modifications included build script, three table updates, and source code changes to display and print from a different folder.
• Add repo reason field to Collateral Tab page in Customer Account system of Branch plus. Alter table for additional column called repo reason. Changed three reports displays field in Loan Journal, Repo on Hand, and Repo Sold Reports. Edit PowerBuilder source code based on customer request. Request included, when repo type has a drop down selection of Voluntary or Involuntary repossession, allow users to select one of the six new repo reason decode values. However, if repo type is blank, do not allow user to select a repo reason. Also if repo reason 'Other' has been choice allows user to edit own reason. Additional changes included adding decode values for these new repo reason, also making these new field required if selected.
• Prevent users from blank out customer first and last name on Customer Search criteria window in Branch Plus system. Modifications to nvo and user objects.
• Remove General Ledger 5094 and 5095 from user selection for making checks payments, but allow display in General Ledger reports for historical purposes.
• Relocated validation characters logic to non-visual object for accessibility.
• Add store denial reason of credit card payments using 3rd party DLLs'. Modifications to rules table, including to non-visual objects business rules.
• Added functionality to identify customers in North Carolina who are in military including their pay grade level.
• Add functionality to identify customers who are active in combat zone then block customer information from contact.
• Modified batch processing payments for Principle Payments from Central Banking system. This data feeds into Branch Plus application. Script stored procedure was changed for this purpose.
• Provide extra column to help identify US Citizens. Alter a database table, data window, including stored procedure.
• Additional General Ledger account was made accessible to users. GL 5210 Bank over Short account. Changed rules table and data window object.
• Provide print confirmation box to user. Reducing number of pages printed.
• Changed source code allows North Carolina Security Finance Companies to use monthly prorated method instead of weekly. Modified build and rules script.
• Extra Central Bank data into process indicator and process note, new fields added to Branch plus system. Changes include stored procedure alter table, and non-visual scripts.
• Modified cash drawer payments related to dealer reserve and dealer discount. Modifications include store procedures, non-visual objects, alter table scripts.
• Additional title Notes to Collateral Tab was included and display of this new field in Title Report.
• Marked customer accounts to as ceased and desist preventing collections calls. Designed and created new table, new records in decode tables, rules table was changed, new data windows, window, user objects, and non-visual object was created to allow user to select from a list of options of do not call.
• Modified system to accommodate for Ineligibilities, affect 3 stored procedures.
• Add new section to Insurance Remittance Report changes included one data window.

Optics System

• In Loan Progress report re-calculated average results by adjusting average Dealer Reserve and Discount amounts to not include zero, blanks or of specific loan types. This change effect Branch plus and Optics systems.
• In Optics parameter retrieval window, modified column Delinquency Status to accept single and multiple selection via drop down data window and popup window.
• Create new response window containing Application name, build version build number, compile date time, database name, and user id/name. Provide two command buttons one that closes this window and the other opens version changes that displays html document.
• Modified store procedure in parameters to retrieve and display reports based on are of business PFC, SFC, and Mexico.
• Re-design about Help window to open version changes document from a different location.
• Various cosmetic changes to OPTICS report system main window. Such as edit title to say OPTICS. Expand window to screen width and length.
• Add Dealer Discount Amount and total to PFS Dealer Reserve report, Dealer Reserve for text field changed to Dealer Hold Back for, and PFS Dealer Reserve Tree view option text has changed to PFS Dealer Hold Back.
• Change PFS MONTHS TO DATE report to include dealer discount, add totals and average calculations for dealer reserve and dealer discount.
• Include Dealer Discount and Dealer Reserve columns to report, database table, and stored procedure. Include adding fax value to column app source and corrected dealer reserve and discount average calculation.
• Add Dealer Discount totals to report next to Dealer Reserve.
• Add Dealer Reserve and Dealer Discount to PFS Weekly Progress Report.
• Add State Leader's and Auditor Names for different organization to Location Information screen that is similar to Home Office application also written in PowerBuilder.
• Analyze OPTICS system reports of cosmetic issues, system errors problems, and for consistency of look, behave, and ease of use. Report issues to management for review and possible later modifications.
• Edit Operations record Mexico report by removing unwanted fields and adding required fields for this report and associated data window object including stored procedure.
• Modified stored procedure by add new column to table, procedure and report data window for display regarding Vehicle Title Report.
• Modified PFS Loan Progress report data window, rules table, stored procedure for addition app source value for addition of FAX option display.
• Modified PFS Operation Record Report allowing retrieval by report type, including SQL in stored procedure. 339
• Correct cosmetic issues with Category PFS report fields overlapped others.
• Adjust report Collections Report data window and stored procedure, allow only most recent paid out accounts to display when a specific parameters is selected.

Environment: PowerBuilder 11.5.1 Build 4897/12.5.1 Build 4015, VM Workstation 9.0.2 Build-1031769, ASE 12.5, Sybase DEDIT Utility 15.0, Microsoft Visual SourceSafe version 8.0.50727.1551, SQL Anywhere Database version 10.0.13662