Systems/data Analyst Resume
Seattle, WA
SUMMARY
- Over 7+ years of Extensive work experience a Business Analyst in various industry domains such as Banking, Mortgage, Insurance, Investments and commercial lending.
- Finalized 7 major vendor contracts through meticulous negotiations encompassing mutual benefits between vendor and the corporation.
- Tracked business goals using key performance indicators and balance scorecards and effectively communicated it to the leadership team to facilitate decision making.
- Significantly improved customer satisfaction scores and consistently doubled the number of positive responses every semester. Proactively worked with staff and faculty and was re - elected periodically to continue.
- Highly experienced in Defining, Gathering, Documenting, Managing requirements by conducting Joint Application Design (JAD) sessions and translating them to technical requirements.
- Experienced in working with Financial institutions, Equity Markets, Derivative Markets, Portfolio Analysis, Mortgage loan servicing, Loan Origination, Annuities.
- In depth knowledge of Rational Unified Process (RUP), Agile and other traditional development methodologies, along with the Unified Modeling Language (UML), Use Case.
- Excellent Analytical skills to understand the Business and Functional Requirements and communicated effectively with upper management and developers.
- Experience through all phases of the System development life cycle (SDLC) including analysis, development, black box testing and implementation. Experienced in performing GAP analysis.
- Proficient in interacting with Stakeholders, Subject Matter Experts (SMEs), System Analysts and Technical team with excellent communication and interpersonal skills. Experienced with Data mapping, data modeling, data migration, metadata and data flow diagrams.
- Excellent skills in writing Business Requirements Document (BRD), Use case Document, Functional Requirement Document (FRD) and Requirement Traceability Matrix (RTM).
- Experience in Graphical User Interface (GUI) design, wire frames, prototypes, screen mock-ups, site navigation models.
- Expert in using PERT techniques in activity diagrams.
- Solid understanding of Conceptual and Logical Data models and Created use case scenarios, process flows and functional & system specification.
- Highly experienced in drawing Entity Relationship Diagram (ERD). Conducted User Acceptance Testing (UAT) with stake holders and business users.
- Highly experienced in broad range of technologies including business process tools such as MS Project, MS Office Suite and MS Visio.
- Exceptional problem solving and sound decision making capabilities, recognized by alternative solutions, and confident, accurate, decision-making. Excellent track record for meeting deadlines and submitting deliverables on time.
- Excellent Communication skills with ability and willingness to work towards the business and technical requirements of clients and users.
- Exceptional flexibility and ability to work independently and in a team acting as liaison between management and development team for requirements.
TECHNICAL SKILLS
Operating Systems: Linux, Macintosh, Win, Unix
Project Management: MS Office Suite 03/07, MS Project 03/07
Business Modeling: MS Visio 03/07Forecasting: SPSS, Excel data analysis
Business Intelligence: Excel data analysis, Crystal Reports
Finance/Accounting: MS Money, Quick Books, Quicken
Database/Query: MS SQL Server, MS Access, Oracle, SQL, MySQL, Visual FoxPro
Programming language: HTML, DHTML, XML, ASP, PHP
Cloud/SAAS Solutions: Salesforce
Web Analytics: Omniture SiteCatalyst
Life cycle management: Adobe Acrobat Pro
PROFESSIONAL EXPERIENCE
Confidential, Seattle, WA
Systems/Data Analyst
Responsibilities:
- Coordinating with technical teams and product owners to define and understand reporting requirements.
- Gave input to project management activities throughout the project life cycle, influencing scope, charter, risk plan, project plan, issues and status.
- Created wire frames for website requirements, and worked with UX Designers and developed detailed prototypes and use cases.
- Generating SQL queries to capture reporting data from SQL server. Providing Excel based statistical analysis and creating pivots tables and charts for business reporting and assistance in data driven decision process.
- Worked extensively with media management software for creating slotting groups for proprietary media assets
- Implemented online contract document interactivity with databases using document lifecycle management software.
- Obtaining a thorough grasp of the business process that is being followed in the project environment.
- Extracting the business requirements from the end users keeping in mind their needs for the application and managing them using Rational Requisite Pro.
- Involved in gathering and documenting the requirements that were critical to the business process and using those requirements to design application software using a Use Case approach.
- Elicited demands from the stakeholders and analyzed them for consistency, flexibility and completeness.
- Extensively involved in Performance measurement and Client reporting.
- Prepared Business Workflow models that cover "How" business processes are accomplished.
- Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of Rational Unified Process effort in different iterations and phases of the Software Development Life Cycle.
- Extensively involved in writing use cases to narrate the functionality of the application.
- Used Microsoft Visio for complete process modelling using UML to create Use Case diagrams, Activity diagrams, Sequence diagrams and Process Flow diagrams.
- Played a substantial role in the process identification, definition and functional requirements gathering, in an effort to develop a practical technology solution.
- Prepared and analyzed AS IS and TO BE workflow scenarios, designed new process flows, and documented the business process and various business scenarios, activities of the business from the conceptual to procedural level.
- Used iRise for a mockup application simulation and feedback during the JAD sessions.
- Used Rational Clear Case as a Configuration Management Tool
- Involved in converting the User requirements into business requirements, functional requirements.
- Non-technical specifications included creating proper documentation and clear illustration of the requirements for the benefit of Project management, subject matter experts and test users.
- Mainly used Test Director for bug tracking and Reporting and also for reporting defects.
- Extensively involved in User Acceptance Testing (UAT).
Confidential, New York, NY
Business Analyst
Environment: Oracle, PL SQL, Rational Requisite Pro, Rational ClearCase, Rational ClearQuest, DOORS, Mercury WinRunner, Microsoft Visio, ERwin3.5.2
Responsibilities:
- Worked with a team of 4 Business Analysts.
- Was an integral part of business process redesigning.
- Interacted with the stakeholders to get a better understanding of client business processes and gather business requirements.
- Was involved in the complete SDLC process
- Created business process workflow diagrams (Activity diagrams) for theGAPas-isand to-be process inVisio,Rational Rose.
- Created Business Use-Case Model and Business use Case specifications after accessing the status and scope of the project and understanding the business processes.
- Producedfunctional specificationsand led weeklyJADmeetings with development consultants and business units to discuss outstanding technical issues and deadlines
- Created and managed use-case templates and traceability relationships inRequisitePro.
- Managed all the requirements (Business and Application use cases) in RequisitePro, making requirements available to all team members and to maintain traceability between requirements, design and UAT test cases.
- Visualized complex data structures usingERwinand established enterprise-wide standards for managing data
- PreparedLogical Data ModelsusingERwinthat contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
- Managed and controlled change usingClearQuest, associated requirements to specific change request/enhancements/defects and made sure that other teams were following the change requests guidelines.
- Linked business processes to organizational objectives, performed critical path analysis, and identified opportunities for business process improvement.
- Supported with Quality Assurance Analyst with logging the test cases and their results and developed testStatusReportsforStakeholder review.
- Supported the QA team by assisting with automated testing sessions using WinRunner and logging and maintaining the results via a traceability matrix.
- Updated the issues log with all issues identified during UAT and created defect tickets in ClearQuest for all defects and enhancements identified during UAT.
- Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes using the Rational ClearQuest.
Confidential, Herndon, VA
Business Analyst
Responsibilities:
- Gathered user and business requirements through interviews, surveys, prototyping and observing from portfolio managers and UI (User Interface)
- Worked with Project manager, created Work flow diagrams, Activity Diagrams on MS Visio/MS Project using Program Evaluation and Review Technique (PERT) technique.
- Conducted Joint Application Development (JAD) sessions for requirements gathering with Business Stakeholders, SME’s, Users, refined it using Wireframes, mock ups, Context Diagrams, Use Case Diagrams and made conceptual illustrations for scenario focused engineering.
- Reconcile the tax information from generated reports, balance sheets, and general ledger accounts and post and prepare journal entries (J.E.).
- Worked on the initiating of the loan for the REO through loan origination system including the financial documents required.
- Worked on reconciliation of the accounts related to the tax difference between the REO and NREO properties.
- Coordinated with business users to prepare, update Business Requirement Documents (BRD) and Functional Requirement Documents (FRD). Created Use Cases documents for requirements
- Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
- Involved in creating data models for the data warehouse and specify data mapping documents from specific data sources.
- Worked in the development phase of the projects and prepared test scripts and test plans.
- Scheduled meetings with developers, SAs (System Analyst) and testers to collaborate resource allocation and project completion using MS Project.
- Conducted process improvements, status meetings, presided over the Changed Control Board meetings to discuss Defect and Enhancement.
- Conducted UAT and Coordinated with the QA Team for the sign-off process before deployment and assisted the Project Manager on creating the Lessons learned document.
- Created Ad-Hoc financial reports for the top management using Ms Excel.
Confidential, Wilmington, DE
Business Analyst
Environment: MS Office, MS Project, MS Visio, Oracle, Windows NT, LINUX, HTML, Web based tools, Windows/Unix, Load Runner.
Responsibilities:
- Conducted interviews with key business users to collect requirement and business process information.
- Performed gathering, analysis, review and signoff of business requirements and conducting of interviews, sessions etc
- Created Process flows based on the requirements to define the user interface and written activity steps.
- Documented the Business requirements into the Functional specification document.
- Have participated in Requirements Walkthroughs, Defect Review Meetings, and Status Meetings.
- Supervised and developed documentation effort from an analysis standpoint. Utilized Use Cases, Stated requirements documents, feature specifications, workflow diagrams etc throughout the analysis phase of the project.
- Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed.
- Performed Gap analysis to determine the as is system, documented the Gaps and consulted the development team and project manager to fix the issues.
- Re-engineered the system to document the User interface based on the current functionality of the application.
- Made Screen Mockups/Definitions using MS Visio.
- Experienced setting up test scenarios and executing on these scenarios and worked closely with testing team to make sure all the changes made to requirements documents are implemented in their Test Cases.
- Involved in maintaining the Requirements Traceability Matrix (RTM) across the deliverables for a Project.
- Worked closely with lead to create the Impact matrix to document the impacts on other blocks.
- Worked with application development team to identify bottlenecks that could hinder progress of development.
- Collaborated with developers as needed to determine the root cause of defects
- Checked validation of the application against the requirements
- Involved in meetings and walkthroughs.
Confidential, Windsor, CT
Business Analyst
Responsibilities:
- Organized, conducted JAD sessions for requirements gathering. Prepared Business Requirement Documents and Functional requirement Documents.
- Worked extensively on the Life Insurance, Fixed Income products like Annuities and Account Opening Modules, categorized customer base with the extensive services provided by Confidential Financials.
- Created Requirement Traceability Matrix to maintain all the requirements extracted from the Users, Stakeholders, made sure all the documents are being accounted for.
- Developed Context Diagrams, Wireframes, Swim Lane Diagrams, mock ups, which helped in Rapid prototyping and pinpointing potential problems early in the process.
- Coordinated with Project Managers, Developers, SME’s to design, create Work Flow Diagrams using MS VISIO.
- Have been a part of Pre-Sales effort by giving recommendations to categorize and organize the customer database in a more effective manner.
- Involved with the requirements, design, development, and administration of transactional and analytical data constructs/structures.
- Conducted Data Archiving, Data Mapping and involved in receiving the Data Feed from updated Data Sources.
- Worked in the development phase of the projects and prepared test scripts and test plans.
- UAT was carried out with prospective users, Conducted status meetings, any Defect and Enhancement
Confidential, Los Angeles, CA
Business Analyst
Responsibilities:
- Gathered user and business requirements through interviews, surveys, prototyping and observing from portfolio managers and UI (User Interface)
- Creation of the functional requirements specification from the business requirements. Participate in JAD Session with the business users.
- Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software.
- Prepared logical Data Models that contains set of diagrams and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
- Performed GAP analysis for the application to identify the AS-IS and TO-BE business process to improve the process in the project.
- Planned and defined system requirements to 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.
- Worked on Wire frames during the Elaboration Phase Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
- Scheduled meetings with developers, SAs (System Analyst) and testers to collaborate resource allocation and project completion using MS Project.
- Created Mock-up forms in MS Access for better visualization and understanding of the software solution. Regularly worked with the CMA (Content Management Application) and CDA (Content Display Management) teams.
- Worked in the development phase of the projects and prepared test scripts and test plans.
- Assisted the SA to document all custom and system modification Assigned problems to appropriate software development team for fixes
- Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro.
- Authored progress and completion reports which were then submitted to project management on a weekly basis.
- Helped in carrying out the UAT as per the perspective of the users.
