| Confidential | | Access Developer Access, Excel, SQL Server, VBA, Word | | Debug and document an Access databases that run on a nightly basis. Improve and move processes from the Access databases to a SQL Server data warehouse. | | Confidential | | Access Developer Access, Excel, VBA, Word | | Sunland Trading is a honey importer. A one month project to upgrade and improve Access databases that handled inventory, shipping, and invoicing. | | Confidential | | VBA Developer/Data Analyst Access, Excel, PowerPoint, VBA, Word | | As part of changing to ServiceNow my role was developing applications for ETL, data migration and cleansing on User, Active Directory, CMDB, and ITIL information. Responsible for requirements documentation, data cleansing, transformation, and validation of data. The applications are developed Access, Excel, PowerPoint and Word utilizing macros, functions and classes. | | Confidential | | VBA Developer /Data Analyst Access , Excel, VBA, Word | | This SAP data migration project took data from one instance of SAP to another for several Latin American countries. Responsible for requirements, cleansing, transformation, and validation of data for Employee, Customer, Vendor, Credit, Material, Open Account Payables and Open Account Receivables. Develop applications in Access, Excel and Word utilizing macros, functions and classes. | | Confidential | | VBA Developer Access, Excel, VBA, Word | | Brought in to develop Access applications to track financial information, enabling users to create custom reports and Excel worksheets in Microsoft Office 2010 as part of this hi net worth facility upgrade. | | Confidential | | VBA Developer Access, Excel, Outlook, Sybase, VBA, Word | - Development through deployment of applications and databases tracking fixed income trades in Office 2010.
- Developed prototype applications to aid in reconciliation of Trades, Positions, and P L in Access.
- Developed ETL Access application to consolidate data from Sybase, text files, Excel and XML.
- Excel reporting applications utilized Charts, Pivot Tables, Dashboards, User forms, APIs and Classes.
- Wrote messaging applications to alert user of users of possible problems areas and status of trades and positions in Access and Outlook.
| | Confidential | | VBA Developer/Data Analyst Access, Excel, VBA, Word | - Coordinated, gathered and defined data requirements for global card benefits data with account managers.
- Designed / developed in Access report generation and data maintenance. Designed and developed a forecasting tool on card benefit revenues and expenses. Document and trained users on Access and Excel coding, process, and procedures.
| | Confidential | | Developer Access, Excel, VBA, Word | - Develop databases to manage employee, machine and application data for upgrade to Vista and Office 2007. Coordinate and verify requirements for user machines and applications. Responsible for testing and development of Excel workbooks, Access databases and their Add ins to verify compliance and operability in Office 2007 and Vista.
| | Confidential | | Data Analyst/Developer Access, Excel, VBA, Word | - SAP data migration project taking data from one region into another to create a single instance of SAP data. Responsible for requirements, cleansing, transformation, and validation of data for Inventory.
- Pricing, Open Sales Orders, Customer Master, Product Allocation, and Open Account Receivables utilizing Access, Excel and Word.
| | Confidential | | Data Analyst/Developer Access, Excel, Oracle, SQL Server, VB.Net, VBA, Word | - Set up tactical calculations and analysis tools for commercial lending, distressed assets, fixed/other assets, and open/failed trades as part of the Quantitative Impact Study team. The QIS team was in charge of monthly and quarterly reporting of impact assessment in changing from Basel I to Basel II banking regulations utilizing Access and Excel.
- Designed and implemented numerous programs to analyze and report various data for business as usual processes in Access and Visual Basic Net compared to Access, SQL Server and Oracle databases.
| | Confidential | | Programmer Access, Excel, Oracle, VB, VBA, Word | - Developed programs to operate and retrieve information from various instruments conducting test on hair and skin into an Oracle or Access database utilizing Visual Basic, VBA, Excel, and Word.
- The programs utilized the data to create Word documents or Excel Spreadsheets with charts, pivot tables, and a variety of images to illustrate the product claims. The scientists could also create test results in Excel and load them into Access or Oracle to further analyze and document their results. Designed and programmed methods and classes in Word and Excel to pull information from Excel, Access or Oracle to demonstrate results.
| Confidential | | Programmer/Analyst Access, ASP, Crystal Reports, Excel, SQL Server, VB, Word, Java | | Developed programs to operate and retrieve information from various instruments conducting test on hair Programmed, maintained and supported applications for the back office of a hedge fund utilizing Visual Basic, Java, and Active Server Pages against SQL server databases. Wrote ASP applications to track trader information, user services, industry information, and initial public offerings. Wrote specifications, user manuals and installation instructions in HTML and DHTML. | | | Confidential | | Programmer Access, Excel, Oracle, VB, VBA, Word | - Programmed, maintained, and supported a call center and inventory management system in Visual Basic utilizing Excel, Word and Access with a SQL Server database that allowed users to enter, bill and ship from several warehouses. Developed an inventory tracking and prediction application so manager could successfully chart sales, inventory, stock, and volume.
- Programmed, maintained and supported applications for the back office of a hedge fund utilizing Visual Basic, Java, and Active Server Pages against SQL server databases. Wrote ASP applications to track trader information, user services, industry information, and initial public offerings. Wrote specifications, user manuals and installation instructions in HTML and DHTML.
| | | |