We provide IT Staff Augmentation Services!

Business Analyst Resume

Cincinnati, OH


  • 6+ years of experience working as a Business Analyst in Banking & Insurance & Financial domain
  • Demonstrated ability to use Analytical skills, to critically evaluate all information gathered, resolve conflicts, clearly define loosely given information, distinguish user requests from the true needs of a user, and provide solution ideas from requirements.
  • Develop, implement and maintain application software to established standards and specifications
  • Ability to build relationships as well as positive rapport with customers and team members.
  • Performed SQL queries using TOAD software. Wrote SQL statements to extract data from the Tables
  • Work in cooperation with technical support to prepare application software procedures and documentation for usage, operation, back - up and recovery, problem resolution, shut-down and initialization and process automation.
  • Assisted Business User during deployment in formulating User Acceptance Testing (UAT) for customized application and getting confirmation for product Release
  • Demonstrated understand and proficiencies in Microsoft Office suite including OneNote
  • Highly analytic with the ability to view projects at both strategic and tactical levels.
  • Demonstrated ability to consult with each team to ensure proper implementation as well as user expectance is achieved through product life cycle.
  • Work effectively with Microsoft SQL, Excel, PowerPoint, Word (familiar with MS Teams)
  • Experience in developing conceptual, logical and physical data models as per enterprise standards
  • Comprehensive knowledge and experience in Software Development Life Cycle (SDLC) with business process models: Waterfall & Agile(Scrum) methodologies Proficient in creating various documents like Business Requirements Document (BRD), Functional Requirement Document (FRD) and Functional Specification Document (FSD)
  • Comprehensive knowledge and experience in Software Development Life Cycle (SDLC) with business process models: Waterfall & Agile(Scrum) methodologies Proficient in creating various documents like Business Requirements Document (BRD), Functional Requirement Document (FRD) and Functional Specification Document (FSD)
  • Ability to listen to inform and to understand conversation to detect what information teams may be hesitant to talk about or do not fully understand.
  • Expert at interacting with stakeholders, Subject Matter Experts (SMEs) and end-users to understand, analyze, communicate and validate requirements using Joint Application Design (JAD), Joint Application Review (JAR) sessions
  • Excellent understanding of Data services, Data ETL using SQL query tools and applications
  • Developed process to accommodate UAT life cycle for metadata application activities using MS Word, Excel, PowerPoint, Visio
  • Demonstrated writing skills, to relay and communicate information effectively to customers, less technical teams, marketing, managers, and also technical staff. Adopted Gherkin format to write acceptance scenarios as basis for requirements.
  • Wrote Behavioral Driven Development (BDD) acceptance criteria for user stories using Gherkin scripting language.
  • Developed, modified and enhanced clientele reports via Microsoft SQL Server 2012 and SSRS
  • Demonstrated ability to create highly innovative and creative to solutions to complex problems.
  • Excellent Team Player with ability to think analytically and troubleshoot issues.
  • Ability to talk with individuals and groups to understand the scope of essential requirements.
  • Experience in conducting weekly and monthly business review meetings to keep SME's, Stakeholders, product managers, executive staff and team members apprised of goals, project status, resolving issues and conflicts and preparing product demonstrations.


SDLC Methodologies: Waterfall, Agile-Scrum, Waterfall - Scrum Hybrid, Kanban, Scrumban, XP, Spiral.

Business Skills: Change Management, Project Planning, Process Modeling, Risk Management, JAD Sessions, Impact Analysis, GAP Analysis, SWOT Analysis and Cost-Benefit Analysis.

Project Management Tools: JIRA, Rally, Confluence, Version One, Unified Modeling Language (UML), Lucidchart.

Modelling Tools: Wireframe.cc, Moqups, MS Visio, Balsamiq, SharePoint Designer, CA Erwin, Swagger.

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Project, MS Outlook, MS SharePoint.

Testing Tools: HP QC, HP ALM, HP LoadRunner, Cucumber, POSTMAN, Swagger, SOAP UI.

ETL and Reporting Tools: Tableau, QlikView, Informatica, Spotfire, IBM Cognos, SQL Server Data Tools - BI, SSRS.

Languages: VB, JavaScript, node.JS, ASP SQL, T-SQL, PL-SQL.

