We provide IT Staff Augmentation Services!

Senior Business Systems Analyst Resume Profile

2.00/5 (Submit Your Rating)

Santa Ana, CA

OBJECTIVE: Seeking permanent-fulltime position as Senior Business Systems Analyst or Release Manager

SUMMARY

  • Experienced with Business Requirement Analysis. System Analysis, Quality Assurance Analysis, Risks Analysis, Impact Analysis, Data Analysis, Gap Analysis, Trend Analysis, Variance Analysis.
  • Experienced with Project Management, Release Management and Change Management Process.
  • Experienced with defining Test Cases and Test Scenarios for System Testing, and UAT.
  • Experienced with Quality Assurance System Integration Testing, Regression Testing, and UAT.
  • Experienced with Infrastructure Planning, Analysis and System Upgrade
  • Experienced with UML, Use Cases and As-Is To-Be Models.
  • Experienced with MS SharePoint Systems and Document Content Management Software.
  • Experienced with web services modules
  • Experienced with Release Management
  • Experienced with Business Process Development and Business Process Improvement.
  • Experienced with Agile and Scrum, RUP, RAD, CMMI, and SDLC - Waterfall Methodologies.
  • Experienced with Water SDLC and Agile Methodologies
  • Experienced with ITSM and ITIL and Service Delivery Process
  • Experienced with writing Business Requirement Document, Business Process Design Document, Functional Specifications Document, Technical Design Document, System Test Plan, Systems Test Scripts, UAT Plan, UAT scripts, Implementation Plan, User Help and Training Guide.
  • Experienced with Language Translations

TECHNICAL SKILLS

  • JavaScript, Java, Visual Basic 2005 and 2008,VB.NET, HTML, DHTML, XML
  • Operating Systems: Windows Administration, Windows NT/2000/XP/ Vista software installation, Android OS, Android Application Installation, Android Application Testing
  • Oracle 11g, SQL server 2005 and 2008 with SSIS, SSAS, SSRS. PL/SQL Developer for Oracle, Oracle OraHome92, Toad for Oracle and SQL Server, DB2and AS400 iSeries, PeopleSoft
  • MS Office 2007 and 2010 Word, Excel, PowerPoint, MS Visio,
  • MS Project

WORK EXPERIENCE

Confidential

Senior Business Systems Analyst

Worked on a ERP, Data Migration Web Service Project in SOA Environment for Corporate IT Department at First American Title Insurance Company. The goal was to save the company 3 million annually. Duties were as follows:

  • Gather Business requirements
  • Manage the project, plan the milestone, deliverables, and timeline
  • Facilitate and conduct project meetings to discuss the project issues
  • Perform Business Systems analysis, GAP Analysis, cost benefit analysis, and cost estimation
  • Create Conceptual Design Functional Specification Document
  • Provide support to Developer to complete Low Level Design Document LLD
  • Work closely with Java Dot Net Development team, and provide guide lines to developers
  • Perform GAP Analysis using As-Is To-Be process models
  • Design the interface diagrams
  • Design the Web Service components. The Web Service to be resided on Biz-Talk server using Service Oriented Architecture SOA
  • Define Usecases create UMLS diagrams
  • Facilitate the project meetings
  • Create Test Case Scenarios Test Case Strategy
  • Capture XML Data using beyond compare software tool
  • Lead UAT efforts
  • Perform data analysis data mapping
  • Work as liaison between business owners and technical teams
  • Create Traceability Matrix
  • Conduct technical JAD sessions with technical teams
  • Gather defect report and test results from testing teams
  • Use Service Now web application platform to create IT Service Request, Incident, and Problem Management tickets
  • Use MS Visual Studio Team Explorer running on Team Foundation Server to report the defects
  • User SharePoint project repository to manage project documents
  • Use MS Project to create project plans and milestones.
  • Use Cognos, MS Access MS Excel to create forecast reports
  • Run PL/SQL Queries to generate reports data sets using Toad for Oracle
  • Use SOX Complaince
  • Used Agile Methodology.
  • Work with Offshore Teams

Confidential

Senior Business Systems Analyst

  • Worked as Business Analyst at LAUSD IT Division, ISIS Integrated Student Information System Group, the duties were as follows:
  • Work on LAUSD Students CAIR Immunization Interface Upgrade Project
  • Work on LAUSD Student Tuberculosis Interface Upgrade Project
  • Work on LAUSD Student Record Payment Information System Upgrade Project
  • Create project charter and project plan
  • Estimate efforts and timeline for the deliverables
  • Define scope and milestones for the project
  • Gather business requirements from business owners, and perform requirement analysis
  • Perform Impact Analysis, Requirement Analysis, System Analysis, and GAP Analysis
  • Write Business Requirement Document BRD , Functional Specification Document FSD
  • Conduct business meetings with business owners
  • Obtain clarification on the business requirements
  • Obtain sign-offs
  • Conduct technical JAD sessions with technical teams
  • Perform data analysis and data mapping
  • Work on the Functional Specs documents
  • Upload Scanned Images and documents to EMC Documentum eRoom website
  • Supported web services
  • Write Oracle 11g queries to perform data analysis using Toad for Oracle and Toad for Data Analyst
  • Perform field mapping between Oracle and DB2 Legacy tables
  • Perform mapping between Oracle and Front-end Java applications. Work with Java and Back-end developers
  • Perform reverse engineering in front end java application to identify the backend Oracle tables
  • Used Agile Methodology

