We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

Moorpark, CA

PROFESSIONAL SUMMARY:

  • Nearly seven years of experience as Business Systems Analyst, with expertise in analysis, design, development and implementation of software applications.
  • Expert knowledge and experience of SDLC processes like Waterfall, Agile (Scrum), and RUP for software enterprise initiatives.
  • Experienced with Risk Management,Basel II/III Implementation, Capital Adequacy Calculations (CAR), Risk Ratings system, Credit Risk, Trading platforms and Fixed Income Products like Treasury (Bonds, Notes, and Bill),Mortgaged Backed Securities (MBS),Municipal Bonds, Corporate Bonds, Junk Bonds and Convertible Bonds.
  • Wrote complex SQL queries to perform the Back End Testing of the Oracle database using SQL and UNIX shell commands.
  • Hands on experience in Oracle and UNIX environment.
  • Created and maintained SQL Scripts and UNIX Shell scripts to perform back - end testing on the oracle database.
  • Supported UAT team with technical aspect of testing like running autosys batch jobs.
  • Experience in gathering business requirements, evaluating data sources, translating requirements into specifications, application design, technical and business writing and testing various methodologies.
  • Knowledge of Rational Requisite Pro and DOORS for requirement management and created traceability metrices among requirements.
  • Reviewed and worked on JIRA Tickets
  • Experience with facilitating workshops and meetings to define and document business training requirements for new product releases.
  • Worked in cross-functional environments and acted as a point-of-contact between the management and technology team; made presentations to them regarding the requirements and project updates.
  • Coordinated and conducted JAD sessions to review the progress of the project.
  • Expertise in UML like class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams, as a business analysis methodology for application functionality designs using MS Visio and Rational Rose.
  • Experience in performing and conducting UAT and coordinating the overall test effort.
  • Experience with tools such SQL and Toad for writing and running queries and perform data analysis.
  • Knowledge of GAP analysis and data mapping documents
  • Experience in assisting with implementing change management and establishing traceability.
  • Experience in Quality Assurance Life Cycle (QALC) aspects such as establishing project standards, writing test strategies, test plans, test cases, defect reports and developing test scripts, traceability matrices and test environments.
  • Defining test cases, analyzing bugs, interaction with team members in fixing errors and User Acceptance Testing (UAT)
  • Strong leadership skills
  • Experience working with offshore teams.
  • Understanding of concepts related to Consumer Lending, Consumer/Business Credit Cards and Consumer loans.
  • Extensive experience in General Ledger, A/P, A/R, Primary Mortgage, Commercial Loan and Data Migration Applications.
  • Extensive experience in development of loan processing system and mortgage using Empower system

TECHNICAL SKILLS:

Methodologies: Rational Unified Process (RUP), Agile (Scrum), DOORS, Rational Requisite Pro, SDLC, Product Life Cycle Management, SWOT Analysis, GAP Analysis, RAD, Cost Effect Analysis, Use Cases, Workflow diagrams

Business Tools: Rational Rose, MS Visio, Rational Modeler

Tracking Tools: Rational Rose, ClearQuest2002, Bugzilla, Quality Center

Operating Systems: Windows 9x/NT/2000/XP, UNIX

Databases: Oracle 11g/9i/8, SQL Server 2010, MS Access 2013

Quality Assurance: Software Application Testing Life Cycle, Knowledge of automation tools, HP Quality Center

Business Applications: MS Office 2013 (Word, Excel, PowerPoint, Outlook), Macromedia Dream Weaver, Adobe Go Live, Image Ready, Photoshop Flash, Adobe Acrobat, MS Visio, MS Project, Front Page 2000, HRDW (Human Resource Data warehouse), Business Objects, MicroStrategy Business Intelligence, Axure Pro, LAWSON

Environments: Java, C, C++, SQL, HTML, J2EE

WORK EXPERIENCE:

Confidential, Moorpark, CA

Sr. Business Analyst

