OBJECTIVE:

BUSINESS TECHNOLOGY TEAM MANAGER

SUMMARY:

• Highly motivated and dedicated professional with over 12 years of experience, excellent interpersonal, verbal and written communication skills; Hands - on experience in Corporate Project and Financial Planning and Analysis, Budgeting and Forecasting at enterprise and business unit levels; Collaborative and participative management style fostering the environment of trust and cooperation; Ability to communicate with various levels of management, build constructive working relationships and drive the agenda under pressure; Excellent presentation skills; High proficiency in Excel and sound judgment in applying critical assumptions to complex Financial models.
• Excellent time management, organizational and problem-solving skills.
• Ability to meet tight deadlines in fast paced environment with ever-changing priorities.
• Results rather than task-oriented with strong ethic and leadership characteristics.
• Reliable, confident and insightful team leader consistently delivering exceptional results.

CORE COMPETENCIES:

• Financial Planning and Analysis
• Budgeting, Forecasting and Reporting
• Revenue, Expense and Cash Flow Projections
• Financial and Operational Performance Measurement (Cost/Benefit Analysis, ROI analysis, KPI and metrics development, Business Reviews)
• Financial Statement and Ratio Analysis (Solvency, Liquidity, Profitability, Valuation, Payout and Activity Ratios)
• Corporate Finance and Capital Budgeting
• Investment Analysis, Project Finance and Valuation (FCF, NPV, IRR, Sensitivity Analysis), Cost/Benefit Analysis
• Strategic Management and Statistical Analysis
• Portfolio Management, Performance Evaluation and Benchmarking
• Risk Management (Risk Identification, Analysis and Mitigation Planning)
• Project and Operations Management and Effective Team Leadership
• Agile Methods in Software Development
• Project Charter and Project Management Plan Development
• Business Requirements, Scope and Change Management
• Stakeholder and Communications Management, Facilitation Techniques, Negotiation and Influencing
• Time and Cost Management, Schedule Development, Critical Path, Trend and Variance Analysis
• Quality Management and Continuous Process Improvement
• Human Resource Management and Team Building, Effective Decision Making, Motivational Techniques, Interpersonal and Conflict Resolution Skills
• Virtual and Remote Team Management
• Diversity, Cultural Sensitivity and Emotional Intelligence

TECHNICAL SKILLS:

• Professional user of MS Office: Excel (lookup, reference, aggregating and conditional functions, Pivot tables, Charts, etc.), MS Project, Access, Word, Visio and Outlook
• Advanced VBA/Macro Programming (Visual Basic for Applications) in MS Office Suite applications
• Design and architecture of large-scale real-time applications; business continuity and migration planning
• Building and optimization of complex queries to large SQL Server, Oracle and DB2 databases
• Solid foundation in Web technology, ERP systems, OLAP/BI tools (Actuate and Essbase) and Data Warehouse design
• Professional quality presentations with Power Point

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Business Analyst/Project Manager

Responsibilities:

• Collaborated closely with business and technology partners on the analysis of payment system data, SWIFT messages and accounting events to determine data dependencies critical to forecasting the end of day balances at Bank of America’s Reserve accounts across the world
• Lead the daily stand-ups, regular line of business (LOB) partner meetings, Sprint/Iteration planning, Retrospectives and Story Grooming sessions with developers according to Agile/Scrum framework; provided the Backlog status updates for the high priority items during LOB reviews and planning sessions
• Prepared in-depth meeting notes highly praised by LOB partners, followed up on the issues discussed
• Worked closely with a development manager on the project planning, creating project schedules and resource histograms, investigated business cases for expanding system scope to support intraday liquidity monitoring needs of funding managers
• Created the “as is” and “to be” business process and data flow charts, maintained domain and interface definitions, mappings and artifacts on Confluence (corporate collaboration website)
• Prepared the high quality features and user stories according to Agile principles in Version One having adopted elements of Scaled Agile Framework (SAFE™) and Behavior Driven Development (BDD) to structuring user stories and features
• Performed data sampling and carried out rigorous data analysis and reconciliations to support development of complex system business rules, verify data, performance testing and feasibility studies for expanding an account monitoring using DB2 SQL queries, advanced Excel formulas and VBA macros
• Conducted follow up investigations successfully detecting the sources of discrepancies, errors and performance issues in the system, documented defects and suggested solutions and workarounds, stayed on top of the issues allowing for timely resolutions
• Created the release presentations and conducted walkthrough sessions to validate the scope and solidify the acceptance of deliverables by LOBs
• Provided an ongoing guidance and support for QA and developers serving as a subject matter expert
• Enhanced the Global Cash Position Management platform, the multi-threaded real-time liquidity management application
• Expanded the platform’s Currency Position management capabilities from 3 to 17 currencies in Asia, Pacific, Europe and Americas business regions
• Reconciled the Central Bank account statements to the payment system data which allowed finalizing the system rules for the two major currencies
• Improved Currency Position and Account monitoring by implementing new rules to increase visibility for pending cash flows and repaired payments; improved look and feel of the application
• Revised the SWIFT interface allowing for 6 additional currencies and new message types
• Prepared the requirements for sourcing additional attributes from upstream interfaces and converting GBS DAS transactions feed to real-time
• Enhanced the system security allowing for user access segregation by currencies, roles and dynamic reporting groups, integrating the system with enterprise entitlement request interface to meet mandatory auto-revocation requirements
• Successfully managed mandatory remediation/decommissioning projects: retirement of legacy cash management applications (Cash Letter Extract, Same Day Settlement, and Reciprocal Netting).
• Ahead of the very aggressive critical delivery timeline collected requirements and developed full suite of Global Liquidity Management reports using Actuate BI/reporting tools, including a highly complex Summary Intraday Liquidity Management report presenting the summary of bank’s intraday liquidity sources and usage during the month and across currencies according to the guidance from Basel Committee on Banking Supervision and provided guidance in reconciling reports data which finalized acceptance by LOBs, having been recognized with a Silver award
• Managed the migration of more than 50 Actuate reports from AIX to Linux, promptly learned the development environment rebuilding more than 10 reports, allowing the team to meet mandatory deadline

