OBJECTIVE

• An opportunity as a Software Business Analyst where I can utilize my business system analysis, quality assurance, program development and training experience

SUMMARY

• Over seventeen years of experience in information technology, telecommunication, financial, banking and transportation industry participating in medium to large projects
• Strong knowledge of BABOK, PMBOK, Zachman Framework, Agile, Waterfall and RUP business methodologies
• Experienced with a variety of techniques for gathering and documenting requirements such as, JAD, MoSCow, prototyping, business process maps, use cases, system flow diagrams and entity relationship diagrams
• Experienced in CMMI processes, managing JAD sessions, Project Management Life Cycle and Software Development Life Cycle including system analysis, design, testing and implementation of software applications
• Strong analytical and product development skills with emphasis on business problem solving, including a thorough understanding of how to interpret customer needs and translate them into application and operational requirements
• Experienced in relational database development and SQL programming
• Proficient in technical background in analyzing complex processes and executing test scripts in .Net applications, Web UI, web services
• Excellent communication, documentation, interpersonal and organizational skills
• Dynamic leader with proven business analysis and quality assurance experience in strategy planning and efficient task analyzing

TECHNICAL SKILLS

Platforms: Windows 95/2000/NT/XP/Vista, MS DOS, Unix, Mainframe/MVS

Languages: SQL, PL/SQL, XML, JCL, UML, BPMN for Business Analysis

RDBMS: ORACLE Personal/Server, MS SQL Server, SSAS, SSRS, MS Access

Software: MS Project, MS Visual Studio, MS Test Manager 2012,MS Visio, Sparx Enterprise Architect, Power Designer, IBM Cognos BI, IBM Rational Tools, IBM Rational Requirements Composer, MS TFS, MS PowerPoint, MS Excel, Crystal Reports, MS SharePoint, MS Dynamics CRM, HP Quality Centre

PROFESSIONAL EXPERIENCE

Sr. Business Analyst Consultant - E-BUSINESS / IT

Confidential

Responsibilities:

• Performed analysis of Complaint Module requirements to be developed in Health Inspection System
• Elicited Business requirements conducting JAD sessions and Interviews with SMEs and remote Public Health Unit users through screen mock-ups and presentations
• Created Business Requirements and System Requirements specifications, Use Cases, Process and Data flow diagrams
• Translated business systems requirements into technical specifications for software development
• Provided Business Analysis assistance to developers during software development phase
• Collaborated with Business Users and SMEs to develop and update Business and Solutions requirements
• Participated in department’s new application design walkthrough and statuses updates meetings

Sr. Business Analyst Consultant - E-BUSINESS / IT

Confidential

Responsibilities:

• Performed GAP analysis of OPP systems, systems functionalities of MTO COL, WRPS and OPP CRS applications to define current and future functional capabilities needed to develop OPP Integrated Collision Reporting System to be implemented on mobile platform of Single Data Entry - reporting of Collision on the collision scene by OPP Officer (Blackberry, tablet)
• Participated in creating of Business Case, performed the Cost-Benefits and Risk Assessment analysis of proposed solution, participated in development of presentations to executive management
• Performed risk and impact analysis of new system development, used estimation with Risk Analysis and mitigation strategy techniques, SWOT technique of new software development
• Used functional decomposition and Business Process Re-engineering techniques for system analysis of electronic data enter and transfer to MTO RUS Collision System process. Developed Data Mapping documents for MTO and OPP business data on MS Visio and Excel tools, documented Business Rules
• Collaborated with MTO Business Analysts on daily basis to clarify and define MTO Collisions Business Rules and participated in Production UAT testing activities
• Conducted JAD, Focus and workshop sessions through screens mock-ups, one-to-one interviews with business users and SMEs to gather, update and review business, systems and solution requirements
• Created User Stories and Test Cases in MS Team Foundation Studio tool, assigned tasks to Development team
• Translated business systems requirements into technical specifications for software development team: developed various business artefacts, Functional Requirements Specification, Design Specification, Process and State diagrams with swim lanes for cross functional users, User Stories, Data Models diagrams, Entity Relationship diagram
• Analysed database tables and associations with developing and executing SQL queries in MS SQL database, developed data mapping for migration data from Legacy to new developed eCRS system and migration plan; analysed current metadata and repository functions; participated in defining Data Dictionary
• Participated in defining of release scope prioritizing of requirements based on business values, risks and implementation difficulties
• Developed Change Management document for Software development project’s phases, prepared Presentations and Business Requirements documents for various stakeholders
• Developed various Statistical reports using IBM Cognos BI tool from OPP users business requirements
• Created Test Plan and Test Scenarios, Requirements Traceability Matrix of OPP Integrated Collision Reporting System, participated in UAT activities
• Provided Business Systems Analysis support during software development phase in application’s testing, implementation, monitored the progress and logged defect in MS TFS 2013 tool
• Developed User’s manual and quick guide documentation, performed presentations and provided training to users
• Reported status to and followed overall direction from Management

