SUMMARY

Experienced in design, data modeling and reporting, data warehousing, development and testing programs for business and scientific applications, utilizing databases and programming languages. Results-oriented and self-motivated.

PC, IBM mainframe
Windows 2000/ 98, Windows NT, MS-DOS 6.0/5.0, OS MVS/TSO
ERwin, ER/Studio, VISUAL BASIC 5.0/4.0, Crystal Enterprise/Seagate Info 7.0, Crystal Reports 11/6.0, Business Objects, VSS 4.0, ORACLE 8i/9i, MS SQL Server 2005/ 6.5, MYSQL, SSRS 2005, MS ACCESS, MS EXCEL, PowerPoint, PARADOX, dBASE IV, SQL, T/SQL, PL/SQL, C, CLIPPER, FORTRAN

Confidential,Sunnyvale, CA 10/07-04/09

• EAG is the largest, fully integrated and independent materials characterization and surface analysis organization in the word, serving more than 2,600 active client companies across 35 countries with over 20 locations throughout the United States, Europe and Asia.
• Worked in a cross-functional role facilitating and gathering requirements for internal Reports, interacted professionally with a diverse group, managers and subject matter experts, utilizing SQL Server 2005 Database and Reporting Services and Visual Studio 2005 in .NET 2.0 Framework.
• Worked with Excel VBA application and macros to convert Excel Reports to SSRS 2005 Reports as well with Excel pivot tables and reports and Lookup functions.
• Developed complex Reports based on stored procedures, views, with sub reports and with charts in a fast growing and changing environment with the largest fleet of surface analytical instruments and the broadest range of techniques.
• Reports reflected all spheres of EAG Labs activities analyzing Revenue by Fiscal year and month, by labs region and country, by service and technique. Reports represented statistical data related to number of samples arrived, jobs performed and jobs invoiced on a weekly and monthly basis

Confidential,Foster City, CA 04/06-09/07

• Gilead Sciences, Inc. is a research-based biopharmaceutical company that discovers, develops and commercializes innovative medicines in areas of unmet need. With each new discovery and experimental drug candidate, Gilead Science seeks to improve the care of patients suffering from life-threatening diseases.
• Gather Reports requirements and develop very complex CAPA, Documents Control and Training Reports utilizing Crystal Reports 11 and SQL Server 2000 views and stored procedures.

Confidential,S. San Francisco, CA 12/0--02/06

• Developed internal statistics reports related to the new product, utilizing Crystal Reports 10 and Oracle 9i (DataMart) stored procedures and views.

Confidential,Concord, CA 11/04-09/05

• ERG is an Australian - based company and employs over 900 people in 11 countries.
• ERG Group is a word leader in the development and supply of integrated fare management and software systems for the transit industry, and for its smart card systems and services.
• Develop custom Reports from Metrix 4e Support Center Web based application.
• It is the most comprehensive, feature-rich support center application in the industry; going far beyond call-taking to give customer the ability to dispatch and manage field service operations and perform service in conformance with warranty and service contract agreements.
• Gather Reports requirements and develop custom Reports:
• Asset Management Reports: Device Life Cycle History, Stock and Install Reports as well as Vandalism and Asset Summary Reports.
• Performance Measurement Methodology Reports: Availability and Reliability all devices as well as smart cards on weekly and monthly basis, utilizing Crystal Reports 10 and Oracle 8i Database. All Reports based on stored procedures and corresponding packages and global temporary tables.

Confidential, Hercules, CA 06/04-08/04

• Developed Financial, Sales, Purchase Order and Inventory Reports utilizing Crystal Reports 9 and 10 and Oracle 9i Database via Baan driver.
• Deployed, published and scheduled reports on company intranet using Crystal Enterprise.

Confidential,Emeryville, CA 11/03-04/04

• Pinnacle Rock Associates is a System Consulting and Development firm specializing in the Retail Industry.
• Worked in a team of talented professionals creating the leading edge solutions for our clients developing Web as well as Windows based applications.
• Worked in the Visual Studio.Net environment and with MS SQL Server 2000 Enterprise Manager.
• Developed Merchandising, Order Entry and Management, Product Information Management System Reports utilizing Crystal Reports 9 and SQL Server 2000 views and stored procedures.

Confidential,Sunnyvale, CA Database and Data Warehousing Development (Certified Training Program)

11/02-08/03

• Crystal Reports 9/ Enterprise (OLAP/CUBE), Oracle and SQL Server Enterprise Manager, ERwin, ER/Studio, Brio.

Confidential,Berkeley, CA Programmer/ Financial Analyst

10/00-08/02

• The Public Health Institute (PHI) provides administrative and technical assistance, support services include accounting and financial management; development support; contract and grant administration and others.
• Worked in IT department developing main Financial and human resource Reports (Lawson System) regarding budget and expenses information as well as tracking employees and payments information utilizing Seagate Info 7.5 (Crystal Reports 8.0), Access, Excel, PL/SQL and Oracle 8i Database.
• Suggested a new approach to the design of the main financial reports, which significantly improved their performance (they were generated much faster then before), and they were successfully deployed over the Internet.
• Reports were based on complex views and stored procedures, which required intensive use of PL/SQL for developing Oracle Packages and Stored Procedures. Huge database, hundreds of tables and millions of records.

