SASEG*.*, Tableau, MicroStrategy and MS Excel
Sr. BI Intelligence Analyst with 15+ years of experience and expert in Data Analytics and Strategies. Customer Retention, Campaign Analytics, Trend Analyses, Sales and Revenue in Consumer Collection Division. Professional in data Visualization and Reporting. Surpasses at identifying data vulnerabilities, developing, implementing, and establishing: strategy best practices, policy development, assessment, remediation, and validation. Excellent communication and organizational skills for client goal setting and satisfaction. Ability to multitask in fast-paced and stressful environments.
Actively researches and leverages current and emerging data technologies. Utilizes data-centric security metrics to strategically predict trends.
PROFESSIONAL EXPERINCE:
Sr. BI Intelligence Analyst October 2006 – November 2019
Bank of America (Remote) Newark, DE
Responsible for annual trending analyses for Sales, Revenue and Customer expenses. Provided data reports, visualization and trending analysis to internal division stakeholders. Managed all aspects of data reporting and served as the single point of contact for the creating and developing of effective SASEG9.4, Tableau, MicroStrategy to generate automatic reporting.
Managed and allocated branch resources and personnel who serve as liaisons. Synchronized with third-party vendors and stakeholders in setting right customer goals and objectives.
Lead the development of embedded data analytics using the Tableau, MicroStrategy platform. Created scripts/integrated testing for weekend release into production. Prepared waterfall reports for management review using the Tableau, MicroStrategy platform. Utilized MS Excel Pivot tables to develop analytic reporting. Researched, analyzed and segmented data for list generation purposes.
Provided effective leadership and coordination to automate reporting and data analytics for the Consumer Collection Division.
Maintained implementation of the Code Validation Board for Consumer Collection Division. Cross trained co-workers how to code in SAS and SQL//PLSQL//PROC SQL.
Data Analyst- Reporting, Researching and Analytics October 2004 – February 2006
GMAC Mortgage Horsham, PA
Developed and oversee multiple processes, customer analyses trends, customer expenses, Sales and Revenue trends submitting to upper management.
Led the development of embedded analytics using the SQL Server, SAS, SSIS, SSRS platform.
Orchestrated waterfall reports for management review using the SQL Server, SAS, SSIS, SSRS platform. Utilized MS Excel Pivot tables to developed Data analytics reporting. Researched, analyzed and segmented data for list generation purposes.
Provided Ad-hoc Reports for Monthly Client Retention, Product Relationship, Demographics breakdown, Service
Cross-Sell, Profitability and other special management reports.
Database Contractor February 2004 – September 2004
The Vanguard Group (Randstad) Malvern, PA
IT Manager (Contract) January 2003 – January 2004
Database Consultant Corp. Philadelphia, PA
Assistant Vice President – Business Development June 2002 – December 2002
United Savings Bank Philadelphia, PA
Marketing Customer Information (MCIF) Manager December 1998 – March 2002
Wilmington Savings Fund Society, FSB Wilmington, DE
Sr. Database Administrator (Database Marketing Manager) May 1986 – November 1998
Wells Fargo/Wachovia/First Union/CoreStates Bank Philadelphia, PA
EDUCATION
Major: Bachelor of Science, Mansfield University Philadelphia, PA
CERTIFICATIONS
Tableau 2015 - MicroStrategy 2010 - SASEG 2009 SAS Programming I Essentials at SAS 2005
SAS Programming II Manipulating Data at SAS 2005 SAS Programming III at SAS 2006
SAP Applications at SAP 2006 DBA Masters Certification at Oracle Institute 1998
OS/2 - Warp - PCLC’s - Advanced OS/2 Warp and Lan Server 1996
PC Support - PCLC’s 1996
AWARDS
Team work at Bank of America – Superior Performance Award, 2019
Recognition Awards from Internal customers – Bank of America 2006 to 2019
AFFILIATIONS
Board of Directors for Associazione Regionale Siciliana
Member of Direct Marketing Association (DMA)
CLEARENCE Top Secret /DOD
TECHNICAL EXPERTISE
Data visualization, Data modelling, Data Analytics, Tableau, MicroStrategy, InterAction, Analtyix database system, Explore Database, Sedona Intarsia Database, Pinnacle database system, Total Marketing Database, SQL Server, SASEG9.4, SQL-Plus, Oracle, Unix, SAP, FTP, BusinessObjects 6.5, Crystal Reports, iMark, Mapinfo, Consumer Point, Business Point, Novell Network, Quattro, IMS, TSO, SAS, UCC7, CRISP Systems and Adobe PDF, Microsoft 365 Suite (Access, Visual Basic, Word, Excel, PowerPoint, Team, Skype and Outlook), and Cisco WebEx