MSOffice, MSAccess, VBA, SQL Automation Developer
Resume:
Russell Owen Hertz
*******.*****@*****.***
Nashville, TN 37069
SUMMARY
** **** ***** ***** ************ 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, Oracle, DB2, DB creation, and normalization, scripting tables, views, stored procedures, triggers and functions.
Experience with VB6, Classic ASP, MS Access, MSOffice, VBA, XML, XSLT, PowerBuilder, SharePoint DB
Good organizational skills. Impeccable and dependable communications with clients and others.
SKILLS
Programming:
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
Business Analysis and requirements gathering:
In all of my development activities:
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.
Software:
MSOffice
FTP
Audio software
Photo and graphics creation and retouch
3D graphics creation
Attachmate Extra
Exceed
ClearCase
PVCS
Other:
Process Automation, Object Oriented Architecture and Programming, Technically literate and abreast of new technologies and convergence’s, DB creation, Server IIS calibration and Production, QA, and test region setups.
Following:
Node.js, JavaScript Frameworks, HTML5, CSS3, Mobile development, Microsoft SharePoint and MOSS,
EMPLOYMENT HISTORY
Automation Developer:
1ApTask at First Data / FiServ (Hagerstown MD.)
1November 2019 – Present
1Responsibilities:
2Credit Card Processing Lifecycle
Process Automation in Office 365 Suite Access and MSOffice Suite MSExcel and SQL Server as back ends.
Aid Business Analysts by Following what activities they normally perform and automating
them so that they can run them automatically from their workstations.
Strong Emphasis on complex Excel Processes.
Maintenance of Existing process automations as well as entirely new automations
Create full Access applications if deemed necessary for the amount of data and audit specifications.
Senior Developer:
2WCapra Consulting (Nashville, TN.)
1September 2017 – September 2019
1Responsibilities:
2Mainly provide solutions for Exxon Mobile Customer Loyalty Program. Loyalty Program Data ETL
Automation of Internal HR and Business Processes (Expense Reports and KPI) using VBA Excel MS Access and MSOffice Suite.
Automation of Excel Dashboards creation and ETL activities.
Creating new Automated PCI Compliancy archival and Reporting Process for Network Vulnerabilities Detection Hardware using VBA Excel MS Access and MSOffice to start and then porting to a AWS web-based solution.
Creation of Payment Gateway to process all claims from different Clients and route to proper Banks. Using Excel MS Access and MSOffice to start then routing to AWS Web based solution.
MS Office and Access 2010 VBA Developer Automation:
3TMFloyd at BCBSSC. (Columbia, SC. And Nashville, TN.)
1August 2016 – June 2018
1Responsibilities:
Analyze current system of Processing Pharmacy Package Plans for Companies and Provide Automation through VBA Excel MS Access 2010 and MSOffice.
Meet and plan with Customer to discuss current processes
Document current Process and come up with design and Architecture to accomplish their goals.
Develop solution that is well written and easy to use and for existing developers and to maintain when contract is over.
Self-managed and report straight to the director for any issues or concerns related to project.
MS Office and Access 2010 VBA Developer Automation:
4Contractor GSS Global systems Solutions Inc. at Client BNY Mellon Bank (Nashville, TN.)
1August 2015 – April 2016
1Responsibilities:
Automation of sophisticated large bank processes through the use of VBA, MSOffice, Outlook, Excel, MS Access Programming Solutions.
Creation of new application to automate MS Excel and MS Outlook for BNY Mellon New Account requests.
Application automated the manual processes that Clerks did to process all new account requests coming into BNY Mellon Bank. Monitoring and processing all emails and attachments coming into multiple Email accounts for different groups to process. Assigned work IDs and Saving of email and attachment metadata and rerouting of emails and work to proper clerk’s outlook folders for additional processing and tracking
Involved sophisticated assigning algorithms for assigning of work based on criteria found in MS Excel attachments of the emails.
Senior Classic ASP Developer:
5Contractor Conexess at Client Jack Henry and Associates (Nashville, TN.)
1May 2015 - August 2015
1Responsibilities:
Patch security vulnerabilities in the company owned website software by implementing OWASP solutions.
Responsible for research and resolution to Classic ASP Website Software for Banking Utilities.
Powerbuilder Developer:
6Contactor Beacon Hill Technologies at Client PGI Polymer Group Inc. (Nashville, TN.)
1February 2015 – May 2015
1Responsibilities:
(Short Contract): New Requirements gathering, Design, Code, Test and deliver Applications written in PowerBuilder.
Enhancements and Fixes to Factory Shop Floor System called FIRM used for all factory shop floor areas.
Create requirements and Fix documentation and technical descriptions.
MS Access 2013 VBA Automation Developer:
7Contractor at The Judge Group at Client Aramark (Nashville, TN.)
1August 2014 – February 2015
1Responsibilities:
New Requirements gathering, Design, Code, Test and deliver Databases using Access2013. Strong VBA.
Application requirements summary: two Applications: 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:
8Contractor at TekSystems at Client Affinion Group (Nashville, TN.)
1August 2013 – July 2014
1Responsibilities:
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
1Mphasis(HP) (Nashville, TN.)
1March 2010 – August 2013
1Responsibilities:
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 I II III
BCBSFL(FCSO) (Jacksonville, FL)
1June2000 – March 2009
1Responsibilities:
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 Medicare 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 Medicare 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 FTE’s.
Contractor Production Systems Analyst
1ISS (Jacksonville, FL)
1June 98 - June2000
1Responsibilities:
Assigned to BCBSFL as production testing for Y2K compatibility.
Submitting production jobs in a Y2K test environment for Medicare 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 Y2K compatibility.
Submitting production jobs in a Y2K test environment for Medicare 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
1Wellspring Resources (Jacksonville, FL)
1Nov.95 – June 98
1Responsibilities:
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.
EDUCATION
Associate in Arts, Brevard Community College1992
Pursued B.S. Computer Science U. of Central Fl.93-94
Pursued B.S. Computer Science U. of North Fl. 94-96.
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
• object-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
Projects
Claims Time Entry Tool – Application to allow for real time, clock time and claims count entry for the Claims Processing Dept. (Operations area) Served as a small Work Management tool
Client/Web E-News Tool - The Provider Web Content and Education Department was looking for a new tool for them to screen scrape the entire Medicare website and provide a list of content which they could then pick and choose links from to add into a new HTML or TXT formatted Enews article that would then get sent to all the regional providers. It relied heavily on VB, HTML, XML, DOM and VBScript. The VBScripting was the underlying code for the HTML DOM manipulation and output file writing. I worked closely with the customer which was very picky about detail. I built a long-lasting relationship with the whole department. I also maintained and enhanced the application with them anytime the Medicare Website was redesigned (DOM changed).
PCAce Alternate Transfer Tool - Client Side VB6 Application - The Electronic Document Interchange Department needed a new tool for Providers all over the region to send electronically formatted claims to our UNIX based Gateway for processing. I worked diligently with the customer and outside third-party developers to understand their processes and to create a tool that worked seamlessly with existing PCACE software. I developed a long-lasting relationship with the area as well.
I’ve maintained an excellent working relationship with all customers and have even won difficult customers confidence back for our IT department.
Mainframe Screen Scraping tools - Early in my employment with First Coast Service Options I was running mainframe batch jobs using Attachmate as the interface. I found that I was doing a lot of repetitive work and created some scripted macros to automate screen navigation and validation and then automated the ftp of summary info from Archives. I was recognized and promoted to Technical Analyst I.
MS Access development and mentorship – I was responsible for the maintenance and enhancements of our End of year bonus and merit increases as well as mentoring of one of our customers in coding all his various tasks in VBA for the applications he was working on
Web Intranet Applications - I’ve created, enhanced and maintained many 3-Tier Web Intranet applications using VB6, ASP, COM, VBScript and JavaScript, XML, XSLT and SQL Server DB as the back end as this was a large portion of what I worked on (7 years).
We used VB6 to code the business object for each web application (dll). This module was responsible for business rules and connecting to the DB connection module (also a VB dll) to run the specific stored procedures we needed to return data from. I wrote applications in ASP and I would be responsible for the creation of all tables, stored procedures, triggers, and views within the specific Database as well. I have been doing Web Intranet applications in VB6, ASP and SQL for about 6-7 years and recently started implementing AJAX into my apps as well.
Created different forms of reporting mechanisms utilizing MSOffice, especially Word allowing for dynamic customer letter creation populated from parameterized SQL queries. Used XML and XSLT to dynamically create customizable HTML reports as well. Most recently, I’ve used Crystal reports to provide for multiple sub reporting output.
As a Technical Analyst I learned PowerBuilder 6.5 and built innovative screen scraping I spent about 3 years creating and evolving the applications until I had the opportunity to start development in VB6 so I moved into VB6 as a Technical Analyst II
Automation of MSOffice is something I've done as well. Email validation scripts, VB6 dynamically writing autostart and autoclose scripts into office documents, etc.
I wrote a VB6 module for inclusion into a larger application to create word reports from data located in SQL server.
Also wrote a web based reporting mechanism that pulled data from SQL Server converted it to XML and then ran specific XSLT pages against it providing automated HTML formatted reports
I also very familiar with SQL Server and write SQL Server stored procedures and triggers as well as scripted tables, views etc.
I've scripted small tools for myself sometimes like a html page to browse through Windows NT Domains/groups/and users: VBScript
Created HTA apps that allow for web applications that look like windows applications allowing some unique abilities
GANYMEDE - Using Access and VBA and adhering to the company framework, I created a more object oriented method to process the numerous banks formats. The current Access applications within the company were all written top down procedural with little abstraction and lot of hardcoding. I created a formatting table to define the different requirements of each bank. The application would then pull those requirements into special processing objects and know exactly where in the resulting file to drop the formatted data, or where to retrieve and drop data in an Excel worksheet. When new banks files were needed, I would just need to create a new mapping in the table for that client. The rest was abstracted avoiding the need to repetitively write a whole new procedural process for each bank.
DOCENROLL- Worked with Clients, BA’s and DocuSign Developers to streamline a new process for banks to give their customers an electronic form mailed to their address in order for them to fill out and sign. My task was to take the resulting data file and convert it into a strict DE5 VAX format for batch processing. Reusing my custom file mapping and processing I was able to streamline the processing fast. While the source file format kept changing in scope I was able to make quick mapping changes to remedy and keep my end in sync.
PULSAR - There was a need to grab the exported results of all the assigned projects for our area in Excel and process all the results into a new reformatted spreadsheet and then create a pivot table for presentation to the upper management. The responsible party was manually finagling the data and building the same report every week taking many hours. I automated the whole process to run in nearly one minute.
COMPLAINT TRACKING - The legal department was having some problems with their complaint tracking application written in 2003. They were having to go into access design time and create a report and define query criteria every time they wanted to create a report. They were not avid Access users so this was kind of daunting for them.
Contact this candidate