Niko Stavropoulos
Chicago, IL 60656
(773) nnn-nnnn
Over fourteen years programming experience in both business and scientific arenas.
· Proficient at PL/SQL, Perl, ksh, and Oracle. Expert at Manugistics tables, stored procedures, and scripts.
· Expertise in C/C++, Java, and relational databases. Experience in Bioinformatics, and theoretical physics.
· Masters in Physics. BS in Computer Science and Biology.
· Easily learn new information systems and programming skills. Actively involved in programming since 1983.
SKILLS
Languages: C (14), C++ (12), PL/SQL (6), ksh(14), csh(14), Perl(3), SQL (8), Visual Basic (6), (years experience) Javascript (5), VBScript (5), ASP (5), CSP (4), Java (3), Assembler (4),
Pascal (2) , Fortran (4), COBOL (1), JCL (1), ASP.NET (1), C# (1)
Operating Systems: Windows XP/2000/NT/98/95, Linux, Unix, DOS, CMS, VMS, Unicos, Mac OS
User interfaces: Window,
MFC, X-windows, Motif, Xt lntrinsics,
OpenLook
Databases:
Oracle 9.2, Oracle 8.1.7, SQL Server, RedBrick,
SyBase
Misc
Software: Visual
Studio .NET and v 6.0, Crystal Enterprise 8.0 / 8.5,
MicroCal Origin, 3d Studio Max
Other: Install
Shield, OCX, ActiveX, ATL, STL, COM, DCOM, Toad, PVCS, Source Safe,
PowerPoint,
Microsoft Word, Microsoft Excel, Microsoft Access,
Manugistics, McHugh, Red Prairie
Senior
Analyst Applications Development
·
Caremark:
o
Participated in the EPPM Project.
This stands for Enterprise Project Portfolio Management. It consisted of migrating resource and project
information from two different project management software packages to the CA (Niku) Clarity project management web based tools.
§
Tools used:
·
Visual Studio .NET 2005 C#, C++.
·
Aqua Data Studio v4.7.2 to access the remote Oracle Clarity
database.
·
Oracle to access the underlying data tables within Clarity
·
SQL Server to Heat and Planview tables
·
Access 2003 SP2 in Parte extract
·
XMLSpy to analyze the validity of the XML data
generated.
·
UltraEdit v9.0 to sort the final XML file correctly.
§
Several data interfaces were created to facilitate the near real time
transfer of requests from Heat. This
resulted in the creation of Incidents in Clarity along with assignment and
status updates to these Incidents from either end. C++ was used for the interface. Analyzed COBOL code to retrieve logic for
default values when transferring data from Heat to Clarity.
§
Convert 1400 resources from Planview and
Parte to resources in Clarity.
Downloaded entire LDAP directory to extract user information that
matches new Clarity resources. Extensive
name matching on data between these three systems and PeopleSoft.
§
Analyzed the data structures and table of projects and resources in a Planview project management database. Mapped how these data items relate to the
data attributes within Clarity. The
method of transfer of data into Clarity is XML via Clarity’s XML Open Gateway
or XOG. A combination of SQL queries and
Microsoft Visual Studio .NET were used to generate the XML files required to
transfer data to Clarity. The data was
hierarchical and required an SQL with 11 self joins to format the data for XML
output. 706 Planview projects were converted to Clarity
projects.
§
Similar analysis was required for the Parte. This was a home grown project management
database. Many custom attributes were
required for Clarity to absorb these projects as well. There was a total of 4919 project convert to
Clarity.
§
Analyzed Lotus Notes scripts for old Work Request system to determine
how to communicate between it and Clarity for creation of Incidents. Later I advised that it would be better to
replace this system with Incidents that is built in to Clarity.
§
Converted 409 project to Clarity for their
2007 Plan from an Access database call Cupid.
Senior
Systems Engineer
·
Conagra:
o
Participated in the Manugistics 7.2 upgrade
project.
§
Updated 22 stored procedures to handle the new table layouts in Oracle
9.2.
§
Updated 7 more stored procedures to handle character-set issues between
a WMS system, Red Prairie and Manugistics.
o
Wrote custom perl scripts with a ksh wrapper to load accrual and allocation flat files into
Oracle tables for the purpose of comparing the data accuracies before and after
input to a
o
Updated perl and ksh
scripts that executed jobs and distributed data to other systems.
o
On call for production support.
This includes failed jobs, incorrect data, missing shipments or
orders.
o
Part of the transition team to transfer their Schaumberg office to
o
Taking in requests through Clarify to fix problems with data
translation in Informatica and coordinating with the
coders to develop an appropriate solution.
These Informatica interfaces translate data
between SAP, Red Prairie, Manugistics, and other
system.
o
Writing Perl scripts or C++ programs to extract data that we need from
multiple historical flat files.
Sometimes for analysis and other times so that the correct extracted
record blocks can be modified and reprocessed.
o
Creating custom Oracle PL/SQL stored procedures that query the
underlying tables in Manugistics and/or Red Prairie. Up to as many as 42 temporary tables were
needed within the stored procedures in order to keep total processing time to a
minimum for complicated queries. The
front end to this is a Crystal Report, using version 8.5 and now 9.0. These are published to the Crystal Enterprise
server. Approximately 25% of the reports
have sub-reports as well.
o
Designing ASP, CSP, and Javascript pages to
override the default page setup in Crystal Enterprise 8.0 / 8.5 / 9.0 for
ConAgra. Including parameter screen
replacement and instance viewer. Data
was accessed from an Oracle 8.1.7 test database that I managed.
o
Experience with the use of Manugistics,
McHugh, Red Prairie database tables and relationships. Performance optimization of current stored
procedures. Creation of Unix shell
scripts for automated testing and detection of possible problems with Informatica batch processing. Project management duties associated with
each of these items.
Software
Engineer
·
TruServ: Developed an automated files transfer system
for TruServ. A custom Visual Basic
program and Xellenet Remoteware
scripts were created. The Visual Basic
program, that I was solely in charge of writing, dealt with automatically generating
the appropriate scripts for Remoteware to sync up
data between stores. Minimal interface
required.
·
A.C. Nielsen: Developed inventory control software for A.C.
Nielsen. Consumer packaged goods data
was statistically analyzed to assist upper management in decision making. Integrated 40 Fortran
and C programs into a common GUI. The
project utilized C, Visual C++, and MFC.
·
Felpro: Major contributor to the development of the
sales force automation project for Felpro. Each traveling sales person uploads daily
sales data from their laptops to the SQL Server in the main office. Worked on the front-end GUI in Visual Basic
and back-end data base design and stored procedures and triggers on SQL
Server. I was the sole person in charge
of writing the Visual Basic portion of this project during this time. Used Farpoint and SofTabs add-on GUI controls for a lot of the
interface. Received feedback from sales
people for changes they would like to the interface and mode the appropriate
modifications and additions to the design in VB. The project utilized Visual Basic, Microsoft
Access, OCX, ActiveX, etc. Used Install
Shield for packaging and distribution of initial install and updates to the
laptops.
·
A.C. Nielsen: Re-engineered user interface written in
·
Perseco: Developed a reporting software tool for Perseco, which analyses sales data for McDonalds. The project utilized Crystal Reports and
Oracle 8.0.5.
·
A.C. Nielsen: Designed and developed “Data Exchange” data
analysis software for A.C. Nielsen. It
performed comparative data analysis of sales data based on global market,
product line, etc. It utilized Visual
C++ with MFC and SofTabs grid controls. Data was on an Oracle 8.0.5 database. I was instrumental in improving the
performance of the data processing.
Researcher
·
Research towards
master degree in collaboration with Professor Dirk K. Morr.
·
Research on defects
and impurities in strongly correlated electron systems, such as s-wave and
d-wave superconductors. Calculation of
Green’s functions and Density of States.
Used Visual C++ for all calculations.
·
Visual Studio
.NET used to advance programs with GUI interface.
HYSEQ
Incorporated.
Software
Engineer
·
HYSEQ, a biotech
firm, acquired the core group from
·
Added 10,000
lines of C code to previous data analysis software package (SCORES).
·
Created
15,000-line data analysis package (SUPERCHIP) for a process technology
currently being developed.
·
50-100 lines of C
code are added to these programs daily.
·
Set up network of
Sun Microsystems Spare 20 workstations using Solaris 2.x.
·
Installed
operating system patches. Gcc, X-windows, Motif, DNS,
E-mail, accounts, groups, specialized account initialization files, etc.
·
Attached five
external hard drives to server and created directory structure.
·
Fixed memory and
hard drive problems of the server.
·
Configured my
home office computer to run Linux and communicate via ISDN.
Computer
Programmer
·
Created software
in C for the reconstruction of DNA sequences from oligomer
hybridization data. The software
analyzed, charted, and graphed the data in order to evaluate the success of
experiments and searched for similarities to known sequences in the Genbank database.
Custom database created for storage of analyzed data. Edited and debugged on Solaris based Sun
Microsystems machines
·
User interface
using X-windows and Motif
·
Largest package
(SCORES) is 10,000 lines long with 50 lines added daily
·
System
administration functions:
Compiled and installed Gcc,
X-windows, Motif, etc.
Located and corrected causes of system crashes
Set up LAN using 3Com EtherLink
II cards and PC-NFS software
Pixel Vision
Computer Consultant
·
Extensive
programming in C for computer animation software package.
·
Creation of
computer generated cartoons for output to video.
·
3-D computer
animation.
EDUCATION
Masters degree in
Physics, August 2002
Northeastern
Double major. B.
S. Computer Science, B. S. Biology, May 1992
Languages: English, Greek
1. Quantum
Corrals, Eigenmodes, and Quantum Mirages in s-Wave
Superconductors, Dirk
K. Morr,
Nikolaos Stavropoulos, Physical Review Letters, Volume 92,
Number 10,
2. Quantum
Interference between Impurities:
Creating Novel Many-Body Systems in s-wave superconductors, Dirk K. Morr, Nikolaos Stavropoulos,
Submitted to Physical Review Letters,
cond-mat/0205328
3. Quantum
Interference between Multiple Impurities in a d-wave superconductor, Dirk K. Morr, Nikolaos
Stavropoulos, Physical Review B, v 66,
October 24, 2002,
cond-mat/0207243.
4. Drmanac, S., Stavropoulos,
N. A., Labat, I., Vonau,
J., Hauser, B., Soares, MB., Drmanac,
R., Gene-representing cDNA clusters defined by
hybridization of 57,419 clones from infant brain libraries with short oligonucleotide probes, GENOMICS, 37 (1):
29-40 OCT 1 1996
5. Drmanac, R., Drmanac, S., Labat, I., Vicentic, A., Gemmel, A., Stavropoulos,
N. A., Jarvis, J., SBH and the integration of complementary approaches in
the mapping, sequencing, and understanding of the complex genomes, Proceedings of the 2nd international
conference on Bioinformatics, Supercomputing, and Complex Genome Analysis, World
Scientific Publishing Co., 121-134, (1992)
6. Drmanac, R., Drmanac, S., Labat., I., Stavropoulos,
N. A., Requirements in screening eDNA libraries
for new genes and solutions offered by SBH technology, Proceedings of 3rd International Workshop of Transcribed Sequences, (1994),
in press.
1. Drmanac, S., Labat,
Stavropoulos, N. A., Cheng, M., Drmanac, R., Gene cataloguing and
100-bp-resolution
genome mapping by hybridization of one hundred
6-mer to 8-mer oligonucleotide probes, Genome
Sequencing and analysis
conference IV, September 1992, Hilton