Mar 2019 – Dec 2019 · 9 mos · West Point, PA

• Dozens of excel and access files were validated to meet FDA standard. Testing was done with Merck SOPs to confirm accuracy of the code and data flow. Light coding in VBA and SQL existed to correct programmer bugs.
• IT Skills: LIMS SQL, Labview, Access, Excel, Oracle

Apr 2018 – Dec 2018 · 8 mos · Mays Landing NJ

• Combination of ERP/Database analyst and software developer to support team of mechanical engineers at a fast growing manufacturing company.
• Excel VBA & formulas, SQL Server, Seradex, Visio, VB.net, Business Intelligence

Dec 2017 – Mar 2018 · 3 mos · Greater Chicago Area

• * Key skills are Ruby, Ruby on Rails, Java Script, React, Bootstrap, HTML, and SQL.

Mar 2017 – Dec 2017 · 9 mos · NYC

• The main task is refactoring code behind several applications. We were successful in trimming several seconds on the importing/exporting processes. This is important for the 100s of end users in India and Japan had past issue of data flows taking long time.
• Excel VBA code is being improved; OOP code, faster datatypes, updating web services from SOAP to REST/JSON, and building of stored procedures in Oracle using Toad. Agile scrum meetings are held daily.
• IT Skills: Ruby/Ruby on Rails, Java Script, Web Services, Oracle 11g, Excel 2016, SOAP/XML, REST/JSON

Nov 2016 – Feb 2017 · 3 mos · South Plainfield NJ

• * IT Skills: SAP NetWeaver: Business Warehouse, Business Intelligence, Business Objects, Hana.

Jun 2016 – Oct 2016 · 4 mos · Wilmington, DE

• Production support was given to two groups within JPMC’s credit card division. Tasks varied from SAS/Unix scripting, Oracle objects, building web services using REST/JSON, VSTO .net windows/web applications with MS Office.
• Agile SDLC was used; sprints every other week, scrum meetings daily, and heavy JIRA work.
• There was building of stored procedures which eliminated a minimum of 2 seconds off loading of data onto forms and webpages.
• IT Skills: Visual Studio.Net 2013, Unix, SAS, Oracle 11g, PLSQL, SOAP/REST/JSON, VBA, Jira Agile SDLC

Jul 2015 – May 2016 · 10 mos · Rahway, NJ

• Development serviced the eDiscovery management team of 50. The application interacted with sql server, ms outlook(VSTO), and very large image files. Windows/Web .Net applications were built to be used by 50 data analysts. The analysts can now work with more specific data, and quicker than before.
• A large VBA Access/Excel CRM Dynamics application was enhanced using oracle and Sql server data about incidents from the analysts. The general functionality and appearance was improved.
• IT Skills: Visual Studio.Net VSTO 2013, REST/JSON, C#, SQL 2005, Oracle 12c, Access & Excel 2013, VBA, Vault, SharePoint, Robocopy, FTK Image.

Jul 2014 – Jul 2015 · 1 yr · Easton PA

• Web development were used to automate redundant tasks by the full time data analysts. The accounts payable department received the excel files from vendors, and spent a long time reformatting, mapping, data scrubbing, and exporting to management.
• The automation saves dozens of manual hours of data input. Web pages collected data into database and excel spreadsheets. Excel VBA organized the data for internal use.
• IT Skills: Ruby/Ruby on Rails, Javascript, HTML, CSS, Excel

Mar 2014 – Jul 2014 · 4 mos · NYC

• College Board is a not for profit organization that helps high school students with continuing their education into college. The Access application organizes SAT tests into testing categories, students, strong and weak points.
• The centralized way of forms and reports saved the company hours when searching for key data of a student.
• Excel and PDF files used for fund accounting. Several dozen SAP Crystal Reports were repaired and tested.
• IT Skills: SAP BI Launchpad (Infoview), SAP BO XI Crystal Reports, Excel and Access 2007, VBA

Aug 2013 – Jan 2014 · 5 mos · NYC

• Responsibilities focused on building and fixing Excel formulas for several workbooks. These workbooks where used by financial managers in creating ratings of brokerage and financial firms.
• Several universes (queries, hierarchies, classes, objects) with BO Universe Designer were made and maintained. I built a couple dozen complex ad hoc Web Intelligence Reports (custom hierarchy, lov, prompts, and drilldowns) and also migrated several BI reports to Webi. There was weekly web development enhancements and bug hunting.
• IT Skills: HTML, SAP BO XI Web Intelligence & Business Intelligence, Excel 2010 Power Pivot

Feb 2013 – Jul 2013 · 5 mos · Ewing NJ

