MS SQL Server BI Developer/DBA Resume

Title

MS SQL Server BI Developer/DBA

Primary Skills

SQL server, BI, T-SQL, SSIS, SSRS, SSAS, XML, HTML, ASP, AS400 / iSeries and more.

Location

US-NY-Brooklyn

Posted

Apr-08-11

RESUME DETAILS

MS SQL Server BI Developer/DBA

SUMMARY:

Highly motivated and experienced MS SQL Server Developer/DBA with extensive design, analytical, problem solving skills.

SKILLS:

Databases: MS SQL Server 2000 / 2005 / 2008, DB2/400, MS Access, MySQL 5.0

Software/Utilities: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, MS SQL Enterprise Manager, SQL Query Analyzer, SQL Server Profiler, Database Engine Tuning Advisor, DTS, SSIS, SSRS, SSAS, MS Visual Studio 2008, ODBC, FTP, SFTP, IIS, JDK 1.5, MS Office 2000, OS/400 through V5R4M0, BRMS, MS Great Plains Dynamics Financial System

Programming: T-SQL, HTML, JavaScript, ASP, Crystal Report, Java, XML, C#, ColdFusion

ILE RPG, RPG/400, CL, ILE CL, SQL/400, Sequel

Operating Systems: Windows 7, Windows Vista, Windows Server 2003/2008, IBM AS400 / iSeries System Administration

EXPERIENCE:

Focus Camera, Brooklyn, NY 2009 -- Present

SQL Server Developer/DBA

• Maintain MS SQL Server 2005/2008, including security, configuration and install service packs upgrades.

• Build ETL processes utilizing SSIS /DTS, including FTP data from remote location, transform it, mart it to data warehouse and provide proper error handling and alerting.

• Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures.

• Configure and maintain Report Manager and Report Server for SSRS.

• MS SQL Server database administration, including configure Scheduled Tasks for regular Database Backup and Maintenance Activities, create and modify tables, stored procedures, various clustered/non-clustered indexes, triggers, check constraints and functions.

• Logical and physical design and implementation SQL Server databases.

• Create triggers to keep track of changes to the fields of tables when changes are made.

• Develop and implement web applications using HTML, Javascript, ASP and SQL Server stored procedures.

• Write ad-hoc query batches and stored procedures to assist in analyzing, cleaning, checking and processing data to ensure the maximum possible integrity and quality.

• Write ad-hoc queries to extract data as per Business Requirements.

• Perform regular reviews of the database to identify performance problems, inadequate programming, and data duplication problems.

• Build applications that use eBay API to automatically upload and download data from eBay.

• Create ad-hoc queries from SQL Server databases for custom reporting needs

• Assist junior programmers with scripts, SSIS projects, troubleshoot complex stored procedures and query optimization.

United Way of New York City, New York, NY 1999 -- 2008

Applications Administrator/ Programmer Analyst/DBA

• Install, configure and maintain MS SQL Server 2000 and 2005.

• Implement migration SQL Server databases, user logins, and DTS packages from one server to another.

• Manage security, backup and restore on MS SQL Server databases and AS400/iSeries systems.

• Utilize Fundraising applications and MS Great Plains Dynamics Financial System administration, including security, configuration and installed upgrades on an ongoing basis.

• Develop a business continuity plan for the SQL Server Databases.

• Set up and maintain database environments to support production, QA and development activities.

• Creation of triggers used to alert specified power users of certain transactions taking place within the database.

• Configure SQL Server Log shipping between primary and secondary servers.

• Generate reports with Microsoft SQL Server Reporting Service and Crystal Report.

• Created utility to upload data from SQL Server to AS/400 to create new and update over 16,000 existed vendor accounts in Accounts Payable system.

• Designed application to process over 20,000 customer letters to acknowledge annual contributions.

• Created utility to upload data from Excel files to AS400 / iSeries and create billing statements.

• Retrieved data from SQL Server and AS400 to create different financial reports

Programming done in T-SQL, Stored Procedure, SSRS, Crystal Report, HTML, JavaScript, ASP, Java with using Java Foundation Classes and Java Swing components, ODBC, FTP, RPG ILE, CL and Printer file.

Garage Management Corporation, New York, NY 1998 -- 1999

Programmer Analyst

• Completed an A/R software and database conversion from S36 to AS400 system, as a key member of a three person project team.

• Recreated the following applications:

-Customer Rates Increase/Decrease module.

-Billing Transactions, gathering information, adding transactions to history files and creating report.

-Billing Batch Control, calculation daily and monthly charges, creating Billing statements.

Programming done in RPG400, ILE RPG, CL, utilizing Exception/Error handling, subfiles, pop-up windows, message files, the Open Query File command etc.

United Way of New York City, New York, NY 1997 -- 1998

AS/400 System Administrator/Programmer Analyst

• Installed new software releases and IBM PTF.

• Performed system backups and recovery.

• Modified Distribution Report download utility. Designed validity checking program.

EDUCATION:

BS in Engineering

Moscow University, Moscow, Russia

Certifications

MCTS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

IBM Certified Specialist AS400 RPG IV Programmer

Certificate in Java Programming

New York University, New York, NY

Certificate in Computer Programming RPG400, CL, DB2/400

SYRIT, Brooklyn, NY

CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »

Related:

Programmer / Developer Resumes

©2003-2012 Dev Bistro

©2003-2012 Dev Bistro

Contact this candidate