| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLE Street Address PHONE NUMBER AVAILABLEBusiness Systems AnalystProven 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 managehigh-level technical issues without losing the ability to communicate with non-technical individuals in order to achieve desired results.Professional HighlightsManaged project to reformat and transfer poorly edited data from the Philadelphia Sheriffs Office MS Access-based legacy system to a new ERP system running SQL Server 2008 with a 98% accuracy rate, far exceeding the 80% requirementWorked 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 Groups Oracle-based collection of medical journals and medical images without interruptionCoordinated 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 windowWork HistoryCollabera (Assigned to Wells Fargo Bank, CIB, Temporary) Philadelphia, PAAssociate Analytics Assistant 4/2022 to PresentPerforming research to ensure customer tax compliance for the Corporate & Investment Banking divisionSpectraforce Technologies Inc. (Assigned to Guidewell Connect, Temporary) working remotely Raleigh, NCLicensed Health Insurance Agent 9/2021 to 12/2021Sold ACA plans and Dental plans for BCBS Arizona Insurance, during 2021 OEPThe Carney Group (Assigned to Company Voice, Temporary) working remotely Blue Bell, PATelephone Customer Service Representative 1/2021 to 9/2021Provided customer service for Bright Health Insurance, an ACA insurer, serving members in 10 statesThe Carney Group (Assigned to The Results Companies, Temporary) worked remotely Blue Bell, PALicensed Health Insurance Agent 8/2020 to 12/2020Sold Medicare Advantage and Prescription Drug Plans from Humana, to existing Humana members for AEPOptum Inc. (AARP/United Health Care Call Center) Horsham, PACustomer Service Representative and Licensed Health Insurance Agent 6/2017 to 7/2020Acted as licensed agent in 50 states to sell United HealthCare Medicare Supplement and RX plans,as well as AARP Delta Dental insurance plansPace Data Systems (Assigned to City of Philadelphias Department of Licenses and Inspections) Philadelphia, PABusiness Analyst and PL/SQL Developer 2/2014 to 4/2017Worked with SMEs from L & I to identify data in the legacy ERP system that needed to be migrated to thenew ERP system, developed mapping documents, data conversion specifications and schedulesWrote PL/SQL code procedures utilizing cursor loops and bulk processing in Oracle 11g, to convert data fromthe legacy ERP system (Hanson) to the new ERP system (Eclipse), in accordance with mapping documentsMFR Consulting (Assigned to City of Philadelphia Sheriffs Department) Philadelphia, PAProject Manager/Business Analyst/SQL Developer 5/2013 to 12/2013Managed team of 3, to migrate property sales data for the Philadelphia Sheriffs Department from anMS Access 2003 database to a MS SQL Server 2008 database, to be accessed by a new ERP systemBased on sampling of legacy data. created functions and stored procedures in T-SQL and developed processfor transforming and loading data. Participated in prime contractors Agile development processPeopleShare (Assigned to Corporate Call Center) Blue Bell, PALicensed Health Insurance Agent 8/2012 to 12/2012Sold Medicare Advantage, Supplement and Prescription Drug Plans from HCSC to callers in four statesBarbara Thomson Consulting Philadelphia, PABusiness Analyst 5/2011 to 10/2011Supplied technical knowledge to a transportation consulting firm, developing system integrationspecifications for a proposed fare collection system for the New York Metropolitan Transit AuthorityU.S. Census Bureau, Regional Census Center Philadelphia, PATeam Leader 5/2010 to 12/2010Hired and trained 24 field-based supervisory and line personnel to use case management softwareCoordinated a large-scale field data collection and quality control operation across three-state region,completed accurately, on time and in budgetDynamics Research Corporation (Assigned to Veterans Benefits Administration, PITC) Philadelphia, PAProduction/Development Support Database Administrator 9/2008 to 7/2009Managed Oracle 9i and 10g databases residing on local hosts running UNIX and Windows, includinginstallation of Oracle Critical Patch sets and completing the Oracle 9i to 10g migrationsUsed Quest Toad and Spotlight tools to evaluate database health and identify potential performanceproblems in Oracle databases running on Dell PowerEdge R900 and Sun E6500 serversCreated new database objects such as tables, indexes, triggers, functions, materialized views,packages and stored procedures in support of remote applications development teamsCurrent Medicine Group LLC Philadelphia, PAWeb Operations Manager/Oracle Developer 9/2006 to 6/2008Supervised 3 member IT staff in supporting content management, subscriptions andcustomer support for a division of Springer publishingManaged Oracle 8i databases, the IIS web server operations and addressed customer internet connectivityissues to guarantee database accessibility to a worldwide customer base of medical librariesWrote complex SQL queries against the subscriber databases, to generate ad-hoc reports used by the salesand marketing staff to identify lapsing subscribers and prospects for targeted marketing campaignsComputer Sciences Corporation Moorestown, NJProduction/Development Support Database Administrator 1/2003 to 1/2006Served as a production DBA providing 24x7 management of databases for the Logistics Modernizationprogram, a $900 million project to migrate U.S. Army logistics systems to an SAP R3 solutionDay-to-day duties included monitoring the databases, verifying completion of backup and interface jobs, theinstallation of Oracle patch sets and software upgrades, and managing customer accounts for over 400 usersPerformed mandated quarterly U.S. Department of Defense security audits, then developed and executedprojects for risk avoidance and remediationWrote SQL, PL/SQL, SQL*Loader programs and Unix Korn shell scripts to support multiple applicationdevelopment teams, execute data loads and refreshes, and build new database interface processesEarly CareerOracle Data Engineer (1/2001 12/2002) Computer Sciences Corporation Moorestown, NJOracle Database Developer (11/1999 1/2000) Computer Sciences Corporation Moorestown, NJProgrammer Analyst Project Leader (1/1995 11/999) City of Philadelphia Philadelphia, PAProgrammer Analyst I Programmer Analyst III (10/1986 12/1994) City of Philadelphia Philadelphia, PATechnical SkillsEducation and CertificationsLa Salle University M.B.A. (1994)Management Information SystemsDrexel University B.S. (1983)Humanities & Social SciencesComputer Learning Center Certificate (1986)Computer ProgrammingVillanova University Certificate (2014)Project Management ProfessionalDatabase Management Software: Oracle 11.2.0.3.0; Microsoft SQL Server 2005, 2008 R2; MySQL 5.0Database 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.2CRM Systems: SAP, Salesforce; Siebel, CanvasDevelopment Tools: PL/SQL Developer 10,05; Sun Java 1.5; Crystal Reports 2020; Microsoft Visual SourceSafe 6.0OS Software: Sun Solaris 5.10; Microsoft: Windows 2003, 2008 Server; Windows 7.0, Windows 10.0Server Hardware: Sun - E6500, SunFire 15K, V420, V480, V490; Dell - PowerEdge 4200, 6300, R900Backup 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.5Data Visualization Tools: Power BI Version: 2.126.927.0;Tableau 2021.2Web Technologies: Adobe ColdFusion 4.5 Web Application Server; HTML; CSS; XML; ASP 3.0Conferencing Software: Cisco Webex, MS Teams, Zoom |
