SUMMARY:

To obtain a position where I could utilize my knowledge and experience of Data Analyst / Programmer.

COMPUTER SKILLS:

Systems: MS Windows, MS DOS, Mac OS

General Tools: MS Office, Adobe, MS Visual Studio

Special Tools: AutoCAD, Bently Microstation, Matlab, Mathcad, SPSS

Data Mining: Statistics, Quantitative Analysis, Metadata Design, Factor and Pattern Analysis

Custom ETL: Data Format Analysis, Stored Procedure Programming, GUI Design

Warehousing: Data Marts Design, Tables Normalization, Data Reporting

Primary Languages: SQL, VB6/VBA/VB.NET, Fortran

Supplementary Languages: C/C++/C#, HTML/XML/XSLT, Java

Databases: MS Access, MS SQL Server, Personal Oracle7

Large data sets manipulation: in MS Excel and MS Access

Data collection: summarizing, processing and results analysis

ETL data: from ASCII automatically generated files

MS Excel formulas: (sumifs, vlookups, nesting) creation and utilization

MS Excel charts: and pivot tables manual and programmatical creation

SQL queries: ad hoc generation in Excel/Access/SQL Server/Oracle

SPSS usage: for data tabulation and statistical analysis

Mathcad spreadsheets: development and usage

MS Access / VBA database: design, programming, support and data analysis

MS Excel / VBA spreadsheets / macros: programming and calculation models development

MS Access / Excel / Word: integration, connection and linkage

MS Outlook / VBA application: design, development and maintenance

MS Access: external databases (MS SQL Server, Oracle) linking and connection

VB6 / VB.NET frontend application: design, coding and backend database linking, Applications for AutoCAD /2007 (AutoLISP, VBA), Applications for Bentley Microstation V8 (VBA)

Applied Mathematics, Operation Research, Quantitative Analysis: Physics, Engineering Science, Civil / Environmental Engineering, Earth Science

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

IT Consultant

Responsibilities:

• Design Excel applications for Banking Reporting System
• Write VBA macros for data statistical analysis and clustering
• Program charts and diagrams for automatic data presentation

Confidential, New York, NY

Senior Engineering Developer

Responsibilities:

• Analyzed systems requirements and design engineering desktop applications
• Developed technical software for engineering and management using VB, VB.Net, Fortran
• Designed database and related applications using MS Access, Personal Oracle 7

Confidential, New York, NY

Adjunct Instructor

Responsibilities:

• Lectured in Fundamentals of Computer Science, Mathematics and Statistics
• Taught courses in Visual Basic, SQL, Windows 95 and MS Office.
• Trained students in Data Processing and Computer Operations.

Confidential

Senior Scientific Programmer

Responsibilities:

• Supervised Engineering Computation Group, managed Wndows3.11 workgroup
• Developed software for numeric computations using Basic and Pascal
• Worked out methods of computer - aided engineering, performed mathematical modeling

Confidential

Adjunct Faculty

Responsibilities:

• Lectured in Computer Science and Computational Mathematics
• Taught courses in Turbo-Pascal, Basic and MS DOS
• Developed scientific computer applications and tutorial programs

Confidential

Computer Scientist

Responsibilities:

• Developed software for hydrodynamic research using PL/1, FORTRAN-77, C
• Designed and coded programs for experimental data collecting and interpretation using Pascal, C
• Performed computerized analysis and mathematical simulation

Confidential

Engineer/Programmer

Responsibilities:

• Developed computer programs for engineering calculations using FORTRAN
• Designed computer-aided engineering system using PL/1 and Pascal.
• Collected the data for computer database.