Michael Mina's Page
Profile Information
- Short Bio:
- Experienced business analyst and project manager with a proven record of creating solutions via the application of interpersonal, analytical and technical skills. Excels in diverse environments. Technical extrovert with excellent communication skills and a proven record of adding value. Problem-solver and consensus-builder.
Specialties:
Project Management, Database Marketing, Marketing Research, Data Administration, Data Modeling, Data Analysis, Business Intelligence, Data Warehousing, Metadata Management, Database Design, Data Flow Diagrams, Business Process Mapping, Software Instruction, Instructional Design.
Feel free to contact me at michael.mina@att.net
- My Website:
- http://michaelmina.info
- Field of Expertize:
- Finance, Marketing Databases, SAS
- Years of Experience in Analytical Role:
- 13
- Professional Status:
- Technical
- Interests:
- Networking, New Venture
My work at National City Bank
Since 9/2007, I have been, and I currently am, a Senior Market Analyst for National City Bank. My accomplishments include:
- Coordinated development of customer scoring algorithm and segmentation strategy for $11 Billion, 270K household bank acquisition.
- Developed a process to analyze telemarketing campaigns (15.5 million phone calls).
- Prepared data intensive analysis of campaigns related to our 3.6 million account, $51 billion savings portfolio, and some campaigns related to the 3.4 million account, $14 million checking portfolio.
From 5/2005 - 9/2007, I was a Business Analyst at National City Bank. My accomplishments included:
- Contributed to business process design sessions and helped prepare 70 page requirements document for corporate-wide CRM project expected to earn $90 million over 5 years. Received Champion Award and nomination for Excel Award. Celent recognized National City as a "Model Bank" for this project.
- Developed complex SQL for Best In Class corporate initiative consisting of 33 projects. Participated in requirements gathering and prepared statement of deliverables. Received two Champion awards.
- Determined that incorrect privacy data for 80K customers of 2 acquired banks was preventing us from marketing to them. Identified affected customers. Received VIP Award.
- Helped Fulfillment department correct the misreporting of 1099 forms. Created queries to correct deletions, map data to correct format, and reinsert data into tax form files. Developed automated QC process and reduced accounts requiring manual correction from 14,000 to 6. Received VIP Award.
- Developed methodology to compare account data and household data and identify data anomalies via SQL queries and Visual Basic modules as part of the Data Warehouse Remediation project.
- Managed data preparation for annual Customer Satisfaction Surveys across 7 states. Met with requestor and others to develop business rules. Prepared complex SQL queries to generate final results.
- Assumed joint responsibility for running Data Warehouse metrics. Enhanced SQL queries that generate the metrics, added additional metrics and documented the procedure to run the metrics. Developed an automation-assisted process to validate the Household Profitability Audit Report that had been previously validated manually.
- Developed reports to enable analysis of checking accounts, money market, brokerage, mortgages, student loans for the purpose of direct marketing, fraud investigation and statutory reporting.
- Coordinated development of customer scoring algorithm and segmentation strategy for $11 Billion, 270K household bank acquisition.
- Developed a process to analyze telemarketing campaigns (15.5 million phone calls).
- Prepared data intensive analysis of campaigns related to our 3.6 million account, $51 billion savings portfolio, and some campaigns related to the 3.4 million account, $14 million checking portfolio.
From 5/2005 - 9/2007, I was a Business Analyst at National City Bank. My accomplishments included:
- Contributed to business process design sessions and helped prepare 70 page requirements document for corporate-wide CRM project expected to earn $90 million over 5 years. Received Champion Award and nomination for Excel Award. Celent recognized National City as a "Model Bank" for this project.
- Developed complex SQL for Best In Class corporate initiative consisting of 33 projects. Participated in requirements gathering and prepared statement of deliverables. Received two Champion awards.
- Determined that incorrect privacy data for 80K customers of 2 acquired banks was preventing us from marketing to them. Identified affected customers. Received VIP Award.
- Helped Fulfillment department correct the misreporting of 1099 forms. Created queries to correct deletions, map data to correct format, and reinsert data into tax form files. Developed automated QC process and reduced accounts requiring manual correction from 14,000 to 6. Received VIP Award.
- Developed methodology to compare account data and household data and identify data anomalies via SQL queries and Visual Basic modules as part of the Data Warehouse Remediation project.
- Managed data preparation for annual Customer Satisfaction Surveys across 7 states. Met with requestor and others to develop business rules. Prepared complex SQL queries to generate final results.
- Assumed joint responsibility for running Data Warehouse metrics. Enhanced SQL queries that generate the metrics, added additional metrics and documented the procedure to run the metrics. Developed an automation-assisted process to validate the Household Profitability Audit Report that had been previously validated manually.
- Developed reports to enable analysis of checking accounts, money market, brokerage, mortgages, student loans for the purpose of direct marketing, fraud investigation and statutory reporting.
A d v e r t i s e m e n t
Photos
Analytic Jobs
Events
Recent Visitors
© 2009 Created by Vincent Granville
Comment Wall
You need to be a member of AnalyticBridge to add comments!
Join this network