Facebook:

E-mail: adx2ut@r.postjobfree.com

469-***-****

Database Analyst / VBA Developer

R Studio

Data Base Servers: SQL-Server 2008, 2005, 2000, Oracle 9i

ANSI SQL Dialects: T-SQL, PL-SQL, DMO-SQL, OSQL

Microsoft Database: Access 2013, 2010, 2007, 2000, 97, 95 VBA

Microsoft Visual Basic 6, 5, 4, 3

Application Integration: ACCESS / EXCEL / WORD via Adobe

WEB Development: PHP, MySQL

Scripting Technologies: WHS, VBS, CDO, ADSL, MSO Encryption

Develop and implement database collection systems, data analytics and other strategies that optimize statistical efficiency and quality.

Filter and “clean” data by reviewing reports, locating and correcting problems.

Identify, analyze, and interpret trends or patterns in complex data sets.

Facilitate delivery of ad hoc analysis and data requests.

Ensure data quality, consistency and security

PROFESSIONAL REFERENCES

Personal Development

A Self-Paced Learning Project (May 2023 to Present)

I developed a prototype housed within MS Access, which uses VBA to leverage database tools such as tables, forms and queries to communicate with WORD and EXCEL Messaging uses the REST API to transmit messages through TWILIO. The prototype contains the same SMS features found in commercial SMS applications. The distinction is the prototype is a RAD (Rapid Application Development) capable of being customized for practical situations. I am now adapting the app to assist small groups and project management.

Bank of America

Contractor: Project Manager (May 2022 to Feb 2023)

Business Metrics is the transformation of complex source files into meaningful and visually appealing reports. Using ACCESS queries, specific fields are extracted and appended into a single table. Commonality is the key to extract and recombined the source files; which are exported into a single EXCEL workbook. Each supporting source file is likewise exported and included within the analysis workbook. Commonality transforms fields into columns. This common thread enables select statements to perform calculations. The filtering mechanism within Excel enhances the ability of the user to easily the data. Pivot tables summarize the data into visually appealing tables. One workbook with the ability to contain multiple source files; each independently calculated based on their own set of business rules. The greatest benefit of this technique is the ability to adapt to change. Changes within the business and changes within the environment.

Retirement (April 2018 to April 2022)

My retirement consisted of investing in real estate. Purchasing, remodeling and reselling properties is not for the faint hearted. Especially, for those of us who do not possess multiple skill sets. Speculation is labor intensive unless professionals are hired, in which case the profits diminish. My transformation into a real estate speculator came with a greater learning curve. I derive satisfaction and purpose by participation in veteran organizations and inner peace by evangelizing and feeding the homeless. I continue speculation but confine my activities to the financial markets and leave real estate to those brave souls with greater knowledge, skill and experience

J.P. Morgan Chase

Contractor: Senior Business Analyst (June 2016 to March 2018)

Microsoft Access 2013 / Microsoft Excel 2013 Business Analyst tasked with performing customer support of . UT ‘User Tool’ applications which enables the Auto Finance department to monitor, engage and analyze business activity. I was based in Fort Worth, but support end users at the Phoenix Arizona Data Hub. My skills are a combination of Customer Support, Software Development and Business Analysis. I now develop standalone survey applications into frontends tools for the purpose of statistical analysis using R as the programming platform. My In-depth understanding and knowledge of the programming and business analysis enables me to design and elevate applications to a higher level of understanding the market, reacting to market changes and reducing the amount of time required to adapt to market conditions.

ATS The Cloud - Credit Protect Services

Contractor: Senior Business Analyst (January 2016 to June 2016)

Microsoft Access 2013 / Microsoft Excel 2013 Business Analyst. I was tasked with performing file comparisons for the migration from a mainframe platform onto SQL Server. The conversion required the comparison of main frame files available as views existing on SQL Server.

Chuck E Cheese Entertainment

Contractor: Senior Developer / Business Analyst (July 2014 to January 2016)

Microsoft Access 2013 / Microsoft Excel 2013 Contract VBA Programmer / Analyst. I converted a mainframe Performance Bonus system into a Windows Desktop Application. Built into the system were dynamic informational interfaces to WORD and EXCEL that enabled the application to produce statistical graphs and pivot tables. In summary the application uploads Excel files and generates Adobe PDF as well as Excel spread sheets suitable for in depth financial analysis. Data validation and quality control features of the application were performed using both scripted and ad hoc queries on the SQL Server back end.

CORE LOGIC

Employee: Senior Taxation Service Business Analyst (July 2013 to May 2014)

