We provide IT Staff Augmentation Services!

Business Analyst Resume

3.00/5 (Submit Your Rating)

Trenton, NJ

SUMMARY

  • Providing quality control & continuity of care between Business Requirements and IT infrastructure for all project and site deployment. Offering 10+ years of hands - on technical leadership overseeing business operations & IT strategy, implementation, training & support.
  • Proactive IT and Business Management professional with a self-motivated team player driven work ethic, with integrity and passion to respond and work independently with minimal supervision to manage meticulous details at all levels and expertise in a timely and innovative fashion under pressure.
  • Proven track record of policy creation, business process development and bridging the gap between IT Infrastructure, Operations and Business Stakeholders.

Core Competencies

  • Business Analysis
  • Data Analysis
  • Project Management
  • Change Management
  • Systems Analysis
  • Finance and Audit
  • Quality Assurance

TECHNICAL SKILLS

Operating Systems: Windows 95/98/NT/2K/2K3/8/10, UNIX, Terminal server

Applications: Axiom, Cognos 10, 8 BI Reporting, Cognos EP (7.3, 8.1), Crystal Reporting 11.0, Framework Manager (8.1, 8.3), Great Plains Accounting, Hyperion, Impromptu, IRIS(1.5, 2.0), Sungard Step intelliMATCH(7.3, 8.1), MAS500, Midas Plus Accounting, OpenPages, PeopleSoft, Microsoft Office (Excel, PowerPoint, Word), SharePoint, Visio, Broadridge, Bloomberg, Swift, BoNY Clearing

Databases: Oracle, DB2, SQL Server, MS Access

PROFESSIONAL EXPERIENCE

Confidential • Trenton, NJ

Business Analyst

Responsibilities:

  • Conducted JAD sessions with Business, Operations, Information Technology Support, Developers, Vendors, and Management to effectively communicate efforts at a task level using an Agile Methodology.
  • Created and managed the Functional and Technical Specification documents to assist the developers in design, review test cases for the QA team, identify key milestones for Project Managers, and analyze data points that will impact Security, Investigation, Audit, Legal and Compliance, and field agencies.

Confidential • Mount Laurel, NJ

Business Systems Analyst

Responsibilities:

  • Validated Book of Record inventory of fixed assets with physical inventory listing.
  • Led JAD sessions with owners/users to determine outcome of servers, operating systems & applications.
  • Determined server categories to include: Active, Dormant, Decommissioned
  • Identified current operating system versions, and application usage for future platform state of physical, virtual or cloud-based fixed assets.

Confidential • New York, NY

Business Analyst / Data Analyst

Responsibilities:

  • Conducted workshops, value stream mapping, and solution-based identification using FMU playbooks, Resolution Plan submissions, 2016 SRP Payment Clearing & Settlement follow-up work & submission.
  • Created and managed the process owner tracker of the contingency plan documentation for approval from shared departments (stakeholders in Treasury and Finance, Lines of Business within Operations, Information Technology, Compliance, Governance, Living Wills, Wealth Management, Change Management, Legal, Marketing, Upper-Management, and external Auditors).
  • Successfully acquired the first multi-department FMU process contingency plan sign-off for SEC review.
  • Worked with Global and offshore MIS team members to build a SR-14 regulatory approved FMU and Agent approved repository and reporting tool friendly database for referenced liquidity of Capital Markets, Commodities, Derivatives, Credit and Risk accounts that are impacted by domestic Dodd Frank and international EMIR guidelines.
  • From the first golden reference data center source, identified 545 unique fields from 35 SharePoint views and created load sheets for the newly created and validated reports from the Bucharest, Romanian development team.
  • Successfully completed the first Dodd Frank required reports for referenced source data.

Confidential • Portland, ME

Senior Business Analyst

Responsibilities:

  • Managed Gap and Risk Analysis on SharePoint for time-critical Federal reporting requirements (FRY-14, FRY-9C and FFIEC 30/40) for various line-of-business products (Credit Cards, Mortgages, Consumer and Commercial Loans, Auto Finance, Collections, General Ledger and Wealth Management).
  • Created new governed business processes, mapped detailed data center elements from source systems to target reporting schedules using ETL (Extract, Transpose, Load) methods.
  • Defined and documented business requirements for multiple Tier 3 projects.
  • Created business specification documents and liaised between development of Axiom (Reporting), Hadoop (Data Warehouse Staging), SQL (Querying and Data Manipulation for Downstream Applications) and the line-of-business teams within the defined workstreams.
  • Supported Program Manager of Change Management with strategic initiatives to advise management and automate core business requirements and processes, resulting in an enhanced visibility approach and minimal risk solution for the company’s future progress.

Confidential • New York, NY

