Summary:

Seeking a role in Management Consulting or Business Analytics, I have expertise in business analytics, data and project management, business intelligence, application development, process creation, development and automation, and creating automated reporting solutions. A highly responsible and dedicated team player with the ability t learn new skills quickly, build strong work relationships, and a proven ability t single-handedly troubleshoot and find workable solutions t highly complex problems.

Skills:

Software:

• Data Analytics, Automation, and ETL: VBA, Excel, Access, T-SQL, PL-SQL, Visual Basic 2010, C .NET, SSIS, Business Objects Information Design Tool
• Statistics: SPSS
• Econometrics: SAS,R,STATA
• Report Development and Deployment: SSRS, SSMS, SSAS, Business Objects Web Intelligence, Oracle Application Express
• Database Design: ErWin, Visio
• Data Visualization: Tableau, Cognos, VBA/Excel t PDF, Xcelsius
• Databases: Oracle 11g
• Strong Business Analyst skills Soft tech: interacting with users understand the business processes and logic
• Strong Analysis skills possesses the stamina t look at numbers all day week-after-week
• Strong Technical skills SQL Server, DBA, Data Warehouse/Mart, Cubes

Employment:

Confidential

Associate, Business Analysis, Reporting, and Application Development

• Developed a custom database with customized reporting capabilities for Global Contracts Management ERISA Remediation team using Access and VBA.
• Created and managed robust Oracle APEX workspaces for Wholesale Loan Operations team.
• Created and Ran stored SQL/PL SQL procedures in SQL Developer t update/insert raw data int Oracle Databases.
• Queried data using SQL store procedures t produce and deliver multiple weekly reports.
• Developed advanced Remitter Database and Reporting System using Access/Excel/VBA for Receivable Operations team which transformed int APEX and Oracle 11g solution. Served as Project Manager for this initiative.
• Created batch file script for mass data file manipulation

Confidential

Business Analytics Process Specialist

• Full-time role with full benefits, reason for leaving: resigned for better offer.
• Developed and implemented an ETL process t manage 9 servicer source files utilizing advanced VBA, SQL, Access, and C .NET from multiple unique sources.
• Developed and deployed a loan tracking database using C .NET and MS Access for Default Control Team.
• Established ODBC link t SQL production data tables for Trust and Fund Services Team and led the creation and automation of customized reports and various other automated tools for Default Control Team.
• Created multiple automated Subservicer Productivity Performance reports including Subservicer Productivity, Charge-Off Analysis, Exception Reports in addition t automation tools utilizing SQL/VBA and Advanced Access queries.
• Automated and received recognition award for Wells Farg weekly claims packet generation process, Daily Escalation Reports and Monthly Exception Reports for Default Team.
• Provided Ad Hoc Analytics reporting support t multiple lines of business and managed multiple projects for both internal/external team members.

Confidential

Sr. Business Analytics Process Analyst

• Full-time role with full benefits, reason for leaving: resigned for better offer.
• Created, restructured, and automated Financial Reporting metrics for the Retail Lending, Home Equity, Legacy M I/Harris, CRA, Government Lending groups utilizing VBA, Access, and SQL.
• Developed an Investor Funded Loan Tracking database with multiple input forms, a dashboard, and filters t export t Excel.
• Created Tableau and SSRS reports for Mortgage Sales and Mortgage Operations business.
• Took over commission statement generation process for loan originators, market managers, and new hires. Thoroughly analyzed existing process and created automation tools for various data extraction/manipulation pieces of the process.
• Collectively generated and delivered over 25 reports on a daily, weekly, and monthly basis consisting of Scorecards, performance matrix, operation analytics, and dashboard reporting.

Confidential

Business Analytics Process Analyst

• Consulting engagement, reason for leaving: contract assignment ended.
• Automated analysis of over 1 billion for the Large Corp, Small Corp, and Public Funds sector on revenue updates/analysis/reports, fee analysis, management/client reporting on a quarterly basis utilizing VBA. mstsc
• Utilized Advanced Excel and VBA t automate the quarterly generation of the top ten revenue producing clients by segments.

Confidential

Analyst Consulting Contract reason for leaving: company shut down

• Utilized Visual Basic for Applications t automate processes and reports through an ODBC link t SQL Server.
• Created multiple customized employee productivity reports in Tableau for various lines of business.

Confidential

President and CEO

VBA Development Business Process Consulting Projects

Integra Realty Resources

Confidential

Developed automated input, tracking, and reporting spreadsheet for the management team and controllers.

Confidential

Developed automated rate modeling spreadsheets for actuarial associates on the Product Development team.