SUMMARY

• Senior Business Analyst with over 7 years of experience with full project life cycle experience in Mortgage Banking, Financial industry, and Hospitality Services.
• Diverse experience in Information Technology and Software Development life cycle that includes requirements gathering, design, analysis, regression analysis, development, testing, implementation, UAT coordination, and production support for data warehouse projects.
• Expertise in large - scale business rules driven technology using rule engines.
• Familiar with client/server, and web application development tools; software development methodologies, and design techniques.
• Experience in Commercial Off-the-Shelf (COTS) software system implementation in evaluating and selecting COTS solution
• Strong experience with SQL, Visio, Requisite Pro, ClearCase, Remedy, RUP, UML, and MS Project.
• Recent experience includes data analysis, mapping, and data reconciliation and creating SQL scripts for data validation, reports, data migration, data conversion and ETL transformation verification.

TECHNICAL SKILLS

Languages: Java and J2EE based applications programming, UNIX Shell programming, Perl Scripting, SQL, PL/SQL, Visual Basic (VB), HTML, DHTML, XML

Applications: Ab Initio, Access, MS Project, PowerPoint, Visio, Dreamweaver, Informatica, DataStage, AquaLogic 6.x, Oracle Apps EBS

Databases: Oracle 9i/10g, Sybase, SQL Server

Methodologies: Rational Unified Process (RUP), Waterfall, JAD/RAD, eXtreme Programming, SDLC Process, SCRUM

Other: UML, Use cases and Use case diagrams, Data Flow diagrams, Entity Relationship Diagrams, corporate data dictionary

PROFESSIONAL EXPERIENCE

BUSINESS ANALYST

Confidential, Washington, DC

Responsibilities:

• Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR).
• Liaised with business and functional owner during high-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Performed GAP analysis of business rules, business and system process flows, user administration, and requirements.
• Ensured all artifacts complied with corporate SDLC Policies and guidelines.
• Aided management in standardizing Web applications by preparing GUI standards and recommending alternatives for in corporation in phased, iterative manner.
• Developed use cases, workflow, screen mock-ups, and conversion requirements, business process models, and use case diagrams.
• Created Reporting specification, which involved mock-ups, data mapping, and generating details.
• Performed UAT as well as sourcing analysis-using SQL.

BUSINESS ANALYST

Confidential, Washington, DC

Responsibilities:

• Work with business for gathering requirements.
• Developing Spotfire Reports based on the requirements.
• Involved in creating supporting SDLC Documents for the reports such as Requirements Document, Solutions Specifications.
• Involved in creation of test steps for the UAT of the reports and reviewing with the business, QA, and developer.
• Performed UAT testing for the Spotfire reports and Created supporting documents such as RTM Shakeout test and Test Execution Results.
• Coordinated cross-functional activities with the functional team, development team, conversion team and technical architecture team to execute application and integration activities.
• Updating Reports with fixes to meet the Business requirements as a result of testing.
• Assisted with post deployment testing and issue tracking via remedy.
• Assisted in identifying GAAP with COMPASS and traders practices. Maintained change requests and issues with COMPASS via remedy.
• Responsible for Business, Functional, and Data Requirements for the customization and integration of the COTS Product: COMPASS

BUSINESS ANALYST

Confidential, Washington, DC

Responsibilities:

• Work with business for gathering requirements.
• Involved in creating deliverables for the functional requirements such as use cases, process flow diagrams, context diagrams, and reports specifications document under SCRUM methodology.
• Managed the change request process, involved gathering and prioritizing them.
• Involved in data mapping effort for the interface as well as reporting needs.
• Involved in understand of current SAS programming interfaces to understand the GAAPs and functionalities that can be leveraged.
• Performed unit testing for the code releases.
• Reviewed BA deliverable with the development, and testing teams; assisted in creation and verification of the QA test plan, strategy, and test cases.
• All Bugs were documented via HP Application lifecycle Management 11.0, involved in prioritizing, and resolving them on a regular basis.
• Involved in creation of test steps for the automation team.

