SUMMARY:

To build custom Microsoft Data Solutions, in a technical environment that presents a daily challenge, entailing a wide variety of software development and data analytics as the primary duties and responsibilities, with a company that offers exceptional advancement and growth opportunities.

SKILLS:

• Expert in Access, Excel, VBA, SQL, Sharepoint
• Excel: vlookups, hlookups, OffSet, Indirect
• Pivot Tables, Pivot Charts, PowerPivot
• Requirements Gathering
• Technical Documentation
• User Manuals
• SOX Compliancy (Sarbanes Oxley)
• Risk Identification & Analysis
• ROC (return on capital)
• ROIC (return on invested capital)
• SDLC Policy & Guidelines
• Agile Methodology
• Remote Access Support
• KPI (key performance indicators)
• Systems Analysis
• Database Design
• RFO (request for offer)
• Business Requirements
• Preventative Maintenance
• VPN configurations
• Expert knowledge of Windows
• IIBA Member (since 2010)
• CountIF, SumIF, Linking, Import/Export
• Slicer, Timelines, Calc, MS Query, Macros
• Elicitation Process
• Financial Analysis
• ROI (return on investment)
• ROR (rate of return)
• ROMI (return on marketing investment)
• Solution Specifications Document
• Flow Charting
• Application Automation
• Waterfall Methodology
• Project Scope
• Custom GUI
• Business Process Modeling
• Advanced Data Analytics
• MS Project, MS FrontPage, MS Publisher, MS InfoPath, Crystal Reports, Corel WordPerfect Suite, Acrobat, Lotus 123, Lotus Notes, QuattroPro, Quickbooks, PageMaker Pro
• Data Backup and Recovery Systems
• Visual Source Safe

CONTRACT HISTORY:

Confidential, Ft. Worth, TX

Sr. MS Access/Excel/SQL/VBA Developer/Analyst

Responsibilities:

• Duties were to design and create a fully automated GIS Data Loading System to interface with the clients new ArcGIS Geo Database Enterprise System by Esri.
• This involves building a custom data - loader from Excel (.xlsx) and Access (.accdb) files.
• Heavy Excel data analytics, data tracking, data metrics, custom dashboards, custom data processes, custom pivot tables, automated workbooks, custom business rules.
• Imported hundreds of databases, built multiple custom data models using Access/Excel/VBA/T-SQL.

Confidential, Austin, TX

Sr. MS Access/Excel/SQL/VBA Developer/Analyst

Responsibilities:

• Duties were to reengineer from scratch and to fully automate a State Waiver Tracking & Reporting System for the Center for Policy & Innovation (CPI) department, under the Department of Aging & Disability Services (DADS) leadership.
• The new system now incorporates custom performance measures and other user functionality such as auto importing and exporting of custom data-sets, auto-emailing of those data-sets from within the database, custom data-entry user screens, custom user-level security features and custom waiver reporting metrics with the following output.
• Also developed custom Excel Dashboard Analytics and Templates using a variety of automated tools such as vlookups, pivot tables, INDEX, Match, OFFSET, custom macros and custom VBA scripts to automatically capture and process data from external departments, prior to importing data into the database.
• Also created new Business Processes that govern how the data-flow is validated, manipulated and analyzed prior to report generation.

Tools: Access 2013, Excel 2013, Visual Basic for Applications (VBA), T-SQL, PowerPoint 2013, Word 2013

Confidential, Denver, CO

Sr. MS Access/Excel Developer

Responsibilities:

• Built multiple automated MS Access databases for the “Technology Dept”. Created new automated data processes that massaged and manipulated large datasets from SAP and SQL.
• Heavy Access, Excel & Data Analytics. Heavy Excel, vlookups, pivot tables, slicer and data processing macros.

Confidential, Minneapolis, MN

Sr. MS Access Developer

Responsibilities:

• Built/enhanced four (4) separate databases, TimeTracker DB, Agent Termination DB, Financial Intelligence Unit DB, and the Confidential DB.
• Automated "Import/Export" functions, data manipulating, report generation, data-entry screens, and built custom SQL queries used as data dumps to Excel for further analysis using custom pivot tables, vlookups and VBA.
• Created & implemented custom "Test-Plans and Excel Templates" for the UAT process.

Confidential, Las Colinas, TX

Sr. MS Access Developer

Responsibilities:

• Built a custom "Project Manager Database" for the Purchased Services Dept.
• Met daily with project Director to define business needs and project scope.
• Designed and implemented custom user-screens that allowed for detailed project management functionality by providing custom automated reporting, pivot-tables, v-lookups, importing and exporting of .xlsx and .txt files, user tracking metrics and automated processes.

Confidential, Plano, TX

Sr. Systems Analyst/MS Access Developer

Responsibilities:

• Duties were to build ten (10) custom user-screens with a wide variety of functionality for the client "Fidelity Investments - Defined Benefits Dept.".
• Enhance twelve (12) existing MS Access Databases to accommodate a new thirty-two character part number. This directly impacted over 300 tables, 1,100 queries and 180 reports.

Confidential, Dallas, TX

Sr. Business Systems Analyst

Responsibilities:

• Built multiple “Automated Mortgage Lender and Loan Tracking & Reporting Systems”.
• Began the Elicitation process and developed the initial Project Scope document, Stakeholder Requirements, Solutions Specifications, Interface Control and Report Specifications Documents.
• Served as Database System Implementation Specialist overseeing four (4) individual desktop-level tracking and reporting applications and seven (7) enterprise-level batch reporting applications.
• Assessed business operations and processes to understand procedures, information flows, handoffs, decisions, and communication pathways.
• Participated in meetings to automate, upgrade, or expand applications that accomplish business operations of assigned work unit(s).
• Created, designed, and formatted technical specification documentation including architecture diagrams, process flows. Created Test Environment and Test Plans, Automated Testing Scripts and Processes, Oversees UAT Group.
• Provided support by tracking production problems and troubleshooting to sustain application in production.
• Developed queries, analyses, and/or reports.
• Provided guidance and technical supervision to other staff.

Confidential, New York, NY

MS Access Developer

Responsibilities:

• Created an automated Inventory Tracking & Reporting System.
• Created custom interface allowing users to enter inventory data; physical counts and location and product information.
• Created a custom “Administrator Utility” that allows management to control user input, the ability to perform data backup, and restoration procedures.

Confidential, Tampa, FL

Webmaster/MS Access Developer

Responsibilities:

• Developed custom Web Analytics Reporting.
• Developed Back-end Access/Excel database.

Confidential, Tampa, FL

MS Access Developer

Responsibilities:

• Created an automated data-capture system from newly installed Biometrics Identification hardware.
• Seamlessly integrated this tool into the client’s existing GCM Database Tracking and Billing System, in compliance with the new “Florida Statue 538.23(3)”.

Confidential, Orlando, FL

MS Access Developer/Analyst

Responsibilities:

• Provided technical support on four projects; two were for the US-IT Dept. and two for the Human Resources Dept.
• Developed 2 (AMEX) American Express Cards Tracking and Reporting Systems.

Confidential, Orlando, FL

MS Access Developer

Responsibilities:

• Created an Automated MS Access Database & Web Reporting System for the Information Technology Services Dept.

Confidential, Orlando, FL

MS Access/Excel Developer

Responsibilities:

• Created an Automated User-Security Access Tracking and Reporting System to meet SOX requirements.
• Created a custom MS Access Database to import large volume Excel spreadsheets extracted from SQL Server and SAP enterprise data systems.
• Heavy design and development of user interface screens, macros, IF statements, pivot tables, vlookups, import specifications, SQL statements and VBA coding.

Confidential, Tampa, FL

MS Access Developer

Responsibilities:

• Create an Automated Web Data Import and Reporting System.
• Designed custom user interfaces to automate and validate the processing of employee Time Sheets.
• Created custom tables, queries, forms, reports and macros to calculated, manipulated, and summarized employee time sheets for daily and weekly reporting.