OBJECTIVE:

Seeking permanent - full time position as Lead Technical Business Systems Analyst

SUMMARY:

• Experienced with Business Requirement Analysis. System Analysis, Quality Assurance Analysis, Risks Analysis, Impact Analysis, Data Analysis, Master Data Management Analysis, Gap Analysis, Trend Analysis, & Variance Analysis.
• Experienced with Project Management, Project Portfolio Management, Release Management and Change Management Process.
• Experienced with writing Business Requirement Document (BRD) and Functional Specs Document (FSD)
• Experience with Business Intelligence Reports
• Experienced with Report Creation, Data Modeling, and Data Extraction from external sources
• 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 Mobile Phone Quality Assurance Testing iPhone and Android Mobile Phones
• Experienced with Infrastructure Planning, Analysis and System Upgrade
• Experienced with UML, Use Cases and As-Is & To-Be Models
• Experienced with Amazon Cloud Databases
• 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 Informatica
• Experienced with MySQL

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, MS SQL server 2005, 2008, 2012, 2014 & 2016 with SSIS, SSAS, SSRS.
• PL/SQL Developer for Oracle, Oracle OraHome92, Toad for Oracle and SQL Server, DB2 and AS400 iSeries, PeopleSoft, Report Builder 3.0 and MySQL
• MS Office 2010 & 2013 - Word, Excel, PowerPoint, MS Visio, MS Project, MS SharePoint, Informatica version 10

PROFESSIONAL EXPERIENCE:

Confidential, Moorpark, CA

Systems Analyst - Level V

• Working on Loan Servicing, Loan Origination, Letter automation, Billing & Escrow Statement Generation, System Migration & Web development projects which include a special project for transformation of MSP Legacy System application into a SQL Server & Dot Net Platform based Web Application
• Responsible for leading the ongoing development and analysis efforts and managing the project.
• Create Functional Specs Document.
• Project Management of the assigned tickets that includes effort estimation for Life Cycle of the Project.
• Write Use Cases and create UML Diagrams using MS Visio
• Provide direction to onsite & offshore developers & QA Analysts
• Review the QA Test plans & UAT plans
• Act as liaison between business & technical teams
• Gather business requirements from Line of Business
• Perform requirement analysis
• Create Functional & Technical Specs that includes the API Design and the Database Specs
• Create UI wireframes and mockups
• Use AS-IS & TO-BE approach
• Create Use Cases
• Work closely with Development team to redesign and re-engineered the database and Dot Net ERP & CRM Application Design
• Create test case scenarios and test cases
• Work in Local and AWS Cloud SQL Server Environments
• Work on network issues related to company website and SQL databases
• Provide analysis support for SQL Server Infrastructure & Database Migration
• Perform analysis on issues related to SQL Server & Websites Firewalls
• Support the Web & Mobile API Design efforts
• Perform QA on Web and Mobile API that includes system integration testing
• Write SQL Queries to perform Systems analysis and QA analysis, and Import of External Data into SQL tables
• Work with SQL Server ETL, SSIS & SRS Packages
• Design PDF Documents using HP Exstream Dialog Software.
• Migration of Oracle 11g & MySQL databases to AWS Microsoft SQL Server 2016 Environment
• Design Business Intelligence Reports using Tableau and Snowflake
• Review the code for SQL Stored procedures
• Make recommendations for code fix
• Setup JAD session with technical & business teams
• Work on cross platform team projects
• Conduct facilitation meetings with line of business & Business Partners to discuss the current issues within the system
• Perform Post Deployment Quality Assurance validation
• The tools used are MS Office 2013, MS Visio Professional, Google Drive, Google Docs & Service Now
• Worked Agile/Scrum Environment for existing Application enhancements and used full SDLC for the new Projects
• Worked on Datawarehouse, Data Mapping, and Data migration projects using Informatica version 10.2.0

Confidential, Monterey Park, CA

Senior Business Systems Analyst

• Responsible for performing analysis on Federal Reserve Bank business logic for Commercial Loans Audit
• Communicate with Internal Corporate Clients to gather business requirements.
• Perform analysis on business requirements and analyze the Commercial Loan accounting rules
• Create Change Requests based on new Commercial Loan accounting logic
• Perform systems analysis on existing Oracle PL SQL Code Logic
• Write Oracle SQL Queries to plugin the new Federal Reserve Bank logic for Commercial Loans.
• Setup facilitation meeting to discuss the project and new design issue
• Work closely with Development team to modify and develop the SQL code
• Provide Enterprise Level Support

