MS Access Developer/ Data Analyst Resume Profile, Lithonia, GA

Reference Id: 8765     Posted on Saturday 7th March 2015      Microsoft

Please note that this is a not a Job Board - We are an I.T Staffing Company and we provide candidates on a Contract and Full-time basis. If you need I.T.Professionals to fill a Contract or a Full-time Position, please call (800) 693-8939

MS Access Developer/ Data Analyst  Resume Profile, Lithonia, GA


  • I am a highly motivated selfstarter who is eager to learn and assume increasingly greater responsibility I am capable of performing multiple tasks while maintaining my focus on meeting deadlines and quality of work standards I have proven software experience in administrating and using Adobe over 15 years experience utilizing Microsoft Office Suite Microsoft Windows XP SQL Server 2000/2005/2008 MS Access MS Excel ASP VBA ADO DAO ODBC Crystal Reports XI DTS SSIS JavaScript and HTML I am confident in my problem solving skills when working in teams and on solo projects My oral written and listening skills are exceptional
Selected Employment
MS Access Developer/ Data Analyst Confidential

  • Designed and developed a mail merge application using MS Access VBA ADO and SQL
  • Responsible for the management of the database performance backup replication capacity and security
  • Designed and developed an Employee Tracking System using MS Access VBA DAO ADO and SQL
  • Designed and developed technical specification for data migration
  • Performed data migration from MS Access to SQL using DTS VBA and ADO
  • Built data input and designed data collection screens Managed database design and maintenance administration and security for the company
  • Analyzed massive and highly complex data sets performing adhoc analysis and data manipulation
  • Monitored database systems to ensure data integrity
  • Created extracted and maintained queries and reports using Crystal Reports
Programmer/Data Analyst Confidential

  • Designed developed documented and implemented a Claims Tracking application using MS Access VBA ADO DAO and SQL
  • Created/ Modified documents such as Dec Pages Endorsements Billing Notices and Cancellation Notice using Crystal Reports and SQL
  • Performed all support functions associated with the collection quality checking and trending of data that is used for measuring the effectiveness of the IT department
  • Responsible for creating daily/weekly/monthly reports and metrics that measure success/failure ratio of production reports as well as monitoring database backups using Crystal Reports
  • Administered organized modified as well as troubleshoot reports using Crystal Reports XI
  • Maintained accurate daily and monthly metrics for the Data Services department including production uptimes server/disk utilization inventory and help desk calls
  • Used software applications such as Access Excel and PowerPoint to assemble manipulate and format data for the creation of databases and reports
  • Verified data integrity by executing stored procedures in SQL to authenticate statistics
Programmer Analyst Confidential

  • Designed developed documented and implemented an invoice tracking system to upload invoice information from clients to track if an invoice item was paid open completed or cancelled using MS Access VBA ADO and Oracle
  • Developed specs for an Online User Request System OURS for users to submit system requests adhoc reports etc via the web using ASP Javascript VBscript AJAX and Oracle

Programmer Analyst Confidential

  • Designed developed documented and implemented an Accounting General Ledger system to calculate complex algorithms for data migration using MS Access SQL ADO DAO and VBA
  • Developed a Check Request System to for the Claims Department using VBScript ASP Visual InterDev JavaScript MTS COM SQL ADO and Visual Basic which allows the data to migrate to the General Ledger system for check processing
  • Built a frontend positive pay interface for extracting check stock information from the General Ledger system to upload to appropriate financial institution using MS Access VBA ADO and SQL
  • Developed designed documented and implemented Work Tracking System using MS Access and SQL Server to track new business renewals and policy change transactions
  • Analyzed coded and maintained legacy system applications
  • Handle departmental requests for system changes including reporting applications and troubleshooting
  • Created frontend interface to extract data from SQL to Pervasive SQL Platinum GL System
  • Provided deliverables in the form of database designs information models data migration plans and/or data warehouses using Visio and MS Project
  • Collaborated with Management/Project Manager and development team to document how to create/enhance/modify data load scripts to accommodate changes in production
  • Communicated with management to obtain proper information for data migration process
  • Collaborated with internal customers for data cleansing and enhancement
help Desk Technical Analyst II Confidential

  • Provide 1st level support for 6000 endusers on Windows 95 98 and Windows NT 40 workstations connecting to Windows NT server via LAN and RAS
  • Troubleshoot and configured dialup networking MS Outlook/Exchange and modem configuration
  • Provide support on all MS Office products
  • Primary support for MS Access 97 to 2000 migration troubleshoot and resolved database issues
  • Developed and maintain frontend interface in MS Access to streamline the incoming call process Database was developed to extract data from case management system and populate information into Clarify
  • Performed network account administration with combined NT and Netware authentication

Search Resumes

Looking for I.T Professionals on a Contract basis?