SUMMARY:

• Highly motivated IT Professional with experience in SQL Server, OracleDatabases.
• Demonstrate leadership abilities andteam work skills as well as the ability toaccomplish tasksunder minimal direction and supervision.
• Create and Develop Stored Procedures for Projects using T - SQL in SQL SERVER.
• Tune code thru code reviews in T-SQL.
• Create and Develop SSIS Packages.
• Create and Develop SSRS Reports.
• Create and Develop Stored Procedures for Projects using PL/SQL in Oracle.
• Knowledge in database architecture and design;
• Experience with database replication and integration;
• Experience with SSAS
• Understanding of multiple database concepts and procedures;
• Proven experience in a data warehouse application development environment;
• Expertise in schema optimization for performance and scalability;
• Excellent written communication skills;
• Data analysis/modeling
• Excellent problem solving ability;
• Ability to multi-task and still maintaining focus;
• Create materials to support of various Applications and Projects
• Create Documentation to support projects

TECHNICAL SKILLS:

Programming Languages: Transact SQL, XML, SQL, PL/SQL, SAS, MS Access, Word, Excel, Power Loader, COBOL, VB, .NET

Database Skills: Microsoft SQL Server 2000,2005,2008-r2, and 2012 Oracle 8,9,10 & 11, Oracle Enterprise Manager, Navigator, ERWIN, Toad, RMAN, Teradata

Operating Systems: Windows 98/2000/XP, Windows Server 2003, UNIX, IBM, Linux

Software: SQL Server Management Studio, Microsoft Visio, Microsoft Office,Toad for Oracle,Database Engine Tuning Advisor, SQL Server Profiler, Oracle Management Utilities, Crystal Reports,ETL, SSAS, SSRS, SSIS, DTS

EXPERIENCE:

Confidential, Orlando, FL

SQL Server Developer

Responsibilities:

• Documenting SSIS packages.
• Re-factoring and updating the SSIS packages for SQL Server 2012.

Confidential, Lake Mary, FL

SQL Server Developer/DBA

Responsibilities:

• Create and Develop Stored Procedures for Projects using T-SQL
• Create, Update, and Support SQL2008R2 Databases
• Backup, Restore SQL Databases using SQL Backup, and Restore Utility
• Create & Maintain SSIS packages
• Use SSIS packages for ETL.
• Create & Maintain SSRS reports
• Getting data for the SSRS and SSIS from Excel Files.
• Create & Maintain SSAS Projects Using Cubes
• Tune and Upgrade stored procedures.
• Database migration and import/export.
• Performance monitoring of SQL servers.
• Track and document server and database changes
• All Software changes are tracked thru to production using TFS
• Support, Maintain and Control Security on Salesforce
• Support, Maintain and Administrator in Satmetrix application for Confidential Surveys.
• Maintain and Support CRM applications.

Confidential, Maitland, FL

SQL Server Developer

Responsibilities:

• Create and Develop Stored Procedures for Projects using T-SQL
• Create & Maintain SSIS packages.
• Convert DTS packages to SSIS
• Create & Maintain SSRS reports,
• Create & Maintain Crystal reports
• Getting data for the SSRS and SSIS from Excel Files.
• Setup and Supporting users in Report Builder 3.0
• Created and Supported the Candidate Portal
• Create & Maintain stored procedures, views, indexes and tables in SQL Server Databases
• Document and Support internal and External Applications.
• Create and Support packages written .net
• Backup, Restore SQL Databases using SQL Backup, and Restore Utility
• Supported and Maintained SQL Server Reporting Services (2008+) writing reports, writing report models, administrating a SSRS server instance and BI portal
• Experience working with SSAS
• Data analysis/modeling for Sql Server databases.
• Working with team members on a global scale across multiple countries.

Confidential, Lake Mary, FL

SQL Server Developer

Responsibilities:

• Create and Develop Stored Procedures for Projects using T-SQL
• Create, Update, and Support SQL 2005& 2008 Databases
• Backup, Restore SQL Databases using SQL Backup, and Restore Utility
• Create & Maintain SSIS packages
• Use SSIS packages for ETL.
• Create & Maintain SSRS reports
• Getting data for the SSRS and SSIS from Excel Files.
• Tune and Upgrade stored procedures.
• Database migration and import/export.
• Performance monitoring ofSQL servers.
• Track and document server and database changes
• Document and Support internal Insurance Applications.
• Create and Support packages written .net
• Support Sharepoint helping out Sharepoint Administrator

