Meka Madu 617-***-**** ******@*****.***
•Background
•Objective is to create innovative statistical models, analytics and reporting that drive profits, loss mitigation and increased productivity for businesses and groups using research design and measurement methods that give project the best chance of success. Provide the insight required for senior management to make sound decisions and informed projections for the future of the business.
•Data analysis, inference and presentation for Executive and senior leadership audiences using dashboards and scorecards.
•Financial and Operations management strategy development and modeling
•Data Warehouse architecture, design, management and maintenance
•Process analysis, project management and software development life cycle experience
Qualifications
•Excellent analytical skills
•Project management experience around executing complete data, process and project roll-out using advanced Business intelligence tools including Cognos Framework manager, Transform, Business Objects, ETL tools, SQL Server SSAS, SSIS.
•Experience leading and implementing Risk Management, Compliance and Business process analysis for IT, Retail & Financial Service sector applications including CRM Strategies, Call Center and back-end operations
•Software: UNIX, NDM, Cognos BI, Crystal Reports Enterprise, Excel, SAS, SAP and MicroStrategy.
•Strong programming, trouble shooting and tuning/optimization skills ( Oracle PL/SQL, Microsoft SQLServer, SAS, Teradata, SAP)
Experience
CVS Caremark MEDD Enrollment Operations
Enrollment Operations Reporting Senior SQL Developer Apr 2015 – Mar 2016
Created, deployed and maintained SSIS ETL packages on 2008R2/2012 to support complex CMS based reporting processes covering platforms including End to End Timeline reporting for member enrollment services.
Created ad-hoc and recurring reports to support critical Annual Enrollment Period (AEP) Reporting for client based accuracy analysis using SSRS 2008 platform.
Initialized project to convert SSIS resources from 2008 to 2012; worked with a team of developers, data architects and administrators to implement upgrade, migrating hundreds of SSIS packages to new server environment.
Bank of America Legacy Assets and Servicing Division
Centralized Operational Reporting Consumer Product Strategic Analyst Jan 2013 – Jan 2015
•Lead developer and management resource for a group of operational and compliance reporting dashboards built to monitor internal and external mortgage portfolio metrics.
•Develop, deploy and maintain SSIS packages to complete ETL processes with non-traditional sources including Sharepoint, Teradata, SAP and SQLServer.
•Supported SAP HANA, BEX Query development while developing front end reporting using WEBI and Universe platforms
•Provided Daily, monthly and quarterly reporting on key call center operations performance and productivity metrics.
•Created Tableau based reporting and analytics for CFPB data on Mortgage complaints to address and minimize negative impact to the bank.
Apollo Group
AECCSS Reporting and Analytics Senior Reporting Analyst Mar 2012 –Sept 2012
•Database consultant and report developer for a series of conversion projects transforming reports from Crystal Reports, Access and Excel into SSRS reporting suites for senior managers using SQLServer/SSRS, SSIS, Oracle and several ETL tools.
•Deployment and incorporation of new data assets including SalesForce and Oracle based platforms
•Designed and deployed Tableau Dashboards to sit on top of SalesForce Application, providing Just-in-Time reporting and analytics for Call center operations management. Provided Daily, monthly and quarterly reporting on key call center operations performance and productivity metrics ;
Wells Fargo Bank
Consumer and Business Deposits – Analytics Marketing Database Consultant Dec 2009 – Jan 2012
•Managed the SMART (Strategic Management Acquisition and Retention Tool) leads development and delivery system for marketing campaign deployment providing analytics, forecast and post-campaign performance tracking for both consumer and business campaigns (EAST/WEST) on Prospector, SOLD and Direct Marketing vendors.
•Developed new performance tracking dashboard for small business marketing campaigns to standardize metrics and deliver real time campaign performance tracking while providing actionable insights through analytics. Standardized portfolio report creation and delivery to eliminate manual processes and reduce user error rate.
•Created portfolio and customer centric performance reports and Supported conversion/merger efforts by providing post-conversion leads list support for converted accounts.
Business Direct – Operations Management Metrics Analyst June 2006 – Dec 2009
•Lead Developer and analyst for Business Direct Eagle Eye Dashboard application which provides senior level management top-down performance metrics and forecast reports designed to facilitate agile management and faster decision-making while tracking productivity and through-put for mid-level managers and their teams. These key performance metrics drive overall strategy for the operations group and provide the basis of the team member incentive packages which in turn drive team member satisfaction, better quality, higher productivity and lower cost
•Responsible for translating new systems implementations into quantifiable business metrics using cost/ benefit analysis and key performance indicators to measure impact and identify trends, patterns and variations. Created comprehensive process maps for complex iterative procedures and deduced changes that would increase efficiency reduce bottlenecks and save costs by reducing FTE counts.
•Designed and implemented tests and strategies for our verifications groups that would increase conversion rate; reduce fallout and maximize commitments by predicting customer response to requests for documents regarding personal and business entities. These findings were also applied to queue logic to create a more efficient process for verifying approved applications which drives down the timeline and increases both customer and banker satisfaction with the bank and it’s process.
KSC-TRI Systems Inc. Los Angeles, CA
Technical Consultant/ Education Specialist May 2004 – June 2006
Executive Analytics and Design, Boston, MA
Web Applications / IT Systems Developer Feb 2003 – May 2004
Education B.Sc. Computer Engineering, Northeastern University, Boston, MA
•Activities Business on Board Trainee, Phoenix Arts and Business Council; Founding member, Linking the Youth of Nigeria through exchange (LYNX); Registered Federal Independent Contractor for Learning and Computer Education systems; Researching emerging markets;