Confidential,CA Report Developer/ Financial Analyst

05/00-09/00

• Developed accounting, marketing, sales and actuarial reports for California Automobile Association utilizing Seagate Crystal Reports 7.0, PL/SQL and Oracle Database.
• Provided ad hoc financial analysis, forecasting and reporting.

Confidential,Redwood City, CA Report Developer/ Financial Analyst

04/99-05/00

• Developed standard and custom (accounting and financial) reports for Adecco - the word\'s largest staffing company with 5000 offices around the globe, utilizing Seagate Crystal Reports 7.0, Visual Basic 6.0, VSS 6.0, MS SQL Server 7.0 and MS Access and Excel 7.0. Exported Reports to Excel format for more detail analysis and calculations.
• Converted Reports to run on Internet against SQL Server 7.0 database tables and stored procedures: reports were displayed using the Crystal Web Reports Server with parameters supplied by an HTML form created by Active Server Pages (ASP).

Confidential,Lafayette, CA Programmer

07/97-02/99

• Worked as a Programmer for a software company developing a client/server, multi-user application utilizing Visual Basic 4.0, VSS 4.0 and MS Access and Excel and SQL Server 6.5 database.
• Application was designed to develop data automation systems specifically for ambulatory surgery centers and included Scheduling, Billing, Inventory, Security and Report modules
• Developed reports using Crystal Reports 5.0/6.0 based on complex views and stored procedures. Linked reports to a table-driven report writer application using the Crystal Report Engine API.
• Worked directly with clients on gathering reports specific requirements as well as end user training and providing support and troubleshooting. Collect and analyze medical, pharmacy, and laboratory claims data to identify potential risk algorithms.
• Wrote SQL Scripts to convert data from dBase file format to SQL Server using BCP utilities. Worked on building data integrity and standardization through system integration.
• Enhanced the existing Visual Basic application by adding new user requested modules.
• Participated in \"Black box\" and \"White box\" front-end main application testing.

Confidential,CA Programmer

04/97-06/97

• Worked as a Programmer for VentureOne, the leading investment research firm serving the venture capital industry, providing information products and services to many of the nation\'s leading venture capital firms, growth companies, investment banks and other related professional service providers.
• Developed enhancements to internal system, which uses Access 7.0 as a front-end to SQL Server 6.5 and Visual Basic 4.0 Application. Produced Custom Reports for clients and internal use.

Confidential,Carlos, CA Programmer

03/96-03/97

• Performed analysis, design, programming, implementation and maintenance of client/server, multi-user relational database system utilizing ERwin, Visual Basic 4.0 and Access 7.0 as a database engine. The program was subsequently converted to MS SQL Server 6.5 (ODBC).
• Project included data modeling (ERwin), table design, form design, report design, testing and maintenance.
• Used third-party Custom Controls TrueDB Grid, Sheridan, and Crescent.
• Handled all front-end coding including embedded SQL.
• Primary focus of the project was to track employees, projects and employees\' hours information.

Confidential,San Francisco, CA R & R Report Writer

11/95-02/96

• Worked as a Reports Developer for the Academic HealthCare Division using the R & R Report Writer tool and referencing the client database and interface, Columbus.
• Researched and compiled report specifications, created report templates, developed test data when needed.
• Troubleshooting report generation problems and supported clients with report issues.

Confidential,Emeryville, CA QA Engineer

06/95-08/95

• Tested the industry first commercial software support system designed to help reinforce and implement effective performance management concepts.
• Developed test plans for assigned functional areas of the product.
• Reviewed documentation and made sure that it accurately described product functionality.
• Entered bugs into the bug tracking database (MS ACCESS 2.0) and followed bugs through to the final resolution.
• Did regression testing, user interface testing under Windows 3.1, Windows 95 and Windows NT.

Confidential,Berkeley, CA QA Analyst

12/94-03/95

• As a QA Analyst (black box testing), tested \"risk management\" software under DOS and Windows 3.1
• Tested for compliance with specifications, did regression testing, user interface testing, and integration testing.
• Wrote and carried out test plans. Prepared written bug reports, and worked with software engineers on bug resolutions. Prepared written summaries of the projects.

Confidential,San Francisco, CA Database Programmer

1992-1993

• Created database using relational database management system for Windows 3.1-Microsoft Access.
• Was responsible for data integration and structure definition
• Designed data entry forms for payroll and developed a variety of customized reports which kept track of employees\' projects and money allocations.

Confidential,Odessa, Ukraine Programmer/Researcher

1978-1991

• Designed, developed, maintained and administrated database of thermodynamic properties of freons, hydrocarbons, oil fractions, atmospheric gases and other substances.
• Designed computer simulation of P-V-T systems behavior and approximated experimental properties of gases, liquids, and mixtures.
• Created programs to develop new Equations of State, based upon experimental data and the results of the computer simulations.

VB Programming for Windows,
Introduction to ORACLE Tools,
Using UNIX Operation System
B.S. in Applied Mathematics and Physics,
B.S. in Computer Science,