We provide IT Staff Augmentation Services!

Msaccess Vba Automation Developer Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • 20 plus years doing requirements gathering, planning, architecting, development, testing and delivery.
  • Programmer/Analyst with experience in corporate applications design, development and deployment across multiple platforms using a variety of technologies and lifecycle maintenance of legacy applications.
  • Responsible for needs discovery, meeting with customers for requirements gathering, technical documentation, development, testing and final product delivery.
  • Experience in •SQL Server DB creation, and normalization, scripting tables, views, stored procedures, triggers and functions.
  • Good organizational skills. Impeccable and dependable communications with clients and others
  • I take responsibility for initial meeting with customers to listen carefully and discuss their needs.
  • I examine the system they work with and procedures they follow to help get a 50,000 ft view of their processes and needs.
  • I consider the future needs of the group and how the application being discussed flows from and into other existing apps and processes.
  • I attempt to meet semi - regularly with customers and get to know their other activities and applications. There is always the possibility that the new applications can pull from or flow into the next.
  • I propose initial examples and mockups to customers to insure we understand each other and we are on the right track in order to catch issues early on.
  • I maintain and exemplary relationship with customers and have been known to win over hesitant groups or those who are used to getting what they did not ask for in previous experiences.
  • I work hard to make the requirements document easy to understand so that newcomers can look at what I’ve documented and get a good understanding of the system and how the new application fills their needs.
  • Agile Development and Waterfall. Technical documentation.
  • Direct interaction with Customers for new and existing project needs discovery.
  • Consistent meetings with customer throughout project lifecycle to establish timelines, hurdles and impacts.

TECHNICAL SKILLS:

  • MS Access
  • MS Visual Basic 6.0
  • MSOffice Automation
  • VBA
  • Classic ASP
  • XML, XSLT
  • PowerBuilder 6.5 and 12.0
  • SQL Server 7 - 2008 R2
  • JCL
  • DOS batch
  • HTML
  • DHTML
  • VBScript
  • JavaScript
  • Win32 API
  • SOAP
  • VML
  • SVG
  • WSH
  • XML DOM Automation
  • AJAX
  • Crystal Reports
  • Web Architecture Solutions
  • MSOffice
  • FTP
  • Audio software
  • Photo and graphics creation and retouch
  • 3D graphics creation
  • Attachmate Extra
  • Exceed
  • ClearCase
  • PVCS
  • Node.js, JavaScript Frameworks, HTML5, CSS3, Mobile development, Microsoft SharePoint and MOSS

STRENGTHS:

  • Development and management of project plans
  • Solid mathematical background
  • Medicare business
  • Conceptual Thinking
  • Development, maintenance and integration of software, testing and implementation
  • Take pride in quality work bject oriented programming
  • Methodical
  • Work closely with client s vendors and cross - functional team members
  • Responsible to work deadlines
  • Development of business requirements
  • Analytical nature strive to improve both the business operations and the work processes
  • Experience with data manipulation self-motivated flow charting/process mapping, documentation
  • Knowledge of Health Care
  • Proficiency with mainframe system

EMPLOYMENT HISTORY:

MSAccess VBA Automation Developer

Confidential

Responsibilities:

  • New Requirements gathering, Design, Code, Test and deliver Databases using Access2013. Strong VBA.
  • Application requirements summary: two Applications for Process Change Tracker and New Employee screening and requirement check of App with departmental Queues.
  • I architected and developed new MS Access Applications to handle the internal needs of departments as. Development in Access and VBA in an object oriented fashion using classes.
  • I held meetings to discuss the customer’s needs in a hybrid Agile fashion.
  • I Created requirements documentation and technical description of the agreed upon solution.

Reporting Analyst/Developer

Confidential

Responsibilities:

  • Support of the Companies 40+ MSAccess2003 Databases using Access2010 - Maintenance and problem resolution. Strong VBA.
  • Strong ETL, DTS, SSIS type activity, pulling data from SQL Server, Oracle, and DB2, Automated the transforming through VBA and written to fixed file formats as well as Excel. Used Pass through queries and ADO coding.
  • I architected and developed new MS Access Applications to handle the internal needs of departments as well as complex file conversions necessary for external clients (banks) and new Business needs. Majority of development in VBA in an object oriented fashion using classes. File conversions required query of Oracle DBs and creation of strictly mapped result files for those Banks and also for our VAX system.
  • Created a number of issue tracking applications to handle tracking of complaints and issues for the Office of the President.
  • I Set up and held meetings to discuss the customer’s needs.
  • I Created requirements documentation and technical description of the agreed upon solution
  • Introductory to SalesForce development and light application creation.

