Ruel Cespedes

Summary:

An accomplished IT Professional with over 20 years in Rapid Application Development (RAD) and support. Worked within a wide range of industries including Banking and Finance, Federal and State Government, Aerospace, Medical and Biotechnology, Mortgage and Real Estate, Insurance, Petroleum, Manufacturing, Wireless and Ecommerce on multi-platforms and networked environments.

Experienced in Designing, Developing, Implementing, Managing and Supporting Large Scale Database Applications and Data Migration from Access to SQL Server. Creating Reports for Financial Analysis, Data Analysis, Compliance Analysis, Requirements Gathering and Documentation, Technical Writing, Project Management in full Systems Development Life Cycle (SDLC), Prototyping and Development, QA Testing, Trouble Shooting and Problem Solving, Conversions and Upgrades, Implementation, Desktop Support, and Training.

Capable of communicating project development to all levels of management and project team members as well as translating end-user requirements from high level design specifications throughout a project's life cycle and convert them to technical specifications. Skilled in structured development and data modeling methodologies, implementing and supporting ETL processes, production implementation and rollout, and change control processes.

Worked in fast paced (Agile and Scrum), team or self-directed environment with the ability to prioritize multiple tasks and manage time, budgets, and personnel effectively as well as work non-standard hours, travel as required and willingness to assist in other IT related processes and tasks as needed.

Technical Qualifications \ Skills:

Programming Language: Visual Basic for Applications (VBA)

Microsoft SQL Server Management Studio: 2016/2012/2008R2/2005/7/6.5/6

Microsoft Access: 365/2019/2016/2013/2010/2007/2003/2002/2000/97/95/2.0/1.0

Project Management Tools: MS Project, Visio, Word, Excel, and PowerPoint

Reporting Tools: Advanced Excel, Advanced Macro Development, Pivot Tables and Graphing Proficiencies

QA Tools: TFS, Rational ClearCase; Rational ClearQuest; Remedy

Operating Systems: Windows 11/10/8/7/Vista/XP/2000/NT4.0/98/95/3.1; Novel; UNIX; Dos

Education:

Bachelor of Science in Professional Aeronautics, Embry-Riddle Aeronautical University - Daytona Beach, FL 1994

Associate of Science in Technology, Community College Of The Air Force - Montgomery, AL 1992

Associate of Arts in Information Management, University Of Maryland - College Park, MD 1989

Professional Experience:

Raft LLC, Reston, Virginia May 2021 to March 2023

Senior MS Access Developer

Responsibilities:

Designed, developed, and implemented a custom-made Access Database for the United States Air Force Chaplain Corps Activity Reporting System (AFCCARS). The database tracking system manages the religious and spiritual needs of airmen and their families. AFCCARS is used to track and report on the activities of chaplains and their assistants, including counseling sessions, religious education classes, and other activities related to providing spiritual care and support. AFCCARS helps the Chaplain Corps to understand the needs of airmen and their families and to ensure that they are receiving appropriate spiritual care and support. It also helps to track the performance and effectiveness of chaplains and their assistants, and to identify areas for improvement.

American Electronics, Inc. California, Maryland October 2017 to October 2020

Senior MS Access Developer

Responsibilities:

Designed, developed, and implemented a custom made Access Database and VBA solution called the Navy Training System Plan (NTSP) Database and a Crew Scheduling Phasing Plan (CSPP) Database for the United States Navy. Both the NTSP and the CSPP Database calculates and plans the required Manpower Requirements for each job skill required onboard ship, aircraft, and support personnel for the entire US Navy. The calculation forecast the Manpower Requirements by Fiscal Year and executes future crew requirements and training based on a phased process.

Bank of America Charlotte, North Carolina August 2016 to October 2017

Senior MS Access Developer

Responsibilities:

Designed, developed, and implemented a custom made Access Database and VBA solution that reports data using SQL Server and Excel Spreadsheets on SharePoint. Developed and executed ad-hoc data mining reports based on user requests for Data Analysis, Financial Analysis, and Compliance Analysis.