Responsibilities

  • Actively involved in Design and Implement customization to packaged software applications (i.e. Encompass, Optimal Blue, Leads 360 etc.) supporting Retail line-of-business.
  • Review & Understand packaged software capabilities and features and apply my knowledge to solutions. Closely Work with software vendors as needed.
  • Executed SQL statements to check if the data integrity has been maintained.
  • Worked on brokerage applications for trading, risk management and processing
  • proprietary profitability system serving treasury security and services, commercial bank, and investment bank units.
  • Followed Software Development Life Cycle using Agile (SCRUM) Methodology which is based on iterative and incremental development.
  • Involved in Configuration Testing of the application across different platforms. Worked in Microsoft SharePoint to get detail requirements, plans and minute. Also used JIRA to report Bugs to the developing team
  • Created and maintained SQL scripts and UNIX as a part for back-end testing on the oracle database.
  • Changes in system for the eDisclosures forms as per State & Federal regulation& other regulatory authority.
  • Attended JAD Sessions in order to capture Business rules around Data elements on the User Interface system
  • Involved in Source Data Analysis, and designed mappings for data extraction
  • Create use cases & process flow for CSR (Customer Representatives) training for web portal
  • Performed data driven test for multiple scenarios with different sets of data using internal and external data sources.
  • Migrated SSIS packages and SSRS reports
  • Execution of Unix, Autosys Batches, retrieval of logs, identification for the source of errors
  • Knowledgeable of manual execution of Autosys Batches
  • Write business & functional requirements for various web portals such as Binder Portal, SLP Internal & External Portals, Member (client) Portal
  • Generated parameterized queries for generating tabular reports using global variables, expressions, functions, and stored procedures using SSRS.
  • Performed GUI testing and Functionality testing manually.
  • Worked and used Excel Macros as requirement template
  • Good working knowledge of SQL using QMFP facility in Mainframe.
  • Scheduled and Executed UNIX batch jobs using Autosys.
  • Maintain system documentation. Assist in development of training materials on customization / enhancements.
  • Participated in application & end-user support process. Performed other related duties as required and assigned.
  • Always demonstrates behaviors which are aligned with the organization’s desired culture and values.
  • Supported the re-design of the Mortgage Asset Management System.
  • Conducted interviews with key business users to collect requirement & business process information for loan process including set-up Account, New Loan set-up, Escrow Analysis, Appraisal, Credit, income & Title functionalities.
  • Involved in Configuration Testing of the application across different platforms. Worked in Microsoft SharePoint to get detail requirements, plans and minute. Also used JIRA to report Bugs to the developing team.
  • Conducted Weekly meetings to check the progress of project.
  • Comprehensively worked with requirement gathering for Enterprise reporting system using RequisitePro
  • Developed 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
  • Experience in complete WATERFALL, AGILE/Scrum, RUP SDLC Client /server architecture providing a well-balanced understanding of business relationships, business requirements.
  • Functioned as primary liaison between business line, operations, & technical areas throughout the project cycle.

Confidential, Atlant

Business Analyst

