We provide IT Staff Augmentation Services!

Excel And Access Developer Resume

San Diego, CA

SUMMARY:

Access & Excel Developer/VBA/Software Engineer

SKILLS SUMMARY:

  • Technical Management, Software design and development process.
  • Expertise in Windows 98, 95, 2000, XP, Windows Vista, Windows 7, MS Office suite of products 97, 2003, 2007, 2010, 2013 VB for Applications.
  • MS Access, SQL and Visual Basic for Applications Database development, Business Objects.
  • MS Excel, Macros and Development.
  • MS VISIO 2003, 2007, 2010
  • Expertise in relational database management systems.
  • Strong Computer Knowledge, strong analytical skills.
  • Excellent interpersonal and communications skills, proactive and responsive.
  • Bilingual, Spanish

TECHNICAL SKILLS:

  • Excel, Visual Basic, Macros
  • MS Access Advanced, SQL. Oracle.
  • FOCUS Programming. e)Visual Basic 6.0 Programming
  • Adobe PhotoShop
  • Turbo Pascal Programming
  • MS Word
  • MS Power Point
  • Visio
  • Numeric Analysis
  • Digital Image Processing
  • Calculus Finite Mathematics
  • Mathematical Analysis
  • Statistical Analysis.
  • Business Objects.

EXPERIENCE:

Confidential, San Diego, CA

Excel and Access Developer

Responsibilities:

  • Debugging and update current Excel database and Macros, using VBA, creating functions and user interface for Sales department.
  • Designing, Debugging and updating current Access database using SQL, Recordset, in Module VBA and creating queries Access system to get pricing structure in place.
  • Plenty experience in ADO, DAO data access interfaces of accessing data.
  • Using Visual Basic to control the connection, statement builders, and returned data for the user.
  • Building out Access, VB and Excel Macros to the Database to make changes and alterations. It is for their pricing structure database
  • Develop new projects in Excel and Access according to the user needs in the Sales department.
  • Using Word, Powerpoint and Visio to create reports and flowcharts.

Confidential, San Diego, CA

Access Developer

Responsibilities:

  • Design an Access database drafted to take various information streams coming from manufacturing operations.
  • This database is written around defect tracking and calculating rolled throughput yield.
  • A substantial portion of the output of this database is Pareto Charts, Trend Analysis and/or Histograms that help our Engineers turn the data into actionable intelligence to select and prioritize projects and continuous improvement ideas.
  • This Database is to have our manufacturing personnel (Line Leads, Repair Technicians, Supervisors) input the data into a common “universal” Access database where the Engineers will be able to call up the file and generate outputs and watch for trending.
  • Create Manual for this project With MS Word and also developing forms as a guide for the users.
  • Create flowchart using MS Visio application.
  • Database created using Modules with VBA (Visual Basic for Applications) using ADO and DAO data access interfaces, using queries, macros, and VBA procedures.
  • Designing forms to get a friendly GUI (Graphic User Interface).
  • Experience with Excel (Macros and queries using data analysis tools and VBA Modules), Business Objects database structures, exporting data, data processes/flows.

Confidential, San Diego, CA

Access Developer/Independent Consultant

Responsibilities:

  • Design an Access database to import *.txt, *.csv, *.xls, *.xlsx format files from the information related to International Customs system.
  • Design a friendly Graphic User Interface, where customer can create custom reports and export to excel format and also creating Charts to include in the report.
  • Technical support in the process to download the raw data from SAP system and work with Ad Hoc data.

Confidential, San Diego, CA

Access Developer/Software Engineer

Responsibilities:

  • Develop, create, and modify general computer applications software or specialized utility programs.
  • Analyze user needs and develop software solutions.
  • Design software or customize software for client use with the aim of optimizing operational efficiency.
  • May analyze and design databases within an application area, working individually or coordinating database development as part of a team.
  • Working in the Emergency Needs Team in Formulary Services Government Department.
  • Collecting, receiving, obtaining data, identifying pertinent information, and preparing clear and concise reports which reflect understandable data analysis results.
  • Programming in VBA Modules for Access using ADO, DAO, Excel, Macros.
  • Experience with Excel, Access, Business Objects database structures, exporting data, data processes/flows; creating databases, tables, Macros and queries using data analysis tools and VBA Modules.
  • Importing and Exporting ASCII Delimited Text, Comma Separated Format, Excel files.
  • Creating, Analyzing, debugging and updating Formulary Databases.
  • Designing GUI (Graphics User Interface) for inside and outside Government Customers for PART D Type
  • PL/SQL development.
  • STAR TEAM Software.
  • TOAD software.
  • Oracle environment, creating own schemas to development, QA and production.
  • Knowledge in ODBC Databases.
  • Creating Flowcharts Diagrams for Tool Documentation in VISIO.

Confidential, San Diego, CA

Access Developer/Data Analyst

Responsibilities:

  • Working in the CS - 21 Department tracking and Designing Reports for all Confidential items to report to managers using Crystal Reports, Business Objects, SQL, ACCESS, EXCEL, VBA, SQUID and PowerPoint.
  • Creating PowerPoint presentations and Excel charts in the reports for customers.
  • Debugging and Updating Databases that we have in site to easy handle and downloading raw data to the best way to work with it.

Confidential, San Diego, CA

Data Analyst/Access Developer

Responsibilities:

  • Managed the conversion of property records from an Access database to the Oracle Property Manager application.
  • The conversion required the ability to quickly learn a new data load application, the functional aspects of the PM application, and the fasted way to correct errors that were encountered.
  • After the initial load of the data, I was responsible for on-going corrections to the data.
  • This included creating multiple access queries to compare legacy data to converted data, using the Oracle applications for corrections, and identifying anomalies.
  • I worked closely with the implementation team during this effort.
  • I was retained after the other data conversion people completed their assignments due to my ability to quickly learn and my attention to detail.
  • Working with Excel, Access, SQL, Data Load Software and Oracle.
  • Report to management on the progress of the project.

Confidential, San Diego, CA

Access Developer/Data Analyst

Responsibilities:

  • Creating reports for ITD (Information Technology Division) in Excel and Access using Visual Basic for Applications.
  • Creating Queries based on SQL language and VBA.
  • Creating Modules based on Visual Basic.
  • Creating Reports and Documents with VISIO Software.
  • Import/Transfer Files from Business Objects to PC to work with Access Databases.
  • Creating Reports in Business Objects.
  • Updating and Debugging Databases.

Confidential, San Diego, CA

Closing Assistant/Access and Excel

Responsibilities:

  • Creating EXCEL FORMS for Mortgage Consultants in the Loan by Phone Department.
  • Working with Mainframe software extracting information for Loan Representatives using RUMBA.
  • Using MS EXCEL AND ACCESS to create databases to keep information updated.
  • Auditing and Updating Information in Fund Department.
  • Enter Appraisal, Escrow and Preliminary Reports Information to the System.

Hire Now