Jacquelyne Vann

Freelance Database Programmer & Database Designer

1591
Location:Tennessee, United States
Profile:https://www.freelanced.com/jacquelynevann
1
Kudos
4.5
2 Skills
$50
Rate/Hr
Jacquelyne E. Vann

PROFESSIONAL PROFILE

Database Analyst/Administrator with extensive experience designing, coding, testing and supporting database conversion packages using SQL Server DTS/SSIS. Extensive experience setting up administering and developing in SSRS and SSAS. Proficient in various technologies, including MS SQL Server, Microsoft Office Products (i.e. Word, Excel, PowerPoint and Access), Visio, IIS Web Server, JavaScript, VBA,Visual Basic, .NET, Active X Scripting, C#,C++, PHP, XML, HTML, CSS, SharePoint Development/Administration, Windows Server Applications ( i.e. IIS, Cluster Administrator and Terminal Services),Windows Operating System and Unix, Oracle and Teradata. Database Analyst/Administration skills include:

• Database monitoring and tuning
• Load Balancing
• Created and managed SQL backups
• Load and Transform data from Access, Excel, text/csv file and Mainframe applications
• Retrieving data from Teradata, Oracle, SQL Server and Mainframe data sources for conversion, analysis and reporting purposes.
• Planning, development and support of complex SQL queries, stored procedures and views • Database security, monitoring and controlling database access
• Index Planning and development
• OLAP/SSAS Database planning, design and development
• Planning, design and development of SSRS reports.
• Planning design and development of DTS and SSIS packages from Oracle, Teradata and DB2.

EXPERIENCE

PlanIT Technology Group (Amerigroup Corporation)
SQL Server/Access Developer 05/2010 – 02/2011
Extract load and transform data from various data sources. Gather and analyze data for reporting purposes. Building SQL Server and Access databases to meet Federal, State and Local government standards.
Key tasks:

• Lead in the design and development databases
• Developed automated SSIS 2005/2008 packages to extract, transfer, load and convert data from outside data sources and non-partition databases.
• T-SQL Using SQL Server 2005/2008 on partition and non-partition databases
• Developed reports using SSRS 2005/2008, .NET, VB and non-partition databases.
• Developed Windows Scripts
• Data profiling, looking for trend and patterns the data set.
Cook Systems International (FedEx Services)
Marketing Data Analyst 03/2009 – 02/2010

Extract load and transform data from various data sources within the FedEx organization using SSIS. Gather and analyze data for marketing campaign reporting purposes.
Key tasks:

• Lead the development of automated SSIS packages to extract, transfer, load and convert data from FedEx existing data warehouse to reporting database server.
• Convert and load data to FedEx data warehouse applications from various outside sources like Access, Excel and text/.csv files.
• Planning, development and support of complex SQL queries, stored procedures and views.
• Develop PL/SQL Scripts for analysis and reporting.
• Data profiling looking for trend and patterns in Marketing data.

G2 Technology (ServiceMaster)
Data Analyst/Administrator 03/2008 – 01/2009

Managed the SQL Server database for the Procurement Department. Extract load and transform data from internal and external data sources. Gather and analyze data for reporting purposes.
Key tasks:

• Lead in the upgrade and migration from SQL Server 2000 to 2005.
• Lead the development of automated DTS/SSIS packages to extract, transfer, load and convert data from various.
• Lead in the designed and development of reports of SSRS reports
• Planning, development and support of complex SQL queries, stored procedures and views.
• Converted and loaded data from Access, Excel, text/.csv files and other database applications.
• Performed database monitoring and tuning
• Created and supported SQL Server backups and jobs.
• Index planning and implementation
• Managed database security, monitoring and controlling database access.
• Planned, designed and developed databases and applications
• Managed IIS services, Cluster services and Terminal services.

FedEx Services
Security Data System Specialist 02/2003-06/2008

Managed and developed the SQL Server (SSAS, SSRS) database and ETL Processes for SDR&A. Extract load and transform data from internal and external data sources. Gather and analyze data for reporting purposes. Developed and supported the enterprise-wide security case management system.
Key tasks:

• Lead in the upgrade and migration from SQL Server 2000 to 2005.
• Lead the development of automated SSIS packages to extract, transfer, load and convert data from FedEx existing data warehouse to reporting database server.
• Lead in the designed and development of reports of SSRS reports and non-partition databases
• Created and managed SSAS, SSRS, SSIS and SQL Server Agent Jobs.
• Planning, development and support of complex SQL queries, stored procedures and views and non-partition databases.
• Converted, loaded and integrated data from Access, Excel, text/.csv files and internal FedEx database applications including the mainframe with data captured for security applications.
• Performed database monitoring and tuning
• Created and managed replication services from the server to server for backup and redundancy.
• Created and supported SQL Server backups and jobs.
• Index planning and implementation
• Managed database security, monitoring and controlling database access to all database servers.
• Designed and developed web applications and reports using .net, PHP, C#, asp, VBA, SSRS, Excel for the enterprise-wide security case management system.
• Planned, designed and developed databases and applications
• Performed load balancing and disk space planning in a multi-server environment.
• Created windows scripts
• Managed IIS services, Cluster services and Terminal services.

CADD Solutions(FedEx Services)
Developer/Data Administrator 12/2000-02/2003

Managed the SQL Server database SDR&A. Extract load and transform data from internal and external data sources. Gather and analyze data for reporting purposes. Developed and supported the enterprise-wide security case management system.
Key tasks:

• Developed and automated DTS packages to extract, transfer, load and convert data from FedEx mainframe application, excel, Access and text/.csv files to load into security’s case management reporting system.
• Planning, development and support of complex SQL queries, stored procedures and views.
• Performed database monitoring and tuning
• Lead the creation of security’s first web based case management/reporting system.
• Created and supported SQL Server backups and jobs.
• Index planning and implementation
• Managed database security, monitoring and controlling database access.
• Designed and developed web applications and reports using HTML, CSS, JavaScript, VBScript
• Planned, designed and developed databases and applications.

VP Buildings
Business System Analyst 01/1997-12/2000

Support and management of the company’s financial application
Key tasks:

• Supported and trained existing financial application.
• Lead PeopleSoft Financials data conversion/migration from Oracle to SQL Server.
• Planning, development and support of complex SQL queries, stored procedures and views.
• Developed database applications using Visual Basic.
• Developed PL/SQL scripts, queries and stored procedures.

EDUCATION & TRAINING
State Technical Institute, Memphis, TN AAS, Information Technology
University of Phoenix, Memphis, TN Pursuing BS Information Technology