Responsibilities:

  • Involved in business analysis and project management, coordinating between the team members, addressing budget issues and creating test plans according to the business requirements.
  • Maintained Functional Requirements Documents (FRD) for the Tellers functions & Operations Management applications ensuring that they are current.
  • Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
  • Wrote SQL Queries to gather data from these MS Access Tables.
  • Performed Data Analysis, created gap analysis document, and performed data quality Checking.
  • Created numerous temporary, derived, permanent and volatile tables.
  • Teradata SQL performance tuning.
  • Work on Jira environment.
  • Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using oracle SQL, SAS, procedures, packages, functions, database triggers.
  • Prepared test plans using business requirements, data mapping documents and technical specifications.
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Expertise in problem solving and bug tracking using JIRA, HP ALM, Quality Center
  • Worked projects on Agile and Waterfall methodologies.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS
  • Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity
  • Executed SQL statements to check if the data integrity has been maintained.
  • Studied and analyzed risks associated with fixed income investment performance, including inflation risk, interest rate risk, currency risk, default risk, and liquidity risk.
  • Tested UNIX shell scripts written for ETL Processes to schedule workflows on Autosys.
  • Extensively used SQL queries to extract data from the database for Analytical purposes.
  • Retail, lending, and operational regulatory compliance audit and monitoring reviews
  • Performed GAP and Risk analysis of existing system and evaluating benefits of new system.
  • Created Requirement Specification Documents after conducting Interviews with End Users, JAD Sessions and analyzed their current systems.
  • Create internal reports using Dashboard and basic SQL queries in the tool to track activities of the teams.
  • Performed Back-end Testing using PL/SQL for Database Validation
  • Conducted functional requirement reviews and walkthrough with the Integration experts and stakeholders.
  • Identified Use cases for Business Requirements and Created UML diagrams like Use Case Diagrams, Activity Diagram using MS-Visio for various stakeholders.
  • Involved in Testing Autosys Jobs, that automates workflows
  • Understood and worked on Fixed Income, Equities & Trade Cycle, Derivatives -- Options, Futures, Mutual Funds, Portfolio Management, Brokerage
  • Assist end users and IT staff in the use of data to satisfy informational and reporting requirements and implementing and using SQL.
  • Created Functional Requirement Specifications/Use Cases following the Agile Methodology using MS Word/Visio.
  • Worked on Data mapping, logical data modeling used SQL queries to filter data within the Oracle database tables.
  • Create SQL queries to read data from databases.
  • Used Teradata SQL assistance to write SQL queries for data extraction.
  • Developed SQL queries, functions, stored procedures and triggers to perform the backend testing of the data
  • Wrote SQL Statements to extract Data from Database to verify the output Data of the reports
  • Recommended process or system changes intended to eliminate identified risks or gaps.
  • Managed the change request and analyzed the impact of the change request on the application in regards to Project Plan, Project Scope and Project Schedule.
  • Responsible for Back-End Testing Using SQL Commands
  • Provided regular verbal and written status reports to IT management and business community; published meeting minutes and maintained project plans.
  • Involved with the Quality Assurance team to develop and design test plans and test cases.
  • Tested the final application for usability testing (UAT) to verify whether all the user requirements were catered to, by the application.
  • Performed UAT testing along with call center managers to make sure that application meets their requirements
  • Worked on ATM transaction processing/options ranging from personalized Fast Cash withdrawals to deposit automation.
Confidential, Stamford, CT

Business Analyst

Responsibilities:

  • Arranged walkthroughs and interviews with the Subject Matter Experts (SMEs) and other stakeholders to keep track of user requirements and thus modifying business goals when necessary. Also recorded the requirements in a format that could be easily understood by both the business and the technical groups.
  • Implemented RUP within the different groups involved in the project, to configure and develop processes, standards, and procedures.
  • Converted user requirements into business requirements, analyzed the same, and segregated them into high level and low level business requirements.
  • Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
  • Assisted in integratingTableaudata into the active archives to make it readily accessible.
  • Extensively used SQL to retrieve, and manipulate data in the database
  • Use SQL to select the accounts with certain characteristics and to track the volumes with each processed file for a time period to create volume and functionality graphs.
  • Revised the use case, collaboration, object, sequence, activity, and state diagrams using Rational Rose/MS Visio according to UML methodology.
  • Responsible for Analysis and Defect Tracking using HP ALM, Bugzilla, JIRA, IBM Clear Quest.
  • Developed internal risk rating methodology based on financial risk models and metrics for growth, profitability, capital, liquidity and leverage, streamlined public and private company review workflow
  • Managed credit exposure associated with the banks broad range of foreign exchange, Derivatives, and Treasury Management products.
  • Participated in Agile development practices and Agile software development.
  • Reviewed and finalized the User Requirement Specification (URS), Functional Requirement Specification (FRS), technical specification, and detailed design documents.
  • Created different traceability views to maintain the traceability of the requirements using Rational RequisitePro/DOORS.
  • Involved in validation of data coming from sources outside the company using DTD.
  • Finalized the requirements for building an OLAP tool for extracting data from a central legacy server and loading it into an Oracle server.
  • Wrote SQL queries to query a database for the purpose of analysis.
  • Used Rational Unified Process (RUP) for streamlining the team’s development activities.
  • Conducted reviews with all the stakeholders to ensure that the data warehouse meets requirements and Service Level Agreements (SLA).
  • Prepared documents such as project scope, project vision, project success, business requirements, functional specification, data warehouse process flow (SQL queries & crystal reports) using MS Office (Word, Excel, Visio) and Dashboards
  • Expertise in Problem solving and tracking bug reports using Bug tracking tools such as ALM, JIRA
  • Revised and finalized the impromptu web reports and reports in Quality Center.
  • Coordinated the database validation by executing SQL queries on Oracle server.
  • Used MS Project to manage schedules, deadlines, and resources.
  • Acted as a liaison between the different stakeholders for facilitating communication between them.

