SUMMARY:

Teradata Certified Data Warehousing and Customer Relationship Management Professional. A self - starter with a proven record to accurately get the job done ahead of schedule and under budget. Considered an SQL expert with an ability and desire to educate fellow employees.

TECHNICAL SKILLS:

Extensive Experience:

Software: SQL, Teradata RDBMS, Oracle, Microstrategy, Excel, Access, Word, Visual Basic

Hardware: Confidential MPP Servers, PC workstations

Moderate Experience:

Software: COGNOS, SAS, Novell, PowerPoint, FORTRAN, COBOL

Hardware: Intel-based servers and IBM Mainframes

PROFESSIONAL EMPLOYMENT:

Confidential, Washington, DC

Business Intelligence Analyst

Responsibilities:

• Created a model to predict which packages most likely contained illegal drugs. A report was generated and used to interdict packages. After a warranted search, drugs were found in a vast majority of packages listed on the report.
• Created a model to predict which checking accounts presented to the Confidential the prior day to purchase stamps were most likely fraudulent. These accounts were nearly always fraudulent accounts. This process cut 30 days off of the old process to get checking accounts listed on the bad account list thus stopping further fraud.
• Worked with every member of the team to improve SQL skills and data model understanding

Confidential

Responsibilities:

• Sufficiently mastered the Online Fraud Detection Application ( Confidential ) to assist with the creation of several rules which directly lead to the reduction of fraudulent chargebacks in the amount of $500,000 per month.
• This necessitated mastering Oracle SQL, the Confidential data model, and the creation of multiple tables which were used to analyze the behavior of both fraudulent and non-fraudulent customers.
• Automated a process to utilize XML to block the further usage of Accounts with fraudulent chargebacks. This saved over eight hours of manually entering this data and it occurred weeks earlier in the month.
• Assisted with the training of every member of the Fraud Team in understanding multiple Confidential databases and improving every members SQL skills

Confidential

Responsibilities:

• Created an Internet Opportunity Report which showed that 66% of all Visits to the Retail Counter of the Post Offices could have been handled over the internet. Potential savings to the Confidential: $1 Billion annually.
• Major contributor in the conversion of the Windows Operation Survey (WOS) Report from the Point-of-Sale (POS) System to the EDW. Once converted, the Confidential Retail Senior Management had visibility to the Window Operations up to the National level and was able to reduce Work Hours Nationally saving over $100 Million annually.
• Developed an Upsell Report which determined a Champion at each of the 17,000 Confidential POS-equipped Retail Units, and determined the potential increase in revenue if all of the Confidential Retail Employees raised their performance to the level of their Unit’s Champion. Potential revenue increase $100 Million annually.

Confidential, Phoenix, Arizona

Teradata Senior Consultant

Responsibilities:

• Acquired extensive knowledge of applications for Data Mining, CRM, Customer Profitability, and Channel Analysis.
• Received extensive training on the Teradata RDBMS including the import and export utilities, hardware configuration, performance tuning, logical and physical data modeling, and front-end tools.
• Assisted with technical presentations of Teradata Solutions to many Financial Institutions.

Confidential, Phoenix, Arizona

Consulting Systems Engineer

Responsibilities:

• Successfully converted Arizona and Nevada Retail Accounts within four months using the data warehouse. Project required mastering the details of several major-processing systems. Conversion considered most successful of the 70 NationsBank had executed.
• Substantially enhanced the Confidential ’s view of its Customers by assisting in the design of a nationwide householding system that combined three existing systems.

Confidential

Responsibilities:

• Developed a process to identify the Confidential ’s High-Value customers who also held Credit Cards. These customers generated 50% of the net operating income of the Confidential . Identifier used extensively to provide an enhanced level of service, increasing customer satisfaction and loyalty.
• Redesigned the load process of Collection Data saving $100,000, cutting 24 hours off the load cycle, and increasing the number of users by 10 fold. This improved productivity of the entire Collection Department.
• Increased revenue by $100,000 monthly by leading a project that correctly repriced Credit Card Accounts held by former employees.
• Dramatically reduced returned mail and increased the accuracy of geographic analysis by leading a project to correct customer addresses. This significantly reduced fraud caused by mail intercepts.

Confidential

Responsibilities:

• Played a major role in the conversion of Business Card Accounts to a new processing system. Achieved accuracy levels during the set-up process never before approached. 
• Key Load Team member that designed a suite of tables to hold the Commercial Card data. My innovative techniques were subsequently adopted by other areas.

Confidential

Responsibilities:

• Mastering Teradata RDBMS and SQL.
• Creating tapes for mail solicitations and many other outside vendor needs.