Data Analyst Business

JEFFREY N. CRUMP, MBA

Farmers Branch, TX 214-***-**** LinkedIn ****.*****@*****.***

Innovative, ambitious Business & Data Analyst with years of invaluable experience and a strong educational foundation. Respected by colleagues and project teams for passionately offering first-class customer service to internal and external entities. Adept at offering a sound domestic and international business perspective, having worked in a diverse array of telecom settings over the course of an impressive career. Practiced at leading full lifecycle implementations of data warehouses and data marts. Liaise effectively with various entities including Developers, IT Consultants, Support Representatives and end-users to set forth necessary system features and operations. Skilled at moving data from source to target locations. Now seeking a Business Analyst or Data Analyst role with a healthcare focus with an organization that fosters career progression and growth.

CORE COMPETENCIES

Data Analysis & Mapping, SQL Environments (Data Lake, Teradata, Oracle), SDLC Environments (Agile & Waterfall), Documentation & Reporting, Communication, Problem Solving, Troubleshooting, Teamwork, Leadership, Active Listening, Billing System Implementation, SQL Scripting, Siebel, Middleware, Unix (Shell Scripts), Linux, Ubuntu

EXPERIENCE

TEKsystems Sr. Data Analyst (10/26/2022 to Present)

Client: Wells Fargo

Working with data in Hadoop Data Lake

Use SAS Software to create reports to verify business requirements.

Creating mapping documents to map data from many sources to the company Data Lake

Writing complex SQL queries to find customers who fit the profile for new products.

Creating synthetic test data for testing efforts.

Verified ETL process from legacy Teradata database to company Data Lake.

RCG Global Services Sr. Consultant (5/2015 to 9/2/2022)

Clients, Pizza Hut, Alliance Data

Liaise with business and technical clients to work according to automated testing requirements; document operations and develop requirement-based solutions

Write SQL scripts to move data from store databases to company database (ETL)

Offer gap analysis for testing without automation in comparison to automation testing potential; craft automated test scripts using Java/Selenium/testNG platforms

Deliver training guidance and customer support for system integration via Oracle PLM, SOA, and PeopleSoft

Devise test plan and cases to confirm integrated system functionality between Oracle Agile and PeopleSoft

Excel within the Scrum Team to author stories and assign points with the utmost accuracy

Accenture Data Analyst (8/2012 to 5/2015)

Examined and documented source data, creating maps to move data from source to target locations

Contributed to a project team that wrote SAS programs to identify Medicaid and Medicare patients using records, notifying them of new drug availability and other important factors

Collaboratively identified Medicare and Medicaid records that were modified erroneously, restoring them to a proper state and resubmitting the correct versions to CMS for approval

Supervised ETL developers to transition Medicare and Medicaid records from legacy systems into an Oracle database

Called on SQL Developer to author ad-hoc reports

Fannie Mae Sr. Data Analyst (8/2011 – 8/2012)

Authored system requirements to develop new structures in a data mart, along with a logical and physical model for a relational database

Crafted comprehensive database tables and load strategies for employee data and job assignments

Wrote PL/SQL code in Toad to profile and import data into Oracle tables

Led troubleshooting for SAS programs leveraged to develop analytic reports; also tested and validated data in Business Objects reports

Bank of America Sr. Data Analyst (2/2011 – 8/2011)

Devised system-level requirements to import data into the Home Loan Division’s Enterprise Data Warehouse, using Toad to analyze data from batch files before loading into the Enterprise Data Warehouse

Created multipart SQL queries to profile source file data received, along with strategies to map data from source file to Oracle and logical data models for new warehouse tables

JEFFREY N. CRUMP, MBA

Page Two

Southwest Airlines Sr. Analyst (02/2009 – 03/2011)

Examined and profiled data prior to data warehouse importing, partnering with Middleware Developers to troubleshoot data issues concerning the interface between the middleware and data warehouse

Verified that data marts contained information needed from the data warehouse in the hub and spoke architecture, confirming accuracy across data mart reports

Led End-To-End (ETE) UAT testing to align final project results with end-user requirements

Guided Extract, Transform, and Load (ETL) to load data across sources into the Enterprise Data Warehouse (EDW)

Validated and finalized Ab Initio scripts from UNIX command line, assessing data files from the line as well

Blue Cross Blue Shield Sr. Analyst (03/2007 – 10/2008)

Developed ETL program, utilizing SQL scripts to load data from source to Teradata data warehouse tables

Outlined testing strategy for data warehouse projects’ testing measures, crafting plans and conveying status updates to senior management

Tested and validated data transformation business requirements

Automated manual processes using UNIX shell scripts

Profiled data to understand how to propagate across database tables

ADDITIONAL ROLES

Business Intelligence Consultant, Rent-A-Center (07/2006 – 3/2007)

Consultant, Alliance Data Systems (09/2005 – 07/2006)

Consultant, Citigroup (06/2005 – 09/2005)

Consultant, Verizon (06/2002 – 09/2002, 12/2002 – 04/2005)

Consultant, Genuity (04/2001 – 12/2001)

Consultant, Accenture (08/2000 – 02/2001)

Business Analyst, WorldCom (04/1999 – 08/2000)

Business Analyst, Telecom Technologies (04/1998 – 04/1999)

Business Analyst, MCI (01/1994 – 04/1998)

EDUCATION & CREDENTIALS

Master of Business Administration, University of Phoenix (April 2002 – April 2004)

Bachelor of Arts, English with Minor in History, Texas Tech University (September 1980 – August 1985)

Contact this candidate