Post Job Free

Resume

Sign in

Data Analyst Process Improvement

Location:
Dallas, TX
Posted:
February 16, 2024

Contact this candidate

Resume:

RUSSELL H. WEAVER

PROFILE

Accomplished data analyst driven by professionalism, accuracy, and timeliness. Talent for conceptualizing, planning, and executing process improvement; recognized for building high-trust relationships and consummate champion for value add.

I am a high-end BI Analyst – I deliver mission critical analysis to the “C” Suite

SUMMARY OF KEY CROSS-FUNCTIONAL IT STRENGTHS

Database Management& SQL Query Customer Relationship Management (CRM)

Excel – Design, Pivot Tables, Filtering & Macros Root Cause Analysis (RCA)

Data Collection & Ad-hoc Reporting Problem & Change Control Management

Scorecard and Dashboard Reporting Service Level Agreements (SLA)

Metrics, KPI’s and Forecasting ISO 9000

Call Center Support and Reporting Six Sigma (Green Belt - DMAIC Methodology)

Incident Management Business Analytics

Insite (Quantitative / Qualitative) Strategic Plan Development

ITIL V3. Foundation

Education

University of Alabama – BS in Commerce and Business Administration – Management, Marketing, and Economics

Six Sigma Certification – Green Belt - DMAIC Methodology – Bell Helicopter

ITIL V3 - Certification

Professional Experience

Morrison Supply Fort Worth, Texas Sept 2012 – May 2013

BI Operations Reporting (Corporate)

ENVIRONMENT

9 Regions – 6 States – 115 locations – Retail, Commercial and Showrooms

Data Warehouse consisted of 4 servers – 5 databases; reviewed over half a terabyte per day

SIGNIFICANT ACHIEVEMENTS:

Developed /Produced and Automated Daily, Weekly, Monthly, Quarterly and Yearly Time Statistical Trending Reports

Delivered Metrics and KPI’s through Dashboards / Scorecards for Process Improvement to the “C” Suite

For Acquisition/Mergers - Researched & Compiled over 6,000 US Supply Competitors; Plotted using MS MapPoint

Process Analysis included Critical Review of Existing Database in Preparation of Major Modification to Identify

Problems and Opportunities for Improvement

Problem Management – Tracked Incidents to Resolution – Created Root Cause Analysis (RCA) Reports

Change Management – on Change Management Board for Software Updates

Trained Members of Different Departments to Use the Primary In-house Application for Data Entry

Project Management - Worked with Design Developers and Coders for Revisions (Screen Layout and Data Entry)

TechniSource (Contracted to Citi Group) Dallas, Texas Jan 2011 – Sept 2012

Senior Business Analyst

ENVIRONMENT

Reported on Multiple Regions (World-Wide) on IT Incident and Problems

Produced Monthly / Quarterly Trending, Metrics, and Dashboards for Process Improvement

Using MS Access, used SQL Queries to Collect Data into Excel, Modeled the Data, Creating Six Sigma Minitab

Charts / Graphs with Regression Analysis (Statistical Analysis) and Imported the Graphed Results into PowerPoint for Presentations for Upper Management with the Goal of Process Improvement and Value Add

SIGNIFICANT ACHIEVEMENTS:

Responsible for Standard Rules and Definitions of Values Used for the High Level Categorization (for LATAM, EMEA, ASPAC, and NA). The Statistical Reports Were Delivered Verbally and Electronically to Multiple Levels of Management.

Recognized for Process Improvement

American Heart Association Dallas, Texas Feb 2010 – April 2011

Business Analyst (Contractor)

ENVIRONMENT

Managed Multiple Web Sites to Prevent Malware Anomalies from China

Developed Weekly, Monthly and Quarterly Usage Patterns by User Interest Categories

Reported and Forecasted Trends to Management

SIGNIFICANT ACHIEVEMENTS:

Deleted over 40,000 Adware and Malwares in a 3 Month Period

Profit Central, LLC, Dallas, Texas Oct 2006 – Feb 2010

Business Analyst

ENVIRONMENT

Managed multiple investing avenues including Options, Equities, and Futures

Intensive Data Collection, SQL Queries, Excel Pivot Tables, Filtering and Macros Utilized

Researched and Plotted Historical Trends, Quantified Risk Management for Over 400 Equities

Utilized: Trend Analysis, Exponential Moving Averages and Statistical Applications

Databases used - File Maker Pro, Access

SIGNIFICANT ACHIEVEMENTS:

Developed SQL and Excel Processes to Review and Report Over 400 Equities, Notating 18 Key Performance Indicators

Textron Fort Worth, Texas Dec 2003–Sept 2006

Metrics & Reporting Analyst

ENVIRONMENT

Collected Data for 10 World-Wide Companies, SQL Queries, Excel Pivot Tables, Filtering and Macros Utilized

Managed 91 Service Level Agreements (SLA’s) and 6 Key Performance Indicators (KPI’s)

Developed SQL & Excel Reporting Procedures and Processes for Service Credit Tracking Against SLA’s and KPI’s

Designed Daily SQL & Excel Reports for Service Delivery Managers of 10 World-Wide Business Companies

Database used– Home Grown From Computer Associates

SIGNIFICANT ACHIEVEMENTS:

Credit Tracking Recovery in excess of $3 Million

Participated in Six Sigma Black Belt project (Project/Change Management) a Savings of $798K

Green Belt Project Produced a Savings to Textron of $50K

Recognized for Superior Performance

Electronic Data Systems Colorado Springs, Colorado Jan 2000 – July 2002