Business Analyst Consultant - E-BUSINESS / IT

Confidential

Responsibilities:

• Analyzed current “As-Is” and developed new “To-Be” business processes of New Online Registration, Financial part of Private Career College system, prepared business flow diagrams, built the flow chart diagrams using “rules based logic”
• Conducted JAD sessions through mock-ups screens, Focus group meetings and requirements workshops with Stakeholders to elicit and gather requirements participating in PCC system modernization project
• Participated in development and presentations to stakeholders of new PCC prototype model integrated with OSAP application developed on Oracle platform
• Created Process, State, Activity diagrams with swim lanes in Power Designer for improving process of placing and revising TCAF bonds, Accounts Reconciliation, New Registration and Annual Renewal processes in Financial department
• Developed Mock-ups for prototype model, Built Process, Cross-Functional, State and Activity diagrams, Business Object Catalogues in Power Designer for improving process of placing and revising TCAF bonds, Accounts Reconciliation, New Registration and Annual Renewal processes in Financial department
• Coordinated and performed UAT activities of Child Care application and logged defects in MS Test Manager v.12 tool, performed Handshaking/Connectivity testing of multitier application
• Participated in department’s new application design walkthrough and statuses updates meetings

Sr. Business Systems Analyst Consultant - E-BUSINESS / IT

Confidential

Responsibilities:

• Gathered Business requirements, translated them into Functional Design Requirements and prepared System Requirements Specifications with Use Cases, screens, business process flow diagrams and descriptions for component based TELECOM OSS/BSS solutions of Customer Management - ICM (CRM application), Order Management systems integrated with legacy system participating in Enterprise enhancements project
• Analyzed system interface of Account Maintenance, Payment, Billing, Provisioning systems in Enterprise Business Transformation system for developing capabilities matrix in Reward program project
• Prepared functional requirements specifications participating in Enterprise new release project with Enhanced Payment Splitter and Consolidation process for different accounts functionalities in Billing Life Cycle; for enhancements of billing process in Telecom - Billing system to interface with new system of Reward program - Blue Loyalty project
• Analyzed data and created data presentation using MS Excel tool with building Pivot tables, multi-layer charts, used VB Macros and built reports
• Performed Solution Design functional decomposition, mapping User Stories and Solution Requirements to application’s components in complex architectural design, participated in building sequence diagram with Use Case mapping
• Prepared Business Artifacts, technical specifications, documented Business Rules, Detailed Test Plans traced to Functional Requirements in IBM Rational Requirements Composer tool for Solution Acceptance
• Participated in developing of Detailed Design Specification document, Use Cases, Design Sequence and Cross-Functional diagrams using UML on Sparx Enterprise Architect software tool
• Led group of 4 Business Analysts for creating solutions acceptance business artifacts, mapping business, solutions requirements to Business Capabilities and Solutions Components (SAS) in eCommerce Sales and Service Portal project built on JAVA/J2EE/Weblogic architecture including mobile version of Sales and Service Portal with online payment
• Created User Stories for Buy, Install/Activate, Billing Customer Life Cycles in Sales and Service Portal project that impacted Telecom-Call Center (Customer Interaction Management), Telecom - Billing modules functionalities built on IBM CRM software application in Agile environment
• Developed templates for SRS, Detailed Design Document; requirements traceability matrix for Functional, Non-Functional requirements, User Acceptance and Integration Test Cases to ensure application’s full test coverage with MS Excel
• Administered and managed business documentation repository, documented records and document management rules in MS SharePoint tool
• Participated in department requirements workshops to scope, discover, define and prioritize Functional Capabilities in Business Requirements Document

