We provide IT Staff Augmentation Services!

Business Systems Analyst Resume

Dallas, TX

PROFESSIONAL SUMMARY:

  • Business Analyst with over 5+ years of experience in Financial banking, Retail Banking and Investment Banking Sectors with all phases of the Project Development Life Cycle.
  • Strong Experience in Agile, Waterfall, Object Oriented Analysis and Software Development Life Cycle (SDLC) processes.
  • Experience in working with Architects and Developers to transform new requirements into Salesforce.com design and implementation.
  • Experience in Requirement gathering through participating in interviews, workshops, and JAD sessions with clients, developers, and QA Analysts, and referring to existing system documentation and procedures.
  • Strong Knowledge on Fixed Income and financial markets.
  • Well - versed in documenting Business Plan, Requirement documents, Functional Specification documents, and Standard Operating procedures.
  • Experience in Conducting Market Research, Feasibility Studies, Data analysis, System Analysis, Gap Analysis and Operational Risk Analysis.
  • Experience in creating UML (Unified Modeling Language) diagrams such as activity, use case, sequence, collaboration and deployment diagrams.
  • Experience in conducting GAP Analysis, Risk Analysis, SWOT Analysis, Cost-Benefit Analysis (CBA), Net Present Value Analysis (NPV), Return on Investment Analysis (ROI), and Break Even Analysis.
  • Knowledge on Anti Money Laundering(AML) and Know Your Customer(KYC).
  • Experienced in configuring and deploying Linuxbased operating systems on HP Proliant class processing platforms.
  • Possess advanced SQL programming skills, strong understanding of data warehousing concepts and experience working with large relational databases.
  • Proficiency in use of Financial Models using Microsoft Office Suite Excellent oral and written communication skills with ability to communicate with all levels of management and team members.
  • Possess exemplary requirement gathering, coordinating meetings, technical writing, presentation, listening, time management, inter-personal, organizational, interpretation, problem escalation, leadership, decision making, motivational, issues management, and influencing skills.
  • Ability to solve complex problems independently and generate innovative solutions.
  • Ability to manage group dynamics, facilitate team interaction & negotiate effectively.
  • Experience identifying and implementing sustainable "best practice" solutions and procedures.
  • Self-starter, assertive, enthusiastic, creative and aggressive person with strong focus on attention to details, customer focus, follow-through and solution orientation.
  • Ability to effectively handle multiple priorities, concurrent projects and aggressive deadlines.

TECHNICAL SKILLS:

Test Management Tools: Test Director, Quality Center, ClearQuest, TFS

Operating Systems: Windows XP/2000/ME/98/NT, UNIX, Linux

Languages: C, C++, SQL, Java, TSL, .Net, shell scripting

Web Languages: VB.Net, HTML, XML

Databases: Oracle, MySQL, SQL Server 2000,PL/SQL Teradata

Browsers: Internet Explorer, Netscape Navigator, Mozilla Firefox

Project Management Tools: MS-Office 2013/XP, Microsoft Visio, Excel, Power Point

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Business Systems Analyst

Responsibilities:

  • Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results by using T-SQL.
  • Optimized the database by creating various clustered, non-clustered indexes and indexed views.
  • Developed queries using joins, unions, sub-queries, date and time functions, co-relation sub-query etc.
  • Performed User Acceptance Testing (UAT) and Regression Testing for Trade Tracking System for PBMO
  • Gathered Requirements from the end user and involved in developing logical model and implementing requirements in SQL Server 2008-R2.
  • Primarily responsible for developing applications in SSIS as perBusinessRules and features of the tool.
  • Used Control Flow Tasks like For Each Loop Container, Execute SQL Task, Bulk Insert Task, File system Task and Data Flow Task.
  • Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
  • Extensively used SQL for reporting and validating as well as for joining the tables.
  • Created different reports such as Cross Tab and Parameterized reports, using SSRS and delivered the reports to concernedbusinessusers and internal stakeholders.
  • Responsible for creating reports based on the requirements using SQL Server Reporting Services (SSRS).
  • Implemented audits and security controls across the Linux infrastructure.
  • PerformedSystemsStudy and developed Entity Relationship Diagrams and Table Structures. Developed Tables, User-Defined Functions, Triggers, Views, Indexes, and Stored Procedures to perform different computations on the integrated data using T-SQL.
  • Collected and documentedbusinessprocesses as well as business rules. Participated in the identification, understanding, and documentation ofbusinessrequirements, including the applications capable of supporting those requirements.
  • Reviewed and analyzed the business requirements document to derive the functional specifications document and assisted in the preparation of System Requirement Specifications.
  • Facilitated business requirements gathering sessions with the client, and overlooked the creation of Use Cases/Activity Diagrams, Functional Specifications using UML/Visio
  • Designed and developed Use Cases and UML models using Rational and developed Sequence Diagrams, OOD using UML.
  • Participated and facilitated different levels of discussions through User Interviews, Structured Walkthroughs and JAD sessions, conference calls and business workshops held to plan business strategy.
  • Attend weekly change request meetings to document changes and implement procedures to test changes upon completion.
  • Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Involved in creating various documents such as Use case, Business Requirements and Functional requirement specifications.
  • Used MS Office suite (Word, Excel, Access, Visio, Power Point, Outlook, Project) for project tracking, documentation, and presentation to senior management
  • Extensively used SQL queries, JIRA and cloud storage processes
  • Conducted UAT (User Acceptance) Testing. Provide end user training and extensive go-live assistance. Provide solutions to users via phone/email by providing them with screen shots of the different screens, which helped them in understanding the process at a much faster pace.
  • Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL
  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).

