Senior Technical Business Analyst Resume
IrvinE
SUMMARY:
- Detail oriented, dedicated, pragmatic, concise Analyst with national and international work - experience, strong, diverse background in IT Project-definition and - governance, systems maintenance, -design and -analysis, Financial- and Cost-Accounting, Planning and Reporting.
- Upholds highest level of professional and personal ethics; well-versed in regulatory requirements: strong in analyzing and defining requirements to build and deploy innovative software solutions.
- Proficient in using multiple Business Intelligence and Information Technology-tools and -applications so to reach top-priority business and corporate goals.
EXPERTISE:
- Thinking Outside the Box
- Focus on Business Needs
- Dead - line oriented
- Deliver on-Time
- Process Flow efficient
- Higher Standards
- People and Communication skilled
- Collaborate
- Business Analysis
- Never Compromise Quality
- Data Science/Business Intelligence
- Making Sense of Big Data
- Systems Analysis
- Unleash Processing Power
- Financial Analysis
- Time for Clarity
- Finance and Accounting
- Pursuit of Perfection
- Audit and Compliance
- Passion for Effectiveness and Success
- Private/Wealth/Investment B king Support
- Demonstrate Control
- Credit and Lending Support
- Serve Wisely
TECHNICAL SKILLS:
Systems: Proficient: MS-Office (all applications), MS-Access, MS-SharePoint, HP-Quality Center, WebAmmo, TSoft Documentation, InfoPort Imaging Peregrine, MS-SQL Server querying, Adobe Editor, SAP Business Objects, SAS Business Intelligence/Analytics, Monarch, QuickBooks-Enterprise Solutions, NextGen, GreatPlains, NetSuite, iGL, Hyperion, Microsoft-FRx, T24, Olympic, ACBS System-as-a-Service-platform, Avaloq, IBM-400 platform, Straight-Through Processing (STP), RACER, OLC, MSP, AFS and SIL, TOAD for Oracle querying
Languages: Fluent: English, French, German Beginner: Spanish
CAREER SYNOPSIS:
Confidential, Irvine
Senior Technical Business Analyst
Responsibilities:
- Evaluate/document current manual credit scoring process and write specifications and logic rules in business requirement document for developing team to enhance the Scoring Decision Engine
- Use TOAD for Oracle to generate research and volume data from the Data-Warehouses through multiple table joins and aggregation functions
- Chart and document ‘Special Assets Department’ and ‘Servicing Department’ data and process models of ‘as-is’ and ‘future’ status and draft comprehensive business requirements serving sub-ledger data-migration
- Design vision document and propose rules through writing business requirements guiding developers to build a new ‘Online Banking’-application
- Drafting business requirement document to adapt loan origination system to comply with the federal Fair Lending ‘Equal Credit Opportunity Reg. B’ Act
- Write rules to automate end-to-end Customer Credit Application process
- Defined source logic for federal Small Business Authority (1502) report and METRO 2 Credit Bureau report
- Working with subject matter experts/users to understand, identified and solve sub-ledger-to-delinquency repository system data variances/issues and refine interface routines
- Assisted in resource requirement, cost estimation, cost benefit analysis, and return on investment report compilation and presentation
- Facilitate rapid application development (RAD) sessions through web-ex and telecommunication with stakeholders and users in remote locations
- Coordinated and controlled across division the User Acceptance and Regression Testing effort prior to Loan Origination Systems (LOS) core- and admin-release deployments
Confidential, San Diego
Contractual Analyst
Responsibilities:
- Provided Financial Control subject matter expertise and acted as mediator bridging the technical- and business-end of Stakeholders
- Assessed growing/expanding Prescription Drug Plan (PDP)Business Model and advised on seamless integration with applied and new technology
- Analyzed existing finance and operational workflows and advised on potential enhancements
- Assisted in planning and designing a new core application
- Used MS-SQL to generate validation data from Data-Warehouses-in-development
- Diagrammed 'As Is' process definitions for 'To-Be' process definitions to serve Business Case discussions
- Wrote Functional and Technical Requirements and -Specifications to interpret and define business rules so to: process CMS (Center for MediCare and MedicAid Services) Part D Direct Subsidies, LIPS, LEP, NMEC- and COB-fee, Plan to Plan and Coverage Gap transactions specified comprehensive Aging Reports by Insured Members and Line of Service, Accrual-, Exception- and Variance-Reports defining purpose, justification, attributes and columns, owners and runtime parameters facilitate the building of automatic Cash- and Underwriting-Statements and -Reports to meet business needs improving internal Explanation of Benefits reports development
- Facilitated joint application development (JAD) sessions in one physical location with local stakeholders and local users
- Assisted in specifying reports and performing Integration- and Acceptance-Testing for new ASO (Administrative Service Organization) models sold under the PDP Business Model
- Formulated Test Cases Scenario to facilitate User Acceptance and guarantee Stakeholder Approval
Confidential, San Diego
Contractual Analyst
Responsibilities:
- Provided high level consulting service to Confidential personnel to allow the development of the latest generation of commercial loan processing application
- Followed the flexible, holistic product development strategy of Scrum agile software development methodology working on scrum and product backlog items
- Analyzed and formulated specifications for commercial lending clients and their business needs
- Formulated requirements, managed and monitor commercial lending feature enhancements
- Advised staff on all managerial levels on complex/new banking and fiscal regulation issue to be solved through information technology and changed systems functionalities
- Collaborated with developers and subject matter experts to establish and formulate the technical vision
- Analyzed tradeoffs between usability needs and performance
- Formulated user requirements and technical specification
- Designing presentation templates for project and executive meetings
- Translated commercial lending and general banking knowledge and experience to write workflow and program specifications
- Guided general users, managers and executives through define concepts
- Facilitated interface development, parameterization, code-merging, and testing
- Performed diligent business requirement analysis and formulated development scripts to specify user interface design and data conversion methodology
- Evaluated and documented the quality assurance test results and monitored the performance of newly developed modules within the application as end-user
- Communicating with off-shore, international and national stake holders
Confidential, Miami Beach
Comptroller
Responsibilities:
- Planned, implemented and Quality Assurance tested accounting system implementation
- Spearheaded updating of the on-site billing package
- Designed and developed MS-Access database for cost accounting/MIS and data warehousing
- Directed financial accounting functions to ensure timely and accurate reporting of clinical financial information
- Developed and implemented policies and procedures according to IFRS and US GAAP to ensure HIPPA, Medicare and Medicaid compliance
- Enforced timely payment of current liabilities, proper control and recording of cash/check Co-pay receipts
- Designed MS-Access database to record and monitor fixed assets and automate depreciation calculation
- Automated monthly Call report securing the Line of Credit
- Drafted the monthly, quarterly and annual financial statements, cash flow report and analysis of variance in accounts, ratios, investment analysis, fee collections and charges
- Implemented QuickBooks Enterprise, replacing time-consuming manual record keeping
- Reviewed third party operational and medical equipment contracts about current market competitiveness and renegotiated conditions with suppliers
- Met on regular basis with auditors, lenders and third party agencies to guarantee proper systems control and accounting
- Drafted the annual capital and administrative budgets as well as financial and credit policies of the clinics for discussion and approval
- Directed the preparation of statistical information and reports for management, physicians, government and agencies
- Directed, forecasted and analyzed the impact of special projects, new services and the benefits of a possible affiliation.
- Reviewed current operational procedures (Diagnostics, HR, Billing and Collection) and recommended enhanced operating procedures.
- Supervised the selection and training of departmental personal
- Initiated performance evaluation and recommended merit increase, promotions and disciplinary actions
- Implemented biweekly meeting to discuss Finance, Accounting and HR issues in open forum
- Launched documented reference, training and testing platform for all staff to:
Confidential, Miami
Senior Analyst
Responsibilities:
- Daily intra-company Requisitory /Change Management tool maintenance and business process change documentation
- Provided strong link between the Finance team, the Letters of Credits, Bank Guarantees team, the Payment team and IT
- Liaison between the Miami BoA IT team, the Geneva, Switzerland software supplier and the Chenai, India Helpdesk management
- Defined business rules, proposed workflow alterations, core- system changes and applied parameter and table maintenance
- Analyzed FedWire error log to specify vital changes to the payment module
- Analyzed variances in the Balance Sheet, the Off Balance Sheet and Memorandum Balance Sheet to specify necessary changes to the system
- Analyzed differences in the MS SQL Server application and specified changes necessary to the system-tables to guarantee accuracy of the MIS
- Acted as mediator between the Technical (programmers) and Business end (users) breaking down the communication barriers between stakeholders and developers
- Bridging the Business Owners needs and the Developers skills guaranteeing that the needs of all system users was met
- Converting workflow changes into program change specifications
- Describing business processes
- Charting product booking and evaluation processes (Derivative products, Foreign Exchange products, Hedging products)
- Interpreting stakeholders needs and translate into programmable specifications
- Financial-, control-, evaluation-Reports change, alteration or modification specification formulation
- Systems upgrade and module implementation planning and test script designing
- Formulated pre-implementation test scripts and post-implementation Quality Assurance ‘snap-check’ controls
- Managed the IRS 1099-xxx and IRS 1042-S project to automate form production and reconciliation
Confidential, Miami Beach
Senior Accountant/Analyst
Responsibilities:
- Assistant to the COO taking minutes at Board Meetings and monitoring department Head’s allocated tasks progress
- Facilitated disaster response planning (DRP) sessions in Geneva, Zurich and Lugano
- Designed and developed comprehensive internal website with MS-FrontPage detailing operational/financial procedures and directives
- Directed the AVALOQ core-banking system implementation project budget and forecast
- Supervised the Project designing, planning, implementation matrix and briefed the Board of Directors about possible deviations or delays.
- Supported internal audit team in setting up guidelines for internal control ‘snap-checks’ and assisted external audit company during regular and extraordinary audits
- Launched mainframe systems EOD/M/Q/Y processing
- Formulating, documenting, numbering and sampling IFRS, UK and US GAAP accounting procedures
- Monthly interest receivables and payable accruals monitoring and client account/safe custody fee processing
- Guided the Corporate Events Dept in diarizing Security Events (Coupon Payments, Maturities)
- Stepped in as Managing Substitute for Finance Companies, Brass Plate Companies and Trust accounting and settler/beneficiaries reporting
- Proposed annual budget and directed monthly forecasting process
- Calculated and reported Key Performance Indicators (Product Return, Revenue Analysis of Client Investment Portfolios and Fund Management to Senior Management and the Board
- Spearheaded the team automating Swiss National Bank (weekly Liquidity, monthly FX- and Securities Positions and Bulk Risk) Bank of England reporting
- Facilitate implementation of automatic SWIFT messages processing
- Directed Reconciliation Team in implementing application for automating NOSTRO/VOSTRO account reconciliation
- Performed preliminary analysis and managed blueprint paper for FBAR+FATCA (Offshore Disclosure Reports) mainframe modules design
- Assisted in planning and implementing the KYC standalone application
- Designed and formulated internal compliance and accounting procedure for SOX (Sabanes-Oxley)