We provide IT Staff Augmentation Services!

It Business Analyst Resume

Columbus, OH


  • Over 10+ years of Business Analysis / Scrum Master experience with in - depth understanding of Finance, Pharma and Banking industries - Web Applications and mobile app development with PCI Compliance
  • Proficient in various Software development life cycle (SDLC) aspects such as Requirement Analysis, Design, Development, Testing and Deployment using traditional Waterfall, Agile and Hybrid methodology.
  • Extensive experience in communicating with Subject Matter Experts (SME), performing Requirements gathering, Business analysis, Data analysis and Documentation from both formal and informal sessions interviews, Net Meeting, Q&A, video conferencing and JAD sessions.
  • Extensive knowledge of payment operations, and Global Clearing Systems.
  • Experience working on Automated Financial Systems platform (AFS) in fully integrated commercial lending system designed to process multiple types of loans on a single, real-time, multibank, multilingual, multicurrency system.
  • Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, and Metadata Management Services.
  • Extensive knowledge in Payments processing and SWIFT messaging standards. Have good knowledge of Wires, MMI, Check, Cash, Ipay, DD and Confidential payments.
  • Excellent understanding of EFT system (such as Confidential, Fed Wire, Internal Transfers, MMI, Check, Cash, Ipay, DD and Confidential payments, Automated Cash management and Prime Brokerage). Knowledge of Online Banking and the whole Fund Transfer process.
  • Translate Business Requirement document (BRD) into comprehensive Functional Requirement Document (FRD), writing SOP’s to process the documents and System Design documents (SDS) across the deliverables of a project.
  • Expertise in creating Dashboards reports to support the end users and customers using various reporting tools like Tableau Desktop, QlikSense and Spotfire
  • Extensive experience in Extract, Transfer and Load (ETL) process using SQL Server Integration Services for Data migration and Data Warehousing projects along with good project management skills.
  • Designed and implemented SQL queries using joins, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL server) for timely reporting.


SDLC: Agile (SAFe)- Scrum, Kanban & XP, Waterfall

Requirements Management: Rally ALM, JIRA, HP ALM, HP Quality Center

Process: Flows Visio

Programming Languages: Java & J2EE, vb.net, C

Database: Oracle (TOAD), Postgres, MSSQL

Version Control: Git, SVN, Visual Source SafeCI, C

Automation Tools: BDD with JBehave, Selenium-MTAF, Jenkins

Others: WinSCP, SOAP UI, Postman, MS Office

Code: Quality Sonar

Scripting Languages: HTML, Java Script, CSS, JSON, Ruby, AFSVision


Confidential, Columbus, OH

IT Business Analyst


  • Working in Financial Crime Transaction Monitoring (FCTM) in Anti-Money Laundering ( Confidential ) for Risk and compliance in mitigating Payments and Transactions.
  • Writing SQL queries to conduct Data Analysis, Data Comparison, Data Filtering, Data Computation, and Data Validation based on BRD/User Stories and to analyze, query, sort and manipulate data according to defined business rules and procedures.
  • Validate the backend tables using SQL Developer for checking the validity of the backend data and Tested data.
  • Chair defect triage meetings to understand the defects and to come up with different solutions for work arounds, tracking defects using HP QC ALM and made sure those defects are efficiently passed from one layer to another and retested, and verify the defects that are fixed and track them to closure.
  • Conducting the validation STLC from Test execution, issues resolution & report generation using HPQC/JIRA.
  • Conduct quality assurance due diligence and high- risk reviews on transaction monitoring banking business according to the bank’s BSA/ Confidential policy and procedures.
  • Ensured CDD is properly performed by the LE/LOB and EDD is applied in cases where warranted to mitigate Confidential /TF.
  • Planning and executing of the Extract, Transform, and Load (ETL) Process from source to target, proficient skills in creating entity relationship diagram, including conceptual diagram, logic diagram and physical diagram
  • Working on non-functional or technical requirement including interfaces data flows, environment, contingency and retirements as well as service levels from business and operational support perspective.
  • In-depth Gap analysis performed, process flow generated and reviewed and vetted with knowledgeable and accountable clients, sponsors, users, cross functional service providers and interdependent application teams.

Confidential, Columbus OH

