Professional Experience:

• Over 15 years of experience in SQL Database Administration and Programming
• Proficient in the following
• SQL Server and T-SQL.
• creating and using Stored Procedures, Views, User Defined Functions.
• creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• data Extraction, Transforming and Loading ETL using various tools such as SQL Server Integration Services SSIS , Data Transformation Services DTS .
• creating dynamic packages for Incremental Loads and Data Cleaning in Data WareHouse using SSIS.
• experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Extracted, transformed and loaded data from various data sources and destinations like Access,Excel,CSV,flat files using connectors, tasks and transformations provided by SSIS.
• developing Drill Down, Sub reports and Charts using Global variables,Expressions and Functions for the business users.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.

Technical Proficiency:

• Operating Systems: Windows XP,7.
• Languages: Clipper, T-SQL, HTML
• Data Warehouse Tools: SSIS, SSRS, SSMS, Business Intelligence Development Studio, DTS, Enterprise Manager.
• Databases: Dbase,MS Access, MS SQL .
• Reporting Tools: Excel, SQL Server Reporting Services, R R Report Writer, Crystal Reporting.
• Other Tools: MS Office, Visio, MS Excel,

Skills:

• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
• Bilingual Fluent in English and Spanish
• Served in the United States Marine Corp. 1978 - 1982