Confidential, Woodland Hills, CA

BUSINESS SYSTEMS ANALYST

Responsibilities:

  • Responsible for eliciting detailed business, functional, and technical requirements for maintain as well as change projects
  • Responsible for the documentation of the project requirements including business requirements document, functional requirements document, and also participate in documenting the functional design document and technical design document.
  • Developed customized SQL reports and queries for management decision-making and operational management.
  • Skilled in bug reporting and tracking using ALM (Quality Center), IMB Clear quest and JIRA
  • Responsible for getting verifications, validations and approvals for the project deliverables
  • Followed structured approach in determining the scope of the respective project and the impact of the project initiative on the companywide systems and their corresponding operations
  • Responsible for preparing use cases, swim-lanes, and workflow (process flow) diagrams and using these artifacts to inform and educate the business and the stakeholders on the project impact and the solution delivering methodology
  • Extensive experience working in an Agile development environment.
  • Responsible for analysis and detailed documentation of business process and henceforth manage and perform upgrades to the process based on the business needs
  • Involved in identifying the existing business processes by interacting with subject matter experts. The SME's involved were complex processors - both financial and non-financial.
  • Responsible for collaborating with the development and the testing team in testing the intended solution, acting as the primary source for the documentation of the given effort
  • Followed the UML based methods using Rational Rose/MS Visio to create use cases.
  • Activity/StateChart, Sequence, and Collaboration Diagrams.
  • Facilitated collection of functional requirements from system users, and prepared business requirements document using Rational RequisitePro/DOORS.
  • Responsible for checking the system/solution integrity and performance by testing it manually as well as running pre-defined SQL queries. Performed the same with the technical team and the clients.
  • Wrote SQL test queries for UAT
  • Responsible for managing a team of 5 comprising of analysts, developers, and testers

Confidential, Fort Worth, TX

BUSINESS ANALYST

Responsibilities:

  • Job responsibilities include but not limited to Client interaction, managing artifacts, problem resolution, escalating issues, manage testing, prioritize projects, gather estimates for time and cost, deal with ongoing challenges etc.
  • Involved in identifying the existing business processes by interacting with subject matter experts. The SME's involved are complex processors, financial processors and non-financial processors.
  • Define project scope, business requirements, use-cases, and functional specifications.
  • Identifying, researching and analyzing problems and developing alternative solutions to resolve underlying operational issues.
  • Conduct requirement analysis and gap analysis.
  • Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
  • Facilitated JAD sessions with the clients and assessed the facts of the discussion to not only gain an understanding of the issues, but drive to a solution.
  • Proficient in overall Defect Management /Problem solving including tracking bugs and reporting using Quality Center and JIRA.
  • Assessed risks in trading application and worked with teams to reduce risk implications.
  • Acted as liaison between business and technical staff at all levels.
  • Experience in complete WATERFALL, AGILE/Scrum, RUP SDLC Client /server architecture providing a well-balanced understanding of business relationships, business requirements.
  • Involved in writing complex SQL queries to extract the data from Oracle database
  • Involved in Data Analysis, Data Modeling and Logical Data Specification.
  • Perform Requirement Analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stake holders and conducted document analysis.
  • Responsible for creating Business Requirement Document (BRD), Functional Specifications Document (FRD) and involved extensively in use case analysis using the UML tool MS-Visio.
  • Conduct JAD (Joint application development) sessions on Business Requirement Document and Functional Specification Documents with IT Directors, Project Managers, Data/Business Analysts, and Development Team.
  • Made sure the business requirements are met in cost effective manner. Regarding the same performed budgeting and valuation analysis to gauge the project efficiency.
  • Coordinate demo workshops to Business Managers, Business Users and demonstrated the entire functionality of the product.
  • Responsible for validating the financial effectiveness of the whole project team. For the same performed budgeting and expense and cost analysis. Also, laid down the forecasted benchmarks to gauge the project effectiveness.
  • Assisted in SOX compliance testing. For the same analyze the requirements and gather evidence.
  • Involved in creating and running UAT test cases and test scripts. Also, generated reports for UAT test cases.

Hire Now