MS SQL Server 2005 / Microsoft Access / Microsoft Excel 2003 - 2007 I was responsible for the maintenance, modifications and enhancements of distributed Mortgage Servicing databases. I created, modified and performed quality assurance and statistical analysis which included regression analysis, automated pivot tables and Excel statistical analysis on tax servicing applications. I am proficient in rewriting MS Access queries to T-SQL stored procedures. I program at the master level in all dialects of VBA as well as MS Office application objects.

BANK of AMERICA

Employee: TSU Senior Business Analyst (September 2011 to July 2013)

MS SQL Server 2005 / Microsoft Access 2003 - 2007 / VBA I was responsible for the maintenance, modifications and enhancements of distributed Tax Servicing databases migration from MS Access 2003 to 2007 in this migration II coded automated scripts for redundant testing of code modules as well as overall functionality. This included the conversion of MS Access queries to pass through and stored procedures designed to shift the processing from the front end application to the back end server. Creation of DTS packages to enhance reporting and provide greater performance, reliability and transaction logging.

SAMSUNG Communications

Contractor: Application Developer / Business Analyst (April 2011 to June 2011)

Extract, transform and load (ETL) I created a functional Statistical prototyped in Microsoft Access. The application enables data to be analyzed and reported using custom and conventional ETL data techniques from CSV text file, Excel spread sheets, or EDI generated files received from retail sources (Radio Shack, WalMart and Best Buy) enabled the data collection of inventory and sales data and measure data trend and operational needs of multiple departments. QA assurance was logged by loading the data into a SQL Server Database. The prototype enables management to gauge data size requirements, measure the constraints and benefits of internal development against external third party products and services. The reporting capabilities were written in VBA Excel, CDO objects.

VERIZON Communications

Contractor: Reporting Specialist / Application Developer / Business Analyst (July 2010 to April 2011)

Microsoft Access / Excel / VBA, I was tasked with converting a performance evaluation system written in MS Excel into MS Access. The transformation of a flat file process into relational tables enabled the system to gather, evaluate and simplify corporate management performance. The system summarizes statistical data within an accuracy level of 95%. Reports are generated based on pivotal data in a variety of graphical formats. The accuracy of the system is based on evaluations of the source data within three standard deviations. What enables this application of really stand out are the automated capabilities to import and extract data through the use of the Excel object model and well as interface with the Calendar, Task, Email and Note capabilities of MS Outlook through the use of the Outlook object interface..

METLIFE Home Loans

Contractor: Reporting Specialist / Application Developer / Business Analyst (December 2009 to April 2010)

Microsoft Access / Excel / VBA, I was tasked with the job of integrating the Remedy Reporting System into their internal tracking system. MS Access is used as the file processing that outputs data presented as Excel spread sheets. Initially designed as a prototype; the proof of concept evolved into a tool which measures and evaluates advisor performance and simplifies their staffing requirements.

BERYL COMPANY

Employee: Report Specialist / SQL Developer: (January 2007 to October 2009)

SQL Server 2000, Microsoft Access 2003, 2007, VB 6, and Web Focus

Automated systems programmed ad hoc reporting processes, redesigned, improve and the legacy VB6 systems with industry standard practices and procedures. Effective automated systems are determined by a thorough understanding and documentation of the manual procedure people use to perform their jobs. Efficiency improved by analysis and redesign of the legacy process. At Beryl I maintained the existing legacy application, wrote new applications, debugged and resolved corrections to corrupted database systems

GOODMAN NETWORKS

Contractor – EDI Application Developer: (December 2005 to January 2007)

Advanced MS Access skills / SQL Developer / Process Documentation

Application Environment: SQL Server 2000, Microsoft Access 2000, VB6 and WHS

The glue which holds the EDI process together is VB Scripting. Automated process execution, enable reporting and monitor procedure execution. When errors occur they are transmitted via Common Dialog Objects (CDO) and SQL stored procedures into logs. SQL Server Jobs and Scheduled Task monitor, log and report on the receipt, updating of all applications. Essential to every automated system is the User Interface, built in MS Access, enabled the user to schedule ad hoc processing, report monitoring with the specific purpose of improving and replacing repetitive and costly manual processing with efficient methods and procedures.

DALLAS AREA RAPID TRANSIT

Contractor – Application Developer (June 2005 to September 2005)

Application Environment: Advanced Microsoft Access 2000 SQL, VBA

SQL queries within MS Access analyzed and converted reversed engineered data contained in Excel Spread Sheets into Access front ends. The users who maintain this type of data are often not the programmers or engineers. Safeguards included code which prevented accidental deletion of formulas as well as unauthorized access or interaction with the date, where the data is to be stored and what kind of storage facility.

