Joseph Ely Email & Phone Number

Glenside, PA, US

Pending completion

Fort Washington, PA

Access, Excel, VBA, SQL Server, SSIS, VS2012, SSMS.

Initially a contractor at OCWEN before being brought on as an FTE.

JPMC-Wilmington DE

JP Morgan Chase - Agile Application Developer for:Business Quality Assurance and Test Account Management and Support (TAMS)Business Engineering-TechnologyConsumer and Community Banking

Philadelphia PA

• Analyze existing production data collection, analysis and reporting environment. Develop new applications converging functionality of existing tools.
• Converging previously created individual Access tools into a “main” interface so users can navigate to and through tasks much easier.
• Design/Develop/Implement multiple database tools to build, edit, and analyze data to support primary and secondary lines of business.
• Create GU interfaces for a couple of dozen users to maintain mission critical data.
• Create the requested analysis/reporting for frequent international/coast to coast presentations.
• Various newly developed automation tasks: Automated Powerpoint creation. Outlook automation.

Conversion of existing Access back-end database tables to SQL Server 2003 and associated conversion of front-end/client GUI interfaces to accommodate upscaling from MS Access to SQL Server for data storage.Access, VB, VBA, ADO, XML, EDI, OCR, image warehousing, Encode images to B64.Client-server. Automate following processes.Develop database.

Assist team with resolution discovery concerning User Issues relating to Server and Application Migrations Authentications and Access to Server Paths.Create and distribute Installation/Setup documentation for updates, plugins, and applications across various servers. Distribute executables or paths to executables for installations. Create netuse script to.

Analysis, scrubbing and conversion of Excel spreadsheets to delmited text files for import into SQL Server database. Two years of history for eleven acquisitions representing a multi-million dollar revenue stream on a monthly basis. Reporting for A/R, A/P, Purchasing, Inventory, Vendor Analysis, and more. Data imported from Excel files into MS Access.

Provided with two 1,000 page text documents both with continuous text strings containing information collected identifying all MS ACCESS databases/applications existing on all company network drives. This information collected by network engineers. Imported and deparsed those documents into an MS ACCESS database for upscaling/upgrading considerations..

Develop database application to support Fleet Program of 500+ vehicles for pharmaceutical company.Conversion of Excel spreadsheets to database tables. Automate interface import data with insurance carriers, leasing companies, claim/accident service companies. Safe driving program automation. New vehicle orders and allocation. Vehicle terminations. Vehicle.

Evaluate Paradox 9.0 application for stability and scalability. Conversion of Lung Transplant Database from Paradox 9.0 database application to client-server, MS Access version 2000. Distribution of user interface to various workstations to support multiple users. User authentication.Conduct training and evaluation classes.Develop needed reports for.

Project Tracking Database application to support tracking of budget approved projects for IT department to support Life-cycle technology. Very complex relationships, queries, updates. Client-server, Access, MS Project used to track development progress of custom Project Tracking application. Automate distribution of reports in Snapshot format.

Financial Analysis Application. Client-server, Access. Develop application to assist Controller with analysis of purchasing for University Hospital IT departmental budget. Analysis reporting in Excel.

State of New Jersey Department of Motor Vehicles. Client-server, Access and Oracle.Query and report from Oracle database residing; Database consists of New Jersey Department of Motor Vehicles Enhanced Vehicle Inspection program, over six millions records, two hundred tables, hundreds of statistical readings fields. Very complex relationships dealing with.

Tracking Application. Federal tracking and reporting requirements. Client-server, Access. Application developed to allow entry and tracking of distribution of Standard Operating Procedure manuals for all occurrences or movement of anything in Merck's manufacturing plant, entering and exit of buildings to the manufacturing and testing of new products...

Change Management Application. IT Production Turnover application. Web reports. Access applications to track the ongoing progress and management of IT projects. Reports in Access and static web pages which distributed automatically to company Intranet pages. Distribution of management reports via email automation in Excel and Access Snapshot formats.

Application for State Engineers collection of bridge and sign inspection data. State and Federal reporting. Access

Import collected data from asset assessment tools for State of Connecticut Y2K hardware and software analysis. Access and various network analysis tools.

Proof Department application to track data entry of nearly 800 operators. Mainframe data extraction Access front-end.

Financial Analysis application. Four hundred clients, $350 million monthly revenues. Derived from Excel spreadsheets and financial statements. Client-server, Access

included (but not limited to);Setting up automated financial solutions in electronic spreadsheets (VisiCalc, Lotus, Excel), utilizing the desktop automation tools available to derive information from various midsize to mainframe data sources. Developing user interface(s) to collect data. Developing data crunching and reporting tasks particular to that.

Operation of data processing equipment for Supply Company/2nd Battalion Honorable Discharge

Education record

Accounting

Education record

Education record

Visual Basic 6.0 Advanced Topics 1986 Morse Business School Marketing, Business Management and Accounting