SUMMARY

• Full understanding of Project Management processes (Initiating, Planning, Execution, Monitoring & Controlling, Close out) and Knowledge areas (Integration, Scope, Time, Cost, Staffing, Quality, Risk, Communication, and Procurement management) in software development domain.
• Highly successful in software engineering/technology driven environments.
• Responsible for capacity planning, resource loading, costing, estimating, and budgeting
• Designed official escalation channels and risk mitigation strategies based to identify and resolve bottlenecks.
• Extensive project management expertise in a collaborative environment across global teams of professionals in Agile (Scrum) environment.
• Provide Business Analysis, SQL Programming for data collection and data extraction
• Proven expertise with functional testing of banking applications like Vision Plus, ACH, CardPac and Mainframe testing. Have strong experience in using testing tools like Mercury Quality Center, Mercury Test Director, QTP and MS Office Suite.
• Deep understanding and experience of Investment Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments.
• Domain Analysis, Data Analysis, Business Rules, Gap Analysis, Prototyping, developing/creating business process related documents with stronger affinity to financial services, investment banking, fixed income, equities, commodities, trade cycle, ETF, securities trade processing/clearing, asset management and mortgage. Diversified profile with client base ranging from investment banking to insurance to energy sector to digital imaging to retail banking to government services
• Analyzing all compiled information and documentation to determine client AML risk levels
• Analyzed accounting problems, recommend corrective action, and reconcile accounts.
• Development and implementation of several parallel projects and systems to improve the overall process, resulting in increased productivity & achieved project management excellence.
• Effectively applied SDLC methodology and enforced project delivery standards.
• Excellent Communication and Leadership Skills with display of Time Management abilities.
• Strong persuasive skills, facilitation skills, problem solving skills, business skills, verbal and written communication skills and interpersonal skills.
• Comprehensive knowledge of Agile (Scrum) & RUPs Iterative based Software Development Life Cycle processes.
• Strong analytic skills to conduct Risk Analysis and propose viable alternative solutions.

PROFESSIONAL EXPERIENCE

Confidential, Menlo Park, CA

Senior Business Analyst

Responsibilities:

• Extensively and closely worked with the business owners, conducted formal interviews, live meetings and JAD sessions to identify requirements and functional specifications.
• Used JIRA and Confluence to create User Stories and Visio to create UML diagrams including use case, activity and sequence diagrams to extract business process flows.
• Conducted the JAD sessions to understand the requirements and data behavior when data redemption occurs.
• Provided overall project management to multiple projects successfully completing them on - schedule and on-budget.
• Conducted and controlled brainstorming sessions with project focus groups.
• Analyzed IAM system data extracts to align work efforts with mergers, acquisitions, and divestiture of new or existing businesses.
• Created use cases on the basis of the high-level requirements document and user stories via MS word.
• Conducted JAD Sessions with SMEs, end users to resolve what data should be shown in the initial phase.
• Followed the UML based methods using MS Visio to create Use Case, Activity, Sequence, and Collaboration Diagrams.
• Created Use Case diagrams, activity diagrams, sequence diagrams in MS Visio
• Tracked testing and capture screenshots for testing purpose using Jira.
• Participated in Business Requirement and Technical Design Sessions for converting Commercial Loan's legacy systems to AFS
• Excellent understanding of Data services, Data ETL using SQL query tools and applications.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI. Periodic reporting is done on a daily, weekly, monthly and quarterly basis which helps the client.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Responsible for analyzing the impact related to SWIFT message changes on BNYM applications which included both MT and MX message types.
• Strong knowledge of Agile PLM, scrum processes and experience in redesign of product development process as per the business requirement.
• Analyzing existing Vision PLUS functionalities in 2.x version. Incorporating new changes in 2.x as per 8.x Vision Plus version standards.
• Responsible for handling inter-bank communication related to exports through SWIFT messages.
• Develop KPIs and provide ITSM performance metrics reports using ServiceNow Performance Analytics Module.
• Tested integration of Empower LOS with GSE Applications - AUS ( DU, LP), UCDP, CU, ULDD, MERS
• Used AWS command line client and management console to interact with AWS resources and APIs.
• Specialty worked in the following technologies: Visual Basic, C#, ASP.NET, Access, VB.NET and Oracle.
• Responsible for identifying and analyzing various Wires and ACH payment initiation channels that send payment transactions to the Payment processing systems such as ACI Money Transfer System and PEP+. The analysis included all Outbound and Inbound payment flows for Domestic and International payments
• Extensive experience in collateral management, valuations, fixed income, hedge funds, and risk analysis.
• Demonstrated experience with Finance/Accounting systems and processes
• Collaborate with business users of Digital Marketing teams, Vendors, and IT teams to introduce process to implement AEM/CQ5 for the IT/Digital Marketing teams
• Develop stored procedures for data validation on Oracle SQL developer
• Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
• Financial Statement and Ratio Analysis (Solvency, Liquidity, Profitability, Valuation, Payout and Activity Ratios)
• Extensive experience in Tableau Enterprise Environment and Administration.
• Good comfort level with Capital Markets, Money markets, Trading Systems, Derivatives Strong in Options, Equities, Fixed Income, US government Treasury Securities T-Bills, T-Bonds and T-Notes, Municipal Bonds, Stocks Trading Cycle, Margin Requirement, Mark to Market, Hedge Funds.
• Working with Global Scape AWE team for ensuring successful FTP setup for Vendor file transfer. Gathered requirements like FTP server details, authentication and encryption method, IP addresses, Port number, FTP directory structures
• Originated various reports and report formats for from the General Ledger GL, cash flow and P/L statements
• Helping customer on sub ledger and General Ledger balances reconciliation.
• Multiple Organizational Change Management (OCM) certifications and extensive OCM experience
• Private Wealth Management Division, engaged in migration assessment of Trust and Custodial accounts from in-house to Broadridge Trust Platform
• Prepared year-end financial statements P L, Cash Flow, Balance Sheet and budgets for the company.
• Subject Matter Expertise in Securities Lending, Custody, Reference Data Integration, Basel II accord, Cash Management processes and Repurchase Agreements (classic Repo and Sell/Buy Backs).
• Experienced in Tableau Server administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data refresh instances.
• Validated the test data in DB2 database on Mainframes using SQL queries.
• Write Technical System specifications for Operational, Legal and Compliance enhancements or changes in Empower
• Expertise in PLM (Product Life Cycle Management), MDM (Master Data Management)
• Due to Business Needs and timelines of project, Business approach to Agile (Scrum) Instead of Waterfall methodology.
• Worked with cross-functional teams for building use cases, demonstrating the business requirements, developing business models; designed and developed business flow diagrams, Object Oriented models using MS Visio.
• Involved in UAT process and coordinated with the UAT team to get the feedback to make change requirements document.

