Business Analyst/ Sql Server DBA
Resume:
CHAUNNAH RAILEY - MBA
Southaven MS 38671
901-***-**** **************@*****.***
SKILLS: Software – Hardware – Operating Systems - Printers
Programming Languages: SQL Server 2000 / 2005/ 2008/ 2012/2014/2016, SSIS packages, DTS Packages, SQL Report Services.
Software: Microsoft Software (Project, Word, Excel, Access, Outlook, FrontPage, Money, Works), Crystal Reports (versions 6, 8.0, 8.5), Norton Utilities, Netware, PC Anywhere, Zetafax, AOL, Internet Explorer, SQL Server, Lasso, FileMaker Pro, C++, Assembler, COBOL, AS/400, Visual Basic, Authorware 5.0, Trainersoft, Director 8, Dreamweaver, FrontPage 97 and 2000, Drumbeat, HTML, JavaScript, CSS, .NET
Hardware: PCs, Servers & Peripherals (Windows NT Server 4.0, Windows NT Workstation 4.0, Webstar, Snap Servers, IBM, Dell & Compaq); Citrix Servers; Ethernet NICs, Routers & Hubs.
Operating Systems: Microsoft Windows 3.x/95/98/NT/2000/XP/7/8, MS-DOS, UNIX, Macintosh OS 8, 8.6, and 9.0
Printers: Hewlett Packard, Epson, Cannon, Lexmark.
PROFESSIONAL EXPERIENCE:
Business Analyst/SQL DBA/Data Warehouse - CRS (Arkansas) 3-2018 to 8-2018
Migrate SQL Databases from 2012 and 2014 to 2016.
Creatied a system for reporting of data utilizing SSRS, SSAS.
Extracted data from internal data warehouse system to SSRS
Created Reports as needed.
Created procedures and jobs for database optimization.
Developed and tested backup and recovery operations and provided documentation instructing on procedures.
Minimized user access based on need using SQL users and groups and AD as needed.
Created jobs to report on data integrity, utilizing indexing, and daily and weekly dba maintenance jobs not in place.
Business Analyst/SQL DBA/Data Warehouse - Highline Aftermarket (Memphis, TN) 7-2017 to 2-2018
Build and implement a series of databases (staging, test, prod) to manage internal and external data sources routinely.
SDLC
Creating a system for reporting, capturing and correcting error of data utilizing SSRS, SSAS.
Extracted data from internal data warehouse system to SSRS
Work with SAAS Cloud services
Agile/SCRUM as a utility to utilize SDLC with current technology to optimize new processes with older methods and changing needs.
Created ad-hoc reports
Created SP's and formulated basic coding and scripting to be utilized for reports within the organization
Responsible for gathering requirements and designing data mart entities and data warehouse
Working with system supporters in automating and evaluating applications for future needs.
Implementing best practices to ensure optimal performance.
Maintain all Databases, data integrity, indexing, daily and weekly dba maintenance.
DB backups nightly and Monthly.
Tracking storage usage and making recommendations.
SQL DBA - City of Memphis (Memphis, TN) 2- 2015 to 12-2017
Maintain 30 SQL Servers ranging from SQL 2000, 2005, 2008, 2012 and 2014. Over 1500 databases
Analyzed current business practices. Recommended software changes and updates for multiply software pieces for use in house.
Work with SAAS Cloud services.
Advanced Excel(pivot tables, vlookup, modules, ODBC, ADO and complex formulas.
Facilitate sprint planning, daily scrums, retrospectives and software demonstration
Active Directory Troubleshooting, user creation and user maintenance
Microsoft outlook troubleshooting after moving to office 365 platform and using powershell scripts for such purposes.
Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard, supported more than 20 client companies, using ' general business reports and used SDLC.
Developed different type of reports using SSRS and SQL Server 2008/2012/2014.
Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
Expertise in T-SQL writing stored procedures, triggers and functions.
Expert in data transformation services SSIS, DTS.
Experience in using DMV and dynamic management functions for finding out long running queries.
Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
Worked on configuring SQL Server with minimum privileged access.
Troubleshoot performance problems, fine-tuning of databases and index Analysis.
Worked on SQL Server 2012 and 2014 set up on new servers.
Experience on 64 bit SQL Server 2014 / SQL Server 2012 R2 systems.
Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
Created Linked Servers between SQL Server 2012 and 2014 R2. Created SSIS packages for data transfer between the two environments.
Working knowledge in Analysis Services(SSAS) and Reporting Services(SSRS).
Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
Strong experience in mentoring team members and writing documentation.
24 X 7 Production Database on Call Support
AD user account management
Outlook 365 migration, management and troubleshooting.
SQL DBA - ACB COOP (Memphis, TN) 7- 2012 to 2015
Maintain 12 SQL Servers ranging from SQL 2000, 2005, 2008 R2 and 2012. 504 databases
Analyzed current business practices. Recommended software changes and updates for multiply software pieces for use in house.
Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
Expertise in T-SQL writing stored procedures, triggers and functions.
Expert in data transformation services like SSIS, DTS.
Experience in using DMV and dynamic management functions for finding out long running queries.
Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
Worked on configuring SQL Server with minimum privileged access.
Troubleshoot performance problems, fine-tuning of databases and index Analysis.
Worked on SQL Server 2012 set up on new server.
Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems.
Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
Created Linked Servers between SQL Server 2008 R2 & Access. Also created SSIS packages for data transfer between the two environments.
Working knowledge in Analysis Services(SSAS) and Reporting Services(SSRS).
Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
Strong experience in mentoring team members and writing documentation.
24 X 7 Production Database on Call Support
SQL DBA - Contract work 11- 2011 to 7-2012
Fullen Dock & Warehouse (Frayser, TN) : AutoZone (Memphis, TN): International Paper (Memphis, TN)
Mimeo.com (Memphis, TN): Max Enterprise (Memphis, TN)
Converted over 50 databases from Access 2003 to Access 2010. Made needed changes to Queries, Forms, Reports and Macros. Analyzed business practices for recommending needed improvements.
Analyzed current business practices. Recommended software changes and updates for multiply software pieces for use in house.
Project Coordinator for RF refresh project. Designed a database for collecting data from multiple sites and vendors of all known RF products and pertinent information. Pooled data for duplicate verification and known site and contact information.
Analyzed current systems and provided detailed documentation with recommendations for new software where needed and provided information on advanced features not being utilized.
Project Coordinator for project converting in house software. Maintained the project using Microsoft Project. Scheduled all meetings and prepared meeting minutes. Assisted users in becoming familiar with new software and advanced features. Reported project milestones to upper management.
Created Crystal Reports to pull customer data from SQL server and use on the web server.
Information Technology Business Analyst FTN Financial (Memphis, TN) 3-2003 – 4- 2010
Support the reporting, analytical, and development needs of FTN financial Capital Assets. Created reports to use as repository for customer address and payment information. Gathered information from all departments for help in collecting debts from customers. Sent billing notices to all customers. Created reports for meetings to show trial balances.
Project Coordinator for all projects including conversion of software from the as400 to CATS in house software. Converted and analyzed multiple banks auto loans. Working knowledge of Microsoft Office was required, including Access, Word, Excel and Outlook. Working knowledge of personal computers and networking to assist in helping users with the computer related issues that arise.
Create stored procedures, views and tables in SQL Server 2000 and SQL Server 2005. Created DTS packages in SQL server 2000 and created SSIS on SQL server 2005. Created complex reports using Crystal Reports connecting to a SQL Server 2000 and 2005 databases containing a large number of tables. Examples include:
A filtered loan report passing three parameters and allowing for individual loans to be shown upon double clicking.
A stratification report having contractual formulas.
Institution reports for individual and groups.
Numerous reports based on loan details.
Account reports for trade receivables
Invoices for collecting debts from customers
Select the appropriate options to generate a report of customer balances of more than $1 and more than 30 days overdue for accounts receivables.
Review the aged receivables report to identify accounts requiring collection action.
Enter receipts into accounts receivable system.
Updated customer information in accounts receivable system.
Reviewed the aged receivable report that showed open or unpaid accounts on a regular basis.
SQL DBA/Operations System Administrator FTN Financial (Memphis, TN) 3-2003 – 3 -2010
Provide technical support in a LAN and WAN environment for all individuals in Operations. Maintain, upgrade, and implement new features with underwriting software and ensuring it adheres to Agency Standards. Work with clients for data needs and corrective action of data upon analysis and review. Verification of trade objectives internally and with the clients to get proper authorized documents. Position requires strong communication skills, the ability to handle multiple tasks, and excellent organization skills. Working knowledge of Microsoft Office is required, including Access, Excel MS Project and Outlook. Working knowledge of personal computers and networking to assist in helping users with the computer related issues that arise.
Created and maintained Crystal reports for better communication. Created and maintained databases to assist in easier and faster workflow.
Reports based on information obtained from client data.
Databases created for ease of data handling.
Maintained and enhanced databases currently implemented.
SQL DBA/Lending System Administrator Superior Bank (Fort Smith, AR) 7-2001 –1-2003
Project Manager – Lending System - Responsible for Direct and Indirect Lending integration for all application systems.
Project Manager - Superior Finance Company – Responsible for data and software conversion for all application systems.
Designed and managed the project using Microsoft Project.
Managed installation of hardware and software to support new technology.
Managed data conversion from current system to new format.
Interacted directly with the clients, and vendors.
Extensively documented the progress on the project, facilitated weekly project status meetings,
performed site visits, needs assessments, systems testing, and overall functional verification of
specified system.
Reported all project milestones, and progress to upper management.
Provided all data in Excel format for users not having access to Microsoft Project.
Provided support for Lending personnel for 2 states. Technical maintenance of various lending
software programs, Easylender, TCM, GulfPak, Bakerhill, Fair Isaac. Also provided technical
maintenance and support for CIS/Remote Access, Citrix Servers and I-32.
Primary support for all networking issues in a Novell/NT environment.
System Administrator/Analyst McIntosh Group (Fort Smith, AR) 1-2001 – 7-2001
Designed and maintained multiple websites with database interfaces. Websites used secured server connections.
Helped to create and maintain an Internet Website for the Arkansas Oklahoma State Fair that allowed ticket sales on line and connected to a SQL Server database.
Resolved server and client hardware and software issues to ensure connectivity and functionality.
Analyzed and repaired LAN and Internet connection problems.
Examined and repaired PC and Macintosh hardware and printers.
Performed hardware and software upgrades. Assembled new systems.
Provided network administration, planning, implementation, and support in a TCP/IP environment that includes Macintosh application, file, mail, and web servers, along with Snap storage servers.
Network Administrator/Teacher, Crawford County Continuing Education Center
Crawford County Adult Education Center. (Van Buren, AR) 2- 2000 - 6- 2001
Project Manger – Testing website – Responsible for project to create online testing center.
Designed and managed the project using Microsoft Project.
Extensively documented the progress on the project and facilitated weekly project status meetings, systems testing, and overall functional verification of specified system.
Managed installation of web server.
Reported all project milestones to upper management.
Implemented and maintained SQL Server which housed testing databases.
Implemented NT Server and Email Server.
Installed network cabling for 85 hosts.
Provided NT administration and support
Taught Computer classes including Windows 98, Access, Word, Excel, and PowerPoint.
EDUCATION
Webster University (Fort Smith, AR)
June 2001 – May 2003
Master of Business Administration
Major: Business Administration: 3.6
Arkansas Tech University (Russellville, AR)
June 1999 - May 2001
Bachelor of Science
Major: Computer Science / GPA: 3.93
Westark College (Fort Smith, AR)
June 1997 - May 1999
Associate of Arts
Major: Computer Science / GPA: 3.91
Contact this candidate