Environment: Mockup Screens, MS SQL Server 2012, IBM Requisite Pro, Rational Rose, SSRS, SSAS, SSIS, MS Visio, MS SharePoint 2010/ 13, MS Project, Visual Studio 2010, QTP, HP ALM (QC), Tableau, Teradata

Confidential, Dallas, TX

Business Systems Analyst

Responsibilities:

  • Worked as business analyst to support the re-design of the Mortgage Asset ManagementSystem.
  • Extensively involved in the development of Reporting Data Warehousing System.
  • Designed the business requirement collection approach based on the project scope and SDLC Methodology.
  • Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
  • Developed business process models in RUP to document existing and future business processes.
  • Performed extensive requirement analysis including data analysis and gap analysis.
  • Designed and developed project document templates based on SDLC methodology.
  • Designed and developed all Use Cases and UML models using Rational.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using Visio.
  • Analyzed the strategies of Risk management, Mortgage, Fixed Income and Derivatives in the investment division
  • Established a business Analysis methodology around the RUP (Rational Unified Process)
  • Developed requirement reports for day-to-day retail banking needs for opening account, online baking using rational SoDA.
  • Organized and executed the User Acceptance testing.
  • Worked with the Prime Brokerage Middle office (PBMO) Business team to document the Use Cases.
  • Conducted and coordinated Portfolio Performance measurement: return, calculation and attribution.
  • Analyzed, interpreted various asset class i.e. Equity, fixed income, Funds, Derivatives, Money markets.
  • Created JIRA Workflows for multiple projects according to business needs and Created projects while keeping up existing projects/agile boards
  • Developing strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products, process and revenue streams.
  • Analyzed, organized, and updated database using SQL.
  • Worked with marketing team in knowing what exactly bank's client wants.
  • Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
  • Partnered with the technical areas in the research and resolution ofsystemand process problems.

Environment: Windows Vista, MS Office, RUP, UML, SQL, Rational Rose, MS Visio, SWOT analysis, Rational SODA. Clear Quest

Confidential, Chicago, IL

Business Systems Analyst

Responsibilities:

  • Responsible for gathering requirements from users, mainly Traders & Risk Professionals
  • Functioned as the primary liaison between the operations and the technical team and resolved process issues throughout the project cycle.
  • Collaborated with the marketing team in identifying the needs of the bank's customers.
  • Established a Business Analysis methodology around the RUP (Rational Unified Process)
  • Facilitated numerous JAD (Joint Application Development) sessions utilized for the creation of design documents and system specifications for applications.
  • Responsible for all pre and post-go live business requirements and proper documentation. Managed project list of IT department to prioritize deliverables. Set up and reviewed testing, training and documentation on all modifications and enhancement. Identifying entity types and then assigning attributes to those entities (Data Modeling)
  • Created functional & technical specifications for an in-house front office trading application whose main products were related to ABS (Asset Backed Securities), CDO (Collateralized debt obligations) and Whole Loan Mortgages.
  • Review of Financial Ratings, Underwriting philosophies, Reduce the Average Claims Turnaround time.
  • Managed multiple projects that would be implemented for the followingbusinessrelated to Fixed Income, Trade Clearance, Asset and Wealth Management and Billing.
  • Worked on a Risk Management System, which supplies users with intra-day and end-of-day speeds, status of modeled bonds, as well as market and credit risk (delta) information
  • Responsible for data mapping of feeds from several reference data systems, including Bloomberg, to a number of in-house applications.
  • Used MS-Visio to document current work flows, manual processes and end-to-end processing of system interactions
  • Developed and executed associated project plans and test scripts for User Acceptance Testing (UAT) and subsequent user training.
  • Developed strategic partnerships with various business units to develop a solid knowledge base of the business, including the business plan, products, processes and revenue streams.
  • Played a key role in the planning, testing, and implementation ofsystemenhancements and conversions.

Environment: Rational Requisite Pro, Rational Rose, RUP, UML, PL/SQL, MS Office, MS Project, Windows 2000, Crystal Reports, Java, HTML, Oracle, MVS.

Hire Now