Ms Sql Software
Resume:
Mary Dignam
ac2750@r.postjobfree.com
Certification:
Microsoft Certified Database Administrator (MCDBA) Certified Medical Billing and Coding Specialist (CBCS) #M7Z2S2L5 Microsoft Certified Solution Developer (MCSD)
Education:
University of Southwestern Louisiana Lafayette, Louisiana BS Computer Science Certified Health Information Specialist Houston, Texas American College of Acupuncture & Oriental Medicine Houston, Texas MS Acupuncture & Oriental Medicine Northam Road Teacher’s College Penang, Malaysia
AS Education Summary of Skills:
Software/Database Development: MS Access, MS Excel, MS SQL, MS Word, MS Project MS Power Point, VB / COM / COM+, ASP/ASP.Net, ADO/ ADO.Net, Visual Studio/Web Matrix, HTML/CSS, XML, PhotoShop, After Effects, Brackets, FrontPage, JavaScript, C++, Unix, IBM SPSS, Google Docs/Sheets/Slides/Forms, EndNote, RefWorks, After Effects, Premiere Pro, MediSOFT v16, CPT-4, ICD-9-CM, CMS 1500, 45 wpm, HIPAA, OSHA Experience:
9/16- 4/17 Programmer Pacific Star Corporation Houston, TX MS Access/MS SQL software development. Pricing tool, Event/KPI Management automation software. 4/15- 4/16 Program Data Management AARP Houston, TX Clean up Commodity Service Food Program data. Automate and integrate Excel spreadsheets. VBA user interface code reuse capacity for other programs (Food Fairs, Pantry, etc.). Pivot tables. MS Access data processing. 4/13- 4/14 Software Developer UHY Advisors Houston, TX Interpreting business needs, operational requirements and translating them into Excel applications for Invesco Tax Provisions department. Designed user interfaces, consolidate spreadsheets, integrate and automate applications using Excel and MS Access. Automate testing of reading text files for different data sets.
• Excel Macros, VBA Excel, MS Access, Infoquest/IBM DB2, MS SQL data base integration, Citrix XenApp 2/12- 1/13 Data Specialist Wise Men Consultants Houston, TX Integrating and automating Excel spreadsheets applications for Performance Indicators Reports at BP Control of Work/Process Area. COW Dashboard, Weekly Live Permit Report, Level 2 Risk Assessments Report, Break-in Report, Control of Work Audit Report, User deviation, task timeline scheduling.
• Pivot tables, Excel Macros, VBA Excel, MS Access, Oracle data extract from Sentinel Pro 3/08-5/08 Excel programmer Executrain Houston, TX
• Generated payroll reports at Sungard, a computer consulting company
• Utilized: pivot tables, Excel Macros, VBA Excel
• Programmed Excel to automate spreadsheets, reducing biweekly payroll prep time by over 8 hours 12/07-1/08 ASP programmer Modis Technology Group Houston, TX
• Enhanced Web portal ASP application for Wind/Solar (Green Energy) company, Element Markets, LLC.
• Generated timeline calculation using recursive programming.
• Utilized: JavaScript, VB Script, MS Access, ASP, Project management software. 1/06 -11/06 Programmer Southwestern Processors Houston, TX
• Developed Sorting, Purchase Order, Shipping, Settlements applications for Metals Resorting and Redistributing business. Enhanced Scale and Receiving applications. Designed integrated backend and front-end MS Access databases. Barcodes, Metorlogix Optimus. Designed archiving databases for transfer to MS SQL. SSIS
• Designed a more accurate and efficient inventory system.
• Streamlined the purchasing process, satisfying the metal suppliers and ensuring steady supply of scrap metals. 3/05 -5/05 Programmer Clover Systems Houston, TX
• Modified ASP.Net Starter Kit Time Tracker to meet company internal web-based timesheet application needs. VB.Net, ASP.Net, MS SQL, JavaScript. Integration with UltiPro and Great Plains databases. Visual Studio, DTS. Mary Dignam’s resume 2 / 2
10/04 -12/04 Application Specialist RSA Consulting Houston, TX
• Developed Valet Parking Garage Ticketing Issuance System - MS Access, VBA, Excel, PI xKeys Pedal USB, Bar Code 39. Check in and check out time capture for accounting purposes
• Generated Invoice Report for Speed Shore – Gupta SQLBase, Centura/Crystal Reports, Visual Manufacturing
• Customized SQL statement from Template Report to extract required invoice layout for US government agency
• Utilized: GPSS VB.Net Order Entry development – MS SQL 2000, VB.Net, ASP.Net, JavaScript
• Generated order output file for integration with Commerce One Accounting module. Visual Studio, DTS. 07/00 -06/01 Database Integration Specialist Entelligence Houston, TX
• Implemented MS SQL DTS to back up, restore, and archive databases for various departments.
• Worked with FoxPro developers on database design and usage
• Rehosted MS Access databases to MS SQL 2000. DTS
• Reduced excess temporary tables to improve system resource usage using Index Tuning, Performance Monitor
• Restructured store procedures to improve performance MS SQL Database Development support for Planners Project
• Designed online hotels and meeting reservations application using MS SQL, ADO, and VB COM
• Developed logic for dynamic search criteria
MS SQL Database Integration for Framelogix Ecommerce
• Developed Ecommerce’s proprietary application using MS SQL, XML, ADO, and VB COM+ for shopping cart order and partner components. Generated custom invoice reports. DTS.
• Integrated Great Plains with Ecommerce’s proprietary application. DTS. 04/99 -07/00 Computer Consultant US Interactive Houston, TX
• Maintained MS SQL 6.5/7.0 production databases for domain, entity, referential and business rule based integrities
• Customized the MSDN FMStocks sample for the Mail Out ASP application
• Corrected Late Fee calculation for invoicing and accounting purpose
• Ported and customized existing Net Dynamics Java front and middle tier to a new application for Texas Alcohol Awareness Testing and Administration. Updated and maintained Department Public Safety drivers database with more than 16 million records.
09/97 -06/98 Computer Consultant Metro Information Systems Houston, TX
• Developed intranet software in 3 tier system using ASP, ADO, and VB COM
• Developed foreclosure reporting using ASP/ADO/Unix Oracle on NT 4.0/IIS 3.0 with integration of other data sources from Sybase Open Client/System 10 and AS400 Active X access components. 11/95 -09/96 Computer Consultant Berger & Company Houston, TX
• Redesigned Project Management Software and Help Desk Software in Access 2.0 and Access 7.0 for Brown & Root
• Rewrote Gas Compression Software from GWBasic to Visual Basic 3.0 in Access 2.0 for Production Operators Inc. 06/94 -12/94, 10/99 Software Developer Zytek/Truc Nguyen companies Houston, TX/Irvine, CA
• Designed and developed inventory system, accounts receivable/payable with MS Access 2.0 (Paging system)
• Web & intranet development for company’s products and internal accounting purposes (Turbo Star, Biometrics) 10/89 -11/95 Senior Software Engineer Unisys Space Systems Houston, TX
• Developed and modified flight simulation software and GUI interfaces using C++, FORTRAN, UIMX/X Windows, and awk scripts. Ascent, Navigation, Payload departments. Shuttle, MIR and ISS.
• Provided MS Access trainings to company employees
• Maintained department’s performance charts for Team Excellence Oregon Matrix information 04/88 -08/89 Programmer Analyst II Expert Database Marketing Systems Irvine, CA
• Developed extensive sorting /matching database software for demographics & marketing, using Fuzzy Logic
• Tested software sorts versus firmware sorts with Microsoft C, MS DOS batch scripts, and utilities 09/87 -03/88 Computer Consultant Stratavision Westlake Village, CA
• Developed computer aided marketing with StoryBoard Plus
• Developed Electronic Medical Billing System (NEIC), a PC-Mainframe system using MSDOS & Cobol
• Installed and tested Votan/Dragon Systems’ voice recognition software
• Initiated PC-Mainframe file data transfer for sales data collection and products analysis
• Lotus 123 spreadsheets integration with database from Dbase III for Coca Cola Los Angeles
Contact this candidate