Technical Business Analyst / QA


  • Gathering requirements, writing stories related to mobile application and web application in Commercial Lending business
  • Develops technical documentation (designs, specifications, processes, workflows) and communications.
  • Communicated with developers, business and other team members to thoroughly understand the requirements to ensure high Quality software. Played a key role in timely delivery of the product.
  • Simulates or recreates user problems to resolve operating difficulties and identify problems. Carries out procedures to ensure that all systems, products and services meet standards and requirements.
  • Experience in both the technical and business sides of the mobile app product and build knowledge so that they can represent from a subject matter expert as well.
  • Develop and document application test plans and scripts based on software requirements and technical specifications
  • Translate Business Requirement document (BRD) into comprehensive Functional Requirement Document (FRD), writing SOP’s to process the documents and System Design documents (SDS) across the deliverables of a project.
  • Experience on well-known Commercial Lending product Misys Loan IQ on all modules with expertise on Accounting.
  • Gathered business and functional requirements for new batch and real time interfaces for the 'Global Loan Platform / Misys Loan IQ' conversion project.
  • Experience using test management, bug tracking and reporting tools JIRA, HP QC/ALM. Proficient in testing to ensure successful execution and appropriate application of solutions.
  • Identified various business processes and developed process flow diagrams for the acquisition systems verification.
  • Used MS Visio to create Use case diagrams, Activity diagrams and Sequence diagrams as well as designed Mock-ups and wireframes using mock-up screens to get feedback from UI/UX team about the web form designed.
  • Performed Data Analysis and Data Validation by writing complex SQL queries.
  • Conducted GAP Analysis in understanding how the upgraded system carries out the business functions and assists in ensuring the timely and effective implementation.
  • Manage testing and create comprehensive testing scripts for a project involving the addition of new enhancements in Loan IQ. In addition, create general regression scripts in Loan IQ for use in major software upgrades. Assisted in coordinating the consolidation of global testing across multiple projects.
  • Worked with the data modelers to come up with the fact table structures that conformed the business reporting requirement as well as performance requirements.
  • Involved in extensive DATA validation using SQL queries and back-end validations.
  • Worked closely with Developers and User Representatives, participated in the product design process including specifications, end-user reviews and application walk-through.

Confidential, Somerville, NJ

Business Analyst / Quality Analyst


  • Worked as a Business System Analyst and Pharma Domain Quality Consultant in Quality Services and Quality Management group of Compliance Group.
  • Supported project team with HP Quality Center tool to ensure the quality of the software from GMP Purview for Test Management and Defect management process
  • Work with the Data modeler and Development team in modelling the data base, analyze data in db by writing SQL queries
  • Interacted with the development team on regular basis to ensure and balance practicalities with innovative and efficient business systems solutions
  • Gathered requirements and developed process flows diagrams in accordance with Medicare and Medicaid rules and regulations pertaining to the Facets configuration and evaluated the impact of proposed changes.
  • Worked on Data Mapping to map Facets data to outbound eligibility extracts Conducted Gap Analysis of requirements, generated workflow process, flow charts
  • Defined and documented the vision and scope of the project.
  • Working with sponsors, standards core and governance teams to define stakeholders, propose data standards and adjudicates feedback from stakeholders.
  • Participated in weekly status meetings to present status and in corporate any digressions from the original scope.
  • Carried out a thorough target organization assessment and risk and impact analysis

Confidential, Tampa, FL

Sr. Business Analyst


  • Partners with business leaders on research, design, build, configuration and operation of niche platforms (e.g. Financial Systems, Commercial Lending. Wealth management, Risk Systems, Treasury services, Sales Tracking Systems).
  • Research Confidential and wire transactions which alert in the Actimize Commercial Banking Fraud application for suspicious activity, and determine if client confirmation is required
  • Created content and designed overall look of internal and external sales and marketing brochures, data sheets, flyers and Web pages while maintaining strict branding guidelines
  • Syndicated Lending domain knowledge including Loan Origination, Loan Trading, Straight though Processing
  • Experience working on Money Movement Channels.
  • The Project included automating interfacing with other banks through Swift for updating the financial transactions
  • Responsible for handling inter-bank communication related to exports through SWIFT messages.
  • Worked with all front office systems in ensuring the smooth implementation of trade processing using SWIFT messaging and other protocols for settlements.
  • Hands on experience on funds transfer application including the messaging system like SWIFT and FIX protocol. CHIPS and Fedwire.
  • Excellent understanding of EFT system
  • Knowledge of Online Banking and the whole Fund Transfer process.
  • Enhanced the Global Cash Position Management platform, the multi-threaded real-time liquidity management application
  • Managed the IT Software development of the Treasury & Capital Markets systems, supporting Foreign Currency, Derivatives transactions, fixed income, and payment systems with interfaces to Swift, Chips, and Chaps.
  • 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
  • Lead the process throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing RUP methodology. Utilized guidelines and artifacts of RUP to strategize the implementation of Rational Unified Process effort in different iterations and phases of software development life cycle.
  • Created documents of the use cases and created the use case, activity, logical, component and deployment diagrams using MS Visio and Rational Rose to communicate clearly with the development teams.
  • Redesigned web services methodology for the application while implementing reusability from different servers. Liaised with the technology team to derive Functional Requirements.
  • To better define the rationale for the new process compiled Vision and Scope documents. Prepared reports for process improvements and trend analysis
  • Played a pivotal role in conducting Functional testing, Regression testing, Integration testing, Smoke testing and UAT (User Acceptance Testing)
  • Responsible for supervising work activities (Development, Testing) to ensure that they are well-performed, coordinated among team members and consistent with the approved work plan.
  • Signed off progress and completion report which were then submitted to project management on a weekly basis.

