SUMMARY:

• Confidential is an innovative and driven Professional Sr. Business Analyst with 10 years’ experience. Confidential ’ is a professional Analyst with extensive knowledge and skills including: reconciliation, financial reporting and analysis investment, analyzing data, Full SDLC Life Cycle, Testing Requirements, general ledger, auditing and knowledgeable of CCAR, GAAP and Sarbanes Oxley (SOX) Standards & Government Regulations.

TECHNICAL SKILLS:

• Enterprise Data Management (EDM)
• Risk Data Aggregation (RDA) Standards
• Auditing /Federal Reserve Board Exams
• Global Policy Source Measurements
• Comprehensive Capital Analysis and Review (CCAR)
• Global Ledger and Reporting Operations
• (BPC) Business Planning and Consolidation
• Enterprise Stress Testing Data Governance
• Data/ Process Governance and Compliance
• Oracle, SAP eLedger
• OBIEE (Oracle Business Intelligence)
• Essbase
• TOAD
• SharePoint
• JIRA (Atlassian), HP Application Lifecycle Management (HP ALM)
• Microsoft (Intermediate) Excel, Project, VISIO, PowerPoint, Word
• SQL (Basic)
• Requirements Gathering
• Business Requirement Document (BRD)
• System Requirements Specification (SRS)
• Requirement Traceability Matrix (RTM
• User Stories
• System Mapping / System Integration
• SOR Mapping/ ADS Mapping
• Data Lineage/Data Warehouse
• Agile, Waterfall Software Development
• Gap Analysis
• Data Quality Assurance
• Master Data Management (MDM)/ Data Relationship Management (DRM)
• Process Improvements
• Risk Regulatory Reporting
• Project Management
• Change Control/Issue Management

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Senior SOX Compliance Analyst

• Maintenance and monitoring adherence to the financial and regulatory reporting internal control methodology
• Project management, oversight and reporting SOX deficiencies and COSO Compliance
• Training and support for business partners on application of the methodology
• Determination and application of materiality and scoping
• Development and maintenance of supporting infrastructure and technology
• Partner closely with controls / compliance team members within the different business units as well as the external and internal auditors
• Documentation and assessment of internal control weaknesses and data errors or omissions within Archer(E - CAP) database

Confidential, Charlotte, NC

Advanced Analytics

• Assist in initiatives to optimize Confidential ’s FSB Phase 3 Reporting and ensure appropriate integration into the reporting infrastructure.
• Conduct meetings with Data Providers to assess/remediate identified data gaps.
• Assist in data sample review to ensure accuracy and completeness.
• Aid in documenting the process for Governance & Oversight compliance
• Update/Create templates for CRR Corporate Finance group aligning with COSO policies
• Update group with SHRP issues pertaining to Data/control reporting process
• Analyzing the severity of control deficiencies, both individually and in the aggregate, and the impact to internal control for FR Y15, FR Y12 and FR Y12A financial reporting
• Contribute to the timely, accurate and complete production and submission in Q217
• Conduct Data Reconciliation relating to the Balance Sheet activities for Schedules HC-R Regulatory Capital, HC-L Derivatives and Off Balance Sheet Items Activities in reference to FR-Y9C
• Ensure the Balance Sheet (BS) is in balance between HC-R and HC-L Reporting Data by utilizing OBIEE and General Ledger
• Mapping/Reconciling data for edit check purposes for FR Y-15, FR Y-12 and FR Y-12A . To ensure the data submitted for the FRB is accurate and reasonable per the FRB instructions for a particular reporting quarter and or year

Confidential, Charlotte, NC

Sr. Business Analyst

• Leveraging experience working with different bank portfolios and analytics arena to systematically mine data to detect trends, anomalies, issues, etc. for purposes of communicating and prioritizing data remediation and workarounds
• Leveraging this experience to develop algorithms to repair, interpolate and extrapolate missing and/or inadequate data quality
• Reconcile FR Y14Q/M Portfolios in respect to Federal Reserve Instructions to the LOBs Response and provide report to management
• Monitor/Review changes to Enterprise Policies for Front Line Users/ Control Functions for FRY 14Q/M
• Managed LOB’s to ensure updates are made to all contents when changes are provided that will affect the current process resulting to non-compliance and becoming an audit issue
• Owning and assisting with the development of trainings focused on compliance with issue management policies and best practices
• Assisting with other Issue Management projects and initiatives as necessary
• Manage follow-up on audit results and implemented necessary resolutions to LOBs
• Work closely with external auditors and federal examiners
• Communicating with the Federal Reserve Board to ensure any items to which the Federal Reserve requires clarification are addressed to the Line of Business
• Creating new design approaches to enhance solutions/processes improvements
• Reviewing system/process changes to ensure they align to existing strategy
• Providing consultation as a Subject Matter Expert (SME) in regards to FRY 14Q/M processes/solutions
• Utilize JIRA application to conduct metric reports on key issues within the FR-Y14Q/M and make recommendations

Confidential, Charlotte, NC

Sr. Business System/ Project Coordinator Consultant

• Lead and coordinate User Acceptance Testing (UAT) across assigned projects. Including, partnering with IT and related test leads, script development, script execution, status and defect reporting using JIRA
• Extensively used Requirements Traceability Matrix to track requirements during QA testing phase
• Documented business needs, working with various function teams such as SMEs, IT and developers to create business requirements to achieve business needs and obtain applicable sign -off
• Managed the escalation of production issues/risks with LiMS (UX) application and ensure that they are escalated to the appropriate resources and researched through completion
• Provide front-line support to end users for new and enhancements to LIMS application during testing efforts through the entire life cycle process
• Organized meetings and prepared documentation through all phases of the project using multiple Microsoft Office tools including Excel, PowerPoint and Visio and SharePoint.
• Customized and configured workflow to allow the integration of client/server applications and test layout to ensure the system is meeting corporate needs Provides technical expertise in identifying, evaluating, and developing systems and procedures that are cost effective and meet business requirements.
• Worked with user groups to provide training, resolve questions, assess user needs, and recommend changes
• Presented feedback to the business as needed by re-engineering technical processes for greater efficiencies with significant impact to the business.

Confidential, Charlotte, NC

IT Business Analyst

• Managed financial models (US Daily, US MTH ACTUALS, US MTH AS IS) to ensure financial data is consolidated accurately by utilizing automated reporting through the use of Excel
• Utilized Essbase system to validate reports for data quality and to ensure data mapping was successful
• Support Integration efforts with IN$IGHT and SAP eLedger systems
• Conducted Ad Hoc reports for variance analysis for financial reporting, compare data for testing validation to ensure reports are working as expected for report/system enhancements and functionality prior to production.
• Maintained and updated reports, templates extract from business intelligence tools ( databases, dashboards, Oracle, SAP eLedger)
• Supported end users (BAs and PM) with Frontline unit training on new and enhancements to reports, BI tools and systems
• Applied standard change control process to track defects originating from post-requirement phases during testing and production
• Lead and coordinate full Quality Assurance (QA) process lifecycle for QA Integration, UAT and regression testing activities while working with Quality Assurance to provide product guidance on testing areas
• Reconciling system values such as BPC, DRM/MDM to ensure they are nsync
• Utilize iXP Java Web Start application to monitor Autosys jobs average runtimes, time of completion, and process chains for OBW Schedule to report job failures and errors to end users, etc.

Confidential, Charlotte, NC

Business Analyst

• Prepare and distribute of business lines of studies, reports, analyses, and recommendations in areas such as budgets, forecasts, financial statements, statistical reports, variance and business forecasts
• Conduct Ad Hoc reports for variance analysis for financial reporting
• Conduct presentations to internal clients to ensure each understood the financial impact of their business decisions, providing alternatives with accompanying analytics
• Record journal entries for periodic financial transactions and preserve supporting documentation.
• Reviewed transactions in general ledger and subsidiary ledgers for incorrect GL coding and proper balance
• Evaluate complex profit plans, operating records, and financial statements
• Developed and maintain models, integrated financial statement plans
• Involved in quarter, yearly closings and preparing monthly financial statements.
• Reconcile and analyze according to schedule, general ledger accounts for cash, investments, accounts and other receivables, other assets, accounts payable and accrued expenses, and other liabilities.
• Review data transactions for cash and for short and long-term investments, along with related investment income

Confidential, Charlotte, NC

Business Analyst

• Analyzed subsequent variances and identify trends and opportunities to lower control costs
• Used Oracle Tools Project Portfolio Management to manage and capture ideas, surveys, and request across Confidential customers through Web based.
• Managed the customer relationship project to determine customer satisfaction with our new branding strategies and recommend new product ideas and enhancements depending on the portfolios scoring and analysis conducted for each metrics
• Gather financial data for use in implementing participation agreement

Confidential

Business Analyst

• Responsible for driving closure of open items and partnering with business to close items as soon as possible
• Work closely with business partners to research and assist team in resolving reconciling items and outstanding issues
• Investigate, logging bugs and system enhancement requests backed by applicable research
• Established and maintained business process and implement recommend enhancements or changes as necessary