SUMMARY

• A seasoned IT technical consultant having 10+ years of diverse IT skillset and experience with 9+ years core experience as an IT Business Systems Analyst in medium to large sized complex projects (5+ million) developing Business and System requirements for private sector (Telecommunication and Banking) and the Ontario Public Service (OPS) ministries including the Ontario Ministry of Agriculture, Food and Rural Affairs (OMAFRA), Ministry of Transportation (MTO), Ministry of Government and Consumer Services (MGCS) and Ministry of Health and Long - Term Care (MOHLTC). Additionally, have provided augmented QA Testing and Training services as needed.
• Extensive experience with the Software Development Lifecycle (SDLC) and methodologies such as Waterfall and Agile methods with a focus on iterative development and delivery with proven ability to lead sprints.
• Hands on experience in requirements gathering, analysis, design, functional testing, and training with strong focus on Microsoft Dynamics CRM.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Strong hands-on experience in creating Business Cases, Business Requirements Document, other Business requirements artefacts, testing documentation, Enterprise architecture artefacts and assist Solution designer/architect in the preparation of technical artefacts including technical design.
• Strong core experience working on large systems implementation and case management solutions.
• Proficient with system concepts and development methodologies to support business application.
• Skilled in mapping client requirements with Microsoft Dynamics CRM application functionality.
• Developed Microsoft Dynamics CRM 2013 & 2015 plugins and customized forms.
• Strong core experience with developing documentation towards production readiness such as support model, SLAs, and checklists, and copy books for operational and data migration.
• Strong hands-on experience in working with technical SMEs and business SMEs in reviewing and analysing design gaps, provide initial cost and time estimates for change requests and enhancements, assist development team in first level triaging of defects to identify solution gaps and review with business and delivery team.
• Strong core experience documenting and tracking requirements in project and issue tracking systems.
• Proven experience in creating business analysis artifacts i.e. Business requirements document, Business events, Business Glossary, Business rules, Functional and Non-functional requirements document, Supplementary System Specifications, System Storyboards, Requirements Traceability Matrix, Use Case Specification, User Interface Requirements, Business Analysis Work Plan, Requirements Management Plan, System Design Specifications, User interfaces and End-user Training/Support Guides using UML, Rational Rose, Microsoft Office, Enterprise Architect and Microsoft Visio.
• Expertise in creating Business Use Case model, System Use Case Model, Conceptual/Logical data Models, Activity Diagrams, Sequence Diagrams, Data flow diagrams, Data Inventory Report, Process modeling(Business Process Diagram/ System Flow Diagram) and other UML design documents as per project management methodology.
• Expertise in creating automated information, decision-making, problem solving, conducting gap analysis, feasibility analysis, cost-benefit analysis, SWOT analysis, stakeholder analysis, and presenting reports to stakeholders and management with identified gaps between business systems and compliance requirements.
• Expertise in creating Business Use Case model, Sequence Diagrams, Data flow diagrams, Data Inventory Report, Process modeling(Business Process Diagram/ System Flow Diagram) and other UML design documents as per project management methodology.
• Good knowledge of program & service concepts, general best practices, Zachman Framework and GO-ITS 56 Enterprise Architecture principles for business architecture, information architecture, application architecture, technology architecture, and security architecture and privacy design principles for personal information.
• Strong hands-on experience with Business Object Oriented Modeling, UML tools and techniques.
• Extensive experience with supporting OPS ODS Digital First strategies and working with Digital Service standards including formal submissions for assessments as per official digital standards established.
• Extensive experience developing and updating architecture governance artifacts for ensuring successful completion of the Enterprise Architecture governance checkpoints for Checkpoint Row 2 (Conceptual), Checkpoint Row 3 (Logical Architecture), and Checkpoint 3 (Physical Architecture). Key artifacts developed were Information Model, Fact and Dimension Matrix, Interface Data Requirements, Business Function Model, Business Process Model, Business Scenario, Business Rules Source and Profile, Business Network Model, Service Oriented Architecture (SOA) Service Specification, Service Profile, Service delivery models - self service, digital service, public private partnership, State Transition Diagrams, System Architecture Document, System Functional Requirements, Logical Application Design, and Deployment documents, Conceptual, Logical and Physical Data Models, Logical and Physical Dimension Models, Logical Threat Risk Assessment (TRA), Supplementary Specifications, Database Inventory, User Interface Design
• Strong core experience with supporting QA teams by creating testing documentation such as Test Cases, Test Plans and Traceability matrix.
• Proficient with the OPS / Public Sector Architecture Governance Points and deliverables
• Extensive experience in creating Business Cases, Project Opportunity Assessment with estimated project costs, Project Plan, Communication Plan, Risk Management Plan, Data Masking Assessment, Security Review Questionnaire, Disaster Recovery Document, Application/Systems Recovery Plan.
• Proficient with reporting progress of assignment regularly to Project Management and raise any issues/concerns with proposed mitigation strategies.