• ASG helps put together the patient of the unique disorder with a therapist having correct specific background, and the insurance providers. I worked on importing and exporting of Excel data, SQL queries, forms, tables, and VBA code.
• I prepared and executed the migrating the Access backend into Sql Server 2008 tables (data mapping, differing datatypes, primary keys, null values, ect). After testing, SSRS Reports were built for management.
• IT Skills: Microstrategy, SSRS Reports, Access VBA 2010

Jan 2012 – Feb 2013 · 1 yr 1 mo · Montvale NJ

• For this financial services/accounting firm, my role was part of a 14 man team building a new dashboard application servicing management in organizing a portfolio of client financial data.
• The front end was done using Excel to summon sql server data for display (grid controls, forms) and export (spreadsheets). Excel VBA (ADO, Web Services, and ActX) & Word VBA were needed for the data flow, and ensuring certain SharePoint files existed.
• IT Skills: VB.Net 2010, PLSQL Oracle 11g, Web Services, Excel VSTO/VBA, SharePoint, SOAP/XML, C#

Feb 2011 – Dec 2011 · 10 mos · Livingston NJ

• I worked in the Accounting department supporting numerous Access applications. Data focused on balance sheets, general ledgers, and ad hoc reporting. Strong focus was on finding, and explaining data issues.
• SAP Web Intelligence (lov, prompt, hierarchy, parameters); gave managers a better understanding of accounting reports of the various expenses. Some SAP universes with objects, hierarchies & classes were modified in BO’s Universe Designer.
• IT Skills: SAP BO XI Web Intelligence, Transact SQL, VBScript, VBA

May 2010 – Feb 2011 · 9 mos · Parsippany NJ

• My responsibilities were applications to four accounting departments of Deloitte; Process Standard, National Tax Technology, Tax Service Center, and International Tax Process (Outsourced).
• Weekly were generated statistical reports in SAP Crystal Reports (java scripting) on stock values of companies over user selected date ranges. These were used by several analysts over four global locations; US, India, and England. Average hours per week were 65.
• IT Skills: SAP BO XI Crystal Reports, Access/Excel/Outlook VBA

Oct 2009 – May 2010 · 7 mos · Pine Brooks

• Many small applications were built to automate or enhance functionality (Accountants, CFO, Sales, and Human Resources). Generated many small applications to report on key points/alerts within client data.
• Displaying information involved VBA for Microsoft Outlook, Excel and Access (6 files). Shared Sql Server responsibilities with another senior developer; building tables and views, heavy coding in T-Sql, basic administrative and analyzing data.
• Communication with recycling clients existed in multiple time zones, and several countries outside the United States.
• IT Skills: SQL Server 2005, SharePoint, VBA: Excel, Outlook, Access 2007, Html, JavaScript

Jul 2008 – Oct 2009 · 1 yr 3 mos · Morristown NJ

• Worked with systems support to ICS billing team in responding to customer inquiries and having Sarbanes-Oxley compliance.
• Gathered information regarding customers; attempted calls, type of call (long distance, local), length of call, originated number, destination number, rates, and time of call.
• Responsible for customer facing responses of Claims/Disputes Adjustment Tracking sub ledger inquiries. Created various billing reports with two accountants. This included automation and completion of the monthly results and metrics reporting, and mechanization of inward statement validation, utilizing VBA and light Oracle skills.
• IT Skills: Oracle 10g, Excel and Access VBA

Feb 2007 – Jun 2008 · 1 yr 4 mos · Glen Mills PA

• For this financial services & accounting firm an Excel financial tool used by over a hundred end users was enhanced, debugged, and later migrated to version 2007.
• Knowledge of the finance industry/terms was imperative in doing this assignment (annuities, derivatives, risk, portfolio management, compliance, and stakeholder). The application received data from the traders; requiring both reporting back to them, and to the operations department.
• VB.Net application helped both focus on the type of transactions, relevant companies, investment banks, times, and locations. ADO.Net extracted data from XML files and then imported data into Excel spreadsheets.
• IT Skills: SAP BO XI Crystal Reports, VB.Net 2005, C#, Bloomberg Excel Add-in

Jan 2006 – Jan 2007 · 1 yr · Titusville, Morris Plains NJ

• A large application was maintained and enhanced. This represented the communications between district managers (500), sales personal, and headquarters.
• It involved Access forms displaying marketing data from Oracle and MS Access databases (tables, views, procedures, queries).
• At the Morris Plains office I worked in a clinical trial environment on a dental application for organic chemists. It had an Oracle database and an Access frontend. The application was designed, developed, tested, and deployed to the users. This excel file helped users create clinical formulas based on end user inputting of data (compounds, amounts, ect).
• Excel VBA code was improved, and documentation was done for management.
• IT Skills: Access & Excel 03, VBA, Javascript, Oracle 9i, SQL

Nov 2004 – Jan 2006 · 1 yr 2 mos · Lansdale NJ