Confidential

Senior Systems Analyst

  • The duties were as follows:
  • Estimate efforts and timeline for the deliverables
  • Create project charter and project plan
  • Worked on Mortgage Fraud Prevention, Underwriting, and Govt. Bankruptcy- Legal Automation Projects.
  • Define milestones for the project, and manage the project
  • Gather business requirements from the line of business owners, and perform requirement analysis
  • Perform Impact Analysis, Requirement Analysis, System Analysis, and GAP Analysis
  • Write Business Requirement Document BRD , High Level Design HLD and Express Project document EPD
  • Write use cases, draw use case diagrams
  • Apply As-Is To-Be process models
  • Write Test Plans and Create Test Strategy for System Testing and UAT
  • Write Test Cases for System Integration Testing and UAT
  • Perform System Integration and Regression Testing
  • Report Defects in the SharePoint Defect Log
  • Perform Post Deployment Production Validation
  • Write MS SQL/AS400 iSeries Queries to validate the data and perform data analysis
  • Build reporting analytics using Microsoft SQL Server Analysis Services
  • Create Datasets for Business Intelligence Reports using MS SQL Server ETL, SSIS, SSAS, SSRS, Oracle PL/SQL, and Cognos Reporting Tool was used to run reports
  • Provide support for the web services
  • Supported the Infrastructure efforts for the project, and comply with ITIL and Service Delivery Principles
  • XML Loan Data Capture, Comparison and Analysis using Beyond Compare software
  • Manage system upgrade efforts for iOriginate loan application, and other loan underwriting applications
  • Create Test Loans in SIT Environment using Bank of America iOriginate and EDGE loan applications
  • Supported Test Efforts for Loan payment modules
  • Validate Loan Data in Artificial Intelligence website
  • Support data mapping for the reports
  • Support Data Warehouse projects to consolidate data at a centralized location.
  • Run Inline Reports to find manual corrections in Loan Ratios, validate the corrected data in CLUES and 1008 forms found on web application called Status Mart
  • Perform Underwriting Analysis
  • Conduct facilitation meetings
  • Conduct technical JAD sessions
  • Manage documents using SharePoint system and define SharePoint directories and folders
  • Track project performance using Nexus, Clarity, and Viper tools
  • Report defects using HP Quality Center
  • Use Remedy for Problem Management and Service requests, HP Tech-Direct for other Service Requests
  • Perform Release Change Management by creating Release Schedules, and following the Release dates for Dev to Test, Test to UAT, and UAT to Deployment Migration Phases for Bi-Weekly Releases
  • Create Change requests for additional business requirements, and update the release schedule
  • Perform Trend Analysis to forecast the future releases
  • Use Water SDLC and Agile Methodologies
  • Work with offshore teams as part of the project
  • Create Traceability Matrix
  • Provide weekly status report
  • Work with Offshore Teams
  • Apply SOX compliance

Confidential

Senior Business Analyst

  • The project is called Advance Meter which is an application, and will be used to run the wireless meter reading system. The following were the duties.
  • Analysis of Business Process Design Requirements
  • Design and Architecture of Database Models, and Business Process Models using UML 2.0, Archimate 1.0andBPMN 2.0 Modeling languages, MS Visio 2010, and Sparx Enterprise Architect Modeling tools
  • Analysis and Design of SharePoint and Infrastructure Architecture
  • Write Business Process Document BPD
  • Perform Business Analysis and GAP Analysis
  • Use Case and Activity diagrams
  • Work with As-Is To-Be process models
  • Import and Export of XML schema of the Data and Business Models
  • Reverse engineering of SQL Server database schemas
  • Provide solutions for complex process logic issues
  • Attend Requirement workshops
  • Conduct facilitation meetings with different architecture teams
  • Provide product support and training to end users
  • Tools used: Office 2010, MS Visio Professional 2010, and Sparx EA Modeling Tool.
  • Provide weekly status report
  • Apply SOX compliance

Confidential