BANK of AMERICA

Contractor – Application Developer (August 2004 to December 2004)

Application Environment: Peregrine Asset Center 4.3, AutoMate 5.5,

Advanced Microsoft Access 2000 SQL, VBA

Responsibilities: Designed and developed automated solutions capable of importing, manipulating and populating information from and to dissimilar systems. Automated systems are nothing new. What is exciting is their ability to recycle and leverage production data such as purchase orders, invoices and pricing data. The capability to report on the status and availability of products is very desirable. Utilization of existing resources can be achieved by manipulating and integrating repetitive procedures. To qualify an existing process; the process must measure, report and log errors. ? Qualitative and empirical techniques are the corner stones of Six Sigma

CITI CAPITAL

Contractor – Application Developer (February 2004 to May 2004)

Application Environment: Advanced MS Access 2000 SQL, VBA

Responsibilities: Designed MS-Access based application capable of importing production text files and manipulating those files into daily production reports based on statistical analysis. The ability to leverage information from existing systems is very useful especially when variables such as date ranges are used. Statistical functions such as Networkdays are is extremely effective in both quantitative and qualitative analysis.

Trammell Crow Residential Services

Contractor – Application Developer (August 2003 to November 2003)

Application Environment: Advanced MS Access 97, 2000 SQL, Visual Basic 6, Crystal Reports 6, Visual SafeSource Responsibilities: Created a debugging technique that iterated through the tables collection which discovered application corruption resulting from links to non-existent linked objects. Modified and created ad hoc Crystal reports based on complex SQL queries. I prepared the transition of several accounting and business applications from client server to browser based applications. I provided the functional and relational analysis and design components for transition of two production based systems EVBS (Partner Ownership) and Risk Management

Verizon Communications

Contractor – Applications Developer (August 2002 to January 2003)

Application Environment: Oracle 8, Access 2000, Visual Basic 6, Excel 2000, Visual SafeSource

Responsibilities: Developed COM integrated reports using the VBA Excel object model, Oracle 8 and Visual Basic 6 to process EDI data stored on Oracle databases. The purpose of the application was to facilitate the planning, management and implementation of corporate wide divisional projects. The result permitted groups of managers to input, track and report on the individual progress of each project. Excel provided the capability to create dynamic graphs using numeric computations which transformed tables of data into the dramatic corporate presentations.

GENUITY Telecommunications

Employee: Applications Developer (March 2001 to August 2002)

Application: SQL Server 7, Access 97, Access 2000, Visual Basic 6, Excel 97, Visual SafeSource

Responsibilities: Developed application front end which extract, report and analyze warehoused data. COM methods and VBA techniques enabled the RAD scalable modeling and data analysis. Data extraction using COM were integrated with WinSQL to provide flexible and simple sources used to merge data into Excel spread sheets.

Verizon Communications

Contractor - Applications Developer (July 1999 to February 2001)

Application Environment: SQL Server 6.5, Access 97, Visual Basic 6.0, Visual SafeSource

Responsibilities: Maintained nine (9) two-tier Corporate Database Applications. Fueled by the need to ‘easily’ extract data from corporate EDI data warehouses these applications used Microsoft Access, VBA and Visual Basic front ends tied to SQL Server.

Trammell Crow Residential Services

Contract or - Application Developer (August 1997 to August 1999)

Application environment: Crystal Reports 5.0, Visual Basic 5.0 and Access 97, Visual Basic for Applications Visual SafeSource

Analysis and design was the cornerstone of this application which was designed to enhance an existing HR Payroll process. The functional components consist of a Visual Basic front end linked to external Fox Pro 2.0 tables. The application calculates detailed and summary reports.

EDUCATION

University of North Texas

School of Business Administration

Dallas County Community College District

Buy a book, Open it, Read it

MILITARY SERVICE

UNITED STATES MARINE CORPS

NOV. 1968 TO OCT. 1971

Presidential Detail

Honorable Discharge

SERVICE ORGANIZATIONS

Lions International

United State Marine Corp League

American Legion

PROFESSIONAL REFERENCES

Rance Greer

Auto Finance VP Software Operations

J.P. Morgan Chase

817-***-****

adx2ut@r.postjobfree.com

Dan Morrison

Core Logic, Operation Manager

817-***-****

Barry Evans

Sr. VP Bank of America / Core Logic

214-***-****

Steven Abney

Applications Manager Beryl Company

817-***-****

Contact this candidate