Confidential - Kansas City, MO

Business Analyst

Responsibilities:

• Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Perform Customer Due Diligence, KYC, Risk Rating, investment screening and selection, for the private client group, as per bank's Compliance and AML guidelines
• Understood Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Deep understanding the Business Flow of Investment Banking, and extensively involved in Portfolio management and analyses, Mutual Funds, Securities trading.
• Involved in the process of Use Case creation for Payment Credit Card (PCI Compliance)
• Participated in understanding existing Sovereign's ACH processing system, daily PEP payment processing and analysis of PEP reports, payment distribution, daily reconciliation and balancing.
• The FX products involved were Spot, Forwards, Swaps, NDF, Options and also for Middle Office, Back Office, Cash Management, Nostro reconciliation, P L, Accounting
• Conducted UAT to confirm that all derivative products can successfully process during the trade life cycle.
• Created new process of generating counterparty risk net notional exposure, mark-to-market exposure, coverage, and relevant trade margins via two SQL Server stored procedures that led to a significant decrease in report generation time and maximized accuracy by appropriately utilizing live trade data, thereby enabling the capital markets trading desk to adjust next-day trading strategy to minimize any further exposure.
• Work with vendor technical support to identify ongoing issues and defects that need to be resolved for the Commercial Lending System. Utilized Commercial Lending banking application and was responsible for the design and process flow of the system.
• Managed the production of cash flow, P L and balance sheet reports
• Analyzed the existing reports of the reporting system in the database. Checked the consistency of the data after ETL process using SQL queries.
• Domain expertise in Financial Risk Reporting, Liquidity Risk, BASEL, CCAR, Credit Risk, Market Risk
• Worked on Transaction Details project which involved making transactions received as part of MT 940 and MT 942 SWIFT statements, in the form of reports
• Extensive knowledge in Payments processing and SWIFT messaging standards. Have good knowledge of CHIPS, FED and ACH.
• Experience and knowledge of accounting practices especially involving sub ledger and general ledger postings/transactions
• Developed policies and procedures to align with new /updated processes and comply with current laws and regulation SOX, PCI-DSS
• Designed and modified User Interfaces using JSP, JavaScript, CSS and jQuery
• Coded and debugged stored procedures and functions for use on Crystal Reports and VB.NET/VB.
• Participated in gathering requirements for the integration of various credit cards functionalities like account boarding, payment processing, collections and write-off.
• Coordinated Joint Analysis Design sessions to directly extract and negotiate requirements for CD/IRA; Investment and Savings Projection; ATM Image/Deposit changes
• Discussed with SMEs across different businesses units to gain solid knowledge of the existing Credit Risk Calculation System and assisted in preparing an advanced Risk Assessment and ROI Management.
• Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Write and execute positive and negative test cases to ensure the data originating from the data warehouse Oracle dB is accurate through to the SQL dB in the applications.
• Established Best Practices for Enterprise Tableau Environment and development processes.
• Worked on Billing Document Type, Credit Memo, Debit Memo and Pro forma Invoices, Inquiry, Quotation, Sales Order, Rush Order, Cash Order, Scheduling Agreements and Contracts.
• Provided Agile PLM Application Support - configuration, customization and on-demand reports
• Worked with Oracle Support in analyzing and identifying root cause for Agile PLM issues
• Worked with AWS Cloud platform and its features
• Returned securities off the excess collateral report each morning and reported cost of financing to management
• Experience and knowledge of accounting practices especially involving sub ledger and general ledger postings/transactions
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.