SUMMARY:

• Self - starter, highly organized and motivated, team leader, problem solver and creative thinker with abilities to plan, organize, prioritize, projects and mentor developers. Seeking a BI Architect, BI Developer and Database Engineer position to support a company initiative to organize their data structure, quality, security, analysis, visualizations, ETL, and database system design and architecture; in addition, leading or managing the development team.
• 17+ years as production support SQL Server DBA, expert in Scheduling SQL Agent jobs, migration, consolidation, upgrades, backup and restore, log shipping, mirroring, replication, performance tuning, capacity planning, troubleshooting, server hardware and components, disk subsystems Raid Set, SAN LUN, Solid state
• 17+ years programming developer with T-SQL, batch scripting and optimizing T-SQL, stored procedures, functions, triggers, views, indexes, constraints, file groups, partitions, tables, data types.
• 17+ years designing and developing, from concept, both the physical and logical Entity Relational data model: login and role base security, employee management, lead management, log events, inventory, invoice, fulfillment, batch processing healthcare models and remapping data from old models to new models.
• 8+ years designing and developing, from concept, the physical and logical Star and Snowflake data model, Type 1, Type 2 and Type 3 records for operational and analytical reporting and analysis.
• 10+ years programming DTS and SSIS, Loading data from Oracle, AS400, DB2, SQL Server, Excel, flat files, Consolidating data from heterogeneous sources, moving data between systems, Loading data warehouses, Cleaning, capturing, and standardizing data, Identifying, capturing, and processing data changes, and Creating SSIS batch processing frameworks.
• 5+ years BI developer with custom report request, SSRS and Excel report development, data quality standardization, outlier discover, and basic statistic understanding.
• Strong technical, interpersonal, and creative skill with ability to communicate efficiently with senior management and software engineer to create functional and design specification.

TECHNICAL SKILLS:

Languages: T-SQL, VB.Net, C#, VB, VBA

Data Base: SQL Server 2000, SQL Server 2005, 2008 R2, 2012, 2016

OS: DOS, Windows NT 2003, 2008, 2012

Application: SSIS, SSRS, MDS, IIS, Excel, Visio, SQL Sentry, Spotlight

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, Georgia

Database Engineer, SSIS Developer, Data Conversion Analyst

Responsibilities:

• Designed an ETL plan to use SQL server 2016 and SSIS to manage the ETL process to pull data from Bond Adapt applicant tracking systems to confirm to Microsoft CRM input file formats.
• Worked with 3rd party vendor’s developers to create project plan and tasks and deliverables.
• Create a process to pull a set of Accounts by certain parameters and all the dependent sets of corresponding data such as, business contact, office, billing, and job location addresses, job orders, application (submittals), assignments, and recruits and all the recruits’ dependent attributes and documents (resumes).
• Reverse engineered the source of data from the Bond Adapt ATS forms by using SQL profiler traces and using excel to document the data path to CRM input file formats.
• Created MDM tables to manage attribute translations between systems.
• Performance tuned the ETL process by indexing staging and MDM tables, and creating pre-staging tables, and using query plans to find bottlenecks in the ETL T-SQL code.
• Mapped the Microsoft CRM input field to the Bond Adapt ATS field by using SQL profiler to see where and how data was being stored.

Confidential, Alpharetta, Georgia

Database Engineer, Data Modeler, SSIS Developer, DBA, Solution Architect

Responsibilities:

• Documented user requirements to Software Specification Requirements by using Word, Excel, and Visio.
• Fostered meeting with senior managers to define fact and dimension models and measures for the EDW.
• Mentored junior developers with understanding data semantics, T SQL Code, SSIS, and DBA tasks.
• Create a performance model to measure the performance of a cell phone insurance claim being filed to the time the claim is fulfilled by the warehouse and the device is sent to customer.
• Create a performance model to measure the performance of a cell phone insurance claim when a same unit repair involves repair vendors.
• Developed the T SQL code that would transform the transactional ODS data to a linear model of time sequences to measure the length of claim processing and repair cycles at various point.
• Created Excel workbooks to access SSAS cubes to layout the various models of the data using pivot tables, charts, and slicers.
• Installed SQL Server 2016 MDS application and configured models and entities and loaded data to support business requirements and created a custom DDL trigger to inforce and automatically assign roles security to views to access the data from the MDS database.
• Performance tuned complex T SQL ETL code for performance and ease of reading, used techniques such as CTE, temp tables, in memory tables, columnar store tables,
• Designed a SSIS and C# batch control system to import flat files without having to create a new SSIS package each time.
• Coded a T SQL table partition process to dynamically switch out data from tables.
• Managed 8 2014 and 2016 SQL Server DB with about .5 terabytes of data.
• Involved with SOX security audit and setup of role base groups in Dev, QA, UAT, and Production.
• Monitored various production SSIS ETL loads and managed index.

