SOFIA GEISINSKY
*******@*****.***
PROFESSIONAL EXPERIENCE
RG Intelliconstruction Corporation November 2007
- Present
Brooklyn, NY
Senior Business Manager
. Responsible for all aspects of business development, process,
profitability measurement, strategy, and marketing
. Manage contract customization and negotiations
. Manage detailed scheduling of project planning and completion
. Extensively communicate with prospects and clients
. Create custom business and financial reports utilizing MS Excel and
other applications
. Interact with NYC Department of Buildings and other agencies to obtain
necessary construction permits and licenses
The Depository Trust & Clearing Corporation January 2007
- November 2007
New York, NY
QA System Analyst/Programmer Analyst (Consultant)
. Responsible for testing and analysis of business requirements of Trade
Repository Processing (TRP) System, Pricing System (PRC), Listed
Securities NYSE (LSN) System.
. Participated in full cycle of testing of enhanced TRP system including
stress testing up to three times the current peak-day trading volume,
and running the new TRP database parallel with production system. It
required to use of web based
DTC test products to analyze the status and condition of database in
order to fallow test requirements.
. Created test plans and test cases for baseline and production parallel
testing, set up test environment, schedule tests with CA-7 and
Scheduler, create run sheets and execute regression test of system
. Create and modify JCL jobs and JCL Procs
. Develop and implement programs utilizing COBOL with access of VSAM and
DB2 databases
. Create and run SQL queries using DB2 Utilities (QMF, SPUFI)
Echo Broadcasting Group December 2003
- December 2006
Brooklyn, NY
Senior Business Analyst
Marketing and Sales Department
. Analyzed business, financial, operational, and reporting aspects of
Station's marketing and advertising department
. Developed "Advertisement Schedule" application to allow easy
computerized access to advertisement scripts
. Produced, interpreted and presented comprehensive reports on sources
of advertising revenue
. Analyzed in detail effectiveness of various advertising campaigns;
examined target audiences and advertisers
. Negotiated advertising contracts with new and existing advertisers
First Data Merchant Services September
2000 - October 2001
Melville, NY
Senior Programmer/Application Developer (Consultant)
. Worked on development, implementation, and support of electronic
financial transaction processing systems
. Supported Credit Card Processing System for cardholder and merchant
services
. Developed, modified, tested, and enhanced on-line applications.
Performed production support
. Designed and created user interfaces for transaction databases
Unilever Home & Personal Care February 1995
- July 2000
Englewood Cliffs, NJ
Senior Business Analyst/Programmer t
. Performed lead technical role in entire lifecycle of Process of
Logistic Data System
. Communicated extensively with internal application users to
develop appropriate application solutions
. Translated analysis of business requirements into application
specifications
. Developed applications in COBOL, COBOL II, and CICS with access to DB2
and VSAM databases
EDUCATION
State University (Mining Institute); Dnepropetrovsk, Ukraine
BS and MS in Mining and Civil Engineering; Minor in Computer and
Information Sciences
ADDITIONAL INFORMATION
Tools/Utilities: MS Office
including MS Excel, MS Access, IBM Utilities,
Intertest, Abend-Aid, File-Aid, QMF, SPUFI,
DCLGEN, Endevor, Changeman, Infoman, Expeditor,
DFSORT, CA-7
Programming Languages/Software: SQL, JCL, COBOL, COBOL II, CICS, DB2,
VSAM