Summary:

• Dynamic Business Lead/Senior Financial Business Analyst professional with 10 years of experience in financial industry.
• Worked extensively on business user requirements gathering, gap analysis, development of functional specs and testing (SIT and UAT) for critical mission accomplishing projects.
• Expertise includes Treasury Services and Securities line of business including Liquidity, Core Cash and Global Trade.
• Expertise in Controllers group related to month - end / quarter-end reporting, accounting and financial reporting/operations.
• Expertise in Confidential (Anti-Money Laundering) compliance, KYC (Know your customer) and CDD (Customer Due Diligence) related projects.
• Extensive knowledge of Equities, Fixed Income instruments including debt securities, Derivatives, FX OTC Options, Capital Markets, Bonds, Exchange-traded Funds, Asset-Backed Securities and Mortgage-Backed Securities.
• Strong knowledge of market risk, credit risk, risk management and wealth management.
• Strong knowledge of Dodd Frank, Basel and other banking regulatory requirements.
• A very good team player with excellent communication skills and presentation skills.

TECHNICAL SKILLS

• Win 95/98/2000
• MS Access
• MS Project
• MS Word
• MS Excel
• MS Visio
• MS PowerPoint
• Acrobat Pro
• SharePoint
• Hyperion Mercury Quality Center
• Test Director
• JIRA
• Application Lifecycle Management (ALM)
• MIDAS
• NetX
• eAnalytics
• Docspeed
• Hyperion Financial Management Application
• Hyperion Planning Application
• LAP General Ledger
• SAP
• Business Objects
• Essbase
• Smart view

PROFESSIONAL EXPERIENCE

Confidential

Sr. Accounting Business Analyst/ Project Manager

Responsibilities:

• Worked on analysis of current CMT system used for cost of funds calculation and gap analysis between CMT and target system RFI.
• Reconciled the balances between GL and source systems for accurate calculations; resolved breaks via meetings with IT and users.
• Did testing of back office source system files to ensure that the proper accounting flows were created.
• Created change management documents capturing all the business and technical requirements, system flow, testing schedule and project timeline; worked with Treasury to define reports for Front Office.
• Undertook analysis for exceptions in target system and manual accounting workarounds required. Interacted with business users to define details of the process and ownership of manual entries.
• Analyzed legacy referential data in BDR/Starware and approach required for legacy New Edge GOPs in RFI.
• Worked on process of reconciling GL and RFI balances via an automated recon tool.
• Walkthrough of change management and project documents with users.
• Involved in testing of RFI system, accounting entries and cost of funds calculation; used Business Objects for testing and obtaining GL balances.
• Participated in project status calls and worked on reporting for senior management.

Confidential, NJ

Sr. Business Analyst/ Project Manager

Responsibilities:

• Created business/functional requirements for all the reports in HFM and HP application.
• Worked with business to create templates for the reports by legal entities and by balance sheet/income statement accounts; created smart view templates using Essbase for IHC Board report.
• Mapped all Chart of Accounts to report line items. Requested new accounts as required through DRM (Data Reference Management) system; mapped legal entities and consolidated them for reporting purpose.
• Worked on memo accounts for reporting and created logic for formulas to be calculated.
• Reconciled the balances from general ledger LAP to OFSAA to Hyperion.
• Analyzed and reconciled the balances in HFM and HP. Worked with IT on the differences via tableau reports; reconciled the IHC Pln and Mgt Rpt cubes in Essbase for reporting.
• Analyzed unmapped métier (business line) revenue and expense balances for each month and allocated the unmapped balances coming from general ledger LAP to appropriate legal entity/business line.
• Reconciled pre-allocated and post-allocated IFRS and GAAP balances in the system.
• Worked on journal entry requirements for intercompany eliminations and manual adjustments in HFM.
• Created IFRS and GAAP input templates for business to input monthly and quarterly manual adjustments.
• Uploaded manual balances for budget data and memo accounts in the application. Aggregated the data from the leaf level dimension members to report at an upper level dimension hierarchy.
• Updated the board report based on the CFO requirements every quarter.
• Created test cases corresponding to all the business/functional requirements and uploaded in ALM; tested all the reports and tracked issues /defects in ALM.
• Created traceability matrix for business to functional requirements to test cases.
• Worked on Security matrix for the application to grant access to users based on legal entities, business line and read/write access roles.
• Trained business users on the application for journal entries, reports and smart-view templates.
• Reported the status of the project and defects resolution on weekly basis to senior management.
• Worked on Go-Live documents, training manuals and created Hyperion smart view/Essbase retrieval templates for business.
• Supported post Go-Live issues related to data reconciliation and production of reports.

Confidential, NY

Sr. Business Analyst/ Project Manager - KYC Client Onboarding

Responsibilities:

• Performed UAT on KYC data load for new fields and performed testing for eAnalytics reporting of KYC fields.
• Created integrated project plan for all the projects related to accounts and client services workstream. Coordinated with technology for the plan dates and milestones.
• Managed the process for updating the legal agreements in Docspeed.
• Attended meetings for updating insider training and risk rating sections in KYC forms.
• Created test scenarios for sync up functionality of data.
• Participated in daily calls for operational issues and maintained a log of action items/key decisions.

Confidential, Chase, NY

Sr. Business Analyst/ Project Manager

Responsibilities:

• Finalized business requirements and reporting requirements for New Business Initiative project.
• Developed future workflow model in MS Visio for the approval process of PDCs and RRMs.
• Interacted with technology for functional requirements and design of the new workflow tool.
• Worked on Qlikview reporting requirements for the project.
• Worked on UAT Test strategy and test scripts. Used ALM for UAT testing.
• Created training manuals for businesses for the workflow tool and ALM.
• Drafted LOB Implementation plans and Operating Model templates for LOBs.

Confidential

Responsibilities:

• Created current and future data flows for implementation of target architecture.
• Held meetings with stakeholders for gathering business requirements for Appway and Mantas.
• Created sample reports for business and worked with Mantas to get the reports automated. Worked with data mapping team to have all the EvA report fields mapped to Mantas fields.
• Reviewed functional specification for design / build with IT team.
• Created traceability matrix between business and functional requirement document.
• Created firm wide questionnaire and model based on pilot GWM model.
• Assisted in the process of Periodic Review Appendix and procedures for KYC Standards.

Confidential

Responsibilities:

• Participated in sessions for finalizing business requirements for Confidential Forms.
• Worked with data dictionary team for the KYC Forms fields and their definitions.
• Created Confidential template to understand the reliance within LOBs and legal entities.
• Worked on gap analysis for Confidential ; co-ordinated cross LOB sessions to resolve the gaps.
• Created Ready Access use cases for different actors ( Confidential Investigations, Customer KYC Owner, and KYC On-boarding) and their roles.
• Led the Firm’s internal process of audit - KEYS for all the projects within the team.
• Trained the team on preparing Keys materials for their projects.
• Attended the meetings with oversight and control team/ audit team for review of Keys materials.
• Attended CDD (Customer Due Diligence) meetings; tracked all the action items and follow-ups.
• Created action plans using MS Project for Confidential compliance projects.

Confidential, NJ

Senior Business Analyst/Business Lead

Responsibilities:

• Participated in sessions for finalizing business requirements for Consolidated Financial Dataset (CFD) and Fully Absorbed Cost Calculations.
• Attended work sessions with data architecture team to finalize data mapping and reporting requirements for tax /legal department.
• Participated in sessions with developers and IT project managers to monitor the build stage and finalizing input templates and upload templates for forecasting/budgeting.
• Writing test scripts for each test case/scenario and the associated financial and reporting requirement.
• Responsible for creating risk/action/issues log and submitted the same to PMO.
• Participated in UAT and resolved all defects/issues. Used JIRA to track all defects.
• Facilitated the implementation of the system to the users through training manuals and demo sessions.

Confidential, Chase, NY

Financial Business Lead

Responsibilities:

• Participated in business requirements session with different workstreams and technology teams.
• Tested Business Objects data/reports to ensure the Global view for Treasury Line of Business matches the books and records balances; performed data analysis for breaks and worked with reference data and accounting/corporate team to resolve the same.
• Provided approval as Business Lead for the enhancements to Business Objects reports.
• Financial Business Lead/Data Analyst - Fixed Assets Reconciliation/Substantiation (4+ months)
• Led efforts to analyze the fixed assets data for Treasury and partner with transaction owner counterparts to review and understand the reconciliation and substantiation process and identifying gaps that may exist from a business process/ control perspective; identified the legal entity/foreign exchange breaks in the reconciliation process.
• Trained the business users and ensured that the appropriate validation/certification for fixed assets was done across teams.
• The project was to create a database using MS Access for creating month-end balance-sheet reports, variance reports and substantiation templates/ statistics. The database was to help maintain the integrity of the accounting balances and review controls for TS risk compliance.
• Participated in sessions for analyzing the legal entity and intercompany product related balances.
• Worked on creating balance sheets and income statement month-end flash reports by each product and legal entity from TS database.
• Performed reference data analysis and maintained database tables for TS (Treasury Services) database and interacted with controllers to align the products for balance sheet and P&L accounts.
• Created substantiation reports and data statistics for senior management at TSS global level.
• Delivered monthly variance analysis for balance sheet and income statement for TS products, month-end reconciliation in accordance with the corporate standards, and analysis of daily adjustments for Liquidity for regulatory and federal compliance.
• Performed quarterly data analysis for SFAS107 compliance related to Assets/Liabilities/Receivables for TS across different regions.
• Worked on analysis for Operating Loss schedule, Accounts Receivable schedule, and Reserves schedule.
• Analyzed Gaps and Differences between the current financial architecture and future state.
• Worked with SAP team to understand the requirements and Service Level Agreements to understand the posting and processing timing; Created new data sources and SLAs for daily/monthly posting of GTS files.
• Worked on Chart of accounts (COA) to map the original GLAS accounts to SAP accounts. Requested new SAP accounts via COA database within JPM Chase architecture.
• Resolved data mapping issues with Hyperion chart of accounts.
• Conducted the business / functional requirements and design walkthroughs with the workstreams/LOBs.
• Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
• Worked on Essbase to pull CMR (Corporate Management Reporting) reports and resolve the issues and misposting within CMR.Developed test strategy and step by step test execution for testing of each related application.
• Worked with infrastructure team to design Financial Data Warehouse (FDW) to ensure that appropriate MIS (Management Information System) data dimensions are applied to each GL account for accurate management reporting.