Data Analyst Developer

Location:

Greenville, SC, 29601

Salary:

75000-85000

Posted:

August 01, 2019

Contact this candidate

Resume:

Terry Ray

*** ****** ****** *****

Simpsonville, South Carolina 29681

Mobile: 864-***-****

**************@*******.***

*/**** – Present Trayology Simpsonville, SC

IT Consultant, Data Analyst, and Developer

•Managed clients as an IT Consultant, Data Analyst and Developer specializing in the assistance of small businesses in having a top notch IT infrastructure without the expense that is associated with some other methodologies and automation software tools.

•Reviewing with individual businesses operational business and the business processes associated in order to establish the most cost-effective system design.

•Utilizing Microsoft SharePoint for providing an overall review of projects and allowing the clients to actually view individually specific Wiki sites with timelines of progress, costs and an area for providing any changes to the initial project scope.

•Provided client with business process mapping into IT automated processes taking into consideration the project scope and ensuring an efficient functionally designed system.

•Researching technologies available and develop project plans which will best suit the businesses' operational needs and provide both a time frame and estimated cost of project.

•Reviewing any changes to the original project for feasibility in ensuring proper flow with established project guidelines.

•Perform analysis on system to determine on how well the system is working by preparing reports, documenting the processes, testing and proper implementation.

•Discussed any possible improvements to the system taking into consideration future changes in business processes and technologies available.

•Supporting and Administering Microsoft SQL Server 2005, 2008, 2012, as well as Microsoft Server 2008 R2 and Microsoft Server 2012; including the usage of Active Directory and Active Directory Web.

•Providing data analysis in order to provide insightful reporting utilizing Microsoft SQL Server 2013 Management Suite and the SSRS, SSIS and SSAS services.

•Establishing and maintaining backup and recovery strategies for databases on Microsoft SQL Servers 2008 and 2012 and Windows Server 2008 R2 and Windows Server 2012.

•Ensuring integrity from data collected and optimizing the design for the best performance and reporting.

•Designing and developing Microsoft SQL Server web based applications programming with Microsoft .NET, Microsoft C#.NET and Microsoft C++.NET.

9/2007 to 4/2009 Fluor Enterprises, Inc. Greenville, SC

Data Analyst\IT Architect\Network Engineer

•Responsible for consolidating and validating IT Enterprise Architecture data into the modeling application called Telelogic System Architect for the LAN, WAN, Cloud and ERP system for over 650 world-wide sites and growing.

•Responsible for monthly QA of all data in the IT Enterprise Architecture Modal and incorporate any new meta data into the enterprise modal.

•Establish processes for capturing meta data from all data warehousing sources including Oracle, Terra data, and Microsoft SQL 2008.

•Continually improved on ways to more efficiently process the large amounts of data that come from a variety of sources and in various formats and by making use of Visual Basic Code and code specific to the various Microsoft Office 2010 applications namely, Excel 2010 and Access 2010.

•Provided analysis of system sources and establish correct mapping to them.

•Coordinated monthly meetings with suppliers of application and infrastructure data to review.

•Prepared monthly vital statistical information on Fluor’s Global Infrastructure which was done injunction with IBM with whom we did many of our day to day outsourcing.

•Maintained IT architecture and Data infrastructure for the entire enterprise.

•Responsible for enterprise wide network connectivity requiring remote connection to switches and routes when site would loose connectivity to the WAN and Cloud.

•Administered and maintained the IT Architecture Sharepoint site.

•Responsible for QA of IT architecture data generating weekly and monthly reports using SSRS and SSIS.

•Maintained current back-ups of architecture modeling data.

•Maintained and published HTML version on the intra net and Microsoft SQL database of the IT architecture server data to the IT architecture's Sharepoint site.

•Document data mapping specifications and all developmental work.

•Provide analysis of system sources and establish correct mapping to them.

•Review new hardware and software being implemented into the environment and made recommendations on the benefits and risks.

•Review and oversee implementation of any changes or enhancements to ERP system.

2/2007 to 8/2007 Solutions Plus Simpsonville, SC

Data Analyst/Database and Application Developer

•Developed a standalone utility for a third party application called AuditSystem2 which is an electronic document discovery program used in litigation by law firms for accounting cases developed by Deloitte and Touche.

•Managed IT Staff and Administrative staff for the company.

•Designed and develop Visual Basic in Visual Basic Studio 2005 code for processing work papers outside of the AuditSystem2 including the database mining and mapping of data.

•Designed and developed SSRS reporting to be generated based on several criteria based on selections from a GUI interface.

•Designed and developed in-house reporting using SSIS for upper management and fellow programmers to review for reports that would be used in the production version of the application.

•Acted as Subject Matter Expert (SME) for any new information technology projects for the company as new projects come in on a frequent basis mainly in the area of database programming by mapping imported data to current systems.

•Worked with Access 2007 and SQL Server 2005 Express as database back-end for the development of applications.

•Documented data mapping specifications and all developmental work.

Contract Positions

6/2006 to 12/2006 Wachovia Corporation Charlotte, NC

Senior Developer\Data Analyst- Global Supply Chain

•Designed and developed the widgets and Web Parts on the banks Sharepoint site for generating the bank’s internal Global Supply Chain Department’s Pipeline Reporting tool used by the bank’s CIO’s and CTO’s, and the customers internal to the bank.

•SharePoint Administrator and Subject Matter Expert for the IT Vendor Management and other departments that needed access to the data responsible for the

•Created SharePoint Wiki page site for IT Vendor Management to share the IT Vendor information and for running various ad-hoc reports that were then posted to the SharePoint site in Word, Excel, Text, CSV format.

•Documented data mapping specifications and all developmental work and kept current on the SharePoint Wiki.

•Implemented and developed migration plan from Access 2003 to SQL 2000, including VBA redesign and data security remodeling that generated objects that were posted directly to the departments SharePoint site.

•Managed department level administrators with the corporate Sharepoint with a Microsoft SQL Server. backend Managed department administrators.

•Used Visio for both application process flow modeling and database modeling.

•Utilized existent technology that is made available via Microsoft Window Share Point Server to create team site for various Lines of Business to enter request from IT Vendor Management in a central point.

•Utilized the date moved over to the central SQL server for adding to the pipeline and tracking the progress weekly for reporting to the customer and provided these generated reports weekly to Upper Executive Management.

•Recoded the current reporting tool to utilize the list build in the Share Point Team site and connect to the hotel virtual server space dedicated to IT Vendor Management for storage of images and any other OLE objects via a hyperlink.

•Used PowerPoint as a tool for displaying presentations on applications being developed and enhancements being made to current application that have already been developed.

•Used MS Projects for maintaining scheduling of projects that are actively underway, including the usage of charting and time lining.

•Hotel server space that I acquired will also be used for quarterly backups of completed transaction, and store any attached data that is not housed and reference by code to another location.

•Used Terra data to run financial report in reference to the IT Vendor Management Department.

•Became familiar with Basel and its regulation so I would be familiar with them when doing reporting.

•Rewrite code for existing Microsoft Access database.

•Fixed bugs in existing VBA Code using Visual Basic for Applications.

•Administered and maintained the IT Architecture SharePoint site.

•Generate internal customer pipeline reports using SSIS for weekly meetings of the bank technology directors and other Lines of Business.

•Posted pipeline reports once approved to the SharePoint site.

•Database Administrator for Microsoft Access and SQL 2000 and 2005 Servers.

•Pulled data through writing queries from SQL 2005 server to provide the upper management weekly using SSRS to output the data to the SharePoint site.

•Designer and developer using VBA and Visual Studio 2005 Visual Basic programming.

•Acted as Subject Matter Expert (SME) for information technology projects for the Global Supply Chain Department.

•Imported data from a variety of data sources that were not connected via any previous programming or data tooling connectivity.

5/2005 to 5/2006 Yardiac.com Greenville, SC

Data Analyst\ Database Administrator

•Building custom applications for office automation based on information stored on a SQL 2000 server utilizing a combination of Microsoft Access 2003, VB6, and Visual Basic 2005 Express, including a variety of procedures and triggers; creating a more efficient method of conducting business in an online retail shopping environment.

•Incorporating the Office 2003 Professional suite in the process of automating current businesses processes involving customer service and financial data based on the data stored on the SQL 2000 server for customer service representatives.

•Create feeds from the SQL Server 2000 database that were provided to a variety of shopping portals to generate greater revenue through online marketing.

•Create customized reports with Microsoft Access and Crystal Reports based on request both to be regenerated on a timed basis or ad-hoc.

•Acted as the System Administrator and Network Engineer.

•Used Visio for both application process flow modeling and database modeling.

•Decreased the amount of labor time necessary for processing day to day functions creating a greater profit margin implementing automated online ordering system, including triggers to flag any suspicious or invalid orders; saving time and money.

•Implemented the use of Terra data for managing the reporting on the warehouse inventory.

•Created better checks and strengthened data integrity with Microsoft Access as a front end connecting to the SQL 2000 server acting as the shopping cart.

•Prepare proposals and research new database and data mining technological advancements for controlling partners to choose and decide, based on my information and experience; which would indicate more accurate and efficient reporting based on data pulled from SQL Server 2000.

•Responsible for hardware located on the LAN and maintaining connectivity in order to stay connected with the remote warehouse that received and filled the online and call in orders.

2/2004 to 05/2005 Ryan's Restaurant Group, Inc. Greer, SC

e Learning Content Developer and Administrator/ Data Analyst

•Worked on a project that integrated the e Learning system and the custom time entry/payroll system used by the company.

•Managed developers for the Content Management System used for the eLearning on initial courses.

•Developed triggers and procedures to generate data from the time keeping system In SQL Server 2000 and create user accounts in the e Learning system with courses assigned to the appropriate team members already based on their job with the company.

•Developed input forms for management and operations personnel using Visual Basic, XML and HTML for on the intranet to dynamically query the Microsoft SQL 2000 databases on Windows 2003 Server for team member data and generate reports to print; or allow the exporting of the data from that query into various formats usable in other Microsoft Office applications – Word, Excel, PowerPoint.

•Maintained optimal performance, reliability, and scalability of Microsoft SQL databases with the usage of SQL tweaking tools and the continual tuning of stored procedures, set-based logic, user-defined functions, and triggers.

12/2002 to 2/2004 MICHELIN North America Greer,SC

Help Desk System Analyst/Data Analyst/Business Analyst\Network Analyst

•Team lead for Windows XP rollout to all of the US and Canadian plants with a team of 30 working in various sites.

•Migrated user data and confirm all systems were accessible after the upgrade.

•Working at Michelin Information Technology Services assisting callers with a wide variety of technology related issues having to support approximately 13,000 users of DELL PCs throughout the Michelin North American sites including the United States, Canada, and Mexico.

•Software applications supported included Microsoft Office XP Word, Excel, PowerPoint, Access, Oracle, Terra data, Lotus Notes, Lotus Organizer, SAS Systems, Rumba 7.0, People Soft, Hummingbird Exceed, Same Time, cc:Mail, Intellisync and additional supplemental and user managed software packages.

•Used Visio for both application process flow modeling and database modeling.

•Team Lead on Michelin North Americas Windows XP Rollout Project which consisted in the upgrade of 13,000 DELL PCs throughout the Michelin North American sites from Windows NT 4.0 to Windows XP Professional.

•This project ended at an earlier date and cost than anticipated to due team efforts to complete the project and with a user satisfaction rate of 96%.

•Corrected custom designed database application issues due to lack of ODBC connectivity or incorrect parameters to Oracle and Microsoft SQL database servers.

•Worked in multi-server environment consisting of several hundred Novell Netware 5, Windows 2000, AS400, ERP Microsoft Dynamics system and Unix servers.

•Software applications included Microsoft Office XP Word, Excel, PowerPoint, Access, Visio, Lotus Notes, Lotus Organizer, SAS Systems, Rumba 7.0, People Soft, Hummingbird Exceed, SameTime, cc:Mail, Intellisync and additional supplemental and user managed software packages.

•Researched and resolved all levels of related problems and provide proper document and solutions for future awareness including network, applicaton and PC issues.

05/2001 to 12/2002 bRowZthis! inc Wake Forest, NC Wake Forest, NC

bRowzthis! Inc – Part OwnerInc – Part Owner

•IT projects including web design, application design, web applications, networking, server administration, database design, database administration, IT systems analysis, and intra/extranets.

•Used Visio for both application process flow modeling and database modeling.

•Used Visio for network diagramming for both LAN and WAN.

•Worked with Microsoft SQL, Oracle, Sybase, and Terradata in developing database driven application for several companies.

Permanent Positions

01/2000 to 05/2001 Lucor, Inc. - Jiffy Lube, International Raleigh, NC

MIS Manager

•Managed entire IT department including the documentation and publishing of standards, defining and conducting required testing on all applications.

•Responsible for managing the data migrating from the POS systems and National headquarters into the SQL database for use in weekly, monthly, quarterly and yearly reporting and to migrate into the in-house Great Plains Dynamics ERP system.

•Used SQL to import the individual stores inventory and designed queries to indicate any discrepancies in comparison the headquarters purchase orders.

•Ran reports from Microsoft SQL Server data grouping each store showing their inventory amounts and flagged where there were discrepancies on a weekly basis.

•Used PowerPoint as a tool for displaying presentations on changes being made prior to the change on the network infrastructure.

•Used PowerPoint as a tool for displaying presentations on applications being developed and enhancements being made to current application that have already been developed.

•Used MS Projects for maintaining scheduling of projects that are actively underway, including the usage of charting and time lining.

•Administrator of 213 NT servers in the field at POS locations and 2 NT Servers, 1 Windows 2000 Server, 1 SQL Server, 1 Oracle Server, 1 Netware Server in the corporate office using Active Directory and Single Sign On.

•Used the following network protocols TCP/IP, NetBios, Netbeui, IPX/SPX.

•Implemented migration from Access to Microsoft SQL 7.0/SQL 2000.

•Programmed and debugged applications using Microsoft Visual Basic for applications and Macro media Cold Fusion, Front Page and HTML for web based applications that were Microsoft SQL databases.

•Used Visio for network diagramming for both LAN and WAN.

•Used Visio for both application process flow modeling and database modeling.

•Email administrator for Exchange Server for all locations.

•Migrated Exchange 5.0 Server to Exchange 2000.

•Maintained 150 corporate PCs in one location and 50 PCs in the 13 other regional remote sites including all the peripheral devices.

12/1995 to 12/1999 North Carolina Department of Transportation Raleigh, NC

Computing Consultant - NCDOT – Construction Unit

•Developed and maintained Microsoft Access, Oracle 8i and Microsoft SQL 6.5/7.0 databases.

•Programmed various applications with use relational databases between Oracle8i and Microsoft SQL Server 7.0 using Microsoft Visual Basic and Microsoft Access.

•Managed IT support staff located in various offices throughout the state of North Carolina in Construction Unit branches.

•Acted as IT Support to the State Secretary of Transportation with presentations and other IT specific projects.

•Used Visio for both application process flow modeling and database modeling.

•Sent to two week long training in Oracle.

•Created an intranet, web based application called NCDOT - Construction Unit Personnel Projection with Macro media Cold Fusion connecting via both specific ODBC’s and encoded connections to both Oracle/Microsoft SQL 6.5 database servers; providing better projections of personnel needs during the times when to elements of the weather will not permit contractors working on new highway projects to continue working; with data compiled from the Farmer’s Almanac.

•Provided statewide training and assistance with Microsoft Office programs and Microsoft operating systems for branch employees. Developed and maintained Microsoft Access databases. Used Microsoft Visual Basic for programming database applications.

IT Related Skilled:

•Microsoft Windows Server 2012, Microsoft Windows Server 2008, Microsoft Windows XP, Vista, 7, 8, 8.1.

•Design and Develop SharePoint Wiki Sites, Web Parts, Widgets and SharePoint Administration.

•Proficient in several programing languages including Visual Basic, .Net, Python and Java.

•Expert in the Microsoft and Open Office Suite Packages.

•Over 16 years of experience with Microsoft SQL Server from administration to tuning them for better performance up to Microsoft SQL Server 2012.

•Well versed in writing SQL code including triggers, ad-hoc queries and calculated fields with the assistance of aggregate function.

•Experience with writing complex queries including loops and sub queries.

•Have a creative gift for understanding the issue or question at hand and design or generate a report that give more overall and future insight.

•Communication is a key in the overall benefit and optimal functionality of any business process that is being automated, and I have a great gift for being able to communicate to all people involved despite if they are a fellow developer, end user, or executive level management.

•Very conscious of the necessity to maintain integrity of the data in order to receive the true picture of what the data is telling.

•Excellent capability to create queries that answer business questions and further or fine tuning of business functions and processes.

•Excellent communication skills and take great pride in the work I do because I am a representative of the company while working.

•With over 20 years of Information Technology experience in many of the variety of realms that exist within this trade, I am an excellent subject matter expert on a great deal of area in IT.

Additional Non IT Related Skilled:

•Speak German and Spanish fluently.

•Speak some French and Portuguese.

•Excellent communicator in the ability to speak on whatever level deemed by the persons present.

Education:

University of South Carolina 1991-1994 1991-1994

University of Phoenix BS Information Technology 1998-2001

References:

Fred Zaytoun

Fredco Biz

919-***-****

John McNeill