PROFESSIONAL SUMMARY

Programmer with extensive experience working with companies to extract, retrieve and summarize data, website management, applications development, and user assistance with various computer software. Ability to communicate technical expertise to variety of stakeholders, organize projects and provide excellent customer service both in person and through written communications.

TECHNICAL SKILLS

Excel VBA , Oracle PL / SQL, Oracle Objects for OLE OO4O , SQL Server 2005 T-SQL , ODBC, Access, JavaScript, XHTML, CSS.

EXPERIENCE

Confidential

Excel Programmer, Web designer

• Working for the Director of Administrative Services cleaned and organized data in SalesForce using Excel spreadsheets and VBA. Work was done remotely.
• Helped maintaining the organization websites using Wordpress.

Confidential

VBA Excel Developer Consultant

• Working for the Director of Credit Card Business Quality Assurance and Test Account Management and Support wrote program to keep statistics of testing results. Data was retrieved from Oracle and presented on Excel spreadsheets.
• Wrote technical specifications for the program.

Confidential

Excel Specialist Consultant

Working for the Vice-President wrote VBA scripts that pushed data from multiple workbooks to forms used by underwriters working with multifamily and commercial real estate loans. Forms were submitted to HUD, Fannie Mae and Freddie Mac.

Created charts and input forms in Excel according to user specifications. Wrote formulas to link workbooks and spreadsheets.

Formatted spreadsheets, documented changes and additions. Tested macros, formulas and links.

Confidential

Instructor

• Taught computer classes Windows, basic Word and Excel to students from the consulate of Ecuador.
• Proctor / Examiner for the State of New York GED Testing Program
• Helped administering the GED test. Ensured students had the proper test form, prepared documents for tracking attendance and tests taken, packed documentation and tests to send to the New York State Department of Education.
• Wrote VBA script to track test attendance and print documents. Supported and helped staff using Excel and Word.

Confidential

Excel / Oracle Consultant

• Wrote Excel / VBA scripts to read data from spreadsheets and prepared it for upload to Oracle. Scripts cleaned the data remove quotes, dashes, etc. , verified it against the company databases and reformatted it before upload using PL / SQL.
• Prepared ad hoc reports and data entry screens in Excel. Using macros and Oracle Objects for OLE OO4O inserted data in Oracle.

Confidential

Excel / SQL Server Consultant

• Using ODBC and Excel / VBA wrote scripts to upload data from Excel to SQL Server. Wrote queries to prepare reports in Excel and reports that were presented on a browser HTML .
• Updated tables to synchronize databases with data kept in Excel and other databases.
• Wrote step-by-step instructions for the installation of in-house programs and restoration of databases.

Confidential

Document Management Consultant

• Reviewed and scanned Case Report Forms, CRFs and related drug trial documents. CRFs are questionnaires filled out by patients when testing a new drug .
• Using Adobe Acrobat cross referenced CRFs with bookmarks and links. Prepared documents for FDA submission.
• Wrote Excel VBA ad hoc scripts for internal use.

Confidential

Excel / Oracle Consultant

• Using SQL Navigator wrote PL / SQL code to search data, update tables and to execute scripts and stored procedures.
• Wrote Excel / VBA scripts and SQL code to automate the retrieval and updating of research data in Oracle and Access. This was needed to synchronize Wyeth internal databases with study data captured by the program Activity Base.
• Prepared reports according to specifications for other departments within Wyeth. Reports were done using Excel / VBA with data from Oracle using SQL and Oracle Objects for OLE OO4O .
• Transferred Activity Base protocols from development to production, set up fields in the database, gave access rights to scientists, did minor changes to templates.
• Helped updating text documents with experiment descriptions, prepared presentation slides and flowcharts using PowerPoint.

Confidential

Helped customers to set up computers, replaced parts and installed software.

Confidential

Web / Intranet Developer

• Designed, wrote and tested Intranet applications using MS-SQL Server, ASP, Visual BASIC, HTML, CSS and Crystal Reports.
• Created tables and wrote stored procedures and queries using MS-SQL Server Enterprise Manager to add, edit and retrieve data.
• Supported all applications above and assisted the support team with software and hardware issues.

Applications Programmer

• Using Delphi wrote and tested menu driven applications to read, validate and transfer scanned survey data to Oracle databases.
• Wrote macro-driven Excel applications to automate the collection of enrollment figures kept in Access tables.
• Prepared status and ad-hoc reports using Crystal Reports and Excel. Using ODBC retrieved data from MS SQL Server, Access and Sybase.

Confidential

Delphi Programmer

• Used Delphi to prototype and write custom accounting programs that interacted with the accounting packages Platinum and Dynamics Great Plains using BTrieve tables.
• Designed and wrote small Delphi applications for in-house use. Data in these applications was kept in dBase and Access databases. All development was done in Windows 95/98 and Novell networks.

Confidential

Delphi Programmer

• Worked very closely with users in the design and prototype of an inventory/accounting package for Durable Medical Equipment in Windows 95.
• Wrote working prototypes showing screens and program flow.
• Wrote documentation explaining system functions and processes.

Confidential

Paradox Programmer

• Wrote and maintained multi-user data entry applications written in Paradox DOS . Used SQL code embedded in Paradox to query Sybase tables.
• Interviewed users and wrote ad hoc programs to produce reports for different units within Covance. Wrote specifications, manuals and validation documents required by the Food and Drug Administration.

PowerBuilder Programmer

• Wrote data entry applications written in PowerBuilder / Sybase.
• Wrote SQL code to create reports as requested by management. Used DB Artisan and SQL Programmer to access Sybase tables.