OBJECTIVE:

A challenging position as a Senior Microsoft SQL Server Database Administrator/Business Intelligence Developer.

SUMMARY:

• 10+ years of experience as Microsoft SQL Server Administrator, SQL 2000/2005/2008.
• 10+ years of experience in MS SQL Development, Stored Procedures, Triggers, Functions.
• 10+ years of experience designing, developing and implementing MS SQL Server Databases.
• 6 years of experience developing reports with MS SQL Server BI Reporting Services.
• 4 years of experience developing integration solutions using SSIS/DTS.
• 11 years of experience in Confidential GP and NAV ERP Systems databases.
• 15+ years of experience in Relational Databases Analysis and Business Process Analysis.

TECHNICAL SKILLS:

Programming Languages: Transact SQL, MS SQL BI Reporting Services, MS SQL Analysis Services, MS SQL Integration Services, C#.Net, ASP.Net 2.0, Visual Studio 2005, VBA for applications, VB Script, Confidential C/Side & CAL, Confidential Dexterity.

Data Bases: Microsoft SQL Server 2008/2005/2000.

Software: Confidential NAV, Confidential GP, Microsoft Office, Microsoft Project, Integration Manager, eConnect, Report Writer, Modifier.

Operating Systems: Windows XP, Windows Vista, Windows 2003, DOS.

PROFESSIONAL EXPERIENCE:

Business Solutions Database Developer

Confidential, Fort Lauderdale, FL

Responsibilities:

• Upgraded 3 instances of SQL Server 2000 to SQL Server 2005.
• Implemented the entire ERP Database user security on SQL Server 2005.
• Developed an entire suite of Business Notifications using SQL Triggers, SQL Stored Procedures, SQL Mail and SQL Agent like notifying users when Purchase Orders Items are received, when Sales Orders are ready to be shipped, notifying Account Payables Dept. when invoices are close to due date.
• Developed an automated application notifying customers about overdue invoices, sending the invoices detail in HTML format using SQL Stored Procedures, SQL Mail and SQL Agent.
• Implemented several SQL Database Maintenance Plans to full DB and Transaction log backup, rebuilding table indexes to increase DB performance.
• In charge of Confidential NAV (ERP system), Database Administration, supporting users, customizing and developing new application using SQL Server, C/SIDE, C/AL programming language

Confidential

SQL DBA Consultant, Miami, FL

Responsibilities:

• I did support functional consultants installing and configuring several instances of SQL Server 2005 to be used with Confidential GP Version 9 and 10.
• I did develop a very important interface between a proprietary system that controls the stock investments in Venezuela and MS Dynamics GP using MS SQL Server Stored Procedures and SQL Agent. I developed several reports for different customers using MS SQL Reporting Services.

Confidential

MS Dynamics Navision Developer/SQL Developer

Responsibilities:

• Developed and implemented a large variety of Confidential NAV Customizations for Sales, Purchases, Finance and Manufacturing modules on four client implementations using C\SIDE, SQL Triggers and SQL Stored Procedures.
• Developed and implemented the Web Data Collector Program to manage Confidential NAV Manufacturing Transactions (Transfer, Adjustment, Consumption and Production) using Visual Studio 2005, SQL Stored Procedures and NAV Application Services.
• Developed lot of Reports for Customers using MS SQL Reporting Services and SQL Stored Procedures.
• Designed Database models for new developments to integrate with ERP MS Dynamics NAV.
• Developed SQL Server Maintenance Plans for different customers to have a backup strategy using Full, Differential and Transaction Log Backups.
• Developed some SQL Maintenance Plans to rebuild table indexes to increase DB performance.
• Implemented SQL DB Transaction Log Shipping Replication in one customer company.

Confidential, CA

Senior MS Dynamics GP Database Developer

Responsibilities:

• In charge of development team and responsible for developing and delivering high quality Confidential GP customizations and vertical solutions using SQL Server, Visual Studio and Dexterity.
• Developed and implemented a large variety of integrations between Confidential GP Databases and third party software using SQL Store Procedures, DTS, and SQL Agent.
• Developed a great number of reports using MS SQL Server Reporting Services and Stored Procedures for SQL 2005 and SQL 2000 for a great variety of customers like Journals, Banks, Pharmaceuticals, Engineering, Retail Sales and so others.

Confidential, CA

Systems Coordinator

Responsibilities:

• In charge of IT Operations, Database Administration and Software Development.
• Developed and Implemented Confidential GP customizations, training and technical support to Confidential GP users.
• Customized Confidential GP forms and reports with VBA.
• Developed and implemented the Energy Project Control System (developed with Dexterity) and integrated with Confidential GP.

Confidential

Systems Analyst

Responsibilities:

• Developed office automation tools for the Automation Production Project Management Team.
• Developed and implemented a drilling movement system (drilling and rehabilitation of wells.) Developed with Microsoft Visual Basic.
• Developed and implemented the Material Elongation and Fatigue Test Analog System with MTS machine. Developed with Microsoft Visual Basic.