Information Technology Customer Service

PATRICK J. MOONEY

**********@*****.*** **** Roanoke Street Philadelphia, PA 19118 215-***-****

Business Systems Analyst

Proven information technology professional with 25+ years of experience developing, implementing and maintaining business information systems as well as 10+ years of experience in project management. My refined expertise in business analysis, database maintenance, application development data conversion, combined with my teambuilding and sales knowledge, allow me to manage

high-level technical issues without losing the ability to communicate with non-technical individuals in order to achieve desired results.

Professional Highlights

Managed project to reformat and transfer poorly edited data from the Philadelphia Sheriff’s Office MS Access-based legacy system to a new ERP system running SQL Server 2008 with a 98% accuracy rate, far exceeding the 80% requirement

Worked in conjunction with the National Health Service of the United Kingdom to test and implement a new subscriber login system for its members, enabling members at hundreds of locations to continue accessing Current Medicine Group’s Oracle-based collection of medical journals and medical images without interruption

Coordinated a crucial three-year project on a $900 million program to load several terabytes of data from five U.S. Army supply chain command centers into a large Oracle database warehouse, using Unix shell scripts, Oracle SQL Loader and PL/SQL, culminating in a 32-hour final load process into a new SAP system, well within the allowed 36-hour window

Work History

Collabera (Assigned to Wells Fargo Bank, CIB, Temporary) Philadelphia, PA

Associate Analytics Assistant 4/2022 to Present

Performing research to ensure customer tax compliance for the Corporate & Investment Banking division

Spectraforce Technologies Inc. (Assigned to Guidewell Connect, Temporary) – working remotely Raleigh, NC

Licensed Health Insurance Agent 9/2021 to 12/2021

Sold ACA plans and Dental plans for BCBS Arizona Insurance, during 2021 OEP

The Carney Group (Assigned to Company Voice, Temporary) – working remotely Blue Bell, PA

Telephone Customer Service Representative 1/2021 to 9/2021

Provided customer service for Bright Health Insurance, an ACA insurer, serving members in 10 states

The Carney Group (Assigned to The Results Companies, Temporary) – worked remotely Blue Bell, PA

Licensed Health Insurance Agent 8/2020 to 12/2020

Sold Medicare Advantage and Prescription Drug Plans from Humana, to existing Humana members for AEP

Optum Inc. (AARP/United Health Care Call Center) Horsham, PA

Customer Service Representative and Licensed Health Insurance Agent 6/2017 to 7/2020

Acted as licensed agent in 50 states to sell United HealthCare Medicare Supplement and RX plans,

as well as AARP Delta Dental insurance plans

Pace Data Systems (Assigned to City of Philadelphia’s Department of Licenses and Inspections) Philadelphia, PA

Business Analyst and PL/SQL Developer 2/2014 to 4/2017

Worked with SME’s from L & I to identify data in the legacy ERP system that needed to be migrated to the

new ERP system, developed mapping documents, data conversion specifications and schedules

Wrote PL/SQL code procedures utilizing cursor loops and bulk processing in Oracle 11g, to convert data from

the legacy ERP system (Hanson) to the new ERP system (Eclipse), in accordance with mapping documents

MFR Consulting (Assigned to City of Philadelphia Sheriff’s Department) Philadelphia, PA

Project Manager/Business Analyst/SQL Developer 5/2013 to 12/2013

Managed team of 3, to migrate property sales data for the Philadelphia Sheriff’s Department from an

MS Access 2003 database to a MS SQL Server 2008 database, to be accessed by a new ERP system

Based on sampling of legacy data. created functions and stored procedures in T-SQL and developed process

for transforming and loading data. Participated in prime contractor’s Agile development process

PeopleShare (Assigned to Corporate Call Center) Blue Bell, PA

Licensed Health Insurance Agent 8/2012 to 12/2012

Sold Medicare Advantage, Supplement and Prescription Drug Plans from HCSC to callers in four states

Barbara Thomson Consulting Philadelphia, PA

Business Analyst 5/2011 to 10/2011

Supplied technical knowledge to a transportation consulting firm, developing system integration

specifications for a proposed fare collection system for the New York Metropolitan Transit Authority

U.S. Census Bureau, Regional Census Center Philadelphia, PA

Team Leader 5/2010 to 12/2010

Hired and trained 24 field-based supervisory and line personnel to use case management software

