SUMMARY

• To obtain a position as MS SQL Data Base administrator/Developer in a successful organization that will allow self improvement and take full advantage of my vast knowledge base.
• A focused team player motivated by organizational objectives related to performance, coordination and accountability for the Database Management System.

• Maintain data query environment by completing performance tuning, query optimization, and performance profiling.
• Perform code reviews, analyze execution plans, and re - factor inefficient code.
• Investigate data and reporting anomalies, providing support for maintaining and modifying databases and reporting.
• Design, build and deploy actionable reporting solutions while following established standards.
• Ensure data accuracy and reliability.
• Proficient in SQL Tuning and writing efficient SSIS packages.
• 6.8 years with SQL Server RDBMS
• 6.8 years developing T-SQL Stored procedures, tables, views, common table expressions.
• Studies existing information processing systems to evaluate effectiveness and develops new systems and data specifications to improve production or workflow as required.

TECHNICAL SKILLS

• T-SQL
• SQL Servers 2005. 2008/r2. 2012
• BI Stack
• Visual Studio 2005. 2008. 2010. 2012
• SSIS
• SSRS
• Power Pivot
• Pivot tables
• Pivot charts
• Power BI
• Share Point integration.

PROFESSIONAL EXPERIENCE

SQL Developer

Confidential

Responsibilities:

• Created Visual Studio project in 2012 Visual Studio to adjust and create new functionalities in existing Project.
• Created SQL tables, stored procedures and scripts.
• Connected to SQL database objects using CLR (C#) stored procedures, tables and views.
• Created technical document.

SQL Server Developer

Confidential, Broomfield, CO

Responsibilities:

• Used (SSRS ) SQL Server Reporting Services
• Used and adjusted (SSIS) SQL Server Integration Services (ETL)
• Used SSIS to extract data from external source into internal database for SSRS reporting.
• Created SQL queries, stored procedures and modified existing SQL scripts
• Did data analyst and studied database architectural makeup
• Used SAS 9.4 add-on in Excel 2007 to create data source for SSRS reporting.
• Software development team member
• Checked existing databases to insure maximum performance

SQL Server Administrator\ Consultant

Confidential, Denver Colorado

Responsibilities:

• Analyzed current 2005 SQL Server database systems for problems and /or issues.
• Did interviews with customers to identify problem area / Stored Procedures.
• Wrote SQL script to identify current file(MDL) capacity for three month periods for charting purposes.
• Wrote SQL script to identify long running stored procedures for charting purposes.
• Created traces for SQL Profiler.
• Created files (Trace) for Database Tuning Advisor to identify problem indexes.
• Used SQL Activity Monitor to monitor daily database activity.
• Identified index issues, created and /or rebuilt/ organized to improve performance.
• Advised client on future capacity planning and possible upgrade of SQL Server 2005 to SQL Server 2008r2 database.
• Generated reports (SSRS) to identify performance issues on remote servers using SSIS to extract data.
• Working Knowledge of SQL Server 2012 environment

SQL Developer

Confidential, Lincoln NE

Responsibilities:

• Created Sql queries.
• Created tables, temp tables, views, stored procedures, user defined functions and indexes.
• Alter and/or update existing stored procedures/view based on customer/ requestor change request.
• Troubleshoot queries using query plans and hints.
• Created SQL script to drive SSIS packages.( ETL)
• Created and maintained reports generated in SSRS from multiple external data sources.
• Created and maintain SSIS/ETL packages using Business Intelligence Development Studio (BIDS) 2008/2010 importing and exporting data warehouse.
• Utilized BI and TFS(Team Foundation Server) including but not limited to Stored Procedures, Views, table maintenance, SSRS, and .Net CLR development
• Working Knowledge of SQL Server 2012 environment

SQL Developer

Confidential, Colorado Springs, Colorado

Responsibilities:

• Responsible for creating and maintaining the data model and physical integrity of one or more databases
• Installs, upgrades and maintains database management systems
• Ensures database system stability thru monitoring, performance tuning and capacity planning
• Designs, develops, and documents logical and physical data structures based on conceptual data definitions and models
• Created data link between three remote servers.
• Created Replication (transaction) between three servers.
• Created Report Server (SSRS) on internet facing server.
• Created Reports using SSRS from 11 different data sources utilizing SSIS.
• Created SQL code for report generation.(SSRS)
• Created ASP login page for internet facing Report Server
• Monitored SQL Server performance, Did updates and tuning made adjustment where needed
• Created and maintain backup’s schedules and recovery plans.
• Created reports based Analysis Services result set(SSAS).
• Created and maintain SSIS/ETL packages using Business Intelligence Development Studio (BIDS).
• Created database, tables, stored procedures, functions, views as need.
• Through research, training, self-study and self discipline, stays informed of new developments within the field

System Administrator

Confidential, Colorado Springs, CO

Responsibilities:

• Analyzed and identified potential issues with Microsoft computer operating systems.
• Introduced and integrated new technologies into existing environments.
• Performed routine audits of systems and software.
• Performed Backups
• Applied operating system updates, patches, and configuration changes.
• Installed and configured new hardware and software.
• Added, removed, or updated user account information, reset passwords, etc.
• Answered technical queries.
• Responsibility for security.
• Responsibility for documenting the configuration of the system.
• Troubleshooting LAN, Desktop, Server and software issues.
• System performance tuning.
• Ensuring that the network infrastructure is up and running
• Create Reports using Microsoft Services in BID environment (SSRS).

SQL Server Report Server Developer

Confidential, Colorado Springs, CO

Responsibilities:

• Monitored SQL Server performance using Server Profiler.
• Created various traces to identify slow running quires and stored procedures.
• Created indexes on tables based on Database Tuning Advisor.
• Developed Reports using SSRS reporting service.
• Used Visual Studio Business Intelligence to create and update reports.(SSRS)
• Creating Matrix and tabular reports
• Creating reports based on customer requirement. (AHOC)
• Created stored procedures and scripts to support data for(SSRS) reports
• Updated current reports

Database Developer

Confidential, Denver, Colorado

Responsibilities:

• Utilized SSIS packages to retrieve data
• Created SSIS packages using Visual Studio/Business Intelligence
• Monitored query performance using server profiler
• Monitored query performance using execution plans
• Created stored procedures to filter data based on audit requirements
• Moved and recreated stored procedures
• Did stored procedure testing to transfer to production status
• Created reports(SSRS) based on data generated by stored procedures from different data sources
• Created insert statements to insert large amounts of data into multiple data bases based on trigger statements(data warehouses).

Database Administrator (TSQL)

Confidential, Colorado Springs, Colorado

Responsibilities:

• Gathered database requirements, formulated conceptual design
• Installed and configured instances of 2005/2008 MS SQL Server
• Created file groups and Databases
• Created disaster recovery Plans
• Created Backup and recovery/restore strategies
• Created maintenance plans to execute scheduled backups
• Created logins and assigned server-scope permissions
• Did Troubleshooting to resolved database issues.
• Used query execution plans to monitor query cost.
• Used Server Profiler to monitor lock/deadlock activity.
• Used Activity monitor to gather information about user connection and locks held.
• Used System Performance monitor to monitor SQL server cost on system resources.
• Used Database Tuning Advisor for recommendations to improve performance.
• Imported and exported data to and from SQL 2005/2008 Server using SSIS integration.
• Knowledge in use of Clustering Log shipping replication environments.
• Knowledge in use of MS Server 2005 Analysis Services (OLAP) created Cubes, fact tables, dimensions in the form of Star/Snowflake Schema and extracted data for Report creation.
• Knowledge in use of Visual Studio Business Intelligence Environment.
• Knowledge and use of SSIS packages to extract, transform and load data.
• Created monthly Batch processing packages in SSIS Business Intelligence to load data ware house grouped by month/year.
• Created Stored Procedures to generate batch processes.
• Knowledge in use of Replication transact, merge and snapshots.
• Created reports using SQL Report Server Services(SSRS)& Access database.
• Extracted (SSIS) from external sources and loaded data into database for SSRS reporting purposes.