SUMMARY:

• For further consideration, my Resume is enclosed herewith, and gives an account of skills and experience; 6 years in Mainframe computer operations. In Programming ; have an ongoing exposure to C# ; Visual Studio ASP.NET 2005/08/2010/2012 - Experience in using various QA Software Testing methodologies; in support of Software Development projects with databases; using MS SQL Server 2005 Standard / 2008 R2/2012; SSIS / SSRS, also have experience in Technical Documentation, and some Web development .
• I am very keen and willing to learn new on the job technologies; or skills to achieve success in the position offered.
• I would welcome the opportunity to discuss my application further.
• I therefore look forward to hearing from you, thank you for your time and consideration.

SQL PROFESSIONAL SKILLS:

• Troubleshooting, Database Objects authorization, DTS, ETL Tools; using (SSIS), Objects Creation such as Tables, Views, Good Knowledge of Data Warehouse (SSAS) and SSRS.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities./SQL Server Commands and DTA (Database Tuning Advisor)
• Excellent knowledge in system tables and system stored procedures using T-SQL.
• Experience with SQL Server 2005/2008/2012, DDL / DML Triggers.
• Experience in ETL of data using SQL Server SSIS; migration of Data from Excel, Flat file, and Data analysis for correctness.
• Experience with Data Types, Indexes, Stored Procedures, Triggers, Table-Valued Functions.
• Experience of loading and merging data from different sources into database table or view in a user-specified format; utilizing the various Control Flow and Data Flow task components of SSIS, and the capturing of errors during a process for correction and later input
• Develop, & implement program logic with use of C# scripts in ETL processes..
• Good knowledge in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export
• Strong skills in documentation of procedures and processes of a system in a format that is easily understood
• Experience with MS Office Products / Visual Studio 5 / 6, 2012, Visual C/C++, C#, TFS, SourceSafe.
• Familiar with XML technologies
• Experience with ADO.NET, ASP.NET and C#, LINQ, HTML, CSS and some JavaScript
• Generated reports using the report Wizard, and the report Model Builder approach; used the Query designer in querying database report model and editing the report format to satisfaction
• Documenting Relationship model with metadata
• Leadership, project management and time management.
• Worked with database connections, SQL joins, loops, aliases, views, Designed Sources to Targets mapping from primarily Flat files to Tables within Database

TECHNOLOGY KNOWLEDGE & EXPERIENCE:

Microsoft Windows 2008 /Server etc. Winrunner 8.0, Microsoft Word 2007/2010, Excel 2007/2010, Access 2007/2010, Visual Studio 2008 / 2010, Microsoft Visual C++ 2.0 /5.0/6.0, Visual Basic 5.0/6.0, C# .Net, MVC/ Telerik WPF Controls. Crystal Report 6.0, SourceSafe, TFS, JavaScript,SQL Serve). HTML 4.0, CSS, Adobe Photoshop CS5, DreamWeaver MX 2004, Corel Draw 5, Visio 5/2000/ 2010, SQL Server Database Tools / SSRS, SSIS (ETL).JCL -Mainframe,

PROFESSIONAL EXPERIENCE:

Confidential, Sarasota, Fl

MS SQL DBA / Data Analyst

Environment: SQL Server 2008R2; SSIS/ SSRS, Gensource Claims DW, Tropics Policy DB, and Oracle Pl/SQL

Responsibilities:

• Worked independently, with a sense of urgency and within a deadline-oriented team environment interacting with clients and users.
• Responsible for daily, weekly, monthly, and quarterly data and configuration actions.
• Interpret results using a variety of techniques, ranging from simple data aggregation to complex.
• Identify root causes in case of ETL failures, analyze, design, and develop specifications for enhancements, maintenance, and extensions to existing reports as well as develop new reports and Ad Hoc reports.

Confidential, Miami, Fl

Data Analyst/Developer

Environment: Microsoft products: Word, Excel, Visio and Development Software, Visual C# SQL Server 2008R2 /2012, including SVN

Responsibilities:

• Identify improvement opportunities and enhance processes as necessary.
• Worked with Sales, Marketing and development teams; to enhance Salesforce and Eloqua processes as necessary.
• Participate in the migration of the required changes from Test environment to Production.
• Provided resolution to issues that have been logged to the bug tracking system.
• Ensure that the necessary or all parties are notified and kept abreast of status during both release and issue instances.
• Gathered and documented functional and technical Process flow requirements for development.
• Hand coded some ETL Processes for a DW using T SQL / SSIS.

Confidential, Lantana, Fl

Contract SQL Server (2008R2) / .Net (Framework 4.0) Developer

Responsibilities:

• Interfacing with an Oracle database, extracting data (read only) as required for the WPF application I created using Visual Studio12, TFS, LINQ to SQL / Objects.

Confidential, Deerfield Beach, Fl

SQL Server Data Analyst / Developer

Responsibilities:

• Provided support to analytical and reporting projects; applied to the strategy of email marketing by extracting data feeds to build data marts, Data Validation /Extraction / Importing / and Cleansing (Metadata and Data Quality, Data Standardization) to a Data Mart to aid various companies in their marketing campaign.
• Using ETL Tools (DataBase Studio) , SQL Server 2005 , SSIS and writing T- SQL Queries.

Confidential, Dania Beach, Fl

SQL Server DBA / Developer

Responsibilities:

• Maintaining Indexes on production Database / Backups/optimization of Queries /Trouble-Shoot and Monitoring Deadlocks with the use of SQL Profiler.
• Database development projects producing; documentation for setting-up SQL Replication Server and Reporting Server, Using SQL Server 2008R2, Visio 2008
• Collaborated with Developers to define detail requirements, best approach and practices

Environment: .NET 4. /Windows 7,Visual Studio 2010

Confidential, Miami, Fl

.Net / SQL Server Developer/ SSIS

Responsibilities:

• Client discussions to gather requirements, Design and create SQL Server Databases; Data modeling, Data Normalization, Referencing XML Data, Writing complex Queries to manipulate Date / Time Data, Excel spreadsheets Data import using SSIS, Database development projects with front end interface (multi-tier), Using Visual Studio 2008 (Team),Programming in C#, SQL Server 2008 /Visio 2008 Team,.NET 3.5./ Windows 7 environment.