SUMMARY:

Strong business analyst contractor with a solid accounting background in a variety of industries. Commitment to improving processes and providing financial analysis that drives management decisions. Proven project professional with a strong track record of successful projects and delighted clients.

AREAS OF PRACTICE:

• Financial Analysis
• Strategic Planning
• Variance Analysis
• Forecasting & Budgeting
• Financial Modeling
• Contract Negotiations
• Management Reporting
• Financial Statement Reporting
• Market Analysis
• ERP Implementation
• Process Improvement
• Cost Accounting
• Inventory Management
• Internal Controls
• Business Intelligence
• Data Mining
• SDLC
• Agile
• Waterfall
• Manufacturing
• Banking
• Retail
• Consumer Products
• Services
• Pharmaceutical
• CATV

COMPUTER APPLICATIONS:

• SAP
• Oracle
• PeopleSoft
• OBIEE
• Hyperion Enterprise
• SQL Server 2008
• Visio
• Hyperion Essbase
• Business Objects
• SAS
• Microstrategy
• Crystal Reports
• Informatica
• Cognos
• Yardi
• RSA Archer
• Hadoop
• SQL
• TOAD
• CLPR
• JD Edwards
• PL/SQL
• VBA
• MAPICS
• Tableau
• Teradata

PROFESSIONAL EXPERIENCE:

Business Analyst

Confidential

Responsibilities:

• Defined, collected, analyzed and reported data for data controls testing.
• Migrated data testing results to an SQL database to be integrated with other data sources for reporting.
• Documented and created tickets for user to track issues in HP Quality Center.
• Work with technical team to acquire new data sources, remediate data quality issues.
• Lead control data testing and business audit review.
• Lineage capture and metadata documentation for federal regulatory reporting across several lines of business.
• Identified, clarified and resolved data discrepancies to ensure it is complete, valid and accurate.
• Participated in the analysis of current business process and systems to recommend process and system enhancements to improve business performance and maximize the effectiveness of technology.

Business Analyst

Confidential

Responsibilities:

• Assist in the technical build - out and support of databases, BI tools and dashboards that enable data analysis and data visualization.
• Support user with analyzing data mapping for old and new product Hierarchies.
• Document and create tickets for user to track issues.
• Work with technical team to acquire new data sources, remediate data quality issues.
• Responsible for working with our WDM technical partners to assist in translating business needs into complex analysis designs and recommendations.
• Ensure adherence to data management / data governance regulations and policies.
• Analyzed SQL queries, troubleshoot Wholesale Profitability application and system issues on OBIEE platform. Identified defects and document business improvements between ProfitMax and ProfitView.

Business Analyst

Confidential

Responsibilities:

• Accountable for the business staging and process of all data elements and periphery reference elements for monthly Confidential profitability reporting.
• Manage BAC Mortgage HUB and Wholesale Credit Provisioning projects overseeing the data mapping and integration of Confidential ’s reporting in accordance with existing sourcing technical logic.
• Manage offshore resources with primary responsibility of ensuring off-line business support and monthly reporting and data validations.
• Lead business support partners for the Risk Data Aggregation (RDA) project impacting profitability data sourcing and reporting.
• Create test plans and assist in the testing for projects with Loan products.
• Engaged Technology partners to extract, transform, and load credit risk data from various source systems in accordance with prescribed business requirements and regulatory guidelines.
• Accountable for data taxonomy and analysis of Confidential Critical Reporting Metric (CRM) across Line of businesses for regulatory compliance.

Business Analyst

Confidential

Responsibilities:

• Identified, managed and reported on all internal control deficiencies real-time and work with business Process Owners to facilitate the creation of action plans and remediation timetables to correct the deficiencies noted.
• Worked effectively with key stakeholders, including external auditors and senior management, to promote an understanding of Key Controls and managing expectations.
• Participated in setting and achieving Access and Identity Management performance metrics.
• Perform research and data analysis to ensure that financial reports are consistent per system.

Business Analyst

Confidential

Responsibilities:

• Maintain and enhance the F&A data & process governance structure.
• Worked with the Business User and Finance Leaders for requirements gathering, business analysis, testing, metrics and project coordination.
• Coordinated technology and organizing data governance across Finance.
• Performed data analysis using Excel in support of standard report offerings and customized client data analysis needs.
• Designed dashboards and score cards using Power Pivot for analysis of business.

Business Analyst

Confidential

Responsibilities:

• Responsible for performing reconciliations of WISe Data Marts supporting regulatory reporting.
• Created business requirement document (BRD) outlining functional requirements.
• Regression test all fix bugs and business required enhancements.
• Managed complex requirements from diverse stakeholders using trackability matrix.

Senior Financial Analyst

Confidential

Responsibilities:

• Prepare monthly and quarterly reporting decks on capital expenditures for FP&A management
• Participated in development and validation of reforecasting templates for business partners to use in the LRP and AOP process.
• Track and ensure requests are consistent with FP&A’s ROI and NPV financial modeling, workflow approval routing and accounting treatment guidelines. Regularly perform modeling by validating savings to evaluate capital spending for capital projects.

Financial Business Analyst

Confidential

Responsibilities:

• Responsible for producing monthly, quarterly and Executive Information System reports.
• Gathered requirements and coordinated with various departments to assure satisfactory data content, quality and data integrity.
• Assisted in developing project timelines/deliverables/strategies for effective project management.
• Performed data validation testing using OLAP Cube against the Apprise General Ledger.
• Review and analyze actual consolidated and regional financials and KPI results to identify business trends.

Senior Financial Analyst

Confidential

Responsibilities:

• Performed GL Reconciliation and research variances between source and target general ledger systems.
• Review and monitor recording of transactions originated by operations to ensure 3rd party reports and general ledger are in agreement.
• Performed research and data analysis to ensure that financial reports are consistent per system.

Financial Business Analyst

Confidential

Responsibilities:

• Responsibility included communicating with the various Line of Business Units, the Technology Group and subject matter experts to ensure compliance of requirements of the Data Repository for Extended Warranty.
• Duties include data validation, business requirement gathering and documentation, process flows, data mapping and process documentation.
• Actively involved in testing and reporting defects identified to appropriate channel for resolution.
• Manages multiple project deliverables of active projects within the Extended Warranty Group and the Technology Group and reports status to senior management team.