SQL Developer Resume Profile

SKILE

Databases: SQL Server 2000/2005/2008, PostgreSQL, ADO.Net
Database Tools: T-SQL, SQL Server Enterprise Manager, SQL Query Analyzer, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, OLTP, PGAdminIII, PL/PgSQL, CONNX
Operating Systems: Windows 9x, 2000, NT, XP, Vista, Linux
Other Technical Expertise: SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , and C

Work Experience

Senior Data Analyst, Confidential Transferred data from various formats to SQL Server databases using SSIS Created scripts to maintain data in production environment according to business rules Created various database objects e.g.: check constraints, stored procedures, user defined functions, triggers Created and ran weekly report scripts
Verified mail addresses with Melissa database
Converted data from an obsolete database located on MS SQL Server 2008 to a new database system located on MS SQL Server 2010 for the Government of Alaska
Responsible for creating SQL scripts for various purposes
Created scripts for data inserting, updating, and deleting in various databases
Created scripts for data searching in old WIC Women, Infants, Children database system
Created stored procedures for inserting data for U.S. Department of Labor

SQL Developer

Confidential

Extracted, transformed and loaded data ETL from MS SQL Server 2000 into PostgreSQL target server. CONNX
CONNX.com a data pump used as a main tool, which extracts transfers and loads data automatically after initial setup. The whole ETL process was automated according to the user's requirements. Also, views from all transferred databases on PostgreSQL server with PGAdminIII were created. All views are documented within the Data Dictionary, which was transferred into a table on the PostgreSQL server schema
Created stored procedures on both database systems - MS SQL Server 2000 and PostgreSQL

SQL Server 2000

Confidential

Developed a computerized system in a newly established business, whose prime
products are varieties of soft drinks
Suggested and installed new hardware and software that replaced the company's obsolete
manual management system, which improved company's business transactions
Created a new web page, which reflects company's goals, products, and improved their marketing strategy

Consultant

Confidential

Designed and implemented several Visual FoxPro projects for insurance companies in a client-server environment based on customers' business rules
Developed database maintenance routines for archiving and purging data indexing, validating,
saving, and undoing data controlling access to data displaying descriptive error messages
Used Visual FoxPro for building an application front end. Created remote views to access data on a server MS SQL 6.5 through ODBC and defined connection
Created reports and documentation. Provided technical help and consulting to clients and other programmers working on these projects

Programmer

Confidential