TECHNICAL SKILLS

Software Methodologies: RUP, Agile (Scrum, Kanban), Lean, UML, Business Analysis (BABOK),, Object Oriented Analysis(OOA), AODA, OPS GO ITS Standards, Enterprise Architecture and the Architecture Gating process, Zachman Framework.

Software Tools: TOAD, PL/SQL Developer, Microsoft Visio, Microsoft Project, Power Designer, PowerBuilder, Balsamiq, Microsoft Office, Mercury Testing Suites, Rational Requisite Pro, HP ALM 11.5, HP Load Runner 11.5, CA Endevor

Languages & Technology: VB, VB.NET, C#, NET Framework, Java, J2EE, Crystal Reports, Business Objects, Microsoft InfoPath, Active X

Middleware: Microsoft SharePoint 2007/2010, Oracle WebLogic, IBM WebSphere

Database Technologies: Oracle 8/9i/10g, SQL Server 2000/2005/2008 , My SQL, DB2, IMS/DB2, MS Access, PL/SQL, Empress, Sybase

Web Development Tools: ASP, ASP.Net, IIS, XML, PHP, Java Script, HTML 5

Operating Systems & Platforms: Windows XP/2000/Vista/7/8, UNIX, Linux, Main Frame z/OS, Windows Server 2003/2008

Networking/Internet/Security: LAN, WAN, SAN, SOAP

Business Intelligence/Data Warehouse/ETL: SQL Server Reporting Services 2008, Cognos 10.1.1/10.2.2 , Informatica 9.6.1, Oracle Warehouse builder, Microsoft Power BI

CRM/ERP/COTS: Microsoft Dynamics CRM 365/2016/2015/2013/2011/4.0 , Salesforce 27.0, Seibel IP2014/IP2019, IBM Unica

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Analyst

Responsibilities:

• Extensive experience decomposing high-level scope to determine granular needs and developing effort estimates in enabling the Project Manager to develop the overall project schedule. Where required, will develop Business Requirement Plan using methodologies such as Iterative Rational Unified Process (RUP), and Agile Sprint
• Worked in the Software Development Lifecycle (SDLC) and methodologies such as waterfall and Agile methods with a focus on iterative development and delivery. Led sprints for the agile projects.
• Strong hands-on experience in creating Business Cases, Business Requirements Document, other Business requirements artefacts, testing documentation, Enterprise architecture artefacts and assist Solution designer/architect in the preparation of technical artefacts including technical design.
• Designed configuration of MS Dynamics CRM as per the business user's requirements and needs.
• Assisted in migration of current CRM to MS Dynamics CRM with added features and functionality.
• Strong core experience working on large systems implementation and case management solutions.
• Performed gap analysis of functionalities and data with project scope and current state and reported to management.
• Conducted, assessed, evaluated, and documented stakeholder interests and business needs & features.
• Created Dynamic CRM data cleansing modules to identify duplicate data using rules from a rules table in the database.
• Prepared PMO/ Enterprise Architecture artifacts for CP/0 such as Business Requirements Document, Context Diagram, User Case model, Use case briefs, Use Case documents, Data Dictionary, Non-functional requirements, Supplementary specifications, Process Flow diagrams, Data mapping documents, and User Interface Prototypes/ Wireframes
• Led and prepared assessments (alpha/beta/after live) based on OPS ODS / Public Sector Digital Service Standard and Digital assessment processes.
• Strong hands-on experience with Data models like conceptual data models and business domain data mappings
• Proficient to work with diverse groups and communicate across technical and business teams.
• Utilized various requirements gathering techniques such as Interview, Brainstorming/Elicitation, Joint Application Development(JAD), Prototyping, Survey, Observation, Roleplay, Workshop, Document Review, and Benchmark Application
• Strong core experience with developing documentation towards production readiness such as support model, SLAs, and checklists, and copy books for operational and data migration.
• Strong hands-on experience in working with technical SMEs and business SMEs in reviewing and analysing design gaps, provide initial cost and time estimates for change requests and enhancements, assist development team in first level triaging of defects to identify solution gaps and review with business and delivery team.
• Proficient with system concepts and development methodologies to support business application.
• Trained users on features and benefits of Dynamics CRM solution and IT staff on system administration, security
• Strong core experience with supporting QA teams by creating testing documentation such as Test Cases, Test Plans and Traceability matrix.
• Used Zachman Framework and GO-ITS 56 Enterprise Architecture principles for business architecture, information architecture, application architecture, technology architecture, and security architecture and privacy design principles for personal information.
• Developed production readiness support model and checklists to support of pre-load of data.
• Proficiently reported progress of assignment regularly to Project Management and raise any issues/concerns and propose mitigation strategies.