Senior Systems Analyst

  • Worked on Home Affordable Modification Program HAMP Project with Bank of America Mortgage Service Technology Group, and provided support for Government regulatory reporting projects.
  • Create project charter and project plan
  • Estimate efforts and timeline for the deliverables
  • Gather business requirements from the line of business owners, and perform requirement analysis
  • Perform System Analysis
  • Design high level workflow diagrams
  • Write use cases, draw use case diagrams
  • Apply As-Is To-Be process models
  • Write Business Requirement Document BRD , High Level Design HLD and Express Project document EPD
  • Perform Impact Analysis, Requirement Analysis, System Analysis, and GAP Analysis
  • Work with Technical Delivery Manager and Development team to support the development efforts, and validate the Lower Level Design document
  • Coordinate the design efforts between stakeholders and development team
  • Conduct facilitation meetings
  • Conduct technical JAD sessions
  • Manage efforts for SQL Server 2008 migration upgrade.
  • SupportAS400 iSeries and MS SQL Server environment including ETL, TSQL, DTS, SSIS and SSRS packaging
  • Support data mapping for the reports
  • Support Data Warehouse projects to consolidate data at a centralized location.
  • Provide support for the web services
  • Build reporting analytics using Microsoft SQL Server Analysis Services
  • Create Datasets for Business Intelligence Reports using MS SQL Server ETL, SSIS, SSAS, SSRS, Oracle PL/SQL, and Cognos Reporting Tool was used to run reports
  • Write SQL Queries to validate the data and perform data analysis
  • Support Quality Assurance and System Integration Testing efforts to identify the defects and bug fixing
  • Supported the Infrastructure efforts for the project, and comply with ITIL and Service Delivery principles
  • Support the process improvement by applying ITIL principles of Service Management
  • Supported Loan Modification Payment Adjustment System
  • Manage documents using SharePoint system and define SharePoint directories and folders
  • Track project performance using Nexus, Clarity, and Viper tools
  • Report defects using HP Quality Center
  • Use Remedy for Problem Management and Service requests, HP Tech-Direct for other Service Requests
  • Perform Release Change Management by creating Release Schedules, and following the Release dates for Dev to Test, Test to UAT, and UAT to Deployment Migration Phases for Bi-Weekly Releases
  • Create Change requests for additional business requirements, and update the release schedule
  • Perform Trend Analysis to forecast the future releases
  • Use Waterfall SDLC and Agile Methodologies
  • Create Traceability Matrix
  • Work with Offshore Teams
  • Apply SOX compliance

Confidential

Senior Business Systems Analyst

  • Supported the Business Systems Analysis of Dole Cargo Container Inventory Web Site Project. The application was based on Microsoft ASP.NET 3.5 architecture, VB.Net Programming language, MS SQL and Oracle 9i PL/SQL. Provide support for the web services
  • Run PL/SQL Queries to generate reports using Toad for Oracle
  • Run reports using Cognos
  • Work with Offshore Teams

Confidential

  • Supported the Business Systems Analysis for small private businesses on part time bases, and evaluated their system automation needs
  • Performed online sales of Computer and Mobile Phone Accessories
  • Language Translations and Interpretations

Confidential

Senior Business Systems Analyst

  • Supported Business Systems Analysis efforts for Honda online Web Learning Management System, and Sales Finance Web applications. Supported Sarbanes Oxley act compliance efforts
  • Perform Release Change Management by creating Release Schedules, and following the Release dates for Dev to Test, Test to UAT, and UAT to Deployment Migration Phases for Bi-Weekly Releases
  • Create Change requests for additional business requirements, and update the release schedule
  • Perform Trend Analysis to forecast the future releases

Confidential

Senior Business Systems Analyst

  • Perform Release Change Management by creating Release Schedules, and following the Release dates for Dev to Test, Test to UAT, and UAT to Deployment Migration Phases for Bi-Weekly Releases
  • Supported Sarbanes Oxley Act IT Audit Compliance efforts.
  • Supported testing efforts on ACH Wire transfer modules for Vendor Payments.
  • Supported the Business System Analysis efforts for development of an ERP, Accounts Payable and Procurement Web Portal that is used for the automation of invoice payments to the Vendors using the SQL Server, Oracle, PeopleSoft Procurement and Payroll interfaces. Provide support for the web services
  • Create Change requests for additional business requirements, and update the release schedule
  • Worked with Offshore teams.

Confidential

Senior Business Systems Analyst

  • Worked the following
  • Online Event Management System
  • Online Billing Portal billing process improvement
  • Provided support for CMM Level 3 Certification Compliance
  • Worked with Offshore teams.
  • Perform Release Change Management by creating Release Schedules, and following the Release dates for Dev to Test, Test to UAT, and UAT to Deployment Migration Phases for Bi-Weekly Releases
  • Perform Trend Analysis to forecast the future releases
  • Create Change requests for additional business requirements, and update the release schedule

Confidential

Senior Programmer Analyst

  • Worked on various Health Care and Clinical Information Systems Projects
  • Gather requirements
  • Performed requirement systems analysis
  • Performed Web/Desktop, and Database Application Development Coding,
  • Provide support for the web services
  • Project Management Define Scope, Objectives, Project Plan, and manage projects
  • Worked on ERP, CRM, Membership Sales Marketing, IT Financial Services, and Clinical applications projects
  • Create Incident, Problem, Change and Release Management Databases
  • Perform Release Change Management by creating Release Schedules, and following the Release dates for Dev to Test, Test to UAT, and UAT to Deployment Migration Phases for Bi-Weekly Releases
  • Create Change requests for additional business requirements, and update the release schedule
  • Perform Trend Analysis to forecast the future releases
  • Supported the HIPPA, FDA, Compliance efforts

We'd love your feedback!