Senior Technical Business Analyst

Responsibilities:

  • Served as a single point of contact for communication and coordination for tracking any movement of daily data center ETL source files used by multiple lines of business.
  • Identified, documented, tracked and resolved any technology issues, requests, questions, enhancements, or updates using SharePoint.
  • Tracked UAT tested issues and defects for immediate resolution using Mercury Application Lifecycle Manager.
  • Tracked Production enhancement requests and bug remediation using JIRA and SQL.
  • Monitored daily activity and position reconciliations for various Regulatory space to include Dodd Frank, European Market Infrastructure Regulation, and the Monetary Authority of Singapore markets for several asset classes to include Credit, Equity Derivatives, Equity Prime, Foreign Exchange, Commodity and Interest Rates.
  • Documented Business Requirements, Functional Specifications, and User Acceptance Test Scripts and Test Cases.

Confidential • Fort Washington, PA

Senior Technical Business Analyst

Responsibilities:

  • Served as a conduit between the Capital Market business community and the technology team.

Confidential • New York, NY•

Senior Technical Business Analyst

Responsibilities:

  • Created a technical Functional Requirement Document using quantitative calculations that answered how the enhanced and new market announcements of forward curves of oil, natural gas, and power will be presented to customers and channel partners through communications with various team members of: data center, production, information technology support, development, quality assurance, customer care, editorial, finance, marketing, compliance, order process and order fulfillment, and product management.
  • Created a centralized data center Market Data Category Code matrix that was sorted and grouped by symbol identification, utility hub, region, product, daily and monthly reporting values along with referenced natural gas supplied power hubs.
  • Communicated with various onshore and offshore teams to create external communications to include 90-day Channel Partner Notices for vendors, and Subscriber Notes for customers published on company's website.
  • Created a Business Functional Requirement Document for Confidential Market Center, to enhance a web-based dashboard application for customers to navigate for news, commentary, & price-point trending for various global Petro Chemical products.

Confidential • Saint Petersburg, FL

Senior Business Analyst

Responsibilities:

  • Reverse-engineered 26 existing reports using PV01 (Present Value of a One-Basis-Point) and VaR (Value at Risk) data tables mapped directly from vendor Algorythmics inbound data feeds.
  • Successfully completed both the Market Risk stakeholder-approved PV01 and VaR Table modification requirements for data warehouse shell creation.
  • Created a field-level data dictionary showing all attributes for the Cognos development team.
  • Validated all aspects of Algo Risk Service - Back Testing Report
  • Identified and verified the required data center import fields and calculations
  • Enabled practitioners to calculate, evaluate and fully understand the integrity of applied risk methodology for producing analytics such as VaR.

Confidential • Pennington, NJ

Senior Business Analyst

Responsibilities:

  • Translated business needs into technical requirements and supported all business systems specifications of IRIS 2.0 for the Implementation and Hierarchy Synchronization Project.
  • Created end-to-end Risk Management line-of-business design requirements for the technology solutions team (software/hardware developers and vendors).
  • Created a MetaData draft version Template to identify multiple application values for data mining sourced information at data store, schema, entity and element levels.

Confidential

Project Manager / Senior Business Analyst

Responsibilities:

  • Managed the complete front-end to back-end SDLC processing - From initial contract agreement to project task assignment, approach methodology to documentation control, and scheduled team meetings to project status meetings; various processes have been accounted for and completed for a near-future ‘go-live' production model.
  • Fully involved liaison between business stakeholders; business process owners; project management; developers; security administration; data warehouse engineers using AVETL (Analyze, Validate, Extract, Transform, Load) & ETL methods; quality assurance team; quality control support; auto-system group; and information technology infrastructure (system, data, architecture).
  • Coached several internal technical analyst and developers in acquiring vendor files, such as BONY, and standardizing data feeds ahead of expected project deadlines.
  • Established and maintained working relationships with various vendor Autosys groups, Technical Analysts, and Relationship Managers for the benefit of quickly acquiring and sharing client specific application data with multiple team members for project acceptance.
  • Created the "Business Process Modeling" documentation, which included Business Requirements, Technical Specifications, Data File Layouts and Libraries, End-to-End Data Flow Diagrams, Process Flow Diagrams, intelliMATCH Configuration Templates, Q & A Test Scripts, Training Manuals, Dash-Board Presentation Slides, and Project Plan Schematics.
  • End-to-end Project Management and in-depth contact with all direct and indirect teams involved; Business end-users and Management, Data Warehouse developers and programmers using SQL, External (Vendor) and internal (General Ledger to in-house application team members) Source-file analysts, Security Administration, Change Management, intelliMATCH application development team, Quality Assurance Team, and application specific Support Group to include SharePoint.