Confidential, Duluth, Georgia

Database Engineer, Data Modeler, SSIS Developer, DBA, Solution Architect

Responsibilities:

• Engineered 3 retail POS data warehouse from concept to implementation.
• Mentored junior developers with design, coding practices, and SSIS development.
• Created customer dimension table to manage merging multiple customer accounts into one Account.
• Developed algorithm using T-SQL for exact pattern matching and SSIS fuzzy matching to find customer account that would roll up to one account.
• Automated with SSIS, address standardization, DPV, and CASS, geocoding, and profile mapping.
• Automated with SSIS NCOA (National Change of Address) process to send and receive address information.
• Implemented a reverse append process that would send method of payment credit card information to a 3rd party vendor that would send back a customer name and address for processing
• Used SSIS to automate file directory, FTP, SFTP, and FTPS file downloads and uploads.
• Collaborated with Data Analysis team to create Customer Segments by analyzing shopping patterns such as purchases, visits, tenure, and also creating Geographic Profiles buy analyzing loyalty and closest store.
• Created various operational reports about sales data and identify data quality issues. .
• Maintained backups, security, index and T-SQL tuning, stored procedure and function coding.

Confidential, Norcross, Georgia

Database Engineer, Data Modeler, SSIS Developer, DBA, Solution Architect

Responsibilities:

• Collaborated in a 4 person Solution Architect team to document online webstore data warehouse from data source to fact and dimension tables.
• Used Excel to create mapping data flow documentation and used Visio to create data flows diagram.
• Worked with system Architects to understand and document business processes.
• Worked with senior partners to create project plans to assign task and resources.

Confidential, Smyrna, Georgia

Database Engineer, Data Modeler, Excel Programmer

Responsibilities:

• Used an existing Excel workbook application that managed the broadcast scheduling of programs, I facilitating scope and discovery with the client and gathering requirements that outlined the functional and non functional requirement for a SQL Server 2008 R2 database and Excel VBA forms and reports application.
• Created a 10 table 3 normal form data model in SQL Server 2008 R2 and developed store procedures for the calling application and coded triggers for auditing.
• Developed Excel forms to enter and update the data; in addition, to developing Excel reports.
• Imported and mapped data from Excel worksheet into the tables using SSIS and T-SQL code.

Confidential, Atlanta, Georgia

Database Engineer, SQL Server Solution Architect

Responsibilities:

• Provided SQL Server 2008 R2 DBA production and development support, troubleshooting poor server performance, Optimizing stored procedure, functions, and adhoc T-SQL, index tuning, and creating new table and triggers.
• Assigned ownership of Healthcare Business Intelligence application for Cardiac Catheterization Lab (CCL) and Ortho Spine and Joint information management systems.
• Assigned the task to document, automate, and correcting reporting and benchmark anomalies in the manual quarterly data marts process.
• Create Individual or peer grouping of medical facility benchmark models of CCL procedures involve case documentation of supplies and medications used, as well as procedure and outcomes.
• Ex (Best in Class, National Averages, Volume Class Averages, by Quantity Used, Inventory Cost, Total Cost, Procedure Time, and Length of Stay (LOS); in addition to, grouping the data by procedure classes such as CRM, EP, Ablation, Stenting, Ballooning, Value replacement, by various vascular location or cardiac defect.
• Engineered a solution to automate the manual running of 17 T-SQL scripts and ETL of data from the ODS.
• Refactored the T-SQL code by organizing function and batch scripts using schemas, using tables to store runtime parameters, and using T-SQL reformatting tools to format code for easy of reading.
• Scripted main style store procedure to call all other procedures as a single batch.
• Used SQL Profiler to capture underperforming T-SQL code, then either added indexes and statistics or refactored the T-SQL code to improve performance.
• A star schemas type 1 model of cases was used to control sample size and data quality reporting.
• In addition, summary statistic, such as, central tendency, standard deviation, percentile, quartile, skewness, kurtosis, five-number summary where derived from the star schema model.
• Coded percentile, skewness, and kurtosis statistical equations in T-SQL.
• An Excel workbook that would query the tables for a set of data to display in Excel to be used in boxplot, histograms, and bell shape column charts, to help understand data distribution before and after outlier removals for Length of Stay, Total Cost, Total Time by clinical procedures.
• Created an Excel dashboard to display 400+ benchmark outcomes and transaction data used.
• Used Visio to create ER models and Data flow diagrams, and used excel to create mapping of parameters, tables, and columns used by benchmark.
• Create an Excel file format and data element capture protocols to load hospital patent billing information.
• Create 2008 R2 SSIS packages that used the new XML configuration file, used Script task, Script component, Control Flow and Data Flow tasks to transform the data, and for data imports and exports to and from Excel and text.
• Import the data into tables, using rules to classify outliers, then used mathematical rules (Two-Sigma rule OR 99.9 percentile, to remove additional outliers.
• Design mapping tables to map department (cost centers), activity, and UB92 codes to standard transaction Identification.
• Create Staging table to preaggrate dataset by combining attributes such as MSDRG Codes, doctors, Day of Admit and Discharge, additional analysis by segment based on type of room and cost of room and board, Length of Stay, type of blood, insulin dependent, and age.
• Loaded Star schema Fact and Dimension tables with final results.
• Created and Excel workbook using VBA, ADO, and Excel 2012 automation to pull data out of fact tables and load worksheets link to either pivot tables or charts.
• Provided SQL Server 2008 R2 DBA production and development support, backups and restore, performance tuning, file migration, memory tuning, processor tuning,.
• Created 2008 R2 SSIS ETL Bus frame work, with the following components: Batch File Control system to load files and provided an audit trail of when and who processed the file, if the file completed processing and added metadata to the record to track what file the record came from or what file and record provided the change.
• Created a SSIS Batch Scheduling Control system to create data files by tracked the date range of records in the files and if the file was ever created.
• Created audit tables and triggers to capture and log changes to finical transactional data.
• Used T-SQL merge statement to captor updates and deletes of data changes and write what data changed to audit tables.
• Designed Active directory OU to manage role based security.
• Optimized SSIS packages and SQL Server 2008 R2 to insert 1 Billion record files.
• Create star data model to support both Type 1 and Type 2 record inserts and updates with a partition design both using federated tables and SQL Server partition indexes .
• Designed tables to file groups to SAN LUN mappings and sizing guides to support 1 TB size tables and 3 TB databases.
• Designed table partition by Month and year to map to file groups
• Created operational SSRS Reporting Service reports.
• Performance tuned data warehouse workloads by change locking, threading, and index strategies.
• Tested and bench marked NAND Flash SSD Storage Solutions: Violin Memory, Kaminario K2, and FusionIO with Data warehouse loads and as TempDB accelerators.
• Worked with system teams to benchmark vendors HBA hardware and EMC Clarion CX300 SAN by configuring various Raid types and LUN.

Confidential, Atlanta, Georgia

Database Engineer, SQL Server DBA

Responsibilities:

• Provided day to day SQL Server DBA issue support of 98 production 2005, 2008, and 2008 R2 SQL Server.
• Configured the memory allocation and the distribution of SQL server instances on 2 and 3 node Windows Clusters.
• Create 5 two node Windows Server 2008 R2 Clusters with each have 2 instances of SQL server 2008 R2 one was a VM and one bare bone server.
• Performance tuned a poor performing Microsoft Dynamics Solomon applications database by tuning memory to prevent paging to disk, automating a online index rebuilding job to optimize disk IO, rebuilding the transaction log files.

Confidential, Atlanta, Georgia

Database Engineer, SQL Server DBA, T-SQL Developer, BI Developer, Data Analyst

Responsibilities:

• Review current data model, made changes, added indexes, and add new table for new reporting functionality.
• Coded new T-SQL functions, triggers, store procedures to meet new reporting needs.
• Created or modified 2008 R2 Reporting Service reports by using TABLIX and chart object to meet the software specification requirements
• Work on a design to consolidate 6 servers to 2 servers by using Marathon Technologies everRun MX to create a fault-tolerant server solution which uses a Type-1 Zen hypervisor with a more configurable hardware solution..
• Analysis performance and logical problems in custom application code and made correction and recommendation to correct problems and made recommendation on best practices on new SQL 2008 R2 server installations.

Confidential, Atlanta, Georgia

Database Engineer, SQL Server DBA, Data Modeler, ETL Developer (SSIS), T-SQL Developer, BI Developer, Data Analyst

Responsibilities:

• Designed a 3 tier ETL Buss using SSIS to load data into a star schema for processing.
• Create 2005 SSIS packages to load data from various data stores.
• Performance tested various ETL load and export patterns for flat file, and xml files.
• Performance tested various ODBC and OLEDB drivers to extract data from the AS400.
• Research and developed procedures for various data quality issue in the various data extracts.
• Developed a 370 DTS to SQL 2008 SSIS migration design by documenting and mapping out all the ETL and EAI data paths and schedules of the current data warehouse and the schedules of the data processing inside the various policy management systems and capacity planning of current system.
• Gathered operational requirements and designed a set of 2008 SSIS templates that where configurable use SSIS configuration files, added customized logging to automatically record begin and end times of SSIS package execution, amount of records processed, amount of records failed processing, automatic email of SSIS package failures to operations, and the ability to customized file imports and export file names and path.
• Planned on how to convert 370 DTS packages to SSIS and added an additional 200 SSIS packages.
• Designed an SSIS ETL process to snap shot all required data from claims and multiple policy management system in SQL 2000, SQL 2005, DB2/AS400 databases to create a Repository of Raw Data to be used by the old data warehouse and new data warehouse in design.
• Coded and Event driven ETL and EAI bus design to first move raw data from repository and adding metadata (lineage) and MD5 Cryptographic hash value to records and loading the data into staging tables, then the demoralizing policy and transactional data into tables, then creating the aggregated tables for reporting, and then creating any data files for downstream systems.
• Created a taxonomy to classification what the individual SSIS packages where processing and used SQL Sentry to manage the dependency and execution and SSIS packages.
• Managed a group of SQL Server 2000 and 2005 x86 databases on a Type 1 Hypervisor x86 (ESX 3.5).
• Analyzed performance problems with virtualized database system by capturing performance data from both the Type 1 Hypervisor and guest operating system to create capacity planning reports.
• Create security reports to create an audit frame work to clean up login account and permissions.
• Working with the developers and SQL Server Profiler, to facilitate performance and errors research of applications problems.
• Created an upgrade path for a new Windows Server 2008 x64, SQL Server 2008 Enterprise x64, using a blade server with a Type 1 Hypervisor x86 (ESX 3.5), and using 15 disks from EMC SAN and Database Mirroring across sites.
• Created a seconded upgrade path to a newer database system that used Intel 7500 EX processors and a PCI SSD (Fusion IO) since the current benchmark validated a faster server design.
• Coded T-SQL scripts and documented an upgrade path from SQL Server 2000 to SQL Server 2008.
• Work and trained with both .Net offshore and local development teams and operations, to transfer knowledge and assists with Architecture Guidance.
• Developed solution with QA teams to test Migration of databases and new SSIS ETL process.

Confidential, Atlanta, Georgia

Database Engineer, SQL Server DBA, T-SQL Developer, SQL Server Capacity Plan Developer

Responsibilities:

• Created a Technical review for improvements of the Current SQL Server 2005 database, hardware, ETL processing, and SQL Server 2005 Analysis service.
• Used performance monitoring tools, waits states, virtual file stats, and SQL Trace to identify bottle neck and problems with current architecture.
• Created a cost model of upgrade paths of current servers and new server and direct attach storage.

Confidential, Atlanta, Georgia

Database Engineer, SQL Server DBA, ETL Developer, T-SQL Developer, BI Developer, Data Analyst, SQL Server Capacity Plan Developer

Responsibilities:

• Create IIS log file data ware house to analyze internal website usage by create a SSIS ETL process to load the files, a data warehouse using star schema to report on the data, and SQL Server 2005 Reporting Services reports with views to provide staff with reports and used Access 2003 ADP project for add hoc reports.
• Create SSIS packages that used the new XML configuration file, used Script task, Script component, Control Flow and Data Flow tasks to transform the data, and for data imports and exports to and from Excel and text files and used SQL Agent to schedule the packages.
• Extensively used SSIS Import/Export Wizard, to perform ETL operations.
• Used SSRS 2005 by defining data source and building data source views to create tabular and crosstab tab reports; in addition, to installing, managing, and publishing reports.
• Maintain an ETL process that collects 10,000 log files from various telecommunication devices that used the following Microsoft technologies VB to poll and schedule polling of devices, MS Messaging Queue to queue the polling and import process, and DTS Packages to extract, load, and transform data.
• Maintain a one Terabyte data warehouse by research data anomalies and Tuned the data warehouse by using file groups and table partitions, rebuilding indexes, dropping unused indexes, adding new indexes.
• Create project plan for SQL Server 2005 consolidation, migration, and upgrade of multiple databases into 2 servers.
• Architected new x64 Enterprise SQL Server 2005 Data Accessing Layer using 2 IBM servers with 2 socket Quad Core Intel 5100 Xenon series processors, 2 IBM DS3000 NAS that used 24 15,00 RPM SAS drives and 2 card dual port 4Gb port Qlogic HBA.
• Ran performance metrics using SQLIO to determine how to configure raid groups by compare Raid 10 and Raid 5 performance, and the amount of disk per raid group, disk NTFS tuning, and HBA settings.
• Migrated a SQL Server 2000 650 GB data warehouse on a 8 yr old Enterprise Unisys server that was clustered and EMC SAN to midrange IBM server and NAS, by using LiteSpeed Backup compression to move the database, SQL server 2000 log shipping to mirror the database, then used detach and attach data files to do an in place 2005 upgrade.
• Migrated and consolidated 8 databases with a total of 350 GB of data by using LiteSpeed backup compression to move the database and use 2005 Mirroring technologies to keep database in sync before conversion date.
• Remapped all SQL Server security to manage accountability, by using lest privilege principle by isolating all SQL service account, by creating new login account and giving explicate object level permission to applications, separating SQL Admin account from developer’s roles, and using NT Login account for DBAs.
• Create new Backup plans using quest Litespeed Backup, used SQL Sentry Event Manager to report on DTS errors and to analyze Schedule conflicts, Use Quest Spotlight, SQL Server Profiler, DMVs to analyze wait stats of SQL Server Wait types and NT Performance monitors to analyze under performing T-SQL and Disks to file group layout.
• Provided 24 / 7 on call production support of SQL Server.

Confidential, Atlanta, Georgia

Database Engineer, SQL Server DBA, ETL Developer

Responsibilities:

• Managed 600 GB OLTP SQL Server 2000 HA Cluster 600 GB that process 1.2 million dollar a day of quotes and policies.
• Created design and requirement documents for change control board and use Project Manager to layout, task and schedules.
• Installed and used Quest Spot Light and Performance Analysis to monitor HA SQL 2000 system, in addition to running performance monitor and performance monitors to baseline system.
• Installed and Configured SQL 2005 and applied Service Packs to cluster, and conducted security audits.
• Removed custom log shipping solution, then configured SQL 2000 Log Shipping for reporting server and created a HA hot stand by server .
• Documented ER model of current DB system, removed tables not related to current OLTP system.
• Architected a new backup strategy for 9 SQL 2000 and 2 SQL 2005 Server, by using once a week full backup, differential backup every 24 hours, and transactional backup every hour.
• Ran SQL trace (profiler) to analysis system performance problems, by finding poor performance T-SQL and baseline store procedure calls.
• Using query plans to rewrite T-SQL statements and identify where statistic and indexes needed to be created and worked with developers to write code using best practices.
• Ran tools such as sp who2, sp lock, sp blocker pss80, and DBCC INPUTBUFFER () to resolve locking problems and worked with Microsoft Support to identify locking problems with HA SQL Server 2000 system.
• Architecture a new solution to migrate current HA SQL 2000 to 2005 by moving from 32 bit to 64 bit and choosing PowerEdge2900 2-Socket, Quad-Core servers.
• Designed new ETL processes to load tables in production using DTS.

Confidential, Cumming, Georgia

Database Engineer, SQL Server DBA, T-SQL Developer

Responsibilities:

• Analyzed the business requirement to architect and configure a Geographically Distributed High Availability and a scalable data service tier using x64 Windows 2003, x64 SQL Sever 2005, x64 hardware, for the new Microsoft SharePoint Service (MOSS 2007) implementation and Operation Manager 2007.
• Managed the project and staff by creating work items and work tasks using Project Manager 2005 and Excel.
• Designed Failover Cluster Solution by using MS Cluster Service in a 2 node (Dell x64 servers) active passive configuration.
• Create a Development and QA Server environment to test SharePoint 2.0 and SQL 2000 to SharePoint 3.0 and SQL 2005 upgrade.
• Setup a Virtual Server R2 2005 environment to test configuration issues.
• Designed and implemented a new SQL 2000 Backup plan for existing environment and resolved day to day problems with the SQL servers.

Confidential, Atlanta, Georgia

Database Engineer, SQL Server DBA

Responsibilities:

• Analyzed the business requirement to architect and configure a Geographically Distributed High Availability and a scalable data service tier using x64 Windows 2003, x64 SQL Sever 2005, x64 hardware, and EMC storage for the current Microsoft Dynamics Axapta 4.0 implementation.
• Worked with managers to help organize projects task based on scope of project and dead lines.
• Designed Failover Cluster Solution by using MS Cluster Service in a 2 node (Dell x64 servers) active passive configuration connected to an EMC Raid 1+0 and 2 x Raid 1 configurations for redundant data storage and cluster Replication Distributor
• Designed Geographically Distributed Disaster Recovery Solution by using Log Shipping
• Designed AD Security Solution using organizational unit (OU) and groups to simplify security management of Cluster and SQL Server accounts and administrative users.
• Configured x64 Windows 2003 MS cluster service, 64-Bit SQL Server 2005 failover cluster and Log Shipping
• Created test plan to verify the technical requirements by creating a strategies to test SAN to server conductivity, cluster hardware failures, cluster service failures and geographical distributed log shipping.
• Provided tier 1 and data quality support for mission critical OLTP for terminal based card activation and reloads on x84 SQL Server 2000 with several horizontal partitioned 200 GB sized databases and x84 Widows Server 2003 clustered environment.
• Analyzed data model and made design changes to table structures, data types, and used file group to segment tables. Also add to the data model by design new tables to capture batch and transactional data updates.
• Provides team leadership by mentoring entry and junior level SQL developer by teaching them advance T-SQL skills, and helping them understand relational data models, business models and processes.
• Developed DTS packages to automate file and batch processing, made DTS packages configurable at runtime by using XML document, and created complex path of execution by creating if path by disabling and enabling DTS objects at run time.
• Documented and scripted, debugged, and optimized complex T-SQL statements (cursors, theta join, temp tables, unions, group by and case statements) to fix production data in billing, transactions, Ebase40, and reporting systems.
• Worked with the account department to create financial models to analyze sales and billing transaction data, researched reporting anomalies, and discovered lost revenue.
• Created algorithms based on the current Business model to mine the sales transaction date which lead to discovering on average of $30000 month in extra credits being issued and discovered sales transaction that would not be build because of violation of business rules but where not reported on.
• Created star schema models to load sales data and created T-SQL statements to dice the data by many view for sales teams.
• Discovered holiday capacity performance issues in the SQL Server environment and provided solutions to increase transaction rate of the database by using such strategies as performing file growth of peek time, remove fragmentation by rebuild cluster and no cluster indexes, updating statistics, and increase the amount of transaction log backups.
• Using .Net 2 and Enterprise library programmed a socket driven main frame message passing simulator and create a batch file processing and message passing utility to process reloadable debit card account request through a web service.
• Modified and created Reporting Service reports and setup and maintained replication and modified custom replication store procedure.

Confidential, Atlanta, Georgia

Database Engineer, SQL Server DBA, ETL Developer, T-SQL Developer, Data Analyst

Responsibilities:

• Developed DTS packages that where configurable from xml file to make transition from Development, QA, and Production trouble-free.
• Developed DTS packages to copy, delete, move files and load multiple files, log errors in tables, receive and pass parameters to T-SQL statements, move data between databases and created dynamic T-SQL to update SQL task objects.
• Developed processes to query multiple 200 G size databases for customer’s data using store procedures, functions, dynamic T-SQL, and created views to manage horizontal partition tables.
• Wrote reports to base line system using Perfmon Counters to gather data, Excel to format the data, and wrote a price to performance report for new server purchase.
• Created Reporting Service reports for management using Visual Studio 2005 and VB.NET.
• Researched and corrected locking problems, backup databases, wrote SQL Agent Jobs, optimized T-SQL statements by using indexes, statistics and join hints.