We provide IT Staff Augmentation Services!

Business System Analyst Resume

San Jose, CA

SUMMARY

  • Business Analyst with 7+ years of diverse IT experience in Financial and Insurance Services, Consumer Risk and Credit Analytics.
  • Good understanding of various fixed income, annuities, mutual funds, pension funds, tax - deferred and after-tax annuities, IRAs, brokerage accounts, and Asset management.
  • Expert in documenting functional specification for business process improvement and automation, data modeling, and system architecture.
  • Proficient in transforming business requirements into functional specifications, focusing on workflow analysis and design, business process reengineering, UI design, portal design, and process flow modeling.
  • Highly skillful in conducting/coordinating requirements gathering session (RGS), Joint Application Development (JAD) sessions, and brain-storming sessions with subject matter experts (SME).
  • Extensive experience in producing UML data models, creating Behavioral diagrams (Activity diagram, and Sequence diagram) and Structure diagrams (Class diagram and Data flow diagram).
  • Expert in preparing Business Requirement Document (BRD), Functional Requirement Document (FRD), Use Case Document (UCD), and Test Case Document (TCD).
  • Working knowledge in writingSQLquery for identifying databases involved in the application development.
  • Worked with leading IT Insurance, Healthcare, Retail, Mortgage and Banking Clients during my tenure asBusinessAnalyst/ RequirementsAnalyst.
  • Knowledge ofAS400Power MHS, Foresight EDI Validator, Ultra Edit and interface/outboards operations, SQL within SAS Enterprise Guide.
  • Intuitive understanding of business processes and efficient in performing GAP analysis, SWOT analysis, Root-Cause Analysis, and Impact Analysis.
  • Strong knowledge of SDLC including Waterfall and Agile methodologies.
  • Proven ability in defining, preparing, and documenting entire Testing Life Cycle (TLC), and User Acceptance Test (UAT) plan.
  • History of excellence in Data Modeling, Data warehousing, Data Analysis, Quantitative analysis, Reporting processes, Data Migration, Creating Dashboards, and End-user Training.
  • Strong business acumen, strategic thinking, communication, interpersonal and presentation skills, adept at creating, editing, and coordinating extensive communication networks.
  • Creative and Self-Starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

TECHNICAL SKILLS

Operating Systems: WINDOWS XP/ 2000/ 2007/ VISTA

Databases: MS-Access, MySQL, Oracle, SQL Server, Sybase, Teradata, OLAP

Data Modeling Tools: UML 2.0, Power Designer 16.0, PeopleSoft 9.2, Rational Rose, MS Visio, Gliffy

Office Suites: MS Word, MS Excel, MS Access, MS PowerPoint, MS OneNote, MS Projects

Communication Tools: MS Outlook, Lotus Notes

Document Management Tools: SharePoint, Clear Case

Defect Tracking Tools: Silk Central, JIRA, Quality Central

Business Intelligence Tools: Hyperion, Business Objects, AS400, Cognos

Messaging: IBM MQ Messaging,SWIFTMessaging (SWIFTAlliance Access,SWIFTAlliance Gateway), SIDE Reporting & Viewer (Eastnets), Unix Shell Scripting, SQL Oracle, MSSQL

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Business System Analyst

Responsibilities:

  • Gathered business requirements, analyzed business process, collected data from various sources, analyzed data, and monitored performance.
  • Translated business requirements to functional requirements and technical specifications with help of Data flow diagrams (DFD) for developers.
  • Attendedagileiteration sessions and present a report on the status of various TFS tasks for the iteration
  • Analyzed research data withUXteam, generated insights about user goals, needs and pain points using affinity diagrams.
  • Facilitated brainstorming sessions with Product andUXteams in concept generation and feature ideation. Executed end-to-endUXdesign for multiple departments: Product, Marketing, Enterprise, e-Commerce, and cross-channel publication.
  • Responded and took action to address issues initiated from the User Stories, category and pricing leadership; this includedretailchanges, new items, discontinued items, scanning problems, reporting and other miscellaneous request.
  • Manipulated, cleansed, and processed data using Excel, Access, and SQL; Wrote SQL queries for data extractions.
  • Analyzed economic data using statistical tools like SAS, SPSS to ensure data quality.
  • Provided all requirements gathering support for theagileteam.
  • Produced Requirements traceability matrices (RTM) to support the application development, and control changes on requirements.
  • Executed database queries inSQL, worked with XMLs & performed E2E verifications for mobile message services.
  • Running database & writingSQLqueries.
  • Created user stories for all bank owned development including changes toAS400and middleware components.
  • Performed GAP analysis for new application requirements and prioritized them based on the business needs to identify critical features required for each release.
  • Assisted the Quality assurance (QA) team in writing, executing the Test plans and Test cases.
  • Ensured that the test cases, test script, and test scenarios covered all the points mentioned in the business requirement document (BRD) and functional specification (FRD).
  • Worked on post production validation (PPV) to ensure that all the enhancements worked smoothly.
  • Assisted business users with User Acceptance Testing (UAT) and received sign-offs on the new application.