Confidential, Maitland, FL

IT Instructor

Responsibilities:

• Teach students in Oracle versions 10 & 11, Excel, Word, Power Point, SQL Server 2005 & 2008 Databases, .net, and Linux
• Evaluate and grade students' class work, laboratory work, assignments, and papers.
• Maintain student attendance records, grades, and other required records.
• Prepare course materials such as syllabi, homework assignments, and handouts.
• Compile, administer, and grade examinations or assign this work to others.
• Keep abreast of developments in the field by reading current literature, talking with colleagues, and participating in professional conferences.
• Initiate, facilitate, and moderate classroom discussions.
• Plan, evaluate, and revise curricula, course content, and course materials and methods of instruction.
• Supervise students' laboratory work.
• Maintain regularly scheduled office hours to advise and assist students.
• Advise students on academic and vocational curricula and on career issues.
• Generate and adjust long - term and short-term forecasts for assigned programs.
• Review historical data and long-term forecasts to provide staffing recommendations to Campus Directors and recruiting.
• Update and maintaindatabases
• Provide performance reports to Campus Directors.
• Setup of Windows 2005 servers.
• Windows cluster setup and configuration.
• Setup of SQL Server 2005, and 2008.
• Database migration and import/export.
• Experience in SQL Server Integration Service (SSIS).
• Show Students how to use SSIS as an ETL tool.
• SQL Server Reporting Service (SSRS).
• Manage Windows and SQL Server user accounts.
• SQL Server disaster recovery techniques and procedures.
• Performance monitoring of Windows and SQL servers.
• Track and document server and database changes

Confidential, Orlando, FL

Database Administrator

Responsibilities:

• Install and configure databases to Oracle version 10g, on HP Itaniums Server running on VMS
• Run RMAN to backup, restore for Oracle, loading the Oracle 7.3.4 data into 10g
• Created Oracle databases, tables, indexes on 10g to support upgrade from 7.3.4.
• Develop documentation and scripts to support this upgrade
• Upgrade SQL Server databases from .
• Write various reports using SSRS.
• Write various packages in SSIS and DTS to interface with Oracle.
• Used SSIS for ETL with Oracle.
• Create & Maintain Crystal reports
• Data analysis/modeling for Oracle/Sql Server databases.
• Manage the Loan Origination Production Database in SQL Server 2005.
• Ensure data integrity, data recoverability and quick access to data.
• Recommend system improvements and provided support for improvements.

Confidential, Philadelphia, PA

Database Manager/Project Manager

Responsibilities:

• 12 years of support on Oracle, SQL Server, and Unix in a production environment.
• Install, maintain, and create Oracle databases on Compaq TRU64, Windows NT.
• Install, and maintain SQL server 7.0 and 2000, using PeopleSoft.
• 5+ years of hands on experience on SQL server.
• Use DTS/SSIS to move SQL HR data into Oracle database as part of ETL tool.
• Install, upgrade, and patch Oracle and SQL server databases.
• Provide application and security support on all databases.
• Create & Maintain Crystal reports
• Conduct timely backups and restore operations on all databases.
• Successfully implement Oracle Financials for A/R,G/L,A/P and HR, which resulted in theability to access Financials and HR over the company Intranet and provide more reliable and timely reporting.
• Create and support G/L, A/P, A/R and HR reports written in PL/SQL.
• Troubleshoot and support applications created by the Development Group, to catch potential bugs.
• Document and maintain procedures for backup and restores, which results in quicker restores and heads off potential problems.
• Upgrade Oracle databases and Oracle financials.
• Assist other team members in developing their technical skills.
• Provide support to team members in all phases of the software development life cycle
• Manage a team of IT professionals in developing, implementing, and customizing insurance claims projects as Project Manager, this project ran for 3 years.
• Setup Oracle 11gRac in a Linux environment.
• Data analysis/modeling using ErWin for Oracle Databases