Confidential

Sr. Business Analyst

Responsibilities:

• In-depth knowledge of Agile methodology, Rational Unified Process RUP methodology, Waterfall methodology, Use Cases, Software Development Life Cycle SDLC processes, Object-Oriented Analysis and Design OOA/D
• Extensive experience with Agile Methodology preparing User Stories, Tech Stories, Tech Debts and SPIKES's in each sprint of the PSI Potentially shippable increments.
• Performed gap analysis of functionalities provided by Microsoft Dynamics CRM - 365 with project scope.
• Facilitated JAD sessions, workshops, surveys and executed preliminary investigations of current data sources to capture new business, functional and data requirements with business stakeholders and user groups forinception phase.
• Conducted, assessed, evaluated and documented stakeholder interests and business needs.
• Delivered Microsoft Dynamics CRM- 365 projects through analysis, design, development, training, and deployment activities necessary to deliver superior quality Microsoft CRM solutions.
• Proficient in project planning, scheduling, and reporting to support project timelines.
• Strong core experience working with Project managers to ensure sufficient time is available in project schedule to support an appropriate level of quality assurance and user acceptance testing.
• Prepared PMO/ Enterprise Architecture artifacts for CP 2/3 such as Business Requirements Document, Context Diagram, User Case model, Use case briefs, Use Case documents, Data Dictionary, Supplementary specifications, Process Flow diagrams, Data mapping documents, CRUD Matrix and User Interface Prototypes/ Wireframes
• Created and developed Microsoft Dynamics CRM Custom parts (workflow, data migration, data integration, ISV functions and site-map) to plug into out-of-the box Microsoft Dynamics CRM Solution.
• Involved in Dynamics CRM data capture, integration, auditing, data mapping, importing data and creation of interfaces.
• Developed and maintained Product Backlog, Sprint/iteration backlog, User Stories, Requirements Traceability Matrix and assignment of Team Foundation Server (TFS) tasks for agile team members.
• Contributed in TRA(Threat and Risk Assessment) and PIA (Privacy Impact Assessment) review
• Coordinated Unit testing for each use case, System Integration Testing, User Acceptance testing, Pre-Production testing, Pilot testing and Post Implementation testing with SME’s, End users and business leads.
• Led and prepared assessments (alpha/beta/after live) based on OPS ODS / Public Sector Digital Service Standard and Digital assessment processes
• Prepared Business Requirement Documents BRD's after the collection of Functional Requirements from System Users that provided appropriate scope of work for the technical team to develop prototype and overall system
• Followed the UML methodology to Create UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, Data Flow Diagrams DFDs, ER Diagrams using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Model
• Participated and contributed in developing material for the OPS Architecture Governance Points (AGP0-4) and deliverables
• Extensive experience working by Acts, Policies, and Procedures of Public Sector Services
• Extensive experience in implementing QA Methodologies, preparing Test Strategy, Test Plans, Test Cases, Test Script, Test Data, Test Artifacts, and Deliverables for various applications.
• Developed and execute manual test scripts based on business scenarios, business processes, and use cases and triage the defects in TFS and performed tests against functional and non-functional requirements before production deployment.
• Extensive experience to document requirements using storyboarding utilizing tools such as Azure DevOps and Jira
• Prepared custom reports and performed SQL query, data analysis, and verification on MS Access.
• Effective in executing multiple tasks and assignments ahead of schedule. Strong Image for dedicated teamwork, high energy, work ethics, and commitment with the capability to handle new technologies and situations.

Confidential

Sr. Business Analyst

