Frank Hruby Email & Phone Number

Charlotte, North Carolina Area

Data Lead for MDSS (Marketing Decision Support System) data warehouse. MDSS houses 250MM+ accounts and 40MM+ retail and business households across 24 months of history. MDSS is the source system for householding retail and business accounts, account and household level profitability and High Value customers. • Managed the data quality workstream for monthly database releases. Met SLA every month in 2017.• Led onshore and offshore data quality team on the monthly data warehouse load and managed coordination with our UAT teams.• Designed and developed innovative dashboard, analytics, and reports using Tableau to identify data issues and lead KPIs development and tracking across key business functions.• Implemented new processes to standardize and automate various QC functions which led to more accurate data, few issues and a decrease in QC cycle time.• Evaluated, recommended and implemented strategies for developing enhancements to the data warehouse. • Conducted weekly Teradata learning presentations for the team on various Teradata topics including tables, joins, queries, macros and functions.• Performed ongoing assessment of data quality and test processes and provide direction for continuous improvement.• Led efforts to implement new data sources in the data warehouse.• Assisted team with database work including managing space, loading tables, building macros, updating tables and fields and streamlining and enhancing queries.

Charlotte, North Carolina Area

Data Quality lead for Wachovia/Wells Fargo systems integration and bank conversion for each of 20 merger events.• Responsible for the testing of the decisioning and tracking of over 30,000,000 accounts in 5,000 branches across the 3 year integration for the enterprise across the retail and wholesale and brokerage lines of businesses. Goals were met for each of the conversions. • Re-engineered and automated integration testing process which resulted in an increase in data quality, efficiency and organizational flexibility. Decreased total cycle time by over 40%. • Managed test plans and tracking of conversions and daily reporting of performance metrics.

Charlotte, North Carolina Area

Provide leadership on data quality assurance, testing and analytics for large enterprise-wide IT projects. and the Wachovia/Wells Fargo systems integration and. Manage the data quality validation testing for the Risk Information Management Environment (RIME).• Managed the testing and data quality for a number of enterprise-wide initiatives. Led a team of offshore analysts. • Managed the testing for the moving of data from BDW (Brokerage Data Warehouse) to EIW (Enterprise Information Warehouse). • Managed the production validation of the RIME data. This entails the aggregated data from the current month which is compared to expected norms and historical trends to identify trends and variations. Documented business rules are also executed to identify data quality issues. We have met our validation goals each month with no outstanding issues. • Developed and managed a defect tracking system for RIME production validation that traces defects to resolution and provides for metric and status reporting. • Testing of G/L data required for input to the RIME data warehouse.

Charlotte, North Carolina Area

Provided strategic, analytical and project management skills for retail bank, small business and private banking projects. Utilized customer data marts, models and analysis to increase sales and revenue. Worked closely with technology managers, business managers and analysts to develop solutions on various cross-sell, retention and revenue-generation projects. • Provided key leadership in the start-up, development and production of employee scorecards and ranking reports for 30,000 employees of the retail bank. This included scorecard design, database development, performance analysis and reporting responsibilities along with data quality responsibilities.• Provide insightful analytics to inform and support LOB Strategy, such as opportunity identification and performance analytics, customer segmentation, forecasting, and wallet share analysis.• Designed and developed initial retail book of business/portfolios for 2,500 financial centers which is a critical performance measure and currently an incentive multiplier for the 30,000 retail bank employees. In 2007, the book of business resulted in a $3 billion increase in deposits and outperformed the control group.• Designed and developed revenue reports and analyses for all 3,000 financial centers and 12,000 retail bank employees tracking lost revenue to the bank from NSF refunds, fee waivers and CD fees uncollected. Result was an increase in total revenue collected for the retail bank.• Developed data management programs, analytical processes for statistical modeling and sales goals for the retail bank. This included goals and analysis for new customer acquisition, cross-sell, small business and balance growth goals.• Oversaw the development of monthly reports and analysis for customer retention incentive program. Hired, trained and supervised five employees.• Created and implemented an employee referral tracking method, increasing loan and deposit referrals by 20% for over 20,000 financial center employees.

Charlotte, North Carolina Area

Managed targeted marketing and analytical projects to acquire, cross-sell and retain customers. Developed and managed analytical projects related to customer segmentation, acquisition, attrition, profitability and revenue generation for small business, commercial and on-line customers. • Analysis of large datasets to uncover patters and trends using statistical analyses.• Developed models of customer behavior to drive analyses for various revenue and profit generation projects including segmentation, retention, reporting and modeling. • Collaborated with IT group on warehouse and data mart development efforts. Provided guidance on householding, data cleansing, quality assurance testing, and future enhancements. • Produced direct-mail files for small business acquisition and cross-sell efforts for 2,500 financial centers. Consistently outperformed the control group.• Analyzed customer behavior and integrated the results of the analysis into effective strategies for retaining and acquiring new customers.• Managed and maintained vendor relationships with Dun & Bradstreet and Experian and incorporated the data into enterprise-wide systems and initiatives. Developed solutions with vendors to solve marketing and data issues.

Charlotte, North Carolina Area

Responsible for company, industry, financial and marketing research supporting small business, commercial and capital markets segments. Worked with relationship managers, portfolio managers and underwriters to apply information and provide key insights in their decision-making.• Developed and implemented a marketing strategy to automate the delivery of information to various user groups across the organization. As a result, clients had instant access to information versus three day delay. • Developed customer strategy to improve targeting and segmentation of existing prospects.• Created a company information system that houses numerous marketing, credit and lending data on over 10,000,000 companies. Developed a business design for the system along with identifying, testing and implementing fixes and enhancements to improve the operation and use of the system. Decreased online marketing and credit report expense by $350,000 per year and provided access to 30,000 bank employees.• Managed a knowledge-based decision support system for new customer acquisition and competitive analysis to increase acquisition rates.• Designed and developed databases to facilitate information retrieval, delivery and performance tracking. This included tracking of data usage, costs and relationship to sales success. Surpassed all quality and efficiency goals.

Buffalo/Niagara, New York Area

Heard complaints on residential and business real estate assessments and made a determination as to whether the valuation needs to be reviewed or adjusted.

Buffalo, Ny

Practiced law in the areas of taxation, bankruptcy, estates, business and contract law.

Master Of Business Administration (Mba), Accounting

Doctor Of Law (J.D.), Tax Law/Taxation