Sales Sql Server Development Project .Net Business
Resume:
East Brunswick, NJ *****
Phone: 732-***-****
mailto:**********@*****.***
Tatyana Rozentuler
Insightful, result-driven IT professional with over fifteen years of solid
experience and notable success in designing and developing Web and Client-
Server applications as well as planning, analysis, and implementation of
solutions in support of business objectives. Excel at providing a full
lifecycle project development and data processing. Hands-on experience
leading all stages of system development efforts, including requirements
definitions, design, architecture, testing and support. Highly motivated
and over achiever, with a positive can do, get the job done attitude.
Technical Skills:
Operating Systems: Microsoft Windows NT, Windows 2000-2003/Windows XP
/VISTA, AS400
Database Systems: SQL Server 7.0/2000/2005/2008, Oracle 9i/10g, DB2,
MSACCESS 2000/2007
Programming Languages: VBA, VB 6.0, .NET including VB.NET, C#.NET, ASP.NET,
ADO.NET, DOS, VB and JavaScript AJAX, HTML, DHTML, XML
Development Tools: IIS 6.0/7.0, Visual Studio.NET
2003/2005/2008/2010,.NET Framework 1x/3.0/3.5/4.0, OO4O, WCF,
SOA, SOAP, Windows and Web Services, SQL*PLUS, PL/SQL, T-SQL, ETL, SSIS,
SSRS, BCP Utilities, HTML, Crystal Reports 8.5/XI,
Crystal Reports Business objects, SQL Server reporting
Services, Active reports, Visio, AppForge, CrossFire, BlackBird, MDS
Blackberry, BES, Microsoft Visual SourceSafe, MSI,
Infragistics, IBM iSeries Client Access for Windows, ESP Espresso v 1.1
. Professional Experience:
10/2010-Present QT Talk, New York, NY
Senior Programmer Analyst/DBA
. QT Talk and Chase getaway integration - Chase getaway CIM (Customer
Information manager) integration with multiple Qttalk Web based
applications such as Pure minutes and QTtalk. Programmatically created
customer profiles, which include payment and shipping information and
can referenced later in future banking transactions, eliminating steps
in the transaction process for repeat customers and potentially
increasing customer loyalty.. Process written utilizing ASP .NET2008
Framework 3.5, VB SOA technology, featuring SQL Server 2008 and
Authorize.net as backend data store. Performed full life time cycle
development for this project.
. SMS - smsftp massaging is in-house VB .NET service. It utilizes API's
of Protoview third party application service allowing sms messages
transmission by mobile devices. Created programmatic keywords
configuration and programmed multiple message responses based on
command received from mobile device. It includes SQL server business
objects modification to support custom keywords created.
. QTTalk.com Server migration - Successfully completed migration of
QTTALK web server to new advanced multiprocessor server. It included
web server and web sites migration and security as well as migration
of all existing scheduled jobs, multiple third party web services and
third party software installation/configuration.
. SQL Server 2000/2005 database administration, support and maintenance.
8/2006 - 8/2010 HealthFirst New York, NY
Programmer Analyst
Participated in technical analysis, design, development, and implementation
of new and existing systems, specializing in Object-Oriented methodologies
Windows and Web environments, as well as production support, project
management and client relationship. This included: requirement gathering,
development of multiple prototypes and presenting them to upper management
and business partners for review, coding of applications, creation of the
documentation such as Functional Specifications, Technical notes, Release
Notes, Installation Instructions for QA/TS, QA test scripts, Post-
Production Support Notes and User Manuals.
. HealthFirst Member Search Application - This is a web based
application which was developed as a part of membership retention
effort of HF. It was designed to be accessible from a desktop
computers, as well as phones from Blackberry browsers. Written
utilizing ASP .NET2008 Framework 3.5, VB SOA technology and WCF
Library, featuring SQL Server 2008 and DB2 as backend data stores. It
is hosted as a Web Service on IIS 7.0. Performed full life time cycle
development for this project including BES Server configurations and
security.
. Studio for EMeving applicants and storing results - EMEDNY HF/City of
New York Medicaid Eligibility Verification is ASP .NET Framework 2.0
VB system with mobile support. It utilizes existing Sun Guard
components written on C# such as: tokenizes and parser (EDI 271/272).
The application is hosted on IIS 6.0 and uses Domain Authentication
for internal user authentication or UserName / Password for external
user authentication; ASP.NET2005 VB technologies and SQL Server 2005
used to develop this system. This system also includes Managers
Enrollment Review which is a .NET ASP VB application with the ability
to review, analyze and print verification receipts. Performed full
life time cycle development for this project.
. Encounters - ASP .NET VB Framework 2.0 system with mobile support.
Designed to support sales operations activities to record new
member/potential member interactions in order to create notes for
Member Services department. Mostly accessed from Blackberry devices by
sales representatives working on the marketing sites. SQL Server 2005
used as a backend for this tool. Domain security achieved by custom
HTTP headers created on the BES server. Performed full life time cycle
development for this project
. PHSP renewals and Outreach tracking - ASP .NET VB Framework 2.0 system
with mobile support. Designed to support sales operations activities
to record member/potential member interactions and member services
notes. Mostly used by sales representatives from Blackberry devices.
SQL Server 2005 used as a backend for this tool. Full life time cycle
development project.
. POC -Provider OnContact - is a part of OnContact HealthFirst
Enterprise system. A Client/server application - written using NET2005
Framework 2.0 VB WINFORMS. It used for tracking provider activities,
calls, provider search and includes custom components for extracts and
reports generation. SQL Server2005, DB2, SAS and Oracle utilized as
data store.
. Online Claim Status Verification - Web service - written utilizing VB
.NET 2005 SOA technology as a custom component to be accessed by
providers. It used by different applications to verify status of an
existing claim. DB2 was utilized as data store.
. EZR- HealthFirst data entry Enrollment system - ASP .NET2003 VB
Framework 1.1 Data is stored in a SQL Server2005 database. The system
is responsible for performing necessary calculations to determine
applicant's eligibility, benefit package information, and appropriate
type of transaction which must be submitted to MHS (e.g., new member,
reenrollment, recertification, update, disenrollment and
reinstatement). Once these calculations have been completed, the
system verifies that no constraints in MHS (or the KIDS submission
application) will be violated. Following this verification the
information is submitted via 834 transaction (and subsequent
programmatic updates to the information in MHS). The system continues
to identify transactions which are rejected in MHS and to update the
DOTS database/system for successful transactions.
. DOTs - HealthFirst Document Tracking System which is a Visual Basic
6.0 Application. This system also used to verify member eligibility
for benefits based on documentation submitted and immigration status
of the member. SQL Server 2005 used as a back end.
. EZR_To_DOTS - Windows Services written using VB .NET 2003 Framework
1.1 technology and responsible for synchronization between EZR and
DOTS. After EZR enrollment application was successfully entered into
EZR system the EZR_To_DOTS process will update DOT's tables with the
information collected from the EZR.
. EZR Selective Conversion - this is a set of DTS/ SSIS packages which
runs as a scheduled job and used to convert (or copy) data for CHP
applications within EZR that become pended in various error workflow
statuses. It also serves to move CHP application data entered directly
into MHS and DOTS systems via an enrollment rep into the EZR database.
The business user has no interaction with the selective conversion
except to request that specific applications be set to an error status
for re-processing. SQL Server 2000 originally utilized for
development of this product. The product was since converted to SQL
server 2005 SSIS project.
. HF Correspondence system - Used to generate correspondence
documentation, data extracts and tracks correspondence documentation
workflow statuses. In participation in a team with other developers
developed multiple letter templates, views, snapshots, stored
procedures, functions: linked servers to support current application
needs. This product is WINFORMS application .NET 2005 VB Framework
2.0, VBA, DB2, SAS, Oracle and SQL Server2005 technology used for this
project.
. Other web and client/server applications: EMEDNY which is a web based
ASP .NET2003 C# Framework 1.1 application. Initiate and develop of
HIPPA rolls option parameters functions for .NET VB shared code
library to restrict printing/displaying of member, certain diagnosis
and treatments information based on a member consent form.
Participated in conversion of Member ID's/SS# via External ID project.
Created multiple jobs for cross system synchronization between DB2,
SQL Server and Oracle. Was responsible for Crystal reports business
objects Crystal server administration, configuration and support, code
review, issues troubleshooting, analysis, testing and documentation
for HealthFirst offshore team and third party vendors.
2005-2006 LOEHMANN'S NY
System Analyst
. Requirement gathering for system development from Business Users
. Development and maintenance of applications and post-production
application support.
. Conversion of existing applications from VB6 to VB .NET 2003/2005
and ASP.NET
. Creation of various database jobs, PL SQL scripts, DTS/SSIS
packages, stored procedures, triggers, roles and functions.
Developed HR Paperless System using ASP.NET2005 VB Framework 2.0, which
allowed Lehmann's stores to complete and submit HR forms via Intranet.
(Payroll forms, Change of Status and etc.). Participated in development of
a suite of database applications to serve the needs of a large clothing
retailer. Major system components developed included:Sales/Invoicing module
which was utilized by the sales associates during the sales event. This
module charged customers for the selected stock item(s) and generated
invoices. Customer Tracking Module which was used to keep track of the
purchase activity of the firm's customers and allowed the sales associates
to enter customer purchase information during the purchase event. This
information was later utilized as an aid for marketing activities.
Wholesaler Maintenance Module was used to manage various wholesaler data,
including but not limited to Lines Carried, Defective Merchandise, Time to
Deliver and so on. The system was developed using Microsoft .NET2003
Framework 1.1 and Microsoft SQL Server 2000. Reports were produced using
Seagate Crystal Reports Professional 8.5. Also participated in development
of the Electronic Points application, which added bonus points to the
Customer Account based on the store transactions. The application
implemented random selection of customers for Special Bonus shopping spree.
Maintained Distribution Management System which allowed users to submit
Excel files for automatic entry into the STS file Based System. Worked on
the Web Printer ASP .NET2003 Framework 1.1 Project, which allowed users to
receive reports by e-mail, sent them to the printer or to create snapshots
for view. Worked on the Orders part of the Loehmann's Allocation system,
which is a VB.NET 2005 Framework 2.0 based application.
2001-2005 GIRL SCOUTS OF USA, New York, NY
Senior Programmer Analyst
Conversion of GSUSA Membership System from Legacy (Mainframe) file based
system to SQL Server 2003. Development and Implementation of multiple PC
Mainframe scripts, Mainframe profiles and Batch files. GSUSA PC based
Membership System (WINPCMS), Council Activity System (WINCAS) and Data Base
Utilities (DBU), which had undergone major functional enhancements.
Converted multiple projects from DAO/RDO to ADO/OO4O. Created database
objects, such as tables, views, snapshots, indexes, and sequences. Coded,
tasted and implemented various systems, VB, JAVA and batch Scripts. Created
jobs, DTS packages, stored procedures and functions. Worked on a various
projects involving use of PC Mainframe ETL processes. Provide SQL Server
2003 support and maintenance. Participate in GSUSA Membership System
Database design. Provided security of the database by setting up users
groups and accounts and assigning special rights to it. Consulted the
clients, find the problem and provided the solution for the in-house
database repair and maintenance. Created stand alone applications for GSUSA
50th National convention in Atlanta GA (Delegate Tracking). Wrote multiple
reports utilizing Crystal, MS Access, Active Reports and system Scripts.
Utilized AS400, SQL Server 2000 and Oracle as applications data store
2000-2001 SLEEPYS NY
System Analyst consultant
Created database objects, such as packages, tables, views, indexes,
sequences. Functional design of the workload processes. Coding, testing and
implementation of various PL/SQL blocks, stored procedures, functions and
packages design and development of multiple forms and reports. Assisted
users on a daily basis in problems resolutio. Developed VB6 automatic funds
transactions posting application for Finance department. Utilized Oracle
7.3, SQL Server 2000,TSQL, Active Reports, DOS and VB scripts.
1998 - 2000 COMPUTER SOLUTIONS INTERNATIONAL INC. Consulting Services, New
York, NY
Programmer Analyst
. Developed a number of new online applications, participated in EDI
client/server project maintenance and technical support of existing
products, testing new programs, writing reports and generating customized
views based on data from SQL Server, Access Data Bases and ISAM files.
Education:
. 2007 Microsoft boot camp: SQL Server 2005 Database developer
. 1997-1999 Bramson ORT Technical Institute, Forest Hills, - NY AS in
Computer Science
. 1983-1989 Republic of Belarus Polytechnic Academy, BS in Architecture
+ Skills: Proven ability to work independently and as a team member
Ability to be flexible and work analytically in a problem-
solving environment
Contact this candidate