Data Analyst Technical

DATA ANALYST

Improving end user experiences; providing required results!

An experienced IT specialist and leader supporting business and data management applications worldwide. Strong collaborator and communicator with a diverse background spanning over 20 years. Experienced in various technical, account service, and management roles from small regional business environments to international corporate settings. Excellent communicator providing technical and non-technical training in both individual and class settings. Primary focus is on improving end-user experiences and refining system performance at all levels.

TECHNICAL EXPERIENCE

Architecture: Desktops/Laptops, Client/Server, Mainframes, Enterprise (3/n-tier)

Database & Tools: MS SQL Server, MS Access, Oracle, DB2, SQL, Data Modeling, Import/Export, Replication

Platforms & Systems: Windows, Linux/UNIX, Terminal Servers, IBM/AIX, HP/UX, SCO UNIX, SUN Solaris

Programming Languages: Scripting, Visual Basic, C, C++, SQL, SQL*PLUS, PL*SQL, UNIX shells, Micro Focus COBOL/COBOL II, System 370/390 JCL, MVS

Software Packages: CISPlus, Microsoft Office (Access, Excel (and integration of the two), Outlook, PowerPoint, Word, Publisher), Visio, MS Project.

VALUE OFFERED

Communication:

Multiple years working with and training both technical and non-technical co-workers and clients. Ability to connect with multiple groups.

Experience:

Broad technical background with very quick refresh window on previously used technologies and short learning curve on those new to me.

Technical Orientation:

Focus on refreshing previously used skills as needed and strong desire to learn new technologies as opportunity is provided.

PROFESSIONAL EXPERIENCE

Bank of America 2017 - 2019

IT Security Specialist III

Provide weekly system updates to international audience on over 264,500 open network file shares, each representing a security risk to the corporate IT environment.

Partner with both technical and non-technical contacts in identifying/prioritizing the most critical of the security vulnerabilities and addressing the best approach to “lock them down”.

Assist multiple lines of business in remediating identified vulnerabilities enabling the teams to secure the previously identified gaps in network access and come into compliance with corporate policy.

WageWorks, Inc. 2017 - 2017

Integration Engineer

Collaborate with new clients and carriers to develop appropriate mapping for COBRA feeds both internal and external enabling un-interrupted processing of insurance coverage for ex-employees of the new client.

Create detailed mapping plans to implement inbound and outbound file feeds, including working with third party vendors, developing implementation plans, testing files/feeds and promoting these into the production environment.

Respond to technical issues to provide migration and file level support for escalated non-repetitive data issues.

Analyze, identify and resolve data issues using SQL scripting.

Develop and maintain documentation for each client on processes, scripts, and case resolution procedures for future reference and/or use.

Vizient Inc., Irving, TX 2016 - 2017

Data Analyst

Prepare “Spend” analyses/presentations/reports for presentation to various Hospital systems by internal representatives in response to “Requests for Bid” related to inventory required to operate the multiple hospitals within the systems.

Mapped incoming spend data from various sources across the country into defined fields utilized for corporate standardized RFP analysis.

Conduct data collection, validation, and process reporting functions for market assessment and contracting initiatives.

Compile and present analytics in routine business reviews with internal clients.

NCR, Fort Worth, TX 2011 - 2016

Software Support Analyst II

Ensure internationally distributed data is correctly mapped for import into locally hosted web applications for financial reporting.

Provide technical support, assistance and advanced trouble-shooting services to international clients regarding delivery, installation, outages, component level problems, and other technical issues.

Perform GAP Analysis involving in-depth research and exhaustive troubleshooting to resolve issues between the promised product and what the customer was experiencing in the day-to-day production environment.

Generate and run ‘ad-hoc’ SQL to validate/verify table data is complete, current, accurate and correct.

Troubleshoot/debug SQL Stored Procedures to ensure scripts design/code is correctly to accomplish the specific purpose for which they were implemented.

Import missing data from remote servers into the host tables for accurate reporting.

Manually import specialized management data from clients into SQL Server tables not populated by the normal automated import process.

Run SQL queries to extract specific data requested by clients, transfer this data into MS Excel worksheets and send to the client via file transfer or email attachments.

EDS/HEWLETT-PACKARD, Plano, TX 2007-2010

Business Services Analyst / ITO Service Consultant

Lead team of 10 telecom support personnel by designing, developing, implementing and maintaining desktop tools for validation/cleansing of circuit data in support of telecom network billing operations.

Utilize SQL Server, SQL, Visual Basic, and MS Access to analyze, manipulate, and integrate data and applications.

Supported team as first client call for assistance; acted as primary interface regarding technical, informational or procedural assistance.

Managed defect resolution process, including follow-up on outstanding items related to desktop tools comprised of Microsoft spreadsheets and associated VBA macros as well as SQL scripting.

Integrated local solutions and work with IT groups to identify specific, recurring issues and resolve permanently.

Identified and tested new or underutilized capabilities in existing tools; facilitated adoption and use on a broad scale throughout the department.

Effectively led team of Telecom Support personnel through multiple network and management transitions.

EDUCATION AND TRAINING

SOUTHWESTERN BAPTIST THEOLOGICAL SEMINARY, Fort Worth, TX

Master of Church Music (Education)

WILLIAM JEWEL COLLEGE, Liberty, MO

Bachelor of Music Education

Contact this candidate