Technical Lead

Confidential, Nashville

Responsibilities:

  • Application and Web Development using ASP, XML, XSL, VB6.0, COM, VBA, VBScript, JavaScript, HTML, CSS, MS Access, Clear Case etc.
  • SQL Server DB creation, and normalization, scripting tables, views, stored procedures, triggers and functions.
  • Design and Creation of Company Intranet Portal Utilizing Classic ASP, ASPX and PHP
  • Maintenance of the TennCare Internet and Intranet Websites.
  • Responsible for needs discovery, meeting with customers for requirements gathering, technical documentation, development, testing and final product delivery.
  • Helped out PowerBuilder Developers with projects by taking on some of their development workload. Entailed meeting with customers for requirements gathering, technical documentation, development, testing and final product delivery.
  • Exposure to Web Services, .NET, MSVS2010, C#
  • Roles: Designer, Developer, Maintainer as well as team resource for programming and design questions.

Technical Analyst

Confidential, Jacksonville

Responsibilities:

  • Application and Web Development using ASP, XML, XSL, AJAX, VB6.0,COM, DCOM, VBA, VBScript, JavaScript, HTML, CSS, Paint Shop Pro, MS Access, SQL Server, etc.
  • Promotion within from Technical Analyst II to Technical Analyst III
  • Responsible for needs discovery, meeting with customers for requirements gathering, technical documentation, development, testing and final product delivery.
  • Meetings with customer throughout project lifecycle to establish timelines, hurdles and impacts.
  • Coordination with proper outside groups for DB creation, Server IIS calibration and Production, QA, and test region setups.
  • Outward facing Web Applications as well as Intranet and browser based CD Rom applications.
  • Web Screen Scraping applications using VB6, JavaScript and XML saving users many hours of time.
  • Responsible for creation of tables, views, stored procedures, triggers and functions in SQL Server.
  • Roles: Designer, Developer, Maintainer as well as team resource for programming and design questions.
  • Promotion within from Systems Analyst to Technical Analyst II and moved to Application development team Developing in Visual Basic, ASP and SQL Server.
  • Outward facing Web Applications as well as Intranet and browser based CD Rom applications.
  • Creation and automation of a myriad of Office applications to aid with Confidential Claims tasks.
  • Coded VBA to automate MS Office applications including MS Access, Excel, Word, and Outlook as standalone apps or to compliment other applications.
  • Nature of work revolves around creation and automation of a myriad of applications to aid in the business of processing Confidential Claims.
  • Aid in the conversion of old application written in DOS based DFM language over to PowerBuilder 6.5.
  • Design and development of MVS Screen Scraping framework for many departments to use to aid in creating nightly batch changes. Saved thousands of hours and the need for additional Confidential ’s.

Production Systems Analyst

Confidential, Jacksonville

Responsibilities:

  • Assigned to Confidential as production testing for Confidential compatibility.
  • Submitting production jobs in a Confidential test environment for Confidential Part A.
  • JCL changes to make jobs compatible with the test system.
  • Created comprehensive log procedure for testing and audit trail.
  • New Assignment. Needed in CWF area testing for Confidential compatibility.
  • Submitting production jobs in a Confidential test environment for Confidential Part A.
  • JCL changes to make jobs compatible with the test system.
  • Created small macros in Attachmate’s ‘Extra’ to save time in archiving job history onto floppy storage

Production Systems Analyst

Confidential, Jacksonville

Responsibilities:

  • Received daily requests from users for jobs to be run against DB2 on MVS
  • Submitted jobs though CA-7 Personal Scheduler.
  • Prepared nightly schedules to be run for several different clients and had revolving on-call pager through evenings.
  • Aided in the transition to Unix scheduling system ‘Autosys’ and worked with developers to test the new production environment.
  • Volunteered to work control center for a month when department was short.
  • Developed Access apps that automated processes such as FTP, weekly - monthly system statistics, and logging of our daily activities with users.
  • Did own software and hardware configuration on our PC’s for our immediate group.

We'd love your feedback!