Wells Fargo Charlotte, North Carolina April 2016 to July 2016

Senior MS Access Developer

Responsibilities:

Designed, developed, and implemented a custom made Access Database and VBA solutions to reconcile monthly and quarterly derivatives data in SQL Server and Excel Spreadsheets on SharePoint. Developed and executed ad-hoc data mining reports based on user requests for Data Analysis, Financial Analysis, and Compliance Analysis.

Quadrant Financial, Inc Louisville, Kentucky May 2011 to September 2015

Senior MS Access Developer

Responsibilities:

Designed, developed, and implemented a custom made Access Database and VBA solution called the Small Business Finance Database. The Database provides government-sponsored commercial loans to small businesses. The loans cover a wide range of business needs, including renovation, construction, expansion, refinancing, acquisitions, and equipment purchasing. Developed and executed ad-hoc data mining reports based on user requests for Data Analysis, Financial Analysis, and Compliance Analysis.

Excel and Access, LLC Southern California June 2009 to May 2011

Senior MS Access Developer

Responsibilities:

Designed and developed over 100 custom made applications using Microsoft Excel, Micosoft Access and Microsoft Sharepoint.

Smile Makers Spartanburg South Carolina January 2009 to June 2009

Senior MS Access Developer

Responsibilities:

Designed, developed, implemented, and supported custom made business applications for internal departments such as Sales and Marketing, Warehouse and Inventory, Finance and Accounting, and Training. Worked directly with staff to create new business applications by gathering requirements, creating design specifications, developing the applications, implementing new version releases, and training users with the new application. Recorded and documented end user communications via the applications issue tracking systems.

First Data Martinsburg, West Virginia July 2008 to December 2008

Senior MS Access Developer

Responsibilities:

Designed and developed a customer tracking database in order to identify client impacts and migration strategy for the de-conversion of First Data's processing platforms. Designed and developed a client specific reporting database for major National Clients and Independent Sales Organizations to ensure all clients are notified of changes and impacts.

IRG Jefferson City, Missouri January 2008 to June 2008

Senior MS Access Developer

Responsibilities:

Designed and developed a Statewide Compliance Assistance Reporting System (CARS). The State of Missouri Department of Natural Resources (DNR) has contracted Tier to consolidate three Access Database Systems and convert the backend to DB2.

Columbia Medical Assistance Research Triangle, North Carolina October 2007 to December 2007

Senior MS Access Developer

Responsibilities:

Designed and developed a company wide Document Tracking System. The District of Columbia Medical Assistance Administration (MAA) has contracted A C S to develop a document tracking system that will manage over 6000 medical providers to be compliant with Federally Regulated Medical Industry.

Textron Fastening Systems Southern California September 2005 to September 2006

Senior MS Access Developer

Responsibilities:

Enhanced and maintained internal systems applications used to provide Quality Management towards Lean Manufacturing. Performed Data Mining from Quality Systems requiring continuous improvement in design, coding, documentation and unit testing for enhancements and maintenance of applications. Worked with various business units for confirmation of requirements and presentation of design.

Adecco Technical Northern California May 2005 to June 2005

Senior MS Access Developer

Responsibilities:

Redesigned, developed and implemented a company wide Project Tracking & Reporting Database (RDB) in Visual Basic for Applications 2003 at Genentech in South San Francisco. The application was originally developed for Project Engineering and now required Corporate Engineering information. This project required front-end and back-end redesign, working closely with the end-users to gather and translate their requirements, prototyping all GUIs, trouble shooting and problem solving during testing, providing analysis for new or changing requirements, documenting all specifications, logging and making all code changes, and training all users. RDB is the central reporting database for all Genentech construction projects worldwide.

Modis Nothern California March 2005 to May 2005

Senior MS Access Developer

Responsibilities:

