- 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.
- 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,
- 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