BUSINESS ANALYST

Confidential, Washington, DC

Responsibilities:

• Created of production publishable units consisting of Legacy as well as Ad-Hoc reports created via excel macro scripts.
• Involved in data mapping as part of ODS data warehouse.
• Assist with documentation of UAT Test Plan, Test Strategy, and Test cases for the applicationADWLoans Release 11.10 viaMercuryQualityCenter.
• Involved in the creation of RTM to verify the current project requirements are being met and tested adequately.
• As per UAT, perform Backend testing to various data warehouses to ensure the new fields can be accessible and are reporting the data as per transformation logic applied via toad.
• As per UAT, identify / create scenarios to retrieve information from the business objects universe create and verify that information is correctly represented on the BO reports generated.
• Upon UAT, assist in production validation of the application, which requires creation and verification of production checklist for the application to ensure the changes are deployed correctly, additionally provide an exceptions handling mechanism for soft stops as well as hard stops foreseeable to encounter on the application.

BUSINESS ANALYST

Confidential, Washington, DC

Responsibilities:

• Handled requirements gathering and converted functional requirements into technical specification documents in deliverable-based, stressful environments throughout the entire SDLC.
• Performed in customer facing roles; including meeting with users and business owners to identify functional requirements, as well as user privileges, to enhance usability, etc. for both customer facing websites.
• Performed detailed functional requirements, usability documents, sign-offs documents, requirements traceability matrix, use cases, technical specifications, data dictionaries, scope documents, mock-ups screens in MS Visio, and has updated/edited visual flow diagrams.
• Analyzed current business requirements and developed solutions specifications for high-availability, high-performance business rules management system.
• Evaluate alternative designs and recommend optimal solutions.
• Knowledge transfer sessions with the development team while the SharePoint site was under development for UAT testing purposes.
• Generated weekly status reports via MS Access / MS Excel.
• Understanding the Data dependencies, Business Logic, Reporting needs, for Data Validation and report generation.
• As part of UAT testing, involved in validating the report generated via SharePoint to the MS Access version.Documenting any discrepancies with the reports and prioritizing for current or deferred for future releases.
• Creation of Test Plan, Test Case Specifications,Test Data, Identification Exit Criteria, Post Production shakeout testing steps, shakeout Test completion document for the PLS Loss Mitigation Status Report, Project Tracker Report via SharePoint / SQL Server database.
• Documenting Business Requirements Document as well as creating / updating MS Access database for Invoice reconciliation of each vendor on a monthly basis.
• Involved in weekly discussion with the litigation department and the underwriters for progress in individual projects and verification of these changes reflected in the reports.
• Worked closely with the vendors for reconciling any data issues indentified and updating the Data requirements, if needed for them.
• Remedy was used for Change Management.

BUSINESS ANALYST/UAT

Confidential, Sterling, VA

Responsibilities:

• Built and authored system requirements related to software/applications development.
• Translated business requirements into functional design documents.
• Built and authored use cases as they relate to business requirements.
• Participated in technical design workshops.
• Assisted with analytical study on CRM practices, industry CRM trends and CRM business needs.
• Assisted with process improvements upon understanding Client needs, conducting inbound/ outbound calls, handle emails, faxes and mails effectively.
• Worked with business partners to develop new business processes supporting Confidential .’s service and offerings.
• Document materials for UAT training, this includes but not limited to UAT test cases, UAT test Scenarios, and UAT Test Plan.
• Assisted in documentation of training materials required subsequent to release for end users.
• Strong commitment to challenge and solve problems faced by our clients.
• Documented maintained and prioritized items on the issue log and communicate agreed upon changes to the development, QA and UAT teams.
• Involved in getting CM approvals for all functionality changes agreed upon for a release.

IT ANALYST

Confidential, Raleigh, NC

Responsibilities:

