Programmer Analyst,resume profile

Objective

To obtain a position involving application programming and database development utilizing Microsoft Access ideally with a SQL Server back-end. Opportunities to further learn and work with Visual Basic C or Java would also be of interest.

Summary

Over 7 years as a programmer in the financial aerospace and law industries specializing in desktop application development database development and reporting. Played key role in the development and administration of a million-record database to store airplane part attribute measures. Contributed to development of mission-critical database to generate business plan forecast and its reconciliation with actuals. Highly analytical logical creative excellent critical thinker. B.S. in Psychology and A.S. in Computer and Information Systems.

Skills

Proficient in Microsoft Access MOS in Access 2013 Extensive Visual Basic for Applications VBA programming
Knowledge of SQL
Experience developing in SQL Server 2000 and 2005 tables views and DTS packages
Academic introductory study of Java Visual Basic .NET and C .

Experience

Confidential

Continuing education to update programming skills. Coursework including application development with Microsoft Access 2010 Java Visual Basic .NET and C . 3.9 GPA.

Programmer Analyst Confidential

Maintained and enhanced an Access 2003 front-end and SQL Server 2005 back-end database to keep track of case files for a law firm with over 200 users. Business areas included foreclosures bankruptcies evictions escrow closings and litigation.
Added fields for mail-merging into Word documents.
Developed user interfaces and reports.
Gathered requirements and resolved issues in a Rapid Application Development environment.
Extended code to migrate data and documents between differing case types.
Developed various e-mails automatically sent to agents upon completion of certain escrow milestones.

Data Analyst

Confidential

Supported store logistics change management for first assignment contract extended to support Operations Impact Assessment review. Migrated Excel spreadsheet into an Access 2003 database of normalized form. Created Views in SQL Server 2000 and created Excel pivot tables to link to the views.
Created Access 2003 database user interface and reports based on precursor Excel file and future requirements.
Programmatically parsed Excel data for migration into normalized data schema.
Created 13-week Gantt chart in MS Access report.
Allowed filtering of pivot tables from combo boxes populated through ADO code.
Dynamically assigned SQL to pivot cache based on user s selections and desired level of aggregation.

Programmer Analyst

Confidential

Provided maintenance support for Boeing s highly complex airplane options Configurator application.
Visual Basic 6 coding and testing for Change Requests and data conversions
Wrote ADO code for the synchronization of Client/Server data
Created and updated Macroscope P documentation 560s 490s 550s
Tested third-party applications such as Clearcase and VMware Workstation

Programmer

Confidential

Supported development of mission-critical database to generate Business Plan Forecast and its reconciliation with Actuals for Boeing s Supply Management and Procurement organization. Developed front-end in MS Access 2002 and back-end in SQL Server 2000.
Substantially increased performance of aggregation of 44 million records.
Implemented schema using nightly server data aggregation with option for user-on-demand local refresh.
Developed Views and DTS packages to load and display text file data.
Generated color-coded report in Excel from Access via OLE automation.
Consolidated and simplified reporting allowing one report to handle multiple grouping/filtering combinations.
Enabled variable field cross-tab queries as form recordsources via dynamic code-driven binding and formatting.
Developed XOR-based encryption algorithm to secure Boeing Limited data from outsourced programmers.

Programmer

Confidential

Played a key role in the development and administration of a million-record database to store airplane part attribute measures and documentation for parametric analysis. Developed front-end in MS Access 97 and 2000.
Wrote VBA ADO and DAO code designed user interface and maintained user-level security.
Provided technical support for a group of 75 users.
Increased efficiency and accuracy through automated matrix coding and data validation procedures.
Interacted with customers on a regular basis to define requirements.
Integrated and normalized 2 large precursor MS Access databases into one new database with SQL Server back-end.
Automated dynamic iterative SQL generation based on form input of indefinitely-chained attributes.
Developed reports and data extracts

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship