We provide IT Staff Augmentation Services!

Programmer Analyst Resume Profile

5.00/5 (Submit Your Rating)

CT

Profile

Summary

Expertise in Excel, Access and VBA Programming. Develop in Access to create programs, databases, ETL applications, data analytic tools, and reporting tools. Program Excel workbooks to graphically represent data, dashboards, charts, pivot tables , create Business Intelligence and Business Analysis tools. Seamlessly integrating MS Office applications to work cohesively together.

Key Skills

Proficient or familiar with the following technologies, concepts, and software:

Office Integration

Data Analysis,

Visual Studio C , VB

Web Development

Access, Excel, Word

Cleanse, Validate, Report

SQL Server, Oracle

ASP .Net, SharePoint

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.

We'd love your feedback!