Confidential, El-Segundo, CA

Senior Business Systems Analyst

• Perform analysis on the Service Requests for the enhancements to existing and new BI Reports. The reports contain the data for TWC accounting and Billing System which uses various billing & discount codes. The report data is stored in ODS Platform.
• Conduct project & facilitation meetings with end users using WebEx and MS Outlook.
• Gather detail business requirements from the Business Owner, and identify the detail specs for the report.
• Perform Master Data Management Analysis
• Perform GAP analysis.
• Use AS IS and TO BE Models for the report.
• Perform work estimates using JIRA Planview System.
• Write complex TSQL/SQL and Netezza Queries to perform data analysis and the report column mappings.
• Create Business Requirement Document (BRD), and obtain the BRD approvals from the Business Owners.
• Move the Service Request to Development Queue for the report development.
• The reporting tools used; MS SQL Server SSIS, SSRS, MS Repot Writer, Netezza, MicroStrategy, and AAHA.
• The office tools used; MS Office, MS Visio, MS Project, JIRA Planview Project Management Tool, MS Outlook, WebEx Online Meeting Tool, and Remedy Online Service Desk System.

Confidential, Agoura Hills CA

Senior Business Systems Analyst

• Provide Project Planning and Project Management support that includes creation of Project Plan & Impact Summary Documents, mapping of Project Quality Assurance (PQA) lists & managing the PQA process to maintain the Quality Standards, Project Portfolio Management and Document management
• Provide high level cost estimates for design based on the number of estimated effort hours provided by each team & size of the requirements, and provide comparison between the actual versus estimated efforts after the task is complete
• Manage SharePoint & Discovery websites
• Identify the Project Scope from the Project Charter
• Gather Business Requirements & User Stories from Line of Business Group which includes Product Owners, and Stakeholders
• Accountable for ensuring user stories to have acceptance criteria.
• Proficiently helped development teams to break down large user stories for execution.
• Advised product owners, scrum masters and teams to improve their ability to create good product backlogs.
• Actively assisted in the acceptance and validation of the stories by testing the delivered stories.
• Create web design wire-frames and conceptual design mockups
• Create web design work-flows
• Create High Level Design for Application (HLD) Development & Migration Projects
• Create Accelerated Change Document (ACD) for System Upgrade and System Migration Projects
• Provided ITIL/ITSM support for Service Requests, Incident Management, Problem Management, Change Management, and Root Cause Analysis during the application and system upgrades process.
• Provided support for improvement of ITSM Service Delivery Process & Design
• Perform Impact Analysis and evaluate the magnitude of the change
• Perform Business & Requirement Analysis on the Functional Requirements
• Act as Liaison between Technology and Line of Business Teams
• Create Use Case Diagrams and Write Use Cases
• Create current and target state process diagrams
• Perform GAP Analysis using As-Is & To-Be process models
• Work closely with Infrastructure & Application Development Teams to define detailed Technical & System Requirements
• Perform Systems Analysis on the Technical Requirements
• Perform Master Data Management Analysis, Data Analysis & Data Comparison to troubleshoot the Reporting and Data issues by analyzing the Microsoft SQL Tables, and writing the SQL/T-SQL Queries
• Create Reports using MS SQL Server Report Builder 3.0
• Work as liaison between business owners and technical teams.
• Facilitate the project meetings.
• Conduct technical JAD sessions with project teams
• Review Test Plans, and coordinate the efforts for Component Integration Testing (CIT), System Integration Testing (SIT), and User Acceptance Test (UAT)
• Coordinate the Defect Management Efforts
• Create Traceability Matrix to track the efforts
• Review Deployment Plans
• Upload Project Documents to SharePoint Project Repository
• The tools used for the project are: MS SQL Server Management Studio, MS Office 2010 (Word, Excel, Power Point, and MS Visio), MS Project 2010, MS SharePoint 2010, CA Clarity, Nexus, PPRT, HP Quality Center, Remedy and Discovery
• Methodologies uses; Waterfall, Agile-Scrum

Confidential, Santa Ana, CA

Senior Business Systems Analyst

