Sr. Business Analyst Resume
Riverwoods, IL
SUMMARY
- 10+ Years Professional Experience as Business system Data Analyst with strong knowledge of E - Commerce in Retail, Banking and Sales Business Channels with experience in B2B, B2C, Sterling OMS and Ecommerce portals web application development.
- Proven success as a business system Data analyst through the years, providing a well-balanced understanding of business relationships, requirements and technical solutions.
- Working expertise of industry standard methodologies including Business Process Modeling (BPM), Rational Unified Process (RUP), Waterfall, Spiral and Agile with SCRUM.
- Experience in data visualization, ad-hoc reporting and building and publishing insight generating dashboards with Tableau, etc.
- Strong understanding of project lifecycle and SDLC methodologies like, Waterfall, RUP and Agile.
- Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams) as a business analysis tool for solution functional design
- Working knowledge in Anti-Money Laundering (AML), Suspicious Activity Reporting (SAR), Customer Risk Scoring (CRS) and Know Your Customer (KYC).
- Experienced in using project management tool JIRA.
- Experience in conducting Joint Application Development (JAD) sessions with end-users, expert team, development and QA team for project meetings, walkthroughs and customer interviews.
- Experience in developing using ETL (Informatica) and Cognos Business Intelligence Suite with multiple data sources like Oracle, MS SQL and DB2 databases
- Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
- Exposure to Client/Server, Web Application developmental tools and Software development and design.
- Strong experience in integrating using messaging middleware, WSDL and XSDs as used in system integration layer.
- Developed SQL queries as part of data analysis and QAT effort
- Assisted Business Stakeholders perform end-to end testing as part of UAT effort.
TECHNICAL SKILLS
Internet Technologies: HTML, CGI, Java Script, VB Script, SOA, .Net, Webservice
Databases: MS SQL server, MS Access, Teradata, ERwin
Office & Reporting Tools: Word, Excel, Rational Rose, RequisitePro, RationalSODA, Clearquest, Rational ClearCase, CrystalReports
Software Modeling Tools: Rational Rose 2000, Microsoft Visio 2000
Operation systems: UNIX, Windows NT, Windows 7
General Office: MS Office, XL, PPT, MS SharePoint, MS Outlook, Lotus Notes.
Languages: C, C++, Java, Python, Visual Studio 6.0, VB 6.0, Java, MS- XML 3.0, SQL
PROFESSIONAL EXPERIENCE
Confidential - Riverwoods, IL
Sr. Business Analyst
Responsibilities:
- Work closely with the internal strategy and modeling teams to understand the new strategies being put in place to either allow or reject consumers to be pre-approved for a credit card and personal loan.
- Good understanding of reading credit reports.
- Create and upload daily prepaid credit card requests for processing.
- Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
- Conducted audit on credit profiles of consumers.
- Conducted JAD sessions and elicited customer requirements by organizing interviews with internal/external stakeholders and subject matter experts (SMEs).
- Coordinated and managed all aspects of Scrum project (Product Backlog, Sprint Planning, Daily Standup, User Stories sizing).
- Documented the Business Requirement Document to get a better understanding of client’s business processes of both the projects using the agile methodology.
- Good knowledge of JD Edwards and SAP for account configuration, billing, financial modeling and reporting.
- Gather requirements, update and create customer databases.
- Helped ensure that the validated production application met Credit Card industry compliance requirements.
- Facilitated scrum ceremonies in Agile Scrum Methodology as Scrum Master and responsible for solving impediments, conflicts and conducting the various ceremonies.
- Manage and maintain credit card templates, images and embossing files.
- Translated statement of work into business and system level requirements using Agile methodology.
- Business Systems analyst for multiple Agile Scrum Teams consisting of 12 members, operating 2 weeks sprints.
- Worked in testing projects for mainframe applications, internet banking applications, Graphical User Interface (GUI) based applications and credit card transaction authorization using simulators.
- Process Flow Development and Documentation. Prepare User Stories for Scrum Team Refinement.
- Work with both Front End and Back End Development teams as well as UX to ensure that identified user story acceptance criteria had successfully been met.
- Work with other Product Owners and Managers to priorities business stories
- Coordinate and Manage the migration of Epics, user stories, and bugs to a JIRA backlog
- Create multiple backlog queries and developed dashboards in JIRA to provide real time performance data to the scrum team as well as senior leadership
- Work closely with the vendor developers and help them understand the strategy team needs.
Confidential - Austin, TX
Sr. Business Analyst
Responsibilities:
- Experience from Front to back office, worked with fund managers, financial advisors and technical team members.
- Responsible for Tuning and Optimization for the AML and Project management department.
- Analyzed and studied Credit Card process and regulations to be complied for card services in detail.
- Worked on integrating the credit card processing system with the new strategic exposure calculation engine to generate credit risk metrics.
- Played major role in writing lower level and upper level Use case.
- Adept at writing data mapping documents, data transformation rules, maintaining data dictionary, data migration documents and interface requirements documents.
- Review, maintain, update and disseminate AML / Compliance Policies &Procedures.
- Create and maintain data model/architecture standards, including master data management (MDM).
- Responsible for the valuation and development of credit card products.
- Worked on data modeling and produced data mapping and data definition documentation.
- Wrote SQL statements to extract data from the Tables.
- Develop, coordinate and oversee BSA Risk Compliance and related initiatives to meet regulatory guidelines and related Board and operational policies & procedures.
- Writing data mapping documents, data transformation rules and maintaining data dictionary, data migration and interface requirements documents. Able to update Microsoft share point portal with the updated project documentation.
- Used the ETL processes of Data Stage tool to load data from DB2 and Oracle, into the target Teradata database.
- Worked on Master Data Management (MDM) for maintaining the customer information and also for the ETL rules to be applied.
- Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Servicing, Loan Origination, MBS, CMBS, and Secondary Mortgage Market
- Worked deeply into laws and regulations related to BSA /AML, OFAC, and FCPA and the ability to apply this knowledge in gathering and reviewing the documentation requests.
- Administer training to external end-users on Data Governance procedures and master data functionality.
- Maintain awareness of regulatory changes in the BSA/AML arena which may affect assigned business lines and ensure appropriate communication and development of appropriate policy/procedure(s) changes to remain in compliance.
- Oversee the management of the data governance KPIs and quarterly reporting.
- In-depth interaction with Primary markets, Secondary markets and mortgage backed securities and asset backed securities for requirement gathering.
- Made the changes the Policy Administration system to report to FRAUD AML system whenever any fraud is encountered.
- Aimed at significantly improving the efficiency and effectiveness of the firm’s global credit risk, interpretation, definition and implementation of Basel II requirements, and amplifying exposure management activities.
- Assisted project team in preparing Functional Specification Document (FSD), developed non-functional requirements, and documented Business Requirements Document (BRD).
- Prepared detailed design documents to translate business process effectively for developers and product managers using MS Visio.
- Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.
Confidential, Kansas city, MI
Business Analyst
Responsibilities:
- Address all aspects of the loan lifecycle, starting from identifying a deal right up to loan closure.
- Used standard Business Analysis methodology centered on RUP (Rational Unified Process). Responsible for eliciting and gathering business user’s requirements.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
- Experience from Front to back office, worked with fund managers, financial advisors and technical team members.
- Developed a Financial Systems Datamart and a Customer Information System (CIS) Datamart as components of the data warehouse.
- Extensively performed data modeling.
- Responsible for Tuning and Optimization for the AML and Project management department.
- Analyzed and studied Credit Card process and regulations to be complied for card services in detail.
- Worked on integrating the credit card processing system with the new strategic exposure calculation engine to generate credit risk metrics.
- Played major role in writing lower level and upper level Use case.
- Adept at writing data mapping documents, data transformation rules, maintaining data dictionary, data migration documents and interface requirements documents.
- Review, maintain, update and disseminate AML / Compliance Policies &Procedures.
- Used SQL to communicate with the databases.
Confidential, Herndon, VA
Business Analyst
Responsibilities:
- Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case VOB
- Captured requirements for monthly SL to GL postings, calculating GL beginning and ending balances.
- Captured Data flow diagrams and formatting of the data flowing through interfaces.
- Accumulated system requirements from various departments like accounting, IS (Information Systems) through surveys and interviews.
- Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
- Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word.
- Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
- Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
- Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
- Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
- Facilitated user acceptance testing and test strategies with Information Systems Group.
- Performed manual front-end testing to check all functionalities of different modules.
- Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
- Trained the future users to coordinate their activities vis-à-vis CORD system.
- Assisted the SA to document all custom and system modification after the SCR’s were satisfactorily solved.
- Created and managed project templates,use case project templates, requirement types and traceability relationships in Requisite Pro.
Confidential, Madison, WI
Business Systems Analyst
Responsibilities:
- Responsible for defining the scope and implementing business rules of the project, gathering business requirements and documentation.
- Prepared Business process documents, project management process Documents, Functional Specifications, project plans, methodology and scope documents, release plans, upgrade plans and production support documents.
- Interacting with the Business Users and Prototyping the modules Service requests, Accounts, and contacts.
- Gathered requirement from E-commerce clients to prepare Business Requirement Document (BRD), Functional Requirement Document (FRD), functional specifications, use cases, conceptual modeling, and guided technical team in new custom development and enhancement.
- Interacted with the clients and the architect for gathering the functional requirements and documented them. Identified Use cases from the requirements and wrote Use Case Specifications.
- Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
- Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
- Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
- Assisted with the BRD for the Point-Of-Sale (POS) implementation project
- Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
- Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using modeling tools.
- Performed Data Analysis of existing data through SQL.
- Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
- Created surrogate key tables to map the required dimensions.
- Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project.
- Carried out defect tracking using Clear Quest.
- Maintained proper communication with the developers ensuring that the modifications and requirements were addressed and also monitored these revisions.
- Involved in compatibility testing with other software programs, hardware, Operating systems and network environments.
Confidential, NJ
Business Analyst
Responsibilities:
- Learned about eCommerce and different types of payment methods for conducting the same.
- Form the requirements and using technologies such as JavaScript, XML, LDAP, AML language (similar to XML), and TIBCO configure and provide custom enhancements to the client.
- Liaison between the client and development team to support the client’s data analysis and reporting needs.
- Involved in setting up different configuration environment for compatibility testing and manual testing.
- Gather requirements for the listed options risk management system, specifically for index options risk management spreadsheet.
- Defining requirements for product control and risk management end of day feeds.
- Wrote Test plan and Test cases for the Integration testing and system testing.
- Analyzed existing data and used tools available to successfully forecast the pricing models.
- Use Cases and other Process Flow Models were designed using MS Visio and Rational Rose.
- Constructed Use Cases and Wireframes and translated them into a Functional Requirement Specifications document
- Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.