TECHNICAL SKILLS:

Database Design and Development: SQL Server 6.5, 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008R2, SQL 2012, SSRSMS Access (all versions up to Access 2016 - VBA, DAO, ADO, ODBC, ActiveX, Security, SQL, ADP)Oracle 9i (PL/SQL)Sharepoint 2007/2010, InfoPath 2007/2010

Speed Ferret, Total Access Analyzer: MS Excel (all versions Excel 2016 VBA, Data Validation, PivotTables, Charts, Formulas, Conditional Format)

Crystal Reports and Crystal Info: Visual Basic 6.0, VBA Tools for VB.NET 2003, Visual Studio.NET 2005, and Visual Studio Pro 2012

Web Design and Development: VBScript, JavaScript HTML, XML, CSS, FTP ASP Classic and ASP.NETMacromedia Suite: Dreamweaver 8, Flash 8, Director 8, Fireworks 8, Dreamweaver MX

Other Software: MS Office Professional & Developer's Editions 95/97/2000, 2002, 2003, 2007, 2010, 2013, 2016 Visio 2000, 2003, 2007 Visual SourceSafe, Vault

WORK EXPERIENCE:

Confidential ( Monroe, LA)

Data Analyst/SQL Developer

Responsibilities:

• Subject Matter Expert for Credit Audit Checklist, Collateral Audit Checklist and create Processor Checklist
• Create and support Exclusionary Appraiser List, LOS Conditions Processor, ROC Data, and Task Navigation Access databases
• Visual Stuidio 2012, SSRS and SQL Server stored procedures for Confidential pipeline reports

Confidential (Austin, TX)

Data Analyst/SQL Developer

Responsibilities:

• Create and design Access GUIs and serve as Subject Matter Expert for Offer Manager Tool, Offer Builder Tool, and Task Navigation Tool
• Create and maintain stored procedures for Product Manager tool
• Maintain Product Mix, Offer List, Doc IDs, Matrices, along with all Data Request Forms and Offer Request Forms.
• Process marketing products and offers with rate plans for Eligible Offers DRF, Retail and Events DRF, Web and Call Center DRF, Brokers DRF and Roll-Offs
• Process Offer Request Forms to create new offers
• Maintain SQL stored procedures, DTS package for Product Tracker, SQL views and tables
• Process All Offers Ever Offered and All Offers in Market reports as needed.

Confidential (Monroe, LA)

VBA Developer

Responsibilities:

• Excel work includes import process, data links, VLookups, HLookups, advanced formula functions (business rules and logic), hidden PASS/FAIL engine, conditional formatting and data validation
• Develop Collateral Checklist, Credit Audit Checklist, and Compliance Checklist to process auditing of loans for Correspondent Lending Division in Monroe, LA.
• Created documentation and Update Checklist for tracking updates.
• Provided and documentation to IT personnel for continued maintenance

Confidential (Houston, TX)

Senior HRIS Analyst

Responsibilities:

• Develop InfoPath forms for Sharepoint 2007/2010 (Performance Evaluation, Employee Change Form, Position Change Form, Employee Search)
• Develop Sharepoint Lists
• Access database developer for various HR applications (compliance, benefits, reporting, mass upload process)
• VBA and SQL using MS Access 2010, Excel 2010; InfoPath 2007 and 2010; Sharepoint Designer 2010

Confidential (Houston, TX)

Senior Access Developer

Responsibilities:

• Support development efforts for EPOCH Access 2003 and EPOCH Access 2010 Cost Engineering Project Management application linked to SQL Server database
• Access 2003 and SQL Server 2005 and SQL Server 2008R2 stored procedures, TSQL and SQL data scripting; utilize xSQL Object and xSQL Data compare tools
• Work in virtual remote, Rackspace Cloud, VPN, local and server environments
• Extensive report design and customization perform analysis and interpretation of financial and other data (Activity Variance reports, Cash flow Charts, Dashboard reports, Budget and Forecast Analysis reports, Summary reports); form design (data entry, tree views, import/export processes, user/group security)
• VBA code debugging; perform client patches and deployments
• Develop extensive table driven security model and tree view UI development for all Users and Groups on Project and Client levels, and functional object level security
• Assist in conversion of Access 2003 application to Access 2010.

