SQL / Software Developer / DBA Resume

SUMMARY:

Microsoft Certified Solutions Associate (MSCA, MCTS), DBA / T - SQL / PL-SQL / ETL / BI / Data Warehousing / OLTP / OLAP / Database Developer / Software Developer / Reporting Solutions / Electronics Engineering
Detail-oriented, self-motivated, able to meet strict deadlines in team atmosphere

TECHNICAL SKILLS:

SSMS 2000-200 8, BIDS, Server Profiler, SQL Tuning Advisor, MS SQL 2000-200 8, MySQL, Oracle 10g, Sybase, T-SQL, PL-SQL, SSIS, SSRS, SSAS, MDX
Visual Studio 2003-200 8, Crystal Report, Embarcadero Rapid SQL, Oracle SQL Plus, Kepware OPC Server, Proficy Machine Edition IIS, ASP.NET, VB.NET, C#.NET, HTML, JavaScript, XML, AJAX, PLC

PROFESSIONAL EXPERIENCE:

SQL / Software Developer / DBA

Confidential

Responsibilities:

Design Microsoft SQL Server solutions and database security
Architect and implement relational databases following best practices (OLTP, OLAP)
Apply data availability strategy including backup, restore, and maintenance plans
Create, manage, troubleshoot, and maintain database objects (tables, views, complex stored procedures, user defined and CLR functions, indexes, triggers, relationships, keys, constrains)
Data extract, transform, load, and distribution (SSIS packages and ETL procedures), replication, Oracle ODI, and archiving solutions
Tune and optimize database performance (locking, waits, and IO monitoring, query tuning, defragmentation, re-indexing, partitioning, statistics, database settings, server configuration)
Business Intelligence - Integration, Reporting, and Analysis Services (SSIS, SSRS, SSAS)
Maintain company’s data warehouse databases via scheduled ETL and SSIS package jobs
Develop reporting solutions (on-demand reports, data driven and scheduled distributions)
SQL Database Mail distributions

Confidential

Software Developer

Responsibilities:

Part of a business analysts team to aggregate requirements, recommend alternatives and implement solutions
Robust enterprise web and Windows desktop object-oriented applications (ASP.NET, VB.NET, C#, AJAX, jQuery) for manufacturing, finance, sales, and HR departments
Access to real time statistics data for customers and suppliers (ASP.NET, SSRS)
Developed company-wide custom CRM internal application
Time sensitive automated internal and external email notifications (Database Mail)
Software development life cycle (SDLC), documentation, user manuals
Corporate project management office and help desk support

Programmer Analyst / IS Engineer

Confidential, PA

Responsibilities:

Acquiring, installing, and administering of new-built applications
Complete systems from data collection to “Visual Factory” reporting screens
Project Management experience
Provide live and statistics data through networked displays and Blackberries.
Plant automation and quality improvement systems.
Work with DBA team to design, create, and tune up tables, relationships, and indexes to improve queries performance

Confidential

Help Desk and Support

Responsibilities:

Network/System Administrator/Programmer

Confidential, Cherry Hill, NJ

Responsibilities:

Front and back-end programs for company needs (VB.NET, VB6, Crystal Report, Access). Designed checks, invoices, and reports layouts
Planned, installed, analyzed, and supported servers, computers, and network. Controlled network and systems security in Headquarters and 7 locations in NJ and PA. Provided onsite and remote helpdesk support for clients