SOFTWARE DEVELOPMENT / ANALYTICS EXECUTIVE
(Currently employed - very successful - open to growth opportunities)
Dear Recruiters:
As TEAM LEADER for a FORTUNE 500 COMPANY, I've leveraged my experience with client services, project management, analytics, systems development and SAS to design and implement an integrated system supporting core financial and marketing functions, decreasing the monthly processing overhead by 85%, while improving computational accuracy and internal controls.
In an earlier engagement with Wells Fargo Home Mortgage, I created a comparative market analysis of third-party demographic and credit data relevant to customer modeling and segmentation along with my recommendation for future purchases. Additionally, with Tracfone Prepaid Wireless, I created email and telemarketing campaigns that decreased customer retention rates by 17%.
With Citibank, I developed a risk management system that resulted in a 10% ($4,800,000) decrease in gross fraud losses for 1998 and implemented changes to credit policies that improved existing cardmember marketing programs.
Relevant skills include Excel, Word, Powerpoint, Access, Project, Visio, Visual Basic, CHAID, CART, regression, clustering, SAS, SQL, OLAP, JAVA, Object Oriented Design(UML), Oracle, SQL Server and logical & physical data modeling.
Have MS Statistics, BS Applied Math and Project Management certification.
Compensation in recent years has ranged from $95,000 to $125,000.
Resume follows.
Thank you.
3 years with current employer
FORTUNE 500 COMPANY
Northeast, USA
TEAM LEADER - MARKETING SYSTEMS
Joined this company as a TEAM LEADER reporting to the Senior Vice President of MARKETING SYSTEMS. With a staff of 5, responsible for the implementation of a financial reporting and analytics application, for a major division of the company, supporting 100+ lines of business.
Leveraged my experience with client services, project management, analytics, systems development and SAS programming to design and implement an integrated system supporting core financial and marketing functions for 60+ users.
MAJOR BUSINESS INTELLIGENCE INITIATIVE
When I joined, the project was a year old and failing. As project manager and liaison between internal clients and external consultants, I interviewed stakeholders to understand existing development and formalize business requirements, secured programming staff to transition from consultants to my team and hired a technical writer to create system documentation and training materials.
Next, we implemented change control, disaster recovery and testing procedures to comply with corporate standards and an Oracle database to house operational data. Capitalizing on the base product, we leveraged its dimensional database to automate our manual processes, reducing the monthly close by 85%, from 7 to 1 business days, while improving computational accuracy and internal controls.
To meet requirements not addressed by the base product, we designed and implemented a customized subsystem to allow marketers to estimate sale, a SAS return flow model to improve estimation and a reporting application to present results.
Furthermore, we created a budgeting subsystem with SAS, Excel and Visual Basic to satisfy the business need for flexibility and the marketing need to create real time P&L scenarios. The subsystem automates both the budget consolidation and the interface to the Peoplesoft general ledger.
Presently, I am working with senior management and internal auditors to satisfy standards regarding change control, information security, and internal controls required by Sarbanes-Oxley legislation.
NOV '00 - OCT '01
QUAERO L.L.C.
New York, New York
SENIOR MANAGER - ANALYTICS
Joined this provider of Analytical CRM consulting services as a Senior Manager reporting to the Executive Vice President of Client Relations. Utilized my experience with customer analytics, experimental design and SAS programming to serve clients in the telecommunications and financial services industries. Expanded my knowledge of customer relationship management, marketing automation, data warehousing and call center operations.
After a year of successful consulting engagements, market conditions forced clients to slash consulting budgets, resulting in layoffs at Quaero.
CUSTOMER DATA MART DESIGN - WELLS FARGO HOME MORTGAGE
Senior management at Wells Fargo retained Quaero to design a customer data mart to support cross-selling initiatives. As the analytical lead, I was responsible for recommending third-party data relevant to customer modeling & segmentation for inclusion in the data mart.
As a first step, I collected and reviewed information from 20+ vendors including Experian, Equifax, Trans Union and Acxiom. Based on their current data purchases, I created a comparative analysis of demographic, individual credit and summarized credit attributes of the major vendors along with my recommendation for future purchases.
CUSTOMER RETENTION PROGRAMS - TRACFONE PREPAID WIRELESS
Based on the Tracfone business model, customers who failed to purchase additional minutes within specified time periods had their service discontinued and lost their phone numbers causing customer upset and negatively impacting ROI.
As a first step, I interviewed marketing and operations to understand their business and address concerns. Working together, we decided to implement email and telemarketing campaigns to remind customers to purchase additional minutes within the specified time frame.
Next, I met with IT to identify data necessary for campaign execution and created business requirements and execution work flows for both campaigns. Based on a prior relationship, we engaged West Telecommunications to provide our outbound telemarketing.
Furthermore, I implemented audit processes using SQL to ensure the call center delivered on our requirements, designed tests based on experimental design to measure campaign effectiveness and SAS reports to present results. The campaigns resulted in 17% reduction in gross customer attrition rate.
OCT '99 - MAY '00
PROVIDIAN FINANCIAL, "ARIA.com"
San Francisco, California
ANALYTICAL CONSULTANT - SMITH HANLEY CONSULTING GROUP
Accepted a six-month contract-to-hire assignment with this issuer of credit cards in an online start-up venture, "ARIA.com", reporting to the Vice President of Customer Analytics.
In the late 90's senior management at Providian believed the Internet would revolutionize the credit card business. Since the Internet was a non-traditional acquisition channel, ARIA decided not to leverage the resources of the existing Providian business and create its own analytical infrastructure.
I was invited to join the Customer Analytics team developing this infrastructure.
As a first step, I proposed a monthly review to measure and track the ARIA portfolio. Leveraged my experience with SAS, SQL and Excel to extract and manipulate performance data from our customer databases and presented a comprehensive vintage-based review of the ARIA portfolio to senior management.
Unfortunately, following this initial success, it was quickly becoming clear that the Internet was not delivering on its promise to transform the business and was likely just another acquisition channel for Providian.
In March 2000, Providian offered me a full time position. However, after learning that the existing Providian portfolio was assuming the ARIA customers, I decided to complete my project work, resign my position and return to New York.
DEC '94 - SEP '99
CITIBANK CREDIT CARDS
Long Island City, New York
MANAGER - CREDIT RISK MANAGEMENT
Joined as an Assistant Manager reporting to the Vice President of Fraud Risk Management. In my first role, I managed the fraud screening effectiveness of Citibank's authorization system. After developing and successfully implementing a 'neural-network' enhancement to the authorization system, I was promoted to Manager in 1997. Following this promotion, I worked in Credit Risk Management where I proposed and implemented changes to underwriting policies that improved existing cardmember marketing programs.
After five rewarding years with Citibank, the explosion of the Internet and the promise of e-business led me to seek a new challenge. Providian Financial invited me to join their on-line venture, "ARIA.com", so I resigned my position at Citibank and moved to San Francisco.
BASELINE - AUTHORIZATION SYSTEM ENHANCEMENT
CITICORP SERVICE EXCELLENCE AWARD
Authored business requirements and proposed project to Systems Development to secure development resources. Designed and executed test plans to ensure system programmers delivered on project specifications. Developed a scoring module to detect authorization fraud as part of Baseline. Project resulted in 10% ($4,800,000) decrease in gross fraud losses for 1998.
EDUCATION
Certificate in Database Application Design and Development '05
Columbia University, New York, New York
Certificate in Project Management '03
Kepner-Tregoe Project Management Workshop
Master of Science in Statistics '94
State University of New York at Stony Brook, Stony Brook, NY
Bachelor of Science in Applied Mathematics '92
State University of New York at Stony Brook, Stony Brook, NY
RELEVANT SKILLS
* CHAID, CART, logistic regression, ANOVA, factor analysis and clustering.
* BASE / SAS, SAS / STAT, SAS / MACRO, SAS / SQL, SAS/FMS, SAS/E-Miner.
* SAS Intrinsic and Unica Campaign.
* MVS / ESA, VM / ESA, UNIX and Windows NT.
* SAS/AF, SAS/SCL, Visual Basic, Java and UML
* IBM DB2 / UDB, ORACLE, SQL Server and Informix SQL.
* ProClarity, SAS/FMS and MDX.
* MVS / JCL, TSO / ISPF and Syncsort.
* Excel, Word, Visio, Project, Access, Powerpoint and Visual Basic.
CONTINUING EDUCATION
* Project Management Workshop '03
* SAS Enterprise Miner '03
* ProClarity Client Training '02
Unica Corporation, Lincoln, MA
* Unica Campaign Partner Training '01
Citibank Learning Institute, Long Island City, NY
* Risk Management '98
* Foundations of Profit and Loss '98
SAS Institute, New York, NY
* Strategic Performance Management '04
* SAS / AF : Application Development I & II '03
* Macro Language '99
* Logistic Regression Modeling '99
* Multivariate Statistical Methods: Practical Applications '98
* Basics Statistics Using SAS Software '98
* Advanced Programming Techniques & Efficiencies '96
American Statistical Association, Alexandria, VA
* Classification and Regression Trees '00 |