Business Analyst Consultant - E-BUSINESS / IT

Confidential

Responsibilities:

• Reviewed, analyzed and evaluated business process, systems and users’ needs, prepared Business Case with Project Cost Estimation Sheet, Software Requirement Specifications, built Cross-Functional and Business Workflow Diagrams with UML for Ontario Rural Planning Management System developed with MS Dynamics CRM 11.0 integrated with Client Portal Online Registration website and mobile Field Investigation module software development
• Created User Stories and mapped them to Application’s components
• Built logical and physical data model diagrams on MS Visio tool
• Met with customers to elicit and verify Business requirements conducting interviews, requirements workshops, translated them into Functional and Non-Functional requirements
• Analyzed current Patient News software program functionalities, identified gaps/opportunities, performed risk assessment for process improvements in future (“To-Be”) system design and enhancements developed on MS Dynamics CRM, performed procurement planning for MS Dynamics GP from third party company
• Conducted workshops and JAD sessions with stakeholders to discuss software development process, manage business requirements through all phase of the project
• Prepared Test Scenarios and Test Cases for Patience News program built on MS Dynamics CRM 2011 integrated with e-business Client Portal system
• Created and updated Test Scripts using MS Visual Studio 2010 Team Suite
• Wrote User Manual Guide and software release documentation
• Participated in users and Quality Assurance Analysts training
• Performed various software testing activities, identified and resolved software systems issues

Business Systems Analyst - E-BUSINESS / IT

Confidential

Responsibilities:

• Led project for migration of large data from legacy system for Confidential: participated in extracting, transforming, loading data to Data Warehouse on SQL Server Integration Services (SSIS) for banking and financial institutions, gathered data and business requirements, developed data mapping specifications, Business Plan, Test Scenarios, performed testing and monitored the migration process
• Participated in Business Case development, created System Requirements Specification of Debtors Payment Website (developed using Web Services on JAVA (J2EE) platform ), analyzed and verified payment transactions for different banking institutions, analyzed data and root caused problems for urgent issues in production environment
• Participated in creating, storage, migration, preservation and disposition of records in information management software applications (MS SQL database) for various financial clients
• Analyzed data writing and executing MS SQL scripts and queries, reports to customers, process of transactions to populate the database and in-house applications
• Created financial reports and performed data analysis using MS Excel with developing complex formulas and multi-layer charts, SSRS Reports and SQL Server Analysis Services(SSAS)
• Gathered requirements using Survey/Questionnaire technique with closed and open-ended questions for remote users, conducted Focus group sessions
• Elicited and wrote functional and technical requirements for business process workflow (CRM- eCollect core application) developed with EAI/ESB architecture on Microsoft BizTalk Server, prepared Test Plans and documentation for users
• Participated in meetings and JAD sessions with stakeholders and SME to manage requirements for software applications developments
• Used IBM Rational Rose tool with Rational Unified Process method, managed requirements repository and requirements traceability matrix for Business artifacts, documented records and management rules in MS SharePoint tool
• Provided training and performed presentations of software application new features and enhancements to users and stakeholders
• Coached and mentored 4 QA Analysts performing various technical and user acceptance testing activities, created test strategy, test plans through all phases of data migration to DWH (Sybase data to MS SQL Server)
• Participated in configuration of business process workflow developed in MS .Net 4 environment and prepared Test Plans and documentation for users
• Reported issues in HP Quality Center

Business Systems Analyst Consultant - E-BUSINESS

Confidential

Responsibilities:

• Worked in Agile Scrum, fast paced environment for development and customization of software application
• Created and updated business, functional, non-functional requirements for Fleet Complete and Courier Complete application developed using Web Services on Java platform, mobile applications with Confidential technology for monitoring contractors, invoicing and online payments
• Was responsible for analyzing the business needs of an application and making suggestions for design improvement
• Developed Test Plan, managed and executed the core activities of the test effort, monitored the test coverage and evaluated the overall quality of the test cases and the outcome of the testing conducted in each test cycle
• Participated in Unit, System, Integration (Handshaking/Connectivity) application, UAT testing of Fleet Complete and Courier Complete
• Documented Business requirements, Test Scenarios through reviewing, analyzing and evaluating business system and user needs for software development and testing purposes using MS Excel and MS TFS tools
• Participated in JAD sessions with developers and stakeholders