Environment: MS Office (Word, Excel, Access, PowerPoint), Teradata, SQL, JIRA, SAS, SPSS, MS Outlook.

Confidential, New York, NY

Business/System Analyst

Responsibilities:

  • Conducted brainstorming sessions with business users and SMEs to gather business requirements; additionally, facilitated Joint Requirements Planning (JRP) sessions to better understand the business domain, requirements, and project scope.
  • Create, analyze and present sales comparison,retailmanagement, movement, Inventory and margin impact reports to optimize profitability and evaluate effectiveness of marketing programs.
  • Facilitated data mapping exercises to understand data flow, compliance, and regulatory requirements with respect to liability balances (BASEL II, US GAAP, and IFRS, SOX).
  • Documented business requirements and functional specifications with mockups to explain in detail the business implications and impacts.
  • Coordinated with documenting processes usedagilemethodology to write theBusiness Requirements documents and designed Functional specifications.
  • Created sequence diagrams and dataflow diagrams using UML to facilitate better understanding of the process.
  • Interacted closely with designers and software developers to understand application functionality, facilitate data migration, as well as updated them about end-user sentiments.
  • Involved in preparation of test plans and test strategy documents and documented entire testing processes, test cases, and test results.
  • Attended JAD sessions to understand the impact on other lines of business.
  • Conducted feasibility analysis for automation of reports and inclusion into the dashboard.
  • Conducted training sessions to train business users in using the PEARL (Business Objects) reporting application.
  • Worked on the post implementation support while the application was in production.

Environment: MS Office (Word, Excel, Access, PowerPoint), Hyperion, Business Objects, UML, RUP, MS Outlook, Quality Central.

Confidential, Washington, DC

Business/System Analyst

Responsibilities:

  • Interacted with SMEs, securities traders, and business users to gather requirements and understand the business process. Conducted controlled brain-storming sessions with project focus groups.
  • Involved in gathering and synthesizing business requirements and translated them into functional requirements to be used as input for design specifications.
  • Mastered knowledge of securities lending business (including trading in equities, fixed income products) in order to document business requirements accurately. Also gained expertise with security reference data in investment management.
  • Utilized SDLC Agile Scrum methodology for overall project management and implementation.
  • Acted as liaison between the SME’s and the technical teams; handled scheduling, resource planning and allocation matters, as well as conducted status meetings and compiled reports.
  • Extensively worked on documenting user requirement specifications and business process; additionally assisted in developing system requirements.
  • Implement weekly reports utilizing Oracle Analysis studio and ad-hocSQLqueries.
  • Designed data flow diagrams and data process models to present a better view of the system that enabled the technical team to identify key processes.
  • Contributed to customization, enhancement, update, and changing functionalities of the reports using Cognos.
  • Carried out specific data processing and statistical techniques using SAS/ SQL.
  • Worked on Bloomberg terminal to update daily security values for NAV calculations.

Environment: MS Office (Word, Excel, Access, PowerPoint), SQL, Bloomberg, Cognos, RUP, MS Outlook.

Confidential, San Diego, CA

Business/System Analyst

Responsibilities:

  • Collaborate with system analysts, software engineers/ architects, and the business users to develop both high-level and detailed application models that meet the business needs.
  • Provide overall business systems analysis and design support; including system testing.
  • Studied and assessed the clients systems and business processes.
  • Developed project plans and managed scope.
  • Set-up and maintenance of agent information within theAS400with accuracy
  • Used Rose and Visio to model the process using the UML to create Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Sequence Diagrams and Collaboration Diagrams.
  • Used SQL queries to filter data within the SQL Server.
  • Worked with different Subject Matter Experts (SME’s) to define and gather requirements for Life and Annuity Insurance.
  • Transformed XML data to various types of documents.
  • Involved in converting the User requirements into business requirements, functional requirements and also created business process models from the requirement specifications.
  • Worked with user groups to provide training, resolve questions, assess user needs and recommend changes.
  • Developed status reports and other project communications.
  • Provided key input in working with users in defining project and system requirements.
  • Performed functional testing and User Acceptance Testing (UAT).
  • Developed user guide for the Policy Quotes and Claim functions and also part of the team reviewing the system document for production support.
  • Primarily acted as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.

Environment: MS Visio, UML, MS Excel, RUP, MS PowerPoint, Rational Requisite Pro, Quality Center, SQL

Hire Now