• Multiple applications were built using Oracle, Access, and Excel. The first serviced the Field Sales Training department by simplifying their current process of planning managerial time toward scheduling company events.
• Also, numerous Excel VBA files were built and enhanced for budgetary issues of managers in several departments.
• Business meetings focused on bringing value to a manager’s team, business clients, and the withdrawal of Vioxx, FDA regulations (21 CFR Part 11), GMC, and full project lifecycle challenges.
• IT Skills: Oracle 9i, Access & Excel 02, SQL Navigator, VBA, Clearcase, Clearquest, Documentum

Feb 2004 – Nov 2004 · 9 mos · NYC

• ALC builds list databases for large investment banks (Credit Agricola). I helped build an Oracle 9i database from 1000s of files, each about transactions.
• Most of the time was working with the front office; traders. The functionality for this financial application involved ASP web development.
• Spreadsheets display financial data; risk management, portfolio management, market analysis, derivatives, swaps, equities, etc.
• Every week enhancement to the appearance and functionality of ALC’s website (JavaScript and Html).
• IT Skills: Active Server Pages 3, Fireworks/Dreamweaver 4, Oracle 9i, JavaScript, CSS

Aug 2003 – Feb 2004 · 6 mos · NYC

• Pfizer’s IT Vendor & Contract Management was led on a project to enhance their current application using MS Access. Tables, their relationships, forms, and sophisticated queries were constructed.
• An application that determined employee compensation and commission was enhanced. Access VBA was used for coding and testing.
• Maintaining good coding standards and well linked tables was imperative. Later migrations involved Access 97 applications into version 2000.
• I conducted training, client proposal and written documentation.
• IT Skills: Access 97/00, Documentum, Clearcase, Clearquest, VBA, SQL, Oracle 8i, PLSQL

Apr 2002 – May 2003 · 1 yr 1 mo · NYC

• I assisted a multi-national team complete their data process for production. Working mostly with traders I used Java & Excel VBA applications; repair, build, and analyze data outputs.
• The applications involved user security, financial trading, and summaries (books) of the trading. This data was brought into a global database. Understanding financial term was important (annuities, derivatives, equities, swaps, clearance, market analysis, risk management, futures, etc).
• IT Skills: Java, J5EE, Javascript, Calypso, Sybase 15.x, Excel 2003/2010, VBA, SQL

Apr 2002 – Dec 2002 · 8 mos · Mountainside NJ

• I created a new client-server application catering to the doctors and staff of the Outpatient Department. Establishing effective security was imperative to meeting the FDA’s standard.
• The front-end on user desktops utilizes Visual Basic.Net to populate a series of forms and Crystal Reports from Sql Server.
• The second project was managing programmers of the IT Department in repairing a Managed-Care application. It imported patient data into tables.
• IT Skills: Sql Server 00, Visual Basic.Net, MS Project 98, Access/Excel 97, Invision, C#

Feb 2001 – Apr 2002 · 1 yr 2 mos · Murrey Hill NJ

• Support was given to BOC’s Food-Beverage division (a group venture called Thinkage LLC) servicing food processing plants.
• MS Access forms and reports would focus on key areas of the plant, with a central focus on improving efficiency. Hundreds of sensors were strategically placed providing live data for Intouch Software.
• SQL Server 2000 databases were built for each client replacing Access. Visual Basic 6 replaced MS Access.
• IT Skills: Mobile Wonderware, SQL Server 00, Visual basic 6, Access 97/00/02/VBA, XML, SAS

Apr 2000 – Feb 2001 · 10 mos · Matawan NJ

• Java and VB6 were done to build online applications for Spiderdance’s game show clients (MTV, Walt Disney, History Channel, 007 Series). The projects created the logistics for internet users to participate in online competitions.
• IT Skills: Java, J2EE, Visual basic 6, Excel 00, Crystal Reports 8, Javascript

Apr 1999 – Apr 2000 · 1 yr · Easton PA

• Numerous accounting applications were built for Bethlehem Steel and a subsidiary environmental firm called Res-Rec. The applications represented the purchasing, shipping, and accountability for engineering equipment.
• MS Excel (VBA) was used to produce spreadsheets for quick viewing of key data by management, later converted to version 2000 via Monarch Reports.
• The Access back-end, given the large amount of data, had to be migrated to Oracle 8.
• IT Skills: SQL, Access & Excel 97/00, VBA, Visual Basic 5

Apr 1998 – Apr 1999 · 1 yr · NYC

• Perform in-depth reserve analyses. Identify internal and external frequency and severity trends.
• Many financial applications were enhanced and built using Excel 97, with Oracle 8 on backend. Excel financial formulas acted as the business logic; sorting, grouping, charting, and pivot tables.
• IT Skills: Excel Formulas, Oracle, SAS, Visio