Business Analyst/data Analyst Resume
Raleigh, NC
SUMMARY:
- An IT professional with 7+ years of experience in business analyses primarily for banking and financial domains with a demonstrated ability in Business Analyses and Business Process Documentation. A formal Computer science qualification coupled with strong analytical and problem solving skills helps deliver cost effective solutions while maintaining the focus on the bottom - line.
- Experienced in business analysis and producing Business Requirements Documents and Functional Requirement Documents.
- Excellent knowledge of various Software Development Life Cycle methodologies. Experienced in both Waterfall and Agile methodologies using SCRUM techniques.
- Experienced in managing and maintaining requirements from project conception to completion.
- Experienced in performing GAP analysis and Impact Analysis on existing software and documenting the deltas needed to satisfy the business requirements.
- Proficient in UML with a good understanding of data flow diagrams, use Case diagrams, Sequence diagrams and Activity diagrams.
- Proficient in creating data mapping documents for data models to facilitate data transformation and reporting.
- Experience in Oracle E-Business Technical & Functional Design.
- Proficient in SQL queries with a good understanding of data analysis and management using different tools.
- Experience in Oracle E-Business Suite R12 implementation.
- Experienced in working with QA teams and assisting the QA team with identifying test cases and coordinating User Acceptance Testing (UAT) sessions.
- Experienced in creating Requirements Traceability Matrix (RTM) to keep track of the requirements from implementation through testing.
- Effective communication skills for coordination between globally located teams.
- Self-starter works well independently or as member of a team.
- Possess a working knowledge of project management tools like Microsoft Project and have participated in project planning sessions with development and QA teams.
- Equities (Common Stock, preferred stocks)
- Fixed Income Securities (Treasury Bonds, Mortgage Backed Securities (MBS), Asset Backed Securities (ABS), etc.
- Derivatives (Options, Forwards Futures, Swaps, etc.)
- Basic Risk concepts
- Regulatory Compliance - DODD FRANK, Basel II III
- Pricing Models
TECHNICAL PROFICIENCY:
Server & T-SQL Microsoft SQL
Quick Test Pro (QTP)
Oracle & PL/SQL E- Business suite
JIRA
Microsoft Visio
Microsoft PowerPoint
Microsoft Project
Microsoft Excel
Quality Center (QC)
Microsoft Word
EMPLOYMENT:
Confidential, Raleigh, NC
Business Analyst/Data Analyst
Responsibilities:
- Gathered user and business requirements through interviews, surveys, and worked with team to identify gaps and defects.
- Designing functional and technical changes of customization in Oracle EBS financial projects.
- Worked with the business users to understand the existing reports for prime brokerage, stock loans, swaps, futures and options.
- Enhancement, defect fixing and implement support the expansion necessary to accommodate facility. The company wanted to implement enterprise application in Oracle E-Business Suite developed in ADF 11g.
- Analyzed, prioritized and managed the requirements for enhancing existing reports developed with Cognos.
- Conducted user story workshops.
- Conducted requirements workshops with developers and testers.
- Identified various data sources and documented the data mapping relationships between them.
- Assisted the data architect with designing and architecting the ETL process.
- Assisted the data architect in reviewing the dimensions and measures of the data model which was based on a modified star schema.
- Conducted demo sessions with management.
- Conducted GAP analysis and created AS-IS workflow and TO-BE business processes.
- Assisted in testing reports that were developed using COGNOS.
- Participated and contributed in daily Scrums, Sprint meeting and Sprint review meetings
- Involved in development of test plans and test case.
- Worked with Excel to do data mapping.
- Conducted UAT (User Acceptance Testing) for validation of the application
Technologies used: Agile/ Scrum, Windows, MS Project, MS Visio, Quality Center, Java, Cognos.
Confidential, O’Fallon, MO
Business Analyst
Responsibilities:
- Captured business requirements and converted them to user stories, categorized into respective epics and maintained a requirements matrix.
- Design and developed user interface in ADF to import chart accounts from BAAN system and transfer to GL in Oracle E-Business Suite
- Facilitated Scrum planning meetings to coordinate between product team, develop team and QA team.
- AR invoice delivery system to distribute pdf invoices.cm/dm/using JAVA & Oracle E-Business suite for PDF document merge utility.
- Used JIRA to enter all user stories as product backlog items.
- Managed prioritized stories for the sprint and maintained backlog items.
- Designed Activity diagrams using Microsoft Visio for more complex user stories.
- Participated in daily SCRUM work meetings and weekly Sprint project progress meetings.
- Directly interacted with clients to determine the requirements and translate them into user stories that development team cam work with.
- Assisted QA team in preparing test cases and test plans.
- Participated in bug review meetings, updated requirements documents as per business user’s feedback.
- Developed and documented user acceptance criteria documents.
Technologies used: QTP, Microsoft Visio, JIRA, Microsoft Office, Windows XP, .NET
Confidential, New York, NY
Business Analyst
Responsibilities:
- Worked with the business stake holders in analyzing and identifying user stories for TBA MBS and its trading process by conducting joint application Development (JAD) sessions.
- Focused specifically on the implementation of TBA MBS trading platform.
- Designed flow diagrams using Microsoft Visio for more complex user stories.
- Used JIRA Server to enter all user stories as Product Backlog items.
- Worked with the development team in clarifying requirements issues.
- Conducted sprint planning meeting, various review meetings and client team meeting.
- Participated in daily stand up meeting with the team.
- Worked closely with the QA team and assisted them in identifying test cases and test scenarios.
- Assisted the QA team in testing the system in each sprint.
- Assisted the QA team in identifying test cases for automation.
- Participated in defect review meetings at the beginning of each sprint to identify defects carried over from the previous sprint.
- Worked with Pivot tables, VLOOKUP in Excel.
- Conducted user acceptance testing sessions with the business users.
Technologies used: Oracle PL/SQL, Microsoft Visio, JIRA, QTP, Java.
Confidential, New York, NY
Business Analyst
Responsibilities:
- Gathered user and business requirements through interviews, surveys, and worked with team to identify gaps and defects.
- Developed and maintained RTM (Requirement Traceability Matrix) and conducted requirements and design walkthroughs with designers, developers and management staff.
- Assisted the project manager in documenting meeting agenda and minutes of the meeting.
- Developed several SQL queries to understand the data and data-relationships.
- Created use cases and corresponding test cases from requirements using QTP.
- Conducted requirements workshops with developers and testers.
- Conducted GAP analysis and created AS-IS workflow and TO-BE business processes
- Involved in development of test plans and test cases.
- Conducted UAT (User Acceptance Testing) for validation of the application.
Technologies used: Oracle, Java, Microsoft Project, Microsoft Office, Microsoft Visio, QTP.
Confidential, Boston, MA
Consultant
Responsibilities:
- As a Credit Risk Analyst, my role involved analyzing various Banking Asset Products such as Auto Loans, Housing Loans, & Personal Loans and to recommend approval or denial decisions.
- Promoted a full range of personal banking products & services (Home Loans, Personal Loans, and Auto Loans).
- Established and maintained strong customer relationships.
- Assessed the credit information of the customer to determine the degree of risk involved in extending credit or lending money to Consumer and commercial applicants.
- Reviewed the Credit Applications and made recommendations based on the customer’s credit worthiness.
- Prepared and maintained the worksheets of the loan disbursed.
- Ensured completion and processing of all necessary documentation by support staff.
- Escalated the applications which required Manager Review.
- Followed-up with customers to ensure a high level of customer satisfaction was maintained.
- Lead a team of 2 junior executives and mentored them with the goal of achieving improved performance as a team.