Modified and optimized Clorox's Data Warehouse Organizing and Tracking Solution (DOTS) database in Oakland California. A homegrown application written in MS Access 2000 that interfaces with SAP Business Warehouse. This project required the expert ability to interpret the application's data model, query structures, workflow processes, hidden items, report generation without documentation in order to make changes and reports for new business requirements. The optimization required front-end and back-end redesign, prototyping all GUIs, trouble shooting and problem solving during testing, providing analysis for new or changing requirements, documenting all specifications.

Adecco Technical Northern California October 2004 to November 2004

Senior MS Access Developer

Responsibilities:

Designed, developed, and implemented from scratch a company wide Project Tracking & Reporting Database (PTRDB) in Microsoft Access 2003 at Genentech in South San Francisco. Originally all projects were tracked in MS Excel and now required a new front-end and back-end designed in MS Access. This project required working closely with the end-users to gather and translate their requirements, prototyping all GUIs, trouble shooting and problem solving during testing, providing analysis for new or changing requirements, documenting all specifications, logging and making all code changes, and training all users. PTRDB is the new central reporting database for all Genentech construction projects worldwide.

Apex Systems Northern California April 2004 to July 2004

Senior MS Access Developer

Responsibilities:

Designed, developed, and implemented a company wide Intranet based Administrative Tool for Process Managers and Team Leads within Data Validation that assigns mortgage loans to Loan Agents, QA Personnel, Credit Analysts and Underwriters for an existing mortgage system that uses scanned documents within FileNet and Loan Data within Empower at Greepoint Mortgage in Novato California. Supported and assisted the client with project planning, researching new tools and technologies, requirements definition, business analysis, design, testing, system documentation, data integrity and user training.

Provided interpretation of user requirements to developers, facilitated user interface testing and consulted the lines of business for development and maintenance. Provided analysis and documentation to support all operations such as job streams, report distribution, delivery schedules and calendar job scheduling, in addition to assisting the project team in developing functional and quasi-technical specifications, capacity planning, data backups, test plans and test scripts for data validation, maintenance and performance monitoring. Helped with design issues, all test phases and implementation and post-implementation activities.

Atlantic Resource Group Richmond, Virginia December 2002 to December 2003

Senior MS Access Developer

Responsibilities:

Designed, developed, upgraded, and modified a company wide Security Management System that tracks the surveillance and patrol of all Philip Morris USA facilities across the United States in Richmond Virgina. The system, scattered across 27 databases was successfully consolidated, normalized and upgraded for Windows XP Pro compliance and rollout. Required coordination of data collection, data modeling, data normalization, schema structural changes, customer interviews, and interface development among multiple security departments. Performed on an aggressive development schedule.

Created intuitive user interfaces with the use of ActiveX controls, employing a point and click environment. Streamlined reporting process to provide canned and ad hoc queries for static and dynamic data. Improved process flow on the use of the application by tailoring each table, query, form and report to the needs of each department's function. This process was achieved during normal business hours and zero interruption to operations of security.

RCG Information Technology Houston, Texas March 2000 to December 2002

Senior MS Access Developer

Responsibilities:

Designed, developed, and implemented a company wide HRIS Geosciences Career Assessment and Skills Evaluation System (CARDS) and a Data Request Tracking System (DARTS) for ExxonMobil's Upstream Exploration Department in Houston Texas.

The Career Assessment and Skills Evaluation repository became a valuable tool for Human Resources (HR) to establish skills and salaries for geoscientists, a guide for the Training Department to improve skills, and allow Project Managers to query essential skills to design a new exploration team or simply for HR to find replacements for geoscientists that were moving on to other projects.

The Data Request Tracking System became a powerful tool for Upstream Exploration with the ability to track 2D and 3D seismic requests, payment of invoices for data procurement through the use of frontend accounting, integrated with existing financial, purchasing, and tax reporting applications, which allows project managers to budget based on forecasted data request volumes.

Contact this candidate