Business Associate - E-BUSINESS/IT

Confidential

Responsibilities:

• Prepared business process models; used MS Visio to create Class, Activity, ERM diagrams; analyzed, documented and reviewed business requirements
• Participated in business analysis and development of Use Cases, User Stories, Test Plans and Test Scenarios for functional and system testing according to requirements for development of Billing Module in web-based Confidential Construct Job (third-party add-on application), Enterprise applications
• Was responsible for coordinating tasks, managing and mentoring of test executions and results in QA team
• Performed database analysis and testing on SQL Server 2005
• Validated technical design created by IT developers against functional specifications
• Worked with QA team to design Test Plans and Test Cases for User Acceptance Testing (UAT) in HP QC Test Lab and Plan Modules, MS SharePoint
• Participated in different kinds of testing like Functional, System Integration, Installation, Regression and Ad-Hoc tests for fixes and enhancements of Construct Job, Enterprise Resource Management and Database Manager applications
• Identified, tracked and resolved variances in testing issues, bugs and risks in HP Quality Center, AdminiTrack test tools
• Participated in test results walkthroughs and presentations
• Identified of root cause of problems of application’s defects and configurations issues
• Coached and mentored QA Analysts

Business-Quality Assurance Analyst - E-BUSINESS/E-COMMERCE/IT

Confidential

Responsibilities:

• Developed Business Requirements, prepared System Requirements Specifications, Use Cases for Confidential Project Portfolio Management, CRM and System Manager applications, MS Exchange Outlook integration - Business to Business eCommerce Web Service
• Analyzed current “As-Is” system developed on Lotus Domino and participated in development of new “To-Be” system, created various business artifacts with screenshots and diagrams on MS Visio tool
• Participated in data migration project of migration data from MS SQL to Oracle database mapping tables and developing business documentation.
• Run queries using MS SQL and built Reports for database testing
• Analyzed business data using OLAP in Data Warehouse for troubleshooting of applications integration
• Prepared and maintained test plans according to Confidential product customization and extension for several customers
• Was Subject Matter Expert of Project Portfolio Management, Resource Management, MS Exchange Outlook integration modules of Confidential application and facilitated knowledge transfer within QA and development teams
• Executed unit/integration testing of Functional test scripts of application developed on various languages such as, French, Korean and German
• Participated in verification, validation and acceptance testing for Automation Tools Team using Mercury WinRunner, performance and stress tests in LoadRunner tool
• Participated in unit/integration, verification, validation and user acceptance testing, performance and stress tests in LoadRunner tool
• Tested Report Designer tool which involved several SQL views and queries
• Used Mercury Test Director bug tracking system for testing issues
• Participated in test results walkthroughs and presentations
• Analyzed root cause problems of application defects and configurations issues
• Documented business and technical requirements for Confidential application on Pocket PC and Palm OS
• Participated in creating user’s training manuals for new applications and develop help files to meet users needs

Systems Programmer Analyst E-COMMERCE / FINANCE

Confidential

Responsibilities:

• Developed, tested E-Commerce, Client-Server applications for trading (TD Waterhouse)and insurance companies
• Maintained, enhanced and implemented banking application ( Confidential, Confidential Bank) using JCL scripting on Mainframe/ MVS platform
• Participated in validation of accounting entries in batch file feeds
• Used manual and automated testing tools (IBM Rational Tools)
• Analyzed user requirements and developed solutions to customer’s production problems

Programmer Analyst

Confidential

Responsibilities:

• Developed and customized application on SAP MDM platform
• Analyzed, developed and maintained application for transportation system using COBOL on UNIX/AIX, NCR platforms

Application Developer

Confidential

Responsibilities:

• Created, tested and debugged reporting application from Change Management System using MS Access, Oracle, PL/SQL, Power Builder 5.0.03

Programmer Analyst

Confidential

Responsibilities:

• Developed programs for telecommunication application using macro assembler (Electrostation department)
• Designed and developed test procedures using JCL on IMS platform (Accounting department).
• Coded in COBOL, DB2, Micro Focus COBOL on Unix, MVS platform for payroll and other accounting applications
• Designed local PC database using MS Access. Developed Visual Basic GUI front end for inventory control application