Confidential (Austin, TX)

Systems Developer

Responsibilities:

• Design and edit existing applications in both MS Excel and MS Access 2003
• Design automated Actuals Load Process tool to import data from Excel accounting Finance File, browse for file and then looping through selected external Resource Forecast (Excel) workbooks (by Contract) and updating multiple Project worksheets with data from Resource Forecast Model Database (MS Access).
• Excel automation client, splitting data from one worksheet into multiple worksheets based on specific field filtering.
• Work on Resource Forecast Model workbooks automation and database to store data from forecasting and Actuals Load.
• Work on Gold Bid Model workbooks to store bid and proposal information by Contract and Project
• Design automated Field Test Matrices application to extract XML
• Create pivot tables of Hours by Cost Center to then create Resource Staffing bar charts and Productivity Labor and Non Labor pie charts from compiled data for quarter end reporting.

Confidential, MD

Visual Basic programmer

Responsibilities:

• Analyze 50+ Visual Basic projects for systems including Parts Description, Sensor Scan (2 versions), Hydraulics, Temp Comp, Quality, and various applications written in Visual Basic 6.0.
• Produce Visio data flow charts, and data analysis.
• Test re-compiles on multiple projects with dependent ActiveX components.
• Edit existing code: add polynomial transformation equation to calculate the difference between linear coefficients and quadratic coefficients for Sensor Scan (test stand) software; revise GUI; make enhancements for ease of use; edit and add code to write to/read from DCSC board on unit under test.
• Edit stored procedures (SQL Server 2005)
• Re-compile and re-install (including register and unregister ActiveX component files) for 50 users due to a server name change.
• Write code to read from/write to XML.
• Software used: SQL Server 2005; Visual Basic 6.0; Visio; MS Access 2003; FoxIt Reader; FarPoint Tab Pro.

Confidential (Houston, TX)

Programmer III/Tech

Responsibilities:

• Develop applications for call center and managerial support for databases (Access 2000 and ODBC Oracle)
• Develop processes to provide repayment plan history data for IVR project
• Design Disaster Relief database for Special Forbearance repayment plans
• Serve as Subject Matter Expert and provide ongoing support for Collect database and Collection Letters databases
• Design/support Loss Mitigation and provide support for Research database
• Maintain new hires, terminations and USER ID table linked to 42 databases for security
• Provide Visual SourceSafe to co-workers and Serve as Technical Lead within department
• Create Visio data flow charts and documentation
• Design interfaces to support data warehouse processes and letters (collection letters, reminders, repayment plans)
• Design queries to extract data from relational data sources into data warehouse
• Establish controls to ensure the accuracy and consistency of data; Report Development & Deployment
• Meet with department heads and end-users to gather reporting and other requirements
• Analyze requirements to create forms and reports and develop key complex business reports
• Troubleshoot scheduled processes for MS Scheduler for Access databases on multiple servers
• Create batch file release process for frontend/backend installations
• Create EOM credit reporting for 600,000+ loans to conform to Metro2 format
• Member of the Process Improvement Team: re: Stop Codes.
• Software used: Oracle i9, PL/SQL, pass-through queries, crosstab queries, VBA, Access queries, forms, reports, macros and Excel macros; automated Excel exports and email processing, and batch file version releases. Software utilized: MS Access 2000, Oracle 9i, PL/SQL, SQL Navigator, Speed Ferret, Total Access Analyzer, Visual Source Safe, MS Project, MS Scheduler, and Rational ClearQuest. Trained in FCRA, RESPA, Metro2 standards, and Introduction to Project Management.