• 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
• Perform GAP Analysis using As-Is & To-Be process models
• Create Conceptual Design & Functional Specification Document - CDD. Provide support to Developer to complete Low Level Design Document (LLD). Work closely with Java & Dot Net Development team, and provide guide lines for 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). Update Usecases & create UML diagrams
• Work as liaison between business owners and technical teams. Facilitate the project meetings. Conduct technical JAD sessions with technical teams
• Create Test Case Scenarios & Test Case Strategy. Gather defect report and test results from testing teams, and manage defect issues.
• Create Traceability Matrix. Lead UAT efforts. Capture XML Data using beyond compare software tool. 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. Use SharePoint project repository to manage project documents. Use MS Project to create project plans and milestones.
• Run Oracle PL/SQL Queries to generate reports data sets using Toad for Oracle. Run TSQL Queries to generate reporting datasets. Create Business Intelligence Reports using Cognos, MS Access & MS Excel tools to forecast future trends,
• Perform Master Data Management Analysis
• Use SOX Compliance. Used Agile Methodology. Work with Offshore Teams
• The tools used for the project are: MS Office 2010 (Word, Excel, Power Point, MS Access and MS Visio), MS Project 2010, MS SharePoint 2010, CA Clarity, HP Quality Center, HP PPM, Service Now, Team Foundation Server

Confidential, Los Angeles, CA

Senior Business Systems Analyst

• 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 User Requirements/User Stories. Create Functional Specification Document (FSD)
• Conduct business meetings with business owners. Obtain clarification on the business requirements
• Work on the Functional Specs documents. Upload Scanned Images and documents to EMC Documentum eRoom website. Write Oracle 11g queries to perform data analysis using Toad for Oracle and Toad for Data Analyst. Create reports using Cognos. Perform field mapping between Oracle and DB2 Legacy tables. Perform data analysis and data mapping. 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-Scrum Methodology

Confidential, Calabasas and Agoura Hills, CA

Senior Systems Analyst

• Estimate efforts and timeline for the deliverables, 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. Manage Defects, and report Defects in the SharePoint Defect Log.
• Write MS SQL/AS400 iSeries Queries to validate the data and perform data analysis. Perform reporting analysis using Microsoft SQL Server Analysis Services. Create Datasets for Business Intelligence Reports using ANSI SQL/TSQL Queries, SQL Server ETL, SSIS, SSAS, SSRS, Oracle PL/SQL, and Cognos Reporting Tool was used to run reports. Perform Master Data Management Analysis 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 Confidential 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. Perform Post Deployment Production Validation support.
• 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, Los Angeles, CA

Senior Business Analyst

• Analysis of Business Process Design Requirements. Modify the 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, Agoura Hills CA

Senior Systems Analyst

• Worked on Home Affordable Modification Program (HAMP) Project with Confidential Mortgage Service Technology Group, and provided support for Government regulatory reporting projects. The duties included Requirement & Systems Analysis, HLD Creation, SQL Server Reporting support, TSQL Queries,System Integration Test & UAT support.

Confidential, Westlake Village CA

Senior Business Systems Analyst

• Supported the Business Systems Analysis of Dole Cargo Container Inventory & Sales Order Management Web Site Project. Analyzed the problems with Oracle Sales Order Management, Pricing, and Cargo Inventory Databases, and provided solutions. Run PL/SQL Queries to generate reports using Toad for Oracle.
• Generate reports using Cognos. Work with Offshore Teams

Self Employed

• Performed Internet sales of Computer and Mobile Phone Accessories
• Language Translations and Interpretations

Confidential, Torrance, CA

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, Westlake Village, CA

Senior Business Systems Analyst

• 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
• Supported testing efforts on ACH Wire transfer modules for Vendor Payments.
• Supported Sarbanes & Oxley Act & IT Audit 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
• Worked with Offshore teams.

Confidential, Rosemead, CA

Senior Business Systems Analyst

• Worked the following projects: 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, Pasadena, CA

Senior Programmer Analyst

• Project Management - Define Scope, Objectives, Project Plan, and manage projects. Gather requirements. Performed requirement & systems analysis
• Performed Web/Client Server/Desktop, and Database Application Development & Coding, Provide support for the web services. 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 Compliance, FDA, Compliance efforts. Worked with Offshore Teams
• Tool used: MS Office Lotus Notes, Vantive Service Request System, Remedy, and Niku Project Management Tool