Confidential

Sr. Business Analyst

Responsibilities:

• Worked closely with the Treasury and Data Architects teams to analyze current business processes, data transformations and liquidity regulations mandated by the Federal Reserve and Confidential
• Performed independent data analysis using Toad for Oracle; analyzed existing SQL queries, Excel files manual procedures and system specifications to enable the migration of the data and processes into the Enterprise Data Warehouse (EDW)
• Prepared the high quality business requirements document for the deposit data enhancement project aimed at providing key inputs into automating the key liquidity metrics (Liquidity Coverage Ratio - LCR, Net Stable Funding Ratio - NSFR) and the Internal Liquidity Stress Test mandated under the Dodd-Frank regulation for the two legal entities (Bank of the West and First Hawaiian Bank) within the data warehouse
• Automated the data extraction process in the Collateral database built in MS Access which expedited the data delivery to the data warehouse and allowed to meet the critical deadline

Confidential

Sr. Business Analyst, Contractor

Responsibilities:

• Worked on resolving complex analytical challenges for the new Global Cash Position Management platform, guiding the team of developers and QA engineers on gradually phasing out the software solution taking into account the technology limitations and strict timeframes
• Created the numerous business requirements and system specifications according to Agile methodology: user stories, domain definitions, acceptance criteria, dynamic user interface prototypes, bug and improvement tickets; participated in the Sprint/iteration planning, Sprint retrospective and story grooming sessions with the developers
• Developed the prototype model for the international position management feature, comprised of the interrelated spreadsheets which served as benchmark for developing system rules and the application screens
• Collaborated closely with the business and technology partners on the analysis and mapping of payment system data, SWIFT messages and accounting events to determine the data dependencies critical to forecasting the end of day balances at Bank of America’s Reserve Accounts across the world
• Performed the data analysis: created complex SQL queries to DB2 databases; reconciled the Central Bank account statements to the payment system data providing detailed narrative; parsed XML messages and flat files with VBA/macros; created the charts to visualize system throughput indicators
• Interfaced with QA Team to facilitate development of the test script; performed system functionality tests

Confidential

Business Analyst

Responsibilities:

• Automated Basel II regulatory reporting, validation and variance analysis processes with Excel, Access, VBA, Oracle and Essbase
• Reengineered Quarterly Risk-Based Capital Reporting Form (FFIEC101) adding flexible variance analysis tool for monitoring changes in the components of Regulatory Capital
• Successfully carried out extensive data validation of the Oracle reporting tool against the Essbase cubes uncovering a number issues in the early stages of the software release
• Was able to promptly resolve numerous technical challenges for the team, including resolving the issue with the semiannual Capital Review report generating database built in MS Access, which allowed to meet the reporting deadline

Confidential

Business Analyst

Responsibilities:

• Gathered business requirements for the replacement of the main trading platform
• Documented current processes, data flows and use cases for Trading Operations, Reporting and Billing teams
• Prepared scoring questions and templates as part of RFP (Request For Proposal) package for the information system vendors

Confidential

Business Analyst

Responsibilities:

• Obtained business requirements and developed tactical asset allocation applications in Excel VBA and MS SQL Server
• Reengineered a number of daily and monthly processes and workflows of the Fixed Income Portfolio Management team: daily cash flow allocation process, tender offer form automation, archiving trades and risk data, portfolio to index mapping, sending trades to CRD (Charles River Trading System), etc.,
• Developed sophisticated portfolio optimization and hedging tools that resulted in tremendous time savings and improved asset allocation

Confidential

Project Manager

Responsibilities:

