SUMMARY:

Operated as a Senior Application/SQL Developer/Analyst with over 20 years of application and database development involving expert root - cause analyses, problem-bug resolution, emphasizing report writing using stored procedures and ad-hoc queries, along with database/query performance tuning, data maintenance and production support. My background includes full life-cycle design & development (Waterfall/ AGILE/SCRUM ) of financial, accounting, asset management enterprise-wide business critical apps for market leaders using PowerBuilder & SQL.

TECHNICAL EXPERIENCE:

• Transact - SQL(T-SQL) , MS SQL Server 4.x-2012,2016, SSMS 2017 , Sybase 10.x/11.x/ASA , Sybase ASE 12.0/12.5/12.53 , SQL Anywhere, SSIS, Visual Studio SSDT, Crystal Reports, DB2, Oracle 7.x/8i/9i/10G/11g(PL/SQL) , Informix, OBIEE Publisher
• PowerBuilder 3.0 - 12.5 (15yrs) using/ PFC/ObjectStart/ACL as base architecture-framework.
• Familiar with other languages and technologies including but not limited to the following: web technologies, Citrix, ClearCase/ClearQuest, PVCS SourceSafe, Salesforce , JIRA, Remedy, SSIS , CRM, ERP, EAM, OLE, DDE, SDK, API, IIS, Windows XP, 7, 10, WIX-Cloud based platform

PROFESSIONAL EXPERIENCE:

PowerBuilder/SQL Developer

Confidential

Responsibilities:

• Responsibilities include but not limited to complete system design and new development of prototype client/server application filing and records reporting system for nationwide reformation of government applicant filings, not limited to state and federal entities.
• System coded using PowerBuilder 10, MS SQL Server 2012, creating tables, stored procedures for analytical processes for business rules, looking to eventual upgrade to PB 2017.
• Duties also include compiling functional design specifications, data integration DTS, system upgrades, enhancements and maintenance.

T-SQL Developer

Confidential

Responsibilities:

• As T-SQL developer for private web hosting company on high volume transaction application (OLTP) written in ColdFusion as primary frontend development tool utilizing stored procedures to create reports and SQL queries within web-based infrastructure for market leading website/application utilizing web-based/stack technologies.
• Duties include ad-hoc query scripting and bug-resolution of complex SQL queries, containing merge , cross/outer apply , joins, cursors, CTE s, table variables, with hundreds of database containing thousands of base tables in excess of 3 million records, with a several over 20M .
• Recent duties and responsibilities include SQL report writing, performance tuning using Database Tuning Advisor, Query Analyzer, and use of DMVs to determine efficient use of indexes, including missing and underutilized index candidates for immediate performance tuning and maintenance as well as targeting high CPU consumption SQL queries and stored procedures as additional candidates for performance tuning.
• Also performed data analysis of blocks, locking by reviewing/analyzing sp who3 results; Query Stores.
• Previous employment responsibilities include maintenance support and development for Confidential on their Professional PetSitter application using ColdFusion 2016 , and MS SQL Server 2016 with duties including system enhancements and bug fixes.
• Also had to maintain multiple versions of client databases and assisted with database upgrade from MS SQL Server, including Management Studio 2017.
• Design, develop and maintain a variety of websites and online portals for clients involved in online sales, Ed-tech and professional services using cloud-based web technologies. Technologies include various web frameworks, LMS, HTML, WIX and WIX Code.

PowerBuilder Developer/SQL

Confidential, St Louis

Responsibilities:

• Responsibilities include maintenance support and development for PowerPlant EAM system. Responsible for resolving maintenance task and code development as part of application enhancement/modification, and bug resolution, using PowerBuilder versions 11.2 and Oracle versions 9i/10g/11g .
• Business areas include but not limited to, Ad-hoc reporting/SQL queries using PL/SQL, Work Orders/Projects, CR, CWIP Charge, Retirement Unit and Property Unit Catalogs, Admin batch interface jobs/tasks.
• Recently began development of GL and Accounting reports using Oracle Business Intelligence - Publisher.

PowerBuilder/SQL Developer

Confidential, Atlanta

Responsibilities:

• Responsibilities include development for PowerPlant EAM system.
• Responsible for resolving maintenance task and code development as part of application enhancement/modification, and bug resolution, using PowerBuilder versions 11.2 and Oracle versions 9i/10g/11g .
• Business areas include but not limited to, Depreciation Studies, Budgeting, ARO, CR, Projects, and most recently part of the development team responsible for the newest Rates & Regulatory module.
• Also worked on the Maximo Adapter , creating stored procedures and triggers as part of the third-party software integration team.
• Updated data model using TOAD .

PowerBuilder/SQL Developer

Confidential

Responsibilities:

• Responsibilities include comprehensive production support of EAM system, EMPAC for all licensed client base worldwide; responsible for resolving all issues, to include application enhancement/modification, bug resolution, handling client phone calls, etc.
• Responsibilities also include, though not limited to client and server-side development for business-critical enterprise asset management system, using PowerBuilder, upgrading from earlier to most current versions 7, 9, 10.5, 11.5, 12.0, 12.5 , and Oracle versions 9i/10g/11g .
• Duties also include software and hardware recommendations, maintenance, and technical support.

Production Support/SQL Specialist

Confidential, Atlanta

Responsibilities:

• Responsibilities include 24/7 comprehensive production support of day-to-day operations for SOX regulated corporate-wide business critical PowerPlant Financial Asset & Property Management system version 10.
• System is designed in PowerBuilder v11.5 and running Oracle 10G as back-end and is integrated with Oracle Financials, including running SQL scripts to modify, import and clean up data and modify data objects.
• Also responsible for running ETL scripts during software upgrade to transfer data to updated system.
• Business areas include but not limited to general ledger, allocations, journal entries, book and tax CWIP accounting, month-end closing, charge repository, & work order processing.
• Remedy BugTracking Software, TOAD

Senior PowerBuilder Programmer/Analyst/VB.NET/SQL

Confidential

Responsibilities:

• Redesign, develop, and migrate/convert current metal Re-Bundling application from a VB.NET framework to a PowerBuilder 10.5.2 application utilizing Oracle- PL/SQL as backend to include business areas of inventory management and historical genealogy tracking of parent-child records and relationships.

Senior PowerBuilder-SQL Programmer/Analyst

Confidential

Responsibilities:

• coding and testing of both client and server-side modifications and enhancements to the Drug Product Loader import process for a suite of medical and clinical software applications, WORx, a drug therapy management system. PowerBuilder 11.1, Informix

Senior PowerBuilder-SQL Programmer/Analyst

Confidential

Responsibilities:

• Migration/enhancement of corporate wide Confidential application, a retail promotional tracking software.
• Drafted migration analysis, coordinated efforts with PM, DBA, and Business manager to deliver stand-alone client application, eliminating the necessity to log onto the application via Citrix Metaframe network server.
• Also responsible for managing, developing, coding, testing and implementation of all system enhancements and modifications, which included database changes necessary to migrate batch processes from multiple databases over to a single database server.
• Using PowerBuilder 6.5 - 10.5 ( OraclePL/SQL )

Senior PowerBuilder & SQL Programmer/Analyst

Confidential

Responsibilities:

• Member of new products development team, responsible for new development of both enhancements and modifications on Retail Annuity system.
• Worked with user community to gather system requirements, resolving system errors and bug fixes, defining functional specifications, unit testing, system maintenance and training for corporate wide Insurance Claims and Death Benefits financial and accounting systems, which also included any modifications to database objects (stored procs/triggers), client-side modification/creation of user objects, functions, PFC extensions.