• Worked with users gathering requirements to define and validate test objectives, test conditions and test scripts for Oracle Administrator and Oracle Enterprise Budgeting and Planning.
• Performed quality assurance on setup and configuration of Oracle Administrator and Oracle Payables.
• Executed applications and integrations testing for Oracle Administrator, Oracle Enterprise Budgeting and Planning, Oracle General Ledger and Oracle Payables.
• Executed applications and integrations testing for Custom Financial Statements and Adjustment, and Footnotes module. Verified and ran reports for custom set of books created to match the requirements.
• Conducted structured walk-through with Education stakeholders to review test objectives, test conditions and test scripts.
• Participated in the conference room and enterprise pilot to confirm the business process for the Oracle Financials 11i implementation.
• Manage test documentation, test results, issues and defects through Clear Quest and Test Manager.

SR. BUSINESS ANALYST / UAT LEAD

Confidential, Herndon, VA

Responsibilities:

• Involved in understanding and creating requirements for applications end-to-end functionalities. Gathered and documented business requirements and managed requirements using Doors. Documented Data, Functional, and Interfaces requirements.
• Created Mock up screens using Visio for displaying data in the AquaLogic portal from different applications. Created requirements as to how the data was retrieved in the portal using stored procedures and web services.
• Involved in identifying various segments that will be displayed on the app and combining those functionality from usability perspective.
• Acted as main point-of-contact (POC) for business, development and testing teams for all the requirements related issues. Assisted project manager in maintaining issues and action items lists. Documented and maintained project related activities, including meeting minutes, release documents, project schedules etc, on share point site. Managed change request (CR) process using the Tracker tool.
• Led UAT (User Acceptance Testing) effort by creating UAT Plan, Test Cases and UAT summary report as part of the standard project deliverables documentation. Created RTM (Requirement Traceability Matrix) to associate Test Cases and requirements (UAT), Used Mercury Quality Center tool to manage defect tracking.
• Identified, named, defined and modeled numerous data elements in RMTM database tables using Erwin and mapped new/existing data for upload. Performed data analysis, validations, and analyzing data quality issues using SQL scripts.
• Involved in analyzing/interpreting ER diagrams, data dictionary and data models from various source systems for data mapping activities.
• Involved in identifying the gold source, and flow of accounting transactions in the upstream general ledgers.
• Created requirements for time dimensional reports, including quarterly and monthly summary reports. Helped reports developers in understanding data elements and business knowledge for creating reports with proper diagrams and charts, for upper management.
• Validated the monthly and the ad-hoc reports generated by the application using Business Objects.
• Used Remedy tool to manage production tracking.
• Verified reports data in excel spreadsheets against the database.

Environment: Ab Initio, Oracle 9i/10g, Shell/Perl Scripts, WebFocus, Sun Solaris Servers, Quality Center, Remedy, DOORS, MS Visio, MS Project, Business Objects

SYSTEMS ANALYST / UAT

Confidential, Rockville, MD

Responsibilities:

• QA of renewals process which involves creating test data for maintaining Firms, and Individuals accounts balances via PeopleSoft.
• Executed Win runner Scripts for test data creation.
• UAT testing of XML portal for web CRD inclusive of documenting updates to the application variables and successful unit testing.
• Validation of Business rules applied to the reports generated via CRD.
• Writing / updating SQL scripts for testing new functionality / code via toad.
• Documenting test cases and test results via doors.
• Performed data analysis and validations using SQL.
• Created reports using SQL, PL/SQL, and UNIX for daily and monthly registration statuses.
• Managed change request (CR) process using the tracker.
• Created Test Plan / Test Scenario / Test script and provided Test results for QA.
• Tested Ad-hoc reports developed using Oracle, SQL, PL/SQL, and UNIX.
• Assisted in RTM (Requirement Traceability Matrix) to associate Test Cases and requirements (UAT).

Environment: .Net, XML, SQL, PL/SQL, ERwin, UNIX, Oracle 9i/10g, TOAD, Requisite Pro, Tracker