Analyst, Consumer Banking Risk Analytics Resume
4.00/5 (Submit Your Rating)
SUMMARY
- More thansevenyears of experience in consulting and performing data analysis for a variety of clients in manufacturing, healthcare, beverage, and aerospace.
TECHNICAL SKILLS
- MS Power BI
- Tableau
- SAS
- SQL 2012
PROFESSIONAL EXPERIENCE
Confidential
Analyst, Consumer Banking Risk Analytics
Responsibilities:
- Provide Enterprise Credit Risk Oversight support to the Consumer/Retail Bank.
- Create process flow mapping for all consumer lending products.
- Conduct SAS analysis to determine exposure / risk for SunTrust mortgage / credit division.
- Created SQL inner joins to manipulate data and find insights pertinent for decision making
- Develop reports/dashboards/ and presentations in Tableau to be distributed to senior management and regulators.
- Provide independent analysis of business results.
Confidential, Atlanta, GA
Data Analyst
Responsibilities:
- Resolve difficult pricing problems through data mining and data manipulation to establish organizational metrics.
- Analyze current and future customers' price/cost trends in order to build awareness of Confidential services.
- Created dashboards and queried information using MS Power BI and Power Query
- Automate reports via SAS coding to provide senior leadership with stats
- Used Excel to create pivot tables and graphs for presentations to senior leadership based on findings.
- Built databases in MS Access, establish KPIs, and coordinate with Import/Export teams to provide strategic support.
Confidential, Atlanta, GA
Data Analyst(Contractor)
Responsibilities:
- Manipulated data in Excel using a variety of formulas to create KPIs,andidentifytrends
- Make high - level, key observations and suggestions to leadership based on trends anddata from other internal business units with Excel pivot tables and V-Lookup
- Used Tableau to build reports/dashboards to monitor/update trends for the moderator team; monitor comments and flag key comments, records, and suggestions from operators
- Used Sharepoint to transfer files and communicate with upper management
- Track Call Center Data and provide insights to the Call Center Management to improve agent response time
- Report trending data using SQL, to the Problem SWAT teams and highlight inefficiencies within store operations
- Used SQL 2012 for creating inner and outer joins in order to create insights for upper management
Confidential, Atlanta, GA
Data Analytics Consultant(Contractor)
Responsibilities:
- Accountable for supporting Services Quality function in analyzing CoPQ and providing appropriate graphical summaries/reports identifying opportunities and measurements to targeted goals/objectives.
- Provided quality data analysis with Excel,reviewed KPIs, andgave summariesfor decision making purposes.
- Initiated cross training with Quality Engineers to identify opportunities impacting customer satisfaction and cost reductions.
- Reported to Quality Mgr. and provide multiple Excel reports on performance for areas of improvement.
- Communicate with multiple department heads to plan, organize, and implement change management.
Confidential, Atlanta, GA
Data Analyst(Contractor)
Responsibilities:
- Responsible for improving systems by understanding life cycles; establishing one-on-one relationships with clients and suggesting requirements.
- Executed queries with SSMS and/or T-SQL commands.
- Exported db datasets to Text or CSV files for import into other systems such as MS Excel or Access.
- Prepared and validated data, gathering documents, develop proposals, and provide positive resolutions.
- Performed special assignments and took on other research projects in accordance with specific guidelines established by management.
- Communicated between Coding/Programming departments and Program Managers.
Confidential, Atlanta, GA
Franchise Owner/Agent
Responsibilities:
- Maintained ownership of key recurring deliverables and request from clients. Recommended solutions for business issues and challenged current methods to improve efficiency.
- Reviewed and standardized complex documents to ensure accurate with compliance and all regulatory requirements.
- Daily activities included analyzing financial statements, expenses, and data file preparation, testing and implementation.
- Responsible for analyzing current trends and products to assist clients with their insurance needs.
- Provided solutions for clients inquiring of broker insurance products and a variety of property insurances.
Confidential, Atlanta, GA
Sales/Use Tax Consultant
Responsibilities:
- Served as a lead consultant on sales and use tax audit engagements for various manufacturing, aerospace, cosmetic and publishing companies.
- Performed file management; manipulated and extracted pertinent data from client text files/ data dumps
- Compilation of monthly account reconciliations on tax accrual balance sheet accounts
- Developed and prepared detailed client database used to determine taxability of various items purchased by clients, including equipment, machinery, professional services used for various management scenarios.
- Initiated and implemented strategic training for the sales/use team on Microsoft Access.