• One of the key contributors to the retirement of the old Portfolio Accounting platform
• Driving the project of migrating TBA (“To be announced”) trades (forward contracts on Mortgage-Backed Securities) onto the new Portfolio Accounting platform (APX - Advent Portfolio Exchange).
• Designed Test Cases/Scenarios for the proposed transactions to reflect TBA trades in APX and tested the results: adjusted various settings in the test environment, imported and posted the transactions, created the necessary custom security type, reconciled Realized Gains/Losses and Accrued Interest to the results in PAM, etc.
• Developed a number of detailed and high level flow charts to illustrate current process flow for the TBA transactions between Trading, Settlements and Portfolio Accounting applications
• Created mapping files and other supporting documentation to facilitate development, testing and implementation of the new process flow
• Reengineered the Market Value Exceptions and Cash and Securities Flows Audit processes: carried out extensive research and detected significant process flaws, proposed an improved process, developed prototype application, defined target system and created hand-off documents for technology team including business and technical requirements

Confidential

Business Analyst

Responsibilities:

• Designed and implemented more than three dozen highly visible custom automation tools with MS Office VBA, VBScript, Batch Scripting, SQL and GBS Scripting, which resulted in significant borrowing cost reductions, improved liquidity and risk management, significant time savings, tighter controls and better customer service, having touched every aspect of FX Back Office Operations: Forwards, Futures and Options Processing, Accounting and Project Management
• Made complete overhaul of the spot position/cash reconciliation process
• Streamlined and brought into compliance number of FED and OCC regulatory reports
• Improved Nostro account funding accuracy saving thousands of dollars on overdraft fees, interest and opportunity costs
• Delivered numerous ad-hoc reports requests with Excel and Access
• Provided exceptional services including user mentoring, consulting and training in advanced Excel capabilities (Formulas, Pivot Tables, Filters, Charts, etc.)

Confidential

Web Developer

Responsibilities:

• Implemented more than dozen high quality and complexity web design installs by using technical specifications, graphical and text content provided by web designer with PHP, JavaScript, HTML and CSS
• Web technology concepts and skills I learned while preparing to and performing this job allow me to more easily navigate through modern IT Infrastructure
• Exposure to high quality designs and fonts improved my visual presentation skills

Confidential

Analyst

Responsibilities:

• Carried out Investment analysis of Mineral resource companies and mining projects (DCF, NPV, IRR, sensitivity analysis, etc.) providing managers with investment advice in the form of presentations and executive summaries
• Prepared Financial and Operating reports to support M&A Due diligence projects
• Used Bloomberg to obtain various financial information about M&A targets and support valuation process
• Performed search for investment opportunities in Energy technologies
• Conducted economic research in Energy and Non-Energy Mineral resources markets
• Managed Mineral Reserves audit projects; served as a liaison between mining plant operating managers and the mineral resource audit company

Confidential

Investment Analyst

Responsibilities:

• Carried out Financial planning and Investment analysis for a series of construction projects
• Prepared Investment Memorandum to be presented to the Corporate Investment Committee
• Monitored cash spending across investment initiatives presenting updated cash balances to project managers
• Performed suburban Real Estate Market research with assistance of Real Estate Consultants
• Formulated research requirements for the consultants and insured delivery of the research results
• Saved more than 100K in USD equivalent by successfully negotiating research commission

Confidential

Analyst

Responsibilities:

• Carried out long-term financial planning for diversified Financial Corporation and its individual businesses including Corporate Banking, Retail Banking, Investment Banking, Asset Management, Insurance and Leasing
• Performed regular updates to financial models after arrival of new financial information from internal and external sources; the models served as the core element of the corporate strategy development process
• Developed strategic scenario management tool with MS Excel and VBA
• Participated in financial markets research collecting information from various sources, including Bankscope and Zephyr (proprietary financial databases), general financial information and competitors Web sites, etc., to perform Strategic benchmarking of the corporation and update key assumptions in the Financial models

Confidential

Analyst

Responsibilities:

• Automated financial monitoring to satisfy Anti-Money Laundering (AML) regulatory requirements
• Developed insurance premiums control application with MS Access
• Modified and appended several management reports to the task tracker database (based on the Lotus Notes/Domino platform and Excel)
• Monitored traders’ activity in order to detect and prevent Conflict of Interests
• Revealed several important violations involving Repo transactions

Confidential

Management Information System (MIS) Analyst

Responsibilities:

• Provided Analytical support for decision making process within Consumer Banking business
• Built complex and resource intensive T-SQL (Transact-SQL) queries to large SQL Server databases providing exceptional analytical reports to managers of the Confidential
• Used MS Excel and VBA (Macro) to streamline Management Reporting
• Participated in Data Warehouse development project supplying data specifications to the project managers; learned a whole lot about OLAP technology and compromises to be considered carefully while solving analytical needs of the business users
• Successfully carried out emergency business analysis and documentation of credit verification unit business processes
• Increased knowledge of retail Financial Debit and Credit products

Confidential

Intern

Responsibilities:

• Automated numerous Internal Control procedures and reports related to User Access Control, Software Control, Financial Monitoring, Quality Control, etc., with VBA, Access, Excel, SQL Server and TCL
• Performed regular and ad-hoc Information Security Control Procedures
• Detected significant Information Security breach