Confidential, SFO, CA

Business System Analyst


  • Handle SWIFT Alliance non-routed messages; research duplicate, failed, or unsolicited messages
  • Maintain SWIFT procedures ensuring compliance with established policies and practices
  • Evaluate the SWIFT annual release, identifying business lines and applications that may be affected by changes.
  • Analyzed project & client requirements and prepared Requirements Document for effort estimation.
  • Assessed the flaws in the existing AS-IS underwriting system and made clear recommendations of Business Process Improvements and incorporated them in the future TO-BE system design.
  • Conducted workshops to understand requirements for Data Warehouse design, conducted client-side validation to study ETL (Extract Transform and Load) operations on database.
  • Reviewed and maintained Project Changed Request PCR related to the project throughout the lifecycle.
  • Assisted the Project Manager in preparing a project plan using Clarity to ensure timely completion.
  • Assisted and fully collaborated with QA and Development team with preparing various Test Documents like Test Plans, Test Cases, Test Scenario and Test Scripts for Unit, Regression and System Testing.
  • Coordinated and prioritizes outstanding defects assigning to the designated team.
  • General knowledge of policies, plans, procedures, products and regulatory requirements for cash services functionality (cash, audit, reconciliation, wires, Confidential )
  • Created relationships in Requirement Traceability Matrix (RTM) linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
  • Ensured that regulatory, legal, bank and audit requirements are met and advised management on needed actions.
  • Assisted the BSA/ Confidential /OFAC Operations Manager in order to ensure adherence to State and Federal regulatory compliance with Bank Secrecy Act and Anti-Money Laundering (BSA/ Confidential ) requirements.
  • Ensuring compliance with all Confidential laws, regulations, guidelines, written procedures; OFAC, FINCEN, KYC, customer/transaction monitoring. .
  • Coordinated and performed System Integration testing (SIT), Regression Testing, and User Acceptance Testing (UAT) to check the functionality of the application.
  • Worked under high pressure to meet Regulatory compliance.

Confidential, Dallas, TX

Business Analyst


  • Constantly interacted with the Product Director at Telnet for the enhancements and discussion on the changes.
  • Analysis on EDI files 820 for the Telnet clearing house, which had various clients
  • Interacted with one of their important Client, provider Yale for the usability and current challenges that are faced usability point of view.
  • Knowledge of Business Intelligence, Data Warehousing, Data Modeling and Analytics concepts with expertise in grasping transaction flows and process management


Business Analyst


  • Gathered user and business requirements through open-ended discussions, brainstorming, interviewing key business users to better understand their needs and resent solutions using structured SDLC approach.
  • Prepared Business Requirement Document (BRD) converted into Functional Requirement Specifications (FRS) and walk through with the designers, developers and stakeholders.
  • Managed/Updated requirement documents as needed throughout the design/development process (e.g. Document revision, Change Request).
  • Daily cash posting of checks and wires, update cash reports and distribute to management.
  • Processing and post payments to franchisee accounts that include checks, wire and Confidential transfers in addition to credit card transactions.
  • Contacted customers by telephone, wire, or letter to negotiate and arrange satisfactory repayment schedules.
  • Processed multiple bank account receipts from the lockbox, wires, and Confidential .
  • Utilize Visual Basic to create interactive business documents used by analysts, QC and bankers to retrieve necessary customer information and create completed KYC review.
  • Create and implement SharePoint based applications for general use by KYC

Hire Now