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.