Coordinated a large-scale field data collection and quality control operation across three-state region,

completed accurately, on time and in budget

Dynamics Research Corporation (Assigned to Veterans Benefits Administration, PITC) Philadelphia, PA

Production/Development Support Database Administrator 9/2008 to 7/2009

Managed Oracle 9i and 10g databases residing on local hosts running UNIX and Windows, including

installation of Oracle Critical Patch sets and completing the Oracle 9i to 10g migrations

Used Quest Toad and Spotlight tools to evaluate database health and identify potential performance

problems in Oracle databases running on Dell PowerEdge R900 and Sun E6500 servers

Created new database objects such as tables, indexes, triggers, functions, materialized views,

packages and stored procedures in support of remote applications development teams

Current Medicine Group LLC Philadelphia, PA

Web Operations Manager/Oracle Developer 9/2006 to 6/2008

Supervised 3 member IT staff in supporting content management, subscriptions and

customer support for a division of Springer publishing

Managed Oracle 8i databases, the IIS web server operations and addressed customer internet connectivity

issues to guarantee database accessibility to a worldwide customer base of medical libraries

Wrote complex SQL queries against the subscriber databases, to generate ad-hoc reports used by the sales

and marketing staff to identify lapsing subscribers and prospects for targeted marketing campaigns

Computer Sciences Corporation Moorestown, NJ

Production/Development Support Database Administrator 1/2003 to 1/2006

Served as a production DBA providing 24x7 management of databases for the Logistics Modernization

program, a $900 million project to migrate U.S. Army logistics systems to an SAP R3 solution

Day-to-day duties included monitoring the databases, verifying completion of backup and interface jobs, the

installation of Oracle patch sets and software upgrades, and managing customer accounts for over 400 users

Performed mandated quarterly U.S. Department of Defense security audits, then developed and executed

projects for risk avoidance and remediation

Wrote SQL, PL/SQL, SQL*Loader programs and Unix Korn shell scripts to support multiple application

development teams, execute data loads and refreshes, and build new database interface processes

Early Career

Oracle Data Engineer (1/2001 – 12/2002) Computer Sciences Corporation Moorestown, NJ

Oracle Database Developer (11/1999 – 1/2000) Computer Sciences Corporation Moorestown, NJ

Programmer Analyst Project Leader (1/1995 – 11/999) City of Philadelphia Philadelphia, PA

Programmer Analyst I – Programmer Analyst III (10/1986 – 12/1994) City of Philadelphia Philadelphia, PA

Technical Skills

Education and Certifications

La Salle University – M.B.A. (1994)

Management Information Systems

Drexel University – B.S. (1983)

Humanities & Social Sciences

Computer Learning Center – Certificate (1986)

Computer Programming

Villanova University – Certificate (2014)

Project Management Professional

Database Management Software: Oracle 11.2.0.3.0; Microsoft SQL Server 2005, 2008 R2; MySQL 5.0

Database Management Tools: Oracle Enterprise Manager 1.3.6; Platinum TSreorg 2.0; Quest Toad 9.6.1.1, Spotlight 4.0.4.678; SQL Navigator 4.1,

Office Automation Software: Microsoft Office 2021, Project 2019, Visio 2019; Adobe Acrobat DC,

CA Unicenter AutoSys 4.0.0.30, Erwin Data Modeler 3.5.2

CRM Systems: SAP, Salesforce; Siebel, Canvas

Development Tools: PL/SQL Developer 10,05; Sun Java 1.5; Crystal Reports 2020; Microsoft Visual SourceSafe 6.0

OS Software: Sun Solaris 5.10; Microsoft: Windows 2003, 2008 Server; Windows 7.0, Windows 10.0

Server Hardware: Sun - E6500, SunFire 15K, V420, V480, V490; Dell - PowerEdge 4200, 6300, R900

Backup Tools: Oracle RMAN, Sun Solstice Backup 5.5; Seagate Backup Exec Version 7.0; Symantec Veritas NetBackup 6.5 SAN Media Server; EMC VMware 5.5

Data Visualization Tools: Power BI Version: 2.126.927.0;

Tableau 2021.2

Web Technologies: Adobe ColdFusion 4.5 Web Application Server; HTML; CSS; XML; ASP 3.0

Conferencing Software: Cisco Webex, MS Teams, Zoom

Contact this candidate