Jay Fogarty

Schwenksville, PA 484-***-**** ad3wqb@r.postjobfree.com Linkedin.com/in/jay-fogarty-1b4a947

Software Engineer and Developer Strategic Technology Leader

Leading IT project and solutions to optimize performance, drive efficiency, and support the end user.

Dedicated IT Professional innovating and implementing forward-thinking solutions to improve operational performance, enhance the user experience, and support organizational goals in dynamic environments. Adaptable Self-starter analyzing existing tools and spearheading changes to optimize outcomes. Innovative Technology Developer with exceptional communication skills adept at designing, building, enhancing, and maintaining applications to advance overall functionality, solve problems, and simply make things work better.

Information Technology Leadership

Software and Application Development

Database Builds and Management

Strategic Problem Solving

Cross-functional Collaboration

Code Writing, Testing, and Implementing

Data Architecture and Maintenance

Performance Issue Reconciliations

Customer Support and Success

SQL, PL/SQL, Oracle, .Net, Jira, and C# Expertise

SSIS, SSRS, SSAS

Sept 2020 to Sept 2022: Level One Malvern, PA

Level One brings deep domain experience in e-billing and payments, print and mail management, customer preference management, and data analytics and reporting to Utilities to minimize risk, expedite implementation, and deliver on the promise of better customer engagement.

Application Developer

Using Sefas Print Designer software, designed and implemented utility billings and tax documents. Sefas Print Designer is a software tool that generates bulk pdf from a data file. Party of a task group to migrate to the newest version called Harmony,

Feb 2017 to Oct 2019: Change Healthcare, King of Prussia, PA

Publicly-traded provider of revenue, payment cycle management, and clinical information exchange solutions to connect payors, providers, and patients in the U.S. healthcare system.

Software Engineer

Provide critical technology support, including app development, bug fixing, data loading, and documentation management. Communicate effectively with management to discover issues and goals, and then deliver solutions to optimize daily business performance.

Lead the conversion of Pervasive Jobs (an ETL tool) into .Net and PL/SQL jobs

Enhance ClaimsXten and ClaimsCast solutions written in various forms, including .Net, and PL/SQL by modifying code for new software features and fixing bugs

Integrate new data from Medicaid and Medicare into the Oracle database

Test other Developers’ code and recommend improvements accordingly

Track bug fixes and enhancement requests using Jira

Demonstrate expertise with SQL, PL/SQL, .Net, Jira, and C#

Jan 2012 to Jan 2017: Software Methods, West Chester, PA

Privately-owned IT staffing company.

Database Consultant

Consulted with Teva Pharmaceuticals, innovating and implementing strategic IT solutions to ensure alignment toward organizational goals. Designed, implemented, and supported business intelligence, enterprise data warehouse, and other business application systems. Advanced expertise in data analysis, data modeling, third-party provider data integrations, ETL process development, reporting, quality assurance, maintenance, and more to drive operational excellence and support a multitude of end users.

Overhauled the Do Not Call (DNC) system, rewriting code and ensuring accuracy to avoid incorrect calls

Streamlined data from five HR systems after Teva acquisitions to consolidate sales reporting information

Completed extraction transition load work (ETL) to support other documents for ad-hoc report requests

Loaded IMS data into the Oracle database and generated reports as needed

Developed proficiencies with SQL, PL/SQL, Shell Scripting, Syncsort DMExpress, Vertica, and Oracle

Nov 2003 to Nov 2011: SunGard Availability Services, King of Prussia, PA

Privately-held firm providing business continuity services, including IT production and recovery.

Developer Database Administrator (DBA)

Designed and maintained the proprietary CMS database operating as the data leader for all requests, updates, and issues. Enforced the database standards, oversaw metadata, created and modified database objects, and worked tenaciously to swiftly resolve problems. Handled performance tuning and initiated key changes to optimize the user experience.

Wrote scripts in PL/SQL and T-SQL, and stored procedures for Oracle and SQL Server

Coded new product features and fixed defects using C#

Installed Oracle RDBMS 11g, 10g, and 9i

Wrote and corrected Crystal Reports

Collaborated with various teams, including Consulting, Hosting, Sales, and Software to resolve customer issues and answer questions regarding product installations

Advanced proficiencies with SQL, PL/SQL, T-SQL, Oracle, and C#

Used SSIS to migrant an Oracle database to SQL Server.

Used SSRS to read data from multiple SQL Server databases.

March 2002 to Nov 2003: Lew Wolfe Pool Renovations, Conshohocken, PA

Renovation and pool servicing company that opened and closed pools for the season.

Labor Worker

Took one year off from the IT industry to assist family member in running family business. Realized true passion for information technology, development, and database administration.

Sept 2000 to Dec 2001: Cyber, Inc., Fort Washington, PA

Service provider to pharmaceutical company offering video conferencing support.

Oracle Database Administrator (DBA)

Maintained existing database, oversaw upgrades, and created customized solutions to support various users. Managed backups, tablespaces, and user accounts. Performed ad-hoc projects as needed.

Maintained existing Oracle 9I database on a Unix Solaris server

Collaborated with cross-functional teams to manage the Siebel CRM

Gained in-depth knowledge on Oracle and Siebel

June 1998 to Sept 2000: IQVIA (fka IMS Health), Plymouth Meeting, PA

Company that collected health care information and sold it to other firms to assist with development of commercialization plans, portfolio plans, patient targeting, and marketing strategies.

IT Consultant Oracle Specialist

Worked strategically to maintain existing systems, develop tools to advance functionality, create new systems, and optimize stored procedures for an Oracle database.

Utilized awk and Perl with UNIX shell script wrapper to generate extract

Wrote PL/SQL scripts to support technology changes

Leveraged SQL*Loader to import data from outside feeds, including Dendrite, NDC, and Pfizer

La Salle University – Bachelor of Science, Computer Science

SQL • PL/SQL • C# • .Net • Jira • Shell Scripting • Syncsort DMExpress

Vertica • Oracle • Siebel • awk • Perl

“Jay would offer solutions to quickly address the needs of our customers and propose new ideas to evolve the efficiency of the platform as well as strengthen its performance. He was very approachable and carried a positive attitude.”

Core Competencies

Professional Experience

Education

Technical Tools

Contact this candidate