Responsibilities:

• Served as a liaison between business team and the project team by assisting the business in identifying, understanding, and documenting their business needs.
• Conducted Gap Analysis to show the current and proposed functionalities of the system.
• Extensively used agile methodology's best practices during the SDLC.
• Gathered business, system, and functional requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter Experts SME's .
• Identified and developed Use Cases from the business and systems requirements. Documented high level and detailed Use Cases to include all the functionalities of the new system.
• Gathered the functional and business requirements by conducting JAD sessions and participatory Design Sessions involving major leads from the Technical Department.
• Coordinated data migration from old to new system during Teradata system capacity expansion
• Followed the UML methodology to Create UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, Data Flow Diagrams DFDs, ER Diagrams using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Model.
• Extensively used Rational Requisite Pro to gather and manage requirements. Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Prepared custom reports and performed SQL query, data analysis and verification on MS Access.
• Monitored version control and defect tracking activities using Rational Clear Case and Rational Clear Quest.
• Supervised the User Acceptance Testing UAT to test the usability of the application.
• Pre- and post-conversion training along with weekly status reports.

Confidential

Sr. Business Analyst

Responsibilities:

• Good understanding of Project Process and ability to analyze business problems and identify solutions. Worked extensively with the team to meet business requirement, create prototypes, and analyze workflow.
• Developed and maintained Agile project artifacts such as User Stories, Product Backlog, Sprint backlog and assignment of Team Foundation Server (TFS) tasks for agile team members.
• Experienced in creating Business Requirement Documents, User Requirement Specification, and Functional Requirement Specifications. Experienced in creating Data Flow Diagrams, Use Cases, State Diagrams, Sequence Diagrams, Component Diagrams, Use Case Diagrams & Activity diagrams.
• Served as a liaison between business team and the project team by assisting the business in identifying, understanding, and documenting their business needs.
• Developed data migration strategies and impact analysis for both Teradata and oracle database systems.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams DFD .
• Followed the UML methodology to Create UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, Data Flow Diagrams DFDs, ER Diagrams using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Model.
• Extensive experience in implementing QA Methodologies, preparing Test Strategy, Test Plans, Test Cases, Test Script, Test Data, Test Artifacts and Deliverables for various applications.
• Proficient in creating and executing UAT test cases, developing test plan, managing defect tracking, assisting Quality Assurance team.
• Prepared custom reports and performed SQL query, data analysis and verification on MS Access.

Confidential

Sr. Business Analyst

Responsibilities:

• Led elicitation of requirements within the Software Development Lifecycle (SDLC) and project delivery methodologies such as Waterfall and Agile with a focus on iterative development and delivery. Led sprints for the agile projects.
• Performed gap analysis of functionalities provided by Microsoft Dynamics CRM - 365 with project scope
• Strong hands-on experience on existing online S2i services, such as Child Support Services (CSS) Program, Vehicle Licence Plate (Valtag) Renewal service, Driver Abstract service, Vehicle Abstract service, Personalized Licence plate (PLP) service, Used Vehicle Information Package service, Online Drivers Licence Renewal service, Healthy Smile Ontario service, Administrative Child Support Service, Integrated Address Change service
• Performed comprehensive analysis of CRM system related business practices and drivers to increase system utilization, sales and retention while streamlining customer experience.
• Customized Dynamics CRM entities, create multiple forms (security based) on entities, add custom JavaScript on form events, and add web resources, navigation links to achieve the business requirements.
• Proficient in project planning, scheduling, and reporting to support project timelines.
• Strong core experience working with Project managers to ensure sufficient time is available in project schedule to support an appropriate level of quality assurance and user acceptance testing.
• Captured process flows by preparing activity and sequence diagrams, pre- and post-conditions, performance requirements, impacted areas, high-level business rules, issues, areas in scope and out of scope, assumptions for Dynamics CRM implementation.
• Facilitated JAD sessions, workshops, surveys and executed preliminary investigations of current data sources to capture new business, functional and data requirements with business stakeholders and user groups forinception phase
• Conducted, assessed, evaluated, and documented stakeholder interests and business needs
• Prepared PMO/ Enterprise Architecture artifacts for CP 2/3 such as Business Requirements Document, Context Diagram, User Case model, Use case briefs, Use Case documents, Data Dictionary, Supplementary specifications, Process Flow diagrams, Data mapping documents, CRUD Matrix and User Interface Prototypes/ Wireframes
• Created Business Requirement Document BRD, Functional Requirement Specification FRS document, User Requirement Specification URS, and Change Request CR document for system application development.
• Participated in the conceptual phase of ServiceOntario Modernization modules - eResidency, HC Renewal, HC/DL Renewal Harmonization, and Single Photo Signature including creating OHCR sequence diagram and eResidency and GeoLocation integration requirements, business flows, UML use case diagram, and use cases.
• Reviewed open data initiative and BI - IT strategy for reporting needs
• Co-ordinated & Conducted on-demand training sessions for the Business Leads, End Users and System Administrators
• Good knowledge of Zachman Framework and GO-ITS 56 Enterprise Architecture principles for business architecture, information architecture, application architecture, technology architecture, and security architecture and privacy design principles for personal information.
• Responsible for performing Functional, Integration, Performance Testing, and End to End testing. Involved in quality assurance standards and phase planning, coordination, and implementation of QA strategy for the overall project. Performed user acceptance testing (UAT) to validate user requirements and expectations.
• Performed industry research, provide options, and make recommendations for solution improvements.
• Utilized test management tools and version control systems on one or more platforms such as Azure DevOps, HP ALM 12.5, Octane & CA Endevor
• Ensured alignment and adherence to the Ministry of Government Services’ processes and standards.

