OBJECTIVE:

Access & Excel Developer/VBA/Software Engineer

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 b)MS Access Advanced, SQL. c)Oracle. d)FOCUS Programming. e)Visual Basic 6.0 Programming f)Adobe PhotoShop g)Turbo Pascal Programming h)MS Word i)MS Power Point j)Visio k)Numeric Analysis l)Digital Image Processing m)Calculus Finite Mathematics n)Mathematical Analysi
• 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
• In charge of developing, creating, updating and maintaining internal tools as:
• ASCII Generator Tool.
• ASCII Comparison Tool.
• FRID’s Analyzer Tool.
• Formulary Query Tool.
• CMS Deletion Tool.
• PNAT Tool or CNAT Tool.
• 2PDF Converter Tool.
• PTOC Tool.
• 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 in Confidential site in San Diego and Japan.
• 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 (over 3000 leases).
• 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.