Sr. Consultant Resume
5.00/5 (Submit Your Rating)
SUMMARY:
- Seasoned Finance Change professional with 17 years of broad - ranging experience in Projects Implementation and Management, Business Requirements and Analysis, UAT Testing, Regulatory Reporting, Accounting, Auditing and Budgeting.
- Experience as PM, Lead/Sr.BA working with Financial Instruments, Trade life cycle, Reference Data and Product accounting (Equities, Fixed Income & FX Derivatives).
- Well versed in the SDLC process with particular emphasis on Business Requirements gathering (BRD), Functional specification documents (FSD), Change Control and UAT testing.
- Capability to focus on details whilst keeping the ‘bigger picture’ in mind. Proven leader having lead teams in a cross-functional & international environment, also strong individual contributor.
- Strong educational background of M.S. (Accountancy & Economics) coupled with professional certification of Chartered Accountancy (India), also passed Uniform CPA (USA) examination.
TECHNICAL SKILLS:
- MS Excel
- Visio
- Word
- PowerPoint
- SharePoint
- Business Objects
- Access
- Oracle SQL
- HP Quality Centre/ALM
- SAP R/3
- SAP byDesign
- IBM CMOD.
PROFESSIONAL EXPERIENCE:
Confidential, New York, NY
Sr. Consultant
Responsibilities:
- Finance change lead analyst for IHC/CCAR regulatory reporting supporting DB Stride FDW infrastructure focusing on FR-Y14M, 14Q and Y9C for Residential, Corp and CRE Loans (Loan IQ/DMI).
- Requirement analysis via user engagement sessions with Product Control (NY), Operations (NY, Manila, and Pune), Risk (Germany) and Data sourcing (NY, Ukraine and London) to determine IHC required ‘non-DBP’ attributes and MDRM mappings.
- Test planning, creating and executing test cases in HP ALM for CCAR/IHC reporting ‘non-dbp’ attributes - from source to transformation layer and from transformation layer to FDW. Explaining FDW edit check rule failures and RWA variances in risk-runs due to attribute changes (test vs. prod)
- Worked on GMI (listed derivatives) migration from R&N platform and IFRS9 attribute testing.
- Worked on attribute requirements and testing for AWM deposits systems - PBS/Global+
- Management reporting for weekly status meeting highlighting progress, key risks/issues and upcoming project milestones.
- Updating KOPs for product control adjustments to FDW and Axiom.
Confidential, Jersey City, NJ
Sr. Consultant
Responsibilities:- Lead Treasury/GL Business Analyst with a focus on requirements analysis, planning/testing multiple cycles of UAT & system migration for US Core Banking/Sub-ledger implementation.
- Independently managing the Change Control (CCR) process for requirement clarifications including ‘pillar review’ with HQA PMO, Technology, Systems Division & Head Office (Tokyo).
- Created 500+ test cases with BRD traceability matrix for FX & Money market products - FX Spots, Forwards, Swaps, NDFs, Single rate forwards, Window Options, Time deposits, Commercial paper, C/Ds, Foreign currency P&L conversion etc.
- Executing complex end to end UAT testing with upstream and downstream dependencies utilizing HP Quality Center - with focus on testing new functionality, revised GL mapping & multiple journal entry patterns. Responsible for defect reporting & triaging with technology.
- Design, testing and triage for Product control replacement GL reports for journal, balances, P&L etc. in CMOD & OBIEE and Liaising with data-warehouse for accurate transactional level vs Ledger reconciliation (O300).
- GL conversion planning, data cleansing & pre/post migration adjustments.
- Analyzing, researching & responding to Head Office Enquiries for FX/MM GL track.
- Providing project status to Management from Finance, Operations & Tokyo.
Confidential, New York, NY
Vice President / Solutions Manager
Responsibilities:
- Project Management & Reporting including monthly steering committee with Finance Seniors, proactively tracking open Issues, resource projections, project charter, creating & delivering various project & FX related presentations for ‘two-down’ sessions with FPG Managing Director.
- Requirements elicitation, gathering & BRD creation for FX Business Product Control & Corporate FX Treasury hedging.
- Hosted & led Inter-system requirements discussion with FX Desk, Treasury, Product Control, Operations, Credit Risk groups on Accounting, Trade Events (including compression) & Reporting, Reconciliation, Regulatory topics. Reviewed FRD for Finance & Ops systems.
- Creation of system context diagrams in MS Visio to facilitate understanding of current vs future state system flow for Finance seniors.
- Data Analysis including Trade compression POC with volume projections, Multiple warehouse P&L, FX hedging & back to back trades, Reference Data (Warehouse, Customer MSA/CSA), Product definition(spot vs. forward) & Deal/Cover/Spread calculations.
- Planned & hosted a 2 week Finance workshops with participation from Product Control and Finance technology to discuss key functionality & design choices.
- Exposure to regulation like SDR (Dodd-Frank), EMIR & reporting including FC1/FC2, FR2436, NCCE.
- UAT Planning & Test cases - created detailed cross system UAT plan/timeline, hosted UAT kickoff meetings with key stakeholders & oversaw creation of 800+ Finance UAT test cases.
- Created system conversion/go-live checklist after gathering inputs from product control, operations & technology stakeholders.
- Independently train, manage & assign tasks to a team of 3 team members.
- Managed eDealer migration phase for APAC & CEEMEA securities ageing (90+ branches) - from requirements to UAT & go-live. Performed project scoping for LATAM product processors.
- Led the requirement gathering process by conducting workshops with business users (SME’s) and stakeholders, understanding business process descriptions, task and workflow analysis.
- Sessions with various groups like Finance, Operations, Risk Management, IT and Global Market Analytics (GMA) to discuss and finalize and document the business requirements for aging the firm’s securities inventory.
- Conducted explanatory sessions on ageing methodology for Volcker Rule ageing initiative.
- Generated reports for risk management team using Business Intelligence tools like Business Objects and SQL. Provided aged inventory data in the form and format required by the senior management.
- Involved in initial BRD phases for initial margin interest allocation engine including hosting discussions on proposed interest allocation methodology.
- Created proof of concept in excel for consideration with Corporate Treasury project sponsors.
Confidential, Horsham, PA
Accounting Manager
Responsibilities:- SAP byDesign implementation including writing/executing upgrade plan, test cases & validating results. Ensuring accurate data migration & creation of custom reports.
- Creation & compilation of FP&A reports/monthly reporting packages like P&L variance analysis, budget v/s actual, bookings summary, pipeline analysis, revenue & expense forecasts, backlog, top 10 customers, capex spend for the CFO & CEO and other ad-hoc analysis as directed by them.
- Participated in annual budgeting exercise re-casting financials into functional & geographical format.
Confidential, Warren, NJ
Sr. Business Analyst
Responsibilities:- Functional requirement analysis (FRD) - Best in class P&L processor for securities (GTPL - 2mm Equity & FI trades/day) with emphasis on Trade Events, Reference Data & Ledger Posting. Worked on the conversion and migration of data from the legacy systems to the newly P&L processor.
- Downstream Feeds Management - Lead point of contact for 65+ downstream consumers including various Risk (Credit Engine), Contracts (GENESIS) and BASEL (OPTIMA) systems. Updated feed layouts and documentation as per Citibank SDLC standards. Participated in feed testing and UAT validations.
- Project Management & documentation - Maintaining and tracking weekly project status for management review. Developed ‘heat map’ dashboard for upstream & downstream SLAs. FRD presentations & release notes to end-users.
- Data Analysis - Conducted data analysis for large datasets and prepared front to back, ops vs. finance and Prod vs. UAT recon reports using Excel, MS Access and SQL.
- Change Control - Authored 100+ change request (CRs) for Trade Events, Referential Data, Posting, Reporting and Accruals.
Confidential, Edison, NJ
Manager
Responsibilities:- SAP R/3 implementation - Requirements Analysis. Identifying Key differences in US GAAP and Indian GAAP. Mapping of existing legacy GL codes and cost centers into proposed SAP GL codes & cost centers. Planning & executing UAT testing and conversion/parallel processing.
- Expense-Point expense management implementation - Requirements analysis and evaluation off the shelf systems. Authored detailed BRD for customization requests. 2-way mapping & integration - into SAP system for GL booking and into Preview payroll system for payout through payroll. Identifying Approval hierarchy and workflow. Setting up expense categories, approval groups, expense limits, and other approval parameters. Primary responsibility for UAT Testing and User Training.
- FP&A - Lead member of Finance & Accounting team for $230mm+ US Operations of L&T Infotech as per US GAAP in SAP. Had overall functional responsibility of General Ledger. Managed 5 team members across geographies.
- Audit & Management Assurance - Liaison with Statutory & Internal Auditors (Ernst &Young).