Steven L. Smith

**** ****** ** **********, ***** 75067

Email: acuutp@r.postjobfree.com

LinkedIn: http://www.linkedin.com/pub/steven-l-smith/25/b5a/392

Phone: 469-***-****

PROFESSIONAL SUMMARY:

Steven is an experienced Analyst who is proficient with describing technical data to individuals regardless of their technical understanding. Is very customer service focused. He has assisted both the public and co-workers with various projects and events. He has managed ad-hoc business units and teams, sometimes across multiple countries, to gather complete datasets and communicated findings. Functioned independently and proactively, identifying issues and raising them to management, as well as offering potential solutions.

TECHNICAL SKILLS:

Microsoft Office Suite, Microsoft Access, Microsoft SQL, Visual Basic, Microsoft Project, Microsoft Visio, Microsoft SQL Server Reporting Services

PROFESSIONAL EXPERIENCE:

Silverleaf Resorts, North Richland Hills, Texas July 2015- December 2015

Database Reporting Analyst

Converted Access reports into MS SQL Server 2013 for marketing and statistical purposes.

Utilized temp tables and stored procedures to create custom SQL queries and reports

Developed Excel formulas and pivot tables to validate data generated from SQL queries.

Used SSRS application for departmental report creation and deployment

Environment: Windows 7, Office Suite 2013, MS Access 2013, MS SQL Server 2013

DTCC, Coppell, Texas April 2015- June 2015

Business Data Analyst (Contractor)

Responsible for creating and delivering program specific reports from ServiceNow and T.A.D.D.M. Service Management tool

Executed QA techniques to evaluate the exactness of TADDM and ServiceNow data for reporting purposes.

Managed customer requirements while ensuring good practices in standard methodologies and processes to deliver an integrated solution.

Converted data from XML files using MS Excel to create component listing while using pivot tables and lookups to discover relationship data.

Environment: Windows 7, Office Suite 2010, ServiceNow, IBM Tivoli Application Dependency Discovery Manager

City of Fort Worth, Ft. Worth, Texas May 2014 – December 2014

IT PROGRAMMER / ANALYST I (Contractor)

Created custom SQL scripts to retrieve data from various SQL 2010 databases and tables to create statistical reports for departmental needs.

Developed flow diagrams and data maps using MS Visio for CRM application development.

Researched and presented options for software proposal that showed pros/cons of developing a custom application or purchasing “box product” software.

Constructed database to support tables for CRM application.

Provided tier 1 technical support to Planning and Development end users that ranged from PC troubleshooting and new pc user setup

Provided administrative duties to city permitting system, Accela Automation that included new user profile, data, and rule creations.

Environment: Windows XP, Windows 7, Visual Studio 2008 and 2010, SQL Server Reporting Services 2008, Accela Automation 7.3

American Airlines, Fort Worth, Texas February 2013- November 2013

Business Technology Analyst (Contractor)

Collaborated with Network Engineers and other IT professionals to identify and document requirements, complex designs, abstract concepts and implementations of network solutions.

Evaluated and presented recommendations on technical solutions and business ideas based on technical and financial analysis.

Generated financial report for new server rollout project by extracting data from custom applications and hand written documents.

Used data scrubbing techniques such as v-lookup formulas and pivot tables to justify data for reporting purposes.

Environment: Windows 7, MS Excel 2010, SharePoint 2006

Lone Star Aerospace, Addison, Texas September 2012 – Nov 2012

Business/Data Analyst (Contractor)

Reinforced knowledge extraction via client interviews, Delphi groups, surveys, and other primary research methods.

Created data flow diagrams to illustrate relationship between data subjects

Prepared and synthesized collected data

Utilized object orientated program system to process and generate results that address assigned task

Environment: Windows 7, MS Excel 2010, MS Visio 2010, MS Access 2010, EBSCO Host, Proprietary Decision/Support System

Compucom Systems, Inc. - Dallas, Texas June 2011 – Aug 2012

Client Software Sales Analyst

Developed financial and technical reports based on supported client criteria

Manage software procurement for assigned Enterprise level customers

Explored a multitude of software publishers to ensure that feasibility with customer’s software requests.

Implementation of Order Management starting from inception of order to order placement and fulfillment through invoicing.

Environment: Windows 7, MS Excel 2010, MS ACCESS 2010, MS Word 2010, Visio, SharePoint 2007, Outlook 2010, SAP

Compucom Systems, Inc. - Dallas, Texas June 2007 - October 2010

Data Analyst/Sales Operation Administration

Supported Compucom Sales Associates with software pre-sales inquiries for US and Canadian customers.

Established relationships between Compucom and Software Vendors.

Contacted software publishing companies to retrieve current pricing and promotional information for mid-size to enterprise level customers.

Acted as Project Lead for potential customers’ Request for Quotes and Request for Pricing.

Provided data-based insights and crafted recommendations.

Gathered and analyzed massive amounts of information expeditiously for various simultaneous requests.

Used MS Excel 2007/2010 to analyze and modify spreadsheets and used MS Word 2007/2010 to create documents and perform data entry.

Pulled data from PDF documents.

Environment: Windows XP, Windows 7, MS Excel 2007/2010, MS ACCESS 2010, MS Word 2007/2010, SharePoint 2007, Outlook, Visio

EDUCATION:

Prairie View A&M University, Prairie View, Texas, May 2004

Bachelor of Business Administration, Management Information System

Contact this candidate