Web Technologies: WSDL, XML, HTML, SOAP, Web Services, REST.

Databases: SQL Server Management Studio 2014, Oracle 11g, 12g, Oracle 11g, MySQL Server 2012, MS Access, Team Foundation Server (TFS) 2012.

Data Warehousing: OLTP, OLAP, Data Marts, Data Mining, Slicing/Dicing, Drill Down/Roll up, Pivot, Data Mapping, Data Modelling, Star and Snowflake Schema, ETL.


Business Analyst

Confidential, Cincinnati, OH


  • Business Analyst in requirements gathering and development, in Financial Operations and Technology, Treasury, Front-office trading, clearing, product control, with emphasis on financial services, risk, capital markets, investment management and asset management domain.
  • Responsible for large scale change initiatives across multiple functional areas
  • Responsible for trading solution, by using Fidessa's global connectivity network to access listed derivatives and cash equities liquidity
  • Utilized Excel, Access and SQL scripts to process, clean and validate data for the EDI processes
  • Evaluating design and operating effectiveness of controls for business and Information Technology purposes.
  • Responsible for loan life cycle, loan origination, loan data, customer data, loan servicing.
  • Responsible for the recruiting, management and career development of consulting staff.
  • Provided project turn-around expertise at the customer site with emphasis on regaining customer confidence.
  • Responsible for staff/account management and prioritization and forecasting.
  • Opine on high-risk ICM Correspondent Banking clients escalated to AFC from global COB teams, providing approvals, offering guidance or further escalation, requesting additional attestations to mitigate firms risk appetite.
  • Coordinating and tracking all projects for releases using Project Management System JIRA.
  • Supported Senior Advisor on multiple aspects of account management, including answering client inquiries, examining portfolios, making recommendations, and acting as primary contact
  • Monitored project activities and advised staff of issues due to resource availability.
  • Responsible and accountable for the coordinated management of multiple related projects directed toward strategic business and other organizational objectives.
  • Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those external to the organization.
  • Created and built reports/ analysis while directly working with MS Access / SQL and Teradata joining relational tables together.
  • On a daily, weekly, and monthly basis, demonstrated the ability to create complex SQL queries that can filter or aggregate data to generate KPIs
  • Experience with Fidessa buy side solutions; sell side solutions, global connectivity and market data.
  • Knowledge in loan IQ., markets, equity, M&A.
  • AMS buy-side and sell-side firms improve post-trade efficiency, lower running costs and reduce operational risk.
  • Directed recruitment//staff development initiatives to maximize productivity.
  • Business Requirements Gathering, Business Process Flow, Business Process Modeling and Business Analysis
  • Analyzing and redesigning existing information system process flows to ensure accurate aggregation of financial data from multiple systems for consolidated financial reporting.
  • Documenting enterprise risks and key controls through detailed process flow maps and narratives including business continuity plan.
  • Conducting comprehensive business risk assessments and risk profiling for various process and operations of clients.
  • Utilized SQL server for select statements needed to access data from different schemas containing data stored.
  • Testing operating effectiveness of the controls over financial reporting and UAT.
  • Performing diagnostic assessments and evaluation of financial processes for clients in the insurance, banking and diversified financial service, Credit management, Wealth Management, and retirement processes.
  • Interacted with healthcare clients to gather requirements, objectives, and input and output requirements retail banking, manufacturing, and utility industries. Review business manuals and requirement document (BRD) in order to summarize system-specific business rules and other operating conditions.
  • Experience with customer operations, money movement, actuations, on boarding, account management, collections.
  • Coordinated End to End Testing activity and UAT.
  • Demonstrate an understanding of complex trading processes currently undertaken by potential Fidessa

Environment: SQL Server, UML, Rational Requisite Pro, Test Manager, Clear Quest, Windows, Agile, MS Visio, MS Access, MS Project, UAT, JAD, UML Diagrams.

Business Analyst

