ALLA BAYMAN
***** *********** ***., ****** *****, MD 21117
*********@*****.***
OBJECTIVE:
To obtain a challenging position as a SQL Developer, Programmer/Analyst, Software Engineer
SUMMARY OF SKILLS AND QUALIFICATIONS:
Database Design, Creating, Conversion, Administration and Maintenance (SQL Server, Oracle, MS Access).
Visual Studio .NET (C#, ASP.NET, VB.NET, SSRS, SSIS)
Business Intelligence proficiency (SSRS, Crystal reports, Cognos)
Working knowledge with Oracle, ASP, MySQL, WebSphere
SQL Programming (T-SQL, PL-SQL)
Customer Support and Training
EXPERIENCE:
02/2016 – present SQL Developer
Wells Fargo
Developing and troubleshooting legacy stored procedures (SQL Server 2008) and reports (Business Objects 2011).
Resolving problems specified in the problem tickets.
Creating ad-hoc queries.
Demonstrate ability multitask and prioritize concurrent assignments.
Using PAC2000 to create the problem tickets and respond on work requests.
06/2010-01/2016 Programmer/Analyst
Press Ganey Associates, Inc.
Developing and troubleshooting complex software to run the transmission processes between hospitals and Joint Commission to improve the process of care with eClinical Quality and Core Measures (VB.Net, C#.Net, PL-SQL, Visual Studio 2013)
Creating reports with SQL Server Reporting Service (SSRS, PL-SQL) using Business Intelligence and SQL Server Integration Services (SSIS) tools.
Creating and maintaining the database tables, stored procedures, views (Oracle, SQL Server 2012) using Oracle SQL Developer.
10/2008 – 05/2010 Database Engineer
PSYCH/COMC
University of Baltimore
Developing and troubleshooting the complex software to improve the quality of behavioral health treatment for children and adolescents through outcomes evaluation. The software works for a data repository to store, sort and transmit data to the responsible agencies.
Developing solutions with VB.NET, ASP.NET, SQL Server 2005, SQL Reporting Service (SSRS), HTML, CSS, Visual Studio 2005-2008
06/2005 – 8/2008 Programmer/Analyst,
Institute for Governmental Service and Research,
University of Maryland
Developing and troubleshooting the complex software that allows the maintenance and sharing of client and offender information across the different organizational networks (substance abuse, mental health, social services, juvenile and/or criminal justice services), while protecting confidentiality.
Environment: SQL Server 2000/2005, SQL Reporting Service (SSRS), VB6, ASP.NET, C#, HTML, Object Oriented Programming, XML, IIS and Visual Studio 2005/2008.
10/2004 – 04/2005 Programmer/Analyst, Consulting
PKW Associates, Inc.
For VIPS:
Developing and troubleshooting the software for the health insurance companies and hospitals. The software was built to help users to pick up, hold, analyze and send the medical information from the hospitals and doctors to insurance companies.
Working with VB6 (SQL Server 2000 as a back-end), classes, ActiveX controls.
Troubleshooting procedures to transfer data between the SQL Server and Access Database. Creating reports of the transactions. Establish user rights to the tables, store procedures and views to resolve database performance issues, database capacity issues, replication, and other distributed data issues.
For Northrop Grumman:
Developing solutions with Java, JSP, ASP, MySQL, Oracle 8 and Crystal Report 10
Designed Java application to select data from an Oracle Database and send it to the default printer as a Crystal Report without presenting intermediate data screen to user.
02/2001 – 07/2004 Software Engineer
NovaTech Process Solutions, LLC.
Developing, troubleshooting and supporting the software for the chemical plants.
The software was created to help users to enhance the performance and improve the process of the creating and running batches in the chemical plants.
Working with VB6 (SQL Server 2000 as a back-end), classes, ActiveX controls
SQL Server 2000: Database design and maintenance, developing store procedures, triggers and views for ensuring the security and integrity of the company database (Establish and enforce user rights to the tables, stored procedures, triggers).
Designing and scheduling database maintenance plans that would optimize, check for integrity and backup databases and transaction logs.
Design reports in MS Access and Crystal Reports 8.5
Learning Visual Studio.NET in order to enhance the project.
05/1999 – 01/2001 Programmer/Analyst
Signature Systems, Inc.
Developing Software in VB6 (SQL Server as a back end) for the variety of projects, including Housing Authorities of Baltimore City.
Crystal Reports 7 design.
SQL Server 7 - triggers, stored procedures, database design and maintenance.
Customer Support and Training
Testing and troubleshooting
EDUCATION:
1987 BS in Computer Engineering, State Institute of the Food Industry
Moscow, Russia
REFERENCES AVAILABLE UPON REQUEST