Senior Business Analyst

ENVIRONMENT

Developed SQL & Excel Reporting Procedures and Processes for Performance to Both WorldCom (the Customer) and

EDS Management

Acted as Liaison Between Client Support Groups and Cross-Functional Technical Operations

Performed Root Cause Analysis (RCA) Against Failed System Changes

Instrumental in Data Integrity and Accuracy Against Service Level Agreement Contract Deliverables

Databases used – Tivoli, Crystal Reports

SIGNIFICANT ACHIEVEMENTS:

Established Data Collection and Reporting System to Address Lagging Service Level Agreement (SLA) Contract and

Key Motivator to Groups Encouraging Collection of Missing Information

Results: Increased Awareness Led to Increased Productivity in Root Cause Identification; Reporting Levels Improved

From 35% to 97%; Highly Successful in Reducing Contract Penalties of $350,000 Per Month

Financially Recognized for Personal Effort Toward Preparation and Successful Implementation of Y2K (Zero Failures)

Problem and Change Control Coordinator Plano, Texas Jan 1999 – Jan 2000

ENVIRONMENT

At the Corporate Level, Reviewed Technical Changes for EDS IT Environment (Plano)

Performed Root Cause Analysis on Failed Changes Reported on Financial Risks to Client and Company

Instrumental in Change Control Board – Financially Bonus - Recognized for Zero Failures

Databases used - Remedy, Vantive

Y2K – Corporate Team Member

Senior Customer Focus Representative Plano, Texas Jan 1998 –Jan 1999

ENVIRONMENT

Worked Directly With Multiple External Clients in All Aspects of Customer Service and Support

Created ISO 9000 Quality Management System (QMS) Documents for Group

Acted as Internal Compliance Auditor for ISO 9000 Process

Databases used - Remedy, Vantive

SIGNIFICANT ACHIEVEMENTS:

Quality Management System (QMS) Effort Resulted in ISO 9000 Certification

Financially Recognized for Personal Efforts towards QMS and ISO 9000 Certification

Client Server LAN Administrator, Team Leader Plano, Texas May 1995 – May 1997

ENVIRONMENT

Acted as Subject Matter Expert Providing Daily Desktop Support and Network Support for 450 Macintosh Users for the

Manufacturing Division (World-Wide); This Division Represented Over 40% of EDS’s Revenues

Intensive Data Collection, Database Queries, Excel Pivot Tables, Filtering and Macros Utilized

SIGNIFICANT ACHIEVEMENTS:

Assumed Responsibility for developing a Matrix Reporting System Documenting Client Monthly User Problems by

Group and Data Storage Usage. The System Predicted, Statistically, Future Storage Requirements in All Areas of IT

Results: Improved Communications Between EDS and Clients Depicted What Future Growth and Costs Would be a

Year Before They Would Occur; Many New Increases in Storage Level Contracts Were Executed With Sales Totaling

Over $5 Million

Database Used - Remedy

Origin IT Systems Management Arlington, Texas May 1997- Jan 1998

Mainframe/Midrange Change / Problem Coordinator

ENVIRONMENT

Conducted Daily Operational Meetings with Multiple Clients, Negotiated Weekly Windows for Mainframe Maintenance

Prepared and Documented Processes for ISO 9000 Certification

Acted as Internal Auditor for ISO Process Compliance After Certification

Databases used – Infoman, Netman

SIGNIFICANT ACHIEVEMENTS:

Recognized for Personal Effort in Document Collection

Successfully Moved 2 Clients to Larger and More Powerful Mainframe System; Estimated $2 Million in Sales

From the archives:

City Attorney’s Office – The City of Dallas – Dallas, Texas Jan 1994 - May 1995

LAN ADMINISTRATOR / Optical Imaging Specialist and Records Manager

1993 Dallas County lost a $23 Million case. The opposition used desk top computers. The City Attorney’s Office had NONE.

Opposition delivered 65 case files to The Dallas City Attorney’s Office. Dallas County had 1 person charged to work the case. This single attorney could not go through al the documents and develop a legal strategy. Dallas lost this case and learned that they needed to get on board with computers. The City Attorney, Sam A. Lindsay (1991-1999) contacted Apple Computer asking for help. Apple Computer was keenly aware of the Super Conducting Super Collider in Waxahachie Texas who was scanning and tracking documents in a paperless environment. The City Attorney contacted the Department of Energy office to learn of the software that was being used and who was the Records Manager’s. My name was provided and I accepted an interview.

Duties

Cross train Records personnel in the process of reviewing all documents to ensure all pertinent and required information was on the document.

Create a Circle Back tracking process for failed documents to be returned to the appropriate department – what was missing or incorrect and how to return the document(s) to the Attorneys office.

The process for control number alteration and linking of old document(s) to revised and accepted documents.

Create process for document retention, document control numbers and the assignment to the appropriate department. (See below)

Create a training for 40 admins and attorneys on how to use the search feature etc.

Taken from the City of Dallas Attorneys Office web site – this shows the width and breath of its representation

GENERAL LITIGATION (2024)

“City government in Dallas is a large, diverse, and complex operation. The mission of the General Litigation Section is to represent the City and its officials and employees in a wide range of claims and lawsuits, which can arise from those operations, including: challenges to City ordinances and policies, federal and state constitutional claims, contract disputes, public utility regulation, disputes arising from public works projects, eminent domain, environmental issues, land use and zoning disputes, lease disputes, and disputes involving title, easements and other property interests.”



Contact this candidate