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.