Confidential • Jersey City, NJ

Business Analyst

Responsibilities:

  • Managed front-end to back-end data field mappings of Corporate & Investment Banking - Swift, BONY, Nostro, and Foreign Currencies accounts using Access, SQL, and excel.
  • Tracked cash and securities transactions to include BNYMellon, London Clearing House (LCH), and Bloomberg vendor clearing files; daily securities movement transactions for middle-office support, as well as end-of-day cash settlement balances for back-office reporting.
  • Successful pivotal communication hub for all attributes associated with a Broadridge ‘Go-Live' migration project.
  • Communicated with project management in an ever-moving developmental environment
  • Identified vendor specific data scripts and incorporated data value layouts unique to Business Requirements (BRD).
  • Gathered technical specs of data feeds from vendor relationship managers and developers.
  • Interpreted vendor file/s, structured the timing of file-transfer-protocol, coordinated the efforts of UAT testing scripts between middle-office applications and back-office ledger transactions
  • Designed and modeled reconciliation statements with quality control, reconciled test results with the business group, and formalized documentation.
  • Documented effective transactional service products and market data: equities, fixed income, and derivatives with emphasis on international movements impacted by EMIR guidelines.
  • Exposed to FISERV NXG, UNIX shell scripting, Autosys, Bloomberg, ORACLE, MS-SQL 2005/2008, and VBA Scripting. (Migration of Broadridge general ledger accounts using intelliMATCH for NewEdge and BONY reconciliations.)

Confidential • Charlotte, NC

Project Mgr. / Technical Business Analyst

Responsibilities:

  • Created a hybrid project model between waterfall and agile (scrum mastering) to accommodate business and development teams for migration project success.
  • Maintained the JAD Project Design, Business Requirement Document, and the Functional System Design.
  • Supported up-stream and down-stream production groups to ensure completeness and accuracy of current and historical data.
  • Managed the complete intelliMATCH application SDLC cycle.
  • Identified and documented various stages and phases of specific planning, design, UAT and production changes (additions/deletions) to the current intelliMATCH reconciliation environment.
  • Utilized Best Business Practices related to the ‘clean-up' process prior to the newly created intelliMATCH application instance.
  • Maintained control for the merger of companies, accounts, balance pools, matching pass criteria, import formats, user groups, security profiles, and user access and privileges.
  • Effectively communicated and documented efforts of various groups; DBs (Database) using ETL methods (, SA (Security Administrators), Web-based Admin (Citrix), System Operations team (Domain specified applications), Administrative Systems team (FTP, SFTP Secured File Transfer Protocol ), Developers, Programmers, Engineers, Management, Quality Assurance testers, Reconcilers, Application Support, Business Reporting, Vendor Relationship Managers.
  • Exposure to Bloomberg, Desktop Software, Citrix, Web-based and SQL server applications: .Net, Symantec i3, intelliTRACS, IRIS-Web, nBalance, RIE Data warehouse (Legacy Confidential file repository), SSIS (SQL Server Integration Services), and Swift.

Confidential • New York, NY

Project Manager / Business Analyst

Responsibilities:

  • Created reconciliation reports with rules to match/combine/delete/provide exceptions to discrepancies.
  • Interpreted report specifications; created an import format and lookup tables, uploaded data, created matching criteria and produced a crystal report from a template.
  • Created a technical developmental matrix using SQL that lists: company, accounts, balance pool identifiers, field names, field locations, field sizes, delimiter format, import formats, class identifiers, multiple matching pass criteria based upon full or partial matched or unmatched items, export report links, and table formats
  • Built links, tables, matching field identifiers, and establish rules.
  • Documented the functionality & operational attributes of data, including Calypso & Bloomberg, into final reports.
  • Fine-tuned end-user specification requests into live quality control documents.
  • Created desktop software level instructions, summary-level of processes, and development creation of functional attributes of a successful reconciliation statement per requested requirements.

Confidential • Jersey City, NJ

AVP-Finance and Control Officer

Responsibilities:

  • Managed intelliMATCH reconciliations and reported daily movements of Loan & Letter of Credit Department customer transactions of various automatic and manual, domestic and international capital market accounts to include London Clearing House (LCH).
  • Documented desktop software level procedures of daily reconciliation & quality control processes of transactional services including Securities & Fund Services, Fund Accounting & Custody Services and the direct impacts of European Market Infrastructure Regulation.
  • Developed functional Cognos Power Play reports for financial/accounting & back-office support groups.
  • Steered the 2007 budget revenue and cost process for all divisions of Fortis Americas; reported final budget to Home Office in Brussels using FRAS System and USD to/from EUR currency exchange.

We'd love your feedback!