Confidential

Sr. Business Analyst

Responsibilities:

• Analysed high-level scope to determine granular needs and developing effort estimates in enabling the Project Manager to develop the overall project schedule. Where required, will develop Business Requirement Plan using methodologies such as Iterative Rational Unified Process (RUP), and Agile Sprint.
• Strong core experience with stakeholder management & communication, project status reporting, workshop facilitation, meeting management, and conflict resolution
• Strong hands-on experience in creating Business Cases, Business Requirements Document, other Business requirements artefacts, testing documentation, Enterprise architecture artefacts and assist Solution designer/architect in the preparation of technical artefacts including technical design.
• Strong core experience working on large systems implementation and case management solutions.
• Performed gap analysis of functionalities and data with project scope and current state and reported to management.
• Strong core experience with development of the Business Architecture Document, System Architecture Document, Systems Requirements Document, and Information Architecture Document
• Co-owned end-to-end Data Migration activity from Legacy to CRM (including Design, support to Development and UAT with end users); prepared the Business and System Rules for such data migration to be applied in Scripts.
• Strong core experience with developing documentation towards production readiness such as support model, SLAs, and checklists, and copy books for operational and data migration.
• Worked on MS CRM Dynamics for handling the customer claim inquiries, Validation and Case Creation.
• Strong hands-on experience in working with technical SMEs and business SMEs in reviewing and analysing design gaps, provide initial cost and time estimates for change requests and enhancements, assist development team in first level triaging of defects to identify solution gaps and review with business and delivery team.
• Strong core experience documenting and tracking requirements in project and issue tracking systems.
• Proficient to work with diverse groups and communicate across technical and business teams.
• Led hands on assessment and trouble shooting of TS applications, databases and systems (Licensing and Control System (LCS), Suspension and Impoundment Management System (SIMS), Licensing and Control System Services (LCSS), Driver Services System (DSS), Access Enforcement System (AES), Revenue Management System (RMS) (Financial), Authorized Requestor Information System (ARIS), Management Information System (MIS) (Reports), Database Tables, Notices
• Developed use case and functional data into user documentation.
• Worked on business and systems requirements related to licensing, registration, permit, enforcement, safety inspection, photo identification, and fraud prevention line of businesses, services, or functional areas.
• Strong hands-on experience with resource utilization and financial reports for management.
• Engaged hands-on with all stages of automated system implementation in complex mainframe, with online batch, and Financial reconciliation transactions.
• Participated in development of Power BI visualization of Dashboards & Scorecards (KPI) for Public Services
• Work involved working with legacy infrastructure hosting environments such as mainframe with complex applications and supporting legacy applications and modernizing.
• Strong hands-on experience to documented errors and tested new application software and features rapidly.
• Performed with QA engineers/developers to develop Test strategies and Test plans
• Performed analysis of the design and technology/components employed in non-conforming web sites and analysis of business process and policy options for achieving AODA conformance.
• Utilized my strong communication, interpersonal, collaboration, and negotiation skills to work seamlessly in an agile cross-functional team, with clients, vendor(s), and other stakeholders.