Natarshia Peck Email & Phone Number

Richmond, Virginia Area

Glen Allen

DBA, SQL/SSIS Developer•Duties include writing scripts,stored procedures and queries to create data files and transform text files into relational form ;update and create SSIS packages to export and import flat files from SQL serverDBA, Data Processing Programmer•Data Processing programming for multiple clients to import files, standardize and cleanse data, create output files, generate reports, and documentation.DBA, Administration • Database administration work including creating scripts to maintain database tables, views and indexes, backup and disaster recovery plans, upgrading SSIS packages, upgrading SQL Server servers, and monitoring servers.

Richmond, Virginia Area

Richmond, Virginia Area

DBA, Developer• SQL Server 2005/2008 DBA: Create new databases for customer management and processing applications. Implement databases across a SQL Server 2005/2008 Virtual/Cluster/Mirrored environment. Monitor cluster and mirroring status for database environments. Maintain database indexes and statistics routinely. Administer PCI based security procedures for user accounts and encryption security. Create back and restore procedures for ad-hoc and routine schedules for training, development, and disaster recovery procedures. Analyzed database structures for missing indexes or foreign keys. Create, monitor, and maintain SQL Agent Jobs for transactional data and SQL Server maintenance. Monitor server load via performance monitoring and SQL Server dashboard reports to reduce server bottlenecks due to SQL Server requests. • SQL Server 2005/2008 Developer: Create, test, and maintain T-SQL stored procedures, functions, views, and triggers. Create and maintain SSIS packages to import or export data to various internal and external systems and file formats. Create SSIS packages to run financial reports. Create and maintain SSIS packages for server maintenance. Provide suggested improvements for current T-SQL procedures to improve performance or improve data quality. Write ad-hoc queries to gather statistical data about the transaction data stored with the database. Create fact and valid values tables and views to support financial and operational reporting. • Reporting Analyst: Administer Crystal Server Reports. Set up user and groups to schedule reports to be delivered via email and to share drives. Updated various pre-written reports to use dynamic dates to allow them to be run without user interaction. Administer/Develop reports in SSRS and cubes in SSAS for offline reporting capabilities. Design ETL procedures for Data Warehouse processes. Administer the ReportServer and SSAS databases within Management Studio.

Remote

• SQL Server 2008 DBA: Gathered performance statistics on logistical and reporting based databases. Applied performance tuning measures at the server and database level to improve ETL and BI Reporting applications. Application based tuning for database access for Tableau BI Reports. Created and Administer the Database Maintenance plans for Indexes, Statistics, and Backups.• SQL Server 2008 Developer: Write Stored Procedures using T-SQL to transform, de-normalize, and load data. Maintain SSIS packages that run ETL scripts to load data from production databases to reporting databases. Create SSIS package to archive data from production and reporting into flat files with dynamic names based on archive date. Create procedures to cleanse data.• SQL Server 2008 Consultant: Provide database and server level suggestions for maintaining and improving the current environment including the Tableau server, IIS server, and Cold Fusion Server for hardware and software requirements.

Database Analyst: Maintain security rights and policies for Microsoft SQL Server 2000/2005 databases via Enterprise Manager/Management Studio and DCL scripts. Create/maintain logical star schema DB designs to support static reports and multidimensional cubes. Create/maintain SQL Server stored procedures, SQL Jobs and DTS packages that automate updating database entities. Develop/Maintain Microsoft Access database applications that perform ETL for data imported or exported into the Data Warehouse and other accounting based systems. Create and Maintain ETL scripts for Data Warehouse processing. Migrated SQL Server 2000 DTS packages to SQL 2005 SSIS packages. Create and restore DB Backups. Maintain Development and Integration testing environments.Report Developer: Design, develop, implement, and maintain revenue based, general accounting, financial analysis, management, and reporting solutions using the Cognos tool suite. Develop java script based web queries for ad hoc reporting.

Data Analyst: Revised and implement back end reporting procedures. Design new views and procedures to use as reporting data sources. Audit reporting database integrity problems. Develop Excel pivot reports and Crystal form reports for accounting and marketing analysis. Design Crystal from reports for Word and Excel formatting. Modify Crystal reports datasets, prompts, and calculations based on business rules. Maintain and revise scheduled reports as business rules change. Execute ad-hoc queries for instant data analysis.Reporting DBA: Maintain Sybase ASE 11.x user accounts, groups, roles, stored procedures, triggers, tables, replication subscription and definitions, and perform database maintenance. Perform logical table designs necessary for site application functionality. Troubleshoot and maintain SQL Server 2000 DTS packages for data transfer between SQL Server 2000 and Sybase ASE 11.x Modify and maintain BCP UNIX shell script for database maintenance functions.

Cognos Reporting Developer: Developed and implemented customized Cognos catalogs, cubes, and reports for the Department of Defense Procurement System. Provided Tier-1 customer support for the Cognos software. Performed installation and upgrade testing of Cognos software integrated with the Procurement System.

Bs, Management Science And Information Technology

Master Of Science, Information Systems