Confidential, Houston, TX


  • Gathered User and Business Requirements through Surveys, Prototyping and Observing From Portfolio Managers and UI (User Interface).
  • Analyzed and Prioritized User and Business Requirements as System Requirements That Must Be Included While Developing the Software.
  • Responsible For Installing, Configuring, Upgrading And Maintaining A Scalable And High Performing Solution.
  • Worked in mainframe environment and used SQL to query various reporting databases
  • Involved In Inception Phase And Prepared Logical Data Models That Contains Set Of Diagrams And BRD (Business Requirement Documents) Supporting Documents Containing The Essential Business Elements, Detail Definitions, And Descriptions Of The Relationships Between The Actors To Analyze And Document Business Data Requirements.
  • Extensive knowledge of Trade data accounting, multi firm processing capabilities. Straight through Business processing with integration through SWIFT messaging with counter parties through the complete settlement process.
  • Working on enhancements in Business Objects, Cognos and Informatica.
  • Planned And Defined System Requirements To Use Case, Use Case Scenario And Use Case Narrative Using The UML (Unified Modeling Language) Methodologies.
  • Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
  • Correspondence Included Solicitation Letters, Financial Transaction Confirmations, and Quarterly and Annual Policy Statements.
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
  • Scheduled Meetings with Developers, System Analysts (SA) and Testers to Collaborate Resource Allocation and Project Completion Using MS Project.
  • Created Mock-Up Forms In MS Access For Better Visualization And Understanding Of The Software Solution.
  • Authored Progress and Completion Reports, Which Were Then Submitted To Project Management on a Weekly Basis.
  • Developed Strategies With Quality Assurance Group To Implement Test Cases In Mercury Test Director For Stress Testing And UAT (User Acceptance Testing).
  • Collaborated With Quality Assurance Analyst In Automated And Manual Black Box Testing Using Mercury's Winrunner.
  • Suggested Measures and Recommendations to Improve the Current Application Performance.

Environment: Microsoft Office, MS Visio, HP Quality Center, MS Project, SVN, Requisite Pro, UML, SQL Server, Java, J2EE.

Business Analyst

Confidential, Detroit, MI


  • Organized and contributed to user-story workshop for the team to write user stories based on ARL and BRD.
  • Created SQL Queries and Stored Procedures using SELECT and JOIN for Portfolio Drill Downs to pull data.
  • Worked on service-oriented architecture (SOA), REST and FIX Protocols; API documentation for JSON messages in multi- tier architecture; content management using TFS.
  • Executed Stored Procedures using Test Parameters/ Test Data in DB to determine if the outputs are correct.
  • Worked with the Product Owner and the Development team in managing the Technical Debt.
  • Contributed to the planning meetings using techniques estimation techniques like Planning Poker, T-Shirt sizing.
  • Attached diagrams, documents, links and comments to the tasks for the developers to implement the story.
  • Created Mockups screens and Wireframes Vision for the team to create forms and views for the application, worked closely with the clients to gather requirements and scheduled timely meetings and discussions.
  • Good Understanding of Application Development in MVC and distributed code in Model, Views and Controller.
  • Involved in project implementation in agile methodology to facilitate on time task completion in the Sprints.
  • Analyzed and Documented the Approved Requirements List (ARL), Business Requirements Document (BRD)
  • Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and commercial lending system.
  • Involved in Backlog Refinement meeting to prioritize & estimate the PB based on the requirements and team, used techniques - MoSCoW, KANO Model, Value Stream Mapping, and Business - Technical value to prioritize.
  • Interacted with Financial Analysts to understand Fundamental analysis, Financial models to calculate Expected Return, Market Risk and Portfolio Risk of the portfolio to be used in Analytical tools.
  • Created, documented, and published Business Requirements Document for the new LIMS system
  • Created schemas to perform CRUD operations for Credit Card Information of the clients paying claim amount.
  • Assisted the team in documenting the WCF Web Services for SOAP/ XML in Swagger to enhance reusability.
  • Conducted meetings for the Design and Development teams to come up with Functional and Technical Specs.
  • Assisted the Product Owner in writing clear and concise user stories and provided detailed task description.
  • Suggested the implementation of Entity Framework to design Data Access Layer to access the data in Database.
  • Involved in Technical Discussions to provide Functional Specifications and Compliance perspective to the team.
  • Managed the testing team and lead the creation of test cases for both LIMS systems

Environment: Visual Studio, ASP.NET, C#, MVC, Razor, WCF, SQL Server, JQuery, Team Foundation Server, IIS, .Net Framework 4.0, Visual source safe, CSS, HP QC

Hire Now