Engineer Data
Resume:
# _ +
-
-
-
-
-
-
-
-
-
-
-
~ 2013 - 2015 +
-
-
-
-
-
-
~ 2003 - 2013 +
CARL DURKES
Senior Data Engineer
765-***-**** ********@*****.*** Indiana, USA
EXPERIENCE
Data Engineer
Purdue Federal Credit Union
West Lafayette, IN
Migrated 80,000 Online banking users to new SQL 2016 environment from SQL 2008 Modeled the in-house Person to Person payment to eliminate the rising vendor cost by 100% Designed four promotions for members to adopt, expand, and grow within the credit card reward program Replaced the employee sales incentive tracking system for 150 front office staff Converted SQL Server Reporting Service (SSRS) Reports into Power BI dashboards to better leverage end user self service of data consumption for the Marketing and Contact Center departments Proficient in writing complex T-SQL that include stored procedures, CTE, temp tables, ranking functions, TOP(n), and PIVOT Data Architect
Purdue Federal Credit Union
West Lafayette, IN
Created incentive data model for membership giveback of $30 million Developed an OLTP credit card rewards program - Savings hundred thousands of licensing over previous program Quantified growth potential in Northwest Indiana by 6,000 Purdue University Alumni Replaced Marketing Customer Information File with accurate and sustainable solution Automated monthly board packet generation from our data concerning shares, loans, Reward Programs, and survey information
Database Administrator / System Coordinator
Purdue Federal Credit Union
West Lafayette, IN
Provided data migration expertise to modernized to current and robust application Built 100+ SSRS solutions to allow self-supporting research platform to accurately determine data driven decisions Managed 5 projects for installation of eCommerce products: Online, Mobile, and Phone Banking Systems Trained 200 employees on the enhanced eCommerce products Solved the balancing issues for the One Touch Bio-metric Kiosks and ATM Networks Decreased downtime by 50% during month end processing AREAS OF EXPERTISE
Microsoft T-SQL
Proficient
SQL Server
Integration
Services
Proficient
SQL Server
Reporting Services
Proficient
Business
Intelligence
Advanced
Gathering Project
Requirements
Proficient
Query Tuning and
Optimization
Proficient
-
-
-
-
~ 2013 - Ongoing
>
-
-
-
-
~ 2016 - Ongoing
>
-
-
-
-
~ 2018 - Ongoing
~ 1998 - 2002 +
/
PROJECTS
My Member Perks
https://www.purduefed.com/personal/my-member-perks/ A program that continuously rewards credit union members for their trust and loyalty to Purdue Federal Created SSIS packages to gather data from 5 sources to calculate monthly points (Mobile, Online Banking, Core Systems, Mortgages, and Statements)
Used T-SQL procedures to make the process modular and simplify the SSIS packages Developed 10+ SSRS reports that allowed better insight into the program and what was working and not working financially Rewarded the Membership with over $30 Million dollars in giveback Cash Rewards
https://www.purduefed.com/personal/cards/credit-cards/cash-rewards/ A cash back only credit card rewards program.
Processed 900,000 monthly transactions with my T-SQL procedures Awarded instant bonus and My Member Perk points on individual transactions to maximize point redemption Developed a voucher program using T-SQL for the Purdue University 150 Year and Purdue Federal Credit Union 50 Year anniversaries to award $30,000 worth of points to the lucky winners Created a premiere cash back reward program for a Top 100 Visa portfolios in the United States Satisfaction Surveys
Selected transactions on a daily basis to survey members about their experience with the Purdue Federal Established a Secure FTP site to send and receive information on a daily basis with vendor to reduce delays in reporting Masked personal information when sending to the vendor to minimize the security risk of data leaving the premise Distributed daily (120) and annually (6000) surveys equally across branches and employees while eliminating duplicate accounts surveyed within a 60 day window
Used SSIS packages to load information into our Sales system to calculate enhanced incentive pay based on results MOST PROUD OF
Client Relations
Supported the data requests of employees in a timely and successful manner
16 years of service
Played a key role in enhancing eCommerce products to grow Purdue Federal Credit Union into a Billion dollar organization
EDUCATION
Business Management
Purdue University
West Lafayette, IN
GPA
3.2 4.0
Contact this candidate