It Consultant Resume
Jersey City, NJ
SUMMARY:
- To obtain a position where I could utilize my knowledge and experience of Data Analyst / Programmer.
- 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 front-end application design, coding and backend database linking
- Applications for AutoCAD 14/2000 /2004/2007 (AutoLISP, VBA)
- Applications for Bentley Microstation V8 (VBA)
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
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.