IT Business Analyst
Resume:
Shahid Syed
**********@*****.***
EXPERIENCE SUMMARY:
I have over 20 years’ experience in IT Business Analysis and Data Analysis, Data Reporting with excellent knowledge and experience in Business Solutions, Change Management and Agile/Waterfall Project Management.
Extensively worked on Enterprise and Cloud upgrade, and integration of third-party vendor applications including Guidewire Policy Center, Billing Center, ECS Claim Center (Coverages, Forms & Policy Rating for Auto, GL, BOP & WC LOB’s), SharePoint, AEM, Salesforce, Amdocs Ensemble, and Infrastructure upgrade projects.
Excellent working knowledge & current experience of Insurance Policy Admin, Underwriting, Billing & Claims Systems, various type of Payment transactions, (ISO/NCCI Circulars, Forms, Modifiers, Rating, WC POC Proof of Coverage Reporting, Regulatory Compliance reporting), Document Generation, Digital & Electronic Documents Management.
Extensive experience of Analyzing Legacy Systems migration, Integration of Internal & third-party applications, defining Acceptance Criteria, writing Business Proposals, Project Initiation Documents, Business Cases, Project Charters, Project Plans, Project Schedules, Go-Live and Production Checkouts Plans & Checklists.
Vast experience of gathering and writing Functional & Non-Functional Business Requirement, defining As-Is and To-Be business processes, creating Use Cases, User Story Cards, Epics, Product Backlog, Sprint Backlog, Process Flows, Data Flow Diagrams, Activity Diagrams, Sequence Diagrams, Flow Charts, Wireframes, UI Mockups, Change Requests, UAT Plans, Test Cases, and Summary Reports.
Vast experience of various requirement gathering techniques including, Brainstorming Sessions, SME’s and Users Interviews, Survey Questionnaires, Examining Problem Reports, Requirement Workshops, Document Analysis, Reverse Engineering, and Prototyping.
Extensive experience of Improving Business ROI on Technology Projects, and Demonstrating Business Solutions to Business partners, Project Stakeholders and Facilitating and Moderating Requirement Review sessions, JAD sessions, Showcasing & Demo sessions, planning sessions and providing Communication support to Project Stakeholders.
Strong experience and ability to define and develop Business Rules, Data Conversion Processes, Data Integration Processes, Business Process Models, Workflows, Impact Analysis, Risk Analysis, Data Analysis, Gap Analysis, Change Control, ETL Mapping, and conducting Business and Technical presentations to project stakeholders.
Excellent knowledge and working experience of Document Management System (DMS) and Enterprise Content Management Systems (ECM) including Thunderhead, OpenText Extream (HP Extream), ImageRight, FileNet, SharePoint and Adobe Experience Manager (AEM).
Extensive knowledge and working experience of Team Collaboration and Defect Management tools including Confluence, Jira, Rally, VersionOne, Quality Center, TestLink, Trac, Rational Doors, and ClearQuest.
Extensive working knowledge and experience of UML/RUP for modeling views, process flows and workflows in Rational Rose, and Microsoft Visio.
Strong knowledge and working experience of Waterfall, Agile/Scrum, Kanban, DevOps, CI/CD, RUP methodologies; System Development Life Cycle (SDLC), Project Management Life Cycle (PMLC), ITIL Practices & Procedures and Defect Management Processes.
Excellent experience & skills of Data Management, Data migration, Data Analysis, PL/SQL Programming (Stored Procedures, Triggers, Packages) and writing complex SQL queries on Oracle, Teradata, PostgreSQL, Sybase, SQL Server and DB2 Databases.
Excellent Scripting & Troubleshooting experience on Linux, Unix, AS400 and Windows environment.
Excellent knowledge of standard CMMI and ISO compliance processes required for Software Development and Business Process Improvement.
PROFESSIONAL EXPERIENCE:
Sr. Business Analyst
State Farm Insurance, Bloomington, IL Sep 2010 – Current
Projects and Tasks:
Guidewire Policy Center 8, 9, 10 Cloud, (Rating, Coverages, Forms & DocuSign, Nexus)
Guidewire Billing Center 8, 9, 10 Cloud, (Enhancement, CR’s, Production Support)
Adobe Experience Manager (AEM 6.0, 6.5)
Enterprise Claims Services (ECS)
Integrated Customer Platform (ICP Phase 1.5 Web & Mobile)
Unified Auto Experience (UAX) AQP-C, AQP-SA Sales Cloud Int.
SharePoint 10 Migration & Infrastructure Upgrade
NCCI/ISO Compliance Reporting
P&C Rating Engine
Customer Underwriting Index (CUI)-Auto
Worked on Internal and third party integration projects of State Farm including Guidewire Policy Center (Cloud) Policy Rating, Underwriting, Coverages, Forms, SBT’s), Guidewire Billing Center (Cloud), Enterprise Claims Services (ECS), Auto Quote and Purchase Customer (AQP-C Web & Mobile), Auto Quote and Purchase Sales Associate (AQP-SA Sales Cloud Int.), After Hours Quote & Bind (AHQB), PVC/QEC, NECHO, AEM 6.0/6.5 (Adobe Forms, Life Cycle Designer, Forms Pro, Digital Asset Management), SharePoint 2010, Data Analysis of Policy, Billing and Claim Data. Also worked on TSO’s for IMS’s to troubleshoot rate set and other issues.
Responsibilities:
Worked on Guidewire Policy Center & Billing Center Cloud upgrade, enhancement, CR’s & Production issues, PC integration with third party apps from inception to implementation. Actively worked on Coverages, Forms generation, DocuSign integration, PC-Nexus integration for WC Premium Audit, ISO Regulatory Compliance, Policy Rating, Product Model, Data Model, Data Conversion, PCF, XML’s, Messaging, ID Cards, Endorsement, Declarations, Notices, Exclusions and supporting documents for Auto, GL, BOP and WC LOB’s. Closely worked with Guidewire support and Guidewire ODC to discuss and get resolution of Assigned work, Open cases and Production issues.
Actively worked on Billing Center CR’s and Production issues including Payment Arrangements, Invoicing Issues, Disbursement, Commission Statements, Fraud & Prevention, Producer Codes, Audit Credits, Installment Changes, Policy Change Credits, Delinquency Workflow & Endorsements. Defined Requirement, Acceptance Criteria. Created Product Backlog, Sprint Backlog, User Story Cards, demonstrated “Out of the Box” functionality and Solution to Business SME’s and created requirement close to OOTB functionality of Guidewire Policy Center & Billing Center.
Worked on ECS Claims implementation at State Farm. Worked on business solution, migration strategy, ISO Claim Search, document analysis, claims conversion, data migration, Screen & UI designs, XML validations, Business model and Activity patterns. Defined business rules for various functionalities of ECS Claims for Auto and Workers Compensation LOB’s.
Worked on requirement elicitation, business rules, data mapping and workflows of First Notice of Loss (FNOL) through Claim Wizard and external system claim import.
Worked on First report of Injury (FROI), Assignment rules for manual and automatic assignment, Exposures, Deductible recoveries, verified and unverified policies, Payment and recovery for salvage and subrogation, rules for user management.
Worked on Data & Digital Asset Migration, Adobe Forms Integration, Forms & Standard Based Template Designing, Life Cycle Designer, Forms Pro, and Digital Asset Management (DAM) components of AEM project. Closely worked with Business Users, Adobe Consultants and Customer Experience team to define AEM functionality, Migration Strategy, Workflows, Forms Inference, Templates and Modules.
Worked with business partners, Subject Matter Experts (SME’s) and third-party vendors to gather and define requirement, defining acceptance criteria, writing Business requirement, Business Rules, User Stories, Epics, User Guides, Process Flows, Wireframes, UI mockups, Functional requirement, Data Mapping, Requirement Change Notifications (RCN’s), Use Cases for Web-based and mobile Applications of State Farm.
Created Business Rules & Requirement for various type Payment Plans for ACH & Credit transactions including Account Number validation, Routing Number validation, Credit Card Validation, Purchases, Refunds, Disputes, Adjustment, and Charge Backs.
Performed Business Analysis and Project Coordination activities including Requirement gathering, developing As-Is and To-Be business processes, writing Business Proposals, Project Charters, Project Plans, Business Requirement, Functional Requirement, Gap Analysis, Change Control, Data Mapping, ETL Mapping, Use Cases, Epics, User Story Cards, Backlog Refinement, Product Backlog, Sprint Backlog, Process Flows, UI Mockups, UAT Test Plans, UAT Test Cases and Data Conversion Test Cases.
Validated requirements and design by analyzing the scenarios with business SME’s (P&C underwriters and agent representatives) and Stakeholders. Routed Business documents to all the Stakeholders for Review, Authorization and Sign-off.
Worked as a liaison between business partners and technical teams for Product Modeling and opening Risk, Issues and Dependencies.
Facilitated and moderated Daily Scrum meeting, Project Sync up meetings, Design review meetings, Sprint planning sessions, showcase sessions, Defect triage meetings, Projects Backlog Sessions, CMRB meetings, Go/No Go meetings, Sprint Retrospective meetings for various ongoing projects.
Analyzed and updated Requirement Changes, Created Business Process Models, Use Cases, User Acceptance Test Cases, Data Conversion Test Cases, Requirement Traceability Metrics, Status and Summary Reports.
Created and updated Business-related documents and Project Deliverables on Confluence, Lotus Notes and SharePoint Project Repositories.
Worked with Testers, Developers, End-users and performed various types of validations including Data Integration, Data Conversion, User acceptance testing, and Telematics integration (DSS products In-Drive, OnStar, Self-Report).
Worked on Data Analytics, Data Visualization, and Dashboard Maintenance to Analyze States-wide KPI’s and future Business trends.
Performed PL/SQL Code Analysis, and wrote complex SQL queries on Oracle, DB2, Teradata, IMS, SQL Server and PostgreSQL databases to perform Data Analysis and validate data integrity.
Worked on special assignments (e.g., work with Business Partners on framing out a new business concept for the company).
Resolved production issues (tickets and incidents) by reproducing the incidents locally and resolving them using HP Service Manager.
Communicated Project status, results, and other project related issues and progress to all the project stakeholders on a daily & weekly basis.
Environment: AzureDevOps, CI/CD pipelines, Confluence, Jira, Thunderhead, J2EE, DB2, PostgreSQL, Teradata SQL Assistant, TOAD, Sybase Central 6, VersionOne, OneNote, BPMN, Salesforce, Team Foundation Server, Tableau, SQL, PL/SQL, MSBI, T-SQL, Clear Quest, Clear Case, ReqPro, UML 2.0, Selenium, HP-Unix, HP QC/ALM, Exstream, FileNet, Office 365, Jenkins, Windows Server 2007, Citrix, GOSU, AS/400, JCL, SAS, DataStage 9.1, Cognos 9.5, Business Objects, Primavera P6, Splunk, Power Point, MS Visio, MS Project, Windows XP/7, Lotus Notes, C#, HTML, XML/XSLT, XPath, Java Script, TestLink 1.9.3, Trac, SharePoint, IBM WebSphere MQ, WAS 8.5, HTTP Watch, App Watch
Business Analyst Jun 2008 – Aug 2010
Aviva Insurance, Scarborough, ON
Projects:
Guidewire Policy Center 4
Production support, CR’s
Worked on strategic project of Aviva Canada that replaced legacy policy administration system and implemented Guidewire policy center 4. Worked closely with Guidewire Architects and Business experts to define objectives, business requirements, integration requirements and outlined potential solutions. Identified integration points of P&C applications with Guidewire software, performed impact analysis, risk analysis, defined acceptance criteria, created and executed user acceptance test cases.
Responsibilities:
Gathered, defined and organized business and functional requirement, documented the functional requirement using agile scrum project methodology (i.e. Epics, User Stories and Prioritizing the Product Backlog, Sprint Backlog)
Worked with internal business stakeholders, provided them subject matter expertise and business solutions that satisfy business sponsors and stakeholder needs.
Worked on configuration capability (Screen/UI, application settings or parameters, and Business Rules) using Guidewire Policy center.
Extensively worked with Guidewire technical integration team to define high level design (HLD), low level design (LLD), end-to-end functionality, and flow of Auto insurance application of Aviva Canada.
Developed interface specification documents using signed-off requirement including application requirement, process flow, data and interfaces.
Facilitated and organized Requirement review, Design review, Data mapping, Test cases review and Defect triage sessions.
Collaborated with Test leads and Testers to review Test plan, Test Strategy, Functional Test cases, UAT Test Cases and Defect reports.
Worked on Estimates, Business impact analysis, and Risk analysis on all the phases of Guidewire Policy Center Integration and Change control process.
Executed the Business acceptance test cases ensuring the full coverage of the requirement as per Functional specification document and Change request.
Executed SQL queries to retrieve data from data files to ensure data mapping.
Performed all the Requirement Management, Test management, and Defect management activities on HP Quality Center.
Analyzed System and Acceptance test results prepared Summary reports, Defect reports and Status reports.
Environment: J2EE, SQL Server 2005, Oracle 10/11g, DB2, Unix AIX, Solaris, MS Visio, MS Project, Windows Server 2003, Citrix, Windows XP/Vista, VB.Net, C#, VB6, HTML, XML, VB Script, SharePoint, HP Quality Center, Rational Clearcase
Financial Business Analyst Jun 2007 – Jun 2008
Xeye Inc/Odyssey Financial, Mississauga, ON
Projects:
RB IR17 Royal Bank
Vantage Client Management System, TD Release 14
CIBC Oracle 10g Certification
Scotia CCP
FTI Xweb 4.1
Worked on “Wealth Manager” application. Wealth Manager application provides customizes asset and portfolio management solution to major financial institutions in North America, including Royal Bank, Scotia McLeoad, TD Financial, CIBC TAL, Fiduciary Trust, Nationwide, and ATB Securities. Wealth Manager is a client and web-based brokerage product of Xeye. This is a highly scalable, enterprise-wide wealth and portfolio management application, designed to help banks and trusts, wealth and portfolio managers, investment advisors, financial planners and broker dealers.
Worked on VB Client 3.1 application and Java-based Xweb 4.1 application for various clients. Worked with end-client business SME’s on gathering business requirement, analyzing requirement, translating business requirement into technical requirement, specs review and walkthroughs. Created UAT test plans, Implementation plans, and change management activities for various projects. Worked with technical writing team, reviewed release notes and training material.
Environment: Java, J2EE, Rational Doors, JSP, Servlets, VB6, JDBC, TOAD, Oracle 10.2, PL/SQL, Unix (Solaris 9), Linux, Windows Server 2003, Windows XP, SQL Navigator, Quality Center 9.0
Business Analyst
Tracfone Wireless Inc. Miami, FL, Remote Feb 2005 – May 2007
Project: Ensemble 6.0, CSM Module
Worked on the migration of Tracfone wireless subscribers for voice and data services on Amdocs Ensemble platform. Worked on Business Requirement, Use Cases, Data Analysis, Implementation Planning and Go-Live of Amdocs Ensemble 6.0 billing system. Created requirement, use cases and workflows of CSM (Customer Service Management), Usage, Billing, Accounts Receivable, and Accounts Payable modules. Also worked on data conversion, SQL validations, test data management, UAT and production support activities of Ensemble 6.0 project.
Business Analyst
CELESTICA International Apr 2000 – Jan 2005
Projects:
SAP R/3 FI/CO, MM
Performed Functional and Technical Business Analyst activities of FI/CO and Material Management (MM) modules of SAP R/3 ERP. Gathered and Analyzed requirement, Developed strategies and Procedures for efficient implementation of SAP R/3 modules integration. Worked across the various stakeholders of the project on requirement, design, development, testing, troubleshooting, and production rollout of SAP R/3.
Financial Accounting
Worked on Financial Accounting (AP, AR, GL) enhancement project on JD Edward AS400 platform. Analyzed change requests, created technical specifications and defined business rules on RPG, RPG ILE in JD Edward. Performed database analysis writing SQL queries on DB2 database. Also analyzed and tested Physical files, Logical files, SQL tables, Indexes, Views, and Stored Procedures on AS400.
Education & Professional Training:
Bachelor of Business & Economics
Project Management Workshop training from PIM
Data Modeling and Relational System Design Training, from Orasoft
SQL*Plus and PL/SQL Courses from Orasoft
COBOL & RPG/400 Programming from SBTE
CPBS ERP evaluation and implementation training from Afcomp, Dubai
Contact this candidate